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

SDTM 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.
• All work and documentation complain with Confidential regulation CFR 21 part 11.

Confidential, Wayne, PA

SDTM 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 Confidential accepting format (SDTM) using Oracle database and OWB.
• All client data files converting to SDTM model and sending back to client or Confidential .
• 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).

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.