Internship Financial Analyst resume example

• Under supervision, built a forecast from operational drivers rather than a flat growth assumption, reconciled the opening balance to the ledger, and explained price, volume and timing variances to the budget owner.
• The team rebuilt the rolling forecast around cohort revenue and driver-based headcount assumptions; I supported research preparation, validation, and documentation under mentor review. The team removed a recurring quality failure from the reviewed workflow; confirmed with my mentor that my contribution was limited to the assigned support and validation work.
• The team created margin bridges for 7 product lines and reviewed them with operating leaders; I supported research preparation, validation, and documentation under mentor review. The team identified annualized cost actions that finance owners could validate; confirmed with my mentor that my contribution was limited to the assigned support and validation work.
• Under supervision, owned a monthly reconciliation using Excel control totals, resolving unmatched ledger entries before financial reporting and documenting the journal-entry approvals.
• Under supervision, built an internal-controls checklist around account ownership and cutoff evidence, reducing month-end review queries from 22 to 9 across two comparable closes.

• In a mentor-reviewed simulation, built an Excel reconciliation between ledger balances and operating schedules, isolating timing differences from posting errors; attached source references so accounting reviewers could reproduce each adjustment.
• As a second supervised exercise, prepared an accounting variance bridge in Excel, separating volume, rate, and one-off costs; reconciled the bridge to the close package before using it in the budget discussion.
• Under supervision, the team automated monthly close checks across 14 account reconciliations; I supported research preparation, validation, and documentation under mentor review
• Created a synthetic ledger and supporting schedules with timing differences, reversals and an unmatched item; reconciled opening and closing balances and retained the source for each proposed adjustment.
• Tested the workbook after changing a period and reversing an input, identified formulas that failed to update, and added a control total and reviewer notes explaining the remaining assumptions.
• Owned the synthetic-ledger reconciliation using control totals, resolved an out-of-period posting and completed an evidence index linking every adjustment to its source record.

Relevant coursework: Financial accounting, statistics, operations management, organizational behavior

• Published a personal accounting methods note using synthetic journal entries, explaining cutoff judgments, reconciliation differences and the approvals needed before changing a real ledger.