SUMMARY

• Senior Programmer/Analyst with over twenty years of hands - on expertise working in fast-paced, large scale mainframe environments using SDLC methodology.
• Core technical skills include COBOL, DB2, CICS, Natural/ADABAS, TSO, ISPF, JCL, VSAM and IMS on IBM z/OS mainframe and AS/400 (iSeries).
• Experience with multiple industries, excellent analytical technical design/documentation skills and work well independently or as part of a team with lead experience.

TECHNICAL SKILLS

Programming: COBOL, CICS, DB2, Natural/ADABAS, CLIST, T-SQL, IMS, Access, Visual Basic, Control-M, Zeke, CLP

System Specifications and Design: Structured design and methodology, flow-charting, structured hierarchy charts, Microsoft Office, Visio, SDLC

PROFESSIONAL EXPERIENCE

Confidential, Denver CO

Senior Application Systems Analyst/Programmer

Responsibilities:

• Responsible for the online/batch Pay Calc/Leave programming system using Natural programs calling Sub-Programs and external Subroutines passing data via LDA/PDA parameters.
• Using Natural Debug to identify programming issues.
• Use Predict XREF to obtain a cross-reference listing for file updates and program calls in analysis phase.
• Perform validation, development, testing and implementation of requirements to support FPPS.
• Resolve Change Request (CR), Problem Report (PR) and Data Request (DR) issues raised by QuickSAR (Software Action Request System).
• Design, code, test, debug, document, and maintain programs/modules for FPPS.
• Analyze complex program flow between program, subprogram and external subroutines to become familiar with processing and to document LEAVE programming in Visio.
• Present program deliverables (programming / application standards, quality assurance and documentation) in compliance with DOI/IBC requirements.

Environment: IBM z/OS mainframe, TSO/ISPF, COBOL, Control-M, Natural/ADABAS, Endeavor, N2O

Confidential, Tempe AZ

Senior Programmer Analyst

Responsibilities:

• Project to correct batch cycle problems - Taxes doubled during Confidential load process.
• Project to Backup BSP files for Costa Rica, Hong Kong and New Zealand
• Modified Revenue COBOL program REV2290C to mask display of the 11-character credit card number
• Perform miscellaneous fixes on PROCs from the Technology Requests - Roadmap “To Do” List
• Task to modify multiple JCLs to route output to the JES held queue and in XPTR (Xporter)
• Project to updateTicket Lookup Service (TLS) Search Enhancement
• Developed conversion Adhoc program to parse and update two new columns on the Name table.
• Created complex DB2 cursor to select the appropriate records for parsing.
• Developed routine to unstring the full name into First and Last name columns and to perform LTrim for leading spaces prior to updating the table.
• Developed production JCL for Operations to execute Adhoc conversion with “Run Instructions”.
• Used linkage to control processing 200 million rows 1 partition at a time.
• Used COMMIT-COUNTER to COMMIT after every 500 rows.
• Incorporated error routine to handle SQL-DEADLOCK, SQL-UNAVAIL-RESRCE and all other SQL errors.

Environment: IBM z/OS mainframe, TSO/ISPF, COBOL, DB2, VSAM, Endeavor, REXX, Clist, SharePoint, SQL

Confidential, Auburn WA

Senior Programmer Analyst

Responsibilities:

• Reverse engineered legacy software business logic imbedded in COBOL programs to create a new web based system with enhanced features for internal customers via company intranet.
• Analyzed legacy code to identify and document all business rules from the current processing logic using a refined process methodology.
• Used a pragmatic approach of validating business rules to ensure success in FAA Certification process.
• Assisted in designing the new database, security model framework and all technical requirements for the new system in an ASP.Net/C#, SQL Server Environment.
• Used the reverse engineering analysis to create new design requirements via P490A - Unit Task Specification format and presented to the .Net development team.
• Documented all business functions used to calculate retest/reject dates, track time sensitive material exposure to determine material shelf life and all processes to print barcode labels used in the fabrication of tools and aircraft parts to meet strict QA/QC and FAA engineering specifications.
• Assisted in developing P750A Workload Responsibilities UI documents to define scope, dependency with other applications and test cases/steps.
• Developed SQL queries to identify table data needed to satisfy all requirements necessary to test program logic and the functionality of programs and screens.
• Developed, executed and documented all Unit Test scenarios via P770S Test Case and Results.

Environment: IBM z/OS mainframe, TSO/ISPF, COBOL, VSAM, DB2, Endeavor, SQL Server

Confidential, Sacramento CA

Senior Programmer Analyst

Responsibilities:

• Reviewed the Specific Functional Design (SFD) artifact to thoroughly understand the design approach and requirements of System Development Notice 12036.
• Studied SFD to thoroughly understand high-level diagrams, process flows, assumptions and constraints.
• Made modifications on COBOL programs as needed for the California Medicaid Management Information System (MMIS)
• Components included: programs, files, copybooks, includes and various interfaces to other subsystems.
• Analyzed all existing jobs and programs that imported daily Web SQL attestation transactions into a Flat File and in turn updated the ACA Self Attestation Master File (VSAM).
• Identified all programs that updated the Master File and proposed the best place to add logic to capture the most recent daily transactions
• Developed new daily Self Attestation Report.

Environment: IBM z/OS mainframe, TSO/ISPF, COBOL, VSAM, DB2, Panvalet

Confidential, Tumwater WA

Mainframe Developer

Responsibilities:

• Performed system analysis and design activities for system application architectures
• Worked closely with Business Analysts and SMEs to identify current processes in order to determine strategy for effective technical solutions
• Provided technical estimates to assist in defining delivery/rollout schedules
• Programmed technical solutions to comply with requirements and standards
• Wrote SQL stored procedures to identify various data for multiple purposes
• Provided translation of Use Cases into technical application solutions
• Identified technical risks and assist IT Core Team in identification of risk mitigation strategies
• Identified and resolved potential batch performance issues
• Worked closely with the agency’s Enterprise Architecture Office (EAO) to ensure:
• The solution was compatible with targeted service oriented technical architecture and direction
• The design and development specifications meet L&I standards
• Architectural documentation is captured and stored in the Agency’s repository
• Developed programming to generate Client Notification Letters to inform clients about the Medical Provider Network and their current provider enrollment status

Environment: IBM z/OS mainframe, TSO/ISPF, COBOL, CICS, VSAM, Natural/ADABAS, Endeavor, N2O

Confidential, Seattle WA

Senior Programmer Analyst

Responsibilities:

• Analyzed legacy systems and interfaces to determine current functionality
• Developed the “Mainframe AS-IS” document detailing all programs, jobs, and FTP’s that pass and receive data through the current systems batch processes and screens.
• Performed data analysis by use of scans of SOURCLIB, JCLLIB and PROCLIB libraries as well as reviewing the CA View output queues to determine what jobs are still being executed and to see expanded full file, table and report names after symbolic substitution occurs
• Performed research for defining Scope, Vision and Detail Design Requirements documents
• Developed solutions to meet the business requirements through collaborative efforts with Oracle DB
• Outlined these solutions through the use of Visio documents imbedded in the Design Documents
• Created Visio data flows for supporting graphical depiction of the AS-IS and Design documents

Environment: IBM z/OS mainframe, TSO/ISPF, COBOL, VSAM, DB2, Nomad, Oracle, Lawson, Endeavor

Confidential, Austin TX

Developer Analyst 3

Responsibilities:

• Performed initial assessment of the project by analyzing the Benefit System business requirements
• Developed plan for Best Practice approach to accomplish task in the time frame allotted and presented Proof of Concept to the TWC Staff for management approval
• Collaboration with customers to thoroughly understand business processes
• Analyzed and extracted information from programs, JCL and batch scheduling tool ZEKE
• Analyzed batch job Predecessor/Successor relationships and Triggers for all Batch Cycles
• Created Visio Technical Flows of each System, Subsystem and interfaces to Tax system
• Coordinated with Business Analysts to feed technical information into Business Flows

Environment: IBM z/OS mainframe, TSO/ISPF, COBOL, VSAM, DB2, Natural/ADABAS, ZEKE Scheduler

Confidential, Seattle WA

Senior Systems Analyst/Programmer

Responsibilities:

• Documented all program modules that create or update tables and edit system data
• Coordinated importing of all analysis documentation into a SQL database for project decision making and timing/coordination of the migration project
• Modified Natural modules in an ADABAS environment to meet requirements for 2010/2011
• Developed Control-M automated scheduler to replace Legacy Operations Batch Cycle
• Migrated nightly mainframe batch cycle jobs controlled by operations to Control-M job scheduler
• Provided production support and maintenance of Natural/ADABAS applications as well as batch cycle data transfers (FTP) and related interfaces
• Created and executed SQL scripts to select data from database tables for Archive Project

Environment: IBM UNIX mainframe, Natural/ADABAS, SQL, DB2, ASP.Net, C#, Control-M