Life Insurance System

ALFRED B. CLARK

*** ****** ******

Unionville, CT 06085

Tel.: 860-***-**** home

*********@*******.*** home

Profile

. Over twenty years of analysis / development experience in life insurance

and annuity administration applications on all platforms.

. Experience with several home grown and vendor life insurance

administration systems, compensation systems, repetitive payment

applications, and financial reporting systems.

. Heavy new product development including Term, Whole Life, ISWL, UL, VUL,

Joint Life, COLI, and Fixed and Variable Annuities.

. Expert level data conversion experience.

. Extensive application, data manipulation and testing tools experience.

. Strong business area knowledge of life products and business processes

with the discipline to perform and document business level analysis.

Excellent communication skills, works very well in team and independent

environments.

Skills Summary

Products

Whole Life Term UL VUL COLI Annuities

Technical

MS Access

MS Excel

MS Word

Windows

IT CONSULTANT - September 2000 to present

SELECTED EXPERIENCE

Tek Systems/Lincoln Financial

July 2008 to April 2009

. Member of team working on projects for I4L Integration

. Project Tasks included design, coding and testing of new

accounting reports.

. Resolved defects discovered in testing

. Fast paced, multi-tasking environment

. Heavy contact with business customers via email, telephone,

and personal contact

On-Line Systems/State of Connecticut DCF

April 2008 to July 2008

. Analyzed and implemented Federally mandated changes to DCF

(Department Child & Family Services) system.

. Working with business customer, designed, developed and

tested new tables.

. Software tools used included MS ACCESS, MS EXCEL, and MS

ACCESS VB.

The Life & Annuity Group/Mass Mutual

November, 2007 to April 2008

. Maintenance on RPS System -- Repetitive Payment System.

The Life & Annuity Group/Andesa TPA

April 2005 to November, 2007

. Project's goal was to convert business to Andesa system.

During participation, elements of Cigna, Utica Life, NY Life &

Mass Mutual systems were converted.

. Designed and produced reports to assist in the monitoring

of the effort.

. Designed and tested transactions to move data through the

conversion system

. Software included MS EXCEL, FTP, MS ACCESS, MS ACCESS VB

VERTEX Inc./Computer Science Corporation

September 2004 to April 2005

. Member of team upgrading and converting John Hancock Vantage

life insurance system.

Technisource/United Health

May 2003 to October 2003

. Designed and implemented changes to TOPS statistical system

. Changes provided additional data elements to supplement

monthly claims payment data relating to revenue code

expansion.

. Software tools included TSO/ISPF, TSO/FILE-AID, MS WORD, MS

EXCEL

Corporate IT/CIGNA Healthcare

October 2001 to March 2002

. Developed Access database to assist in Earnings system

migration using DB2, SQL, QMF, SPUFI, TSO/ISPF, ENDEVOR,

MICROSOFT WORD, MICROSOFT EXCEL, MICROSOFT ACCESS, VSAM,

FILE-AID, VSAM

. Analyzed technical specifications designed and implemented

test plans. Assisted in testing and validation of CIGNA

Healthcare release 2B, HFO Reporting using DB2, SQL, QMF,

SPUFI, TSO/ISPF, MICROSOFT WORD, MICROSOFT EXCEL, MICROSOFT

ACCESS

Computer Staffing Associates/CIGNA Healthcare

April 2001 to September 2001

. Performed detailed analysis in support of banking

transformation project.

. Performed analysis converting secondary account number file.

Computer Staffing Associates/Lincoln National Life

September 2000 to March 2001

. Created ad hoc reports for customers using various

utilities, transferring reports to Excel spreadsheets.

Mattioda Associates/Mass Mutual

September 1997 to August 2000

. Responsible for the analysis, design, of company initiatives

with VANTAGE One version 12 life insurance System.

. Aided in training of new associates.

. Provided support to Vantage One version 12 System to enhance

existing Alternate Source Interface as well as add new

collections sources.

. Provided support to produce Vantage One version 12 loan and

surrender checks through PALM system.

. Assisted on PALM Y2K upgrade.

. Developed support to generate letter to agents to provide

security info (PINS) to access Mass Mutual web site.

. Member of team supporting initiatives in FSX, Annuity Agent

Compensation System.

Full Time Employee Status

Travelers

October 2003 to September 2004

. Performed analysis & design on personal lines Homeowners

system for Speed to Market project.

. Analyzed request to eliminate "action codes" throughout the

homeowners system.

. Software tools included TSO/ISPF, EZTRIEVE, MS EXCEL, MS

WORD.

AETNA, Inc.

March 2002 to May 2003

. Successfully analyzed and implemented support for the ACAS

claims system.

Travelers Insurance

April 1996 to August 1997

. Member of team converting Aetna Property Casualty system to

Travelers system.

Aetna Life & Casualty

June 1985 to March 1996

. From 1992 to 1996 worked with unit supporting the Casualty

Processing system.

. Responsibilities included troubleshooting production and

system test problems as well as analysis for various system

enhancements.

. Project leader of team that developed automatic renewal

processing for CPS.

. Responsible for maintenance and development of CPS

Underwriter Renewal Tickets.

. Prior to 1992 worked with unit maintaining the Universal

Life and Traditional Life Insurance Administration systems and

subsystems.

. Supervisor of unit supporting LIAS Billing & Collection

systems and LIAS Complex Change system.

. Developed PC applications for attendance and other record

keeping. (Ashton-Tate DataBase Two Plus, Clipper)

. Developed PC based sales tracking system for distribution to

field offices. (Ashton-Tate DataBase Two Plus, Clipper)

. Project Leader: reformat and print life direct bills through

electronic publishing.

. Responsible for maintenance and development of life billing

system.

. Responsible for maintenance and development of Universal

Life Annual Reports.

. Assisted in development of knowledge base system to generate

language for life insurance beneficiary assignments. (KBMS)

EDUCATION

Connecticut Computer Service, Inc.

4994: Introduction to Programming Microsoft.NET Framework

Applications with Microsoft Visual Studio - June 22-26, 2009

2956B: Core Foundations of Microsoft.Net 2.0 Development

August 2009

2957B: Advanced Foundations of Microsoft.Net 2.0 Development

August 2009

Tunxis Community College - Associates Degree Business Administration --

December 1979.

Contact this candidate