Susant Sahu

Data Analyst, Power BI / BI Developer with 4+ years of hands-on experience building enterprise dashboards, semantic models, DAX measures, Power Query transformations and SQL-based reporting solutions, backed by 13+ years of overall professional experience. Strong in end-to-end BI delivery covering requirements, data preparation, dimensional modeling, visualization, KPI development, validation, performance optimization and stakeholder collaboration. Experienced in automating reporting workflows and improving refresh/report performance.

Core platform exposure includes Microsoft Fabric and Snowflake.

Sr. Data Transformation Analyst at Accuris (Former part of S&P Global) (2022-03 – 2026-04)

• Designed and developed interactive Power BI dashboards, KPI reports and self-service BI solutions using DAX, Power Query and optimized semantic/data models to deliver actionable business insights.
• Built complex SQL queries, views, stored procedures, CTEs, joins and window functions to prepare, transform and optimize data sources for Power BI reporting and analytics.
• Developed star-schema data models with fact/dimension structures, relationships and reusable reporting datasets to improve scalability, maintainability and analytical consistency.
• Created advanced DAX measures, calculated columns and time-intelligence calculations for KPI tracking, trend analysis, business logic and executive reporting.
• Used Power Query (M) to extract, cleanse, transform, merge and standardize data from multiple sources while applying business rules, data-quality validation and reconciliation controls.
• Optimized Power BI and SQL performance through query, DAX, data-model and transformation optimization, improving report responsiveness and reducing unnecessary data processing.
• Reduced weekly report generation time from 4 hours to 45 minutes by automating recurring data preparation and reporting workflows.
• Delivered end-to-end BI solutions from requirements gathering and KPI definition through data preparation, modeling, visualization, testing, deployment support and stakeholder feedback.
• Developed automated and near-real-time reporting solutions and KPI dashboards for operational monitoring and management decision-making, collaborating with cross-functional stakeholders to resolve data and reporting issues.
• Explored Generative AI and AI-assisted analytics to accelerate data exploration, reporting automation and insight generation, applying AI-enabled approaches alongside Power BI, DAX, SQL and Python to improve analytical efficiency.

Senior Content Analyst at IHS – IHS Markit (2014-10 – 2022-02)

• Performed data validation, classification, quality checks and structured content analysis within enterprise data workflows, maintaining accuracy and consistency across large datasets.
• 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 at ALP SOLUTIONS Ltd (2012-07 – 2014-10)

• 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.

B.Tech in Mechanical Engineering (2011)