DIANN C. EGELAND

***** ** ***** ****** 515-***-****

Madrid, Iowa 50156 ac4met@r.postjobfree.com

CAREER SUMMARY

Accomplished information technology professional with expertise as a technical analyst, software developer, and tester for the insurance and risk management industries. Reputation for applying root cause analysis and performance standards to ensure accurate data analysis and quality assurance. Known for collaborating with business analysts and off-shore developers to conduct system testing of new and existing software and to manage the data warehouse. Recognized for effective management of the systems development life cycle including planning, analysis, design, and implementation. Knowledge of electronic file transfers, job log analysis and job scheduling.

PROFESSIONAL EXPERIENCE

Aureon Staffing, West Des Moines, Iowa 2/1/2017 - 4/7/2017

Temporary Administrative Assistant for Aureon Technology.

MARSH & MCLENNAN COMPANIES, Des Moines, Iowa 1999 - 2016

A global professional services organization providing insurance brokerage, risk management, reinsurance services, talent management, investment advisory, and management consulting.

Laid off at the end of 12/2016 due to budget cuts.

Sr. Programmer Analyst / IT Production and Development Support, 2006 – 12/31/2016

Provided IT support for the Universal Billing System (UBS) as business analyst, project manager, support coordinator, and technical lead. Served as the liaison between account managers, IT business analysts and IT developers on and off-shore to ensure consistent and accurate development and implementation of COBOL programs for over 3 million insureds a year.

Developed a program to gather processing time from 13 nightly and monthly jobs to provide run time data to IT management to more effectively analyze need for additional hardware or disk space.

Verified test and production data, libraries, objects, control tables and user profiles from UBS to migrate to the new IBM mainframe resulting in a seamless hardware upgrade without interruption to business processes.

Created critical development standards, work flow instructions, and conducted peer reviews on over 10 new COBOL development implementations weekly resulting in 100% compliance of standards and work processes.

Implemented software to scan over 500 contractually unalterable name and address files a week to flag corrupt files resulting in a reduction of IT research time by a minimum of two hours a week, ensuring data integrity, cost savings, and customer satisfaction.

Analyzed intermittent ‘out of balance’ remittance files from customers to determine the root cause and correct files resulting in cost savings of researching future defects.

Gathered and analyzed data on UBS to convert 4 – 6 clients a year from social security to employee id account number, executed SQL updates to stay in sync with client data being passed to the UBS system resulting in uninterrupted customer support.

Monitored and supported electronic data transfer of over 4,000 test and production billing, remittance, payment, enrollment and name and address files a month resulting in uninterrupted transfer of data and a high level of end-user satisfaction and confidence.

Performed promotes for application software including COBOL source code, Copylib, menus, JCL, Cognos Quiz and QTP for 3 legacy systems, using Intersolv software PVCS Version Manager, to ensure source code integrity, version control, accurate and controlled updates to application software to safeguard against “abends” and unplanned production downtime.

Programmer Analyst - Data Warehouse, 2005 - 2006

Gathered, cleaned and integrated data from various sources, mainly from the operational legacy systems into the data warehouse database.

Developed SAS programs to load data from over 42 clients to the data warehouse resulting in ensuring data integrity for marketing mailings and telemarketing campaigns.

Programmer Analyst, 1999 - 2005

Enhanced and maintained Cobol on-line and batch programs for a membership system, affinity group services and group universal life. Managed IT project requests from marketing to effectively centralize information.

Responsible for enhancing, maintaining and developing on-line and batch programs utilizing COBOL in a KSAM file structure for Affinity Group Services, which included application entry, billing, issuance, marketing, carrier and client reporting.

Consolidated the month end batch jobs using the Maestro batch scheduler resulting in processing time savings of 6 hours, increasing the system availability to users.

Coordinated the implementation of data transfers from 8 Affinity Group systems for a federal regulatory project resulting in ensuring compliance with the USA Patriot Act and Office of Foreign Assets Control (OFAC).

GuideOne Insurance, Des Moines, Iowa, 1997 - 1999

As a Software consultant with Compuware, at GuideOne insurance I analyzed, tested and documented Y2K efforts in the Commercial Lines and Commercial Auto systems. Converted programs from COBOL to COBOL/370 and from Extracto to COBOL/370. Maintained and enhanced programs that used VSAM files and IMS database in both batch and CICS environment.

The Principal Financial Group, Des Moines, Iowa, 1995-1997

As a Software consultant with Analyst International Corporation, was responsible at the Principal Financial Group for converting on-line programs from ICOM to CICS. Also responsible for the enhancement and conversion of the Reserve and Dividend programs that created the on-line and batch reports for the actuarial department.

Mercy Medical Center, Des Moines, Iowa, 1993-1995 Programmer Analyst/Project Leader. Was responsible for writing general and detailed specifications for a variety of hospital applications such as Patient Management, Medical Records, Patient Appointments and Chart Tracking. Performed troubleshooting, made program changes, tested and installed a variety of applications in an IBM 3090 MVS environment using COBOL, COBOL II and CICS in an IMS DB environment.

Allied Group, Des Moines, Iowa 1992-1993

As a programmer/analyst for Allied Insurance maintained the batch COBOL and on-line CICS programs in an IBM mainframe environment.

EDUCATION

BA International Management, 2000 Simpson College, Indianola, Iowa

AAS Computer Science, 1978 Des Moines Area Community College, Ankeny, Iowa

CERTIFICATIONS

Fellow, Life Management Institute (FLMI)

Associate, Customer Service (ACS)

HIPAA compliant

COMPUTER COMPETENCIES

Tools: MS Office, Gentran, JCL, CICS, VSAM, TRAX, Supertool, PVCS GUI, Ultra Edit, Cognos, COBOL, FTP, Easytrieve, Test Track Pro, SRD, Outlook, SQL, Powerhouse, TSO, KSAM, ChangeMan, Maestro

Hardware: IBM Mainframe, HP3000, AS/400, UNIX

Database: DB2, Turbo Image

Contact this candidate