SUMMARY:

SAP BW/IBP/HANA/SAC Application Architect Professional in Enterprise Business Reporting, Data Visualization, Budgeting, Planning based on allocation and statistical methods and Analytical Solutions with 16 years of experience in SAP includes in-depth hands experience on Gap Analysis, Physical/Virtual Data Modeling, Functional Requirement Gathering, Agile methodology, Obtain Business Sign-Off and Cut over Activities.

End to End Analytical solution provider from the requirement gathering, full custom model and enhancing the SAP standards using BADI and ABAP CDS Views.

Designed and Developed the Dynamic Analytic Application Metrics to identify how well the S&OP Planner is planned in the past by comparing the history of Actuals from S/4 HANA and Plan data from IBP Cloud using Monthly Lag and Weekly Lag model to adjust the risk of stock out and maintain the optimum stock at all level of supply planning network.

Configured and enhanced the SAP CPI-DS integration across S/4 HANA, BW/4 HANA and IBP.

Strategic thinking, highly motivated to learn and resolve complex business logic using emerging technologies effectively that not only support the best practice but also align with the organization's short- and long-term business benefits using state of the Art technologies to support the Machine Learning capabilities.

Custom Demand Waterfall Report to align with workday model instead of the regular calendar month to identify the outliers based on the client requirement for the Final consensus demand plan.

Expert in functional and technical testing the objects developed by offshore team by comparing data Operational Data and multiple semantic layer of SAP BI data.

5 years of experience in HANA modeling using calculation views, Stored Procedures and Analytic Privileges, in-depth knowledge of how the Graphical HANA calculation execute into SQL statements.

Modeling 360 view of data visualization and reporting using the HANA Modeling calculation views for Tableau.

Worked with C-Level team to create data visualization and data discovery using Analytical tools.

Translating end user insights into actionable solution to meet their present and future business analytical needs.

Designed to Automate the General Ledger trial balance reconciliation to notify the variance to accountant during the month end closing for the Bank.

Dashboard creation for the controller of finance to review the performance of multiple line of business (LOB) with aggregated data.

Integrated predictive data analytics based on the machine learning and internally generated forecast.

Obtain Business sign off on the new initiatives using multiple business scenarios and creating quick prototypes in production.

Implemented 12 full Life cycles of SAP BW Implementation, 2 full cycle of BPC and 5 full life cycle of BW/BOBJ implementation.

Designed and developed end-to-end Analytics solution starting from generic ABAP Extractor, SAP BW Data Modeling and all the way to HANA Modeling Views, BOBJ Dashboard / WEBI report.

Expertise in Multi-Dimensional Data Modeling, LSA++ Architecture, Roles-based information Model, Cross Functional Data Integration, Semantic Integration, Process Integration, Technical Integration, Data Acquisition and Performance tuning.

Extensively worked on the ABAP Routines/BADI, Bex Query, User exit variables, VBA macros, generic extractor and BI content extractor enhancement.

Analytical functional expertise in the SAP ECC Modules SD, Project System (PS), A/P, A/R and New G/L, Fixed Assets, Controlling (FI/CO), PP, APO and MM.

Certification: SAP certified Application Consultant for Business Information Warehouse with mySAP.com, 2002, SAP AG, Germany.

OpenSAP certification on S/4 HANA Implementation, Semantic Notation and SAP BW/4 HANA in nutshell (2014), SAP Leonardo, SAP HANA Query Optimization, SAP Data Intelligence for Enterprise AI, Intelligent Decisions with SAP Analytics Cloud(2020), Statistics for Data Science and Modern Data Warehousing with SAP BW/4HANA (2018) .

BRAVO Award from IBM, 2005 for successful Roll out of SONY SAP BI Project (10 star Delta) for my outstanding contributions.

Clients : FMC, Pfizer, Bank of America, M & M MARS, CINTAS, SONY, Shell, Gillette and HP.

Work

Autorisation : US Citizen

Industries: Agro Science, Financial, Pharmaceutical, Food, Apparell, Oil& Gas, Consumer Products and Consumer Electronics.

Experience

Client: FMC Philadelphia, PA Apr 2019 to Present.

Role: SAP HANA BI/IBP/Finance Integration and Analytics Architect.

Architected and identified the efficient way of transferring data SAP CPI/IBP data BW/4 HANA Model.

Wrote ABAP code to reduce the data footprint to meet different type of time series data to integrate the data between S/4 HANA and IBP.

Designed and Developed the report for the treasury to identify the risk of currency fluctuation using ACDOCA source and BPC Planned/Budget Data.

Designed Analytical model for S&OP Operations to monitor the performance planning against actual.

Environment: SAP BW/4 HANA, S/4 HANA, SAP IBP, Analysis for Office, SAP CPI-DS Cloud and SAP Analytics for Cloud.

Client: Deloitte Consulting-Pfizer Collegeville, PA Apr 2015 to Mar 2019.

Role: SAP BW Application Consultant.

Designed and developed solution to generate the most accurate final sales forecast data using the financial budget data at cost level and the demand forecasting data at unit level.

Created Enterprise Portal(EP) based application for the user to maintain hierarchy and Webdynpro based data entry for the report threshold values.

Created Enterprise Portal Roles and User management for the Self-service business group.

Designed to model to identity the winner of the forecast methods between machine learning and APO forecast.

Generated WEBI 4.1 reports for the Demand planning report and Design Studio 4.1 for the Inventory Rebalancing Tool.

Sales forecast data are delivered through Tableau visualization using SAP HANA Calculation View. Data Foundation and data transformations are done at the SAP BW level.

Implemented Inventory rebalancing tool to maintain optimized inventory at the plant level using PO data, MRP data, and User Maintained Safety Stock and Inventory Demand/Shipment data.

Designed and Developed the solution to identify the exceptions for the worldwide Transportation Lane.

Created generic extractor in APO using ABAP/4 function module and developed data model in BW to reconcile the measures.

Environment: SAP BW 7.5 Powered by HANA, HANA 1.0 SP 11, BOBJ 4.1, TABLEAU, Analysis for Office, and SAP APO.

Client: O&M Inc Richmond, VA Oct 2014 to Mar 2015.

Role: SAP BI/BPC Application consultant.

Created interactive Dashboard for SBU Sales Analysis Dashboard with Gross Margin (GM) and Gross Margin (GP) % using BICS connection.

Created SAP BW transformation on COPA cube to add additional measure for integrated Sales Margin WEBI reports.

Worked in CMS to maintain authorization.

Integrated multiple sources using IDT and created dashboard to track the sales commissions.

Environment: SAP BW 7.01, BOBJ 4.0.

Client: Bank of America, Charlotte, NC Sep 2013 to Aug 2014.

Role: SAP BW/BPC Application Architect.

Innovated solution to automate the trial balance reconciliation process to identify the variances across the SAP systems.

Provided High Level Design document to implementation team which outlines the optimization process, functional alignment and technical improvement to meet the SLA.

Presented advantages of the HANA columnar based data model and BODS ETL for Non-SAP data to COE team.

Identified and recommended solution to remove duplicate data sets on FI-GL balances in BW through bottom up data analysis.

Involved in the remediation process to convert the legacy systems into the integrated SAP environment.

Involved in the BPC consolidation for the inter company elimination and equity pickup.

Environment: BW 7.3, SAP ECC 6.0 and SAP BPC NetWeaver 10.0.

Client: BDI, (Remote) Chantilly, VA. Jun 2013 to Aug 2013.

Role: SAP BW/BOBJ BPC Consultant.

Designed BI Data Model to generate BOBJ reports and improved the reporting performance 80%.

Created ABAP/4 routines to calculate the measures for the Dashboards.

Client: ELO Touch Solutions Inc, Menlo Park, CA Nov 2012 to Jun 2013.

Role: SAP BI Team Lead.

ELO Global SAP and BI Implementation is a big success for their Business.

Responsible for SAP BI Implementation end to end process, validating and extracting data from ECC to delivering BI reports in BO suites.

Implemented SD, AP, AR, GL, Inventory and PO using SAP BI Standard contents.

Enhanced GL data transformation to meet the BPC requirements.

Worked proactively to meet the deadline with limited budget. Trained business users to create self service reports using WEBI.

Configure the Physical Data model CO-PA and oversee development activities, prepare cutover plan, Create Unit Test and Integration Test Plans, Conduct unit tests and integration test

Environment: BW 7.3, BOBJ 4.0, Design Studio 4.1,WEBI 4.1, BPC NetWeaver 10.0.

Client: Pfizer Inc, Collegeville, PA Sep 2011 to Oct 2012.

Role: Sr SAP BW Consultant.

ePA3 (Enhanced Project Accounting Approval and Analysis) Project is created to phase out the Budget and Forecasting using SAP – IP for the Project Accounting.

Worked with Business to identify the KPI based on the Commitments, Budget and Actual derived from WBS transaction to meet their summary and global reporting needs.

Validated data from ECC PO to BI Web Report to make sure the accuracy of data, implemented SAP Note to get the correct value for commitments.

Identified WBS hierarchy issue in the report and re-engineered the Data model with new ECC data source to fix the total issues.

Created PO, journal Entry and GR/IR to check how the account assignment is works with WBS structure as PO goes through the different approval process.

Wrote complex ABAP/4 start routine to distribute the key figure value based on the multiple conditions.

Environment: BW 7.3 and ECC 6.0.

Client: EMC Inc, Southborough, MA Feb 2011 to Sep 2011.

Role: Principal Application Architect

Design a Data Model for Global Revenue reporting to provide better services to customer and increase the sales.

Worked on the POC to integrate Revenue data with other cost modeling from third party system.

Review the functional and RICEFW document written by SAP Implementation partner for the OTC and R2R team.

Designed Bex Query to support the BOBJ dashboard using BICS connection.

Designed Semantic layer and developed report using Webi (BICS) and Webi in BOBJ 4.0.

Environment: BW 7.3 and ECC 6.0.

Employer: Itelligence Inc., Cincinnati, OH Oct 2009 to Jan 2011.

Role: SAP Consultant.

Client: Cintas Inc

Architected the interface from SAP BW to SAP BPC to transfer data through the infospoke by writing expert routine.

Analyzed, Designed and Developed WOR (weekly operational report), data sourced not only from SAP but also from legacy AS/400 system.

Created P& L statements using SAP standard extractor new 0FI_GL_14 and 0FI_GL_20.

Client: Bellisio Foods

Designed Data model to get the Open Production orders using Generic extractor function module using the Object ID tables.

Extracted data from Material View (2LIS_04_P_MATNR) to get open production order to compare with SD ABC indicator.

Enhanced Material Ledger on PP to get the open Order cost to compare in the multiprovider level.

Environment: SAP BI 7.01, SAP BPC 7.0, SAP ECC 6.0.

Client: M & M MARS Inc, West Chester, PA. Nov 2006 to Sep 2009.

Role: Senior SAP BI Analyst

The US PRISM (SAP BI & ECC) implementation in April 2009 was a big success for the Snack and Food businesses at MARS.

Conducted meeting with business to define the current Business Analytic requirement and design the future business models that not only supports the organizational needs but supports the best business practices of the SAP BI.

Developed complete Technical Architecture for Daily Inventory Projection (DIP) including Data Modeling, complex routines and Bex / Web reporting.

Wrote complex Transformation Routines using ABAP to calculate the Critical Unload priority based on Safety stock.

Involved in developing Inventory Demand reports which helped to reduce the 30% cost of the Aged Inventory.

Generated DIP reports using Bex query and WAD.

Created Dashboards using WAD and Visual Composer to generate list of Material reports using Java Script.

Worked on Query development and designed many queries using BEX analyzer for data presentation. Incorporated queries into workbooks. Used Variables, calculated and restricted key figures, conditions filters and exception for BEX queries.

User exits, BADI’s, ABAP Object Oriented Programming.

Environment: SAP NetWeaver 2004s, SAP BI 7.0, SAP ECC 5.0,, Enterprise Portal 6.0

Education: Master of Science (Computer), Bharathidasan University, India.

Bachelor of Science (Computer), M .K. University, India.

Contact this candidate