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 including Lean and DMAIC methodologies.
· Solid technical background.
· Excellent organizational and communicational skills.
· Adherence to established shop programming and documentation standards.
· Committed to constant improvement and learning.

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), Six Sigma Black Belt Training.
PC and Lan Experience: MS OfficeVisio, and Lotus Notes,
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, SQL Stored Procedures, DTS packages, MQ series, TCP/IP, VBScripts, Visio and Visual Basic. Currently learning SQL2005.

Selected Professional Achievements

Confidential, Vancouver, WA
Senior Programmer/Analyst
Responsibilities: Business Analyst, Systems Analyst, Sr. Programmer/Analyst, Q/A

• Supported the server side (Crystal reporting and SQL2000).
• Documentation, enhancements and support for Electric Department server database.
• Designed and created the Water Department Data Base and the mainframe extracts, daily updating process (DTS packages) using FTPs of mainframe extracts (ETL). Full life cycle project including enhancements.

Confidential,Senior Programmer/Analyst
Responsibilities: Business Analyst, Systems Analyst, Project Lead, Sr. 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, Sr. 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, Sr. 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 Electric Department server database (ETL).
• 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 Electric Department (ETL).
• 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 (ETL).
• 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, TCP/IP, Crystal Reports, T-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: Sr. 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.

Confidential,Redmond, WA August 2003 – February 2004
Senior Programmer/Analyst Contractor Lively and Partners Consulting Network
Responsibilities: Systems Analyst, Sr. 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 Health Insurance Systems Conversion
Responsibilities: Sr. Programmer/Analyst, Q/A

• 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, Lake Oswego, OR June 2000 - June 2001
Senior Programmer/Analyst Contractor Computer Horizons
Health Insurance Systems, Common Membership team.
Responsibilities: Sr. Programmer/Analyst, Q/A

• 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 COMSYS Worker Compensation Insurance Systems
Responsibilities: Sr. Programmer/Analyst, Q/A

• 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: Sr. 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

Education

AA Degree, Data Processing
Flagstaff, Arizona, Structured Programming
Northridge, California, Business Administration
Six Sigma Black Belt Training