•Provided Initial Impact Assessments and Efforts Estimations for Change Request/Projects proposed by Client.

•Understand the requirement from Client and translating those in form of Solution Design Document/Technical Design Document.

•Work on Build, Unit Test ,Regression Test and Support UAT/SIT Phase.

•Extensively worked on Enhancement of BW Data models in Finance, Procurement and HR Data Flows and solving reconciliation issues between ECC and BW.

•Extensively worked on CDS (S4 HANA Analytics) views (Basic, Composite and Consumption Views) for Finance, Procurement and HR modules.

•Creating Extended Views to Enhance existing Reports built on CDS views.

•Supported Technical Team in S4 HANA Upgrade for any issues related to CDS Views.

•BOBJ Support for End Users and performing Functional Test during BOBJ Upgrade.

•Worked on Open ODS View, Composite Provider and ODP Extractors.

•Designed Service Level Catalogue for BW/Analytics Team which was well received by Client and Project.

•Created Aggregation Level , Planning Function and Planning Sequence and resolved issues related to Planning module.

Worked on Change Request /Enhancement as per user requirement. Understand the requirement and translating those in form of Solution Design Document. Enhancement of Data Source using BADI. Developed ABAP Routines (Start/End Routine) in the Transformations as per business logic. Work on Build, Unit Test, Design Test Scripts and Support UAT. Extensively worked on Enhancement of BW Data models in Finance, Procurement and HR Data Flows and solving reconciliation issues between ECC and BW. Handling Incidents and managing the ticket flows within Team. Open OSS with SAP in case of any Product Issues on SAP BW and Reporting Tools (SAP BOBJ) Process Chain Development maintenance and Automation of Monitoring Process Implemented and Supported CDS Views for one of Client in Support Project. Created Extended Views to Enhance existing Reports built on CDS views. Troubleshooting Reconciliation issues between CDS Views and base tables on S4 HANA. Troubleshooting CDS views related errors during system upgradation. Support Basis Team during Quaterly-Half Yearly System Maintence task. Worked on Open ODS View, Composite Provider and ODP Extractors. Designed Service Level Catalogue for BW/Analytics Team which was well received by Client and Project. Created Aggregation Level, Planning Function and Planning Sequence and resolved issues related to Planning module.

Project had Interface with Non- SAP Application, development of Transactional and Master data flows and Bex Reports. Worked on Data Model Design and Development of complex KPIs in Bex Query Designer. Co-ordination with Off Shore Testing team, tracking defects raised and ensured that defects got resolved within estimated ETA. Daily Meeting with Business to understand gaps in KPI reports and worked to close the same. (E.g. Aggregation, Result Rows or Data Display/ Data Issue). Follow-up meeting with Business for BIT Sign-Off. Identifying and collection objects which would be part of Go-live Scope. Technical validation of BW objects in Production. Executing Data load activities as per Data Load Plan by coordinating with Service Team.

Extensively Worked on Bex Queries using Hana Studio, Build Meta Query consisting of approximately 50 KPIs having complex business logic. Reconciliation of Meta Query with Existing Reports. UAT Support and Fixing Defects (High Priority). Worked on Process Chain Optimization, Identifying the dependencies within the data flows and sequencing them accordingly to reduce data inconsistency incidents. Standard Data Source Enhancement in ECC, Replicating Data Source in BW and using the newly added fields in Bex Queries. Preparing Cut-Over and Data Load plan to Deploy the Changes. Post Go Live Support.

Worked Extensively on Advanced Data Store Objects and Composite Providers. LO Extraction, Deletion and Filling Setup Tables for Logistics flow. Order-to-Cash (OTC), COPA, FI-GL, Demand Plan, Sales Plan flows migrated to BW 7.5 on HANA as per LSA++ Architecture. (Green Field Re-Implentation) Co-ordination with Business Users, tracking defects raised and ensured that defects got resolved within estimated ETA Co-ordination with On Shore Deployment lead on Release planned as per the Project Timelines, was part of four major releases done during period Nov17 – Mar18. As part of Release management, below are few KPI - Preparing Data load plan and its dependencies on existing data model. Identifying and collection objects which would be part of Go-live Scope as the development was done in Sprints. Identifying the dependencies within the Sprints. Co-ordination with Service Team on QA checks. Follow up with Service Team on Sign Off required in various stages of Transport movement. Execution and Preparation of Cutover and Data load plan. Technical Validation of BW objects in Production. Executing Data load activities as per Data load plan. Post Go-Live Support.

Since Management decided to go for SAP HANA BW , old data from SAP BW on oracle database was required to be migrated from old BW system to SAP HANA BW and there after move data to Sybase Database (Archived Data) Listing the cubes module wise which should be archived on priority. Development of function module to extract data from MultiProvider. Creation of Extract Structures, Data Sources, Transformation to Load Data. Creation of DAP (Data Archiving Process) to move data from HANA BW to Sybase Database. Creation of Export Data Sources to move Master Data from old BW to HANA BW.

Data Loading - Involved in Data loads scheduling and Troubleshooting. Preparing Data load re- scheduling plan whenever ECC system outages were planned and executing the same. Proactively participated in the Monitoring and Support task, Extensively worked on load monitoring using RSPC, RSMO, SM37,SM50 and /SSA/BWT Reports. Ensured Data load are completed within Agreed SLAs and Accurate for Reporting. Performance Tuning which includes Indexes, Data Target administration Jobs like Rollup of Aggregates, Compression of Info Cubes, Change log Deletion and PSA Cleanup. Problem Resolving related to data loading and Query Performance. Transport Management/Change Management – Collecting and movement of BW Objects from Development, Quality and Production System using SE09, SE01, SE03 and STMS. Bex Queries and Workbook collection and movement from Dev to Production system. Transport Management (Solution Manager) – CHARM Process

•Worked on Migration of BW 7.x flows to BW 7.5 on HANA (Green Field Approach)

•LO Extraction, Deletion and Filling Setup Tables for Logistics flow.

•Created Advanced DSO, Composite Provider, Info objects, Info sources and datasources in HANA Studio Eclipse.

•Created query on Composite provider , Restricted and Calculated Key Figures, Customer Exit Variables in Eclipse. Implemented Start Routine, End Routine and Field Routine and enhancement of Data Source using BADI.

•Preparing and Execution of Cutover plan. Executing Data load activities as per Data load plan and Post Go-Live Support.

•Project had Interface with Non- SAP Application ,4 Transactional, 5 Master data flows and 5 KPI Reports.

•Worked on Data Model Design and Development of complex KPI’s in Bex Designer.

•Worked on Installation of Technical content in SAP BI 7.0 and Developed Performance statistics Report for BI Production server.

•Analyzed Business Requirement and developed BI Data load Reporting Dashboard , views created based on standard SAP Data load request tables.

•Near Line Storage – Data Archiving of Legacy BW Prod Server.

•Coordination with basis team to resolve issues that arise during data loads, This could include analysis of short dumps, inactive Transformation rules, IDOC issues, table space issues, etc.

•Transport Management (Solution Manager) – CHARM Process.

Short Term On-Site Assignment in Germany on BW Performance KPI Implementation Project