SUMMARY
7+ years of professional experience in analysis, design, development, implementation and testing of business applications as a SAP BW/BI Developer.

Summary:
Handled Support, Upgrade and Implementation projects in SAP BW.
Implemented 2 full life cycle implementations in SAP BW/ BI 7.0 projects for FI/CO, MM and SD modules.
Expertise in migration of Data source, Queries & workbooks from SAP BW 3.x to BI 7.0.
Inquisitive work in Process chains, Testing, Go-Live, Production Support, End-user training, CTS Transports, OSS Notes and Documentation.
Proficient in data extraction from SAP R/3 to BW system using extraction structures such as LO Cockpit and Generic Extractors extracting data from various source systems through Full update / delta update.

• Experience in the customizing standard business content extractors and enhancing data sources in various applications using customer exits and profound knowledge in using RDA Data sources.

Strong experience in ETL activities like Data Extraction, Data Modeling, Loading, and Scheduling, Monitoring of Process chains for automated data loads from different source systems, Data Marts and Open Hub Services.
Strong experience in Design and Development of BW Reports, Web Application Designer, BEx Query Designer.
Created BEx Reports using Formulas, Selections, Structures, Calculated Key Figures, Restricted Key Figures to give an insight of Business Intelligence and aid analysts in decision making.
Hands on experience in designing web templates and using control queries to increase the query performance.

• Partook in many performance issues by writing stored procedures and performed unit testing, system integration testing, and user acceptance testing at different levels.
• Experienced in writing complex ABAP routines and converting business needs into Data Modeling and Reporting Solutions.
• Extensively used, Variables, Calculations, Sorted inputs, Drill Down and Prompts.
• Worked with production support team and resolved high priority tasks, monitored and debugged load failures, transfer routines, process chains.

Skill Set:

SAP BW 3.x, BI 7.0

Reporting Tools:

BEx Analyzer, WAD, Report Designer, Webi

ERP:

SAP R/3 (4.5B, 4.6C, 4.7), ECC 6.0

Domain Experience:

MM, SD, HR, FI-CO,HR

Professional Experience:

Client – Duration:

Confidential,San Jose, CA Jan 12 – Present

Role:

SAP BW/BI Consultant

Environment:

SAP BW3.5, SAP R/3 ECC 6.0, FI-CO, HR

Responsibilities:

• Gathered requirements from business users and performed Gap Analysis.
• Involved in Data Modeling of Custom architecture.
• Created Info Objects, Info Sources, Info Cubes and developed transfer structure, update rules and transfer rules as per business requirement and extracted data from external sources
• Developed transformations with start routine, update routine and end routine and involved in the creation and maintenance of DTP and Info Packages for loading data in to data targets
• Involved in development and extraction of Complex Flat File Data Extraction into BW system.
• Created process chains for periodic upload of master data, transactional data, and text data and scheduled and monitored the data loads with delta update and full update mechanisms.
• Involved in building BEx Reports. Created variables, conditions, exceptions, cell editors, customer exit variables and structures for developing complex custom reports.
• Extensively used exception aggregations, cell editors, formula variables, RFK’s and CKF’s in the queries.
• Involved in updating Technical and Functional Documents.
• Involved in Unit Testing and System Integration Testing.
• Involved in Aggressive Data Validation Test in UAT Phase.
• As a part of production support involved in monitoring load failures, Delta loads and monitoring the performance of the system.

Client – Duration:

Confidential,Pittsburgh, PA Jul 10 – Jan 12

Role:

SAP BW/BI Consultant

Environment:

SAP BW3.5/BI 7.0, SAP R/3 ECC 6.0, FI-CO, SD

Responsibilities:

• Thoroughly examined business requirements, worked on phase target documents, design documents and project planning.
• Worked with functional teams and customized different data sources for various applications over different modules like MM, CRM, FICO.
• Made use of all new components that are available in DWW for data modeling.
• Worked on Emulated data source migration with export.
• Created Transformations based on transfer rules and update rules during the data flow migration process.
• Used standard and customized extractors to loads data from source system to BW system through full and delta updates.
• Used ABAP code to implement start routines and end routines within transformations like Transaction Quantity and Transaction amount (ZTRAN*** & ZTRAN****).
• Created and Activated DTP’s to transfer data between two persistent objects within BI system.
• Used remodeling concept to enhance Info Cubes and avoid data reloads for making changes.
• Extensively worked on new templates in Web Application Designer (WAD) to design new applications.
• Transferred line item dimensions from Info Cubes to custom created, write-optimized Data Store Objects (DSO’s).
• Designed queries using all types of constraints like Variables, Restricted Key figures, Conditions, Free Characteristics and Exceptions.
• Tested and documented each and every object that is migrated from BW 3.x to 7.0.
• Responsible for performance enhancement activities including Indexing, Cube Re-clustering, Compression and Maintaining Aggregates.

Client – Duration:

Confidential,New York Apr 09 – Jun 10

Role:

SAP BW/BI Consultant

Environment:

SAP BW 3.5, BI 7.0, SAP R/3 ECC 6.0, SAP BO 3.x, SD, MM, CRM

Responsibilities:

• Configured and customized Logistics Cockpit, LO Extractors and extracted LO structures like sales order, purchase order into corresponding BI content.
• Scheduled and monitored Full and Delta Update data loads.
• Extracted data from PM and generated reports on top of it.
• Involved in entire System Upgrade and migrated data sources from BW 3.5 to 7.0.
• Hands on experience with WAD, formatted changes like bar graph to line graph conversion in the upgrade process.
• Hands on experience with ABAP data dictionary, typically used for performance enhancements over various reports.
• Extensively worked on loading BPS data from RDA sources to custom created real time Info Cubes.
• Worked on all sort of Data extractors including Generic, LO Cockpit and Business Content Extractors.
• Optimized extractions from CRM System for data sources like 0CRM_SRV_PROCESS_I, 0CRM_SRV_PROCESS_H etc
• Used ABAP routines to modify Transformations rules according to user requirements and also enhanced Info Objects that are mapped to Communication Structures.
• Designed and developed entire ETL flow, worked on Open Hub Service connections to transfer BW system’s data to Non SAP system.
• Scheduled and Monitored Process Chains to automate the performance tuning jobs like Maintaining Aggregates, Indexing, BW Querying, Compression and Partitioning.
• Worked on BW statistics to evaluate statistical performance in OLAP system.
• Intensely worked on new features in Net weaver 04 platform like BEx Information Broadcasting.
• Used Web Application Designer (WAD) to publish reports (iviews) in Enterprise Portals (EP).
• Worked on HTML, Java script to design web templates and publish the generated reports, also used java script in WAD to pass variables to different levels.
• Always kept user convenience in consideration and used navigational attributes, filters to design and develop query in a way it supports the data analysis intuitively, to give a detail level information esp. in major areas of FI, SD and MM.
• As a part of production support, involved in monitoring performance of the system and handling load failures.

Client – Duration:

Confidential,Woonsocket, RI Feb 08 – Mar 09

Role:

SAP BW/BI Consultant

Environment:

SAP R/3 ECC 6.0, BI 7.0, BEx, SD, SAP BO 3.x, MM, FI

Responsibilities:

• Extensively worked on developing Process Chains to automate periodic uploads of transaction data and master data.
• Designed and generated all sorts of periodic reports which includes daily, weekly, monthly (MTD, YTD etc.).
• Monitored and controlled data loads into major sales target areas like MM, SD, CO-PA etc.
• Captured secondary data into legacy systems with SQL server as backend through UD Connect.
• Designed and generated comparison charts/reports by appending secondary sales data to primary data, effectively used variable exits to meet user/report requirement.
• Conformed each and every data load into BW system with corresponding source system data.
• Carried out many performance activities in BI system including Aggregate Maintenance, Indexing and Target Compression.
• Intensely supported client over the Management Cockpit Area.
• Carried out admin activities like authorizing objects, assigning roles, integrating various systems for special users in Enterprise portal.
• Wrote special user exit programs to enhance fields and Customized extraction programs in R/3 system.
• Developed ad-hoc queries, designed web reports in WAD as per client requirements.
• Partook in building start and update routines, transfer and update rules for target data objects.
• Done performance tuning for various targets by optimizing code at various levels, creating indexes for ODS, aggregates for Info Cubes.
• Extensively worked on different types of extraction to pull data from SAP and Non SAP legacy systems using initialize, Full, Full Repair, Delta data loads and also worked on flat file data extraction for different systems.
• Involved in distribution and development of Process Chain list for automation and performed pro-validations after the data loads.
• Designed and developed different extractor modules for various Generic Data sources.
• Extracted data from various r/3 tables using ABAP programming, followed by BW extraction.
• Configured RRI to different financial reports in BI system.
• As a support team member monitored and debugged load failures, transfer routines.

Client – Duration:

Confidential,Dublin, OH Mar 07 – Jan 08

Role:

SAP BW/BI Consultant

Environment:

SAP BW 3.5, SAP R/3 4.7b, FI, CO-PA

Responsibilities:

• Partook in the design of logical and physical data modeling.
• Loaded master data /hierarchies by creating master data Info Sources.
• Designed extended star schema, created, activated FI info cubes and reported management cockpit information reports with web interfacing.
• Activated accounts payable, accounts receivables and profit center accounting Info Cubes.
• Enhanced Generic Extractors, Data Sources, created user exits and customized delta loads for Data Sources.
• Extensively worked on COPA generic extraction.
• Designed and developed extract structures, transfer structures. Created transfer rules for communication structures and maintained using update rules.
• Captured all the changes in R/3 system business process by adding custom created Info Objects to the existing Info Cubes.
• Performed data extractions from data sources (PSA) to ODS Objects, Used ABAP data extraction programs for generating reports.
• Extracted data from Non SAP source systems (SQL) using DB Connect.
• As a part of production support involved in monitoring performance of the system, handling load failures.

Client – Duration:

Confidential,Jan 06 – Feb 07

Role:

SAP BW Developer

Environment:

SAP R/3 4.7, SAP BW 3.5, SD, MM, ABAP/4

Responsibilities:

• Designed, developed and extracted data from r/3 system and flat files into BW system specifically from SD and MM modules using regular extraction and LO Cockpit extraction methods.
• Recorded all the reporting needs of client and relatively made an inquisitive analysis on standard Info Cubes and ODS objects (BI Content). Loaded transaction data into these business content Info Cubes from data sources like 2LIS_12_VCHDR (order), 2LIS_11_VAHDR (sales), 2LIS_13_VDHDR (billing).
• Worked on Creating and filling setup tables for LO Cockpit Extraction.
• Enhanced data sources like 2LIS_02_SCL, 2LIS_02_ITM and 2LIS_02_BF by adding structures and populated fields using user exits.
• Created and automated Process Chains for periodic load of transaction data and master data.
• Monitored each and every transaction into BW system via Persistent Staging Area (PSA).
• Designed and developed various reports over MM, SD related Info Cubes: “Report for variance in price of material from different vendors”, “report for incoming order and sales figures”.
• Designed and generated many complex (order to cash) reports in BEx with variety of business requirements considering all modules: sales overview, billing, shipment and also designed “special purpose” reports using all constraints; Exceptions, Restricted key figures and Calculated key figures.
• Improved query performance using aggregates, compression and partition techniques.
• Generated various MTD, YTD sales reports.
• As a support team member monitored and debugged load failures, transfer routines, process chains and high priority tickets like setup table filling for LO Extraction, setting up init loads etc.

Client – Duration:

Confidential,Oct 04 – Dec 05

Role:

SAP BW Developer

Environment:

SAP BW 3.1, SAP R/3 4.7b, FI, MM, SD

Responsibilities:

• Gathered requirements from business users and performed Gap Analysis.
• Extensively worked on creating and customizing number of DSO’s, Info Cubes, Info Sources, data Sources in FI, SD & MM modules.
• Activated business content data sources for 2LIS_13_VDHDR, 2LIS_13_VAHDR, 0FI_GL_2.
• Maintained Purchasing and Inventory Logistics data extractions.
• Enhanced Communication structures, transfer rules and extract structures.
• Customized number of Info Objects and Info Sources as a part of Gap Analysis.
• Created and developed Generic Extractors for loading data from customized tables.
• Scheduled Info Packages for initialization and delta updates.
• As a support team member monitored and debugged load failures, transfer routines.

Education: Master’s in Computer Science