Pranjal Jaiswal
Noida
Summary
MIS Executive aiming to grow into a Data Analyst role, with strong experience in reporting, dashboarding, and process tracking. Cleans and validates data, automates weekly and monthly reports, and explains insights in simple words to help teams act fast. Learning advanced analysis to move from reports to deeper problem‑solving and forecasting.
Overview
2
2
years of professional experience
1
1
Certification
Work History
MIS Executive
Qdigi Service Limited
03.2025 - Current
- Designed and maintained Power BI dashboards for operational KPIs and SLA tracking.
- Automated ETL workflows and reporting using SQL and Advanced Excel, reducing manual effort by 30%.
- Performed data analysis to identify trends and improve SLA compliance by 12%.
Documentation Executive
UNIVO Education Pvt. Ltd
08.2023 - 11.2024
- Processed and analyzed 30,000+ student records using SQL and Excel for admissions reporting.
- Developed Power BI dashboards to monitor application trends, achieving 20% YoY growth.
- Conducted KPI-based presentations to improve admit rate by 8%.
Education
B.Tech - Mechanical Engineering
Rajiv Gandhi Proudyogiki Vishwavidyalaya
05.2021
Skills
- Data Visualization: Power BI (DAX), Interactive Dashboards
- Programming: Python (Pandas, NumPy, Matplotlib, Seaborn)
- Data Analysis: ETL, KPI Reporting, Trend Analysis, Business Intelligence
- Database & Data Management: SQL (MySQL, PostgreSQL)
- Spreadsheet Tools: Advanced Excel (Pivot Tables, VLOOKUP, XLOOKUP, VBA), Google Sheets
- Other: Data Cleaning, Data Transformation, Reporting Automation
Certification
- SQL (Intermediate) – HackerRank
- Google Advanced Data Analytics Professional Certificate
- Microsoft Excel – Udemy
Timeline
MIS Executive
Qdigi Service Limited
03.2025 - Current
Documentation Executive
UNIVO Education Pvt. Ltd
08.2023 - 11.2024
B.Tech - Mechanical Engineering
Rajiv Gandhi Proudyogiki Vishwavidyalaya
Projects
E -Commerce EDA | Python, MySQL
• Analyzed a large e-commerce dataset (Target E-commerce Dataset] - 100k+ records) using Python (Pandas, NumPy, Matplotlib, Seaborn) and SQL to uncover key trends in sales, customer behavior, and product performance, identifying a 15 percent increase in potential revenue through targeted marketing strategies.
• Visualized key findings through compelling charts and graphs , effectively communicating data-driven insights that led to a 5 percent reduction in customer churn during a pilot program.
Agent Task Tracker | Advance MS Excel
Built a dynamic task tracking dashboard using Power BI, enabling managers to identify and address bottlenecks in agent workflows, leading to a 20 percent improvement in call contact rates within the first month. Leveraged slicers for targeted analysis, visualizing key metrics such as form completion rates and call outcome distributions. Enabled daily/monthly performance evaluations and result qualification, demonstrating proficiency in data visualization and performance reporting.