Ashwini Koppula

Data Analyst @Optum

US

Worked on Revenue and Cost Analysis for Financial Products (e.g, mutual funds and retirement plans) and collaborated with cross- functional teams using Agile methodology, optimizing the cost-to-revenue ratio by 15% for a portfolio of $500M in assets.* Utilized advanced SQL techniques such as CTEs and Window Functions to extract, aggregate, and manipulate over 2 million rows of financial data, enabling accurate reporting on product performance and increasing data retrieval efficiency by 25%.* Conducted high-level analysis of financial product performance, assessing revenue trends, cost fluctuations, and profitability metrics for a diverse range of products, leading to a 10% improvement in cost efficiency and a 5% increase in overall revenue.* Employed Python with libraries such as Pandas for data manipulation, NumPy for numerical analysis, SciPy for statistical computations, and PySpark for processing large datasets (up to 1TB), optimizing analysis time by 40% for large-scale reports.* Leveraged AWS S3 for storing large financial datasets and used AWS Glue for ETL processes, streamlining data preparation, reducing processing time by 30%, and ensuring seamless integration of multiple data sources for reporting.* Designed high-level, interactive Power BI dashboards incorporating advanced features like Bookmarks, Drillthrough, and Dynamic Parameters to visualize real-time revenue and cost insights, empowering executives to track product performance and optimize strategies for a portfolio valued at $2B.

University of Maryland Baltimore County

Master's degree

Malla Reddy College of Engineering & Technology

Bachelor's of technology