SUMMARY:

• 10+ years of Experience in IT industry on SAP BI from .
• Currently working in USA at client place (Mondel z International East Hanover, NJ) as Onsite coordinator since 2013 and holding valid H1 - B Visa till Sep 2018.
• Worked in SAP BI and exposure to Sales & Distribution Process.
• Visited client places in Toulouse-France and Chicago-USA for Go-Live.
• SAP BW & BI 7.0, BW 7.3 & 7.5 - Data warehousing workbench, Data Transfer Process.
• Implemented BI for the application areas Materials Management (MM), Sales & Distribution (SD)
• Performed extraction of data from SAP source systems using LO-Cockpit, Cross Application (Generic Extractors) extractions and Flat files.
• Worked on user exits.
• Expertise in Back-end Business Warehouse Components and involved in Performance tuning.
• Worked on Front-end Business Warehouse Components viz. Queries, BEx-Analyzer.
• Extensively worked on customer exits.
• Business Explorer Analyzer, Query Designer.
• Worked on Transportation of objects.
• Modification/Activation of Standard Business content.
• Experience in Scheduling and Monitoring of data flow to Info cubes, ODS objects.
• Expert in writing the ABAP routines in transformations.
• Capable of working independently and with team members (Mentoring, Team building activities, etc).
• Strong verbal and written communication skills, self-motivated, quick learner
• Strong awareness on implementations, Enhancements, Support projects
• Leadership experience dealing with small teams and gathering the status and monitoring the deadlines for the project deliverables
• Participated in various organization level activities like the fresher’s in SAP-BI and also as a panel member in the BI interview team.

SKILLS:

Modeling: Infocubes, InfoSources, DataStore objects, InfoObjects, ODS, InfoSets, Hierarchies, Multi Providers, Update Rules, Transfer Rules, Info Packages, Transformations, Business content, User exits, Start routines, Routines at Update rules and Transfer rules, routines at Info package level, Process chains, Aggregates, Statistics.

Data Extraction Expertise in Data Extraction.: Worked on Generic Extractors, COPA and Logistics Cockpit & extracting data from Flat Files for Master and Transactional Data.

Reporting: Worked on Business Explorer Analyzer, Query Builder, Web Application designer, Info Set Query, Exceptions, Conditions, Variables, Structures, Filters, Free Characteristics, Restricted Key Figures and Calculated Key Figures.

BW Operations: Worked Master and transaction data Load Monitoring, Event Processing, Data Archiving, and Performance Tuning.

PROFESSIONAL EXPERIENCE:

Onsite Coordinator & Team Lead

Confidential

Responsibilities:

• As Onsite coordinator &Team lead involved in requirement gathering workshops and worked closely with the Business users to finalize the requirements.
• Involved in preparing the high level technical design documents.
• Involved in performance tuning of Queries, Optimization of data flows by removing yearly
• Info Cubes and reporting based upon DSO s.
• Involved in creating the composite providers, Semantic partition DSO s.
• Setup periodic Data loads from R/3 and from a legacy system (flat files).
• Developed Generic extractors to extract R/3 data
• Worked on user exits.
• Installing and creating BI objects like infoobjects, DSOs, infocubes.
• Creating and managing data flow using DTPs, transformations and InfoPackages
• Migrated 3.x DataSources to 7.x.
• Designed and developed queries to generate reports in BEx Analyzer.
• Created Exceptions, Conditions, and Variables, Restricted key figures, New SelectionCalculated key figures and formulae
• Worked on query designer.
• Created aggregates for infocubes to improve query performance.
• Monitoring the process chains.
• Analyzed and corrected production problems as they occur in the SAP BI.
• Handling the tickets.
• Maintaining Work History for all the tickets until it is closed down.

Environment: SAP - BI 7.0, BW 7.3 & 7.5, MM, SD, FI.

Application Developer

Confidential

Responsibilities:

• Setup periodic Data loads from R/3 and from a legacy system (flat files).
• Developed Generic extractors to extract R/3 data
• Worked on user exits.
• Installing and creating BI objects like infoobjects, DSOs, infocubes.
• Creating and managing data flow using DTPs, transformations and InfoPackages
• Migrated 3.x DataSources to 7.x.
• Designed and developed queries to generate reports in BEx Analyzer.
• Created Exceptions, Conditions, and Variables, Restricted keyfigures, New Selection, Calculated keyfigures and formulae
• Worked on query designer.
• Involved with performance tuning of Queries by, Compression, and indexing of InfoCubes.
• Created aggregates for infocubes to improve query performance.
• Monitoring the process chains.
• Analyzed and corrected production problems as they occur in the SAP BI.
• Handling the tickets.
• Maintaining Work History for all the tickets until it is closed down.

Environment: SAP - BI 7.0, MM, SD, FI.

BW Consultant

Confidential

Responsibilities:

• Involved in creation of Info Areas, Info Objects, Info Cubes, and DSO’s, and created required Transformations and DTP to load data into Data Targets.
• Involved in creating the generic data sources.
• Uploaded Master Data and Transaction Data from Different Source systems.
• Involved in preparation and review of Unit Test Plans & Documentation.
• Designing and mapping source and target structures to load transactional data and master data.
• Maintained routines for required objects.
• Involved in transporting the cubes, Transformations and Multi Providers from Development to Quality system.
• As a Quality Team Lead involved in Unit and Acceptance Testing and delivered all the objects within time with highest quality.
• Activated and Installed relevant Business Content Info Objects.
• Involved in Data Modelling and Data Staging.
• Create Process chains for Master data and transaction data loads.
• Involved in migration of data from BW 3.5 system to BI 7.0 system

Environment: SAP BI 7.0, MM, SD.

BW Consultant

Confidential

Responsibilities:

• Involved in Data Modeling to Design Custom Info Providers based on Reporting Requirements.
• Modify Standard and create Custom Data Source, Info Source, ODS, and Info Cubes
• Involved in writing Start Routines at Transfer Rules and Update Rules.
• Involved in writing Start Routines and End Routines in transformations.
• Interacted with Business End Users and Developed Queries as per Functional Specifications.
• Involved in the Transports of Objects and Coordinating transports to BWQ and BWP.
• Worked extensively on BEx Analyzer and created Queries using BEx Variables, Navigational Attributes and Filters.
• Worked with Calculated and Restricted Key Figures, Structures, Variables, Conditions and Exceptions in the BEx Queries.
• Involved in Performance Tuning of BEx Reports by maintaining Aggregates, Compression, Partition and Indexing of Info Cubes.
• Created Work Books and inserted multiple queries into Work Book.
• Data Reconciliation by comparing the data between SAP R/3 and SAP BW Systems.
• Involved in extraction of the data from different data sources that includes SAP Systems, Flat Files.
• Used DB Connect to Load Data.

Environment: SAP BI 7.0.

BW Consultant

Confidential

Responsibilities:

• Involved in front end designing of BEx Reports in BI 7.0 for different application modules.
• Developed BI Reports and BEx Queries from functional specs on the previously developed Infoproviders.
• Designed Formulae, Calculated Key Figures, Restricted Key Figures, BEx Variables and User Exits which are used in BEx Queries.
• Created Structures and Cell Definitions in BEx Query Designer, Queries in Ad-hoc Designer
• Involved in creation of Web Templates in Web Application Designer (WAD) using Standard Web Items like Table, Navigational Block, Drop Down, Filters etc to execute the reports in Web and Publish Queries in Enterprise Portal for the End Users.
• Involved in Analyzing the Technical Specs for BEx Reports as per the business application modules and also suggested the requirements for BEx Reports for some of missing pre-requisite reporting objects.
• Involved in preparing the technical specs based on the HLD’s provided by the front office and developing the Reports.
• As a Quality Team Member involved in Unit and Acceptance Testing and delivered all the objects within time with highest quality.
• Validating the Reports before they are transported to Quality system with existing data in the Development System for the Data Reconciliation as per the functionality of the Reports.
• Involved in calculation of the intermediate values using the Customer Exits as per the given Technical Specs like YTD, and Last year YTD, Last Week and Number of weeks for the user In Put Period etc.
• Proactively involved in raising both the functional and technical issues with to HLD’s given for Reports.

Environment: SAP BI 7.0, SD, FI.

BW Consultant

Confidential

Responsibilities:

• Extracted data from SAP R/3 Source System using LO cockpit
• Set up procedure for extracting SAP R/3 data for Customers, Sales Order in Sales and Distribution using LO-Cockpit.
• Setup the Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management.
• Generated the Data source from SAP R/3 using LO-Cockpit
• Uploaded Transaction Data from the Flat Files
• Daily monitoring of Info cubes and ODS object Data Loads
• Data loading was monitored and the failed data packets were analyzed for Quality check in PSA and reloaded to ODS and further into Info Cubes.
• Involved with PSA in Monitoring the Data Transfer from Source Systems into BW.
• Involved in writing Start Routines at Transfer Rules and Update Rules.
• Creation of Info Cubes and ODS for various applications in SAP BW System.
• Installed Business Content Info Cubes, Info Sources in SAP BW System.
• Involved in mapping of info source with the Data targets using update rules.
• Maintained Info Cubes, Update Rules and Creation of Info Package and scheduling the data into the Data Targets.
• Involved in Info Cube maintenance i.e. Compression, Creating Aggregates, and Partitioning of Info Cube.

Environment: SAP BI 7.0, SD.