Summary





Having 4 years of experience in the field of Business Objects worked on Data Warehousing Business Intelligence Tool, Business Objects
Involved in analysis, design and development of Business Objects Reporting Applications
Good knowledge in Data Warehousing concepts
Extensive knowledge of Crystal Reports XI R2
Good knowledge of SQL and PL/SQL
Good communication and presentation skills and ability to adapt to the technical environment as a developer


Employment

July, 2008 -  Present
Working as BI Consultant

September, 2007 -  June, 2008
Worked as Software Engineer

May, 2005 -  August, 2007
Worked as Software Engineer

Business Objects Certified professional Crystal Report 2008

Business Objects Certified professional BusinessObjects Enterprise BOCP - BOE

BI Tools : Business Objects 6.5.1 XI R2/XI3, Designer, Web

Intelligence, Desktop Intelligence
Reporting Tools : Crystal Report XI R2

Data Bases : Oracle 8i/9i

Operating Systems : Windows 98/NT/2000/XP

Programming Languages : Pl/SQL, Java

Informatica, HTML

Project #1

July, 2008 -  Present

Role : BI Consultant - Designing Universe, Development and Implementation of the reports.

Description :
This project was developed for Fresenius Medical Care North America which is a wholly owned subsidiary of Fresenius Medical Care AG and Co. KGA, located in Bad Homburg, Germany. Fresenius Medical Services, operate more than 1500 outpatient dialysis clinics in the US This project is basically a migration of Actuate Reports to BOXI R2. The major purpose of the report enhancements is to enable Physician to monitor patient s progress on their treatment and to provide the highest quality standards in dialysis care and products in the industry to meet the needs of patients and affiliated physicians.

Role

Understanding the actuate workflow and transforming them into BO XI R2 Using BO Features
Played a key team member role, On Time Delivery of the developed reports as per the agreed time
Created Reports using dynamic/ static prompts, Sub reports in place and on Demand.
Preparing Technical Specification Document TSD S
Implementing the logic in BO Crystal Report XI R2
Design of the Universe using Derived tables to meet the complex business requirement.
Developing reports using Crystal Reports XI R2 and Web intelligence report using multiple data provider.
Extensively developed reports as per the business requirements.

Project #2

September, 2007 -  June, 2008

Description :
Gap Inc is 1 of America s largest speciality retailers. Gap Inc is a brand-builder. Gap Inc create emotional connections with customers around the world through inspiring product design, unique store experiences and compelling marketing. Gap Inc provides a online purchasing center for the customers which complaints the company s extensive call center oriented mail order operations. The project was aimed at studying sales variations for their buying patterns and maintaining inventory levels depending on the sales history as well sales forecast.

Responsibilities :
Performed the Integrity check and finally Exported Universe to Universe Domain of the repository
Created reports for various Portfolios using Business Objects
Created Reports using Table, Cross Tab, Chart and Master-Detail formats
Created Reports using Multidimensional analysis modes Drill Mode and Slice and Dice
Organized data in reports by using filters, sorting, ranking and highlighted data with alerts
Created Ad-hoc reports using Business Objects and finally Exported to Document Domain of the repository

Project #3

July, 2006 -  August, 2007

Description :
The Multi National Bank is a National organization that offers consumers a full array of deposit, investment, credit and personal finance services. The application consists of 2 main modules Personal and Business. The Personal module was the basic interface to query the database and generate reports for rates, payment terms, view founding, protection options and investment consideration. The Business module consists of varies business units for personal, Business and Estate Insurance. The project provided web based reports of the current and future financial needs based on the information received from the transactions available in the Data warehouse.

Responsibilities :
Interacted with Business Users, Business Owners to know their Business views in developing and modifying Universe and Reports accordingly
Involved in the Designing, Analyzing and Documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports
Created Classes, different kinds of Objects, Cardinalities and Strategies as a part of Universe development
Qualified nations of Dimensions, Measures and Detail objects.
Checked the Integrity of the Universe
Exported the Universes to the Repository to making resources available to the users
Created reports for various Portfolios using Business Objects
Exported the Universe to the Repository to make resources available to the users

Project #4

September, 2005 -  June, 2006

Education

Skills


Description : Stephens Investment Banking Department offers a full array of financial services to a broad range of clients in the field of sales and trading and investment banking. This projects deals with Investment Banking. The main objective of this project is to development of Data Mart and Reporting System to analyze the profits the company is earning from their clients. The data is obtained from different sources like flat files, relational tables and Ms-Access tables. The data is extracted from the sources using Informatica as ETL tool and obtained data is used in the reports which are developed using Business Objects. Responsibilities : Generated Reports for various Portfolios using the Universes and Free hand SQL as Data Providers Created Reports using Table, Cross Tab, Chart and Master-Detail formats Created Reports using Multidimensional analysis modes Drill Mode and Slice and Dice Organized data in reports by using filters, sorting, ranking and highlighted data with alerts Created ad-hoc reports as per the user needs Exported the Universes to the Repository to making resources available to the users