Test Engineer Analyst

Ronak Mandliya

Senior Test Analyst

Mob : +91-837*******

E-mail : **************@*****.***

Summary:

7+ years of Extensive experience in IT Industry as a Software Test Engineer with emphasis on ETL/ DW BI testing, Data Migration, Report testing, Manual testing, well acquainted with SDLC and bug life cycle of application and SQL Creation in Banking Domain.

Good Knowledge in Data Warehouse Concepts and Agile methodologies.

Exposure to reporting tools like Business Objects and Tableau.

Involved in preparing the Test Plans, Test Strategy documents, Test Cases & Test Scripts based on business requirements, rules, data mapping requirements and system specifications.

Experience on Functional testing, System Testing, Regression Testing, Integration testing, Smoke testing, System Integration Testing (SIT), Batch Testing and Performance Testing.

Involved in preparation of Defect Report, Weekly Status Reports, Checklists, Test Readiness Documents, Test Summary Reports.

Understanding of Data Models, Data Schema, ETL and created extensive store procedures, SQL queries to perform back-end data warehousing testing.

Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.

Develop and document test plans based on functional requirements and technical specifications.

Experience in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification, identifying Data Mismatch, record and document results and compare to expected results.

Ensure data integrity standards and reconciliation with the production systems.

Create, Execute and Debug SQL queries to perform data completeness, correctness, data transformation and data quality testing.

Assignments also include working on Batch Scheduling tool Control-M to run and monitor ETL jobs.

Strong analytical skills, logical approach towards solving problems and flexible enough to adapt new technologies.

Self-motivated team player with natural leadership traits, highly productive and adaptive, strong research, and time management with good interpersonal and communication skills.

Education

2008-2012 B.E (Computers) BAMU University Jawaharlal Nehru Engineering College, Abad 60.5 % 2007-2008 Class XII Board of Secondary Education, Maharashtra Jalna Education Society College, Jalna 76.83% 2005-2006 Class X Board of Secondary Education, Maharashtra St. Mary’s high School, Jalna 75.33% Work Experience

Mar 2020 – Till date Vodafone Intelligent Solutions Aug 2016 – Mar 2020 Fiserv India Pvt Ltd

Jun 2013 – Aug 2016 Cognizant Technology Solutions Skill Set

Operating Systems Windows XP, 7, 8, Linux

Database, Test/Defect

Management Tools

SQL, Oracle 10g, HP ALM Quality Centre 12.0, JIRA, Rally, Quip Tools and Utilities SSIS 2017, Informatica 9.1, Pentaho7, SQL DBX, Putty, Control-M/EM 7.0, GIT, Tableau, SAP BO Testing methodology

ETL testing, Data Warehousing, Database testing, Functional testing, Report testing, Data Migration testing System testing, Integration testing, Manual testing, Regression testing, User Acceptance testing Projects Description

EDSP

Roles

Responsibilities

Duration

Environment

Client: Vodafone Germany

Enterprise Digital Services Platform (EDSP) provides cross domain information in a Central Data Store (CDS) in near real time.

CDS is split into 3 Logical layers, Layer 1 consists of the database tables and data replication 1:1 from the data sources using Oracle Golden Gate (OGG) replication tool. Layer 2 consists an abstraction layer that ensures all access from the Layer 3 Enterprise Services to Layer 1 is only via the Layer 2 objects.

The HTTPS and CSV Services provide data only from Layer 3. Deputy Manager

Analyzed solution architecture and design documents including Source to Target& detail design documents needed to plan test design activities.

Involved in creating test scenarios, test cases and test results for data warehouse/ETL testing.

Perform source system data analysis to manage source to target data mapping.

Perform testing of real data from one core system to another.

Create, Execute and Debug SQL queries to perform data completeness, correctness, data transformation and data quality testing.

Written Test Cases for system to compare Source and Target database systems.

Record and document results and compare to expected results.

Responsible for documenting the process, issues and lessons learned for future references.

Reviewed the test activities through daily Agile Software development stand-up meetings. From Mar 2020 – till date

Domain : Telecom Solutions

Objective : Database Testing, Functional testing, Report testing Technologies : Oracle Golden Gate, Oracle 12C

Reporting tools : Xray for Confluence, JIRA

Projects Description

AIM

Roles

Responsibilities

Client: TWG (The Warranty Group)

Administrator interface management (AIM) solution is batch processing system used to run the third-party administration business and administrative business of TWG organization. It processes client files to support admin of TWG as well as financial reporting and insurance services. It uses collected data to deliver services relating to underwriting, actuarial insight, pricing and marketing. Detailed data is used to analyze the client's performance, compared to expectation and support potential pricing adjustments.

Data Architect, Analyst

Analyzed solution architecture and design documents including Source to Target& detail design documents needed to plan test design activities.

Involved in creating test scenarios, test cases and test results for data warehouse/ETL testing.

Perform source system data analysis in order to manage source to target data mapping.

Perform migration and testing of static data from one core system to another.

Perform data migration audit, reconciliation and exception reporting.

Create, Execute and Debug SQL queries to perform data completeness, correctness, data transformation and data quality testing.

Performed ETL using Microsoft SSIS, to extract, transform and load test data on the test environment and to tested against the database.

Extensively involved in testing the ETL process from different data sources (AS400, SQL Server, flat files) into the target database as per the data models.

Written Test Cases for ETL to compare Source and Target database systems.

Record and document results and compare to expected results.

Analyzed the testing progress by conducting walk through meetings with internal quality and development groups.

Responsible for documenting the process, issues and lessons learned for future references. Duration

Environment

Reviewed the test activities through daily Agile Software development stand-up meetings. From May 2019 – till date

Domain : Insurance Solutions

Objective : ETL/DWH Testing, Report testing

Technologies : SSIS, SQL Server

Reporting tools : Quip, JIRA

Projects Description

INAV

Roles

Responsibilities

Duration

Environment

Client: State Street

I am part of the team developing ETL’s (using Pentaho) to calculate the iNAV (Net Asset Value) for various banks.

To run the ETL’s developed for different clients, where iNAV needs to be calculated and validate the data transformed is done using MIG21 tool.

Senior Test Engineer

Understanding the requirements of iNAV project’s Functional Requirement and Specification.

Design and execute test plans on computer applications and reports.

Record and document results and compare to expected results.

Generate historical analysis of test cases and results.

Create, Execute and Debug SQL queries to perform data completeness, correctness, data transformation and data quality testing.

Test case execution, Data validation in DW and MIG21.

Validating output- fixed width csv stream files generated.

Executing SQL queries to get the required results from Database.

Lead a team which ensure no issues on meeting deliverables.

Co-coordinating between development team and Onsite Leads.

Daily status calls with clients and onsite leads.

Mentoring new joiners and fresher’s.

From Aug 2016 – till date

Domain : Investment Banking

Objective : ETL/DWH Testing, Report testing

Technologies : Pentaho, MIG21, Oracle

Reporting tools : Rally

Projects Description

Repo

Roles

Responsibilities

Duration

Environment

Client: Credit Suisse

REPO (Repurchasing Agreement) deals with trading platform where traders are booking trades which includes different applications like VISION, Repo Client. This allows the traders to book trade and it will push to downstream systems for the complete trade flow mechanism.

Verify that data is transformed correctly and make sure that all projected data is loaded into the data warehouse without data loss and redundancy.

Senior Test Engineer

Working as a Primary SQA and understanding the Functional Requirement and Specification.

Creation of Test Cases and Test Scenario.

Prepared Test Report at the end of Functional testing.

Executing Test Cases and raising defects in HP ALM, proposing a fix.

Executing SQL queries to get the required results from Database.

Report testing using Business Objects.

Effective coordination between development team and BA’s. From Jun 2013 – Aug 2016

Domain : Investment Banking

Objective : ETL/DWH Testing, Report testing

Technologies : Oracle, Informatica, Control-M

Reporting tools : HP ALM 12.0

Achievements

CIS award for best Customer Satisfaction.

Appreciated within the team for suggesting better Solutions and improving processes.

Received Client Appreciation Award.

Active participation in technical and non-technical events Personal Details

Date of Birth May 26th, 1991

Gender Female

Marital Status Single

Languages Known English, Hindi, Marathi, Gujarati

Passport Details K5426205, Date of Expiry : 26/07/2022 Current Address B-101, Sai Dreams, Pimple Saudagar, Pune References are available on request.

Contact this candidate