Senior Oracle PL/SQL Programmer Resume

PROFESSIONAL EXPERIENCE

Senior Oracle PL/SQL Programmer

Confidential

Responsibilities:

Act as the core project team lead to coordinate and manage all Clinical Trial programming activities
Serve as the lead programmer to design and specify the overall approach to a project’s programming tasks.
Provide statistical programming liaison with the client and input for SOPs.
Create and maintain programming tracking documentation.
Create, test and maintain PL/SQL programs for clinical studies.
Generate summary tables, data listings, graphs and derived datasets as specified in the statistical analysis plan.
Generate outputs and reports to support other departments.
Perform validation on computer - generated output to verify accuracy.
Transfer of deliverables.
Following departmental SOPs and relevant regulatory guidelines (e.g. ICH) to comply
Coordinated international conference call Biometric meetings to discuss Clinical Trial requirements and deliverable timelines

Oracle PL/SQL Programmer/Data Loader

Confidential

Responsibilities:

Monitor Oracle data loading procedures/processes for complex stock trading/financial investment data and troubleshoot errors encountered - during/after work hours
Create and enhance existing Oracle procedures/Unix shell scripts according to new business requirements; test, document, and deploy to Production environment(s)
Load external client CSV data files into internal company Oracle database
Create CSV files from Oracle database according to business requirements and sent to email distribution list

Oracle PL/SQL Developer

Confidential

Responsibilities:

Designed automated report matching call center data from a SQL Server database to 3 other Oracle databases and created client extracts (pipe delimited text files).
Supported large DataWarehouse project: designed, tested and executed PL/SQL to merge two internal database applications (RxPlus and C1st) into DataWarehouse/reporting datamart.
Utilized ANSI SQL in writing stored packages, procedures, functions - designed SQL queries for client data extracts (pipe delimited flat files) according to client business requirements.
Designed and executed validation scripts on external data files loaded into Oracle database via SQL*Loader

Oracle Software Engineer, IT Dept

Confidential

Responsibilities:

Supported a large scale project that involved merging multiple external financial databases (6) into one large datawarehouse (4.8 million records). The project matched customers from separate financial accounts using key (common) fields. A unique identifier (UCID) was assigned to link the multiple accounts from various financial sources to the same customer.
Loaded multiple financial data flat files from separate financial systems utilizing SQL Loader. A program matched the same customer to multiple accounts from different financial sources and generated an XML file. I utilized an XML view tool to determine whether the right customers were matched correctly to the right accounts according to business rule specifications.
Designed and executed validation scripts on external CSV data files loaded into Oracle database utilizing SQL*Loader
Managed and validated XML files received/sent from other branches of the Confidential organization.

Oracle PL/SQL Software Engineer

Confidential

Responsibilities:

Supported an Oracle Biochemistry application using Oracle 8i database and Oracle Forms 6i. Involved setting up users with database and application privileges utilizing TOAD. Investigated Oracle Forms internal code according to requests by the IT director (wanted to know how the code was working or not working). I also investigated application errors/bugs as they were reported by users of the application and implemented fixes.
Utilized Visual Basic.Net and ASP.net to develop front end applications for in house business operations. Developed ASP.net reports for intranet application
ETL uploads of data files and spreadsheets into an Oracle 10g database via SQL Loader and VB.net. The IT director would provide me flat files and ask me to load them into the Oracle database according to requirements provided.
Designed and executed validation scripts on external data files loaded into Oracle database via SQL*Loader