CAREER SUMMARY

• Over 7+ years of Experience in Information systems. Experienced in manual and automated testing in Database, Data Warehouse, and Reporting applications as well as Client/Server and Web applications.
• Experienced in using the tools Quality Center, Win Runner, QuickTest Pro (QTP).
• Good knowledge of database concepts, data models , data relationships
• Experienced in extracting data from SQL Server 2008 R2 databases and Oracle
• SQL Server Management Studio and TOAD.
• Experience with data analysis and reporting tools like Access, SSRS, Excel 2010, 2007 and 2003.
• Extensive experience is using Complex SQL queries using techniques like Sub queries, Correlated Sub queries, Views, Functions and Stored Procedures for speedy and effective data analysis and system analysis.
• Excellent hands-on experience with HP Automation Testing tools like QTP 9, 10 and 11, Quality Center 9/10, Application Lifecycle Management (HP ALM 11), Load Runner and WinRunner.
• Experience on Test management toolslike TMS, Quality Center and Test Director.
• Excellent Scripting Knowledge of Mercury’s “TSL” for Win Runner, and VB Script for QTP.
• Experienced is testing SSRS reports
• Experienced in testing Dashboards, Scorecards, Transactional Reports, Parameterized reports, drill down reports, and drill through reports.
• Experienced in performing Manual/Automated testing with emphasis on functionality testing, White Box Testing, Black Box Testing, System and Regression Testing.
• Involved in executing the Acceptance Tests and Unit tests on Microsoft Visual Studio
• Involved in creating the work items in Microsoft Visual Studio Team Web Access
• Developed, Created Test Suites and Executed manual test cases in Microsoft Test Manager, Functional, End-to-End, Regression and UAT testing.
• Proficiency in Data Warehousing concepts and processes , ETL processes QA
• Strong fundamentals in all the phases of Software Development Life Cycle (SDLC) adherence to Software Quality procedures and in a wide array of QA efforts including Business Modeling, Planning, Design and Implementation of tests.
• Proficient in creating and executing test cases and test scripts, testing the software requirements in accordance with test plans, documentation of test results, producing status reports and configuration management
• Proficient in Defect Tracking, Reporting and effectively communicating the defects using Defect Tracking tools like PVCS Tracker, Rational Clear Quest and the Defects Tab in Quality Center.
• Expertise in the development and documentation of Test Plans in the Client\\Server architecture and Web applications.
• Conducted design and review sessions with clients, consulting staff, and management. Defined coding and development standards and implemented design and code review procedures throughout the project lifecycle.
• Proficient in preparing QA metrics and checklists to ensure that the application meets the entire requirement specifications and implemented Task level quality control based on QA standards, policies and procedures.
• Proficient in multi-tasking to work on multiple projects and thrive in a fast-paced, deadline-based environment and managed daily assigned duties were completed in accordance with time.
• Proficient in writing T-SQL and PL/SQL procedures.
• Detail-oriented with good communication skills, excellent analytical and problem solving skills and good team player.
• Excellent in defect fixing, solving complex problems and Performance Tuning.
• Excellent leadership qualities

EDUCATION

• Bachelor Of Science, Master Of Science

SKILLS SUMMARY

Testing Tools

QTP 9/10/11, Win Runner, and Load Runner

Defect Tracking Tools

Quality Center 9/10, QC/ALM 11, Test Director, Rational Clear Quest, JIRA and Bugzilla

Project Methodologies

Rational Unified Process, SDLC, Waterfall, Agile

Languages

C, C++, JAVA, J2EE, JSP

Data Base

Oracle9i/10g, SQL Server, DB2

Scripting Language

VB Script, JAVA Script, HTML, DHTML, UML and XML

Operating Systems

Windows 2000, 2003, XP, Home, Vista and UNIX

Protocols

TCP/IP, HTTP and HTPS

Application Servers

Web Services, Web Logic and Web Sphere

Version Manager

Visual SourceSafe, PCVS and Clear Case

Browsers

Internet Explorer, Netscape Navigator, Mozilla Fire Fox, VMware

Others

MS Office, MS Excel, Visio and Adobe

EXPERIENCE SUMMARY

Confidential, South Bend, IN May 2012 – present
Project: MSCRM-SFCRM Integration, AX2012 Reimplementation
Sr. QA Analyst/Automation Engineer

Project Description:
Confidential with hospital,medical practice orhome care setting, to create a high-performance environment that is experientially, clinically, operationally and financially strong. The Scribe MSCRM-SFCRM integration replacement with a more reliable system helps the CRM and the Sales Force User keep track of the client information. Integration of CRM-AX 2012 helps the finance user track the finance part of the Client

Responsibilities:

• Actively Involved in the Agile/Scrum Methodology.
• Coordinating the team throughout the entire agile phase.
• Reviewed and Created Business Requirements on Spec Log and Functional specifications for creating Test Plan andTest Cases.
• Developed Scenarios and Feature Files for the acceptance Tests on Spec Flow
• Involved in executing the Acceptance Tests and Unit tests on Microsoft Visual Studio
• Involved in creating the work items in Microsoft Visual Studio Team Web Access
• Developed, Created Test Suites and Executed manual test cases in Microsoft Test Manager, Functional, End-to-End, Regression and UAT testing.
• Defect Analysis, resolution and Tracking.
• Functional expertise on Health Insurance Sales, Enrollment and Billing.
• incident report/tracking
• Executed the Queries on Microsoft Test Manager to track the Test Cases
• Executed End to End Testing for the Integration of Microsoft Dynamics CRM to Sales Force
• Experienced in UI testing for Microsoft Dynamics CRM
• Executed and tested Reports on Microsoft CRM and Sales Force
• Involved in TDD (technical Design document) meetings with developers and BA’s from starting of the project to know the exact functionality
• Prepared the Test Plan, Test Approach, Test Execution Summary and Daily Defect Reports.
• Written and executed extensive SQL queries using Inner, Outer, Left, Right and Self Joins.
• Extensive experience in Backend testing and DB2 Database Validation using Quest Central and Data Studio
• Used data-driven testing and database accessing techniques during automation scripts development
• Created and maintained automated tests using QTP by coding in VB Script.
• Developed custom QTP function libraries (like Object Oriented Functions, Database Functions, and Utilities etc). These functions are application independent and platform independent that can be used across multiple projects.
• Developed a comprehensive Automation Regression Suite that is executed at the end of each sprint.
• Test Execution and Scheduling from Quality Center. The test execution is unattended with no manual intervention.
• Execution of smoke tests on each build using QTP and reporting the results to management
• Performed integration testing & data validations using QTP for various interfaces.
• Performed database testing to test data migration from different test environments.
• Test data mappings and changes as per the requirements.
• Developed utility scripts in QTP to export data from different database tables to Excel.
• Developed workarounds for many of QTP challenges by writing VB Script functions.

Environment: Microsoft Visual Studio 2010, Microsoft Visual Studio Team Web Access 2010, Java/J2EE, Microsoft Test Manager2010, QTP 10/11, Quality Center 10, SQL Server 2005/2008R2,MS Office, Tech Talk Spec Log1.1.39.0,Tech Talk Spec Flow1.8.1.0,Microsoft Dynamics CRM2011, Sales Force

Confidential, Herndon, VA Jun 2010 - Apr 2012 
Project: SIR (Servicer Investment Reporting)
Sr. QA Analyst

Project Description:
SIR helps Fannie Mae business users track the Investment’s made by Confidential and also helps track Confidential portfolio.

Responsibilities:

• Implemented whole life cycle of QA Methodologies starting from test strategy, test planning, creation and implementation of extensive test scenarios, preparing test environments for execution, preparation of test data depending on the type of scenario, Defect identification, tracking, and preparing test summary at the end of each build/release.
• Developed complex SQL queries to validate the data.
• Developed automation scripts in QTP using VBScript.
• Designed and Developed Test Cases according to Functional Requirements and design specifications of the application.
• Involved in QTP modular driven framework.
• Extensively used QTP methods (VBScript Methods & QTP Methods)
• Performed Testing of Reporting applications by extracting data from reporting databases and validating reports against them.
• Developed ad-hoc queries and reports to validate data warehouse and dashboards.
• Developed and executed test scenarios and prepared test data to meet the requirement by using the Business and functional Requirements.
• Developed and executed back end scenarios for database perspective testing.
• Involved in system test and user acceptance certification testing.
• Coordinated with client and business team in case of clarification and collection of business of requirements for all releases.
• Coordinated with developers to fix the problem and enhancing the application.
• Developed and maintained test scripts and test cases based on system flow and field validation by using positive, negative, boundary, and null value testing scenarios.
• Performed Internal and external test case reviews with Business team and external clients to review the test scenarios and test data.
• Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures for test changes.
• Analyzed and maintained test results using Quality Center (QC).
• Involved in data creation, validation and execution of .csv, .pdf and .xsl reports that are used to report the loan, servicer and contract level data.
• Performed key role in creating the test environment and data loading for every release.
• Performed extensive XML validation using Altova XML spy for XML Data validation and Schema design and validation.
• Lead the team meetings for Bug fixes depending on the defect severity and functional specifications.

Environment: SQL Server 2005, 2008 R2, SSRS, Oracle10g/9i, Quality Center 10, Rational Clear Quest, Rational Clear Case, QTP 10, VB Scripting, Toad

Confidential, Bethesda, MD Mar 2009 – Jun 2010
Sr. QA Analyst 
Project: LCE (Laboratory of Cardiac Energetics)

Project Description:
Laboratory of Cardiac Energetic System (LCE) is a web based system. This system is used to satisfy reporting, data mining and research requirements for MRI/CT imaging sections of LCE laboratory.

This system collects patient information, medical history, MRI/CT techniques, medications, MRI/CT measurements, CT scan images and observational items for each exam entered into the system. The data is entered for each exam or it can be imported directly from the measurement and study workstations. Application has diagram templates that allow data elements to be added to depict the condition of the heart and aorta (Main Vessel which Transfers blood from heart to body) under different conditions. The system is used to generate Cardiac MRI/CT reports for the diagrams and textual data in excel sheets or PDF documents or faxes.

Responsibilities

• Developed Test scripts to meet the requirement by using the Business Scenarios and Business Requirements for MRI and CT exam modules.
• Involved in the requirement collection and Business Analysis meetings
• Coordinated with developers to fix the problem and enhancing the application.
• Implemented whole life cycle of QA Methodologies starting from planning, Capturing, Creating, Executing, Reporting and Tracking the defects.
• Created and executed SQL queries to fetch data from an SQL Server database and to validate and compare the expected results with those actually obtained.
• Developed test cases for source systems and documented test cases.
• Executed test cases and logged results in Excel.
• Generated test scripts using Quick Test Professional to check the functionality of the system.
• Used Quality Center to save the generated test scripts.
• Linked detected defects during automation to requirements and test scripts using Quality Center.
• Actively participated in status meetings to report issues.
• Generated scripts using Load Runner to measure the performance of the system.
• Performed web testing using Quick Test Professional to check the compatibility, reliability, and scalability of the application in different browsers.
• Transformed the data using various SQL techniques, functions and logic in order to validate data for testing.
• Performed ETL process QA to track down data issues from Data Warehouse to Staging and back to source databases.
• Retrieved data from UI and validated it against data in tables.
• Involved in testing the data in System Test, System Integration, UAT environments.

Environment: SQL Server 2005, QTP 9.5, Quality Center 9, SharePoint, ASP.net, C#, Team Foundation Server 2008, VB Scripting

QA Analyst, MD Apr 2008 – Feb 2009
Project: CDS (Clinical Data System) 

Project Description:
This a web based system which will replace currently deployed NHLBI-DIR system(s) and the paper process for recording and evaluating research data with a multi-tier web based system. This new system will enable generation of regulatory reports (DSMB, IRB) out of the box and assist physicians in producing scientific papers. This system is used to satisfy reporting, data mining and research requirements for carrying out clinical research studies based on specified study and its related protocols.

Responsibilities

• Analyzing and understanding existing system.
• Built test data set for various reporting applications.
• Developed test plans and test cases to test the Database and Reporting applications
• Finding data processing issues in Reports and ETL systems
• Executed test plans and created Defect logs.
• Performed Smoke, Regression and Functional testing.
• Tested data in Systems Test, Systems integration and UAT environments.
• Analyzed and evaluated existing systems and documented procedures.
• Documented existing SQL Server Reporting System including tables, relationships, Forms and Reports.
• Coordinated with DEV teams in resolving identified defects.
• Supported users to resolve any reporting issues in order to explain the details behind the report data.

Environment: SQL Server 2005, SSRS 2005 QC, QTP9.0, ASP.net, C#

Confidential Aug 2005 - Dec 2007 
Role: QA Tester 

Project Description:
Confidential is one of the largest banks in India. Providing services related to consumer and business banking in the areas of checking, savings, credit cards, loans, mortgages and brokerage accounts. Worked on different types of savings account applications including CD, Retirement accounts and higher education savings.

Responsibilities:

• Involved in preparing the test plans and the test cases based on Business Requirement Documents (BRD).
• Developed positive and negative test scenarios for Black Box testing and performed manual testing.
• Open the bugs using bug tracking tool Test Director, and assigned them to the Development team.
• Re-executed test cases under Test Lab tab updated the test cases and reported the results.
• Performed Unit testing (whit box) debugging the COBOL code for loan modules.
• Performed Regression testing by executing the test scripts.
• Analyzed the test results with Win Runner reports.
• Involved in manual checks for scripts, to track and analyze the business logic.
• Participated in Regression testing, Compatibility testing between versions and Integration testing.
• Actively participated in daily and weekly test progress meetings.

Environment: IBM Mainframe, MVS, COBOL, JCL, TSO / ISPF, DB2, Windows NT, Test Director, Win Runner, J2EE, SOAP, FTP, SNA server, XML, XSL, VTAM, Web Sphere, z/OS, Manual Testing