SUMMARY:

• Having 12 years of experience as Senior SAP BW HANA Consultant with strong expertise in SAP HANA, BW 7.5/7.4/7.3, BW 7.5 Upgrade, Business Objects, Tableau, Integrated Planning and SAP ABAP.
• Extensively involved in Business Blueprint/Requirements gathering, Gap analysis, Project Scoping, Sizing, Preparing Functional and Technical Specifications, Functional Design and Modeling, Functional Unit Testing, Performance Testing, Integration testing, Regression testing cycles and End User Training and Documentation.
• Experience in Modelling on BW 7.5 on HANA mixed scenarios including creation of ADSOs, Composite Providers on generated BW infoproviders.
• Strong experience in ETL process extracting data from different source systems SAP and Non - SAP to HANA.
• Worked on BW Upgrade project from 7.4 to 7.5 version executing Pre and Post system validations during the upgrade.
• Worked on resolving highly critical issues after the upgrade to BW 7.5 which was coordinated with SAP on implementing the note for the bugs.
• Strong experience in Reporting and Analytical tools and extensively involved in report building practice with users on Analysis Office, WEBI and Tableau.
• Strong experience in building solutions using Modelling tools SAP HANA, SAP BW, creating HANA models using Graphical views and implementing different time structures required for reporting and creating interfaces to integrate with upstream applications.
• Strong experience in creating Calculation views using Star Joins, Filters, Input parameters, Calculated Columns for complex KPI s and deriving Time Buckets joining Dimension Views.
• Strong experience in Data Warehouse design techniques and Data Modeling (SAP BW 7.3/7.4/7.5) configuration & customization of SAP BW models, data flows, enhancement of transactional/master data extractors, Infoproviders construction, consistency & performance tests, process chains design, troubleshooting, transporting, functional & technical documentation.
• Strong experience of SAP BI report design techniques, implementation and supporting complex reports (Query Designer, Bex Analyzer, WAD, Web Intelligence) and knowledge of Analytical tools like Explorer, OLAP, Dashboards and SAP Lumira
• Extensive Technical experience with BW on HANA, latest features of BW7.5/7.4/7.3 implementing performance and maintenance optimized data models utilizing standard LSA and LSA++ architecture specifications.
• Strong consulting approach to work with IT team members and internal business users and Business analysts.
• Familiar with all stages of SDLC from design through post-implementation & proficient in ASAP Methodology and SAP BI Best Practices and design principles.
• Broad knowledge of standard SAP BI Business Content (SAP BW 3.x & SAP BI 7.x) and new specific features and capabilities of SAP BW 7.4 and 7.5.
• Strong experience in ABAP with implementation knowledge of Start Routine, End Routine, Using Enhancement Spot and BADI for BW Extractor enhancements and Customer Exit Variable Enhancements
• Extensive experience with multiple Industry models like Retail, Apparel, Consumer Goods & Services Industry clients and Resources Clients implementing End to End projects and Application Maintenance projects.
• Extensive experience in handling data extraction and integration to BW with POS (Point of Sale), SAS Plan, MDM, SD, SCM, APO, FI (AP, AR, G/L), SRM, CRM & HCM modules and non-SAP source systems.
• Experience in implementing the data models for Operational reporting for E2E reporting, POS Dashboards, FGI reporting, Shipment Delivery Analysis, Perfect Order Analysis, OCSL, Procurement, Cross Functional planning, Production Planning areas.
• Experience in implementing Analytical reporting models for Standard Profit Loss, Customer Profit Loss, COPA analyzer and Sales Analyzer tools.
• Strong experience in data staging from Cross-applications and Non-SAP systems into BI.
• Data flow modeling in BW on HANA using Composite Providers, Advanced DSO, InfoObjects, InfoCubes, APD, SPO s, VirtualCubes, Multi-providers, Open Hub Destination, Info sets, Aggregates, ODS/DSO objects, Data Marts, Transfer Structure, Transfer & Update Rules/Transformation rules and Data Sources.
• Extensively involved in data extraction of LO Cockpit, Generic, COPA, CRM, SRM, SNP and non-SAP data using DBCONNECT into SAP BW.
• Process Chain Design: Break loads (PSA, DSO, Cube) out into Local chains for better maintainability
• Performance Tuning with Aggregates, compression, Rollup, Partition, Reconstruction, OLAP Cache, Query Mode, Indices, Multi-Provider, Line Item Dimension, Query Monitor (RSRT), Indexes and Archiving. Experience in using BWA (BW Accelerator) Filling of BIA Indices, Roll up etc.
• Enterprise reporting with Business Objects Webi, BEx Query Designer, Analyzer, WAD and Dashboard Designer. Developed Complex BEx Queries using CKF, RKF, Variables, Structures, Filters, Free Characteristics, Conditions, Exceptions, and RRI.
• Exposure to IP and BPC modules and BODS.
• Strong experience in creation and execution of Test Scripts for all the cycles of testing. Extensive exposure to testing tools like HPQC and RQM and Defect tools like Clear Quest and ALMQC.
• Extensive experience in Business Objects creating Webi reports for Reconciling reports and Customer analytics reports
• Over 5 years of experience in BW-ABAP for consolidating multiple Business process data and for data conversions in BW.
• Expertise in analyzing, architecting, designing and modeling data for various industries like AFS, Products, Alcoholic Beverages, Resources.
• Experience with Business Objects tools like WEBI, OLAP. Hands on knowledge with SAP Lumira.
• Experience in interacting with Business users in analyzing the Business process requirements and

TECHNICAL SKILLS:

Data Warehouse: SAP BW 3.5/7.0/7.3/7.4/7.5, SAP HANA

Reporting Tools: Tableau, Analysis Office, BEx, WEBI, OLAP, SAP Lumira, Portal

Databases: HANA, Oracle, DB2.

Languages: SAP ABAP, SQL.

Operating Systems: Windows NT/2000/XP

ERP Systems: SAP R/3, SAP ECC 6.0

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Senior SAP BW HANA Consultant

Responsibilities:

• F acilitate requirements gathering and reconciliation of data definitions with business and IT experts for MP&IM Reporting
• Worked on creating HANA calculation views and LSA++ data models for transforming POS transactional data and SAS Planning data available for reporting.
• Created Operational reports using Analysis Office for reporting and Tableau for creating Dashboards
• Created multiple key metrics for Inventory Average, Sell-Out Units, Dollars at different granularity
• Involved in BW7.5 on HANA modelling of Mixed scenarios including creation of ADSOs and Composite Providers on top of generated HANA views. (For BW info providers)
• Hands on experience in using SAP BODS (Business Objects Data Services) to extract structured/unstructured data from different source systems into HANA
• Working experience on HANA Application Lifecycle Manager to transport Code
• Leading Onshore and Offshore teams
• Test final output based on requirements and business needs.

Confidential, San Francisco, CA

Senior SAP BW HANA Consultant

Responsibilities:

• Analysis, Design and Implementation of End-to-End data modeling for FGI Agility project
• Worked on HANA SPS12 creating calculation views for reporting of MDM data in the reports. Worked on extraction of DP and SP data from APO to BW7.5 further created reporting data model in HANA.
• Created Operational reports using Analysis Office for reporting FGI SP Summary, Ship Risk Service line, DC Operations, E&O Summary, Demand Waterfall, Supply Waterfall.
• Created multiple key metrics for FGI Agility reporting like Forecast, WFC Actuals, Current Inventory, MFC Actual, and Beginning Inventory.
• Created Interface and regional Interfaces in HANA that generates data for reporting to use in the Composite provider.
• Worked on creating HANA Calculation Views and Dimension Views using Star joins. Used Input Parameters for improving performance of the extraction and create Calculated Columns for the metrics.

Senior SAP BW HANA Consultant

Responsibilities:

• Analysis, Design and Implementation of End-to-End data modeling for Tableau Data extract for building Global POS (Point of Sale) Dashboards using Tableau reporting Tool.
• Worked on HANA SPS12 creating calculation views for extracting data from HANA to Tableau. Worked on refreshing Tableau data extracts from HANA in Tableau 9.2 version.
• Created Workbooks on Tableau Data extract for reconciliation of Point of Sale data in HANA
• Created multiple KPI’s for dashboard reporting which are derived for multiple time buckets like YTD, MTD, LW, 8WK(Rolling 8 Weeks), and STD(Season to Date).
• Created Interface and regional Interfaces in HANA that generates data to Tableau.
• Worked on creating HANA Calculation Views and Dimension Views using Star joins. Used Input Parameters for improving performance of the extraction and create Calculated Columns for the metrics.

Confidential, San Francisco, CA

Senior SAP BW HANA Consultant

Responsibilities:

• Analysis, Design and Implementation of End-to-End data model and reporting for Forecast Accuracy Operational reports as part of Confidential program
• Created multiple data modeling and reporting objects involve Composite providers, DSO, HANA Calculation Views, BEx reports with complex time structures.
• Created multiple KPI’s for reporting to show Forecast Accuracy percentage by period and by different level of Product Dimension aggregation.
• Created Operation reports showing Global KPI’s for Shipments from SAP, Point-Of-Sale from Legacy System and Plan data from SaS Planning Application.
• Worked on creating HANA Calculation Views and Dimension Views using Star joins. Used Input Parameters for improving performance of the reports and create Calculated Columns for the metrics.
• Extracted Sales Units data from Point of Sale, Shipments from OTC functional areas from different source systems, cleansed, converted and loaded the data into BW system.

Confidential, San Francisco, CA

Senior SAP BW HANA Consultant

Responsibilities:

• Analysis, Design and Implementation of the BW Data Models on HANA involving End-to-End data modeling and reporting for the Global BI reporting program to the client.
• Created multiple data modeling and reporting objects involve Composite providers, DSO, HANA Calculation Views, BEx reports with complex time structures.
• Created multiple KPI’s for reporting to show Actual data and Plan data from Point of Sale, Inventory and OTC functional areas which also involves to show the reporting in different time buckets..
• Created reports based on the snapshot data aggregating Actuals and Plan for different planning seasons.
• Involved in Execution of test cases and fixing the defects raised during the SIT and performance testing for different Organizational region data.
• Involved in Report building practice sessions on Webi and Tableau with Business users.
• Activation of BW Content (v.7.4), customizing BW solutions on HANA, creation of HANA Views, data flow, enhancing transactional and master data standard extractors, construction of different types of Infoproviders, universes, Query development in SAP BEx and SAP BO WEBI, performance tests, data-load process chains, incidences attendance and elaboration of functional and technical documentation, etc.
• Worked on creating Attribute Views, Analytical views and Calculation Views. Developed HANA Views and Composite providers within BW reporting and BOBJ reporting
• Worked on creating Data models optimized for LSA++ Architecture and HANA enabled Data models.
• Creation and Execution of test scripts using ALMQC tool for Functional Unit Testing, Performance Integration testing, Regression testing cycles in all the release of Project life Cycle.
• Worked on raising defects using ALMQC and driving the functional team testers for closure of defects provided the solution.
• Involved in End to End development of Product Master from MDM, Customer Master from MDM, Date master data dimensional views.
• Extracted data related Point of Sale, Inventory and OTC functional areas from different source systems, cleansed, converted and loaded the data into BW system.

Confidential, San Francisco, CA

Senior SAP BW HANA Consultant

Responsibilities:

• Analysis, design and implementation of the HANA Models which are Interfaces to provide the actuals data from multiple functional areas to SAS for E2E Planning.
• Involved in SAP HANA Sidecar implementation on BW Landscape to integrate with SAS Planning System to provide the Historical data for different functional modules for OTC, POS, and Inventory for Planning.
• Created multiple Graphical HANA Views involving star joins, Input Parameters, Calculated Columns, and Joins to derive time buckets.
• Created HANA Models to extract data for Point of Sale, Inventory, Shipments, Adjusted Demand from SAP ECC, and Legacy applications.
• Created Calculation Views with Star joins, calculated columns with currency conversion, Filters and Time variables/parameters.
• Created Graphical HANA interfaces to provide Actuals for Shipments, Open Orders, and Size Optimization data to upstream Enterprise applications through BODS for SAS Planning.
• Involved in Execution of test cases and fixing the defects raised during the SIT and performance testing for different Organizational regions.

Confidential

Senior SAP BW HANA Consultant

Responsibilities:

• Analysis, design and implementation of the BW models and Operation reporting based on OTC, MTD, STP, FTS and CRM Service process integration.
• Activation of BW Content (v.7.4), customizing BW solutions on HANA, creation of HANA Views, data flow, enhancing transactional and master data standard extractors, construction of different types of Infoproviders, universes, Query development in SAP BEx and SAP BO WEBI, performance tests, data-load process chains, incidences attendance and elaboration of functional and technical documentation, etc.
• Creation and Execution of test scripts using ALMQC tool for Functional Unit Testing, Performance Integration testing, Regression testing cycles in all the release of Project life Cycle.
• Worked on raising defects using ALMQC and driving the functional team testers for closure of defects provided the solution.
• Worked on creating Data models optimized for LSA++ Architecture and HANA enabled Data models.
• Delivered Operational reports and Analytical reporting for Sales Cycle Pipeline, Sales Overview, Returns and Credits, Credit Note, Manual Pricing, Shipped Not Billed, Cross Functional SD report in OTC Process area.
• Worked on CRM integration with BW for Service and Complaint operational reporting.
• Worked on reports that will allow the STP team to identify by product category, Supplier and Branches, the amount invoiced on non-catalogues items.
• Worked with Security team to define Roles/Authorizations for BW Reporting users
• Implemented BW APD for deriving On-time In full Indicators and Volumes in Sales and Distribution Process Area.
• Introduced Best Practice methods for Data modeling, LIS re-inits from ECC, usage of TVARVC variables etc.
• Created reports which compose Views of high-level summary by product category, then a detailed view by Branch/Supplier, a detailed view by Branch and a detailed view by Supplier.
• Involved in End to End development of Customer Master, Vendor Master, Material Master, Purchase Orders Source List, Sales Order and Vendor Contracts objects development.
• Extracted from different sources, cleansed, converted and loaded the data into BW system.

Confidential, Copenhagen, Denmark

SAP BW Process Lead

Responsibilities:

• Analysis, design and implementation of the BW model, based on SAP SD, MM, QM, PP.
• Creating all customizing BW solutions, configuration of SAP BW model, data flow, enhancing transactional and master data standard extractors, construction of different types of Infoproviders, Multiproviders, query development, reports (Bex, WEBI) performance tests, data-load process chains, incidences attendance and elaboration of functional and technical documentation, etc.
• Solution Responsible for SCM Area which covers Production Planning, Quality Management, Material Management, Cross Functional Planning (Demand Planning/SNP).
• Creation and Execution of test scripts using RQM tool for Functional Unit Testing, Performance Integration testing, Regression testing cycles in all the release of Project life Cycle.
• Creation and Execution of test scripts using ALMQC tool for Functional Unit Testing, Performance Integration testing, Regression testing cycles in all the release of Project life Cycle.
• Worked on raising defects using Clear Quest and driving the functional team testers for closure of defects provided the solution.
• Worked on LSA Architecture using SPO’s in all the data models for integrations of SCM Business processes.
• Implemented data models for Operational reporting for Shipment Delivery Analysis, Perfect Order Analysis, MTC/STC, P2P, Cross Functional planning, Production Planning areas.
• Preparing the Functional Specifications and Technical design documents defining BW structures.
• Designing, creating and modifying BW data Models and BI Reporting Models as per the technical design documents and Client naming standards.
• Understanding the Business functionality of Procurement, Planning & Scheduling (SCM), SD, and Finance to validate the business specific end user reports. Fixing GAPs and doing enhancements to BW Data models.
• Working on Application Maintenance Incidents. Performing Weekly data loads and Monthly Adhoc Loads to multiple Businesses.
• Working with Service Now supporting tool to prepare the Trending of Incidents in Support Environment.
• Worked on Integrated planning in designing and development of planning reports - Number of SKU’s hitting Forecast Accuracy Targets, and Commercial Planning for Customer/Brand Profit & loss containing Volume planning from APO.
• Worked on creating Planning IP cubes, Planning IP Filters, IP functions and Aggregation levels to achieve the reporting requirements.
• Worked on Integration of Inventory Management, Production Planning, QM, APO processes into BW.
• Implemented Inventory Management flow for Operational reporting on Days Sales Inventory, Inventory Volumes Analysis on Weekly and Monthly basis.

Confidential

Senior SAP BI/BW Consultant

Responsibilities:

• Analysis, design and implementation of the BW model, based on SD, Procurement, CRM, Transportation, Planning & Scheduling consulting with business units to understand their needs, enhancing BW solutions
• Worked on Functional designs by interacting with the Client and collecting the requirements and report functionalities.
• Preparing the technical design documents from understanding the Business process and the Functional Design.
• Worked on activation of Standard BI Content data flows and custom data models for Master and Transactional data extraction.
• Creating the objects as per the technical design documents and client naming standards.
• Involving in the peer review process for Development, Technical documents and the Unite testing
• Understanding the Business functionality of OTC, CRM, Procurement, Planning & Scheduling (SCM), Finance to validate the business specific end user reports
• Resolving the defects that were raised during the Performance Integration testing. Preparing the unit test documents.

Confidential

SAP BW Developer

Responsibilities:

• Analysis and implementation of the BW model, based on Sales to Cash, Requisition to Pay, Manufacturing, Quality Management, Finance and Business Planning consulting with business units to understand their needs, enhancing BW solutions.
• Worked on Functional designs by interacting with the Client and collecting the requirements and report functionalities.
• Preparing the technical design documents from understanding the Business process and the Functional Design.
• Attending the daily calls with onsite team and discussion on the open items.
• Preparing the document for the objects which may get impacted.
• Development of the objects as per the client standards defined in the detailed design documents.
• Performing testing of the development.
• Maintaining the daily issue logs and working on the different open items.
• Preparing the detail plan for the data load during BIT and USAT phase.
• Preparing the scenario test scripts and conducting the workshops to the testers during BIT phase.
• Resolving the issues encountered during BIT phase and implementing the GAPS found during BIT and USAT.
• Worked on Application data integration in Sales, Purchasing, Inventory, Manufacturing and Planning data

Confidential

Responsibilities:

• Analysis and implementation of the BW model, based on Demand Planning and Supply Network Planning and PP consulting with business units to understand their needs, enhancing BW solutions.
• Worked on Functional designs by interacting with the Client and collecting the requirements and report functionalities.
• Preparing the technical design documents from understanding the Business process and the Functional Design.
• Attending the daily calls with onsite team and discussion on the open items.
• Preparing the document for the objects which may get impacted.
• Development of the objects as per the client standards defined in the detailed design documents.
• Performing testing of the development.
• Maintaining the daily issue logs and working on the different open items.
• Preparing the detail plan for the data load during BIT and USAT phase.
• Preparing the scenario test scripts and conducting the workshops to the testers during BIT phase.
• Resolving the issues encountered during BIT phase and implementing the GAPS found during BIT and USAT.
• Worked on Application data integration in Sales, Purchasing, Inventory, Manufacturing and Planning data

Confidential

SAP ABAP Developer

Responsibilities:

• Worked on Reports both Classical and Interactive and on ALV Repots also.
• Worked on Data conversion programs.
• Modified the layout set and developed print program for smartforms as per the client requirements.
• Development of high performance objects which are optimized for handling high volumes of data.
• Interacting with onsite coordinator/client to discuss the Technical/Status Review of project work and for any work related issues clarifications.
• Done the Code review and Unit Testing of the objects.
• Good Conceptual Knowledge and hands on experience on ALE/IDoc’s, BAPI and BADI's and LSMW.