SUMMARY:

• Test Plans, Test cases and Test Strategies for both Automated and Manual Testing, Excellent professional skills by working independently, as a team member for testing of E - commerce, ERP, Financial, Telecommunications, Client/Server, Mainframe and Web based applications.
• Expertise in working with HP Test Suite (Quick Test Professional (QTP),Win Runner,Quality Center, Test Director), Back End testing (Database Testing) using TOAD, SQL-Developer by using SQL. Expertise in Custom function development by using VB Script and Automation Frame work design and development.
• Hands-on experience in diversified fields of theSoftware Development Life Cycle (SDLC), specializing in Quality Assurance Process and Methodologies like Water Fall, V-Model, Agile and Scrum.
• Expertise in requirement analysis to prepare Test Scenarios and Test Plan.
• Expertise in Development of test cases, Scenarios and strategies for automation.
• Proficient in analyzing the SRS (Software Requirement Specifications), Functional Design Documents and AUC (Application Use Cases) to formulate Test Plans, Test Strategies and Test Cases for Manual as well as Automated Testing for various applications to ensure proper business compliance.
• Extensive experience in developing Automation Frame Work. Interact with the development team, Test Planning, Monitoring Test Progress, Reporting the Business & Testing requirements and Test Metrics.
• Extensive experience in Black Box Testing with manual and automation using tools like Quick Test Professional and QualityCenter.
• Expertise in automating the Database testing using ODBC connections inQTP.
• Experience in testing of Client/Server & Web-based applications on windows and UNIX platforms.
• Expertise in designing Automation Architecture (Framework) by using Data Driven and Keyword driven techniques for the Automation.
• Expertise in Defect Tracking, Report generation and requirement tracking throughout the test life cycle using QC, TFS and Bugzilla.
• Expertise In developing external custom functions using VBScript forQTP.
• Expertise and experience in performing different kinds of testing like Functional Testing, GUI Testing, Backend Testing, Regression Testing, Cross Plat form and Cross browser Testing.
• Expertise in Descriptive Programming for developingQTPScripts.
• Expertise in writing and testing Queries, Views, Triggers, and Stored Procedures in Oracle and SQL Server.
• Expertise in testing of application in JAVA, J2EE, VB and .NET architectures.
• Expertise in UNIX commands and wexecuting them on different LINUX Flavors.
• Experienced in working with business analysts, development groups in analyzing business specifications and in Working with other testers to resolve technical and end-user issues.

TECHNICAL SKILLS:

Testing Tools: QTP, TFS,Clear Quest,Quality Center,Win Runner, SOAP UI,ALM

Programming Languages: C, C++, C#, Cobol, VB.NET, ASP.NET, VB Script, XML, XSLT.

Operating Systems: Windows NT 4.0/XP/2000/98, UNIX, Linux ES 5/4, OS/390

Mainframes: CICS, TSO, SPUFI, MVS, IMS, JCL, VSAM.

RDBMS: Oracle 10G/9i, 8i, SQL Server2000/ 2005, DB2, MS Access 2000.

Web/Application Servers: Web Logic, Web Sphere, IIS6, VMware Virtual Machine, Windows Server 2003 R2,WSSO,Microsoft .NET 3.5 SP1

GUI: Crystal Reports 8.0/8.5/11.0., OBIEE 10g AND 11g, Business Objects, Cognos

Enterprise Applications: Active Directory, LDAP, Citrix.

Designing Tool: Microsoft Project Plan, MS Visio.

Data Warehousing: Informatics, Power center, IBM Datastage, Ab-Initio

App Server: Tomcat6, Web Sphere 5, Web logic 9

Scripting Languages: TSL, Perl 6, ASP, JavaScript, VBScript, UNIX Shell Script

Networking: TCP/IP, SOAP, HTTP, HTTPS, FTP, SSL

Version Control: PVCS Tracker 6.8,Clear Case.

Amdocs Applications: Amdocs-Billing, Enabler, Clarify, Ensemble, CSM, API, AMSS, AAM, SC

PROFESSIONAL EXPERIENCE:

Confidential, Kennesaw GA

Sr.QA Analyst

Responsibilities:

• Utilized Agile and Scrum methodology to test the project.
• Studied Requirement analysis and Gap analysis of Business System Design.
• Created detailed test plan, test strategy and test cases based on functional specification, flow diagrams and use case documents.
• Documented Test cases and Scripts referencing the business rules in HP ALM.
• Performed Functionality, Integration, Regression, System and End to End testing.
• Tested the Epic Modules - Ambulatory Epic Care, Prelude/ADT registration, Billing, Emergency (ASAP),Inpatient, Pharmacy/Willow and Cadence(Scheduling
• Validated the discreet data in EPIC my chart and created test EMR data.
• Involved in validating the patient records and health information data in EPIC interfaces.
• Reported the issues inALMwith proper priority and severity to the concerned developer.
• Involved in writing automation test scripts for regression testing using HP QTP.
• Created object repositories inQTPto store the objects in the application.
• Created and executed the SQL queriesto fetch data from the databases and Involved in database validation- check the updated data inthe database.
• Attended the bug triage meetings to discuss the issues with development team and BA's.
• Updated and maintained the test scripts as per change in requirements.
• Setup the data for UAT environment.

Environment: Epic Hyperspace, HPALM, HPQTP, Oracle, HTML, Java EE 5, Windows 7,Jira.

Confidential, Charlotte, NC

Sr. Quality Assurance / ETL Analyst

Responsibilities:

• As a part of Agile Team works closely with Developers and UI Designers. Participates in the daily scrum meeting for updates.
• Involved in all the stages of SDLC, starting from the requirement analysis to the post production regression testing.
• Assisted the Business Analyst in writing the requirements for the application as I was involved on the UAT testing.
• Developed Test Plan, Test Strategies, Test Case and Test Scripts with very little formal requirement document. This was possible only after knowing the application in-depth.
• Created my own test data by developing and executing the SQL queries keeping in mind the different kind of investors.
• Executed SQL queries for the data validation of the data transformation from one record keeping system to another and back end testing was done.
• UsedQuality Center11.0 in which we had all the requirements, test cases and the defect-tracking module.
• Created Test Scenario matrix to analyze a requirement and test case boundaries.
• Created Requirement Traceability Matrix (RTM) inQuality Center, Which helps QA team to identify uncovered requirements and better plan testing.
• Involved in Unit, Functional, System, Integration and Regression testing.
• As a Team Created the Quick Test Professional (QTP) architecture which uses Shared object repository, Reusable Actions and Global Function library.
• Verified & validated data Integrity by ETL to and from OLTP Databases, Flat Files, Enterprise Data Warehouses and Data Marts.
• Tested the Extract processes using PL/SQL to extract from Staging area and then load to Star Schema data mart using PL/SQL packages
• Worked with Data Warehouse / ETL team to report defects in build phase and staging areas.
• Performed analysis on existing Modular Driven Automation Framework, Documented the Advantages & Disadvantages, Suggested the Changes to the framework.
• CreatedQTPShared object repository to maintain& update all the objects in the work flow.
• DevelopedQTPscript Templates such as Dynamic Data Validation, Logon Scripts.
• Initiated the process for Creating test cases inquality centerusing reusable modules
• Involved in analyzing functional requirements documents for multiple projects.
• Attended daily meetings, status meetings and defect tracking meetings

Environment: Quality Center, Quick Test Professional (QTP), AQT, Netezza, ETL, Data warehousing, UNIX Sun Solaris, Java, ASP, XML Web Services

Confidential, Wellesley, MA

Sr. Quality Analyst

Responsibilities:

• Developed unit test cases, configured environments and prepared test data for testing.
• Wrote PL/SQL /Complex SQL queries for system testing.
• Performed data quality test to determine whether processed data is correctly extracted, transformed and loaded.
• Worked with various EDI transactions like 834,835,837,276,277 in accordance with HIPPA standards
• Created public folders, private folders, personalized pages and custom views on the Cognos connection portal.
• Worked with Business analysis team to prepare a detailed Business Requirement documents.
• Involved in writing & implementation of the test plan, various test cases & test scripts.
• Performed Functionality, Stress, Security, GUI & Regression testing of web-based applications.
• As QA Tester, performing responsibilities with both the functionality and back end testing.
• Wrote SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Worked with Production environment to resolve several data issues.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
• Validate the ETL code that the data pulling from the source (IMS Auto) and data movement from pre-staging to pre-landing/pre-landing to landing is complete and accurate.
• Validated the complex issues of Policies using Green Screens (IMS) Mainframe Systems
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
• Tested several reports and automated using Quick Test Pro.
• Written several Stored Procedures and modified existing stored procedures.
• Involved with extraction routines to verify all the required data loaded into target systems.
• Extensively executed SQL queries in order to view successful transactions of data and for validating data.
• Extensively used Informatica tool to extract, transform and load the data from Oracle to DB2.
• Was involved in analyzing scope of testing the application. Test Strategy was created to test the all modules of the Data Warehouse.
• Created the test data for interpreting positive/negative results during functional testing.
• Involved in the whole testing life cycle covering the entire project from initiation to completion
• Clearly communicated and documented test results and defect resolution during all phases of testing.
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates and integrity.
• Used SQL queries and custom programs to perform data validation.

Environment: SQL Server 2008, HTML, MS Excel, .Net, HPQuality Center, Quick Test Professional (QTP11.0), VBscript

Confidential, Newark, NJ

Sr. Quality Assurance Tester

Responsibilities:

• Analyzed user requirement document and developed test plan, which includes Test Objectives, Test Strategies, Test Environment, Test Priorities, Test Cases etc.
• Involved in Complete Software Development Life cycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Participated in conducting Manual and automated Tests withQTP
• OptimizedQTPscripts for Regression testing of various applications
• Performed Data Driven testing usingQTPto test the application with different sets of data for positive and negative test cases.
• UsedQuality Centerto load test cases, test plans and executed test cases.
• Performed GUI and functionality testing of the web application on Windows and UNIX.
• Executed SQL queries to do the Data Base Testing.
• Involved in writing SQL queries to find the test data in existing systems.
• Performed back end database testing by using SQL queries for inserting, retrieving & updating data.
• Participated in Project meetings attended Inspection and Review meetings and initiated conference calls to discuss issues originated while testing.
• Provided on call support. Executed the Test Cases manually and reported the defects to Developers.
• Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Extensively used Ab Initio for extraction, transformation and loading process.
• Observed the Extract, Transform, Load process with Ab Initio and tested the data load process using the Ab Initio ETL tool
• Tested and worked on creating open document reports for business.
• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select for testing Business Reports with various boundary conditions.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Tested the ETL Ab Initio graphs and other ETL Processes (Data Warehouse Testing)
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Validated format of the reports and feeds.
• Effectively communicate testing activities and findings in oral and written formats.
• Worked with ETL group for understanding Ab Initio graphs for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables

Environment: Quick Test Professional,Quality Center, SQL Server, MS Excel, MS Access, Windows, UNIX.

Confidential, Atlanta, GA.

Quality Assurance Tester

Responsibilities:

• Analyze the requirements and prepare the Test specifications including test plan from requirements and test scenario development from use cases.
• Created Test Plan, Test Cases and responsible for execution Test cases.
• Developed several SQL queries to perform backend testing. Conducted database testing, passing SQL queries to the Oracle database.
• Participated in Design and Implementation of Automation Framework.
• Created test coverage analysis Reports using Test Director for User Acceptance Testing.
• Defect Tracking, Reports, Analysis and Test Batch maintenance in Test Director.
• Developed test cases, test scripts manually and also using automated tool Quick Test Professional.
• Developed User Defined Function for the Reusable Usage and maintaining the Libraries inQTP.
• Performed GUI interface testing at client side.
• Prepared the test data for positive and negative testing used in data driven testing.
• Parameterize the scripts, handle errors and create checkpoints (GUI, text, bitmap) using Quick Test Professional.
• Quality Assurance testing of Client/Server and WEB based applications.
• Manage the testing process, schedule batch tests, log and track defects using Test Director.

Environment: Test Director, Quick Test Professional, Win 2000, UNIX, JAVA, J2EE,Websphere, XML, ORACLE, TOAD, UML, SQL, SAP/ HR, TCM/Siebel.

Confidential

Quality Assurance Consultant

Responsibilities:

• Analyzing Requirements and Functional specifications.
• Verified that the requirements were testable, designed the test approach and ensured clear definition of roles and responsibilities.
• Involved in the development of the Test plan - Approach, scope, resource assignments & schedules and Testing Strategy.
• Prepared the Effort estimation for the project.
• Given the KT sessions on requirements and application to the team.
• Responsible for preparation of test scenarios and test cases.
• Prepared the test execution plan and tracking the execution
• Collected the metrics and analyse the applications status
• Created & Executed Test Procedures manually before using the automated testing toolWinRunner.
• Worked onWinRunnerfor Regression, Integration, and system Testing.
• Developed and maintained automated testing scripts withWinRunner.
• Enhanced scripts by adding the GUI, text checkpoints.
• Participated in automated scripts code Walkthroughs and QA Reviews.
• Used Parameterization for testing the application with a set of data.
• Identified, Documented, and Tracked software defects using Test Director and discussed it with the development team to solve the defect.
• Worked as software configuration coordinator to manage the Testing documents and updates

Environment: Test Director,WinRunner, ASP, JSP, Java, J2EE, JavaScript, WebSphere, HTML, XML, C, C++, SQL, SQL Server 2000