GAIL WARREN

addezr@r.postjobfree.com

919-***-****)

EDUCATION

B.S. in Computer Science – North Carolina A&T State University, Greensboro, NC 27411

SKILLS

Oracle7-Oracle11g XML (Oracle) TOAD/SQL*Navigator

PL/SQL Packages SQL*LOADER SQL*PLUS

Stored Functions UNIX/Linux SQL

Stored Procedures Export/Import XML XQuery

Triggers Python training Table Functions

FTP Cron Database Object Creation Informatica training Putty

EXPERIENCE

April 2013 – Dec 2019 Consultant at GlaxoSmithKline (GSK) INC.

PL/SQL Developer on the GSK Travel and Expense System. I was responsible for creating the application to parse and process xml messages via PL/SQL and XML XQuery, as well as provided Level 1 support. I also supported various applications by developing procedures/functions and modifying packages, writing Unix scripts, scheduling cron jobs and creating database objects. I provided Level 3 support as needed. Tools used were Oracle 9i/10g/11g, PL/SQL, SQL*PLUS, SQL, UNIX, CRON, Putty, SQL*LOADER, SQL*Navigator/TOAD and Oracle XML XQuery

October 2008 – February 2013 Consultant at GlaxoSmithKline (GSK) INC.

PL/SQL Developer on the GSK Travel and Expense System. I was responsible for developing new packages and modifying existing ones, writing UNIX scripts, scheduling cron jobs and creating tables, views, sequences, etc as needed. I created journals and accruals in support of the general ledger systems JDE and SAP. Also, I interfaced with IBM’s TRACS system. Tools used were Oracle 9i/10g, PL/SQL, SQL*PLUS, SQL, UNIX, SQL*LOADER, SQL*Navigator and TOAD.

February 2008 – June 2008 Consultant at GlaxoSmithKline (GSK) INC.

PL/SQL Developer – Responsible for developing PL/SQL store procedures and UNIX shell scripts in support of various projects. Tools used were Oracle 9i, PL/SQL, SQL*PLUS, SQL, UNIX, TOAD and SQL*Navigator.

September 2007 – December 2007 Consultant at GlaxoSmithKline (GSK) INC.

PL/SQL Developer – Responsible for developing PL/SQL store procedures and UNIX shell scripts in support of the CMS application. Also analyzed CMS data and made corrections as needed. Tools used were Oracle 9i, PL/SQL, SQL*PLUS, SQL, UNIX, TOAD and SQL*Navigator.

October 2006 – August 2007 Consultant at American Kennel Club (AKC) INC.

PL/SQL Developer – Responsible for developing PL/SQL packages in support of AKC’s web applications to register dogs and litters. Also created scripts to fix database issues as needed. Tools used were Oracle 9i, PL/SQL, SQL*PLUS, SQL, UNIX and SQL*Navigator.

March 2005 – September 2006 Consultant at GlaxoSmithKline (GSK) INC.

PL/SQL Developer – Responsible for developing PL/SQL packages to be used by Oracle Clinical validation and derivation procedures. Assisted other developers with PL/SQL coding. Created reports used by the Data Manager, Study Leads and department members to analyzed Oracle Clinical data. Conducted all PL/SQL code reviews. Managed all department PL/SQL code in the CVS repository. Created audit tables and triggers for all existing and any new tables in two schemas. Tools used were Oracle 9i, PL/SQL, SQL*PLUS, SQL, TOAD 8.0 and Oracle Clinical 4.5 backend.

Wrote XML for an autoencoding system using PL/SQL and Oracle 9i.

Wrote UNIX shell scripts to be used by TWS.

Other tasks included organizing and implementing a table cleanup effort in two schemas and documenting the functionality of the remaining tables. Created documentation - PL/SQL Coding Standards, Code Review Checklist, usage of all packages public procedures and functions, Q/A Checklist, and documented the functionality of several existing packages.

April 2004 – January 2005 Consultant at Quintiles Transnational Inc.

Programmer Analyst – Responsible for maintaining 60+ databases used in on-going clinical trials

(Interactive Voice Response Systems). Created new scripts and modified existing scripts as needed. Tools used were PL/SQL, UNIX, SQL*PLUS, SQL, SQL Navigator, SQL*Loader, and Oracle.

Trained new team members and acted as a mentor for less experienced team members.

Technical writing that included Unit Test Plans, Database Code Reviews, Test Cases and Report Code Review documents.

March 2003 – December 2003 Consultant at GlaxoSmithKline (GSK) INC.

Programmer Analyst (PreClinical IT) – Responsible for planning and executing the deployment of a vendor software package. Duties included – planning and conducting database migrations (from Oracle 7.3.4 to 8.1.7) and configuration tasks, planning and conducting application installation tasks, designing and developing application installation scripts in an NT environment via Microsoft SMS Installer and producing a data migration plan, a deployment plan and verification scripts. Worked with the database group to establish database schemas. Conducted a data migration pilot. Tools used were PL/SQL, Export/Import, SQL, SQL*PLUS, and TOAD 7.4.

Technical writing which included Unit Test Plans, System Requirements, Technical Installation, Test Cases, Data Migration Plans, Unit Specifications, Design Specifications and gathered business requirements and prepared a feasibility report for the enhancement to an in-house web application.

Enhanced an existing in-house application that provided graphical trend reports to the users, with tools Visual Basic 6, ADO/COM, SQL, Oracle8, SQL*PLUS, and Quality Analyst 5.2. Migrated five database instances to new servers using Export/Import, TOAD 7.4 and SQL. Developed the application installation scripts using Microsoft SMS Installer.

August 2001 – November 2002 Consultant at PPD INC.

IVR Systems Developer - Responsible for developing IVR (Interactive Voice Response) Systems for Clinical Trials. Lead Developer on several major projects and maintained existing systems using Visual Basic 6, Oracle Objects for OLE, SQL, Visual Voice, PL/SQL, Stored procedures and functions, SQL*PLUS and Access97.

Designed/Build/Maintained Oracle7.3/8i databases used to manage patient data and created automated documents for the client using SQL, Triggers, Sequences, RightFax, Outlook, TOAD and Access97.

December 1998 - June 2001

Systems Engineer at Business Telecommunications, Inc.

TBS - Designed/Developed/Supported client/server applications in support of this vendor product. Wrote specialized utilities and front-end applications (CAIMAN, RAPTURE) with read/write capability to allow internal BTI departments to communicate with the product and make database corrections. Trained department members and users on the TBS application. The creation of CAIMAN and RAPTOR saved BTI approximately $2.3 million in licenses.

PayPhone - developed this application to evaluate BTI payphone activity on a quarterly basis.

TBS2Local – responsible for the modification and support of this internally developed application.

Local/TBS Audit – developed this application to audit the TBS and Billing system’s databases and produced reports showing the differences between the two.

Tools used were Visual Basic 6, ADO/COM, Oracle8, PL/SQL, Triggers, Stored Procedures and Functions, SQL, SQL*PLUS, Dynamic PL/SQL, Access97, Excel97, SQL*Loader, Oracle Objects for OLE, Q&E and TOAD.

Recognition: Received several Certificates recognizing my achievements on the TBS project - which consisted of an 850+ table database.

October 1994 – December 1997

Systems Integrator at First Citizens Bank

Responsible for the design, development and support of PC software for the banking industry.

Sole developer for several major projects including Decision Power - an online credit scoring

system and Motivator – online sales tracking system to track deposit products sales.

Both projects were fully implemented several weeks ahead of schedule. End-user satisfaction

was over 95% in the first week of implementation.

Continuous enhancements to the teller software (BranchTeller) and CSR software (BranchBanker)

using Ampersand Corporation’s Script language.

Recognition: Received several Certificates recognizing my achievements on various projects

April 1989 – June 1993

Staff Systems Engineer at IBM Corporation

Provided in-depth technical support to customers and IBM Field support personnel on the 4680

point-of-sale product line (operating system and features, applications, hardware, and 4680 BASIC).

Assisted with IBM and user software modifications, system design, system installation, problem

determination, and user exit design and coding; developed several presentations and participated

in various training sessions. Managed several critical accounts. Instrumental in maintaining key

accounts through detailed technical expertise. Identified and if appropriate provided solutions to product

deficiencies and provided circumventions to customers.

Recognition: Achievement Awards

Technical Leadership Award

Contact this candidate