Back to Developers
Anjali Kolli

Anjali Kolli

Data Analyst

Rajahmundry, Andhra Pradesh $11/hr Remote Full-time 1+ yrs exp 89 · Excellent

About

Data Analyst with 1 year 9 months of experience at PwC India in US healthcare revenue cycle operations, working with structured datasets and operational reporting. Skilled in Power BI, SQL, Python, and Advanced Excel through hands-on analytics projects. Strong foundation in data analysis, data cleaning, and KPI reporting. Seeking a Data Analyst role to generate actionable insights and support data-driven decision-making.

Skills & Expertise (33)

Data Analysis Intermediate
7.1/10
1.75
Years Exp
Pivot Tables Intermediate
7.0/10
1.75
Years Exp
Data Cleaning Intermediate
6.9/10
1.75
Years Exp
Data Visualization Intermediate
6.8/10
1.75
Years Exp
Business Intelligence Intermediate
6.5/10
1.75
Years Exp
Gemini MS Office Suite Prompt Engineering Microsoft Copilot Data Analysis & Visualisation KPI Tracking Healthcare Analytics NumPy Pandas Trend Analysis DAX Slicers KPI Cards Dashboards Window Functions Subqueries Aggregations Joins Calculated Fields Dashboard Reporting Conditional Formatting HLOOKUP VLOOKUP Dashboard Development MIS Reporting Operational Reporting KPI Analysis Data Validation

Work Experience

Specialist

PwC Bangalore India

Jun 2024 - Mar 2026

Managed and updated insurance claim tracking data in Excel for 30-35 accounts daily, performing data validation checks to ensure accuracy and consistency - maintaining 95%+ quality SLA from day one. Leveraged Excel (Pivot Tables, VLOOKUP, filters, conditional formatting) to track claim status, identify denial patterns, and perform ad hoc analysis on claim trends and generate operational reports for internal review. Monitored KPIs including claim resolution time, denial rate, and follow-up cycle status; performed root cause analysis on recurring claim denials to support faster resolution and reduce repeat errors. Contributed to resolving 2,500+ weekly claim follow-ups within 2 days against a 5-day SLA as part of a 55-member team. Prepared MIS reports and maintained an MIS dashboard and operational reporting summaries in Excel for internal stakeholders, enabling data-driven tracking of claim resolution and efficiency. Documented data workflows, reporting logic, and SOPs to standardize processes and support team onboarding. Coordinated with US-based client stakeholders (Advent Health) to ensure timely claim resolution, flag data discrepancies, and reduce processing delays.

Education

Bachelor of Science (MPCS) - Aditya Degree College for Women

2021 - 2024 · India

Intermediate (12th Grade) - Sasi Junior College

2019 - 2021 · India

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 9/15
💰 Rate 5/5
🏆 Certs 0/5
Verified 5/5
Total Score 89/100

Profile Overview

Member sinceApr 2026
Work ModeRemote
AvailabilityFull-time