System architecture & Integration
Data Migration planning & executions
Master Data Management - Customers/Vendors
Master Data Quality Management
Data Analytics: Tableau, Power BI, Excel
ERP: SAP ECC, S/4HANA, JDE E1, Fusion
Database: SAP HANA, SQL Server, Oracle
ETL: SAP Data Services (BODS), SDI, SLT
Programming: Python, PL/SQL
Modern Technologies: Kafka, Microsoft Azure
Maersk (Dec 2021 – Till now)
Project: NFTP Data Migration (Ocean & LnS releases), Master Data Quality & Stabilization, Process Improvements
Technologies: BODS, HANA, Power BI, Python, ECC, S4/HANA, MDG, CMD, MDM
NFTP Data Migration (Ocean & LnS) project is a large scale, multiyear project with commitment of migrating Master & Transactional Data from ECC & Non ECC system to S/4 HANA (including S/4 MDG) financial chassis. Migrating 100M+ data volume across PTP, ATR and OTC objects required robust understanding of data migration process and ETL solution with optimum performance to meet the business timelines.
Master Data Quality & Stabilization revolves around building framework to make sure master data is available and consistent in all the consuming application with minimum latency. Customer and Vendor data was harmonized together to unify the data across organization.
My role involved in architecting the data migration framework, work with business/tech team to understand System topology and process improvements, prepare data migration plan, measure and improve master data quality, ETL design, handling large volume of data, Reconciliation and Reporting.
MDSap TECH (March 2021 – Nov 2021)
Project: Etisalat - Native HANA migration
Technologies: HANA, SDI, SQL and PL/SQL
As part of this project, we implemented a large scale out (50TB, 9 nodes) HANA system and migrated over 120 TB of compressed data from Netezza to HANA for daily, weekly and monthly reporting.
My role is the project was to architect the data storage strategies to reduce data footprints yet not compromising on reporting performance. We managed to achieve by implementing data tiering (Hot, Warm and Cold) using NSE, Effective partitioning, Optimizing SQL queries, Implementing right access control and Data security.
MDSap TECH (March 2021 – Nov 2021)
Project: National Health Observatory (NHO)
Tools: HANA, SDI, BODS
NHO project aims to build a central data warehouse system in HANA and integrate medical domain data from all the hospitals in KSA region. These data will be useful to measure and analyze patient’s movement (inflow and outflow), bed availabilities and other KPI to provide better medical services across KSA region. This project is a part of VISION 2030.
My role was to build end to end data warehouse and reporting solutions in HANA and Power BI to track the real time hospital and service availability.
MAXIM INTEGRATED INDIA CIRCUIT DESIGN PVT. LTD (2015-2021)
Projects: GES – Data migration, PDM, SCM Rollout, Price Forecasting tool
Technologies: HANA, SLT
I have been part of various projects during my tenure at Maxim Integrated. It includes GES (legacy to SAP data migration and reporting), EDW (Enterprise Data Warehousing), PDM (Part Data Management), SCM Rollout and Price forecasting tool.
My role involved managing end to end Data for data migration for material, Bill of materials. Managing the EDW Data integrations, tracking the data quality of materials, BOM and others related data as part of PDM. Role also comprises of building data foundation layer to support SCM (JDA) forecasting.
As part of Pricer tool, I had architected and built a python framework for data ingestion for Machine learning Forecasting algorithm to synchronize the entire process from data extraction, upload the data to blob, Trigger the ML end point, Download the blob, Upload the data back to EDW and Send the file to Pricer Tool.