SUMMARY:

• Having around 10 years of experience as SAP BW HANA Consultant with strong expertise in SAPHANA, Native HANA, BW 7.4/7.3/3.5, Bex, Business Objects, Integrated Planning and SAP ABAP(BI Enhancements) .
• Extensively involved in Business Blueprint/Requirements gathering, Gap analysis, Project Scoping, Sizing, PreparingFunctional and Technical Specifications,Functional Design and Modeling, Functional Unit Testing, Performance Testing, Integration testing, Regression testing cycles and End User Training and Documentation.
• Strong experience in Reporting and Analytical tools and extensively involved in report building practice with users on Analysis Office and WEBI.
• Strong experience in building solution using Modelling tools SAP HANA, Native HANA and BW,creating HANA models using Graphical views and implementing different time structures required for reporting and creating interfaces to integrate with upstream applications.
• Working experience on Demand signal repository for POS operations and analyzing the business growth.
• 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 3.5/7.3/7.4) 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.
• Good knowledge on sales growth on Demand signal repository as live database for sales.
• 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
• 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.3 and 7.4.
• 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 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 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 Shipment Delivery Analysis, Perfect Order Analysis, OCSL, Procurement, Cross Functional planning, Production Planning areas.
• 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.
• Extensive experience in Business Objects creating Webi reports for Reconciling reports and Customer analytics reports
• 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 transforming them into documenting, designing, and rolling out the deliverables.

TECHNICAL SKILLS:

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

Reporting Tools: BEx, WEBI, OLAP, SAP Lumira, Portal

Databases: HANA, Oracle, DB2.

Languages: SAPABAP, SQL.

Operating Systems: Windows NT/2000/XP

ERP Systems: SAP R/3, SAP ECC 6.0

PROFESSIONAL EXPERIENCE:

Confidential, Harrisburg, PA

Sr SAP BI Technical Consultant

Responsibilities:

• Analysis, Design and Implementation of End-to-End data model and reporting for Forecast Accuracy Operational reports as part of E2E Global Reporting 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, Long Island, NY

SAP BW HANA Consultant

Responsibilities:

• Analysis, Design and Implementation of the BW Data Models on HANAinvolving End-to-End data modeling and reportingfor 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, King Of Purssia, PA

SAPBW Process Lead for SCM

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, Lyndhurst, NJ

SAPBW Process Lead OTC PTP

Responsibilities:

• Involved in GAP analysis based on local requirements, enhancing transactional and master data standard extractors, construction of different types of Multiproviders, query development, 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).
• Implemented data models for Operational reporting for Shipment Delivery Analysis, Perfect Order Analysis, OCSL, 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.
• 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.
• 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.
• 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, Battle creek, MI

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, Chicago, IL

SAP BW Developer

Responsibilities:

• Analysisand implementation of the BW model, based on 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, West Chester, PA

SAP BW Developer

Responsibilities:

• Analysisand implementation of the BW model, based onDemand 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