22 Sturbridge Avenue
Deptford, New Jersey 08096 / Cell: (609) 617-6417
Home: (856) 232-7672
SUMMARY:
Senior Software/Database Developer with fourteen years of experience in the design, development, implementation, testing, and support of software applications for pharmaceutical and business environments. Looking for a full-time position as a Senior Oracle Developer or Data Architect, as well as the opportunity to further learn and utilize application DBA skills.
EXPERIENCE:
GlaxoSmithKline: Pre-Clinical Division (01/2004 – Present): 709 Swedeland Road, King of Prussia, PA
Title: Senior Software Engineer
Development Tools/Environments:
§ Oracle 8i/9i/10g, PL/SQL, SQL Navigator, SQL Plus, Windows NT, Visual Basic 6, Visual Source Safe, Java, XML, Eclipse, DataStage
Development Tasks/Responsibilities:
§ Re-architecting the database for a clinical trials registration and ordering application including:
o Developing an entirely new data model for the existing application.
o Developing the data migration plan and the SQL scripts necessary to implement the new design.
o Implementing the data migration plan with a minimum of application down time.
o Modifying the application PL/SQL, Java and VisualBasic code to accommodate the new database design.
§ Developing and maintaining a clinical trials registration and ordering application including:
o Conducting a performance tuning project that improved database response time by 50%.
o Ongoing development and management of tables, sequences, triggers, indexes, and PL/SQL packages and procedures.
o Developing new Java code to support new user requirements.
o Deploying application code to/configuring a Tomcat web server.
o Utilizing DOM parser to load/parse application configuration files for generating XML streams to send to web browsers.
o Utilizing SAX parser to load/parse XML in order to create new study data.
§ Performing the design and implementation of interfaces to synchronize data:
o Across three GSK applications in near real time. Interface includes Java procedures, XML, SAX parser, PL/SQL stored procedures, and DataStage processes.
o Between the GSK shipping and study management applications in near real time. Interface includes web services, C#, Java, and PL/SQL stored procedures.
§ Migrating a clinical trials registration and ordering application:
o From Oracle 8i to Oracle 9i (databases).
o From internal hosting to external vendor hosting.
o To a new environment for a technical refresh project.
o From Solaris 8 to Solaris 10 (web servers).
o From Oracle 9i to Oracle 10g (databases).
§ Performing the technical direction and oversight of both in-house and offshore development teams and offshore support teams including:
o Working with business analysts to identify and develop business and system requirements.
o Breaking down requirements into packages of work and providing effort estimates.
o Developing high level designs to implement packages of work and ensuring their implementation.
o Providing technical support to project developers.
o Conducting code and design reviews to ensure project standards are maintained.
o Assigning packages of work to developers and ensuring that their work is completed within project timelines.
§ Performing schema level exports/imports of Oracle databases.
§ Maintaining/enhancing, providing front line application support, and vendor interactions for:
o A clinical trials registration and ordering application.
o A clinical trials shipping application Oracle database.
§ Participating in requirements gathering and analysis sessions.
§ Writing technical documentation including: technical designs, design review reports, code reviews and code review reports, technical installation plans, and technical installation reports.
§ Providing on-site and off hours user support including:
o Providing technical oversight for an offshore support team for two clinical trials applications.
o Managing code fixes and discussing/reviewing design and code changes.
o Working with business and IT resources to schedule production releases.
First Consulting Group (09/1996 – 01/2004): 575 East Swedesford Road, Suite 200, Wayne, PA
GlaxoSmithKline: Pre-Clinical Division (07/2000 – 01/2004): 709 Swedeland Road, King of Prussia, PA Title: Senior Software/Server Developer
Development Tools/Environments:
§ Oracle 8i, PL/SQL, SQL Navigator, Windows NT, Visual Basic 6, Visual Source Safe, Java, XML
Assignment Summary:
§ Assigned to a project for an in-house GSK Interactive Voice Response system linked to a centralized Oracle database. Included Visual Basic and Intranet applications that supported the administration of the system and 24/7 helpdesk support. Allowed clinical trial investigators, study nurses, pharmacists and local study monitors to telephone in and register patients in clinical trial studies and to order study medication. Allowed investigators to record patient activities such as clinic visits, withdrawals, and other study events. Provided better visibility of study progress, increased control of inventory, provided real-time monitoring of study enrollment, and prevented over-enrollments once study targets have been met.
Development Tasks/Responsibilities:
§ Performed the development, maintenance, and future enhancements of the database architecture, including the design and development of PL/SQL stored procedures, views, triggers, and table changes.
§ Maintained/enhanced the Visual Basic Graphical User Interface.
§ Performed the development and maintenance of the database interface for the IVR System.
§ Performed a portion of the design, development, and maintenance of a concurrent system interface.
§ Participated in requirements gathering and analysis sessions.
§ Provided on-site user support.
DuPont: Agricultural Division (01/1999 – 06/2000): Pesticide Screening Utility Project
Title: Server Developer
Development Tools/Environments:
§ Oracle 7, PL/SQL, SQL Navigator<Comp2>, Windows 98, Visual Source Safe
Assignment Summary:
§ Assigned to a project for a Visual Basic/Oracle client-server application that was designed to 1) satisfy all requirements of work processes associated with conducting biological and chemical evaluations of experimental chemicals for use as crop protection agents and 2) increase the efficiency of screening operations and the sharing of information across all discovery research groups.
Development Tasks/Responsibilities:
§ Installed, evaluated, tested, and implemented SQL Navigator version control integrated with Visual SourceSafe.
§ Designed, developed, analyzed, and tested interfaces to remote project databases using Oracle PL/SQL procedures and functions.
§ Designed, developed, and implemented data diagrams, database tables, and stored procedures using PL/SQL.
§ Deployed the application into the production environment.
§ Supported the production environment via on-site support for acceptance and integration testing.
McNeil: Consumer Products Division (09/1996 – 12/1998) Drug Manufacturing Electronic Batch Records Project
Title: Software Developer
Development Tools/Environments:
§ C, Palette Graphical User Interface Tool, DCL, SQLMOD, Rdb, CADRE Teamwork CASE Tool (VAX/VMS and Windows 95 client-server environment), CMS and MMS (configuration management), Cantata (testing), Microsoft Access, Platinum Technology InfoReports
Assignment Summary:
§ Assigned to a project for an electronic data collection, storage, and reporting system comprised of a document management system, logbooks, nonconformance reporting, process control systems, and batch records used to manage the complex information requirements associated with new product development, New Drug Applications (NDAs), and Current Good Manufacturing Practices (cGMP). Product packaging departments used the application to measure the actual performance of product packaging lines versus the expected packaging line performance.
Development Tasks/Responsibilities:
§ Identified user requirements and designed, developed, and maintained the software for the electronic batch records system in a full life-cycle environment.
§ Analyzed, designed, developed, implemented, and tested administrative functions, batch records, and nonconformance reporting modules.
§ Identified user requirements, and performed analysis and design for audit trails within the nonconformance reporting modules.
§ Designed, developed, tested, and documented custom reports for company wide use.
§ Designed and developed system reports using InfoReports from Platinum Technology in an Rdb environment.
§ Gathered user requirements, designed, developed, tested, and documented the electronic batch records planning and performance tracking system using Microsoft Access.
§ Provided 24/7, on-call application support to troubleshoot end-user problems.
EDUCATION:
Bachelor of Science Degree, Computer Science, The Richard Stockton College of New Jersey, 1996
Associate of Science Degree, Computer Science, Gloucester County College, 1994