Oracle versions 5 through 12 (Designer, Developer, PL/SQL, and other Oracle tools in use from 1987 through to the present), all phases of application development, including user requirements specification, entity-relationship modeling, database administration, design, storage allocation, user interface issues, development of forms and reports, documentation, programmer and user training, upgrades, configuration management, and application performance tuning.
- M.S., Computing and Information Sciences (1999), St. Mary’s University, San Antonio.
- B.S., Computing and Information Sciences (1985), Trinity University, San Antonio.
- Oracle Database 11g Administrator Certified Professional (OCP)
- Oracle Advanced PL/SQL Developer Certified Professional (OCP)
- Oracle Forms Developer Certified Professional (OCP)
- Oracle Database: SQL Certified Expert
- CompTIA Security+
Oracle Certification Exams Passed:
- 1Z0-007 Introduction to Oracle9i SQL
- 1Z0-047 Oracle Database SQL Expert
- 1Z0-051 Oracle Database 11g: SQL Fundamentals I
- 1Z0-147 Program with PL/SQL
- 1Z0-144 Oracle Database 11g: Program with PL/SQL
- 1Z0-141 Oracle Forms Developer: Build Internet Applications
- 1Z0-146 Oracle 11g Advanced PL/SQL
- 1Z0-052 Oracle Database 11g: Administration I
- 1Z0-053 Oracle Database 11g: Administration II
- Extreme Joined Views Using Pipelined Table Functions. ODTUG Technical Journal, Third Quarter 2008.
- Conditional Logic Using SQL Expressions. Oracle Technical Journal, Fall, 1996.
- Concentration Distribution of the Marijuana Metabolite Delta9-Tetrahydrocannabinol-9-Carboxylic Acid and the Cocaine Metabolite Benzoylecgonine in the Department of Defense Urine Drug-Testing Program. Jemionek JF, Copley CL, Smith ML, Past MR. Journal of Analytical Toxicology. 32(6):408-416, Jul/Aug 2008.
CONSULTANT (1-96 TO PRESENT).
Senior Database Specialist on the Department of Defense Tri-Service Drug Testing Laboratory Information System. As this data may be used in prosecution, all software is held to extraordinary standards of accuracy.
TECHNICAL STAFF, RESEARCH DYNAMICS, INC. (5-94 TO 1-96).
Providing guidance on a day-to-day basis to other software professionals in the efficient and effective application of the functionality available with Oracle. Handling database administration, data modeling, upgrades and software installation.
INDEPENDENT CONSULTANT (4-92 TO 4/94)
Performed contract work, either directly or as a subcontractor, for Oracle Corporation, Computer Sciences Corporation, PRC Inc, US Army (Ft Lee, VA), US Air Force (Randolph and Brooks AFB, San Antonio, TX), Research Dynamics, InterVarsity Christian Fellowship, and Pilgrim Convenience. Activities include:
• Upgraded software from Oracle version 5 to 6.
• Upgraded from SQL*Forms versions 2.0 and 2.3 to version 3.
• Trained programmers on use of SQL*Forms 3.0.
• Remapped terminal keyboard layouts for users and programmers.
• Developed new systems, including table designs, storage allocations, and user interfaces.
• Optimized applications, in some cases reducing run-times from days to minutes.
• Upgraded from customer’s C language menu application to SQL*Menu.
• Upgraded from custom FORTRAN report launchers to a generic SQL*Forms report launcher.
• Reduced size of applications by half, eliminating tens of thousands of lines of code.
CONSULTANT, ANALYSTS INTERNATIONAL CORPORATION (4-91 TO 4-92).
Identified and performed many tasks required to port an Oracle application from SQL*Forms 2.0 on AIX over to SQL*Forms 3 on DEC VAX/VMS. Adapted applications to interface with Oracle Financials. Tuned all aspects of their applications, including data storage, index usage, forms data entry, and reporting. Used SQL*Net to synchronize multiple database tables.
SYSTEMS ANALYST, INTERVARSITY CHRISTIAN FELLOWSHIP (8-87 TO 4-91).
Worked with users to provide technical support and services to meet the needs of personnel within the division. Initiated and developed several new projects, among them combining departmental name and address files into a unified corporate resource, and using outside service bureaus to obtain telephone numbers, ZIP+4 numbers, duplicate identification, and address changes from the National Change of Address system. Rewrote the user manual for a program developed in-house. Redesigned printed data entry forms. Enhanced existing applications. Upgraded applications to take advantage of Oracle version 6. Primary language was Pascal.
SOFTWARE DEVELOPER, EPIC SYSTEMS CORPORATION (12-85 TO 8-87).
Used the MIIS dialect of the MUMPS language to develop new features for Epic’s software product line. Started by making enhancements to their word processing product. Interfaced it to their database management system. Was one of two people chosen to develop a new full screen forms-driven style of data entry (similar to Oracle’s SQL*Forms tools) to replace the old line-oriented data entry mode.
ANALYST, PILGRIM CONVENIENCE, INC. (6-83 TO 11-85).
Analyzed the needs of a laundry and dry cleaning firm with close to forty locations. Hired, trained, and supervised programmers. Selected hardware, language, and word processing software. Implemented specialized data collection and reporting software. Began with a networked environment. Later ported to a multi-user database server using MUMPS. Software remained in production use with little or no maintenance for over 20 years.
ACADEMIC COMPUTING CONSULTANT, TRINITY UNIVERSITY (8-82 TO 5-83).
Provided technical assistance to students and faculty in the use of languages, word processing, and operating systems utilities. Monitored proper use of computing equipment. Worked with a wide variety of languages and other software in both batch and interactive environments.
APPLICATIONS PROGRAMMER, RESOURCE LOGIC, INC. (5-82 TO 7-82).
Wrote accounting software for the Datapoint 6600 and 8800 systems using Datapoint’s Databus language and RMS OS.
PROGRAMMER ANALYST TRAINEE, FOX PHOTO MIS DEPT. (7-81 TO 1-82).
Worked with Data General Nova III minicomputers running the RDOS operating system. Worked midnight to 8 a.m. Was responsible for diagnosing hardware, software, and operation problems for 30 computer systems nationwide.