Mayank Gurjar

Mayank Gurjar

Data Analyst specializing in Power BI, SQL, and Excel

Pune, India

About

Data Analyst specializing in Power BI, SQL, and Excel, with experience in data analysis, data validation, and data cleaning, building interactive dashboards and KPI-driven reports that improve operational vis- ibility and support faster, data-driven decisions. Experienced in translating business requirements into scalable data models and SQL-based analysis, with additional exposure to Python-based data pipelines and data transformation

What I'm looking for

I am looking for role in the domain of data analyst

Experience

Stratacent

Data Analyst

Stratacent

Sep 2025 – Present

• Designed and developed interactive Power BI dashboards for the Moody’s Rating Application Support Team, giving stakeholders real-time visibility into support operations and reducing manual status-reporting time by 20%. • Delivered KPI-driven reports tracking issue volume by location, severity, resolution status, average resolution time, and SLA compliance – surfacing SLA breach risks 2 days earlier on average and supporting weekly leadership reviews. • Partnered with cross-functional teams on the TransUnion Call Monitoring Decoupling project, translating business requirements into SQL development and database testing strategies. • Performed System Integration Testing (SIT), Unit Testing, and manual SQL data validation using SSMS 22, identifying and resolving data-accuracy defects prior to release.

Power BISQLSSMS

Education

Indian Institute of Information Technology, Jabalpur

B.Tech · Computer Science and Engineering

2021 – 2025

Skills

LLMsPrompt EngineeringAWSPySparkn8nDockerSSMSGitMySQLPostgreSQLPythonSQLExcelTableauDAXPower BI

Languages

English (Professional working proficiency)Hindi (Native or bilingual proficiency)