Financial Analyst Ii

MADHURA BURANDE

857-***-**** *.**********@***.*** Linkedin Portfolio

Summary

Financial Analyst with extensive financial operations, variance analysis, and reporting automation. Proven expertise in SQL, SAP, and advanced Excel to drive process efficiency and enhance reporting accuracy. Strong record of collaborating cross-functionally to support strategic decisions, optimize costs, and deliver actionable insights. Adept at developing financial procedures and dashboards that improve reporting timelines and stakeholder communication Education

University of Massachusetts Sep 2022 – May 2024

Master of Science in Finance Boston, MA

Maharashtra Institute of Technology Aug 2018 – May 2021 Bachelor of Business Administration Pune, India

Experience

Citigroup Jan 2024 – Present

Financial Analyst II Boston, MA

• Developed and maintained advanced Excel-based financial models and incorporated SQL-driven data analysis to forecast revenue, expenses, and profitability for corporate clients, enhancing revenue forecasting accuracy by 20%

• Conducted variance analysis on monthly and quarterly financial reports to identify discrepancies between budgeted and actual figures, leading to a 15% improvement in forecasting accuracy and alignment with strategic financial goals

• Designed and implemented automated dashboards using Tableau and Power BI to visualize real-time financial data, improving executive reporting efficiency by 25% and delivering timely insights for strategic decision-making

• Collaborate with cross-functional teams to assess the financial impact of process adjustments for audit readiness using SQL and SAP to extract, manipulate, and validate large datasets used for reconciliation, claims reporting, and compliance reviews

• Optimized liquidity planning and capital structure analysis by evaluating funding strategies and automating CECL reporting through Excel macros and functions, thereby streamlining cash flow optimization for financial institutions Moneywise Wealth Planners Jan 2020 – Jul 2022

Financial Analyst II Pune, India

• Created and maintained reports on claims adjustment, headcount tracking, cost forecasting, and utilization. Conducted in-depth financial analysis and presented findings to stakeholders, leading to a 20% improvement in cost efficiency

• Automated Excel-based reporting workflows using VBA and Python, reducing manual errors and saving 30% of reporting time

• Supported weekly, monthly, and quarterly close processes with P&L, GL, and expense analysis, improving reconciliation accuracy

• Established and monitored KPIs for financial performance, contributing to a 20% improvement in cost efficiency and enabling better financial decision-making and forecasting with in-depth variance analysis for actual vs. forecasted financial performance, identifying key drivers and presenting actionable recommendations to senior management for corrective actions

• Streamlined the financial reporting process by automating tasks with Excel and Python, reducing manual reporting time by 30% and bolstering data-driven decision-making across multiple departments Projects

Financial Analyst WACC, SWOT, ThinkCell, PowerPoint, Excel Aug 2023 - Dec 2023

Developed a model for a public company, estimating 12% sales growth, 5% dividend growth, WACC via 3 methods, and current stock value, studied Investment performance, and formulated SWOT analysis and Investment thesis

Utilized ThinkCell and PowerPoint to streamline financial reporting processes, reducing preparation time by 40% Investment Analysis MPT, S&P 500, Factor Analysis, Excel Jan 2023 – Apr 2023

Considered 3 different portfolios of stocks, measured their returns, implemented their regression, and compared the performance to the S&P 500. Applied modern portfolio theory (MPT) and factor analysis to design a diversified Asset Mix. Enforced tools and Excel or portfolio returns, risk metrics, and Sharpe ratio computation, improving efficiency by 20%

Introduced a machine learning algorithm to forecast financial trends, enhancing predictive accuracy by over 35% using Variance analysis and Advanced Excel with VBA

Skills

Financial Analysis: Financial Modelling (DCF, PTA, CCA), Budgeting, Forecasting, Variance Analysis, QuickBooks Data Analysis: SQL, Excel (Advanced Formulas, VBA), Python, Data Visualization Software & Tools: SAP, Oracle Financial Services, HFM, Hyperion, Bloomberg Terminal, MS Office, NetSuite Reporting: Tableau, Power BI, Financial Reporting, Dashboard Creation Investment Performance: Portfolio Tracking, Valuation, Return Calculations Processes: Risk Assessment, Scenario Analysis, Revenue Analysis, Cost Analysis, Compliance Reporting Compliance: Regulatory Compliance, Accounting Standards (GAAP, IFRS), Sarbanes-Oxley (SOX), Basel III

Contact this candidate