Client : Ecolab, Saint Paul, MN ( March 2020 to Till Date)Role : Senior Lead SAP BW / BODS ConsultantEnvironment: BW 7.4 on Hana/ Oracle(SP5), ECC on Hana, BO Data Services 4.2Client : McKesson, Dallas, TX ( Oct 2019 to March 2020)Role : Senior SAP BW ConsultantEnvironment: BW 7.4 on Oracle(SP5), ECC 6.0Client : Tetra Pak, Dallas, TX ( May 2019 to Till Date)Role : Senior BW/ BO/ Hana ConsultantEnvironment: BW 7.5 on HANA(SP5), ECC 6.0, SCM, GRC, Business Objects(Webi, Lumira)Client : Chicos FAS, Fort Myers, FL (Jun 2018 – Apr 2019 ) Role: Senior SAP BW / HANA ConsultantEnvironment: SAP BW 7.4 on Hana , SAP ECC, POSDM, Sybase IQ NLS , HANA 1.0 SPS9 Client : Harman Kardon, Remote (Mar 2018 to Jun 2018)Role: SAP BW Lead ConsultantEnvironment: SAP BW 7.4 on Hana , SAP ECCClient : Tetra Pak, Dallas, TX ( Sep 2017 to March 2018)Role : Senior BW/ BO/ Hana ConsultantEnvironment: BW 7.5 on HANA(SP5), ECC 6.0, SCM, GRC, Business Objects(Webi, Design Studio)Client : Medtronic, Minneapolis, MN ( Mar 2016 to Aug 2017)Role: Data Architect( SAP BW on Hana)Environment: BW 7.4 on HANA, ECC 6.0, APOClient : Chicos FAS, Fort Myers, FL (Feb 2014 – Feb 2016 ) Role: Senior SAP BW BO Hana ConsultantEnvironment: SAP BW 7.3 on Hana , SAP ECC, POSDM, Sybase IQ NLS , HANA 1.0 SPS9 Client : Multnomah County, Portland, OR ( Apr 13 to Nov 2013 )Role: SAP BW Lead / ArchitectEnvironment: BW 7.01, ECC 6.0, SRM 7.0.

 Involved in designing, documenting and configuring the Information Model for the enhancements using environment SAP BW 7.4 on Hana 1.0 Design and development of SAP Hana Calculation Views and Hybrid data model. Working on reporting solutions for the Store Bonus Allocation report on BO Webi with Composite Provider and Advanced DSO / Open ODS views based on Hana Views using BW Modelling tools. Data Provisioning and replicating data from source system to HANA Database. Access the data from Non Sap systems using Smart Data Access. Creating Stored Procedures and Calculation Views using SQL Script. Analyzing Performance using Plan viz. Created ADSO with external HANA view setting and wrote complex calculations in Calculation view instead of writing in BW routines improving the performance. Created Open ODS views to access the data from source directly. Enhanced standard Data Sources Implemented LSA++ architecture using ADSOs, Open ODS Views and Composite Providers. Developing Web Intelligence Reports using SAP BO 4.1. Co-ordinate with client and handled project related issues

 Involved in designing, documenting and configuring the Information Model for the Pro-Simplification Project, consolidating the Two ECC source Systems into one and its impact to SAP BW systems. Realignment of data with the ECC source system consolidation, Changes to BW Transformations Routines and Report Modification.

 Involved in designing, documenting and configuring the Information Model for the Tetrapak enhancements using environment SAP BW 7.5 on Hana Design and development of SAP Hana Calculation Views. Worked on reporting solutions for the APO SNP Planning data contains Demand, safety stock, to bring it over to BW and report on BO Free Analysis with Composite Provider and Advanced DSO using BW Modelling tools. Worked on BO Design Studio creating Reports on Bex. Worked on reporting solution for the Opportunity Management Free Analysis report using UD Connection as Source system. Created Reports using Office for Analysis over Bex. Worked on Hana Composite Provider, Advanced DSO and Open ODSView , XXL Info Objects using BW Modelling tools. Involved in Preparing the Technical specifications as per the functional specifications. Involved in the review of technical designs, HANA Models built by the team members and providing the estimates for the models based on the complexity. Created Attribute View, Analytical view and Calculation views to achieve the OTC KPI’s. Involved in providing reusability suggestions for the HANA Models and have been the reviewer for the HANA KX documents submitted by the team members.  Worked on reporting solution FI Spend Analysis Report and PO Usage Invoice Items, Credit Limit Analysis Report(on FI_AR). Developed more than 6 HANA Complex Data Models (data from different source systems),2 scripted calculation views. Created attribute, analytic and calculation views for Sales and Procurement modules as part of the current POC.

 Gather and discuss Business requirements from the Users for APO Projects Involved in designing, documenting and configuring the Information Model for the Covidian Integration / Implementation(APO SNP Planning data) using environment SAP BW 7.4 on Hana Loading the APO MALA and MALO planning extractors data into BW and load it back to APO. Worked on Aggregated Planning with Aggregated Safety Stock, Distribution Receipt (Planned), Distribution Demand (Planned), Production (Planned) and Dependent Demand key figures. Hands on experience in creating Hana Information views modeling : Attribute, Analytical, Calculation Views Extensive knowledge on Composite Providers, Transient Providers, Advanced DSO’s, Open ODS View using BW Modeling Tools in Hana Studio. Designed new data flows to feed data to BW from non-sap and push to APO and back to non-sap using Open hubs. Development co-ordination with Offshore team. Created generic extractors with delta capability using tables, views and function modules. Extensively involved in setting up of procedures for extracting data from SAP ECC by using generic extraction, FICO and LO cockpit. Enhanced the Business Content standard extractors like 2LIS_02_HDR, 2LIS_02_ITM and 0FI_GL_4, 0FI_AR_4 as per the design requirements. Involved in Design and development co-ordination for the Service & Repairs Reporting for Medtronic. Designed and developed the APO Demand Planning data validation report for Management.

 Migration and remodel implementation of BW on Hana for 4 major brands of Chico’s. Worked on Hana modeling to create application for the POSDM downstream reporting using analytical / calculated views in Enterprise Hana.  implemented Near-Line Storage archiving solution to archive the data from BW on Hana to Near-Line Store using Sybase IQ.  Designed and implemented the information model for POSDM, AFS Retail and Inventory Management and Non SAP Sources on SAP Cloud(HEC) environment. Involved in in pre and post HANA migration activities for BW 7.3 on Hana. Pre migration activity including housekeeping tasks and post migration issues fixes. Worked on Enterprise Hana to create Hana Analytical Views, Calculated Views and publish them to BW to utilize the Hana Models. Successfully implemented Sybase IQ Near-Line Storage to archived BW on Hana data into Near-Line Storage. Extensively worked in Semantic Partitioned Objects and Query Performance on Hana. Designed and Developed Reporting on Hana Analytical Views / Calculation Views and publish them in BW with Virtual Provider. Extensively involved in gathering the reporting requirements from the business users by meetings. Extensively involved in creating the detailed reporting requirements documents for each reporting area and for the cross functional reporting. Involved in a detailed gap analysis between the SAP Standard Business Content and Reporting Requirements. Involved in creating a technical design document for each of the reporting areas. Designed and implemented a highly complex information model using Semantic Partitioned Objects on DSO’s, SPO’s on Cubes. Extensively worked on Inventory Management(Loading BX, BF and UM) and Inventory snapshot management, Extensively worked / Implemented on POSDM Data Flow BW on Hana for different Units. Created Web Intelligence(Webi) Reports based on Bex Reports using Universe(BO 3.1) with BW 7.01 as source

 Designed and implemented the information model for Finance, Material Management, Supplier Relationship Management and Human Resource. Extensively involved in gathering the reporting requirements from the business users by conducting workshops and meetings. Involved in a detailed gap analysis between the SAP Standard Business Content and Reporting Requirements. Extensively worked on installing business content extractors from Finance, SRM, HCM areas and enhance the same to suite the requirements of business. Extensively involved in training of the end users and creating training documentation. Developed highly formatted Special Ledger, SRM Workflow, Contracts, Procurement and FI based Spend Analysis Reports, Equipment and Maintenance Report, Employee Time Details Report (CATSDB) based on Bex Queries using formatting options like charts, alerts. Extensively worked on Start routine, Transformation routines and End routine. Extracted the legacy historical data from MSSQL using DB connect for cross system reporting. Extensively worked on sending BW data to MSSQL Analytics via open hub. Extensively worked on identifying and activating the standard business content extractors, cubes , DSOs and reports in the modules of SD, MM and FICO Created generic extractors with delta capability using tables, views and function modules. Extensively involved in setting up of procedures for extracting data from SAP ECC by using generic extraction, FICO and LO cockpit. Enhanced the Business Content standard extractors like 2LIS_02_HDR, 2LIS_02_ITM and 0FI_GL_4, 3FI_SL_ZZ_TT(generated special purpose ledger) as per the design requirements. Extensively worked on activating the business content objects in the modules of SRM, Finance, and Human Capital Management. Developed Balance Sheet Report with drill down for GL account , fund , grant, fiscal year, fiscal period, cost center document no and internal order.

Client : Medtronic, Minneapolis, MN (Apr 09 to Apr 13 )Role: SAP BW/ Hana/BO Onsite Lead Environment: BW 7.01, BW 7.3 on HANA, ECC 6.0, Business Objects 4.0, BO Data Services.Worked on SAP BW 7.3 on Hana (Implimentation) Managed Onsite and Offshore Teams (development and support) and acted as SPOC for all communication between client and IBM onsite offshore team. Involved in designing, documenting and configuring the Information Model for the Global Sales Reporting using environment SAP BW 7.3 on Hana and Business Object 4.0. Designed and implemented the information model for Finance, Supplier Relationship Management and Customer Relationship Management, Sales, Inventory, Material Management, Supply Chain Management, Production etc. Involved in in pre and post HANA migration activities for BW 7.3 on Hana, pre migration activity including housekeeping tasks, and post migration check list. Extensively worked on creating the Web Templates as per the requirements Extensively worked on extracting data using DB connect and Flat files. Extensively worked on migration of Queries, work books, web templates and Query variants from 7.01 to 7.3 Extensively worked on the start / end routines and the routines in the transformations. Created generic extractors using function modules and tables for reporting on the custom build contract application in ECC. Extensively worked on installing business content extractors in all areas and enhance the same to suite the requirements of business. Developed APO Pipeline Snapshot Report, Inventory Summary/Details Report, Cycle Count Details Report, Sales Actual vs Plan, Sales trends report, Shopping Cart details report, Number of Events and Complaints Report etc. Involved in design and development of backend objects like DSO, Info cube, Info objects, Info set, Multiproviders, APDs, Hana-Optimized Cubes, Hana-optimized DSOs, Semantic Partition Objects (SPO), dataflow templates, and Composite provider.

Client : Avaya, New Jersey (Jan 05 to Apr 09)Role: Sr. SAP BW Developer/ Global Team LeadEnvironment: SAP BW 3.0b, SAP R/3 4.6/3.1  Managed offshore team (development and support) and acted as SPOC all the communications / interactions with users and onsite. Worked in architecture team to design the new requirement. Involved in cutover plan preparation for all go-lives. Worked extensively on performance tuning on existing process chains, set up the dependencies, master data and hierarchies. Worked on different areas SD, MM, and APO. Worked on GLPCA (profit/loss) reports, Inventory summary reports, Sales performance reports, Sales Actual-To-Date Report. Worked in both support and development areas. Responsible for SR count, SLA and development deliveries. Worked on long pending issues and proposes quick workaround. Worked on aggregates, compression, PSA deletions. Set standards, review check list for BW development and ABAP development related to BW. Work on Bex Queries, virtual characteristics, cell definitions, workbooks, user profiles and role assignment. Worked on SAP R/3 upgrade project in lie BW testing.

Worked @IBM for Client Avaya Managed offshore team (development and support) and acted as SPOC all the communications / interactions with users and onsite. Worked in architecture team to design the new requirement. Involved in cutover plan preparation for all go-lives. Worked extensively on performance tuning on existing process chains, set up the dependencies, master data and hierarchies. Worked on different areas SD, MM, and APO. Worked on GLPCA (profit/loss) reports, Inventory summary reports, Sales performance reports, Sales Actual-To-Date Report. Worked in both support and development areas. Responsible for SR count, SLA and development deliveries. Worked on long pending issues and proposes quick workaround. Worked on aggregates, compression, PSA deletions. Set standards, review check list for BW development and ABAP development related to BW. Work on Bex Queries, virtual characteristics, cell definitions, workbooks, user profiles and role assignment. Worked on SAP R/3 upgrade project in lie BW testing.