Back to Developers
Pranjal Mishra

Pranjal Mishra

Data Analyst

Greater Noida 3+ yrs exp 91 ยท Outstanding

About

Data Analyst with 2.5 years of professional experience at Wipro Technologies in software development and production support, now specializing in data analysis, business intelligence, and dashboard reporting through a hands-on certification in SQL, Power BI, Tableau, and Advanced Excel. Skilled in data cleaning, data validation, KPI and SLA tracking, MIS reporting, and building interactive dashboards using DAX and Power Query. Comfortable working with large, multi-source datasets, coordinating with cross-functional stakeholders, and translating raw data into clear, actionable business insights. Strong foundation in root cause analysis, requirements gathering, and production support from prior software development experience.

Skills & Expertise (32)

SQL Advanced
8.4/10
3
Years Exp
Data Cleaning Advanced
8.0/10
3
Years Exp
Power BI Advanced
8.0/10
1
Years Exp
Tableau Advanced
8.0/10
1
Years Exp
Business Performance Analysis Advanced
8.0/10
3
Years Exp
Data Visualization Advanced
8.0/10
3
Years Exp
DAX Intermediate
7.8/10
1
Years Exp
Advanced Excel Intermediate
7.5/10
3
Years Exp
Data Validation Intermediate
7.5/10
3
Years Exp
Data Reconciliation Intermediate
7.5/10
3
Years Exp
Java Intermediate
7.0/10
2
Years Exp
RESTful APIs Intermediate
6.8/10
2
Years Exp
Spring Boot Intermediate
6.8/10
2
Years Exp
Database Maintenance Intermediate
6.5/10
2
Years Exp
Microservices Intermediate
6.5/10
2
Years Exp
Trend and Pattern Analysis relational databases Production support English Hindi Executive Reporting Dashboard Design Ad Hoc Reporting MIS reports Data Modeling Basics Power Query Index-match SUMIFS XLOOKUP VLOOKUP Pivot Tables MySql

Work Experience

Data Analyst

AI Variant

Dec 2025 - May 2026

Performed data cleaning, transformation, and validation on multi-table hospitality and e-commerce datasets from multiple sources, ensuring data accuracy, consistency, and integrity. Developed and tracked key business KPIs - Total Revenue, ADR, RevPAR, Occupancy Rate, Cancellation Rate, Average Order Value (AOV), Order Volume, and Customer Retention Rate - to support performance monitoring and business decision-making. Wrote and optimized SQL queries (JOIN, GROUP BY, WHERE, aggregate functions) to extract, reconcile, and analyze data for revenue and performance reporting. Built interactive Power BI and Tableau dashboards using DAX measures, calculated fields, filters, and slicers, plus Power Query (M) transformations, for executive and MIS-style reporting. Identified trends and patterns across business segments, translating findings into clear, actionable recommendations for stakeholders.

Project Engineer

Wipro Technologies

Jul 2022 - Feb 2025

Worked as a Software Developer, designing, developing, and maintaining RESTful APIs and microservices for enterprise-level systems using Java and Spring Boot, working directly with relational databases. Gathered and reviewed requirements from cross-functional stakeholders, ensuring design and implementation aligned with business specifications. Maintained data integrity and consistency across production systems, supporting deployment, monitoring, and issue resolution activities in production and lower environments. Investigated and resolved technical issues through root cause analysis, ensuring stakeholder satisfaction and system reliability.

Education

Data Analyst Certification - ExcelR Institute

2025 - 2026 ยท India

B.Tech, Electrical Engineering - Shri Ramswaroop Memorial College of Engineering and Management

2018 - 2022 ยท India

Certifications

Data Analyst

ExcelR ยท 2025

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 11/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 5/5
โœ… Verified 5/5
Total Score 91/100

Profile Overview

Member sinceJul 2026

Availability Details

Visa Status

Citizen

Relocation

Depends on Offer