SUMMARY:

• Over 6 years of diverse experience in information technology with an emphasis on Software Quality Assurance in industries like Telecom and Banking.
• Experienced software automation tester looking for a responsible and challenging position with a turbulent and dynamic organization which offers opportunities for personal and professional development and where I can utilize my knowledge and skills.
• 6.5+ years of testing experience in Information Technology with emphasis on Quality Assurance with Manual, ETL Testing and Automation Testing on Telecom and Banking domain.
• Good Knowledge in Tableau Development.
• Developed and enhanced different Dashboards based on Various LOB data and fixed many bugs in Tableau.
• Good exposure to all the Oracle concepts as Joins, Views, Indexes, Partitioning, PL/SQL.
• Developed ETL test cases for various lines of businesses based on ETL mapping document.
• Extensively used ETL for testing and supporting data extraction, transformations and loading processing in a corporate - wide-ETL Solution using Microsoft SSIS Packages.
• Tested the ETL Data Stage jobs and other ETL Processes (Data Warehouse Testing)
• Worked with ETL group for understanding & mapping for dimensions and facts.
• Expert in retrieving database information writing SQL Queries and transforming data to information as needed. Performed extensive Backend Testing of the applications using PL/SQL Queries in SQL Developer and Microsoft SSMS.
• Good understanding and exposure of Core Java concepts such as Abstraction, Encapsulation, Inheritance, Polymorphism, Collections, JDBC (Java Data Base Connectivity) Programming and Interfaces.
• Good knowledge in developing end to end automation using Selenium Web Driver/RC/IDE/Grid, TestNG, Jenkins.
• Involved in designing and developing strategic Test plans, Test Cases, Test Scripts, Test Scenarios, Test Reports for manual and automated test cases.
• Good Knowledge in Tableau Development.
• Developed different Dashboards based on SQL data and fixed many bugs in Tableau.
• Extensive experience in white box testing, Black box testing Functional, Integration, Unit, API, Regression, User Acceptance (UAT) and System Testing.
• Highly skilled in using web technologies like JavaScript, HTML& CSS.
• Strong at bug-reporting, bug-tracking and change management using Test Management tools like Quality Center.
• Automated and generated test cases for Angular.js application using protractor with jasmine framework.
• Extensive experience in testing applications implemented in JavaScript, XML, HTML, SQL Server and Oracle.
• Experience in Understanding the code written in different programming languages Java, HTML, JavaScript and CSS, SQL, and Oracle.
• Experienced using Web-debugging tool like Fire Path and Firebug for finding elements locator.
• Experience working with Agile software development methodologies
• Good Exposure to all stages of Software Development Life Cycle (SDLC), Software Testing life cycle (STLC) and Bug Life cycle.
• Effective communication, proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.
• Good communication and presentation skills with ability to communicate at all levels.
• Strong team player, enthusiastic learner, confident, sincere and committed.

TECHNICAL SKILLS:

Testing Tools: Selenium2.0 / 1.0, Selenium web driver, HP Quality Center,JIRA

Operating System: Windows, UNIX

Languages: JAVA, C, C++, HTML, XML, Java Script, CSS,Angular JS, JSON

Query Tools: TOAD, SQL Developer, SQL Navigator, SQL Plus, DB Visualizer

Web Debugging: Xpath, Firepath, Firebug

Databases: Oracle 12c,11g,10g and 9i,MYSQL, MS SQLServerManagementStudioPostgres,Vertica

ETL: OWB 11G, INFORMATICA, MS SSIS

BI: OBIEE 11G, Tableau

Methodology Agile: IDE/Tools Eclipse, Putty

Integration Serve: r Jenkins API SOAP, REST

PROFESSIONAL EXPERIENCE:

QA Engineer

Confidential - Denver, CO

Responsibilities:

• Working on Agile SDLC approach implementation for the whole testing life cycle
• Gathered requirement and created, executed and documented Test Cases as per requirements in JIRA.
• Performing ETL Testing across different databases to verify the data after system integration.
• Ensuring that data from database reflecting correctly in reports or not.
• Extensively conducted Back-End Testing using which involved complex SQL Queries.
• Responsible for data validation testing using Oracle, SQL, Postgres, Vertica and executing testing on data Warehousing project
• Created and maintained data mapping documents to support data migration.
• Created test scripts for security. Positive, negative and system integration testing (SIT) were performed.
• Creating Test scripts for regression testing to test the old data.
• Working with team manager in supervising, guiding, and supporting their testing efforts for integration.
• Developing Oracle, SQL, Postgres, Vertica queries for Database testing.
• Responsible for writing the test cases and test scenarios based on the functional specification and technical specification.
• Maintaining all Test cases in JIRA and updating the status as progressed.
• Cross functional database testing using internal Automation Tool.
• Working on JIRA for bug status tracking and maintained and created status reports for the application.
• Involved in the weekly defect review meetings to review the status of defect fixes and upcoming build releases.
• Using JIRA for version control, tracking defects, enhancement requests, maintaining Test cases and test scenarios, assign work activities and assess the real status of project throughout the life cycle.
• Documented the test execution summary results and reported the status of assigned test tasks and issues to project manager for approvals.

QA Engineer

Confidential - Denver, CO

Responsibilities:

• Working on Agile SDLC approach implementation for the whole testing life cycle
• Reviewing Business requirements, Design documents & done detailed analysis required for the project.
• Attending the design walkthrough with Designers and developers.
• Gathered requirement and created, executed and documented Test Cases as per requirements in Blueprint.
• Testing all the Tableau Dashboards and SSIS packages.
• Developing and Enhancing Tableau Dashboards based on requirement.
• Performing ETL and Automation Testing to verify the data after system integration.
• Ensuring that data from database reflecting correctly in Dashboards or not.
• Checking all kind of Dashboards like Adhoc and static which involves graphs tables etc.
• Tested ETL SSIS Packages to check data flow from one database to another db.
• Extensively conducted Back-End Testing using which involved complex SQL Queries.
• Responsible for data validation testing using SSMS and executing testing on data Warehousing project
• Created and maintained data mapping documents to support data migration.
• Validating the data mapping process using SSMS query in Ms SSMS(SQL Server Management Studio).
• Created test scripts for security. Positive, negative and system integration testing (SIT) were performed.
• Creating Test scripts for regression testing to test the old data.
• Using Selenium Tool to check data in different tables automatically.
• Working with team manager in supervising, guiding, and supporting their testing efforts for integration.
• Developing SSMS queries for Database testing.
• Responsible for writing the test cases and test scenarios based on the functional specification and technical specification.
• Responsible for writing Test scenarios and Test scripts for UAT testing.
• Working on JIRA for bug status tracking and maintained and created status reports for the application.
• Involved in the weekly defect review meetings to review the status of defect fixes and upcoming build releases.
• Using JIRA for version control, tracking defects, enhancement requests, assign work activities and assess the real status of project throughout the life cycle.
• Documented the test execution summary results and reported the status of assigned test tasks and issues to project manager for approvals.
• Tracking the functional queries to closure with the help of the Component designers and developers.
• Coordinating with team members and make sure that test deliverables adhering to the time lines, status reporting to management, and escalating

Senior QA Engineer

Confidential

Responsibilities:

• Involved in Automation Testing using Selenium and as ETL Tester to test the data.
• Participated in Requirements and Design review meetings.
• Rich experience in User Acceptance Testing, System Functional Testing, Regression Testing, and Smoke Testing .
• Extensively did Integration Testing to check all the requirements are correct.
• Tested ETL RDBM to check data flow from one database to another db.
• Extensively conducted Back-End Testing using which involved complex SQL Queries.
• Responsible for data validation testing using SQL and executing testing.
• Maintained data mapping documents(Realtion Data base models) to support data migration.
• Used to check the Informatica maps to check whether the data is mapped properly are not.
• Used TestNG Annotation is Selenium Web Driver and executed a batch of tests as TestNG suite
• Good Experience with Selenium Web Driver And Continuous Integration tool Jenkins.
• Configured Selenium Web Driver, TestNG, Maven tool and created selenium automation scripts in java using TestNG prior to agile release.
• Participated in developing automation scripts using Selenium Web drive
• Worked in a team, involved in the UI, layout and front-end programming (HTML).
• Followed agile methodology, participated in daily SCRUM meetings and testing each SPRINT deliverables.
• Involved in writing of Automation Test cases using Selenium Web Driver, Java
• Used web-debugging tools like XPath, Firebug and Fire path to locate elements.
• Developed test code in Java language using Eclipse IDE and TestNG framework.
• Involved in creating complete RDBMS to support automation test framework using SQL server.
• Automated Smoke and Functional test cases using Selenium Web driver, TestNG and Java.
• Conducted weekly walkthrough on testing progress and providing daily status update to the management.
• Determine priority of action and additional resources required, based on incident severity.
• Identifying test cases to be run for regression testing and conducting regression testing as and when new builds were made

QA Engineer/ETL tester

Confidential

Responsibilities:

• Worked on Agile SDLC approach implementation for the whole testing life cycle
• Reviewing Business requirements, Design documents & done detailed analysis required for the project.
• Attending the design walkthrough with Designers and developers.
• Gathered requirement and created, executed and documented Test Cases as per requirements in Quality Center.
• Understanding various components and prepared the test scenario document, Peer reviews the test design and getting sign off from the E2E designer.
• Used OWB tool, packages and procedures using SQL developer, reports using OBI.
• Tested GUI Reports created using OBIEE Tool.
• Tested all the OBIEE Dashboards and few Tableau Dashboards.
• Ensured that data from database reflecting correctly in Dashboards or not.
• If necessary used to fix some defects in Dashboards.
• Used to check all kind of Dashboards like Adhoc and static which involves graphs tables etc.
• Analyzed PLSQL Packages and procedures and identify the exact issue for the mismatch of the requirement with the reports.
• Tested ETL OWB mapping to check data flow from one database to another db.
• Extensively conducted Back-End Testing using which involved complex SQL Queries.
• Responsible for data validation testing using SQL and executing testing on data Warehousing project
• Created and maintained data mapping documents to support data migration.
• Validated the data mapping process using SQL query.
• Created test scripts for security. Positive, negative and system integration testing (SIT) were perform.
• Worked with team manager in supervising, guiding, and supporting their testing efforts for integration.
• Verified the test cases and tests scripts written by Jr. Testers in QC.
• Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.
• Responsible for writing the test cases and test scenarios based on the functional specification and technical specification and documented in HP Quality Center.
• Worked on Quality Center for bug status tracking and maintained and created status reports for the application.
• Involved in the weekly defect review meetings to review the status of defect fixes and upcoming build releases.
• Used QC for version control, tracking defects, enhancement requests, assign work activities and assess the real status of project throughout the life cycle.
• Documented the test execution summary results and reported the status of assigned test tasks and issues to project manager for approvals.
• Tracking the functional queries to closure with the help of the Component designers and developers.
• Preparing the presentation of New Functionalities and providing the information to entire team and Customers on for every release.
• Coordinating with team members and make sure that test deliverables adhering to the time lines, status reporting to management, and escalating the issues

QA Tester/Manual tester

Confidential

Responsibilities:

• Involved in testing all the different Dashboards manually.
• Analyzed user requirements and software requirement specifications documents.
• Attend requirement review meetings and clarify queries on requirements
• Identify high level scenarios for the system requirements.
• Review Requirements Matrix to ensure all requirements are included in the scope of testing .
• Conducting and involving in meetings and walkthroughs with users, developers and Business Analysts to gather information about business process.
• Preparing test plan and reviewing with business and getting approval
• Reviewing test scenarios with business and getting approval
• Developing test cases based on test scenarios created and getting approval
• Executed the test cases to test the functionality of the Dashboards.
• Created and executed the Test plan, Test Cases and Test Steps for all the modules and stored in HP Quality center.
• Defect Tracking, Report generation and requirement tracking throughout the test life cycle using Team track.
• Responsible for conducting for Pre-UAT demo and UAT testing support activities.
• Working with Quality Center on Customizing the User privileges and various module labels.
• Preparing and providing test status reports to the management on system status, system changes, problems and potential impacts.
• Provides necessary support during deployment testing.

QA Testing Intern

Confidential

Responsibilities:

• Document test scenarios, expected results and actual results.
• Execute test cases and scripts used in testing of a web application.
• Participate in reviews and meetings with analysts and developers.
• Report and trace defects using HPQC software and mapped the defects with requirement.
• Gained hands-on experience with manual software testing to identify code violations and improvements related to efficiency, changeability, robustness, and security.
• Works closely with the team to develop and create test plans with robust and comprehensive test cases based on software requirements and technical specifications.
• Provide test execution and defect status to the project team.
• Verify resolved bugs during the project.
• Participated in sprint planning and collaborates with the Product team to review user stories and acceptance criteria for testing purposes.
• Collaborate with Team members to resolve defect.