PROFESSIONAL SUMMARY:

• Over 9 years of experience in information technology as a Software QA professional.
• Strong knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Hand on experience working in Waterfall, V model and Agile methodologies.
• Hand on experience in Test Planning, Test Execution, and Reports using Microsoft Test Management and Lab management.
• Extensive experience in analyzing Requirements, Functional and Technical Specifications and converting them into Test Scenarios and Test Cases.
• Strong working experience in Black box, White box, Functional, System, Integration, Regression, Automation, and End to End testing.
• Experienced in Web Application testing including Functionality, Usability, Interface, Compatibility, Security testing.
• Hand on experience in test and defect management tools such as Quality Center, TFS, Microsoft Test Manager (MTM), Team Foundation Server (TFS) and JIRA.
• Extensive knowledge on ETL process, OLAP, OLTP and N tier data architecture and RDBMS.
• Hand on experience in ETL testing using ODI (Oracle Data Integrator), Informatica and DataStage and data validation.
• Experience in data validation and testing Database Applications of RDBMS in Oracle, SQL Server, DB2.
• Hand on experience in analysis, creation of testing data to validate the ETL transformations rules, business rules including positive and negative scenarios and conditions.
• Hand on experience in BI report testing using OBIEE, Hyperion, Enterprise Performance Management (EPM 11) and business object.
• Good understanding of OBIEE repository (Physical, Business Model and Mapping and Presentation layers) for both Stand - Alone and integrated and analytics implementations.
• Hand on experience in writing simple and complex SQL (DDL, DML and DCL) queries for back-end testing and data validation using TOAD, SQL Developer, SQL Server Management Studio.
• Expertise in Defect Tracking, Defect management and Reporting using Quality Center, BugTraker, JIRA.
• Hand on experience in Configuration and version management tool Subversion (SVN), JIRA.
• Built a dynamic relationship with the client, development and other teams to insure the highest quality deliverable possible and to deliver them on time.

TECHNICAL SKILLS:

Testing Tools: SOAPUI, Quick Test Pro (QTP), Quality Center, TopTeam, Rally, Application Life Cycle Management (ALM), Microsoft TFS, MS Visual Studio, MS Test Manager

RDBMS: Oracle 11i/10g/9i/8i/7.x, MS SQL Server 2008, UDB DB2 9.x, Sybase 12.5, Teradata V2R6, MS Access 7.0

Programming: UNIX Shell Scripting, SQL, SQL*Plus, PL/SQL, JAVA, .Net, Visual Basic Script, C++

Web Technologies: JavaScript, HTML 4.0, and DHTML, Java, JSP, XML, J2EE, Microsoft .net and C#

Environment: UNIX, MVS, HP-UX, IBM AIX 4.2/4.3, Novell NetWare, Win 3.x/95/98, NT 4.0

Config Management: Sub Version(SVN), Rally, JIRA

Methodologies: Waterfall, V-Model, Agile, Verification and Validation

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Sr. Quality Analyst

Responsibilities:

• Worked as alternative QA Lead and also played vital role working as Quality Analyst.
• Participated daily bug triage meeting to make sure high priority bugs.
• Reviewed the Business/ Functional/ System Requirement Document.
• Reviewed High Level Design Documents, Detailed Design Documents and Requirement Tractability Matrix.
• Used Microsoft Test Manager (MTM) for creating and executing Test Cases.
• Generated test progress report using MTM.
• Worked with the project team to determining defects using the Team Foundation Server (TFS).
• Wrote and executed SQL Queries using the tool MS-SQL and Aqua Data for testing integrity of data in multiple database.
• Backend testing done in Sybase Server and MS-SQL Server.
• Worked in creating Data migration test cases and running the test.
• Worked on System Integration testing, Functional testing, backend testing, UI testing, Regression testing, and Backend testing.
• Coordinated with Product Users, Business Analysts, Developers, Dev Lead, QA Lead, QA Manager, and fellow QA team mates to deliver high-quality and enterprise-class releases on monthly basis.
• Used Trello tool for Kanban system work environment for creating backlogs, current release work items, test case planning for the current release work items, running test cases, verifying or returning work items as necessary.
• Actively participated in Status reporting meetings and interacted with team members.
• Worked with team members in quality assurance procedures and processes and facilitated discussions on areas of improvement.

Environment: Microsoft Test Manager (MTM), Team Foundation Server (TFS), Visual Studio, Sybase Server, MS-SQL, Agile, Kanban, HTML, CSS, MS Office, Trello.

Confidential, Austin, TX

On-shore QA Lead

Responsibilities:

• Lead a QA team of 15 off-shore and on-shore team members.
• Analyze system requirement, technical design specification documents, business rules, data validation specifications and enhance test overage accordingly.
• Analyze the data needs for testing and prepare test data.
• Collect and review the business flow, business scenarios from business analyst, architecture team and management team.
• Responsible for Test planning, Test estimation, testing deliverable review and submission and task management.
• Worked with Developers, Business analysts and Project managers to determine In-scope/Out-of-scope, environment and testing timelines.
• Develop and reviewed Test Strategy, Test Plan and testing scenarios.
• Coordinate and manage day to day activity with On-shore and Off-shore team.
• Participate in requirements/design review meeting and provided feedback on testing perspective.
• Provide walkthroughs/presentations of Test Strategy, Test Plan, and Test Approach with business and technical team.
• Provide training for Process, Tools and Technique to team members as needed.
• Lead and worked as a single point of contact for all Testing activities includes Functional testing, System Testing, Integration Testing, Re-testing, Cloud migration testing, Backend testing, End to End Testing, UAT Testing and PROD Testing.
• Performed Database Testing includes: Data Quality, Data Integrity.
• Review, inspect, evaluate and track QA deliverables which includes RTM Test Requirements Mapping, Test Scenarios, Test Scripts, Test Data requirements, Defect Reporting.
• Preparing and maintaining the release and cycles to keep track of code movement and testing using ALM 12.0.
• Tracked, reported and follow-ups defects using ALM 12.0.
• Generated and distributed test progress and defect status reports to Management team.
• Facilitated defect review meetings and improved existing defect management process, driven team to work in faster manner by reporting defects status.

Environment: Vertica, ClickView, Hadoop, Web Server, SFTO, SQL Developer, ODI, ALM 12.0, MS Office, SQL Server, Toad, Visual Basic Script, SharePoint, Putty, Unified Functional Testing (UFT), Vertica, Infomatica, Hadoop, LoadRunner 12.0, TOAD

Confidential, Phoenix, AZ

Sr. ETL/ BI Tester

Responsibilities:

• Analyze Data Models, Data mapping, Design, Conversion and ETL design documents.
• Create, maintain and track of Requirement Traceability Matrix.
• Worked with the project team to determining defects using the MTM and Version One.
• In charge for coordinating ETL testing: Source, Staging, ODS, EDW, BI.
• Implemented SQL Queries for testing integrity of data in database (Backend Testing).
• Tested database integrity, referential integrity and constrains during the database migration testing process.
• Tested the reports different types of Customized Reports (Drilldown, Aggregation) Created by OBIEE to meet client requirements.
• Created and administered the physical layer, Business Model and Mapping Layer and Presentation Layer in a OBIEE Repository using OBIEE Administration tool.
• Involved in validating the reports layouts in OBIEE based on Report Layout Document.
• Creation and execution of test cases on Oracle Reports and OBIEE.
• Executed SQL Queries for testing integrity of data in database (Backend Testing).
• Backend and Database Testing: Oracle, MS-SQL Server, MS Access databases.
• Analyzed business requirements, transformed data, and mapped source data using the Teradata Financial Services Logical Data Model tool, from the source system to the Teradata Physical Data Model.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning.
• Used Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata.
• Experience in Data migration and Data distribution testing.
• Tested database integrity referential integrity and constrains during the database migration testing process.
• Designed and kept track of Requirement Traceability Matrix.
• Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings.
• Extensively involved with ETL test data creation for all the ETL mapping rules.
• Executed SQL statements to test the integration between application and database.
• Proficiently worked with OBIEE to test Physical Model, Business Model and presentation layer and established relationships.
• Tested different types of Customized Reports (Drilldown, Aggregation) created by OBIEE to meet client requirements.
• Validated the reports layouts in OBIEE based on Report Layout Document.
• Creation and execution of test cases on Oracle Reports and OBIEE.

Environment: DataStage 8.0, OBIEE 11g, Teradata, SQL, Microsoft Visual Studio, MTM, MS Office, SQL Server, Oracle Data Staging, Version One, Agile, Kanban

Confidential, Topeka, KS

Sr. QA Engineer/Sr. QA Analyst

Responsibilities:

• Reviewed and analyze the Requirements documents, Design documents, Data design/flow, Data mapping documents to identify the Test scenarios and test data for testing.
• Collected and reviewed the business flow, business scenarios from business analyst.
• Responsible for writing and executing the test cases/test scripts for accessibility testing on web application as per government compliance using tool JAWS, AccVerify, and Wave.
• Responsible for performing 508 compliance validation testing.
• Effectively coordinated with the development team for closing a defect
• Prepared Test Scenarios by creating Mock data based on the different test cases
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process
• Tested data migration to ensure that integrity of data was not compromised
• Ran Data Stage jobs by using Data Stage Director and by running UNIX scripts as well
• Wrote complex SQL queries for extracting data from multiple tables and multiple databases
• Before the Load is accepted to test, have performed the smoke or shake-out test
• Extensively used Oracle database to test the Data Validity for Data Updates, Deletes & Inserts

Environment: My SQL, SQL Developer, Top Team, IBM Cognos 8.0, ClearQuest, SharePoint, Jaws, AccVerify, Wave, QTP 11.0, Oracle 12G, MS Office, Outlook, JIRA, Confluence, Beyond Compare

Confidential, Kansas City, MO

Sr. QA Analyst/QA Engineer

Responsibilities:

• Worked as a single point of contact for all Testing activities includes Functional testing, System Testing, Integration Testing, End to End Testing and UAT Testing.
• Developed and maintain Test Approach and Test Plans documents for Functional, System and UAT testing and reviewed with project management and business user’s team.
• Responsible to develop and maintain the user guides for UAT testing support.
• Manage resource allocation and task assignments for different data mart to the team members.
• Mentor junior test engineers to encourage best practices and thorough testing of the application.
• Responsible for exporting the Requirements and Test cases into Quality Center using excel add-in.
• Responsible for creating requirement traceability matrix (RTM) into Quality Center and generate the report to verify the test case vs. requirements coverage.
• Responsible for test cases execution and defect management using Quality Center.
• Developed and generated test progress and defect reports from Quality Center.
• Responsible for testing progress meeting and sending testing status reports to Project Management team and Development Team.
• Tested the various Service Oriented Architectures (SOAs) spanning across various departments using SOAP & WSDL using SOAP UI Pro.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity.
• Tested all OBIEE Dashboards according to the requirement.
• Validated the Security, navigation to a particular screen, dashboard, page, and report for OBIEE.
• Validate access for data, screens, dashboards, pages, and reports, response time to access the application, particular dashboard, page and report, capability on Reports for OBIEE.
• Validated if the summary reports are working from charts, tables, table headings, counts are matching between the summary and detail report where appropriate.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Used Quality Center for bug reporting. Tracked and reported the bugs with Quality center.
• Created Data base checkpoints and wrote SQL queries to validate the data
• Created and maintained shared object library, Functions, data sheet in Quality Center for QTP scripts
• Developed and implemented standard testing practices/approach to improve the testing process for manual and Automation Testing using Quality Center 10.0 and QTP 10.0
• Utilize defect tracking tool HP Quality Center to trace, assign, verify and close defects

Environment: SQL Developer, Oracle EPM 11.1.1 Web Client, ODI Release 10.1.3, Hyperion 8.5, Informix Client, Quality Center 10.0, QTP 10.0, MS office 2010, SQL Server 2008, JAVA, Visual Basic Scripts, SharePoint, Putty, WINSEP, Sub version (SVN), JIRA, WebServices, SOAPUI, XML

Confidential

Sr. QA Analyst/ Complience Tester

Responsibilities:

• Participate in requirements and functional specification reviews and walk through to ensure that the testability requirements are met
• Developed and maintain Functional, Integration, Security, Conversion and UAT Test Plans
• Developed process documents, users manual and defect loging process to support UAT testing
• Conducted test execution/status meeting with project stake holders
• Followed the standard procedures and templates to develop the test cases, developed the test cases to perform the compliance testing such as 508, 131 using JAWS and AccVerify
• Responsible for writing and executing the manual and automation test cases to perform accessibility testing on web application as per government compliance using tool JAWS, AccVerify, FireEye
• Supported UAT testing and created defect guide lines documents for users using Quality Center
• Created integration test scenarios and tested application areas developed on SOA architecture and WebServices
• Generated and distributed test progress and defect status reports to Management team
• Facilitated defect review meetings and improved existing defect management process, driven team to work in faster manner by reporting defects status
• Wrote and executed the Test cases for Web apps diagnostics, accessibility and compliant validation based on government defined process and procedure using the tools
• Utilized defect tracking tool HP Quality Center to trace, assign, verify and close defects

Environment: - .NET, Microsoft SQL Server 2008, SQL Server Management Studio, MS office 2007, Share Point, Subversion, Quality Center 9.6, J2EE, HTML, XML, VB Scripts, JAWS, AccVerify

Confidential, NJ

Sr. QA Analyst/ Tester

Responsibilities:

• Responsible for implementing and monitoring the QA on very initial stage of SDLC, involved in requirements gathering and analysis along with Business Analyst and SME’s.
• Developing and execution of test plans, test cases based on business requirements of the Application.
• Performed automated testing for Web Applications.
• Extensively used Quick Test Pro for functional and regression testing for automation of multiple modules in the environment.
• Tested compatibility of application with Internet Explorer 6.0, Netscape Navigator 5.0.
• Report defect found during test cycles and Track the defects and retest fixed programs Developed and customized Excel reports and graphs using Dashboard for reporting in QC.
• Define and develop standard testing approach and time lines based on given testing time frame.
• Wrote and execute SQL Queries to get testing data to validate BI reports.
• Develop, maintain and execute test automation scripts in QTP using visual basic, setup test data needed for scripts to run in different environments.
• Customize QTP, installed add-ins, develop function libraries, recovery scenarios and environment variables using QTP 8.0.
• Tracked, reported and follow-ups defects using Quality Center 9.0.0.

Environment: QTP 8.0, Quality Center 9.0, JIRA 6.0, TOAD, Oracle Client 11G, UNIX, ASP, VB scripts, TOAD 8.0, JDBC, Window NT, SQL, Business Object 6.0