SUMMARY:

Information Technology specialist with over 35 years of technical experience, which includes 25+ years of pharmaceutical, biotech and healthcare (Life Sciences) specific industry experience. Possesses extensive knowledge of clinical and safety reporting systems, electronic health record systems and the Oracle RDBMS, in addition to a proven record of exceptional performance, flexibility and providing customer driven solutions.

TECHNICAL SKILLS:

HARDWARE EXPERIENCE: Digital Equipment VAX series computers, AlphaServer 2100A 5/250, Solbourne, Sun SPARC 10 and 20 series computers, IBM RS/6000, Wintel, Macintosh, Data General MV and S series computers, Compaq Proliant Server and Deskpro series computers.

LANGUAGE AND SOFTWARE EXPERIENCE: Oracle RDBMS v5 - v11,SQL Server 2005/2008, C, C++, PL/I, Fortran, BASIC, Oracle Forms, Oracle Reports, SQL, PL/SQL, Pro*C, Pro*PL/I, T-SQL, SSMA, 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, Bash, 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, JDBC, Jasper Reports, Microstrategy BI, Oracle NetBeans IDE, MKS and CVS version control software, JIRA enhancement/issue tracking system.

OPERATING SYSTEM EXPERIENCE: SunOS, Solaris, AIX, SCO Unix, DEC Unix, HP-UX, Linux, VMS, AOS, AOS/VS, RDOS, MS-DOS, Windows server NT/ 2000/2003/2008 , desktop XP/7, Pocket PC 2000/2002.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Clinical, Argus Technical Specialist

Responsibilities:

• Migrating four Argus single - tenant databases to an Argus multi-tenant database. Additionally, the process involves upgrading Argus from 7.0.1 to 8.1.2. Tools: Oracle 11g, 12c RDBMS, PL/SQL, SQL, Windows 2008, 2012 servers.
• Designing and developing a custom Argus Configuration Extract tool (ACE). ACE extracts Argus database configuration data into an Excel spreadsheet. Configuration data is stored in a custom schema, which allows for comparisons and delta analysis between client configurations. Tools: PL/SQL, SQL, Oracle 12c RDBMS, Windows 2008, 2012 servers, Linux.
• Designed and developed a custom Tenant Copy Utility (TCU). TCU extracts Argus data from a source tenant and inserts into a target tenant. This entails updating target sequences and data organizational structures. Tools: PL/SQL, SQL, Oracle 12c RDBMS, Windows 2008, 2012 servers, Linux.
• Technical lead responsible for analysis, design, development and validation of the Confidential data migration effort from the AstraZenica Sapphire system to Argus. The process involved extending Argus ESM import profiles to in corporate extended E2B data elements (including custom PL/SQL data transformations), cleansing and verifying E2B XML source files, as well as programmatically migrating associated regulatory reporting (non-E2B) data directly into the Argus 8.1 database. Additionally, providing Argus 7.x, 8.x support, Oracle Clinical 5.1 upgrade and software support. Authored custom Argus Tenant Copy Utility. Tools: Oracle 12c databases, PL/SQL, SQL, Java, TOAD, Windows 2008/2012 R2 and Linux servers.

Confidential, East Norriton, PA

Data migration specialist

Responsibilities:

• Technical lead responsible for analysis, design, development and validation of the Confidential data migration effort from ARISg to AERS.
• The process involved cleansing and verifying E2B XML files from the source system, as well as migrating associated data elements directly into the AERS database.

Tools: Oracle 9i, 11g, 12c databases, Java, JDBC, Oracle NetBeans IDE, TOAD, PL/SQL and SQL.

Confidential

Oracle Clinical, Argus Technical Specialist

Responsibilities:

• Providing ongoing Oracle database technical support, including Oracle Argus Safety 7.x, 8.x, Oracle Clinical 4.x, 5.x and Oracle AERS 4.x support.
• Performed OC v4.6 to OC v5.1 (95+ million responses rows) upgrade, performed Argus 8.1 multi-tenant installation which included WebLogic (10.3.6, 12.2.1.1), BI Publisher (12.2.2) and Oracle Access Manager (11.1.2.3), assisted with the development of an Argus Safety custom tenant copy utility and associated tools .

Tools: Oracle 10g, 11g, 12c RDBMS/Client/ODAC, PL/SQL, SQL, TOAD, WebLogic 12.2.x, 12.1.x, 10.1.x install/config, Oracle Access Manager (OAM) 11.1.x and 11.2.x, Business Intelligence Publisher 12.2.x install/config, Windows Server 2003, 2008 R2, 2012 R2, Red Hat Linux 7.2, VMware. Waterfall SDLC.

Confidential, Irvine, CA

Oracle Argus Technical Specialist

Responsibilities:

• Providing ongoing Clinical and Safety system technical support.
• Installed, configured and authored Installation Qualification (IQ) documentation for Argus 8.0 Safety Multi-Tenant System installations on Windows middle-tier and back end servers.
• Providing ongoing guidance and assistance with Test and Production installations, configuration and validation rollouts.
• ESM and AGProc setup and configuration (E2B, etc.). Applied Argus 8.0.1.1 patch. Tools: Oracle 12c RDBMS, Oracle 12c Client /ODAC, PL/SQL, SQL, TOAD, WebLogic 10.1.4.3, Oracle Access Manager (OAM) 11.1.x and 11.2.x, Microsoft Active Directory, Kerberos, Windows Server 2008 R2, VMware.

Confidential, St Louis, MO

Senior Safety and PharmacoVigilance Systems technical specialist

Responsibilities:

• Provided analysis of client safety technical and system requirements; configuration and technical support of safety related solutions to meet identified needs; development and execution of programs to support E2B and custom data migrations; development and execution of validation packages with respect to data migrations and custom developed PV software; provided technical expertise in support of Business Development pre-sales efforts.

Tools: Oracle 10g, 11g RDBMS, ODAC, PL/SQL, SQL, Pro*C, C/C++, Java, ASP, .NET, TOAD, Windows and Unix/Linux Servers, VMware, Argus, AERS, eTrace, MedDRA and WHODrug dictionaries.

Confidential, Parsippany, NJ

Oracle database performance and architecture specialist

Responsibilities:

• Provided Oracle SME performance/architecture analysis and testing for the Confidential PVM performance enhancement project.
• Techniques and solutions included: PL/SQL functions, procedures, packages, triggers, pipelined functions, bulk collections, dynamic SQL, materialized views, functional indexes, collections, varrays, records, types, dynamic SQL, etc.

Tools: Oracle 10g/11g databases, PL/SQL, SQL and TOAD, .NET, Windows, Linux.

Confidential, Parsippany, NJ

Argus, SharePoint, Documentum Migration Specialist

Responsibilities:

• Work Stream Lead responsible for project management, analysis, design, development and validation of Safety System attachment extraction from client acquired SharePoint, Documentum and Argus systems to client Documentum and SharePoint systems.
• Work Stream lead responsible for liaising with client staff (including IT management and DBA team) and managing off-shore resources for the Confidential data migration component of the project.

Technologies included: Java, JDBC, SOAP Web Services, Documentum Foundation Class (DFC) 6.7 API, SharePoint 2010, Oracle 11g database, PL/SQL, Pro*C, TOAD and Oracle NetBeans IDE, Argus 5.x, 7.x, ARIGs 5.x, Documentum 6.7, Windows, Linux.

Confidential, Canonsburg, PA

Oracle Database Developer

Responsibilities:

• Assisted with final migration analysis, logic modifications and issue resolution for an Oracle AERS to Argus safety data migration.

Technologies include: PL/SQL, SQL, TOAD, Oracle 11g RDBMS, Argus 7.x.

Confidential, Oakland, CA

Oracle Database Developer

Responsibilities:

• Assisted with the integration of Confidential Group's proprietary PRIMO safety system triage product with the Oracle Argus safety system.
• Responsibilities included investigating and devising an E2B interface that will allow the two systems to communicate outside of the Argus provided interface.

Technologies included: PL/SQL, SQL, E2B ICHICSR standards, TOAD, Oracle 10g RDBMS, Argus 7.x.

Confidential, Princeton, IN

Project Manager/Technical Lead/Oracle Database Developer

Responsibilities:

• Project Manager and Technical lead responsible for developing a strategy for the movement of Confidential and source documents to the BMS CARES AE system, and the new Document Information Management System (DIMS).
• Responsibilities included conducting business unit requirements gathering and analysis, developed source and target flow information road maps, identified outcomes to be achieved, managed partner and third party technical resources and processes (including off-shore), authored functional and technical specifications and validation (IQ/OQ/UAT) documentation, executed validation scripts in dev/test/prod environments, developed and tested custom data movement software, worked with client architects and project managers to ensure successful project delivery, provided overall end-to-end project stewardship of the Confidential and document migration strategy.
• Data movement included a combination of structured and non-structured data from flat files, from PL/SQL, and Oracle databases.

Platforms: Windows and Linux servers, Oracle 10g, 11g RDBMS, Documentum Foundation Class (DFC) 6.7 API, Java, SQL, Pro*C, PL/SQL, TOAD, HPQC, Argus 7.x, Oracle NetBeans IDE, Windows, Linux.

Oracle Database Developer/DBA Consultant

Confidential

Responsibilities:

• Technical lead responsible for developing a clinical document migration strategy and solution for the Confidential (BMS) acquisition of Confidential Pharmaceuticals.
• Activities included moving data and documents from Confidential ’s Argus and Documentum systems.
• Source documents were extracted from an Argus database and Documentum export file to Operating System file shares for future import into a document information management system.
• Responsibilities included requirements gathering, functional and technical documentation, software development and overall stewardship of the document migration component of the project. Additionally, assisted with software development for the migration of Argus case data to the CARES (BMS proprietary) safety system.
• Created and executed IQ/OQ test scripts using the HP Quality Center software package.

Platforms: Windows and Linux servers, Oracle 10g, 11g RDBMS, DBMS JAVA, UTL FILE, PL/SQL, SQL, Pro*C, TOAD, HPQC, Argus 7.x, Documentum (DFC) 6.7, Oracle NetBeans IDE, Windows, Linux.

Confidential, San Diego, CA

Oracle Database Developer/DBA Consultant

Responsibilities:

• Designed and developed a data extraction program to pull data stored in an Oracle 7.3.4 database.
• Process included converting Oracle 7.3.4 obsolete data types and restricted column names to current Oracle 10.2 data types.
• In addition, researched all referential integrity information (primary and foreign keys, etc.) and created a mapping document.
• Data was moved to an Oracle 10.2 database in order to eliminate any performance issues on the existing production database.
• Data was extracted to comma delimited flat files for migration to Confidential ’s new Persona system.
• The extraction program was written entirely in Pro*C and PL/SQL and uses the UTL FILE and DBMS LOB packages.

Platforms: Windows 2003 Server and XP Professional, Oracle 7.3.4 and 10.2, PL/SQL, SQL, Pro*C, Microsoft Access and Excel and TOAD, Windows.