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, Karnataka06.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
Similar Profiles
Tina StaplesTina Staples
Senior Technical Account Manager at LSEG Post Trade Regulatory ReportingSenior Technical Account Manager at LSEG Post Trade Regulatory Reporting
Kailash ChauhanKailash Chauhan
Product Owner at Morgan Stanley:CAT Regulatory ReportingProduct Owner at Morgan Stanley:CAT Regulatory Reporting
NARESHA KRNARESHA KR
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
Divya NelaturiDivya Nelaturi
Medical Coder at Augustus Health CareMedical Coder at Augustus Health Care
JEEVAN KUMAR PERIKALAJEEVAN KUMAR PERIKALA
Data Engineer at Suncorp InsuranceData Engineer at Suncorp Insurance