Oracle System
Resume:
David Johns
Gaithersburg MD 20879
Home: 301-***-****
**********@*******.***
Summary:
Ten years experience in leadership and senior technical positions for
system design and development. Manager and technical lead for the Startec
Oracle billing development team. For the last nine years, professional
efforts have been focused on software engineering and development using
Oracle PL/SQL, creating and maintaining Oracle forms, and maintaining web-
based systems developed using PL/SQL and Oracle HTTP. The most recent
experience is with Oracle 9i and 10g using PL/SQL, triggers, stored
procedures and packages, database designer, C and Pro-C, using Explain Plan
and TkProf to improve performance.
Clearance: SECRET
Education: BS Mathematics from Clarion University
Technical Skills:
Databases: Oracle 10g and earlier versions, Access, Visual FoxPro, MySQL
Software and Tools: Enterprise Architect, Erwin, Rational Rose, Rational
ClearCase, Rational ClearQuest, RSA, Oracle Forms (6i, 10), Oracle Reports
(6i, 10), TOAD, SQL-Loader, PVCS Version Manager, PVCS Tracker,
Operating systems: Windows XP and earlier versions, AIX, UNIX
Languages: JAVA, JDBC, JSP, JSF, JDeveloper, C, C++, UML, XML, HTML, Visual
Basic
Present position: EES (December 2009 - May 2010)
Oracle Developer
Designed Oracle reports and forms (10g) for moving the Department of Energy
(DOE) Funds Distribution System (FDS) from a COBOL-based system to Oracle
Forms and Reports system. Used Oracle Analytic functions to gather and
group data.
CSC (October 2005 - July 2009)
Senior Application Engineer
Worked on a Java Server Faces (JSF) library to provide a base platform for
moving DCAPES (Deliberate and Crisis Action Planning & Execution Segments)
to a Java-based system. Maintained the DCAPES application for the Air
Force using Oracle relational database tools. Administered an Oracle
database to support DCAPES system for the United States Air Force.
Analyzed incoming database problems reported from production sites and
support production DBAs in resolving application and database issues.
Instantiated Oracle SQL package tuning and coding. Provided support to the
DCAPES' help desk. Performed unit and regression testing for software
releases.
FCBS/CHM May 2003 -September 2005
Oracle Developer
Analysed, created the basic design, and developed the Financial Accounting
Reporting System (FARS). Improved accuracy and efficiency of systems
software and performed upgrades to the Payment Management System (PMS) in
support of the Department of Program Management (DPM) of the U.S.
Department of Health and Human Services (HHS). PMS is a web-based Oracle
system using PL/SQL and Oracle's HTTP package for HTML page design.
Z-Tech Corporation ( May 2001 - May 2003),
Software Specialist V
Led group effort to create use cases for Grant Closeout Module (GCM)
development. Responsible for updating stored procedures and Oracle forms
to reflect new business rules and updating CASE (ERWin) with database
changes. Maintained the Payment Management System (PMS) and developed
upgrades for the Program Support Center (PSC) of the U.S. Department of
Health and Human Services. Maintained the Grants Management (GM) and
Quick View (QV) programs in support of IMPAC II (Information for
Management, Planning, Analysis, and Coordination) project.
STARTEC Global Communications (1998 - 2001)
Technical Lead and Senior Programmer Analyst
Led and managed the design and documentation of the Billing and Conversion
System (BACS II), which was capable of processing
4 million records in an hour. BACS II was developed in C and Pro*C using
Oracle packages, triggers, and stored procedures on a Unix (AIX) platform.
BACS II replaced BACS in order to be able to handle the larger amount of
data that needed to be processed.
As technical lead, managed the upgrades and fixes for the Billing and
Conversion System (BACS). BACS was processing data for up to 5 million
calls/day using an Oracle 8 trigger-based system running on a UNIX box (AIX
4). BACS used stored procedures, Visual Basic and Excel for report
production
Primary analyst and programmer responsible for the Data Conversion system
(DCS). This system took files, downloaded from the switches, and extracted
customer and carrier data that was entered into the database for use by the
Billing System. The DCS made use of Unix scripts and various classes to
send email pages to our production support staff if switch files were late
or damaged.
R.O.W. Sciences, Inc. (1996 - 1998)
Senior Programmer Analyst
Lead programmer and analyst for the National Human Genome Research
Institute's (NHGRI) FUSION (Finland-United States Investigation of Non-
Insulin-Dependent Diabetes Mellitus Genetics) project. Worked directly
with the clients on site, providing analysis for a variety of systems in
order to accomplish quick adjustments to systems and to meet at their
convenience to discuss further enhancements to existing systems.
Established systems documentation standards. The FUSION system analyses
and groups genotype data used to generate reports for further scientific
analysis.
Built a query-by-example application that created SQL queries on the fly,
based on data dictionary information. This application pulled data from
the NHGRI Grants Management System (GMS) using OLE to work with Excel
spreadsheets and providing e-mail capabilities for use by IMPAC II which is
the main grants management system for NIH. Created ad-hoc SQL reports as
well as many standard SQL-based reports.
Responsible for system design, documentation and implementation of the
Radiation Research help-line for the Department of Energy (DOE). Designed
the base classes for surveys, using object-oriented techniques, that
satisfied the client's requirement for pollsters' being able to step
through the survey questions from a script on their screen and ensuring
that required fields contain entries. The information collected by this
online information collection system was sorted weekly using a set of SQL
commands and was then uploaded to the appropriate agency. Met regularly
with the DOE staff to analyze the data collection techniques being used.
Lead design analyst and programmer for the Women and Children (W&C) Child
and Collateral baseline surveys for SAMHSA (Substance Abuse and Mental
Health Services Administration.)
Mortgage Dynamics, Inc. (1995 - 1996)
Programmer Analyst
Maintained software and system documentation for Mortgage Dynamic's
marketing and analysis system.
CTS Associates
Programmer
Redesigned the entire brick tracking system process, reducing the average
computer processing time from 90 minutes to less than 25 minutes per shift.
Initiated design of a point of sale application.
Contact this candidate