Pfizer Inc. (Pfizer) is a research-based global biopharmaceutical company. Report migration from Cognos to Sap BO, Analysis the existing Cognos reports in IBM Cognos studio and replicate in BO. Create adhoc report as per user requirement. Create documentation of each newly developed reports. Provide training to end users. Improvement in developed universe and reports. Automate manual business reports.

Project Summary:

Pfizer Inc. (Pfizer) is a research-based global biopharmaceutical company. Report migration from Cognos to Sap BO, Analysis the existing Cognos reports in IBM Cognos studio and replicate in BO. Create adhoc report as per user requirement. Create documentation of each newly developed reports. Provide training to end users. Improvement in developed universe and reports. Automate manual business reports.

Technologies Used: SQLSAP Business Objects 4.2 (IDT Webi&CMS), IBM Cognos Report Studio 10.2,Toad 11.5

Key Responsibilities:

To gather all the requirements from business analyst.

To create Webi Reports and Universe

To develop and maintain universe in IDT based on business requirements.

To Migrate reports from Cognos to BO.

To make documentation on reports.

Enable Row level security.

Project Summary:

Miles Software Solutions (P) Ltd. develops wealth, asset, portfolio, and investment management software. It offers MoneyWare, a software solution used for investment management solutions, such as financial planning, portfolio management system, portfolio risk and performance analytics, family office, fund accounting, trade execution, revenue and incentive management, mobile solutions, Islamic banking, and trust banking solutions; asset management solutions, including fund and pension funds management solutions; lending and collateral management solutions, such as reporting services;

Key Responsibilities:

To gather all the requirements from business analyst.

To create Webi Reports and Universe (Based on tables and SP).

To develop and maintain universe in UDT/IDT based on business requirements.

Miles Software Solutions (P) Ltd. develops wealth, asset, portfolio, and investment management software. It offers MoneyWare, a software solution used for investment management solutions, such as financial planning, portfolio management system, portfolio risk and performance analytics, family office, fund accounting, trade execution, revenue and incentive management, mobile solutions, Islamic banking, and trust banking solutions; asset management solutions, including fund and pension funds management solutions; lending and collateral management solutions, such as reporting services;

Key Responsibilities:

To gather all the requirements from business analyst.

To create Webi Reports and Universe (Based on tables and SP).

To develop and maintain universe in UDT/IDT based on business requirements.

Employer: Itree-Consulting

Client Name: ICICI Bank, ATPI(Griffin), MCGM, Reliance.

Duration: Apr 2011 – Apr 2016

Role: SAP BO BI Consultant

Technologies Used: SQL server 2008, Business Objects 3.1,4.0, Crystal Report, Dashboard Design tool & Crystal Report.

Key Responsibilities:

To gather all the requirements from business analyst.

To create Webi Reports and Universe (Based on tables and SP).

To develop and maintain universe in UDT/IDT based on business requirements.

Technologies Used: SQL server 2008, Business Objects 3.1,4.0, Crystal Report, Dashboard Design tool & Crystal Report.Technologies Used: SQL server 2008, Business Objects 3.1,4.0, Crystal Report, Dashboard Design tool & Crystal Report.

Project Summary:

To create Webi Reports and Universe

To develop and maintain universe in IDT based on business requirements.

To Create Dasboard.