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