Alan Roger Willis
1369 Michigan Avenue NE Washington, D.C. 20017-3830
[Send email to request phone number] 29-9509-Hm [Send email to request phone number] 57-0809-Cell
alan_r_willis@yahoo.com
PROFILE:
I am an Information Technology professional with 15+ years in areas of project
management, configuration management, software development, Systems Programming,
and database management. I am adept in establishing relationships with technical
and non-technical personnel to ensure optimal learning and support. Salary is
negotiable.
MAJOR PROJECTS & ACCOMPLISHMENTS:
Successfully migrated six Air Force DB2 subsystems and QMF applications to
version 8 from version 7.
Converted System and application Image Copy and Modify jobs to use LISTDEFs
and DB2 Templates.
Created and delivered a document on HUDCAPS disaster recovery and assisted
client in modifying the HUD Business Resumption Plan to include this
information.
Resolved network communication between three office PCs and two server
printers for Canaan Baptist Church office staff.
In response to OIG findings, I created and delivered a document on reducing
security exposures in the project using TOP SECRET IBMGROUPS.
As part of development testing used SAS to extract and manipulate data from
production tables and load it to the test tables
Created several jobs to monitor the performance of DB2 table/index spaces and
DASD space for performance tuning.
As part of the HUDCAPS production cycle analysis, I identified several QMF
queries that were not performing efficiently and recommended to the client that
the queries be redesigned to take advantage of the clustering index.
Converted indexes from TYPE 1 to TYPE 2 in an effort to take advantage of DB2
version 5 index enhancements.
Responsible for Y2K Systems and application testing. The testing included
developing test plans and checklist, installing Y2K testing software, applying
patches, applying maintenance, and coordinating software updates with vendors.
Coordinated the installation of DB2 3.1 and DB2 PM 3.2 at ten IRS Service
Centers and the development site. The installation included coordinating dates
and times with Service Center managers and approving installation scripts.
Coordinated the 2nd annual Database Administrator (DBA) Conference.
Coordination included: cost analysis; creation of an information packet for
section members and field participants; approval of all topics and handouts;
submission of actual cost to budget personnel; and preparation of conference
agenda. Prior to implementation, I reviewed and tested deliverables from
contractors for the conversion of the Automated Collection System (ACS).
Spoke about RACF/DB2 Security at the 3rd annual RACF Conference. The topics
included an introduction to DB2, RACF administrator responsibilities, the
DB2/RACF interface, and ACS/ICS RACF groups.
Appointed Contract Office Technical Representative (COTR) for the redesign and
re-hosting of the Automated Inpatient Data System and the Report of Patient Data
System from Honeywell GCOS-8 flat files to IBM MVS and DB2. Responsible for
signing off on all deliverables, settling disputes between contractors and users,
and coordinating all technical reviews.
Managed the General Systems Branch for five months. I was responsible for the
day-to-day operations of the team. Prepared division level project status
reports, employee evaluations, and attended mid-level management meetings with
users and agency personnel. In this position I reassigned work to fit personnel
resulting in an 85% decrease in backlogged work.
Project Leader over the development of 35 COBOL programs for the Medical
Expense and Performance Reporting System following Air Force and DOD programming
and documentation standards.
Creator and editor of the first Air Force District of Washington Small
Computer Bulletin (AFDWSCB).
TECHNICAL SKILLS:
Software - SQL, COBOL, COBOL II, C Language, PL/I, CSP, SAS, DYL280-II, CLIST,
FORTRAN, SIS, ADA, BASIC, PASCAL, MICRO FOCUS COBOL, Assembly Language,
DYL280-II, REXX, CLIST, CSP, SPSS
Software Tools - QMF, ACF2, TOP SECRET, RACF, DB2PM, File-Aid, DBA-XPERT,
OMEGAMON II for DB2, COOLGEN, Platinum TOOLSET, CANDLE DB2 Tools, BMC Tools,
DB2V7, CICS, SMP/E, DFSMS, ISPF, GTF, TSO, File-Aid, ENDEVOR, ABENDAID/MVS,
Data-AGER, TRANSLATE 2000
Operating/Hardware Systems MVS, OS/390, Honeywell GCOS8, UNIX, UNISYS, Windows
XP, Windows (2000, XP, 98, and 95), IBM compatible PC, TCP/IP, VTAM, and VM
ADP Concepts Software Development Life Cycle (SDLC), Risk Management,
Configuration Management (CM), Project Management, Change Management, Capability
Maturity Model CMM (CMM)
PROFESSIONAL EXPERIENCE:
Drexel Technology Associates Berwyn, Pa.
Sr. Systems Programmer May 2007 to Present
Mr. James Paylor (703) 692-0357
As Senior Systems Programmer on a contract with the U.S. Department of Army Data
Center, Pentagon, I am responsible for maintenance, performance tuning, and
development support to developers and end-users on the Air Force Systems. Also
provide monthly status reports and support for various other DB2 related
software.
Self-employed Washington, DC
Information Technology Consultant Nov. 2004 to Present
[Send email to request phone number] 29-9509
As a Senior Information Technology Specialist, I provide technical support to
clients in the area of server network problem resolution, computer hardware
purchases, PC problem resolution, PC peripheral communication problems, and
various other hardware/software needs.
Advanced Technology Systems Washington, DC
DB2 Applications Database Administrator Nov. 1998 to Nov. 2004
Mrs. Danielle McNamee (301) 270-8737
As Senior DB2 (DB2 V7) Database Administrator on a contract with the U.S.
Department of Housing and Urban Development, Office of Information Technology, I
was responsible for database maintenance, performance tuning, and development
support to developers and end-users on the Housing and Urban Development Cost
Accounting Program System (HUDCAPS) and Personal Services Cost System (PSCS)
projects for production, development, and disaster recovery environments. Also
provided weekly status and monthly status reports to supervisor and client and
performed monthly and quarterly DB2 utility and object maintenance.
U.S. Department of State Washington, DC
DB2 Systems Programmer Sep. 1996 to Nov 1998
Mrs. Elaine Williams (703) 875-4078
As Senior DB2 Systems Programmer for the Foreign Affairs Data Processing Center
at the U.S. Department of State, I was responsible for supporting the Year 2000
compliance testing for hardware and software, DB2 support for all seven LPARS and
the maintenance system, performance tuning, and written technical and
non-technical status reports as needed.
Internal Revenue Service Washington, DC
Computer Specialist May 1991 to Sep. 1996
Miss Jean Crichton (301) 384-3385
As a Computer Specialist, I served as Project Manager for the ACS/ICS Database
Technical Team, responsible for the maintenance, modification, and development of
the DB2 subsystems at the development site and ten production sites. Also I was
responsible for the maintenance of ancillary DB2 products such as QMF and DB2
Performance Monitoring and tuning. Provided weekly technical and non-technical
status reports and acted as Section Chief when required. Also maintain SAS code
and DB2 related utilities.
US Department of Air Force (Pentagon) Arlington, VA.
Computer Programmer (Civilian Employee) Jan 1980 to May 1991
Mr. Leonard Flens (703) 695-0181
As a Computer Programmer Analyst for the 7th Communications Group (January 1980
to May 1987 and May 1988 to May 1991) and 1802nd Communications Squadron (May
1984 to May 1988), I was responsible for programming, database, and project
management support to the Air Force Surgeon Generals office, the 1100 Resource
Management Group, and the Air Force District of Washington. The support also
included the maintenance, modification, development of code written in various
4GLs, purchasing and installing ADP hardware and Software, and and performance
tuning of all applications. Also provided weekly and monthly status reports to
management and the client, responded to Congressional inquiries, and performed
monthly and quarterly DB2 utility and object maintenance.
Education:
Class Location Class Title Course Hours/Type Course Dates
Woodrow Wilson Sr. High School, WDC Academic High School Diploma Sep. 1974 to
Jun. 1977
University of D.C. Computer Information Systems Science Bachelors of Business
Administration Aug. 1977 to Dec. 1983
Strayer University Information Systems Graduate Certificate Apr. 2008 to
Present
Active Secret Clearance as of August 2007
|
