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