Sql Server System

IT Application Developer

Talented IT/Business professional with wide range of computer technical

skills and knowledge in an application development environment.

Experienced in developing and maintaining server based and mainframe

applications and extensive use of different databases. Effectively

communicates with customers and business users to clearly understand their

requirements. Adept in analyzing business requirements and providing

technical solutions that meet the customer's needs. Experienced in

recommending application changes and improvements to further enhance

application effectiveness and efficiency.

Career Accomplishments

. Have developed and maintained both on mainframe and server based

applications.

. Worked on systems of many product types which include a New Business

system, a policy administration system and a producer admin and pay

system.

. Lead programmer on year 2K changes

. Senior programmer on systems projects for both software and hardware

upgrades.

. Have incorporated innovative practices and have looked for

opportunities to leverage technology or processes that are already in

place. Constantly make an effort to reduce workload by automating

manual processes.

. Ability to quickly learn new systems and software

TECHNICAL SKILLS

Languages : PL SQL, PowerBuilder - up to version 10, Merant (server

based Cobol), SQL Server database,

Cobol/MicroFocus Cobol - Mainframe/Server, Assembler

Support Tools: Sybase database, Oracle database, TSO, PVCS, JCL, DOS,

CLIST, DB2 database

PROFESSIONAL EXPERIENCE

Lincoln Financial Group, Hartford, CT

Lead Systems Designer November 2000 - Present

Lead Application Developer - Member of team responsible for supporting

all New Business and

Underwriting applications and processes on daily basis. Supported

Powerbuilder system that were built

with PB 10, PFC, SQL Server database, Merant (server Cobol) and

imbedded SQL Also, supported

Vantage test system using mainframe Cobol and DB2.

* Application related job responsibilities include the research,

analysis, design and implementation of new enhancements and

architectural upgrades.

* Created Cobol programs to interact with New Business system and

Vantage administration system

* Developed SQL calls which were imbedded in or called from the

Cobol programs.

* Duties included running the mainframe policy administration test

system to support product updates.

* Provided system support for DSS system which included

documentation, testing and implementation.

* Developed in PowerBuilder 7 and PowerBuilder 10 using a SQL

Server database. The application also used Powerbuilder PFC,

called external DLLs and imbedded SQL.

* Worked closely with clients and peers on development solutions,

alternatives and integrated solutions

Systems Designer May 1998 - October 2000

* Lead in support and development for producer administrative

systems using PowerBuilder and Microfocus Cobol .

* Provided technical support for the Producer Services team

developing with Cobol and DB2 databases.

* Participated in development and execution of Y2K test plan for

server and mainframe applications.

* Developed SQL Server queries for state audits.

Summary of other positions:

Cigna Corporation April 1976 - May 1998

* Worked with DB2 databases on the mainframe and with Sybase

databases on the server.

* Supported many applications over the years and went into many of

the jobs without prior knowledge of the applications.

* Consistently provided support that made the applications more

stable and efficient.

* Earned the respect and trust of system management and the client

area and was able to move to more challenging positions.

* Began working on mainframe applications, working in output

operations and eventually moving up to lead developer.

* Examples of systems worked on are the ALIS administrative

system, a New Business admin system and an agent's compensation

system.

* Provided design support, development and implementation when

some of the applications were moved to the server.

* Provided training support of new server agent application when

distributed to their field offices.

Education, Classes

Community College Employer sanctioned

courses

Cobol Programming TSO workshops

Assembler programming IBM/JCL for operators

Accounting Advanced IBM/JCL

Marketing Dale Carnegie course

Introduction to Java

PowerBuilder Development

Oracle 10g PL/SQL

Programming Class

LOMA 1 - 8

Personal Information

Address: 47 Cooley Road

North Granby, CT 06060

Home phone: 860-***-****

Cell phone: 860-***-****

Email: ***********@*****.***

Contact this candidate