• Created custom web application and data warehouse for Fortune 500 company combining multiple accounting departments for reporting, budgeting, and forecasting• Reduced P&L ETL process at Fortune 500 company from days with user involvement to minutes with no user involvement and full audit data trail• Designed and developed system to automate ACH and data feed creation and transfer via SFTP to various banks and vendors with workflows and full audit data trail• Collaborated with project managers and auditors like PwC on compiling SDLC documentation• Developed custom solutions to automate transforming data feeds from vendors to remove the manual user intervention before loading into data warehouse• Designed and developed automated solutions to extract data feeds and provide users with web-based tools to modify and transfer data to external systems, like Workday, while providing a full audit data trail• Created custom generic KPI model and web application clients could easily implement for analytics through Qlik Sense• Designed and developed full suite of web tools for a grant management system that integrates with benefit reporting software and provides users with a fully audited process from application to grant to sending payments with tools to measure the program’s performance and forecast future spending

• Automated manual processes with external and third-party software like Blackboard, Great Plains, key card system, banks, and government agencies• Designed, developed, and maintained custom web-based Student Information System (SIS) from various ASP, Access, Excel, and third-party software• Developed lead service API that would clean and validate leads from different vendors• Designed and implemented an automated scheduling web tool for classes, rooms, and students with tools for manual adjustments• Designed, developed and maintained event-based automation processes for students from account and email creation, key card access, and key card funding (ACH)