Career Experience
BNY Mellon
June 2023 - August 2023
- As a member of an Agile development team, created design documents for data migration of a vendor application utilizing a new MSSQL database schema.
- Converted and tested 50+ stored procedures for the new database schema.
- Worked in compliance engineering to provide risk assessment on current and potential future customers. Utilized LexisNexis Bridger Insight to determine if an individual or business is sanctioned, politically exposed, or low risk.
UKG
May 2022 - August 2022
- Worked as a member of an Agile development team to enhance CanadaTax, a web app used by UKG employees to assist customers with their Canadian taxes. Focused on features that help account managers keep track of pending collections from customers.
- Implemented a back-end to pull data from multiple tables, and added an additional column to store employee notes related to each collection. Added front-end features to sort alphabetically or by earliest date, as well as automatically highlighting past-due dates.
- Implemented a search bar that would allow users to filter results by tax representative. Added an autofill feature and utilized local storage to save a user's search.
- Created a feature to scan a table to check for manual entries and if found, enable an option to remove them from the database.