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.

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

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 ACCELYA 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 update Ticket 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 Confidential 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 Confidential 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

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

Confidential, Seattle, WA

IT Systems Programmer/Analyst

Responsibilities:

• Supported programming for Medical/Dental billing and claims systems
• Responsible for programming requests using COBOL and CL in an AS400 environment
• Developed SQL scripts to update benefits files for ad-hoc file modifications as requested
• Created CL programs to back up database files and execute SQL scripts
• Scheduled CL jobs to run after the batch cycle updates were completed
• Responsible for developing report enhancement programming to meet business needs
• Modified existing programs to include ICD9 fields in extract files
• Developed programming to create file extracts as needed by customers
• Created new FTP scripts and coordinated with Security Analyst to test prior to implementation

Environment: AS/400 (iSeries), COBOL, CICS, CL

Confidential, Mercer Island, WA

IT Application Developer

Responsibilities:

• Programming support and development of Confidential and Confidential Underwriting legacy systems using COBOL, Easytrieve, and Assembler in an MVS IBM mainframe environment to meet business requirements
• Developed logic to change Assembler online elements, macros, tables, and copybooks to enhance edits and return rejectable error messages
• Responsible for a SSN verification project that involved developing COBOL extract programs, FTP encrypted files to third party vendor for name, DOB, and SSN validation, and developed jobs to update master files in a batch environment with return file information
• Used Endeavor mainframe change management software
• Developed and conducted User Acceptance testing in coordination with Business Analysts / Scheduling
• Debugged application programs using Expediter
• Developed system specification requirements as part of the project estimation and approval processes
• Developed system and user documentation as part of the promotion package

Environment: IBM z/OS mainframe, Z/OS, DB2, TSO/ISPF, VSAM, COBOL, Assembler, Endeavor

Confidential, Olympia, WA

Senior Programmer Analyst

Responsibilities:

• Maintained COBOL and CICS programs with enhancements to IMS/DB2 Databases
• Developed the programming components for an interface with Department of Licensing
• Developed new standardized COBOL programs and JCL to replace legacy DYL280 programs
• Conducted User Acceptance testing in coordination with Business Analysts
• Developed and executed test scripts for generating repetitive test cases
• Debugged application programs using Expediter and IBM Debug
• Used Rational RequisitePro for project development and defect tracking

Environment: IBM z/OS mainframe, TSO/ISPF, COBOL, CICS, VSAM, DB2, IMS, Rational ClearQuest

Confidential, Seattle, WA

Analyst/Programmer

Responsibilities:

• Wrote numerous COBOL programs to extract and report data as required for analysis and reporting
• Made new functionality available to end users via PFkeys in online programs that in turn submit batch jobs that email reports directly
• Duties also included backup DBA for KOVIS document archive / retrieval and PlanetPress email and print systems
• Assigned to both Pension and Eligibility teams, I resolved problems and developed programming solutions to meet the needs of the business
• Used Online File Utility (OLFU) to correct production data as needed for Billing Management

Environment: IBM VSE mainframe, COBOL, CICS, KOVIS, PlanetPress

Confidential, Seattle, WA

Senior Systems Analyst/Programmer

Responsibilities:

• Analyzed scope and developed project plan to make program modifications on a Geographical Coding System migration project to a Windows / SQL Server platform
• Modified Natural modules in an ADABAS environment to pass and receive GEO coordinate parameters to the new ESRI Arc GIS driver module for the Student Assignment and Transportation Systems
• Worked closely with C# programmer to develop, test and implement a solution in C# to communicate between Windows platform and the mainframe
• Developed an involved test strategy for all interfaces using the GEO system. Tested results and made recommendations to management on solutions

Environment: IBM UNIX mainframe, ADABAS/Natural, DB2, ASP.Net, C#

Confidential, Seattle, WA

Information Systems Analyst/Programmer

Responsibilities:

• Responsible for supporting the Patient Accounting Legacy System written in Natural /ADABAS
• Project manager on large-scale project to acquire a new HR solution for the physicians payroll
• Reported directly to the CIO of UWP as the acting Administrative Director of Information Systems
• Performed programming maintenance and created adhoc file extracts and reports as needed by management and agencies using Natural, COBOL, and DYL280
• Managed a large conversion project to comply with new format changes for medical claims submission
• Analysis of JAVA and XML programming code for requirements gathering
• Analyzed and coordinated data migration issues as required
• Made related changes in support of switch to SFTP to meet HIPPA requirements
• Wrote and executed programs to import extract files into Excel and formatted for CIO and CFO reports

Environment: IBM VSE mainframe, COBOL, ADABAS/Natural

Confidential, Seattle, WA

Senior Software Developer

Responsibilities:

• Project lead on building new application solutions as well as maintaining and enhancing existing applications in a Natural ADABAS environment
• Performed software programming and debugging, made recommendations for development techniques to meet requirements, and documented all work
• Played an integral part of the functional and technical analysis of a major system redesign effort
• Performed project scope and direction, feasibility studies, and cost benefit analysis
• Various projects included:
• Converted core business transaction processing from the mainframe to client server technology
• Used COBOL to extract data files, created conversion software using Data Junction to convert and load data into SQL databases / tables and to meet user reporting requirements
• Provided data via linked tables from SQL-Server into Access and Excel
• Uploaded daily cleared fund file from bank internet site, introduced daily check text file to mainframe batch processing via FTP from network to a VSAM file, created production job processing with error trapping at all steps, and final ADABAS file updates if all criteria matched
• Increased internal / external Web presence by providing customer and internal services over the web using XML, VB scripts, and hyperlinks to mainframe reports after FTP to the network
• Supported Claims System as needed and in nightly Claims batch jobs as well
• On-call support of batch processing cycle and SQL-Server DTS packages
• Numerous projects writing and executing T-SQL scripts and Stored Procedures to extract data using INNER JOIN on master tables, UNION to concatenate result sets into one table, and CAST and CONVERT to reformat data

Environment: IBM VSE Mainframe, ADABAS/Natural, COBOL, CICS

Confidential, Seattle, WA

Senior Systems Analyst

Responsibilities:

• Project lead on financial accounting OmniPlus payment system using COBOL and CICS.
• Coordinated with Systems Analysts, Business Analysts, and users on problems, projects, and fixes that impacted production processing.
• Responsible for all aspects of systems problem reports (SPRs).
• Facilitated weekly team meetings to review, prioritize, and discuss programming approaches.
• Developed programming solutions for Service Requests using COBOL, CICS, and JCL. Full test life cycle included use of test plan, testing module and JCL changes in model office and QA environments.
• Lead programmer on a post Y2K Security production problem.
• Worked closely with Action Team to design specifications and implementation of a Visual Basic Security Application running under RACF for the online Financial Accounting System.
• Submitted and Approved ChangeMan packages to Production Control.
• Responsible for quick response to on-call problems.

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

Confidential, Bellevue, WA

Senior Analyst Programmer

Responsibilities:

• Performed programming development and maintenance within CICS / COBOL using IMS calls.
• Responsible for the Forms Database, Commercial Business, and Workers Compensation lines with timely enhancements to comply with ISO and State Insurance Commission regulations.
• Worked closely with the Business Analysts in order to acquire detailed specifications, test plans, and coordinate implementation with Personal Lines and Statistical Reporting.

Environment: IBM z/OS mainframe, COBOL, CICS, TSO/ISPF, XPEDITER, Endeavor