Programmer Analyst

MAXINE MCKENLEY-DALEY

**** ******* **** ****, *****, NY 10460

917-***-**** qsosl3@r.postjobfree.com

_____________________________________________________________________________

RANGE OF EXPERIENCE

Programmer/Analyst with over 14 years experience in full system development life cycle, implementation and maintenance of computer-based application systems for micro, mini and mainframe environments; a proven record in troubleshooting systems, identifying problems and developing innovative solutions; excellent analytical and debugging skills including reading dumps and resolving Production Abends. Strong user relations, resulting in high quality systems and procedures that significantly improve the company operations and contribute ultimately to improved profits. Exercise sound judgment in evaluating situations and decision-making, code with minimal guidance and consistently meet project deadlines.

SPECIALITIES

Systems Analyst - Programmer/Analyst - SQL Developer - Data Analyst - Data Mapping

Application Support - Data Manipulation – Data Conversion - Documentation

___________________________________________________________________________________________________________

SKILLS PROFILE

Hardware: AS/400, IBM S/4341/9XXX, RISC/6000, IBM S/3X, PCs and compatibles

Databases: SQL Server 2000/2005/2008, PostgreSQL, DB/400, DB2, FOXPRO

Languages T-SQL, pgSQL, AcuCOBOL-GT, Acu4GL, AcuSQL, COBOL/11/4OO/ILE, CL, JCL, RPG/400/1V, CICS, COBOL, Embedded / Interactive SQL, C++, Visual Basic

Op Systems: OS/400, AIX, DOS/VSE/SP, VSE/ESA, OS/2, MS Windows NT

Tools/Utils: AS/400 Utilities, SSRS, CRYSTAL Reports, Microsoft Office Suite, ERWIN, VISIO, TCP/IP, FTP, AcuBENCH, PRO-IV, STRADIS methodology

____________________________________________________________________________________

PROFESSIONAL HISTORY

NYMAGIC INC. (Publicly Traded Insurance Company), New York, NY

Programmer/Analyst 04/2004 to 05/2011

Supported the Policy/Claims/Collections/Reinsurance/Accounting (AP/AR) applications, on Client server system utilizing AcuCOBOL, Acu4GL and, AcuSQL, using vision files and SQL server 2000/2005/2008. Provide ongoing Production and on-call support

• Maintained data consistency between the Policy Administration and the Reinsurance databases

• Analyzed, mapped and converted data from legacy system to a new SQL Server 2008 database

• Implemented and deployed datamarts for reporting & analysis

• Queried production databases to provide ad-hoc reports, utilizing T-SQL to Excel spreadsheets

• Coded, test database objects for analysis and management reporting

• Consolidated and modified validation routines eliminating error transactions by 99%

• Authored functional, detailed technical specifications, and design processes from user requirements

• Developed and deployed dynamic reporting solutions with Crystal Reports and SQL Server 2008 Reporting Services on time and within budget.

SEABURY & SMITH, INC. (Marsh & McLennan Group Company), New Hyde Park, NY

Senior Programmer/Analyst 04/2000 to 11/2003

Supported multi-lines of insurance and risk management back office applications as a COBOL, RPG, and SQL Programmer/Analyst.

• Maintained existing applications specifically the Universal Billing System which interfaced with Payroll, Accounts Receivable, Accounts Payable, and Policy Details and Tracking on an AS/400 using COBOL/400/ILE, RPG 111/IV/400, DB/400, embedded & interactive SQL, and CL

• Developed new application/subsystem providing file maintenance capabilities using subfiles, flowcharts using VISIO and ERWIN for data modeling

• Provided production support, read dumps resolving abnormalities in production job flow

• Prepared technical specifications from user requirements

Independent Contractor, New York, NY 07/1998 to 03/2000

Performed various tasks as the need arises, such as:

• Installed PC software products, maintained Windows NT Client server system

• Wrote and debugged programming code as outlined in specifications using RPG or COBOL

• Designed, developed & maintained MS-Access 97/Visual Basic systems – specifically traveler/passport tracking system for consulate, and order entry/accounts receivable system for small manufacturing company

LIFE OF JAMAICA LIMITED (Publicly traded Life Insurance Co), Kingston, Jamaica WI

Senior Systems Analyst 10/1992 to 03/1998

Designed, developed and maintained insurance back-office applications, implemented replacement system, and provided ongoing production support.

• Maintained existing applications (Life Insurance, Agency/Broker, Payroll, Mortgage, General Ledger, Accounts Payable and Receivable) on IBM 4341/9221 using CICS, COBOL 11, RPG 111, VSAM; and AS/400 using RPG 111/400, COBOL/400, DB/400, SQL

• Designed and implemented systems which effectively met user requirements in a timely manner

• Prepared requirements definition, wrote functional and technical specifications

• New Life Project - team member for the implementation of the new life insurance system SOLCORP/INGENUIM 5.1.1 on RISC/6000 using MicroFocus COBOL, DB2, embedded SQL, CICS/6000. Had specific responsibility for the Agency/Brokerage subsystem and Data Conversion from AS/400 and IBM 4341/9221 (over 3,000,000 records)

• Total Quality Management - member of a project team, which effected quality improvements, geared at improving operational areas and developing standards within the company

PRICE WATERHOUSE (JAMAICA), Kingston, Jamaica

IS Specialist / Systems Coordinator 10/1990 to 09/1996

Overall responsibility for the firm's in-house computer information systems, provided all technical and operational support including backup administration, user support and training

• Provided technical support during the conversion of all applications from COBOL, RPG 111, PRO-IV, and VSAM to INGRES/FoxBASE Client Server system.

• Developed new and maintained existing applications on IBM 9375 and AS/400 using DB/400, COBOL, RPG 111/400 and PRO-IV.

• Supervised the Operations staff (5 persons) ensuring accuracy and timeliness for data input, processing, and generation of reports

____________________________________________________________________________________

EDUCATION/TRAINING

University of Technology, Kingston, Jamaica

Bachelor of Science - Computer Science and Management

• First Class Honors (GPA 3.96)

Integrated Database Management System

Systems Analysis and Design – Full Development Life Cycle, Project Management

LOMA/FLMI - Level 1 Certification - Principles of Life and Health Insurance

Contact this candidate