Home

DURGA CHAITANYA ALURI - Python QA Automation

sanjana@abdsinc.com

Location: Andover, Massachusetts, USA

Relocation: Remote

Visa: H1B

Durga Chaitanya Aluri Location: Massachusetts SUMMARY: Over 10years of progressive experience in software testing, including Automation and manual testing for web and mobile applications in Banking, E-commerce, and Healthcare domains. Accumulated 6 years of experience working on diverse projects for esteemed clients, including NFCU, Commonwealth, Best Buy, Family Health Care in the US. Experienced in designing and building test Automation Frameworks, utilizing Jenkins for Continuous Delivery and Continuous Integration. Experience with Python web frameworks, such as Django or Flask. JavaScript's asynchronous nature aligns well with the way modern web applications work. Proficient in Selenium WebDriver with JavaScript and testing framework using page object model with page factory approach. Strong knowledge of embedded systems architecture, including hardware, firmware, and software integration. Developed Test Scripts for BDD using Cucumber and utilized Appium for mobile testing on Android Integrated Pandas with Python testing libraries to execute and validate data transformation logic. Designed and implemented robust data manipulation scripts using Pandas for QA data preparation. Proficient in writing SQL queries for data validation and backend testing to ensure data integrity and accuracy. Developed and executed MySQL database queries using the MySQL connector, with hands-on experience in retrieving and validating data through Selenium and Python automation scripts. Experienced with cross-functional teams (developers, architects, DevOps) to troubleshoot complex issues, especially those involving system integrations. Designed, executed, and automated REST API test cases using Postman collections and scripts. Integrated Postman tests into CI/CD pipelines for automated regression testing. Perform hands-on testing of embedded systems and Bluetooth-enabled devices. Conducted comprehensive testing of SOAP-based web services, including WSDL validations. Designed, executed, and automated REST API test cases using Postman collections and scripts Good experience running Selenium automation scripts and updating the scripts according to enhanced requirements using Selenium WebDriver in Java and Python. Experience in open-source test automation frameworks, including Selenium, Cucumber, and Testing. Located web elements using XPath expression and CSS selector. Strong knowledge of SQL queries, RDBMS, and databases. Developed Test Scripts to implement Features, Test Scenarios, and Step-Definition for BDD (Behavior Driven Development) using Cucumber (Gherkins format). Performed Device Lab Testing on various activated devices and worked on Mobile app testing of Native, Web, and Hybrid apps. TECHNICAL SKILLS: Methodologies Agile, Waterfall, SDLC,SDTC Testing Tools Quality Center/ALM, QTP, Selenium, Appium, Maven, Testing, MS-Excel, JIRA, Radar, BugZilla, Cypress, Protractor, Playwright, SOUPUI, JMETER, Ready API,Cucumber Test Build & Integration Tools Maven, Jenkins, Cloud Operating Systems (OS) Windows, Mac, Android, Unix, Linux Database MS-SQL Server, MS Access, Oracle Scripting Languages SQL, VB Script, JavaScript, PHP, HTML, CSS, XML, JSON, Node.js (Restful web services), jQuery, Programming Languages C, C++, Java, Python, Gherkin IDE s Eclipse, Visual Studio Code, IntelliJ, PyCharm Browsers Internet Explorer, Mozilla Firefox, Google Chrome, Safari Version Control Tools Git, Code Search, Docker API Testing SOAP UI, Rest, Postman, Ready API, Karate, Swagger Types of Testing E2E Testing, Security Testing, Integration Testing, Regression Testing, UAT Testing, Black Box Testing, White Box Testing, Unit Testing, UI Testing, Localization Testing, Performance Testing and Ad-hoc testing, Manual Testing Education details: Master s in computers and information systems security from Wilmington University, New Castle, DE. Bachelor s in pharmacy, JNTU-Kakinada, India. WORK EXPERIENCE: Client: NFCU Jul-2024 Till Date Role: Python QA Automation Responsibilities: Developed and executed Python-based automation test scripts to validate banking data workflows and ensure data integrity across multiple systems. Utilized libraries like Pandas, NumPy, Hashlib, and Dask for advanced data processing, analysis, and validation. Designed and implemented test cases for validating data transformations, calculations, and integrity between source and target systems. Automated data validation processes for structured and unstructured datasets to ensure compliance with banking standards. Collaborated with cross-functional teams to define test strategies for banking application features Focusing on critical financial calculations and transactions. Generated comprehensive test reports and defect logs using DevOps, enabling effective defect tracking and resolution. Validated Excel-based reporting systems by creating automated test workflows using openpyxl for data extraction, comparison, and validation. Conducted data quality checks using Python libraries to ensure accuracy in customer records, transactions, And account details. Supported Dev and QA teams by debugging and resolving automation test issues, enhancing test coverage For banking processes. Client: Commonwealth (Boston) Aug 2023 May 2024 Role: QA Analyst Responsibilities: Developed and executed robust test automation scripts using Python in PyCharm IDE. Leveraged Pandas and NumPy libraries to perform complex data manipulation, aggregation, and validation for claims data. Conducted thorough validation of claims data transformation rules and business logic for healthcare domain standards. Created and optimized SQL queries to extract and compare large datasets from relational databases. Verified claims adjudication data by cross-referencing against policyholder records, provider details, and service codes. Ensured the accuracy of payment calculations and adherence to contract terms and conditions. Conducted end-to-end testing of the claims process, ensuring compliance with healthcare standards. Documented defects related to data inconsistencies, automation script failures, and business rule violations in defect tracking tools. Identified discrepancies in claims data and collaborated with cross-functional teams to resolve issues. Used Python libraries to generate detailed test reports, highlighting discrepancies and anomalies in claims data. Documented detailed test cases, validation scripts, and test execution results for healthcare-specific scenarios. Provided training and mentoring to junior team members on Python-based data validation techniques and healthcare domain concepts. Client: Best Buy, MinneapolisOct 2019 July-2023 Role: QA Analyst (SDET) Responsibilities: Developed automated test scripts using Selenium with Eclipse IDE in a BDD framework to validate front-end functionalities. Tested shopping cart, product search, and checkout workflows across different devices and screen resolutions. Performed end-to-end testing on iOS and Android devices with various carriers to ensure smooth order placement and fulfillment. Verified app responsiveness, usability, and compatibility for both platforms. Designed and implemented robust test strategies for both front-end and back-end systems Conducted compatibility testing to ensure the e-commerce platform performed consistently across popular web browsers. Logged and tracked bugs in Jira, ensuring documentation of replication steps and issue prioritization. Worked closely with development teams to perform root cause analysis and recommend fixes for identified issues. Tested API endpoints using Postman and Swagger to validate functionality, performance, and security. Integrated API testing into the CI/CD pipeline to automate execution during builds. Used SQL queries to verify correct data flow between the application and database, ensuring order and transaction data integrity. Used SQL queries to verify data integrity and consistency during order placements, inventory updates, and payment processing. Monitored application logs using Splunk to identify server-side errors, slow API calls, and bottlenecks during order processing. Utilized Git for centralized workflow management, including branching and merging for codebase updates. Validated workflows such as placing orders, payment authorization, shipment tracking, and refunds for various delivery methods (e.g., home delivery, in-store pickup, Shipping, locker pickup, curbside pickup, home delivery). Identified and implemented enhancements to test processes, automation frameworks, and CI/CD pipelines. Worked closely with developers, product owners, and stakeholders to ensure feature requirements were met. Actively participated in Agile ceremonies such as daily stand-ups, sprint planning, and retrospectives to align QA efforts with team goals. Prepared test plans, designed test strategies, and ensured all test activities aligned with project timelines and quality standards. Created and maintained detailed test plans and test cases and processed documentation on Wiki pages. Regularly updated and optimized automated test scripts to handle new features and changes in application workflows. Contributed to improving test frameworks and the QA process by implementing best practices and automation efficiencies. Client: Family Health Care, Brooklyn, NY May 2018 - Oct 2019 Role: Software Tester/ QA Analyst Responsibilities: Experience in BDD automation frameworks like Cucumber and developed feature files in the Gherkin language. Developing automated test scripts using Selenium, an open-source end-to-end testing framework, to test web applications and APIs. Conducted manual and automated API testing using Postman, Swagger, and SOAP UI, validating RESTful and SOAP APIs. Designed, developed, and executed automated test scripts using Selenium WebDriver with Java to validate web application functionality, user interactions, UI elements, and backend processes Ensuring thorough test coverage and efficient execution of functional and regression tests. Focused on verifying request-response structures, payload integrity, and status codes. Integrated Selenium and API test automation into the CI/CD pipeline using Jenkins, enabling automated Testing with every build and facilitating quick defect identification and resolution. Logged and tracked defects in Jira, working collaboratively with development teams to reproduce, diagnose, And resolve issues provided detailed reports and test logs for better defect management. Prepared detailed test execution and defect reports, summarizing test results, defect status, and quality Metrics Communicated findings and recommendations to stakeholders to support informed decision-making. Actively collaborated with business analysts, developers, and product managers to understand requirements, Discuss test coverage, and ensure all scenarios are validated efficiently. Client: EeZee Technologies Pvt, ltd, India May 2011 July 2015 Role: Software Test Engineer Responsibilities: Directing, leading, and motivating teams in transformational assignments, working on succession planning of the team, and rendering technical guidance to the staff. Plan on the estimations for the sprint. Analyzed User Stories thoroughly and familiarized with the web application and mortgage domain. Participated in the regular project team meetings to discuss automated testing strategies and test plans. Created positive and negative tests and Boundary value tests, created Test Data, and wrote test cases to cover all the possible scenarios of testing. Developed an effective automated test script design to maximize the reusability and maintainability with a page factory approach using a page object model. Created selenium scripts to test and perform functionality, regression, and E2E testing. Performed intensive regression testing with the help of a data-driven approach using Selenium Web Driver with testing data providers. Extensively involved in database testing, checking data integrity through SQL queries after data migration by embedding queries in Selenium. Configured different environments in Jenkins to execute test cases against hard launch or soft launch. Used Postman &REST Assured for rest service testing. Introduced Element highlighters in the script to make UAT testing more manageable and more attractive. Performed smoke testing after each building by running the smoke suite, including high-priority test cases and manually exploring touched areas, verifying fixes to check if they meet business and functional expectations. Performed GUI and Functional testing for the web application to test the enhanced features by Developing SQL queries that peered into the back end to verify transactions performed on the front-end GUI. Analyzed software defects and reported them using the JIRA bug tracking system. Created screenshots and attached them to bug reports. Responsible for creating test automation suits projects from inception to ongoing maintenance state. Keywords: cprogramm cplusplus continuous integration continuous deployment quality analyst user interface javascript active directory microsoft Delaware New York