SUMMARY

• Around 7+ years of experience in Software Testing, Quality Assurance of various business applications in Web based Client / Server environments and well versed in all stages of testing aimed at providing complete business solutions.
• 4+ years of experience in Relational Databases.
• Experience in Software Development Life Cycle (SDLC) aspects such as Requirements Analysis, Design, Development, Testing and Deployment.
• Experience in Information Technology with emphasis on Quality Assurance.
• Exceptional experience with Oracle, MS SQL Server.
• Extensive experience in Manual and Automated testing of web based and client - server applications
• Extensive experience in Quality Assurance Life Cycle (QALC) aspects such as developing Test Strategies, Test Plans, Test Cases (Manual / Automated), Defect Reports and developing Test Scripts, Traceability Matrices and Test Environments.
• Expert in using Mercury interactive testing tools like Quick Test Pro, Quality Center, Win Runner, Load Runner and Rational Tools.
• Experience in performing Functional, Regression, Integration, Security, Database, Smoke, Black Box, negative and positive testing Manually and with Automation Tools
• Experience of Web testing, Unit Testing, Integration Testing and Functional
• Backend Testing of Client/Server and Web based applications.
• Extensive experience in testing Web applications like Healthcare, Banking and Financial.
• Created automation regression scripts using QTP
• Hands on experience in TSL and VB Script programming for Development of scripts in QTP and managed the data in QC.
• Developed QTP scripts in Expert View Environment using Parameterization , Checkpoint , Regular Expression , Object Identification etc 
• Good knowledge in deployment of MS SQL Server Integration Services packages and My SQL Databases.
• Capable of designing multi table relational databases with proper enforcement of relational constraints.
• Designed and deployed basic SQL Server Reports with data pulling from My SQL database.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from My SQL databases.
• Extensively used SQL queries for back end Testing and while data are being transferred between the front end and the back end database server.
• Expertise in using the database development tool TOAD for Oracle to interact with the backend database.
• Experience in importing and exporting of requirements between Quality Center from Microsoft Word/ Microsoft Excel.
• Extensive experience in manual testing in varied environments and using automated testing tools like Win Runner, QTP, Load Runner and Test Director/Quality Center.
• Experience working in an agile programming environment. Represented the testing team in the daily Scrum and CCB's.
• Excellent understanding of QA Methodologies, Testing Procedures. Well versed with Web Testing
• Expertise in programming languages Java/J2EE, VB, C, C++, .NET, HTML, XML.
• Expertise in Problem solving and Bug Reports using Tracking Tools such as JIRA, Microsoft Raid.
• Experience in writing, maintaining and updating Test Documentation for various stages of testing for reference and Auditing purposes.
• Ability to collaborate with peers in both business and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Impressive ability to understand business requirements, meet deadlines, work in groups, interact with developers and team leads.
• Highly motivated, organized and results oriented with excellent communication and presentation skills with capability of adapting to new and fast changing technologies

TECHNICAL SKILLS:

Testing Tools: Quick Test Professional, WinRunner, TestDirector, Quality Center, LoadRunner, Rational Clear Quest, Rational Test Manager

Web technologies : HTML, DHTML, XML, JSP, ASP, Servlets

Web Server: IIS 4.0/5.0, NES, Apache, Java Web Server

Programming Languages: Java, C++, C

Databases : MySQL, MS SQL Server.

Tools : SSIS (ETL Tool), SSRS (Reports Tool).

Markup languages : HTML, XHTML, XML

Scripting Languages : VBScript and TSL

Databases : Oracle, SQL Server 2000/2005/2008 /2012 and MS Access

O/S : MS-DOS, Windows NT / 95 / 98 / 2000 / 2003 / XP, RedHat Linux, Unix

Hardware : IBM Compatible PCs, Pentium PCs, Intel based machines, Terminal Emulators.

Packages : MS Word, MS Excel and MS PowerPoint

GUI : Visual Basic, Developer/2000

PROFESSIONAL EXPERIENCE:

QA Tester

Responsibilities:

• Analyzed the Test plan and responsible to enhance in the areas of Automation approach, Test Methodology, quality considerations and Metrics.
• Analyzed business requirements, functional specifications, UML documents and dataflow diagrams and developed Test Requirements.
• Execution of Automation test cases using QTP 10
• Wrote detailed test cases analyzing use case artifacts, UI specs and supplemental specs and involved in shakeout testing of the environment.
• Outlined and developed Testing Strategies, and develop Test Scenarios and Test Cases
• Worked on .NET applications like ReviewWeb, Global Termination Application, Manager Feedback application.
• Performed Data Conversion testing during different projects.
• Performed Risk- Based Analysis in writing and executing test cases in various projects.
• Worked on NTBatch Interfaces.
• Involved in Migration of NTBatch to Control-M Scheduling tool.
• Worked on Control-M Scheduling tool
• Troubleshoot production issues and suggested resolutions for Perl Script processes.
• Given resolutions for the outstanding problems during the development
• Troubleshoot the production issues and proposed solutions for development.
• Leading the offshore team.
• Extensive SQLs were written using third party tools like Query manger (SQL Server), SQL Server Management Studio in order to validate the results generated. Several reports (SQRs, Crystal) were run as part of testing and data validation.
• Tested the application for defects in GUI, functionality for every construction cycle.
• Involved in End user training and support at the end of every test cycle.
• During SQL Server 2005/2008 Upgrade did the Functional Regression and Performance testing for different processes.
• Involved in Setting up the environments for QA and UAT
• Involved in System Admin activities like refreshes, deployments, user requests.
• Performed Risk Based Testing for different Projects and Tasks to deliver the quality product. Tested several negative scenarios to deliver the Quality Product.
• Used Microsoft SharePoint and RAID as a repository to store Test documents.
• Performed Build Verification Test by running SQL queries to check if the data is migrated without any discrepancies from legacy systems to the new systems. Identified data by creating appropriate SQL Queries in Test Snapshot. Conditioned data whenever needed.
• Developed UNIX Shell Scripts/SQL queries to run automated scripts for back-end testing.
• Performed Regression testing of the application after the fixes.
• Tracked Defects using Quality Centre, RAID, JIRA and interacted with developers to fix the defects of the application.
• Involved in migration of Quality Centre to RAID, RAID to JIRA.
• Coordinated with UAT team for the testing and provided support whenever needed.
• Used Collaborative method whenever needed during the crunch Timelines to deliver the Quality Product.

Environment: Windows Server 2000/2003/2008 Win XP/7, SQL Server 2000/2005/2008 , RAID, Quality Centre, JIRA, QTP 10, Visual Source Safe, Perforce, Perl Script, Control-M Interface, NTBatch Interface, MS Visual Studio 10

QA Tester

Responsibilities:

• Reviewed and Analyzed System Requirement Specs (SRS), high level scenarios (HLS), use cases, detailed level requirements and design documents.
• Worked with users, systems analysts, designers and programmers to create/analyze various required project/test documents.
• Responsible for Integration Testing, Performance Testing etc.
• Automated Functional testing using QTP.
• Recorded automated scripts using Quick test Pro to perform the functional testing of the application
• Major responsibilities included writing Test plans, creating Test scripts, team co-ordination and technical writing / Documentation during Manual Testing
• Good Understanding of Object Repositories. Used Shared object repository. Applied Regular Expressions on object properties to decrease object duplication in the repository.
• Analyzed test cases for Reusable Actions, insert them in driver scripts to increase modularity in test process.
• Designed and developed automation scripts to Data Drive using Excel sheets and Oracle database.
• Used data table object and its corresponding methods and properties (Data warehousing) application testing using SQL queries.
• Generated SQL queries to validate various reports, loads and extract process from My SQL database.
• Developed SQL queries to validate conversion requirements and the format of legacy data from My SQL database.
• Used Quality Center for Defect Management and to analyze the variation between the expected and actual results.
• Maintained the Defects Tracking in QC and to analyze the variation between the expected and actual results.
• Modifying and creating SQL queries and stored procedures for quality assurance and analysis.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by ETL tool.
• Created data extracts as part of data analysis and exchanged with internal staff.
• Analyzed business requirements from Black Box testing perspective, business process and system architecture/design.
• Used Load Runner for the performance testing
• Prepared Test Data for system testing as per the specifications
• Involved in creating users and setting up user groups and assigning privileges to user groups in Test Director which includes specifying transition rules and data hiding.
• Written data driven test to handle the scenario requiring multiple sets of data using data table parameters in Quickest Pro, also developed the baseline scripts
• Used the Exception Editor in Quickest Pro to handle unexpected events and errors that occurred during test run
• Created VBScript library files containing User Defined Functions and utilized these functions in various test scripts using Quicktest Pro
• Performed the Back-End testing to ensure data consistency on front-end by writing and executing SQL queries on the database
• Executed UNIX shell scripting for batch mode testing
• Coordinated with users for User Acceptance test in production environment.

Environment: Test Director, QTP, Load Runner, MySQL, SQL Server, .Net, ASP, Servlets, Microsoft SQL Server, CSS, VSS, XML, SQL, MS-Office, Doors, Windows XP and UNIX.

QA Tester

Responsibilities:

• Responsible for designing, developing test plans use cases and executing test scripts.
• Performed Unit, Integration, Smoke, functional, Regression, and system testing.
• Interacted with Business users and Technical team in providing clear solutions to requirements.
• Used Quality Center for preparing the test plans and manual test scripts.
• Reported defects using Quality Center.
• Involved in loading the flat files into Oracle Database and involved in writing Complex SQL Queries.
• Involved in writing Complex SQL Queries using TOAD to validate the loads & Extracts.
• Experienced in web based as well as My SQL client server projects with responsibilities including analysis, design, development, implementation and maintenance.
• Designed SSIS Packages using ETL tools to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by ETL tool.
• Analyzed the data from My SQL database and designed reports for end users.
• Processed claims in Facets & QNXT and verified 835X12’s are generated and sent to Provider.
• Processed 837P, 837I & 837D transactions, verified those 837 transactions converted correctly to XML file format & XC keyword file format and verified the claims data loaded to Facets & QNXT for further processing.
• Enrolled members through online screens and 834 transactions to Facets & QNXT.
• Tested the portal application to make sure the claims, members are loading to Facets & QNXT and Providers can check the member eligibility and claim status.
• Involved in testing the Pharmacy Claims.
• Involved in testing the Medical Claims & Dental Claims in QNXT.
• Involved in creating rules (e.g.: copay, deductible, quantity limits) for Pharmacy Claims testing.
• Processed NCPDP transactions to make sure Pharmacy claims routed to Facets.
• Followed the HIPAA implementation guides for preparing the EDI files.
• Used Desktop Validation tool to check the EDI files for HIPAA errors.
• Executed commands in Unix to view the files and FTP the files to Unix server for processing.
• Assisted in the development and maintenance of Testing Procedures and adhere to all business processes. 
• Ability to work from functional specifications to write test plans.
• Managed test plan and schedule
• Automated Claims & Members screens in Facets & QNXT using QTP.
• Designed, Developed Test automation Strategy for Quick Test Pro.
• Performed backend testing using SQL queries and verified data integrity
• Interacted with developers & various members of team to discuss and resolve defects and their priorities.
• Performed backend testing using SQL queries and verified data integrity
• Assisted the management in Web optimization to enhance customer experience

Environment: Java, Java Script, Oracle 11i, Facets, QNXT, MySQL, SQL Server, UNIX, COBOL II, DB2, CICS, TSO/ISPF, JCL, Windows/NT/2000, Quality Center, QTP and TOAD