Database Design

Working in MRL's (Merck Research Laboratories) RIS (Research Information Systems) Data Warehouse Group as an Oracle PL/SQL developer involved in various ETL tasks for the following projects VM Console (View Management subsystem) of Merck's Clinical Trial product CRISP (Clinical and Regulatory Information Program). Built the several CG (Clinical Genomics) Oracle SQL views needed for the product's summer release. Wrote the Oracle PL/SQL derivation functions (needed for transforming entered data according to preset business rules) in the VM console for the summer release. Wrote the Oracle PL/SQL stored procedures needed to update Prescribed Time Details and rollup to Prescribed Time for individual protocol based Oracle schemas (Clinical Trials) , referring data from the main Master and Clinical Representative Oracle databases. Regionalization Process to run all required audit programs for verifying product and system data (protocol based for all clinical trials conducted)