Gaurav Tomar Email & Phone Number

Noida, Uttar Pradesh, India

Noida, Uttar Pradesh, India

Noida Area, India

Professional experience - *OHADI - Installed OHADI for Informatica, designed and developed new ETLs to handle extra attributes of the Interface HDI tables in Incremental load. The new ETLs were developed to follow the OHADI architecture. Also involved in the execution of OHADI loads, testing, logging issues and providing solution.*Oracle HDWF, Informatica - Data Model Customization, ETL design and Development: Worked on the first ever implementation of Oracle Healthcare Data Warehouse Foundation (HDWF) for a leading Cancer Research Institute. Was involved in design and development of Informatica ETLs for incremental loading of HDM tables from the interface HDI tables.*Oracle HDWF, ODI 11g - Worked on the pilot project to customization of Oracle Healthcare Data Model using ODI for a leading Pharmaceuticals company. Was also involved in development of ETL for incremental loading of HDM tables from the interface HDI tables.Worked on the project to customization of Oracle HDWF using ODI for a leading Healthcare service provider. Involved in providing functional inputs, ETL development from source to interface HDI tables & running OHADI loads. In the latest project he is involved in developing functional mappings and ETL design & development.*InForm – Argus Safety Integration Designed and developed PL/SQL procedures so that data from Oracle Health Sciences InForm is reflected in upstream Argus Safety cases as attachments. Proof of concept to convert XML attachments into HTML format. Written custom mappings SQLs and PL/SQL routines to map the E2B+ fields to Argus Case Form fields on Import and Export module of E2B.*OCDA - 2.1, Informatica - Working on Implementation for a leading US based Healthcare and Life Sciences company. Responsible for Integration of various OCDA components like Database, Informatica and OBIEE. Involved in Design, Development, Testing and Bug fixing Activities

Noida

Bangalore

*Data Cleansing & Application Development - Development and Team Management: Worked as IDQ developer and lead for data cleansing of a leading energy domain MNC. IDQ is used for cleansing the data and different validation rules which is tested against the data. Error codes are populated for incorrect data and on the basis of those error codes reports are generated.

Bangalore

*Transaction Banking Application Development - Worked as JAVA and PL/SQL developer for application development for transaction banking of a leading international bank. Used JAVA to call the PL/SQL scripts to fetch the data from database and insert the data into database.*Risk Database and ETL - Worked as Database and ETL developer for risk reporting data warehouse of a leading international bank. Used PL/SQL for creating back end procedures, functions etc and Informatica as the ETL tool. This setup was also used Unix scripts wherever other technologies fell short.*Payment device Activation Application Development - Worked as JAVA and PL/SQL developer for application development for payment device activation of a leading international bank. Application allow Basic Card member to activate Supplementary cards in the VR, during the Basic's activation process.

Bachelor Of Technology - Btech, Electrical, Electronics And Communications Engineering

10+2, Science

Education record