SUMMARY

• 8 years of experience in Enterprise Systems and BW/BI that includes SAP BW/BI, ECC and Business Objects.
• Extensively worked on SAP BW 3.5, and BI 7.0 and HANA.
• Proven experience in three complete life cycle implementations of SAP BW that includes requirement analysis, data modeling, technical design and development, data extraction, report generation, and transport.
• Excellent knowledge of SAP BW components like Info Cubes, Multi - Cubes, Info Source, Info Objects, ODS objects, Transformation, Process chains, Update rules and Transfer rules.
• Experience on BI-Upgrade from BW 3.5 to SAP BI 7.0(NW 2004s).Migrating the 3.5 objects to BI.
• Comprehensive experience in the ETL process of SAP BW life cycle. Active involvement in the each of these phases. Effectively trained my team members with non-technical skills of the ETL process.
• Experience in Net weaver 2004s- Data transformation, DTPS, DSO’s, BEx Broadcasting, Web Analyzer, BEx Report designer and BEx query designer.
• Expertise in Report Generation - Worked extensively in BEX Analyzer in building Queries and saving in Workbooks and created Custom Queries using Conditions, Exceptions, Variables & Structures and created aggregates for frequently used queries, RRI - Jump queries, Web Publishing and Trained End-users.
• Extensively used Business Objects reporting functionalities such as Master Detail, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Experience on Establishing Source system connection from BW to SAP R/3, Flat file, and BW. Involved in transporting the objects from development to test and Production systems, analyzed the reason for failures of the Transports.
• Involved in Quality testing methodologies using Unit Testing and Integration Testing.
• Involved in activation of Business Content.
• Experienced with Authorization Variables, Authorization Objects, Creation of Roles and Users.
• Created Process chains for Master data and transaction data and Monitored daily, weekly and monthly process chain loads.
• Good Knowledge in SAP HANA data modeling using Attribute View, Analytic View and Calculation View.
• Having strong knowledge on SAP HANA Data Modeling using Attribute Views, Analytic Views and Calculation Views (both Graphical & SQL script based) & SAP HANA Data Provisioning using SAP LT Replication Server (SLT).
• Hands on experience in HANA modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, analytical view and calculated views. Experience in applying privileges.
• Hands on experience in configuring SLT system, loading the data from ECC system for real time reporting based on the business requirement.
• Experience in creating Virtual providers based on HANA model.
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
• Experience in loading data from tables in HANA Database to BW data marts.
• Involved in business and architectural discussions.
• Good knowledge of Change Analysis and Migration support.
• Strong experience with logistics business users.
• Excellent interpersonal skills and communication skills.

TECHNICAL SKILLS

Programming Languages: Java, C, C++, PL/SQL, SQL, XML

RDBMS: Oracle 10g/9i, SQL Server 2000/2005, DB2, SAP BW 3.5, 7.0, SAP ECC

Operating Systems: Windows 98/XP/NT, UNIX

Tools: PL/SQL Developer, Microsoft SQl Server, Business Objects Data Integrator/Data services

ERP: SAP, PeopleSoft

Data Modelling: SAP HANA Studio

Data warehouse ETL Tools: SAP Business Objects Data Services 4.0, Informatica Power Center 8.1/7.1.

PROFESSIONAL EXPERIENCE

Confidential

BI/BOBJ/HANA Developer

Responsibilities:

• Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.
• Created Functional document specification and Design requirement specification for the HCM reporting requirement.
• Gathered and analysed the requirement to replicate the ECC content in HANA using data provisioning.
• Performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Configured SLT system, loaded the data from ECC system for real time reporting based on the business requirement.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool).
• Created virtual info provider based on HANA models.
• Build and enhanced BI objects that include Info Objects, Data Sources, Transformations, DTP, DSO, Info Cubes, Multi-providers, Info set and Open Hub.
• Involved in managing of info cube, which involves info cube content, performance issues like indexes, statistics, compression of the info cube and rolling up the data to the aggregates.
• Created required data sources, DTP’s, info providers, export data source and routines for data consolidation.
• Created BEx queries and assigned them to role.
• Worked extensively in BEX Analyzer in building Queries and saving Workbooks and created Custom Queries using Conditions, Exceptions, and Variables & Structures. Created aggregates for frequently used queries, RRI - Jump queries.
• Created WEBI report based on BEx queries, Universe using UDT.
• Created WEBI report based on HANA models using IDT.
• Performed gap analysis between existing and new reports.
• Performed gap analysis between blackened objects and security.
• Implemented new security model with variable security in the analysis authorization.
• Worked on performance optimization of master data load.
• Managing client tickets during the support process of the project and resolved all the issues.
• Developed process chains to automate the initialization and delta updating of all the data.
• Worked on the decommissioning projects and created data sources to extract data from legacy system using data service.
• Involved in designing universe on top the BEx queries and developed WEBI reports.
• Extensively worked with the business users on regression testing the WEBI reports and fixed the issues.
• Worked with the security team and the business user to get access to the necessary folder for the super user to run the WEBI reports.

Environment: SAP BI 7.3, SAP ECC 6.0, BOBJ4.0, HANA 1.0 SP2, Ms office, Visio, MS Outlook.

Confidential, Chicago, IL

BW/BI developer

Responsibilities:

• Created Functional Specifications for HCM- PY and TM reporting requirements.
• Set up the Architecture for HCM - PY, PA and TM reporting requirements.
• Enhanced HR master data for Employee, person to fit user requirements with work schedule, Managers PERNR, MBO eligibility, address information and other required fields.
• Enhanced wagetype master to establish relationship between wagetype, its symbolic account and the G/L account from T030 table into a Lookup DSO.
• Merged wagetypes from KRONOS to wagetypes in SAP based on description field into a lookup DSO.
• Created a FM extractor to bring data from Info type 0041.
• Extensively Worked on Lo Cockpit and performing necessary procedures like setting up of update Mode, deleting set up tables, filling up of set up tables and loaded data from ECC to BI system.
• Performed LO Cockpit extraction, Knowledgeable in LIS, Generic and CO-PA extraction.
• Worked with SAP R/3 Logistics (LO) in loading Sales and Distribution data into BI.
• Created ODS, Info cubes, Multi-providers and info sets and extracted SD data (Data sources Like 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 11 VASCL) of SAP R3 into SAP BW using LO Cockpit(LBWE) extraction. Extensively worked for Sales Order Review.
• Extensively used Structures, cell definition, calculated key figures, restricted key figures, new selection, new formula, exceptions and conditions.
• Worked on multiple end routines, transformation routines to model data into the Info providers.
• Worked closely with Security and Basis team on Role management and transports management.
• Leading the On-going development and testing activities for HCM-BI requirements.
• Organized multiple workshop sessions to train users with reports.
• Managing Problem tickets during the support phase after Go-live and ensure Smooth Go-Live and Transition to Sustain.

ENVIRONMENT: SAP BI 7.0, ECC 6.0, CONTOL-M, Business Objects, and Business Explorer.

Confidential, PA

BW/BI developer

Responsibilities:

• Defined the BI-architecture for DP waterfall and forecast accuracy report based on adjusted sales history from APO server.
• Worked on performance optimization of master data load.
• Performed analysis, design, development and implementation of standard/ customized InfoCubes, ODS Objects.
• Involved in meeting with high level architects, got the details causing the BI load to fail on a frequent basis.
• Involved in monitoring the master data process chains load and the process chain dependencies.
• Worked on process chains restructure based on their dependencies and the load of the master data.
• Restructured process chains to increase the performance of the BW system.
• Tailored Transformations and Routines to optimize performance.
• Liaised with various cross-functional groups for enhancements and selecting best solutions for issues.
• Created Update routines and Transfer routines and start routines for data transformations.
• Created Process chains to load master and transaction data.
• Worked on transportation of objects across development, QA and production systems.

ENVIRONMENT: SAP BI 7.0, ECC 5.0, BEx analyzer, BOBJ

Confidential -Palmolive, NJ

BW/BI Consultant

Responsibilities:

• Involved in Business /user requirements gathering and Understanding the current Business process, data applications and reporting methodologies, in order to meet the Management and Analytical reports.
• Performed analysis, design, development and implementation of standard/ customized InfoCubes, ODS Objects and MultiProvider for FICO and CO-PA modules.
• Implemented Standard Business Content InfoCubes like Line Item (0FIAR C03), Payment History (0FIAR C05), and Cost and Allocation (0CCA 11) and customized those using Update Rules. Created ODS, InfoCubes and MultiProvider for queries
• Creation of transporting requests for missing objects in BW 3.5 using transport correction and moving those objects into BI 7.
• Analyzed and performed the up-gradation for ITT, PNL and DFR applications from SAP BW3.5 to SAP BI7.0.
• Extensively worked on Data warehousing workbench to create Data Store Objects, Multi providers, Transformations and DTP’s.
• Involved in regression testing for ITT and PNL applications and did the changes in the code of start routine and end routines.
• Created transformations to map source fields to target fields for Indirect Trade Tracking and Profit & Loss applications.
• Created DTPS to load data from PSA to DSO’s and as well as into Info cubes for ITT & PNL.
• Involved in Transportation of all Objects like: Info objects, Query’s and DSO’s etc into BI production system after validation and testing the same in development system.
• Extensively worked on BPS on BPS with Planning Areas, Planning levels, Planning packages, Planning Functions.
• Worked with planning functions.
• Created Web Interface. Done Unit Test and System Test for Planning Layouts.
• Prepared End User training documents.
• Developed reports using Business Explorer that had exceptions, conditional formatting, restricted key Figures and calculated key figures.
• Worked with the users for defining the reporting needs and helped design/develop flexible queries and pre-calculated reports using BEX reporting features like variables, exception and conditions in Sales and purchasing areas exception and conditions in Sales and Purchasing areas.
• Involved in the creation of queries for planning.
• Designed functional specification based on user requirements.

ENVIRONMENT: SAP BI 7.0, SAP BW 3.5, SAP R/3 4.7, BEx Analyzer.