INFORMATION SERVICES ANALYST - Shelter Mutual Insurance Company - Columbia, MO
(2015-01 - 2021-12)
- Tech Lead - Auto Policy Administration System Production Support and Enhancements Team. A cross platform system requiring knowledge of COBOL, CICS, IMS, DB2, Java EE, JavaScript, Java Spring, and WebSphere MQ.
- Tech Lead – Book of Business Update processing, Distributed Batch processing, and Common Services Application. Provide knowledge of these systems for all future projects and production support when 1st, 2nd and 3rd lines are unable to solve the issue in time to meet the service level agreement.
- Tech Lead and Project Manager - Address Synchronization Project which allowed the ability to synchronize address across systems using Java Restful API's and Java Script Radio Buttons to select system(s) to be update.
- Tech Lead and Project Manager - Automate Underwriting Approval for Auto Business Use Policies. Modified, removed, and created new business rules to Java EE code and COBOL/CICS code.
- Tech Lead - Designed system modifications to allow the ability to choose ACH or check refunds. Modified XML message models, Java EE, COBOL, CICS and WebSphere MQ code so the new enumerations passed validation and stored correctly on the DB2 tables.
- 3rd line production support - Analyzed, Java, JavaScript, Java Spring, JCL, CICS, IMS, COBOL, DB2, SQL, and WebSphere MQ to identify a possible work around and solution to the root cause to maintain service level agreements.
- Data Expert - Identified corrupt data using SQL, data comparison, and log searching tools. Created SQL and/or XML messages to correct the data.
- Tech Lead - Designed the policy data update process for the COVID-19 Relief Payments. In an extremely condensed timeframe, we created an automated process that read multiple files created by marketing to generate 22 SQL statements to update 15 DB2 tables for 1.1 million policies. This allowed us to process these refunds and get the money our customers before our competitors announced their refunds.
SENIOR DEVELOPER - Shelter Mutual Insurance Company - Columbia, MO
(2008-01 - 2015-12)
- Quality Assurance Coordinator - Policy Update Services Project. Developed test cases for user acceptances testing and down-stream validation. Coordinated testing by developers, users, and downstream systems.
- Developer - Full Policy Inquiry Service Project. Developed CICS DB2 Stored Procedures using WebSphere MQ to pull current policy data from the Shelter Policy Administration System tables and generated XML messages consumed by Underwriting, Agency, and Actuarial Systems. We rewrote these later using Java Restful APIs.
- Developer - Shelter Policy Administration Back End System. Developed interfaces with the Accounting and Actuarial Systems using CICS, COBOL, DB2 and WebSphere MQ.
SYSTEMS ANALYST - MetLife - Greenville, SC
(2004-01 - 2008-12)
- Developer - Long Term Care System. Implemented the upgrade of Calligo 4.3 to 5.4. Provided all technical design documents, functional requirements, test scripts and training. Re-authored all correspondence using Calligo's 4th generation authoring language. Coded the transfer of policy data from INGENIUM's Policy Administration System to Calligo using COBOL, CICS, XML, and WebSphere MQ.
- Developer - Created new INGENIUM screens to the update the status of a claims using CICS, COBOL, HTML and Java EE.
DEVELOPER - Ahold Information Services - Greenville, SC
(1999-01 - 2004-12)
- Developer – Supply Chain Systems. Merged Tops Supermarkets into Giant Foods Store's systems. Converted DATACOM to ADABASE by creating a master VSAM file and conversion programs in COBOL. Modified COBOL code for the Pricing and Marketing Merchandising Applications. Developed reporting jobs using COBOL, JCL and VSAM.
- Developer – Payroll Systems. Rewrote Tops Supermarkets Union Contracts for the CYBORG payroll system. Developed programs in COBOL/CICS to adjust the pay and pay rate scales according to the results of union negotiations. Developed reporting tools using COBOL and CICS.
PROGRAMMER ANALYST - MetLife - Greenville, SC
(1996-01 - 1999-12)
- Programmer Analyst - Maintained the Record Keeping functions of the Unified In force System by modifying COBOL batch programs according to business requirements.
- Programmer - Modified COBOL programs, VSAM files and DB2 tables to accommodate the expanded date for Y2K.
