QA Test Lead in ETL/DB Testing with 11+ Yrs of Experience
Overview
11
11
years of professional experience
Work History
QA Lead
Bank of America – Regulatory Reporting
03.2020 - Current
Extensive ETL testing performed to implement the Axiom Reporting tool with complex transformation logics tested in Oracle DB
Primarily served as ETL tester working on core Extract of Data from Upstream systems and transforming as per Business requirements and mapping logics eventually loading up to populate different dimensional reports
Prepared the SQL’s against Business requirements using CTE’s against Informatica Code
Leading a team of 12 members and Involved with Business Onshore to strategize the Test approach and cycles
Plans the sprint capacity with PO based on PI planned progress rate
Allocate the sprint stories to the Team and monitor the progress
Bridges the Dev QA collab for effective and time saving completion of Agile sprint stories
Focus on Uniformity completion of 12-15 SP’s for each resource
Demo the integrated Functionality to the End users in each sprint
Involved in Release management effectively avoid Leak free every Release
Project 3 – ETL Testing for Axiom Implementation
Client Bank of America – Regulatory Reporting
Accomplishment - Exhaustive ETL testing performed to implement the Axiom Reporting tool with complex transformation logics tested in Oracle DB
Role – QA Lead
QA Analyst and Senior QA Analyst
Bank of America
06.2016 - 03.2020
Oracle replaced IBM Netezza DB for Bank Loans Sector handling 20+ Upstream and Downstream applications
Gathered the Business requirement of Enhanced Technical functionalities
Analyzed the difference in Database structure using DBA’s help
Documented the various test scenario’s applicable on DB
Tested the Migration of Netezza to Oracle by comparing the Data in Tables/Views
Designed various Positive and Negative test cases using sql queries
Prepared Reports to provide an regular progress of Projects
Tested the integration of all upstream and Downstream systems with Oracle DB
Involved in Regular calls with SM and PO highlighting any risks associated.
Microstrategy Reports are tested to showcase the Business related Loans progress numbers
Involved in RCA with Development team to fix the bug in Time
Project IBM Netezza Decommission
Client – Bank of America
Accomplishment - Oracle replaced IBM Netezza DB for Bank Loans Sector handling 20+ Upstream and Downstream applications
Role – QA Analyst and Senior QA Analyst
QA Analyst
Travelers Indemnity company
04.2014 - 06.2016
Tested the implementation of ICD 10 codes on Claims portal of Travelers involving18 impacted vendor application Including Xerox.
Understanding of test environment and preparation of test data
Test scenario design and Test case creation as part of waterfall methodology
Peer Review of cross functionalities Test Preparedness
Test Execution on UI and DB using basic sql’s
Execution and defect tracking in Quality center
Production support for the Release
Project ICD 10
Client – Travelers Indemnity company
Accomplishment - Tested the implementation of ICD 10 codes on Claims portal of Travelers involving18 impacted vendor application Including Xerox.
Role – QA Analyst
Responsibilities -
Education
Bachelor of Engineering - ECE
Appa Institute of Engg and Technology
Kalaburagi, Karnataka
06.2013
Skills
QA professional with Enrich exp in UI, DB/ETL Testing with Informatica and Oracle DB Integration Exp
Hands on Automation testing Exp with Tosca
Test Lead with technical and Operations people managing skills of Team size from 2 to 28
Numerous client recognition in successful deliveries, Developed Internal Axiom Tool leading to 90 hrs effort save per quarter, Achieved Insprint Automation saving upto 180 hrs per quarter and one resource effort per sprint, Received Accolades and various Awards and Rewarded by Current Organization for successfully managing Deliver, Team, Client and Extra curricular activities.
Tools Worked
Completely worked on Autosys from Job updates to Force runs including defining sedevants and Variables
Informatica has been thoroughly used across ETL testing for complete logic mapping understanding and testing
Axiom Reporting E2E from Objects creation, Adenza Package adoption, to Testing Free form and Tabular reports along with Workflow runs errors fixing
Spreadsheet comparator for Excel comparison along with Built in macros
Quality Center, JIRA, Qtest and Octane for defect and Test Execution progress tracking
Automation
Worked on Tricentis developed Tosca Automation tool to create regression suite
It’s a non coding scan capture and unique parametric identification tool that provides complete solution in terms of efficiency and accuracy to test large suites
Operations and People management
Complete tracking of Entire Team (18 members) timesheet submissions review
Billability tracking of Resources across different spaces based on Vacation planned
Vacation tracker maintenance along with Resource planning tracker per week
Involved in staffing internal to projects as well as External Hiring
Manages Specifically ETL hiring and Axiom related resource onboard
Organize Team lunches, Team Events and Sports Events at account level
A regular Emcee and Event planner with people ranging from 10 to 2000+
Senior Analyst at Financial Markets Regulatory operations - Standard Chartered Bank Global Business Services Pvt LtdSenior Analyst at Financial Markets Regulatory operations - Standard Chartered Bank Global Business Services Pvt Ltd