Business Intelligence Analyst

Mounika Somapangu

314-***-**** *******.*@***********.*** LinkedIn Covington, GA

Professional Summary

5+ years of experience as a Business Intelligence Analyst, specializing in financial data analysis, reporting automation, and cross- functional data solutions for credit risk, regulatory compliance, and capital planning teams.

Automated recurring reporting processes using Excel (Power Query, VBA, PivotTables), reducing manual effort by 85% and improving delivery speed from 2 days to under 2 hours.

Cleaned and transformed 1.5M+ records from disparate financial systems, ensuring audit-ready data structures and improving reporting accuracy across business units.

Developed Excel-based scenario modeling tools and KPI dashboards for portfolio risk tracking and stress testing, contributing to a 15% improvement in capital adequacy assessments and faster decision-making cycles. Work Experience

Liberty Mutual Insurance, USA Business Intelligence Analyst Jan 2024 - Current

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.

Vivma Software Inc, India BI Analyst Apr 2018 - May 2022

Built advanced Excel-based reporting solutions using PivotTables, Power Query, and VBA macros to automate recurring financial reports, reducing manual workload by 85% and report delivery time from 2 days to under 2 hours.

Cleaned and transformed quarterly financial data (1.5M records) using Power Query and Excel formulas, streamlining ingestion from disparate systems and improving data reliability for executive reporting.

Designed Excel-driven portfolio risk tools with scenario modeling and sensitivity analysis features, supporting credit risk teams in stress testing and enhancing capital adequacy decisions by 15%.

Conducted deep-dive audits using Excel and SQL (CTEs, Window Functions), validating GL balances and exposure calculations, and helping maintain 100% SOX, FDIC, and internal compliance standards.

Partnered with BI and finance stakeholders to create Excel dashboards tracking KPIs such as delinquency rate, asset quality, and charge- off trends, increasing visibility into portfolio health and accelerating review cycles by 40%.

Developed data lineage documentation and process flows using Excel and MS Visio, improving cross-team knowledge transfer and reducing onboarding time for new analysts by 50%.

Delivered Excel-based ad hoc analysis for regulatory and internal audit teams, identifying data anomalies and root causes that led to corrective actions and stronger governance protocols.

Supported migration of manual Excel processes to Azure Data Factory pipelines by prototyping logic in Excel/Power Query, ensuring accuracy and continuity during cloud transition.

Technical Skills

Business Intelligence & Analytics: Data Modeling, Data Mining, Data Warehousing, Dashboard Development, KPI Reporting, Ad Hoc Analysis, Reporting Automation, Trend Analysis

Data Science & Machine Learning: Machine Learning, Deep Learning, Natural Language Processing, Statistical Modeling, Predictive Modeling, Model Evaluation, Feature Engineering, Algorithm Development

Database Management & Querying: SQL, T-SQL, PL/SQL, Database Design, Query Optimization, Stored Procedures, Data Extraction, Data Transformation, Data Loading, Data Governance

Cloud & Big Data Technologies: AWS, Azure, Databricks, Snowflake, BigQuery, Hadoop, Spark, Data Lakes, Cloud Computing

Programming & Scripting: Python, R, VBA, Scripting, Automation, Statistical Analysis, Data Visualization, Data Cleaning

Financial Data Analysis: Credit Risk Analysis, Regulatory Reporting, Capital Adequacy, Portfolio Management, Financial Modeling, Stress Testing, Scenario Analysis, Agile, Waterfall Education

SOUTH EAST MISSOURI STATE UNIVERSITY Master of Science, Applied computer science

Contact this candidate