Ranu Soni

Data Analyst

4+ yrs exp 88 · Excellent

About

Data Analyst with 4 years of experience leveraging SQL, Python, Power BI, and Advanced Excel to deliver data-driven insights and business intelligence solutions. Experienced in data cleaning, transformation, data modeling, and dashboard development across retail and healthcare domains. Proven ability to analyze large datasets, develop KPIs, and improve business performance through actionable insights and stakeholder-focused reporting.

Skills & Expertise (17)

Python Advanced

8.5/10

Years Exp

SQL Advanced

8.5/10

Years Exp

Power BI Advanced

8.0/10

Years Exp

Advanced Excel Advanced

7.5/10

Years Exp

Pandas Advanced

7.5/10

Years Exp

NumPy Advanced

7.0/10

Years Exp

Dashboarding Advanced

7.0/10

Years Exp

Data Transformation Advanced

7.0/10

Years Exp

Data Cleaning Advanced

7.0/10

Years Exp

Exploratory data analysis Advanced

7.0/10

Years Exp

DAX Intermediate

6.5/10

Years Exp

Power Query Intermediate

6.5/10

Years Exp

Pivot Tables Intermediate

6.5/10

Years Exp

ETL Pipelines Intermediate

6.0/10

Years Exp

Advanced Functions Intermediate

6.0/10

Years Exp

VLOOKUP Intermediate

6.0/10

Years Exp

Data Modeling Intermediate

6.0/10

Years Exp

Work Experience

Associate Consultant

Infosys Ltd

Oct 2025 - Present

Analyzed 8.5K+ grocery sales records using SQL and Python to identify key revenue drivers across product categories, outlet sizes, and location tiers. Cleaned and transformed raw datasets, improving data quality and consistency by 25%. Developed key business KPIs including Total Sales, Average Sales, Item Volume, and Customer Ratings. Conducted segmentation analysis to identify high-performing product categories and Tier-3 market opportunities. Discovered Low Fat products contributing 60% of total sales, enabling targeted inventory optimization strategies. Designed and deployed interactive Power BI dashboards, supporting decision-making in inventory planning and outlet expansion.

Senior Systems Engineer

Infosys Ltd

Aug 2022 - Sep 2025

Examined 10,000+ patient records to identify key risk factors influencing heart disease. Performed EDA on 13+ clinical attributes including age, cholesterol, blood pressure, and heart rate. Identified critical risk indicators such as age (50+), gender, exercise-induced angina, and ST depression. Built Power BI dashboards to visualize patient segmentation and disease patterns. Delivered actionable insights that improved early risk detection and analysis efficiency by 30%.