Summary
Overview
Work History
Education
Skills
Professionalexpertise
Accomplishments
Timeline
Generic

Tanvir Ahmad

VA

Summary

7+ years of experience in the IT industry with emphasis on Quality Assurance/Software Testing with exposure of both Manual and Automated testing tools. I have an Expertise in validating and testing of Client/Server and Web-Based Applications in various environments. Experienced writing complex queries in Teradata SQL assistant to check the data from Source and Target. Extensive Retail/Banking Industry experience, Involved in all the phases of Software Development Life Cycle. Extensive experience in Data warehousing, design of Extraction Transform & Load (ETL) environment. Extensive Retail/Banking Industry experience, Involved in all the phases of Software Development Life Cycle. Participated in requirements analysis reviews and working sessions to understand the requirements and system design. Extensively involved in various phases of Software Development Life Cycle (SDLC) with experience in managing testing lifecycle process using Waterfall, V-Model and Agile. Expertise in Manual Testing of applications developed for Windows and UNIX Environments. Strong skills in implementing QA standards, and testing methodologies for Enterprise GUI, and WEB applications using Use case documents. Complete understanding of QA Methodology and QA Strategy. Experience in developing and executing test plans and Created test plans and test scenarios to prove the compliance of the solutions. Diversified experience in testing at every phase of the testing process: Functional, Integration, Regression, User- Acceptance, System Integration, Black Box testing and End-to-End Experience in analyzing application enhancement requests to identify application functionality that is suitable for Regression Testing. Experience working with UNIX, SQL scripting, managed version control software and defect tracking systems. Expertise in Problem solving and Bug Reports using Bug Tracking Tools JIRA, Quality Center, Bugzilla, and Clear Quest. Experience in using Automated Testing tools QTP/UFT, Selenium IDE, Selenium web driver, LoadRunner, and SOAP UI. Experience in creating Requirements Traceability Matrix to ensure comprehensive test coverage of Business requirements. Experience in Testing strategies for ETL technology using Ab Initio tool in complex, high volume Data Warehousing projects in both Windows and UNIX environment Excellent ability to handle multiple tasks and work independently as well as in a team. Self-starter, quick learner, Schedule driven - Results focused, Attention to details, Strong desire for quality. Good judgment skill to access high risk areas on which to focus testing efforts. Excellent communication, documentation, presentation and organization skills with quick learning ability to adapt to a new environment.

Overview

7
7
years of professional experience

Work History

QA Manual Tester

Burlington Coat
02.2023 - 09.2023
  • Company Overview: Burlington, formerly known as Burlington Coat Factory, is an American national off-price department store retailer, and a division of Burlington Coat Factory Warehouse Corporation with more than 1,000 stores in 40 states and Puerto Rico, with its corporate headquarters located in Burlington Township, New Jersey
  • Testing of EDI Software for Datawarehouse EDI 900 Series
  • Service Now for Incident Creation and Test Management
  • Testing EDI Software and creating data to generate Work Order, Pay Order, SKU, ASN, Labels and Invoice and approvals
  • Validation by Associating ASN with Appointment from Logistics
  • Routing data to unit allocation department and validating backend data to be added to store batches and released
  • Working on Burlington EDI Gateway and Vendor EDI Gateway for Order validation
  • Creating test script as per scenarios given in BRD and testing to see application function
  • Using MS Excel for listing Data and Graphs
  • Burlington, formerly known as Burlington Coat Factory, is an American national off-price department store retailer, and a division of Burlington Coat Factory Warehouse Corporation with more than 1,000 stores in 40 states and Puerto Rico, with its corporate headquarters located in Burlington Township, New Jersey
  • Environment: Oracle Form, ServiceNow, Jira, Excel and SmartSheets

QA/UAT Tester

US Bank
01.2022 - 01.2023
  • Company Overview: U.S
  • Bancorp (stylized as us Bancorp) is an American bank holding company based in Minneapolis, Minnesota, and incorporated in Delaware
  • The company provides banking, investment, mortgage, trust, and payment services products to individuals, businesses, governmental entities, and other financial institutions
  • It has 3,106 branches and 4,842 automated teller machines, primarily in the Western and Midwestern United States
  • It is ranked 117th on the Fortune 500, and it is considered a systemically important bank by the Financial Stability Board
  • Worked at US Bank Empower Project for Mortgage Loan Software Created by Black Night
  • Performed manual testing including functional Testing, UAT Testing and E2E on Mortgage Application for US Bank
  • Used SharePoint to house all test documentation and report
  • Provided support for Unit and UAT testing as required for the application or any other assigned application
  • Detects, logs, and reports program bugs and glitches by Creating issue with JIRA Zephyr
  • Tracks defects and helps troubleshoot errors and retests when defect was fixed
  • Reviews BRD and develops test cases and creating tests scripts
  • Going through Business Requirements Documents with Business Analysts and Participating in Meetings
  • Interacted with developers with bug analysis and fixes
  • Used JIRA for error reporting and communicating between developers, product support and test team members
  • Creating and Updating Test Script in using Jira and MS Excel
  • Using SQL Server Studio to Validate Data Flower downstream from Empower
  • Validating Empower Data flow to CITRIX
  • U.S
  • Bancorp (stylized as us Bancorp) is an American bank holding company based in Minneapolis, Minnesota, and incorporated in Delaware
  • The company provides banking, investment, mortgage, trust, and payment services products to individuals, businesses, governmental entities, and other financial institutions
  • It has 3,106 branches and 4,842 automated teller machines, primarily in the Western and Midwestern United States
  • It is ranked 117th on the Fortune 500, and it is considered a systemically important bank by the Financial Stability Board

QA Analyst

Macys
08.2019 - 10.2021
  • Company Overview: Macys is a retailer company that engages in design, marketing, and sale of clothing, accessories, and personal care products in the United States and Canada
  • Coordinated with business analyst/users on the test script review and sign-off
  • Worked in agile environment with 2 week sprints, used JIRA for sprint planning and tracking the reports
  • Involved in preparing the high level Test Plan and developed Test Cases in accordance with the functional specifications
  • Worked with Project Managers on estimates, statuses and risks
  • Report weekly status to the senior management and escalate issues
  • Prepared the gap analysis document by analyzing both the requirement specification document and design specification document
  • Involved in setting up the test environment for smoke and functional test
  • Used ALM Quality Center for executing manual test sets, collecting test results, and analyzing the data
  • Tracked and logged defects in Quality Center and coordinated meetings with developers and business analysts to prioritize the bugs, bug fixes and problem resolution
  • Preparing Weekly Status Reports/Daily Status reports
  • Established Traceability between the Requirements and the Tests in Traceability Matrix using Quality Center
  • Generated Bug Reports and Test case coverage reports for status meeting and also involved in resource planning for test cases coverage
  • Involved in Bug Review meetings and participated in weekly meetings with management team
  • Planned and executed Backend testing using numerous SQL Queries to verify the dataflow from the database
  • Responsible for testing all new and existing ETL data warehouse components
  • Support programmers through the ETL development processes on IBM Data Stage and PL/SQL and hands-on programming of ETL tasks
  • Wrote complex queries in Teradata SQL assistant to check the data from Source and Target
  • Used Teradata utilities (MLOAD & FLOAD) to load the source files in to test region
  • And did the querying on the same data
  • Created some macros in Teradata to load the test data in to Target tables
  • Involving in Testing Crystal Reports for the data validation in SimCorp Project
  • Formulating the QA plan for black box testing of the application, including Functional, Regression, Integration, Systems and User Acceptance Testing
  • Performing database testing to verify backend database transactions
  • Wrote complex queries in Teradata SQL assistant to analyze the data
  • Coordination of test plan, test results and reports in central repository – Share point portal
  • Worked with the business users on User Acceptance Testing by mentoring them on various aspects of testing
  • Involved in entire Software Development Life Cycle (SDLC)
  • Macys is a retailer company that engages in design, marketing, and sale of clothing, accessories, and personal care products in the United States and Canada
  • Environment: ALM/Quality Center, Business Objects, ETL, QTP, Load Runner, SOAP UI, JAVA, UNIX, XML, Oracle, SQL, Teradata, Informatica Designer, Work Flow, Teradata SQL Assistant

QA Engineer

Union Bank
02.2017 - 06.2019
  • Company Overview: Union Bank offers banking, mortgage, trading and financial services like Brokerage Services, Mutual Funds, Fixed income Investments, etc
  • Analyzed business requirements, documented and developed Test plans, Test requirements, and Test Cases
  • Worked in an agile environment to emphasize on real time communication over written documentation
  • Interface with vendors or providers for escalated support and advanced product knowledge
  • Mentor other engineers across product development teams
  • Used Quality Center to create the detailed Test Plan and Test Cases from the business requirements documents and meetings
  • Used selenium for regression testing
  • Used JIRA for test management and the overall communication with the team
  • Reviewed and enhanced test cases for application functionality testing
  • Participated in different meeting like sprint planning meeting, daily scrum meetings, review meetings and retrospective meetings
  • Reviewed and approved unit tests
  • Reported defects during manual testing using ALM Quality Center
  • Generated defect reports/graphs using Quality Center for the developers and project managers
  • Used Selenium IDE to record and play back scripts
  • Exported scripts recorded in Selenium IDE to Selenium Web driver in different languages such as Java, C#, python and Ruby
  • Created Requirement Traceability Matrix for future UAT Testing and maintained documentation for the whole testing process
  • Performed back-end testing by extensively using SQL queries to verify integrity of database
  • Used Teradata utilities to load the sample test data in to target tables
  • Used to play with the queries in the Teradata sql assistant
  • Involved in coordinating the test of Selling & Delivery application also involved in critical enhancement across a variety of systems including S&D handheld, ETL &Data Warehouse/Reporting
  • Perform functional testing and prepare regression test scripts for ETL processes
  • Involved in Executing test scripts per defined ETL testing processes
  • Designed, documented, built user interfaces for, and constructed queries for large-scale databases in both Microsoft Access and SQL Server
  • Worked on UAT with entire group of Business users and BA team and verified its results
  • Extensively worked on any requirement upgrade and/or change request while doing UAT
  • Worked closely with development team to ensure the application performance and stability and also ensure the application completes the whole end to end process
  • Participated in weekly status meeting with Development and Management Teams
  • Union Bank offers banking, mortgage, trading and financial services like Brokerage Services, Mutual Funds, Fixed income Investments, etc
  • Environment: Agile, Teradata, SQL Assistant, JIRA, ALM QC, ETL, Informatica, BO Reports, Universe, Oracle, Windows 2000, MS SQL

Education

Bachelor - Computer Science

University of Punjab

Skills

  • ETL Tools: Informatica Power Center, Work Flow, Designer, Data stage, Power BI
  • Programming Language: SQL, JAVA, VB, C#, RUBY, Python, NET
  • Front End Tools: MS Office, MS Project Professional, MS Access, Lotus Notes
  • Databases: MS Access, Oracle, MS SQL Server, SYBASE, PeopleSoft, DB2
  • Database Tools: Teradata, TOAD, MS SQL Server Management studio
  • Testing Tools: Quality Center (HP/ ALM), Quick Test professional(QTP/ UTF), MTM, Load Runner, selenium IDE & selenium web driver, SOAP UI
  • Reporting Tools: JIRA, Clear Quest, Bugzilla, Service Now

Professionalexpertise

  • 7+ years of experience in the IT industry with emphasis on Quality Assurance/Software Testing with exposure of both Manual and Automated testing tools.
  • Expertise in validating and testing of Client/Server and Web-Based Applications in various environments.
  • Experienced writing complex queries in Teradata SQL assistant to check the data from Source and Target.
  • Extensive Retail/Banking Industry experience, involved in all phases of Software Development Life Cycle.
  • Extensive experience in Data warehousing, design of Extraction Transform & Load (ETL) environment.
  • Participated in requirements analysis reviews and working sessions to understand the requirements and system design.
  • Extensively involved in various phases of Software Development Life Cycle (SDLC) with experience in managing testing lifecycle process using Waterfall, V-Model and Agile.
  • Expertise in Manual Testing of applications developed for Windows and UNIX Environments.
  • Strong skills in implementing QA standards, and testing methodologies for Enterprise GUI, and WEB applications using Use case documents.
  • Complete understanding of QA Methodology and QA Strategy.
  • Experience in developing and executing test plans and created test plans and test scenarios to prove the compliance of the solutions.
  • Diversified experience in testing at every phase of the testing process: Functional, Integration, Regression, User-Acceptance, System Integration, Black Box testing and End-to-End.
  • Experience in analyzing application enhancement requests to identify application functionality that is suitable for Regression Testing.
  • Experience working with UNIX, SQL scripting, managed version control software and defect tracking systems.
  • Expertise in Problem solving and Bug Reports using Bug Tracking Tools JIRA, Quality Center, Bugzilla, and Clear Quest.
  • Experience in using Automated Testing tools QTP/UFT, Selenium IDE, Selenium web driver, LoadRunner, and SOAP UI.
  • Experience in creating Requirements Traceability Matrix to ensure comprehensive test coverage of Business requirements.
  • Experience in Testing strategies for ETL technology using Ab Initio tool in complex, high volume Data Warehousing projects in both Windows and UNIX environment.
  • Excellent ability to handle multiple tasks and work independently as well as in a team.
  • Self-starter, quick learner, Schedule driven - Results focused, Attention to details, Strong desire for quality.
  • Good judgment skill to access high risk areas on which to focus testing efforts.
  • Excellent communication, documentation, presentation and organization skills with quick learning ability to adapt to a new environment.

Accomplishments

Sucessfully helped in rectifying bugs and deliver mortgage Application for US Bank in time projected.


Delivered great data for Burlington EDI software for their Warehouse Management


Timeline

QA Manual Tester

Burlington Coat
02.2023 - 09.2023

QA/UAT Tester

US Bank
01.2022 - 01.2023

QA Analyst

Macys
08.2019 - 10.2021

QA Engineer

Union Bank
02.2017 - 06.2019

Bachelor - Computer Science

University of Punjab
Tanvir Ahmad