Engineer Clinical Research

Shipra Jain

Contact No: +1-669-***-****

Email: adgxml@r.postjobfree.com

** *** ****** *, *** Jose, CA - 95134

https://www.linkedin.com/in/shipra-jain-215aa723/

QUALITY ASSURANCE ENGINEER

Data Warehouse Testing OBIEE Report

Healthcare Domain (Supply Chain) ETL testing

I, a result-oriented professional with over 9 years’ experience in Software Quality Assurance in Healthcare domain. I have Insightful knowledge Data warehouse, Informatica and ETL testing on Technical side.I am Healthcare and Pharma knowledge which includes Supply Chain Management, Patient and Drug Life cycle.I have worked with Healthcare domain project for organizations like Astrazeneca, SANOFI, Quintiles(IQVIA now) etc. Seeking assignments in Testing (Siebel, PeopleSoft, Database, ETL & Manual Testing) and OBIEE Report validation as Test Lead/Senior Tester with a technology driven organization of repute.

Work Experience:

● Cognizant, Pune, March 2015 - Oct 2016

Associate

Client: SANOFI France

Report Testing (Study Related to Protocol)

Role: Leading team technically to build SQL test case framework. Complex SQL validation and writing joins, ensure data consistency and estimating test case execution and building QA plan for onsite coordinator.

Tools: SQL, Informatica, HPQC, ETL Testing

● Cognizant, Pune, Feb 2013 - Feb 2015

Associate

Client: AstraZeneca Amazon Global finance

Report Testing (Related to Investigator, Sites, Med, Payments) Role: ETL tester and Report tester. We have ODC model with AstraZeneca and I am responsible for ETL testing and report testing for same. AstraZeneca Amazon Global finance is huge data model which deals with sale, headcount etc. I have used Informatica tools to check mappings and SQL queries and HPQC for out testing and test case management.

Tools: SQL, Informatica, HPQC, ETL Testing

● Quintiles Technology, Bangalore, April 2012 - Oct 2012 Senior Testing & Validation Engineer

OBIEE Reports (Patients, Investigators, Sites)

Role: Clinical Trial Management System is a Siebel based application which has been developed for the client to manage their Clinical research activities and to Extract Data. Since this become one source of data being entered for all the clinical activities, there have being many downstream applications which consume data from this Siebel applications. In order to facilitate many interfacing systems between CTMS-CRM, CTMS-PeopleSoft, CTMS-ELVIS, CTMS-INNTRAX, CTMS to OBIEE etc have been developed using ETL tool have been developed. It also include data extracts in the form of flat file to the customers of Quintiles.

Tools: SQL, Siebel, PeopleSoft, OBIEE

● Ness Technology, Bangalore, March 2010 - April 2012 Senior QA Engineer

OBIEE Reports

Role: Clinical Trial Management System is a Siebel based application which has been developed for the client to manage their Clinical research activities and to extract data. Since this become one source of data being entered for all the clinical activities, there have being many downstream applications which consume data from this Siebel applications. In order to facilitate many interfacing systems between CTMS-CRM, CTMS-PeopleSoft, CTMS- ELVIS, CTMS-INNTRAX, CTMS to OBIEE etc have been developed using ETL tool have been developed. It also includes data extracts in the form of flat file to the customers of Quintiles.

Tools: SQL, Siebel, PeopleSoft, OBIEE

● Aptuit Informatics India Pvt. Ltd., Bangalore, June 2007 - March 2010 QA Engineer

Oracle Reports, Packaged ERP Application, Supply Chain Management Role: Communication with Product Analysts and Business analysts to escalate any deviation from current system requirements. Deriving the test cases from functional specification. Involved in execution of test cases and reporting bugs. Involved in functional and regression testing. Validation of Report data by writing SQL. Additional Certification

● Certified Software Test Professional (CSTP) Level 1 certified with 89%.

● ISTQB Foundation Level certified.

● Certified SQL (OCA)developer.

Personal Details:

Highest Education: Bachelor of Engineering, Electrical Engineering (Rajiv Gandhi Proudyogiki Vishwavidyalaya, Bhopal 2006)

Visa Status: Valid H4 EAD till Feb 2021

Contact this candidate