Name: Mahitha Mosali
Phone: 404-***-****
Role: Senior QA Engineer
E-mail: ***********@*****.***
PROFESSIONAL SUMMARY
Senior QA Engineer with 9+ years of experience in all phases of Software Testing Life Cycle (STLC), developing Test Strategy, Test Cases, Test Plan and Automation test scripts using Selenium. Diversified experience in Automation and Manual testing serving various domains such as Finance and Retail.
Experience in different phases of Software Testing and Software Development Life Cycle (SDLC) including Agile Methodology/SCRUM, Waterfall and Kanban.
Experience in Web based testing including GUI Testing, Regression Testing, Integration Testing, System Testing, Performance Testing, Stress Testing, Functional Testing and Unit Testing.
Expertise in automation of Web-based application testing using Selenium Web driver, Selenium RC, Selenium Grid, Selenium IDE and Worked on multiple browsers like IE, Firefox and Chrome Driver
Performed BDD -Behavior Driven Development, ATDD- Acceptance Test-Driven Development and testing using Cucumber, Selenium, JAVA and TestNG.
Expertise in Mobile testing using Device Anywhere and Perfecto Mobile.
Experience in creation of Automation test scripts using frameworks like Page Object Model.
Hands on experience using Excel (POI API) for Data Driven Development testing frameworks.
Experience in using TestNG test frameworks in creating test scripts, test suites, HTML reports.
Worked on Postman, SOAP UI for Restful Web services testing and validated the responses
Hands on experience in using build and project management tolls like MAVEN and Configuration management tools like SVN.
Performed Continuous integration automation using Jenkins.
Experience in using finder mechanisms like CSS, XPath expression, HTML id, name to find the Web Elements.
Expertise in writing SQL Queries and performing Database testing including data integrity and data validation testing.
Experience in data validations using HBase and HIVE environments.
Performed manual and automated testing using HP-Mercury tool like Quality Center, Quick Test Professional.
Expertise in Defect Management/Problem Solving including tracking bugs, reporting using Quality Center/ALM, Version One, Bugzilla and JIRA.
Participated in requirement review meetings, analyzing requirements, developing test plan and test cases, Requirement Traceability Matrix, Defect management, Reporting and tracking
Experience in preparing test data for positive and negative testing and identified critical bugs in the product early in the test execution cycle.
Experience in Black Box Testing Techniques - Boundary Value Analysis and Equivalence Portioning
Experience in preparing Test data by retrieving data from Relational Databases Oracle.
Documented, implemented, monitored, and enforced all processes and procedures for testing which are the standards defined by the organization.
Reviewed & revised suit of test cases to reflect changes made to the Test Plan documentation for new functionality and performance issues.
Worked with cross functional testing teams and developers for closing defects.
Performed duties as an individual contributor and can manage multiple projects and tasks simultaneously.
Highly motivated, self-starter able to work independently and collaboratively within a diverse technical team.
Certified in ISTQB/BCS Foundation Level.
EDUCATION SUMMARY
Completed Master of Computer Applications (MCA) from Jawaharlal Nehru Technological University, Hyderabad, India in the year 2008.
Completed Bachelor of Science (BSC) from Sri Venkateshwara University, Tirupati, India in the year 2005.
TECHNICAL SKILLS
Development methodology
Agile/ Scrum, Waterfall, Jenkins, SVN, GIT
Artifacts
Test Plan, Test Case, RTM, Test Summary Report, Bug report
Automation Tool
Selenium IDE, Selenium Web Driver, Selenium Grid, Quick Test Pro, Cucumber, Junit, TestNG, Auto It and Soap UI, Post Man
Framework
Page Object Model, Data Driven, Hybrid Testing Framework.
Mobile testing
Device Anywhere, Perfecto Mobiles
Bug Management Tools
Quality Center -10.0, JIRA, ALM, Version One
Programming Languages
C++, Java, Java Script, VB Script, HTML, XPath, CSS
Database/Database tools
Oracle, MySQL, SQL, Hive, HBase, Toad, MySQL Work Bench, Putty
Operating Systems
Windows 07/ XP, UNIX.
PROFESSIONAL SUMMARY
PROJECT-I:
Project: ATUL (NCL, LWE)
Client: American Express
Role: Senior QA Engineer
Location: 200 Vesey Street, NY
Duration: June 2017 – Till Date
Project Description:
Atul application enables Business consultants to gather information about a prospect before calling them for the purposes of acquisition. This application provides all necessary information in one place for Business consultants.
NCL: is an internal application of Atul, helps the user to view the different companies associated with Amex and their details which include their contact details, existing card, card member since, GCS spend and Amex products eligibility. This application helps the business team to analyze their targets.
LWE: is a web application as a part of internal application of ATUL called "on the web". It provides the business team to view information about a company from different sources like Google, White Pages, Yelp and Foursquare. It helps them to identify which source is more reliable and it makes it easy for them to look up for all the information in a single tab. On the web provides the business information like contact details, address, services provided, working hours, photos, maps, reviews and rating.
Responsibilities:
Understanding and analyzing the Business requirements and functions requirements.
Involved in creating, updating and executing of test cases according to requirements.
Involved in Creation and Maintenance of Project object model (POM) framework, which included Selenium, Java, Maven and TestNG.
Involved in Smoke testing/Sanity Testing and Regression Testing.
Involved in verifying data in application through SQL queries against the Business Rules.
Created and monitored Jenkins jobs for the nightly execution of UI automation sanity and regression suites
Creating Hive tables and writing Hive Queries on Data Sets
Involved in Verifying and comparing data in HBase and HIVE.
Involved in testing Web Services manually using Postman.
Coordinated with Developers to resolve any open defects by replicating the scenarios in debug mode.
Participated in daily Scrum meetings.
Involved in preparing monthly QA metrics and Weekly status reports.
Maintain Tasks, Create Defects and track them on JIRA test management tool.
Documented the Service overviews, Refactoring changes on Confluence.
Environment: HBase, Hive, Selenium Webdriver, AGILE, SQL, UNIX,POM, TestNG, Maven, Jenkins, Auto IT, JIRA, Postman, MySQL Work Bench
PROJECT-II :
Project: Maverick
Client: American Express
Role: Senior QA Engineer
Location: 200 Vesey Street, NY
Duration: April 2016 – Till Date
Project Description:
Merchant Financing from American Express is a unique approach to small business lending. Available exclusively to American Express Card-accepting businesses, it’s a simple way to boost cash flow – all on terms that are simple and way to understand. The project was to design an internal web portal called Maverick to discover/explore the prospects. Maverick serves as an internal web portal for all the statistical analysis teams at American Express. This particular portal has much functionality like discovering a prospect, knowing people, knowing business, understanding the digital data. Maverick is developed for ETL processing such as extracting data from different sources (legacy systems, Amazon S3), transforming it as per business use and then loading of transformed data to HBase.
Responsibilities:
Understanding and analyzing the Business requirements and functions requirements.
Involved in creating, updating and executing of test cases according to requirements.
Developed and maintained automated regression test cases in Selenium Web Driver using Java programming language.
Designed and developed Page Objects using Page Object Design Pattern and Selenium Web Driver.
Configured Maven for JAVA automation projects and developed Maven project object model (POM).
Designed, coded and executed automated tests using TestNG and Generate tests using Log4j in various output target.
Participated in continuous integration using Jenkins.
Involved in Smoke testing/Sanity Testing and Regression Testing.
Involved in verifying data in application through SQL queries against the Business Rules.
Creating Hive tables and writing Hive Queries on Data Sets
Involved in Verifying and comparing data in HBase and HIVE.
Coordinated with Developers to resolve any open defects by replicating the scenarios in debug mode.
Participated in daily Scrum meetings.
Involved in preparing monthly QA metrics and Weekly status reports.
Defect tracking was done in JIRA.
Environment: HBase, Hive, Selenium WebDriver, AGILE, SQL, UNIX, POM, TestNG, Maven, Jenkins, Auto IT, JIRA.
PROJECT-III:
Project: CPS Migration
Client: American Express
Role: Senior QA Engineer / Technical Lead
Location: 200 Vesey Street, NY
Duration: July 2015 – March 2016
Project Description:
CPS migration project is for migrating Tera data into HBase. Post-ingestion files are sent to a landing zone for processing into business Hive tables. Data received is transformed in HBase and extracted into the final business Hive tables. All feeds are defined in one field configuration template. List codes to be ingested and processed will have an individual list code configuration template. Each business Hive table will have its own extract configuration template.
Responsibilities:
Understanding and analyzing the Business requirements and functions requirements.
Involved in creating, updating and executing of test cases according to requirements.
Prepared Test data for test cases
Creating Hive tables and writing Hive Queries on Data Sets
Involved in Smoke testing/Sanity Testing and Regression Testing.
Involved in verifying data in application through SQL queries against the Business Rules.
Involved in Verifying and comparing data in HBase and HIVE.
Coordinated with Developers to resolve any open defects by replicating the scenarios in debug mode.
Participated in daily Scrum meetings.
Involved in preparing monthly QA metrics and Weekly status reports.
Defect tracking was done in JIRA.
Environment: HBase, Hive 1.2, JIRA, MYSQL 5.1, WinSCP, AGILE, UNIX, Java, Map Reduce 5.0.1, SVN
PROJECT-IV:
Project: Default and Recovery
Client: Standard and poor’s
Role: Senior QA Analyst
Location: 55 water street, NY
Duration: May 2013 – April 2015
Project Description:
Standard & Poor’s is a leading provider of financial market intelligence. The world’s foremost source of credit ratings, indices, investment research, risk evaluation and data, Standard & Poor’s provides financial decision-makers with the intelligence.
The Default and Recovery has two modules called Creditpro as DR1 and Data Management tool as DR2. Credipro is used to get the default and recovery rating information for the Issuer, Instrument, Structure Finance and Sovereign across geographies, regions, industries and sectors. Data Management module is used to add or modify the rating data for Issuer, Instrument and Default pipeline Standard & Poor’s is a leading provider of financial market intelligence.
Responsibilities:
Understanding and analyzing User stories based on Detail acceptance criteria for the corresponding Sprint.
Involved in creating, updating and executing of test cases according to requirements.
Developed and maintained automated regression test cases in Selenium Web Driver using Java programming language
Designed and developed Page Objects using Page Object Design Pattern and Selenium Web Driver.
Configured Maven for JAVA automation projects and developed Maven project object model (POM).
Executed System Test Cases/Scenarios in DEV environment and make sure that user stories are working as expected.
Developed Keyword Driven framework to retrieve test actions, test data from Excel files.
Designed, coded and executed automated tests using TestNG.
Proven ability in developing BDD scripts with Cucumber and writing step definitions for behavior
Participated in continuous integration using Jenkins.
Involved in Rest Web services testing using SoapUI.
Performed monthly load testing for different subject areas like Issuer, Issue, SF and Sovereign.
Involved in verification of manual update files for different subject areas
Involved in Smoke testing, Sanity Testing and Regression Testing.
Involved in verifying data in application through SQL queries against the Business Rules.
Actively interacted with the onsite team, development team and conducted meetings for clarifications.
Coordinated with Developers to resolve any open defects by replicating the scenarios in debug mode.
Involved in Regression Testing on DEV / QA / UAT Environments.
Participated in daily Scrum meetings.
Involved in preparing monthly QA metrics and Weekly status reports.
Defect tracking was done in Quality Center and ALM.
Environment: Java, ETL Informatica, AJAX, ALM 11, Toad for Oracle 11g, Manual Testing, MS Excel, Eclipse, Cucumber, Selenium Web driver 2.45, Selenium IDE and SOAP UI
PROJECT-V:
Project: Rebranding
Client: Dealer track
Role: QA Analyst
Location: New Hyde Park, NY
Duration: Dec 2012 to April 2013
Project Description
Dealer track Inc. headquartered at New York is a leading provider of on-demand software and data solutions for the automotive retail in the United States. In recent time Dealer track acquired many companies like Trivin, JM Solutions, and Arkona etc. To identify and resolve branding violations in facing customer (UI) of different products which were originally owned by different organizations and that are acquired by dealer track rebranding project was implemented. The main agenda of the project is to provide unique look and feel for the customers.
Responsibilities:
Analyzed the violations and separated the violations in various categories.
Actively interacted with the onsite team, dev team and conducted meetings for clarifications.
Involved in Preparation of Test cases based on Backlogs.
Involved in testing of application using the Scrum (Agile) methodology.
Performing integration and functional testing for different application.
Coordinated with application team and ensured resolution of all issues and completion of work on time.
Maintained and issued weekly reports on all automation tests.
Involved in creating, updating and executing of Test Cases according to requirements
Involved in preparation of Test Scenarios from each line of the violation.
Gained thorough understanding in short span of time on products DMS-CRM and AAX-American Auto Exchange which is handled in phase – 1, CMS which is handled in phase –2.
Involved in preparation of test strategy and test plan for every product Created and Updated stories and tasks in JIRA.
Involved in Preparation of Test Plan and review of Test Plans.
Involved in GUI, Functionality and Regression Testing.
Actively participated in daily Status calls, Retrospectives and Team meetings
Defect tracking was done in JIRA.
Environment: .Net, Visual Studio 2008, Manual Testing, JIRA, Microsoft Office Excel, QC 10
PROJECT-VI:
Project: Clean Sheet Hp.com
Client: Hewlett Packard
Role: Software Test Engineer
Location: Houston, TX
Duration: June 2010 to Sep 2012
Project Description:
Clean sheet HP project was intended to revamp the HP website to deliver a new world-class B2C website across the globe in multiple languages with support to Mobile users. The new site is completely dynamic in nature with various levels of customization and efficient for user and the site publishers. The experience is designed to be personalized and engaging, bringing to life HP’s brand and market leading products and services. The new site has capabilities to grow business, improve customer relationships, generate leads and convert visitors to customers.
Responsibilities:
Interacting with client, Development team to understand and gather the Functional and Non-Functional requirements for projects/each release.
Involved in testing of application using the Scrum (Agile) methodology.
Involved in Requirements streaming, and Preparation of Test cases based on Backlogs.
Involved in updating and executing of Test Cases according to requirements.
Performed GUI and functional testing for different modules of application using Black box Testing Techniques.
Involved in Preparation of Test Scenarios and Review of Test Cases.
Involved in mobile testing using Device anywhere and providing additional training for the team members on Device anywhere tool.
Involved in Regression testing using Quick Test Pro and Creation of automation scripts for desktop pages.
Testing and logging defects using Quality center, resolving issues with Dev team.
Updating HPQC with test data created and generating reports from HP QC Dashboard.
Adhering to process, ensuring relevant business stories are mapped from Test Plan to Test Lab in HPQC.
Reporting daily status of data creation and sending weekly status reports.
Involved in training session on search and mobile scrums and task allocation to team Members
Worked with Business Customers, Business Analysts, Software Developers, QA team, and Project Leads to ensure successful roll out of high-quality application
Environment: .Net, Java script, Html, Ms-Excel, QC 10, TRIDON, QTP10, VB Script, Device anywhere, Perfecto Mobiles.