Back to Developers
Sonali Gupta

Sonali Gupta

Projects & Reporting Analyst

2+ yrs exp 75 · Very Good

About

No bio added yet

Skills & Expertise (23)

Microsoft Excel Advanced
8.5/10
2
Years Exp
Microsoft Power BI Advanced
8.5/10
2
Years Exp
Dashboards & Reporting Advanced
8.5/10
2
Years Exp
Google Sheets Advanced
8.0/10
2
Years Exp
Data Cleaning Advanced
8.0/10
2
Years Exp
Data Validation Advanced
8.0/10
2
Years Exp
Data Reporting Advanced
8.0/10
2
Years Exp
Data Management Advanced
8.0/10
2
Years Exp
Data Visualization Advanced
8.0/10
2
Years Exp
PowerQuery Intermediate
7.5/10
2
Years Exp
Data Extraction Advanced
7.5/10
2
Years Exp
Power Query Intermediate
7.5/10
2
Years Exp
Looker Studio Intermediate
7.0/10
2
Years Exp
DAX Intermediate
6.0/10
2
Years Exp
ETL Processes Intermediate
6.0/10
2
Years Exp
Data Modelling Intermediate
6.0/10
2
Years Exp
MySql Intermediate
6.0/10
2
Years Exp
Python Intermediate
5.5/10
2
Years Exp
SQL Server Intermediate
5.5/10
2
Years Exp
Darwinbox Intermediate
5.0/10
1
Years Exp
DAX Studio Intermediate
5.0/10
1
Years Exp
Databricks Beginner
4.0/10
1
Years Exp
MS Office Suite

Work Experience

Projects & Reporting Analyst

Vensysco Technologies Limited

Apr 2025 - Present

Managed data preparation, validation, consolidation, and backup for FY 2024-25 and FY 2025 exam and operations projects, handling 16,000+ records, 50+ files, and 70+ project sheets, ensuring audit-ready and error-free reporting. Built and maintained standardized master sheets, payment trackers, cost compilations, and result files using advanced Excel and Google Sheets formulas (SUMIFS, SUBTOTAL, Pivot Tables, QUERY, IMPORTRANGE), reducing manual effort by 80%. Developed Power BI dashboards for attendance FY 2025-26, identifying trends, data gaps, efficiency insights, and critical KPIs. Published Looker dashboards for operational analysis across multiple exam cycles and government projects (Ghaziabad Nagar Nigam, Railway Recruitment Cell, SSC) during FY 2025–26, continuously creating and analyzing rolling 1-3 month datasets per exam cycle to enable live tracking, trend analysis, data gap identification, and KPI monitoring. Produced structured outputs, documentation, and consolidated reports while coordinating with cross-functional teams to resolve discrepancies and support smooth project execution.

HR Analyst

Manjushree Technopack Limited

Sep 2023 - Oct 2024

Designed and developed dashboards in Power BI to analyze datasets of 10,000+ employee records, providing actionable insights that improved decision-making across 25 plants. Collaborated with cross-functional teams to ensure data accuracy, achieving 100% consistency and relevance across locations. Generated 20+ HR reports using Excel (Pivot Table, VLOOKUP) to analyze attrition, retention, and hiring trends. Planned HR analytics using tools like Darwinbox and Bluetree, increasing efficiency by 20%. Created employee dashboard in Power BI for FY2023-FY2024, delivering actionable insights for data-driven decisions.

Education

Bachelor of Engineering in Information Technology (Honours) - Institute of Technology & Management

- · Afghanistan

Certifications

No certifications added yet

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 10/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 75/100

Profile Overview

Member sinceJun 2026