SUMMARY:

• 7+ years of total IT experience and very good knowledge QA of Software Applications and Testing.
• Extensive experience in testing of data warehouse / data marts for business applications with Banking, Financial, Brokerage, Insurance, Pharmaceuticals, Manufacturing.
• Experience in all phases of Software Development life cycle such as Agile, Scrum, Waterfall, RUP
• Experience working closely with Test Data Management (TDM) team for data scrubbing. exists in source tables.
• Experience working in using Databases like Oracle, Teradata, SQL Server, DB2, MS Access and DB2. Expertise in Database Programming (Stored Procedures, Triggers, Packages, PL/SQL) using Oracle.
• Experience in UNIT Testing, Integration Testing, System Testing Functionality, Regression, Performance Testing and User Acceptance Testing.
• Strong knowledge in DBMS, RDBMS databases like SQL Server 2008, Oracle, Toad
• Extensive experience in using HP Quality Center for Defect Tracking purpose, QTP, Load Runner and Performance Center.
• Experience in testing the web services using SOAP UI and Experience working in agile development environments.
• Experience in UNIT Testing, Integration Testing, System Testing Functionality, Regression, Performance Testing and User Acceptance Testing.
• Strong knowledge in DBMS, RDBMS databases like SQL Server 2008, Oracle, Toad
• Solid experience of AGILE, Scrum processes, Waterfall & V Methodologies of SDLC.
• Experience in Bug Tracking and reporting using HP ALM, JIRA, Test Director and Clear Quest.
• Expertise in Selenium automation using Selenium Web Driver, Selenium Grid, JAVA & Maven.
• Designed and implemented different automation frameworks like Keyword Driven framework, Data Driven framework and Hybrid framework for a number of projects.
• Experienced in Test data Mock up for different file formats like XML, X12.
• Expertise in EDI File 4010 to 5010 remediation testing.
• Expertise in writing Selenium Web Driver automation scripts in JAVA for different domains/websites and executed automation scripts on different browsers/environments.
• Exposure of Web Services Testing using Service Oriented Architecture tools Postman, REST and SOAP UI - Groovy Scripting.
• Good Knowledge on all the Health Care EDI transactions.
• Hands experience in performing backend testing on Oracle, SQL Server and MYSQL databases.
• Experience in creating Test Plan, Test Scenarios, Test Cases and Test Status Reports.
• Good analytical, presentation and communication skills.
• Ability to adapt to changes and willingness to take on challenges
• Good communication skills and versatile team player providing valuable inputs.
• Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time.

TECHNICAL SKILLS:

Testing Area: System Requirement Analysis, GUI, functional, Integration, System, Stress/Load Test Using white box, Block box techniques and Manual Test

Operating Systems: Windows NT/2000/2003/XP Professional /Vista.

Test Management tools: Rally, HP Quality Center, Rational Test Manager

Testing tools: Test Complete, Selenium, Rational Robot, Mercury QTP, Win Runner, Load Runner, Test Center, Performance Center, ReQtest, QA Wizard Pro

Defect tracking tools: Rally, Rational Clear Quest, Quality Center

Domain Knowledge: Banking, Health Care, E-commerce, Telecom, Retail

Languages: C, C++, VB, TSL, SQL, PL/SQL.

Scripting Languages: VBScript, JavaScript, SQA Basic

Programming: HTML, DHTML, XML, CSS

Databases: Oracle, SQL Server 2005/2008, DB2, MySQL

PROFESSIONAL EXPERIENCE:

Sr. QA Tester/ Analyst

Confidential, Atlanta, GA

Responsibilities:  

• Analyse the HLD's and LLD's and prepare the comprehensive Test Plans, Test Cases and Test Scripts. 
• Document proposed practices and testing improvements. 
• Created Functional Test scenarios based on the specifications manually. 
• Created Test Cases / Scripts based on the Test Scenarios identified. 
• Involved in Systems Testing / Functional Testing of the application. 
• Involved in the Onsite / Offshore model. 
• Converted Manual Integration tests into automated tests. Used QTP extensively for the purpose of GUI and Functionality testing. 
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
• Executed test scripts, co-ordinate and conducted System and UAT testing. 
• Created, developed and executed test cases and test scripts manually and using automation tools. 
• Wrote VB Scripts to do automate testing using QTP. 
• Worked on Test Data Management (TDM) tools and supported automation frameworks and solutions for test data governance.
• Assisted quality assurance implementation in all the phases of SDLC.
• Used Microsoft Excel and Access to test small amount of data imported from different database management systems like SQL Server, DB2.
• Involved in defect tracking and task management using JIRA for testing and product deliverable
• Participated and be an active contributor in daily scrum meetings, requirements/story review meetings, and design reviews and preparing release notes for each sprint.
• Performed Back end testing by writing SQL statements like Join, Inner Joins, and Outer joins and Self Joins used TOAD and SQL Developer.
• Working as a Project Administrator HP ALM/Quality Center to organize and manage all phases of the software testing process, including planning tests, executing tests, and tracking defects.
• Done SOA testing for Payments API's using SOAP UI and Java framework for web services testing.
• Performed the testing of Restful web services for verification of customer details using SOAP UI.
• Extensive involvement with the Quality Assurance team for building exhaustive set of test cases.
• Conducted System Testing and User Acceptance Testing for every client and Conducted Backend testing writing extensive SQL queries.
• Sending highlight to Test Manager and the Scrum master about issues that can or impacting the test phase.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Performed for Cross browser testing on different operating systems to verify the compatibility of the application on operating systems like windows 2000, Windows 2003, XP, Vista, Mac to support different Web Browsers like Internet Explorer, Firefox, Chrome.
• Monitoring and tracking code migration, coordinating & managing 'Issues' & 'Escalations ‘in all environments (i.e. Integration, Sys. Test, UAT, Performance/Tech. Test, Training & Staging environments) & final migration into Production Environment.
• Analysed the business requirements, developed test plans and created test cases in Quality Centre, a test management tool.
• Validated cube and query data from the reporting system back to the source system. 
• Tested analytical reports using Cognos Analysis Studio 

Environment: Java, Jenkins, SOAP UI, Cognos,, Teradata 13.0,SQL Server, UAT, Oracle 11g, HP, Agile, Web Application, QTP, SQL, PL/SQL,TFS, UNIX, ALM/HP Quality Center 11, TOAD, SQL Navigator, Windows XP Professional, MS Excel, XML, XSD, XSLT, XML Spy, Unix Shell Scripting

Senior Quality Analyst

Confidential, Bellingham, WA

Responsibilities:

• Requirements Analysis of the requirements and preparation Test plan and Test Specs.
• Tested type 1 and type 2 mappings to populate reference tables and dimension tables.
• Preparation of detailed test plan & performed Integration, Regression, Retesting of the work product before release.
• Created and revised tests for large   ecommerce client's mobile device applications 
• Performed manual cross browser testing on VMWare environments to simulate various OS/browser combinations. 
• Tested several reports developed using Business Objects.
• Tested the calls to web services to make sure correct data is sent to back end via web developer tools (Firebug, Chrome Developer Tool) 
• Managed formal SIT /UAT   testing   and E2E   testing   in ALM based on the approved requirements per each system release.  
• Proficient in validating the transformation and edits on claims as required by the   CMS. 
• Wrote java script for client-side scripting and cross-browser compatibility
• Assisted in proof-of-concept reviews and stress testing for applications owned and supported by our application support team. 
• Involved in transition from Iterative model to Agile model and lead the QA team to complete each sprint successfully. 
• Tested SQL queries, PL/SQL scripts to validate the data and performance of the database.
• Supported Performance Testing as part of Performance Tuning.
• Good Exposure in Test Automation in   QTP , ALM 
• Ecommerce testing for making purchases online 
• Verifying the reports existence based on requirements.
• Tested and validated the cube data, ensuring that the data is correct by comparing the data results to comparable source system reports or by querying individual transactions and forms.
• Responsible for testing Business Reports developed by Business Objects.
• Wrote and edited test cases in Test Rail web-based test management system 
• Responsible for managing requirements, test case execution and logging defects in HP ALM tool. 
• Experience working with Report designer, Report Manager, Report Server. Result is exported to Excel or pdf.
• Led testing of MS reporting services to accommodate Agile development.
• Involved in gathering and documenting the requirements that were critical to the business process.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XIR3.
• Involved in all testing phases: Unit Testing, System Testing, Acceptance Testing, Performance Testing, Regression Testing, Integration Testing, and Quality Assurance Testing.
• Used SQL functions, operators and expressions for validation of Data between source and target.

Environment: Quality Center, Ecommerce, Agile, Business Objects XIR3, Web application, CMS, JAVA, Oracle 9.1, DB2, Bugzilla, UNIX, ALM, Stored Procedures, Test Cases, Test Scripts, Test Plan, XML, XSLT, XML Spy, Toad, Mainframes

QA Analyst/ Data Analyst

Confidential, Eden Prairie, MN

Responsibilities:  

• Design and execute the test cases on the application as per company standards and tracked the defects using HP ALM/Quality Center.
• Worked on HIPAA Transactions and Code Sets Standards according to the test scenarios such as 270/271, 276/277, 837/834/835/837 transactions.
• Performed black-box testing of the Healthcare application ( FACETS ) and identified the different test cases for regression testing. 
• Worked on testing the Migration files, Claim Submissions to different Payers as per their specified edits. Also, Different types of Claim Submissions are handled: Web Services, FTP/SFTP
• Analyzed HIPAA EDI transactions in XML and X12 responses and of 270 and 276 and looked for defects for amendment. 
• Created mock data for testing various scenarios for the applications
• Test Data Mock for 834,837 EDI Files
• Written several complex SQL queries for validating Cognos Reports.
• Retest & Regression test
• Writing Complex Queries in SQL Server, Oracle and MY SQL to test the data used by the web apps.
• Used SoapUI for testing web services and API. Wrote test cases to automate the process and run validations on the API daily.
• Involved in all testing phases: System Testing, Acceptance Testing, Regression Testing, and Integration Testing.
• Extensive use of defect tracking tools, such as Jira ALM, Quality Center, Test Director, VSS tracker, Clear Quest and Test Track Pro. 
• Good Exposure in Test Automation in   QTP , ALM 
• Authored and Executed Test Cases for the Operational Data Store (ODS) and Enterprise Data Warehouse (EDW) in both   Facets   4.31 and Legacy Systems. 
• Used Quality Center to state requirements, test plan, test cases, update test run status for each iteration and to report the defects.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
• Involved in testing the Cognos reports by writing complex SQL queries.
• Provided the knowledge transfer to the new members to the team.
• Prepared the Project Status Report and Provided Walkthrough to the Client.

Environment: Cognos, EDI,SQL Server, Facets, Oracle 11g, SQL, PL/SQL, UNIX, ALM/HP Quality Center 11, TOAD, SQL Navigator, Windows XP Professional, MS Excel, XML, XSD, XSLT, XML Spy, Unix Shell Scripting

Quality Analyst

Confidential, Bellevue, WA

Responsibilities: 

• Derived Testable requirements by analyzing Business and Functional documents for various features of the site. 
• Created test specification and test plans by reviewing business and technical documentation. 
• Modification of existing Test Plans and Test Scripts for Android testing. 
• Developed detailed Test Cases based on the Functional Requirements and design documents. Executed the test cases and analyzed the test results.
• Involved in analysis of users business requirements and helped in creating user stories.
• Test multiple mobile (iOS and Android) Applications for company clients.
• Participated in daily scrum as part of agile process and provided project updates.
• Identified the test data to execute the test cases.
• Manual Testing/mobile application testing, Symbian, Blackberry, Android   Mobile applications.
• Involved as a Functional Testing Analyst for establishing the Individual Benchmarks and Baselines for Java Applications.
• Involved in co-ordination and implementation of Quality Assurance procedures.
• Performed Functionality, Regression Testing of the application using Quick Test Professional (QTP).
• Test multiple mobile (iOS and Android) Applications for company clients.
• Performed Stress Testing on database resources using Load Runner.
• Conduct performance testing and coordinate monitoring as joined activity - DBA and application developers monitoring the server health.
• Analyze test results and prepare detailed Performance Test Reports including the recommendations.
• Coordinated with different teams and involved in for End to End testing.

ENVIRONMENT: Cognos, Teradata, SQL Server ,UAT, Oracle, CRM, Mobile Applications, HP, Agile, Web Application, QTP, SQL, PL/SQL,TFS, Android IOS, UNIX, ALM/HP Quality Center 11, TOAD, SQL Navigator, Windows XP Professional, MS Excel , XML, XSD, XSLT, XML Spy , Unix Shell Scripting.

Test Analyst

Confidential, Clever Land, OH

Responsibilities:

• Tested functionality and performance of Web Services.
• Worked in a highly dynamic AGILE environment and participated in scrum and sprint meetings
• Developed test tools and frameworks for automation.
• Defined test cases from technical specifications and Stories.
• Created and maintained test cases and test scripts.
• Developing and executing automation test scripts using Selenium Web Driver.
• Verified compatibility on different browsers like IE 8/9/10, Chrome and Firefox.
• Updating automated test scripts for the change requests and enhancements in the modules.

Environment: Windows XP, Java, MySQL, Oracle, Selenium Web Driver, Clear Quest, Version One