SUMMARY

• Around 6 years of extensive IT experience in various phases of IT projects such as testing, deployment and application support.
• Experienced in testing of Banking, Telecom and Academic clients.
• Expertise in Manual and Automated testing. Worked on large number of projects and systems over the years and built a solid knowledge across the board in Smoke, Functional, Regression, Database, Load, Stress, Data validation, Security, Integration, Web based, GUI testing and UAT.
• Experienced in all phases of Systems Development Life Cycle (SDLC)implementing Waterfall,V - Model,andAgile, Iteration, Scrum methodologies.
• Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices.
• Expertise in performing all test activities such as planning and control, choosing test conditions, designing test cases and checking results, evaluating exit criteria, reporting and test closure.
• Hands on experience in automation testing using QTP.
• Experience working with huge volumes of data, analyzing record sets for Data Quality, Data Validation and Metrics using SQL.
• Worked onWeb ServicesTesting usingSOAP UI 4.0/3.0, Apache Axis Client 2.x
• Testing experience in a Mainframe environment
• Strong experience in testing tools like Quality Center, Quick Test Pro, Load Runner, Performance center.
• Has good knowledge of web technologies likeWeb Services, SOAP,XML, HTML, .NET, JavaScript, VB Script, C, C#, and C++.
• Experience in testing and writing complex SQL, Confidential -SQL and PL/SQL statements.
• Strong in Analyzing Business spec Requirements & Develop comprehensive test Spec & execute them.
• Experience with integration testing of the applications using various sources like flat files, sybase and oracle databases.
• Experienced in writing and executing SQL queries to verifying Source-to-Target mapping and transformation rules (ETL Processing) in Data warehouse manually.
• Experience assessing testing processes, creating, implementing testing strategies and SQA strategies using Agile-testing methodology.
• Participated in defect meetings with developers to validate the severity of the defect. Manually retested the application for smoke testing and regression testing.
• Ability to interact with developers and product analysts regarding testing status and QA documentation
• Expertise in Problem solving and Tracking Bug Reports using Bug tracking Tools.
• Involved in jobs scheduling, monitoring and application support in a 24/7 environment.
• Excellent communication skills and Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.

TECHNICAL SKILLS

TESTING TOOLS: QTP 9.5/10, ALM HP QC 8.2/9.2/11, Performance center, SOAP UI 3.5/4.0, Test Director, Load Runner 9.5/11, TFS 2010

SCRIPTING: VBScript, Java Script, UNIX Shell Script

Operating Systems: Windows 95/98/NT/2000/Windows XP, UNIX, Sun Solaris, Red Hat Linux

DATABASE: Oracle 9i/10G, MS Access 2003, SQL Server 20052008, MYSQL 4, AS400

WEB SERVER: Tomcat, Apache, MS IIS 5.0/6.0, WebLogic 7.0

LANGUAGES: Java, C, C++, SQL, PL/SQL, VBA

LANGUAGE UTILITY: MS Office 2007, Eclipse, MS Visual Studio .Net

BUG TRACKING TOOLS: Test Director 8.0, Quality Center 8.0/ 9.2/ 11

PROFESSIONAL EXPERIENCE

Confidential, Addison, TX

Lead QA Analyst

Responsibilities:

• Reviewed and analyzed the Business Requirement Documents and Technical requirement documents.
• Participated in writing High level Test plans, Unit test plans, Test Scenarios, and Test Cases.
• Expertize in Developing and Evaluating Business Requirements and expertise in Researching, Identifying and Resolving Problems.
• Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution using QC
• Performed Functional, Regression, Data Integrity, System, Compatibility.
• Manually tested web applications
• Ran SQL queries naually for data validation
• Took initiative to explore Alternative Approaches to Projects tasks and Communicated clearly about the technical topics and interacted effectively with representatives and various Business Units.
• Involved in Developing, Resolving Problems with maintain and executing Test Plans and Test Scripts for all BAU Releases to large Independent & Integrated Releases.
• Extensively executed SQL queries in order to view successful transactions of data and for validating data in SQL Server Database.
• Performed Web Service testing using SOAP UI
• Used Selenium WebDriver and Selenium Grid for testing application in different browsers.
• Used firebug tool for finding Xpath of the Web Elements.
• Modified and Executed automated and manual test scripts for different modules using QTP.
• Involved in maintaining and uploading the QTP Scripts to Quality Center.
• Agile Management and Software Development.
• Strong testing Quality Assurance experience within Agile environment .Good understanding of Agile software development lifecycle (iterative and incremental)
• Extensively used TFS for creating stories.
• Involved in User Acceptance testing (UAT) exclusively in Agile environment.
• Used Mercury Quality Center to document issues found during the testing process, suggested appropriate solutions and prioritized defects for resolution in coordination with the development team.
• Lead the projects and organize meetings with different LOB, Technology, TDM and Project Manager.
• Perform UAT testing and prepare test scripts and worked on remediation of issues.
• Worked in understanding Interdependencies between components from small to medium and provided training and guidance to onsite and Offshore folks
• Extensively used Quality Centre for Defect Reporting and Defect Tracking.

Environment: QTP, Oracle, Soap UI, Putty, Selenium, Java, AS400, SQL Server 2008, QC 9.2/11, Windows XP, PL SQL, MS Office tools, Agile, Db Visualizer, TFS 2010.

Confidential, Atlanta, GA

Sr.QA Analyst

Responsibilities:

• Analyzed the Business requirement and Design documents to develop Test Plan.
• Wrote and executed test cases using Quality center for manual testing solutions.
• Executed system, integration, end-to-end, and user acceptance test (UAT) test cases.
• Reviewing test plans, results analysis, capacity planning guides for releases.
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Detailed repeatable end to end test cases for application, interviewed developers to gain detailed information on complex calculations and backend exception processing in order to validate the back end utilizing SQL Plus
• Created Manual Test Suites for various modules.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Experience in creating Users, changes in user roles and password changes
• Reported bugs and tracked defects using Quality Center
• Ran test status reports
• Performed the tests in both the SIT, QA and contingency/backup environments
• Performed testing extensively for integration and unit testing of standalone and distributed GUI-based applications.
• Involving in Functional testing, End to End testing and Regression Testing
• Involved in Web Services Testing using SOAP UI.
• Installed, configured SOAP UI to test web services using WSDL file given by Development team.
• Developed Weekly and Final Test Status reports with all the Test Metrics Such as Total Test Executed, Total Test Analyzed, Total Passed and Total Failed.
• Conducted SIT and UAT status calls and review meetings.

Environment: QTP, Oracle 9i/10g, XML, Flat Files, SQL,, MS Excel, UNIX, Windows, Quality Center 9.2 and Test Director 8.0, SOAP UI 3.0, Web Services

Confidential, Bingham Farms, MI

QA Analyst

Responsibilities:

• Analyzed functional requirement and conducted Walkthrough.
• Understanding requirements and technical specifications.
• Preparing and reviewing Test cases and Procedures to ensure coverage of and conformance of business requirement.
• Worked closely with business team to make sure all the changes made to requirements documents are implemented in the test plan and test cases
• Worked on BAT (Benefit analyzer tool) to remediate ICD9 codes to ICD10 and verify the Mapping for recommended tables before remediating.
• Worked parallel on creating claims, processing claims with both ICD9 and ICD10 codes.
• Mapping of ICD-10 codes to procedure and diagnostic codes.
• Identify scope systems that will be modified by the ICD-10 project to accommodate ICD-10 code and /or downstream impacts from ICD-10 codes.
• Extensively Worked in HBEK & HRBK to make necessary changes to Benefit Constructs for testing BAT (Benefit Analyzer tool) application recommendation phase.
• Worked in visualizing and documenting the artifacts such as Class diagrams, Use Cases diagrams, using MS-Visio.
• Worked on Confidential NPS to test the Test Claims in HIQK & HEHK.
• Utilized Quality Center for test plan, test execution, requirement gathering and defect reporting.
• Involved in performing UAT with stake holders and business owners.
• Involved in writing Data Mapping Documents for the system and involved in documenting the ETL process and writing SQL Queries for the retrieval of the data.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting data.
• Involved in Status Tracking, Risk Identification and Defect Prevention activities as part of the Project
• Preparing and reviewing Test Cases and procedures and to ensure coverage of and conformance of business requirement.
• Generating Automation Regression Test Script, maintenance and enhancement of scripts as per the application change request for every new release.
• Wrote Technical documentation and performed black box testing.
• Identified defects and escalated defects using Quality centre.
• Lead the team of 6 including onshore and offshore.

Environment: NPS,QC, MS VISIO, SharePoint,QTP, RUP, UML, XML, HTML, Microsoft SQL Server 2005, Manual And Automated Testing,Loadrunner, Sybase, ASP.NET 2.0.

Confidential, Atlanta, GA

QA Analyst

Responsibilities:

• Created Test Plan and developed an test strategy for Day 2
• Understanding the specifications for Data Warehouse ETL Processes and interacting with the data analysts and the end users for informational requirements.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
• Created several test scripts using QTP, which includes data-driven tests and batch tests
• Performed Record and play back method In QTP.
• Customized Automation Framework using Data driven framework, and Functional testing by writing VBScripts in keyword driven framework of QTP.
• Carried out System Integration Testing (SIT) where data flows between Legacy System via Internal Tibco application to 3rd party vendor application.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Monitored the successful running of the UNIX scripts/jobs to verify the loading of data from source into the target tables and reporting database and informed the same to the developers.
• Created trigger messages for BW Engine to activate Tibco jobs in batch processing.
• Performed end user testing before the Build is released for actual real time implementation.
• Summarize test results in formula test analysis reports according to the documentation standards.
• Worked on backend testing on Oracle and written SQL/PL SQL queries.
• Interacted with developers and various members of team to discuss and resolve defects and their priorities.
• Verified within each module, that the functions and procedures were executed without error and that all complied with the established business requirements specification.
• Assisted the Web Services Testing team to create the Test Case scenarios.
• Performed end-to-end and Regression testing.
• Reported bugs and tracked defects using Quality Center

Environment: Ab Initio, (GDE 1.14, Co>Op 2.14), EME, Data Profiler, TIBCO, QTP, Oracle 9i, ToaD, Weblogic,PL /SQL, Toad, MS Excel, UNIX, Windows, Quality Center 8.2, DB2

Web App SW tester

Confidential

Responsibilities:

• Performed Unit, Integration, functional, Load, performance, Regression testing.
• Involved in preparing Business test cases, test design, test Cases, and Strategies.
• Perform Functional, Regression, System, and Integration in batch mode across features.
• Performed End-to-End testing manually and was associated with User Acceptance Testing.
• Performed Black box testing for the Web based application
• Review the test cases and bug reports.
• Implemented and executed automated Test Scripts for Regression Testing using QTP.
• Created and executed SQL queries to fetch data from database server to validate and compare expected results with those actually obtained.

Environment: J2EE, JSP, PL/SQL, QC, Oracle 8.x, Mysql 4.2.0, QTP, Web Servers: Apache 1.3.3 and Tomcat 1.5.