NagaSai Mobile: 978-***-****

SAP HANA BW * HANA BI & BW-BO Consultant Email ID:SAIBW2014 @GMAIL.COM

PROFESSIONAL SUMMARY

Around 14+ years’ experience as SAP Techno-Functional Consultant & Project lead with expertise in Implementation, Data Migration, Upgrade,Support in SAP BW/BI, SAP HANA, SAP BO, SAP ABAP.

SAP-EXPERTISE

SAP-HANA:SAP HANA Modeling (HANA Design Studio),Calculation view,Stored Procedures, SQL Scripting.

SAP BW HANA: Open ODS View, Composite Provider,ADSO.

SAP BW/BI : Info Cubes,Dso,Info sets, Start Routines, End Routines, Expert Routines, Customer exits .

SAP BW4 HANA: Start Routine,End Routine

Extraction:SLT,SDA, Enhanced Standard Logistic Extractors, Generic Extractor,Finance.

Reporting: Bex Query Designer, Bex Analyser, Business Objects -BO (Webi Reports, Analysis Edition), Tableau.

SAP ABAP: Start Routine,End Routine, Expert Routine, Classic Reports, Interactive reports.

ABAP - Reporting,. Proven success in performing all reporting features, OLTP Extraction from SAP R/3 into BW using different extraction structures.

SAP BPC :Working Knowledge .

SAP Performance: Performing Cache,To improve the Query Performance. Monitoring the systems for system logs, verification ABAP Short Dumps,, Background Jobs, updates, lock entries,and missing indexes, performance monitoring

Reporting: Bex Query Designer, Bex Analyser, Business Objects -BO (Webi Reports, Analysis Edition), Tableau,Cognos .

Industry Experience : Manufacturing,Pharma,Utility.

Functional Experience: SD-Sales Disturbution, FI-CO,MM,HR,C0-PA,

Educational Qualification:

Master of Computer Applications from University Of Madras.

PROJECT DETAILS

Project No: 1

Client : komatsu : WI--Milwaukee SAP- HANA Consultant Sep 2019 to Till Date .

Roles & Responsibilities:

Designed and implemented SAP HANA data modeling

Converting the Data from the current calendar week to Fiscal calendra week.

Developed few report for asset accounting for the depression value

Created the data flow and report for general leader based on planned value and actual value.

Understanding the business process and creating the technical and functional specifications documents.

Project No: 2

Client : Isuzu: CA-Anaheim SAP-HANA / BW Consultant Jan 2019 to Aug 2019 .

Roles & Responsibilities:

Understanding the business process and creating the technical and functional specifications documents.

Conducting the workshops to Identifying the KPI for the business owners

Created Open ODS View,Composite Provides,Advanced Data Store Objects.

Developed few report to Display Sales Order which are Back Order.

Provided support for data load, validation, performance monitoring and tuning. BW Data load scheduling, monitoring and troubleshooting data extraction / load.

Designed and implemented SAP HANA data modeling using Calculation View.

Project No: 3

Client : Schneider Electric SE TN-Nashville SAP-BW/HANA Consultant May 2017 to Dec 2018 Date .

Roles & Responsibilities:

As a application owner was responsible for system maintaience which includes several modules i.e. Sales & Distribution, Finance, Company, Customer, Master Material, Production Planning, Performance Management, support each country roll-out.

Developed Data Models for back-end design, construction and unit testing of the Info Cubes, Composite Providers, Multi-Providers, and Info Packages

Imported SAP BW Models in SAP HANA, Converting the standard DSO into HANA Optimized DSO, Standard Info Cube into HANA optimized Info cube.

Provided support for data load, validation, performance monitoring and tuning. BW Data load scheduling, monitoring and troubleshooting data extraction / load.

Developed Calculation view based on SQL Scripts.

Project No: 4

Client: EMD Millipore Corporation MA-Boston, SAP-BW Consultant June 2015 to April 2017.

Roles & Responsibilities:

As a application owner was responsible for system maintaience which includes several modules i.e. Sales & Distribution, Finance, Company, Customer, Master Material, Production Planning, Performance Management, support each country roll-out.

Solution Highlights:

Implemented Layered Scalable Architecture for the consolidated systems .

Build a Framework that can be reusable for all Business units with minimal changes as per local requirements.

Migrated the SAP BW to SAP BW on HANA.

Converted the Standard Dso to Advanced DSO, Cube.

Created Open ODS View,Composite Provides,Advanced Data Store Objects.

Conducting the workshops to Identifying the KPI for the business owners .

Understanding the business process and creating the technical and functional specifications.

Developed the tableau dash board reporting for monitoring the supply chain for the orders. Integrated different views in to single dashboard report.

Project No: 5

Client : Schneider Electric SE MA-Boston SAP-BW/HANA Consultant Feb 2014 to May 2015

Roles & Responsibilities:

Migrated the SAP BW to SAP BW on HANA.

Understanding the business process and creating the technical and functional specifications documents.

Was responsible for converting the Dynamic Ax based reports to SAP-BI/BOReports

Was part of the project for developing a consolidation system for North America.

Data Auditing/Reconciliation reports

Part of the project for implementing the SAP-BW on Hana.

Build a Open hubs in BW and down load the data for the Customer,Vendor, Material Master for NAM Reporting System.

Project No: 6

Client : Price Water House Coopers London, SAP-BW Consultant United Kingdom (Enhancement and Support) London - March 2013 – Jan 2014

Roles & Responsibilities:

Presented the overall POC presentation with the client with the key advantages for arhiving data and performance improvement areas on their existing system.

Handled CR’s and PR’s as part of Enhancement work for GFS 6.7, 6.8, 7.0, 7.1 and 7.2 Releases

Analyzed the existing BW system and identified the key Models with huge volumes of data in terms of perfomance.

Developed Multi Provider, Virtual Info Cube to accommodate the archived data from PBS with SAP BW data into the respective reports.

Modified the respective settings on the Bex Query Designer to accommodate the NLS data into the respective reports.

Presented the overall POC presentation with the client with the key advantages for arhiving data and performance improvement areas on their existing system.

Project No: 7

Client : Mylan Australia (ANZ Rollout Implementation) Pittsburgh, SAP-BW Consultant PA

Mar 2012 – Feb 2013.

Roles & Responsibilities:

Involved in requirement gathering from business users for Australia reports.

Prepared the design flows for OTC, FI and CO.

Developed Multi Providers, Info Cube, DSO, Transformations, Start Routines and Field Routines for the respective data models.

Transported the Developed objects from Development to Quality.

Involved in Unit, Integration and UAT test phases for newly developed objects.

Created Bex Queries such as Aged Trial Balance by Customer and AR Roll Forward Report with Appendix Tab reports like Invoices, Credits, Transfers and GL Accounts.

Created OQ and PQ Test scripts for Bex Reports and Backend objects in MTC.

Documented FSF and Config documents for Bex Reports and BI Backend.

Project No: 8

Client : National Grid - NewYork - SAP BI Lead Dec 2010 – Feb 2012

Roles & Responsibilities:

Managing the work allocation with in the team.

Was responsible for completion of UAT for the project .

Trained and guided the fresher’s during the Various Phases of UAT.

Was past of the team during the cut over for Release 2 and Post implementation.

Designed and developed process chain to automate the loading process

Enhanced the standard data source to meet client requirement

Involved in creating unit test scenarios to check the data validity

Picked up the skill of web-reports.

Project No: 9

Client : Kraft Foods-Chicago, Illinois SAP BW Lead Consultant Jan 09 – Nov 2010

Roles & Responsibilities:

Travelled onsite and involved in requirement gathering from business users for the rollout

Experience in leading and managing teams

Worked/supported in all phases of a project including analysis, design, development,s Testing and preparing Technical Specifications.

Was handling high-prioritized tickets regarding extractions, Performance Issues and also load failures.

Extracted Data from Generic Data Sources Using Transparent Tables

Involved in creation of Info Objects, Info Cubes, ODS, Info Source, Data Source, Communication Structure, Transfer Structure, Transfer rules, Update rules, Update methods, info packages, Transformations and DTP’s.

Transporting the developed and changed objects from development system to different system Landscape using Rev-Trak.

Developed front-end reports using Business Explorer (BEx).

Created Process chains for different Business areas to automate the loading process.

Changing of existing queries suiting the requirements of the client from time to time.

Also working as a mentor in the BW QA process in reviewing the objects developed by different team members

Project No: 10

Client : Shell GSAP-OP(Germany & Europe) - SAP BW Consultant Feb 2006 – Dec 2008

Roles & Responsibilities:

Involved in implementing BWSP flow for different Time zones (Layer wise architecture that is specific to Shell).

Involved in creation of Info Objects, InfoCubes, ODS, Info Source, Data Source, Communication Structure, Transfer Structure, Transfer rules, Update rules, Update methods, info packages, Transformations and DTP’s.

Worked with LO Cockpit Extractions, FI extractions, created customized extractors (Generic DataSource) to extract data from R/3.

Extracted data thru Flat Files into SAP Business Information Warehouse.

Loaded the data from R/3 to BW and used different Update modes like Full, Initialization, Delta and Repair Full.

Changing of existing queries suiting the requirements of the client from time to time.

Transporting the developed and changed objects from development system to different system Landscape using Rev-Trak.

Project No: 11

Client : Shell GSAP-OP- SAP ABAP Consultant July 2005 – Jan 2006

Roles & Responsibilities:

Preparation of Technical Specification.

Estimation of Object.

Analysis and development of objects as per client requirements.

QA Team Memeber .

Preparation of Unit test plan/ Unit Test Report.

Contact this candidate