Mahima Advilkar
Mountain View,CA
Summary
Analytical professional with strong Tableau expertise and a track record of delivering impactful financial insights. Known for conducting root-cause analyses that drive significant claim recoveries and process improvements. Ready to enhance operational efficiency and support data-driven decision-making.
Overview
5
5
years of professional experience
3
3
Certifications
Work History
Senior Operations Analyst Finance and Billing
Omatochi
Dublin, California
06.2024 - Current
- Developed and automated Tableau dashboards monitoring clinical program KPIs, such as claim denials, turnaround time, and financial risk, enhancing transparency for leadership and payer partners.
- Conducted root-cause analysis on denied claims and process bottlenecks, driving a $300K claim recovery, and improving program performance by 20%.
- Partnered with product, compliance, and scheduling teams to standardize billing SOPs and workflow documentation, reducing cycle time by 15%.
- Delivered monthly performance and variance reports, aligning with clinical, operational, and financial goals, and informing management reviews and payer audits.
Program Manager – Entrepreneurship Initiatives
Smith Center for Private Enterprise
Hayward, California
01.2024 - 11.2024
- Led a structured entrepreneurship residency program, supporting 40+ students in identifying industry gaps and transforming early ideas into viable startup concepts.
- Guided the development of 8+ validated business ideas, helping student founders refine problem statements, value propositions, and go-to-market thinking.
- Designed and facilitated hands-on workshops focused on ideation, customer discovery, product-market fit, and execution, increasing participation and sustained engagement across cohorts.
- Connected student founders with industry ecosystems and investor-facing platforms, including Founder’s Bay, Founder Village, and LG Nova, enabling exposure to real-world startup networks.
- Acted as a mentor and advisor to student teams, providing structured feedback, resource guidance, and execution support throughout the ideation and validation lifecycle.
- Coordinated with faculty, external partners, and innovation organizations to align program goals, timelines, and outcomes, creating a repeatable model for future cohorts.
Senior Business Analyst
Capgemini
Mumbai, MH
02.2023 - 08.2023
- Built 12+ automated Power BI/Tableau dashboards for operational and risk metrics, bridging data needs between program managers and analytics teams ensuring data integrity
- Performed program-level root-cause analysis using SQL/Python to identify fraud/churn patterns, boosting decision accuracy by 25%.
- Maintained issue logs, process trackers, and documentation supporting leadership in portfolio reviews.
Strategic Marketing Analyst
CCI Projects Pvt Ltd
Mumbai, MH
12.2020 - 02.2023
- Reported to the VP of Business Strategy overseeing a ₹10B real estate portfolio; aligned marketing and financial strategies to drive ROI.
- Directed digital and offline campaigns generating ₹550M revenue with a 35% ROI improvement through strategic GTM execution.
- Built analytical dashboards tracking spend efficiency, conversion quality, and lead performance; enhanced forecast accuracy by 10%.
- Strengthened cross-functional alignment between sales, finance, and marketing through executive performance reporting.Consolidated and analyzed multi-channel (ATL, BTL, TTL) campaign data in SQL, Excel, and Power BI, improving visibility into marketing spend, lead quality, and ROI by 40%.
- Designed and executed 15+ A/B tests and attribution analyses across digital and offline campaigns, optimizing targeting and creatives to boost ROI by 35% and reduce CPL by 18%.
- Automated KPI dashboards and campaign performance reports, cutting manual reporting time by 50% and enabling data-driven decisions across finance, sales, and leadership teams.
Education
Master of Science - Business Analytics
California State University East Bay
Hayward, CA05-2025
Master of Science - Accounting And Finance
University of Mumbai
Mumbai05-2021
Skills
- Data analysis
- Tableau expertise
- Financial modeling
- SQL proficiency
- Business strategy
- Performance metrics
- Customer Success
Certification
Fundamentals of Generative AI and LLM
Accomplishments
Stanford XR Immerse the Bay "23 Hardware Track Winner
Timeline
Senior Operations Analyst Finance and Billing
Omatochi
06.2024 - Current
Program Manager – Entrepreneurship Initiatives
Smith Center for Private Enterprise
01.2024 - 11.2024
Senior Business Analyst
Capgemini
02.2023 - 08.2023
Strategic Marketing Analyst
CCI Projects Pvt Ltd
12.2020 - 02.2023
Master of Science - Business Analytics
California State University East Bay
Master of Science - Accounting And Finance
University of Mumbai