Jose Thomas Rajesh

MOBILE: +1-412-***-****

EMAIL: adjr2c@r.postjobfree.com

Quality Assurance Lead with 13 Years of diverse experience in Information Technology with emphasis on implementation of User/Business/Functional requirements to enable the product as a defect free product. Extensive business knowledge of global Financial services, Insurance and CRM domains with aim of promoting transparency of code quality across developers, product owners and senior management. Expertise in Manual, ETL, Automation, and Database testing. Adept liaison among functional and technical teams, capable of managing and mentoring cross cultural staff and vendors.

Core Skills include:

Database Testing

Estimation & Budgeting

ETL/DWT Testing

Requirement Analysis

Release Management

Team Management

Agile Delivery

Automation Testing

Strong understanding of QA Principles and Process, Software Testing Life Cycle (STLC), Bug life Cycle and QA development methodologies like Waterfall, AGILE/Scrum, V-Model.

Has Strong Experience in leading 15 member team in both the onshore/offshore model

Has strong experience in translating Business requirements into System Functional Specifications and System Design Specifications and thus mapping the Functional Test cases to the Requirement Traceability Matrix

Has proficiency in ETL/BI tools like Informatica power center, SQL Server Integration Service (SSIS) and Reporting tools like Actuate Reports, SSRS and AXIOM

Extensive experience in ETL/ Data warehouse backend testing (Execution of ETL Process and Data Validation of Source to Stage and Stage to Target)

Good experience in data warehouse concepts and technologies like OLTP, OLAP, Data Models (Star/ Snow Flake Schemas), DataMart’s (Dimensions and Facts) and Reporting.

Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.

Proficient in troubleshooting database issues and experienced in using performance monitor/profiler to solve dead locks/ long running queries.

Expert in creating Test Plan, Test Scenario, Test Scripts, Traceability Matrix, Test Strategy, Test Estimation, Test Effort, Scheduling, Defect Tracking and Executing Test cases.

Familiar with Excel for developing Requirements Traceability Matrix (RTM) and Capturing and Updating Change Requests.

Experience in preparing test reports from HP ALM and prepared daily test status reports to communicate the test status with the team.

Excellent verbal and communication skills, has clear understanding of business procedures, adapt new environment quickly, Team building, Leadership and Project Management Skills.

TECHNICAL EXPERTISE

Primary Skills

ETL, Automation, Database and Manual testing

Programming Skills

VB, Java

Databases

SQL Server 2005/2008, Oracle 10g/9i/8i, Teradata

Databases Tools

Toad, Oracle SQL Developer, Query Builder, Query Analyzer

Testing Tools

Quality Center - 10.X, Application Lifecycle Management, Bugzilla, Eclipse, IntelliDb 8.3,Jira

Source Control Tools

Visual Source Safe, Tortoise SVN, Star Team, Rally

ETL and Reporting Tools

Informatica 8.1, SQL Server Reporting Service, SQL Server Integration Service, Actuate, Erwin data modeler, AXIOM

Domain Skills

Banking, Insurance and CRM

Techno-Functional

Team Building, Planning & Prioritizing Skills, Time Management, Cross Cultural Skills, Customer Orientation

PROFESSIONAL EXPERIENCE

Working as Quality Analyst IV in Insight Global, Pittsburgh from Nov 2019 to Till Date

Worked as Technical Test Lead in Infosys Technology, India/USA from Jun 2013 to Oct 2019

Worked as Associate in Cognizant Technology Solutions, Chennai from Apr 2012 to Jun 2013

Worked as Software Engineer in Hexaware Technologies, Chennai from Dec 2009 to Mar 2012

Worked as Associate Software Engineer in Tratum Technologies, Bangalore from Apr 2007 to Dec 2009

EXPERIENCE SUMMARY

PNC Bank Nov 2019 to Till Date

QA Analyst IV

Project Description

He is assigned to work on the PNC Bank – RRX project for the leading bank in America at client development center - Pittsburgh. Working on RRX(Regulatory reporting project)in which our source system is EDW and our target system is TOAD. Where we load the data in ETL Informatica and will validate the data in our RRXPP tables. Also we will validate the reports using the AXIOM tool by checking code and reports in WF’s, DD, DS and Aggregations, meanwhile to validate the full data we will pull the reports from Tabular to get the FEDERAL values.

Responsibilities

Gain an understanding of the testing requirements, analyze moderate to highly complex requirements documents, design specifications, functional specifications, and changed or modified code.

Attending the daily standup meeting with Development and Business teams to review current changes in each release cycle.

Ensure all documentation and scripts are maintained and kept up to date with application changes.

Executing daily Batch/Jobs, which load/move the data to target tables.

Preparing test strategy document and get approval from the Project manager, Change the bank and run the bank teams

Preparing the Test Results Summary Document after the completion of testing in both SIT and QA testing before prod implementation and get approval

Scheduling daily meetings with offshore team and discuss daily updates on the ongoing releases

Executing and monitoring the RRX Calculator batches and validating the FFIEC, 9C, 14Q Reports

Validate the MDE/MDA functionality, Validate the Categorization process, where the business rules are applied to categorize the data accordingly. This process is done as part of batch process

Validate the Data quality that is loaded to RRW environments before processing

Validate the GL Reconciliation functionality. Calculation of GL balances and exposure balances and validation of GL Recon report, this is also a part of batch process to check completeness of data.

Validated all the Federal submitted Finance reports such as FRY 9C, FFIEC 031 and Risk reports such as 14Q using Axiom Regulatory tool

Axiom - Cross checking the different components of Axion like Data Source, Data Models

Axiom - Executing the workflows using Workflow module

Axiom - Comparing the reports generated by the Axiom tool with the results from queries written based on the Business requirements

Axiom - If any differences found raising bugs and analyzing the differences using Drill down options in Freeform report, Aggregation and Portfolio Modules

Validation of the RRX amounts comparing the results from complex SQL queries with the FFIEC 101 … generated from the Batch processing

Tested the modified STMs due to source system updates as a part of ETL validation

Finding Feasibility for automation and impact to existing automation.

Traceability of Defect or Requirement with Test Case.

Co-ordinate with Development Team and all stakeholders to discuss defects/issues.

Helping Business team with required information for UAT in QA environment.

Environment: Informatica, AXIOM, OBIEE, Oracle 10g/9i, SQL Server 2008, Teradata, HP ALM, SharePoint

Citi Bank Jan 2018 to Oct 2019

Sr. ETL Test Lead

Project Description

He is assigned to work on the Citi Private Bank – CPB project for the leading bank in America at our onshore development center - Tampa. Project one is a financial module, Banker will handle the financial module to generate reports and statements.

Responsibilities

Thorough out the project in various iterations/Sprints – conducted system testing, integration testing, functional testing and integration testing.

Created complex SQL scripts for source and target following the mapping document guidelines.

Created the Testing Document for all the involved tables by identifying the unique data for performing data validation.

Test extract, transform and load (ETL) processes to assure that the data has correctly moved from source to staging and staging to target.

Performed UAT and Regression Testing.

Environment: Informatica, Oracle 10g/9i, SQL Server 2008/2005, HP ALM, Confluence, Java

Bank of America Jun 2014 to Sep 2018

Sr. ETL/Automation Test Lead

Project description:

He is assigned to work on the Mortgage Servicing Package – MSP project for the leading bank in America at our offshore development center - Chennai. The Loan Sphere Mortgage Servicing Package initiative is to convert Bank Dals and iSeries platform capabilities and related loan portfolios to the MSP platform of BKFS. This initiative will result in the standardization of many loan servicing activities and process across consumer and mortgage. The purpose of the project is to test all the conversion activities and to ensure all the critical elements are balancing from pre conversion to post conversion.

Responsibilities:

Established QA process framework and management process for software delivery in MSP projects.

Thorough out the project in various iterations/Sprints – conducted system testing, integration testing, functional testing and integration testing.

Created complex SQL scripts for source and target following the mapping document guidelines.

Created the Testing Document for all the involved tables by identifying the unique data for performing data validation.

Test extract, transform and load (ETL) processes to assure that the data has correctly moved from source to staging and staging to target.

Performed thorough validations (data correctness, datatypes, constraints, historical, data counts, integrity etc.) required both from the data point of view as well as the business point of view.

Created testing scripts to validate all the data columns for all the dimensions, facts as well as standalone tables in their respective data loading format.

Created a series of testing scripts with the typical format of count validation followed by data columns validation and finally null column checks and primary, foreign and surrogate key validations of all the dimension and fact tables.

Executed automation scripts on different browsers/environments & reported defects to the team

Created Automated Regression test suit. Involved in design and implementation of Selenium WebDriver automation framework for smoke and regression test suites (TestNG and Maven).

Maintained the Selenium & JAVA automation code and resources in source controls like CVS, SVN over the time for improvements and new features

Automated the testing of the whole script by IntelliDB bank tool.

Created Automated Regression test suit to provide up to 65% efficiency in QA process.

Created the Test Plan and Test Cases in HP ALM, identified issues and created defects in HP ALM

Provided daily updates regarding the progress of the project to the Client Manager.

Environment: Oracle 10g/9i, SQL Server 2008, HP ALM, IntelliDb 8.3, Tortoise SVN, Rally

Bank of America Jun 2013 to May 2014

ETL Test Lead

Project description:

He was first assigned to work on the SFDMS (Single Family Default Monitoring System) Project for the leading bank client in America at our offshore development center - Chennai. He has been part of Operational Data Source - ODS and Agency Reporting. The Objective of the project is on a monthly basis Bank is required to report all FHA loans that are in default status for 30 days or more to the U.S. Department of Housing and Urban Development (HUD). The Next Gen SFDMS application processes the entire master database loans and determines if loans are in default or not. All the loans which are found as defaulted in the master database are applied to the transformation logics and the associated defaulted codes are reported to HUD via EDI transmission. Loan status is continually reported until such a time that the loan is no longer in default and the default episode is closed.

Responsibilities:

Closely involved in gathering requirement, design, development and implementation of the project

Developed high level test matrix based on business requirements, functional and technical specifications, and development standards for assigned project/applications

Developed test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability.

Developed SQL queries to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.

Performed Count Validation, data validation, data scrubbing, data cleansing for data coming from sources during data migration/conversion.

Extensive SQL querying on Staging, Data Warehouse and DataMarts.

Ensured Error logs and audit tables are generated and populated properly

Have active interaction with DBAs' related to the schema, dblink creation, data refresh for multiple rounds of testing and other tasks.

Participating in defect triage meetings to work closely with developers to inform them about defects. Experience in defect management cycle.

Environment: Oracle 9i/8i, SQL Server 2005, HP ALM, Tortoise SVN, Rally

Travelers Indemnity Company Apr 2012 to May 2013

DWT/ETL Tester

Project description:

He is assigned to work on the Distributions project at our offshore development center - Chennai.

Distributions project is a collection of data marts designed to store the Agency & Agent demographics and considered as the backend for Travelers sale and marketing operations. The project takes care of Data Requests and Enhancements to support these applications. The Lync is a new portal to assist Travelers field staff in managing their agencies. The Internal Structure business objective is to build a flexible data structure allowing users to create and maintain the current alignment of business to the business organization geography.

Responsibilities:

Closely involved in gathering requirement, design, development and implementation of the project

Reviewed the requirements document created by the BA and prepared a thorough test plan.

Involved in rigorous meetings with the product owner and DWH Lead to prepare a roadmap for implementing the test plan on a sprint basis as part of the agile model.

Reviewed test cases, validation steps and test scripts prepared by the testing engineer with the product owner.

Created test plan and test cases from the business requirements to match the project's initiatives in Quality Center.

Developed SQL Queries and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.

Written complex Oracle SQL queries and executed them to validate the incremental ETL Loads.

Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage.

Involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and Test Data.

Maintained the test logs, test reports, test issues, defect tracking using HP ALM

Environment: Oracle 9i/8i, SQL Server 2005, HP ALM, Tortoise SVN, Rally, Visual Source Safe

Ernst & Young Dec 2009 to Mar 2012

ETL Test Analyst

Project description:

The purpose of this project is to create the ODS Source, from 8 different source system. OS layer is the first layer of the ID ODS where the entire source file is loaded through ETL. Source files from different source system will be loaded into appropriate data files directory. An ETL process then reads and loads them into staging tables. All the data in OS layer is loaded with no transformations or validations (excluding file date, basic data type validations). After the data has gone to staging, Data Cleansing, Data Enrichment will be done as the data is moved from the Staging Area to ODS. Business and referential integrity rules will be applied to the data before it is loaded into ODS tables.

Responsibilities:

Attended meetings with architects, developers and business analysts to understand data model, data flow and warehouse design.

Worked in Client location (USA) as an Onsite Lead.

Written test cases developed the validation steps and reviewed them with testing team manager.

Developed test scripts using SQL according to the mappings and rules specified in mapping document.

Performing different data quality checks like null check, length, validity, alphanumeric on all different fields and columns.

Researching more on bad data/defects and categorizing them as source issue, ETL issue or historical issue.

Experienced with data models Start Schema and Snow-Flake Schema

Extensively tested several BO reports for data quality, fonts, headers & cosmetic.

Created test plan and test cases from the business requirements to match the project's initiatives in Quality Center.

Maintained the test logs, test reports, test issues, defect tracking using Quality Center.

Good working experience in creating Test Plan, Test Scenario, Test Scripts, Traceability Matrix, Test Strategy, Test Estimation, Test Effort, Scheduling, Defect Tracking and Executing Test cases

Environment: Oracle 9i/8i, SQL Server 2005, Quality Centre, Informatica 8.1, Business Objects XI, Visual Source Safe, Tortoise SVN, Star Team, Erwin data Modeler

British Telecom Apr 2007 to Dec 2009

BI Developer/Database Test Engineer

Project description:

He is assigned to work on the EDW and CosmoCall project at our offshore development center -Bangalore.

The scope of this project is to load the data into an Enterprise Data Warehouse which will form the Centralized data repository for all Internal/Downstream systems. EDW will be built across various phases where data from ISS PACE will be loaded into Data Warehouse with historical information. Also tested the

Cosmo reports for client which helps them to analyze their Call records, Team, Agent, Email, SMS, and Group records by which they will be able to track the various areas of development

Responsibilities:

Attended meetings with architects, developers and business analysts to understand data model, data flow and warehouse design.

Created tables, views and indexes.

Optimizing the complex stored Procedures and tuning Queries.

Create/Update new DB Logins & Roles and assign them as per AD team request

Monitoring SQL Server Logs, Job history.

Data base maintenance and Report design creation.

Environment: SQL Server 2005, SQL Server Reporting Service, SQL Server Integration Service, Actuate e.Report Designer Professional 8.0, Star Team, Bugzilla, Quality Centre, SVN

EDUCATION AND CERTIFICATIONS

Mater of Computer Application from Bharathidasan University, India

Bachelor of Science in Mathematics from Madras University, India

Contact this candidate