Sr.automation Test Engineer/etl Tester Resume
Los Angeles, CA
SUMMARY:
- Around 7+ years of professional IT work experience in Software Testing / Quality Assurance /Automation and Manual Testing in Web and Client - Server based applications.
- Experienced in Software Quality Assurance (SQA), Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
- Experience in Test Management and Testing Life cycle Methodologies like Agile & Waterfall models.
- Experience in developing manual and automated Test scripts and test cases based on the client requirements.
- Having experienced in Agile Methodologies, Scrum stories and sprints experience in a Python based environment, along with data analytics, data wrangling and Excel data extracts
- Having good experience in undergoing various testing methodologies like Automation Testing, Manual Testing, Functional Testing, System testing, Regression Testing, User Acceptance Testing, Backend Testing, e-Commerce application testing and Web Services testing.
- Experience in working on various test strategies and preparing Test Plans, Test Cases, Test summaries and Analyzing Test Results.
- Expert in developing test automation scripts using Selenium Web Driver for Regression and Performance testing for various releases of the application.
- Expertise in automation testing using Selenium with Java.
- Experience programming in Java, Python, JavaScript, HTML, XML and SQL on Windows XP, Vista Operating Systems and UNIX environments.
- Experienced with mobile test automation tool see Test to run same application on other mobile devices. Having strong experience with core java, JavaScript, shell scripting.
- Hands on experience in setting up the environment of Appium for automating test cases of applications that are running on iOS and Android devices.
- Experienced in Functional testing, Performance testing, Usability testing, Security testing, Smoke testing etc.
- Experience in testing applications in different OS such as Windows and UNIX/LINUX environments.
- Expertise in using tools like HP Quality Center, JIRA and BugZilla etc. Combined Protractor with powerful tools and technologies such as Selenium, web Driver, Cucumber and JBehave.
- Experienced in Functional testing using Selenium IDE. Sound knowledge in JUnit, TestNG framework for Unit testing and Maven for Project building tool, Jenkins for Continuous Integration.
- Good Understanding of Web Services and Service Oriented Architecture (SOA) and Object Oriented programming..
- Extensive hands on experience in Performance Testing using Apache JMeter and Load Runner tools. Involved in Data Warehouse Testing using ETL tools and Database Testing.
- Experienced in writing SQL verification scripts to test the result of deployment for correct business logic for Back-end testing.
- Configuring sales cloud prototype during design, assisting with implementation configuring and roll out.
- Expertise in designing and implementing Selenium Automation Frameworks using Data Driven, Hybrid, Page Object Model (POM).
- Experience in web services testing using XML to follow the SOAP standard.
- Experience in Back-end testing, Data validation, Database testing using SQL queries.
- Involved in Functional testing, Black box testing, Negative testing, Compatibility testing, Recovery testing, etc.Experienced in the atmosphere of cross-functional team within the organization’s Agile Project Life-cycle and WaterFall Methodology.
- Team player with good Communication and Interpersonal Skills.
- Strong ability to troubleshoot any issues generated while building, deploying and in production support.
- Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
TECHNICAL SKILLS:
Testing Tools: QTP 10, MTM, Eclipse IDE, SOAP UI, HP Quality Center 10, Selenium,Cucumber,Lawson.
Defect Trackers: HP Quality Center 10.0, Dovetail, Bugzilla 2.0,Jira,MTM, Bugger, Jira
Prog. Languages: C,C#,vb, Java, PL/SQL, HTML
Mobile Os: Web/App Server
IOS, Android, Windows Mobile, Blackberry: Weblogic8.1,IIS-6
Database: Oracle 10g/9i, SQL Server, MS Excel, MS Access
Version Control Tools: SVN, GIT, TFS
Operating System: Windows 2003/XP/NT/98/95, UNIX (Sun Solaris 10/9)
CI Tools: Jenkins/Hudson, Travis Cloud Based Testing Sauce Labs, Browser Stack
FrameWorks: Hybrid, Data Driven, Keyword Driven, Cucumber, BDD/ATDD, Page Object Model(POM).
EXPERIENCE:
Confidential, Los Angeles, CA
Sr.Automation Test Engineer/ETL Tester
Responsibilities:
- Project is developed using agile/scrum methodology.
- Implemented POM (Page Object Model) automation framework using JAVA, Selenium Webdriver and Cucumber.
- Designed automation test cases by using java, Junit, maven and selenium webdriver.
- Used Selenium Grid to run test cases in multiple browsers and Platforms.
- Performed functional testing on Patron reports and report generator.
- Developed automation script for Mobile Native applications (IOS, Android) using Appium, Java.
- Performed stress test on data migration from Titanium to SQL database.
- Used Emulator and IOS simulator in physical devices for manual testing.
- Used Java language and TestNG framework for scripting. Used Maven for building the WebDriver project.
- Good Experience in Android and IOS operating system.
- Involved in writing SQL queries for backend/ETL testing.
- Performed troubleshooting, fixed and deployed many Python bug fixes of the two main applications that were a main source of data for both customers and internal customer service team
- Used TestNG Annotations in Selenium Web Driver in Python and executed a batch of tests as testing suite.
- Developed automation test scripts for client -server and web based applications using Python Silk and other automation tools.
- Built database Model, Views and API’s using Python for interactive web based solutions.
- Created SQL Queries using SQL Plus for dropping indexes prior to the load graph execution to be able to perform direct loads on the database tables.
- Placed data into JSON files using Python to test Django websites.
- Used Python scripts to update the content in database and manipulate files.
- Developed web based application using Django framework with Python concepts.
- Created automation framework in Selenium WebDriver using behavior driven approach like Cucumber.
- Tested SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse.
- Tested request and response XML's based web services interfaces using SOAP UI.
- Performed Web Services Testing and XML validation by creating test case suite using SOAP UI.
- Regression test cases were written and automated using Selenium WebDriver.
- Prepared Traceability Matrix to ensure the adequate coverage of the test cases.
- Tested compatibility of application for dynamic and static content under various cross browsers using HTML IDs and XPath in Selenium.
- Used agile methodology with Scrum Process.
- Involved in Writing Python Scripts to develop automated scripts and frame works.
- Used BDD framework with Cucumber, Java and created future files with scenario and scenario outline files.
- Experienced in performance testing tool jmeter.
- Integrated with Continuous Integration tools Jenkins for running test on nightly basis automatically.
- Following-up with developers as to the status of jiras and ensuring that the issues are resolved.
- Used Java language and Junit framework for scripting.
- Extensively used Selenium locators like (Xpath, CSS Selectors, Fire Bug, Fire path locator) and WebDriver to test the web application.
- Worked on static and dynamic objects using xpath and DOM.
- Log defects using JIRA application and communicate the defect status updates to the responsible analysis and implementation teams.
- Performed Smoke, Functionality, Integration, System, Regression tests based on Analysis, and understanding of the requirements, non-functional specifications, and end-user needs.
- Used Git as code repository and Code Collaborator to manage code reviews
- Managed Code reviews using GIT as code repository and code collaborator.
- Prepared manual and functional test cases on mobile and web applications as per requirement.
- Used eclipse, IDE, Android SDKand TESTNG framework to develop test code in java language
- Used HP ALM Quality Center as bug reporting tool and testing tool.
Environment: Java,Web Driver, POI, DATADRIVEN,POM, APPIUM Emulators, IOS Simulators, Agile, SQL & NO SQL DB’s, GIT, JSON, XML, Jenkins, Maven, Protractor.
Confidential, New York
Sr. Automation Engineer
Responsibilities:
- Setup the Automation Framework using Selenium Web Driver, Eclipse, TestNG and Run test cases in multiple browsers and Platforms.
- Used Agile methodology (Scrum) to ensure the new features meet the customer requirements and acceptable quality assurance standards
- Involved in implementation of Test Automation Framework build using Selenium WebDriver, protractor to handle Angular JS.
- TestNG and Maven technologies under Java platform utilizing industry leading harness design patterns and approaches.
- Performed Web Services Testing and XML validation by creating test case suite using SOAPUI.
- Prepared Traceability Matrix to ensure the adequate coverage of the test cases.
- Tested compatibility of application for dynamic and static content under various cross browsers using HTML IDs and XPath in Selenium.
- Performed API Level testing for Web Services, enhanced the Test harness and developed many Test suites using XML and Python.
- Performed the Mobile Testing for Mobile App of Client, identify the Mobile Platform like IOS, Android by using Appium.
- Developed Selenium test scripts for identified test cases by using Data Driven framework. Developed Selenium function library to reduce redundant scripting.
- Perform functional, UI, System, Regression, Smoke, Sanity, backend, Ad-hoc, UAT, stress, load and other non functional testing.
- Developed automation script for Mobile Native applications (IOS, Android) using Appium, Java.
- Developed test automation strategy and road-map aligned with enterprise IT goals, resulting in dollar savings and improved smoke/regression test coverage.
- Worked with the engineering team to develop best practices and documentation for QA automation across our tech stack
- Maintained and design automation frameworks ensuring they are kept up to date for maximum test coverage.
- Created Projects, Workflows, Custom Fields, Notification Scheme, Permission Scheme, Screens schemes and Issue Type Schemes within JIRA.
- Designed and created automated test frameworks and test scripts using Selenium language
- Contribute to the integrity of the test plans, test cases, test data, and test environments.
- Experienced in writing complex SQL queries by understanding the dependency of data between tables.
- Used Jenkin to monitor the defects and the health of the build in a daily basis.
- Proven ability in developing BDD/TDD scripts with cucumber and writing step definitions for behavior .
- Performed load testingto determine the upper limit of all the components of application like database, hardware and network so that it could manage the anticipated load in future.
- Performed performance testing to establish the benchmark behavior of the system.
- Good Experience in JMETER.
- Involved in User Acceptance Testing (UAT) of the application.
- Involved in Knowledge Transfer, Group Discussion and Training Session.
- Prepared the Test Results document which summarizes testing activities and results.
Environment: PL/SQL, Phython, JAVA, HTML, Selenium, QTP, Watson Analytics, QC, JIRA, SQL Server 2008, ORACLE, IOS Simulators, Agile/Scrum, JIRA, SVN, Jenkins and ANT
Confidential, St.Louis, MO
Sr.Automation Engineer
Responsibilities:
- Analyzed the user requirements by interacting with system architect, developers and business users.
- Reviewed and analyzed Detail Designed Specification and Technical Specification documents.
- Analyzed the SRS (System Requirement Specifications) and developed Test Suites to cover the overall quality assurance testing.
- Carried out ETL Testing: Tested the ETL jobs and verified the data loaded into the Data sets in the UNIX box and ODS tables.
- Performed functional and regression testing using HP Quality Center.
- Coordinated UAT testing with business users and trained them in testing new features as needed.
- Manual testing the functionalities such as login, employee details, asset management in agile environment.
- Executing test cases, ad-hoc product testing, reporting bugs and reporting tester status, writing test scripts, test automation using diverse testing tools like UFT/QTP, Quality Center, WinRunner, LoadRunner.
- Experience in creating and consuming Web Services using c#.
- Excellent working knowledge on Team Foundation Server (TFS) Architecture, design, development, administration and maintenance.
- Experience with batch testing for forming, running and executing test batches using Batch runner tool.
- Experienced in testing client server and web based applications using HP tools like Quick Test Professional (QTP), Quality center (QC). Also possess good knowledge of UNIX/Linux shell commands to tail the logs, adding users, starting services from the shell, settings aliases to frequently used commands, creating users and settings file system permissions.
- Analyzed business requirement to identify positive and negative scenarios to prepare test cases and scripts.
- Participated in team meetings with business users, development and QA team to discuss issues and status.
- Written complex SQL queries for data validation and to verify the extract rules.
- Performed manual testing on the whole application before going for the automated testing.
- Involved in identifying Integration User-Stories and Tasks during the Sprint Planning Sessions.
- Analyzed Black box and white box testing.
- Attending Daily Stand-up meetings, as part of the sprint meetings following the Agile Methodology, for the QA Integration Team.
Environment: QTP 10, Quality Center, Jira, SQL Server, XML, MQ Series, Web Spear, MS - Team Foundation Server,Agile Methodology.
Confidential, New York
Test Engineer
Responsibilities:
- Involved in Unit testing, System testing, User acceptance testing(UAT), UI testing and Regression Testing.
- Develop automation scripts in Quick Test Professional (QTP) to automate smoke and regression testing and automated test data load for every build cycle.
- Extensively used descriptive programming in QTP to handle dynamically changing screens without having to manually change the script.
- Assisted business users in defining UAT test cases and plans; Established and maintained test cases and test data in Quality Center.
- Experienced in using QTP integrated environments like Data Table, Actions, and Recovery scenario.
- Performed end to end testing in the form of scripts.
- Performed various types of testing like Functional Testing, Integration Testing, Regression Testing, System Testing and Compatibility Testing.
- Experienced in the extraction, transformation, and load process (ETL) for a Data Warehouse from their legacy systems using Informatica
- Analyzed Test specifications and written Manual Test cases for Black Box Testing.
- Defect logging, Tracking, Reporting and Validation using Mercury Quality Center.
- Performed Regression Test execution based on the priority of the Test cases in Mercury Quality Center.
- Designed Test cases and executed Test cases and Reported the Bugs using Quality Center.
- Performed Defect tracking in Quality Center. Defects were linked via traceability to specific test case.
- Participated in Defect Reporting Meetings on a daily basis, QA Team meetings and weekly QA testing reviews.
Environment: QTP 9.2, Microsoft Office tools, Windows 2000, SQL, Manual testing, Mobile Testing, Quality Center.
Confidential
Manual Tester
Responsibilities:
- Created test plans & test cases for system and integration testing of the application and execute manual test cases and automate test scripts.
- Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using Quick Test Professional.
- Knowledge of Software Development Life Cycle (SDLC) of Waterfall Methodology.
- Ensure that all the test cases are updated in the Test Director along with Master test plan.
- After successful release of projects, developed automation scripts using QTP and integrated the script with master script.
- Involved as part of automation team using QTP, developed test scripts.
- Involved in Backend Database testing in Oracle using SQL.
- Defects were tracked, reviewed, analyzed using Test Director.
- Maintained Overalldefect lifecycle (Reporting, Updating and requirements, and closing defects).
- Maintained traceability matrix in Quality Center.
- Reviewed the test cases written for Unit and Integration level.
- Analyzed test specifications and converted them into Manual Test Cases.
Environment: JAVA, JSP, WebLogic, SQL Server 2005, and Windows 2003, Testing Tools: QTP 8.2, Mercury Quality Center 9.
Confidential
QA Test Engineer
Responsibilities:
- Expertise in automation tools like QTP.
- Usage of QTP's Data Driven Framework, various GUI Check points, Synchronization and performed.
- Generating/Enhancing VBScripts, executing the test scripts, analyzing test results using QTP.
- Involved in regression and sanity testing.
- Designing test cases. Reviewing of test cases created by other resource.
- Wrote SQL queries to validate the data in the database.
- Testing mobile and web applications including Social & Communication applications and websites.
- Interacted with developers to resolve the ETL and reports defects.
- Experienced in testing different source feeds of data for ETL and prepared mock data for ETL.
Environment: SQL Server,Web Services, Agile, Main Frames, JAVA, J2EE, Java Script, XML, UNIX, QTP 8.2, Windows 2003,JSP.