Systems Project

JAMES D. MORRISSEY

** ******** ***** ********, **. 02025 781-***-**** ***********@*****.***

SKILLS SUMMARY

Accomplished hands-on IT professional with a sense of pride and urgency to get the job done. Experienced in Legacy system conversions, using SQL, SSIS, SSRS and Informatica. Close interaction with the business community, often meeting with various staff for their needs. Able to provide my various business partners with quick, viable and cost efficient methods of getting issues resolved and a project or task completed.

Development

Environments: Visual Studio, MS Access, MVS, CICS, ISPF/TSO PeopleSoft, Informatica Power Center.

Languages/ Tools: COBOL, CICS, DB2, QMF, DataQuant, SQL T-SQL, Stored Procedures, DTS, HTML,

JavaScript, VBScript, Visual Basic 6.0, VB.NET, PL1, Natural, JCL, Easytrieve,

Control-M, Control_D, Visio, Endevor, PVCS, Subversion, Tortoise, TOAD, Fusion,

FTP, Sharepoint, SSIS, SSRS, MS Project, MS Word, MS Excel, SDLC, Project Planning, Change & Release Management. .

Databases: MS SQL Server, DB2 MVS, DB2 AIX, MS Access, Oracle, Adabas, Datacom, VSAM

Professional Experience

ONEBEACON INSURANCE COMPANY, Canton, MA. Sept 2002 – Present

Team Lead /Senior Programmer Analyst

Enhance and maintain numerous Batch COBOL, DB2 apps as well as SQL related applications.

Coordinated Disaster Recovery efforts for team with offshore and onshore resources.

Maintaining Vendors VB.NET Sub ledger Vendor application that interacts with PeopleSoft GL. The vendor no longer supports the application for us. My role is that of a Business Analyst as well as the Lead Developer. This is for 3 separate instances: Claims, Treasury and Receivables.

Handle any and all service tickets that come in for the customers of the Finance team. Could be ODBC connection issues, MS Word/Excel issues, laptop, VPN, DB2 Connect, remote desktop, mapping drives, trouble-shooting and identifying software bugs and then modifying, testing and implementing the change into production using Footprints tickets.

Leading project converting batch COBOL legacy Tax application with an Access front end over to Web Based application using SSIS and SSRS.

Created workflows and Informatica mappings to build business rules to load data using Source qualifier, Aggregator, Expressions, Connected and Unconnected lookups, Filters, etc.

PeopleSoft development using App designer and SQR and PeopleTools.

INVESTORS BANK AND TRUST, Boston, MA. Oct 2001 – July 2002

Senior Systems Consultant (The Programmers Connection, Inc).

Enhanced and maintained numerous programs in the Transfer Agent Systems area using COBOL.

Made various changes to Customers Statements and Confirms. This was usually accomplished using a Standard Extract & Formatter program.

STATE STREET BANK, Boston, MA. Feb 2001 – Oct 2001

Senior Systems Consultant (The Programmers Connection, Inc).

Worked on the Datacom to DB2 Conversion for the DML Securities Lending Team.

Represent the Securities Lending team from an application design & programmers standpoint. Designed 22 major DB2 tables, these tables were previously Datacom tables.

Modified 43 online CICS programs to remove CICS commands and replace it with the appropriate SQL logic. Test all of these programs using Expeditor for CICS.

BROWN BROTHERS HARRIMAN Boston, MA. Nov 2000 – Feb 2001

Senior Systems Consultant (Adept Incorporated).

Worked on Custody team to code, test and implement into production the NRA (Non Resident Alien) tax system. Needed to be familiar with the daily & nightly batch cycles to test all changes.

Wrote a report programs using the DB2 Platinum reporting facility.

NEW ENGLAND FINANCIAL Boston, MA. April 2000 – Nov 2000

Senior Systems Consultant (Eliassen Group, Inc).

Modified “Welcome Guide” system for various issues including: sending duplicate letters to customers, letters to incorrect address, and letters to incorrect policy owners.

Worked on team to “shake out” bugs in the bridging of the EPS Warehouse to Client Solutions tables. Needed to load test DB2 tables with production data and run the batch nightly process to find bugs.

Correct any and all programs when the bugs were detected.

JOHN HANCOCK INSURANCE COMPANY Boston, MA. 1999 – 2000

Senior Systems Consultant (Software Consulting Network).

Interview new outside clients (Lockheed Martin) coming onto the system, to determine requirements needed by both parties. Analyze, program (utilizing COBOL with DB2 SQL), test and document and implement into the production environment.

Enhance and maintain existing billing and payment systems.

STATE STREET BANK, Quincy, MA. 1997 – 1999

Senior Systems Consultant (Software Consulting Network)

Worked on Y2K solutions. Tasks include analysis of programs for possible Y2K issues.

Utilize the Y2K software tool “Platinum 2000” to help with the analysis of the application programs.

Modify PL1 programs when Y2K issues found.

FIDELITY INVESTMENTS, Boston, MA. 1996 - 1997

Senior Systems Consultant (Computer Sciences Incorporated)

Worked in FBSI (Brokerage Services) as well as FITE (Testing Environment).

Maintain and build tools to automate several Brokerage Systems batch environments.

Programmed mainly in batch COBOL with DB2.

J. BAKER, INC. Canton, MA. 1994 - 1996

Senior Programmer Analyst

Interviewed various clients as to their system requirements, so we could bring them into our system.

Supervised programmers and analysts during life cycle of this project.

Created programs using the Electronic Data Interface (EDI) standard.

Responsible for preparing approach documents, detail design documents, and coding programs for all

systems worked on.

NEW BALANCE ATHLETIC SHOE, Allston, MA. 1990 - 1994

Programmer Analyst.

Maintain and enhance batch COBOL & on-line CICS Order Entry System.

Developed new batch & on-line Sales Forecasting System. Maintain payroll & A/P systems.

EDUCATION

Clark University Client Server Programming/Web Development

Northeastern University

Boston State College Boston, Ma

Contact this candidate