Shivangi Upadhyay

Data Analyst

Indore, India 1+ yrs exp 77 · Very Good

About

No bio added yet

Skills & Expertise (29)

Data Validation Intermediate

7.5/10

Years Exp

Python Intermediate

7.5/10

Years Exp

Advanced Excel Intermediate

7.5/10

Years Exp

Power BI Intermediate

7.5/10

Years Exp

Pandas Intermediate

7.5/10

Years Exp

Data Cleaning Intermediate

7.5/10

Years Exp

Data Transformation Intermediate

7.5/10

Years Exp

Power Query Intermediate

7.0/10

Years Exp

SQL Intermediate

7.0/10

Years Exp

If Intermediate

7.0/10

Years Exp

SUMIFS Intermediate

7.0/10

Years Exp

VLOOKUP Intermediate

7.0/10

Years Exp

PivotTables Intermediate

7.0/10

Years Exp

Exploratory data analysis Intermediate

7.0/10

Years Exp

Dashboard Development Intermediate

7.0/10

Years Exp

NumPy Intermediate

7.0/10

Years Exp

KPI Tracking Intermediate

7.0/10

Years Exp

Data Extraction Intermediate

7.0/10

Years Exp

Business Reporting Intermediate

7.0/10

Years Exp

Matplotlib Intermediate

6.5/10

Years Exp

Statistical Analysis Intermediate

6.5/10

Years Exp

DAX Intermediate

6.5/10

Years Exp

Tableau Intermediate

6.5/10

Years Exp

Aggregations Intermediate

6.5/10

Years Exp

Joins Intermediate

6.5/10

Years Exp

MySql Intermediate

6.5/10

Years Exp

Seaborn Intermediate

6.0/10

Years Exp

Data Modeling Intermediate

6.0/10

Years Exp

Subqueries Intermediate

6.0/10

Years Exp

Work Experience

Data Analyst

Nath Outsourcing Solutions Pvt. Ltd.

Oct 2025 - Present

Sole data analyst on the team; owned end-to-end delivery of 5–6 recurring reports per month — 60+ reporting cycles across 12 months — supporting US healthcare RCM operations. Translated requirements from operations managers into structured datasets and reporting outputs used to monitor performance, track metrics and surface discrepancies. Delivered every assigned analytical task within defined reporting timelines, owning accuracy and consistency of all deliverables. Cut manual data preparation effort 10–15% by streamlining repetitive cleaning, validation and transformation using Excel, SQL and Python (Pandas). Wrote SQL queries — joins, aggregations, filters — to extract, reconcile and validate datasets of thousands of records per reporting cycle. Standardized preparation and validation into a repeatable process, improving turnaround and cycle-to-cycle consistency of recurring reports. Built validation checks catching missing values, duplicate records, inconsistent formats and source-to-report mismatches before publication. Cut the risk of reporting errors reaching stakeholders, raising the reliability of recurring business reports. Reduced repetitive data-checking effort across the team through upfront quality control. Contributed to 2–3 Power BI dashboards — datasets, visuals and DAX measures — used by operations teams to track KPIs and business trends. Maintained data models and refreshed underlying datasets, keeping dashboards current for monthly business reporting. Presented findings to internal stakeholders, converting raw operational data into decision-ready insight.

Data Annotation Intern

Smarg Technologies Pvt. Ltd.

Jul 2025 - Sep 2025

Annotated assigned datasets for model training and evaluation workflows, holding to project guidelines for accuracy and consistency. Reviewed assigned work against defined quality standards, ensuring processed data met project requirements before handoff. Supported Python scripts for data processing and basic analytical tasks; collaborated across the team on deliverables and workflow.