SUMMARY

• Thirty eight years of experience in development and support of mainframe and micro applications as a Programmer Analyst. Experience includes relational databases, and programming in many mainframe and WINDOWS/WEB languages and UNIX environments.

TECHNICAL BACKGROUND

Hardware: IBM Mainframe, Harris 800 mini, Data General MV Series, PC, DEC ALPHA 8400, RS 6000, AS400.

Programming Languages: MAINFRAME COBOL, PL/1,"C", Quick C for Windows, Visual C++, C#, DOS batch, Quick Basic, JCL, CLIST, REXX, EDIT MACROS, ISPF Dialog Manager, PASCAL, PC and 370 Assembler, MircoFocus COBOL, SAS, EASYTRIEVE, DYL280, FILEAID, ORACLE PL/I, PBASIC or STAMP BASIC.

Mainframe Software(IBM and UNIX): MVS JCL 4.00 z/OS SUPRA Database, INFORMIX Database, UCC7/CA 7, JOBTRACK, CA TAPE MANAGEMENT, SAR REPORT VIEWING, XPEDITER INTERTEST, SMARTTEST, XEDIT, KEDIT, QQF

PC Software: Visual Basic 6.0,Visual Basic 7.0, C# .NET STANDARD, SMARTSORT /COSORT, Norton Utilities 4.5, Word for Windows 2003, MS - Windows 3.0 to XP, FTP, WS FTP, SQLSERVER 2000, WordPerfect 5.1(Windows), EXCEL 2003, MS Project, STACKER, Procomm plus for Windows

APPLICATIONS: Two College School Systems, Custom Programming Direct Marketing,Vehicle Repair History, Problem Tracking Reports, Configuration Change

PROFESSIONAL EXPERIENCE

Confidential, San Diego CA

Consultant/Programmer

Responsibilities:

• Performed Programming and development(TELECOMMUTING). Coding in JCL,-REXX, CLISTS, DB2, VSAM, COBOL, PL/1,-BATCH, ISMF,ISPF, ISPF DIALOG MANAGER .
• Mircosoft office 2010 VBA. EXCEL VBA MACROS. JCL, VSAM, DB2, PLI, SCLM, FILEMANAGER, FILEMANAGER(DB2), SUPFI, QMF, JIRA, SERVICENOW.

Confidential, San Diego CA

Consultant/Programmer

Responsibilities:

• Performed Programming and development(TELECOMMUTING). Coding in JCL,-REXX, CLISTS, DB2, VSAM, COBOL, PL/1,-BATCH, ISPF DIALOG MANAGER and ASSEMBLER. Mircosoft office 2010 VBA. UNIX(CYGWIN).
• .EXCEL VBA MACROS. CICS BMS MACROS.

Confidential, TORRANCE, CA

Consultant/Programmer

Responsibilities:

• ONSITE in TORRANCE, MAINFRAME SUPPORT. COBOL, SDSF, CICS, BATCH, ZEK, CICS XPED, BATCH XPED, TMS, DB2, REXX, CLIST, ZEK, JJ, JJCAN, JCL, EXCEL VBA, LIBRARIAN, FILEAID, FILEAID DB2, IMS, VSAM, AND IBM MAINFRAME. WORKED ON A CAR SYSTEM. VERTEX TAX.

Confidential, SAN DIEO, CA

Consultant/Programmer

Responsibilities:

• ONSITE in SAN DIEGO, CA DEPT. FGG3N. NATURAL/ADABAS, COBOL, SYSVIEW(SDSF), CICS, BATCH, CA7, CICS SMARTTEST, BATCH SMARTTEST, TMS, DB2, REXX, CLIST, CA-JMR, JEM, JSCAN, AS400, SQLSERVER, JCL
• EXCEL VBA, ENDEVOR, FILEAID, VSAM, AND IBM MAINFRAME. WORKED ON A PROPERTY TAX COLLECTION SYSTEM. OTHER: PITNEY BOWES CODE1, DOCUTEXT, CA-DELIVER, CA-VIEW, RMS(REPORT MANAGEMENT SYSTEM).

Confidential, SANTA FE NM

Consultant/Programmer

Responsibilities:

• ONSITE in SANTA FE NM., for the TAX AND REVENUE DEPARTMENT. Coding in: JCL, BATCH, CICS,ISPF DIALOG, CICS, DB2, QMF, SPUFI, REXX, IRXJCL, SAS, EZTRIEVE, REXXTOOLS, CLIST, BATCH XPEDITER, CICS INTERTEST, PANVALET, HIPERSTATION, XMITIP(EMAIL)
• PLATINUM AND FILEAID. Converting REXX ISPF to BATCH COBOL. CODED A BMS MAPPING program. Used EXCELERATOR and MAPBLASTER.
• Worked on a MIGRATION( COBOL, REXX, JCL) process. REXX, DSNREXX to move test data from one table to anorher. EXCEL VBA MACROS. SOLIMAR ELIXIR-AXIAR (UNIX) forms printing process. Maintenance and processing of 100 plus TAX NOTICES.
• SUPPORTED VB.NET, C#.NET, SQL SERVER APPLICATIONS.

Confidential, San Diego CA

Consultant/Programmer

Responsibilities:

• Performed Programming and development(TELECOMMUTING). Coding in JCL,-REXX, CLISTS, DB2, VSAM, COBOL, PL/1,-BATCH, ISPF DIALOG MANAGER and ASSEMBLER. Mircosoft office 2010 VBA. UNIX(CYGWIN).

Confidential, Centreville, VA

Consultant/Programmer

Responsibilities:

• Performed Programming for Morgan Stanley TELECOMMUTING. Coding in SAS JCL-REXX-COBOL,-BATCH. Modified several programs that produced a TOP SECRET report. Wrote an EXCEL 2007 VBA status report consolidation program. . EXCEL VBA MACROS.

Confidential, San Deigo, CA

Consultant/Programmer

Responsibilities:

• Programming for SWEETWATER UNION HIGH SCHOOL DISTRICT. Coding in COBOL in a OPENVMS environment.

Confidential, Centreville, VA

Consultant/Programmer

Responsibilities:

• Performed Programming for ACE INSURANCE COMPANY on site in NEW JERSEY. Coding in Eztrieve JCL-REXX-BATCH. Modified several programs that produced an ACF2 report. Improved BATCH REXX 3.4 ISPF file list for the ACF2 process. . EXCEL VBA MACROS. JAVA SQL SERVER CODING

Confidential, Alpharetta, GA

Consultant/Programmer

Responsibilities:

• Programming for ACCENTURE/SEMPRA/SDGE on site in San Diego Ca.. Coding in Eztrieve, JCL, COBOL, DB2 in their BILLING DEPARTMENT. Created several programs that produced a BILL REDESIGNED output file.
• Maintained current BILL PRINT process. Created FILEAID XREF layouts for Variable Length files. TOOLS used: FILEAIDDB2(FILE AID/RDX), FILEAID, CICS, DB2, VSAM, MOVE TO DB2, CNTL-M, ENDEVOR, XPEDITER, SPUFI, BATCH SPUFI, BATCH REXX, EXCEL VBA.

Confidential, Centreville, VA

Consultant/Programmer

Responsibilities:

• Performed TELECOMMUTING (Virtual private network-VPN) programming for ACE INSURANCE COMPANY. Coding in Eztrieve JCL-REXX-BATCH. Created several programs that produced an ACF2 report. . EXCEL VBA MACROS

Confidential, Park, CA

Consultant/Programmer

Responsibilities:

• Coding in COBOL 390 TSO/MVS/z/OS and IMS/DC/DB, DB2, VSAM, PANVALET, JOBTRACK and JCL/BATCH system for a ISUZU Automotive Company in a Technical programming team.
• Coding includes: Windows XP, EXTRIEVE CLISTS /REXX / ISPF DIALOG, COBOL(DB2,IMS,VSAM,QSAM), MVS, DB2-IMS-FILEAID, EXCEL/ ACCESS/WORD/ OUTLOOK VBA., JOBTRACK.
• Developed and supported Visual Basic 6/ACCESS/EXCEL VBA applications SQLSERVER T-SQL/STORED PROCEDURES, related to the many different projects. Developed a REXX/ISPF PANEL program that calls a DB2 COBOL program. . EXCEL, WORD VBA MACROS

Confidential, New York, NY

Consultant/Programmer

Responsibilities:

• Coding in COBOL 390 TSO/MVS/z/OS and IMS/DC/DB, DB2, VSAM and JCL/BATCH system for a Banking System in a Quality Support Service Technical team.
• Coding includes: Windows XP, CLISTS/REXX/ ISPF DIALOG, COBOL, MVS, FILEAID(FILE AID/RDS), QUALITY CENTER, SYNSORT, EZTRIEVE and EXCEL/ ACCESS/ PROJECT/ POWERPOINT/ VISIO/WORD/ OUTLOOK VBA., ZEKE.
• Developed and supported Visual Basic 6 applications related to the many different projects.

Confidential, Sacramento, CA

Systems Engineer

Responsibilities:

• Coding in COBOL 390 TSO/MVS/z/OS and VISUAL AGE COBOL and VSAM CICS and JCL/BATCH system for DHS/EDS MEDICAL in a Service Delivery/Technical team.
• Coding includes: Windows XP, SAS, CLISTS/REXX/ISPF DIALOG, COBOL, MVS, CICS/INTERTEST, FILEAID, SYNSORT, ASSEMBLER and EXCEL/WORD/OUTLOOK VBA, Crystal Reports 9.0. Developed and supported Visual Basic 6 applications related to the many different projects.

Confidential, La Jolla, CA

Senior Programmer Analyst

Responsibilities:

• Coding in COBOL 390 and RAMIS on a CMS system. Working in a Customs Solutions group. Coding includes: Windows 2000, REXX, COBOL, ACCESS 2002, VISUAL BASIC 6.0, EXCEL 2002, SQLSERVER 2000, SPSS, SAS, WINBATCH.
• Developed and supported Visual Basic 6 applications related to the many different projects.

Confidential, San Diego, CA

Senior Programmer Analyst

Responsibilities:

• Coding in COBOL 390 for a DB2, VSAM CICS and BATCH system. Working for the SDCCD School System. Involved in a Supra Database conversion to DB2.
• Involved in maintenance of the student online and batch systems. Assignments include DB2, UNIX and WINDOWS environments, Testing, and conversion of an SUPRA HR system to an IBM 9672 DB2.
• Developed and supported Visual Basic 6 applications related to the many different projects.

Confidential, San Diego, CA

Senior Programmer Analyst

Responsibilities:

• Coded in COBOL II(REL 3.2) for a DB2, VSAM, ORIGINAL EQUIPMENT MANUFACTURER SYSTEM. This is a parts database for many automotive manufacturers. Coded an MVS Cobol DB2 conversion to UNIX Oracle MicroFocus Cobol.

Confidential, San Diego, CA

Consultant

Responsibilities:

• For San Diego Gas & Electric, coded in COBOL II(REL 3.2) for a CICS DB2, VSAM, ENVIRONMENTAL HAZARDOUS WASTE SYSTEM, coded a conversion from COBOL to COBOL II for the FLEET system. Maintained, developed and configured ACCESS databases for the TELECOM system.

Confidential, San Diego, CA

Programmer Analyst

Responsibilities:

• For GALAXY 2000 Credit Union System Division, developed and maintained programs for the individual Credit Unions of the organization. Used a Data General computer with an AOS operation system. Programmed in PL/I using an SQL relational database.

Confidential, San Francisco, CA

Consultant

Responsibilities:

• For Pacific Bell, developed and maintained programs for a voucher adjustment system and a marketing inquiry system in which sales staff could configure products with engineering staff.
• Used IBM Mainframe, VM/CMS, PL/I, REXX, SAS, DB2, MVS, JCL, XMENU, ABC Flowcharter, Visual BASIC, IBM PC, DOS 5.0, Windows 3.0, COBOL II 3.1.

Confidential, Romulus, MI

Programmer Analyst

Responsibilities:

• Maintained and enhanced the Vehicle Repair History System for General Motors as a systems analyst and technical support programmer. Wrote online system to retrieve database information using DB2
• ISPF Dialog Manager, REXX, CLIST, EASYTRIEVE, SAS,MVS ASSEMBLER, and PL/I and COBOL Wrote DB2/QMF reports for a problem tracking system and a configuration change request system.
• Maintained/developed a DB2 database load system using PL/I. Developed a system to verify the integrity of a communications system maintenance upgrades using Microsoft "C" 5.1, PC-Macro assembler 5.0, and QUICKBASIC.

Confidential, Monterey, CA

Programmer

Responsibilities:

• Implemented a direct marketing system for a food supplement company in a COBOL CICS/DLI environment. Wrote batch COBOL/DLI programs, wrote and maintained production JCL, assisted senior programmer in the installation of McCormick and Dodge AP, AR, and GL package operating under CICS/DC/DB and MVS.