Aanchal Gupta
Professional Mentor@aanchal
Senior Data Analyst | Power BI | SQL | Python | Tableau | ETL | Data Visualization | 4+ Years Experience
Data Analyst · Medi AssistBengaluru, Karnataka, India
- followers
- 4
Services
2About
Data Analyst with 4+ years of experience in Business Intelligence, Data Analytics, and Dashboard Development across healthcare, insurance, finance, and energy domains. Skilled in SQL, Power BI, Python, Tableau, Excel, DAX, ETL, and data modeling. Experienced in designing interactive dashboards, optimizing SQL queries, automating reporting processes, and transforming large datasets into actionable business insights. Worked on end-to-end BI solutions involving data extraction, cleansing, modeling, visualization, and KPI reporting. Proficient in Power Query, BigQuery, MS SQL Server, and statistical analysis. Strong problem-solving, stakeholder communication, and analytical skills with a proven ability to deliver data-driven solutions that improve business performance and operational efficiency.
Experience
1 role
Medi Assist
Verified companyCurrent1 role · Full-time · 1 yr 3 mos
Data Analyst
Current– Present · 1 yr 3 mos · Full-time
Bengaluru, Karnataka, India
Built an interactive Power BI portfolio performance dashboard with corporate-level slicers, enabling drill-down analy ross IPD/OPD claims, beneficiary segments, and cashless vs. reimbursement claim types for pan-India corporat
• Project: Powerfolio Portfolio Generalized Dashboard
Power BI Reports / SQL Data Marts
- Built an end-to-end Power BI dashboard integrating 3+ billing systems to monitor revenue, billing accuracy, and payment delays across 5+ regions, reducing week-on-week bug count by 25% via trend analysis using Power Query.
- Built a Power BI dashboard to analyze insurance claims portfolio across corporates, enabling YoY comparison of claims, events, and incurred amounts.
- Identified key trends such as higher cashless claim adoption ( 78% cost share) and increasing claim volumes, improving business visibility.
- Optimized dashboard performance by handling large datasets and ensuring smooth slicer-based filtering.
Education
1
Bachelor of Engineering (BE)
Chandigarh UniversityVerified institution
Computer Science and Engineering
–
Skills & expertise
7Select any skill to find other members who share it.
Top skills
Databases & Data Engineering
Software Engineering & Programming
Data Analysis & Business Intelligence
Mentors like Aanchal
Browse all mentors
Senior Full Stack Developer @ Infosys
New mentor5 yrs exp
AI Agents & Agentic WorkflowsCSSData Structures & AlgorithmsDesign Patterns+24
2 servicesfrom ₹499Mock interview1:1 call
No open slots right now
Naveen
Senior Software Engineer @ Ford | Backend & System Design Mentor @ Ford
Bengaluru, Karnataka, India
Senior Full Stack Engineer @ Ford
New mentor4 yrs exp
FastAPIFlaskGoogle Cloud Platform (GCP)Low Level Design+4
2 servicesfrom ₹200Mock interview1:1 call
No open slots right now
Information Security
New mentor4 yrs exp
Computer NetworksIncident Management & On-CallZero Trust Architecture
2 servicesfrom ₹999Mock interview1:1 call
No open slots right now
Engineering Lead
5.0(1)6 yrs exp
AI Agents & Agentic WorkflowsNestJSPrompt EngineeringReact+12
5 servicesfrom ₹299Mock interview1:1 call
Available today
