Summary
Overview
Work History
Education
Skills
Timeline
Generic

Jayabharatha Reddy

Test Lead
Bangalore

Summary

Senior Consultant Jayabharatha has around 12+ years of experience in Information Technology. He has experience in various levels of Quality Control for Manual and Functional Testing, e-commerce, Integration testing, GUI Testing, ETL testing ,BI testing ,AZURE testing ,Oracle apps testing, Query Surge and Data migration. He also has experience in Product based Web Applications. Major Strengths: Experience in Manual Testing, BI Testing, ETL Testing and AZURE testing Knowledge in SDLC and STLC Experience in design and executed the test cases Experience in Retail, Healthcare and Banking domains. Experience in testing of Web applications and agile methodology Experience in Functional, Usability and System Re-Testing, Regression Testing and Paired testing Experience in End-to-End testing, system integration testing and UAT support Experience in HP ALM, Rally, JIRA and Version one Experience in Query Surge tool Experience in ETL Testing (Informatica ,AZURE and ODI) Experience in data base testing (SQL and Oracle) Experience in UNIX (Winscp and Putty) Experience in OBI and SAP BO Testing Experience in ERP testing (Oracle apps (OM, 2 Custom modules) and OBI (reports)) testing Experience in API testing (SOAP UI)

Overview

12
12
years of professional experience

Work History

05.2021 - Current
  • World bank
  • Project Description: WBG LIBOR Transition
  • The London Interbank Offered Rate (LIBOR) is the most used benchmark reference rate in the global financial markets
  • As the World Bank prepares for the transition, it continues to actively engage various stakeholders, including its Board of Executive Directors, subject matter experts, other multilateral development banks, and borrowers to develop solutions that minimize the impact of the transition for the benefit of itself and borrowers
  • The World Bank will remain committed to preserving the integrity of its financial model while applying principles of fairness and transparency for its borrowers
  • Responsibilities:
  • Analyzed the use case documents, data model, mapping documents and raised the clarifications
  • Designed, developed, and executed Azure ETL test cases
  • Prepared test strategy for support projects (Production support)
  • Involved in Sprint planning meetings
  • Involved in running the pipeline and monitoring the status
  • Wrote high-level scenarios for ETL testing
  • Verified the data between Landing to Raw layer, raw to standard layer ,standard to curated layers
  • Verified data reconciliation between each layer
  • Involved in logging defects in JIRA
  • Prepared daily Bug Summary Reports
  • Coordinated with onsite team on daily basis

Senior Consultant

Ciber Sites India Pvt., Ltd, services Pvt Ltd
Bangalore
03.2018 - Current
  • During this period, Jayabharatha has been working on the following projects:

03.2020 - 04.2021
  • Description: IFC
  • The World Bank is an international financial institution that provides loans and grants to the governments of poorer countries for the purpose of pursuing capital projects
  • It comprises two institutions: the International Bank for Reconstruction and Development, and the International Development Association
  • Responsibilities:
  • Analyzed the use case documents, data model, mapping documents and raised the clarifications
  • Designed, developed, and executed ETL test cases
  • Prepared test strategy for support projects (Production support)
  • Involved in Sprint planning meetings
  • Involved in running the Informatica workflows and monitoring the status
  • Wrote high-level scenarios for ETL testing
  • Verified the data flow from several source system
  • Compared data using Query Surge tool
  • Worked with basic UNIX Commands
  • Involved in logging defects in Version one
  • Prepared daily Bug Summary Reports
  • Coordinated with onsite team on daily basis

Medica
03.2018 - 02.2020
  • Medica, an independent and nonprofit company, is one of the largest health insurers in the Upper Midwest
  • Medica extract data from multiple source system like oracle tables, flat files, csv files using Informatica tool and load in Oracle tables
  • Responsibilities:
  • Analyzed the use case documents, data model, mapping documents and raised the clarifications
  • Designed, developed, and executed ETL test cases
  • Prepared test strategy for support projects (Production support)
  • Involved in Sprint planning meetings
  • Involved in running the Informatica workflows and monitoring the status
  • Wrote high-level scenarios for ETL testing
  • Verified the data flow from several source system
  • Compared data using Query Surge tool
  • Worked with basic UNIX Commands
  • Involved in logging defects in Version one
  • Prepared daily Bug Summary Reports
  • Coordinated with onsite team on daily basis

Lead Consultant

ITC InfoTech India Ltd, MYHERBALIFIE
Bangalore
12.2015 - 09.2017
  • The Herbalife Order Entry Process has been implemented in two process one is e-commerce application, Inhouse and tele sales
  • These all application data will be integrated to oracle database on daily and weekly basis using the ODI tool
  • Using this data, reports will be generated will OBIEE
  • Responsibilities:
  • Involved in BRD walk through meetings
  • Prepared the test strategy document
  • Estimated the testing to be done and negotiate with management to acquire the necessary resources
  • Wrote high level scenarios for Functional testing
  • Involved in writing oracle queries based on the mapping document
  • Involved in validating reports with database
  • Involved in system integration testing and data base testing
  • Logged defects in ALM quality center
  • Prepared daily Bug Summary Reports
  • Coordinated with onsite team on daily basis
  • Updated status with PMO team on daily basis

Senior Tester

EMIDS Technologies Pvt. Ltd, AETNA
Bangalore
12.2014 - 12.2015
  • In this project, the Population Health Management provides integrated population health management
  • The multiple source system like oracle tables, flat files, csv files using Informatica tool and load in Oracle tables
  • Responsibilities:
  • Involved in the detailed specification on requirements
  • Prepared the Test cases based on the User stories
  • Involved in Sprint life cycle (Agile methodology)
  • Established and executed test cases in Rally
  • Involved in comparing the File layout spec with the flat file
  • Verified column Mapping between source and stage databases
  • Verified the ETL data in target database
  • Compared the data in different systems
  • Logged defects in Rally
  • Involved in Scrum master meetings

HDMS System
06.2013 - 12.2014
  • Herbalife, as part of its on-going efforts to scale up new business challenges and complexities has decided to move a major part of the existing HMS system to a new system (DM system)
  • Before Go-Live in the production environment the required master data, the open transaction data and the historical transaction data need to be imported from the old legacy applications to the new DM system
  • Since data structure and data design in legacy systems are different from those of Oracle Applications, data need to be messaged/ converted satisfying the business rules to suite the Oracle requirement
  • Initial data can be migrated by any other means as discussed above depending upon certain parameter such as Volume, usage, complexity, business rule etc
  • Responsibilities:
  • Understood the requirement specification documents
  • Prepared the test strategy document
  • Prepared the RTM based on the BRD
  • Established and executed test cases
  • Involved in Integration testing
  • Verified column Mapping between source and target databases
  • Verified the ETL data in target database
  • Compared the data in different systems
  • Logged defects in QC
  • Sent daily and weekly status reports to Manager

QA Engineer

HERBALIFE Int. Ind. Pvt. Ltd
Bangalore
06.2011 - 12.2014
  • During this period, Jayabharatha was involved in the following projects:

Global Order Capture

Herbalife
06.2012 - 06.2013
  • Needs a mechanism to address the distributor sales, orders, complaints on the product quality and quantity
  • Whenever there is a complaint from any of the distributor, Herbalife business wants the future orders for the distributor is quality checked to ensure the product quality and quantity are accurate based on the order
  • This report will list Distributors/Order Types which have been flagged for Auditing in the above-mentioned manner
  • To provide a report of all case files created against Distributors by the EBP, Refunds and Repurchases and Compliance departments
  • Responsibilities:
  • Understood the requirement specification documents
  • Prepared RTM based on the BRD
  • Prepared test cases and executed them
  • Analyzed the results, logging the bugs and prepared bug reports
  • Sent daily and weekly status reports to Manager
  • Generated reports from Oracle BI Publisher and validating against database
  • Involved in weekly status calls with onsite managers
  • Performed Regression testing after fixing the bugs
  • Tracked the defects by using the tool Quality Centre
  • Involved in Database Testing
  • Involved in integration Testing
  • Involved in End-to-End Testing
  • Involved in UAT support

OLC
06.2011 - 06.2012
  • Online Contract is a web-based application tool, which is used for submitting applications online
  • Online application offers a Distributor with a 24 hour online tool to submit the applications
  • The automation of distributor registration will eliminates manual work currently performed by the country
  • This is both cost savings and an additional tool for the distributorship
  • Before the introduction of “online tool”, all the distributor creation process was done by manually
  • Responsibilities:
  • Understanding of Requirement Specification Documents
  • Preparation of RTM based on the BRD
  • Preparing test cases and executing them
  • Testing EMEA and APAC region based application
  • Analyzing the results, logging the bugs and prepared bug reports
  • Sending daily and weekly status reports to Manager and Client.
  • Jayabharatha

Education

Bachelor of Science - computer science

Sri Krishna Devaraya University

Skills

Technical Summaryundefined

Timeline

05.2021 - Current

03.2020 - 04.2021

Senior Consultant

Ciber Sites India Pvt., Ltd, services Pvt Ltd
03.2018 - Current

Medica
03.2018 - 02.2020

Lead Consultant

ITC InfoTech India Ltd, MYHERBALIFIE
12.2015 - 09.2017

Senior Tester

EMIDS Technologies Pvt. Ltd, AETNA
12.2014 - 12.2015

HDMS System
06.2013 - 12.2014

Global Order Capture

Herbalife
06.2012 - 06.2013

QA Engineer

HERBALIFE Int. Ind. Pvt. Ltd
06.2011 - 12.2014

OLC
06.2011 - 06.2012

Bachelor of Science - computer science

Sri Krishna Devaraya University

Similar Profiles

CREATE PROFILE
Jayabharatha ReddyTest Lead