Hello! I'm Pavani Gopagoni, a results-driven Business Analyst with over 3 years of experience turning complex requirements into scalable, data-driven solutions across financial and healthcare domains. I thrive in collaborative, cross-functional environments and enjoy translating stakeholder needs into clear, actionable analytics and automated workflows that improve decision-making and operational efficiency.\n\nI excel at SQL, Power BI, Python, and Excel, delivering insightful analytics, automated reporting, and robust data governance. My track record includes reducing manual workloads, boosting audit readiness, and enhancing platform usability in regulated settings, all while maintaining a customer-focused, friendly approach.

Pavani Gopagoni

Hello! I'm Pavani Gopagoni, a results-driven Business Analyst with over 3 years of experience turning complex requirements into scalable, data-driven solutions across financial and healthcare domains. I thrive in collaborative, cross-functional environments and enjoy translating stakeholder needs into clear, actionable analytics and automated workflows that improve decision-making and operational efficiency.\n\nI excel at SQL, Power BI, Python, and Excel, delivering insightful analytics, automated reporting, and robust data governance. My track record includes reducing manual workloads, boosting audit readiness, and enhancing platform usability in regulated settings, all while maintaining a customer-focused, friendly approach.

Available to hire

Hello! I’m Pavani Gopagoni, a results-driven Business Analyst with over 3 years of experience turning complex requirements into scalable, data-driven solutions across financial and healthcare domains. I thrive in collaborative, cross-functional environments and enjoy translating stakeholder needs into clear, actionable analytics and automated workflows that improve decision-making and operational efficiency.\n\nI excel at SQL, Power BI, Python, and Excel, delivering insightful analytics, automated reporting, and robust data governance. My track record includes reducing manual workloads, boosting audit readiness, and enhancing platform usability in regulated settings, all while maintaining a customer-focused, friendly approach.

See more

Language

English
Fluent

Work Experience

Business Analyst at MetLife
October 1, 2024 - Present
Collaborated with risk, compliance, and IT divisions to capture business requirements for the Risk Management & Compliance Analytics Platform. Created and managed functional specifications, BRDs, and user stories ensuring Basel III and AML regulatory frameworks. Designed data flow diagrams and workflow visualizations to identify inefficiencies and propose automation-driven improvements. Directed end-to-end UAT, including test planning, execution, and defect tracking to ensure robust reporting deliverables. Implemented data validation and governance controls, reducing compliance data discrepancies by 35% and improving audit readiness. Streamlined cross-departmental communication through Agile ceremonies, improving delivery timelines by 20%. Partnered with business and technology teams to integrate automated exception reporting, improving accuracy and response time across global compliance teams. Developed risk score dashboards and performance metrics using Power BI to monitor portfolio
Business Analyst at Ameriprise Financial Services, LLC
July 1, 2021 - July 1, 2023
Spearheaded development of an Investment Performance Reporting Dashboard that consolidated AUM, return rates, and benchmark variance data across multiple portfolios. Automated manual reporting processes through SQL queries, macros, and Power BI pipelines, achieving a 60% reduction in report preparation time. Collaborated with product, finance, and compliance units to gather and document detailed functional requirements and align them with data governance policies. Built interactive Power BI dashboards with drill-through and slicer functionality for performance analysis by asset class, fund, and advisor segment. Conducted root cause analysis (RCA) on data inconsistencies, resulting in a 92% reduction in reporting errors and improved reconciliation accuracy. Designed data validation frameworks to ensure ETL consistency and improve trust in financial reporting systems. Worked closely with senior management to define KPIs for investment strategy and advisory performance tracking. Conducted
Operations & Reporting Analyst at Bristol Myers Squibb
January 1, 2021 - June 1, 2021
Designed and implemented automated Excel and SQL-based dashboards to track pharmaceutical supply chain metrics and ensure real-time inventory visibility. Partnered with supply chain teams to streamline inventory reconciliation processes, cutting report turnaround time by 30%. Developed standard operating procedures (SOPs) for data extraction and cleansing to improve data consistency across global operational datasets. Conducted root cause investigations into data discrepancies, improving compliance documentation and traceability during internal audits. Assisted in integrating inventory analytics with compliance databases, ensuring alignment with healthcare regulations and audit protocols. Identified process gaps through workflow mapping and recommended automation improvements that optimized resource allocation and reduced manual data handling.

Education

Master of Science in Business Analytics at University of New Haven
August 1, 2023 - May 1, 2025
Bachelor of Engineering in Information Technology at MVSR Engineering College
July 1, 2018 - August 1, 2022

Qualifications

Add your qualifications or awards here.

Industry Experience

Financial Services, Healthcare, Life Sciences, Professional Services