PROFESSIONAL SUMMARY:

• 14 Years of SAP consulting experience. Certified in SAP HANA, SAP BI, SAP BW, OCP 9i DBA with BS and MBA.
• Previous employment as SAP consultant
• Experienced in implementing Projects on Off shore - On site model.

SKILL MATRIX:

SAP S/4 HANA Analytics, SAP Native HANA 2.0: SAP S/4 HANA Virtual Data Models, SAP HANA Modeling, AMDP Classes, SDI/SDQ, OData services, Data Provisioning using SLT and SDA, BW on HANA Side Car Architecture, Calculation view, SQL Script, SAP BW/4 HANA, SAP BW 7.5 7.3 / 7.0/3.5 / 3.1 / 3.0 , BI/BW Architecture, BW Data Modeling and extended star schema, Job Scheduling, ETL, APD, Start/End ABAP routine

SAP BI/Bex/Business Object/BODS 4.2: Analysis for Office, WebI, BEx Query Designer and BEx Web Application Designer in building Queries, Conditions, Variables, Exceptions, Calculated & Restricted Key figures, Data migration via IDoc using BODS 4.2

PROFESSIONAL EXPERIENCE:

Confidential

HANA Analytics/ Migration Engineer

Responsibilities:

• Real time Data replication from ECC source to Confidential e-Hub (HANA DB) using SLT and SDA
• Developed SDI/SDQ Models for data extraction, cleamsing,matching and de duplication.
• Develop SAP HANA models for data extracted, matched, cleansed and deduplicated KPIs
• Developed HANA models for data profiling of survived records
• Developed SAP HANA models data quality check for survived records
• Cross reference HANA modles for survived and loaded records in S/4
• IDoc testing and migration of ECC data to S/4 via Idoc / BODS jobs.

Confidential, Philadelphia, PA

SAP HANA/BW Consultant

Responsibilities:

• Develop TDD based on FDD
• Develop HANA models to be consumed by ODATA services, via AMDP
• Created SAP HANA Calculation views as per busiess requirements
• Develop AMDP classes and consume HANA models in AMDP class
• Conducted UAT and made required changes as per new business requirements

Confidential, Houston

SAP BW/HANA Consultant

Responsibilities:

• Conducted business requirement analysis, gathered business requirements from business users and developed functional and technical design documents
• Build SAP HANA information models using SQL Script base Calculation Views.
• Built user defined HANA functions
• Conducted UAT and made required changes as per new business requirements

Confidential, Orange County, CA

Sr. SAP BW on HANA Consultant

Responsibilities:

• Conducted business requirement analysis, gathered business requirements from business users and developed functional and technical design documents
• Build Native HANA Cohort calculation view as a foundation per business requirement
• Build common master data object relationship/hierarchy as shared dimension.
• Developed various calculation views based on Cohort and joined with other tables/ calculation views.
• Created OTC SAP BW on HANA analytics and supported existing BW application.

Confidential Plano

Principal Consultant - SAP BW / HANA

Responsibilities:

• Managed the project on ‘On Site- Off shore’ model, development activities with development team in India.
• Developed SAP Native HANA model including creating schemas, creating attributes, measures and developing Information Models with Attribute Views, Analytical Views and Calculation Views
• Performed UAT and managed user’s issues and concerns about the developed application.
• Managed the project on ‘On Site- Off shore’ model and managed the development activities with development team in India.
• Management of business user’s daily issue and provided support to users.

Confidential, Irving, Texas

SAP BW on HANA Lead

Responsibilities:

• Conducted business requirement analysis, gathered business requirements from business users and developed functional and technical design documents
• Designed SAP AR reporting solution based on customer balance 0FI AR 6 data source, Customer Line Item 0FI AR 4 DATA source.
• Designed and built CO reporting solution based on COBK and COEP table. Designed SLT real time replication to HANA tables from ECC and consumed HANA data in BW remote cube, based on HANA view.
• Designed and built COPA reporting solution based on CE1100 and BSEG table. Designed SLT real time replication to HANA tables from ECC and consumed HANA data in BW remote cube, based on HANA view.
• Designed SLT real time replication to HANA tables from ECC and consumed HANA data in BW remote cube, based on HANA view
• Built BEx reports for GL, AR, CO and COPA functional area and used the BEx reports as the data source for BOBJ reports.
• Conducted FUT/ UAT, client interaction, schedule and conduct meetings with clients and user training

Confidential, San Francisco, CA

Sr. SAP BW Consultant

Responsibilities:

• Customized 0CUSTOMER ATTR, 0MATERIAL ATTR, 2LIS 02 SCL, 2LIS 11 VAHDR, 2LIS 11 VAITM extractors and scheduling the process chains for the data loads
• Conduct UAT, client interaction, schedule and conduct meetings with clients and user training
• Provided production support for data load, validation and performance monitoring/tuning

Confidential, San Diego, CA

Sr. SAP BW Consultant

Responsibilities:

• Business analysis, requirement gathering and developing technical design document
• Developed the new architecture for daily operations flash reporting.
• Developed web reports where one variable date was driving the daily, WTD, PTD, QTD and YTD reports
• Managed and supervised the Offshore development activities
• Provided production support and resolved the business issues on daily basis.

Confidential, NJ

Principal Consultant

Responsibilities:

• Designed and developed APD process for monthly inventory snap shot, extract data from non-cumulative Inventory cube and storing the summarized data in a new Cube via APD
• Designed and developed open hub to export BI data to Teradata.
• Developed open hubs, created file path directory structures and published BI data to tera data via open hub.
• Developed and schedule the process chains for APD and open hub loads.
• Conducting business analysis and requirement gathering.
• Designed Analytical Science BI solution architecture for flat file based source system, scope management and project management
• Managed the project on ‘On Site- Off shore’ model and managed the development activities with development team in India.
• Conduct UAT, client interaction, schedule and conduct meetings with clients and user training
• Managed the project on ‘On Site- Off shore’ model and managed the development activities with development team in India.
• Customized 2LIS 11 VAHDR, 2LIS 11 VAITM and 0CUSTOMER ATTR extractors
• Installed 0FI AR 4, 0FI AR 6, 0FI AR 10 and 0FI AR 5 data sources, 0FIAR O03, 0FIAR O06, 0FIAR O10 DSO and 0FIAR C03, 0FIAR C02, 0FIAR C05 cubes.
• Conduct UAT, client interaction, schedule and conduct meetings with clients and user training.
• Supported and managed issues after go-live, scheduled V3 batch jobs, ETL, created process chains and optimized the system for better performance.

Confidential, CA

SAP BI Specialist

Responsibilities:

• Conducting fit gap analysis based on existing reports from legacy system.
• Developing over all architecture for OTC based on 2LIS 11 VASTH, 2LIS 11 VASTI, 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 12 VCITM, 2LIS 13 VDITM extractors
• Installed standard BI objects including info objects, DSO, Cubes, Data sources.
• Multidimensional Data Model using Extended Star Schema, designed and developed Info cubes and DSO.
• Customized 0CUSTOMER ATTR, 0MATERIAL ATTR, 2LIS 02 SCL extractors and scheduling the process chains for the data loads
• Writing BI routines for populating data in DSO from look up DSO based on EKES table
• Developed vendor performance reports
• Developed test cases and conducted unit, integration and stress testing
• Configuring open hub destinations
• Customizing the standard extractor to meet specific business requirements.
• Creating and scheduling the process chains for the data loads
• Writing BI routines for populating data in DSO from look up DSO based on 2LIS 02 Confidential data source and lookup for accounting information, pertaining to PO.
• Scheduled V3 batch jobs for delta extraction