SUMMARY

• Over 9 years of experience with QA Methodology and QA Strategies to ensure Quality Control of IT systems and Scrum Agile Methodologies
• Extensive knowledge of Test Strategy, Test Plans, Test Procedure, Test Cases, Traceability Matrix, and Management of Bug reports, Logs and reporting process.
• Strong work experience in Databases and DW Testing, End to End Testing, Regression Testing, Functional Testing, User Acceptance Testing, Integration Testing and System Testing.
• Experience with OLAP tools viz. Cognos 8, Cognos, ReportNet, Framework Manger and Crystal Reports 10.
• Extensively worked in developing and implementing report solutions on Business Objects XI R1/R2 Universe Designer, Web Intelligence XI Report Design R2, Crystal Reports XI.
• Exposure to Universe, Webi documents and maintaining them on Business Objects XI R2 SP3.
• Extensive knowledge of Software Development Life Cycle (Analysis, Requirement, Design, Development, Testing and Implementation) processes and methodologies, Scrum Agile Methodologies and JIRA.

TECHNICAL SKILLS

DW/BI/OLAP Tools: Microstrategy, Cognos 8.2 ReportNet, Framework Manager, Report Studio, Query Studio, Business Objects XI R1/R2 Universe Designer, Web Intelligence XI Report Design R2, Crystal Reports XI, Informatica, Datastage

Testing Tools: HP QTP 9.2, HP - ALM, Telerik, Cucumber, Ruby, Load Runner 8.0, Win Runner, Test Director, Bug Tracker

Database: Oracle 8.0/9i/10g, TOAD, MS SQL Server 7.0/2000/2005, MS Access,DB2, Teradata 14.1

Project Management: Jira, Confluence, MS Visio, MS Office, MS PowerPoint, MS SharePoint, MS Outlook

Operating Systems: Windows 98/NT/2000/2003/XP, UNIX, Linux, OS400, MS-DOS, Mainframe

Programming Languages: SQL*PLUS, Visual Basic 6.0, Java

PROFESSIONAL EXPERIENCE

Confidential, Columbus OH

QA Lead/ Scrum Master

Responsibilities:

• Organized and facilitated overall Release and Sprint planning - including daily stand-ups, reviews/demos and retrospective
• Used JIRA for repository, reporting and tracking bugs, and providing updates on resolved bugs and Involved in end-user training and UAT to implement the application.
• Communicated team status / progress via Release /Sprint burndown charts, Story acceptance rate and defects and make sure the stakeholders are aware of what’s going on
• Builds high-performing teams by helping the team manage interpersonal conflicts, challenges, and opportunities for growth.
• Protected team from over- commitment, managed backlog, prioritized resolution of defects/bug
• Coordinate with the release manager on environment setups & maintenance, code deployments, and production releases.
• Worked with the product owner during the Sprint review session to make sure all stories met Definition of done and get the stories accepted within the sprint
• Worked closely with QA to develop use cases, review testcases and track feature bugs .
• Frequent follow up and friendly reminders to the team on updating JIRA tasks on daily basis for more accurate reporting.
• Work with the team and Product Owner/Manager to maintain a healthy backlog and plan upcoming releases.

Environment: /Applications: Confluence, JIRA, Agile,MS-Office, MS Visio, SQL Management Server Studio 13.0,RUP, Mobile App ( IOS/ Android) Zephyr, Telerik, Win2008/XP

Confidential, Columbus OH

QA Lead/ Scrum Master

Responsibilities:

• Responsible for preparing and manage QA project plan, prepare test estimates, test timelines (Functional, SIT, UAT and Performance Testing)
• Facilitate daily stand-ups, sprint planning, grooming, demo, retrospectives, and other related team and intra-team meetings
• Coaches the team on agile and scrum principles with a goal of continuous improvement.
• Responsible for test deliverables within the sprints
• Involved in bug tracking using JIRA with the team and ALM with all teams.
• Reported all activities to leaders and client management, led project team meetings with representatives of business units, developers, QA, and product owners, maintaining continuous projects statuses.

Environment: /Applications: Oracle 9i,HP- ALM, MS-Office, MS Visio, SQL Management Server Studio, JIRA,RUP,Win2008/XP, Teradata, Unix, Ultra edit, IBM Web Sphere AppServer, Informatica 9.6

Confidential, Columbus OH

Data Warehouse Test Lead

Responsibilities:

• Prepared Master Test Plan, Strategy document and Data validation document.
• Worked within a high performing Agile environment, Participated in User Story discussions, grooming sessions to make sure User Stories are testable and measurable
• Prepared the Test data for different data set Policy, Insuredvehicle, PolicyInsuredProperty for interpreting Positive/Negative/ Regression results based on the Design documents
• Utilized SQL to create scripts and extract data used in system data validation, preparing functional documentation according to required software features.
• Responsible for reviewing test cases, test plans and reporting status ensuring accurate coverage of requirements and business processes.
• Involved in organizing meetings with the business users and reviewing the developed scripts to ensure that they were in accordance to the business user’s expectations.
• Designed and implemented Keyword driven internationalization test automation framework using Ruby .
• Used ALM for repository, reporting and tracking bugs, and providing updates on resolved bugs and Involved in end-user training and UAT to implement the application.

Environment: /Applications: Oracle 9i, Mainframe, HP- ALM, MS-Office,Visio, SQL Management Server Studio, Agile, Micro strategy, Win2008/XP, Teradata, Unix, Ultra edit, Agile, Cucumber, Ruby, Teradata14.0,Informatica 9.6.1, XML, Flat Files

Confidential, Dublin OH

QA Test Lead

Responsibilities:

• Prepared Master Test Plan and developed Use cases, testcases and test scripts for each Distrack activity (Receiving, Blank Q, Negative receive, Inventory, Shipping and Returns)
• Prepared the Test data (Created PO in Distrack, Created EPCIS/ASN/Pedigree event using SPAGG tool, Drop Event via EDI channel (ASN) and Folder (EPCIS/ Pedigree document)
• Print labels generated label via SPAGG tool based upon EPCIS/ASN/Pedigree) for interpreting Positive/Negative/ Regression results based on the Design documents
• Verified Daily Activity, Exceptions, Tracker, Item Trustworthy Scorecard, Inventory Balance, Vendor Data Integrity Scorecard, Chain of Ownership
• NLC Serialization, Pedigree Reconciliation EAI Reports (Pedigree Reporting Portal) Reports in each test case execution phase.
• Coordinate testing activities with onsite and offshore testers as needed
• Report bugs/defects in the HP QC/ALM and ensure problem resolution is communicated in a timely and effective manner between Developers, Lead QA and Project Manager

Environment: /Applications: AS400, HP- ALM, EAI, MS-Office, Visio, SPAGG, SQL Management Server Studio, Oracle 9i, Agile, Win2008/XP, Toad, Unix, Infosphere Traceability Server (ITS), AMS, Distrack, EDI, Devices (1D, 2D readers), WebSphere Sensor events

Confidential, Irvine CA

ETL QM Lead

Responsibilities:

• Designed, Created and Executed SQL scripts for report criteria validation.
• Developed Test Plans and Test Cases and Test Scripts for positive and negative tests and participated in status meetings to report issues.
• Participated in Scrum planning, Release/Iteration planning and assisted others in estimating task effort and dependencies

Confidential, Dublin OH

QA Analyst- DW Test Lead

Responsibilities:

• Identify the Test Scenarios based on the Business Requirement Document (BRD) and obtain sign-off of the Test Scenario document from the respective business owners
• Coordinate testing activities with onsite and offshore testers as needed
• Designed, Created and Executed SQL scripts for report criteria validation. Wrote Complex SQL queries to check proper data population in database before testing begins and to verify BI reports.
• Executed test cases to carry out system testing, functional testing, regression testing, smoke testing, database testing and other black box type of testing
• Prepared the Test data (Input files) for interpreting Positive/Negative/Regression results based on the design requirements.

Environment: Oracle 9i, MS-Office,Visio,QTP, QualityCenter9.2,Teradata,MicroStrategy, Integrity Manager, Cucumber, Ruby

Confidential, Columbus OH

Sr.QA Analyst

Responsibilities:

• Created Test Scenarios and Detailed Test Cases based on the Use Case Documents, Business and Functional Specifications.
• Performed all phases of End-to-end testing which includes user acceptance testing. Functionality Testing, Regression testing
• GUI testing, and unit testing and smoke testing of the application, its interfaces and client-server utilities.
• Used Bug Tracker for repository, reporting and tracking bugs, and providing updates on resolved bugs and involved in end user training and UAT to implement the application.

Environment: Oracle 9i/10g, Toad, SQL*PLUS, XML, DHTML, HTML, QTP 9.2, Quality Center 9.2, Informatica, Cognos

Confidential

QA Analyst

Responsibilities:

• Designed and developed test cases and test scripts based on functional specifications. Involved in preparing the test plan with other team members.
• Wrote Complex SQL queries to check proper data population in database and Verified the data in database tables, tested multiple interactive data entry screens

Environment: Oracle 9i, SQL, Crystal Reports, Win 2003/XP, QTP, MS-office, QC 9.2, MS Visio