Programming:

COBOL, CICS, DB2, Natural/ADABAS, 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

Senior Programmer Analyst, Consultant

• CIMS Modernization / Reverse Engineering Project
• Iterative approach to extract As-Is functionality from existing legacy system in order to design and develop new software for internal customers via company intranet.
• Reverse engineer COBOL programs to capture business rules from the current software and document in a standard template to be used to build the new system
• Assisting in design effort of the new system in ASP.Net / SQL Server Environment
• Assist in negotiating new design features/security model design framework
• Analyzing DB2 code to document processing logic and all current Business Functions
• All documentation being used in creation of Design Requirements on ASP.Net platform
• Processes include Peer and Group reviews for detail accuracy in requirements gathering
• Pragmatic approach of validating business rules to ensure success in FAA Certification process
• Use SQL in development test environment to identify test data to enable warning and test messages
• Capture all functionality needed to print barcode labels needed to fabricate or Tools and Parts

Security Courses:

• Information Protection Computing Security TR011596 - 4/03/2014
• Laptop Security Training TR011018 - 4/04/2014
• Information Security - 4/22/2014

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

Confidential

Senior Programmer Analyst, Consultant

• Reviewed the Specific Functional Design artifact to thoroughly understand the design approach and requirements of the System Development Notice 12036.
• Studied SFD to thoroughly understand high-level diagrams, process flows, assumptions and constraints.
• Worked on COBOL programs to make modifications needed to the legacy California Medicaid Management Information System components such as: programs, files, copybooks, includes and various interfaces to other subsystems. Analyzed existing jobs and programs that imported Daily Web SQL attestation transactions into a Flat File and in turn update the ACA Self Attestation Master File VSAM .
• Designed where in the existing logic that either updates or creates the Master File, where the best place was to add logic to capture the most recent daily transaction and make a call to a new daily Self Attestation Report.

Courses taken to be HIPPA Compliant:

• HIPPA Overview for Suppliers HLS113
• HIPPA Compliance Guide SRM21030
• HIPPA Compliance Program SRM21906
• Data Security and Privacy Training
• OSS Operations Training

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

Confidential

Mainframe Developer, Consultant

Medical Provider Network Project

• Programmed technical solutions for the Department of Labor Industrial Insurance System AD M team using Natural/ADABAS. Responsible for programming tasks in response to 2011 Legislation to develop programming for a new Medical Provider Network of approved Providers.
• 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
• Work 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 OS mainframe, TSO/ISPF, COBOL, CICS, VSAM, Natural/ADABAS, Endeavor, N2O

Confidential

Senior Programmer Analyst Consultant

• Credit and Collateral Management Replacement Project
• Responsible for the analysis phase for the new solution to replace the current Collateral Management System functionality with the new Response Analytics, Inc. enterprise software solution.
• Analyzed existing 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
• Created Visio data flows for supporting graphical depiction the AS-IS and Design documents
• 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

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

Confidential

Developer Analyst 3, Unemployment Insurance Benefits Consultant

• Analysis and Documentation Project
• 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 O/S mainframe, TSO/ISPF, COBOL, VSAM, DB2, Natural/ADABAS, ZEKE Scheduler

Confidential

Senior Systems Analyst/Programmer Consultant

• Spearheaded efforts in Analysis/Documentation effort for Enterprise Migration Project of the legacy mainframe Student Information System SIS to a .Net / SQL Server platform. Gathered information from SMEs and authored detailed design, system specification and architecture documents as well as business logic flowcharts.
• 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

IT Systems Programmer/Analyst Consultant

• 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 database benefits files for ad-hoc file modifications as requested
• Created CL programs to back up database files, execute the SQL scripts, and scheduled CL jobs to run after the batch cycle updates were completed
• Responsible to meet business needs for report enhancement programming
• Modified existing programs to include ICD9 fields in extract files
• Developed file extracts as necessary
• Created new FTP scripts and coordinated with Security Analyst to test prior to implementation

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

Confidential

IT Application Developer

• Programming support and development of Express and Lincoln 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 OS mainframe, Z/OS, DB2, TSO/ISPF, VSAM, COBOL, Assembler, Endeavor

Confidential

Senior Programmer Analyst Consultant

• As an IBM contractor, I was a member of a programming team supporting Financial Interfaces between DSHS and other State and Federal agency Systems. I was responsible for programming maintenance and development to meet Federal requirements as well as nightly On-call support of the Batch Cycle on a rotating basis.
• One project involved to add an online lookup capability from weekly downloaded DOL vehicle and vessel files. The output files from this programming are used to load DB2 databases that are accessed by the DSHS Spider Intranet.
• Maintained programming in COBOL and CICS with enhancements to IMS Databases.
• Developed all the programming components for an interface with Department of Licensing
• Developed new standardized COBOL programs and JCL to replace legacy DYL280 programs
• Developed and conducted User Acceptance testing in coordination with Business Analysts
• Developed testing 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 OS mainframe, TSO/ISPF, COBOL, CICS, VSAM, DB2, IMS, Rational ClearQuest

Confidential

Analyst/Programmer

• Responsible for programming support of the Financial Accounting and General Ledger systems using COBOL as the main programming language in an IBM environment.
• 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

Senior Systems Analyst/Programmer Consultant

• 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

Information Systems Analyst/Programmer Consultant

• 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

Senior Software Developer

• 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

Senior Systems Analyst

• 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 OS mainframe, TSO/ISPF, COBOL, CICS, VSAM, Endeavor

Confidential

Senior Analyst Programmer

• 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 OS mainframe, COBOL, CICS, TSO/ISPF, XPEDITER, Endeavor

Confidential

Programmer Analyst

• Responsible for programming and analysis on problems and projects for the Financial Accounting and Claims legacy systems in a Natural ADABAS environment.
• Developed multiple online screens in Natural to capture data and update master files.
• Created Natural and COBOL programs and batch JCL to execute in nightly batch cycle.
• Analyzed and modified legacy claims and billings systems major project upgrades such as Account Discount, 1099-Misc Reporting and Draft Reversal.
• Used Natural Construct to design programming to access subsystems, PF-keys and online help.
• Coordinated training efforts with Claims and Financial teams before implementation.
• Created user documentation for both online and batch support after migration to production.
• Created restart documentation instructions for Production Operations.

Environment: IBM VSE mainframe, ADABAS/Natural, Natural Construct, COBOL, CICS

Confidential

Computer Analyst / Programmer

• Responsible for online and batch programming development and maintenance using CICS and COBOL.
• Supported all county departments: Assessor, Auditor, Environmental Health, Sherriff, and District Court.
• Accountable for on-call programming and system support, problem solving, and Operational support for all user departments.

Environment: IBM VSE mainframe, COBOL, CICS, VSAM, XPEDITER