SUMMARY

• An accomplished data and analytics consultant with expertise in architecting reporting solutions using BW - HANA/HANA/ABAP/ BOBJ/BODS/Azure. Knowledge of S/4 HANA CDS views.
• Qualified in bridging the gap between business and technology by defining requirements, evaluating risks and issues, and implementing solutions to enhance decision-making.
• Responsible for providing the business strategy insight into the development and deployment of key metrics and for business intelligence solution delivery.
• Responsible for ensuring that key performance metrics are deployed in accordance with global standards established for metric deployment; interacted with the governance process for new metric deployment and development.
• Architected and deployed reporting solutions for Purchasing, MM, FICO, SRM, PP, PS, PM, QM, IS-Media, SD, COPA, GRC & HCM.
• Led quality assurance initiative in BW-ABAP developments and implemented coding standards and performance optimizations. Worked in BW Governance formulating governing processes, procedures and housekeeping activities.
• Extensively worked on ASAP

TECHNICAL SKILLS

SAP HANA: Calculation Views, hybrid models using BW & HANA, SDI and SDA, HANA Live.

SAP BW on HANA: LSA++ architecture, Advanced DSOs, Composite Providers, Open ODS views.

Data Modeling: Designed and developed info object master data & hierarchies, DSO, aDSO, open ODS View, info cubes, Info Sets, open hub destinations, analysis process design(APD) and multi providers, non-cumulative key figures, composite providers, semantically partitioned objects(SPOs), info source, data source, transformations, update rules & transfer rules.

Extraction: SAP R/3, ECC, flat files, Oracle & MS-SQL, LO Cockpit, CO-PA, SRM data sources, Datasource Enhancements, BI Content, view based & Function module based generic extractors with delta.

Planning: Created Filters, Aggregation levels, Data slices, Planning Sequences and Planning Functions. Created custom planning function in Integrated Planning to calculate the cash flows for capital and expenditure and calculated IRR, NPV, ROI and Payback period. BPC-BW integration and configuring models and environments.

Reporting: Design and oversight of Power BI and SAC. Worked extensively on BEx Query designer, BEx Analyzer and Web Application Designer (WAD). Created universes in IDT based on relational connection to SAP BW and UDT on BEx queries. Created Web-I, Dashboards, Crystal Reports & Analysis for OLAP/Excel on SAP BW. Created Lumira Visualizations and storylines. Developed dashboards in Design Studio using JavaScript.

PROFESSIONAL EXPERIENCE

Confidential

Data & Analytics Specialist

Responsibilities:

• Designed and developed pipelines and logic apps to pull data from SAP ECC, SAP BW HANA and non-SAP data sources to SQL Server using Azure data factory. The dashboard built on the provisioned data helped in tracking the productivity of SIPA services provided by the vendors at the plants.
• Fully automated the task of generating LIFO-FIFO Inventory valuation report. This project helped the client have a centralized repository of market prices, unit cost etc. of raw materials across geographies and saved manual task of calculation of LIFO and FIFO every month thereby reducing the man-hours needed for this task.
• Developed a report to measure and monitor the profitability made in different segments. The process included segmentation of the PCA data based on config tables using ABAP transformations and then allocation of indirect costs to direct costs. The allocation was done using Calculation Views.
• Implemented SAP Transportation Management & Finance reporting solutions using SAP HANA, BW on HANA, ABAP & Business Objects. Installed standard business content and converted LSA to LSA++ architecture.
• Implemented TM Cost Analysis, Execution Analysis and Stage analysis reports which helped client to optimize its transport routes and reduce timelines.
• Created HANA Views to create hybrid reporting solution based on aDSOs and HANA tables.

Confidential

Data & Analytics Specialist

Responsibilities:

• Built reporting solutions in Supply Chain using BO 4.1 & BW 7.4 on HANA.
• Interacted with the client and developed Web-I, Analysis for OLAP reports and Dashboards for SCM.
• Transformed LSA to LSA++ architecture and implemented virtualization using composite providers & Open ODS Views.
• Created Inventory and consumption data models using composite provider. The report combined Consumption, Inventory, Material Master, KPI planned data which helped the users list materials where the on-hand quantity was more than the stock level and yearly consumption values.
• Created Open ODS Views on HANA tables for data extracted from Oracle via SLT.
• Used SDA to federate data from Oracle tables and use as a source for Open ODS views.
• Created SPOs for Profit Center Accounting Reports and implementing BADI for central maintenance of partitions.
• Used Advanced DSOs for data staging and reporting.
• Created Monthly operational Inventory report based on HANA Views.
• Developed Cycle Count Summary report based on HANA tables extracted from ECC using SLT. Developed Analytic Views and Attribute views on HANA tables and developed Webi Report on HANA Models.
• Optimized existing ABAP extractors in the IS-U system. Enhanced BW extractors using ABAP.
• Created Dataflows, Workflows & Transformations in BODS to extract data from Oracle to HANA and developed HANA models on top of it.
• Created Lumira dashboards based on Bex Queries and merging it with external sources.
• Created interactive dashboards in Design Studio 1.6 using JavaScript.

Confidential

Data & Analytics Specialist

Responsibilities:

• Interacted with the functional team and users to get the requirements.
• Architected the Spends reporting solution using BO 4.1, BW 7.4 on HANA.
• Designed Web-I reports and Dashboards to report Expense Group/Spend Type for PO and Non-PO Spends.
• Developed APDs to extract spends data for ARIBA.
• Developed HR reports for direct report counts and Organization Unit Chiefs.
• Used LSA++ architecture to create Composite providers and Open ODS Views.
• Developed HANA models for legacy HR data. Created Analytic Views for Payroll, Time and OM and combined multiple Analytic Views in Calculation Views. Used Input Parameters for currency translation. Extracted default schema for currency translation using SLT. Can work on the event-based and parameter-based transformation rules in SLT.
• Developed Transient providers based on HANA Analytic and Calculation views for its consumption in BW and prototyped Advanced DSOs.
• Co-ordinated with the offshore team for development.