Ravi Amaresam ETL Test Lead Cell+1-945-***-**** Email: adyg8p@r.postjobfree.com

PROFESSIONAL SUMMARY

Performance driven professional with 15+ years of valuable experience in Quality Assurance as ETL Technical Test lead and ETL Tester worked in various Projects like SunTrust Bank, Nationwide Insurance, JPMC, Barclay’s, American Express and Santander Bank and Kaiser Permanente.

As a Technical Test Lead Planning and Estimating for the project, knowledge transfer, allocating resources, worked with the scope of Testing and change requests.

Management experience includes Manpower handling, Leadership, and improving team performance, conflict management, decision making, hiring right talent and ensuring smooth functioning of all operations.

Expertise in Testing ETL arena using various SQL Databases in Waterfall, Agile Development Projects and Cloud base Database Snowflake

Extensive experience in ETL Testing using tools Informatica, Ab Initio & Data Stage.

Hand on Testing experience on Hadoop/Big Data Technologies, Experience on data ingestion tool NiFi, used to extract data from various data sources into Hadoop Data Lake.

Write complex SQL queries in Apache Hive, HBase, Presto for data validation and analytic purpose.

Create detailed Test Execution Reports and Analyze, Interpret and Summarize the data into higher level reports and charts.

Expert in Data warehousing applications testing with an excellent SQL skill

Repeated success in the areas of Test Management, stakeholder management & Co-ordination, Delivery, and Process Improvement

Managing and leading team members; allocating resources among team members and guiding team during the project, till final delivery.

Ability to provide Testing Strategy for large to medium sized programs

Have strong domain knowledge in Banking. Financial, Insurance

Done end to end Testing which includes analysis of the Business reequipment, Design doc, Impact Analysis and Retest after Fixing the Incidents.

Communicate and collaborate with cross functional teams during all phases of the program, mentor, train, develop and serve as a knowledge resource to less experienced QA engineers

Partner with Product Owners and Scrum masters to ensure teams are delivering high quality deliverables and Experience in SDLC, STLC, Waterfall and Agile Process.

As a Test Lead, conceptualizing, planning, and estimating for the project; knowledge transfers, allocating resources identifying and managing risks

Expertise in Functional Testing / Integration Testing / System Testing

Used Test Management Tool Quality Center (HP ALM) extensively and certified.

Repeated success in the areas of Test management & Co-ordination, Delivery, and Process Improvement and Followed the scrum model process using the tool Rally

Used SOAP UI and Java application Testing, experience in Manual Testing

Extensive Experience in GIS architecture and GIS Testing SME in Auto Insurance Domain

Extensive experience of analysis, design, develop, execution of Test scenarios and Test scripts

Accustomed to best practices of Defect Triage, Defect Reporting & Test Management

Preparations of team daily/weekly status reports and send to the Client.

Good communication skills, interpersonal skills, self-motivated, quick learner.

Well acquainted with the Software Testing Life Cycle (STLC)

Preparation of Test Plan and Preparation of Detailed Process Flow Diagrams.

TECHNICAL SKILL

Operating Systems : Windows NT /2000, UNIX

Web Technologies : ASP, .NET, C#, JSP, HTML, DHTML & XML

DW Tool : Ab Initio, Informatica, Data Stage, Talend, SISI

Databases : Teradata SQL Assistant, Oracle SQL Developer, Synapse, SQLWorkbench,

IBM DB2, Microsoft SQL Server, DBeaver, BigQuery, Snowflake

Big Data Tools : Hadoop, Spark, Scala, Python, HBase, Kafka, Hive, HUE, Nifi.

Reporting Tools : Cognos BI, SAP BI, Tableau, Power BI

Testing Tools : X-Ray, Quality Center, RTM, Rally, ALM, Jira, qTest, AZ DevOps

Languages : Java, C, C++, Python

Other Tools : VB, Visual Source Safe, Source Depot, Visio, Control-M, UNIX

RPM, CPMA, NAPS, SOAP UI, Logical Viewer, Confluence, Salesforce,

Denodo, Putty, DB Visualizer, Mainframe, WinSCP, TDM, Tableau,

ServiceNow, SharePoint, S3 Browser,Win Diff, OFSAA, Rally, Zephyr

Processes : IBM’s QMS and Agile methodologies.

PROFESSIONAL EXPERIENCE

USAA - Data Migration Plano TX JUL 2021 – till date

Role: ETL TEST LEAD

Description:

Data flow depicts different touch points and team dependencies for the code conversion, common framework, and integration touch point to move data from DL2 to DL3 and DL4

Responsibilities:

Extensively worked in Data Migration Team which involved in replacing the existing Data integration pipeline consisting of DataStage and Netezza with DBT and Snowflake.

Did various ETL Test validation source Vs target tables in Snowflake and Netezza

Execution of Test scenarios and business process test cases to verify the design and functionality of applications as per user requirements in Snowflake.

Used Automation python scripts to dynamically generate test data in JSON format and loading them to Snowflake Staging tables to validate the Transformation logics and data flow to Target tables.

Verified Stage, Integration, and load job details as per .yaml files.

Worked on loading the data into type1 and type2 tables by running the Control-m jobs.

Involvement in all phases of testing such as Functional Testing, Integration Testing, System Testing and Regression Testing, Cutover Testing in Snowflake

Create Requirement Traceability Matrix (RTM) to map the requirements to the Test Plan document.

Creating and maintaining existing Test Plans, Test Case and Test Result documents.

Creating source to target Validation SQL scripts to validate the data as per STTM and verify data within Evidence log tables.

Logging impediments in Jira for Defects Identified and Retest and Closed

Involved in validating Job Dependencies, Scheduling of DBT jobs in Control-M are as per design document.

Written complex SQL queries to validate and compare the data in Snowflake.

Driving Defect Triage meeting and liaising with Development, Data Modeling and Business Teams for closure of defect

Testing of new attributes added to the existing tables and performing Marketplace registration.

Participate in ETL review meetings to review the Test Plan, Test Results and get an approval.

Used Defect Tracking tool QTest to create, execute test cases and link them to Jira stories.

Monitor project progress by tracking activity, resolving problems publishing progress reports to customers, and recommending actions.

Environment: DataStage, DBT, Netezza, Snowflake, QTest, Jira, Python, Control-M, Tableau, Putty, Gitlab, Oracle, Coginito Pro

Santander Bank - Data Lake Boston MA October 2018 – July2021

Role: ETL TEST LEAD

Description:

Data Lake initiative is a business-critical area Build the data lake environment to support the business requirements to integrate semi-structured and real-time data across multiple platforms and environments. Develop data federation capability to facilitate analytics across multiple data sources including Mainframe operational data, Structured data from USA, Tealium Event Stream data from channels and Datamart and feed the data to BTO. The scope of this Data Lake project does not include ingesting or storing any Financial or Legal/Regulatory data.

Responsibilities:

Responsible for Manage the team in by delivering defect free product to customer

Responsible for effective communication between the project team and the customer.

Provide day to day direction to the project team and regular project status to the customer

Establish Quality Procedure for the team and monitor team the meets quality goals

Daily Interaction with Team, Responsible for knowledge transfer and deliverables

Assigning the Tasks to the Team members and Track the Testing Progress

Review of Deliverable Test Scenarios, Test Cases and Preparation of Traceability Matrix, Test Execution, Defect Tracking and Test Closure Report.

Prepare the Test case, Defect status matrix on regular base and update to Client.

Used Application Lifecyle Management (HP ALM) for the Reequipments, Test Cases and Defects tracking.

Provides updates to management on testing status & scheduling Issues

Responsible for successful completion of Functional, Regression, Database testing of the application

Responsible for successful completion of System testing of the application.

Manage the end-to-end line test effort. The activities include identify test data, coordinating test schedules, and mitigating test issues and risks

Identify, define, implement, and conduct necessary tests, as well as log the outcomes of the testing and analyzing the results

Regularly communicates the testing progress and quality to the Project Manager

Delivering the high quality, bug free software to our customers in the financial sector.

Prepared the Test Environment Document and Responsible for software testing of Change Requests

Responsible for Preparing Project Understanding Documents and Knowledge Transfer

Responsible for leading a project team in delivering solution to our customer in the automotive sector.

Deliver new and complex high-quality solutions to clients in response to varying business requirements

Responsible for managing scope, planning, tracking, change control, aspects of the project.

Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals

Tested automated framework to simulate JSON events and post them to Apache Nifi, Apache Kafka and HDFS.

Tested generic automation framework which supports Lambda architecture to cover both batch and NRT (Near real time) data flow.

Write complex SQL queries in Apache Hive, HBase, Presto for data validation and analytic purpose.

Preparing production-like test data in lower test environment required to perform ETE testing. Also develop scripts to generate larger volume of test data.

Environment: Python, Nifi, Hive, HUE, HDFS, Eclipse, Presto, Apache, HBase, Salesforce, Oracle, DBeaver, Snowflake.

American Express – RRD USA October 2016 – August 2018

Role: ETL Test Lead

Description: This is a financial data warehouse program. Objective of this project is to have a centralized repository/source for financial data.

Responsibilities:

Prepared the Test Plan and Test Strategy documents for GMDL & Deposits

Provide the SIT and keep track the progress and make sure that SIT is completed Within time schedule.

Load the data into various hops like Pre-Stage to Stg, Stg to ODS, ODS to OFSAA

Coordinated and shared the Metrics to Leadership team on weekly base

Prepared, reviewed the test cases and test scripts provided inputs to the team

Attend all daily stand-up calls and offshore daily calls to track the progress

Lead the offshore Team by assign the tasks and track the daily test progress

Define Test Approach and Publish Test Execution and Defect Report

Develop BDQ test scenarios by DG team standards for each Test Scenarios.

Prepare test scripts as per updated Mapping Transformation logic

Automated the Regression Testing by running all the test scripts in one time.

Make sure Test deliverables are on time with best possible quality and as per Project standards

Keep update the User stories in Rally and task for each Sprint

Environment: Informatica, Oracle SQL Developer, Rally, Atomic

Barclay’s Card UK April 2014- August-2016

Role: ETL Test Lead

Description:

bPAID Foundation Program, a new processing environment is to be established. Existing merchant acquiring business will also be migrated to the new environment. this migration of existing business hosted primarily in the Darwin, CAMS II And CS&R source systems.

Responsibilities:

Lead the offshore Team by assign the tasks and track the daily test progress

Define Test Approach and Publish Test Execution Report

Defect Management through QC,

Develop End to End Test Scenarios.

Enter defects and mapped to test cases to requirements in Quality Center.

Attend the daily test status / defect call with Client and provide the inputs

Prepare test scripts as per updated Mapping Transformation logic

Automated the Regression Testing and did Reconciliation Verification Testing

Preparation of Test plan document

Extract Defect reports and share it with Project Managers, Analysts & team

Conduct Defect calls with Development & Test teams for faster closure of defects

Review Test cases and scripts

Organizing daily stand-up calls with the team

Make sure Test deliverables are on time with best possible quality and as per Project standards

Environment: Informatica, TOAD, Tivoli, WINSCP, Quality Center10

JPMC USA August 2011- March 2014

Role: ETL Lead

Description:

JPMC's Integrated Customer Data Warehouse (ICDW) project involves using the industry model, Banking Data Warehouse (BDW) data model to drive the development of a Staging Layer, Integration Layer and Semantic layer. Mapping and transformation from Integration Layer to the Semantic Layer. The project is expected to enhance analytical capabilities. Acquisition, portfolio management, and continues to work to support real-time operational feeds, accelerating to daily weekly pace and researching potential new variables.

Responsibilities:

Writing Test Scripts for Straight Map and various business rules to compare data.

Analysis, Design, Development, Testing and Execution of Test Scenarios.

Responsible for effective communication between the offshore team and the customer.

Provide day to day direction to the offshore team and track regular project status

Assign the Tasks to the Team members and Track the Testing Progress

Writing the Test Scenarios, Review, Execution and Defect Tracking

Writing and Executing SQL scripts for Source and Targets.

Writing Complex Test Scripts by using Business Transformation Rules

Understand the Data Model and Mapping sheet documents.

Compare the Critical data for Source to Target in Testing environment.

Smoke Test and Source Systems Unique Key Text (SSUKT)

Develop End to End Test Scenarios.

Upload the test scripts in Quality Center and Execute.

Enter the defects in Quality Center

Mapped to test cases to requirements in Quality Center.

Prepared Client Audit Documents

Attend Daily status calls with onsite team

Prepare QA Release Notes and send to the Client to move code UAT

Environment: Informatics 8.6, Teradata13, UNIX, Control-M, Quality Center10.0

Nationwide Insurance USA June 2009 – July 2011

Role: Test Analyst

Description:

Internet Change Processing (ICP) project is to enhance the functionality of the existing Servicing application to provide customers rating and binding of the policy changes online. Current MyNationwide requires manual intervention of Service Center personnel to make any policy change requested online. With ICP, MyNationwide customers having a Nationwide branded Standard Auto policy can make changes to their policies online, obtain premium change if any and submit the change without requiring manual intervention from Service Centers. ICP implemented started with VA so far 10 states are in live WV, OH, PA, MD, SC, DE, TN, AL, KY and TX

Responsibilities:

Analysis, Design, Development, Testing and Execution of Test Scenarios.

Responsible for effective communication between the offshore team and the customer.

Provide day to day direction to the offshore team and regular project status to the customer

Establish Quality Procedure for the team and monitor team the meets quality goals

Responsible for knowledge transfer and offshore deliverables

Communicating with the offshore team and Client.

Assigning the Tasks to the Team members and Track the Testing Progress

Writing the Test Scenarios, Review, Execution and Defect Tracking

Mapping the Requirements to the Test Cases and Preparation of Traceability Matrix

Prepared the Test Environment and communicate with team.

Prepare the Test case, bug status matrix on regular base and update to Client.

Provides updates to management on testing status & scheduling Issues

Responsible for successful completion of Functional, Regression, Database testing

Responsible for successful completion of System testing of the application and Regression

Manage the end-to-end line test effort. The activities include identify test data, coordinating test schedules, and mitigating test issues and risks

Identify, define, implement, and conduct necessary tests, as well as log the outcomes of the testing and analyzing the results

Conducting defect review meeting with stake holders

Coordination with Performance Testing team and ensures completed on-time

Support production readiness and implementation night validation.

Regularly communicates the testing progress and quality to the Project Manager

Delivering the high quality, bug free software to the Clients

Prepared the Requirement Traceability Matrix to cover functional requirements with Test cases

Responsible for software testing of Change Requests

Attend the defect review meetings and get it resolved defects on time

Environment: Java, SQL Server, SOAP UI, Quality Center 9.2, NAPS, Filenet, Logical Viewer

SunTrust – EC CIS USA December 2008 – May 2009

Role: Test Analyst

Description:

EC CIS (Enterprise Client Customer Information System) Application is a backend application developed using IBM WCC framework. CIS application is developed to provide 360 degrees view of Client Information such that different consuming applications use/ access client related information according to different business needs of SunTrust Bank. The Data is organized in form of DB2 tables and accessed through channel in form of XMLs Requests and Responses (Transactions) by different Applications. WCC Framework comes with predefined Transactions and new customized Transactions (XML Requests, Responses) are built to serve different business needs in order to retrieve, save, update or delete information in CIS Database. Different Transactions are built/updated as part of each Quarterly Release to expand the functionality and to serve different channels with Client related Information.

Responsibilities:

Participating in different releases to Test different Services using Fitness Tool

Participating in Business and System Requirement Reviews with BA and Development Teams

Test Plan Document preparation consisting of Resource Estimation, Test Strategy, Scope of Testing

Preparation of different Reports and Matrix (Functional and System Testing Execution Reports, Requirement Traceability Report, Defect Reports) using Quality Center Dashboard Module

Preparing XMLs for Functional and System Integration Testing

Prepared an executed the fitness scripts developed to validate various out of box and customized WCC services

Coordinating Execution of Functional and System Test Cases, Test Execution Reporting

Using Quality Center

Environment: IBM WCC (WebSphere Customer Center), IBM DB2 V8.1

CLS – NSP2 UK May 2008 – November 2008

Role: Senior Tester

Description:

CLS® (Continuous Linked Settlement) application will do the settling foreign exchange transaction which eliminates settlement risk, improves liquidity management, reduces operational banking costs improves operational efficiency and effectiveness. CLS is a real-time system that enables simultaneous settlement globally irrespective of time zones. CLS is an ongoing process of receiving payments of specified currencies from customers, settling pairs of instructions that satisfy all criteria and making pay-outs in specified currencies. Settlement is final and funds are returned same day. NSP2 project that deploys new infrastructure in various sites to enable FX to execute synchronously.

Responsibilities:

Writing the Test cases, Review, Run the Test cases in Rational Manual Tester.

Created the Test Design in Test Manager & Link to the Manual Tester.

Track the Team Test Case Execution status and update daily Test status Report.

Monitoring the Tivoli Job Alerts for the CLS application involved in various LPAR, TWS, Build Stand up & Connectivity Testing.

Tracking and Chasing Approvals of the defects using CPMA as per Test case schedule.

Environment: C, C++, Java, UNIX, Windows NT/2000.

SunTrust – TPR3 USA April 2007 – April 2008

Role: ETL Test Engineer

Description:

TPR3 project mission is to expand upon the work done in the TPR1 and TPR2 projects to acquire and store operational data from additional 65 SunTrust source systems. Scope of this project is to extract operational data into landing and load data into TPR Database, each source system in its own schema, with minimal deviations from the original structure. Publish source files for use by other applications.

Responsibilities:

Writing the Test cases, Review, Execution and Defect Tracking.

Mapping the Requirements to the Test Cases.

Preparation of daily / weekly status reports.

Responsible for leading the Testing team from Offshore.

Prepared the Test Environment and communicate with team.

Prepare the Test case, bug status matrix on regular base and update to Client.

Verify the Source and Target data & Monitoring the Jobs.

Responsible for software testing of Change Requests.

Written the ETL, Masking, Data related Test cases.

Written the SQL scripts for Source and Target data testing.

Tracking and coordinating the defects using Quality Center

Responsible for Preparing Understanding Documents and Knowledge Transfer.

Environment: Ab Initio GDE 1.14.21, DB2, UNIX, Windows NT/2000.

Wachovia - RDS USA October 06- March 07

Role: ETL Test Engineer

Description:

In recent years, the most iteration of this capital accord, commonly known as Basel, it has created an urgent need amongst banking organizations for sophisticated risk management tools to help them improve their risk management capabilities. The Basel Committee on Banking Supervision published a new framework agreement that aims to make the international financial system safer by having the risk of banks' loan portfolios to be reflected in the capital charges they need to set aside against unexpected losses. This project is basically implementation of Basel complaint for Bank of Wachovia. It extracts data from various sources like Mainframes, Unix Servers, XM Cleansing Hub. Abinitio is used as a Data Integration Module to perform comparison with reference data and current data and load the output in the RDS Data Warehouse which is then used by BI tools to perform risk analysis for the customer.

Responsibilities:

Attend the Basal Training.

Written Test cases for Straight Map.

Verify the Input / Output data of Excels.

Written the SQL scripts for Source and Targets.

Environment: Ab-Initio, Teradata. ALM,UNIX

Microsoft - WWICR USA November 04- September 06

Role: Sr. Test Engineer

Description:

IC Reporting is the end reports generated in xCAT will be represented in website and make available to end users. The purpose of this site is to offer users on-going key business metrics and results which enable users to perform analysis to track progress, to identify areas of improvement, to forecast and to determine a future strategy. WWICR delivers smart reporting for IC data. This internally developed web-based user interface Web Components, and provides predefined, customizable views for the everyday consumers of IC data. Each valid IC user will have the ability to set user preferences for geography, currency, and default report to create a personalized environment.

Responsibilities:

Written the Test Cases according to the Updated Functional Specifications.

Running Test Cases on the Test Servers.

Prepared the Reverse Traceability matrix and make sure that Test cases are meeting all the functional requirements.

Logging Closing Reopening Bugs in Product Studio.

Worked on Functional, Regression and Performance Testing.

Uploading of test cases to Product Studio and mapping of corresponding Bugs.

Worked on various change requests and QFE’s.

Prepared the Test estimates for the current project.

Assigning the Tasks to the Team members and Track the Progress.

Preparing the Test Environment and the give the Test release.

Preparing Daily/Weekly Status Reports send to the Client.

Environment: MS-SQL Server 2000, .Net Framework, Product Studio.

Awards

IT outstanding Contribution Recognition Award

‘I got caught’ Award from Nationwide Insurance

GBS – GD Eminence & Excellent Recognition Award

Multiple IBM FSS Awards

EDUCATION

M. Tech in Computer Science Engineering from JNTU, Hyderabad, India - April 2004

B. Tech in Mechanical Engineering from Nagarjuna University, India - April 1999

CERTIFICATION

ISTQB Certified in Software Testing.

HP Quality Canter 9.0

HP Quick Test Professional 9.0

IBM Six Sigma White Belt Certification.

IBM – People Management Skill Certification

Microsoft SQL Server Certification

PMI – PMP Certification

Certified ScrumMaster (CSM)

AWS Certified Cloud Practitioner

Contact this candidate