Back to Developers
Pinky Patwa

Pinky Patwa

Data Analyst

75
Profile Score

About

No bio added yet

Skills & Expertise (26)

Microsoft Power BI Intermediate
7.8/10
2
Years Exp
Python Intermediate
7.3/10
2
Years Exp
Pandas Intermediate
7.0/10
2
Years Exp
Arduino IDE Git NLP Big Data SQL Power BI Hadoop Pig Time Series Analysis ETL Data Cleaning Microsoft Excel Oracle SQL Server Postgresql MySql Statistical Modelling Probability Descriptive Statistics NLTK scikit-learn Matplotlib NumPy

Work Experience

Data Analyst Intern

MixPrime TradeCom Pvt.Ltd

Nov 2024 - Jan 2025

Conducted in-depth analysis of 10,000+ rows of e-commerce data, extracting actionable insights across daily, weekly, and monthly operational levels from Google Sheets into dynamic visualizations for enhanced decision-making. Implemented custom DAX measures and calculations in Power BI, enabling detailed performance tracking and trend analysis. Daily Tracking: Monitored 20+ critical metrics, enhancing data accuracy by 15% through streamlined reporting processes. Review Analysis: Analyzed data related to call volumes, demo bookings, and customer reviews to evaluate performance metrics and conversion rates. Processed and visualized data for total demos booked, total calls, and total reviews generated in Power BI. Designed dashboards to track conversion rates, leading to a 20% increase in review generation. Settlement Reporting: Automated reconciliation for 1,000+ financial transactions, reducing manual errors by 20% and accelerating financial reporting timelines.

Data Analyst Intern

ASK Investment Managers Ltd.

Jun 2023 - May 2025

Cleaned and transformed candidate data (2,000+ rows, 30+ columns) across multiple department-wise sheets by removing inconsistencies, aligning formats, assigning correct data types, and automating structure for new entries. Developed an interactive Power BI report to analyze hiring trends, showcasing department-wise and city-wise employee distribution; discovered Wealth department had the highest headcount and Mumbai accounted for ~45% of total employees. Worked on Employee Master MIS data, building dashboards to track headcount (346 previous FY, 468 current), new joiners (244), and resignations (102). Created custom DAX measures to calculate attrition rate (~25%) for FY 2024–25 and designed visuals by department, city, and entity using filters and slicers. Integrated data via OneDrive to ensure real-time updates and maintain year-over-year comparisons. Identified high attrition trends from previous employers, notably Kotak Mahindra, and provided department-level breakdowns to HR. Applied formatting to key numeric columns (salary, tenure) using accounting standards, ensuring clean and standardized reporting. Automated manual cleaning and formatting processes to ensure consistent structure for future data entries.

Education

MSc in Data Science and Big Data Analytics - School of Data Science and Business Intelligence

- · Afghanistan

Bachelors of Accounting and Finance - University of Mumbai

- · Afghanistan

Certifications

GenAI Job Simulation

BCG X via Forage · 2025

Data Analytics Job Simulation

Deloitte via Forage · 2025

Data Visualization: Empowering Business with Effective Insights

TATA via Forage · 2025

Microsoft Power BI

The Digital Adda · 2024

Google Data Analytics Certificate

The Digital Adda · 2024

Interested in this developer?

Profile Score Breakdown

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

Profile Overview

Member sinceMar 2026

Skills (26)

Click a skill to find developers with the same skill