Back to Developers
Pratyush Gupta

Pratyush Gupta

Data Analyst

Pune, India 0+ yrs exp 61 · Good

About

Data Analyst with hands-on experience across the full analysis lifecycle: collecting and cleaning large datasets, performing exploratory and statistical analysis, building business intelligence dashboards, and translating findings into clear, actionable recommendations for stakeholders. Proficient in SQL, Excel, Power BI, Tableau, Python, and R, with practical experience in data mining, association-rule analysis, and trend and root-cause analysis. Strong problem-solving skills, comfortable working across cross-functional teams — including finance, compliance, product, and operations — to gather requirements, maintain data quality, drive process improvement, and deliver recurring reporting on a fixed cadence. PGDM in Business Analytics (expected 2026) with a B.Tech engineering foundation.

Skills & Expertise

No skills listed yet

Work Experience

Business Analytics Intern

Outlook Publishing

Apr 2025 - Jul 2025

Developed a comprehensive Power BI dashboard using Excel and Python to analyze and visualize 30,000+ rows of sales data, providing real-time visibility into performance for 5+ departments. Gathered reporting requirements from cross-functional stakeholders, translating varied needs into a single, prioritized dashboard specification. Investigated data to identify 3 recurring sales trends, translating findings into recommendations that drove a 15% improvement in identifying process gaps and performance issues. Standardized data cleaning and manipulation procedures in Python and Excel, reducing manual processing time by 30% and achieving 100% accuracy for internal reporting and compliance. Tracked 10+ key metrics on a fixed weekly reporting cadence, cutting average turnaround times by 20% and providing a data-driven basis for resolving operational inefficiencies. Documented data sources, cleaning methodology, and reporting logic clearly to support handover and repeatable analysis. Coordinated with a team of 4 to ensure timely project implementation and seamless integration of data visualizations into weekly strategy meetings.

Financial Analyst Intern

PredictRAM

Apr 2025 - Jun 2025

Performed exploratory data analysis (EDA) on a large transactional dataset of 25,000+ records using Microsoft Excel and R, ensuring 99% data integrity. Reviewed customer profiles and acquiring-product data to identify changes indicating potential fraudulent activity, supporting risk-mitigation strategy. Leveraged the Apriori algorithm in R to uncover 4+ high-confidence association rules, identifying strong product relationships (e.g., spaghetti and mineral water) to drive behavioral insights. Translated data findings into actionable recommendations for business strategy, including optimizing product placement and enhancing cross-selling opportunities. Created 10+ complex data visualizations (scatter plots, network graphs, heatmaps) using R (arulesViz) and Excel to communicate insights clearly to stakeholders. Ensured alignment among compliance, product, and operations teams through cross-functional collaboration on risk-monitoring initiatives.

Education

PGDM, Business Analytics - International School of Management Studies

- 2026 · Afghanistan

B.Tech, Mining Engineering - University Institute of Technology

- 2022 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 0/20
🎓 Education 10/10
⏱️ Experience 6/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 61/100

Profile Overview

Member sinceSep 2026