SUMMARY:

• Dynamic and result oriented software testing professional having total 10 years of QA experience in Manual Testing, ETL Testing and Test Automation (Selenium WebDriver, TestNG) mainly for applications in Banking, Retail(Retail Merchandising System), Airline and E - Learning Industries
• Proficiency in Back-End Testing/Database Testing, Web-based Applications testing, JDA & Oracle Retail Applications Testing, GUI Testing, User Acceptance (UAT testing)
• Good Hands-on experience in Project initiation activities-Functional FRD/BRD Walk-thru, Automation Scope Identification, Estimation, Preparing Test Plan documents
• Excellent experience in ETL testing(6 years) including Data Analysis, Data Validation, Data Completeness, Data Transformation for various data feeds coming from source
• Extensive experience in developing SQL scripts to validate the database tables and reports for backend database testing
• Experienced using UNIX commands
• Good knowledge of Automation Frameworks using Selenium WebDriver (2 years)with Core Java, TestNG & Maven. This includes framework of types Data Driven, Keyword and Hybrid
• Knowledge on CI/CD tool Jenkins and TDM (Test Data Management)
• Experience in manual testing of web services(XML/SOAP based)
• Proven ability in working individually or as a part of team, problem solving, Process improvement activities, Analytical skills, Reporting
• Efficient Analysis and Planning skills which resulted in effective testing methodology/strategy and Test plan
• Good understanding of Quality Assurance methodologies like Waterfall, V-Model, Agile, Scrum
• Well versed with Defect/Test Management tools like JIRA, Quality Center, ALM and Bugzilla
• Quick Learner with strong analytical skills

TECHNICAL SKILLS:

Testing Tools: Selenium Web driver, Selenium IDE and AutoIT, Jenkins, SOAP UI

Defect Tracking Tools: HP ALM, HP Quality Center, Jira, Bugzilla.

ETL Testing Tools: Ab Initio (GDE & ACE)

Database: Oracle PL/SQL

Languages/Framework: Core Java, TestNG

Build Tools: Maven

Operating Systems: Unix, Windows, Mac OS

Other Applications: Oracle Apps (Oracle RMS 12.0, Oracle SIM 12.0, Oracle RPM 12.0,Oracle RESA),TOAD, Putty, Eclipse, Filezilla, JDA (Supply chain)

PROFESSIONAL EXPERIENCE:

Confidential

QA Lead

Responsibilities:

• Involvement in System test plan preparation and requirements streamlining.
• Identified and prioritize test cases to automate.
• Involved in Automation Environment setup using Eclipse, Java, Test NG and Selenium Webdriver jars.
• Created Test cases using element locators & Selenium Webdriver methods.
• Enhanced Test cases using Java programming features and TestNG annotations.
• Design and developed Selenium Hybrid Automation framework using TestNG, Apache POI and Maven.
• Conducting Data Driven testing, Cross browser testing and parallel test execution.
• Preparation of Weekly and monthly status reports.

Environment: ALM, Selenium Webdriver, TestNG, Java, Maven, Eclipse

Confidential

QA Lead

Responsibilities:

• Analyzing functional specification and creation of high level test scenarios.
• Reviewing test cases and test data. Use statistical methods to analyze data and generate useful business reports.
• Responsible for analyzing data requests to determine availability of data and optimal methods for resulting datasets.
• ETL Testing using Ab Initio (ACE and GDE). Used TDM and TFW templates of ACE Environment.
• Defined the data cleansing strategy based on the exploratory data analysis reports which to be applied on the staging data base and then pushed to the Operational data store.
• Involved in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews.
• Tested a number of complex ETL mappings and reusable transformations for daily data loads.
• Extensively worked with flat files and excel sheet data sources.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
• Used Unix Commands and execution of shell scripts.
• Validated SOAP UI API services.
• Used Quality Center for test script and test result management and bug tracking and reporting.
• Guiding new resources to make them familiar with the project work.

Environment: ALM, Unix, Ab Initio (ACE & GDE), Oracle PL/SQL, SOAP UI, HTML

Confidential

QA Lead

Responsibilities:

• Analyzing functional specification and creation of high level test scenarios.
• Perform automation feasibility analysis and Test effort estimation of underlying applications
• Plan, design and implement automation framework based on business requirements using Selenium WebDriver (JAVA).This includes Data-Driven, Hybrid frameworks.
• Developing Test Plan and Test scripts.
• Manage development code releases and testing of code using Jenkins.
• Used web-debugging tools like XPath, Firebug and Firepath to locate elements.
• Handling the Desktop based objects with Auto IT using Selenium.
• Test Data preparation and work with interfacing applications for data needs.

Environment: Jira, Agile, Selenium Webdriver, TestNG, Java, Maven, Eclipse

Confidential

Sr. QA Automation Tester

Responsibilities:

• Created Test strategy and plan, test data ensuring accurate coverage of requirements and business processes.
• Identified test cases to automate, prioritized suitable candidates for automation and automated test cases using Selenium WebDriver, TestNG and Java.
• Configured Selenium WebDriver, TestNG, Maven tool and created selenium automation scripts in Java.
• Executing jobs using UNIX.
• Data validation using SQL Queries.
• Used Jira for logging defects.
• Follow Scrum Methodology and actively involved in release planning, sprint planning, daily stand-up calls and sprint retrospective meetings.
• Delivered thorough QA testing reports that determined test quality and release readiness.

Environment: Selenium Webdriver with TestNG Framework, Jira, Putty

Confidential

QA Analyst/Lead

Responsibilities:

• My role as a QA Lead (For Release R1B-Asia Expansion, EU and E2E Step 2.1) included helping junior team members identifying and preparing Test Scenarios based on RICEF components, preparing Test Data.
• Experience in understanding RICE (Reports, Interfaces, Conversions and Extensions) components of Oracle Application Business Objects
• Experience in Unix Commands and used FTP for File Handling and File Transferring.
• Analysed RMS(Retail Merchandising System, RPM(Retail Price Management) and Allocation test cases.ETL Testing and Data base Testing using SQL Queries.
• Performed Verification, Validation & Transformations on the Input data (Text files, XML files) before loading into target database. Validated data between source and target files.
• Helped Automation team by providing valuable functional inputs which proved useful in successful execution of scripts through QTP.

Environment: Oracle Applications (Oracle RMS 12.0, Oracle SIM 12.0, Oracle RPM 12.0, RESA), QC, Oracle PL/SQL, QTP

Confidential

QA Lead

Responsibilities:

• Preparation of Test Cases based on ETL Specification Document, Use Cases, Low Level Design document.Reviewing test cases and Test Data.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
• Testing of Data maps between legacy systems and relational databases.
• Tested ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.

Environment: QC, JDA (Allocation, Demand & Fulfillment), Oracle PL/SQL

Confidential

Test Analyst

Responsibilities:

• Understand the requirements and formulate the test specifications including test plan and test scenarios based on requirements.
• Used GUI testing to check for appearance of the website and application.
• Validated ETL process and reports using SQL queries.
• Performed regression testing against the various builds of the application.
• Defects were tracked, reviewed, analyzed and reported using Quality Center.

Confidential

Software Tester

Responsibilities:

• Writing and Executing Test Cases and Performing Regression, Smoke and UI Testing.
• Checking how well the build has been translated into a language.
• Verification of linguistic accuracy and checking of printed documentation, online help messages and command-key sequences.
• Bug Reporting using Online Bug tracking tools by Adobe.