SUMMARY

• Around 6 years of diverse experience in Quality Assurance methodologies and emphasis on Information Technology
• Excellent knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC)
• Sound experience in writing and executing test cases in end to end System, Integration, Integrated system testing, Backend testing, Functional, Regression, Performance test and User acceptance testing (UAT) designed Automation frame Work.
• Experience as Onsite coordinator and QA Lead with various projects and clients
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies.
• Exposure to multiple ETL tools including Data stage, Informatica and SSIS.
• Extensive work in ETL testing using SQL, UNIX, PL/SQL.
• Experience in Mobile Testing iOS and Android for the applications functionality
• Expertise in QA Methodologies like waterfall, V model, Spiral and Agile with scrum
• Designed, Developed and maintained automation scripts using Selenium WebDriver for functional and regression testing
• Development experience in creating automated Test Scripts using VBScript for Functional & Regression Testing using HP Quick Test Professional (QTP).
• Proficient in test strategy preparation, test plan development, test case creation, test execution and bug tracking
• Have extensive experience on Financial, Health Care, and Banking domains.
• Strong knowledge in developing database queries for Backend Testing using ORACLE and SQL Server.
• Responsible for creating manual test scripts to include Functional Test, Regression Test, UAT, Data Migration Test and Study Configuration Test.
• Experience in testing web service using SOAP UI tool. Possess expert level of understanding of WSDL, XSD, Schema, DTD, XML documents for Web Services Testing.
• In - depth understanding of application testing with emphasis on web based and client server applications.
• Responsible for writing detailed bug reports or tickets
• Experience in using test management tools like QC (Quality Center) and Test Director. Have hands-on on experience in other bug tracking tools like Bugzilla, TFS, Ontime and JIRA

TECHNICAL SKILLS

Testing Tools: QTP, HP ALM 11.0, JIRA, BUGZILLA, Selenium2 (WEBDRIVER)

Data warehousing: Informatica 9 / 8.6.1, OLTP, OLAP, Data Stage 8.x, DataMart, SQL*Loader TOAD

Languages: .NET, C#, C++, VB 6.0, OOP Java, SQL

Web Technologies: HTML, XML, Web Services, SOAP UI, RESTAPI

Database Servers: DB2, SQL Server 2000, ORACLE 10i.

Operating Systems: iOS, Android, Windows, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Richmond VA

QA Tester

Responsibilities:

• Analyzed business requirements, data mapping specifications and developed Test Plans, Test Cases, Expected Results and Prioritized tests for the applications for various modules using Quality center.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Involved in automated Regression Testing using Quick Test Professional (QTP).
• Created complex SQL queries for querying data against different data bases for data verification process.
• Created Test cases for Data Acquisition and Data Delivery and tested the data accuracy for all the transformations.
• Validated the data on Front end applications to reflect the data on the back end using SQL queries
• Expertise in planner/designer using mapping, transformations, data validation, oracle data warehouse builder.
• Tested various mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformation
• Tested PL/SQL Packages to transform/load the staging data into schema using business logic.
• Tested several data migration application for security, data protection and data corruption during transfer
• Developed and maintained Selenium WebDriver scripts using in-build framework, JUNIT and TestNG with detailed reporting and screenshots
• Performed end to end testing in the form of scripts for the Mortgage applications.
• Validated web services using SOAP UI by testing XML request and response data with SOAP.
• Extensively created Data Driven Test scripts to read data from the excel using POI API for testing
• Validated the Web Services testing using WEB API(REST) both Request and Response messages
• Responsible for managing and organizing designing/testing documents and logging defects using HP QC
• Used SQL queries to retrieve data from tables and to perform back end testing thru TOAD.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for testing business rules and transformations.
• Performed integration, regression, retesting.
• Tested jobs and used Informatica as an ETL tool to load the final loads. Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: QTP, Teradata, Oracle 11g/10g, XML, TOAD 6.0, MTM(Microsoft test Management),TFS(Team Foundation Server),Java, Agile, SQL, PL/SQL, Unix, Selenium, TestNg, Junit, Eclipse, Quality center 11.5/ALM, Soap UI, Informatica 8.6

Confidential, Charlotte NC

QA/Manual Tester

Responsibilities:

• Coordinated all QA activities and enhancements using Agile Methodology.
• Analyzed user requirement document and developed Test Plans, Test Cases and test Script.
• Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
• Performed Sanity testing, System testing, Functional testing, Integration testing, Web testing and GUI testing.
• Prepared and executed scenarios for the Regression testing on new builds.
• Conducted User Acceptance Test (UAT) with users and customers and wrote issues log based on outcome of UAT.
• Tested bank Loan information web based application used to request and approve Mortgage loans.
• Analyzed test cases for automation and used Quick Test Professional (QTP) to automate manual test scripts for Regression and Functional testing.
• Prepared Test Plan wrote Test Cases and executed test scripts as well as tracked bugs and generated defect report using Quality Center (QC).
• Administered Quality Center partly by creating the user groups and assigning privileges to Users.
• Create and run BAT File to execute Automation Test Suites and generate XSLT Reports using Apache Maven and TestNG
• In the regression phase, the project was automated using Selenium. I was responsible for developing a dynamic framework which could automate all the test cases.
• Experience in Web Services Testing using SOAP UI, WSDL provided by the developers.
• Created test suites and performed data driven testing using SOAP UI. Validate request and response xml through Soap ui
• Hands on experience in collecting several metrics and preparation of defect reports.
• Conducted Regression testing using QTP after the bugs have been fixed by the development team.
• Performed Backend testing to validate the data using Toad, added SQL queries to the required Test cases.
• Involved in Data migration and Data distribution testing
• Report and review the defects in Mercury Quality Center & Jira Defect tracking systems.
• Helped to create Traceability Matrix to ensure comprehensive test coverage of requirements identifies all test conditions and test data needs.
• Attended several walkthrough meeting with Business analysts, Project Manager and Developers and provided feedback accordingly.

ENVIRONMENT: UNIX, LINUX, Oracle10g/11g, SQL Server 2005, SQL/ PL SQL, UML, HTML, ASP, .Net, HTML, Soap UI QC 9.5, QTP 9.5/10.0, Selenium, MS Word, Excel, PowerPoint, Outlook, MS Visio, MS Project

Confidential, TX

QA Analyst

Responsibilities:

• Identified and verified software requirements meeting with Business Analysts and ongoing participation in customer kickoff meetings and Development to QA “hand over” meetings
• Involved in creating and updating the Regression and End-to-End Test Plans.
• Gave an overview of Test Plans in Test Plan Review meetings to get them signed off.
• Interacted with Subject Matter Experts (SMEs) and Development teams to identify and refine test requirement.
• Validated web services using SOAP UI by testing XML request and response data with SOAP.
• Recorded and plays back test in Fire fox using Selenium IDE.
• Used Selenium tool (selenium IDE is a plug-in to Firefox) to record and playback tests and then export the recorded test in other language e.g. html, Java. The Exported test can be run in any browser and any platform using "Selenium Remote control.
• Performed Smoke/Functional/Integration/UAT/Ad-hoc and Manual Performance testing.
• Extensively involved in Regression and End-to-End testing of ESYNC Health Portal application.
• Tested data migration to ensure that integrity of data was not compromised.
• Involved in creating and executing test cases for Multi-Browser testing on various versions of IE, Firefox, Safari and Google Chrome using Add-ons like Firebug, Measure It and Developer Menu.
• Tested data migration to ensure that integrity of data was not compromised.
• Involved in testing the application in various environments such as Test, UAT and Stage environments.
• Worked on different database like Oracle to check the data consistency.
• Involved in the Production Validation for each Release Project and also took part in post-production support
• Involved in writing and executing SQL Queries in TOAD for Back-End testing.
• Involved in Server down time testing.
• Reporting, Tracking and reviewing defects using Quality Center and Test Director.
• Coordinating with Development and Business users to resolve any issues related to defects.

Environment: Quality Center 9.3/11.0, Java, J2EE, XML, Microsoft Office, TOAD, JIRA 5.0, Oracle 10g, SOAP UI, Pl/SQL, SQL Server 2010, VB .Net, ASP.Net 2.0, VB Script, HTML, XML

Confidential, Pittsburg, PA

QA Analyst

Responsibilities:

• Created complex queries to validate Basel2 reports out of Fact table and reporting tables.
• Debug the test as it is enhanced by ensuring the actual results correspond to the expected results
• Conducted Data Migration and Data Cleansing
• Tested and validated the Merger of National City bank and Confidential Basel2 results.
• Understood financial/Bank/Risk terminology which is very essential for Basel2 tester.
• Run regression tests on each new build based on application changes and identify bugs as soon as possible
• Validated all web based manual interfaces and their web screens includes source file landing etc…
• Validated Adjustments screens including the individual source Adjustments posting as well as top side adjustments posting.
• Verified Source file results along with Adjustments files and ensured reports are correct.
• Ran ab initio graphs from UNIX server and verified the outbound files as well as output file contents.
• Created scripts on the application under test’s functionality into modular test steps will allow for considerable reusability.
• Involved in the User Acceptance testing in testing the Congo's Reports and Screens.
• Involved in data validation by running SQL queries on the database tables.
• Created a daily regression test bed to ensure that all Cognos drillable reports in the Decision Center project to generate correctly after the daily load of multi-dimensional data.

Environment: UNIX AIX, Oracle 10g, JAVA, Ab initio 1.13, SQL, Quality center 8, Toad, Cognos.

Confidential, Lincolnshire, IL

QA Analyst

Responsibilities:

• Analyzed and reviewed Business Requirements Document (BRD) and System requirements.
• Involved in System Testing for the above application for Manual and Automated Testing.
• Involved in GUI, Functionality, Regression, Usability, Look and Feel testing of the above Web based application.
• Have experience working on Agile Environment
• Used Load Runner for Web Performance and Web Monitoring Testing.
• Created, Modified and debugged the Scripts.
• Created and Performed Data Driven Testing
• Executed the test scripts and compared the Actual and expected results
• Execute Test cases from Quality Center and raised defects for the failed test cases
• Maintained the Quality Center for backups, adding new Users, Projects and Domain.
• Involved in Handover meetings, Business Analysis and design reviews for each release.
• Coordinated in testing with UAT team - clarified requirements, shared test cases and provided test data.
• Tracked the defects by using Quality Center.
• Quality Center to design and formulate the test plan, test cases, test procedures based on the requirement documents.
• Conduct manual and automated testing to ensure deliverables as per client specifications and testing the application according to user requirement.
• Prepared the Test Approach document
• Identifying Critical test case on each release and updating Regression Suite.
• Conducted browser compatibility testing in various browsers like Internet Explorer, Mozilla Firefox, Safari, Netscape Navigator and Chrome

Environment: HTML, XHTML, DHTML, VB, .NET, ASP, IIS, Visual Studio,Java,J2EE,UNIX,Internet Explorer, Netscape, Quality center 9.0, QTP 9.2,Load Runner 8.0, SQL Server 2005, Oracle, forms, VB Script, Unix Shell scripting, Agile.