Andrew Mckenzie Email & Phone Number

Software Engineer on the Product Train, Colonial Life, Columbia SCGoal: Complete Product Increment objectives for Product Agile Release TrainValue: Allowed Colonial Life agents to sell the Group Critical Illness 6000 (GCI6000) , Individual Whole Life 5000 Plus (IWL5000P), and Individual Dental 8000 Enhancements (IDN8000) productsMy Contribution: • Designed and implemented overhauls to our systems backend, to allow for additional complexities requested by our business unit to sell IWL5000P • Designed and implemented changes to the database structure that comprised our IDN8000 product, to allow for the sale of additional base plan combinations. While not negatively impacting in flight enrollments• Lead release engineer for Colonial Life’s March 2021 production release, enabling the sale of our IDN8000 Enhancements. Responsible for overseeing our release ticket and taking care of the steps required to ensure a smooth production implementation.

Columbia, South Carolina Area

Software Engineer on Consumer Train, Colonial Life, Columbia SCGoal: Complete Product Increment objective’s for Consume Agile Release TrainValue: Allow cost savings by improving the Enrollment File Application system; Implemented crucial infrastructure improvements to SQL and Windows ServersMy Contribution: • Refactored the old EFI code to allow it to accept more general input, allowing more products to be processed through it• Created Jenkins jobs to automate the build process of several legacy applications in Colonial Life’s suite• Created Octopus jobs to use the artifacts created by Jenkins jobs to deploy legacy applications to various environments

Columbia, South Carolina Area

Software Engineer on Individual Dental 8000, Colonial Life, Columbia SCGoal: Complete the Implementation of the Individual Dental 8000 product from start to finishValue: Allowed Colonial Life agents to sell a new dental insurance product to drive premium sales, and contribute to the 5 million by 2020 goal of the companyMy Contribution: • Coded the Harmony product setup and enrollment pages for the product, allowing agents to configure and then sell the product • Coded the Quick Quote page for the product, Quick Quote being an outside application from our primary enrollment system that allows agents to provide snapshots of the products offerings to clients• Implemented several process improvements in the Harmony build process, using Visual Build Pro scripts and Jenkins jobs to reduce local Harmony build times from 45 to 15 minutesSoftware Engineer on Individual Accident 4000, Colonial Life, Columbia SCGoal: Complete the Implementation of the Individual Accident 4000 product that had been in progress prior to my joining the teamValue: Allowed Colonial Life agents to sell a new accident insurance product to drive premium sales, and contribute to the 5 million by 2020 goal of the companyMy Contribution: • Implemented the state activations for the product, allowing Colonial Life to comply with state specific Department of Insurance requirements• Coded the Harmony Rider Add functionality for the product, allowing customers that had already been enrolled in the product or that had transferred coverage to add riders to their policies• Refactored the Harmony product enrollment page for performance increases under large user loads

Office Of Enrollment Management

Goal: Complete an ASP.Net MVC project that had been in the process of being built for several months prior to my joining the teamValue: Improved the functionality offered by the customer facing side of the project with a large number of changes and built out features My Contribution: • Changed the database backing the project so that it utilizes the SQL Talisma database the UA uses• Completely built out the Models, Views, and Controllers necessary to allow the users to sign up for events using our system• Integrated the Customer Registration side of the project with the Program Management side, allowing staff members to build events and impersonate users from Program Management

Aime Building

Goal: Build a mobile application to allow our client, ServiceMaster, to access their corporate intranet on mobile devicesValue: Increased franchisee effectiveness by giving them a quick and easy way to access their intranet, without requiring them to navigate a website not designed for mobile devicesMy Contribution:• Built out a large portion of the Javascript that our application utilized for features such as an events calendar• Implemented some of the code required for us to fully utilize the MongoDB database backing our project• Spoke regularly with contacts we had within ServiceMaster to ensure that the work we were doing was matching up with their expectations and requirements

Vance, Alabama

Goal: Expedite my Team Members work flow by assisting them on projects they were working on, as well as work on projects of my ownValue: Increased Employee productivity through implementing new practicesMy Contribution:• Created a process to expedite the recording of information for a United Way fundraising event through the use of Barcode Scanning• Utilized the SAP system to ensure that the IT budget was balanced, and Team Members were assigned to the proper Cost Centers• Oversaw statistical analysis on the workstations that are installed throughout the plant for the use of Mercedes-Benz Team Members

Vance, Alabama

Goal: Further my education by applying the knowledge I learn in the classroom to real world situations while working a jobValue: Improved my HR team by helping them utilize technological assets more efficiently, as well as laying groundwork for a new HR Database to be built My Contribution: • Communicated with suppliers to establish the Spring 2015 Supplier Conference at Mercedes-Benz• Assisted several HR Team Members by providing them with tools to allow them to perform their jobs more efficiently• Ensured proper maintenance of the HR record keeping system, and beginning the move to an officially supported database system