Back to Developers
Amol Singhal

Amol Singhal

Data Analyst

Ghaziabad, India 0+ yrs exp 86 · Excellent

About

Data Analyst and final-year B.Tech Computer Science (Data Science) student with hands-on experience in Power BI, DAX, SQL, and Python, delivering data cleaning, modeling, and KPI dashboards that reduced reporting time by 20–25%. Built live government infrastructure at NCRTC for one of India's largest public transport rollouts and developed a real-time national AQI tracker. Proficient in end-to-end data product development from raw data pipelines to interactive stakeholder dashboards with a focus on turning raw data into actionable decisions.

Skills & Expertise (25)

Microsoft Excel Advanced
7.0/10
1
Years Exp
Power BI Intermediate
6.7/10
1
Years Exp
DAX formulas Intermediate
6.5/10
1
Years Exp
SQL Intermediate
6.5/10
1
Years Exp
Data Cleaning Intermediate
6.5/10
1
Years Exp
Data Transformation Intermediate
6.5/10
1
Years Exp
Power Query Intermediate
6.5/10
1
Years Exp
Figma Intermediate
5.5/10
1
Years Exp
Data Storytelling Intermediate
5.5/10
1
Years Exp
Predictive Analytics Intermediate
5.5/10
1
Years Exp
Adobe Photoshop Intermediate
5.0/10
1
Years Exp
Python Intermediate
5.0/10
1
Years Exp
Adobe After Effects Beginner
4.5/10
1
Years Exp
Rest API Beginner
4.5/10
1
Years Exp
Gemini AI Beginner
3.5/10
1
Years Exp
Generative AI Beginner
3.5/10
1
Years Exp
AI-Assisted Analysis Beginner
3.5/10
1
Years Exp
VBA Pivot Tables Excel formulas IBM Cloud Statistical Analysis MySql KPI Dashboards Tableau

Work Experience

IT Intern Data Analytics

National Capital Region Transport Corporation (NCRTC)

Sep 2025 - Nov 2025

Built KPI dashboards in Power BI with advanced DAX formulas to monitor real-time operational metrics across the PM-eBus Sewa national fleet program, enabling ministry-level reporting. Cut dashboard generation and manual reporting time by 20–25% through automated Excel pipelines (macros, Power Query) and optimised SQL queries. Collaborated with Sr. GM/IT to redesign Power BI report layouts, significantly improving stakeholder visibility into fleet KPIs and aligning deliverables with project requirements. Performed data modeling and statistical analysis on multi-source operational data, surfacing actionable insights for bus deployment strategy under the PM-eBus Sewa program.

Web Design Intern

Internship Studio

Sep 2024 - Oct 2024

Applied Excel pivot table analysis to user flow data, identifying drop-off points that directly shaped layout and checkout redesign decisions, grounding every design choice in user behaviour. Developed a fully functional eCommerce website with responsive product pages and checkout flow, improving the company's digital presence and online sales capability. Crafted wireframes and high-fidelity mockups in Adobe Photoshop in collaboration with senior designers, ensuring brand consistency throughout the development process.

UI/UX Intern

Zidio

Apr 2024 - Jul 2024

Designed a data-driven weather analysis app in Figma, improving user comprehension of forecast data by 40% during usability testing through clear, intuitive visualisations. Incorporated sprint-by-sprint user feedback in an Agile workflow, reducing total design revision cycles and delivering a refined, production-ready prototype. Built a reusable component library following WCAG accessibility standards, cutting developer handoff time and ensuring consistent interfaces across all user interactions. Produced user-flow diagrams in Figma and Miro, documenting the full design process and facilitating a smooth handoff to developers, shortening the implementation timeline.

Education

B.Tech, Computer Science (Data Science Specialization) - ABESIT

2022 - 2026 · Afghanistan

High School - Ryan International School

- 2022 · Afghanistan

Certifications

Generative AI Hack2Skill

Google Cloud · 2025

Excel Data Analysis

Udemy · 2025

Cloud Computing

IBM / PBEL Virtual Internship equivalent · 2025

Graphic Designing

EDUCBA · 2025

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

Profile Overview

Member sinceJun 2026

Availability Details

Visa Status

Citizen

Relocation

Depends on Offer