- SAS data migration to Snowflake- Optimization of manual federal reserve report- Primary 14Q analyst for commercial/consumer auto- Process automation via python/snowflake- Work with Federal Reserve liaison to validate and correct data inaccuracies. - Team up with the business data owners to reconcile to federal reserve report- Re-write legacy reports to streamline efficiency of old programs/queries- Respond to inquiries from the FRB regarding federal report submission

- Built ad hoc reports for executives, providing valuable insights into business performance.- Maintained and updated company KPIs.- Outlined table structures, definitions, and logic to support the ETL team in the implementation of new databases.- Designed dashboards for back-end servicing and collections. - Revamped and automated third-party reporting processes, streamlining efficiency and accuracy post departure of financial analysts.

• Acted as the primary point of contact for data and analytic requirements in Collections and back-end servicing.• Provided critical support during the new loan operating system conversion.• Automated manual processes across analytics, IT, and business functions, resulting in increased efficiency and reduced human-error.• Recognized with the DRIVEN award for outstanding contributions.• Forecasted collections and aging for monthly collection reports.• Migrated old reports to the data warehouse and the new loan servicing system database.• Conducted data warehouse testing against source databases and documented processes.