PROFESSIONAL SUMMARY

• 8+ years of experience as a QA Analyst with primary focus on Quality Assurance, Functionality and Systems Integration testing on web - based, client-server and mainframes with 2 years experience as a Business Analyst
• Hands on experience in requirements gathering, analysis, detailed requirements design (Cases, user interfaces, report specifications, system to System interfaces), workflow design, functional (Application) testing, creation of test conditions and test scripts.
• Proficient in using Manual testing tools such as HP Quality Center and IBM Rational Quality Manager
• Extensive knowledge of Software Development Life Cycle (SDLC) including Waterfall Methodology, Rational Unified Process and Agile Methodology.
• Strong testing Quality Assurance experience within Agile environment
• Functional Knowledge on capital market, financial, banking and mortgage domain
• Experience in writing Detail ETL Test Plan, Test Cases and Test scripts.
• Experience in writing test scenarios and test cases, developing and maintaining test scripts based on business and functional requirements and documenting all phases of QA process.
• Strong hands on experience with all levels of testing including Smoke testing, Integrated System testing, Regression testing and User Acceptance testing (UAT).
• Hands on experience in handling and processing ETL application with extensive knowledge of Testing and Validating Data Warehouse.
• Experience in Business Intelligence testing in various reports using Business Objects and Crystal Reports
• Manually tested the Application by writing SQL queries using TOAD.
• Used SQL commands to validate the database and test its integration with the front end.
• Work closely with cross-functional teams to thoroughly test requirements and functionality.
• Participated in ETLdesign and ETLdevelopment and Involved in testing source systems and ETLapplications.
• Mainframe manual Systems Integration Testing of post implementation production defects and application change requests
• Proficient in querying various RDMS like Oracle, Teradata, DB2 and SQL server.
• Adept at backend testing and data validation testing using SQL queries
• Analyzed change requests to determine potential upstream/downstream, impacts, estimated task efforts, and performed root cause analysis of application problems
• Extensive use of Defect tracking tool HP Quality Center and IBM Rational Quality Manager
• Strong understanding of user acceptance testing protocols and methodologies
• Organized, detail-oriented and have the ability to work well in a time sensitive environment.
• Excellent team member with problem-solving and trouble-shooting skills and have the ability to adapt quickly to new environments and technologies.
• Excellent Communication and Documentation Skills.
• Ability to understand & analyze business processes & workflows with the objective of providing recommendations for the best use of technology to improve these.
• Create, design, and format requirement specification documentation including process flows, and other information or processes needed to describe required system changes for development and QA for downstream customers

TECHNICAL SKILLS

Operating Systems: Win2000/7/NT/XP/Vista/7/8/10, MS-DOS, WinSCP, Putty

Browsers: IE7/9, Mozilla Firefox 3/3.5/4.0, Safari 2.0,Google Chrome

Languages: C++, SQL

Databases: Oracle 10g/11g,MS SQL Server2008, T-SQL, Teradata 14, SQL Plus, Mainframe Version 6 for windows

Web Servers: Apache HTTP Server, Apache Tomcat

Web Services: WSDL, XML, XSD, Soap Requests/Responses

Testing Tools: IBM Rational Quality Manager, Quality Center 9.5/10.0/11.0/11.52,Green Hat 5.2, SOAPUI 3.5, SSIS, PTC integrity 10

Reporting Tools: SAP Business Objects BI Platform 4.2, Crystal report 2016,SSRS, ShowCase 9.1.0.9

PROFESSIONAL EXPERIENCE

Confidential, Rogers AR

Sr. Software QC Analyst

Responsibilities:

• Developed test plans and test case including documentation of test procedures and test results using Quality center.
• Continually adapted the enhancements and change requests to redefine the testing scope.
• Performed data analysis, identified data dependencies within the source systems to create test sets
• Converted requirements into the resultant test scenarios. Wrote structured and reusable test cases and test scripts. Created QA traceability matrix and test impact analysis documentation
• Participated in requirement analysis and QA reviews. Worked with the business and development teams and cross functional program team during the requirement phase and design phase to identify functional compatibilities and software issues early in the QA process
• Identify, created and maintained appropriate test data bed with valid and invalid data to thoroughly test program logic and verify system flow
• Verified data consistency across multiple platforms and databases.
• Performed data validation and mainframe testing in interactive mainframe environment
• Responsible for executing and maintaining scripts in mainframe application
• Tested user stories in Agile Framework and participated in daily scrum meetings
• Designed developed and implemented user acceptance testing protocols as the final phase of applications development
• Participated and involved in maintaining the backlog for the team, analyzed and provided the needed information like test data, environments for testing at different stages in advance and believed in pair concept, to have the knowledge evenly across the agile test team
• Analyzing, estimating and sizing the User Stories which will help Product Owners to prioritize the Story Cards.
• Conducted end-to-end integration testing and assured software delivered met requirements and expectations
• Delivered UAT documentation to the BA to make recommendations on changes to the applications
• Maintained a log of number of data tested, number of passes, number of fails, number of defects identified, type of defects and the severity and frequency of every defects.

Environment: Mainframe- iSeries Access for Windows version 6, Windows 10

Confidential

Sr. Report QA Engineer

Responsibilities:

• Worked closely with Business Leads and SME's to understand requirements.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Validated reports based on Functional Requirements
• Involved in report testing-Statement, Notices and Forms
• Validated extract files and internal reports, statements and notices against the database
• Extensively worked with backend activities for testing several reports data
• Planned, designed, implemented, executed and evaluated test scenarios to test the system functionality
• Extensively tested several Business Objects Reports - Crystal’s reports and Dashboards to validate the reports the data and cosmetics of the report.
• Wrote Test Plans and Test Cases into IBM Rational Quality Manager tool for Functional and Regression Testing.
• Executed test cases and procedures for Functionality Testing, Integration Testing, Positive Testing, Negative Testing, Black box testing and UAT testing
• Involved in Database testing by writing & executing SQL queries to validate that data is being populated in an appropriate tables and manually comparing the results with front-end values
• Reconciled data between source and target tables. Performed validation of target populations for data consistency and accuracy. Conducted process and data level checks to ensure data integrity and that the client-specific business rules are applied correctly.
• Did extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
• Analyzed the data extracts from Legacy Systems. Interacted with the Technical Analyst to determine the element source, format and its integrity within the system.
• Performed BI Report Testing by writing SQL queries to validate the data on the report and compare with the DWH data
• Reviewed source to target mapping, identified data dependencies and created test data sets.
• Worked with development team to create a suite of test data that fully exercised data validation (detecting and rejecting bad data)
• Analyzed requirement, design documents ad applications to define the testing needs across a complex array of system and data structure
• Reporting the bugs followed whole bug life cycle and prepared Test Status Reports during Test execution processes and regularly communicated with the developers to fix defects.
• Onsite offshore coordination.
• Manage the Test strategy, Program Management plan, identify the inter dependencies and to ensure that risks issues are highlighted and get it resolved
• Evaluated, documented and communicated issues using Rational. Tracked and validated the resolved defects. Created detail test execution reports and analyzed, interpreted and summarize the data into higher level reports and charts and prepared daily test status reports to communicate the test status with the team
• Program level Reporting on the weekly testing status
• Worked with Business, Product Leads, Product Development team, other testing teams closely to ensure smooth project deliveries
• Conducted user acceptance testing to ensure that developed systems satisfied the needs of business clients as specified in the functional requirements
• Created project related metrics, Team efficiency reporting
• Accomplishment and management of Execution tasks.

Environment: Windows 7, Oracle SQL developer, WinSCP, Putty, XNet, FileNet Web Client

Confidential, Atlanta GA

Sr. QA Analyst

Responsibilities:

• Participated in the review and analysis of business requirements, functional specification and design documentsto ensure testability
• Performed manual testing in Agile (Scrum), actively involved in creation of detailed test plans, test cases and test scenarios for different application modules according to functional requirements and business specifications.
• Developed manual test cases inQC/ALM reflecting user needs for the functional, regression, UAT, Integration
• Managed test case development and execution usingQC/ALM
• Responsible for Analysis and Defect Tracking using HP ALM
• Detected and documented defects. Rested software correction to ensure problems are resolved
• Created RTM to match requirements and design specifications, also to show coverage of each testable requirement Performed Regression testing, Smoke Testing, Functional Testing, Integration Testing, GUI Testing.
• Performed Back end Testing-using SQL queries to ensure data integrity and validate the data.
• Worked closely with the application development and design and testing team to resolve technical issues to ensure overall quality of the software.
• Participate in planning, review meetings to resolve different problems in different environment.
• Reviewed business requirement, process flow and data models to grasp the input data sources, how business rules are applied to data and how data is represented externally.

Environment: MS SQL Server, JAVA, Windows, MS Office

Confidential, Charlotte, NC

ETL QA Tester

Responsibilities:

• Analyzed Business Requirements and Identified documents required for system and functional testing efforts for all test scenarios.
• Currently usingPL-SQLfor querying against source and target database objects.
• Conducted review of executed test scripts to ensure quality standards.
• Designed test cases for browser compatibility testing browsers- IE8, Safari, Chrome and Firefox
• Performed DB Testing by using SQL's to validate the Front-End, Backend process compatibilities.
• Validate the Front End OBIEE/ SSRS Reports with the backend
• Building complex SQL statements involving all join variants to enable them to make robust comparisons of source versus target data loaded by the ETL. Querying against source and target Database objects.
• Utilizing technical/functional knowledge of applications to provide assistance in identifying, evaluating, and resolving moderately complex test problems. Documents all phases of the QA process.
• Working with business and development partners to create detailed test plans and validation strategies.
• Identify and document defects in a defect tracking system i.e. ALM and manage issues/defects through resolution.
• Involved in planning, testing, and production certification of software applications in a multi-Operating System and network environment, creating test strategy, test plans and test cases for application testing.
• Performing on moderately-complex to complex test data conditioning, regression testing and testing validation.
• Coordinated and participated in end-to-end testing activities with numerous interfacing partners and SORs, hands-on-testing, and monitor/track to resolution application defects.
• Working with business and development partners to establish and maintain a consistent approach in the execution of the Wholesale QA process.
• Created, prepared, and conducted quality assurance reviews and develops test plans and manual test scripts.
• Provided communication and statuses to QA Lead and project stakeholders.
• Ensured software requirements are verifiable and quantifiable with the ability to build test cases.
• Contributing efficiently and effectively in program and system solutions in solving medium-complex business problems.
• Handled more than one project with changing priorities with a strong sense of urgency.
• Worked on front end testing, including writing front-end test cases, execution with backend validation and UAT testing

Environment: Windows 7, Oracle SQL developer, J2EE

Confidential & Co; Minneapolis, MN

QA Engineer

Responsibilities:

• Performed web services testing by validating XML request/response data using Green Hat Tester.
• Analyzed functional specification document for different operations
• Review XSD document for several operations in XML Spy.
• Discuss review comments for FSD with development teams for the designated operations
• Identify test data required for operation and discuss with development team for all question of test data requirement
• Identification of test scenarios based on valid, multiple valid, invalid and structural invalid circumstances
• Entered test data for each scenario and reviewed the test scenarios identified in excel
• Uploaded test scenarios in QC.
• Created a testing environment, WSDL and http connection in GH tester.
• Created test scripts in GH for each test
• Execute test script in SIT environment
• Wrote SQL queries such as aggregate functions and select statements to test the application for data integrity.

Environment: Windows 7, Web Services, Oracle SQL developer, J2EE, XML

Confidential ; Los Angeles, CA

Business Analyst/Test Engineer

Responsibilities:

• Participated in requirement review meeting
• Interacting with the client for requirement gathering, designing and reporting
• Creating Change Request Documents.
• Data Element Mapping and creating of Business Rules.
• Clarify and document issues raised during the process of data and system model validation, analyzed and propose changes in valuation methodology to make it precise and transparent
• Created test cases for various interfaces based on Business Requirement Documents and System Specification documents
• Performed functional testing, integration testing, regression testing, and system testing before signing off for UAT
• Created and maintained Requirement Traceability Matrix in Quality Center to ensure maximum test coverage
• Analyzed functional specification and created test cases and test plans as per user requirement in Quality Center.
• Responsible for updating and maintaining Quality Center for all the defects found during the functional and regression testing and follow up the bug life cycle.
• Executed regression testing for every modification in the application & new builds using QC
• Extensively worked on handling the application response for Positive and Negative set of data through data driven testing in QC
• Performed Sanity and Smoke Testing of the application manually after each build.
• Perform Backend testing by extensively using complex SQL queries to verify the integrity of the database.
• Manually test each and every module of the application and verify against expected results.
• Participated in the weekly team and project meetings
• Created and executed SQL queries like joins and sub query to fetch data from an SQL Server database server tovalidate and compare expected results with those actually obtained.
• Attended meetings to update status and worked closely with QA manager.

Environment: Windows 7, SQL Server 2008, SQL, J2EE, XML, Oracle 11g

Confidential ; Las Vegas, NV

QA Engineer/ Business Analyst

Responsibilities:

• Bridging the gap in domain understanding between the client and technical team. Coordinating with the stake holders to translate the business requirements into actual project plan
• Interfaced with business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR)
• Create, design, and format requirement specification documentation including process flows, and other information or processes needed to describe required system changes for development and QA for downstream customers
• Analyzed Functional Requirement Documents and Use Case to create Test Plan and Test Cases
• Performed Functionality Testing on Bill Direct Module
• Manually executed test plans and test cases in Quality Center to verify actual results against expected result
• Exported test cases created in Excel sheet to Quality Center.
• Created and executed Test Scripts for Smoke and Regression Testing
• Tested Service Oriented Architecture application using SOAPUI
• Validated Web services usingSOAP by testing XML request and response data communicating with SOAP.
• Created Test Sets to do Functional and Data Driven Testing on the Web Services using SOAPUI tool
• Conducted regression testing using testrunner in SOAPUI.
• Inserted Assertions such as SOAP Fault and NOT contains on the Test Cases to validate the XML SOAP response.
• Performed quality assurance validation with data sets in SQL Management Studio
• Active participation in regular status meetings and defect meetings
• Work with developers, project managers, operations and tech support to achieve project goals timely and effectively.

Environment: Windows 7, SOA, Web Services, WSDL, SQL Server 2008, SQL

Confidential ; Aurora, CO

QA Engineer

Responsibilities:

• Developed test plan and test cases based on the use case document and worked with business and technology team for the same.
• Performed Smoke Testing, Integration and usability testing on the website.
• Maintained project folder structures in Quality Center
• Used Quality Center to manage testing and track test results for each build and report defects detected.
• Analyzing Test Results for each script.
• Client call interaction
• Preparing the test summary report
• Created bug reports by coordinating with software testers and developers
• Performed first level system testing by coordinating with QA team and business analyst
• Performed back-end testing by extensively using SQL commands to verify the database integrity.
• Executed DDL and DML queries to manipulate and validate the database
• Supported Senior QA analyst manual tester in the development and execution of QA continuous process
• Maintaining and tracking major milestones and deliverables during software life cycle management.
• Documenting the daily work for reporting to QA Lead.
• Manually Conducted Positive and Negative testing.

Environment: Windows XP, SQL Server 2008