Guncha Gupta

GUNCHA GUPTA IT QA Analyst Phone No: - Email Id:- Address: CHANDIGARH, INDIA Highly motivated and results-oriented QA Analyst with 16+ years of experience in ensuring quality and regulatory compliance for Banking and Retail applications. Seeking to leverage expertise in ETL testing, data integration, mobile application testing (iOS and Android), and Agile methodologies to contribute to a leading IT Services & Consulting firm. Proven ability to collaborate with crossfunctional teams, develop and execute test plans, and deliver high-quality solutions that meet business requirements. Passionate about implementing best practices in quality assurance to drive continuous improvement and enhance customer satisfaction. PROFESSIONAL SUMMARY Experienced QA professional with a proven track record of 16 years in ensuring software quality across diverse industries, including Banking, Retail, Telecom, and Pharmaceuticals. Expertise in mobile application testing (iOS & Android), ETL testing, data integration, and backend system validation, gained through leading IT services companies such as Infosys and Accenture. Successfully led testing efforts for mobile banking applications, retail mobile apps, and ETL processes within CRM and data warehousing environments. Proficient in developing and executing test strategies, plans, and cases, ensuring adherence to functional requirements, security standards, and regulatory guidelines (GDPR). Adept at collaborating with cross-functional teams, including product owners, business analysts, developers, and stakeholders, to deliver high-quality solutions. Possess strong experience in database testing using SQL, data validation, reconciliation, and troubleshooting data quality issues. Skilled in utilizing various testing tools and technologies, including Postman, Appium, Android Studio, Selenium WebDriver, Jenkins, JIRA, Zephyr, and SQL Developer. Contributed to the implementation and maintenance of test environments and data sets to support continuous testing and deployment pipelines. Experienced in both Waterfall and Agile methodologies, participating in Scrum ceremonies, sprint planning, and retrospective meetings. Adept at documenting test results, defects, and recommendations for stakeholders and management, promoting transparency and informed decision-making. Recognized for leadership, mentorship, and fostering a culture of continuous learning and improvement within QA teams. Received accolades for exceeding client expectations, including 'Employee of the Month' recognition for identifying and resolving a critical bug in a major client project. SKILLS Technical Skills: Mobile Application Testing, ETL Testing, Data Integration, SQL, Test Automation, Agile Methodologies, JIRA, Selenium WebDriver, Database Testing, Test Planning & Execution, IVR Testing, OIM & OAM Testing, JD Edwards Enterprise One Testing Core Competencies: Quality Assurance & Testing, ETL & Data Integration, Mobile Application Testing, Team Leadership & Collaboration, Agile & Testing Methodologies, DataBase Testing, Mainframe Testing, JD Edwards Enterprise Testing, Oracle Identity Management(OIM) Testing, Oracel Access Manager(OAM) Testing Soft Skills: Communication, Collaboration, Leadership, Problem Solving, Analytical Thinking, Time Management, Adaptability, Attention to Detail, Mentorship, Continuous Learning WORK EXPERIENCE Mobile Application Tester Mar 2022 - Present Infosys (Chandigarh) Responsible for ensuring the quality and functionality of a retail mobile application on iOS and Android platforms. Tested native features of a retail mobile application on iOS and Android platforms, ensuring alignment with functional specifications and optimal user experience. Collaborated with product owners and business analysts to define acceptance criteria, ensuring application functionality adhered to business requirements. Designed and executed comprehensive test plans and cases, validating features such as shopping cart functionality, payment processing, and order management. Performed regression testing to ensure the stability and compatibility of app updates and enhancements across various device models and operating system versions. Conducted usability testing to evaluate the user interface (UI) and user experience (UX), providing actionable recommendations for improvement. Mobile Test Engineer Apr 2021 - Mar 2022 Infosys (Chandigarh) Responsible for leading the testing efforts for mobile banking applications on iOS and Android platforms, ensuring adherence to functional requirements, security standards, and GDPR guidelines. Conducted thorough functional testing to validate critical banking features, including account management, fund transfers, bill payments, and mobile deposits. Played an active role in Agile ceremonies, participating in sprint planning, daily stand-ups, and retrospective meetings to maintain alignment with project timelines and goals. Performed usability testing to evaluate the user interface and user experience, providing constructive feedback for enhancements and improvements. Led regression testing activities to validate app updates and enhancements, ensuring backward compatibility and seamless performance. Contributed to the implementation and maintenance of robust test environments and data sets, supporting efficient continuous testing and deployment pipelines. ETL Test Lead Mar 2017 - Apr 2021 Infosys (Chandigarh) Led the testing efforts for ETL processes within a banking CRM application environment, focusing on ensuring the accuracy and integrity of data extraction, transformation, and loading processes. Developed comprehensive test strategies and plans, outlining the test scope, approach, and timelines to meet project goals and regulatory requirements. Provided leadership and guidance to a team of testers, ensuring efficient testing execution and delivery of high-quality results. Estimated testing efforts and adjusted them as needed to maintain project timelines. Conducted meticulous data validation and reconciliation processes to maintain consistency and integrity across data warehouses and reporting systems, ensuring adherence to business rules and regulatory standards. Designed and executed test cases, scripts, and scenarios to validate ETL workflows and data transformations, ensuring accuracy and efficiency. Leveraged SQL queries and scripting tools for comprehensive backend database testing, identifying and resolving data discrepancies and performance bottlenecks. Collaborated closely with development teams, business analysts, and data architects to clarify requirements, address technical challenges, and ensure seamless project execution. Developed comprehensive test strategies and plans, defining the scope, approach, and timelines to align with project objectives and regulatory requirements. Directed a team of testers, providing technical guidance and mentorship to ensure effective test execution, defect tracking, and reporting processes, resulting in high-quality deliverables. Conducted thorough data validation and reconciliation across data warehouses and reporting systems, ensuring data integrity, consistency, compliance with business rules, and regulatory requirements. Designed, implemented, and executed test cases, scripts, and scenarios to rigorously validate ETL workflows and data transformations for accuracy and efficiency. Utilized SQL queries and scripting for backend database testing, effectively identifying and resolving data discrepancies and performance bottlenecks. Senior QA Analyst Dec 2012 - Mar 2017 Infosys (Chandigarh) Responsible for managing and conducting testing activities for data integration projects in the banking sector, with a specific focus on ETL processes, data migrations, and backend systems. Managed comprehensive testing activities for complex data integration projects within the banking sector, focusing on assuring the quality of ETL processes, data migrations, and backend systems. Collaborated effectively with cross-functional teams to validate data integrity and effectively troubleshoot data quality issues, ensuring seamless integration and reliable data flows. Played a key role in conducting and participating in technical reviews and walkthroughs to ensure the quality of QA deliverables. Developed and executed robust regression test suites to validate updates and enhancements to ETL pipelines, ensuring consistent functionality and performance. Conducted meticulous functional, visual, smoke, regression, accessibility, and exploratory testing to guarantee product quality and unwavering adherence to requirements. Conducted thorough data flow and quality testing, tracing data from source systems to subsystems using specialized Data Warehousing Tools (DWT), ensuring data integrity throughout the pipeline. Proactively pulled data from systems, organized it effectively, and prepared comprehensive reports for clients, ensuring data transparency and accessibility for stakeholders. Conducted testing of Web, UNIX, and Mainframe-based applications, demonstrating adaptability and diverse technical skills. Senior Software Engineer Accenture (Bangalore) Apr 2010 - Nov 2012 Performed software functional testing on diverse applications across multiple platforms, including Web, UNIX, and Mainframebased applications. Independently conducted testing on enterprise software, specifically Enterprise JD Edwards (E1) and Oracle Identity Access Management Application (OIM). Managed the verification of a significant volume of Exam Portfolios daily, highlighting proficiency in handling large datasets. Conducted a detailed study and analysis of a customer information system's functionality, identifying key areas for testing and improvement. Independently performed software functional testing on enterprise software, specifically Enterprise JD Edwards (E1) and Oracle Identity Access Management Application (OIM), ensuring functionality aligned with business requirements. Managed the verification process of around 50 Exam Portfolios daily, showcasing strong analytical and organizational skills. Created and maintained comprehensive test artifacts, including the Requirement Traceability Matrix, to ensure comprehensive test coverage and traceability. Successfully managed testing schedules and effectively tracked testing progress throughout the entire Software Testing Lifecycle (STLC), ensuring on-time project delivery. Trained and mentored junior testers, enhancing their technical skills and contributing to overall team performance. Validated output files generated by mainframe batch processes, ensuring data accuracy and integrity. Achievements: Received Employee of the Month (June 2021) in recognition of proactively identifying and contributing to the rectification of a critical bug in a test environment, saving a major client project worth millions of pounds. Received appreciation from clients for valuable contributions to critical projects, demonstrating a strong work ethic and commitment to exceeding expectations. Software Engineer Sep 2007 - Apr 2010 Accenture (Bangalore) Conducted manual testing of pharmaceutical software applications, focusing on functionality, usability, and regulatory compliance. Assisted in the creation and execution of validation protocols and reports for pharmaceutical software systems, ensuring strict adherence to industry standards. Conducted thorough manual testing of pharmaceutical software applications, ensuring compliance with industry standards and regulatory requirements (e.g., FDA regulations). Developed and executed detailed test cases and test scripts derived from user requirements and business processes, ensuring comprehensive test coverage and accuracy. Performed validation testing to guarantee that software systems met stringent FDA and other regulatory standards, contributing to the delivery of safe and compliant pharmaceutical software solutions. Provided valuable feedback and recommendations for optimizing software quality and streamlining testing processes, contributing to continuous improvement initiatives. Played a key role in documenting test procedures, meticulously recording results and identified issues to ensure thoroughness and compliance with auditing requirements and internal reviews. Associate Software Engineer Jan 2007 - Sep 2007 Accenture (Bangalore) Performed functional testing of Interactive Voice Response (IVR) systems, focusing on validating call flows, menu options, and system responses in accordance with telecommunications requirements. Executed predefined test cases and scenarios to ensure the reliability, accuracy, and performance of IVR applications. Conducted functional testing of Interactive Voice Response (IVR) systems within a demanding telecommunications environment, verifying call flows, menu options, and system responses for adherence to stringent requirements. Executed comprehensive test cases and scenarios to rigorously validate the reliability, accuracy, and performance of IVR applications, ensuring seamless user interactions and optimal system performance. Collaborated effectively with developers by identifying and reporting defects using dedicated issue tracking tools (e.g., Bugzilla), facilitating timely resolution and contributing to the overall quality of IVR solutions. Participated actively in test planning and strategy discussions, contributing valuable insights and recommendations for continuous improvement, ultimately enhancing testing processes and team efficiency. Actively participated in test planning and strategy sessions, contributing insights and suggestions to improve testing processes and overall team effectiveness. Conducted various types of testing including smoke, integration, and system testing to thoroughly verify IVR system functionality and stability under various conditions. Assisted in creating and maintaining test documentation, including test plans, test cases, and test reports, ensuring thorough documentation and traceability of testing efforts. EDUCATION Post Graduate Diploma in Computer Applications Panjab University, Chandigarh (07/2020 - 07/2021) Bachelor of Technology (B.Tech.) in Information Technology Punjab Technical University, Jullundhur (06/2002 - 07/2006) ACHIEVEMENTS Received Employee of the Month (June 2021) in recognition of spotting and helping to rectify a critical bug found in a test environment for a major client project worth millions of pounds. Received appreciation from clients for contributions to critical projects and was deputed to client locations in New Jersey, USA, on a Business Visa. Certifications Infosys Certified Selenium Basic Automation Tester (Infosys - 2022) Infosys Certified Global Agile (Infosys - 2020) Projects Adidas - Retail Company Involved in testing the Adidas Retail App, an iPad application designed for store associates, running on iOS 12 and above, to enhance the in-store customer experience. Tested key features of the app, including browsing the e-commerce shop, offering a wider range of products and sizes not readily available in-store, and facilitating various fulfillment options like home delivery, click and collect, and basket transfer. Contributed to the quality assurance of a global retail solution aimed at providing a seamless and consistent shopping experience across all Adidas stores. Royal Bank of Scotland (NatWest) - Banking Company Tested various bank brands under the NatWest Group on Android and iOS devices for a Multi-Factor Authentication (MFA) project using Sauce Lab for simulated device testing. Contributed to the implementation of Strong Customer Authentication (SCA) solutions for e-commerce transactions, aligning with regulatory requirements and enhancing the security of online banking applications. Capital Group of Companies (CGC) - Banking Company Conducted testing on Project SDS, a data warehousing application designed to facilitate data sharing across multiple investment systems within Capital Group of Companies. Tested various functionalities of SDS, including its role as a Data Repository, data pipeline, and data integrator, ensuring accurate and efficient data flow for operational and downstream applications. Capital Group of Companies (CGC) - Banking Company Conducted testing on the PCS project, a Wealth Management initiative at Capital Group of Companies, aimed at transforming technology infrastructure and enhancing services for High Net-Worth (HNW) clients. Focused on key areas, including Custodian Operations, Billing, Accounting, and Asset Allocation, to ensure accurate and efficient handling of client assets. Contributed to the transformation of the PCSIT infrastructure, supporting the company's move towards establishing an Industry Standard RIA (Registered Investment Advisor) model, aligning technology with evolving industry standards. Education Testing Services (ETS) - Educational Company Conducted testing on a UI application developed by ETS, the world's largest non-profit educational testing and assessment organization, designed to enable student registration and administration of exams, including GRE, TOEFL, and PRAXIS. Involved in testing the deployment of Oracle Access Manager (OAM) at ETS, addressing the complexities of user authentication, authorization, and web-based single sign-on across multiple applications. Contributed to the implementation of robust application security policies, including defining rules for authentication and authorization for diverse applications. Tested the integration of Oracle Identity Management, ensuring seamless functionality for examinees retrieving GED information and administrators managing test centers. Wyeth Pharmaceuticals (WYETH) - Pharmaceutical Company Conducted testing on a project for Wyeth Pharmaceuticals, focusing on ensuring compliance with regulations related to pharmaceutical manufacturing and marketing processes across various locations. Involved in creating, updating, authoring, conducting dry runs, and executing test cases. Responsible for initiating Deviation Reports when discrepancies arose, ensuring minimal deviations in effort and schedule adherence for Software Requirements (SRs) and Work Requests (WRs). America Online (AOL) - Telecom Company Performed comprehensive testing to evaluate the functionality, performance, and reliability of an IVR system for America Online (AOL), a prominent telecommunications company, ensuring optimal system performance and seamless user experience. Hobbies Technology Trends, Mentoring & Coaching, Travel & Photography, Community Volunteering, Digital Marketing & Branding LANGUAGES English, Hindi #CreatedByOutspark#