QA Tester, Database and ETL and Manual Testing

Monica A

Mobile : +91-887*******

Email id: ******.********@*****.***

Experience Summary

IT Professional possessing 3.9 years of experience in the IT Industry while being competent in ETL Testing, Database Testing and Manual Testing.

Key Skills

● Expertise in QA testing.

● Good experience in creating, modifying and enhancing Manual Test cases.

● Well versed with SDLC – Agile, Scrum concepts.

● Knowledge in ETL tools: SAP BODS, Talend.

● Knowledge in computer programming languages like C, C++ and database querying languages like SQL and Oracle.

● Working experience in JIRA.

● Absolute knowledge of Database design, RDBMS, data warehousing and data modelling concepts.

● Working experience in Microsoft Azure to analyse and manage input and output sources. Professional Experience

Cognizant Technology Solutions(Experis IT Payroll) : 29-Aug-2019 – till date Wipro Technologies(CBSI Payroll) : 01-Mar-2019 – 15-May-2019 Capgemini India Pvt Ltd, Bangalore : 25-Aug-2015 – 08-Feb-2019 Project 1:

Project Name : MMAP Big Data DW Implementation

Role : QA Tester

Roles

performed

: ● Coordinated with developers and prepared and implemented test plans.

● Documented and reviewed all the test cases in SIT.

● Verified data completeness and transformation rules. Technology : Azure Databricks, SQL Server

Description : Gilead Managed Market Strategy and Operations (“MSO”) team is undertaking an initiative to build an Integrated Data Warehouse (“DW”) and Analytics Infrastructure on Gilead’s Cloud Platform that would serve as a foundation layer for analytic capabilities across the MSO team to enhance quality and visualization thereby reducing manual effort

Project 2:

Project Name : Telkomsel

Role : ETL Tester

Roles

performed

: ● Worked with onsite team to define test requirements to satisfy business objectives.

● Created test cases and test data.

● Executed the test cases

● Involved in writing complex SQL queries to verify source and target.

● Performed data validation testing

● Prepared ST and SIT documents

● Maintained daily status reports with complete information like passed, failed and executed test cases.

Technology : Hive, Abinitio Testing, Winscp, Putty Description : Telkomsel’s current data warehouse was built over a period of time with incremental enhancement/additions across functional layers. While the current system supports the needs of Telkomsel from short term perspective, long term and strategic needs to be achieved by transforming the landscape which is the objective of the “BI2.0 - DATA INGESTION” program.

Project 3:

Project Name : Cerebro RCCL

Role : QA Tester

Roles

performed

: ● Understanding the Client Requirements and functionality of the system.

● Involvement in preparation of Test Procedures, Test Scenarios, Cases and Test Data.

● Executed the test cases.

● Performed Unit Testing and SIT and pointed out the defects and errors that were made during the development phases.

● Retesting the cases where defect has been raised.

● Worked in Microsoft Azure for managing inputs and outputs.

● Created stories and epics in JIRA.

● Worked with Data mapping team to understand the source to target mapping rules.

● Scheduled DEV and SIT jobs in Talend Administration Console(TAC)

● Monitored the control tables for successful job completion. Technology : Talend 6.4, MS SQL, Oracle, Microsoft Azure, JIRA Description : The client needs to migrate data from various sources from the landing layer to the staging layer Microsoft Azure and further to the transformation layer. This extraction and migration of data is achieved through Talend tool. Project 4:

Project Name : CCR Data Migration

Role : SAP BODS developer

Roles

performed

: ● Created custom templates and custom lookups and used them in various business needs.

● Helped basis team in creating Local, Central and Profiler repositories in SQL Server 2008 R2 and configuring Local and Profiler repositories with Job server and Management console.

● Used Data Integrator and Platform Transforms extensively.

● Ability to interpret, configure and implement data mapping / transformation business rules into Data Services.

Technology : SAP BODS 4.2, SQL Server 2012

Description : The client needs to migrate the data from SAP systems to Teradata for doing the sales analysis in which they require a power full ETL tool which can connect to multiple systems and extract the data and load in to Teradata, for this activity BODS 4.2 has been chosen.

Education Qualification

B.E (CSE) Panimalar Engineering College, Batch of 2015 C.G.P.A 7.2 HSC Sri R M Jain Vidhyashram, Batch of 2011 82%

SSLC Sri R M Jain Vidhyashram, Batch of 2009 75%

Personal Details

Birth Date : 08.11.1993

Father’s Name : G. Anbu

Gender : Female

Marital Status : Single

Nationality : Indian

Language : English and Tamil

Monica A,

Chennai, India.

Contact this candidate