OBJECTIVE

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

SUMMARY

Over six 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, SAS, Java Script, VB Script, UNIX, Shell Script

Development

Environments and Applications:

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.

Operating

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

Senior Oracle / SDTM Developer

My responsibilities included but not limited to:

• 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 using Oracle SQL and SAS datasets. 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

Senior Oracle / SDTM Developer

• 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

Oracle Junior DBA / Developer

• 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. Creating packages, functions, procedures and triggers. Synchronized data between OLTP and data warehouse. Create scripts, function and procedures for daily and monthly jobs.