Prachi P

Junior Data Analyst

Mumbai, India 1+ yrs exp 88 · Excellent

About

Junior Data Analyst with 1+ year of enterprise experience at Capgemini collecting, cleaning, and analysing large datasets to generate actionable business insights. Proficient in SQL, Python, Power BI, and Advanced Excel for data extraction, visualisation, and reporting. Experienced in writing SQL queries, validating data accuracy, creating dashboards, and preparing weekly and monthly business reports for cross-functional stakeholders. Holds Microsoft PL-300 and Oracle SQL certifications. Detail-oriented, analytical, and comfortable working independently in remote environments with minimal supervision.

Skills & Expertise (63)

Python Intermediate

7.5/10

Years Exp

Power BI Intermediate

7.5/10

Years Exp

SQL Intermediate

7.5/10

Years Exp

Report Development Intermediate

7.0/10

Years Exp

Dashboards Intermediate

7.0/10

Years Exp

Power Query Intermediate

7.0/10

Years Exp

Advanced DAX Intermediate

7.0/10

Years Exp

Advanced Excel Intermediate

6.5/10

Years Exp

Power Pivot Intermediate

6.5/10

Years Exp

Time intelligence Intermediate

6.5/10

Years Exp

Power BI Service Deployment Intermediate

6.5/10

Years Exp

Scheduled Refresh Intermediate

6.5/10

Years Exp

Row-Level Security Intermediate

6.5/10

Years Exp

SQL Queries Intermediate

6.5/10

Years Exp

Joins Intermediate

6.5/10

Years Exp

VLOOKUP Intermediate

6.5/10

Years Exp

PivotTables Intermediate

6.5/10

Years Exp

Data Profiling Intermediate

6.0/10

Years Exp

Reporting Automation Intermediate

6.0/10

Years Exp

Data Cleaning Intermediate

6.0/10

Years Exp

Visual Design Intermediate

6.0/10

Years Exp

Aggregations Intermediate

6.0/10

Years Exp

Tableau Intermediate

6.0/10

Years Exp

Descriptive analysis Intermediate

6.0/10

Years Exp

Statistical Analysis Intermediate

6.0/10

Years Exp

Stored Procedures Intermediate

6.0/10

Years Exp

Data Manipulation Intermediate

6.0/10

Years Exp

Azure SQL Intermediate

6.0/10

Years Exp

Oracle SQL Intermediate

6.0/10

Years Exp

Star Schema Intermediate

5.5/10

Years Exp

Snowflake Schema Intermediate

5.5/10

Years Exp

KPI Definitions Intermediate

5.5/10

Years Exp

Fact Tables Intermediate

5.5/10

Years Exp

Dimension Tables Intermediate

5.5/10

Years Exp

Relationships Intermediate

5.5/10

Years Exp

Dimensional Modelling Intermediate

5.5/10

Years Exp

ETL Pipelines Intermediate

5.5/10

Years Exp

validation Intermediate

5.5/10

Years Exp

EDA Intermediate

5.5/10

Years Exp

ETL Pipeline Development Intermediate

5.5/10

Years Exp

NumPy Intermediate

5.5/10

Years Exp

Pandas Intermediate

5.5/10

Years Exp

Qlik Sense Beginner

4.5/10

Advanced Formulas Trend Identification Pattern Identification Logical thinking Analytical Problem-Solving Business insight generation Data retrieval KPI Dashboards Drill-through XLOOKUP Charts Data Validation Dynamic Dashboards Google Sheets Data Transformation Stakeholder presentations Release Notes Anomaly Detection Data Cleansing integrity checks

Work Experience

Junior Data Analyst — BI Developer

Capgemini

Nov 2024 - Present

Collected, cleaned, and organised clinical and operational data from multiple sources using SQL and Python; maintained data integrity and accuracy across all reporting pipelines. Wrote SQL queries to retrieve and manipulate large datasets; applied joins, CTEs, aggregations, and window functions to support ad hoc and scheduled analysis requests. Created Power BI dashboards, KPI scorecards, and visualisations tracking patient volume and operational metrics; prepared weekly and monthly business reports for senior stakeholders. Validated data accuracy against source systems maintaining 98%+ accuracy; identified anomalies and documented findings before stakeholder release. Collaborated with cross-functional teams to understand business requirements; translated needs into analytical deliverables independently and on schedule. Automated reporting workflows using Python and Power Query; configured scheduled refresh across 5 Power BI workspaces to ensure timely, consistent data delivery.