OBJECTIVE

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

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.

PROFESSIONAL EXPERIENCE

Confidential, Berwyn, PA

Senior Oracle / SDTM 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 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).

Confidential, Wayne, PA

Senior Oracle / SDTM 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).

Confidential, Horsham, PA

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