OBJECTIVE:

A position in Database Development requiring proven analysis, creative and planning skills to ensure the safety and recoverability of corporate data.

SUMMARY:

Over four years’ experience in Oracle Development.

EXPERTISE INCLUDES:

• Design
• Installation
• Recovery
• Configuration
• Tuning
• Creation
• Backup
• Load Process
• Documentation

TECHNICAL SKILLS:

Databases: Oracle 10.2.0.1, 10.2.0.2, 11.1.0.6, 11.2.0.1, HTMLDB, Oracle9i Application Server, SQL Server 7.0, 2000, Access 97, 2000.

Languages: SQL, PL/SQL, Visual Basic 6.0, Oracle Portal 3.0, WEBDB 2.2, 2.1, Oracle WEB Toolkit, HTML, DHTML, XML, Java Script, VB Script, UNIX, Shell Script, Perl Script, Windows Script.

Environment: Oracle TMS, Server Manager, DBA Studio, RMAN, SQL* PLUS, SQL Developer, Erwin, TOAD, SQL Navigator, Reflection for Unix, Visual Studio 6.0 including Visual Interdev, PC Anywhere, Sybase SQL Anywhere 8, Oracle Application Express 4.1, Auto DCD, Define Generator.

Systems: UNIX SUN (E450, E4500, E10K, Sun Fire 480R, Sun Fire V890), AIX, and HP - UX11i, Linux, Windows XP, NT, 2000, 2003 and DOS.

EXPERIENCE:

Confidential, Berwyn, PA

Oracle Developer

Responsibilities:

• Propose project strategies based on outcome of source data review, contract specifications and project timelines.
• Review and analysis of source (raw) data using SQL ADHOG query and PL/SQL procedures and function.
• Compare source data to the client aCRF and protocol.
• Set up and implement of the Data Conversion Plan. Design, build, test & support work processes & systems.
• Develop and leverage global work process and systems solutions.
• Track performance and report progress against deliverables. Contact client to make sure all source data sets exits.
• Create data conversion plan and maintain project binders. Author mapping specifications from source (raw) data to target (CDISC SDTM and / or sponsor defined standards). Develop CDISC SDTM domains utilizing in house created data conversion tool (Auto DCD), Oracle ADHOG queries, functions and procedures. Create tables, views, functions and procedures. Drop empty columns based on SDTM standards.
• Mentor and train overseas employees in the use of the ETL tool, troubleshoot the ETL tool and identify strategy for data conversion for a given project. Provide post ETL and pooling strategies for a given project.
• Create and maintain process and project specific documentation. Assist in the organization and presentations at client meetings or internal meetings. Identify potential process improvements that may increase productivity or quality of the data conversion.
• Complete project status reports.
• Quality control of CDISC SDTM domains using in house QC tools. Create views, functions and ADHOG queries to check if all domains created based on SDTM standards. Run CDISC report and Check Point software to validate structure and data integrity.
• Create data definition files and Case Report Forms annotated to CDISC SDTM using in - house develop tool (Generator).
• Function as a DIS representative to the client: participate in client meetings, assure issues are communicated to client and resolutions are obtained in a timely manner. Clients included: AZ, GSK, Forest pharm., ROMARK (US Government sponsored studies).
• All work and documentation complain with FDA regulation CFR 21 part 11.

Confidential, Wayne, PA

Oracle Developer

Responsibilities:

• Full developer support for DIS (Data Integration & Standardization) department projects, tuning scripts and users statements. Load data using SAS procedures.
• Creating new PL/SQL packages, functions, procedures and other objects. Create documentations for validation of the new code
• Converting data to FDA accepting format (SDTM) using Oracle database and OWB.
• All client data files converting to SDTM model and sending back to client or FDA.
• Quality control of CDISC SDTM domains using in house QC tools. Create views, functions and ADHOG queries to check if all domains created based on SDTM standards. Run CDISC report and Check Point software to validate structure and data integrity.
• Create data definition files and Case Report Forms annotated to CDISC SDTM using in - house develop tool (Generator).
• Clients included: AZ, GSK, BMS, US Government sponsored studies and FDA.
• All work and documentation complain with FDA regulation CFR 21 part 11.

Confidential, Horsham, PA

Oracle Consultant /Developer

Responsibilities:

• Involved in business analyses for loading data into dictionaries from investigational drug studies.
• Created Migration Load Utility for load MedDRA into dictionary tables using shell scripts Oracle SQL and PL/SQL.
• Load MedDRA into dictionaries and test integrity of the load using Oracle Reports and ADHOC queries.
• Write documentation for UAT and change requests and update SOPs.
• Back end support for WEB client’s application.
• Develop and tune Oracle procedures, functions, packages, and views for loading data into staging data warehouse.
• Load data from flat files using SQL Loader utility and Unix shell scripts Files came from different sources, HMS, DEA office and others.
• Create and administrate new data warehouse for management reporting systems.
• My responsibilities included but not limited to: tuning data warehouse processes implemented on SUN Solaris and using Oracle 10.2.0.5 and 11.2.0.1, tuning of SQL and PL / SQL. Synchronized data between OLTP and data warehouse.
• Create scripts, function and procedures for daily and monthly jobs.