PwCFinancial Analyst
Feb. 2025United States• Built SQL-driven data models by extracting and transforming macroeconomic and credit performance data from SAP S/4HANA and SQL Server databases. Enabled quarterly budget-to-actual variance analysis, APR trend forecasting, and loss-rate sensitivity analysis, presented in rolling forecasts and variance commentary. • Prepared and delivered executive-level monthly and quarterly reporting, assembling Income Statements, Balance Sheets, and Cash Flow Statements along with supporting Variance Analysis Reports and trend commentary in PowerPoint-ready format, facilitating 10-Q briefing packages and board presentations. • Developed SAP ledger audit trails via SQL logic and reconciliation schedules, ensuring full GL to subledger reconciliation and SOX Control testing. This reduced ledger mismatches by 85%, reduced control risk, and accelerated the accounting close process by two days. • Led budget-to-actual variance investigations, jointly with FP&A and Revenue teams, identifying key cost and revenue drivers. Created Excel-based scenario and sensitivity models and integrated Power BI visuals to recommend forecast adjustments and actionable financial insights. • Facilitated monthly cross-functional financial reviews by generating dynamic Excel Management Reports, using INDEX-MATCH, Power Query, PivotTables, and comparative horizontal/vertical analyses, to support operational leaders in understanding P&L drivers, headcount/OPEX variances, and resource allocation decisions. • Coordinated internal audit activities by preparing workpapers and documentation for SOX Section 404 testing, covering design and operating effectiveness of internal controls over financial reporting (ICFR), executing control walkthroughs, and supporting external auditors for compliance audits.
