Vedanti madane

Data Analyst

Mumbai, India 2+ yrs exp 85 · Excellent

About

Data Analyst with ~3 years of experience in SQL, Python, and Power BI specializing in data cleaning, exploratory data analysis (EDA), and KPI reporting. Proven track record of analyzing 100K+ datasets, building dashboards, and generating actionable insights to improve marketing ROI and business performance by 10-15%. Experienced in ETL processes, statistical analysis, and business intelligence.

Skills & Expertise (28)

SQL Advanced

8.0/10

Years Exp

Excel Advanced

8.0/10

Years Exp

Power BI Intermediate

7.8/10

Years Exp

Python Intermediate

7.6/10

Years Exp

Pandas Intermediate

7.6/10

Years Exp

MySql Intermediate

7.6/10

Years Exp

Data Cleaning Intermediate

7.4/10

Years Exp

Jupyter Notebook Intermediate

7.0/10

Years Exp

KPI Tracking Intermediate

7.0/10

Years Exp

VS Code Intermediate

7.0/10

Years Exp

NumPy Intermediate

7.0/10

Years Exp

Statistical Analysis Intermediate

6.8/10

Years Exp

Matplotlib Intermediate

6.8/10

Years Exp

scikit-learn Intermediate

6.0/10

Years Exp

SQLite Intermediate

6.0/10

Years Exp

Git Intermediate

6.0/10

Years Exp

ETL Intermediate

6.0/10

Years Exp

KPI Analytics Intermediate

6.0/10

Years Exp

Business Intelligence Intermediate

6.0/10

Years Exp

Looker Beginner

5.0/10

Years Exp

ChatGPT Beginner

5.0/10

Years Exp

Databricks Beginner

5.0/10

Years Exp

Data Modeling Beginner

5.0/10

Years Exp

Data Warehousing Beginner

5.0/10

Years Exp

Orange Beginner

4.0/10

Years Exp

Claude Beginner

4.0/10

Years Exp

Gemini Beginner

4.0/10

Years Exp

EDA

Work Experience

Data Analyst

Petuk ji India Pvt. Ltd.

Jan 2021 - Feb 2022

Used SQL to extract; pandas to clean and analyze 100K+ campaign datasets, improving campaign effectiveness by 20%. Analyzed marketing campaign performance using Power BI dashboards, increasing ROI by 15%. Performed data cleaning, transformation, and validation to ensure data accuracy and reliability. Leveraged SQL queries for filtering and matplotlib for visualization to continuously track campaign performance, identify trends, and generate data-driven recommendations for campaign optimization. Built product-level KPI dashboards in Power BI to track revenue trends and identify growth opportunities. Analyzed website traffic and SEO performance metrics using pandas, derived actionable insights which increased organic traffic by 10%. Utilized Numpy and Pandas on social media datasets (Instagram, LinkedIn, Facebook) to perform audience segmentation, analyze user behavior, and measure campaign effectiveness.

Data Analyst / Marketing Analytics Specialist

HDB Finance Services

Feb 2020 - Dec 2020

Managed and analyzed 50K+ datasets in Excel using (Pivot Tables, Macros, advanced formulas) to identify business trends. Developed automated Excel dashboards to track KPIs and support real-time business decision-making. Collaborated with cross-functional teams to gather data requirements and deliver actionable insights. Used SQL queries and Excel to analyze customer transaction data and identify cross-selling opportunities, improving targeting effectiveness of cross sell campaigns by 15%. Extracted, cleaned, and transformed CRM data using SQL to improve data quality and lead generation efficiency and improved month on month sales performance. Performed lead conversion analysis using SQL (JOINs, GROUP BY, filtering) and visualized insights in Excel dashboards for digital products like SmartPay and PayZapp, driving improved user adoption and engagement.