Test Engineer Software Development

SWATHI THUMMALUR

Email: ***************@*****.*** Phone: +1-570-***-****

To make use of my extensive knowledge, skills and synergize with the organization to focus on, and achieve, the long-term goals that have been put into place.

PROFESSIONAL SUMMARY

•Around 9+ years of experience in Manual, Automation and ETL testing performing as a Sr. Software Test Engineer using strong analytical and business skills.

•Strong Knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle

(STLC).

Have collaborated with the Clients Cisco Systems Inc. USA, Selective Insurance USA and MasterCard International, Dublin and Sanofi Pasteur.

•Possess specific experience in Banking, Financial Domains and Healthcare.

•Hands-on experience on automation framework using Selenium RC, and selenium GRID.

•Performed Validations in ETL Source to Target mappings and data transformations between source and target databases using SQL queries.

•Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling, and reporting tools like MicroStrategy and Power BI.

•Extensively worked in validating BI (MicroStrategy, Power BI) reports\Documents

•Experience in Business Process Testing and experience in Oracle E-business Suite applications involving ERP/CRM modules – Order Management, Inventory, Purchasing, Shipping, Financials modules – General Ledger, Accounts Receivable, Accounts Payable.

•Perform testing (both system and UAT) for releases that support Salesforce (CRM) and

•SAP (ERP) systems, and other functional applications across the entire organization for all divisions worldwide.

•Development of company s internal CI system, providing a comprehensive API for CI/CD

•Work across functional (development/testing, deployment, systems/infrastructure) and project teams to ensure continuous operation of build and test systems.

•Perform maintenance and troubleshooting of continuous build/deployment systems.

•Prepare Test Data Strategy and approaches and delivering the test data for the required teams.

•Possess specific experience performing testing including Backend, Frontend, Regression, Functional, System, Interface, Usability, and Black box, Integration Verification and Validation End-to-end and User Acceptance Testing. Experienced in Agile Methodology.

•Proficient in Quality Center for Test Designing, Requirement Mapping, Reports, Test Execution and Defect Tracking. And used organizational level customized Jira tool to write the user stories (Test scripts) and defect tracking.

•Ability to work independently or in a team environment or in a rapid pace environment. An effective communicator and strong analytical, problem solving, Organizational abilities and Presentation skills.

•Having good experience in Waterfall/Agile/V-Model/PUMA software Development methodologies.

EDUCATION:

•Master’s in computer applications, Osmania University, India, 2008

TECHNICAL SKILLS:

•PRIMARY SKILL CATEGORY: Testing Functional, Automation Testing, ETL Testing, Database Testing

•TESTING STRATEGIES: Quick Test Pro (QTP), Test Manager, RTC, JIRA, SOAPUI, Bugzilla, TFS, Rally, Sun-Tracker, ALM

•DATABASES/TOOLS: ORACLE 11i, MS SQL, SQL SERVER 2005, TOAD, Snowflake

•PRIMARY DOMAIN: Banking and Finance, Ecommerce, ERP

•SUB DOMAIN: Credit Cards and Load management.

•AUTOMATED TOOLS: UFT, Selenium, HP Quality center, Order to cash, Order Management,

Restful.

PROFESSIONAL EXPERIENCE:

QA Analyst Oct 2021 - Till Date

SANOFI PASTEUR, Swiftwater, PA

Sanofi Pasteur, the vaccines division of Sanofi, is a global leader in immunization, delivering over one billion vaccine doses annually to protect more than 500 million people worldwide.

Contribution:

•Reviewed and analyzed the business requirements, business process and functional requirements for writing test plan.

•Perform data analytical testing for the BI systems.

•Validation of data transformations and perform End-to-End data validation for ETL & BI systems.

•Strong BI report validation developed using MicroStrategy/Power BI.

•Developed Test Plans, Test Cases and logged defects and tracked them.

•Validated ETL Source to Target mappings and data transformations between source and target databases using SQL queries.

•Collaborated with developers as needed to isolate root cause of defects.

•Performed Smoke Testing, System Testing, System Integrations Testing and User Acceptance Testing.

•Responsible for updating and maintaining the Quality Center for all the defects found during functional and regression testing and follow up the bug life cycle.

•Performed test data preparation and data validation using SQL Tools.

•Developed complex SQL queries for querying data against different databases for data verification process.

•Prepared and executed test scripts using Selenium.

•Executed automated regression test cases and daily regression test suites.

•Used agile process and wrote test cases against user stories.

•Conducted QA meetings for the team to walk-through the Test Plan

•Identify improvements to enhance CI/CD

•Planning and prioritizing of CI automation scope and backlog.

•Conducted defect meetings with developers to walk-through each defect in detail for quick resolutions/fixes.

•Performed Regression Testing after defects were resolved in test environments.

•Documented the weekly status reports and presented the QA process to the management.

•Participated in regular project status meetings related to testing. Developed Test Cases and Test Scripts for UAT Testing.

Environment:

SQL, Toad, Selenium web deriver, Informatica PowerCenter, HP QC 11.0, Jira, Oracle 10g, Windows, MS Office, MS Excel, XML, Snowflake, Rally

Responsibilities:

•Involved in ‘Module Test Plan’ Preparation and Requirements Streamlining.

•Preparing Requirement Traceability matrices for new business Module.

•Guiding the team members and handling the Risks.

•Involvement in Test Design includes Test Data preparation and Reviews.

•Responsible for GUI and Functional Testing, using Black box Testing Techniques.

•Involved in Automation Environment setup using Eclipse, Java, Selenium WebDriver jars and TestNG.

•Designed Test cases Using Selenium WebDriver and TestNG.

•Execution of Tests and Reporting Defects.

•Enhancing the Selenium Test cases for Cross browser testing.

•Involved in solving Environmental problems along with Technical Support People, especially in Sever Connections and Database sharing issues. • Involved in Regression Testing using Selenium.

•Preparation of weekly and monthly status reports. Environment:

JAVA, HTML, XML, JSP, Servlets, EJB, WebLogic, Oracle, Selenium.

Lead QA May 2013 - Mar 2014

MasterCard, Dublin

Location: Kuala Lumpur, Malaysia

Description:

MasterCard InControl is a web-based application, and it maintains the credit cards information issued to the customers by issuer. This allows the users to track the customer’s information and credit statements. It also provides the required reports to the application users.

The family solution application provides real-time text alerts or an email whenever card usage within a specific category or period exceeds set parameter. In this way, the InControl family solution application usage communication channels that is already extremely popular among such consumer.

Contribution:

•Requirements Understanding.

•Used Informatica as an ETL Tool for Developing the Data Warehouse. Regression testing of application in multiple cycles to test the functionality.

•Writing test cases and validating/executing the test scripts using HP Quality Center (11.0), defect tracking using Jira to report and track the defects.

•Creating/Updating Test cases according to the FS and URD

•Coordinating with Development team for Defect Analysis and Communication test result.

•Involvement in peer reviews of the test cases and test data prepared by team members.

•Having major experience in test scripts writing, test reporting, resource planning and coordinating with developers and Business analysts.

•Executing the transactions using UNIX commands and XML scripts.

•Debugging the issues from log files.

Environment:

SQL, Toad, Informatica power center, HP QC 11.0, Jira, Oracle 10g, Windows, MS Office, MS Excel, XML, Unix

QA Analyst April 2012—May 2013

Selective Insurance, USA

Location: Hyderabad, India

Description:

Personal Lines application deals with personal property & automobile insurance. The project team provides the support for maintenance and enhancement of the application system. The changes to the application are carried out as per the customer’s requirements and tested versions are delivered to the customer. Selective Insurance P-lines Application has following Line of Business’s. 1) PCL 2) HOME 3) AUTO 4) Dwelling Fire Contribution:

•Understanding the requirements.

•Deriving the test cases based on the client requirements.

•Executing the Test Cases based on the test cases.

•Involving in peer reviews.

•Performing functional and GUI testing.

•Performing back-end testing. • Bug Tracking and reporting.

•Preparing test metrics & traceability matrix.

•Attending regular status meetings as required with onsite teams.

Environment:

Windows, Oracle, TOAD, HTML, XML, Test Director, Quality Center.

Test Engineer Nov 2010-Mar 2012

CISCO Systems Inc, USA

NGCCRM (Next generation Commitment Compliance and Revenue Manager)

Location: Hyderabad, India

Project Description:

The Next Generation CCRM (Next Gen CCRM) project is chartered with the goal of eliminating these capability gaps, reducing costs, and improving efficiency by delivering on the following key goals: Eliminate manual work by providing a powerful system with new features and capabilities. Integration of CCRM data with downstream data such as EDW (Teradata). Reduce the time lag of hold processing.

Contribution:

•Participated in system design/development and involved in preparation of Test Scenarios, Test Plan and Test Cases for CCRM and NGCCRM reports and Test Scripts as per the specifications.

•Involved in designing Hybrid framework based upon user requirements.

•Created Reusable functions and actions for automation test cases.

•Designed the Automation scripts based upon scenarios by using QTP/UFT

•Prepared the datasheets for regression testing.

•By using UFT, performed the smoke test and regression test suites.

•Based upon test scenarios, various functions methods and Descriptive programming and VB Scripting for writing the test scripts using Unified Functional Testing (UFT).

•Used synchronization and Dictionary objects and Regular expressions concepts where it’s necessary in UFT.

•Worked in the environment of Agile Software development methodology.

•Configure test environment for specific test cases, create test data and execute automated or manual tests, document results and updated and uploaded Test scenarios & Test cases in Quality Center.

•Used Data table methods and Excel objects and Utility objects for designing the reusable functions.

•Participated in cross-functional team meetings to understand the user requirements and documented them.

•Involved in UAT testing along with clients. And prepared the UAT test plans and scenarios to check the application.

•Used SQL Queries to retrieve data from tables and to perform Back-End testing.

•Interacting with the developers in resolving the bugs.

Environment:

SQL, Toad, UFT, Descriptive Programming ALM 10.0, Oracle 10g, Windows, MS Office.

Team Member May 2009 - Oct 2010

Ads Globe

Location: Hyderabad, India

Description:

It is a FREE, feature rich and one-stop online classifieds/ads website, serving over a million locations globally, covering over a dozen advertising zones. The users can post or search free local ads in Real Estate/Rentals, Jobs, Autos, Merchandise, Local Events, Yellow Pages,

Dating/Personals, Services, Pets, and Travel. Users can also advertise their businesses, products, or services on all of Info zeal network websites by posting Ad Links or Ad Banners for FREE.

Contribution:

•Documented the test cases for Enhancements based on Requirements Documents.

•Responsible for testing the e-commerce solution of shopping cart software at front end perform the task of testing in web ERP accounting and inventory management system at the back end as well.

•Performed Database testing and writing SQL Queries. • Tracking defects Environment:

Windows, Oracle, TOAD, HTML, XML, Test Director, Quick Test Pro, Unified Functional Testing (UFT), VB Scripting, Quality Center

Test Engineer Sep 2008 - Apr 2009

Dealsglobe

Location: Hyderabad, India

Description:

It is a FREE, smart, and easy to use shopping guide that helps you find the very best deal you are looking for your everyday purchases or the gifts for that special someone. Dealsglobe.com is built on an automated and intelligent data processing platform that scans millions of product listings every day from hundreds of online merchants and serving you only the very best products with special offers, deals, coupons, promotions, rebates etc. The Website is divided into various modules and applications based on functionality.

Contribution:

•Documented the test cases for Enhancements based on Requirements Documents.

•Reporting module status daily to Test Lead

•Responsible for testing the e-commerce solution of shopping cart software at front end perform the task of testing in web ERP accounting and inventory management system at the back end as well.

•Performed Database testing and writing SQL Queries. Environment:

Quick test pro, UFT, Windows 3, SQL Server, and MS Word, Jira

Contact this candidate