RAKSHIT KAPUR
New Delhi
Summary
Experienced Quality Assurance Lead with 11+ years of comprehensive involvement in project management, software quality assurance, and test planning across multiple domains, including HR and Health. Proven track record in leading and mentoring teams to ensure high-quality deliverables in fast-paced environments. Expert in designing and implementing automated testing strategies using tools like Selenium WebDriver, REST Assured, and Postman, with a strong background in Google Cloud platform, enhancing data integrity and system efficiency. Strong analytical skills and adept at crafting complex SQL queries for data validation and manipulation in Azure Data Factory, with extensive experience in database systems including DB2, Oracle, SQL Server and Hadoop ensuring robust data warehousing solutions. Expertise in developing Python driven scripts to test the data. Strong understanding of Tableau tool for data analysis and testing of the reports generated. Recognized for exceptional cross-cultural adaptability and communication skills, facilitating seamless integration into diverse work environments, and contributing to international projects with a focus on delivering precision and client satisfaction. Holds valuable certifications in Agile methodologies and automation tools, positioning as a strategic asset in the global QA community, with a readiness to drive innovation and quality assurance standards in international markets.
Overview
14
14
years of professional experience
Work History
Senior Test Engineer
Jet2Travel Technologies Pvt. Ltd.
New Delhi
08.2024 - Current
- Performing ETL testing on the data received from different sources in Azure data factory from where millions of data is processed by running pipelines and then test it by framing complex SQL queries
- Python driven scripts to validate that, processed data is bug free and is usable to generate BI reports
- Analyzed requirements documents to ensure proper coverage of testing activities.
- Identified root causes of defects found during software testing cycles.
- Evaluated existing test suites regularly and made necessary modifications or additions when needed.
- Assisted in developing training materials for new testers onboarding process.
- Provided technical guidance to junior testers by reviewing their work and providing feedback as necessary.
- Conducted reviews of test cases with stakeholders to ensure accuracy and completeness.
- Monitored application performance in order to identify potential issues or bottlenecks that could affect user experience.
- Participated in design reviews with developers to ensure quality standards are met throughout development lifecycle.
- Worked closely with developers in resolving complex issues related to software functionality.
- Created detailed reports on the progress of each project phase including bug tracking and resolution status.
- Performed functional, system, integration, regression, load and performance testing of software applications.
- Developed and maintained test plans, strategies, procedures, and scripts for manual and automated tests.
QA Lead
Safehouse Technologies
India
06.2020 - 08.2024
- Performing ETL testing on the data received from different sources in Azure data factory from where millions of data is processed by running pipelines and then test it by framing complex SQL queries and Python driven scripts to validate that, processed data is bug free and is usable to generate BI reports
- Spearheading and supporting a team of four, managing schedules, project tracking, and providing technical and functional guidance
- Ensuring data is correctly loaded into EDW database tables from Source tables and validate functionality and data accuracy in destination tables
- Utilizing mapping sheets from Business Analysts to craft complex SQL queries for EDW table manipulation
- Performing ETL testing on the data received from different sources in Azure data factory from where millions of data is processed by running pipelines and then test it by framing complex SQL queries and Python driven scripts to validate that, processed data is bug free and is usable to generate BI reports
- Generating, testing, and analyzing the BI reports developed in Tableau
- Establish and oversee QA policies and procedures, including comprehensive documentation
- Designing test plans for each sprint
- Conducting manual/automated testing of BI reports using Selenium WebDriver with TestNG framework to ensure release stability
- Executing web automation for websites using Selenium WebDriver
- Performing both manual (using Postman) and automated testing (using Selenium WebDriver and RestAssured) of APIs.
Senior QA Engineer
GeneticWeb Technologies
India
08.2016 - 06.2020
- Conducted test estimation, create test plans and test suites
- Liaise with Business Analysts and Development teams to address and resolve issues
- Managed daily updates and report to clients
- Executed testing on ETL tables with large data volumes and complex logic in an EDW
- Validated the complete data flow from staging to warehouse tables, ensuring accurate data delivery to dimension and fact tables
- Implemented complex SQL queries for testing on DB2/MySQL databases
- Conduct functional, health, smoke, and regression testing of reports to confirm accuracy.
Associate Consultant
Capgemini
India
10.2013 - 07.2014
- Designed, reviewed, and executed test cases, developed review checklists and test case templates
- Tested ETL processes including staging, intermediate, facts, and dimensions
- Performed functional testing of analytical and operational reports
- Logged and managed defects in the HPQC tool
- Tested and documented the tracing history of detected defects
- Collaborated with Business Analysts and Development teams to solve issues
- Reported daily testing status to management.
QA Engineer
Aon Hewitt
India
06.2010 - 05.2013
- Assimilated HR domain expertise, applying this knowledge to effectively test ETL tables (staging, intermediate, facts, and dimensions) and reports developed using the Cognos tool
- Designed, reviewed, and executed test cases, ensuring data accuracy through complex SQL queries
- Conducted thorough functional and data testing of reports to verify data accuracy, extensively testing the reports' aesthetics and outputs in various formats such as Excel, PDF, and CSV
- Managed defect tracking using Jira, maintained defect tracing history, collaborated with Business Analysts and Developers to resolve issues, and consistently reported daily testing status.
Education
Master of Computer Applications (Computers) -
Guru Gobind Singh Indraprastha University
India05.2010
Skills
- Project Management
- Software Quality Assurance
- Test Planning
- Test Strategy
- Test Estimation
- Test Cases Design
- Regression Testing
- Functional Testing
- API Testing
- ETL Testing
- Azure Data Factory
- Tableau
- BI Reporting Testing
- Python
- Agile methodology
- Postman
- Web Automation Testing
- Google Cloud Platform
- Data Analysis
- Selenium
- DB2
- Oracle
- SQL Server
- Hadoop
- Jira
- Automation Tools
- BI Tools
- Database Systems
- Java
- Automation: REST Assured APIs
Timeline
Senior Test Engineer
Jet2Travel Technologies Pvt. Ltd.
08.2024 - Current
QA Lead
Safehouse Technologies
06.2020 - 08.2024
Senior QA Engineer
GeneticWeb Technologies
08.2016 - 06.2020
Associate Consultant
Capgemini
10.2013 - 07.2014
QA Engineer
Aon Hewitt
06.2010 - 05.2013
Master of Computer Applications (Computers) -
Guru Gobind Singh Indraprastha University
Similar Profiles
Venkata Nagaraju InakolluVenkata Nagaraju Inakollu
Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)
S ChetanS Chetan
Assistant Manager - Finance at ANIMALL TECHNOLOGIES PVT LTD, Technologies Pvt LtdAssistant Manager - Finance at ANIMALL TECHNOLOGIES PVT LTD, Technologies Pvt Ltd
Shweta SinghShweta Singh
Support Engineer-IT at I-Telemetry Technologies Pvt. Ltd. (Subsidiary of Aaxis Nano Technologies Pvt. Ltd.)Support Engineer-IT at I-Telemetry Technologies Pvt. Ltd. (Subsidiary of Aaxis Nano Technologies Pvt. Ltd.)
Manav SaxenaManav Saxena
Technical Lead at Digicommerce Solution LLPTechnical Lead at Digicommerce Solution LLP
Manvendra KumarManvendra Kumar
Manager- Finance & Costing at Genpact India Private LimitedManager- Finance & Costing at Genpact India Private Limited