Project: Oracle Argus Consultant, Pharmacovigilance• Expertise includes working with following Oracle technologies: PLSQL experience in procedures, Functions, Packages, Cursor, Exceptions and Triggers for Oracle Argus Safety Database.• Techno-functional Consultant with deep understanding of technical and functional aspects of PV Safety systems.• Requirements gathering and analysis for safety system configuration, migration and reporting• Authoring and accountability of document deliverables (requirement and specification documents, IQ, OQ, PQ) and Design, build and implement system configuration for clients.• Author, execute test scripts and manage test execution and issue tracking.• Closely work with clients and vendors to support implementation and resolve product issues A Subject Matter Expert (SME) in Drug Safety Systems - Oracle Argus Safety.• Handling the routing of E2B reports in Argus Safety

Created PL/SQL stored procedures, functions and packages for moving the data from staging area to target DB.• Created scripts to create new tables, views, queries for new enhancement in the application using Oracle SQL Developer.• Created indexes on the tables for faster retrieval of the data to enhance database performance.• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.• Partitioned the fact tables and materialized views to enhance the performance.• Extensively used bulk collection in PL/SQL objects for improving the performing.

• Created and maintained PL/SQL scripts and stored procedures.• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures.• Created and modified SQLPlus, PL/SQL and SQL Loader scripts for data conversions

• Developed web-based dashboard applications for monitoring the server related statistics using charts to enable analysts to perform targeted customer analysis.• Analysis, design, development and implementation of customized solutions for new implementations.