Sai Manish Varma Mudunuri

Data Analyst @Ameriprise Financial Services, LLC

Worked on Portfolio Performance and Risk Analysis by collaborating with Portfolio Management, Risk, and IT teams using Agile methodology and conducting requirement gathering sessions to define portfolio benchmarks and client risk evaluation criteria.• Built optimized SQL queries using window functions and common table expressions to extract data from AWS Redshift and Athena. Handled large-scale ETL for CSV and Parquet files sourced from internal and market data feeds.• Performed time-series analysis and regression modeling to analyze portfolio returns and volatility. Identified 30% of underperforming portfolios and flagged key risk factors that helped advisors restructure investments with better risk-adjusted returns.• Utilized Python with NumPy, Pandas, and SciPy to clean and transform portfolio data. Conducted correlation analysis and hypothesis testing to uncover hidden patterns and reduce risk model error rate by over 15%.• Executed data validation and ETL workflows using AWS Glue, Lambda, and S3. Automated data pipelines that reduced manual intervention by 25% and ensured timely delivery of portfolio risk metrics to internal dashboards.• Developed Power BI dashboards with features like interactive slicers, drill-through pages, and KPI scorecards. Used DAX to calculate rolling Sharpe ratios and Value-at-Risk which improved investment decision speed by nearly 20%.