We provide IT Staff Augmentation Services!

Sr. Qa Analyst Resume

South Bend, IN

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 toolsQuality 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 andTOAD.
  • Experience with data analysis and reporting tools like Access, SSRS, Excel 2010, 2007 and 2003.
  • Extensive experience is using ComplexSQL queriesusing 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 likeQTP 9, 10and11, Quality Center9/10, Application Lifecycle Management (HP ALM 11), Load Runner and WinRunner.
  • Experience on Test management toolslikeTMS, Quality Center and Test Director.
  • Excellent Scripting Knowledge of Mercury’s “TSL” forWin Runner,andVB ScriptforQTP.
  • 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 testingwith emphasis on functionality testing, White Box Testing, Black Box Testing, System andRegression 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,RegressionandUAT testing.
  • Proficiency in Data Warehousing concepts and processes , ETL processes QA
  • Strong fundamentals in all the phases ofSoftware 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 preparingQA metricsand checklists to ensure that the application meets the entire requirement specifications and implemented Task level quality control based onQA 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 theAgile/Scrum Methodology.
  • Coordinating the team throughout the entireagilephase.
  • 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
  • Useddata-driventesting and database accessing techniques during automation scripts development
  • Created and maintained automated tests usingQTPby coding inVB Script.
  • Developed custom QTP function libraries (likeObject Oriented Functions,Database Functions, and Utilities etc). These functions are application independent and platform independent that can be used across multiple projects.
  • Developed a comprehensiveAutomation Regression Suitethat 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
  • Performedintegration testing & data validationsusingQTPfor 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 ofQTP challengesby 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 complexSQLqueries to validate the data.
  • Developed automation scripts inQTPusingVBScript.
  • Designed and Developed Test Cases according to Functional Requirements and design specifications of the application.
  • Involved inQTP 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 usingQuality 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 ofQA Methodologiesstarting from planning, Capturing, Creating, Executing, Reporting and Tracking the defects.
  • Created and executedSQL queriesto fetch data from anSQL Server databaseand to validate and compare the expected results with those actually obtained.
  • Developed test cases for source systems and documentedtest cases.
  • Executed test cases and logged results in Excel.
  • Generated test scripts usingQuick Test Professionalto check the functionality of the system.
  • UsedQuality Centerto save the generated test scripts.
  • Linked detected defects during automation to requirements and test scripts usingQuality Center.
  • Actively participated in status meetings to report issues.
  • Generated scripts usingLoad Runnerto measure the performance of the system.
  • Performed web testing usingQuick Test Professionalto check the compatibility, reliability, and scalability of the application in different browsers.
  • Transformed the data using variousSQL 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 inSystem 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 Aug2005 - 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

Hire Now