Praneeth Sholapur

Business Analyst @Liberty Mutual Insurance

Brentwood, CA, US

Partnered with leaders to document functional needs and model workflows for fintech and healthcare systems. • Streamlined ETL pipelines with automation and optimized SQL queries to support high-volume data processing. • Built custom dashboards (Power BI, Google Data Studio) for real-time sales/finance visibility. • Strengthened compliance by implementing metadata protocols and validation frameworks. • Led cloud migration to Azure Synapse and BigQuery; reduced storage costs and improved analytics speed• Translated large and complex datasets into actionable insights using SQL and Excel, enabling more informed decision-making across finance and operations. • Developed and maintained intuitive dashboards using Looker and Tableau to monitor business performance, customer trends, and campaign ROI. • Conducted ad-hoc analysis and recurring reports to identify performance drivers, revenue trends, and customer acquisition opportunities across key segments. • Collaborated cross-functionally with Marketing, Sales, Finance, and Operations to deliver tailored analytics solutions that aligned with team-specific goals. • Partnered with marketing teams to track CAC, LTV, and lead funnel performance; supported segmentation strategies using predictive analytics and A/B testing. • Implemented process automation and reporting standardization using SQL workflows in Snowflake and AWS Redshift, reducing report turnaround time by 40%. • Acted as a thought partner to operations leadership, uncovering inefficiencies and proposing optimization opportunities that improved team performance and tracking. • Facilitated Agile sprint planning, backlog grooming, and cross-team collaboration to ensure timely delivery of high-impact analytics initiatives. • Stayed current with industry trends, contributing to internal analytics best practices and identifying new tools and technologies to enhance reporting efficiency

University of the Pacific

Master's degree, Business Analytics