ForumO Network
Data Analyst Intern
Pakshal Solanki
Open to workData Analyst Intern
Pune, India2 projects
Projects
2
Skills
8
Roles
3
Network
About
Who Pakshal is
Final-year AI & Data Science undergraduate (CGPA: 8.38/10, expected graduation 2027) with hands-on experience across three internships in data analytics, visualization, and business intelligence. Skilled in SQL, Python, Excel and Tableau with experience building KPI dashboards, cleaning and analyzing datasets of 50,000+ records, and transforming data into actionable business insights. Delivered measurable outcomes including >95% dataset completeness, 6+ operational KPIs, and a projected ~10% reduction in delinquency risk. Seeking a Data Analyst role to leverage SQL, data visualization, dashboarding, and analytical problem solving to support data-driven business decisions.
Skills
8 strengths on profile
PythonSQLTableauExcelData Visualizationpredictive modellingmachine learningstatistics
Experience
Roles and impact
Data Visualization Intern
Infosys
2026 → Present
● Building MedTrack_DV, a 4-dashboard Tableau suite (Hospital Overview, Patient Flow, Department Analytics, Resource Utilization) analyzing hospital operations across 10+ zones and hospitals. ● Engineered 6+ healthcare KPIs (occupancy rate, readmission rate, average length of stay, bed utilization) from raw admissions data, achieving >95% dataset completeness and <2% missing values after cleaning. ● Owned the full analytics pipeline — data collection, cleaning, and transformation in Python (Pandas, NumPy) — then integrated global filters, parameter actions, and cross-dashboard navigation for real-time operational monitoring.
Artificial Intelligence and Sustainability Intern
Shell India & Edunet
DEC 202 → JAN 202
● Built an AI-based urban cooling prediction system using Random Forest on 7,000+ environmental data points (zone area, tree density, humidity) and real-time EOS Weather API data to forecast zone-wise Pune temperature trends for 2027. ● Shipped an interactive GIS dashboard (Folium, Leaflet.js) covering 10+ city zones to quantify Neem tree cooling impact and guide plantation planning toward a 25°C target.
GenAI Powered Data Analytics Intern Job Simulation
Tata Group
OCT 202 → NOV 202
● Explored 50,000+ customer profiles over 6 weeks using Pandas and SQL, cleaning and analyzing 15+ financial attributes to uncover early indicators of credit delinquency risk. ● Built a GenAI-assisted predictive framework identifying key risk drivers (credit utilization, missed payments, debt-to-income ratio) and translated findings into a business report projecting a ~10% reduction in 30-day delinquency.
Projects
What they’ve shipped
End-to-End Sales Forecasting & Demand Intelligence System
Built a retail demand intelligence system comparing SARIMA, Prophet, and XGBoost for sales forecasting, with XGBoost as the best performer (MAPE: 14.10%) on the Superstore sales dataset. Implemented anomaly detection (Isolation Forest, Rolling Z-Score) to flag unusual sales spikes/drops, and K-Means clustering with PCA to segment products into demand cohorts with inventory recommendations.
Employee Attrition Prediction
● Built a classification pipeline predicting employee attrition on the IBM HR Analytics dataset (1,470 records, 35 features), comparing Logistic Regression, Random Forest, and Gradient Boosting classifiers. ● Selected Logistic Regression as the top model based on Recall and ROC-AUC, and identified overtime, low income, and poor work-life balance as leading attrition drivers via EDA and feature importance analysis. ● Translated model insights into actionable HR recommendations on retention programs, career development, and workload monitoring.
PythonRegressionRandom Forest
Education
PES Modern College of Engineering, Pune
B.E. · Artificial Intelligence and Data Science
2023 → 2027
Certificates
Signal Card
3D shareable card for Instagram Stories, WhatsApp, and anywhere
Forumo
Pakshal Solanki
@pakshal-solanki
Other
Data Analyst Intern
Final-year AI & Data Science undergraduate (CGPA: 8.38/10, expected graduation 2027) with hands-on experience across three internships in data analytics, visualization, and business intelligence. Skilled in SQL, Python, Excel and Tableau with experience building KPI dashboards, cleaning and analyzing datasets of 50,000+ records, and transforming data into actionable business insights. Delivered measurable outcomes including >95% dataset completeness, 6+ operational KPIs, and a projected ~10% reduction in delinquency risk. Seeking a Data Analyst role to leverage SQL, data visualization, dashboarding, and analytical problem solving to support data-driven business decisions.
PythonSQLTableau+5
Open selectively
2 projects
Pune, India