We provide IT Staff Augmentation Services!

Automation Engineer /sql Tester Resume

Tarpon Springs, FL

SUMMARY:

  • 7 plus years of QA experience in Manual/Automation testing of Web/Mobile apps and client server application.,SQL Tester.
  • Extended experience in systems testing, integration testing, UAT testing, positive and negative, functionality testing, and regression testing.
  • Thoroughly experience with use cases, and user requirement specification documents.
  • Experience in automation testing using QTP and Selenium
  • Well Experienced in writing VB Scripts in QTP and Java and Python in Selenium
  • Used various Concepts of QTP such as check points, regular expression on various stages of application in different projects.
  • Extensive use of Selenium IDE and WebDriver, JUnit, TestNG.
  • Proficient in using Soap UI for testing Web Services .
  • Co - ordinate with developers, business analysts, and user representatives in application design and document reviews.
  • Extensive experience with MySQL, SQL Server, Oracle Database.
  • Good knowledge of Perl, Python and Bash scripting
  • Extensive experience in Functional testing, Testing system management, Integration testing, Regression testing, GUI testing, Back-end testing, Browser Compatibility testing, Ad-hoc testing, Black Box Testing, System Testing, User Acceptance Testing.
  • Capable to meet tight deadlines in a result-oriented and efficient manner.
  • Good communication skills, a good team player and self-starter, capable of working independently and motivating a team of professionals.
  • Expert in Black Box Testing and also involved in White Box Testing
  • Gathered requirements and application information from Business Area Managers (BAM) and Subject Matter Experts (SME’s) and developed test cases.
  • Involved in design and implementation of Selenium WebDriver automation framework for smoke and regression test suites (JUnit/ TestNG and ANT). Checked Log files to analyze errors experienced during testing.
  • Developed and implemented robust PageObjects pattern base testing with Selenium RC, Selenium Grid and WebDriver which cut down the script development time in half.
  • Used TFS (Team Foundation Server), QC (ALM), JIRA, Rational for defect logging and tracking.
  • Used Android SDK tools such as ADB Logcat and DDMS for identifying software defects in android phones.
  • Conducted data based testing by executing TSQL and PL/SQL queries to in oracle and SQL Server
  • Participated in daily, weekly meetings and technical reviews. Prepared reports showing the testing efforts.

TECHNICAL SKILLS:

Testing Tools: QTP9.0/10/11.0, SOAP UI, Selenium, Load Runner

Bug Reporting Tools: Quality Center, Bugzila

Databases and Tools: Mysql, Oracle, SQL Workbench

Operating Systems: Windows XP/NT/2000, Linux

Languages: Core Java, J2ee, JSP,HTML, SQL, XML, JavaScript, JSP, Servlet, JDBC.

Methodologies: Agile/Scrum, Rational Unified Process (RUP), Waterfall

Framework: Spring IOC,SpringAOP,Spring MVC, Apache Wicket, Struts 1.x, JQuery, Hibernate

Java Development Framework: Spring, Hibernate, Wicket.

IDE: Eclipse 3.x, NetBeans 6.x

Web Service Technologies: Web Services, SOAP, Restful, Soap UI

Deployment & Build Tool: Apache Ant, Apache Maven1.0

Source/Version Control: SVN, VSS, CVS

Documentation Tool: Microsoft Word, Microsoft Visio, Open Office, Excel

Miscellaneous: MS office 2003, EditPlus, TextPad, Log4j, WinSCP.

Other skills: HL7, Ensemble, Meditech, WBIMB, MQ, Interface Explorer, Beyond Compare

PROFESSIONAL EXPERIENCE:

Confidential, Tarpon Springs, FL

Automation Engineer /SQL Tester

Responsibilities:

  • Involved in the development of Test Plan and Test cases.
  • Performed automation for Functional and Regression Testing using Selenium WebDriver.
  • Functional testing for Symbian and Blackberry Platforms, Bug Logging and Tracking .
  • Involved in Backend Database testing in Oracle using SQL.
  • Captured the SQL statements from the application execution and manually checked the results.
  • Wrote complex SQL queries to ensure that data at the front end matched data at the backend.
  • Used SQL to check for referential integrity, for logical checking and for checking format of data in database .
  • Experience in testing using ETL tools such as AB Initio and Informatica . implemented HP's leading edge Business Process Testing (BPT) module for driving test automation
  • Worked with Data Extraction, Transformation and Loading ( ETL ).
  • Used BPT to enable Subject Matter Experts to create business process tests using reusable business components .
  • Performed BPT testing using HP/ Mercury Quality center.
  • Expertise in Manual Testing /mobile application testing for J2ME & BREW wireless , Symbian , and Blackberry, Android (Mobile) applications, client server applications and cloud applications.
  • Developed Python scripts to automate the test cases.
  • Have performed Cross browser testing as well as Mobile testing of the developed we based application.
  • Executed test cases using QC Manual Runner. Reported defects for failed conditions using HP Quality Center and retested resolved defects.
  • Used Android SDK tools such as ADB Logcat and DDMS for identifying software defects in android phones
  • Develop applications to facilitate or automate operational tasks.
  • Create web apps to facilitate operational tasks.
  • Collaborate with internal customer to create software solutions for their problems.
  • Collaborate with customers in order to automate their processes.
  • Create automated RunBook solutions that integrate with Enterprise Systems.
  • Troubleshoot automation issues through entire stack (automation through to OS, including network).
  • Collaborate and communicate with the RunBook team.
  • Complete ad hoc assignments per direction from Service Availability Managers or DTOC (Disney Technical and Operational Center) executives.
  • Extensive experience in writing Python Scripts and UNIX Shell-Scripts
  • Used VIM and PyDev (Eclipse binding with Python) as a script editor.
  • Use of AS400 to validate the script for reservation and cancellation of the resorts.
  • Involvement of custom script and workflow implementation, SQL query development, network and systems design, performance and process improvement, and systems documentation.
  • Used Python codes to handle textbox, dropdown, checkbox, buttons and popup controls
  • Extensive use of Developer Tools (F12) to identify the element’s ID or name in Internet Explorer which is similar to FireBug in Firefox browsers.
  • Experienced in White Box Testing by authoring python Codes in Selenium WebDriver.
  • Involved in documenting test cases and packaging test suites and making them available to all of engineering and QA using Quality Center.
  • Use of SQL scripts in Oracle databases to validate and query the functionality.
  • Involvement in Black Box Testing.

Environment: HP ALM, Selenium WebDriver, Python, Eclipse, PyDev, HTML, Developer Tool.

Confidential, Bristol, VA 

Selenium Tester /Main Frame Tester

Responsibilities:

  • Involved in Business Requirements and Functional Specifications and develop Test Plan detailed Test Scenarios and Test cases.
  • Automated Functional and Regression Testing using Selenium IDE, WebDriver, JUnit, ANT, Java
  • Debugging the application in Xpeditor/TSO and made changes to the values according to Test Cases such as Test condition and Expected results.
  • SQLs are written using QMF to query the DB2 database on mainframe Environment.
  • Developed manual test cases for Regression Testing and BPT testing based on the requirement documents.
  • Implemented BPT framework using QTP tool.
  • Testing on BREW, J2ME, Symbian, Blackberry, Android platforms for Mobile applications, Position Location Tracking Applications, Cloud Applications.
  • Developed JCL ’s and COBOL programs to get the statistics of Policy Conversion into DB2 system.
  • Create JCL to run batch in test environment.
  • Involved in developing Collections screens and templates for email notifications using Servlets, JSP, HTML5, CSS3, JavaScript, JQuery,Swing
  • Extensively worked with Core java Collection classes like ArrayList, Hash Map and Iterator etc.
  • Developed International Error Correction Screens using custom front end forms using XML, XSLT, Angular JS, JQuery and ExtJS Sencha,Swing
  • Tested the application on iPad and iPhone when the operating system was unveiled and made sure the application was enhanced to be compatible with the Android devices
  • Authored JavaScript and Java codes needed for Selenium IDE and Selenium WebDriver to automate the tests.
  • Experience in writing Python Scripts and UNIX Shell-Scripts
  • Implemented Data Driven Framework using WebDriver, JUnit, ANT, Java
  • Used Several Java collection classes, wrote code to handle textbox, dropdown, checkbox controls using XPath, selenium WebDriver classes
  • Used JUnit as driver to launch selenium scripts
  • Experienced in White Box Testing by authoring Java Codes in Selenium WebDriver
  • Involved in documenting test cases and packaging test suites and making them available to all of engineering and QA using Quality Center.
  • Tested Mobile App version on different smart devices
  • Written SQL scripts (PL/SQL) to query and validate the functionality in Oracle databases.
  • Involved in UAT (User Acceptance testing)
  • Extensive involvement in Black Box Testing

Environment: HP ALM, Selenium IDE, WebDriver, ANT, Java, Eclipse, Oracle 10g, HTML, XPath

Confidential, Exton, PA

Automation/SOA Tester

Responsibilities:

  • Involved in creating Test Plan and written Test Cases based on Use Cases and Business Requirements.
  • Hands-on expertise in a variety of test automation frameworks and tracking tools: UFT/QuickTest Pro; Win Runner; Service Test; Load Runner; VBScript; Selenium WebDriver; Ruby/Lucid; Quality Center with Business Process Testing (BPT); Jira
  • Automated Test Cases using Selenium, Eclipse
  • Configured Selenium WebDriver
  • Perform Functional Testing and Regression Testing using Selenium WebDriver
  • Used Selenium WebDriver to handle various web page controls like textbox, button, dropdown, checkbox, radiobutton, labels using XPath and other locators.
  • Used Python for scripting language.
  • Recognized test automation opportunities and analyzed SOA requirements
  • Performed both Black Box Testing and White Box Testing.
  • Tested several web services using SOAP UI Pro (SOAP and REST based)
  • Used Soap UI for API Testing.
  • Involved in documenting test cases and packaging test suites and making them available to all of engineering and QA using Quality Center.
  • Used QC to report defects
  • Expert in writing SQL scripts to query the data and validate the functionality in Oracle databases.
  • Experience in DB2 to maintain the functionality of the database.

Environment: Windows 2003/XP, VS.Net 2008, QTP, ASP.Net, VB.Net, SQL Server 2005, T-SQL, IIS 5.0, Python, Test Manager, CSS and HTML.,QC, Selenium.

Confidential, Tampa, FL

QTP/ETL TESTER

Responsibilities:

  • Analyzed Functional specifications, Business rules to gain a better understanding of the application
  • Prepared Test Cases for Basic, Alternate and Error Flows.
  • Reviewed Test Scenarios and Test Cases.
  • Conducted Smoke testing to ensure the stability of the Application
  • Managing the Test Process, Web/eBusiness Testing,
  • Used Test to invoke the scripts and initially performed the baseline testing and organized all the scripts systematically and generated reports.
  • Test Case Execution and logging defects for the failed test cases into the Excel Sheet.
  • Creation and Maintenance of Defect Profiles.
  • Wrote VBScripts for Black Box and White Box Testing.
  • Coordinating with Development Team for the bug fixing.
  • Status reporting and test updating in Quality Center.
  • Used Unix Shell Scripting as needed for backing up data.
  • Performing Backend testing using extensive SQL queries by UNIX Shell Scripting.
  • Used Win Runner for functional and regression testing of the application to make sure transactions and business processes work as intended and developed TSL scripts.
  • Conducted Boundary and Error testing on the AUT manually for selected Test Cases.
  • Involved in application Functional and Regression Testing of the application.
  • Created libraries in VB Script to call from test script
  • Performed functional testing, smoke testing, regression testing and end-end testing
  • Used Data base driven framework to automate regression test cases using VB Script/QTP
  • Preparation of Defect Reports to track the project status.
  • Involved to write test clients to test the UNIX/Linux functionalities in the language like Java and Shell Scripting.
  • Involved in functional testing, black box testing, negative testing, compatibility testing, and recovery testing.

Environment: Toad, PL/SQL, XML, UNIX, Quality Center 9.0, Weblogicserver5.1, SQL Server 2005 Windows 2003/XP, VS.Net 2008, ASP.Net, VB.Net, SQL Server 2005, T-SQL, CSS and HTML, QTP.

Confidential, Bridgewater, NJ

QTP Engineer

Responsibilities:

  • Created the test plan, test cases and test scripts based on functional requirements, technical specifications and use cases.
  • Used QC to manage the defects/requirements
  • Wrote T-SQL Queries to verify the data in tables
  • Used Agile model in this project
  • Created libraries in VB Script to call from test script
  • Performed functional testing, smoke testing, regression testing and end-end testing
  • Used Data base driven framework to automate regression test cases using VB Script/QTP

Environment: - QTP, VB Script, QC, T-SQL, SQL Server

Confidential

QA/Database Tester

Responsibilities:

  • Extensive experience in Backend testing and Oracle Database Validation using Toad
  • Written and executed extensive database queries using Inner, Outer, Left, Right and Self Joins
  • Experience using SQL query builder and schema browser in Toad
  • Experience with TOAD for backend data validation
  • Extensive use of SQL and DB2 to extract data from the database
  • Wrote Several Test cases based on Requirements
  • Defects were logged and reported using HP's Quality Center
  • Developed and executed manual/automated scripts for Functional, Integration, End-to-End and Regression testing
  • Involved in testing the application utilizing the Waterfall methodology.

Environment: Quality Centre, Oracle 9i, SQL, PL/SQL, TOAD, HTML

Hire Now