SUMMARY

• 15 years of expert level techno - functional experience in SD,FI/CO, MM,SRM,CRM, PP, QM, PM& HR modules of SAP ECC
• 3+ years of Native HANA/BW on HANA Architecture experience
• 8 years of BW modelling experience
• Good understanding of Order to Cash and Procurement to Pay process
• Proven expertise in data warehousing and reporting tools
• Worked extensively on multiple full life-cycle implementations with hands-on work to build and architect solutions
• Outstanding ability to gather and translate complex user requirements into practical, cost-effective software solutions on time.
• Extensive experience in the design and development of HANA models using Attribute, Analytical and Calculated views, SLT Replication, Stored Procedures using SQL Scripts and ETL pipelines using BODS
• Implemented 3 Full cycle of SAP BI/BW 3.0B and 7.0, 7.3, 7.4 implementations
• Implemented 3 Full cycle of SAP 4.6C, ECC 5.0, SRM 4.0 implementations
• Extensive experience in the design and development of Queries and Reports using BEX Query Designer, BOBJ,WebDynpro ABAP, Query Jumps, CKF, RKF, Filters, Variables, Conditions, Exceptions, Drilldowns.
• Experience in the design and development of OLAP data modeling, data mapping, and BI components such as InfoObjects, Info Cubes, DSO, Multiproviders, Hierarchy, DTP, Transformations, Start/End Rules, InfoPackages, Process Chains, APD’s and Open Hubs
• Self-starter, result oriented ability to multitask with exceptional organizational skills.

PROFESSIONAL EXPERIENCE

LEAD NATIVE HANA CONSULTANT

Confidential, Milpitas CA

Responsibilities:

• Translated functional requirements into technical specs, identified from where the data needs to be fetched and created a SQL Script Calculation View for Recommit metrics in HANA for Supply Chain Analytics, created SQL script procedure to push the calculation view data into a table for enhancing the query performance
• Performance tuning of slow running SQL
• Created XSJS scripts for yearend dashboard using filters to be consumed from Angular JS frontend
• SLT Replication for custom tables from ECC holding the product engineering information
• Enhanced and supported Demand Analytics application involving HANA and Tableau systems which shows data from various sources such as Actual Revenue, Act Shipment, Channel Inventory
• Creation of attribute views, analytic views and calculation views
• Created Tableau dashboards for reporting.
• Bug fixes

SENIOR NATIVE HANA CONSULTANT

Confidential, Sunnyvale, CA

Responsibilities:

• HANA migartion for Start- up company to allow lean manufacturing and MRP Planning for reorder point determination which would allow company to carry limited inventory
• Created SAP UI5 HANA XS ODATA Services for table maintenance and stored procedure calls to be consumed from FIORI using, XSJS,JSON, Java Script
• Moved inventory balances, goods receipts and issues related data from ECC to HANA
• Translated ABAP code from ECC to SQL scripts using SQL, CE functions, Cursors, Exception Handling
• Experienced in performance tuning of slow running SQL procedures
• Created BODS job to allow selective data upload into HANA- Created ETL jobs to bring in data for past consumption, inventory balances, future demand and various other master data such as materials, vendors and plants.
• SLT Replication of finance data
• Designed tables and views, Attribute, Analytical and Calculation views
• Created BO Design Studio dashboards for reporting, Micro strategy reports

SENIOR BI/HANA CONSULTANT

Confidential

Responsibilities:

• Worked with the users to get the requirements, performed gap analysis for BW on HANA project, created technical designs, developed, tested and rolled out projects
• Worked on BI to SAS interfaces for Open Orders and MDM (Master Data M anagement) - Master Data from MDM needed to be available to SAS Interface. Involved in creating info objects, data sources, BODS job, Composite Providers and Calculation Views. The Calculation Views were used to send the data over to SAS through BODS ETL tool.
• Created composite providers to join the master data with transaction data and get the code push down benefits of HANA
• Created calculated views based on the generated analytical views
• Created stored procedures using SQL Scripts
• Created Universe using BO 4.1 for Open Orders and Purchasing Reports and developed WEBI reports
• Came up with testing strategy, created and performed unit and integration testing

SENIOR NATIVE HANA CONSULTANT

Confidential, San Jose, CA

Responsibilities:

• HANA migration to decommission BW system
• Worked in fast paced Agile Development environment to solve business critical problems
• Created Native SAPHANAmodelling solutions using attribute, analytical views and calculation views
• Created tables and stored procedures using SQL Script
• Created ETL pipelines using BODS and Snap Logic to load master and transactional data into HANA
• Created full and delta load ETL pipelines to load HR Analytics data into HANA from various sources such as Workday, Taleo, Saba and Concur.
• Developed Micro strategy reports for Purchasing
• Created delta and full load pipelines to load data into HANA
• Created reports using Tableau

SENIOR BW Consultant

Confidential, San Francisco CA

Responsibilities:

• BOBJ Reporting Solutions for SEDM Metrics and Project Compliance from Clarity
• AP Provisioning reports for Document management and Vendors not in work list

LEAD SAP BW CONSULTANT

Confidential, Palo Alto,CA

Responsibilities:

• Worked with the users to get the requirements, performed gap analysis, created functional, architectural designs, reviewed Data Modeling designs with functional teamfor BW projects
• Successfully implemented solutions in SRM, MM, SD, FI and HR modules. Developed custom function module extractors, used ABAP routines in transformations
• Providing project work load and timelines to the business users
• Extensive experience in the design and development of Queries and Reports using BEX Query Designer and BOBJ
• Participated in design reviews, spec reviews, code reviews, test plan reviews
• Worked with various standard as well as custom BI/BW objects for FI, SD of ECC.
• Worked on customization and enhanced the extract structure to support business needs
• Designed and developed various Data targets and Info providers like DSO (ODS), Info cubes, Info objects, Multi providers and Info sets using Adminstrative workbench (RSA1)
• Debugging the Extractor checker, Start routines and End routines
• Open Hub interface to transfer data from BI to Flat Files to load to an external system.
• Performance Tuning - Evaluated statistical performance and provided recommendations for optimization.
• Created DTPs, Info packages for Full, Initial, Delta and Full repair loads for both Master data and Transaction data
• Created process chains using various process to automate data loading, activation of DSO, compression, drop and create indexes, init fills, roll up, attribute change run etc. Performed huge data loads into DSO and Info cubes from ECC as well as the legacy systems
• Developed Queries to access data from various BW Info providers like DSO, Info cubes, Info objects, Multiproviders and Info sets using BEX query designer
• Created Jump queries (using RRI), Restricted Key Figures, Calculated key Figures, Filters, Conditions, Variables
• Collecting and Releasing transports (BW and BEX)
• Reconciliation of BI reports with the ECC & legacy data

SENIOR BW CONSULTANT

Confidential, Indianapolis

Responsibilities:

• Requirement gathering and design for the orders and delivery project and Inventory Management project on BI 7.0 version for Mead Johnson.
• Built BEX queries showing the different metrics .Worked on Bex Analyzer, created Queries with Variables, Filters, Calculated Key
• Created unit test and integration test plans and production cut over documents
• Performance tuning for slow running extractors, created indexes to increase load performance
• Built Metrics for Sales Orders, Deliveries and Invoices
• Identified data sources and extended them where necessary and filled up the extended data sources using user exits
• Created generic data sources based on views and function modules
• Designed DSO’s and Info Cubes and Multiproviders
• Created complex Transformations using start routines, end routines and expert routines