Ms Office Design

Allen C Meredith

**** * *******, ******, ** ***** • 661-***-**** • E-mail: acc7uf@r.postjobfree.com

Summary

Self directed and results oriented Software Developer, highly experienced in designing, developing and maintaining

mission-critical systems centered on IBM mainframe/client server architecture.

• Experienced in all phases of software development lifecycle (SDLC) - ISO 9001 2000 compliant.

• Expert technical knowledge with hands-on experience in software development, maintenance and production

support.

• Demonstrated knowledge of complex database systems – DB2 UDB, IMS, and Oracle.

• Meticulous in assessing and hurdling complex technical issues in a production environment.

Technical Qualifications

Industries: Aerospace, Agriculture, Financial, Freight Service, Health Care, and State Government.

Methodologies: Database Design and Normalization, ETL, OOAD, SDLC, and UML.

Languages: COBOL (II, 370, OS/390, z/OS), Clist/REXX, FTP, JCL, Procs, JES2, JES3, PL/1, SQL, SyncSort,

and XML/XSLT.

Software: CICS, DB2 Utilities, IMS and MVS Utilities, MS Exchange, MS Office, MS Visio, SyncSort, TSO,

ISPF/SDSF, and VSAM.

Development Tools: Abend-Aid, APS, ClearQuest, ChangeMan, CSP, DB2 (ADMIN, DB2I, QMF, Spufi, Utilities), Endevor, ERwin Data Modeler, File-Aid, IBM (BTS, Host-On Demand, MQSeries), Micro Focus Cobol, Netron, Panvalet, Platinum, Rational RequisitePro, and Xpediter.

Databases: DB2 UDB for z/OS V8/9 and IMS V10/11.

Operating Systems: Windows XP/2000/Vista/7, z/OS, OS/390, MVS/ESA, and MVS/XA.

Hardware: Desktop PC’s and Workstations, IBM System z9, IBM S/390, and IBM RS/6000.

Professional Experience

Contract – Programmer Analyst 06/2013-01/2014

Collabera, Boeing, Renton, Wa

Served as on-site consultant for Boeing’s Sonic Release Group to implement Phase I in migrating data from an IMS system to SAP (MS System).

• Served as a technical expert under the guidance of the Senior Programmer and FA, analyzed, identified course of

action and defined code changes to IMS Cobol programs written in APS in a team environment.

• Implemented code changes in rapid succession to meet test implementation deadline.

• Successfully provided technical support to FA’s in the SONIC group to update Part Number Release data.

Skill sets: Analysis/Design, COBOL, APS, IMS DB/DC, DB2 V9/10 for z/OS, DB2 (DB2I, QMF, Spufi, Utilities), FILE-AID, IBM MQSeries, JCL, JES2, Procs, VSAM, SQL, TSO ISPF/SDSF, ClearQuest, MS Exchange, MS Office, Rational RequisitePro, Windows XP, IBM Z/OS OS/390.

Contract – Programmer Analyst 09/2011-05/2013

Eclaro International, Washington State, Olympia, Wa

Worked independently and in a team setting, supported the State of Washington’s DSHS ACES welfare system - TANF,Medical, Cash and Food assistance programs.

• Provided on-time, on-budget analysis, design, development, testing, and documentation of tasks on

mainframe applications and adhered todesign and development standards.

• Active in unit testing and integration testing of assigned tasks following approved testing procedures and

guidelines and provide maintenance support of existing applications.

• Took ownership of support of code in Acceptance Test and Production.

Skill sets: Analysis/Design, COBOL II, CICS (DTCN, EXEC DLI, BMS MAPS), IMS DB/DC, DB2 V9 for z/OS, DB2(DB2I, QMF, Spufi, Utilities), FILE-AID, HIPAA, IBM (MQSeries, Utilities), JCL, JES2, Procs, VSAM, SQL, TSO ISPF/SDSF, ClearQuest, MS Exchange, MS Office, Rational RequisitePro, Windows XP, IBM Z/OS OS/390.

Contract – Senior Programmer Analyst 04/2008-05/2011

VisionIT, Highmark Blue Shield, Camp Hill, Pa

Core contributor in support of the Government’s HIPAA 5010 and ICD-10 healthcare initiatives, in defining, analyzing,developing, testing, and implementing of mission-critical software systems including major enhancements to existing

Claims Subsystems.

• Instrumental in implementing corporate mandate to modernize legacy COBOL applications using IMS DB/DC

and DB2.

• Analyzed mandated requirements, designed, coded, tested and implemented Batch, BMP, and MPP COBOL

programs (100+) for Claims subsystems using CICS, IMS, DB/DC, embedded DB2 SQL, and Xpediter.

• Enhanced and implemented numerous BMS maps and MFS screens populated with claims data.

• Developed and maintained mission-critical production Batch and BMP JCL and PROCS, including Clists/Rexx.

• Insured quality control of mission-critical software by executing, validating and documenting test cases, test

defects, and test results.

• Implemented ETL data sourcing solutions for migrating healthcare data from disparate source systems into the

enterprise data warehouse to meet a wide range of business and system requirements using EZtrieve and DB2.

Skill sets: Analysis/Design, ISO 9001 SDLC, Abend-Aid, COBOL for z/OS, CICS, IMS DB/DC, DB2 V9 for z/OS, DB2(DB2I, ADMIN, QMF, Spufi, Utilities), Endevor, ETL, EZtrieve, FILE-AID, FTP, HIPAA, IBM (BTS, Host On-Demand,MQSeries, Utilities), JCL, JES2, JES3, Platinum, Procs, VSAM, Metadata, SQL, SyncSort, TSO, ISPF/SDSF, Xpediter,

MS Exchange, MS Office, MS VISIO, Windows XP, IBM System z9, and z/OS.

Contract – ISD2 Senior Programmer Analysts 04/2007-08/2007

New Mexico Human Services, Santa Fe, Nm

As an active team member, provided technical support to the Income Support Division’s Integrated Services Delivery (ISD2) system. This project supported the systems that determines eligibility of and distributing benefits to Food Stamp,Medicaid and Cash public assistance recipients.

• Collaborated with end users to ascertain functional requirements and created comprehensive technical

designs of software solutions.

• Modified, tested and implemented ISD2 Cobol, CICS, and DB2 software to introduce changes and new

features required by law, policy and other government initiatives.

• Insured quality control of software by executing, validating and documenting test cases, test defects, and

test results.

• Resolved technical production issues in a timely manner while on-call 7/24 one week a month.

Skill sets: Analysis/Design, ISO 9001 SDLC, Abend-Aid, COBOL II, Microfocus Cobol, CICS, DB2, DB2 (Platinum Tools. DB2I, QMF, Spufi, Utilities), JCL, JES2, Procs, VSAM, Panvalet, SQL, SyncSort, TSO, ISPF/SDSF, Xpediter, MS Office, Windows 2000, IBM MVS/ESA.

Contract - DB2 System Administrator 07/2006-09/2006

Louisiana Department of Social Services, Baton Rouge, La

Recruited to supplement DB2 support of the Comprehensive Enterprise Social Services System (ACESS).

• Administered and optimized DB2 databases, including creating data structures and all related objects.

• Increased level of user support in responding to requests to update DB2 tables to meet new project objectives.

Skill sets: Analysis/Design, DB2 UDB for z/OS, DB2 (Database Design and Normalization, DB2 Admin, DB2I, QMF,Spufi, Utilities), ERwin Data Modeler, IBM Host On-Demand, JCL, JES2, JES3, Platinum, Procs, SyncSort, TSO/ISPF,VSAM, MS Office, Novel Groupwise, Linux, Windows 2000, IBM System z9, and. z/OS.

Contract - Technical Designer Consultant 10/2005-03/2006

American Express, Phoenix, Az

Supported the American Express’s MRA(Membership Rewards Accelerator) project.

• Collaborated with System and Application Architect in defining system architecture/design and determining scope

of change.

• Focal point for all the deliverables that were produced during the design phase and ensured that Design, Build,

and Test were aligned with the requirements established during the analyze phase.

• Ensured proper review of established processes and procedures in place to guarantee designs, code, and

development life cycle.

Skill sets: Analysis/Design, Architecture, ISO 9001 SDLC, UML, COBOL OS/390, ChangeMan, JCL, VSAM, IBM MQSeries, TSO, ISPF/SDSF, XML/XSLT, Lotus Notes, MS Office, Windows 2000, IBM System z9, and z/OS.

Sr Data Consultant 03/2005-09/2005

Kaiser Permanente, Lake Oswego, Or

Supported the Medicare Modernization Act (MMA) and Part D to provide coverage and expansion of affordable health plan choices costs.

• Analyzed, designed, coded, debugged, tested (unit, integration, system, and regression) and implemented JCL,

Procs, Cobol II, CSP, CICS/DB2 applications and BMS maps.

• Provided analytical and technical Skill in other internal projects requiring support.

Skill sets: Analysis/Design, ISO 9001 SDLC, ChangeMan, Cobol, CICS, BMS maps, CSP, DB2 UDB for z/OS,DB2(DB2I, QMF, Stored Procedures, Spufi) JCL, JES2, JES3, SyncSort, VSAM, TSO/ISPF, z/OS, Lotus Notes, MS Office, Windows 2000 Workstation, IBM System z9, and z/OS.

Contract - Senior Programmer Analyst 10/2004-02/2005

WellPoint, Newbury Park,

Enhanced and supported a component of an online IMS Medical System requiring additional functionality to meet current

business requirements.

Skill sets: Analysis/Design, ChangeMan, Cobol/390, IMS DB/DC, IMS Utilities, MFS, Expeditor, JCL, JES3, SyncSort,VSAM, TSO/ISPF, MS Exchange, MS Office, Windows 2000 Workstation, IBM System z9, and z/OS.

Senior Programmer Analyst 05/2003-04/2004

FedEx, Collierville, TN

Enhanced, maintained and supported the Orbit/Edit sub-system of a US Domestic billing system in a teaming environment for FedEx. Greatly reduced the number of Air bills in error and recaptured lost revenue by incorporating new software

business rules.

Skill sets: Analysis/Design, ISO 9001 SDLC, Cobol, IMS DB/DC, IMS Utilities, MFS, JCL, JES2, JES3, SyncSort,VSAM, Xpediter, TSO/ISPF, MS Exchange, MS Office, TeamPlayer, Windows 2000 Workstation, WRQ Reflection, IBM System z9, and z/OS.

Contract - IBM IMS Consultant 05/2002-11/2002

ADM – Archer Daniels Midland, Decatur, Ill

Enhanced, maintained and supported a Cobol IMS Commodity Management System/Shipping for the mid western United States.

Skill sets: ISO 9001 SDLC, Cobol II, CICS, BMS maps, IMS DB/DC, IMS Utilities, MFS, Netron, Sybase, SQL, JCL,JES3, VSAM, Xpediter, TSO/ISPF, MS Exchange, MS Office, Windows 2000 Workstation, IBM S/390, and OS/390.

Senior Programmer Analyst 06/1989-01/2002

The Boeing Company/Rocketdyne, Canoga Park, Ca

Technical lead and team member in the development and maintenance of a highly specialized and complex C/C++, Cobol IMS, DB/DC, DB2 and Oracle manufacturing systems that supported NASA’s Space Shuttle and Space Station programs

requiring Configuration Status Accounting (As Designed, Built and Maintained).

Skill sets: Analysis/Design, ISO 9001 SDLC, OOAD, OOP, UML, CSS, HTML/XHTML, Java, JavaScript, IBM Host-On-Demand, Macromedia Studio, Oracle 8i/9i, PL/SQL, Pro*Cobol, SQL*Loader, SQL*Plus, XML/XSLT, APS, C/C++,Cobol II, Microfocus Cobol, DB2 UDB, DB2 (Database Design and Normalization, DB2i, QMF, Spufi, SQL, Stored

Procedures, Triggers, Utilities), ETL, IMS DB/DC, IMS Utilities, FTP, JCL, JES3, SyncSort, VSAM, Xpediter, TSO,ISPF/SDSF, MQseries, MS Exchange, MS Office, PVCS Tracker, Solaris/UNIX, Window 2000/NT Workstations, IBM

eServer z900, IBM S/390, IBM RS/6000, z/OS and OS/390.

Education

B.S., Information Science, Northeastern Illinois University, Chicago, Illinois

Graduated with honors in Information Science

B.A., Political Science, University of Washington, Seattle, Washington

References are available upon request.

Contact this candidate