Oracle Sql
Resume:
David Short
ablq6t@r.postjobfree.com
OBJECTIVE
Contract position designing, developing or supporting Oracle based systems.
PROFESSIONAL EXPERIENCE
Strategic Pharmacy Services, LLC - Corona, CA
August 2009 - Present: Oracle/Tomcat Developer Consultant
. Designed, coding and implemented a web based, Oracle/Java centric
prescription claims analysis and reporting system. The system includes a
custom raw data import and update engine written in SQL*Loader, Java and
PL/SQL, which accommodates multiple data sources (HIPPA92, Calinx 2.x,
NCPDP 5.x). The system cleanses and consolidates data and provides
current and historical analysis and reporting capabilities. The system
utilizes the Oracle 10g database, Apache Tomcat servlet container and
MicroStrategy Reporting suite of tools. Additional tools: TOAD for
Oracle, HTML, JavaScript, Java Server Pages (JSP).
. Migrated Oracle 10g database (data, stored procedures, functions, etc.)
to SQL Server 2005. Migration conducted in support of SQL Server centric
Strategy Companion BI tool. Additional tools: Microsoft SSMA for Oracle,
TOAD for SQL Server.
ClinDatrix, Inc. - Irvine, CA
July 2010 - Present: Oracle Clinical, AERS, Argus DBA/Developer Consultant
. Providing ongoing Oracle Clinical, AERS and Argus clinical application
system DBA support. Assisting with installation and configuration
issues. Platforms: Oracle 9i, 10g, 11g and ODAC.
Cadence Pharmaceuticals, Inc. - San Diego, CA
August 2010 - August 2010 - Oracle DBA Consultant
. Recovered to production status Oracle 10g database.
LS Technologies - San Diego, CA
July 2008 - February 2010: Oracle Clinical, AERS and TMS DBA/Developer
Consultant
. Installed and configured Oracle Clinical and Remote Data Capture 4.5.1
on hosted Windows 2003 server environment.
. Installed and configured Oracle 10g (10.2.0.3) on Red Hat Linux v4 x86
_64.
. Providing DBA support and custom PL/SQL and C development, reporting and
data extraction expertise.
Edwards Lifesciences, LLC - Irvine, CA
November 2009 - February 2010: Oracle Database Developer Consultant
. Created an automated, database level, email interface for Oracle
Clinical, written in PL/SQL. Package components are called from OC
derivation procedures and send email messages reporting clinical study
trigger events to a dynamically specified user list. The package also
tracks generated email activity and reports any send errors to a dynamic
list of administrative users. Additional tools: TOAD.
DataCeutics, Inc. - Pottstown, PA
May 2009 - July 2009 - Oracle Clinical DBA/Developer Consultant
. Review/Proof/Enhance Oracle Clinical/TMS 4.5.2 Validation Installation
Qualification documentation. Perform validated installation of Oracle
Clinical/TMS 4.5.2 on remote Italian based servers.
Valeant Pharmaceuticals International - Irvine, CA
October 2008 - May 2009: Oracle AERS DBA/Developer Consultant
. Upgraded AERS 4.5.1 system directly to 4.6.1. Process involved a
hardware stack change and data export/import, as well as application of
configuration deltas and data conversion steps. One of two such AERS
migrations performed during this time frame. Additional tools: TOAD.
Synteract, Incorporated - Carlsbad, CA
June 2008 - July 2008: Oracle AERS Consultant
. Provided miscellaneous software design and development using Oracle
database tools (PL/SQL, packages, procedures, functions, SQL, PL/SQL
Server Pages PSP, Pro*C, etc.) and TOAD.
Port of San Diego - San Diego, CA
May 2008 - June 2008: Oracle/OpenLayers Consultant
. Provided custom development and maintenance for the Port District's
Harbor Police Geographic Information System. The touch screen, browser
based, system is accessed by the Harbor Police from their cruisers. The
system displays static and dynamic geographic information on request.
Technologies included: Javascript, AJAX, Java Server Pages, Java Native
Interface (JNI), OpenLayers, Dynamic Data Layers, ESRI GIS Mapping
product suite, Department of Homeland Security (DHS) Geospatial Data
Model and PL/SQL.
Synteract, Incorporated - Carlsbad, CA
November 2007 - March 2008: Oracle AERS Consultant
. Provided custom programming and validation services for the Oracle's
Adverse Event Reporting System (AERS) 4.3.x to 4.5.2 migration.
Responsibilities included creating custom migration programs, E2B file
creation and import programs (created custom program to read flat file
into E2B format, verify file format, content and integrity), code list
modification, custom letter creation and modification, form (custom
field) modification, custom query creation and general admin services.
Created custom process which executes reports outside of the standard
AERS User Reporting Environment. Created and executed custom MedDRA and
WHODrug data load scripts for the TMS 4.5.2 system. Using TMS, created
virtual (versioned) MedDRA data dictionaries. Created custom TMS
functions/Scripts and process that check if coded event terms will change
between MedDRA dictionary versions. Additionally, provided miscellaneous
software design and development using Oracle database tools (PL/SQL,
packages, procedures, functions, SQL, PL/SQL Server Pages (PSP), Pro*C,
etc.) and TOAD.
SunGard Higher Education - San Diego, CA
October 2007 - November 2007: Senior Oracle Developer Consultant
. Provided Oracle software development for SunGard's Banner 8 Higher
Education software system. Responsibilities included reviewing
functional and technical specifications for logical accuracy, coding and
unit testing new processes using Oracle 10g database, Pro*C (Embedded
PL/SQL and Dynamic SQL Method 3), Oracle Reports/Forms, SQL, PL/SQL
Server Pages (PSP), packages (HTP), procedures, functions, MKS Integrity
Software Configuration Management system and TOAD.
Relational Concepts, Inc. - San Diego, CA
April 2007 - October 2007: System Architect and Developer
. Designed, coded and documented custom Clinical Trials Management System
(CTMS). System incorporates Pharmaceutical/Biotech Clinical Trials
program, project, study, budgeting, site, patient and grant management,
as well as many other heavily requested features. Technology: database
neutral design (MySQL to start, Oracle and SQL Server to follow), Apache
HTTP server, Apache Tomcat Java Servlet container, Jasper Reports, Java
Server Faces, PL/SQL, NetBeans Integrated Development Environment.
Additional tools: TOAD.
BioVision Corporation - Irvine, CA
October 2006 - October 2007: Oracle Applications/Developer Consultant
. Designed and built a custom PL/SQL based interface, using Oracle's Open
Interface API, between Oracle 11i eBusiness Suite (Accounts Receivable
and Order Entry module), Oracle Clinical and third party SQL Server and
web based ordering system. Created custom Web based reports based on
Oracle Clinical database data. Also providing Oracle Clinical/RDC DBA
support services. Additional tools: TOAD.
Abaris Lifesciences - Aliso Viejo, CA
October 2006 - December 2006: Senior Oracle Clinical DBA/Developer
. Designed, built and configured Oracle Clinical multi-client hosting
facility environment. Participated in FDA validation documentation
creation and execution. Facility accommodates multiple, unrelated
clients. Each client has their own separate and distinct database
instance and report servers with complete autonomy. Additional tools:
TOAD.
ResMed Corporation - Poway, CA
July 2006 - September 2006: Oracle Applications Consultant
. Provided custom Oracle Applications 11i development (Accounts Receivable
and Order Entry), using Oracle's Open Interface API and PL/SQL. Also,
provided HIPPA related data identification and custom programming.
Oracle Apps 11.5 modules included Accounts Receivables and Order Entry.
Additional tools: TOAD.
Nuvelo Pharmaceuticals - San Carlos, CA
May 2006 - July 2006: Oracle AERS Consultant
. Provided Oracle Adverse Event Reporting System (AERS) configuration and
customization services.
Edwards Lifesciences, LLC - Irvine, CA
October 2005 - July 2006: Oracle Database Developer
. Created automated PL/SQL based interface between Oracle Clinical and
Oracle's TrialMinder Clinical Trials Management System. Responsibilities
included analysis of Oracle Clinical and TrialMinder databases, creation
of table/column mapping document, coding, testing and all supporting
documentation. Additional tools: TOAD.
CliniComp, International - San Diego, CA
September 2005: Oracle Database Performance Consultant
. Engaged to conduct an architectural and performance review of CliniComp's
Global Data Repository. Reviewed user and technical documentation,
interviewed staff and created "Architectural and Performance" review
document.
Synteract, Incorporated - Carlsbad, CA
July 2005 - November 2005: Oracle AERS Consultant
. Provided day-to-day technical support, programming and validation
services for the Oracle's Adverse Event Reporting System (AERS).
Responsibilities included E2B file import (created custom E2B file filter
program to verify file format, content and integrity), code list
modification, form (custom field) modification, custom query creation and
general admin services. Additionally, provided miscellaneous software
design and development using Oracle database tools (PL/SQL, packages,
procedures, functions, SQL, PL/SQL Server Pages (PSP), Pro*C, etc.) and
TOAD.
Ventegra, LLC - La Jolla, CA
February 2005 - August 2005: Chief Technologist
. Provided technology recommendation and third party software evaluation
services.
Prescriber Solutions, Incorporated - San Diego, CA
March 1998 - January 2005: Founder, President and Chief Information Officer
. Devised, designed and developed an automated Electronic Prescription
Creation and Renewal Center software system. The system provides current
and accurate pharmacy utilization data, patient compliance and medication
profile information. The overall objective of the system is to reduce
the medical group's pharmacy related deficit. Data is obtained from
various Health Plan claims adjudication services. Once downloaded, data
was merged and presented via a standard Web browser interface on both
hand held and desktop devices. Data was received in various formats
including MS Access and flat files, then migrated or imported into the
Oracle database. This cross browser, including MS Pocket Internet
Explorer (PocketPC), application runs in an Oracle 9i (SQL, PL/SQL,
Pro*C), MS Visual C++, MS Access, Sybase Enterprise Application Server,
HTML, JavaScript, Java Servlets/Java Server Pages, Apache Web server,
Tomcat Servlet container, Struts Servlet Framework and Windows NT/W2K/XP
environment.
Biogen Idec Pharmaceuticals - San Diego, CA
November 2004 - May 2005: Oracle Clinical Validation/Development Consultant
. Created custom Data Clarification Form (DCF) and Investigator DCF
Signoff Sheet for use by the Cambridge, MA and San Diego, CA Clinical
Data Management groups. Technology included oracle Clinical, Oracle
Reports and Oracle Forms version 6i.
. Provided Oracle Clinical technical expertise and authored validation
steps and scripts for the Information Technology New Drug Development
Group's Installation Qualification (IQ) and Installation Operational
Qualification (IOQ) documentation for a database server and Web/Reports
server migration. Migration included an RDBMS revision level upgrade
and middle tier Operating System upgrade from Windows NT Server to
Windows 2000 Server. The middle tier upgrade involved a complete
rebuild of the middle tier technology stack.
Neurocrine Biosciences - San Diego, CA
December 2004 - February 2005: Oracle Clinical Technical Consultant
. Loaded and versioned WHO Drug and MedDRA dictionaries, including
authoring validation change control documentation. Created Clinical
Data Management support web site. Provided in-house Oracle Clinical,
Thesaurus Management System (TMS) and Adverse Event Reporting System
(AERS) technical support, which included SQL, PL/SQL script and reports
creation.
Pfizer Global Research and Development - La Jolla, CA
January 2003 - August 2004: Business Engine - Developer/Local Project
Manager
. One of two local developers for the Clinical Science (phase 1 through
phase 2b studies) project management system - "Queue". The Queue system
is based on the Business Engine Web based Software System. Pfizer has
implemented numerous enhancements to the "Out of the box" distribution.
Responsibilities included: maintaining and creating new custom Crystal
reports. Additional responsibilities included maintenance and
enhancement of custom interface between the Queue system and Pfizer's
internal financial tracking systems. Technology used included: Crystal
Reports, Business Objects, Erwin, Perl, PHP and C shell scripts, SAS and
PL/SQL.
November 2001 - December 2002: Oracle Clinical - Local Project Manager
. Managed all aspects of local implementation of Oracle Clinical (OC),
Clinical Trials Management system. Responsibilities included creation
and maintenance of project plans, validation documentation and
management of local resources. Managed the OC version 3.2.3 to 4.0.3
upgrade project. This upgrade included RDBMS and OC application
upgrades, as well as, a complete middle tier technology stack change-
out. Managed software rollout and maintenance of ancillary packages
that interface with OC. Additionally, locally managed global OC
consolidation effort.
Altura Strategies, Incorporated - Aliso Viejo, CA
July 2001 - February 2002: Senior Systems Analyst/Consultant
. Devised, designed and developed an online Clinical Trials Database
Management system. This cross browser application runs in an Oracle 8i
(SQL, PL/SQL, Pro*C), C++, PERL, HTML, Javascript, Java Servlets/Server
Pages, Apache Web server/Tomcat Servlet container and Windows XP/W2K
environment.
MedImpact Healthcare Systems, Inc. - San Diego, CA
January 2001 - October 2001: Senior Systems Analyst/Consultant
. Provided general database programming support for MedImpact's pharmacy
claims adjudication and client information management systems.
Responsibilities included report, input screen, C and Unix shell script
creation/modification. Application tools used included Oracle 7.3 and
8i databases, SQL*FORMS 3 and 4.5, PL/SQL, SQL*PLUS, SQR, Pro*C and Unix
Korn shell scripting language. Operating systems included Solaris and
SCO Unix and Windows NT 4.
Agouron Pharmaceuticals, Incorporated - La Jolla, CA
July 1997 - June 2000: Senior Systems Analyst/Consultant
. Provided support for Oracle Clinical - clinical data management
application product from Oracle Corporation. Diagnosed and resolved
miscellaneous technical issues, performed database administration, wrote
miscellaneous reports, SQL, PL/SQL, Pro*C and Unix programs and scripts.
Project leader for custom Case Report Form imaging project, which
interfaced with the Oracle Clinical application. Generally, provided
first tier technical support for the Data Management group. Interfaced
with the corporate Information Technology group as needed. The Oracle
Clinical application runs in an Oracle 7.3 RDBMS and Sun Sparc 450 and
Windows NT Workstation Client/Server environment.
Clinidata Medical Solutions - Del Mar, CA
January 1996 - June 1997: Chief Information Officer
. Responsible for complete system design, including software and hardware
selection, database modeling, application development, local/wide area
network and wireless hand held computer communications, implementation
and maintenance of a two tier Client/Server Physician Data Integration
System. Responsibilities also included ongoing database and external
database gateway administration, enhancement approval and scheduling,
supervision of programming, customer support and Quality Assurance
functions, overall project management and leadership. The system
extracts and merges patient demographic data from customers existing
legacy (Mumps) systems, captures and prints/transmits prescriptions and
presents health plan formulary information at the point of care.
Software platforms included: Oracle v7.3 RDBMS, Oracle Gateway to M
(Mumps), PL/SQL, PowerBuilder v4 and v5, C and C++, Windows 95, Windows
NT v3.51 and v4.0 Server and Workstation, DEC (System 5) and SunOS
(Berkley) Unix. Hardware platforms included: DEC AlphaServer 2100A
5/250, Sun Sparc 20 Workstation, Compaq Proliant 1500 and 4500 Servers,
Pentium clones, Fujitsu Stylistic 1000 hand held computers and Proxim
wireless communications technology. Managed eight person staff.
Affiliated Pharmacy Technologies Incorporated - San Diego, CA
January 1993 - December 1995: Senior Systems Analyst/Consultant
. Installed SCO Unix, Oracle v6 RDBMS (SQL, PL/SQL, Pro*C) on a 486/50
based system. Loaded and modified client's existing Pharmaceutical
Repackaging Facility Software application. Rewrote SQR reports using
Oracle's SQL*REPORTWRITER. Provided complete systems and application
enhancement and support.
Gensia Pharmaceuticals, Incorporated -San Diego, CA
February 1991 - May 1995: Senior Systems Analyst/Consultant
. Designed, coded and implemented an Oracle based Regulatory Document
Tracking System. The system tracked FDA required documents throughout
each phase of new drug testing. Coded miscellaneous reports and data
manipulation scripts to supplement the Oracle based Clintrial Clinical
Data Management System. Managed WordPerfect for SunOS beta program.
Designed, coded and implemented a "Hypertext Like" feature for
WordPerfect on SunOS. This feature was included in Gensia's Computer
Aided New Drug Application (CANDA) software, which was used by the FDA to
assist in the new drug approval process. Assisted with Oracle DBA
functions, miscellaneous Oracle applications and design. Applications
were developed in an Oracle v6 (SQL, PL/SQL, Pro*C), SQL*FORMS v3, C,
VAX/VMS and SunOS environment. Conducted evaluation of Gupta and
PowerBuilder Client/Server software packages. Developed a PowerBuilder
v4 and Oracle v7 based contact management system to support GenESA device
drug delivery system.
University of California, San Diego - San Diego, CA
June 1993 - January 1994: Senior Systems Analyst/Consultant
. Reorganized and resized v6 Oracle database. Performed application and
database design review, including minor SQL*FORMS v3 and PL/SQL
development, for the Alzheimer's Disease Cooperative Study in the Novell
network environment.
Watkins Manufacturing Corporation - Vista, CA
June 1992 - October 1992: Senior Systems Analyst/Consultant
. Corrected various bugs in 286 PC based v5.1 RDBMS (SQL, PL/SQL, Pro*C)
and v2.3 SQL*FORMS application. Installed SCO Unix and an Oracle v6
RDBMS on a 486/50 based system. Migrated database from v5.1 to v6.
Included rewriting DOS .bat files to Unix C shell scripts, upgraded
SQL*REPORTWRITER reports and ported C programs.
MedImpact, Incorporated - San Diego, CA
February 1992 - April 1992: Senior Systems Analyst/Consultant
. Coded and implemented various reports for an Automated Pharmacy Insurance
Billing System. Applications were developed in an Oracle v6 RDBMS (SQL,
PL/SQL, Pro*C) and SCO Unix environment.
Qualcomm, Incorporated - San Diego, CA
February 1990 - July 1991: Senior Systems Analyst/Consultant
. Designed, developed and implemented Human Resources and Labor
Distribution applications, including reporting module. Labor
Distribution application interfaced with Oracle Financials software.
Responsible for trouble shooting new versions of Oracle products.
Performed utility MIS functions and assisted permanent staff with Oracle
design and development. Migrated SQL*FORMS, SQL*PLUS, SQL*REPORTWRITER,
C and VMS .COM files to the Unix operating system. Applications were
developed in an Oracle v6 RDBMS (SQL, PL/SQL, Pro*C), VAX/VMS and
Solbourne/SunOS environment.
Mail Boxes Etcetera, Incorporated - San Diego, CA
November 1990 - December 1990: Senior Systems Analyst/Consultant
. Designed and developed Oracle Pro*C programs for an Electronic Federal
Income Tax Processing System. The programs compressed tax data for
transfer from a Compaq 386 to an IBM RS/6000 running AIX and an Oracle
v6 RDBMS. The programs also updated the database with customer and
government acknowledgment data.
San Diego Unified Port District - San Diego, CA
March 1989 - February 1990: Senior Consultant/Project Leader
. Created software requirements, conducted staff interviews, performed
database modeling and design, created C and SQL*FORMS program
development specifications, provided Pro*C and SQL*FORMS programming
assistance and was responsible for testing and implementation of an
Oracle based Financial Management Information System. Modules included:
labor distribution, payroll, work order tracking, general ledger, motive
equipment, usage and expense reporting. The system was developed on a
PC using Oracle's RDBMS v5.1, SQL*FORMS v2.3, Pro*C and SQL*PLUS.
Pharmisys, Incorporated - Del Mar, CA
June 1988 - March 1989: Senior Consultant
. One of two responsible for initial database design, development and
implementation of an Oracle based Integrated Drug Delivery System. The
system was designed to support clinic controlled pharmacies. Each
pharmacy had PC based formularies, which were polled at night by a VAX
mini-computer. Prescription and re-order information was retrieved and
processed at the repackaging facility. Orders were automatically
generated, filled and delivered to each respective clinic formulary the
next day. The system was developed on a PC and VAX using Oracle's RDBMS
v5.1, SQL*FORMS v2.2, Pro*C and SQL*PLUS.
United States Air Force / Edwards Air Force Base - California
January 1988 - June 1988: Senior Consultant
. Designed, developed and implemented a PC based Oracle Financial
Management Information System to manage contract costs and provide cost
planning and forecasting for the United States Air Force Strategic
Defense Initiative. The system was developed on a PC using Oracle's
RDBMS v5.1, SQL*FORMS v2.2, Pro*C and SQL*PLUS.
General Electric Retail Systems, Incorporated - San Diego, CA
July 1983 - December 1987: Senior Programmer/Analyst - Project Leader
. Responsible for various phases of software design, development and
conversion from an ISAM file system and Fortran based software to an
Oracle database, SQL*FORMS and PL/I based system.
. One of three people responsible for complete design and modeling of new
Oracle database. Modules included inventory control and distribution,
sales, merchandising, general ledger, accounts payable, accounts
receivable, payroll, labor distribution, receiving and purchasing.
Other responsibilities included overseeing design meetings involving
customer service, marketing, and programming staffs; scheduling and
assigning projects to junior and contract programmers; maintaining and
presenting module development schedules to upper management; controlling
all module tables, layouts, and directory structures. All work
performed on Data General hardware and the AOS/VS operating system.
Systems were developed using Oracle's RDBMS v5.0, SQL*FORMS v2.0,
PRO*PLI and SQL*PLUS.
. Coordinated bench marks to determine maximum performance of Oracle on
Data General hardware.
Citicorp Information Resources, Incorporated - San Diego, CA
February 1982 - June 1983: Computer Programmer
. Responsible for conversion of on-line Credit Union systems to Citicorp's
In-House system. Coded, tested, debugged and implemented application
changes to existing modules. Modules included shares, drafts, loans,
certificates, payroll processing, ATM/ACH, and general ledger. All work
performed on Data General hardware, ISAM file system and the AOS/VS
operating system.
HARDWARE EXPERIENCE
Digital Equipment VAX series computers, AlphaServer 2100A 5/250, Solbourne,
Sun SPARC 10 and 20 series computers, IBM RS/6000, PC/AT
286/386/486/Pentium series, Macintosh, Data General MV and S series
computers, Compaq Proliant Server and Deskpro series computers.
LANGUAGE AND SOFTWARE EXPERIENCE
Oracle RDBMS v5-v10, C, C++, PL/I, Fortran, BASIC, Oracle Forms, Oracle
Reports, SQL, PL/SQL, Pro*C, Pro*PL/I, SQR, Word Perfect, Word, dBaseIII
and IV, Foxbase+, Foxpro, Crystal Reports, LogiXML, TOAD, PowerBuilder,
Sybase Enterprise Application Server, Java Servlets/JSP/JSF, HTML, CSS,
XML, Javascript, Korn, Bourn, PERL, MS Internet Information Server, Apache
Web server, New Atlanta ServletExec Servlet container, Tomcat Servlet
container, Struts Servlet framework, Java Server Faces Servlet framework,
MySQL, Jasper Reports, Microstrategy BI, and NetBeans IDE, MKS and CVS
version control software.
OPERATING SYSTEM EXPERIENCE
SunOS, Solaris, AIX, SCO Unix, DEC Unix, HP-UX, Linux, VMS, AOS, AOS/VS,
RDOS, MS-DOS, Windows 3.1/95/98/NT/2000/2003/2008/XP, Pocket PC 2000/2002.
EDUCATION
Mar 1982 Bachelor of Science, Computer Science, Coleman College - La
Mesa, CA
Oct 1981 Associate of Science, Computer Science - Coleman College -
La Mesa, CA
Sep 1977 Computer Science Major - San Diego State University - San
Diego, CA
Jun 1977 Associate of Science, Aeronautics - Grossmont College - El
Cajon, CA
MISC
Security clearance: Secret (Administratively terminated).
Contact this candidate