AMAN SINGH NEGI
Uttarakhand, India |-| - | LinkedIn | GitHub
EDUCATION
Degree
Institute / Board
CGPA / Percentage
Year
B-Tech
Senior Secondary
Secondary
Chandigarh University
CBSE
CBSE
8.12
92.8 %
9.6
-
PROJECTS
1. New York Motor Vehicle Collision Analysis| G-Drive
Technologies: Microsoft Excel (Power Query, Pivot Tables, Charts, Dashboards)
•
•
•
Designed and deployed 2 interactive dashboards that displayed key metrics such as Total Collisions, Risky
Time, Total Injuries, etc, aiding data-backed decisions for urban traffic safety improvements.
Performed data cleaning and transformation using Excel’s Power Query to handle missing values,
inconsistent entries, and formatting issues.
Analyzed over 2 lakh+ motor vehicle collision records from NYC, uncovering that Brooklyn accounted for
27% of total accidents, with peak incidents occurring between 3 PM – 6 PM, alongside other significant data
insights
2. Sales Analysis | GitHub | Tableau-Public
Technologies: [Excel, Tableau]
• Created a Tableau dashboard to visualize sales performance across 4 major regions and 15 product
categories, enabling data-driven decision-making and performance tracking.
• Developed advanced filters and data visualizations that reduced report generation time by 25%,
enhancing operational efficiency and supporting faster business decision-making.
• Delivered actionable insights pinpointing 2 underperforming regions, enabling targeted marketing
campaigns that boosted sales by an estimated 8% within 3 months.
3. Medical-Clinics_HeathCare-PowerBI-Dashboard | GitHub
Technologies: [Excel, Power BI]
• Developed a comprehensive Power BI dashboard analyzing over 15,000 patient records from 6
departments to identify trends in treatment outcomes, cost allocation, and readmission rates.
• Visualized demographic trends revealing that patients aged 60+ contributed to 35% of total
treatment costs.
• Optimized report performance by reducing data load time by ~40% using Power Query
transformations and efficient DAX calculations.
SKILLS
•
•
•
Language & Database: Python, SQL, MySQL, PostgreSQL
Visualization Tools: Excel Charts, Power BI, Tableau, Google Colab
Other Skills: Analytical Thinking, Communication, Negotiation, Team Building, Continuous Learning
ACHIEVEMENTS
● Google HashCode Farewell Round A - Global Rank (2007) [Link]
● Google HashCode Farewell Round B - Global Rank (753) [Link]
● Achieved a top 8% ranking among 1.1 million candidates in the JEE
● Participated in MAKEATHON5 [Link]
