Sumit Kumar

Data Engineer

Uttar Pradesh, India8 yrs 3 mos experience

Key Highlights

Proven track record in building end-to-end data solutions.
Expert in optimizing data pipelines for real-time analytics.
Skilled in integrating enterprise data with BI platforms.

Stackforce AI infers this person is a Data Engineering expert in the Fintech and SaaS industries.

Contact

sumitkumar905@gmail.com LinkedIn

Skills

Core Skills

Data EngineeringMicrosoft AzurePower BiEtlData Visualization

Other Skills

ADFAgile EnvironmentAzure Data FactoryAzure DatabricksAzure synapseBusiness AnalysisBusiness Intelligence (BI)CCustomer ServiceDAXDashboardsData AnalysisData AnalyticsEventhubExtract, Transform, Load (ETL)

About

Experienced Senior Data Engineer with a proven track record in building and optimizing end-to-end data solutions across cloud platforms. Skilled in architecting scalable data pipelines, enabling real-time analytics, and improving data performance using modern tools and frameworks. Demonstrated success in delivering impactful business insights by integrating enterprise data sources with BI platforms. Passionate about learning and implementing machine learning models to derive actionable insights and enhance data-driven decision-making. Data Orchestration: Azure Data Factory, Azure Synapse, Event Hub Programming Skills: SQL, Python, PySpark Big Data & Processing: Azure Databricks, Delta Lake Data Warehousing: Snowflake BI & Reporting: Power BI, DAX, Tabular Editor, Visual Studio Version Control & CI/CD: Git

Experience

Coforge

Senior Data Engineer

Jul 2025 – Present · 8 mos · Remote

Resposible for Developing End to End Business Solution in BFSI Domain

Microsoft AzureAzure Data FactorySQLPython (Programming Language)PySparkMicrosoft Business Intelligence (MSBI)+3

Mckinsey & company

Senior Data Engineer - Power BI

Jul 2024 – Jul 2025 · 1 yr · Gurugram, Haryana, India

Designed and implemented a data pipeline using Snap logic, Azure Data Factory, Azure data bricks, Pyspark, Azure Delta Lake, and Snowflake, resulting in efficient data transfer and storage.
Optimized data transformation processes using ADF, Azure Databricks, and PySpark, achieving a 15% reduction in data processing time, significantly improving data quality, and leveraging Delta Lake for data reliability and performance.
Implemented Snowflake as a data warehouse, creating views/materialized views for optimized Power BI live query performance.
Enabled real-time data analysis in Power BI by establishing a live connection to the curated data model in Snowflake, ensuring up-to-date insights.
Utilized DAX, SQL, Visual Studio, Git and Tabular Editor for optimizing visualization, measures, reports, models.

Data EngineeringPySparkDashboardsSnowflakeAgile EnvironmentVisial studio+6

Tata consultancy services

Senior Data Engineer

Nov 2022 – Jul 2024 · 1 yr 8 mos · Noida, Uttar Pradesh, India · Hybrid

Built an orchestrated data workflow (SQL, ADF, Python, Azure synapse, Eventhub) for ETL, preparing data for Power BI and Power Apps, and integrating with Power Automate to streamline user workflows.
Implemented data models, including star and snowflake schemas, to support efficient data retrieval and reporting.
Analyzing KPI’s involving revenue data to compare forecasted vs. actual figures and conduct profitability analyses. This will involve calculating cost margins and profit margins segmented by country, order number, base plant, and other attributes
Empowering stakeholders to gain a holistic view of supply chain performance, identify areas for revenue growth, and optimize profitability across various business segments.

Data EngineeringAzure synapseExtract, Transform, Load (ETL)Microsoft SQL ServerDashboardsAgile Environment+5

Capgemini

Consultant

Jul 2020 – Nov 2022 · 2 yrs 4 mos · Gurugram, Haryana, India

Developed Power BI Sales End to End reports and dashboards resulting in a 30% increase in operation efficiency.
Involved in Migration from Tableau to Power BI
Experience in creating different visualizations like Line, Bar, Histograms, Scatter, Tornado, Heat maps, Tree maps, KPIs and creating custom visuals.
Designed and developed data models, queries, and ETL processes for data integration, processing, and cleansing.

SQLMicrosoft SQL ServerTableauStatistical Data AnalysisData VisualizationAgile Environment+6

Hcl technologies

2 roles

Analyst

Promoted

Jul 2018 – Sep 2019 · 1 yr 2 mos

Transformed Migrated and transformed 5+ Tableau dashboards and reports to Power BI for multiple internal departments, ensuring seamless data
and visual continuity between platforms.
Recreated and enhanced custom Tableau visuals in Power BI, leveraging Power BI’s visualization capabilities to improve user experience and
interactivity.
Provided training and support to end-users on navigating and utilizing the newly migrated Power BI dashboards and reports, facilitating a smooth
transition from Tableau to Power BI

Microsoft PowerPointMicrosoft ExcelMicrosoft Power BI