Codebasics Logo

Powered by
Codebasics DA Bootcamp

Home

About

Projects

Experience

Contact

Hello, I am

Aswin Kumar

Data Analyst
Resume
Aswin Kumar

2

PowerBI
Projects

About

Me

I'm passionate about using data to drive smarter decisions and solve real-world business challenges. I love transforming raw data into insights, building dashboards, and optimizing reporting for efficiency.

With hands-on experience at Offshore Construction Associates, Re-volt Charging Inc, and KPMG, I’ve developed Power BI dashboards, automated data pipelines, and analyzed EV charging data from 100K+ sessions. My work led to a 20% reduction in reporting time, improved accuracy, and enhanced operations.

Skilled in Power BI, Tableau, SQL, Python, and Excel, I specialize in data visualization, statistical analysis, and process automation. Whether uncovering trends, streamlining workflows, or building predictive models, I make data-driven decisions accessible to stakeholders.

I’m seeking opportunities to create impact, improve decision-making, and contribute to innovative projects. Let’s connect and explore how data can make a difference!

Key

Skills

PowerBI

Tableau

Advanced Excel

SQL

Python

Pipedrive

PowerQuery

Dax

Hypothesis Testing

A/B Testing

My

Projects

Job market in United States in 2023
Job market in United States in 2023

Domain/Function: Tableau

Designed a Tableau dashboards to understand Job market in the United States in 2023. I made three dashboards to help WPI graduates explore jobs and salaries, guide CDC staff with industry info, and show a quick view of graduates' success. These dashboards help CDC plan better.

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain
Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: PowerBI

AtliQ Hardwares, a rapidly expanding consumer electronics company, seeks to enhance its competitive edge by transitioning from traditional Excel-based reporting to a sophisticated analytics solution using Power BI. The primary objective is to unlock actionable insights from their data

EV Station Analysis For USA
EV Station Analysis For USA

Domain/Function: PowerBI

Developed a Power BI dashboard analyzing 76.78K EV stations, revealing a sixfold growth since 2019 and ChargePoint’s 35.9K station dominance. Identified state-wise distribution, competitor presence, and connector trends to aid infrastructure planning.

My

Experience

AI & Business Intelligence Analyst Intern — Offshore Construction Associates, Boston:                             

Designed 24 Power BI dashboards and 35 ad hoc reports, integrating ETL pipelines to automate reporting, achieving a 20% reduction in manual reporting time

Implemented Pipedrive CRM for centralized project tracking, improving stakeholder access to real-time updates and enhancing project visibility by 40%

Automated data extraction using Python-based web scraping, capturing project-critical insights and minimizing data retrieval time by 30%

Enhanced SQL queries to streamline reporting, reducing query execution time by 30% and improving data accuracy for offshore operations

Data and Operations Analyst — Re-volt Charging Inc, Boston:                                                                         

Evaluated EV charging data from 100K+ sessions, identifying usage trends and optimizing station placement, increasing network efficiency by 20%

Engineered and implemented data pipelines integrating multi-source EV charging station data, reducing data processing time by 30%

Constructed a Power BI dashboard to analyze 76.78K EV stations, showing sixfold growth since 2019, achieving insights on state-wise distribution, competitor presence,

and connector types

for better infrastructure planning

Conducted exploratory data analysis on charging behavior, uncovering peak usage times, session durations, and user demographics to support expansion strategies

Developed interactive Power BI dashboards visualizing real-time network performance metrics, improving stakeholder decision-making and reducing downtime by 15%

Data Analyst — Worcester Polytechnic Institute, Worcester, MA                                                                    

Managed 10K+ student records using Excel (Pivot Tables, VLOOKUP), improving data clarity by 30% and ensuring 100% accuracy in academic reporting

Created 10+ Power BI dashboards, visualizing enrollment and performance trends, supporting data-driven decisions for 2,000+ students

Crafted Tableau dashboards to analyse the US job market, helping 2,000+ WPI graduates explore opportunities, achieving a 25% improvement in strategic planning

through interactive visualizations

 Revamped data retrieval workflows, reducing processing time by 25%, enabling faster academic insights and strategic planning

Business Analyst Intern — KPMG, India:                                                                                                        

 Examined financial data using Tableau, identifying key trends, achieving data-driven insights, and resulting in $500K in business decisions

Formulated KPI-driven visualizations, improving reporting efficiency by 20%, resulting in faster financial analysis for stakeholders

Strengthened data quality by implementing validation techniques, achieving 15% higher processing accuracy, resulting in more reliable financial reports