Susant Sahu

Data Analyst / BI Analyst

13+ yrs exp 90 · Outstanding

About

Data Analyst / BI professional with 4+ years of hands-on experience in SQL, Power BI, Python, ETL/ELT, data modeling, DAX and Power Query, backed by 13+ years of overall professional experience in data intensive and analytical environments. Strong experience across data extraction, transformation, validation, analysis, dashboard development, KPI reporting and automation. Proven ability to convert business requirements into reliable datasets, analytical solutions and actionable insights. Core platform exposure includes Power BI, SQL Server, Python alongside Microsoft Fabric and Snowflake.

Skills & Expertise (45)

Advanced SQL Advanced

8.5/10

Years Exp

Power BI Advanced

8.5/10

Years Exp

Data Analysis Advanced

8.0/10

Years Exp

SQL Server Advanced

8.0/10

Years Exp

ETL Advanced

8.0/10

Years Exp

Python Advanced

8.0/10

Years Exp

Data Visualization Advanced

8.0/10

Years Exp

Azure Data Factory Intermediate

7.5/10

Years Exp

Snowflake Intermediate

7.0/10

Years Exp

Data Governance Intermediate

7.0/10

Years Exp

Power BI (Advanced DAX) Data Reconciliation Star Schema Fact & Dimension Modeling Business Rules Microsoft Fabric MS-SQL Server Management Studio OneLake Lakehouse Agile Data Analysis & Visualisation Warehouse Python (Pandas, NumPy, SciPy) MS Excel process automation Stakeholder Collaboration KPI Dashboards Data Validation Data Quality EDA Trend Analysis Anomaly analysis KPI Analysis DAX Power Query Tableau Source-to-Target Mapping Reporting MS SQL Pandas NumPy ELT Data Transformation Data Integration Data Pipelines

Work Experience

Sr. Data Transformation Analyst

Accuris (Former part of S&P Global)

Mar 2022 - Apr 2026

Designed and developed end to end ETL/ELT data pipelines using SQL, Python and Power Query to extract, transform, validate and integrate data from multiple enterprise source systems for analytics and reporting. Built and optimized complex SQL queries, stored procedures, CTEs, joins and window functions for data analysis, transformation, reporting and business intelligence. Developed business-ready data models and interactive Power BI dashboards using DAX, Power Query and KPI-driven visualizations with Microsoft Fabric and Snowflake exposure for modern data analytics and reporting. Performed source-to-target mapping, data transformation, cleansing, standardization and business-rule validation to deliver reliable datasets for analytics and reporting. Automated data processing, reconciliation, validation and reporting workflows using Python (Pandas), SQL and Power Query, reducing manual effort and improving reporting efficiency and data accuracy. Reduced weekly report generation time from 4 hours to 45 minutes by automating recurring reporting and data-processing workflows. Implemented data quality checks, exception validation and reconciliation controls to improve data accuracy, integrity, consistency and completeness across enterprise datasets. Analyzed large datasets using SQL and Python to identify trends, patterns, anomalies and business opportunities, translating findings into actionable insights and data-driven recommendations. Optimized SQL queries, DAX calculations, data models and reporting workflows to improve query performance, dashboard responsiveness and end-user experience. Collaborated with business stakeholders, product owners and technical teams to gather requirements, define KPIs, translate business rules into technical solutions and deliver scalable analytics and reporting solutions. Developed Tableau dashboards and visualizations using integrated datasets, business KPIs and analytical insights, complementing Power BI-based reporting and supporting data-driven decision-making. Exploring AI-assisted analytics and Generative AI to automate analysis, improve reporting, and accelerate insights using SQL, Python, and Power BI.

Senior Content Analyst

IHS – IHS Markit

Oct 2014 - Feb 2022

Performed data validation, classification, quality checks and structured content analysis within enterprise data workflows, maintaining accuracy and consistency across large datasets. CATS (Content Automation Tracking System) we source, edit, and QC classified technical documents such as brochures, data sheets, catalogues i.e. Specify-it CCEI, EDMI, PEI, FMI. Analyzed user and production data to identify quality issues, trends and operational improvement opportunities. Performed lifecycle prediction modelling using industry and technology trend analysis to support strategic lifecycle decisions. Monitored production data, investigated discrepancies and supported process improvements to improve order viability and reduce delivery errors.

Content Analyst

ALP SOLUTIONS Ltd

Jul 2012 - Oct 2014

Managed large-scale data acquisition from global vendor platforms and maintained structured technical datasets. Analyzed datasets to classify components using engineering attributes and market trends. Performed data cleansing, validation and standardization to maintain data accuracy and consistency.