Resume

Sign in

Engineer Test

Location:
Bengaluru, Karnataka, India
Posted:
February 22, 2018

Contact this candidate

Resume:

SHANTHABAI. D

Test Engineer Candidate Number:

Email: ac4kw4@r.postjobfree.com VB36068438

Mobile: +91-789*******

PROFESSIONAL SUMMARY:

4+ years of Experience in Software testing.

Experience on ETL/DWH testing.

Experience on Web Application functional and System testing.

Good Exposure to Data Warehousing concepts.

Expertise in executing SQL queries manually for back-end Database.

Hands on experience in writing database Queries.

Has testing experience in Informatica Power Center 9.6.2 tool, Talend and Good knowledge on Power centre Objects like Transformations (Active and Passive), Mappings, sessions, Session logs and workflows.

Good Knowledge in Dimensional Data Modelling using Star & Snowflake Schemas, Fact & Dimensions tables.

Experience on SAP BO Reporting Tool for Report Testing.

Involved in preparing, reviewing and executing Test Cases.

Well acquainted with the Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Bug life cycle.

Has experience on Quality Center test management tool.

Has experience on JIRA.

Quick Learner, Team player, willing to learn new technologies, flexible, Hardworking, Positive Attitude.

Excellent communication and inter-personal skills.

WORK HISTORY:

Worked as Software Test Engineer with eMids Technologies Pvt.Ltd, Bangalore from Nov 2016 to Till Date.

Worked as Software Test Engineer with Cenduit (India) Services Pvt.Ltd, Bangalore from Jan 2016 to Nov 2016.

Worked as Software Test Engineer in Fidelity National Financial India Pvt. Ltd., Bangalore from September 2013 to Jan 2016

CERTIFICATIONS & AWARDS:

Certified in ISTQB Foundation Level on 8th June, 2017.

CAUSE FOR APPLAUSE awarded for outstanding performance and continued dedication in eMids Technologies.

Certified SQL Server 2003 R2 –Basic with New Horizons Computer Learning Centers, India in Cenduit (India) Services Pvt.Ltd.

EDUCATIONAL PROFILE:

MCA (Master of Computer Applications) from Sri Indu College of Engineering & Technology, Hyderabad in 2011, affiliated to JNTU Hyderabad.

BSC (Bachelor of Science) from Nagarjuna Govt. Degree College, Nalgonda in 2008, affiliated to Osmania University.

TECHNICAL DETAILS:

Testing : ETL/DWH testing& manual testing.

Operating Systems : Windows, UNIX.

Databases : Oracle SQL Developer 3.1.07, 10g, SQL Server 2005, TOAD

ETL Tools : Informatica Power Center 9.6.2, Tidal

Project Management Tool : JIRA

Test Management Tool : HPQC V11

Bug Tracking Tool : Team Tracker

Scheduling Tool : Tidal

Data Access Tool : TOAD

WORK EXPERIENCE:

Project# 1:

Title : ACS

Client : QuintilesIMS

Environment : Talend, Oracle 12c, Windows, JIRA, HP QC (ALM) 11.0

Role : Sr.Test Engineer

Duration : Nov 2016 to Till Date

Project Description:

QuintilesIMS has contracted with the American College of Surgeons (ACS) to build a new registry platform, called the Infosario Registry Platform (IRP).As the IRP is a single platform that can underpin any clinical registry, it becomes a rich source of data for any organization that requires aggregated clinical data from across care settings. In order to ensure that all historical data from registries is also included, legacy data from registries needs to be migrated into the IRP platform.

ACS – Data Migration is developed in TALEND DI & ESB, which will migrate all the legacy registries (NSQIP, SSR, Trauma & cancer) to IRP – System using web services. JSON & XML files are generated & fed to the respective services to consume and store into IRP System.

There are a total of six registries managed by ACS, viz.:

NSQIP Adult

NSQIP Pediatric

NSQIP Bariatric

Surgeon-Specific Registry (SSR)

Cancer

Trauma

In order to go live with the new system, it is mandatory to migrate the legacy registry data to IRP system. This project is constituted to migrate the legacy registry data to the new IRP system

Responsibilities:

Involved in functional study of the application.

Building E2E ETL Testing scenarios by developing Data preparation and SQL Queries

Generating Test data by using Java script

Created test data to execute the scenarios in a Controlled environment and UAT

Executed SQL queries to validate the results

Reported and tracked defects. Verified changes and closed bugs in HPQC Application Lifecycle Management.

Upload and Follow the process of Project Management Tool JIRA

Handling a team of 3, and mentoring them to execute the test cases and explain the business functionalities

Developed and maintained ETL Testing test cases using Oracle11g SQL standard

Participated in the daily status calls to address issues.

Designed and developed reconciliation report between legacy database to XML DB

Interactions with BA & Dev teams to resolve the issues.

WORK EXPERIENCE:

Project# 2:

Title : IRT Management

Client : Spring Bank Pharmaceuticals, Inc, USA

Environment : Informatica 9.6.2, Oracle 10g, Windows, UNIX, Toad 9.7.2, QC 9.0

Role : Test Engineer

Duration : Jan 2016 to Nov 2016

Project Description:

Interactive Response Technology (IRT) systems automate patient and drug management, reducing errors and increasing efficiency. As the largest IRT specialist in the world, Cenduit has the IVRS vendor expertise to empower sponsors for success with a completely personalized system that puts you in control of your clinical trials. With the needs of investigator sites and patients top of mind, Cenduit offers clinical supply chain intelligence and clinical operations know-how through its IRT-driven services

Client wants to have some system which can give some intelligent Informational reports & his existing business situation and how he can analyze specially his business. Data Warehouse (DW) to facilitate near current reporting and ETL process to populate DW.

Responsibilities:

Involved in functional study of the application.

Running the Jobs/Workflow for ETL process.

Prepared and ran SQL queries.

Designed & executed test cases.

Verifying the data in target database after ETL process.

Performed column data mapping between source & target database.

Prepared test data for testing.

Defect Analyzing and Reporting in QC.

Interactions with BA & Dev teams to resolve the issues.

Involved in the Report testing.

Reporting daily testing status report.

Project # 3:

Title : BKFS.

Client : Black Knight Financial Services, USA

Environment : Informatica 9.6.2, Oracle 10g, Windows, UNIX, Toad,

Quality Centre 9.0.

Role : Test Engineer

Duration : April 2014 to Dec 2016

Project Description:

Black Knight Financial Services Data & Analytics is a trusted resource for mortgage lenders, servicers and investors providing market-leading data and analytics solutions that provide powerful, unparalleled insight. These offerings enable our clients to improve performance,

Proactively identify risk, create mitigation strategies and accurately estimate collateral value.

Client wants to have some system which can give some intelligent Informational reports & his existing business situation and how he can analyze specially his business. Data Warehouse (DW) to facilitate near current reporting and ETL process to populate DW.

Responsibilities:

Involved in functional study of the application.

Running the jobs for ETL process.

Verifying the ETL data in target database.

Source and Target data mapping.

Verifying the data which is loaded into target database.

Interactions with BA & Dev teams to resolve the issues.

Reporting daily testing status report.

Developed, Reviewed & Executed Test Scripts and Designed test data.

Identified Test Scripts for Regression testing.

Defect Analyzing and Reporting in QC.

Project #4

Title : Title Point Express.

Client : FNF

Environment : ASP.NET, SQL Server 2005, Team Tracker 5.0

Duration : September 2013 to March 2014

Role : Ass. Test Engineer

Project Description:

TitlePoint sets the standard for efficiency in title searching and order management. Its leading edge architecture and design enable users to easily produce comprehensive, examination-ready title packages – with the convenience of a Web-based browser.

Using TiltePoint’s smart, powerful and full-featured search engine, you can quickly find the information you need and streamline the search process. Perform combination searches of tax, title and images, including starter records. Create merged searches that combine multiple parcels into a single package. Monitor open orders for new plant postings, and much more.

Responsibilities:

Involved in understanding of the Software Requirement Specification

Developed, Reviewed and Executed Test cases

Test Activities included Functional Testing and Regression Testing.

Defect Analyzing and Reporting.



Contact this candidate