SAP Data Migration Lead Consultant

1/2023 – offen

Responsible for understanding business requirements, analyzing data, and providing insights.
Designs, develops and maintains data pipelines for extracting, transforming, and loading (ETL) data. Integrated HANA Cloud with other systems, applications, and data sources to enable seamless data flows and interoperability. Implemented automation, continuous integration/continuous deployment (CI/CD) pipelines using BAS, BitBucket and Jenkins. Created Stories and Dashboards using SAC and enabled CAPM functionalities in SAC for user functionalities

SAP Analytics Cloud, SAP Cloud Platform, SAP Datenmigration, SAP DS (BODS), SAP HANA

4/2019 – 2/2022

 Worked extensively on HANA modeling and responsible for HANA development deliverables in time, Cutover Activities.
 Extensively worked on Calculation Views, Analytical Views, Attribute Views, Star Join CV's, Hierarchies by using Calculation Views, Delivery Units, Import, Export, Filters, Variables, If Else Calculated Formulas, Calculation Attributes/Measures for Inventory Extensively worked on Transposes like Row to Columns, done Currency conversions using Calculation Attributes/Measures & Restricted Calculations.
 Dynamic data selections by using input parameters like Direct, Column, Static, Derived from Table.
 Used Calculation Views for data display as Header and Item Data format.
 Creation of Hierarchies in the SAP HANA Graphical, Cube and Time-based Calculation Views.
 Consuming these views in SAP Analytics Cloud and building stories on top of these views via live connection.
 Creation of Models in SAP Analytics cloud and Creating Responsive stories, Canvas Stories, Grid based tables and Planning Models.
 Worked on reading the BW models into HANA and creating the HANA view to achieve the complex reporting requirement.
 Lead offshore resource for on time delivery of MOCK, Cutover & Go-live.
 Generate weekly status report for design, build, load & load reconciliation which helped leadership for decision making.
 Installed & configured BODS XI 4.0 SP1 in Development & Production Server.
 Used Open Hub Services to push data out of SAP BI using BODS.
 Moved the projects from DEV to ST, ST to UAT and UAT to Production.
 Designed and developed ETL routines in BODS, modified or created new Data Services jobs to meet project requirements.
 Load into SAP HANA using SLT replication methodology.
 Allocating the tasks for the day to the respective team Members.
 Deploy MTAR using Hana XS Advance and activate the concerned ODATA Services.
 Analyzed and debug the ABAP CDS View which were consumed by the Query Browser of SAP Fiori.
 Giving the effort estimate to the customer based on the defects raised.
 Closing the Defects on the given timelines and escalate if there is any slippage.
 Sending the Summary of tasks to the customer for that sprint on daily basis.

SAP BusinessObjects (BO), SAP S/4HANA, SAP Analytics Cloud, SAP HANA