Qa Automation Engineer

Shreya Tiwari

QA Automation Engineer

219-***-****, **************@*****.***

LinkedIn: https://www.linkedin.com/in/shreya-tiwari-aaa87237 1

Professional Summary

Highly skilled QA Automation Engineer with over 7+ years of experience in the insurance, health, global library, and e- commerce industries. Proficient in the Software Testing Life Cycle, including analysis, requirement gathering, design, development, enhancements, execution, and defect life cycle. Expertise in designing automation test suites for web-based applications, cloud-based applications, web services, database, Informatica batch flows, Hadoop/HBase batch flows and performance testing.

Technical Skills

Automation Tools RubyMine IDE, TOSCA DI, IntelliJ IDE, Cucumber (TDD, BDD), Page Object Model, Selenium WebDriver,REST Assured, TestNG, Junit, Watir,Chai,Mocha

Tools SOAPUI, Postman, JMeter, Splunk, Informatica PowerCenter, IICS, ESP, Putty, UltraEdit, WinSCP, UAT, Salesforce, Kafka, Control-M Web Technologies HTML, CSS, XML, JavaScript, JSON

Defect Tracking Tools JIRA, Azure DevOps, HP ALM, Quality Center, RRC, RTC Programing Languages Ruby, Java, SQL

Operating Systems Windows, UNIX, LINUX, Mac

Project Management Agile, Kanban, Waterfall, Microsoft Office, Confluence Databases Oracle, SQL Server, HBase

Source Version GitHub, SVN

Big Data Tools Hadoop, HDFS, MapReduce

CI Tools Jenkins

Certifications

Tosca Automation Specialist Level 1

Tosca Automation Specialist Level 2

Certified Ruby/Cucumber Test Automation Developer from Columbus Technology Solutions

Six Sigma Graduate Certificate - Purdue University Professional Experience

Nationwide, Columbus, OH Mar 2020 - present

Test Automation Developer

As a member of a cross-functional organization, I collaborated with four teams to drive the automation of Informatica batch flows, REST Services leveraging the Ruby/Cucumber framework, and TOSCA Automation Tool. In addition to spearheading the development of automation solutions, I actively participated in partner support testing, production validation, and performance testing, utilizing JMeter to deliver quality results. Responsibilities:

• Create and maintain automated test cases for REST and SOAP services using Ruby/Cucumber framework on RubyMine IDE.

• Write SQL queries to fetch test data from RDBMS such as Oracle and SQL Servers and validate the target data against the database.

• Spearheaded the implementation of continuous integration by developing Jenkins CI/CD tasks to execute test cases on a nightly basis.

• Possess strong expertise in utilizing GitHub to facilitate code promotion from local branches to higher branches.

• Utilized SOAP and REST calls to facilitate communication and verify message integrity within the Kafka Cluster.

• Conducted sanity testing on APIs during the migration from NITRO to AWS.

• Leveraged Splunk tool to monitor daily Production reports and offer support to partners.

• Streamlined automation scripts to ensure data conformity following an Oracle database upgrade.

• Performed rigorous security testing to guarantee that APIs remain inaccessible without the Authorization Token.

• Developed and implemented test plans, test suites, and test cases, and tracked and reported defects using Jira.

• Proficiently utilized the CA(ESP) workstation to execute scheduled batch jobs and run batch flows for various Shreya Tiwari

QA Automation Engineer

219-***-****, **************@*****.***

LinkedIn: https://www.linkedin.com/in/shreya-tiwari-aaa87237 2

applications spanning Nationwide Investments.

• Leveraged the Extract Job Calendar (EJC) to establish precise start and end dates for jobs prior to execution.

• Accountable for streamlining the end-to-end flow encompassing file placement, EJC setup, application execution, target CIM file extraction, and subsequent comparison through automation leveraging the Ruby/Cucumber framework.

• Demonstrated expertise in working with various Informatica tools such as Repository Manager, Designer, Workflow Manager, and Workflow Monitor.

• Spearheaded the development of a Test Automation Framework utilizing TOSCA Commander and authored, maintained, and customized scripts in TOSCA. Implemented test scripts from RubyMine IDE within TOSCA Commander.

• Utilized TOSCA Data Integrity (DI) to automate file comparison for Batch flow testing, streamlining the testing process.

• Demonstrated proficiency in creating automation test cases for batch and REST API testing using TOSCA and developed a comprehensive test automation framework for effective regression testing using TOSCA.

• Work with TOSCA modules such as Test Cases, Requirements, Test Case Design, and Execution List to create and maintain automated test cases for REST API testing.

• Contributed to Performance Testing by ensuring error-free test performance suite through conducting tests in JMeter and updating the test data as necessary.

• Demonstrated proficiency in effectively managing and leading offshore resources, overseeing requirement analysis, test strategizing, test cycle planning, estimation, and reviewing test plans and execution.

• Actively participated in bi-weekly testing touch base meetings with the QA project team, effectively collaborating and providing status updates on testing progress.

• Contributed to the monthly Investment Test Forum, engaging in discussions, and providing updates and issue resolution as required.

• Proficient in ServiceNow to create RFC (Request for Change) for production implementation and database changes.

• Conduct production support testing and adeptly handle any failures or issues that may arise post-implementation.

• Adhere to Agile (Scrum) methodologies and actively participate in daily stand-up meetings, bi-weekly retrospective sessions, and show-and-tell meetings.

Sr Quality Analyst

Eversana Lifesciences LLC, Mason, OH Sep 2019 - Mar 2020 Responsible for testing and automating APIs and the UI on the Salesforce platform to address the widespread system stability issues that were faced on the older platform. Responsibilities:

Created and maintained a comprehensive regression test suite featuring business-critical functionalities, leveraging Azure DevOps to author detailed test cases.

Created effective test scripts based on mapping sheets for CRM to SFDC migration, ensuring comprehensive testing coverage and accuracy.

Conducted rigorous regression testing prior to each UAT and Prod release, ensuring high-quality deliverables.

Validated GUI alignment and column-level data in the Salesforce Application, ensuring optimal user experience.

Conducted API testing utilizing Postman & SOAPUI and authored effective test cases.

Leveraged the REST Assured Java framework to perform effective automation testing for API services.

Utilized Selenium WebDriver, Java, and TestNG to develop automated test scripts that ensure comprehensive test coverage and high quality for the SFDC application.

Effectively validated data through creating and executing SQL queries on MS SQL Server Management Studio and verifying data against API responses.

Utilized Azure DevOps for logging defects and tracking tasks.

Demonstrated an ability to clearly communicate and collaborate with Solution Architects to create and update system design documents and workflows in Confluence on a project basis.

Created detailed checklists (test plans) for each user story, as well as reproducible bug reports in Azure DevOps.

Mentored a team of Quality Assurance professionals by setting objectives, providing guidance and feedback, and motivating them to become more efficient and effective.

Lead and mentor offshore QA team members in developing and evolving standard QA practices to improve efficiency and ensure high-quality deliverables.

Shreya Tiwari

QA Automation Engineer

219-***-****, **************@*****.***

LinkedIn: https://www.linkedin.com/in/shreya-tiwari-aaa87237 3

Coordinated effectively with the offshore team members on a day-to-day basis, and provided KT sessions as needed, ensuring smooth project execution.

Collaborated with business analysts and the test team to conduct risk analysis and assessments related to automation testing, ensuring robust test coverage and quality assurance.

Reproduced and debugged issues, providing customized scripts to support system test teams for effective QA validation.

Created detailed bug reports in Jira and closely tracked the defect lifecycle, ensuring prompt resolution and high- quality deliverables.

Effectively followed Agile methodologies across the team, actively participating in daily standup meetings to provide status updates and ensure compliance with company code standardization rules. Sr Test Engineer

Online Computer Library Center (OCLC), Dublin, OH Nov 2018 - Sep 2019 responsible for creating an automation framework for the Hadoop batch process using the Ruby/Cucumber framework from ground up.

Responsibilities:

Built a robust Test Automation framework from the ground up to test the end-to-end flow of Hadoop/HBase batch flows using Ruby/Cucumber Framework.

Created comprehensive Test Plans, Scripts, and Defect Management Templates from scratch, including the development of manual test cases and test scripts.

Implemented Continuous Integration and Continuous Deployment (CI/CD) pipeline using Jenkins to ensure consistent and efficient testing of batch flows on a daily and monthly basis.

Performed manual testing of batch process jobs by running Shell Scripts on Unix servers and monitored MapReduce/Spark jobs on Hadoop clusters.

Validated and extracted the yarn log for the targeted collection id on the Dev/QA cluster job tracker to ensure quality results.

Created and managed staging directories for test data files mounted to QA and Dev servers to ensure efficient and effective job monitoring.

Created automation scripts to remotely connect to Unix/Linux servers via the SSH protocol, execute commands, file(s) on a given path, and capture the output.

Developed manual test cases and test scripts to ensure optimal test coverage of every job in the batch flow for various file formats such as marc, marcxml, csv, mods, onix, and cdf.

Created a regression test suite and triggered batch jobs on all tracks simultaneously every day to ensure that everything was working as expected.

Provided Root Cause Analysis for any defects identified by the QA team, submitting monthly reports.

Executed batch jobs on Unix/Linux servers using SSH, and scheduled jobs on remote servers using Control-M.

Updated HBase table data and validated test artifacts created in HDFS to ensure data accuracy.

Monitored Jobs on Hadoop clusters, ensuring that all jobs were running correctly and efficiently.

Conducted sanity testing in UAT and Prod Environment during deployment and communicated results to the business.

Validated the fields transferred correctly in the Firefly Database and journal history tool by running tests using a generic account with sudo access.

Used Marc and CSV input test files and ran jobs on remote systems using Control-M.

Parsed through the output XML files and validated job status, checked inserted or updated records in HBase.

Created and executed test cases using IntelliJ as IDE and Cucumber framework, running tests in QA and Dev environments.

Implemented the feature to run the test when triggered and/or scheduled, executing positive and negative test scenarios, and validating errors.

Provided regular status reports to management on testing progress and test automation results.

Used JIRA as a virtual board for stand-up, created test tickets for tracking test progress and raising bugs.

Followed Agile (Scrum) QA methodologies, conducted daily stand-up meetings for status updates, and adhered to company code standardization rules.

Test Automation Developer

Shreya Tiwari

QA Automation Engineer

219-***-****, **************@*****.***

LinkedIn: https://www.linkedin.com/in/shreya-tiwari-aaa87237 4

Nationwide, Columbus, OH Sep 2017 - Nov 2018

Responsible for automating the Duck Creek AgencyPortal UI, REST & SOAP services and Database validation using Ruby/Cucumber frameworks and PowerShell scripting. Responsibilities:

Automated REST services and UI testing using Ruby Cucumber framework, writing test scripts in Gherkin language, and implementing them in Ruby Mine IDE.

Utilized Guidewire Policy Center and Clear Quote tool to validate data bridged from Agency Portal tool.

Proficient in Page Object Model, Selenium WebDriver, and Waitr for UI automation.

Wrote PowerShell scripts to automate e-form PDF filling.

Validated REST web services response codes, error messages, and JSON responses against the UI application and databases.

Performed end-to-end characteristic testing of data flow from Acord PDF to Clear Quote tool.

Conducted both manual and automation testing, including testing of all REST methods and assertion testing for the API.

Conducted daily regression and smoke testing using Jenkins, both locally and on a virtual machine, to ensure application functionality and stability.

Improved the automation test framework by optimizing scripts and implementing dynamic parametrization to increase efficiency and reduce maintenance efforts.

Validated task creation in Automated Work Distributor (AWD) tool for negative scenarios and used RTC and RRC for planning and tracking work.

Collaborated with Business Analysts and Requirements Analysts to break down epics into user stories and build backlog for development sprints.

Utilized HP Quality Center (QC) ALM to track, report, and manage defects throughout the testing lifecycle.

Developed Test Plan, Test Scenarios, Test Cases, and Low-Level Design and performed UNIT, Integration, and System testing.

Sound knowledge on version control and continuous integration tools for collaborating with developers and ensuring that code changes are properly tested.

Followed Agile (Scrum) QA methodologies, conducted daily stand-up meetings for status updates, and adhered to company code standardization rules.

QA Tester

MicroInfo Tech, Inc., Edison, NJ Sept 2016 - Jun 2017 Responsible for testing the existing feature on the application after upgrading the ServiceNow tool. Responsibilities:

Conducted testing on the ServiceNow tool's administration module, including the creation of new Users, Groups, Roles, IT Services, Applications, and Business Services.

Performed testing on various ServiceNow modules, including Forms, Lists, Views, UI Policy, UI Scripts, UI Actions, View Rules, Welcome Page Content, Map Pages, and other UI elements, ensuring their functionality and usability met business requirements.

Conducted back-end testing for database validations and front-end validation testing, ensuring system functionality met business requirements.

Created and executed test cases and scripts for functional, non-functional, and negative testing in ALM and JIRA based on business requirements, utilizing Java.

Performed automation testing using JAVA, Selenium, and page object model and created automation test scripts in Java using Eclipse.

Conducted SQL queries to validate data in the database and provided detailed reports for review.

Performed testing on ServiceNow tool administration module, creating new users, groups, roles, IT services, applications, and business services.

Conducted testing for Forms, Lists, Views, UI Policy, UI Scripts, UI Actions, View Rules, Welcome Page Content, Map Pages, and other UI elements in ServiceNow modules.

Automated testing using Java and Selenium with a page object model approach.

Conducted regression and smoke testing after each SIT, UAT, and production build.

Collaborated with business analysts and developers to understand the application requirements and design.

Created and executed unit, integration, and system test cases. Shreya Tiwari

QA Automation Engineer

219-***-****, **************@*****.***

LinkedIn: https://www.linkedin.com/in/shreya-tiwari-aaa87237 5

Provided comprehensive test coverage for both front-end and back-end testing, including SQL database validations.

Contributed to the development of test automation frameworks and strategies.

Utilized ALM and JIRA for test case and test script management Purdue University, Hammond, IN Aug 2015 - May 2016 Graduate Assistant: Engineering Project Management and Economic Analysis

Facilitated pre-planned, interactive review sessions with 120 Students over 2 semesters.

Assisted in creating and developing course content, materials, and assignments that align with the course objectives and student learning outcomes.

Provide feedback to the instructor to help improve the quality of the course and ensure student success.

responsible for grading assignments and exams and assisting in the preparation and posting of grades.

Held regularly scheduled office hours to provide individual and group assistance to students and ensured timely review of the assignments and posting of the grades.

Maintain a professional and respectful attitude towards all students and colleagues, creating a positive learning environment.

QA Manual Tester

Amazon India Pvt., Ltd., Hyderabad, India Sep 2013 - Jul 2014 Worked as a QA Manual Tester and performed front end testing. Responsibilities:

Developed and executed test cases based on business requirements, and managed defects and other QA artifacts through the T4 ticketing tool, resolving tickets within the T4 ticketing team.

Created Test plan & Defect Management Templates.

Created test-design document for the workflows identified for manual testing.

Created functional, non-functional, and negative test cases based on the acceptance criteria.

Created and maintained test result documents and defect tracking reports.

Maintained a log of the tickets resolve and document each ticket.

Troubleshooted technical issues on the Amazon website and Merchant accounts. Education

Purdue University, Hammond, Indiana Dec 2014 - May 2016 Master of Science in Technology

Computer Information and Industrial Engineering Technology Jawaharlal Nehru Technological University, Hyderabad, India Sep 2009 - May 2013 Bachelor of Technology

Electronics & Communication Engineering

Contact this candidate