CERTIFICATES





 
 
AWARDS



DEGREES


...

 
      

GLOBAL CONSULTANTS INC/JPMORGAN CHASE BANK ....................................... Columbus, Oh.

Consultant/Programmer

Apr. 2005 to Jun. 2006

Coding in COBOL 390 z/OS and VSAM, JCL/BATCH system for a Banking System in a Quality Support Service and Evironmental development Technical team.. Coding includes: Windows XP, CLISTS/REXX/ISPF, COBOL, db2COBOL, MVS, imsFILEAID, db2FILEAID, SYNSORT and EXCEL/WORD/OUTLOOK/ACCESS/PROJECT VBA. Wrote, supported ACCESS/EXCEL VBA programs supporting an Accout Selection Process. This system allows users to select accounts against a DB2/IMS Database. These Accounts were first entered into a EXCEL/VBA Spreadsheet and then processed thru REXX/ISPF extract process. The data was then tracked using an ACCESS database using FTP to the MAINFRAME. Wrote programs in VBA ACCESS to FTP data to and from the MAINFRAME into the ACCESS database or from the ACCESS database to the MAINFRAME. Wrote/maintained ISPF/REXX programs to build test environments, to compile programs, to extract data and to create reports. Wrote COBOL/EZTRIEVE(VSAM, DB2, IMS) to extract data and create reports. Created EXCEL forms to collect user data for requesting account data. Used ATTACHMATE EXTRA for MAINFRAME and IBM eNetwork Personal Communications for emulation.

BLUE PLANET SOLUTIONS / ELECTRONIC DATA SYSTEMS....................................... Sacramento, CA.

Systems Engineer

Dec. 2002 to Aug. 2004

Coding in COBOL 390 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, CLISTS/REXX/ISPF, COBOL, MVS, CICS/INTERTEST, FILEAID, SYNSORT and EXCEL/WORD/OUTLOOK VBA. Wrote, supported WORD VBA problem tracking system. Supported an EXCEL VBA batch process, using data FTP’D from the MAINFRAME. Wrote a CICS program from scratch that would allow entering of A/R transactions. Maintained, supported many CICS programs from many different sub systems. Involved in a major SYSTEM DEVELOPMENT PROCESS, where 100 batch(JCL) jobs were converted. Built quick reports using ACCESS, CRYSTAL REPORTS for clients.

HARTE-HANKS........................................................................................................................ La Jolla, CA

Senior Programmer Analyst

Nov. 2000 to Mar. 2002

Coding in COBOL 390 and RAMIS on a CMS system. Working in a Customs Solutions group. Coding includes: Windows 2000, REXX, SYNCSORT, COBOL, ACCESS 2002, VISUAL BASIC 6.0, EXCEL 2002, SQLSERVER 2000, SPSS, SAS, WINBATCH. Developed and supported an ACCESS 2002 database that tracked programmer hours and projects. Wrote VISUAL BASIC programs that accessed and populated SQLSEVER, ACCESS tables for delivery to clients. Wrote complex VISUAL BASIC programs in EXCEL to arrange data in many formats as needed by clients Wrote complex programs in COBOL, REXX, SYNCSORT, WINBATCH, SAS and RAMIS to extract data and process data. This involved extracting data on the MAINFRAME and then formatting the data and moving the data to the PC environment and then delivering this data to the client in the format that they needed. This could be in a bunch of different products( ACCESS, EXCEL, WORD, TEXT, or SAS). Other support was to maintain three NT SERVERS, make data CDS that were sent to clients, made labels, use of COSORT(this a powerful sort program that was used in the PC environment), FTP, WS-FTP, wrote SAS v8 programs to extract data and arrange data(ODBC,SQLSERVER). Worked on a project that would convert a Borland C++ file matching system to MICROSOFT VISUAL C++. Worked on a project to FTP data using VISUAL BASIC API CALLS from one sever to another in batch mode. Kedit edits files of any size really cool. SPF-SE for PC does not edit any file size only 100 mb. Used MAINFRAME emulators, PASSPORT, IRMA, IBM eNetwork Personal Communications.

SYSTEMS COMPUTER TECHNOLOGY ............................................................................San Diego, CA

Senior Programmer Analyst

Aug. 1997 to Nov. 2000

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.Converted many programs from SUPRA student system on an IBM 4381 computer to an IBM 9672 DB2 system. This involved writing imbedded COBOL DB2 code and the supporting JCL and PROCS, also, on the CICS side converted many COBOL CICS programs that allowed input and extraction of data from the DB2 tables. Supported a SIGMA STUDENT FININCIAL AID SYSTEM (batch and online and ACCESS) this involved many COBOL programs and VSAM files. Also, did the same conversion for SDCCD(San Diego Community College District)HUMAN RESOURCES(HR) CICS online system and batch system. Also, trained many programmers in the process of the conversion. This included DB2, COBOL, JCL(PROCS), SUPERC(ELECTRONIC FILE COMPARES), REXX, SYNCSORT, CICS screen generation in house product, EASYTRIEVE, FILEAID, PDSMAN, SPUFI, EXTRA(MAINFRAME EMULATOR), and in general the ISPF environment. Other tools used are VISUAL BASIC(QUICK BASIC), INFORMIX DATABASE, EXCEED(UNIX), BATCHMAN, HOURGLASS, EASYEDIT, DOS BATCH, JCL FTP, WS FTP, WORD(for documentation…etc). ISPFEDIT program to convert known programs to the conversion programs.

MITCHELL, INC. ...................................................................................................................San Diego, CA

Senior Programmer Analyst

July 1994 to Aug. 97

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. Supported the batch DB2 PARTS database. Wrote COBOL programs, QMF(procs, queries, reports), JCL, DYL280 Used tools like KORN shell, C, VI, EMACS, AWK, SED, PANVALET, SYNCSORT, UNIX SORT, EXCEED, ORACLE 7, DEVELOPER 2000, ORACLE REPORTS 4.5, ORACLE FORMS.

MINI SYSTEMS .....................................................................................................................San Diego, CA

Consultant/Contractor

May 1993 to May 1994

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. Used QMF/QQF(converts QMF queries to COBOL code), FILEAID, SDF2.

FISERV Inc.(formerly Citicorp) ..........................................................................................San Diego, CA

Programmer Analyst

Feb 1993 to Apr 1993

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.

COMPUTER POWER GROUP ........................................................................................San Francisco, CA

Consultant

Jan 1991 to July 1992

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, XMENU, ABC Flowcharter, Visual BASIC, IBM PC, DOS 5.0, Windows 3.0, COBOL II 3.1. Other tools used DB2, SAS, SYSNSORT, JCL, ISPF utilities, ENDEVOR. Wrote WORD .DOT templates, and special FILE MENUS

ELECTRONIC DATA SYSTEMS ....................................................................................Romulus, MI

Programmer Analyst

April 1985 to Dec 1990

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, CLIST, and PL/I and COBOL. Wrote DB2/QMF reports for a problem tracking system and a configuration change request system. Maintained and upgraded a DB2 database load system using PL/I(with embedded DB2 SQL) Wrote a software verification system to verify the validity of the data download to 5000 dealerships. This was written using Microsoft "C" 5.1, PC-Macro assembler 5.0, and QUICKBASIC. Wrote COBOL batch and online programs for a school system. Worked on an online COBOL CICS and JCL BATCH system.

TRANSPAC .....................................................................................................................San Jose, CA

Programmer Analyst

Oct 1983 to Mar 1985

Analyzed, designed, programmed in BASIC, implemented, and maintained of an accounts payable, general ledger and payroll system for a packing company.

CAMBRIDGE PLAN INTERNATIONAL .................................................................Monterey, CA

Programmer

May 1982 to Sept 1983

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 and MVS.