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 me will utilize my and past experience in either a mainframe or client/server environment preferably as a developer/analyst.

SUMMARY

• 15+ years of experience working as a Cobol developer, analyst, and technical lead in teh maintenance and development of teh 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 wif 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 wif 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 SQLOS/Databases: Mainframe: IBM MVS, IBM DB2, LINUX, Sun Unix, Oracle Data Bases, DB2 Databases, Tandem, IBM MVS wif TSO, IBM DB2Software/Utilities: Peopletools 8.4, Librarian, Expeditor, TSO, Oracle Reports, Microsoft Office applications, Informatica Developer, Powercenter DVO,SQL Loader, TOAD, Teradata Data SQL AssistantPROFESSIONAL EXPERIENCE

Confidential, Portland, ME

Responsibilities:

• Technical lead and developer on ETL team converting an IDMS DB application to DB2 using Informatica tools. IDMS/DB2 COBOL, JCL, TSO, Powercenter DVO, Informatica Developer

Confidential, South Portland, ME

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 Confidential data warehouse and ETL processing (Oracle DB). Development and maintenance of two additional company designed Oracle Data bases.
• Troubleshooting and coordination wif 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 wif 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,

Responsibilities:

• Supported Confidential legacy Tandem mainframe system and various subsystems.
• Technical lead on various teams developing processes to indent and mitigate fraudulent use of Confidential fueling card.
• Collaborate wif internal and external clients to identify process improvement opportunities. An example of dis role was as teh technical lead on a team charged wif enhancing Confidential administrative system in support of a major private label partner. Role required numerous face to face meetings and requirement gathering sessions wif 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,

Responsibilities:

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

Confidential, Portland, ME,

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 teh creation and transmission of data files to sales offices in support bonus and incentive sales programs.
• Heavy analysis of existing processes along wif modifications and debugging of existing and new processes.
• Collaboration wif 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 teh production of design documentation based on user specifications.
• Other projects included teh annual redesign of teh 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 teh UNUM’s SDLC protocol.

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

Confidential, Portland, ME

Responsibilities:

• Supported sales reporting systems for Individual Insurance Division’s marketing department along wif 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

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 wif 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

Confidential, Portland, ME,

Responsibilities:

• Individual Disability Insurance Products: Conducted and coordinated market research and analysis.
• Analyzed and consolidated data across product lines;
• Assisted in teh analysis of current processes and recommended solutions; provided end user support for day - to-day use of teh business intelligence data.
• Developed sales materials in collaboration wif division’s marketing department. Edited monthly competitive analysis newsletter to sales force outlining strengths and weaknesses of competitor’s products.

Confidential, Portland, ME,

Responsibilities:

• Manager Advertising and Public Relations: Developed and managed teh development of marketing programs and public relations for teh company’s Individual Disability line of business.

Confidential, Portland, ME,

Responsibilities:

• Manager of New Business processing in teh company’s customer service departments.