Summary
Overview
Work History
Education
Skills
Awards
Tools Worked
Automation
Operations and People management
Organizations
Timeline
Generic
Abdul Hakeem Arif

Abdul Hakeem Arif

Hyderabad

Summary

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
  • Oracle DB Test, MS SQL, Axiom, Tableau, Microstrateg, Agile, DWH, Tosca Automation, Python Shell script, JIRA/Horizon, SOAP UI, Banking & Insurance

Awards

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+

Organizations

  • Accenture Solutions Pvt Ltd (07/2016 - Present)
  • Cognizant Technology Solutions (01/2014 - 06/2016)

Timeline

QA Lead

Bank of America – Regulatory Reporting
03.2020 - Current

QA Analyst and Senior QA Analyst

Bank of America
06.2016 - 03.2020

QA Analyst

Travelers Indemnity company
04.2014 - 06.2016

Bachelor of Engineering - ECE

Appa Institute of Engg and Technology
Abdul Hakeem Arif