Safety Manager
Resume:
Pawan Kumar Sharma
916-***-****(Mobile) ********@*******.***
PROFESSIONAL SUMMARY
PMP Certified (October 2011) with 19+ years of IT experience
* *** ********** ** **** Safety products (Oracle Argus Safety/ Oracle Argus Insight/Empirica Signal Detection) and part of development team in Relsys and Oracle India
Manage and Lead development team for Argus Safety Service packs and Argus Insight 6.0
Experience in Oracle Argus Safety 4.1 (Single-Tenant) to 7.x (Multi-Tenant) (Case Processing, Workflow, Configuration, Interfaces, Console, AG Service, ESM modules)
Extensive experience with E2b reports including and not limited to E2b Plus, extensions and adhoc/aggregate reporting
In-depth knowledge of Argus Safety technical architecture and database modeling
Experienced in Business Configuration (Product/Study/License, Reporting Rules) and System Configuration in Argus Safety Console
Experienced in configuring AG/ESM/E2B (R2/R3) profiles (with customization) and Axway Interchange gateway for electronic submissions using AS1.0 and AS2.0 protocols
Managed Application Support and Infrastructure support with Vendor management for Argus Safety
Experienced in MedDRA/WHO loading and up versioning
Experienced in Cognos integration with web application using Cognos SDK in Argus Insight 7.0
Expertise in Oracle Empirica Signal Detection 7.3
Experienced in authoring/and executing test cases (OQ, IQ and PQ) manual or automated tool (HP Quality Center)
Strong experience in windows/web applications Design, Development and Maintenance using ASP, VB 6.0, ASP.NET, ADO.NET, C#, VB.NET, JavaScript, AJAX, IIS, XML, Oracle 9i/10g/11g and SQL Server 2000/2005.
Strong experience in client interaction with onsite experience in USA, Japan, Singapore and Holland.
Experience in High Level and Low-level Design Architecture using UML (use case identification, use case diagram, Sequence Diagrams, Class identifications and class diagrams, activity diagrams), along with Data base Designing.
TECHNICAL SKILLS
Technologies : ASP, VB 6.0, ASP.NET, C#, VB.NET, ADO.NET, ASP, AJAX, WSDL,
XML, SOAP, XSD, XSLT
Web Development : HTML, DHTML, XHTML, CSS, jQuery, Java script
Languages : Python, C#, VB.Net, VB 6.0, PL/SQL, Sql plus, TSQL
Distributed Technologies : COM, DCOM, MS Web services, XML, Remoting, MSMQ
Operating Systems : Windows - 2000/NT/XP/2000/2003/2008, HP-Unix 10.0
Databases : Oracle 8i/9i/10G/11G, SQL SERVER 2000/2005
Web Server : IIS 4.0/5.0/6.0/7.0, Apache Tomcat
Reporting Tool : Crystal Reports 8.5, Cognos 8.4
Version Control : Microsoft Visual Source Safe, SVN, SOS
Design Patterns : MVP, MVC, Abstract Factory, Facade, Singleton, Observer
3rd Party Libraries/Tool : NumPy, Pandas, MetplotLib, Seaborn, Tableau
ML Algorithms : Linear/Logistics Regression, SVM, KNN, NLP
PROFESSIONAL EXPERIENCE
Argus Safety
Client Name: Pfizer
Organization: Resource Logistics
Environment: Argus Safety 7.0.7
Role: IM Lead (Onsite)
Duration: Jan 2018 – Till Date
Project Description
Supporting Oracle Argus 7.0.7 Business configuration in Pfizer. Support scope consist Reporting Rules, Code Lists, eCBD and managing change controls day to day.
Responsibility:
Managing change controls for Argus Safety (Business Configuration, E2B)
Managed and automated eCBD (electronic configuration baseline documents)
Managed Reporting Rules reverse engineering (queries to populate excel) and provided for Audit requests/or Business
Empirica Signal Detection Implementation
Client Name: United Therapeutics
Organization: Resource Logistics
Environment: Empirica Signal Detection 7.3 / Argus Safety 7.0.5 / Argus Mart / ODI
Team Size: 6
Role: Technical Lead/SME (Onsite)
Duration: Apr 2018 – Aug 2018
Argus Safety
Client Name: Otsuka
Organization: Resource Logistics
Environment: Argus Safety 7.0.4
Team Size: 15
Role: Safety Data Manager (Onsite)
Duration: Oct 2015 – Jan 2017
Project Description
Supporting Oracle Argus 7.0.4 system in Otsuka. Support scope consist configuration/enhancement and handling day to day issues.
Responsibility:
Managing change controls for Argus Safety (Configuration, Interfaces and E2B)
Managing Argus infrastructure
Handling TransformPV tool (eMDR - E2B R2-R3 transformation engine), developed by Vitrana
Handled Argus Safety Performance issues
Empirica Signal Detection Support
Client Name: Pfizer
Organization: Infosys Ltd.
Environment: Empirica Signal Detection 7.3 (PL/SQL, Bash Shell Scripts) / Argus Safety 4.2, 7.0.3.004
Team Size: 30
Role: Technical Lead (Onsite)
Duration: Mar 2013 – Oct 2015, Jan 2017 – Jul 2017 (From Resource Logistics)
Project Description
Supporting Oracle Empirica Signal Detection 7.3 and Argus 4.2/7.0.3 system in Pfizer since March 2013. Support scope consist configuration/enhancement and handling day to day issues. Pfizer has out of box customization that integrates clinical and safety data from different source systems to Pfast (Pfizer custom Database ware house). Empirica Signal Detection uses Pfast dataware house as source system for company database and generates signals (using Signal Preparation Job).
Responsibility:
Day to day co-ordination with Client
Managing technical change controls for Empirica Signal Detection and Argus Safety (Configuration, Interfaces and E2B)
Monitor/Debug/Fix weekly Empirica ETL/Signal Preparation Job (SPJ)
Implemented enhancement (custom term and updated SPJ code) for Signal Views in Empirica
Single Point of contact for Empirica
Member of Argus 7.0.3 Deployment team (AG Service/ESM Service configuration, E2B Profiles setup)
GSIP Reporting
Client Name: Merck Research Laboratory Technology
Organization: Cognizant Technologies
Environment: Argus Safety 6.0 (Safety and DLP), Cognos 10, Spotfire
Team Size: 10
Role: Project Manager (Onsite)
Duration: Mar 2012 – Mar 2013
Employer: Cognizant Technologies
Project Description
Merck Research Laboratory Information Technology has undertaken an initiative to outsource the development and testing of ad-hoc/custom reports, building custom advanced conditions and execution of front end reports in order to effectively service/support the business unit to respond to Health Authority enquires, audit, adhere to aggregate and expedites reporting requirement.
Responsibility:
Day to day co-ordination with Client
Project Planning
Argus SME
DMWT (Clinical Supply)
Client Name: Fisher Clinical Services
Organization: Cognizant Technologies
Environment: SQL Server 2008, SSIS, Team Foundation Server, XML
Team Size: 10
Role: Validation Lead (Onsite)
Duration: Nov 2011 – Mar 2012
Employer: Cognizant Technologies
Project Description
FCS has requested Cognizant to implement an in-house DMWT at FCS, containing data from Cenduit SIRT and the FCS inventory or transferring of data to Novartis (FCS’s Client Pharmaceuticals that has requested the end-to-end visibility of clinical supplies). Currently there is no single system which can provide data extracts to NOVARTIS for drug accountability from patient level to drug/product substance. DMWT is to provide information not only for drug accountability but also for other data extracts related to the studies carried out for NOVARTIS.
Responsibility:
Developed Validation Plan/Test Strategy and co-ordination with Client.
Offshore validation team handling
Reviewed OQ scripts
Developed IQ script
PRIMO
Client Name: November Research Group
Organization: R-Systems Inc.
Environment: XML, XSLT, Oracle 11g
Team Size: 4
Role: Developer
Duration: Jul 2011 – Oct 2011
Employer: R-Systems Inc.
Project Description
PRIMO is streamlined data capture system for adverse events, pregnancy registry, and product complaints. PRIMO complements and extends your existing pharmacovigilance system by providing a unified data intake mechanism from your call centers, safety data management organizations, affiliates and partners.
Responsibility:
Synched the data entry report with the user interface.
Developed audit log report
Installation and IQ for Argus Safety 7.0 multitenant
Wave III
Client Name: Genzyme (Boston)
Organization: R-Systems Inc.
Environment: Cognos 8, Oracle 10g
Team Size: 3
Role: Developer
Duration: Mar 2011 – Jun 2011
Employer: R-Systems Inc.
Project Description
Wave III project consists 6 custom reports build on Argus Insight data mart. These reports help users to analyze the critical data before submitting to FDA.
Report Name
PSUR Cumulative Summary
Periodic QC Report
Periodic QC Labeling Assessment Overrides
Periodic Tabulation of case counts
Periodic Tabulation of event counts
Periodic Tabulation of all cumulative data (standard report)
Submissions to the FDA(Drug/Device) by License ID QC Report
Responsibility:
Client interaction to identify the user requirement
Developed technical design document for reports
Developed complex reports (cross tab)
Writing IQs for all reports
Argus Insight 7.0
Client Name: Oracle India
Organization: Oracle India
Environment: ASP 3.0, ASP.Net 2.0, Oracle 11g, Net Framework 3.5 Microsoft Visio 2007, Cognos 8.4
Team Size: 14
Role: Development Manager
Duration: Sep 2010 – Jan 2011
Project Description
The current focus and theme of the Oracle suite of Safety and Pharmacovigilance products is the enablement of the CRO. CROs are enjoying a significant growth as pharma companies move to conserve costs and gain operational efficiencies. As such, AI must be enhanced to serve the CRO market with a multi-tenant application.
Responsibility:
Involved in Client Interaction (Product management group and Product strategy group) for new roadmap of Product
Identifying the changes in reporting module due to multitenant architecture
Developed technical design document for reporting module
Integrated ASP/.Net application with Cognos using SDK
Code reviews
Argus Insight 6.0
Client Name: Oracle India
Organization: Oracle India
Environment: ASP 3.0, ASP.Net 2.0, Oracle 11g, Net Framework 3.5, Microsoft Project Plan 2007, Microsoft Visio 2007, Business Objects XI, Cognos 8.x
Team Size: 7
Role: Development Manager
Duration: Dec 2009 – Sep 2010
Project Description
Argus Insight, formerly called Power Reports is a highly optimized reporting module that compliments Argus Safety. The Argus Insight Extract Transfer and Load (ETL) engine extracts data from the Argus Safety database and populates a data warehouse in a format that allows efficient querying. The various query, drill down, and output components of Argus Insight let you analyze your safety, workflow, or product data from all angles and produce reports that provide immediate business impact and maximum efficiency in decision making.
Responsibility:
Involved in Client Interaction (Product management group) for new Product features
Managed Project Plan (Scheduling, Monitoring & Controlling, Communication) using Microsoft Project 2007
Involved with design team and participated in various design approaches
Handled virtual team
Code reviews
Interaction with Oracle performance team
Argus Safety (4.1, 4.1SP3, 4.2)
Client Name: Relsys International (Acquired by Oracle)
Organization: Relsys India Pvt Ltd.
Environment: ASP, VB 6.0, C++, Power Builder, Oracle, Net Framework 2.0
Team Size: 6
Role: Tech Lead / Project Lead
Duration: March 2005 – Apr 2006
Product Description
Provide visibility of strategic data across the enterprise and a focal point for all core business activities
Provide focus on key, statistically significant data that would be difficult to uncover without the proper automated tools, solving the need for data insights that manual processes alone cannot accomplish
Explore, compile and analyze known data, solving the need for product, event and productivity knowledge to enable key business decisions to be made
Manage regulatory compliance needs, improve case workflows, and enable the exchange of core data with other systems, thus solving compliance and data management needs
Responsibility:
Delivered Argus Safety 4.1 SP3 service pack
Handled Argus Safety Database
Created PL/SQL stored procedures
Testing / Implementation
Design team member of Console Conceptualization and developed POCs
Novo Nordisk Data Cleanup Project
Client Name: Novo Nordisk
Organization: Relsys India Pvt Ltd.
Environment: Oracle, PL/SQL
Team Size: 3
Role: Tech Lead / Project Lead
Duration: Oct 2005 – Nov 2005
Product Description
The configuration of product families, products, licenses and datasheets in the Novo Nordisk global safety Argus Safety database has been updated in the past to incorporate new business needs and newly defined standards which has created a need to realign the data in Argus Safety with this new configuration.
A first ‘cleanup’ project called phase I has been performed which has restructured configuration and case data for product families, products, datasheets and licenses.
A second ‘cleanup’ project called phase II, which is the subject of this project, is required in order to continue this restructuring according to specific requirements and in order to correct also a few shortcomings of phase I with regards to configuration and case data. The goal is to achieve a fully coherent Argus database and application with none of the functionalities (such as expedited reports scheduling and generation of follow-up reports) being hindered by any side-effects of the restructuring of the configuration data
Responsibility:
Developed PL/SQL scripts to clean up the business configurations (products, product families, datasheets, licenses)
Testing / Delivered
Easy Trak Web
Client Name: Relsys International (Acquired by Oracle)
Organization: Relsys India Pvt Ltd.
Environment: .Net Framework 1.1, ASP.Net, C#, ADO.Net
Team Size: 15
Role: Tech Lead
Duration: Feb’ 2004 – Jan ‘2005
Product Description
EasyTrak™ has set the standard for medical industry complaint handling systems. It not only helps manufacturers of medical devices, drugs and biologics respond to customer complaints, but also assists in the proactive development of corrective action plans. With a single keystroke, EasyTrak™ can provide data to help you analyze trends and identify the root cause of an event. It is this type of automation within EasyTrak™ that takes the worry out of regulatory compliance.
Responsibility:
Analysis and Requirement gathering using UML methodology
Developed CAPA module (Corrective action and Preventive action), Configuration, List Maintenance using ASP.Net 1.1
Used Infragistics (3rd party) control
Created PL/SQL stored procedures
Testing / Implementation
EDUCATION
Graduation: Bachelor’s in science (Math’s)
Certification(s)/ Others: 2 yr. Advanced Diploma in System Management from NIIT in 1997. Certificate in Oracle Developer 2000 from SQL* International in 1997.
Pursuing M.Sc. (IT) from Amity University
Certified PMP
Informatica 8.6 training from Aroha Technologies
Post Graduate Diploma in Clinical Research and Pharmacovigilance from ICRI
Machine Learning certificate from Coursera
Contact this candidate