Mounika Somapangu
Looking for New Opportunities | Business Intelligence Analyst @Liberty Mutuals|
- Role
- Business Intelligence Analyst at Citi
- Location
- Covington, GA, US
- LinkedIn followers
- 500 followers
About Mounika Somapangu
Financial Analyst with 5+ years across FP & A and corporate finance, conceptualized in DCF,…
Experience
Business Intelligence Analyst
Jan 2024 — Present
Cleaned and transformed 2M+ rows of raw claims, policy, and payment data using Python (Pandas, NumPy), streamlining data prep pipelines and improving regulatory reporting accuracy by 35%, while reducing manual QA time by 6+ hours per week. Performed root cause analysis on premium reconciliation mismatches across multiple regional underwriting systems, identifying ETL breakdowns and data-type inconsistencies that, once resolved, enhanced monthly audit and improved reporting alignment by 97%. Developed enterprise-grade Power BI dashboards with dynamic DAX measures to monitor KPIs like claim cycle time, fraud incidence rate, and loss ratios, enabling actuarial and operations teams to make real-time decisions and reducing manual report by 60%. Optimized claims and financial SQL queries on Amazon Redshift and built reusable stored procedures, reducing dashboard refresh times by 77% and accelerating access to high-volume loss reserves and earned premium insights for business leadership. Led ad hoc customer churn analysis using Excel Power Query and VBA macros, segmenting policyholder behavior by tenure, product line, and claim history — insights that directly informed a targeted retention strategy, reducing lapse rates by 12% in Q2. Designed a predictive model for early delinquency detection using policy, payment, and claims history data; the 82% accurate model was used to trigger pre-emptive outreach, lowering high-risk policy issuance by 18% and aligning with Liberty Mutual’s risk mitigation protocols.
Education
Southeast Missouri State University
Master's degree, Computer and Information Sciences and Support Services
2022 — 2024
JNTUH College of Engineering Hyderabad
Bachelor's degree, Mechanical Engineering
2016 — 2020
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.