SUMMARY

• SAP NetWeaver´04s - Business Intelligence consultant having overall 9+ years of experience in SAP Business warehouse configuration and delivery environment like HANA, BW3.x, 7.0, BW 7.3 on HANA & SAP BW 7.4 with BOBI4.0 & SAP BW 7.5 on HANA Migration in Business areas like SD, MM, FI and CRM, APO, SRM.
• SAP BW on HANA certified from OpenSAP.
• Worked on SAP BW on HANA & HANA as a developer.
• In the last 2 years working Transformation Field Routines, Start Routines, End Routines as per the requirement and for the lookups from one DSO to other. Testing and Debugging of routines.
• Strong ability to understand the business.
• Training Attended SAP HANA & BW on HANA.
• Having the savvy knowledge and understanding of Datawarehouse, ETL principals and practice.
• Design and maintained data target/Info provider like Info objects, Basic Infocube, DSO and Multiprovider.
• Working on IM Cube & IM DSO also created virtual provider on analytical view. Created composite & transit provider.
• Experience in data loading and Monitoring process using Process Chains.
• Created Process chains for Master Data and Transactional Data for Both Info packages and DTP & Worked on Transformation and DTP.
• Installed Business Content and Customized to meet the user needs.
• Worked on Data Extraction, Data Loading (Full/ Delta Customizing) and Data Staging Using, LO data Extraction mechanics.
• Hands on experience and technical proficiency in Business Content Data Extraction likes LO cockpit, FI-AP and worked with Generic Extraction data sources.
• Created Transformation Field Routines, Start Routines, End Routines as per the requirement and for the lookups from one DSO to other. Testing and Debugging of routines.
• Used DSO to stage the data before transferring to the contents of the Info cube.
• Extracted Data from the OLTP using the PSA staging Scenario.
• Expertise in Scheduling and Monitoring of data flow to Info cubes, DSO objects.
• Worked on Report Designing to format the reports as per the requirements.
• Designed BEx Reports providing insight of Business Intelligence for Business Analyst for Decision making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Used Variables.
• Involved in managing of Info cube, which involves Info cube content, performance issues like compression of Info cube and rolling up the data to the aggregates.
• Involved in Implementation, Development and Production supporting system.
• Worked with business in gathering report requirements and building/maintaining work plans.
• Excellent business analysis, trouble shooting, presentation, Interpersonal skills & Strong Leadership qualities.
• Excellent oral and written communication and training skills.

PROFESSIONAL EXPERIENCE

Confidential

SAP BW & HANA Migration Lead

Environnent: SAP BW7.5, SAP HANA, SAP BOBI, SAP BODS, SAP ECC, SRM,APO

Responsibilities:

• Currently leading BWoH migration project from BW 7.3 to BWoH 7.5.
• Involved in business and Architecture discussions & studied of Business and technical flow of current objects to understand the Technical & Functional Migration.
• Migrated Cube to IM-CUBE and also worked on converting the Multi Provider to Composite Provider and DSO to ADSO etc..
• Identified the IM Transformation and move transformation into IM.
• Leading a team of more than 15 for the current project from onshore.
• Worked closely with SAP Technical team on implementing the migration project on HANA.

Confidential

Sr. SAP BW & HANA Development Lead

Environnent: SAP BW7.5, SAP HANA, SAP BOBI, SAP BODS, SAP ECC, SRM.

Responsibilities:

• Worked as an Application Module Lead, involved in Change Management, effort estimations, development status tracking, status reporting to client and handle SAP team.
• Leading a team of more than 8 for the project from onshore.
• Worked on SAP BW on HANA, BOBI, BODS.
• Worked with several users, and interacted with them to gather requirements.
• Prepared a presentation of new functionality in BI for the client point of view.
• OLTP extractions from SAP R/3 using LO Cockpit for SD, Purchase, Inventory, production planning.
• Understanding the business process and applying them in Modeling of BW system.
• Experience in extracting data from SAP R/3 using LO Cockpit, FI-SL, CO-PA and generic extractors (View, and FM).
• Created Transformation Routines, Start Routines, End Routines as per the requirement and for the lookups from one DSO to other. Testing and Debugging of routines.
• Expertise in using Open Hub Service functionality to distribute data from SAP BI to other non-SAP data systems.
• Involved in development, design, UAT and after Go-live phases of projects.
• Created Composite providers on BW Modeling tool (Eclipse base).
• Also, worked on IM Cube & IM DSO also created virtual provider.
• Worked closely withWEBIReporting/BOA-OLAP/CR on the requirements.
• Develop and drive implementation of BW best practices and standards for the team.
• Plan, prioritize, and execute BW/BI development across the team.
• Leading and managing cutover activities during implementation Go-live.

Confidential

Sr. SAP BW & HANA Consultant

Environment: SAP BW 7.4, SAP HANA, SAP BOBI 4.0, SAP SRM, FI.

Responsibilities:

• Worked on SAP SRM, FI modules (AP, AR, GL, Fund Management, Grant management etc….) implementation with leading SAP BW on HANA & BO team.
• Identify the business requirements with the help of existing documents and business process needs.
• Lead a team of more than 7 for the project.
• Basing on the requirements, determine which pre-delivered FI, SRM & COPA functional areas to be included.
• Working onmodeling and developed Analytical views for the transactional data, Attribute views for the master data, Analytical views & calculation views as final model in HANA Studio.
• Working on IM Cube & IM DSO also created virtual provider on analytical view.
• Technical Requirements Planning like frequency of data uploads events to be triggered (Process chains).
• Created Transformation Routines, Start Routines, End Routines as per the requirement and for the lookups from one DSO to other. Testing and Debugging of routines.
• Identify the end user requirements (BEx, WEBI, Crystal Report 2013....).
• Set up of the Development environment.
• Business Content Check: Finalize a list of pre-delivered business content to be activated by functional components, data sources, info cubes, objects, queries.
• System Administration procedures like data access issues, definition of roles, responsibilities and tasks for each procedure.
• Agree upon the instrument (template) to record the test result and additional requirements.
• Develop evaluation criteria and test plan.
• Testing of BW operating environment (Plug-ins, BW backend and BW front-end).
• Populate SAP delivered business contents with customer data Verify the content activation Result.

Confidential

Sr. SAP BW Consultant

Environment: SAP CRM, SAP BW 7.4, SAP HANA, SAP BOBI 4.0, SAP BODS

Responsibilities:

• Worked on SAP CRM implementation with Leading SAP BW on HANA & BO team
• Worked with several users, and interacted with them to gather requirements.
• Installed and configured SAP CRM extractor, Report, IM Cube, IMDSO & IO.
• Writing and editing of SAP BEx queries using Query Designer.
• Responsible for developing test cases, business validation rules for verification and validation of data quality.
• Worked on transports of BW queries, objects from Development, Test and Production Environments.
• Developed reports from SAP Info cube by using BEx query designer, applied filters, variables, and parameters/prompts.
• Developed Webi reports, extensively used Variables, Drill down, Breaks, input controls.
• Created simple reports including dynamic calculations involving Queries, List of Values (LOVS), local variables and multiple data.
• Worked with business users for defining reporting needs, help design flexible queries, pre-calculated reports using BEX reporting features like variables, conditions, exceptions
• Creation and maintenance of OLAP universes source from BEx queries.
• Worked on BW-BEx & BO-Webi performance issue.