Developed a SQL-based data pipeline that extracts, cleanses, and structures regulatory data according to NCUA specifications, integrating it into Excel with dynamic formulas and validation logic to streamline the quarterly Call Report process and reduce manual intervention by 80%.
Performed trend analysis on member deposit behavior to uncover actionable insights and deliver data-driven recommendations to executives through structured PowerPoint presentations.
Engineered dynamic Excel-based benchmarking tools for loan and deposit products, leveraging advanced formulas to deliver competitive analytics against 30 local peers and function as an automated decision-support system that streamlines precise rate adjustments.
Accounting Clerk
M.A. Silva Corks USA
01.2021 - 04.2023
Developed financial tracking spreadsheets, improving visibility into blended exchange rates, purchase order payments, and invoice allocations.
Created financial reporting for upper management detailing and comparing profit margins for cork and glass sales in years 2008-2022.
Developed excel templates that facilitated invoice coding for our most used vendor reducing approval time by average of two days.