Experience Summary:

• Have 5years experience in implementing data warehousing/Business Intelligence Applications
• Well versed with Data warehousing Architecture on the Design, Development, and Extraction of Data and using BI and OLAP tools.
• Experience in Analyzing the OLTP model and designing the datawarehouse physical and logical model.
• Experience in Analysing the Reporting Requirements and identifying the Gaps and Created the Data mapping for all the Business areas.
• 5 years of Experience in using Business Objects tools with specialized in ETL Data Integrator, BOXI-R2/R3,pl/sql
• Experience in Installation, Configuration and Administration by using Business Objects Data Integrator / BOXI-R2/R3.
• Experience in Installation and Customization of SAP RapidMarts.
• Extensively involved in ETL development using Business objects data integrator and created dataflows, workflows to extract the data from various sources and load into Target.
• Experience in creating various Jobs,workflows,data flows and involved in Designing and developing initial and Delta Run for ETL jobs
• Experience in Designing and Developing the process to track and Recover the ETL jobs using Data integrator Scripting Language
• Experience in creating Stored Procedures, Materialized views, Triggers, Functions
• Involved in Unit Testing, Integration testing and Performance testing.
• Developed Effective Working Relationships with Client Team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.
• Excellent Communication Skills, Quick Learner with good Problem-Resolving Skills. Ability to work alone as well as in a Team Environment.
• Capable of understanding large and complex projects, Quick learner of new technologies and using them effectively

Skill Set Technical:

ETL:

Business Objects XI R2, Business Objects Data Services 3.X, Business Objects Data Services 4.0

Scheduler:

Data Services Scheduler, Cronacle

BI Tools (OLAP):

Universe Designer, Xcelsius, Live Office, Business Explorer and Web Intelligence.

RDBMS/DBMS:

Oracle 10,9i/8i/8.0/7.0, TOAD, MS SQL Server 2000, MS Access 2000, Flat files, Excel.

Application Software:

PL/SQL, SQL

Experience and Projects:
Nov 2011- Till Date
Client: Confidential
Project:HR Analytics using BO 4.0 and DS 4.0

Description: HR Analytics initiative at Eli Lilly is to enable a dashboard that can present HR professionals
with the right summary metrics and allow the user to slice and dice HR data based on several employee attributes
like location, gender, band, ethnicity, age, etc.

Key Responsibilities:

• Worked with Admin team to install the Data Services 4.0.
• Worked with SAP to resolve the Product issues when extracting using the Extractors.
• Involved in requirements gathering from the HR reporting team.
• Created new Workflows using Headcount and Action Extractors and the related Master Data and Text Extractors.
• Created the data model for Headcount and Actions data using existing SAP BI as reference,
• Created Universe using Universe designer as per the reporting requirements.
• Row level Security implementation on Universe at Business Node level.
• Creation of reports using Web-Intelligence and Business Explorer.

Environment:BODS 4.0, Oracle 10g, ECC 6.0, Toad, Linux, Business Object Enterprise 4.0

Mar2010- Nov 2011

Client: Confidential
Project:Data Services Application Support for Rapid Marts

Description: The Rapid Mart application support at Ericsson is to support the Financeand SCM reporting teams.

Key Responsibilities:

• Scheduling of Jobs using Management Console as per the Business requirements and the Job Dependency.
• Preparation of SMTD document which will help as a reference to the support team to perform the daily activities
• Handling of Trouble Tickets and CR’s raised by the Business Users.
• Worked with Admin to create a working model of integrating Cronacle Scheduler with Data Services.
• Worked on Creation of scripts which will send the notifications to the Admin team when File system size exceeds the Threshold Value.
• Implemented Recovery Mechanism on the Custom Build Finance Rapid Mart jobs.

Environment:BODS XI 3.2, Oracle 10g, ECC 6.0, Toad, Linux

June 2009- Mar 2010
Client: Confidential
Project:Implementation of Finance Rapid Marts.

Description: The V& C Rapid Data Mart solution initiative at Ericsson is to design and deliver the operational and
analytical Finance reporting environment that will allow the business the ability to create necessary reports and
allow easier analysis of Finance data.

Key Responsibilities:

• Creation of new repositories for the Development team and installing the Cost Center Rapid Mart.
• Collecting the requirements on some of the other Finance modules like Trial Balance, Controlling and profitability Analysis.
• Worked on Data Services Designer to create new Workflows and for Customization of delivered Rapid Mart Mappings.
• Created Delta Jobs which will handle the Finance team requirements to report on almost real time data for some of the modules like Trail Balance ledger and Management Reporting Ledger.
• Customization of delivered Workflows mappings as per the Business requirements.
• Implementation of Multi Language and SCD implementation on the delivered Workflows.
• Created new Workflows as per the GAP identified.
• Performance improvement of the jobs using various performance optimization techniques likes Degree of Parallelism, Caching and increasing number of loaders etc.
• Modified the Rapid mart Universe according to the Business requirements.
• Involved in Extracting data from ECC and loading to the Oracle Data Warehouse using Data Services.
• Scheduled Data Services Jobs using Data Services management Console.
• Extensively Involved in Preparation of Technical Specifications.
• Prepared Unit Test cases for unit testing and Specification Requirements.
• Created New Workflows using various transformations available in Data Services like Table Comparison, Case, Query, Map etc.
• Prepared Job dependency document for different jobs in the Rapid Mart and the Custom Build repositories.

Environment:BODS XI 3.2, Oracle 10g, ECC 6.0, Toad, Linux

Sept 2008 June 2009

Client: Confidential
Project:Implementation of Inventory Rapid Mart.

Description: The SCM Rapid Data Mart solution initiative at Eli Lilly is to design and deliver the operational and
analytical SCM reporting environment that will allow the business the ability to create necessary reports and allow
easier analysis of SCM data.

Key Responsibilities:

• Worked on Data Services Designer to create new Workflows and for Customization of delivered Rapid Mart Mappings
• Involved in installation of Inventory Rapid Mart.
• Created the repositories using Repository Manager.
• Customization of delivered Workflows mappings as per the Business requirements.
• Implementation of Multi Language and SCD implementation on the delivered Workflows.
• Created new Workflows as per the GAP identified.
• Performance improvement of the jobs using various performance optimization techniques likes Degree of Parallelism, Caching and increasing number of loaders etc.
• Modified the Rapid mart Universe according to the Business requirements.
• Involved in Extracting data from ECC and loading to the Oracle Data Warehouse using Data Services.
• Scheduled Data Services Jobs using Data Services management Console.
• Extensively Involved in Preparation of Technical Specifications.
• Prepared Unit Test cases for unit testing and Specification Requirements.
• Created New Workflows using various transformations available in Data Services like Table Comparison, Case, Query, Map etc.
• Prepared Job dependency document for different jobs in the Rapid Mart.

Environment:BODS XI 3.2, Oracle 10g, ECC 6.0, Toad, Linux

Nov 2007 Sep 2008

Client: Confidential
Project:GDO dashboard Project

Description: GDO Dashboard initiative at Ericsson is to enable a dashboard that can present HR professionals
with the right summary metrics and allow the user to slice and dice HR data based on several employee
attributeslike location, gender, band, ethnicity, age, etc.

Key Responsibilities:

• Collection of Dashboard requirements from HR Reporting team.
• Creation of Technical Specification Documents.
• Involved in creation of data model for external data like Succession Management, Benchmark and AAP data.
• Involved in creation of Bex Queries for the dashboards.
• Creation of OLAP Universes using BO Universe Designer.
• Involved in the creation of Webi reports using Web Intelligence rich client.
• Involved in Creation of Dashboards on SAP HR data using Xcelsius.
• Extensively worked on Performance and tuning of the Dashboards and Reports.
• Involved in creation of Web intelligence reports using OLAP universes.

Education and Trainings:

• Bachelors of Engineering.
• Trained on Business Object Enterprise XI 3.2.