SUMMARY: * Having around 10 years of experience as SAP BI/BW HANA Consultant with strong expertise in SAP Native HANA, SAP S/4 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, 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. * 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 Modeling tools SAP 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, info providers 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, Logistics, SCM, APO, FI (AP, AR, G/L), SRM, TM, 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, Virtual Cubes, 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, FI - CO, FI-TM, 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.
Description
