PROFESSIONAL OBJECTIVE:

25 years of progressive Information Technology experience in financial services industry, which includes programming, systems analysis, system design, and documentation and technical lead. Seeking a position in which I will utilize my education and past experience in either a mainframe or client/server environment preferably as a developer/analyst.

EXPERIENCE SUMMARY:

• 15+ years of experience working as a Cobol developer, analyst, and technical lead in the maintenance and development of the administrative and finance systems of a large insurance company
• 4+ years of experience working as a developer, analyst and technical lead in developing ETL programs that support data extraction, transformation and loading. Tools included PL/SQL and Informatica.
• 1+ years of experience with Informatica testing tool DVO
• 4+years ETL experience using PL/SQL, Informatica; data integration and normalization
• 20+ years of IT experience in Development, Implementation, Testing, Analysis, Design, and Support of insurance and financial sector applications.
• 10+years experience working with systems development life cycle (SDLC) concepts
• 20+ years in developing SQL in Oracle and DB2 relational databases.
• Extensive experience developing programs in relational databases

TECHNICAL SKILLS:

Languages/Tools: Cobol (CICS, DB2, IMS, IDMS), Unix Scripting, IBM JCL, Oracle SQL, PL/SQL, Informatica, PeopleSoft Peoplecode, SQR, VSAM, SAS, Oracle SQL

OS/Databases: Mainframe: IBM MVS, IBM DB2, LINUX, Sun Unix, Oracle Data Bases, DB2 Databases, Tandem, IBM MVS with TSO, IBM DB2

Software/Utilities: Peopletools 8.4, Librarian, Expeditor, TSO, Oracle Reports, Microsoft Office applications, Informatica Developer, Powercenter DVO,SQL Loader, TOAD, Teradata Data SQL Assistant

PROFESSIONAL EXPERIENCE:

Confidential, Portland, ME

Software Engineer

Responsibilities:

• Assisted in project management and planning efforts for design and deployment of PeopleSoft applications and upgrades.
• Prepared reports, schedules, business requirements, flow charts, and test plans in support of customization production efforts for accounts payable module; developed queries.
• Support and maintenance of corporate data warehouse and ETL processing (Oracle DB).
• Development and maintenance of two additional company designed Oracle Data bases.
• Troubleshooting and coordination with data center technicians of upgrades, installations and testing of third party software and operating systems.
• Implement and deploy various PeopleSoft Financials applications
• Design, develop, test, and document various PeopleSoft applications using PeopleTools, Application Engine and SQR.
• Ongoing maintenance and production support of PeopleSoft AP module
• Primary support of company’s third party special merchant payment system including troubleshooting and coordination with data center technicians of upgrades, installations and testing of third party software.
• Primary support of company’s legacy PL/SQL bank database (Oracle). Responsible for all enhancements, upgrades and production support.
• Developed and implemented dozens of automated batch processing jobs, running in numerous development, test and production environments, involving UNIX utilities and scripts.

Technologies: Oracle Database, SQL*Loader, SQL*Plus, TOAD, PL/SQL (Procedures, Packages), UNIX scripts and COBOL, Informatica

Confidential, South Portland, ME

Senior Programmer / Analyst

Responsibilities:

• Supported Confidential ’s legacy Tandem mainframe system and various subsystems.
• Technical lead on various teams developing processes to indent and mitigate fraudulent use of Confidential ’s fueling card.
• Collaborate with internal and external clients to identify process improvement opportunities.
• An example of this role was as the technical lead on a team charged with enhancing Confidential ’s administrative system in support of a major private label partner.
• Role required numerous face to face meetings and requirement gathering sessions with partner.
• Analysis of existing processes and debugging of existing and new processes.
• Responsible for production, user and technical support of sales department’s systems.

Technologies: Tandem Mainframe, COBOL, Oracle DB, SQL*Loader, SQL*Plus, TOAD, PL/SQL (Procedures, Packages)

Confidential, Bath, ME

Senior Programmer / Analyst

Responsibilities:

• Cobol MVS and CICS development and maintenance of a proprietary application owned by Bath Iron Works.

Technologies: IBM Mainframe, COBOL, DB2, IMS, SQL*Plus, TOAD, UNIX, PL/SQL (Procedures, Packages)

Confidential, Portland, ME

System Consultant/Developer

Responsibilities:

• Responsible for all design, testing and maintenance of UNUM’s marketing and sales support systems. Duties included coding, analysis, testing, and documentation based on user requirements.
• Fulfilled various clients’ requests of detail sales information ranging from Ad hoc and customized reports for department management to the creation and transmission of data files to sales offices in support bonus and incentive sales programs.
• Heavy analysis of existing processes along with modifications and debugging of existing and new processes.
• Collaboration with internal and external clients to identify process improvement opportunities.
• Served as team lead for sales reporting/commission projects, including supervising workload, scheduling, and budget changes.
• Technical lead on team developing a DB2 replacement of UNUM’s legacy Broker Commission System. Role included the production of design documentation based on user specifications.
• Other projects included the annual redesign of the group sales team’s bonus and commission payment system as well as development of various broker batch systems in support of incentive programs.
• Arranging and facilitating meetings to identify user and IS requirements as part of the UNUM’s SDLC protocol.

Technologies: IBM Mainframe, COBOL, DB2, MVS, JCL, SAS, VSAM, CICS, Expediter, TSO/ISPF, IDMS

Confidential, Portland, ME

Senior Programmer/ Analyst

Responsibilities:

• Supported sales reporting systems for Individual Insurance Division’s marketing department along with other sales systems, interfaces and subsystems.
• Programmed, analyzed and tested numerous applications in support of marketing and sales departments.
• Analysis of existing processes and debugging of existing and new processes.
• Responsible for production, user and technical support of sales department’s systems.

Technologies: IBM Mainframe, COBOL, DB2, MVS, JCL, SAS, VSAM, CICS, Expediter, TSO/ISPF, IDMS

Confidential, Portland, ME

Programmer/ Analyst

Responsibilities:

• Supported New Business administrative as well as financial systems batch processing...
• Analysis of existing processes and debugging of existing and new processes.
• Responsible for production, user and technical support of sales department’s systems.
• Member of team replacing division’s legacy mainframe flat file administrative system with an IDMS hierarchal database. Role included analysis and design of various subsystems.

Technologies: IBM Mainframe, COBOL, DB2, MVS, JCL, SAS, VSAM, CICS, Expediter, TSO/ISPF, IDMS