Charles F. Brooks 301-***-**** abobwq@r.postjobfree.com
TECHNICAL PROFICIENCIES:
Platforms: IBM Z/OS, 390/ MVS/ESA, Windows NT
Languages: CICS, COBOL II, SQL, PL SQL, DATACOM, ORACLE 9I, JAVASCRIPT,
ADABAS, NATURAL, DB2
Tools: VSAM, JCL, TSO/ISPF, ORACLE BI, PEOPLESOFT, XPEDITOR, FTP, ETL,
ENDEVOR, IDCAMS, FILE-AID, PANVALET, ABEND-AID, MS PROJECT,
ACCESS, WEB DB, POWER POINT, WORD, VISIO, EXCEL, AGILE\SCRUM
EDUCATION:
UNIVERSITY OF MARYLAND: Business Administration
PROFESSIONAL CERTIFICATONS:
• CompTIA Security+ CE Certification
• DOD Mainframe Environment Certification
EXPERIENCE:
ASM Research Inc. December 9, 2008 – January 2013
Senior Software Engineer
Senior Software Engineer for the Sustainment Engineering of the US Army Enlisted Distribution
Assignment System (EDAS) under the Human Resource Command Officer, Enlisted, Reserves
Management System (OERMS). The main area of concentration has been in an IBM mainframe
environment (Z/OS) utilizing CICS, COBOL II, DATACOM, JCL, ENDEVOR, SQL and CA7.
• Develop new online and batch Application Programming Interfaces (API) to support
EDAS.
• Modify and maintain existing online and batch programs and enhance the data provided
to EDAS.
• Evaluation of Engineering Change Proposals and Problem Reports and review logical
database design. Involved with data analysis for current systems as well as Database
Testing, data conversion, system/sub-system coding.
• Utilize Capability Maturity Model Integration (CMMI) for Enlisted Personnel
Management Division (EPMD).
• Migrated Army Voter Assistance Program (VAP) from Lotus Notes to Java HTML
utilizing Eclipse IDE, JAVASCRIPT, Oracle DB and Oracle BI.
Page 1 of 5
D.C. Human Resources July 2000 – September 2008
Computer Specialist, PeopleSoft, Oracle/Discoverer Administrator
PeopleSoft
• Conversion Team Member for conversion of HR Legacy Data to PeopleSoft – Performed
analysis of data requirements; PeopleSoft Compensation Table maintenance; Extracted
data using SQL queries; Provided PeopleSoft Reports to requesting agencies; Identified
and reported PeopleSoft results, issues, and software defects; Performed management
functions in absence of Project Manager
Project Management
• Developed HR Data Remediation system for data validation, conversion, and
mainframe systems interface with DC Payroll/Personnel systems. Data collected for
12,000 DC government employees
• OPUS-32 - web based Records Management system that allowed tracking of official
personnel folders (OPF); Monitored and reviewed application development;
installed scanning and tracking devices; monitored contracts; and conducted user
training
• Oracle web application District Personnel Manual (DPM) - Monitored system
development, data communications, user support, maintenance and monitored
contract
Oracle
• Alternate Oracle DBA 9i - Updated Oracle database systems using tables,
subroutines, modules and communication links; validated data to maximize
efficiency; and produced desired online production results; Processed and updated
SQL scripts; Performed Back-up procedures; Reviewed vendor invoices/payments for
Oracle Services/Application Software Support; Made recommendations to
management for Oracle System updates
• Oracle Discoverer Administrator - Updated/Maintained End User Layers (EUL);
Granted user and agency table/data access privileges; Maintained Oracle Discoverer
data dictionary to ensure data integrity and security; Provided technical assistance
and training to approximately 160 DC government employee end-users for reporting
of Employee, Benefits, Position, and Payroll data from Discoverer Database; and
Created statistical reports for Executive Branch (Mayor, City Council, FOIA, Dept.
Heads), DC Agencies, and Inter/Intra-agency requestors
SDLC
•
Wrote System Development Life Cycle (SDLC) Manual used as a model for
hardware/software projects; methodologies, documentation requirements, change
management procedures, acceptance testing criteria, projects, activities, reviews,
approvals and resources from initiation through disposition
Mainframe
• Liaison between the Office of the Chief Financial Officer (CFO) and DC Dept. of
Human Resources in the area of technical support
Page 2 of 5
• Performed duties such as software analysis; design program coding; functional,
parallel, system, integration and interface software testing; documentation;
implementation; and maintenance
• Analyzed all project documentation, Requirements Document, and Analysis and
Design documents
• Exported reformatted data elements from DC Personnel/Payroll (UPPS/CAPPS)
systems
• Imported data to ORACLE database and to various HR and Payroll support systems
of the District of Columbia’s Human Resources
• Utilized system analysis concepts and techniques; structured analysis principles;
customer business processes and operations; life cycle management; cost benefit
analysis and internet technologies
• Created compensation, personnel, payroll/disbursements, and time and labor
distribution statistical reports as requested
• Processed files and updated DC Personnel/Payroll (UPPS/CAPPS) with Benefit pre-
tax payroll data, such as Flex Spending Accounts, Optical, Dental, Short/Long Term
Disability, and Health Benefits
• Designed Cross-Match System, which detected overpayment in benefit claims
• Coordinated project-planning meetings with business analysts and development staff
to plan and schedule the installation of new and modified hardware; operating
systems and applications software
• Evaluated off-the-shelf software packages specifying, which was applicable for a
particular project and recommended appropriate procurement actions
• Verified Program Module coding (modifications, enhancements) to ensure program
specifications and project requirements were met and system functionality un-
compromised
• Utilized IBM 3090 MVS, ABEND-AID, COBOL II, JCL, TSO/ISPF, EXCEL,
ACCESS, MS PROJECT, POWERPOINT, ORACLE, DB2, PEOPLESOFT
Impact Innovations February 2000 – June 2000
Consultant – Sr. Systems Analyst
• Y2K Remediation Project of the Patient Billing and Collection, Personnel and Payroll
Information Systems for Washington Hospital Center
• Performed detailed system analysis and program coding changes, which focused on
century date change conversions, cross year/century reporting and accounting
• Created test files needed for file expansion and reorganization due to Y2K compliance
requirement; Developed, executed and validated System tests; Documented all results and
tracked defects
• Ensured completion of assigned projects were on time and met established requirements
• Utilized IBM 3090 MVS, COBOL II, TSO/ISPF, EXPEDITOR, JCL, Shared Medical
Systems (SMS), LIBRARIAN, SIGNATURE, ADABAS, NATURAL
Page 3 of 5
Unisys March 1999 - November 1999
Consultant - Y2K Specialist
• Performed detailed analysis for Food and Drug Administration (FDA) to assess the Y2K
Readiness for pharmaceutical, biologic, and medical consumables industries
• Evaluated Y2K readiness involving extensive travel to selected vendors for on-site
Interviews, which consisted of review of project management; quality assurance; inventory
Collection processes; assessment; remediation; Y2K application testing; integration testing; and
contingency plans
• Prepared and presented briefings and presentations; Wrote evaluation and
recommendation made to FDA on vendor Y2K Readiness; Utilized MS Project, MS
Word, PowerPoint
Software AG September 1998 - December 1998
Consultant –Sr. Systems Analyst
• Y2K Remediation Project of the Retirement and Insurance Systems at the Human
Resources Management (OPM):
• Performed detailed system analysis and COBOL II/CICS coding changes focused on
century date change conversion requirements for screens, reports, Internal/external systems and
date configurations
• Developed and executed system tests, documented all results and defects; Utilized IBM
9000/ESA, COBOL II, CICS, TSO/ISPF, EXPEDITOR, JCL, PLAYBACK, RESOLVE
Cable & Wireless March 1998 - July 1998
Consultant – Sr. Systems Analyst
• Performed on-call technical support for all production problems affecting accounts
payable and general ledger for major financial systems such as McCormick & Dodge, Dunn &
Bradstreet and Millennium
• Worked closely with customers to determine their requirements and developed
applications following the prescribed software development procedures and policies;
Installed software, tested new enhancements, and maintained the BILL PRO System
• Wrote error analysis programs for Post-mortem evaluation, which will alert accounting
of potential vendor late charge payments; Utilized IBM 9000, COBOL II, COBOL, CICS,
VSAM, JCL, MVS/ESA, PANVALET, TSO/ISPF, IDCAMS, RAD, EXCEL, FILE-AID
Dept. of Human Services October 1984 – September 1997
Computer Specialist
• Project Leader: Performed software analysis, gathered business requirements, system
specifications, system design, coding, wrote documentation and developed project plans required
to support systems in the District of Columbia’s Health and Welfare Programs: Aid to Families
with Dependent Children (AFDC), Social Services, Medicaid and Medicare, Rental Vendor
Payroll, Emergency Assistance, Public Assistance, Food Stamps, Foster Care, Adult Protective
Services Systems (APSS), Revised Birth Entry System (RBES) and Day Care; Extracted data
from DOES, SHARE, and DHS computer systems
• Identified issues, resolved critical problems concerning client payments; Reviewed and
analyzed general and detail block diagrams, which provided the basis for logic flow
Page 4 of 5
• Recommended needed redesign studies and carried out study projects; Investigated the
feasibility of alternative design solutions
• Interfaced with users to determine system requirements and needs; Designed and
monitored the execution of testing and implementation plans; Developed extensive test
data necessary for the adequate testing and certification of the program for operational
use
• Converted all batch and on-line welfare systems to the relational database system
ADABAS/NATURAL
• Managed Contractor personnel; Assigned programming tasks and supervised three team
members assigned and reviewed work; approved/disapproved leave requests; provided
training; and evaluated and reported on accomplishments
• Prepared and conducted presentations; Monitored work progress, as required and reviewed
completed work; Utilized IBM 9000, COBOL II, EASYTRIEVE, ADABAS, NATURAL,
CICS, VSAM, JCL, MVS/ESA, PANAVALET, TSO/ISPF, IDCAMS, RAD, FILE-AID
Page 5 of 5