Email:

accq6g@r.postjobfree.com ( Phone 240-***-****

KENNETH BANNERMAN

Summary:

Experience in the data processing environment for over 22 years. Have

written and maintained small to large scale Oracle base RDBMS application

systems using Oracle Forms, Reports, SQL*Plus, SQL*Loader, PL*SQL and

COBOL. Perform System Analyst work with full life cycle methodologies.

Work with Operation Systems such as MS-DOS, Window 3.1, Window 95, Window

98, Window NT, Window XP, Window 7, MVS and UNIX. Written and maintained

technical documentation to support the applications using products such as

Microsoft Word and Microsoft Excel.

Education and Training:

BA, Computer Information System Science, University of the District of

Columbia Washington, DC 1991

Associates, Information Technology, University of the District of Columbia

Washington, DC 1986

CERTIFICATIONS:

Security Awareness Training

CLEARANCE:

Position of Public Trust (SF-85P)

Skills:

Software - Oracle (7.4, 8.0,8 I), Oracle Developer 2000, (Forms version

2.3, 3.0, 4.0, 4.5, 5.0, 6.0,9i, 10g,11 g), (Reports 3.0, 6.0,10.1.2.0.2),

Oracle (9iAS), Oracle (10G) development suite. 11g), SQL, SQL*LOADER

PL/SQL, PRO*C, Visual Basic, MS Access, MS Project, MS Excel, MS Word, TOAD

9.0,9.6, HTML, WEBDB. WINCVS,

Adobe Acrobat 8.x Standard, MS Internet Explorer 7, Microsoft Office 2007

Professional, MS POWERPOINT, MS OUTLOOK, Adobe Flash Player, Oracle

JInitiator Version 1.3.1.22, Windows XP SP2, WinZip 11.x, Reflections for

Secure IT Version 7.1, SharePoint

Hardware - Sun Solaris 2.5.1, IBM PC/Compatible, IBM/MVS 9021-500, IBM 360-

370 MINIS, VAX/VMS 8650, Data General/AOS/VS MV-7800, DEC System 2060. DELL

PowerEdge 6400, DELL PowerEdge 2550, Sun SPARC Enterprise M5000

Operating Systems- MS-DOS, UNIX, VAX/VMS, AOS, MVS, Microsoft Window XP,

Window 7

Tools - TOAD 9.6.1, Borland Delphi 4 Datapump converter, Oracle SQL

Station, WINCVS, Microsoft Word and Microsoft Excel.

Programming Languages- SQL, PL*SQL, SQL*Loader, COBOL, HTML, UNIX

Experience:

PITSS-America LLC - August 2013 - November 2013

Senior Oracle Developer.

. Worked as a Senior Oracle Consultant analyzing and

editing Oracle Forms with new code changes that the client requested.

. Tested Oracle Forms with new code changes to ensure it met the user

request and expectation.

. Work in the Linux environment to compile code and place into client

directory.

. Updated and maintain client log pertaining to the revised Oracle

Forms.

INDUS Corporation, January 2008 to August 2012

Senior Programmer Analyst (Consultant for the Department of

Transportation).

. Worked as a Senior Oracle Consultant for the Department of

Transportation creating, analyzing and

editing Oracle Forms and Reports with new code and data changes.

. Wrote and updated technical documentation to enhance the understanding

of the software.

. Worked as a WINCVS Administrator doing Configuration Management for

the development team software and documents. Performed light duties

using Business Objects software.

. Worked with TOAD to manipulate database changes functions, packages

and procedures, SQL statements, PL*SQL, writing scripts and other

TOAD functionalities.

. Analyzed application architect design information and wrote technical

documentation. Performed light duties with TFS (Team Foundation

Server). Worked as an IT Business Analyst designing and writing

requirements for the team.

Gapalo Consultants contractor for (Computer Science Corporation), October

2006 - January 2008

Oracle Senior System Analyst (Consultant for the Internal Revenue Service)

. Worked as an Oracle Consultant for the Internal Revenue Service

analyzing Oracle database tables and

remapping data structure to prepare the Oracle tables to accept data

from SQL*LOADER control files.

. Built SQL*LOADER control files using direct path loading and parallel

processing to load the data.

. Wrote PL*SQL code to create procedures to process data into reports.

Duties also included system analyst and design work.

Erimax Corporation, September 2004 - August 2006

Senior System Analyst (Oracle Consultant for the Department of Census)

. Worked as an Oracle consultant for the Department of Census teaching,

building and managing an Oracle base application. The existing

application was written in FORTRAN and DELPHI programming language.

This is part of a tracking system that was used in the 2010 Census.

. Analyzed the existing application with the clients and resolve

existing issues

. Converted and rebuilt the existing application in an Oracle 9iAS/10G

application and 9i/10G database environment. Set up the environment

for the Oracle forms and Reports.

. Designed and architected the existing data files into an Oracle

relational database, which includes using ORACLE SQL*LOADER to load

flat ASCII files into the Oracle tables.

. Designed and built an Oracle Forms10G application for the use of

manipulation of the data through data entry screens and reports.

. Designed a FTP (File Transfer Protocol) process for transferring data

from one application server to another.

. Utilized PL*SQL programming language to write packages, procedures and

functions.

. Utilized Oracle Reports10G to generate reports. The reports were

generated into a PDF format.

. Utilized some light JAVA processing to rebuild part of the

application, which consist of JDeveloper and Java scripting.

October 2003 to September 2004. Leave of absence

Maintained household and took care of sick wife.

CACI International, August 2000 - September 2003

Senior System Analyst (Oracle Consultant for the Department of Justice)

. Managed and supervised a team of developers to design and implement a

Production Pipeline Tracking system for logging and controlling

received boxes from Attorneys and outside clients. The system counted

and verified information contained in the boxes.

. Interfaced with Attorneys to understand their processes and the needs

of their day-to-day operations to develop appropriate specifications

and systems.

. Attended upper management meeting to convey the progress of the teams

and the operations of the document centers.

. Managed and built a tracking system developed in Oracle Developer 2000

that searches across several databases to produce information about

different documents required by the Attorneys.

. Worked with the Data Control Conversion team to process scripts using

Perl 5 to load data into various databases.

. Managed the help desk, which consisted of hardware and software

technicians to maintain a day-to-day operation at the document center.

. Maintained a budget to access the needs for equipment and supplies for

the document center help desk.

. Wrote PL*SQL code to write large packages and procedures.

Independent Consultant: October 1994 - August 2000

Supported a variety of companies including HCIA, Department of Commerce,

Bell Atlantic, American Chemical Society, United Way and FAA:

. Worked as a Senior System Analyst assigned to analyze, debug and

create PL/SQL code in a data warehouse environment.

. Transferred data from flat files into Oracle tables through SQL*Loader

software. Part of a team to ensure that the data was channeled

correctly through several processes so the end user could correctly

utilize the data that is stored in the Oracle table.

. Worked as a Senior Programmer Analyst assigned to create Oracle Tables

and use PL*SQL coding to write large packages and procedures.

. Utilized ULT_FILE to load data into the Oracle Table. Tasked to build

Oracle forms using Developer 2000 and WEBDB.

. Worked as a Senior Programmer Analyst assigned to assist in building

an on line Oracle web based system that will show vacancies

announcement and other related employment information on an

application server.

. Built a security system using PL*SQL and HTML code to secure the URL

from outside entry into the web pages. This task included setting up

intervals on modules to update the database at certain times.

. Set up a system that could generate and access email on the web page

from UNIX. This was an Internet based system that would be used

throughout Department of Commerce and other government agencies.

. Worked as a Senior Programmer Analyst assigned to convert an Informix

base system into an Oracle

RDBMS system.

. Redesigned and implemented Informix text screens into Oracle Forms

version 6.0 screens and Informix reports into Oracle Reports 3.0 to be

Y2K compliance.

. Duplicated the exact legacy Unlawful Call Center system into an Oracle

based system using UNIX as the operating system. Worked with UNIX

shell scripting to process data. This is a real time system that

tracks day -to -day phone calls and operation for Bell Atlantic

customer.

. Worked as a Senior Programmer Analyst assigned to help convert a

Paradox base system to an Oracle RDBMS system.

. Converted data from a Paradox database to an Oracle database using

Borland Delphi 4 Datapump converter and Oracle SQL Station.

. Upon conversion and copied into an Oracle temp table, cleaned the

Oracle data to meet the Pfizer system standards.

. Built and maintained Oracle Reports 3.0.5.8.0 and Oracle Forms

5.0.6.8.0-using Developer 2000 R2.1. This is a real time system that

tracks day to day phone calls and operations for Pfizer clients.

. Worked as a Senior Programmer Analyst as part of the National Pledge

and Information Processing System team, which was to capture all the

designated funds donated to the United Way of America.

. Utilized Oracle Designer 2000, Developer 2000, Forms 4.5, Report 2.5

and other Oracle CDE tools. Duties were to design, build and generate

forms and reports using Designer 2000.

. Worked as a Senior Programmer Analyst a as part of the Integrated

Mission System (IMS) team, which consolidated the agency mission-

related information with other desktop operations such as word

processing, spreadsheets, and on-line reference. Was the lead Oracle

Developer 2000 Programmer/ Analyst.

. Provided hands on support to the team converting a PowerBuilder system

to an Oracle Developer 2000 web based system using Oracle Forms 4.5

and PL*SQL 2.3 in a Windows NT environment.

. Consulted and trained PowerBuilder programmers on the use of Oracle

Developer 2000 tools while designing and developing additional modules

of the new Oracle system.

. Designed and reviewed program specification manuals.

. Worked as a Senior Programmer Analyst as part of the ATA (Air Traffic

Automation) 200 FMM (Floor Monitor Manager) Archive team responsible

for building Oracle software using Oracle PL/SQL programming language.

. Built PL*SQL data tables within the software so it will not use the

Oracle tables once implemented.

. Developed a code generator software that essentially built SQL,

PL/SQL, and Oracle SQL*Loader control files. The generated SQL and

PL/SQL scripts were used to extract data from a large (terabyte)

databases and created comma-delimited ASCII files as output. The

generated SQL*Loader control files are used to control loading the

data into a users database. Parameters were passed to these files to

indicate table names.

. Worked with Oracle 7.33 and PL*SQL 2.3. A Sun Solaris 2.5.1 server

using UNIX was the hardware medium for processing this work.

DynCorp (U.S. Department of Energy), November 1992 - October 1994

Programmer Analyst

. Worked as a Programmer Analyst assigned as part of a team for

developing a property accounting and management system for the

Logistics Management Division (LMD) of DOE headquarters.

Responsibilities were to develop modules using Oracle 4GL v. 6.0,

SQL*FORMS 3.0, SQL*PLUS, PL*SQL, PRO*COBOL, and COBOL, and to write

program specifications for the PAMSII system.

. Helped designed a barcode reader/scanner interface to allow LMD to

take physical inventories using PC-IRL. Participated in the barcode

study including requirements analysis, hardware/software

specifications, design, development, testing, and implementation of

the interfacing system, and training of the users.

Washington Consultant Group (U. S. Food and Drug Administration), August

1991 - October 1992

Programmer Analyst

. Worked as a Programmer Analyst on contract with the Food and Drug

Administration (FDA), Public Health Service, U.S. Department of Health

and Human Services.

. Provided Oracle 4GL v 6.0, SQL*Forms 3.0, SQL*Plus, PL*SQL, and Oracle

programming support to the FDA Import Support and information System

(ISIS) Project.

. Designed and developed additional modules in 'C' and VAX command

languages. Maintained Oracle system modules.

American System Engineer Inc (U.S. Navy), August 1988 - July 1991

Programmer Analyst

. Worked as a Programmer Analyst to the U.S. Navy NAVSEA contract.

Performed software design, systems analysis, software development,

unit and system testing, system documentation, software quality

assurance, software maintenance, user interface, and hardware

management.

. Software development was performed using Oracle 4GL v 5.0, SQL*Plus,

SQL*Forms 2.3, COBOL, 'C', and dBase III/Clipper. Developed DOS batch

applications and implemented project management software based on a

Data General MV-7800 for the Navy.

. Performed management and Oracle DBA functions.

University of the District of Columbia, May 1986 - August 1988

Assistant Instructor

. Worked as an Assistant Instructor responsible for teaching and

tutoring Lotus 1-2-3, dBase III, dBase

III plus, and WordPerfect.

. Coordinated and maintained usage of computer laboratory.

. Developed dBase III and dBase III Plus application, and wrote

financial spreadsheets using Lotus 1-2-3.

AWARDS:

Received monetary, second Quarter 1994 Leadership Award for improving the

management of $99 million worth of inventory maintained by the Department

of Energy.

Received Special Recognition Certificate for outstanding software

engineering services.

Received Special Recognition Certificate for outstanding leadership as PTSA

President.

Contact this candidate