SUMMARY:

• Over 6 plus Years of experience as Software QA Engineer/ Software Development Engineer in Test with emphasis on the Design, Development and Architecting Test Automation frameworks, developing automated test scripts and in overall quality control practice.
• Involved in various phases of testing like Integration Testing, System Testing, Functional Testing, Regression Testing, User Acceptance Testing and Performance Testing.
• Extensive experience developing Automated Scripts for Web Applications, Mobile Applications, Batch applications, Web Services and ETL/PL - SQL Applications.
• Highly experienced in complete cycle of SQL Server Integration Services 2000 to … Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers.
• Extensively used Control Flow and Data Flow transformations like Execute SQL Task, FTP Task, Send Mail Task, Conditional Split and Fuzzy Lookup.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access and designed data conversions from wide variety of source system.
• Extensive experience in using various automation tools like UFT/QTP, Selenium, Informatica 8.6, 9, 9.6 Abinitio.
• Experience developing automation scripts for testing SOAP and REST Full Web Services using tools like SoapUI, Parasoft SOATest and custom Java applications.
• Ability to program in various programming languages like Java, C, Groovy, Obj C, VBScript, SQL.
• Experience using test frameworks like TestNG and building object repositories using Page Object Model and Page Factory.
• Experience developing highly modular and extendable Test Automation Frameworks that can be consumed by test apps testing UI, Database and Batch applications.
• Experience in configuring and using source control systems like GIT, SVN and PVCS.
• Experience using various defect management and process tool like HP ALM, Zephyr, Jira, Agile Manager.
• Excellent understanding of Software Development Life Cycle (SDLC) and Software testing life cycle(STLC) methodologies.
• Experience in Agile, Kanban and Waterfall models.
• Experienced working in various domains like Finance, Banking and e-commerce .
• Experience in configuring and using CI-CD tools like Jenkins, Buddy build, Nexus, Artifactory and in using dependency managers like Maven, Ant.
• Experience in testing UNIX jobs and in debugging UNIX scripts.

TECHNICAL SKILLS:

Tools: Selenium Suite, HP UFT Jira, HP ALM, SoapUI, SOATest, EclipseInformatica 8.6, 9, 9.6 Abinitio, Maven, Toad, Jenkins, Ant.

Languages: Java, J2EE, C, VBScript, Groovy, SQL.

Database: Oracle, SQL Server, My SQL.

Web Technologies: HTML5, JavaScript, CSS, Angular JS, jQuery.

Version Control Tools: SVN, GIT, PVCS.

Operating Systems: Windows,UNIX, Linux, IOS, Android.

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh, NC

ETL Tester/Software Development Engineer in Test

Responsibilities:

• Followed Scrum methodology with a sprint of 2 weeks. Involved in daily stand-up meetings.
• Involved in analyz ing the business requirements and developing test cases and test plans.
• Involved in evaluating various automation tools, processes and developing automation strategy for the project.
• Designed and Developed an Automation Framework using Selenium and Java to enable writing test scripts for Web Applications, Mobile Applications and Batch Applications.
• Developed mapping document for ETL development efforts.
• Used Maven as dependency manager for building the framework.
• Used TestNG as test framework and built the Object repository for the Web objects using Page Object Model.
• Used a combination of Key-Word driven frameworks and Data Driven framework.
• Used JFrog Artifactory to manage the Test Automation framework and enable Test Apps to consume the Framework JAR Files.
• Tested ETL mappings, enabling the extract, transform and loading of the data into target tables.
• Identifying field and data defects with required information in Informatica ETL process in various jobs and one to one mapping.
• Preparation of various test documents for ETL process in Quality Center.
• Prepared the guides for UAT & Production readiness for entire SSIS ETL testing efforts.
• Developed UI Test cases using Selenium 3.0 Webdriver and used various locators like Xpath, CSS selectors, ID’s, LinkText etc to identify the objects and interact with them.
• Developed Object Action wrappers using Explicit waits to account for timings and sync issue. This allowed developing reliable automation test cases.
• Used various third party frameworks like JDBI for database access, Apache POI for Excel file handling, XML Unit for xml parsing, JSch for SSH operations and remote computer operations on linux.
• Configured Selenium Grid to execute the Scripts parallelly on different browsers.
• Developed Custom java code to make SOAP and Rest request and used XML Parsers and JSON parsers to validate the Reponses.
• Also used SoapUI and groovy programming language to develop a suite of automation test cases for SOAP WebServices and WSDL validation.
• Validated WSDL with the use of different assertions using SOAPUI.
• Created Service Virtualization using SoapUI while working with third party Vendors and cross functional teams.
• Experience in using JDBC in Soap UI.
• Developed and used Plugins to make the Java code interact with Quality Center.
• Used various defect management tools like Bugzilla, HP ALM to log and track the defects.
• Followed Agile methodology and used Jira to create the stories and track them.
• Extensively used data Tags to handle routine test data and to skip tests. Also used the tags to group the test cases while running the cases
• Used SQL scripts to query the database and generate the test data on the fly.

Environment: Selenium WebDriver, Informatica 8.6.1/8.1, HP ALM, Java, Maven, GIT, Confluence, TestNG, Jenkins, Oracle, XML, HTML, SoapUI, Groovy, Web Services, SOA, SQL, Microsoft Excel, TOAD, Eclipse.

Confidential, Foster City, CA

Sr ETL Tester/QA Engineer

Responsibilities:

• Performed Integration, System, Regression, Performance and User Acceptance testing of an application. Prepared Test Plans and Test Cases for Reports testing and ETL jobs from the requirements. Involved in heavily modifying an existing automation framework using Selenium Webdriver and Java.
• Used Selenium WebDriver to perform UI Automation of the Web Applications.
• Used Ant as dependency manager for building the framework.
• Developed the framework using TestNG and used Surefire plugins to generate test reports
• Used Page Factory to build Object Repository.
• Used Selenium Grid to run the tests on Multiple browsers. Enhanced the scripts to capture screenshots on failure and loop back to the Jenkins results.
• Performed Database automated testing to validate the formed end screens and reports. Used MyBatis framework to connect to the Database from the framework
• Developed end to end framework to enable the testing of different applications across the tech stack.
• Designed and developed a MySQL database to store the test data and also to store the test results for reporting purposes
• Worked extensively on UI applications developed with different technology stack. Extensively used different type of locators like CSS selectors, xpath and others to handle static and dynamic websites.
• Tested SOAP and REST web services using the different assertions like HTTP assertion, security assertions, XPATH assertions in SOAPUI.
• Developed and Executed Web Service Tests using SoapUI Tool comparing with backend data.
• Extensively used TestNG groups for tagging of the test cases and to build various group of test cases like Smoke, Regression, Functional etc.
• Tested ETL graphs to extract and load data from different databases such as Oracle, SQL Server and flat files and loaded them in to Oracle.
• Written test scripts to compare OLTP vs OLAP for ETL testing
• Developed SQL queries to check the database automatically and checking the data integrity in ETL Flow of data from source to stage and target Database.
• Used Jira tool to track the Agile user stories and to track the epics and backlog.

Environment: ETL Informatica, Selenium Webdriver, Ant, Jenkins, SQL, Maven, TestNG, HP ALM12.x, Toad, SQL, Oracle, XML, HTML, Windows 7, MS Office Tools, Microsoft Excel, SoapUI, WebServices, Eclipse.

Confidential

QA Engineer

Responsibilities:

• Created Automated test cases based on the business requirements and described the test setup conditions, set the criteria for test pass/fail. Developed specific instructions on how to perform the tests.
• Responsible for creating and execution of automated test scripts using QTP and Carried out Functionality, Integration and Regression testing using QTP.
• Experienced in Creating test script QTP by recording, without recording, modifying manually and running the script in QTP / HP ALM QC saving the results in HP ALM.
• Created VBA applications using Microsoft Excel to simulate the Application Under Test (AUT).
• Designed and developed SOA tests using SoapUI and HP Service test.
• Tested Soap and Restful WebServices.
• Automated web applications testing with Quick Test Pro using VB Script.
• Inserted Check Points to check the broken links, Text and standard properties of an object using QTP.
• Designed and enhanced QTP Hybrid Driven Framework for the regression testing using modular approach.
• Extensively performed Data Driven Testing using QTP. Created Excel applications to feed data for QTP Data Driven Testing.
• Created Recovery Scenarios to handle Exceptions in QTP.
• Used Descriptive Programming to perform operations on objects not stored in object repository.
• Extracted various properties of the object and used them in descriptive programming to resolve object identification ambiguities.
• Performed Database validations using SQL and tools like Toad, SQL Server.
• Used different defect management tools like HP Quality Center, Sudden Impact and Bugzilla.

Environment: Quick Test Pro, XML, HTML, Business Objects, Oracle 9i, DB2, SQL, PL/SQL, TOAD, WebSphere, Windows XP/2003,Unix, Linux.