$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
monica rathi
,
, United Kingdom
Experience
Other titles
Skills
I'm offering
Markets
United Kingdom
Language
English
Fluently
My experience
2020 - 2021
job
Manage the project related ESA activities
Abbvie Inc.
❑ Creating SOW and amendments
❑ Financial tracking -invoices
❑ Follow the project process, resource managements(onboarding & offboarding)
❑ Create Projects- Monthly utilization reports for monthly review meeting
❑ Project forecasting
❑ Handle the internal project audits
❑ Financial tracking -invoices
❑ Follow the project process, resource managements(onboarding & offboarding)
❑ Create Projects- Monthly utilization reports for monthly review meeting
❑ Project forecasting
❑ Handle the internal project audits
Forecasting, Onboarding
2015 - 2019
job
Mentor and guide the PATs
ABBV RnD eClinical ODS Impl.
Duration Mar-2015 to Jun-2019
Technology Unix, Informatica 9.1 ,Oracle
Project Abstract
Abbvie's eClinical Strategy aims to design, develop, test and deploy an operational data warehouse that serves as the foundation on which Abbvie R&D can make informed decisions based on easily accessible, centralized data collected from the various systems in their clinical and data management application landscape (as well as information collected from Abbvie's third-party vendor applications, such as Clinical Research Organizations).
The ODS will provide the ability to sustainably support the increased scale of trial activity along with reporting and advanced analytics to ensure business decisions are made on accurate and up-to-date information.
The ODS platform will be delivered in stages that provides incremental business value enabling business and technical capabilities..
Role
❑ Worked on Landing & Staging mapping development.
❑ Full ownership and responsibility for task planning, Preparing detailed design in accordance with requirements and specifications and on-time delivery.
❑ Writing the program code (Procedures) to create the mappings and sessions in accordance with requirements.
❑ Created source to target mapping, edit rules and validation, transformations, and business rules.
❑ Writing SQL's used in Source Qualifier queries and Lookup override queries.
❑ Responsible for testing, validation and reviewing of ETL transformation specifications on the input data before loading into target database, based on business requirements.
❑ Reviewed the Business Requirement Document to understand the process and write Test Scenario and Test cases.
❑ Effective communication with testing teams to resolve the defects.
❑ Provided weekly status report to Project Manager and clients and discussed issues related to quality and deadlines
❑ Monitor all production issues and inquiries and provide efficient resolution for same.
❑ Help team members for better project understanding in both technically and domain terms.
❑ Mentor and guide the PATs.
Technology Unix, Informatica 9.1 ,Oracle
Project Abstract
Abbvie's eClinical Strategy aims to design, develop, test and deploy an operational data warehouse that serves as the foundation on which Abbvie R&D can make informed decisions based on easily accessible, centralized data collected from the various systems in their clinical and data management application landscape (as well as information collected from Abbvie's third-party vendor applications, such as Clinical Research Organizations).
The ODS will provide the ability to sustainably support the increased scale of trial activity along with reporting and advanced analytics to ensure business decisions are made on accurate and up-to-date information.
The ODS platform will be delivered in stages that provides incremental business value enabling business and technical capabilities..
Role
❑ Worked on Landing & Staging mapping development.
❑ Full ownership and responsibility for task planning, Preparing detailed design in accordance with requirements and specifications and on-time delivery.
❑ Writing the program code (Procedures) to create the mappings and sessions in accordance with requirements.
❑ Created source to target mapping, edit rules and validation, transformations, and business rules.
❑ Writing SQL's used in Source Qualifier queries and Lookup override queries.
❑ Responsible for testing, validation and reviewing of ETL transformation specifications on the input data before loading into target database, based on business requirements.
❑ Reviewed the Business Requirement Document to understand the process and write Test Scenario and Test cases.
❑ Effective communication with testing teams to resolve the defects.
❑ Provided weekly status report to Project Manager and clients and discussed issues related to quality and deadlines
❑ Monitor all production issues and inquiries and provide efficient resolution for same.
❑ Help team members for better project understanding in both technically and domain terms.
❑ Mentor and guide the PATs.
Analytics, Platform, Manager, UP, Guide, Production, Development, Testing, Advanced Analytics, Support, Transformation, Test cases, Test, Technology, Design, Management, Data Warehouse, Mentor, ETL, R, Database, Data management, Unix, Research, Oracle, Writing, Project Manager, Sql
2011 - 2015
job
Oracle Clinical 4.6, PLSQL Developer and Windows 7
Novartis (Cognizant).
Project Abstract To design and build a clinical database which maintains clinical trial information.
Role
❑ Setup study database in accordance with global standard in support clinical trial
❑ Program and test Study Specific data Validation and Derivation Procedures
❑ Provide Study Specific Support to the Data Management Team
❑ Extensive experience in maintaining the Global Library, creating questions, question groups, DCM and DCIs.
❑ Worked with other team members in creating analysis datasets, discrepancy analysis and in reviewing the case report forms as needed. Currently I am working on post-production clinical trials.
❑ Impact analysis for the post production changes in database.
❑ Ensures high quality deliverables by providing senior review of study level/program level/multi study core deliveries for accuracy.
❑ Provides leadership, training, guidance, and support to other department members based upon expertise in specific skill sets. Collaborates with clients, peers, lead programmers, project teams, and/or requestors to clarify and finalize specifications; uses expanded technical skills to meet evolving project needs.
Novo-nordisk
Role
❑ Setup study database in accordance with global standard in support clinical trial
❑ Program and test Study Specific data Validation and Derivation Procedures
❑ Provide Study Specific Support to the Data Management Team
❑ Extensive experience in maintaining the Global Library, creating questions, question groups, DCM and DCIs.
❑ Worked with other team members in creating analysis datasets, discrepancy analysis and in reviewing the case report forms as needed. Currently I am working on post-production clinical trials.
❑ Impact analysis for the post production changes in database.
❑ Ensures high quality deliverables by providing senior review of study level/program level/multi study core deliveries for accuracy.
❑ Provides leadership, training, guidance, and support to other department members based upon expertise in specific skill sets. Collaborates with clients, peers, lead programmers, project teams, and/or requestors to clarify and finalize specifications; uses expanded technical skills to meet evolving project needs.
Novo-nordisk
Design, Oracle, Training, Data management, Database, Leadership, Management, Windows, Test, Developer, Support, Production
2010 - 2011
job
Understanding and Identifying the requirements
unknown.
Duration May-2010 to Aug-2011
Technology Oracle Clinical 4.5, Toad 8
Project Abstract It was a CDM Project. To build database for clinical trials and perform the data validation activities.
Role
❑ Understanding and Identifying the requirements
❑ Creation of clinical trial study as per requirement
❑ Develop data entry screens (eCRF) and develop data validation and derivation checks
❑ Loading third party data files into database (Batch Data Load) using Toad.
❑ Writing SQL
❑ Participated in Client meetings, Reviews
Technology Oracle Clinical 4.5, Toad 8
Project Abstract It was a CDM Project. To build database for clinical trials and perform the data validation activities.
Role
❑ Understanding and Identifying the requirements
❑ Creation of clinical trial study as per requirement
❑ Develop data entry screens (eCRF) and develop data validation and derivation checks
❑ Loading third party data files into database (Batch Data Load) using Toad.
❑ Writing SQL
❑ Participated in Client meetings, Reviews
Sql, Writing, Oracle, Database, Technology, It
2009 - 2010
job
PLSQL Developer and windows XP
Startup Software Firm.
Project Abstract
EPPS is designed on oracle10g platform. Epps can be configured on 2/3 tier architecture thus can be used on intranet/internet, depending upon the business needs. This system includes following modules:
1)System Administrator, 2) Finance & Controlling, 3) Material Management, 4) Plant & Maintenance, 5) Sales & Distribution, 6) Product & Quality Management, 7) Human Resource Management, 8) Supply Chain Management. Within all above software modules, I am working on Material Management System & Sales System.
Role
Developing, Modifying Forms and Reports.
Creation of Database Objects like Tables, Views, Synonym, Sequence, Packages, Procedures, Functions and Triggers
Involved in analysis, design, coding and Testing.
Involved in modifying various existing packages, procedures, functions and triggers according to the new business needs.
EPPS is designed on oracle10g platform. Epps can be configured on 2/3 tier architecture thus can be used on intranet/internet, depending upon the business needs. This system includes following modules:
1)System Administrator, 2) Finance & Controlling, 3) Material Management, 4) Plant & Maintenance, 5) Sales & Distribution, 6) Product & Quality Management, 7) Human Resource Management, 8) Supply Chain Management. Within all above software modules, I am working on Material Management System & Sales System.
Role
Developing, Modifying Forms and Reports.
Creation of Database Objects like Tables, Views, Synonym, Sequence, Packages, Procedures, Functions and Triggers
Involved in analysis, design, coding and Testing.
Involved in modifying various existing packages, procedures, functions and triggers according to the new business needs.
Quality Management, Platform, XP, Administrator, Software, Internet, Testing, Developer, Supply Chain Management, Resource management, Design, Windows, Architecture, Controlling, Sales, Finance, Management, Supply chain management, Database
My education
n/a
Bachelors, Engineering
Bachelors, Engineering
monica's reviews
monica has not received any reviews on Worksome.
Contact monica rathi
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to monica directly in Worksome.
38000+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark