Back to Developers
Aayush Chavan

Aayush Chavan

Data Analyst

Hyderabad, India 3+ yrs exp 86 ยท Excellent

About

Data Analyst with 2+ years of experience across data analysis, reporting, business intelligence and data processing, backed by an MSc in Advanced Computer Science. Hands-on experience using SQL, Excel, Power BI, Power Query, Python and SSIS to analyse multi-source datasets, build KPI dashboards, automate reporting and improve data quality. Skilled in translating business requirements into analytical solutions, investigating trends and discrepancies, and communicating actionable insights to technical and non-technical stakeholders.

Skills & Expertise (53)

Power BI Intermediate
7.5/10
2
Years Exp
SQL querying Intermediate
7.5/10
2
Years Exp
Excel Intermediate
7.0/10
2
Years Exp
KPI Reporting Intermediate
7.0/10
2
Years Exp
Data Cleaning Intermediate
7.0/10
2
Years Exp
ETL Intermediate
6.5/10
2
Years Exp
Python Intermediate
6.5/10
2
Years Exp
Forecasting Intermediate
6.0/10
2
Years Exp
SSIS BigQuery NumPy MySql Pandas Postgresql Git GeoPandas Folium Time-Series Analysis LSTM Stakeholder Management MSE RMSE MAE Rยฒ ARIMA Prophet SPSS A/B testing Data Governance Documentation Data Modelling Trend Analysis KPI Analysis Performance Analysis Root-cause analysis Variance Analysis Ad-hoc Analysis Data Extraction Data Transformation Data Validation Data Reconciliation Data Quality Decision Support DAX Power Query Tableau Dashboard Development Management reporting Data visualisation Requirements Gathering Exploratory analysis Process Analysis Process Improvement

Work Experience

Freelance Data & Business Analyst

Independent

Feb 2025 - Present

Deliver end-to-end data and business analysis assignments covering problem definition, requirements gathering, data preparation, analysis, visualisation and recommendations. Analyse large and multi-source datasets using SQL, Python and Excel to identify trends, anomalies, performance changes and areas requiring investigation. Clean, transform and validate datasets using Python, Power Query and Excel to improve data quality and analytical reliability. Develop interactive Power BI dashboards to monitor KPIs, performance metrics and business trends. Built reusable reporting workflows that reduced manual reporting requirements by approximately 30%. Translate stakeholder questions into measurable analytical requirements and relevant KPIs. Conduct exploratory and root-cause analysis; perform reconciliation and validation checks before presenting analytical outputs. Present findings, implications and recommendations to non-technical stakeholders through structured reports and presentations.

Business & Reporting Data Analyst

Smallcap Network

Mar 2024 - Dec 2024

Analysed business datasets and performance KPIs to support management decision-making and performance monitoring. Consolidated and reconciled data from 50+ datasets, identifying missing information, inconsistencies and data-quality issues. Developed interactive Power BI dashboards combining multiple data sources for business performance reporting. Used SQL, Excel and Power Query to extract, transform, clean and structure datasets for analysis. Automated recurring reporting processes, reducing manual reporting effort by approximately 15%. Developed KPI reporting structures and conducted ad-hoc analysis in response to stakeholder and management questions. Investigated unexpected performance changes through root-cause analysis and performed data cleansing, validation and reconciliation. Worked with stakeholders to understand reporting requirements and prepared management-ready reports highlighting key findings and areas requiring action.

Data Processing & Analytics Intern

OSG Analytics

Oct 2022 - Jul 2023

Processed and analysed large datasets using SQL, Excel and SSIS, supporting data preparation and reporting activities. Performed data extraction, transformation, cleansing, validation and reconciliation across business datasets. Developed and maintained Power BI dashboards for reporting and performance monitoring. Wrote SQL queries to retrieve, manipulate and validate business data and investigated data-quality issues before reporting. Supported ETL workflows using SSIS and maintained analytical documentation and reporting records. Conducted quantitative and exploratory analysis using Python, Excel and SPSS to identify trends and relationships. Worked with stakeholders to understand analytical requirements and deliver outputs within agreed timelines.

Education

MSc Advanced Computer Science - University of Liverpool

- ยท Afghanistan

B.E. Computer Engineering - Bharati Vidyapeeth College of Engineering, Lavale

- ยท 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 11/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 86/100

Profile Overview

Member sinceOct 2026

Availability Details

Relocation

Open to Relocation