Sign in

Software Developer Sql Server

Queens Village, New York, 11429, United States
March 06, 2012

Contact this candidate

Phil Hayden

***-** ***** ****

Queens Village, NY 11429



OS Related: IBM Z/OS, VSE/ESA, ICCF, IMS/MVS, SPUFI/QMF, TSO/ISPF, Windows NT – 2003 Server, JCL

Programming: CICS, BMS, COBOL, RPGII, Assembler, PL/1, CA-Top Secret

Crystal Reports XI, Power Builder, PL/SQL(Oracle SQL),Transact-SQL(SQL Server)

Database: DB2 v9, VSAM, Oracle, SQL Server , CA-Top Secret


Volt Workforce Solutions, Philadelphia, PA 08/10 to 12/11

IT Consultant/ Senior Software Developer

Developed Publications Software utilizing Cobol, PL/1,CICS and DB2 Stored Procedures in a fast paced environment to enrich the process of creating YELLOW PAGES advertisements. Responsible for the maintenance and support of the Sales Force system integration from an MS/SQL server to the Mainframe DB2 Tables , producing sales reports, invoices and payroll files. Created CICS modules to maintain phone book directory information which also defined geographical boundaries of each directory. Responsible for the creation of DB2 Loads and Unloads of directory tables to store data across multiple regions.

U.S Mortgage Company, Pine Brook, NJ 11/04 to 06/09

IT Consultant/ Senior Software Developer

Coded and created a user friendly online Cobol/CICS historic mortgage application system for HMDA and State / Banking Audits, dramatically reducing time spent archiving prior years analytical data reports.

Responsible for the maintenance and enhancement of the loan origination and servicing software. Duties included Database field mappings of required mortgage disclosures, Logic enhancement via Gupta code, data reporting via Crystal XI Reports Web Enterprise, and Data Extraction via MS SQL, Sybase SQL on a multi-tier Windows network environment.

Telcordia Technologies, Piscataway, NJ 11/00 to 03/04

Senior Software Developer

Areas of development and maintenance covered Customer Record and Number Administration processing for routing of 800 Toll Free numbers to Service Control Points across the Number Planning Area, utilizing PL1, COBOL, CICS, VSAM, under IMS/MVS. Position required a strong emphasis on quality control utilizing CMM (Capability Maturity Model) as well as ISO (International Standards Organization) 9000 compliance throughout the whole development cycle.

Prepared technical design, document, flow analysis, development, testing and integration testing of all code requirements developed.

Kanebo Information Systems Corp., NY, NY 11/94 to 10/00

Senior Software Developer

Responsible for various software development project of Japanese bank in US operations

which included installation and customize integrated global banking system on IBM mainframe utilizing PL1, CICS, VSAM. Designed, programmed and distributed ACH, Payroll, and Check processing Interfaces.

Created a loan transaction detail database interface utilizing PowerBuilder and Transact-Sql

Responsible for Disaster Recovery procedures that includes utilization of disaster recovery facility

from DASD restoration, system/application start up and remote connection interfaces over multiple facilities.

Development software covered wholesale banking to retail banking, such as commercial loans, international funding, foreign exchange and associated general accounting


LaGuardia Community College, LIC, New York

PSI Institute, New York, NY Certificate of Computer Programming

Grumman’s Data Systems Institute, L.I, N.Y Certificate of Computer Operations

Contact this candidate