Available for Opportunities

Turning Data into
Data Analyst|

// Analyst @ WM · MBA Business Analytics · 5+ years

I don't just build dashboards — I build understanding. Power BI, SQL, Python, and a relentless focus on what the data is actually trying to say. Let's turn your messy datasets into decisions.

📄 View My Work 📅 Schedule a Call

Years Exp.

50+

Dashboards Built

98%

Accuracy Rate

Monthly KPIs

↑ 34.2%

▲ vs last quarter

Data Accuracy

98.6%

Reconciliation ✓

ACTIVE QUERY

SELECT SUM(revenue)

FROM finance_data

📊 Junior Analyst @ WM

About Me

The Analyst Who Thinks Like a User

I'm Aditya Phegade — a data analyst with 5+ years across financial operations, business analytics, and customer-facing roles. I hold an MBA in Business Analytics and I build Power BI dashboards that leadership actually uses, reconcile AP/AR records across SAP and Oracle, and identify trends that help teams move faster.

What sets me apart? I've been on both sides of the data equation — waiting for the report and building it. That perspective shapes how I write queries, design dashboards, and present findings: always with the end user in mind.

📊

Power BI Dashboards

Real-time KPI monitoring used by senior leadership daily

🔍

Deep Reconciliation

AP/AR variance analysis across SAP & Oracle ERP

🐍

Python & SQL

Automating reports that used to take days, in minutes

🎓

MBA Analytics

Acropolis Institutions — Business Analyst & Marketing

⬇ Download Resume

Technical Skills

Tools of the Trade

A curated stack built through real-world financial analytics, BI development, and business operations.

Business Intelligence

Power BI & DAX

95%

DAXPower QueryM Language

Database

SQL & Databases

88%

SQL ServerOracle DBCTEs

Programming

Python

80%

PandasNumPyMatplotlib

Spreadsheet

Advanced Excel

92%

Pivot TablesVBAPower Query

ERP Systems

SAP & Oracle

85%

SAP FIOracle ERPAP/AR

Statistics

R & Tableau

75%

R StudioTableauggplot2

financial_analysis.sql

-- Monthly cash flow reconciliation WITH monthly_summary AS ( SELECT DATE_TRUNC('month', invoice_date) AS period, SUM(amount_due) AS total_payable, SUM(amount_paid) AS total_received, COUNT(DISTINCT vendor_id) AS vendors FROM ap_transactions WHERE status NOT IN ('VOID', 'DRAFT') GROUP BY 1 ) SELECT period, total_payable, total_received, ROUND(total_payable - total_received, 2) AS variance, ROUND(total_received/total_payable*100,1) AS collection_pct FROM monthly_summary ORDER BY period DESC; -- ✓ Executed in 0.043s — 24 rows

SQL Mastery

Query.
Analyse.
Decide.

🔍

Deep-Dive Reconciliation

Multi-source AP/AR analysis across SAP and Oracle with automated variance flagging.

📈

Trend & Risk Analysis

Billing cycle patterns, vendor behaviour anomalies, and receivables forecasting.

⚡

Performance Optimisation

CTEs, window functions, and query tuning to cut reporting time dramatically.

🛡

Audit-Ready Data

Compliance tracking across local and international regulatory standards.

Experience

Where I've Made Impact

Five years across financial analytics, content intelligence, and customer operations.

WM — Waste Management

Junior Analyst

June 2025 – Present · 11 months

Managed high-volume financial datasets across SAP & Oracle ERP for invoice processing, vendor payments, and AP/AR — ensuring audit-readiness and regulatory compliance.

Designed Power BI dashboards with DAX & Power Query for real-time cash flow monitoring, used by senior leadership daily.

Built integrated MIS reports by consolidating multi-source data — significantly reducing turnaround time for leadership reporting cycles.

Conducted deep-dive reconciliation on invoice & payment data, resolving vendor account mismatches and strengthening financial controls.

TaskUs

Content Moderator & Data Analyst

Sep 2024 – Apr 2025 · 8 months · Indore

Analysed 300+ items of high-volume UGC daily, detecting behavioural patterns and policy violations with 98%+ accuracy.

Produced weekly risk intelligence reports enabling proactive policy updates.

Refined classification frameworks using pattern analysis, reducing false positive rates measurably.

Fundsroom

Analyst Intern

May 2023 – Jul 2023 · 3 months · Pune

Leveraged analytics to improve DEMAT conversion rates and client acquisition efficiency.

Developed Excel & Power BI dashboards for application tracking, customer analysis, and performance reporting.

Performed market and competitor analysis to identify trends and optimisation opportunities.

Skyline Telesolutions Pvt. Ltd.

Customer Executive

Jan 2021 – Feb 2023 · 2 years 2 months · Indore

Handled escalated customer concerns with professionalism, ensuring retention and data-driven resolution tracking.

Gathered and organised operational data strategically with team leaders.

HGS — Hinduja Global Solutions

Customer Relations Officer

Jul 2019 – Jan 2020 · 7 months · Indore

Managed inbound & outbound collections calls, prepared regular performance reports and tracked payment agreements.

Credentials

Certifications & Education

📊

Business Intelligence Analyst

Certified · BI & Analytics

📈

Business Analytics & Data Mining

Data Analytics Certification

📐

Modelling Using R

Statistical Modelling · R Language

💻

Power BI Certification

Microsoft Power Platform

🎓

MBA — Business Analytics

Acropolis Institutions · 2022–2024

🏛

BCom — Computer Software

K.K. Vigyan Mahavidyalaya · 2019–2023

Turning Data into
Data Analyst|

The Analyst Who Thinks Like a User

Tools of the Trade

Query.
Analyse.
Decide.

Where I've Made Impact

Achievements in Data

Data Visualised

Tools I Work With

Certifications & Education

Turning Data intoData Analyst|

The Analyst Who Thinks Like a User

Tools of the Trade

Query.Analyse.Decide.

Where I've Made Impact

Achievements in Data

Data Visualised

Tools I Work With

Certifications & Education

Turning Data into
Data Analyst|

Query.
Analyse.
Decide.