SUMMARY

• Over 15 years of IT experience including Oracle Database Administration and Oracle Development along with significant expertise in the wireless, Pharma/CRO and IT industries
• Expertise in Oracle Database clinical - related applications: Oracle Clinical 4.6/4.5, Clintrial, TrialDB, OpenClinica, ClinCapture in Good Clinical Practice (GCP), regulated environment and ITIL Configuration Management Database System (CMDB), Oracle 12c/11g/ 10g / 9i / 8i / 8 database designing, development and administration
• Expertise in back-end programming using SQL and PL/SQL, application tuning, database performance tuning, backup & recovery, up-gradation & managed migration issues on production and development environment.
• Experience on RDBMS concepts as well as worked on OLTP, ETL and Data warehouse environment and worked on logical and physical data models.
• Proficient in data management, massaging, manipulation and validation techniques, generation of listings tables and figures, handle very large datasets, and univariate statistical techniques - Survival analysis, analysis variance, regression and correlation.
• Excellent team work and solid communication skills.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr. Oracle Developer

Responsibilities:

• Used PL/SQL to create Packages, Functions, and Procedure for user/data validation, request and response.
• Used PL/SQL and SQL*Loader to load data from source file and triggers.
• Involved in testing CMDB application for Oracle 10g to 11g to 12c upgrade. Involved in applying Oracle patches.
• Worked on generation of scripts for creation of tables, indexes, views, synonyms, grants, roles and privileges.
• Created indexes to improve performance and Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.
• Developed test cases for user acceptance testing and unit testing.
• Perform technical analysis, design, coding, unit testing and problem resolution.
• Involved in topcustomer derivation using Global Customer Hierarchy (GCH) golden gate tables. Developed process to identify changes in GCH data and update topcustomer according to changes made in GCH system.
• Involved in developing process to synch CMDB data based on ESP golden gate tables using XML triggers. For loading data in CMDB from XML trigger XML is parsed and loaded in staging tables.
• ETL/ELT: Using ODI and Custom Packages CMDB extract data from various source like ESP, FE, OMPlus, SPIM, PQ, OTS, GCH via golden gate, XML trigger, CSV files etc. Transform them in staging tables based on requirements and finally load to CMDB INVENTORY REPORT table for various system use for SMR (Service Management Reporting), ETMS, iRepair, SMD (Service Management Dashboard) etc.
• Working on CMDB/EIS project development by following agile methodology.
• Doing requirement analysis and effort estimation and tracking the same using JIRA.
• Doing ICD document review for understanding requirement change and doing impact analysis with other upstream/downstream systems.
• Participating in discussion with BA to prioritize User Story development for the sprint.
• Doing User Story requirement developmentin two weekssprint time.
• Participating in daily status call with onshore/offshore team to discuss work progress.
• Helped refine and determine feasibility, correctness, and completeness of end-user's requirements.
• Developed high level design documents for reporting and analysis projects.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Created numerous executive level reports. Multiple Dashboards were generated to provide insight into the financial data.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created different types of Customized Reports Drilldown, Dimensional hierarchies, Aggregation to meet client requirements.
• Built Business model and established relationships, created joins & Foreign Keys Physical & Logical between tables. Created Time-series function.
• Utilized OBI reporting features (Navigational, Drill Down, Drill Across, Guided Navigation, and Security etc.).
• Used existing data from Oracle EBS for analysis.
• Compared data from Oracle EBS with the OBIEE for data validation.
• Integrated BI Publisher with OBIEE. Created Excel Templates such as Shareholder's Equity report, Reports such as Deposits over quarter/year in BI Publisher.
• Schedule reports and bursting as per the requirement in BI Publisher and represented them in OBIEE dashboards.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Added users and configured security in web logic console of OBIEE 11g.
• Worked as production support for the various reports/Dashboards. Provided performance-tuning queries.
• Responsible for defining the strategies for merging, code quality, defining the backup, archival plans, check-in automation which helped in designing and deploying best Source Code Management procedures and processes.
• Worked with different teams to resolves the issues raised and to discuss about multiple software releases which were held as according to Agile processes.
• Involvement in architecture of DevOps platform and cloud solutions.
• Implemented a continuous delivery framework using Jenkins, Maven, Chef and Nexus in Linux environment.
• Developing serverless code using Lambda and Dynamodb.
• Designing the application layer of the product with EC2, RDS, and Elastic Cache, and configuring AWS Cloud Watch for application monitoring, notifications and alarms.
• Developed scripts using Perl, Python, Shell and Bash for the automation of the build and release processes and developed custom scripts for server storage and to monitor the repositories.
• Setup and maintenance of automated provisioning environment using Chef Recipes & cookbooks within AWS environment. Deployed Linux and Windows servers on AWS EC2 using Chef.

Confidential, Exton, PA

Sr. Oracle Clinical Application & SAS Programmer

Responsibilities:

• Used PL/SQL to create Packages, Functions, and Procedure for data validation and cleaning.
• Used PL/SQL and SQL*Loader to load lab data file loading into Oracle Clinical.
• Involved in testing the application for Oracle 9i to 10g upgrade.
• Worked on generation of scripts for creation of tables, indexes, views, synonyms, grants, roles and privileges.
• Created indexes to improve performance and developed test cases for user acceptance testing and unit testing.
• Perform technical analysis, design, coding, unit testing and problem resolution.
• Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.
• Created Oracle/SAS views for data extracting from Oracle to SAS for Tables and listings.
• Responsible for designing and validating new studies by creating and maintaining GLIB objects like Question, Question Group, DCI, DCM and DVG.
• Responsible for Assigning Sites, Investigators to study and create new patient positions.
• Responsible for the ongoing review and clean-up of all data generated from the clinical study including central and local lab data and encoding. Uploading lab data, PK data from ASCII file to appropriate study.
• Responsible for developing and writing validation and derivation procedures as per study validation document provided by Data management team.
• Provide statistical programming expertise in the production of analyses, tabulations, graphics, and listings from clinical trial data.
• Contribute to the preparation of analysis plans.
• Prepare, document and test required programs and procedure data displays in an efficient manner for inclusion in integrated clinical, statistical reports and other similar reports.
• Contribute to the integrated clinical/statistical report and other similar documents.
• Ensure analysis data and programming code meet regulatory and company standards and are consistently structured to permit efficient programming and reporting.
• Worked on CDISC SDTM and eCTD module 5 case report tabulations.
• Perform quality assurance procedures on work performed by others.
• Develop, test, validate, document, maintain and execute software and/or systems using the currently endorsed tools or support of production activities.
• Responsible for XML data submission to FDA’s SOA platform and eCTD guidelines.

Confidential, VA

Database Administrator

Responsibilities:

• Install and Customize Production, Development and Test Database for Active Health CareEngine with Installation Qualification, Operation Qualification and Performance Qualification.
• Configuration and maintenance of Production, Development and Test Database server & client-server communication.
• Prepared Backups and Recovery strategies to minimize data lose and system down time for production database. Maintain and verify backup using Recovery Manager (RMAN) and Recovery CATLOG.
• Responsible for monitor, maintain, verify, optimize Performance and fine tuning of Database.
• Responsible for designing electronic Case Report Form (CRF) for new studies, annotating CRF to map data object configuration, creating data extract views for SAS table and listings, GLIB object creation and maintenance, preparing study design validation documentation.
• Responsible for the Content Rollout, Assessment Rollout, Third Party codes like ICD9, CPT, DRG, HCPCS, LOS, Medication code rollout using SQL*Loader in staging tables and then update original code tables based on business policies.
• Responsible for installing MEDDRA and WHODRUG data dictionary upgrade.
• Managed end user requirements like user security and Privileges management, automated job scheduling, Network Communication issues etc.
• Performing Data conversion from ORACLE database to MS SQL Server for new .net application using DTS.
• Cloning of production environment into development/test environments on a regular basis.
• Managed Database accounts & resource management including security.
• Responsible for analyzing and applying Oracle database patches and revalidate system after patch updates.
• Database and SQL Tuning using Statspack, PL/SQL Developer, Toad, SQL Analyze, Explain Plan etc.
• Writing back-end PL/SQL Procedures for validating, uploading and deriving data.
• Given support to Development Teams on SQL Tuning and other Oracle related problems.
• Automated Oracle Export Backup through Shell scripting & Cron Job.
• Implemented e-signature software to comply 21 CFR Part 11 and strict quality standards to comply GCP regulations and guidelines.

Confidential, Dulles, VA

Development & QA - Database Administrator

Responsibilities:

• Install, Configure, Customize and Maintain QA and Development Environment Database Servers.
• Writing the SQL and PL/SQL code for data conversion/derivation and validation.
• Writing Unix shell script to automate the jobs.
• Backups at regular interval of both Development and QA Databases.
• Generating BLT status report and resolving the database related issues.
• Verifying the data extracted in CSV flat file as per the TRD/SDD document by loading them in test environment.
• Helping QA testers for their code testing by providing their required data entered through back-end directly for their various testing requirements.
• Reorganizing tablespaces and indexes in times of low activity.
• Automating routine activities through Cron.
• Doing routine UNIX administration activities like creating users, granting privileges and managing security issues.
• Writing database triggers and packages wherever needed to bring Modularity.
• Tuning of queries using explain plan and TKPROF.

Confidential

Database and System Administrator

Responsibilities:

• Install, Configure, Customize, Upgrade and Maintain Development and Production Database for Clinical Database Management System (CDMS) with IQ/OQ/PQ to comply GCP regulations and guidelines.
• Managed the Upgrade of Oracle 9i database to Oracle 10g database.
• Provided Critical Patch Update (CPU), security alerts analysis and guidance support using Oracle Metalink, apply and validate updates as per requirements.
• Responsible for deciding Backup and Recovery procedure strategies. Maintain and verify backup and recovery procedures accordingly.
• Responsible for designing and creating new studies in TrialDB including eCRF design and data object configuration, creating and maintaining Global Library objects and verifying SAS data output using data extract views.
• Responsible for writing validation, derivation and lab data upload procedures using SQL and PL/SQL.
• Responsible for the ongoing review and clean-up of all data generated from the clinical study including central and local lab data and encoding.
• Responsible for the activities necessary for database finalization and adhering to the timelines established by the study team.
• Custom and standard Report generation for client’s need and project management purpose.
• Create and maintain all study documentation on secure web portal.
• Responsible for MEDDRA, COSTART and WHODRUG dictionary version upgrade.
• Interact with study team members to define the necessary listings needed for the support of data clean-up, population acceptability criteria, and summary tables.
• Managed to maintain, optimize, tune and verify Performance of Database using various performance tuning tools like Statspack and third-party tools.
• Handled end user requirements like user security and Privileges management, Request scheduling, Network Communication issues etc.
• Managed Printers, Scanner and other network devices.
• System Administration activities like Installation, configuration and maintenance of Network Operating System and Computer & Peripheral Hardware equipments.

Confidential

Database Administrator

Responsibilities:

• Install, Configure, Customize and Maintain Development and Production Database for Laboratory Information Management System (LIMS) with IQ/OQ/PQ.
• Configuration and maintenance of Database server, Tomcat server & client-server communication.
• Responsible for daily Backups of both Development and Production Instances. Restore and recover data on development system to verify Backup at monthly bases.
• Configured standby database for high availability of data if primary server and maintenance of standby database.
• Provided Critical Patch Update (CPU), security alerts analysis and guidance support using Oracle Metalink, apply and validate updates as per requirements.
• Wrote SQL*Loader control files for uploading Lab data generated by RT-PCR and Lab equipment.
• Allocating system storage and planning future storage requirements for the database system.
• Modifying the database structure, as necessary, from information given by application developers
• Creating primary objects (tables, views, indexes) once application developers have designed an application.
• Enrolling users and maintaining system security. Controlling and monitoring user access to the database.
• Monitoring and optimizing the performance of the database.