Update and maintenance of E2, an MS Access application utilizing a SQL Server backend. Duties include extensive use of stored procedures, triggers, and views, gathering requirements, writing functional specifications and extensive VBA and Access VBA programming. Extensive interaction with internal customers to enhance and debug E2.

Database Developer at The Hartford (Group Reinsurance Plus)

July 1, 2023 - October 19, 2025

Creation and maintenance of SQL Server databases (ver. 2016, 2019, 2022), with extensive use of stored procedures, triggers, and views. Gather requirements, write functional and technical specifications, and create schema documentation. Manage security and user access via Active Directory groups. Create and test disaster recovery plans. Employ SSIS to extract data from disparate data sources. Extensive parsing and scrubbing of data before loading to databases. Conversion of MS Access databases to SQL Server. Moving all our local applications to a Citrix server for increased stability, performance, and security. Created the Premium Admin Tracker (PAT) for GRP's finance area. PAT is an MS Access based application with a SQL Server backend that tracks premium received and due from our clients and creates an A/R ledger. Extensive use of stored procedures to speed up receivable calculations, gaining a 75% increase in performance. Moved our incurral reporting process from Excel to Tableau. C