Objective
Provide application development and database administration services for SQL Server, DB2, Oracle, MYSQL, Microsoft Office in Health Insurance, Financial services and Real Estate.

Summary
Over 10 years of programming experience and development of database applications in IBM mainframe and Windows environments with industry focus on real estate, health care and financial sectors. Developed applications in large IBM mainframe environments for most of career. Changes in market place have presented opportunities to work with new computing environments. Webmaster certification.
Extensive experience in SAS, SAS/MACROS, COBOL, PL/1, ASSEMBLER, Microsoft Office, DB2, IMS, Oracle, CICS, JavaScript, Java, Real media, OS/390 MVS, IDCAMS, VSAM, GDGs, TSO/ISPF, FILEAID, CLISTS, JCL, REXX, Internet, Windows NT, Windows 2000, Windows XP, Unix, Linux, ASP, VBScript, HTML, Cold Fusion, MYSQL, PHP, Sql Server and Visual Basic

Employment

April, 2008 -  Present

Prepared Excel spreadsheets for Strategic Planning Group in the New York City Department of Housing Preservation and Development. Duties performed include data entry ; project reconciliation and analysis ; database lookups, Excel and Word-based project assistance.

January, 2006 -  Present
Nardin Realty Associate

Rentals, Sales, Government programs, Pre-Foreclosure.
Show properties to clients. Assist with applications.
Website maintenance for Internet properties inventory.

Developed JavaScript, Microsoft Office and Internet applications to manage sales, rental and pre-foreclosure inventory. Often programmed in Visual Basic, Excel, VBA matching real estate inventory to customer interests for Real Estate brokerage.

August, 2005 -  December, 2005

Advertising available apartments on the Internet.
Photographing available property and uploading images to website.
Updating real estate inventory databases.
Attending open house functions.

July, 2005 -  December, 2005

Production Assistant provided document solutions and business services. Operated binding and other auxiliary equipment. Provided customer service, anticipating customer needs, suggesting alternatives and problem solving with a minimum amount of supervision. Accepted customer orders, giving pricing information, performed consultative selling to customers and explained the benefits of digital printing technology to customers. Performed multiple tasks at the same time, using automatic equipment capabilities. Picked up and delivered customer orders. Collated, sorted and organized customer orders. Produced work in accordance to pre-established priorities of customer projects. Operated the Point of Sale terminal POS, handled money and made change. Followed copying protocol copyright law, confidentiality and careful handling of original documents

February, 2005 -  May, 2005

A member of the core team engaged in SAS Anti-Money Laundering product application support and development. Provided production SAS log analysis for daily Anti- Money Laundering production job streams. Reviewed and documented anti-money laundering routines written in SAS to detect a variety of potential money laundering behaviors/scenarios. Extensive use of HTML and Intranet to present system documentation and scenario relationships.

Application environment was UNIX, Linux, Windows XP with DB2 Universal Database, Visio, SAS, SAS Macros, SQL, Excel, VBA and other Microsoft Office products. Sun Ultra 80 Model 2450, Solaris 8 64 Bit, Ultra Sparc II 4 CPU 4GB RAM, Dell PowerEdge 6650, RED HAT LINUX 2.1 32 BIT, Intel 2000MHz 8 CPU 16GB RAM
Web Application Server SAS Application Server SAS/Internet Server.

September, 2004 -  December, 2004

Contract DB2 programmer for data warehouse and data modeling team developing health insurance accounts receivables reporting applications at Empire Blue Cross and Blue Shield using business objects. My responsibilities were to prepare ETL functions, written as COBOL programs, to load vendor data files to DB2 tables that would provide reference tables for multi-dimension online analytical processes and business objects applications ; develop functional and program specifications ; production JCL, create test plans, quality assurance, data validation and test scripting.

Application environment was IBM OS 390 Windows XP with COBOL, DB2, QMF, SPUFI, Attachmate, Visio, SAS, TSO/ISPF, Endevor, File-Aid, JCL, Excel, VBA and other Microsoft Office products.

September, 2003 -  March, 2004

SAS programmer with MVS, DB2 and COBOL on a team developing a cohort Risk Adjuster interface with SAS modules. The system collected extracted patient demographic and diagnostic claim information for the SAS model components that computed what the risk adjustment factors for Medicare and Medicaid payments should be per federal guidelines. The project progressed through different levels of software testing from unit testing, integration and system testing through acceptance testing and installation.

Languages and platforms : SAS, SAS Macros, DB2, TSO/ISPF, Endevor, FileAid, Syncsort, Excel, VBA, Office, COBOL, JCL, OS/390

September, 2001 -  August, 2002

Programmer Analyst. Supported the production environment and developed mainframe and LAN applications serving Sears Credit Collection Strategy department. The credit collection department was involved in telemarketing collections and remediation of accounts in varying degrees of delinquency. The primary applications being supported searched private and proprietary databases for delinquent accounts, alternate telephone numbers and address information and applied the new data as updates to customer databases through data entry programs written in Visual Basic, through CICS transactions, Access databases and Excel spreadsheets.

Batch files were transmitted using FTP between Sears and vendor sites for customer database updates and processed through LAN based SAS PC and daily batch mainframe programs.

The computer environment was SAS, SAS Macros, VB 6, Access, TSO/ISPF, OPC, Windows NT 4.0 Excel, FTP, JCL, VBA, Office OS/390

February, 2000 -  May, 2001

Senior Associate Developer, as part of the data warehouse application development team supporting business intelligence and market research. The applications involved tracking broker activity and calculating daily, monthly and annual brokerage commission projections. Prepared and scheduled user written SAS programs, developed COBOL programs and JCL for production environment and analyzed brokerage account activity and production support. Loaded data warehouse and refined data models and elements. Shared responsibility for technical system design but had more responsibility for programming, testing, user acceptance and implementation.

The computer environment was SAS, Hyperion, Humming Bird BI, COBOL, TSO/ISPF, JCL, GDGs, FileAid, Syncsort, DB2, SPUFI, QMF, SQL, OPC, NDM, Windows NT 4.0 Excel, FTP, UNIX, VBA, Office OS/390

October, 1999 -  December, 1999

Programmer. The responsibilities of this position involved SAS programming and Excel spreadsheets for the Human Resource department at Chase. User ad hoc requests for database extracts required new SAS programs to combine data residing on DB2/Access views of multiple Human Resource databases. The data extracts were transferred to the Excel spreadsheet for further processing by Visual Basic macros and delivered to the requestors as e-mail attachments. Responsible for programming, testing, user acceptance and implementation.

The computer environment was TSO/ISPF, SPUFI, QMF, SQL, SAS/Access, CICS, Lotus Notes, Windows NT 4.0, Novell, Excel and Visual Basic.

May, 1999 -  August, 1999

Consultant. This assignment involved completing backlogged maintenance requests and developing a direct store market analysis system to enable product costing in a hierarchy of stores, regions and company-wide for an IBM client, Eckerd Pharmacy. Other responsibilities included production ABEND support and research, maintenance programming for Logistics and order fulfillment. Responsible for programming, testing, user acceptance and implementation.

The environment was Windows NT 4.0, IBM Personal Communications, COBOL II, Excel, PowerPoint, Word, VSAM, TSO/ISPF and MVS JCL.

January, 1999 -  March, 1999
Computer Manager

Consultant. This assignments responsibilities were installing several reporting applications across different platforms for users in the circulation management areas, production support and analyzing computer resources consumed by these systems. The reporting systems had been running in test mode submitted on request by the programming staff. Responsible for programming, testing, user acceptance and implementation.

Environment was remote IBM ESA 3090 multiple CPUs, Windows NT 4.0 and Unix. Languages and software used included DB2, COBOL II, FTP, TSO/ISPF, JCL, Endevor, CLIST, GDGs, Easytrieve, File Aid, Syncsort and SAS.

June, 1998 -  December, 1998
Helene Miller Associate

Consultant. Developed and maintained IBM COBOL II batch programs, JCL and documentation for a legacy employee benefits application. Developed and modified client specific benefit reporting ; programmed general and specific data extracts ; modified and generated client benefit transactions. Responsible for programming, testing, user acceptance and implementation.

Environment included Abend Aid, ENDEVOR, File Aid, Syncsort, VSAM, TSO/ISPF, JCL, IDCAMS, GDGs XPEDITOR and OmniPay Employee Benefits System software.

March, 1998 -  June, 1998
Prudential Bache Securities/ Pinkerton Computer Consultant

Consultant. This assignment involved development and maintenance of IBM COBOL II batch programs, maintenance of CICS applications and JCL for legacy brokerage stock positions applications. Developed and modified client specific stock positions reporting ; programmed general and specific data extracts, file comparison. Responsible for programming, testing, user acceptance and implementation.

Environment included INFOMAN, File Aid, Syncsort, Abend Aid, VSAM, IDCAMS, GDGs, TSO/ISPF, Novell NetWare and IRMA.

December, 1997 -  February, 1998
Banker

Consultant. This assignment involved Y2K conversion of IBM COBOL II batch programs. Responsibilities of the position consisted of program analysis and Y2K modifications to property accounting system COBOL II programs.
Responsible for documentation, programming and testing.

Environment included FILEAID, Abend Aid, VSAM, TSO/ISPF, REXX, Windows NT 4.0, Extra Attachmate.

November, 1996 -  December, 1997
Interim Consultant

Consultant. This assignment involved maintenance programming for IBM mainframe of batch COBOL and CICS legacy accounts receivable systems in a TSO/ISPF, LIBRARIAN environment. The connection to the mainframe was through IRMA and NETWARE using DELL 486 SX 33 MHz PCs, WINDOWS 3.1. The batch COBOL programs were CAPEX optimized, standard IBM COBOL and COBOL II. The client companys name changed from Corning Clinical Labs to Quest Diagnostics. The majority of the work at the beginning of this project involved changing the company name on external and internal reports produced by accounts receivable applications. After the completion of name changes the responsibilities were split between maintaining client specific claims processing batch and online applications, producing ad hoc reports and special projects. Responsible for programming, testing, user acceptance and implementation.

Environment included COBOL II, CICS, LIBRARIAN, FILEAID, Abend Aid, VSAM, IDCAMS, GDGs, JCL, TSO/ISPF.

January, 1996 -  November, 1996

Senior Programmer/Analyst. The objectives of this position were to develop, utilize and install COBOL II, IBM MVS Utilities and SAS application programs for MVS or VSE or PC environment and provide EDI GENTRAN/BASIC application support in several user areas for clients involved in claims processing for health care organizations.
Responsible for programming, testing, user acceptance and implementation.

June, 1994 -  January, 1996

DP Consultant. Installed enhancements to a property management accounting system and provided application support in several user areas for a client involved in gas and electric power utility services. Responsibilities were to replace an existing DB2 table and modify and expand on-line updating and inquiry capabilities using ISPF dialog manager. The application was a combination of programs that were written in COBOL II, DB2, CLIST, Dialog Manager, Lotus 123 Spread Sheets and MS DOS batch programs on BANYAN Vines network.

American Express - Phoenix, AZ
DP Consultant. The technical aspects of this position started with maintaining several job streams. These jobs streams had to be changed regularly, depending upon the frequency they were requested. Developed CLIST applications to automate the required changes. The automation effectively reduced hours of maintenance to minutes. Automating the manual tasks freed up resources to allow growth of the position to include developing and enhancing ad hoc reports and ISPF dialogs. The dialog built JCL based on different variables entered from a panel. Enhancements to dialog enabled a wider variety of reports and analysis to be obtained. The reports were produced by a combination of SORT, COBOL and SAS programs.

June, 1993 -  April, 1994

Provided program maintenance and testing for clients in 3 industry areas, pharmacy related health insurance, pharmacy market research and public utility.

Walsh America/ Pharmaceutical Card Services - Phoenix, AZ

DP Consultant. The details of this position involved programming development and maintenance for several clients. Most the assignments involved COBOL and COBOL II in a large IBM MVS/XA or MVS/ESA environment. Modified claims and billing applications and test IMS/DLI user written input-output for the health insurance client. Other assignments involved testing IMS/DLI I/O modules written in COBOL II for a large pharmacy insurance claims database. All of the IMS interfaces in the batch billing system were replaced when the database was restructured. Claims were transmitted to the data center via NDM that triggered batch billing jobs scheduled for the incoming file. Responsible for programming, testing, user acceptance and implementation.

Software, programs and utilities used on this assignment were IMS/DLI, COBOL II, DYL280 TSO/ISPF, MVS JCL, IDCAMS, GDGs and Network Data Mover.

Arizona Public Service Phoenix, AZ

The assignment with the Public Utility company involved maintaining programs written in PL/I and developing new programs written in COBOL II. Technical skills required for this position consisted of IMS DB/DC, MFS, DB2, COBOL II, PL/I, JCL, TSO ISPF and SAS.

September, 1991 -  June, 1993
System Engineer

DP Consultant. The details of this position involved programming development and maintenance for several clients in different industry areas. Most the assignments involved PL/I, COBOL and COBOL II in a large IBM MVS/XA or MVS/ESA environment. The industry areas served were state government, financial card services, defense manufacturing and computer vendor.

State of Arizona Department Of Transportation Phoenix, AZ
The assignment with the state government involved maintaining PL/I IMS DB/DC applications for Motor Vehicle Department. Technical skills required for this position were familiarity with PL/I IMS DB/DC, JCL, TSO ISPF and COBOL II.

American Express Phoenix, AZ
The project with financial card services involved developing COBOL II programs that paralleled statistical models written in SAS. The position required the programmer to express in COBOL or COBOL II, the formula and routines that defined a parameter for measuring or predicting the market response to merchandise promotions offered by the client.

Hughes Aircraft Tuscon, AZ
The assignment with the defense manufacturer consisted of enhancing accounting applications for personnel and payroll. Accounting applications were written in COBOL. Technical skills required for this position included Easytrieve, DB2, JCL, TSO ISPF and IMS DB/DC.

Education

Training
Working on MS SQL Server, Oracle, DB2 UDB to master database administration and development. Topic includes data storage and management, transformation, security, database replication, troubleshooting, monitoring, and optimizing.