Hitanshi Parekh

About

B.Sc. Information Technology graduate with hands-on experience in SQL, Python, Power BI, and predictive modeling. Built end-to-end analytics projects and published research on airplane accident trend analysis.

Experience

• HOD — Decor Department
  Ignite Club

Education

• B.Sc. Information Technology
  HSNC University
  Information Technology · 2026

Skills

• SQL
• Data Visualization
• Python
• Forecasting
• Classification
• Data Cleaning
• Feature Engineering
• Matplotlib
• NumPy
• Pandas
• Streamlit
• scikit-learn
• Random Forest
• Business Intelligence
• Statistical Analysis
• KPI Development
• Regression
• Statsmodels
• Prophet

Projects

• ATM Transaction Analysis Dashboard
  Power BI

  Designed a multi-page executive dashboard covering 2,790 ATMs across 11 states, tracking transaction volume, revenue, operating cost, profitability, and uptime against a ₹296M total cost base. Built KPI-driven views and interactive filters to surface performance gaps and reduce time-to-insight.

• Trend Analysis of Global Airplane Accidents (2015–2025)
  Python, Machine Learning, Power BI, Streamlit

  Merged and cleaned 4 public aviation datasets into 2,596 accident records and 5,434 fatalities, trained predictive models, and built a Streamlit app to forecast accident trends through 2030.

• Retail Customer Churn & Decision Intelligence
  Python, SQL, Power BI

  Built an end-to-end retention analytics workflow on a 600K+ row retail dataset, applied churn scoring, and created a dashboard for revenue trend, fulfillment mix, and refund risk analysis.

Courses & certifications

• Exploring SAP Analytics Cloud · SAP Learning · 2026
• Data Visualisation for Business Insights · Tata X Forge

⚽ Extracurricular activities

• HOD — Decor Department, Ignite Club

  Led the Decor Department and coordinated creative planning and execution for college events and club activities.

📚 Publications

• Trend Analysis of Global Airplane Accidents Using Data Analytics · 2026