Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

AJAY SINGH CHAUHAN

Noida

Summary

Dynamic Senior Associate Consultant with expertise in Power BI and SQL Server management at Infosys Ltd. Proven track record in delivering impactful analytics reports, enhancing operational KPIs across multiple manufacturing plants. Skilled in data transformation and stakeholder collaboration, driving data accuracy and business intelligence initiatives.

Overview

6
6
years of professional experience
3
3
Certifications

Work History

Senior Associate Consultant - Power BI / Microsoft Fabric

INFOSYS LTD
10.2022 - Current
  • I worked as a Power BI Developer for Havells Wires & Cables division, delivering analytics reports for eight manufacturing plants.
  • Designed and developed eight plant-wise Power BI reports, enabling tracking of plant performance and operational KPIs.
  • Integrated the Power BI reporting pipeline by connecting the source system through middleware, pulling data from the database using import mode.
  • Performed data cleaning, transformation, and modeling using Power Query, converting raw data into structured and standardized formats.
  • Built a master data model with multiple related tables, and ensured proper data consistency across all plants.
  • Loaded and maintained transformed datasets into SSMS (SQL Server), and managed data refresh and validation cycles.
  • Published final datasets and reports into Power BI Service, configured scheduled refresh, and ensured report accuracy.
  • Coordinated with business stakeholders and client teams to gather requirements, provide demos, and explain enhancements and changes.

Senior Analyst / Data Analyst

GLOBALLOGIC
08.2019 - 09.2022
  • Worked on the Cloud Compute tool for data validation and data testing, ensuring data accuracy and consistency across categories.
  • Performed data segregation and classification based on defined business categories and validation rules.
  • Executed data quality checks, identified anomalies, mismatches, missing values, and incorrect mappings.
  • Logged and tracked defects by raising JIRA tickets with proper defect details, screenshots, logs, severity, and reproduction steps.
  • Collaborated with cross-functional teams to resolve issues, retested fixes, and ensured closure within SLA.
  • Prepared validation summaries and status updates for stakeholders on defect trends and test progress.

Education

Master of Computer Applications -

AKTU
Meerut
01.2024

Bachelor of Computer Applications -

Ch. Charan Singh University
Meerut
01.2015

Skills

  • Business intelligence
  • SQL Server management
  • Data visualization
  • Power BI Desktop
  • Power BI service
  • Dashboard development
  • KPI reporting
  • Power Query
  • Data transformation
  • DAX
  • Advanced Excel
  • SSMS
  • Data cleansing
  • Data modeling
  • Stakeholder communication
  • Problem solving
  • Business analysis

Certification

Microsoft: Power BI Data Analyst Associate (PL-300)

Timeline

Senior Associate Consultant - Power BI / Microsoft Fabric

INFOSYS LTD
10.2022 - Current

Senior Analyst / Data Analyst

GLOBALLOGIC
08.2019 - 09.2022

Master of Computer Applications -

AKTU

Bachelor of Computer Applications -

Ch. Charan Singh University
AJAY SINGH CHAUHAN