Data Analyst with 3.2 Years of Experience

VIKAS JAGADALE

Data Analyst

Phone: +91-892******* Email: ****************@*****.*** Pune, Maharashtra Linkedin github

PROFESSIONAL SUMMARY

Data Analyst with 3.2 years of experience in collecting, cleaning, analyzing, and visualizing large datasets to support data-driven business decisions. Strong expertise in Python, SQL, Excel, and Power BI, including advanced SQL concepts (CTEs, window functions) and dashboard development using DAX. Proven ability to translate business requirements into actionable insights, automate reporting workflows, and collaborate with cross-functional stakeholders to improve operational efficiency and KPI tracking.

TECHNICAL SKILLS

Databases & SQL:

SQL, MySQL, relational databases, joins, subqueries, CTEs, window functions, view

,Aggregate functions (SUM, COUNT, AVG, MIN, MAX),CASE WHEN expressions, views Programming & Analysis:

Python (Pandas, NumPy, Matplotlib, Seaborn), OOP concepts, data logic Business Intelligence & Visualization:

Power BI (interactive dashboards, DAX measures, KPI tracking, data modeling) Advanced Excel:

Pivot Tables, VLOOKUP, INDEX-MATCH, Power Query, formulas, conditional formatting Data Engineering & Cleaning:

ETL (Extract, Transform, Load), data validation, missing value treatment, data accuracy Business & Reporting Skills:

KPI analysis, stakeholder communication, ad-hoc analysis, reporting & presentations EXPERIENCE

Data Analyst

Mphasis 3.2Years JAN2023-FEB2026

● Designed and executed complex SQL queries (joins, subqueries, CTEs, window functions) to extract, transform, and validate data from relational databases.

● Analyzed and processed 500K+ structured records using Python (Pandas, NumPy) and Excel to identify business trends, patterns, and performance gaps.

● Developed interactive Power BI dashboards using DAX and data modeling to monitor KPIs, operational metrics, and business performance.

● Automated recurring reports and data pipelines, reducing manual effort by 40% and improving data accuracy and turnaround time.

● Supported weekly and ad-hoc reporting for 10+ business and operations stakeholders to understand business requirements and deliver insight-driven solutions.

● Performed ad-hoc analysis to answer stakeholder queries and support decision-making processes.

● Utilized Advanced Excel (Pivot Tables, Power Query, VLOOKUP, formulas) for detailed reporting and analysis.

Business Impact:

● Improved reporting efficiency by 40% through automation and optimized workflows

● Reduced data inconsistencies by 30% via improved validation and ETL processes

● Enabled leadership to track 10+ KPIs in real time, improving visibility and operational decision support

PROJECTS

Telco Customer Churn Analysis ( SQL Python EDA) Link

● Led data extraction, transformation, and aggregation using advanced SQL

(multi-table joins, CTEs, subqueries, window functions)

● Conducted end-to-end data cleaning, preprocessing, and exploratory data analysis on a customer churn dataset.

● Handled missing values, encoded categorical variables, and normalized data using Pandas and NumPy.

● Built EDA visualizations using Matplotlib and Seaborn to identify churn patterns and customer behavior trends.

● Created correlation matrices and statistical insights to identify key churn drivers impacting retention.

● Designed and implemented an ETL pipeline to automate data preparation and reporting. Outcome:

● Automated reporting for 100K+ customer records

● Reduced manual analysis effort by 50%

● Provided actionable insights to support customer retention strategies Sales Performance & KPI Dashboard (Power BI SQL Excel) Link

● Applied SQL DDL and DML operations to create, modify, and manage sales tables, implemented constraints (PRIMARY KEY, FOREIGN KEY, NOT NULL, UNIQUE) to ensure data integrity.

● Analyzed 12 months of sales and revenue data to track monthly, quarterly, and product-level performance trends.

● Built Power BI dashboards with DAX measures to monitor KPIs such as revenue growth, conversion rate, and regional performance.

● Used SQL queries to aggregate and validate sales data from multiple sources. Outcome:

● Enabled leadership to track KPIs in real time

● Improved visibility into sales performance and trend analysis SOFT SKILLS

● Problem solving skill and solution oriented

● Strong analytical thinking ability and Business Analysis

● Critical thinking mindset and Growth mindset

● Effective stakeholder communication

● Attention to detail and data accuracy

● Data-driven storytelling skills

● Team collaboration

● Time management and prioritization

EDUCATION

Bachelor of Engineering (Computer Science) - University of Pune CERTIFICATION:DATA ANALYSIS CERTIFICATION Link

PORTFOLIO

Data analysis,Excel,SQL and PowerBI projects

Portfolio Link : https://github.com/vikasjagadale123/Portfolio

Contact this candidate