Advisory Intern
• Implemented journal entry control sampling using advanced Excel mechanics, reducing time required to validate financial close and reporting metrics by 15% per control• Automated Balance Sheet Fluctuation and derivative repricing for multi-million dollar evaluations, preventing misstatement of funds for 20 lines of business• Utilized lookups and pivot tables to enhance reporting quality of payroll systems and user access controls• Measured materiality through Settlement Date Impact Analysis, increasing assurance on >$100k of revenue recognition discrepancies between settlement and trade dates