SUMMARY

• 10+ years of experience in Quality Assurance Testing of Client/Server, Web - based applications & Back-end/Database
• Experienced in Testing Medical Malpractice Insurance, Supply chain, Ecommerce, State Projects, Healthcare, Energy Domain Projects
• Experienced in Validation of Public sector Domains such as Child support system, Administration of Court system, Home & Community Services Information system.
• Expertise in Testing Various Technical Environments based on Java, .Net, Oracle Siebel, Small talk, CRM, Data warehouse, ETL, Akamai Server.
• Proficient in Data validation of Analytical Reports Developed using Cognos, QLIKVIEW, SAP BO
• Substantial expertise in Functional Testing, Smoke Testing, Integration Testing, Black Box Testing, System Testing, Regression Testing, Adhoc Testing, User Acceptance Testing.
• Proficient in Developing Test Plans, Test Scenarios, Test Cases, Test Execution, Defect Reporting & Management, Status reporting
• Extensive experience in manual as well as automated testing procedures using QTP, Test Director, Quality Center, JIRA, Workfront, Issue db.
• Used QTP for automation of regression testing.
• Experienced in Holding Project ownership and leading QA Resources for End to End QA Activities
• Experienced in Working & Managing Projects in onsite offshore model
• Thorough experience with SQA throughout the Software Development Life Cycle (SDLC) approach to computer systems development.
• Experience in analyzing Data Model and Expert in writing simple to complex SQL statements for Database testing.
• Experienced in Waterfall, Agile Methodologies and have good working knowledge in RUP
• Familiar with HTML, HTTP, XML, and SOAP protocols and networking technologies.
• Attention to detail and ability to work in tighter schedules and on different applications concurrently
• Worked independently as well as in a team and experienced in coordinating with different groups in a project.
• Excellent Communication, interpersonal and time management, People management skills.
• Excellent analytical abilities in using technology to create elegant, flexible and maintainable solutions for complex development problems.

TECHNICAL SKILLS

Testing Tools: QTP, Quality Center, Test Director, JIRA, Workfront, Issue db

Languages: Java, .NET, Small Talk, Oracle Siebel 7.8/8.0 C, C++, SQL, PL/SQL, HTML, XML.

Databases: Oracle, SQL Server 2000/05, MS Access, Hyperion Essbase

Database Query Tools: Toad, Benthik

Reporting Tools: Cognos, QLIKVIEW, SAP BO

Script Languages: TSL, Java Script, Shell Scripting, Perl Scripting.

Operating System: Windows 98/NT/2000/XP, UNIX.

DMS: Document Processing, Xpertdoc, Hyland OnBase

PROFESSIONAL EXPERIENCE

Confidential

Senior QA Analyst

Responsibilities:

• Review BRD, Use Case, Technical Solution Documents & perform Gap Analysis in the Documents
• Interact with PM, SME’S, BA to gather Functional Requirements and get the Approvals
• Document gathered Requirements & follow up on Pending Requirements
• Involved in Preparing Smoke Test Check list for OASIS Application & made it a Training Document for New Resources.
• Performed Smoke Test Validation on Application Builds for stability.
• Involved in Promoting QA Best Practices within the Organization.
• Performed QALC Activities for modules including Forms/Policy/Finance/Claims.
• Holding Project Ownership Performed Planning, Management & Execution of QALC Activities for Forms & Policy Projects
• Leading QA Activities for all Forms Projects i.e. Endorsement window, Specialty Forms, Senior Care, Existing Production forms
• Assisting Team members on Time crucial Projects to Accomplish QA Deliverables
• Collaborating with Automation Resource in Automating the Test Data Creation for Forms
• Training QA Team members on Functionality of OASIS
• Develop Test Plan for the Projects worked on & Presenting Test approach to the Project Team
• Develop High level Test scenarios and mapping to the Requirements in BRD.
• Presenting the Test scenarios to the Project Team in Test scenario Matrix Review meetings for Approval
• Develop Detailed Functional Test Cases & mapping to the Test scenario Matrix to ensure Overall Test Coverage
• Perform System Integration Testing, Adhoc Testing, Regression Testing.
• Involved in Defect Reporting, Defect Coordination, Defect Management using Issue DB, Jira in a Timely Manner.
• Escalating Issues & Projecting Project status in Workfront
• Perform Data Validation on Analytical Data reports generated using SAP Business Objects Tool
• Develop SQL Statements to perform Data Validation on the Reports
• Perform Data validation of Forms using Nuance pdf comparator
• Perform End to End Testing of OASIS, Xpertdoc, OnBase for Forms Validation
• Perform Forms Triggering and Data validation using Xpertdoc for New forms.
• Involved in Folder Structure validations of OnBase for different data Transactions
• Perform Forms Triggering and Data validation using Document Processing software for old forms
• Creating QTP scripts to create Test Data to assist Users perform UAT
• Assist Dev Team for Unit Testing and Users for UAT by sharing Test Scenarios and Test Cases
• Perform Test Management using Workfront.
• Perform Retesting of the Defects raised by offshore Team to test the compatibility of code on client Environment
• Perform Risk based Testing for Time Crucial Enhancements by reviewing with the Business Users
• Perform Regression Testing of End to End functionality of OASIS for each Release
• Involved in Performance Testing along with OASIS Project Team.
• Developed test cases for GUI, SIT on Java based applications
• Executed Selenium scripts for Regression testing and reported defects.
• Performed Integrated Testing of legacy system based on Python for Historical data.

Environment: Java, AS400, SAP BO, Oracle 11g, Windows 7, MS Word, MS Excel, MS PowerPoint, Workfront, Toad, Issues DB, JIRA, Nuance pdf comparator.

Confidential, PA

Senior QA Engineer

Responsibilities:

• Review and Analyze Functional Requirement Specifications
• Coordinated with Client and BA Regarding the Requirements to have better understanding on User Requirements.
• Coordinated with Developers to have thorough understanding of the application Interface.
• Involved in Testing Activities right from beginning phase of SDLC
• Involved in Testing Web Based Applications
• Involved in Preparing Test plans to cover overall quality assurance.
• Discuss with the Client and drafting high level Requirement Scenarios
• Discussing with the Developers and Technical leads and clarifying the Requirements.
• Preparing the Detailed Test Scripts covering the overall functionality of the Application.
• Entering the Data into the Application using XML Interface.
• Performed Smoke testing, GUI Testing, Functional testing, Integration Testing, System testing, Retesting, Regression testing, Adhoc testing.
• Performing Testing on multiple browsers such as IE, FF, Chrome & Safari.
• Performed Test Management using Quality Center.
• Involved in writing SQL Statements to test the Data flow through Supply Chain Inventory Database
• Involved in writing SQL Statements to validate the data generated in the COGNOS Reports and QLIKVIEW Reports.
• Optimized the SQL Queries using Materialized views
• Involved in Testing the Reports developed using Cognos
• Performed Testing of the Analytical Reports developed using QLIKVIEW.
• Validating the Source to Target Data as part of ETL Testing.
• Validating the Slowly Changing Dimensions as part of ETL Testing
• Worked on Multiple Projects simultaneously and maintained the Time Schedule.
• Performing Compatibility Testing on multiple browsers such as IE, FF, Chrome & Safari.
• Involved in Defect Management using Quality Center
• Involved in uploading the Test scripts from Excel into Quality Center.
• Involved in Testing Data warehouse Reports and also involved in Data Analysis.
• Updated the Status of QA in the Status meeting to meet the Deadlines
• Prepared the Traceability Matrix and ensured all the Requirements are covered
• Documented the Testing process for future testing of QA needs

Environment: Java, Cognos 8.4.1, Oracle 11g,Windows XP Professional, Windows 7, MS Word, MS Excel, MS Powerpoint, Quality Center 11/HP ALM, Toad, Team Tracker, Mariner, QLIKVIEW.

Confidential, IL

QA Engineer/Track Lead

Responsibilities:

• Reviewed the Functional Specs to understand the Business Requirements.
• Involved in Testing Activities right from beginning phase of SDLC
• Involved in Testing Web based Application
• Involved in preparing Test Plan to define the Testing approach.
• Involved in preparing the Test strategy.
• Worked as Team Lead taking Responsibility for modules such as Akamai Server, Discover Bin, Pinterest, Egift cards.
• Interacted with the client regarding Requirements and prepared High level Test Scenarios.
• Working in Onshore Offshore model by coordinating and communicating process, procedure and work to offshore Team.
• Reviewed the Test Cases prepared by the Offshore Team and made sure they cover the functionality as per the client.
• Configured the Testing environment for Test Execution.
• Performed Smoke testing, GUI Testing, Functional testing, Integration testing, System testing, End to End Functional Testing, Retesting, Regression testing.
• Communicating to offshore Team regarding the functionality to be Tested.
• Working on multiple projects simultaneously and making sure thatsoftware product is build according to Quality standards.
• Performing Functionality and Compatibility Testing of Application on Mobile Phone (iphone) with IOS.
• Performing Adhoc Testing of Application on Mobile Phone (iphone) with IOS.
• Testing the E Commerce website and as well as Application Servers.
• Validating the Sourcecode, Pack files, CSS files and image files for the cached content
• Verified the Pack files, CSS files and image files using Fiddler.
• Validating the Cookie’s using Cookie Manager.
• Performing Testing on multiple browsers such as IE, FF, Chrome & Safari.
• Performed Adhoc Testing and found multiple Defects.
• Performed Test Management using Quality Center.
• Involved in writing simple to complex SQL Statements against source database for data validation
• Prepared the defect reports and interacted with developers for debugging.
• Performed Testing on middle layer i.e. Akamai inorder to ensure the load is reduced on the web server.
• Attended daily scrum meetings and updating the Testing activities.
• Reviewed the work of offshore Team and coordinated to the Project Management Team accordingly.

Environment: Java, Akamai Server, Fiddler, Cookie Manager, Oracle 11g,Windows XP Professional, MS Word, MS Excel, MS Powerpoint, Quality Center 11/HP ALM.

Confidential, PA

DW/BI/ETL QA Engineer

Responsibilities:

• Interacted with the Technical leads to understand the domain
• Involved in preparing the Standardized names for all the Reports so that the names in the Functional Specs match with the one which are generated by ETL in the Database.
• Analyzed different Scenarios which were already prepared and Researched for the Terminology Used in the Scenarios to have better understanding of the Applications.
• Tested and worked on configuring test data for different case category functionality
• Performed Web & Client Server Applications based testing.
• Performed Smoke test for deployed builds.
• Involved in Preparing the Test Scripts for the Reports to be tested which were developed using Cognos.
• Firstly performed thorough backend testing which Involved Preparing the Data warehouse Data sheets According to the Functional Specs and the Mock ups.
• Imported the data from the Excel spread sheets into the Oracle Database using Toad.
• Involved in Unit Testing along with the developer’s to verify that the Results are displayed perfectly in the reports.
• Writing Basic to Advanced SQL Queries to ensure that expected Results are displayed in the respective cells for a report.
• Ran the Reports using Cognos Reporting Tool and Executed the Test Scripts against the Reports
• Worked on Testing the different case category reports
• Worked in Star Schema modelcreating SQL Statements based on relation between facts and dimensions.
• Performed system and integration testing as part of the End to End testing.
• Involved in Test Data Creation from the front end using QTP for End to End testing.
• Involved in Performing Regression Testing using QTP
• Participated in the Smoke testing, Functional testing, Integration testing, System testing,End to End Functional Testing, Retesting, Regression testing from front end which involved all the Tracks
• Involved in preparing the Core Datasheets for the End to End Testing.
• Involved in reviews of the Test scripts with the offshore team in India
• Involved in Test management using Quality center
• Involved in Testing Client Server Application
• Involved in uploading the Test scripts from Excel into Quality Center.
• Also worked on Quality center database in writing SQL queries to query the information client needed.
• Validating the Source to Target Data as part of ETLTesting.
• Validating the slowly changing dimensions Type 2 as part of ETL Testing.
• Successful in finding & Logging number of ETL defects which were blocking the data from generating in the reports.
• Logged the Core, Report & ETL related Defects and assigned to the respective developers using the Quality
• Ensured that defects are addressed in time through coordination and people management and all the Defects are in Closed Status.
• Documented and transferred knowledge to the Development team on differentcase category.
• Also Participated in System Testing and UATwith stakeholderstesting the Applications of the Other Tracks.

Environment: Cognos 8.4, Tibco Data Exchange, Windows NT/2000, MS Excel, MS Word, SQL,Oracle 10g, BO, Toad, Quality Center, Clear Case.

Confidential, PA

DW/BI/ETL QA Engineer

Responsibilities:

• Reviewed the Functional Specs to understand the Business Requirements
• Analyzed Data warehousing database to understand the Relation between tables
• Involved in Preparing the Data warehouse Test Scenarios according to the functional specs.
• Involved in testing the Dashboards with multiple reports in BI Environment.
• Fixing the Cosmetic issues in the Reports using Report studio in Cognos
• Ran the Reports using Cognos Reporting Tool and Executed the Test Scripts against the Reports Developed to verify that the reports are generated according to the Requirements
• Writing Simple to complex SQL Statements in order to validate the data displayed in the reports
• Performing System Integration test on Different Dashboards according to the functional specs
• Validating the Data displayed in the Reports against the Data displayed in the EI Analytics Ad hoc Package.
• Validated that Data elements are added under each respective folder in EI Analytics Ad hoc Package.
• Created new reports in EI Analytics Ad hoc Package and added filter conditions in order to pull the Data and validate against the reports.
• Involved in System Integration testing of Front end HCSIS Application.
• Identified issues in Report logic as well as ETL, reported to developers and made sure all the defects are addressed on Time.
• Validating the Flag Indicators as part of ETL Testing.
• Worked in Star Schema model and understood the relation between facts and dimensions.
• Worked on multiple tracks i.e. testing different tracks in Application
• Maintained Test Traceability matrix in order to verify every functionality is covered
• Created Test input requirements and prepared the test data for data driven testing
• Updated the Status of QA in the Status meeting to meet the Deadlines
• Prepared the defect reports and interacted with developers for debugging.
• Documented Status of all Testing Scenarios in ATS (Automated Tracking System) in order to report the status for Management.

Environment: .NET, Cognos 8.4.1, Informatica 8.1.1, Windows XP Professional, MS Word, MS Excel, MS PowerPoint, SQL,Oracle 11g, Benthic, TFS, Quality Center.

Confidential, CA

DW/BI/ETL QA Engineer

Responsibilities:

• Reviewed the Functional Specs to understand the Business Requirements
• Watched the video training sessions and read documentation to understand what the Business and Standards of the Company are.
• Involved in Testing Activities right from beginning phase of SDLC
• Working on the maintenance packages which are reported by the users and make sure they are fixed.
• Working on a work order which involves data warehouse reporting.
• Creating the data for the reports which are generated using Cognos.
• Testing the Work Orders which have Enhancements built on Mainframe Technology.
• Running the DW Reports and verifying the Data displayed is as per the requirements.
• Tested Dashboards in BI Environment by writing SQL statements
• Running the Cognos Reports and verifying Reports are developed according to the functional specs.
• Ran the Cognos reports in reporting studio in order to update the report changes.
• Performing GUI Testing, System Testing, Integration Testing and UAT in Multiple environments.
• Performing Regression Testing on Various Functionalities of the Application built on Mainframe Technology.
• Involved in writing SQL Statements to validate the data generated in the Reports.
• Reported the Defects and Ensured that defects are addressed in time through coordination and all the Defects are in Closed Status.
• Tested current indicators in Slowly Changing Dimension Type 2
• Multitasking on Testing Packages, Work orders, and Regression Testing.
• Involved in testing other Health careApplication helping other team to finish their Work within Timeline.
• Documenting the Testing Process from initial phase of Testing to end.
• Interacting with Clients during Requirements Gathering phase and UAT.
• Involved in Training BTA’s regarding Testing process for Application and DW Environment

Environment: .NET, Cognos 8.4.1, Informatica 8.1.1, Windows XP Professional, Mainframes,MS Word, MS Excel, MS Office, Quality Center.

Confidential, WI

QA Engineer

Responsibilities:.

• Analyzed Functional Requirement Specification (HLD), System Design Specification(SDS), and participated in requirements gathering with different Clients.
• Coordinated with BA Regarding the Requirements to have better understanding on User Requirements.
• Coordinated with Developers to have thorough understanding of the other application Interface.
• Involved in Testing Web Based Application
• Involved in preparing Test Plan to ensure that overall functionality is tested.
• Prepared the Test Scenarios based on the Use Cases.
• Developed the Test Cases for four different modules based on the HLD.
• Involved in the Review meetings of the Test Scripts with the offshore team.
• Enhanced the Test Scripts based on the requirements of the Product Owner.
• Executed Test cases against the applications build on the basis of HLD and Use Cases.
• Performed Functional Testing, Smoke Testing, Positive and Negative Testing, Grey Box Testing, Integration Testing, System Testing and Regression Testing manually.
• Understood the workflows involved in different applications and tested their functionality.
• Updated the Status of Testing and maintained the Test Results in absence of the Team lead.
• Involved in Test management using Quality center
• Logged and reported the Defects using Quality Center.
• Maintained the Record of the defects using the Quality Center.
• Maintained Test Traceability matrix in order to verify every functionality is covered
• Updated the Status of QA in the Status meeting to meet the Deadlines.
• Updated the status of testing applications in the Shared point site.
• Participated in the team meetings to discuss the issues arising out of testing.
• Coordinated with the Developers and made sure that the defects were addressed in time.
• Involved in writing simple to complex SQL Statements against source database for data validation and Data Integration.
• Performed Regression Testing manually and also involved in User Acceptance Testing.

Environment: Oracle Siebel 7.8/8.0, Windows NT/2000, MS Excel, Quality Center, UNIX, SQL Server 2008