SUMMARY

A proactive, trustworthy Applications Developer with extensive experience in application design/implementation, problem resolution, customer satisfaction, SDLC and business requirements analysis. Strengths include analyzing data, manufacturing/planning, logistics/EDI, relating to clients and data management. A detail oriented, responsible team player with a good attitude who works well with little supervision.

TECHNICAL SKILLS

OS/Environments: IBM mainframe: MVS, ESA, VM, XA, OS390, Z/OS 1.7, Z/OS 1.9, TSO, EDI x12, ISPF, BMS, SDF, SDSF, SPUFI, QMF, Unisys IX Clearpath Series mainframe with RDMS 12r2, Windows NT, XP, Windows 2000 Pro, OS/2, DOS, Oracle, Client/Server, ROSCOE, ADAMINTS analysis (ADABAS)

Development Applications: COBOL, COBOL370, COBOL390, COBOL2, eCOBOL, DB2 w/Embedded SQL, Microfocus COBOL, Debugger, INTERTEST, Expediter, ETL, ORACLE: SQL, SQL+, PL/SQL, stored procedures and packages; CICS (Cmd Lvl), EZTRIEVE, EasyTrieve+, JES, JES2, SJP, MVS JCL, PL/1, RPG2, RPG3, Dyl280, SQL Navigator, TOAD, IMS/DL1, IMS/DB, IDMS, Assembler (Macro Lev), AFP, MS SQL Server 7.50, Pivot tables, SUPERC, COMPARE, UltraEdit-32 Prof Text/Hex Editor 12.0 for Windows, VSync, VSAM, TOTAL/SUPRA, Unisys IPF editor and ECL, Powerbuilder 5.0, InfoConnect 3.0, SQL Anywhere ISQL 5.5, UniAccess middleware, HTML/GUI, WINSQL

OOD Environments: VB3, VB4

Networking Environments: LAN, WAN, VAN, TCP/IP, Host Explorer, FTP, VPN, VPS, NetMeeting, NetView, VTAM, EXTRA/3270 - Personal Client, Attachmate, Intranet, Client/Server Portals, FileNet, Hummingbird, Vista (TSO Emulator), DIRECT:CONNECT, NDM, ISDN, Data21, IP Server, Gentran (mainframe component) and Gentran Server for Windows 4.0

Hardware: IBM mainframe: 3090 Series, 3080 Series, 9600 Series, Z800 Series, HP Servers, Windows Servers, UNISYS- IX Clearpath Series OS2200 mainframe

Software: Oracle, CICS, MS Office Suite (WORD, EXCEL, OUTLOOK, ACCESS), Documentum (Contributor), CAMBAR, DFSORT, ENDEVOR, FTP, Lotus Notes 5, Microfocus COBOL Workbench (w/CICS option & Animator), StarTeam/ Kintana, Remedy, Viasoft, Visio, SIS Plus, FileAid, AbendAid, Clists, REXX, SAR, SAVRS, Strobe, Syncsort, CA-Sort , DFsort, ICEMAN, ICETOOL, UCC7, CA-7, CA-11, Panvalet/LIBRARIAN, Remedy, SCLM, Changeman, Assembler (Macro Lvl), CONTROL-D, IDCAMS

PROFESSIONAL EXPERIENCE

Confidential, 10/2007 - 06/2008
Office Of Education
Sr. Programmer Analyst

As a Soft-Train Consultant, supporting the LACOE Payroll/HR System Migration implementation project, on their IBM / Z/OS / MVS System, Client-Server, using eCOBOL / CICS / DB2 / HTML programming debugging skills. LACOE' s payroll systems have never missed a payroll cycle and they pay all District teacher, retiree and staff payrolls (not covered by the LAUSD District).

• Primary duties include: resolution of documented issues (thru their reporting system) occurring on their newly upgraded/converted CICS / eCOBOL / DB2 / HTML, HR and Payroll Systems. These issues typically involve navigational or functional problems, in these CICS/eCOBOL programs and often involved weekly meetings with departmental staff from Student Financial Services Division and HRMS staff (using CALPERS data), to gather incident details or incident specification corrections. Frequent emails between Expert Users and User Acceptance teams were used to notify completion of these incident reports. This migration project involved a Bull System using VSAM files, to an IBM Z/OS mainframe using DB2/CICS/HTML interfaces via IP Server and Intranet portal. The HRMS system was written by INTEGRAL for both the Bull legacy system and the upgraded for the IBM/ZOS platform.
• Assigned tasks on the Credential System and related state download files. Produced a set of CICS/eCOBOL/HTML programs accessing new DB2 data (Archive tables) and sending HTML screens, to replace microfiche. Created DB2 load programs using the newly expanded State Credential download file via the State website. Helped to eliminate microfiche viewers, microfiche service and freed shared office space for the microfiche equipment. Met weekly with the Credential System management to demo new programs, gather specifications and requirements, and receive feedback or user acceptance of newly implemented programs. Gained/improved experience using: SCLM, WINSQL, DEBUGGER.
• Some knowledge-based cross training occurred since most of LACOE' s staff is Bull Systems based.

Confidential, 05/2007 - 09/2007
Sr. Programmer Analyst

As an Irvine Technology Corp Contract Programmer/Analyst, supporting the Experian SBCS System (Small Business Credit Share), on their IBM / Z/OS 1.7 / MVS System, using Easytrieve+ to write conversion programs. Experian is a leader in the Credit Bureau sector and maintains DB2 databases of approximately 26 Terabytes.

• Primary duties include: writing Easytrieve programs to convert historical contributor data to directly batch-update (using Cobol2/DB2) their post-legacy DB2 Systems. Also, working with Testers, in Quality Assurance, to adhere to standards, specification modifications and data-translation changes. Identified corrections or improvements to Systems Requirements Documents. Nominated 'Lead Programmer' , for meeting all QA' s required changes, on all Easytrieve conversion programs being tested, and being written by a staff of 8 contract programmers. Researched and recovered, data sources for conversion. Attended weekly meetings, which included staff from Applications Development, Project management, the Department Director, end-user departmental management, DBA(s) and QA. These meetings were held for resolving data conversion issues, scheduling implementation steps and targeting data sources for conversion.
• Performed ad-hoc programming duties, such as re-testing and promoting groups of Cobol2 programs, copybooks, PROCS and JCL, through the various stages of libraries within ENDEVOR. Met with QA to determine any programming or JCL Standards adherence issues and determine scheduling.
• Attending Production Support meetings. Sometimes being assigned issue resolution tasks involving batch or CICS / DB2 programs.

Confidential, 10/2006 - 03/2007
Department of Public and Social Services
(incl Child Services & Welfare)
Sr. Programmer Analyst

As aPrimetechContract Programmer for Unisys, supporting the LA County LEADER project (Los Angeles Eligibility Automated Determination Evaluation Reporting System) on Unisys' s 2200 Client Server mainframe, using Cobol and SQL for access of Unisys' s RDMS (relational database management) and UniAccess Open Client. Leader is the largest client-server IV-A system in the country using 5.9 Terabytes of DASD. Unisys has been contracting with the County of LA for over 9 years. The environment is 'Unisys / Cobol / PowerBuilder / M-F Cobol / RDMS' .

• Primary duties include writing and testing Cobol/SQL batch programs and promoting the program versions thru Unisys' s multiple staged regions. These batch Cobol programs are exclusively interface and extract programs that feed other county external systems. Working with Eligibility data (EDBC), TANF and CalWorks data. The regions are: 'Production' , 'Staging' , 'UA Test' , and 'Development' , with emphasis on Quality Assurance and peer code review. Met weekly with: LA County user-staff members, Unisys programmers, and Unisys management, to report status, identify issues, review/enhance requirements documents and review/modify implementation plans.
• Learning and using PowerBuilder' s Database Management Tools for ad-hoc SQL queries and SQL performance tuning (in various regions) and for data validation.

Adapted to the Unisys operating systems and library systems. (Unisys is using PowerBuilder & MicroFocus Cobol to code and map online maps and programs, on a separate team).

Confidential, 10/2005 - 06/2006
Academia, Admissions & Records
Sr. Programmer Analyst

Supported SIS Plus System (SIS+), User Security Administration, application development using eCOBOL, DB2 and Embedded SQL in an 'IBM / MVS / CICS / eCOBOL / DB2/ VSAM' environment.

• Developed student letter program in an eCOBOL batch environment using Embedded SQL (and enhancing my DB2 knowledge & currency) and learned output processing language AFP for laser printing and forms creation, and learned data access from pivot tables. Met weekly with IS management and expert users, for test reviews, form appearance and data validation. Used SCLM for source control management.
• Leveraged EDI knowledge while learning how to download e-transcripts via the internet on a state-wide project involving other universities in the CSU System and Imaging processes using OCR technologies. Met weekly with Admissions management, State project leaders, to review testing progress, download issues, specification changes and process improvements. Learned the process-flow on receiving transcripts from other universities and running those image files thru CSF' s contracted Imaging software, from Hershey (using OCR), also on 'error verification' of those transcripts. Studied/analyzed XML data-mappings of etranscripts and EDI transcript (130) creation.
• Obtained Security Administration knowledge while assisting staff, faculty and student assistants by setting-up secure ID(s) and performing password reset services. Performed maintenance to their ACCESS d/b security info backup system.

Confidential, 07/1998 - 11/2004
Manufacturing, Sales, Medical Equipment (Lab, Office, University Research)
Sr. Applications Developer

Supported Legacy Apps in an 'IBM / MVS / CICS / COBOL2 / IDMS / VSAM / EZTRIEVE' environment, while transitioning to Oracle Applications 11i, via a 2-tier, client-server environment. Legacy applications included: order management, inventory analysis/planning, contract management, customer service, manufacturing interfaces, logistics, DRP/MRP and Oracle Interfaces. Used Oracle SQL Editors: TOAD and SQL Navigator, on HP and Oracle servers. 24/7 on-call support with 3 peers, on a rotational basis.

• Ad-Hoc Management reporting on ABC Analysis with various, as-needed warehouse management.
• EDI interface development (extracting real-time data) to support a 3rd Party warehouse Feasibility Study with USCO and used by distribution management. Met weekly with USCO technical team and EDI Coordinators to review EDI transmission results, EDI data mapping improvements and process improvements. Learned more about EDI mapping for 856 transactions, VANS, repository procedures and packets. Performed other EDI transaction set maintenance for Invoices - 810, P.O. - 850 and P.O. Acknowledgements - 855.
• Learned network troubleshooting using VPS and NetView for TCP/IP connected user printers.
• Received Oracle (8i) Education in: SQL, SQL+, PL/SQL, Database Design and Modeling, specifically for BCI migration project. This migration was from the IBM Z/OS platform to the ORACLE ERP platform. Met weekly with expert users to review user acceptance on reported issues and interface enhancement specification changes. Applied education by performing production Oracle (11i) table updates, Oracle interface code debugging, maintaining and enhancing Oracle Stored Procedures & Stored Packages. Ran custom Oracle Forms applications, SQL editors: TOAD & SQL Navigator. Learned version control software: Kintana, StarTeam. Approx 2.5 years of Oracle experience, mostly on the PL/SQL interface to Oracle' s CRM modules, using SQL Loader for the converted shipping orders from the interface. The shipping execution was performed on the Oracle/Websphere side.
• Performed analysis, product evaluation, testing of a CA Transparency for calls to IDMS (originally coded in TOTAL/SUPRA.) Attended classes on IDMS call structure and RDBMS systems for the IDMS d/b.
• Worked with CA products: CA-7 and CA-11 during production set-up with Operations staff.
• Obtained 'Contributor' level education in Documentum. Updated Remedy requests.
• Worked with Integration/Interface Software vendors: TIBCO & BEA.
• Gained exposure to SMS, in the form of scheduled downloads of PC system upgrades and network virus protection.

PROFESSIONAL EDUCATION

• DELTAK (in-house CBT training.)
• Computer Science courses.
• Education training in: SQL, PL/SQL, SQL+, and Oracle Database Design and Modeling.
• IBM (offsite) DB2 training (downtown LA).