SUMMARY:

• Seasoned QA Engineer with experience in analyzing, reviewing and understanding business/functional requirements and translating them into automation scripts for conducting automation regression and integration tests.
• Proficient in manual and automated testing tools such as Test Director/Quality Center, Selenium Webdriver, Selenium IDE.
• Comprehensive work experience in writing complex SQL queries and PL/SQL programs.
• Knowledge about Performance Tuning and query optimization using tools like SQL Trace, Explain Plan and DBMS PROFILER

TECHNICAL SKILLS:

ERP: Oracle applications 11i/R12

Languages: SQL, PL/SQL, JAVA, Python, C++

Databases: Oracle 12c/11g/10g/9i, MYSQL, HSQLDB, TSQL

Web Technologies: HTML5, CSS3, JavaScript, XML, AJAX

Design Methodologies: Agile, Waterfall

Operating Systems: Windows XP/NT/7/10, UNIX, Linux

Java/J2EE Technologies: Core java, JDBC, Servlets, JSP, Junit, Hibernate, Spring

Scripting Language: UNIX Shell Scripting, Gherkin

Tools: Eclipse Jee Neon, Sql*Loader, Oracle Forms, Oracle Reports, Oracle Data Modeler, Oracle Designer, Management Studio, Visual Studio, Erwin, TOAD, Microsoft SSIS, Tableau, Crystal report

Testing Tools: Selenium WebDriver, JUnit, TestNG, Selenium IDE, Selenium RC, Selenium Grid, Cucumber, SOAP UI, HP ALM, Quality Center, JIRA and JMeter

PROFESSIONAL EXPERIENCE:

QA Engineer/QA Analyst

Confidential, Fairfax, VA

Responsibilities:

• Involved in identifying the problem definition as part of continuous process improvement using Define, Measure, Analyze and Improve to support the business continuity of the organization.
• Designed test scenarios, identified test data, created test cases, executed test cases, identified and reported defects, verified defects and participated in Functional, Regression and End - to-End testing.
• Performed defect coordination with triage team, ensured that test defects are tracked to closure and the defect repository is kept up-to-date with the status.
• Wrote SQL queries to test database changes and validated PL/SQL database queries.
• Used JIRA for project management, task allocation to QA, managed tasks in Jira, updated and resolved Issues, added filters to create custome’d reports and created Dashboard reports in Jira.
• Used ER Diagrams, Class Diagrams and data flow diagrams to define Data Mapping parameters of the system.
• Used SOAP UI to document test suites and test cases for RESTful web services and API store testing, involved in testing the service request and response by manual evaluation and adding assertions.
• Understood technical design documents for XML and XSD mapping of data to SOAP services, coordinated with developers and contributed to testing Soap/XML/Rest & Java/JUnit and java based web application portal.
• Worked with development team and tested newly built APIs for improved web service capabilities, used SOAP UI for testing service end-points, created regression suite, data-driven test suites with assertions for XML validation.
• Analyzed the Business Requirements Specification, Software Requirements Specification, Technical design documents and Use cases.
• Analyzed Test plan and prepared test cases as per the Requirements and General Design.
• Executed tests and participated actively in various types of testing such as Black box, Functional, Negative, Positive, GUI, System, and Regression Testing.
• Wrote Test Cases and executed test scripts as well as tracked bugs and generated defect report using Quality Center (QC).
• Prepared Requirements traceability matrix by mapping requirements to the test cases.
• Wrote and executed automated test cases using Selenium WebDriver to automate manual Testing solutions. Created Test Suites using TestNG Framework.
• Used Maven as build tool and Jenkins to create and run deployment jobs in continuous deployment and continuous integration environment.
• Experience with TDD / BDD using Cucumber / Gherkin.
• Experience in developing Test Frameworks using Modular(POM), Data Driven Approaches.
• Performed cross browser compatibility testing to check the compatibility of the application under test with different browsers.

Oracle Developer

Confidential

Responsibilities:

• Worked on various projects in different domains - Insights for Supply Chain are a product developed for warehouse management to control the movement and storage of materials within a warehouse, Construction, and insurance domain.
• Analyzing the new feature requirements, Impacts, designing the database table structure and code development design from technical perspective.
• Developed database objects including Indexes, views, sequences, packages, triggers, functions and procedures to troubleshoot any of the database problems.
• Involved in Creation of tables, Partitioning tables, join conditions, correlated sub queries, nested queries and views for the business application development.
• Created materialized views, views, tables based on the data model.
• Used SQL Loader to retrieve the data into the database tables from flat files and comma separated files (CSV). Created temporary tables and developed SQL*Loader control files to load the data into the temporary tables.
• Worked on advanced concepts of PL/SQL such as Cursors, Records, Collections and Dynamic SQL.
• Widely used PL/SQL tables and Bulk Collect for processing the load on tables and retrieving into oracle.
• Developed PL/SQL Triggers on tables for storing the old and new values for reporting purpose.
• Worked extensively on Exception handling to error handling and tracking.
• Used PRAGMA AUTONOMUOS TRANSACTION to avoid mutating problem in database triggers.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance. Trouble shooting performance issues using Explain Plan and TKPROF and SQL Trace.
• Used ETL tool for Extraction, Transformation and Loading data from various sources into Oracle Database.
• Used various transformations like Filter, Expression, Sequence Generator, Source Qualifier, Lookup, Router, Rank, Update Strategy, Joiner, Stored Procedure and Union to develop robust mappings in the Informatica Designer.
• Done analysis of Source, Requirements, existing OLTP system and identification of required dimensions and facts from the Database.
• Fixed defects for existing code in production environment.
• Involved in the production support, to identify the root cause of the issue and query out the effected data and fix accordingly.
• Written and executed the Test cases for the new developed features.
• Involved in Agile methodology daily meetings and used Github and Rally tools for deploying the code and tracking the daily activities.