We provide IT Staff Augmentation Services!

Sdtm Oracle Developer Resume

Berwyn, PA

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.

Hire Now