Back to Developers
Pranjal Jaiswal Jaiswal

Pranjal Jaiswal Jaiswal

MIS Executive

Delhi, India
80
Profile Score

About

MIS Executive with 2+ years of data analytics experience, transforming complex data into actionable business insights using SQL, Power BI, Python, and Advanced Excel. Delivered measurable impact: 15% increase in applications, 30% reduction in manual effort, and 12% improvement in SLA compliance through automated ETL workflows and predictive analytics. Proven expertise in building scalable dashboards, statistical modeling, and cross-functional collaboration. Ready to apply data-driven problem-solving skills to accelerate business growth as a Data Analyst.

Skills & Expertise (19)

Power BI Advanced
8.5/10
2
Years Exp
Advanced Excel Advanced
8.0/10
2
Years Exp
SQL Intermediate
7.3/10
2
Years Exp
Regression Power Automate Power Query Index-match VLOOKUP Pivot Tables Macros VBA A/B testing Hypothesis Testing Statistical Analysis Data Modeling Data Cleaning & Transformation Data Warehousing ETL Pipeline Development Python

Work Experience

MIS Executive | Data Analytics & Business Intelligence

QDIGI Services

Mar 2025 - Present

Constructed and maintained 10+ interactive Power BI dashboards tracking operational KPIs and SLA metrics, enabling real-time monitoring and strategic decision-making for 50+ stakeholders across leadership and operations teams. Streamlined end-to-end ETL workflows using SQL stored procedures and Advanced Excel VBA macros, reducing manual reporting effort by 30% and improving data accuracy. Performed regression analysis and chi-square hypothesis testing to identify operational bottlenecks and trends. Collaborated with cross-functional teams to streamline data collection processes and establish standardized data quality protocols. Engineered optimized email alerting system in Power BI to flag SLA breaches in real-time.

Documentation Executive | Data Analytics Focus

UNIVO Education

Aug 2023 - Nov 2024

Analyzed and cleaned admission data for 18,000+ applicants using Advanced Excel, identifying high-potential segments through cohort analysis. Developed interactive Power BI dashboards visualizing student admission funnels and tracking application volume growth. Presented data-driven recruitment insights and predictive analytics findings to C-level leadership. Improved admit rate through statistical analysis and A/B testing of admission criteria. Developed and deployed automated weekly reporting system using Excel VBA and macros.

Education

Bachelor of Technology in Mechanical Engineering - Rajiv Gandhi Proudyogiki Vishwavidyalaya

2017 - 2021 · Afghanistan

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 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 80/100

Profile Overview

Member sinceFeb 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation

Skills (19)

Power BI Advanced Excel SQL Regression Power Automate Power Query Index-match VLOOKUP Pivot Tables Macros +9 more