SUMMARY

• Over 19 years of SAP (S4, Native, BW on Hana, BW & ABAP) experience.
• Strengths lie in Architecture, Analysis, Data Modeling of Business Intelligence. Very good logical skills suitable for process design, development & implementation. Excellent communication and customer focused attitude.
• Extensively worked on S/4 HANA - Finance & Supply chain modules.
• Extensively worked on ABAP CDS views, Calculation views, SQL Scripts & Stored Procedures.
• Involved in the development of Cloud Integrated Native-HANA environment.
• Extensively worked on SDI (Smart Data Integration).
• 7 Projects experience in BW on HANA and Native-HANA modeling on SAP & Non SAP data.
• Involved in 7 SAP BW implementation projects
• Involved in 3 SAP-BW-CRM implementation projects.
• Involved in TSW IS-OIL projects and also AFS-Retail implementation project.
• Worked on different technological platforms SAP R/3, BI, Business objects, BODS, SDI & HANA.
• Strong exposure in Functional areas of SD, MM, PP, QM, FI-COPA, SRM, PLM, FM, FS-CD, IS-OIL, IS-RETAIL, AFS, HR Analytics and CRM Analytics.
• Excellent trouble shooting, Analytical, problem resolution and organization skills.

TECHNICAL SKILLS

• ABAP/4, C, C++ and Java
• SAP BW 3.1, 3.5,Net weaver BI 7.5 & B4
• Oracle, SQL & HANA

PROFESSIONAL EXPERIENCE

Confidential - Charlotte, NC

SAP Consultant

Responsibilities:

• Converted the Logistics, HR, PCA, CCA, FI & COPA BW 7.4 objects to B4.
• Responsible for ODP enablement for all the SAP ECC extractors.
• Configured data tiering options for COPA ADSOs.
• Redesigned & Implemented the Inventory Management module.
• Developed Inventory Ageing, Stock Overview reports.
• Leveraged the Native HANA capabilities by building calculation views, dictionary views and used them in composite providers & transformations which also helped in reducing the data foot print.
• Successfully completed the UAT for HR & IM modules and went live on time.

Confidential - North Bergen, NJ

Responsibilities:

• Extensively worked on ABAP CDS views enhancements for S4 SD/MM and Retail POS modules.
• Provisioned the CAR (TLOGF table) data to enterprise HANA using SDA & built union CVs on S4 & CAR data.
• Developed the store performance report on CAR retail sales data
• Improved the performance of MicroStrategy reports by enhancing the underlying CDS views.
• Exclusively worked on Hana plan viz on the generated MicroStrategy SQL.

Confidential - Alpharetta, GA

SAP Consultant

Responsibilities:

• Extensively worked in data extraction from Confidential Hana to ClarusONE Hana using SDI Cloud Integrated platform.
• Extensively worked in data extraction from Walmart Teradata system to ClarusONE Hana using SDI file interface via Azure BLOB.
• Developed the HANA repository objects like tables, views, stored procedures using design time CDS concept
• Worked on developing flowgraphs to move data both from Confidential Hana and Walmart Teradata Files to ClarusONE Hana and persist in Hana tables.
• Worked on SCDs in preserving history for item master, vendor master & cost master.
• Developed scripted & graphical calculation views & DBVIEWS for Vendor Master, Vendor grouping, Item Master, NDC Master, Third-party Medispan data, Third-party FBD data, Drug Master, Bulk PO, PO, PO Receiving, Inventory, Demand Cost, Admin Fee, Formulary, IMS, Item cost history, DC shipments, NWN Cost and Forecast data.
• Developed stored procedures to implement delta logic for cost data, Inventory data, SLA data, Demand data and for data reconciliation process
• Extensively worked on Hana complex calculation views to combine data from Walmart & Confidential systems.
• Extensively worked on SQL scripted calculation views by accessing ECC tables,Vistex tables & BW objects
• Participated in design blueprint / requirement gathering of requirement gathering business requirements for S/4 Hana
• Extensively worked on XSODATA and XSJS components.
• Consumed the Hana DB views using Micro Strategy reporting tool.

Confidential - Columbus, OH

SAP Consultant

Responsibilities:

• Leading and implementing multiple HANA Native and HANA/BW projects and closely working with different business users, Analysts, strategists and solution Managers.
• Extensively involved in project design, road-map, detail designs and development approaches.
• Developed complex HANA information models and achieved MPP(Massive Parallel Processing) by using different column views in SQL Script calculation views.
• Developed the open PO HANA model using projections, aggregations, joins in calculation view.
• Created the SLT model for procurement & COPA modules.
• Developed the stored procedure to access the J*** tables of AFS module and writes the PO status into custom table on which another calculation view is built.
• Worked on POC in bringing SAP ECC supply chain tables data by using BODS ETL tool, as part of Data Lake project.

Confidential - Pittsburgh, PA

SAP Consultant

Responsibilities:

• Designed and developed the Composite Providers & Semantic Partitions for FMR
• Provided the Product Costing Bex Queries to users for Self Service Reporting in BO.
• Developed the ADSOs layer for all the Sales & Procurement extractors by adhering to the LSA++ approach.
• Developed attribute, analytical, calculation views(Graphical/Scripted) and stored procedures for sales process.
• Developed the calculation view for Open Sales order.
• Developed the SQL script based calculation view & procedures to fulfil the time dependent master data requirement.
• Transported the HANA objects through the landscape with CTS++ approach using solution Manager.
• Replicated COPA related tables to accelerate CE1-CE4 real time reports using SLT to HANA DB.

Confidential - Washington, DC

SAP Consultant

Responsibilities:

• Designed and developed the BI infrastructure for Business Planning & Staff Task Assignment Tool.
• Developed Business Planning report, WPA Report, Staff Weeks Report, Variable Cost Report and Task Detail Report.
• Developed the ECC extractors for the Business Planning and Staff Task tool
• Developed the operational reporting on Business Planning & Staff Task module by integrating with Finance & HR data.
• Built the analytical & calculation models so that composite tool can access them.
• Built the hybrid HANA models by joining SAP and NON-SAP data.

Confidential - Allentown, PA

SAP Consultant

Responsibilities:

• Re-designed and developed the BI infrastructure for Sales & Distribution, Procurement, and Inventory Mgmt.
• Collected the requirements from Business for KPI metrics.
• Developed Sales KPI reports, Open Orders report, Shipped Orders report, Sales Analysis trend by month, Sales Analysis, Daily Sales, Open deliveries, Price Volume report and RGA report, PO Invoice Variance report etc.
• Extensively worked on the Finance new GL extractor (0FI GL 14).
• Worked with FI-BPC team for period end activities.
• Worked BW on HANA migration project.
• Worked on SAP based HANA Models (Attribute, Analytical views)
• Composite Models using BW on HANA and HANA Models for global reporting.
• Developed a dashboard for Avantor Business Service report in BO 4.0
• Created SLT transformation for COPA cost based extraction