Quality Assurance Test Automation

Ashish P Patel (U.S Citizen) Clarksville, Maryland (MD), US.

202-***-**** https://www.linkedin.com/in/ashish-p-patel-sdet *************@*****.*** https://www.linkedin.com/in/ashish-patel-57729714 Professional Summary:

Over a decade of progressive skill set enhancement in Information Technology (Databases, Quality Assurance

(Automation/Manual Testing) and Development) of Client/Server, Web/Mobile and Cloud Applications.

Hands on Software Development Architect-Engineer of Test Automation Frameworks (UI/API) for DevOps with open source stack (Cucumber, Jenkins, BitBucket/GitLab, Git, SpringBoot, Maven/NodeJs, Java/JavaScript, Junit/TestNG, RestAssured, SeleniumWebDriver, WebdriverIO, Serenity) using Behavior Driven Methodology (BDD) aimed to standardize testing, reduce code redundancy for ROI, accuracy, efficiency and productivity.

Subject matter expert (SME) for Test Automation Initiatives.

Hands on practitioner of Object Oriented Programming (OOPS) languages (Java/JavaScript/Python) and data structures (JSON/XML/YML/GraphQL).

Experience and knowledge of developing, deploying and testing of REST/SOAP API repositories with Spring Boot in micro-service architecture and Queues (KAFKA/RabbitMQ).

Experience of UI (Page/E2E), API (CRUD, Positive-200, Negative-400/500, E2E) test scenarios in pipelines and performance testing with load runner.

Author Leidos white paper (No code low code automated test architecture) and recipient of excellence awards.

Excellent interpersonal skills, team player grooming analysts, testers on automated testing and tools.

Experienced user of test tools like Swagger (Open-API), Ready API, Postman, SOAP UI and SOA Test.

Excellent testing techniques (Shift left, Data driven, Functional, Black box and White box).

Experience in establishing QA standards and processes (test procedures, plans and scenarios) to meet STLC.

Analytical skills for data models in relational and dimensional databases, data analysis and mapping.

Versatile with database object schema, table, structured query language (SQL) portions DDL, DML, DQL and editors SQL, TOAD, AJAX Data Loader, DB2 visualizer.

Thorough understanding of data extraction, cleaning, transformation and validation processes.

Well Versed with SDLC, STLC, Agile (Scrum), Kanban, management tools (Agility (Version One), JIRA, TFS) and agile ceremonies (Backlog, Grooming, Sprint planning, sizing, stand-up and retrospective). Academics Awards and Recognitions: LinkedIn: https://www.linkedin.com/in/ashish-patel-57729714

Author- Leidos white paper-BDD Wrapper (No code low code automated test architecture).

Performance Excellence Award- December 2023.

Team Award – Benefit Overall Summarization Service (BOSS) - July 2023.

Team Award - CCE IT Modernization Team – December 2022.

Individual Award - outstanding efforts – June 2022.

Performance Excellence Award- December 2019.

Bachelors in Mechanical Engineering- L.D. College of Engineering, Ahmedabad, Gujarat, India -2001.

Diploma in Mechanical Engineering- B & B Institute of Technology(BIT), Anand, Gujarat, India-1996. Technical Skills:

Methodology Waterfall, Agile (Scrum, Safe), Agile(BDD), Kanban Languages Gherkin, Screenplay, Java, Python, C#, .NET, JavaScript, SQL, HTML, JSON, XML and YML. Databases

MS SQL Server 2008/2008 R2, 2014, IBM DB2, OMNI Main frame, Salesforce (CRM DB), PostGres, Oracle 12c, Mongo DB.

Data Modeling Tool IBM Info Sphere, CA ERWIN

Bug Tracking

Tools QC 9.0, HP ALM 11.0, Microsoft TFS, Rally, QA complete, JIRA, JAZZ and Agility (Version One). Tools and Utilities

Jenkins, Spring Tool Suite(STS),Cucumber, Behave, Selenium Web driver, WebdriverIO, Playwright, Cypress, RestAssured, Junit, TestNG, Maven, Node.js,PIP, Gitlab, SourceTree, Bit Bucket, Micro service architecture-Restful, GraphQL and Soap API’s, KAFKA, RabbitMQ, SOATest, SoapUI, Postman, ReadyAPI, Swagger, LoadRunner, Jmeter, Eclipse, VS Code, PyCharm, Hibernate, Embarcadero Rapid SQL, MS SQL, IBM DB2, TOAD, AJAX Data Loader, AutoSys, NotePad++, MS Office, Visio, BrowserUse, Gemini-Flash, ChatGpt AI Models and Confluence. Operating Systems MS Windows 2000/XP/Vista/7/10, MS Server 2008, R2, 2012 Domain Knowledge Defense, HealthCare, Pharmaceutical, Retirement, Financial, Telecom and Research Professional Experience:

2019 to Present

Social Security Administration (SSA) Software Development Architect/Engineer Test Automation (Sr.SDET) Leidos-TechPerm -Tisha Group LLC Computer Systems Analyst/Programmer 3 (CSA3) Leidos is an industry and technology leader supports smarter, efficient digital and mission innovations to federal agency Social Security Administration (SSA) providing financial protection for Americans through various programs. This includes administering retirement, disability, survivor, and family benefits, as well as enrolling individuals in Medicare. SSA also manages Supplemental Security Income (SSI) and issues Social Security numbers. Responsibilities:

Implemented API and UI automated testing framework solutions, standards with flexibility to test different code base and data base with high volume test scenarios for ROI, efficiency, accuracy and productivity.

Architected, developed and implemented BDD Test Automation Framework (BDD Wrapper). A low code no code solution with open source stack Java, Rest Assured and Cucumber-Behavior Driven Development

(BDD) methodology. This implementation has ability to generate feature files from open api (Swagger), JSON or excel programmatically. It can compare request and response schemas programmatically. It can parse request/response data structures, make endpoint calls and perform validations programmatically. It can perform PDF validations programmatically. This solution reduced dependency on programming and coding skills, reduce code redundancy and code management, resource on boarding and training times. Integration of this solution with micro-service provides standardization for Test Automation in CI/CD progressive pipelines. It helps to achieve testing ROI, accuracy, efficiency and productivity. This solution performs most functions provided by AI Testing Tools (Helenium, Evo Suite, Applitools).

Agency wide ping and security BDD API automated scenarios approved by Enterprise Architect (EA), Modern Development Environment (MDE) and development leads.

Architected and implemented automated UI testing framework with open source stack Java, JavaScript selenium, webdriverIO and cucumber for ITIP(.NET) project. (itip-bdd).

Developed, tested, deployed and maintained (10K+) UI (Page/E2E) and API (CRUD, Positive-200, Negative-400/500, E2E) test scenarios in pipelines.

Built and deployed automated API testing repositories/pipelines with decoupled Continuous Testing pipeline having more than10K test scenarios.

Subject matter expert (SME) for test automation initiatives across teams in agency. Providing BDD automated testing expertise, technical solutions and sharing automated testing experience across agency for OBIS initiatives like T16, FALCON, CAA and PSRA. ODTTED, EvidencePortal, EnterpriseAPI, computational utilities (computation services) teams for API module, end to end and legacy data validations.

Supporting performance (load/stress) testing with LoadRunner

Developed proof of concept testing frameworks with python, playwright/cypress, BrowserUse, Google- Gemini-flash/Open AI-ChatGPT (AI Models) for client.

Supporting management activities like feature file standards, scenarios, planning, analysis and management of test reports from progressive pipeline CI/CD.

Environment:

Bit Bucket, Jenkins, Eclipse/VS Spring Tool Suite (STS), Spring Boot, Maven, Cucumber, Behave, Java, Python, JavaScript, Node.js, PIP, SeleniumWebDriver, WebDriverIO, Playwright, Cypress, BrowserUse. AI models Google Gemini, Open AI Chat-GPT, Junit, REST/GraphQL/SOAP micro service Architecture, RestAssured, PostGres, DB2, Postman, SOATest, ReadyAPI, Swagger (OpenAPI), Agility (VersionOne) and Confluence. 2017 – 2019

Transportation Security Agency (TSA-DHS) Software Development Engineer Test Automation (SDET) Accenture Federal -Tisha Group LLC

Accenture Federal Services, a wholly owned subsidiary of Accenture LLP, provides services to federal organizations. On this project AFS serves Travel Security Agency (TSA) of Department of Homeland Security (DHS). AFS provides development and maintenance of vetting functionality with various vetting partners viz (NCIC, SAVE, TVS, IDENT, IAFIS-Biometrics-finger prints).

Responsibilities:

Member of a scrum team worked on federal initiative of Technology Improvement and Modernization (TIM) PreCheck application for vetting used at domestic and international airports. Developed and implemented CI/CD pipeline using micro-service architecture and automated testing for all environments.

Crucial role to develop and implement automated testing framework for TIM project having Cross Population Search UI, NG REST micro-services, Legacy project with Siebel UI and SOA services. with flexibility to point to various environments and scalability to test end points of NG micro services, SOA services and UI with Serenity screenplay, Java, Rest Assured and Serenity-Cucumber.

Architected and developed stub generator to build dynamic payloads in XML and JSON formats standardizing testing efforts. Testing accuracy and efficiency with regression test suite for legacy SOA services and Siebel UI reducing manual testing time, efforts and resources.

Developed load/stress tests for orchestration and performance of REST micro services. Configured and Implemented security automated tests for two way SSL enabled REST micro services.

Automated integration test suites for external vetting partners like SAVE, NCIC, TVS, IDENT and IAFIS- Biometrics and E2E (black box) test suites for TIM-NG REST micro-services Environment:

GitLab, Jenkins, Eclipse/VS, SpringToolSuite(STS), Maven, Serenity/Cucumber, Java/Python, Serenity-screenplay, WebDriver, Junit, REST/SOAP micro service architecture, SQL Developer, Oracle, IBM JAZZ, Siebel, SoapUI. 2016 – 2017

Fannie Mae- BC Forward Software Development Engineer Test Automation (SDET) Fannie Mae is a Govt. sponsored enterprise aiming to expand secondary mortgage market by securitizing mortgages allowing lenders to reinvest their assets. Engaged with project EFFS (Early Funding Future State) functionality aiming to reduce the funding time to the lenders by checking the eligibility, providing loan authorization and the expected amount of funding request received by Fannie Mae on any business day thereby reducing the loan processing time. Responsibilities:

Automated test scenarios for EFFS API using Cucumber, Selenium and Java.

Used JIRA for test scenarios, test plans and test execution using.

Reviewed and Groomed business requirements and functional specification as an agile team player.

SQL queries, sub-queries in Rapid SQL for PostGres.

Agile/Scrum Methodology and ceremonies for project activities. Environment:

Java, Maven, Junit, Selenium Web Driver, Eclipse IDE, Jenkins, SourceTree, TOAD, SQL, JIRA, Spring Framework, Hibernate Framework, PostgreSQL, Hibernate, Embarcadero Rapid SQL, Putty, Postman, source tree and Git. 2015 – 2016

CareMetx (Walgreens Venture) Senior Software Test Automation Engine CareMetx provides mobile solutions, dashboards, portals and other technology solutions to help track and manage the patient's journey from intake to outcomes. Serving patient assistance program management using CareMetx Connect, Health Care Provider Portal and reporting solutions with Manufacturing Dashboards for pharmaceutical industry clients.

Responsibilities:

Automation framework for CareMetx Connect with Selenium Web driver, Java, Page Object Model (POM) design and Excel for data driven testing.

SQL queries, sub queries and joins for validating integrity and accuracy of data received via UI or reported via Manufacturing Dashboard, Client Reports and data feeds received from the clients.

Used QA complete for FDA compliance 21CFR11 to control access of different user roles.

Ran audit logs for drugs Risk Evaluation and Mitigation Strategy (REMS) of reputed pharmaceutical clients.

Count validation, dimensional analysis, statistical analysis and data quality validation for data migration. Environment:

Java, Maven, Selenium Web driver 2.0, Eclipse IDE, QA complete by Smart Bear, Version One, SQL Server 2008/12. 2013 – 2015

Prudential Financial Services (RITS) QA Automation Engineer/Data Analyst Contech Incorporation

Prudential Financials – Retirement IT Solutions provides support to retirement business wing of Prudential Financials. Involved in various applications like PRU-Force (Sales Force) which is CRM applications generating leads and cross- sell opportunities that helped prudential to increase revenue, client retention and reducing cost of sales and PSW

(Plans Sponsor Web) a portal for plan sponsor to review plans, receive alerts, manage participants, download action required reports and research plan investments.

Responsibilities:

Automated testing highly transactional Sales force web application PRU-Force with Selenium and JAVA.

Analyzed, transformed, validated and integrated enterprise data warehouse information with IBM DB2, MS SQL, TOAD, AJAX Data Loader for proprietary and Non-Proprietary Funds. Tested services with SoapUI.

Supported updates and enhancements of PRU-Force (CRMODS DB), generating mapping and DDLs using forward engineering and reverse engineering of CA ERWIN. Team member to build validation engine for incoming payroll files to support validation, help improve data quality with IBM DATASTAGE.

Data base testing of compliance limit reporting on Plan Sponsor Web that comprised of various platforms like OMNI Mainframe, Enterprise Data Warehouse, ODS, Enterprise Service Bus and COGNOS. Environment:

Java, Maven, Junit, Selenium Web driver, Eclipse, SoapUI, Omni Mainframe, CA Erwin, InfoSphere, DATASTAGE, COGNOS, DB2, TOAD, SQL, AJAX Data Loader, MS SQL Server (CRM ODS), TestNG, HP ALM, TFS. 2011 - 2013

Connected Care Solutions Software Quality Assurance Engineer Tele-health is a software suite that clinically transforms the ICU, using a proactive care model that provides a solution to growing physician and nurse shortages while dramatically improving quality of care. Through an ideal blend of medicine with technology, this care model leverages clinical expertise, patented processes and cutting-edge technologies to improve critical care delivery. The program’s extensive reporting including daily management and ICU benchmarking of outcomes – sets it apart from other critical care solutions. Responsibilities:

Analyze requirements and develop test scenarios, data setup for testing.

Developed SQL queries and sub queries and joins to validate integrity of reports..

Involved in creating the test plan based on BRD, Technical Specification.

Used SQL DML to retrieve data and SQL DDL to update the information into database. Environment:

QualityCenter9.0/10.0, SQL Server 2008/12, MS Office Suite, Microsoft Visio. 2009 - 2011

North Carolina LLC Software Test Engineer

Verizon Wireless is the largest mobile communications network and wireless phone provider in the United States. To increase customer loyalty, retention, satisfaction, Verizon adopted IGO (Intelligent global ordering) and eCRM. Market investigation, customer communications and information gathering are important pillars of eCRM. Responsibilities:

Analyze use cases to create test scenarios and test data, requirement analysis to prepare DTPS. ETL specifications, flow diagrams and artifacts from BRD.

Smoke, Functional, Integration and Regression test of the IGO and eCRM web application.

Database Integrity and reliability validation with SQL queries for data persisted. Worked with offshore QA team for functional, regression and integration testing. Environment:

Quality Center 9.0, SharePoint, SQL Server 2008, MS Office Suite, Microsoft Visio.

Contact this candidate