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

years of professional experience

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