Senior Programmer Analyst Resume
Summary of Qualifications
Record of success designing and implementing information technologies to support a wide-range of business application requirements in the financial services and health care industries.
- Skilled in high-volume workflow with creative problem resolution capabilities.
- Experienced in business and systems analysis, programming, testing, and quality control.
- Able to develop ideas into workable plans, establish effective priorities among competing requirements, establish logical and sequential methods for accomplishing stated goals and establish rapport with a wide variety of clientele.
- Analytical skills include identifying and solving problems.
- Skilled at working independently and as a team member, multi-tasking and delegating responsibilities.
Consultant (2007 - 2008)
Confidential, Concord, NH
Participated in a successful new product development project supporting modifications to the Vantage-One Annuity System. Functional responsibilities included:
- Business/Technical analysis and design for required modifications to the Vantage-One Annuity System.
- Systems analysis, coding, testing and problem log resolution support for the Annuity System modification effort.
- Met with key client subject matter experts to review business system requirements.
- Support for modification System and QA testing.
- Assisted with validating results of the modifications made to the database and system reporting.
- Review of the existing interface systems to validate information being sent to several client downstream applications.
Technologies used while on these assignments include TSO ISPF/PDF, OS/JCL (in-stream and Procs) in a JES2 environment, COBOL II and COBOL 390, VSAM/IDCAMS, CICS/SDF, DB2, QMF, SPUFI, FILE-AID, XPEDITOR, Citrix Program Neighborhood - Custom ICA Connections and SERENA ChangeMan for project development.
Consultant (2005 - 2007)
Confidential, East Hartford, CT
Participated as a Developer in the successful modification and conversion of the Vantage-One Annuity System for an existing CSC client, assisted with the technical analysis and design of one of the major enhancements to the new Wealth Management Accelerator System and participated as a Business Analyst/Developer in the initial Admin Conversion Due Diligence Study and the first phase of a Strategic Admin Replacement (STAR) project for another CSC client. Functional responsibilities included:
- Business/Systems analysis, coding, testing and database conversion support for the Annuity System modification effort.
- Technical analysis and design required for the enhancements to the WMA System.
- Met with the clients key subject matter experts to review business and technical system requirements as a member of the due diligence study team.
- Analysis of key data fields from the existing systems and how they relate to the required conversion data fields on the Vantage-One System.
- Review of the clients existing interface systems together with changes which were being implemented for a major Data Warehouse effort being developed as part of another conversion project.
- Involved in the time line analysis for the conversion/data migration method effort for all of the existing life system platforms.
- Assisted with the business analysis of the best of breed review to help determine which modifications from the existing systems were required and for which phase of the Universal Life conversion project.
- Involved in a more detailed data mapping effort to determine which required data fields from the existing systems were necessary for the Vantage-One conversion.
- Review of the initial conversion programs to verify that the code matched the changes indicated on the data maps.
- Business/Technical analysis and design for several required modifications to the Vantage-One System.
- Business and technical support for conversion and modification testing.
Technologies used while on these assignments include TSO ISPF/PDF, OS/JCL (in-stream and Procs) in both a JES2 and JES3 environment, COBOL II and COBOL 390, VSAM/IDCAMS, CICS/SDF, DB2, IBM Assembler, Easytrieve Plus, FILE-AID, INTERTEST, XPEDITOR, CA-Librarian and Endevor for project development, CSC's web-based Open Transaction Architecture (OTA), MicroFocus Mainframe Express (MFE) in a mid-tier environment and Nortel Networks Contivity VPN Client.
Consultant, Application Developer (2002 - 2005)
Confidential, Windsor, CT
Functional responsibilities include analysis, technical design, coding, testing and production implementation of enhancements to the sub-systems that feed and are fed by the SunGard OmniPlus System as a member of the Omni Development and Support Team. Major accomplishments and responsibilities include:
- Responsible for the rewrite, continued maintenance and primary support of the daily price and trade file applications. Assist the production support team to insure that the price and trade file service level agreements are met on a timely basis.
- Maintained database integrity for the daily price and trade file reporting applications.
- Collaborated with the production support manager and internal audit department to validate and insure that the proper edits are in place to meet the compliance requirements of the Sarbanes-Oxley Act.
- Assist with the maintenance and integrity of the application that updates the system Price Information tables used within the General Ledger applications.
- Maintain a positive working relationship with the management and staff of the financial reporting and accounting/audit departments.
- Assist with work request enhancement level-one estimates, script/program code modifications and testing to support the enhancements. Design, code, test and assist with running one-shot programs that handle special non-batch updates to the Omni database on-line system. Assist Business Analysts to help define test conditions and verify the validity of unit and integrated test results.
Technologies used in this position include MicroFocus Toolbox and COBOL for development/maintenance/unit testing, UNIX Shell Scripts in a HP-UX environment, the SunGard OmniStation on-line application, Business Objects, IBM File Transfer Protocol (FTP) to move information from the UNIX server to PC and PC to the UNIX server (copying data from the production to the development environments), CVS for project development, and some experience with Visual Basic/VBA Scripts.
Senior Programmer Analyst (1999 - 2001)
Confidential, Hartford, CT
Functional responsibilities included the business and systems analysis, technical design, coding, testing and production implementation of several new applications and enhancements to existing applications as a member of the Financial Interface Team. Major accomplishments and responsibilities included:
- Completed the business/systems requirement gathering, analysis and business/technical design for all projects that I was assigned, including meeting with internal ancillary management and staff and external vendor management.
- Developed an application that made it possible for the systems administrator to track daily financial charges that were previously not being reported in the system.
- Assisted the Patient Accounting Department through the modification and automation of a daily lockbox and bad debt posting and reporting applications.
- Assisted with the hospitals Y2K efforts and with a major conversion from an ICO (internal) to RCO (remote) processing environment.
- Developed and maintained the scripts responsible for updates to the hospitals General Ledger System.
- Provided some backup support to the programmer responsible for the Crystal Reports applications.
- Assisted with release updates to the IDX Reporting System running on the UNIX Operating System.
- Assisted with additions and changes to Xerox, HP and other printer designations within UNIX.
Technologies used while in this position include TSO ISPF/PDF, OS/JCL (in-stream and Procs) in a JES2 environment, COBOL and COBOL II, CICS/SDF, VSAM/IDCAMS, Easytrieve Plus, Crystal Reports 7.0, IBM File Transfer Protocol (FTP) to transfer information from mainframe to server and server to mainframe and CA-Librarian for project development.
Senior Programmer Analyst/System Designer (1992 - 1999)
Confidential, East Hartford, CT
Participated in the successful installation of the Vantage-One Life and Annuity Application for several new and existing CSC customers. Functional responsibilities included the analysis, technical design, coding, database conversion, testing and assisting with the training of entry-level staff.
- Collaborated with both customer staff and development personnel to help identify and resolve several database related pointer problems discovered during conversion testing for Release 15.0 of the Vantage-One system. Received a performance award during the first quarter of 1999 for assisting several project teams with database conversion efforts, including conversions from VSAM/CICS to DB2 utilizing QMF, SPUFI and SQL code.
- Responsible for the analysis of the Vantage-One Accounting sub-system to help resolve out of balance issues with the reporting of general ledger entries.
- Assisted management while working off-site as a consultant in both a development and production support environment, including helping to train members of the customers programming staff.
Technologies used while in this position include TSO ISPF/PDF, OS/JCL (in-stream and Procs) in both a JES2 and JES3 environment, COBOL II and COBOL 390, VSAM/IDCAMS, CICS/SDF, IBM Assembler, Easytrieve Plus, FILE-AID, INTERTEST, XPEDITOR, Endevor and CA-Librarian for project development.
Senior Programmer Analyst/Systems Designer (1986 - 1992)
Confidential, Bloomfield, CT
Experience with Admin Systems/Claims Payment and Reporting Systems, Employee Benefits Division/Flexible Benefits System and Individual Financial Services Division/PALLM Universal Life System.
- Responsible for a major rewrite and enhancements to help streamline the Payroll Reporting function for the Flexible Benefits System.
- Supported modifications to the medical and dental claims reporting systems. Also responsible for the rewrite to allow for better controls for the Trigger Point client reporting system.
- Maintained database integrity for the Trigger Point client reporting system.
- Developed and implemented an Electronic Fund Transfer application to post medical provider payments to an ACH bank using Network Data Mover (NDM).
- Assisted management in meetings with internal and external customers and vendors with regard to any modifications required to the applications that I supported.
- Worked as a consultant with the CIGNA Admin Systems management to help define the various banking systems applications. Received performance awards in October 1991 and January 1992 for analysis and additional work done assisting my manager with the consolidation of the banking system applications.
- Involved in most every major activity from 1990 through 1992 as either a developer or consultant while working as the primary support person responsible for resolving production problems.
Technologies used while in this position include TSO ISPF/PDF, OS/JCL (in-stream and Procs) in a JES3 environment, COBOL and COBOL II, IBM Assembler, CICS/SDF, VSAM/IDCAMS, CICS Dbug-Aid, Easytrieve Plus, FILE-AID, Network Data Mover (NDM) for Electronic Fund Transfers, Bulk Data Transfer (BDT RJE/NJE), Panvalet and Endevor for project development.
My previous experience includes working as a programmer analyst in the Life Systems Division of The Hartford Insurance Group in both Windsor and Simsbury. I've also had additional insurance experience in personal lines, property casualty, workman's compensation and commercial lines while working as a senior bookkeeper/junior accountant in the Hartford Regional Office Premium Accounting Department of The Hartford Insurance Group.
Operating Systems/Software PackagesIBM and Compatible Mainframes; MVS; S/370; S/390; MS-DOS, UNIX; AIX and HP-UX; Windows Operating Systems through Windows XP, Microsoft Office 2000/2003 (Access, Excel, PowerPoint, Visio and Word); Novell GroupWise; Lotus Notes; Microsoft Internet Explorer; WordPerfect; Adobe Acrobat; some experience with Business Objects, Crystal Reports 7.0, CICS using MQSeries and Microsoft SQL Server Express 2005/SQL Server Management Studio Express/Transact-SQL (T-SQL).
EducationCertificate in Business Administration
A.S. Computer and Information Systems
Computer Programming (Diploma)
