SUMMARY OF QUALIFICATIONS

• Experience on mainframe application platforms for government and education institutions.
• Experience as a software consultant for major software company (CGI-AMS).
• Experience with system design, project management, application conversion, upgrade techniques, technical writing, unit/system testing plans, interfacing, and financial accounting,
• Expert as a COBOL application developer.
• Experience in management and application development.
• Excellent communication, presentation, analytical and problem solving skills.
• Incorporate system lifecycle methodology on all projects and tasks.
• Skilled in mentoring junior programmers, producing technical and user training documentation, leading development teams and establishing strong relationships with end-users and vendors.

TECHNICAL SKILLS

Software/Tools:

COBOL, JCL, TSO/ISPF, SQL, EZTRIEVE, FileAid, Expeditor, IDCAMS, SyncSort, CA-Scheduler

Databases:

VSAM, ADABAS, DB2, Digital ISAM, Honeywell DMIV-TP

Platform:

IBM OS/390, AS/400, VAX Digital VMS, Honeywell GCOS, DYL280, Windows

EXPERIENCE

Technical Responsibility on IBM OS/390

Administration with Concentration in Computer Information Systems

New Mexico Human Services Department (HSD)

• Responsibility for supporting HSD Government Financial System (GFS). This included, ongoing upgrades, enhancements, design/development/implementation of subsystems, resolving data issues, data extraction and reporting, nightly on-call support, interface development for third party applications, and work with managers/administrators on daily technical problems for HSD.
• Management and development roles for upgrades to GFS. Requiring retro-fitting of custom modifications to baseline application, unit/system testing scripts, and problem resolution and coordination steps. Upgrade and enhancements completed on-time and within budget.
• Responsibility of identifying conversion dependencies and writing conversion programs on other application upgrades. The conversion of data involved not only creating COBOL programs to convert the application tables and baseline ledgers with custom ledgers but identifying space requirements for ledgers and analyzing dependencies of tables for sequence loads. Additional orchestration of conversion dependencies of application software included defining of files (VSAM, GDG, and datasets), creating libraries (source, object, JCL, proclibs, copylibs, linkdata), changing pointers in baseline JCL, initialization of files, running of COBOL conversion programs, online screen generation, loads, creation of backups/restores jobs, loads, and setting accounting parameters in online application.
• Designed, developed (printed laser form, mapping of data, JCL, process to search location on report files for destination printing, archiving of reports, and rerun jobs), and implemented laser form process to print purchase documents from GFS to network printers of 100+ government field offices across New Mexico. New process eliminated the need to print, burst, collate, and send required documents from data processing department to field offices reducing operation costs for data processing. Procedures and enhancement completed on-time and within budget.
• Designed and developed process to eliminate manual calculation for federal reimbursements based on HSD financial assistance programs. Expenditures within federal aid groups are validated against online tables defining eligibility and state and federal percentages used to calculate payments reimbursable to state. Human error and federal penalties from late submission hindered the manual process. The process eliminated errors, federal penalties, and manual calculation. Procedures and enhancement completed on-time and within budget.
• Responsible for interface problems into GFS from Child Support Enforcement System (CHEERS Accenture), Food Stamp System, Warrant Redemption System (ISD2-IBM) , Medicaid Interface (Omincaid-ACS), Payroll Interface (HPA-Payroll), LIHEAP (ISD2-IBM), and FEMA interface.
• Interfaced Child Support Enforcement System into GFS by creating journal vouchers to update application. This process was initially manually entered into GFS and was hampered by erroneous data entry and time constraints. Error checking on interface file eliminated data problems. Procedures and enhancement completed on-time and within budget.
• Provided problem resolutions with Joint Accounting System and training of state employees on the technical aspects of CORE software. Daily interaction with bureau chiefs and administrator on requests and problem resolutions. On-going nightly-cycle support (after hour standby support of processes at night).
• Designed and implemented new process to facilitate printing of accounting reports from online financial application for managers and administrators.
• Tested and executed monthly cycle process. Running of preliminary reports, executing monthly cycle jobs (backups, closing jobs, fixed asset depreciation jobs, and final reports), verifying balances by reconciling online application and with general ledgers balances, and running system assurance jobs to verify data inconsistencies.
• Test and execute annual close process. Restoring test region with production backups. Run preliminary reports to verify balance sheet account totals, detail transaction and summary reports from offline ledgers. Execution of annual close process in test region creating beginning balances for balance sheet totals, rolls-over remaining encumbrance balances to new year, updates supporting online accounting tables for new year, and establishes appropriations and budgets for new year. Verify annual close process and sign-off from client. Execute annual close process in production with client sign-off in production.

State of New Mexico Department of Transportation (DOT)

• Sole responsibility for supporting DOT Government Financial System GFS (FMIS).
• Management and development role in upgrading GFS. Requiring retro-fitting of custom modifications into baseline application, unit/system testing, and implementing new upgrade from CGI-AMS. Upgrade and enhancements completed on-time and within budget.
• COBOL modifications to already heavily modified Federal Project Billing Subsystem were applied. Verification warnings were created for the Federal Highway Administration requiring verification of the project, sub-project to the route/section, and federal sequence number. Other COBOL modification required adjustments to federal and state billing to correct inconsistencies in the Project Billing Sub System. This required a new table and batch program to correct billing files.
• New COBOL enhancements along with technical/user documentation were created for a new process to transfer expenses and revenue between funds using a new online application table. The COBOL batch process would then generate ‘JV’ documents loaded in to the document suspense file (SUSF) using a load utility to execute the transfer.
• Modification to create interfaces to Highway Maintenance Management System. This required modifying tables in FMIS to identify maintenance organization and reading fixed asset tables to generate an asset file to be interfaced with the Maintenance Management System.
• Problems with COBOL inventory system posting the ‘SN’ document transaction at the average cost from the INVN table instead of amount originally expended. Problems were resolved for ‘FD’ fixed asset disposition document where user could not delete lines on document along with problems with screen. Other minor problems such as deleting document from SUSF with invalid transaction code required writing a program to delete the document.
• A new COBOL process was developed and documented for Traffic and Safety Bureau. This process was designed to provide the Traffic Safety Bureau Grant program managers four reports of financial grant information by program, grant and detail expenditures. The process read all of the federal aid tables, grant ledger, and general ledger to produce a series of reports with grant information, encumbrance, expenditures, budget balance, unexpended balance, unexpended budget percentages, and totaling at government wide number, federal aid number, organization total, and object total by government wide number. A modification design along with user and technical documentation for the Traffic and Safety Grant Reporting is located in the “Highway and Transportation Department Modification” segment of the “Other Supporting Material” Section of this proposal.
• Highway and Transportation Department Equipment Section required help to resolve problem with EMS-PC equipment system. The EMS-PC system was developed by a software vendor to maintain data for state vehicles on a network of PCs. Because of upgrades to the EMS-PC system problems resulted requiring manual intervention of equipment department staff. Communication problems also existed between the FMIS staff and the equipment section staff. My task was to analyzed and resolved this problem by creating a process to synchronize the equipment and vendor files of the EMS-PC application to the FMIS system. The COBOL process I developed extracted records from the FMIS system and EMS-PC system and create the required update records. This required a onetime process to add, delete, and change records to the EMS-PC system. Another COBOL process for daily execution edited input files for duplicates in the FMIS system. The design and execution of the system was completed within the deadline.
• Experience involved large scale COBOL application upgrades, modification, data conversion processes, interfacing of different software platforms, writing/implementing unit/system test scripts, technical documentation, status reports, post implementation support, and on-call support of nightly cycle JCL jobs.

• Implemented and integrated the Fixed Asset Subsystem of GFS. Procedures and enhancement was completed on-time and within budget.
• COBOL modifications to the Advance Receivable Subsystem of GFS were applied to customize the system to fit the needs of the client. Procedures and enhancement was completed on-time and within budget.

Business Responsibility

• Business duties included responding to RFP, documentation for response to proposal, contract negotiations, determining scope of work, estimates, and administrative duties.
• Functional experience concerned consulting and advising, system design, project management, creation of unit and system test scripts, analyzing modification requests for new or existing processes, and documentation.

Technical Responsibility

• Los Angeles Unified School District (LAUSD) in January 1994 earthquake. Required immediately earthquake recovery program to restore the building structures within the school district. Because of the earthquake, 65 million dollars in expenses were incurred and entered into the financial application without project numbers. FEMA, the national relief agency was not able to reimburse the district for expenses until all expenditures were removed and reestablished into GFS financial application with project numbers. Task was to write COBOL/JCL process to reestablish expenses with project numbers. This project required 3 month completion, however these tasks were completed in a shorter timeframe and budget.
• New Mexico Human Services Department (HSD) initial duties were to analyze posting problems with general ledger and fixed asset ledgers and complete COBOL modifications to the Advance Receivable System. This included statement and invoice modification to fit HSD requirements, miscellaneous COBOL report modifications, and reclassification of cash collected against contractor advances. Continued with on-going daily support for the Government Financial System GFS. Responsibilities were to complete all COBOL/JCL application enhancements, develop system testing procedures, and coordinate with the State on migration procedures. Provide problem resolutions with Joint Accounting systems and daily support. Responsibility included training state employees on the technical aspects of CORE (software residing between application and database).

Education
Bachelor of Business Administration