PROFESSIONAL SUMMARY:

• OverSix plusyears of extensive and diversified experience in Information Technology with emphasis on ETLQuality Assurance Testing on both web based, Client/Server, Windows applications.
• Experience developing & producing Test Scripts and Test Cases for Client server and Web based Applications.
• Extensive experience in testing Client/Server, Web Based and Mainframe applications.
• Expert knowledge base of the Software Development Life Cycle and experienced with Waterfall, Iterative, and Agile methodologies.
• Expertise in Bug reporting tools such asALM Quality Center and Rational Clear Quest.
• Experience on Preparation of test plan, test procedures, Manual and Automation test scenarios, test scripts, Report defects.
• Good working knowledge of validating backend database data and ETL process workflow by writing T - SQL queries in Oracle.
• Proficient in manual and automated testing of applications on Windows and UNIX environment.
• Good experience in client interactions regarding any testing related issues.
• Experienced in creating Selenium IDE Test Suites for Smoke and Regression testing, expert in creating Test Automation frameworks using Web Driver, expert in building TestNG framework with data-driven, modular approach, Batch test execution, reporting and error handling techniques.
• Full SDLC experience and experience with projects and Iterative Software Development Life Cycle Process as per Rational Unified Process (RUP) and Agile Methodology.
• Good working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Business Process Modeling (BPM), Use Case modeling using UML, Data Modeling, Project Management, Change Management, Software Training, Software Development methodologies, QA testing and Systems Testing, troubleshooting of client server and web-based systems.
• Professional experience working on Development platforms, use of open source technologies like Selenium Web Driver, TestNG, Maven, GitHub and Plug-In Jenkins for build management and delivery in CI/CD environments.
• Strong experience in all levels of Testing such as Positive testing, Negative testing, Functional Testing, System Testing, Regression Testing, Data Migration testing and User Acceptance Testing (UAT), Database testing, Security and Usability testing.
• Experienced in Bug Tracking Tools such as ALM Quality Center.
• Experience in working with Business Analysts to understand the business critical functions and workflows define in BPT module of ALM Quality Center and to convert them into automation test scripts using UFT/QTP.
• Expertise in writing Automation scripts in Selenium using Java and Python programming language.
• Hands on experience in writing SQL queries, Joins, Functions, Procedures, Packages, DBMS, RDBMS, and Triggers in Teradata, Oracle and SQL Server databases.
• Experience on both Agile and Waterfall Software development methodology.
• Worked on multiple data analysis task to analyze data, tables and other database contents.
• An expert in analyzing, understanding and testing applications related to banking, finance and mortgage domain.
• Experience in Back-End Testing using SQL on UNIX and Windows platform to validate the consistency of data.
• Good working knowledge of major Operating Systems such as Windowsand UNIX.

TECHNICAL PROFICIENCY:

Testing Tools: Selenium IDE, Selenium Web Driver, Microsoft Test Manager, HP Quality Center, ALM, SOAP UI, Cucumber, Test NG, LoadUI, JMeter

Scripting Languages: RDBMS Oracle, TSL, VB Script, Java, PL/SQL, TSQL

Query Tools: TOAD, MS SQL Server Management Studio, SQL Analyzer, SQL+, My SQL

Web Reporting Tools: Cognos, SSIS, SSRS (SQL Server Reporting Services) etc.

Database: MS SQL Server, MS Access, Oracle, ETLData warehouse, Informatica.

Platforms: Windows, UNIX

PROFESSIONAL EXPERIENCE:

Sr. Automation Engineer

Confidential, Houston, TX

Responsibilities:

• Develop and execute software test plans in order to identify software problems and their causes.
• Write and maintain detailed test plans, test cases, and test scripts.
• Review business requirements and specifications for consistency in quality standards and preparation for testing.
• Execute test cases and/or automation scripts for both functional and regression tests.
• Experience with QA Methodology and QA Validations to ensure the Quality.
• Strong Communication and Interpersonal skills to maintain effective work relationships with all levels of personnel. Clear Understanding of Business Rules and Ability to work as a part of team
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Rest API Testing and Automation Using Postman tool with JavaScript.
• Ability to interact with all levels of personnel from technical to high level executive management within the information technology and business communities.
• Automating Functional and Regression scenarios using Cucumber Behavior Driven Development (BDD) Framework using Java as coding language.
• Coordinated with functional test teams to interpret requirements, developed positive and negative test scenarios, created Functional and Regression test suites in Page Object Model framework using Selenium Web Driver.
• Reviewed Business Requirement and Software Specification Requirements to achieve better understanding of the Application.
• Refactored and re-wrote Selenium Web Driver test scripts to accommodate Regression testing and usable by QA.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Executed Test Cases and Gathered Test Execution results.
• Tested the Functionality of the application through manual Testing.
• Developed Test Scenarios and Test Procedures based on the test requirements.
• Created Test Cases manually for Functional testing based on the Functional areas and Use Case documents.
• Used the business objects (ETL tool) Repository to make resources available to the users for ad-hoc report needs, and Created reports containing all the information regarding the end user business requirements.
• Automated the Test Cases using Selenium, WebDriver, Java Eclipse and JUnit.
• Created, maintained and updated test strategy, test conditions, test cases and regression testing based on business requirement.
• Prepared automated scripts for Maintenance and Regression testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Analyzed existing and planned business processes. Documented workflows and created functional specs for development.
• Used SQL queries to retrieve data from Enterprise Data Warehouse (EDW) /Teradata and validate them, tested on the Mainframe for data validation and also tested using Pivot Tables for ETL processes
• Performed Front End and Functionality Testing using CORE
• Coordinated all the database changes to the development and test databases.

Environment: Windows, Oracle/SQL Server, XML SPY, XML, SQL, MS office, ALM, UML, JIRA, Rational Suite, MS Visio, Scenario builder, CORE, DC Console, WARP

Automation Engineer

Confidential, Fredrick, MD

Responsibilities:

• Developed mappings in Informatica to load the data from various sources into the Date warehouse
• Responsible for testing all new and existing ETL Date warehouse components.
• Performed various types of testing such as Functional, Regression, SIT, UAT, Backend etc.
• Created Test Plans and Scenario which describes the features and functions to be tested.
• Responsible for gathering business requirements and writing functional specifications and process documents pertaining to new customizations or enhancements.
• Prepared Test Plans, Test Scripts and Test Cases based on functional specifications and user requirements.
• Designed and executed the Automation Test Scripts using Selenium WebDriver and TestNG.
• Performed Data driven testing using Selenium WebDriver, TestNG functions and JDBC Connections which reads data from scripts using property and XML files.
• Created Java based scripts for Selenium WebDriver with TestNG as automation framework.
• Integrated the scripts and executed them as a suite using the build integration tool Maven.
• Created Maven Build files and used SVN for version control.
• Monitored the test execution in Jenkins once the code pushed into Continuous Integration.
• Responsible for creating and maintaining automation acceptance test suite using Selenium, Ruby and Cucumber framework.
• Responsible creating the functional testing framework using TestNG and using Selenium WebDriver to automate the UI components.
• Generated Test data and Data Request document for various types of testing for valid data, Invalid data testing.
• Performed defect reporting and bug tracking using HP Quality Center.
• Used XML files in Sending/receiving XML requests using SOAP UI.
• Used Firebug Tool to identify the Objects id, Name, XPath in the application.
• Introduced and implemented Open Source web test tool Selenium and WebDriver for cross browser testing.
• Executed Test Cases recorded in HP Quality Center manually to test the application for its functionality, system integration and verify the Exit Criteria.
• Performed various types of testing, such as Functionality, Regression, GUI Interface, Integration System, User acceptance and, end-to-end testing.
• Actively participated in walk-through, inspection, review and user group meetings for quality assurance with BAs, SMEs and Developers.
• Maintained Metrics and participated in the Weekly Status Updates showing the progress of the testing effort and open issues to be resolved.
• Developed and tested many features for dashboard using Ruby on Rails, CSS, and JavaScript.
• Understand UFT/QTP Error Handling, Recovery Scenarios, and Environment Variables
• Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results
• Produced various test reports such as Test Execution Status, Test Execution Summary/Progress, Defect Status, Defect Summary, Defect Inject Rate on daily and weekly basis and submitted
• Used JavaScript for client-side validations and used DHTML for menu and text effects on the website.
• Detected, reported and tracked defects using ALM Quality Center.
• Used SQL queries to do Backend testing to perform data validation, data migration/data conversion validation.
• Involved in understanding the Java and extensive SQL coding since the application is heavily database oriented.
• Generating Cognos report and validate the data using SQL queries in Teradata and Oracle data bases
• Maintained and modified the UFT/QTP scripts with user defined functions as a part of functional and regression test.
• Created automation scripts in Eclipse, Selenium WebDriver, running them as TestNG.
• Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results
• Developed and executed Test Scripts using Selenium WebDriver, TestNG, analyzed Test Results in Eclipse IDE.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality. Executed SQL queries for Data Migration and Data testing.
• Worked with the components of Data Warehousing like components model, ETL tools.
• Performed Data Profiling of current state of data in the Date warehouse by doing Data Analysis using advanced SQL Queries and Microsoft Excel, finding Gaps in Data and formulating solutions for the same
• Generating Cognos report and validate the data using SQL queries in Teradata and Oracle data bases
• Conducted Bug Review meetings by reviewing and discussing all defects by their business severity and worked actively development and business team to perform the root cause analysis in order to find the resolution.

Environment: Selenium, Java, J2EE, .NET, C#, Cognos, Oracle, Enterprise Date warehouse, ETL, SSRS, Informatica, SQL Server, PL/SQL, XML, ALM Quality Center, UFT/QTP, Etc.

QA Engineer

Confidential, Atlanta, GA

Responsibilities:

• Reviewed FSDs, BRDs and MDDs, use cases, data flow diagrams to creation of test plan, test scenarios, test cases and test data.
• Actively participated in JAD sessions with BAs and SMEs and suggested improvements to the requirements.
• Developed Test Framework in Selenium for UI Regression Test Automation and when necessary, and potentially execute Unit Test automation (Java/JUnit).
• Prepared the traceability matrices to fill the gap between the requirements and the test cases covered.
• Performed functional tests using Selenium WebDriver with data driven framework and documented final results in a database.
• Involved in designing and developing automated functional Test suite using Selenium WebDriver.
• Involved in the Continuous Integration of the automation framework with Jenkins
• Participated in production implementation verification for validating system quality.
• Created, managed and executed Test Cases using Quality Center.
• Performed Functional, Integration, System, GUI, Cross Browser compatibility, Ad- Hoc Testing.
• Conducted regression testing of the existing features and new enhancements of the application.
• Designed and executed the Automation Test Scripts using Selenium and JUnit.
• Maintained Test Data in Excel spread sheet in order to drive variable data into the application under test, and verify the expected result.
• Managed defect reporting and tracking using Quality Center.
• Reviewed test plans, test cases and test scripts to ensure consistency with strategic direction, goals and objectives of QA resources working on the project with Agile SCRUM methodology.
• Managed weekly management status reports and coordinated meetings between test team and development team to review defects.

Environment: Selenium WebDriver, Junit, Jenkins, HP Quality Center, MS-Office Suite, Oracle and Windows.

QA ETL Tester

Confidential, Freeport, Maine

Responsibilities:-

• Created Business Workflow based on the requirements gathered from the client.
• Developed business requirements document (BRD), User stories, User requirements and functional requirements.
• Utilized Agile Software Development Methodology.
• Managed requirement activities using an iterative and incremental methodology such as Agile using User stories and Acceptance Criteria.
• Organized team meetings on a regular basis and involved in active discussion in order to improve the quality by better strategies and analytical approach.
• Reviewed sales agreement, logistics, and legal and supply chain issues.
• Designed and developed scenarios based on business requirements.
• Strong working experience with agile methodologies.
• Worked with ETL group for understating mappings for dimensions and facts
• Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results
• Actively worked with developers as needed to isolate the Root Cause Analysis of defects
• Interacting with other teams through walk-through, teleconferences, meetings, etc. to resolve various issues.
• Performed Regression Testing, UAT and Ad-hoc testing.
• Proficient in writing good SQL queries.
• Initiated, proposed and implemented critical analytical and technical turnkey solutions extensively increasing the quantitative and qualitative value of the application.
• Provided overall project management to multiple projects successfully completing them on-schedule and on-budget.
• Managed the milestones and make sure of their completion within the established timeline.

Environment: s: Oracle, SQL, Java, JavaScript, Data Warehouse, ETL, Quality center, XML, Quick Test Pro, UNIX, Web logic, Share Point, UNIX, POS Registers