Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

Sanjeev Kumar

Carmel,USA

Summary

  • Data & Analytics Architect with over 20 years of experience in data engineering, analytics, and enterprise architecture. I specialize in designing SAP/MS Azure/Databricks Data Analytics solutions and leading end-to-end project delivery. Expertise: SAP: SAP Business Data Cloud, SAP Datasphere, SAP Databricks, SAP Analytics Cloud, SAP Embedded Analytics (CDS Views), SAP ABAP, SAP BW
  • HANA, SAP BOBJ. Non-SAP: Azure Fabric, Lakehouse, Data Warehouse, Semantic Models, Power BI, Azure Databricks , Synapse, SQL, Python,PySpark, Medallion Architecture on Azure Cloud Platform, Azure Fabric Deployment.

Overview

20
20
years of professional experience
1
1
Certification

Work History

Data Architect

Jacklinks
Carmel, Indiana
09.2025 - Current
  • Analyzed Azure Fabric current environment and proposed Best Practices for Data governance and Security.
  • Designed the end-to-end architecture for Nielsen Point of Sales Data via Cloud-to-Cloud feed ingestion via Azure Data Share into Azure Platform ADLS Gen 2 Storage Container.
  • Used OneLake capabilities by creating Shortcuts from ADLS Gen 2 to Lakehouse for files and within Silver Layer for tables that did not need any transformations.
  • Configured the Fabric Data Pipelines to ingest the Nielsen data via Medallion Architecture – Bronze, Silver Gold layers.
  • Designed end-to-end architecture for Walmart Scintilla point of sales data from Walmart Data Ventures via Delta Share Protocol.
  • Configures Databricks environment with Unity Catalog to ingest Walmart Scintilla data (Azure Fabric does not support Delta Share Version 2 .share)
  • Mirrored and consumed Databricks Delta table into Azure Fabric for end-to-end orchestration of the Data Pipelines.
  • Configured end to end pipelines to ingest Scintilla data into Azure Fabric until Gold Layer.
  • Ingest Point of sales Data from Nielsen Cloud to Cloud Feed via Azure Data Share.
  • Jacklinks is an American snack company best known as the producer and marketer of the eponymous brand of beef jerky.
  • Technology: Azure Fabric, Workspaces, Lakehouse, Spark notebooks, Fabric Data Factory, Fabric Datawarehouse, Semantic Models, Power BI reports, SAP Datasphere, S4HANA

Solution Architect

OBE (Oldcastle Building Envelope)
Carmel, Indiana
01.2025 - 12.2025
  • Demonstrated SAP Datasphere and Embedded Analytics tools and technologies to customer.
  • Lead Analytics assessment and designed Analytics Strategy for Blended Analytics and SAP and Tandem data in Azure/Snowflake Platform and Operational Analytics with SAP Datasphere modeling and SAP Analytics Cloud.
  • Collaborated with SAP Sales and tech teams to provision SAP Datasphere(Dev/Q and Prod Env.), licenses and Migration to SAP Business Data Cloud.
  • Datasphere Connection Setup – SAP S4HANA, SAP C4C, SAP SuccessFactors(EC), Employee Central Payroll (ECP), CPI, SFTP, Azure ADLS
  • HCM Data Modeling: Designed SAP SuccessFactors(EC), ECP, Benefits(HWSE) and WFS Bronze, Silver, Gold layers and Analytical Models for SAC Consumption.
  • Performed a fit-gap analysis and defined scope for SAP Embedded analytics with Fiori and SAP Analytics Cloud reporting and data ingestion to Azure ADLS with Snowflake data model and Power BI reporting for Blended Analytics with SAP and historical data.
  • S4HANA Data Ingestion: Designed and Developed SAP ABAP Custom CDS views, Enhanced SAP Standard CDS views for Data Extraction and CDC, Designed and Developed SAP Datasphere Replication Flows for ingestion into Azure ADLS.
  • Performed Data analysis Azure Databricks and build data transformation notebooks to implement business logic and feeding to Snowflake platform.
  • Implemented pre-requisite SAP Notes (50+) for smooth integration between S4HANA and Datasphere platforms.
  • North American manufacturer, fabricator and distributor of building materials including architectural hardware, glass and glazing systems.
  • Technology: SAP Business Data Cloud, SAP Datasphere (Data Modeling), SAP S4HANA, SAP SuccessFactors EC, ECP, WFS (WorkForce), SAP Embedded Analytics (CDS Views), ABAP, MS Azure ADLS, Databricks, Snowflake, Power BI.

SAP/Azure Architect

Delek US
Nashville, TN
05.2024 - 01.2025
  • Led RFP responses, effort estimation, budgeting, and SOW closure, followed by end-to-end delivery of a centralized Transportation Cost Data Hub on Azure Databricks.
  • Architected and implemented a Databricks Lakehouse (Medallion architecture) ingesting multi-modal supplier data (Truck, Rail, Barge, Pipeline) using ADF, APIs, Logic Apps, and AI-driven invoice digitization.
  • Configured Unity Catalog for Data Governance and Security.
  • Configured Autoloader and Spark Declarative Pipelines(aka DLT) for Streaming Data
  • Built scalable ingestion and transformation pipelines using PySpark, optimized Databricks performance (Z-ORDER, OPTIMIZE, VACUUM, indexing), and automated infrastructure and deployments with CI/CD and modular BICEP IaC.
  • Integrated SAP S/4HANA financial data via SAP Datasphere (CDS views) and delivered actionable insights through Power BI dashboards covering actuals, contracted costs, deficiencies, and leakages.
  • Delivered measurable business value by ingesting $500M+ in invoice spend and identifying $30M in transportation cost leakages within first six months.
  • Led a 9-member team of architects and data engineers, collaborated with business and supplier stakeholders on requirements and design, and executed delivery using Agile (bi-weekly sprints).
  • Led Stakeholder meetings and participated in Steering Committee meetings to update project status and progress.
  • Delek US Holdings, Inc. is a diversified downstream energy company with assets in petroleum refining, logistics, asphalt, renewable fuels and convenience store retailing.
  • Technology: Azure Data Factory, Databricks Lakehsoue, Python/Pyspark, SAP Datasphere, SAP S4HANA, Logic Apps, Data Lake Gen2, Power Apps, Power BI, DevOps, BICEP, API Integrations, SQL Integrations, Flat Files, OCR AI– Document Processing

Solution Architect

Caleres Inc.
Carmel, Indiana
07.2023 - 12.2024
  • Led enterprise Analytics Assessment and Platform Evaluation, recommending Azure Databricks Data Intelligence Platform as the next-generation data foundation and defining a 3–5 year Data & Analytics roadmap.
  • Architected an end-to-end Azure Databricks Lakehouse for SAP BW modernization using SAP CDC–based ELT, Delta Live Tables, and Medallion (Bronze/Silver/Gold) architecture, enabling migration from SAP BW, ECC, and S/4HANA.
  • Directed business blueprinting, As-Is/To-Be architecture, estimations, SOW closure, and governance through steering committees and executive stakeholder engagement.
  • Implemented Unity Catalog for centralized governance, security, and lineage; leveraged Serverless Compute, Liquid Clustering, and Predictive Optimization to improve performance, scalability, and cost efficiency.
  • Led a cross-functional team of 18 engineers (Data, DevOps, Power BI, Purview) delivering scalable ingestion and transformation using ADF, Databricks notebooks, CI/CD, and Azure-native services.
  • Delivered governed, analytics-ready data products with Purview cataloging, Direct Lake Power BI reporting on Delta tables, end-to-end data validation, UAT sign-off, and successful go-live and post-production support.
  • Caleres Inc. is a Fashion Footwear industry and a global organization with divisions spread across the world.
  • Technology: SAP BW, SAP Datasphere, SAP Analytics Cloud, MS Azure Data Factory, Synapse Data Warehouse, Databricks with Python/PySpark, Logic Apps, Data Lake Gen2, Power Automate, Power BI, DevOps, Purview, BICEP, SAP BW, SAP ABAP.

S4HANA - Data & Analytics Lead

Stanley Black and Decker
Carmel, Indiana
02.2022 - 05.2023
  • Led business blueprint workshops to gather requirements and designed the CFIN analytics solution leveraging S/4HANA Embedded Analytics, CDS views, OData, Fiori, AFO, and BODS for data integration to AWS.
  • Architected and optimized complex CDS-based embedded analytics, managing system memory parameters and performance to ensure scalable, reliable data extraction and ingestion into AWS analytics platforms.
  • Directed a 12-member onsite/offshore delivery team, providing technical and functional leadership across multiple system integrators to achieve 100% on-time, high-quality delivery.
  • Governed Agile execution through daily scrums, executive status reviews, change control, and functional review boards, ensuring alignment with business and IT leadership.
  • Led integration testing, UAT, production deployment, and smooth handover to AMS, enabling stable post–go-live operations.
  • Stanley Black & Decker, Inc., is a Fortune 500 American manufacturer of industrial tools and household hardware and provider of security products.
  • Technology: SAP S4HANA Embedded Analytics – CDS Views, SAP BODS, SAP Analysis for Office.

Azure Architect

Allison Transmissions
Carmel, Indiana
06.2021 - 01.2022
  • Involved in Pre-sales pitch to propose the Azure solution.
  • Organized 3 weeks of Plan and Define to propose and present end-to-end solutions to IT Directors.
  • Executed a Proof of concept showing the end-to-end data flow and reporting in power BI.
  • Organizing Business Blueprint workshops with business to gather the requirements.
  • Solution design to ingest data from SAP BW and Flat file sources to Azure Cloud and transforming data to destination in Synapse.
  • Worked with business stakeholders and designed compute capacity and data redundancy for Azure Resources as per business requirements.
  • Configuration of SHIR, ADF, SQL Stored Procedures to transform and model data.
  • Configured Logic Apps for email alerts on data load or pipeline failures for error handling.
  • Configured Key-Vault to secure the credentials.
  • Managing onsite/offshore team of technical developers and functional consultants to execute the data & reporting projects.
  • Analyzed, configured, and managed the source SAP BW to ingest the correct and most updated data.
  • Allison Transmission is an American manufacturer of commercial duty automatic transmissions and hybrid Propulsion systems.
  • Technology: MS Azure Data Factory, SQL DB, Synapse DW, Logic Apps, Data Lake Gen2, Power Automate, PowerBI, DevOps, SAP BW, SAP ABAP.

Azure Data Engineer

Delta Faucets
Carmel, Indiana
09.2020 - 05.2021
  • Led RFPs, POCs, and pre-sales presentations, followed by end-to-end delivery of a scalable Data Transformation & Warehouse solution.
  • Conducted Business Blueprint workshops and documented As-Is and To-Be designs for ingestion from 150+ structured and unstructured Point-of-Sale sources (Amazon, Home Depot, Wayfair, Lowes).
  • Designed and implemented Databricks Lakehouse pipelines for data ingestion, transformation, and enrichment, orchestrated via Azure Data Factory (ADF) and integrated with MuleSoft, SaaS, FTP, Logic Apps, and web services.
  • Delivered transformed datasets into Azure Synapse and Cloud SQL Server for downstream BI and analytics, ensuring robust data workflows with automated error handling, dynamic triggers, and notifications.
  • Led a team of 8 Data Engineers to execute and deliver the project with quality and on time.
  • Built enterprise Power BI dashboards and reports, monitored cloud resource usage, and led Go-Live, Hypercare, and post-production support for reliable operations.
  • Delta Faucet Company is an American manufacturer of plumbing fixtures.
  • Technology: MS Azure Data Factory, Cosmos DB, Synapse DW, Data Bricks, Data Lake Gen2, Logic apps, VMs, DevOps, SQL DB, PowerBI.

SAC Architect

Allison Transmissions
Carmel, Indiana
07.2020 - 05.2021
  • Business Blueprint workshops and Business Requirement Documents prep – Plan & Define
  • Solution Design and Development
  • Analysis of BW broadcasting reports/Bex queries
  • Technical restructuring of reports as per required business needs and SAC prep.
  • SAC LIVE data connection setup.
  • SAC Data Models development
  • SAC Dashboards and Stories design and development – 30+ objects
  • Configuration of SAC publications for information broadcasting.
  • Migration of all 30+ BW broadcasting to SAC publications.
  • Security design and setup for publications.
  • SAC bookmarks design for multiple publications with one SAC story.
  • Analysis of 500+ SAP Analyzer workbooks.
  • Re-structuring and cleanup of workbooks and Bex queries.
  • Migration of SAP Analyzer workbooks to SAP Analysis for Office.
  • Hyper care and Annual Support.
  • Configuration S/4HANA Embedded BPC Planning – HANA Views, Virtual Data model for Real Time data access for ACTUALS, Virtual Models for retracting Planned data back to S/4HANA ACDOCP table.
  • Work Status and Business Process flow design and configuration.
  • BPC BADIs (ABAP) implementations for Work Status and KPI calculations.
  • Design and development of Input Schedules to capture both Planning and Budget numbers.
  • Designing test scripts and conducting UAT with business users.
  • Go-Live and Hypercare.
  • Allison Transmission is an American manufacturer of commercial duty automatic transmissions and hybrid Propulsion systems.
  • Technology: SAP Analytics Cloud, SAP ECC, SAP BW, S4HANA Embedded Analytics

SAP BW/HANA Solution Architect

TOYOTA Materials Handling, USA (TMHU)
Columbus, Indiana
04.2014 - 08.2020
  • Migrating SAP BW and SAP ECC data to Azure Platform.
  • Handson development: SAP Tables, ABAP Programs, SAP BW Data models, Azure ADF Pipelines.
  • Toyota Material Handling, U.S.A., Inc., headquartered in Columbus, Indiana, is the U.S. distributor of Toyota lift trucks and tow tractors.
  • Technology: SAP BW 7.5 on HANA / SAP Lumira 2.1 SP1, S4HANA, Microsoft Azure and Power BI

SAP BW/HANA Solution Architect

TOYOTA Materials Handling, USA (TMHU)
Columbus, Indiana
04.2014 - 08.2020
  • The TMHU Telematics department needed an analytics dashboard for all products, services and financial data available. A quick glance dashboards and detailed reporting on Command/Mobile, Factory and After Market Orders together with financials – Profit Center analytics (List sales, Gross Sales, Net Sales, Gross Profit, Operating expenses).
  • Business requirement gathering and Blueprint.
  • SAP BW development – BW7.5 on HANA Data models, Bex reporting, Lumira Dashboards.
  • Toyota Material Handling, U.S.A., Inc., headquartered in Columbus, Indiana, is the U.S. distributor of Toyota lift trucks and tow tractors.
  • Technology: SAP BW 7.5 on HANA / SAP Lumira 2.1 SP1, S4HANA, Microsoft Azure and Power BI

SAP BW/HANA Solution Architect

TOYOTA Materials Handling, USA (TMHU)
Columbus, Indiana
04.2014 - 08.2020
  • This project is to develop financial reports for TMHU Business management with BW7.4 on HANA. The set of reports provides complete financial information w.r.t. Income Statement, Balance Sheet, Net Working Capital, New/Used/Rental Equipment, Service Analysis, Total Revenue, Trend Analysis and Dealer Objectives. The reporting includes both Toyota and Non-Toyota dealers.
  • Business Blueprint to gather requirements.
  • Toyota Material Handling, U.S.A., Inc., headquartered in Columbus, Indiana, is the U.S. distributor of Toyota lift trucks and tow tractors.
  • Technology: SAP BW 7.5 on HANA / SAP Lumira 2.1 SP1, S4HANA, Microsoft Azure and Power BI

SAP BW-HANA Migration

TOYOTA Materials Handling, USA (TMHU)
Columbus, Indiana
04.2014 - 08.2020
  • This project is to migrate TMHU’s SAP BW7.0 on SQL Server to SAP BW7.4 powered by SAP HANA 1.0 SP08 which is the latest version offering by SAP
  • Lead team of six consulting for BW-HANA migration project.
  • SAP BW on MS SQL migration BW7.5 on HANA.
  • Toyota Material Handling, U.S.A., Inc., headquartered in Columbus, Indiana, is the U.S. distributor of Toyota lift trucks and tow tractors.
  • Technology: SAP BW 7.5 on HANA / SAP Lumira 2.1 SP1, S4HANA, Microsoft Azure and Power BI

SAP HANA Lead for APAC

ATOS, Thailand
Thailand
09.2011 - 03.2014
  • I lead multiple projects and POCS in HANA space since the launch of SAP HANA.
  • Close alignment with Business IT stakeholders to pitch in SAP HANA.
  • Lead joint marketing events with SAP Thailand, SAP Singapore as strategic IT partners and Fujitsu, Cisco and Hitachi for SAP HANA hardware appliance partners.
  • Executed multiple POCs to showcase the power of SAP HANA both on suite on HANA and BW on HANA.
  • Worked as a SPOC (Single Point of Contact) for all Asia Pacific HANA initiatives at ATOS.
  • Worked directly with ATOS Thailand CEO and VP of Sales & Marketing to close multiple project deals and SOWs.
  • Worked on multiple SAP BW and HANA implementations with other customers like OCS UK, Friesland Campina MY, Toa Paints, Thailand, ThyssenKrupp Germany.
  • Atos is a European multinational information technology (IT) service and consulting company with headquarters in Bezons, France, and offices worldwide.
  • Technology: SAP HANA, SAP Suite on HANA, SAP BW 7.x on HANA, Cisco, Fujitsu, Hitachi

SAP BW Lead Team (Version: BW 7.0)

Agilent Technologies, USA
Gurgaon, India
02.2009 - 08.2011
  • Green field implementations of SAP ECC-BW and SAP CRM-BW.
  • BW Implementations
  • Agilent is a leader in life sciences, diagnostics and applied chemical markets. The company provides laboratories worldwide with instruments, services, consumables, applications and expertise.
  • Technology: SAP BW 7.0 / BO 3.x

ABAP Developer

Holcim Services East Asia - Thailand
Thailand / India
09.2005 - 03.2008
  • Involved in multiple ABAP projects.
  • ABAP care – A Transport management system in SAP, developed in Module Pool programming.
  • ACC Cements Rollout – SAP Scripts, Smart Forms, ABAP ALV Reports.
  • Siam City Cements – ABAP rollouts, Production Support.
  • Holcim is one of the world's leading suppliers of cement and aggregates.
  • Technology: SAP ECC 4.5 / 6.0

Education

Master of Science -

Skills

  • SAP BDC/BTP Datasphere Expertise:
  • Experienced in setting up connectivity between SAP S/4HANA, SAP SuccessFactors, SAP Sales Cloud, , and Microsoft Azure platform
  • Proficient in designing Replication Flows to Azure ADLS Gen2
  • Experienced with migrating SAP BW from On-Prem to BW PCE in SAP Business Data Cloud and modernizing with Datasphere Generated Models
  • Proficient in Data Builder - Data Flows, Transformation Flows, Analytical Models, SQL and Graphical Views, Remote Tables, and performing advanced data transformation and modeling
  • Experienced with Business Builder – Facts, Dimensions, Fact Model and Consumption Models
  • Experienced in configuring SQL Stored Procedures in SAP Data sphere HANA DB and integrating with Task Chains
  • Proficient in designing security with Data Access Control(DAC) and Orchestration with Task Chains
  • Integrated solutions with SAP Analytics Cloud (Analytics & Planning), Power BI and BOBJ 2025 to enable enterprise-wide reporting and analytics
  • SAP S/4HANA Embedded Analytics – Data Modeling:
  • Experienced in developing complex custom CDS views and enhancing standard CDS views to incorporate business requirements
  • CDS Views configuration for Data Extraction and Change Data Capture for SAP Datasphere and non-SAP environments
  • Hands-on with development of CDS data models and Bex reports for Analysis for Office consumption
  • Experienced in ABAP programming and CDS SQL programming, including development of Table Functions and AMDP
  • Experienced in analyzing and optimizing CDS views performance
  • Author: CDS Views Demystification
  • SAP Analytics Cloud (SAC) Expertise:
  • Proficient in establishing connectivity with SAP S/4HANA, SAP Sales Cloud, and SAP BW
  • Skilled in configuring Live and Import Models, enhancing backend CDS views with custom development
  • Strong experience in building SAC stories, Dashboards, and Digital Boardrooms
  • Experience in analyzing SAC standard business content and modifying as per business requirements
  • Capabilities in SAC Planning, including creation of planning models, input templates, data actions, allocations, value driver trees, cross-model copying, advanced formula scripting, and designing planning stories to support budgeting and forecasting processes
  • SAP BWxHANA & HANA Side-Car
  • Proficient in designing and developing with Composite Providers, Open ODS, and Advanced Data Store Objects (DSOs), Bex Reports Knowledgeable in LSA architecture design principles
  • Experienced in developing Analytical and Calculation Views (both graphical and SQL-based), and integrating Smart Data Access (SDA) with BW models for hybrid data scenarios
  • Traditional SAP BI Tools:
  • Hands-on experience with SAP BusinessObjects, SAP Lumira, SAP Design Studio, and SAP Analysis for Office for enterprise reporting and dashboarding
  • Microsoft Azure Analytics & Data Engineering with Databricks:
  • Experienced with Databricks Lakehouse, Unity Catalog, Lakeflow Connect, Lakeflow Declarative Pipelines, Autoloader, Data Governance and Security, Spark notebooks for Data Transformation and loading
  • Skilled in building Azure Data Factory pipelines (including dynamic pre and post-processing)
  • Proficient with Virtual Machines, SHIR, Logic Apps, SQL Databases, Synapse Data Warehouse, and Cosmos DB
  • Expert in ETL processes for both structured and unstructured data, ingesting data from multiple sources
  • Hands-on experience delivering insights via Power BI reporting and dashboards
  • Experienced with Power Automate for data publication
  • Author: Azure Dynamic Pipelines

Certification

  • Databricks Certified Data Engineer Professional
  • Databricks Certified Data Engineer Associate
  • Microsoft Azure Data Engineer DP-203
  • SAP Certified Associate - SAP Business Data Cloud C_BCBDC_2505
  • SAP Certified – Positioning SAP Business Data Cloud (BDC)
  • SAP Certified Application Associate - SAP HANA 1.0 (C_HANAIMP_1)
  • SAP Certified Support Associate - SAP HANA (C_HANASUP_1)
  • S/4HANA Cloud - Sales Implementation (C_S4CS_1911)
  • OpenSAP Certified SAP BW/4HANA.

Languages

English
Professional Working

Timeline

Data Architect

Jacklinks
09.2025 - Current

Solution Architect

OBE (Oldcastle Building Envelope)
01.2025 - 12.2025

SAP/Azure Architect

Delek US
05.2024 - 01.2025

Solution Architect

Caleres Inc.
07.2023 - 12.2024

S4HANA - Data & Analytics Lead

Stanley Black and Decker
02.2022 - 05.2023

Azure Architect

Allison Transmissions
06.2021 - 01.2022

Azure Data Engineer

Delta Faucets
09.2020 - 05.2021

SAC Architect

Allison Transmissions
07.2020 - 05.2021

SAP BW/HANA Solution Architect

TOYOTA Materials Handling, USA (TMHU)
04.2014 - 08.2020

SAP BW/HANA Solution Architect

TOYOTA Materials Handling, USA (TMHU)
04.2014 - 08.2020

SAP BW/HANA Solution Architect

TOYOTA Materials Handling, USA (TMHU)
04.2014 - 08.2020

SAP BW-HANA Migration

TOYOTA Materials Handling, USA (TMHU)
04.2014 - 08.2020

SAP HANA Lead for APAC

ATOS, Thailand
09.2011 - 03.2014

SAP BW Lead Team (Version: BW 7.0)

Agilent Technologies, USA
02.2009 - 08.2011

ABAP Developer

Holcim Services East Asia - Thailand
09.2005 - 03.2008

Master of Science -

Sanjeev Kumar