Power Bi Data Engineer

Chandan Sengupta

Email: ******.****@*****.***, Phone No.: 916-***-****/ 989-***-****

Data Engineer and Architect

Profile Summary

Talented Analyst with 14+ years of rich experience in Business Analysis, Data Mining & Analysis, BI Reporting, Data Engineering, and Insight Generation. Adept at designing, building, and maintaining data solutions on Microsoft Azure, Databricks, SQL, and SAP platforms to enable data-driven decision-making. Demonstrated expertise in capturing business requirements, translating them into actionable BI solutions, and leading teams to deliver measurable business impact. Skilled in stakeholder collaboration, mentoring analysts, and implementing process improvements that drive operational efficiency and compliance.

Core Competencies

Data Mining & Analysis Business Analysis

Power BI, Tableau, MS Excel, SAP R3/BW/BI Reporting

Azure Databricks SQL Data Ingestion & Pipelines (Azure Data Factory)

SSIS & SSRS Reporting (ETL, automation, dashboards)

Python & R for Data Science, Machine Learning (K2 Analytics training)

Project Planning & Execution

Team Management, Leadership & Stakeholder Engagement

Technical Skills

Languages & Tools: SQL, Python, R, MS Excel, SSIS, SSRS, Power BI, Tableau, Azure Data Factory, Databricks

BI & Analytics: Data Validation, Data Visualization, MIS Reporting, Pattern Analysis

Platforms: Azure Data Lake, Azure Analysis Services, SAP R3/BW/BI/HANA

Other: Performance Monitoring, Data Modeling, ETL Design & Optimization

Professional Experience

Tata Consultancy Services (TCS), Nagpur : Apr 2019 – Present

Senior Analyst – Data Engineering & BI Architecture

Led the team of 4 for development and implementation of comprehensive reports to measure and track progress improvements, ensuring alignment with client organizational objectives.

Migrated legacy MicroStrategy reports to Azure-based Power BI, improving usability and performance.

Built scalable data models in Azure Databricks SQL, integrating multiple complex datasets.

Designed advanced DAX expressions for calculated columns and measures, enhancing analytical depth.

Architected, designed, and developed multiple Power BI dashboards for global demand and capacity planning.

Developed Azure Data Factory pipelines to move data from multiple sources to Azure Data Lake.

Created ADLA USQL jobs to transform raw data, setting policies and limits for optimized analytics performance.

Migrated 15+ dashboards from Spotfire to Power BI with enhanced visualizations.

Led a cross-functional team of analysts and developers to deliver reporting solutions, assign tasks, and mentor juniors.

Oversaw governance of data privacy and security in BI reporting.

Partnered with business stakeholders to align deliverables with strategic KPIs.

Project 1: Demand and capacity Planning Reporting (FedEx OIP – ICON and EU CDP – April 2019 – May 2025)

Involved in design and development of multiple Power BI dashboard and report.

Architecting, designing, and developing complex Azure analysis service and constantly monitoring the daily schedule and provides data to the ad hoc request from the business user.

Managing data privacy and security in Power BI.

Extensively involved in designing and developing the power BI data model using multiple DAX expressions to build calculated columns and calculated measures.

Developed Azure factory pipelines to move the data from source systems and transform the data in azure blob storage and created ADLA USQL jobs to transform the data into azure.

.

Migration of near about 15 different dashboards build in Spotfire are transferred to Power BI with Azure data set.

Project 2 : Data migration project of ASOS (May 2025 – Present):

Built data ingestion pipelines from diverse sources (API, SQL, flat files) into ADLS.

Implemented data transformations and aggregations using Spark in Databricks.

Ensured compliance with data governance and security policies.

Developed reusable frameworks for ETL workflows in Azure Data Factory

Driving and managing data integration activities to ensure that data is received, compete, accurate and available for users.

Sterling Talent Solutions, Mumbai : Sep 2017 – Mar 2019

Business Analyst – SLA & Quality Reporting

Managed SLA-based client refunds through detailed BI-supported analysis, ensuring compliance with contracts.

Developed SQL scripts for turnaround-time (TAT) reporting and variance analysis.

Built dashboards to monitor service delivery performance across Mumbai and Manila sites.

Prepared MPS and budget vs. actuals reporting for management.

Supervised a small analyst team responsible for generating accurate SLA compliance reports.

Delegated workload, trained juniors in BI tools, and ensured timely reporting delivery.

Collaborated with operations and senior stakeholders to improve SLA adherence and reporting accuracy.

Clariant Chemicals India Ltd, Navi Mumbai : Jan 2011 – Sep 2017

Business Intelligence & Data-to-Insight Specialist

Conducted advanced data analysis within SAP ERP, enabling actionable insights in supply chain and sales.

Delivered high-intensity SAP data models and dashboards for top management.

Created KPIs for monitoring OTIF, networking capital, receivables/payables, and P&L performance.

Designed complex ETL queries with Robur, SSIS, and SSRS, optimizing data pipelines.

Converted legacy Robur queries into SQL-based ETL processes, reducing latency.

Supported SAP BW/BI grievance handling and collaborated on HANA migration.

Tower Head of one of vertical (Sales and Finance), responsible for smooth delivery of reports and monitor the KPIs.

Led an operations reporting team, responsible for global SCM reporting.

Developed weekly/monthly management reports using SAP BW, SSIS, and advanced Excel.

Played a key role in implementing SAP Transport Module across Europe.

Successfully transitioned reporting from Switzerland, Spain, and Nordics to India.

Built an in-house SSIS-based E-Freight portal for freight vendors.

Ensured ISO certification compliance for reporting processes.

Sri Balaji Society (BITM), Pune – Nov 2009 – Dec 2010

Assistance Professor – SAP BI / BW instructor

As an instructor is a preconfigured set of role and task-related information models that are based on consistent metadata in SAP Business Intelligence

Career Accomplishments:

Migrated 15+ global dashboards from legacy systems (Spotfire, MicroStrategy) to Power BI.

Successfully deployed power bi reports in cloud-based Azure environment.

Built data ingestion pipelines from diverse sources (API, SQL, flat files) into ADLS.

Implemented data transformations and aggregations using PySpark in Databricks.

Ensured compliance with data governance and security policies.

Developed reusable frameworks for ETL workflows in Azure Data Factory.

Streamlined BI operations using SSIS & SSRS automation, reducing manual effort significantly.

Drove end-to-end BI transitions across global sites (Switzerland, Germany, Spain, Sweden, Nordics).

Consistently recognized for strong team leadership, stakeholder management, and mentoring abilities.

Certifications

Certificate Course in Service Management

Executive MBA – Indo-German Training Centre

Machine Learning Training – K2 Analytics

Ongoing Training – Azure Databricks

Academic Details

PGDM (Systems & Marketing) – SBS BIMM, Pune (2009)

B.E. (Computer Science) – RITEE, Pt. Ravishankar University (2003–2007)

Declaration:

I hereby declare that the above written particulars are true to the best of my knowledge and belief. Additional and appropriate references can be furnished upon request.

Contact Address: Permanent Address:

Flat no. 1302, Bhoomi Perth 10/1901, Sri Balaji Nagar

Sector 7, Ghansoli Navi Mumbai. Khamtari, Raipur CG

MH, 400***-******

Contact this candidate