Back to Developers
Divyanshi Hirani

Divyanshi Hirani

Data Analyst

Lucknow, India 1+ yrs exp 84 · Excellent

About

Data Analyst with 2 years of end-to-end production experience building data pipelines, business intelligence dashboards, and automated reporting systems. Designed 12+ Tableau and Looker Studio dashboards adopted by senior leadership for real-time institutional monitoring; engineered ETL workflows that eliminated 40% of manual reporting overhead. Proficient across the full analytics stack — SQL, Python, data visualization, and statistical analysis. Strong cross-functional collaborator with a track record of translating ambiguous business questions into actionable data insights across academic, finance, and operational domains. Currently completing a Machine Learning and Generative AI certification at IIT Kanpur.

Skills & Expertise (43)

SQL Intermediate
8.2/10
2
Years Exp
Python Intermediate
8.0/10
2
Years Exp
Tableau Intermediate
7.8/10
2
Years Exp
Pandas Intermediate
7.6/10
2
Years Exp
Data Pipeline Development Intermediate
7.6/10
2
Years Exp
A/B testing Data Storytelling Hypothesis Testing Data Cleaning Data Governance Root Cause Analysis MIS Reporting Trend Analysis Linear Regression Logistic Regression Decision Tree Random Forest KNN PCA K-Means Hierarchical Clustering Stakeholder Management Cross-Functional Collaboration Requirements Gathering Dashboard Development NumPy Matplotlib Seaborn scikit-learn MS Excel Pivot Tables VLOOKUP XLOOKUP Looker Studio Statistical Analysis KPI Tracking Complex Joins Subqueries Window Functions Aggregations ETL Pipelines Data Transformation EDA

Work Experience

Data Analyst & ERP Executive

City Montessori School (CMS)

Sep 2023 - Jun 2025

Delivered 12 business intelligence dashboards used daily by senior leadership: Designed and deployed Tableau and Looker Studio dashboards providing real-time visibility into academic performance, attendance trends, and fee collection — replacing ad-hoc spreadsheet reporting across 3 departments. Reduced manual reporting overhead by 40% through data pipeline automation: Engineered Python and SQL data pipelines to automate recurring extraction, transformation, and visualization workflows — compressing weekly report cycle time and enabling same-day insight delivery to cross-functional stakeholders. Maintained 100% data accuracy across institutional-wide ERP data: Designed and enforced a data governance framework — null checks, range validations, cross-table consistency rules — across all student records, attendance, and finance datasets with zero quality escalations over 21 months. Delivered weekly MIS reports that directly shaped academic planning decisions: Applied statistical analysis using Python (Pandas) and Excel to surface attendance risk flags and performance anomalies; findings informed intervention decisions for at-risk student cohorts across departments. Authored production-grade SQL for multi-table ERP data pipelines: Wrote complex queries — multi-level JOINs, correlated subqueries, window functions, aggregation pipelines — supporting student records, attendance, and finance reporting with zero production failures. Led cross-functional stakeholder management across 3 departments: Partnered with academic, finance, and administrative stakeholders to gather data requirements, resolve discrepancies, and deliver business intelligence outputs aligned to institutional goals.

Education

Generative AI & Machine Learning (Certification — In Progress) - IIT Kanpur

2026 - 2026 · Afghanistan

Bachelor of Commerce (B.Com) - Awadh Girl's Degree College, University of Lucknow

2019 - 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 20/20
🎓 Education 10/10
⏱️ Experience 9/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 84/100

Profile Overview

Member sinceMay 2026

Availability Details

Visa Status

Need Sponsorship

Relocation

Open to Relocation