Professional Profile

Over twenty years in the IT industry working extensively within the mainframe and server environment utilizing technologies such as COBOLII, DB2, SQL, SAR, CICS, VSAM, File-AID, IDMS, ADS/O, ADS/A, SQL 2000, SQL 2005, Access, Crystal Reports, IBM Utilities and more. Various professional levels ranging from Technical to Project Lead. Six Sigma Black Belt Training. PMI certification expected 2010.
Solid technical background.
Excellent organizational and communicational skills.
Adherence to established shop programming and documentation standards.
Committed to constant improvement and learning.
"Creative solutions come from listening and examining possibilities
ranging from the wild and wacky to the wonderful. See me on LinkedIn."

Representative Projects:
Retail Systems · Mainframe extracts for downloads
Government, insurance and financial to servers
systems · DTS packages for server database
Health Insurance industry (HIPPA · System analysis
compliance and data reconciliations) and · Maintenance
Medicare · New programming
Public Utilities · Testing
Payroll Deduction (Electronic Fund Transfer) · Quality control
Systems · Data warehousing
Conversions for data and programs

Technical Expertise

Hardware: IBM Mainframe (360, 370, 30XX, OS/390, IBM compatible, IBM VSE)
Data Structures: DB2, IMS DL/I, IDMS, VSAM, ISAM, SQL2000, access
Program Migration Tools: Librarian, Panvalet, Changeman, and PanApt.
Data Management and Testing Tools: FileAid, ISPF, Xpediter, Abend Aid, Data Ager and Ager2000, Microsoft Visual Studio, Object Oriented Analysis and Design (OOAD).
PC and Lan Experience: MS Office, Word, WordPerfect, Outlook, Visio, and Lotus Notes, Excel
Operating Systems: TSO/ISPF, MVS, VSE, DOS/VSE, Windows 95, 98, NT
Languages: CICS, COBOL, COBOL II, EasyTrieve +, SQL, JCL, SAR, ADS/O, ADS/A, OLM, OLQ, QMF, SPUFI, ROSCOE, Crystal Reports, SQL 2000 Querying, DTS packages, VBScripts, Visio and Visual Basic. Currently learning SQL2005.
Please see Skills Table on last page.

Confidential, Vancouver, WA 2006 -2009
Senior Programmer/Analyst
Responsibilities: Business Analyst, Systems Analyst, Programmer/Analyst, Q/A

• Stepped in and learned the server side (Crystal reporting and SQL2000) when it needed to be supported.
• Documentation, enhancements and support for RIO Electric server database.
• Designed and created the Water Department Data Base and the mainframe extracts, daily updating process (DTS packages) using FTPs of mainframe extracts. Full life cycle project including enhancements.

Confidential, Senior Programmer/Analyst
Responsibilities: Business Analyst, Systems Analyst, Programmer/Analyst, Q/A
Coordinated a full life-cycle development for a project moving Retail Union Clerks from previous system to Drug Payment System.

• Assigned tasks, provided analysis and programming requirements, performed program and system follow up, testing, debugging with a seven-member team in all phases for successful on time conversion project.
• Analyzed the Batch processing and by making minimal JCL and program changes improved the process reliability and flexibility. This increased the batch processing window availability from under 15 minutes to over 3 hours and enabled the removal of one disc pack.

Confidential, Programmer/Analyst
Responsibilities: Business Analyst, Systems Analyst, Programmer/Analyst, Q/A
Analyzed the system for changing realty books sorting/selection process and streamlined the process, eliminating the need for constant reprogramming.

Professional Experience

Confidential, Vancouver, WA 2006 -2009
Senior Programmer/Analyst
Responsibilities: Business Analyst, Systems Analyst, Programmer/Analyst, Q/A

• Stepped in and learned the server side (Crystal reporting and SQL2000) when it needed to be supported.
• Created folders of sample reports and documentation of formulae, queries, and mainframe extracts used to create special tables for complex productivity reports.
• Tested and researched data for projects.
• Programmed mainframe downloads, DTS packages and tables for RIO Electric server database.
• Used SQL queries to verify data.
• Worked closely with users to produce reports and Excel files for export.
• Created the Water Department Data Base and the mainframe extracts, daily updating process (DTS packages) using FTPs of mainframe extracts.
• Provided new programming and program modifications for Mainframe enhancements.
• Improved Mainframe downloads to server, DTS packages for server database table loads for RIO Electric.
• Performed special Mainframe extracts to download to server for complex Crystal Reports involving mainframe extracts, DTS packages using SQL queries to load new tables to produce productivity graphs.
• Created folders of sample reports and documentation of formulae, queries, and mainframe extracts used to create special tables for complex productivity reports.
• Created specification packages for system enhancements.

Environment: IBM/VSE, COBOL/COBOLII, VSE/JCL, BIM XP, WordPerfect, SQL2000, Crystal Reports, SQL 2000 Querying, VBScripts, Agile Methodologies, Object Oriented Analysis and Design.

Confidential, Seattle, WA July - October 2005
Senior Programmer/Analyst Contractor Lively and Partners Consulting Network
Responsibilities: Programmer/Analyst, Q/A

• Provided new programming and program modifications for enhancements to legacy IMS System.
• Created specification packages for enhancements.

Environment: IMS, COBOL/COBOL370, JCL, SAR, TSO/ISPF, WordPerfect, XPEDITER, ALM.

Redmond, WA August 2003 - February 2004
Senior Programmer/Analyst Contractor Lively and Partners Consulting Network
Responsibilities: Systems Analyst, Programmer/Analyst, Q/A

• Provided analysis, new programming and program modifications for enhancements to legacy IMS System.
• Created specification packages for enhancements.
• Guided a 2-phase project working with a business analyst and a consultant from IBM.
• Provided practical analysis on the system side, worked out the details and wrote the specifications for Phase 1 and Phase 2 for the Direct Bill project.
• Programmed alterations, JCL, test cases, and much of the test data in conjunction with a Quality Assurance team.
• Pointed out logic and data holes and solve design problems before the coding phase.

Environment: IMS, COBOL/COBOL370, JCL, SAR, TSO/ISPF, DB2, WordPerfect, Mainframe MQ, XPEDITER, ALM.

Confidential, Portland, OR May - July 2002
Senior Programmer/Analyst Contractor COMSYS Confidential

• Programmed conversions and modifications to fit the regional needs.
• Tested and test data creation.

Environment: MVS, COBOL/COBOLII, DB2, VSAM, IDMS, JCL, SAR, FILE-AID, TSO/ISPF, WordPerfect, XPEDITER, Visio, Librarian, Changeman, Lotus Notes, EasyTrieve +, MS Office, Word, Excel, Access, Outlook.

Confidential, June 2000 - June 2001
Senior Programmer/Analyst Contractor Confidential
Health Insurance Systems, Common Membership team.

• Created specifications and analysis for both new programming and program modifications.
• Participated in walk thrus.
• Created and implemented test plans.
• Verified test results.
• Modified and created new CICS displays.
• Worked on HIPPA compliance and data reconciliation.

Environment: MVS, COBOL/COBOLII, DB2, VSAM, CICS, JCL, SAR, FILE-AID, TSO/ISPF, PANVALET, WordPerfect, XPEDITER, ABENDAID, MQ Series, Visio, Librarian, Lotus Notes, EasyTrieve +, QMF, SPUFI, MS Office, Word, Excel, Outlook, Structure Chart methodology, some CSP.

Confidential, Salem, OR July - December 2001
Senior Programmer/Analyst Contractor Confidential

• Provided new programming and program modifications for data conversion project.
• Participated in walk thrus, testing changes.
• Created and implemented test plans and verified test results.

Environment: MVS, COBOL/COBOLII, DB2, VSAM, JCL, SAR, TSO/ISPF, WordPerfect, PanApt, Lotus Notes, EasyTrieve +, MS Office, Word, Excel.

Confidential, Lake Oswego, OR April - September 1999
Senior Programmer/Analyst Y2K projects for various companies
Responsibilities: Programmer/Analyst, Q/A, Interviewing

• Examined JCL, record layouts and programs to identify and verify dates and their usage.
• Wrote data aging programs, used data aging products (DateAger and Ager2000).
• Tested remediated code, compared results of aged files for critical dates.
• Wrote test documentation showing verification of code coverage.
• Performed technical interviews and evaluation of potential candidates to fill open contract positions.

Environment: MVS, COBOL/COBOLII, DB2, VSAM, CICS, JCL, SAR, FILE-AID, TSO/ISPF, PANVALET, WordPerfect, XPEDITER, ABENDAID, DateAger, Ager2000 and IDMS

Confidential, Portland, OR 1998
Senior Programmer/Analyst Retail stores application systems
Responsibilities: Business Analyst, Systems Analyst, Programmer/Analyst, Q/A

• Integrated acquired corporate systems including program modifications, tested changes, created and implemented test plans and verified test results.
• Interfaced with users to acquire information for specifications and analysis for both new programming and modifications to existing programs.
• Modified and created new CICS displays.
• On call responsibilities included on call coverage for all daytime pages, system problem diagnosis and resolution (Abend and debugging).
• Provided documentation using Change management product.
• Documented existing programs and updated same for system changes.
• Retrieved Ad hoc system information.

Environment: MVS, COBOL/COBOLII, DB2, VSAM, CICS, JCL, SAR, TSO/ISPF, PANVALET, WordPerfect, XPEDITER, and ABENDAID

Confidential, Portland, OR 1997 - 1998
Senior Programmer/Analyst Legacy System Conversion
Responsibilities: Business Analyst, Systems Analyst, Programmer/Analyst, Q/A
Served on COGEN application development team. COGEN was a Policy Processing System that handles all casualty applications.

• Performed date driven modifications for specific State of California needs on pre-COGEN system.
• Created programming specifications and requirements to match with abilities of new Insurance System for contract programmers.
• Analyzed old Payroll Deduction System and requirements for new Payroll Deduction (Electronic Fund Transfer) System.
• Performed preliminary (pre-user) acceptance testing for EFT System.
• Analyzed requirements, designed specifications, performed some coding and coordinated remainder of coding for Documerge System.
• Created design specifications and detailed General Ledger test scripts.
• Conducted module modification, testing, Quality Assurance, debugging, and documentation.
• Modified and created new CICS displays as needed for state by state insurance requirements.
• Provided Y2K analysis of Legacy System.
• Modified legacy AS/400 Cobol programs.

Environment: MVS, COBOL/COBOLII, DB2, CICS, ISPF, PANVALET, JCL, SAR, FILEAID, MS Office, Word, Excel, Access, Outlook, Lotus Notes

Confidential, Portland, OR February - April 1997
Senior Programmer/Analyst Contractor
Responsibilities: Systems Analyst, Programmer/Analyst, Q/A

• Coordinated and administered Forms and Check printing conversion (IBM to Xerox) for Poorman Douglas project involving new programming and testing.
• Analyzed IBM printer (programmable) code and COBOL programs providing input data for that printer.
• Created new COBOL programs for Xerox printer including analysis of requirements, testing, Abend, problem diagnosis and resolution, and debugging.
• Programmed DJDE's, Micro Check lines, and variable fonts.

Environment: MVS, COBOL, VSAM

Confidential, Portland, OR November 1996 - February 1997
Senior Programmer/Analyst Contractor

• Designed, developed, programmed and tested corrections to actuarial valuations of retirement fund accounts and payments for PERS pension recipients, resulting from tax law changes.
• Project involved attention to date driven parameters.

Environment: MVS, COBOL/COBOLII, DB2, VSAM, TSO/ISPF, EASYTRIEVE PLUS, IMS/DLI, VM/ESA, ROSCOE, PANVALET, SAR, JCL and FILEAID

Confidential, Portland, OR August- November 1996
Financial company which interfaces ATM's.
Senior Programmer/Analyst Contractor

• Analyzed forms and format of incoming bank data (often in hex dumps) for installation on Tandem computer.
• Extrapolated information tested and debugged new programming and verified (Quality Assurance) correlated data from various files for reporting of cardholder data.
• Handled de-conversion of tapes from Tandem System.
• Ad hoc reporting of various accounts.

Environment: MVS, COBOL, VSAM, JCL, SAR, ISPF and EASYTRIEVE

Confidential, Salem, OR November 1994 - August 1996
Senior Programmer/Analyst Contractor
Responsibilities: Systems Analyst, Programmer/Analyst, Q/A

• Analyzed design and development of programs to provide reports drawing information from databases for Oregon Health System, Medicare, Food Stamps, and Disability programs, as required, for legislative testimony and departmental information.
• Tested, debugged, and provided Quality Assurance.
• Correlated data from various files for case tracking purposes.
• Modified CICS displays. Ad hoc reporting for legislative and departmental requests.

Environment: MVS, COBOL/COBOLII, DB2, CICS, VSAM, FILEAID, EASYTRIEVE PLUS, TSO/ISPF, PANVALET, SAR, JCL, and Intertest

Confidential, Portland, OR 1990 - 1992
Project Lead Programmer/Analyst
Responsibilities: Business Analyst, Systems Analyst, Project lead, Programmer/Analyst, Q/A

• Major Projects:
• Analyzed, designed, developed, tested, and implemented major modifications and enhancements to the Drug Payment Systems.
• Coordinated full life-cycle development for a project moving Retail Union Clerks from previous system to Drug Payment System. Lead for seven-member team in all phases of successful conversion project.
• Created programming modifications and test data for new mailing system from undocumented legacy system.
• Coordinated tasks, provided analysis, programming requirements, performed program and system follow up, testing, debugging.
• Created schedules, met mandated deadlines, set up and met self-directed deadlines.
• Performed problem resolution on an "on-call" basis.
• Maintained and enhanced Claims Processing Systems.

Environment: MVS, COBOL, COBOLII, JCL, TSO, ISPF, VSAM, EASYTREIVE+, IMS, SAR

Confidential, Vancouver, WA March - December 1989
Senior Programmer/Analyst Contractor
Responsibilities: Systems Analyst, Programmer/Analyst, Q/A

• Full life-cycle development of new programs to extract and correlate information from large telecommunications databases.
• Advised corporate customer on computer product purchases in terms of testing, program tracking, user friendliness, and ease of use.
• Provided enhancements to existing large IDMS databases (equipment and phone numbers) and new programs.
• Performed testing for new on-line inquiry and update systems.

Environment: IDMS, JCL, TSO, SAR, ENDEAVOR, EASYTRIEVE PLUS, BRACKETS, ABENDAID, ISPF, and COBOL, ADS/O, ADS/A

Education

AA Degree, Data Processing

Structured Programming

Business Administration

Computer Science