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.
• Currently working on SAP BW on HANA 7.5 Migration and implementation project.
• 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.

TECHNICAL SKILLS:

Data WareHouse: BW 7.5, BW7.4, BW 7.3, BI 7.0, BW 3.5

ETL Tools: SAP BO Data Services 4.0 (Designer, Data Services Repository Manager, Data Services Server Manager, Management Console), SAP BO Data Integrator

InMemory Tools: SAP HANA

Reporting: Business objects - Webi, MS Office.

SAP BW Performance Optimization: Oracle 8,9i, SQL. Core Java, .NET, VB 6.0, D.S, C and C+

Implementation and Enhancement: Worked on end-to-end implementation.

BI Operations: Hands-on experience in areas of Data Loading (Full/Delta), Scheduling, Monitoring, working with Master Data, Transaction Data and Hierarchies.

Modeling: Experienced with creation and maintenance of Data Source, InfoPackage, InfoObjects, DSO s, InfoCubes, DTP s and MultiProviders per the reporting requirements.

Extraction: Data extraction from R/3 systems as well as non R/3 systems such as Flat Files.

Business Content: Involved in evaluating Business Content and activating appropriate Business Contents for the business solution, as per client requirement.

BEx Reporting: BEx Analyzer and Query Designer, Restricted and Calculated Key Figures, Variables, Formulas, Structures, Conditions, Exceptions, and filtering of data.

Process Chain: Involved in developing new Process Chains and sound experience in scheduling, monitoring and handling issues of Process Chains.

SAP HANA: Architect with experience in information modeler with development of various HANA models via Attribute/Analytic and Calculation views. Strong knowledge and experience of SAP ERP Extraction in the areas of Finance, Supply Chain, SD/MM/PP -Logistics, and HR. Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections.

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 migration project from BW 7.3 to Confidential 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 with WEBI Reporting/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 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.

Confidential

SAP BW on HANA Lead consultant

Environment: SAP ECC 6.0, BW on HANA, SAP BOBI 4.0, SAP BODS.

Responsibilities:

• Having experience on in CO-PA on SAP HANA (IMCE). Created Attribute view, Analytical view & calculation view for SD & MM modules and provide development for further BO reporting.
• Working as a core team member as SME and handling the SAP BW on HANA & HANA as a developer.
• Found BW basic designing bug
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Developed data models for the Finance, SD/MM/PP -Logistics, and HR tables in HANA.
• Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables to reflect exchange live rates application.
• Performed currency conversion in Analytical view in SAP HANA
• Handled many SCRs, SMRs, UA tickets and met SLA.
• Prepared the Cutover Activities documentation for Go Live.
• Migrate CUBE & DSO in in-memory database.
• Migrate inventory cube 0IC C03 in in-memory database.
• Monitoring data loads which will be scheduled for hourly, daily and weekly,
• Load monitoring using RSPC, RSMO.

Confidential

SAP BW consultant

Environnent: SAP ERP system BI, FI, SRM, R/3 etc.

Responsibilities:

• Worked as an Application Module Lead, involved in Change Management, effort estimations, development status tracking, status reporting to client and handle SAP BI team members.
• Study of Business and technical flow of objects to understand the requirement.
• BI Objects Development/maintained- InfoObjects, DSO’s, Infocube, Transformation, DTP’s, Start/End routines and Process chains.
• Activated Business Content Objects as per the client’s requirement.
• Created/Maintained BEx Reports.
• Change Management and effort estimations.
• Performed Data Load Tuning by analyzing and adjusting, Indexes, Data Packet Sizing, Aggregates etc.
• Involved in client interactions like con-calls, developing MOM’s and quality related activities of the project.
• Involved in Knowledge sharing sessions with the team members.