SUMMARY : More than twenty five 25 years of IT work experience specializing in computer systems planning, design, development, implementation and support. He has been in the IT consulting field for the last twenty 20 years and has varied industry exposure. He had assumed critical roles in project management and systems implementation and support. Mr. Machacon works well at all levels of the corporate structure.

• HARDWARE: IBM mainframes, ES 9000, IBM 30xx, IBM 43xx, IBM PCs, and IBM 370.
• SOFTWARE: DB2, SQL, IMS, VSAM, CICS, OS/390, MVS, TSO/ISPF, ENDEVOR, PANVALET, LIBRARIAN, SYNCSORT, FILE-AID, INTERTEST, XPEDITER, INSYNC, MF XPRESS, DB2 Stored Procedures, SYBASE, UNIX Shell Scipts
• LANGUAGE: Enterprise COBOL OS/390 LE, COBOL II, MicroFocus COBOL, PL/1, FORTRAN

EXPERIENCE:

Consulting

Confidential

As contract developer, was assigned to the Enterprise Investment Products EIP Lighthouse Team of the Global Systems Integration Division of Vanguard . This was the same group he worked with in 2004 with front-end system converted from Sybase to Java. The team is now responsible for maintaining and providing information on investment products thru its Lighthouse and ViFi websites. Implemented DB2 and Native SQL Stored Procedures SPs to provide and maintain fund information for the UI/Java/mid-tier environment. Coded Cobol/DB2 subprograms, following corporate DB2 architecture, that will be called by maintenance, file load, and audit trail SPs. Also, implemented Cobol/DB2/JCL batch processes that maintain the Enterprise Database including fund steward to catalog table loads. The EIP Database is a central repository of investment product information on characteristics, account, holdings, prices, performance returns , audit information, and analytics. Was involved in analysis, design, testing and support, system defect research and resolution, SQL performance tuning, and turnover of production-bound members. Technical environment include COBOL, DB2, SQL, Stored Procedures, Native SQL, ENDEVOR, Mainframe Express MFE , BMC, Apptune, MVS, JCL, InSync, home-grown RDA Tools, and Agile Methodology.

Confidential

As a contract developer, was assigned to functional groups of the Retail Division of Vanguard in their development and enhancement efforts. At the Transaction History/Personal Performance team, implemented the process that route Brokerage transaction files to the right Test Environment for Project One P1 . The process makes use of BMC Unloads and EZTRIEVE match/merge to filter the input transaction files based on accounts reference file generated for six DB2 test regions. Later, was tasked to revise and test around 90 COBOL/DB2/Stored Procedures programs to use the new P1Trade transaction table which is the merged version of Transaction Main and Detail tables. At the Vanguard Order Management team, coded, unit-tested, and prepared prod jcls to implement the following Investment Account VIA reports using new Enterprise source tables: Rejected Cancel Requests a csv report to Unix server , and the WAVE Management Overrides Report, and the Uncollected Withdrawals Report to go to Infopac. Built the process to filter the response file based on a reference accounts list for routing trade orders into the correct test region. With the Cost Basis Team, was involved in enhancements of various Cost Basis processes and in the year-end Lot Relief Method conversion. Coded and tested COBOL/DB2 programs that will extract brokerage accounts mutual fund holdings before correctly populating the lot relief method field. Revised existing CBA programs to access the correct tables for VIA and legacy processing. Also, revised programs and jobs to improve performance. Coded COBOL/DB2 Stored Procedures to allow mid-tier interface to retrieve data from Cost Basis tables. Coded a process that will generate brokerage and mutual fund extracts for crews that changed fund ownership status for input into the existing account build process. With Merge and Expand project, was assigned to both online and batch teams. For the online team, coded portions of the DB2 common Rules module that will be called by batch and mid-tier to validate if a certain account qualifies to convert to a Vanguard Total Account. Coded architecture, table handler, and event handler programs that will be called by other programs to maintain the work tables. Then, joined the batch team to code carryover of account information from the old to new brokerage account which includes: tax info, address change hold, positions extract, check writing, registration data, and account marketing profile. Technical environment for these projects include COBOL, DB2, Stored Procedures, EZTrieve, ENDEVOR, InSync, Mainframe Express MFE , Apptune, home-grown RDA Tools, and Agile.

Confidential

As developer/contractor, was part of PNC's Wealth Management Technology team that successfully implemented several projects.

• Mercantile Bankshares conversion of trust accounts of this PNC acquisition into PNC's Trust Accounting system which include accounts of Maryland Local Government, Bakery and Confectionary Union, and APCO. Coded, revised, and tested programs that create and process cash activity trade transactions and reports.
• Centerpiece Interface designed a process and developed programs that create comma delimited files on positions, security asset prices, portfolio info, account trans history for transmission to an external party SQLServer-based Portfolio Management System. The system was designed to be flexible enough to accommodate new Centerpiece clients.
• Enhanced Asset Master developed programs that created a new and enhanced classification and categorization of assets such as tax code, capitalization, and style of mutual funds, equities, and fixed assets with logic based on existing asset master values and new code reference sets. The file is now used as another cross-reference file by other AMTRUST applications and was later on revised to store Listed Options fields.
• Exchange Traded Funds ETF Continuous Settlement coded batch, online, and report programs for an ETF Accounting system developed for an external party that allows them to reconcile with NSCC the trade transactions on the party's ETF accounts and assets.
• National City Conversion was involved in job and program performance tuning, specifically VSAM file access, prior to conversion for this large PNC acquisition. For data conversion, coded several programs that format NCC daily accrual files into patterns that follow the PNC's data capture process for eventual processing in AMTRUST.
• Other Interfaces - developed interface processes that provide files containing account info and positions through transmissions to external parties such as Petro Data, Real Property and Loans, and lending institutions that deal with PNC.
• Environment is IBM mainframe, Enterprise COBOL, DB2, VSAM, CICS, FILEAID, XPEDITER, MVS JCL, and ENDEVOR.

Confidential

For JP Morgan-Chase bank's Credit Card Services division, was a member of the team who system tested and supported the conversion of the Authorization mainframe portion of the vendor's Credit Card system as part of in-sourcing,disk mirroring and migration rehost efforts prior to actual turnover to the bank. The team's task was to ensure that the production-bound test environment mirrors exactly production in terms of data accuracy and performance. Provided fixes to data, program versions and process discrepancies. The system runs on an IBM-Tandem hardware platform. Was specifically assigned to evaluate and analyze the Security Fraud subsystem. Environment is IBM Mainframe, COBOL, DB2, IMS, VSAM, CICS, MQ Series, FILEAID, and CHANGEMAN.

Confidential

For a major reinsurance company, Munich Reinsurance America, was the only consultant in the team that supported the multi-platform Data Warehouse systems. Prepared impact analyses and strategies to implement user change and service requests. Analyzed, developed and implemented mainframe/Unix processes, file transfers, data load, system fixes and enhancements to ensure the completeness, accuracy, availability and integrity of data on claims, treaty, policy, certificate endorsements, contracts, premiums, claims and other financials. Environment is IBM 3090 mainframe, HP UNIX, DB2, Oracle Databases, mainframe COBOL, MicroFocus COBOL, VSAM, ENDEVOR, and JCL MVS.

Confidential

For the Corporate Division of the Vanguard Group, a major mutual fund and 401K company, played major roles in the redesign and implementation of the web-based CMDA and IWE systems. Analyzed, designed, prepared specs and coded COBOL DB2 stored procedures and batch programs to provide fund information from the Enterprise databases to the WebSphere mid-tier environment. These databases are central repositories of investment product information on prices, performance returns , and characteristic data. Modified several SYBASE procedures that extract data from the transactional and entry systems for loading into the Enterprise databases. Also, coded DB2 programs to populate percent distribution catalog tables which are the bases for the Enterprise Investment Product system prospectus . The batch portion of IWE also included the redesign and implementation of a Portfolio Composition process based on market values by extracting fund prices from an existing UNIX-based pricing system. Analyzed, designed and implemented the subsequent changes and enhancements for both CMDA Funds Book and IWE. Environment is COBOL OS/390, DB2, SQL, DB2 Stored Procedures, SYBASE, MF Express, InSync, and ENDEVOR.

Confidential

• For the Institutional Division of The Vanguard Group, analyzed the requirements and implemented the enhancements to the following subsystems:
• Disbursement Checks List Report enhanced the existing report file layout which was converted to Comma Separated Value CSV file for FTP to end-user PCs. The system makes use of a web-based front-end E-Vent that generates the control card option that specifies the report format and allows multiple file generations in a day.
• 401K Withdrawal Transactions as requested by business users, modified the Withholding Tax calculations on Qualified Employee Voluntary Contributions taking into account the call chain and tax calculations followed by the existing OMNIPLUS programs
• Proxy Files modified program logic to generate the new participants' share balances file layout as requested by Vanguard's proxy clients.
• Pass-thru Dividends Coded and tested the De Minimus Amount logic for Pass-Thru-Dividend checks. The new logic provided system capability for 401K plans to automatically reinvest dividends paid to members.
• Environment was COBOL OS/390, DB2, VSAM, CICS, InCert, InSync, and ENDEVOR.

Confidential

As analyst/programmer, was part of the team that enhanced the 401K Contributions Subsystem and the Loan Repayment Subsystem of The Vanguard Group, a major pension/mutual fund company. The purpose of the Contributions project was to accommodate and impose limits on Catch-Up contributions of plan members aged 50 and above. Revised online and batch programs to provide catch-up capability and validate options chosen by 401K plans. The purpose of the Loan Repayment project was to assign the correct loan numbers to transactions file transferred by participating companies as payments to 401K loans. The loan numbers sent may be invalid, inactive, or non-existent and therefore need to be corrected thru field cross-validation and payment amount comparison. Coded revisions to existing OMNIPLUS programs, direct updates to transaction DB2 tables and masterfiles, and audit reports. Involvement was on detailed design, coding, unit testing, integration testing, jcl prep and production turnover. Environment was COBOL OS/390, DB2, VSAM, CICS, and ENDEVOR.

Confidential

As senior programmer/analyst for the Check Processing subsidiary of Deutsche Bank, a large commercial bank, was part of the team that analyzed, tested, installed and supported CheckFree's ARP/SMS, an account reconciliation package. Developed and coded the processes that will create the inputs to ARP/SMS from the bank's existing subsystems. Input transaction files were in the form of check issues, cancels, paid checks and stop payments. Also, developed the processes that provide interfaces to the receiving subsystems which include exception processing, dda, and enhanced reports and output files, to make sure that the new check processing system performs the functions of the old-in-house system. Provided heavy JCL support during installation and post-installation phases. After installation, provided support on design, analysis, program and jcl coding, and production implementation of several enhancements as requested by the users. Environment uses IBM 30xx, MVS, O/S 390, COBOL II, VSAM, DB2, and ENDEVOR.

Confidential

As senior programmer/analyst for Merrill Lynch, a major stock brokerage, was responsible for enhancement, development and support of Mutual Fund CORE subsystems and Mutual Fund Advisory MFA subsystem. Fine-tuned for optimized performance several Mutual Fund Single Registration programs which process and update account, fund, and position information. Was part of the team who developed, tested for UAT, implemented and supported the Mutual Fund Portability subsystem. Analyzed, designed, programmed and implemented the Profit and Loss portion of the Portability subsystem. For MFA, generated ad-hoc Quarterly Performance Reports of the different funds as requested by clients. Also, analyzed, designed, prepared specs, and implemented the Assets Held subsystem which monitors and provides exception reports on funds held or managed by Merrill. Environment was IBM 30xx , MVS, VSAM, DB2, COBOL II, PANVALET and ENDEVOR.

Confidential

As senior programmer/analyst for AT T, a major telecommunications company was responsible for development, enhancement and post-installation maintenance of around twenty 20 Interface Systems in support for the residential marketing functions of the company. These systems access the Customer Database that stores centralized information on the account, service activity, calling plans, service orders, wireless accounts, and promotions offered. These systems provide file feed information to and from various users via file transfer protocols with MVS and other platforms including UNIX. The presence of an input file normally triggers the processing in the interface systems. Responsibilities include production problem resolution coding, walkthrough and testing of main and submodules and production implementation which involved preparation of procs, jcls and file transfer jobs. Also, provided training and support to the junior developer who was part of the development team. Environment was IBM 3090 and PC Windows , MVS, COBOL II, IMS DB, VSAM, TSO/ISPF, LIBRARIAN, SYNCSORT, FILE-AID and file transfer utilities such as NDM and AFT.

Confidential

As senior programmer/analyst for Merrill Lynch, was involved in the enhancement of the company's certificate database support systems. The systems process and generate reports based on transactions affecting the certificate databases which include the Anticipated Received File ARF and the Certificate Level Database CLDB . Reference databases used were the Stock Record History and the Security Master for security position information. Responsibilities included the analysis of processing specifications, process documentation, program coding, program revision, system testing and turnover of production proc jcls. Specific areas involved with were on database synchronization and maintenance, security/box reporting, certificate transmittal processing, legal documents and certificate count reports. Environment was IBM 3090, MVS, COBOL II, IMS DB, VSAM, TSO/ISPF and PANVALET.

Confidential

As programmer analyst for Warner Lambert, a major consumer health product company, was primarily responsible for the revision and enhancement of the existing Sales and Goals Estimate system to fit the requirements of a newly-created product division of the company. Also, converted IMS COBOL Sales and Marketing system programs to DB2 COBOL II to make use of the new DB2 tables which existed parallel with the IMS corporate files. Prepared jcls for the system testing and production environment. The technical environment was IBM 30xx, COBOL II/COBOL, DB2, SQL, IMS DB and TSO/ISPF.

Confidential

As programmer/analyst for AT T Consumer Products, was responsible for the implementation of an information service/change request that involved the addition of bar code information in the processing of A/R claims. Modified four on-line programs and their respective screen maps. Coordinated the initial phase of user testing of the bar code inclusion going through the flow of claims processing which included: open claims entry/update, corporate table maintenance, claims authorization, credit memo file creation and printing for eventual microfilming, and the generation of credit memo/microfilm index file. Environment was IBM 3090, COBOL, VSAM, CICS, TSO/ISPF, LIBRARIAN, INTERTEST and FILE-AID.

Confidential

As senior programmer analyst for AT T, participated in the development of the Database Marketing Platform DBMP system. The system is a comprehensive database designed to provide detailed marketing and revenue information on all business customers served by the company and information on other common carrier customers to aid in competitive analysis. Responsibilities included analysis of module specifications, coding and unit testing of COBOL II/DB2 programs, test data preparation including the use of DB2 utilities, and preparation of exec jcls and procs for the system's production implementation. Additional responsibilities during systems testing phase were the identification, preparation and actual execution of test run conditions as quality assurance prior to user acceptance. Environment was IBM 3090, COBOL II, DB2/SQL, MVS, TSO/ISPF, SYNCSORT, XPEDITER, and FILE-AID.

Confidential

As senior programmer analyst for Merrill Lynch, was part of the team that developed the Share Lot Tracking system for the company's Transfer Agency operations. The Share Lot Tracking system monitors and processes information on mutual funds from the time it is credited into the share lot inventory until it is disposed or liquidated. Transactions processed are in the form of share lot credits, debits and movements. Responsibilities included module specification preparation, program and jcl coding, and unit and system testing. Environment was IBM 3090, MVS, COBOL II, DB2/SQL, VSAM, TSO/ISPF and PANVALET.

RCG Information Technology is an IT consulting firm with main office in New York and branches in Philadelphia, Houston, Orlando and Chicago.

Confidential

As programmer/analyst for CONRAIL, a major transportation firm, was part of the team that converted the Work Force Information System WFIS Payroll application from IMS COBOL to DB2 COBOL II. Responsibilities included: test/debug converted programs from the programming factory set up both DB2 and IMS versions of the programs revise and test EASYTRIEVE PLUS/IMS programs into DB2 and conversion of CICS-IMS online link/validation program to CICS-DB2. Environment was IBM 3090, MVS, DB2/SQL, CICS, TSO/ISPF, VSAM, and INTERTEST.

Confidential

Manager

Staff Consultant

Manages and takes charge in international and local consulting engagements which involved information systems planning, systems design and installation, IT operations audit, and computer evaluation and selection.

While at Andersen Consulting,Confidential was involved in the following international projects:

Confidential

As senior consultant, was part of the team that developed the preliminary systems design of the Trade Reconciliation, Accounting and Control System TRACS which is a back office support system for this brokerage firm. TRACS was converted from an existing Micro Focus COBOL Ethernet system to an INSTALL/1-DB2-CICS in IBM 4381 and 3090 environment. Was then designated leader of the Data Base team who was primarily responsible for: the overall design of the data base for the entire application system data analysis BTRIEVE field to DB2 column mapping which was needed for file conversion and the creation of important DB2 objects thru INSTALL/1.

Confidential

As senior consultant/programmer, was involved in the development of the Company Housing System for Kawasaki Steel Corporation and its subsidiaries. The system tracks grants of housing benefits to Kawasaki employees. Primary responsibility was programming and unit testing of programs in VS COBOL IMS DB/DC from Japanese specifications in an IBM 3090 MVS environment using ISPF/TSO and Batch Terminal Simulator BTS .

Confidential

As senior consultant/analyst, was staff-in-charge in the development of the Finance Desk Trade Support System aimed to support the Tokyo-based bond trading operations of SBAL. The preliminary system design, which was initially done in Tokyo, was finalized in Manila thru coordination with the user in Tokyo. This back-office system was developed in a Novell Ethernet setup but ran in an ORACLE/SQL 80386 stand-alone microcomputer environment. Responsibilities included: systems design program walkthrough supervision/support of SQLForms, Realia COBOL, and user exit programmers code review system testing and project administration.

While at Andersen Consulting then SGV Consulting for the period 1985- 1991, Mr. Machacon was also involved in several Philippine local projects on information planning, EDP operations review, system development, programming, and maintenance, and computer evaluation and selection under industries that include financial, government, insurance, etc. His role on these projects ranged from systems developer to supervisor, and to manager.

V. Prior Experiences Details of some work experiences prior to above will be provided upon

request.