Ayubkhan Nazeer Ahamed Khan
Dallas,USA
Summary
- Results-driven Test Lead/Test Manager with extensive experience in software quality assurance, test management, and team leadership across diverse domains.
- Demonstrated expertise in strategic test planning, risk-based testing, automation strategy, and stakeholder communication, ensuring high-quality deliverables in fast-paced Agile and Waterfall environments.
- Currently pursuing a Post Graduate degree in AI & ML in Data Science at the University of Texas – Austin.
- Proficient in Azure Pipeline Testing, with extensive experience using Azure Data Factory (ADF) pipelines for data validation, monitoring, and debugging.
- Skilled in managing pipeline executions and ensuring data integrity across different stages in Azure DevOps.
- Experienced with ETL Informatica Cloud IDMC/IICS for ETL processes, data migration, data profiling, and ensuring data quality compliance.
- Skilled in writing complex SQL queries for data validation, supporting end-to-end data testing processes, and performing database integrity checks on SQL Server and other databases.
- Experienced in developing data testing automation frameworks using Python and SQL, executing automated validation for data migration, transformation, and profiling.
- Proficient in defect lifecycle management using ADO, JIRA, and HP ALM. Capable of logging, triaging, verifying, and closing defects while generating metrics reports to effectively communicate testing status to stakeholders.
- Developed and implemented data quality scripts in Python and Pyspark to validate data across different cloud-based environments.
- Skilled at interpreting system architecture diagrams and summarizing key testing metrics in visually meaningful reports and dashboards.
- Proficient in data manipulation using Python Numpy & Pandas.
- Knowledgeable in exploratory data analysis techniques such as Univariate, Bi & Multivariate analysis with various chart analysis like Histograms, Boxplots, Scatterplots, Heatmaps etc.
- Experienced leader who has successfully led QA teams in various projects while mentoring junior testers on best practices and guiding them in tool usage and project workflows.
- Acquired SAFe Agile Training and certification along with hands-on experience in CI/CD tools like Jenkins.
- Completed ASCENT Leadership training/certification in TCS for young managers.
- Possesses strong analytical and programming skills with a constant drive to learn and groom my skill set.
- Excellent communication and interpersonal skills combined with being a quick learner make me a valuable team player and key innovator.
Overview
13
13
years of professional experience
1
1
Certification
Work History
SDET QA Team Lead
PricewaterhouseCoopers LLP
03.2024 - Current
- Company Overview: PwC is the world’s largest professional service firm, formed in 1998 from a merger between Price Waterhouse and Coopers & Lybrand. PwC employs over 150,000 people across 150 countries. Some of the products & services provided by PwC are Advisory Services, Audit and Assurance, Government Services, Human Resource Services, Private Company Services, Sustainability and Climate change, Tax Services and Transaction Services.
- Configured and monitored Azure Data Factory pipelines for data integrity and validation, leveraging Azure DevOps for continuous integration and deployment.
- Designed and implemented data testing automation frameworks with Python, focusing on data transformation and validation for large datasets.
- Developed complex SQL scripts and stored procedures to validate data transformations and integrity.
- Ensured data quality compliance across multiple stages using Informatica Power Center and IDQ.
- Collaborated with cross-functional teams to maintain high standards in data testing and quality assurance, producing actionable insights on data issues and process improvements.
- Experience in executing performance tests using JMeter to simulate various scenarios, such as concurrent user loads, high traffic volumes, and peak usage periods. Monitor test execution to ensure accuracy and reliability.
- Created test plans with well-defined test approach for test level of the application testing including creation of test scenarios, test cases, requirement traceability matrix to ensure all requirements are covered in test case document.
- Involved in deliverable reviews of each phase (i.e. requirements review, test plan review, test case review and test results and/or test report review) including defect reviews and reporting.
- Proposed value ads and doing POCs. Taking initiatives, providing proposals to bring in more business from client.
- Interacted with team members to ensure smooth progress of project work and ensured adherence to quality norms throughout the implementation process.
- PwC is the world’s largest professional service firm, formed in 1998 from a merger between Price Waterhouse and Coopers & Lybrand. PwC employs over 150,000 people across 150 countries. Some of the products & services provided by PwC are Advisory Services, Audit and Assurance, Government Services, Human Resource Services, Private Company Services, Sustainability and Climate change, Tax Services and Transaction Services.
- Identified viable test strategies to verify products' unique functionality requirements.
- Aligned with QA engineers and testers to replicate and track bugs and defects for correction in subsequent iterations.
Data Analyst and SDET QA Automation Testing
Albertsons - Safeway Inc
08.2023 - 03.2024
- Company Overview: Safeway, Inc. is an American supermarket chain founded in 1995. It is a subsidiary of Albertsons after being acquired by private equity investors lead by Cerberus Capital Management in January 2015. Safeway’s primary base of operations in the Western and Central United States, with some stores located in the Mid-Atlantic region of the Eastern Seaboard.
- Worked in a robust Selenium WebDriver-based Cucumber BDD framework, resulting in reduction of manual testing efforts.
- Led a team of 5 QA Engineers, prioritizing tasks and mentoring junior members, which increased team productivity by 30%.
- Developed complex SQL queries for database validation, ensuring data integrity and supporting backend testing.
- Integrated automated testing into CI/CD pipelines with Jenkins, improving build and deployment efficiency.
- Experience in executing performance tests using JMeter to simulate various scenarios, such as concurrent user loads, high traffic volumes, and peak usage periods. Monitor test execution to ensure accuracy and reliability.
- Experience working in Azure cloud, Azure Dev Ops, Azure Data Factory, Databricks to handle cloud Data.
- Experience working in Leapworks tool to automate the regression scenarios without coding involvement.
- Involved in deliverable reviews of each phase (i.e. requirements review, test plan review, test case review and test results and/or test report review) including defect reviews and reporting.
- Proposed value ads and doing POCs. Taking initiatives, providing proposals to bring in more business from client.
- Interacted with team members to ensure smooth progress of project work and ensured adherence to quality norms throughout the implementation process.
- Safeway, Inc. is an American supermarket chain founded in 1995. It is a subsidiary of Albertsons after being acquired by private equity investors lead by Cerberus Capital Management in January 2015. Safeway’s primary base of operations in the Western and Central United States, with some stores located in the Mid-Atlantic region of the Eastern Seaboard.
SDET - QA Test Analyst
CVS Health Corporation
07.2020 - 08.2022
- Company Overview: CVS Health Corporation (previously CVS Corporation and CVS Caremark Corporation) is an American retail pharmacy and health care company headquartered in Woonsocket, Rhode Island. CVS Health's assets include CVS Pharmacy, CVS Caremark, CVS Specialty, and the retail clinic Minute Clinic. Subsidiaries and assets are CVS Pharmacy, MinuteClinic, ExtraCare, CVS Photo, OTCHS. CVS Pharmacy is one of the largest retail pharmacy chains in the United States.
- Implemented automated regression tests with Selenium, reducing the regression suite execution time by 50%.
- Gathered requirements with business users to cover the testing aspects of various subject areas.
- Played a key role in transitioning the company to a more agile test automation approach using Appium for mobile testing.
- Participated in regular code reviews, reinforcing best practices and maintaining code quality standards.
- Collaborated with the development team to integrate QA processes into the SDLC, promoting a culture of quality.
- Worked on effort estimates which involved providing the number of hours for an approximate count of test cases by analysing the test scenarios, test cases complexity, preparation of data setup, execution of test cases and defect reporting and their closure.
- Worked on HP ALM as a test management tool where requirements were mapped to the test cases, execution of test cases in test lab.
- Delegated the task to team members and guided them towards the specified approach to obtain the best out of them and reviewed the performed tasks and validated the correctness of the defects reported in ALM.
- Executed the test cases in multiple desktop browsers and mobile applications on client provided environment.
- Reported the defects and bringing them to a justified closure by following the proper bug life cycle.
- Created various KPI reports using HP ALM and Excel.
- Conducted walkthroughs with the client, Business Analyst and the Business team on test results document.
- Design, develop, execute, and maintain automation scripts for functional and regression testing for CVS pharmacy desktop & mobile web/app.
- Involved in deliverable reviews of each phase (i.e. requirements review, test plan review, test case review and test results and/or test report review) including defect reviews and reporting.
- Proposed value ads and doing POCs. Taking initiatives, providing proposals to bring in more business from client.
- Conducted trainings and prepared training schedule and functional document as knowledge base document with respect to Pharmacy Applications.
- Perform accessibility testing for Desktop Web as per web content accessibility guidelines (WCAG).
- Prepared traceability matrix and test completion report for system testing.
- Interacted with team members to ensure smooth progress of project work and ensured adherence to quality norms throughout the implementation process.
- Identified test cases for manual and automation with Selenium Web Driver for smoke test, functional and regression tests.
- Woking on generating burn down, velocity charts and test execution summary report using Rally and Jira.
- CVS Health Corporation (previously CVS Corporation and CVS Caremark Corporation) is an American retail pharmacy and health care company headquartered in Woonsocket, Rhode Island. CVS Health's assets include CVS Pharmacy, CVS Caremark, CVS Specialty, and the retail clinic Minute Clinic. Subsidiaries and assets are CVS Pharmacy, MinuteClinic, ExtraCare, CVS Photo, OTCHS. CVS Pharmacy is one of the largest retail pharmacy chains in the United States.
Senior Developer
Kirkland's, Inc.
12.2019 - 05.2020
- Company Overview: Kirkland's, Inc. is an American retail chain that sells home decor, furniture, textiles, accessories and gifts. It operates 434 stores in 37 states as well as an e-commerce enable website. It is based in Brentwood, TN.
- We developed the enhancement requirements for the website.
- Bugs and errors are fixed in the code and deployed.
- Worked in Agile model to interact and deliver the product to customers.
- Kirkland's, Inc. is an American retail chain that sells home decor, furniture, textiles, accessories and gifts. It operates 434 stores in 37 states as well as an e-commerce enable website. It is based in Brentwood, TN.
Application Support executive
Dick’s Sporting Goods
05.2019 - 11.2019
- Company Overview: Dick's has 610 stores in 47 states in the Eastern United States. The company also owns Golf Galaxy, Inc., a golf specialty retailer, with 82 stores in 30 states. The company also operates specialty chains True Runner and Field & Stream.
- We handled the Orders, Returns, adjustments in OLC.
- In EDM and Biztalk we handled the Ecommerce Data collect.
- In SEA we calculate the shipping eligibility, restrictions etc.
- Dick's has 610 stores in 47 states in the Eastern United States. The company also owns Golf Galaxy, Inc., a golf specialty retailer, with 82 stores in 30 states. The company also operates specialty chains True Runner and Field & Stream.
Testing QA Analyst
Giant Eagle Inc.
07.2018 - 04.2019
- Company Overview: Giant Eagle is an American supermarket chain with stores in Pennsylvania, Ohio, West Virginia, Indiana, and Maryland. The company was founded in 1918 in Pittsburgh, Pennsylvania, and incorporated on August 31, 1931.
- We handled the Items, item details, promotions and adjustments in RP.
- In Retalix HQ we add/maintain/edit the item and its promotional information.
- In Deal Central we create/manage promotional deals.
- Giant Eagle is an American supermarket chain with stores in Pennsylvania, Ohio, West Virginia, Indiana, and Maryland. The company was founded in 1918 in Pittsburgh, Pennsylvania, and incorporated on August 31, 1931.
Application Support executive
Target corporation
02.2016 - 02.2017
- Company Overview: Target Corporation is the second-largest discount store retailer in the United States, Target operates 1,834 stores throughout the United States.
- In PIM we handled the Pricing details of the items, SKUs along with all other attributes of that product. It’s the repository of complete information of a product.
- In Prism we handled the Price changes and Price update details.
- Compshop helps in fixing the price competitively with other stores like Walmart.
- DLR helps to Automate the Seasonal Price offers for the products.
- Target Corporation is the second-largest discount store retailer in the United States, Target operates 1,834 stores throughout the United States.
Application Support executive
Target corporation
02.2012 - 06.2014
- Company Overview: Target Corporation is the second-largest discount store retailer in the United States, Target operates 1,834 stores throughout the United States.
- TVS - Target Video Solutions, TCM - Target Case management are critical applications where the surveillance cameras were handled, monitored, troubleshooted, recorded and analyzed for client requests.
- TCM used to identify thefts and legal issues.
- Target Corporation is the second-largest discount store retailer in the United States, Target operates 1,834 stores throughout the United States.
Education
Post-Graduate Certificate - AI & ML in Data Science
University of Texas At Austin
Austin, TX10-2025
Skills
- Data Science, DB, SQL
- ETL Informatica IDMC/IICS
- Functional testing
- Automated testing
- Regression testing
- Test planning
- Dev-Ops Engineer
- Production Support
Accomplishments
✔ Post Graduate in AI & ML in Data Science
✔ Microsoft Certified Azure Fundamentals AZ - 900
✔ GitHub – Copilot Certification
✔ IICS Informatica ETL Data Analysis and Data quality
✔ SAFe Agile Certification
✔ ASCENT Leadership training/certification for young managers
✔ Oracle 11G certification
Certification
- Post Graduate in AI & ML in Data Science
- Microsoft Certified Azure Fundamentals AZ - 900
- GitHub – Copilot Certification
- IICS Informatica ETL Data transformation and Data quality
- SAFe Agile Certification
- ASCENT Leadership training/certification for young managers
- Oracle 11G certification
Honors And Awards
- Client appreciation for quick and Robust implementation of Covid Vaccination process.
- Client appreciation when we become the Leaders in USA to setup Covid Vaccination booking through web and Mobile apps.
- Client appreciation for Successful Retlix HQ Implementation in Giant Eagle corp.
- My team got Best team award for supporting Target Corp Online operations in Uruguay.
Personal Information
Work Permit: H1B
Training
- 2023, IICS Informatica Data Analysis, Online, External
- 2021, SAFe Agile certification, Online, CVS/TCS
- 2019, Ascent Training for Young Managers, Chennai, TCS
- 2019, Ascent Ievolve courses for managers, Chennai, TCS
- 2017, Data Mining basics and Tools, Bangalore, TCS
- 2016, Data Warehouse concepts, Chennai, TCS
- 2015, Teradata, Chennai, TCS
- 2014, Big DATA, Chennai, TCS
- 2013, Datastage, Chennai, TCS
- 2012, Oracle PL/SQL, Chennai, TCS
- 2012, Soft Skills, Chennai, TCS
- 2012, Retail Basics, Chennai, TCS
- 2012, Initial Learning Program, Chennai, TCS
Technical Experience
Azure DevOps, Windows, PYTHON, C, C++, JAVA, Javascript, SQL, .NET, HTML, XML, UNIX, Oracle technologies, Selenium, Cucumber BDD framework, HTML, CSS, Javascript, DB, DB2.
Languages
English
Full Professional
Timeline
SDET QA Team Lead
PricewaterhouseCoopers LLP
03.2024 - Current
Data Analyst and SDET QA Automation Testing
Albertsons - Safeway Inc
08.2023 - 03.2024
SDET - QA Test Analyst
CVS Health Corporation
07.2020 - 08.2022
Senior Developer
Kirkland's, Inc.
12.2019 - 05.2020
Application Support executive
Dick’s Sporting Goods
05.2019 - 11.2019
Testing QA Analyst
Giant Eagle Inc.
07.2018 - 04.2019
Application Support executive
Target corporation
02.2016 - 02.2017
Application Support executive
Target corporation
02.2012 - 06.2014
Post-Graduate Certificate - AI & ML in Data Science
University of Texas At Austin
Similar Profiles
Swathi SrinivasanSwathi Srinivasan
Cloud & Digital Senior Associate at PricewaterhouseCoopers LLPCloud & Digital Senior Associate at PricewaterhouseCoopers LLP
Daniella SandoraDaniella Sandora
Experienced Assurance Associate at PricewaterhouseCoopers LLPExperienced Assurance Associate at PricewaterhouseCoopers LLP
David Boyd, FCPA CIRP LITDavid Boyd, FCPA CIRP LIT
Partner at PricewaterhouseCoopers LLPPartner at PricewaterhouseCoopers LLP