Project System

Accomplished IT professional with solid application development background

and strong communication and organizational skills. Skilled at application

development, analysis, testing, and implementation. Demonstrated ability to

learn new technology and apply to projects using my years of experience in

both mainframe and distributed platforms working with varying relational

databases using SQL and MS OFFICE. Proficient in MS OFFICE. Well-developed

problem-solving skills including a concentration on data analysis. Works

best in team environment.

Professional Experience

ING, Inc., Windsor, CT

2001 - 2008

Sr. Systems Analyst

Team lead on the Valuation Pricing and Trading System and the Fund

Performance System in this large Financial Services company. These are

critical systems which required daily dedication and a sense of urgency.

This job required the ability to think quickly and resolve problems

quickly, both on new projects and existing production support. Involved

with both major IT projects and daily enhancements.

Analysis, Development, Testing, and Implementation on the following

projects:

- Fund Number Expansion (affecting every system in IT) - very

large

- Adding a new data gathering and processing system to Retirement

Services - very large

- Updating the content and format of all mutual fund trading files

- large

- Creating a trade cancellation process through NSCC - medium

- Creating a new Trust Model to accommodate complicated accounting

of trades - large

- Redesign of entire pricing and trading system - very large

- Write and Implement SOX documentation for 3 systems - medium

- Redesign the handling of all trade output files - small

Tasks accomplished:

- Worked closely with the business partners to gather business

requirements, work out solutions, and write business

specifications using MS Word, MS EXCEL and Use Cases for new

projects

- Analysis, Development, Testing and Implementation on all

enhancements and projects for above systems using Visual Basic

6.0, Sysbase, SQL, Rightfax.

- Determined solutions to system failures of existing system

- Documented system changes and procedures

- Worked closely with members of other systems (mainframe,

distributed, and web) to gather their system requirements

- Extensive work on problem resolution determining data defects

- Analyzed and updated data in relational (Sybase, MS ACCESS, DB2)

- System Analysis using SQL and MS Excel

- Integrated testing with other systems

- Maintained project plans using MS Project

- Managed changing priorities and dates on the project plan

- Acted as Subject Matter Expert for the Pricing and Trading

System

- Created test plans used to research valid test cases.

- Used SQL to create new tables in Sybase database, defining data

and the functions of it.

- Translated business specifications into technical specifications

using MS Word/MS Excel

- Created SOX documentation for 3 systems using MS WORD/MS

EXCEL/MS VISIO. This included text document explaining the

processes and controls, spreadsheets mapping out controls, and

process flows for the 3 systems.

- Created XML files to process data correctly

- Monitored the completeness and accuracy of two daily web

applications

- Mentored junior members of the team and trained offshore

consultants

Aetna Insurance, Hartford, CT

1999 - 2001

Sr. Programmer Analyst Contractor

. Rewrote existing system requiring a great deal of design, analysis and

working closely with the business partner. The technology used was VB

5.0, SYBASE database, Rapid SQL and Crystal Reports.

. Led a complete data base conversion. Wrote all stored procedures and

scripts to create new tables, modify existing tables, and convert

existing data to current specifications, which the team was dependent on.

Project went in on time allowing executive management to be able to see

what projects were being worked on and what progress was being made.

Travelers Insurance, Hartford, CT

1984 - 1999

Sr. Programmer Analyst Contractor

. Coded Computer Telephony Integration system using Visual Basic 5.0 and

used an Oracle database. Developed and implemented several stored

procedures in Oracle, allowing the company to make calls easily and

increase new business.

. Worked on a Reporting system written in SQL SERVER, C, ORACLE, and Visual

Basic. Used mostly DBARTISIAN as a third party Oracle utility to convert

database data into flat files and then reload onto Oracle. Involved

writing both embedded SELECT statements and calls to SQL SERVER stored

procedures used by participants working on the system.

Sr. Programmer Analyst

. Sr. Programmer Analyst on large team to create two new workstations -

Life Health workstation and Sales Illustration workstation. Coded these

workstations in Visual Basic, C, EASEL, Microfocus Cobol, QMF, and SQL.

Both jobs included analysis, design, development, testing, and

implementation. Worked closely with other areas to define database

requirements involving a great deal of customer interaction. The

implementations of these systems gave agents the ability to easily and

accurately supply customers an illustration of what their investment

might look like with a very positive effect on sales.

. Project Lead for new platform for all workstations representing the

workstations for Technical Support Area and IBM. Involved bringing

together IBM programmers, workstation programmers, real-time programmers,

and Computer Science programmers and meeting a deadline. The technology

needed to keep track of included visual parts, non-visual parts, MQ

Series on p.c. MQ Series on the host, and performance timings. Researched

and wrote all requirements which were used as final summarization of

entire project. Implemented new platform for all workstations with

minimal fall out.

. Supported production and sole programmer for DB2 system using QMF and

SPUFI .

Education

Management Information Systems, Central Connecticut State University, New

Britain, CT,

3 years towards B.S. degree in Management Information Systems

Manchester Community Technical College, Manchester, CT, A.S. Computer

Programming

Professional Development

. Started my own Limited Liability Company - advertising, marketing,

accounting, taxes, etc.

. Completed a Java programming class on my own time at Manchester Community

Technical College

. Completed Web Development class on my own time at Manchester Community

Technical College

. Completed classes for MCAS (Microsoft Certified Application Specialist)

. Team Lead for Web site development for Protectors of Animals - a local

animal shelter

. Staff member of Protectors of Animals newsletter

Contact this candidate