About

Jeeva Bharrathi K S is a Principal Member of Technical Staff at Oracle with over 11 years of experience in IT. She has extensive experience in ETL testing, database, and DWH testing with Informatica for automation, and is skilled in writing complex SQL queries, Informatica, and ODI. Currently, Jeeva is working in Oracle's Fusion Analytics Warehouse (FAW) in FSCM - Finance & SCM, covering AP, AR, GL, Fixed Assets, Inventory modules, and FAH - Fusion Accounting Hub. She is involved in writing SQL scripts to validate warehouse Dims & Fact tables + RECONCILIATION tables against the Fusion DB source. She is also automating the SQL scripts using ODI - Procedures, Mappings, Scenarios & Load Plans. Prior to Oracle, Jeeva worked at Castlight Health, where she was involved in validation of EDW data from Source (MySQL) to Target (GreenPlum DB - PostgreSQL) along with ETL flow validation in Informatica. She has adequate experience and knowledge in Healthcare domain, dealing with metrics like Accounts, patients, Eligibility, Registration, Visits, Searches, Returns, Insurance policy, Subscribers, Dependents, Household. Jeeva has also worked with the Wellness data (JIFF data) with more importance in tracking the Programs like Get Active (foot steps taken), Eat Smart (by calories) & Sleep well (sleep seconds) and reporting this data in an ease form that is being utilized by the Product Analytics teams. Jeeva has experience in creating Mappings, Reusable Sessions, and Workflows in Informatica and automation of the Regression test suite covering most critical modules of EDW using Informatica. She has worked with databases such as PostgreSQL GreenPlum, MySQL, MS SQL Server, and Oracle 11g. Jeeva is skilled in ETL Tool: Informatica Power center 10.0, ODI, BI Tool: MicroStrategy 9.2.1, and Defect Management Tools: HP QC & JIRA. Jeeva has a Bachelor of Engineering (B.E.) in Electronics and Communications Engineering from Velalar College of Engineering and Technology and a Master of Engineering (M.Eng.) in VLSI Design from Mahendra Institutions. She is a quick learner and good at logical thinking, with a great passion for writing SQL queries for complex and challenging scenarios. Jeeva has relevant experience of