Shiloni Shah

Financial Analyst with 3+ years of experience in FP&A, budgeting, forecasting, financial modeling, variance analysis, profitability analysis, and financial reporting within banking and financial services. Experienced in analyzing financial and operational performance, developing forecasts and scenario models, identifying cost optimization opportunities, and delivering data-driven insights to support business and executive decision-making. Proficient in Advanced Excel, SQL, Power BI, Tableau, SAP S/4HANA, and Oracle ERP, with experience in financial reporting automation and cross-functional business partnering.

FP&A Financial Analyst - State Street - USA

(2026-01)

• Supported consolidated budgeting, quarterly forecasting, strategic planning, and financial performance analysis by evaluating revenue, operating expenses, and headcount trends using Advanced Excel, Power BI, SAP, and SQL, improving forecast accuracy by 12%.
• Developed automated Power BI dashboards integrating SQL and Excel to build scalable financial reporting solutions, monitor business performance, financial KPIs, forecasting accuracy, and executive reporting, reducing manual reporting effort by 35%.
• Performed budget-to-actual and forecast variance analysis, identifying key cost drivers, revenue trends, and expense drivers that contributed to an approximately 8% reduction in discretionary expenses.
• Supported month-end and quarter-end close through GL validation, account reconciliations, journal-entry validation, and financial data reconciliation across SAP S/4HANA and Oracle ERP, ensuring accurate financial reporting and GAAP compliance.
• Built financial models supporting quarterly forecasts, annual budgets, scenario analysis, profitability analysis, and strategic planning to inform business and executive decision-making.
• Partnered with Finance, Accounting, Treasury, and cross-functional business teams to support financial planning, expense analysis, financial reporting, account reconciliations, and business performance initiatives, improving reporting accuracy, process efficiency, and data-driven decision-making.
• Performed profitability and cost analysis using SQL, Excel, and Power BI to evaluate revenue, operating costs, and business-unit performance, identifying opportunities that contributed to 6% operational savings.
• Supported rolling forecasts, annual planning, variance analysis, and financial reporting improvements, enhancing data accuracy, reporting quality, and operational efficiency.
• Delivered monthly and quarterly management reporting with variance commentary, highlighting key financial drivers, risks, and performance trends to support leadership decision-making.

Finance and Accounting Manager - DMI Finance - India

(2021-07 - 2024-07)

• Led annual budgeting, quarterly forecasting, and monthly financial planning for multiple business functions by partnering with senior leadership, analyzing revenue, operating expenses, and cash flow trends, improving forecast accuracy by 18% while supporting strategic business planning.
• Developed financial models using Excel, SQL, and Power BI to evaluate profitability, pricing, investment opportunities, cost structures, and scenarios, supporting decisions that improved operating margins by 11%.
• Managed month-end and year-end close processes including journal entries, account reconciliations, general ledger reviews, accrual accounting, financial statement preparation, and balance sheet analysis, reducing reporting cycle time by 25% while ensuring accurate financial reporting and compliance with internal accounting policies.
• Performed detailed budget and forecast variance analysis to identify financial drivers, revenue trends, and expense variances, supporting cost optimization initiatives that reduced controllable operating expenses by 10%.
• Prepared executive financial reports, quarterly forecasts, KPI dashboards, and management presentations, translating financial data into actionable insights for senior leadership.
• Partnered with Accounting, Operations, Sales, and Finance teams to improve financial planning, forecasting, reporting automation, and budget governance, reducing manual reporting effort by 30%.
• Supported internal and external audits by preparing audit documentation, supporting audit testing, maintaining SOX and internal control compliance, resolving audit queries, and ensuring adherence to GAAP and accounting policies.
• Automated recurring financial reporting and forecasting processes using Excel, SQL, and Power Query, standardizing reporting templates and validation processes and reducing reporting errors by 20%.

Master's - Finance - University of Texas at Dallas (2024-08 - 2026-05)

Bachelor of Commerce - Commerce - GLS University (2019-07 - 2022-06)