RESEARCH DATA ADMINISTRATOR TECHNICAL LEAD/TECHNICAL ANALYST/TRANSITION LEAD
Accomplished Information Technology Professional currently working at a global pharmaceutical company for over 15 years with extensive experience in software development in all phases of development from requirements gathering and analysis to design, development, testing, implementation and support. Leverage passion, computer science background, and tenacious problem solving capabilities to develop innovative solutions. Worked in agile, high performance organization, designing and upgrading business solutions, using cutting edge tools and systems.
*AREAS OF EXPERTISE
Custom Software Development * Configuration Management* Release Management* Team Leadership* Testing/QA/Rollout and Hyper care* System Migrations/Integrations * Data Modeling *Problem Solving* Resource Management* System Migrations/Integrations * OLTP* OLAP * Database/Data warehouse Design* Data Integrity *New Technology Evaluation* Change & Release management* Data Replication. *Discovery and Preclinical IT
Tools/Framework: ERWIN, Oracle Designer, SQL*Navigator, SQL Developer, Todd, Remedy, MS Office, Subversion, JIRA, All Fusion-ERWIN Data Modeler, Chemcart
Enterprise Content Management: SharePoint 2010
Methodologies: Agile/Scrum, Waterfall, SDLC
PKIMay 2015 to CurrentResearch Data Administrator Technical Lead/Technical Analyst/Transition Lead
Lead the execution of the assigned PCB-IT/MRL development projects and delivery of the organization's software products to QA, and ultimately Production as per the SLA.
Ensure normal functioning of metadata registration; data capture and project query tools.
Interfaces with key MRL scientists to capture and write requirements for new computer applications/ tools that are necessary to support their research project(s).
Provides training and knowledge transfer to newly hired Prague IT staff as it relates to the utilization of all data management tools and timely resolution of day-to-day issues arising from drug discovery programs or key IT tools.
Provide hands-on development and mentoring as necessary for peer global support services teams on business related IT dependencies and associated issues.
Work with the Enterprise Architect, PMs, and Product Managers to sequence/coordinate development activities and also ensure that best practices for coding, architecture, and security are employed across the teams consistently.
Project Lead on ELN deployment/adoption in AWS cloud across Merck CROs.
Merck & CoJune 2008 to May 2015Sr. Technical Analyst/ IT Lead
Led upgrade of several applications in Discovery and Preclinical Area.
On a major multi-year Discovery and Preclinical Services Platform Upgrade project consisting of upgrade of Discovery Biological, Chemical and High Throughput Screening data warehouses, led a team of developers and DBAs for successful migration and upgrade of Oracle 10g from Solaris platform database to Oracle 11g on RH Linux platform and remediation of 60 plus client apps; led evaluation/implementation of a AEP 9.0 cheminformatics tools; minimized application downtime by 30% by introducing parallel task execution model ; avoided Oracle partitioning licensing cost of 350K and implemented performance tuning that yielded greater performance than the partitioned tables.
Led & implemented information security enhancements to protect company's information asset including Oracle11g TDE Data Encryption, Oracle FGAC to build virtual private databases (VPD), Fine Grain Auditing (FGA); custom obfuscation tools to mask the identity of the company's proprietary data.
MerckApril 2003 to May 2008Sr. Application System Analyst
Led design/development/implementation of a registration system for registering biologic materials focused on RNAi (siRNA, ssRNA, miRNA) and mixed moieties; Revamped existing Oracle DB model by remodeling it from EAV (Entity-Attribute-Value) model to relational data model.; Performed data migration of legacy RNA data into the new system and decommissioning of legacy databases and creation of the new databases.
Led the technical implement ion of the next generation enterprise chemistry tools Symyx Direct 6.0 Cartridge for Merck scientists; implemented of new commercial databases; upgraded Merck Chemical DBs and remediated number of cartridge dependent applications.
Designed & developed a database of the biologic registration system for the storage and request of frozen biological samples within Merck It gave an ability see if a specific sample exists within the company , or to determine the storage location for a sample that was already frozen.
As part of on implementation of a multi-year global research program to transition from Ariba inventory and PeopleSoft HR systems into SAP and further integrate them with the downstream consumer applications, led a team of developers for remediation of all downstream applications.
MerckAugust 1999 to March 2003System Analyst
Designed, developed and managed custom home grown OLTP and OLAP systems and ETL tools to populate and refresh a Discovery Biological and Chemical Information data warehouse - 1) PL/SQL Upload Engine for Assay Data Upload 2) PL/SQL Summary Engine to summarize assay results and 3) custom PL/SQL Merck home grown data-mart creation engine named to create and refresh project and assay specific data marts for use by scientists.
Set up and maintained experimental/chemical database replication to multiple remote sites in EU and Japan.
Oracle Performance of tuning-SQL and PL/SQL tuning and performance optimization Designed and developed a Registration and Tracking System for Oligonucleotides for Pharmacology to create an oligonucleotide design and supply service for Merck scientists.
It provided a custom Oracle data base and software application for the management of oligonucleotide registration, mapping of oligonucleotide samples to plates and microarray slides, recording storage locations of those containers, and tracking experimental data on oligonucleotide ratings in order to evaluate the usefulness of the samples over time.
Designed and developed Registration and Management System to create cDNA design and supply service for MRL scientists.
BR cDNA provides a custom Oracle data base and software application for the management of DNA clone registration, mapping of clones to plates and nylon web, recording storage locations of those containers, and tracking experimental data in order to evaluate the usefulness of the samples over time.
University of MichiganMS: Computer ScienceComputer Science
Bachelor of EngineeringIndia
Agile, Architect, Auditing, C, C++, chemistry, clones, computer applications, Content Management, Encryption, client, data management, data migration, data warehouse, data warehouses, Data Bases, databases, data base, database, delivery, DNA, downstream, ERWIN, ETL, HR, information security, inventory, Linux, materials, mentoring, MS Office, SharePoint, migration, Enterprise, Navigator, next, OLAP, optimization, Oracle, Oracle DB, Oracle Designer, Developer, Oracle PL/SQL, PL/SQL, PeopleSoft, Pharmacology, Pro*C, coding, Programming, Project Lead, QA, recording, research, SAP, Scrum, SDLC, SLA, Solaris, SQL, SQL Server, tables, UNIX Shell, Upgrade