Led a team of three that provided data and reporting for the Deposit Services group for internal clients throughout the bank.Ran and maintained a daily process that created a database of eight million deposit accounts from multiple input sources, and produced reports (60 daily, 50 weekly, 230 monthly). These reports were generally produced in Excel format, using SAS Proc Report and ODS to create customized, fully formatted reports for internal clients.In a unique position providing data management and reporting for Deposit Services while “embedded’ in the Deposits group, rather than in an IT group. I have been very cognizant of maintaining integrity and accuracy given that we do have the administrative structure of an IT department that is designed to prevent problems.Created automated systems to read SAS logs as text files and create emails for team members with key running and error information to aid in finding and recovering from problems

Performed ETL and validation functions of data streams from all of the bank's operating divisions, and load them into the Asset/Liability system in order to project net interest income, perform balance sheet modeling, and meet regulatory requirementsProvided reports to show accuracy of data inputs and model accuracyInvestigated and corrected all data anomalies and inaccuraciesRefined and improved the ETL processesRemained cognizant of changes to bank products, accounting guidelines, and regulatory requirements and their impact on the data provided