OVERALL SUMMARY:

• Twenty five years experience in programming, analysis and design. Five years experience with banking and other financial systems. Primary concentration with mainframe and Client/Server applications. Highly proficient in COBOL, COBOL II, IMS, DB/DC, DB2, and RDBMS. Well organized individual with an excellent aptitude for details.
• Management, Design and Team Lead experience includes: Full Life Cycle Software Development with business process models, modeling methodologies, requirements gathering, development, testing, implementation, and maintenance.
• Systems and functional analysis including interface with Subject Matter Experts and Management.
• Conducted JAD and RAD Sessions with a Structured Development Environment.
• Worked with Relational Databases, including Oracle, DB2 and MS SQL Server.
• Performed Structured System Design, Data Flow Diagramming and Logical Data Modeling.
• Did Technical writing, creating documentation related to systems development and design.
• Designed and documented systems in UNIX and Windows Computing Environments along with legacy platforms, including familiarity with distributed systems and N Tiered Data Structures.
• Lead, developed feasibility and analysis studies, reviewed technical and user design plans.
• Did Application programming, Data mapping, Data/System Migration and Integration.
• Managed teams that have consolidated multiple systems, including data migration, configurations, and go-live planning.
• Code evaluation included: conducting code reviews, reviews for adherence to programming standards, and adopted methodologies.
• Re-Engineered and application mining, prospecting and extracting business rules, consolidated and modularized projects for systems.
• Personnel reviews encompassing code evaluation, and adherence to programming standards, and programming methodology.

HARDWARE/SOFTWARE LANGUAGES:

IBM 3090, IBM 370/158, IBM 3033, IBM 8100, IBM 486, IBMPS2/MultiMedia, IBM PC/XT/AT, XPEDITER, LIBRARIAN, TSO/PSE, TSO/ISPF, Panvalet, IDMS, MFS, IMS DB/DC, ADF, Telon, Mark IV & V, VSAM, CASETOOL/IEF, COBOL, CICS, INQUIRY IV, DYL 280, SQL, PRO IV, BTS, DLTO, Data Dictionary, DB2, DB2/XPERT, Oracle 6.0-7.0, MVS/OS, Novell, NetWare 3.11, Query Management Faculty, SPUFI, Access, Visual Basic 4.0, PowerBuilder, Microsoft SQL Server, Windows Focus.

TECHNICAL:

Hardware: Windows, UNIX, IBM 3090, 370/158, 3033, 8100, IBM PC and compatibles
Software: Oracle 6.0-7.0, SQL, Xpediter, Librarian, TSO/PSE, TSO/ISPF, Panvalet, IDMS, MFS, IMS DB/DC, DL/I, CICS command, ADBAS SQL, ADF, Telon, Mark IV and V, VSAM, Casetool/IEF, Cobol/Cobol II, MicroFocus Cobol, INQUIRY IV, DYL 280, PRO IV, BTS, TSO/ISPF, TSO CLIST and DMS, OS/JCL, DLTO, Data Dictionary, DB2, DB2/XPERT, MVS/OS, Novell, Netware 3.11, Query Management, Faculty, Spufi, Access, Visual Basic 4.0, PowerBuilder, MS SQL Server, SQL Queries, Windows Focus, Sarbanes Oxley (SOX).

EDUCATION:

Computer Science and Electrical Engineering

EXPERIENCE:
Confidential,Ca 11//07 – 12/07
Technical Specialist

Responsible for producing testing tools of a Backward Data Bridge to
Update VSAM datasets using full files of SAP Tables. Yamaha is converting
mainframe applications to SAP, however there were some applications that needed
to continue running on the Host. Testing tools needed to be written to update existing
application with information from the SAP Tables. These testing tools programs needed to evaluate the CICS log dataset for online programs and production batch schedule dataset to determine which Programs would be affected for the back data bridge. The testing tool programs used to update the information on the mainframe with the SAP data, were CICS command written in Cobol using Xpediter, and batch programs used File-Aid to verify
JCl, PROCS and Copybooks that needed to be changed for program testing.

Confidential,CA 07/06 – 08/07
Technical Specialist / Project Lead

Responsible for all aspects of the System development Life Cycle including
business process models, modeling methodologies, requirements gathering,
development, testing, implementation, and maintenance of assigned projects
and provided a single point of contact for those projects. Currently
project lead for the Open system (Multi-Platform) Warehouse system.
Responsibilities include: Systems and functional analysis of business and
user needs, including direct interface with Subject Matter Experts and
Management, Including prospecting and the extraction of business rules.
Perform Feasibility studies and documentation of requirements. Translation
of business requirements into system requirements and specification.
Program, design, coding, testing, debugging and documentation. Provided
primary support for both online transaction and batch jobstreams in Order
Entry systems. These systems where developed across platforms on the Host
(Mainframe system - in CICS command Level Cobol DB2 SQL, running on Z/OS,
using software tools such as Inter-Test, FileAid DB2, Panvalet, SPUFI and
CEDF) On the (Client -Server system - using Mircofocus Cobol and C with
Oracle and Toad Software) running on a Unix platform. Including using MQ
Series to upload and download data from platform to platform.

Confidential,CA 10/05 – 03/06
Application Architect / Project Lead

• Project lead for the Vehicles Systems Customer Sales Order Status and Vehicle Ordering Regional and Dealer.
• Systems and functional analysis of business and user needs, including direct interface with Subject Matter Experts and Management. Including prospecting and the extraction of business rules, feasibility studies, documentation of requirements, and translation into proper system requirement specification also including program design, coding, testing, debugging and documentation.
• Provided primary support for both online transaction and batch jobstreams in Customer Sales and Vehicle Ordering systems.
• Vehicle parts and order swapping and customer order statues of vehicles. These systems where developed in CICS command Level Cobol DB2 and ADBAS SQL, running on Z/OS, using software tools such as AGS Smart Test, FileAid DB2, Panvalet, SPUFI and CEDF.

Confidential,CA 01/01 – 03/05
Application Architect / Project Lead

• Project lead for the Global Employee Management System (GEMS) human resources, personnel and benefits systems.
• Systems and functional analysis of business and user needs, including direct interface with Subject Matter Experts and Management
• Including prospecting and the extraction of business rules, feasibility studies, documentation of requirements, and translation into proper system requirement specification also including program design, coding, testing, debugging and documentation.
• Provided primary support for both online transaction and batch jobstreams in personnel, payroll and benefits systems. Aforementioned includes: New hire, leave transaction, EIN changes, new vendor files, mock purchase, benefits download and upload data processes LPC software upgrade, and DB2 upgrade from version 5 to 7.
• Provided primary support for Sarbanes Oxley (SOX) in Benefits and Payroll in purchasing and spend management.

ANTHONY MACK PAGE 4

• These systems are written in Cobol IMS DB/DC and DB2, running on OS/MVS and now Z/OS, using software tools, such as Xpediter, Fileaid and Librarian
• As Lead, responsible for managing team of programmers and testers.
• Was responsible for ongoing Code evaluation and periodic Personnel reviews encompassing code evaluation, and adherence to programming standards, and programming methodology.

Ernst and Young, CA 01/00 – 12/00
Senior Associate II

• Developed and did the Architecture of Sprint ION Integrated On-Demand Network. This was a fully integrated broadband communications network that can turn voice, video, data, and high-speed Internet service into a revolutionary e-business tool that can supercharge your business.
• Utilized I/Watch to monitor multiple databases, applications and operating systems across the enterprise, SQLab Tuner to identify records and tune offensive SQL statements in production applications.
• Used SQLab Xpert context-sensitive tuning advice to aid in resolving common database problem, Instance Monitor to monitor performance and diagnose problem areas.
• Served as Space Manager to recover wasted disk space and ensures peak performance with capacity planning. Detailed work with reorganization tools, LiveReorg to reorganizes tables and their associated indexes, TOAD PL/SQL editing, and SQL Navigator for tuning
• Debugging and advanced PL/SQL code libraries to assist DBA’s with Oracle Application Tuning, Oracle Query Optimization, Oracle Database Backup & Recovery and Oracle8 & 8i Database Administration on UNIX and Windows NT-based systems

City of Los Angeles, CA 03/98 - 12/99
Consultant

• Street maintenance system - IMS DB/DC online and batch.
• Extensive maintenance and modification to street lighting system - DB2, COBOL II.
• Worked on tax systems and new open enrollment for the City of Los Angeles written in Command Level CICS and COBOL II.
• Worked on election system written in COBOL II Assisted IN LUPANS System DB2, COBOL II WITH LAN usage.

County of Los Angeles, CA 10/97 - 02/98
Consultant

• Responsible for redesigning the building permit system. This system included over 15 modules interfaced with users.
• Solely responsible for analysis, coding testing, and implementation. Environment: COBOL, IMS, DB/DC.

ANTHONY MACK PAGE 5

Kaiser Permanente, CA 01/97 - 10/97
Consultant

• Worked with a team of (3) enhancing the Medical Options Maintenance (MOM) system. Modules included Solicitation, Enrollment and Disenrollment, and HCFA (government reporting codes) Generated screens and Telcon to generate COBOL code which had to be customized. Environment: COBOL, Telcon, IMS, DB/DC EDS.

Financial Services Group, CA 01/96 - 12/96
Consultant

• Developed batch and online demand deposit applications. The applications were developed for Mercantile and Firstar Bank. Environment: COBOL, CICS, and VSAM.

Home Savings & Loan, CA 02/95 - 12/95
Consultant

• Responsible for analysis design, coding, and conversion of Marshall & Isley Package. Environment: COBOL, COBOL II, DB2, IMS, DB/DC LIBRARIAN, OS/JCL

Northrop, CA 03/94 - 01/95
Consultant

• Responsible for design and implementation of an online purchase order system. Environment: COBOL, DB2, IMS, DB/DC, LIBRARIAN, OS/JCI.

Allied Signal Aerospace, CA 01/93 - 01/94
Project Leader

• Strong analysis, design and programming skills, including user requirement definitions, business process reengineering/analysis. Environment: MACPAC/D turkey, COBOL/IMS, DB/DC, Oracle, and DB2 enterprise wide implementation.

Saudi Business Machines, CA 01/91 - 12/92
Consultant

• Designed an employee personnel and tracking system for Saudi Aramco.
• These systems were designed using Novell NetWare running on an IBM 496 server connected to eight Client IBM PS/2s and were written in Oracle 7.0 and PowerBuilder.

American Express, CA 01/89 - 12/90
Sr. Consultant

• Coded, implemented and documented three major interface systems for the SC non-financial maintenance core extract and submission monitor. Written in COBOL using IMS and DB2. Made major modifications to three submission programs in DB2, COBOL. Used XPEDIER, DB2/XPERT, LIBRARIAN and SPUFI.

ANTHONY MACK PAGE 6

Security Pacific Bank, CA 06/86 - 12/89
Sr. Consultant

• Responsible for the analysis, specification, coding, implementation, and documentation of a potential charge-off loan subsystem.
• The system was written in COBOL using IMS.
• As such, this required charges to fourteen stand alone IMS/MPP transactions and their associated MFS formats, making changes to one driver. IMS/MPP was used to load data passed from an IBM 8100 to the IMS host databases on an IBM 3090.
• The IMS were non-conversational.

Hughes Aircraft Co., CA 01/86 - 06/86
Sr. Consultant

• Responsible for the analysis, specification, and coding of an automated subsystem for backing up purchase orders from a parts purchasing system.
• The system was written in IMS ADF Rel/2, using ADF Audit Exit and COBOL.
• The System was online and used IMS HIDAM-VSAM AND HDAM-OSAM databases. Also created a proper testing environment for IMS systems, including the implementation of BTS II foreground procedures, allocation of databases, indexes, and BTS files.
• Was also responsible for database recovery procedures which were written for an IMS and BTS database environment.

Hamilton AVNET Co., CA 02/84 - 12/85
Sr. Consultant

• As the senior system consultant this assignment was for the design, development, and implementation of electronic packing purchase order and letter of intent systems.
• These systems were written in TELON and IMS DB/DC. Participated in the conversion of the accounts payable and general ledger systems from IDS II to IMS DB/DC.
• Also responsible for the coding of twenty TELON panels, which included screen definitions and custom generation using MSDB and DEDB databases.
• This system was composed of both firstpath and full function IMS databases.

Blue Cross Medical, CA 01/82 - 01/84
Sr. Consultant

• Responsible for developing and maintaining application systems including medical claims, account receivable, account payable, and funds utilization.
• These systems contained a total of forty eight PRO IV programs with access tested at the operator and category levels.
• Also designed and developed the security processing system for the group and individual claims system.

ANTHONY MACK PAGE 7

Denny’s Restaurant Co., CA 01/81 - 12/81
Sr. Consultant

• Participated in the conversion of DOS to MVS.
• Also converted applications operated in both batch and on-line environments.
• Specific responsibilities included the analysis of the file conversion to VSAM and the conversion of COBOL application programs from DOS to OS.
• Programs were written in ANS COBOL, for the IBM-4341 under OS/VS utilizing VSAM, TMS, IMS, IMS/DB, COPICS, ROSCOE and LIBRARIAN.

Glendale Federal Savings, CA 01/78 - 12/80
Sr. Consultant

• As a senior systems consultant for Glendale Federal Savings, designed debugged, and tested a mortgage loan batch summary system that processes data from the Cummins-Allison Data Capture System. Also designed a COBOL, batch system for the express purpose of up dating the MNEMONIC index