SUMMARY:

• More than 12 years of experience in IT industry all of which is in Quality Assurance expediting Manual and Automation testing with around 5 years of lead experience. Test execution, Defect Management and support in all facets of Data Warehouse and Automation testing Lifecycle.
• Professional expertise includes project estimation, Requirement Analysis, Test Strategy/Test Plan preparation, Test design, and Business scenario preparation for data analysis. Test execution, Defect Management and support in all facets of Data Warehouse and Automation testing Lifecycle.
• Hands on experience in Functional Testing, Integration testing, Regression testing, System testing, end - to-end Testing, Database Testing and User Acceptance testing
• Domain Knowledge in Credit Risk, Financial Commercial/Retail, Home Mortgage, Financial Crimes (Anti Money Laundering), Small Business Banking, Utilities, Insurance, and Pharmacy.
• Expertise on Selenium Automation using WebDriver. Programming using Java, JUnit, and TestNG frameworks.
• In-Depth knowledge of Software Testing Life Cycle
• Complete understanding of Testing Methodology, Strategy and Testing Process
• Experience in testing Siebel CRM, UCM/ MDM Implementation integrated with legacy system for loan system and Credit Approval
• Experience in building automation for Continuous Integration and Continuous Delivery
• Experience leading teams with minimum 2 members to maximum 14 members.
• Experience in working for RFPs
• Experience working as a Testing Lead having Mortgage experience of 2 years and Loan Origination experience of 5 years.
• Good Expertise in VB Script and Automation Infrastructure Development.
• Expertise in Using of QTP/UFT Integrated Environment (Step Generator, Synchronization, Actions, Recovery Scenarios and Methods etc.).
• Experience in Descriptive Programming using QTP/UFT.
• Proficient in developing Use Case, performing change request and change management.
• Developed and implemented test plans for complex projects
• Extensive experience in conducting project meetings including Test and Defect review meetings.
• Implemented process related activities (SQA) in the projects
• Experience in Effort estimations using different techniques
• Proficient in working with Onsite-Offshore Delivery model with direct client interaction.
• Experience with integration testing of the applications using various sources like flat files, Sybase and oracle databases.
• Experience in debugging the issues.
• Proficient in working with UNIX using putty Environment.
• Experience working with SDLC, Agile (Scrum) and Waterfall methodologies
• Hands on experience in Agile projects, and hands on experience on VersionOne Agile tool
• Expertise in Defect Management tools - ALM, HP Quality Center, IBM Clear Quest, JIRA and MTM(TFS)
• Educating testing team members on testing industry best practices
• Efficient in interacting with project stakeholders, business, development and management teams.
• Strong analytical skills with excellent interpersonal and communication skills.
• Highly motivated resourceful team player with a positive approach to problem resolution.

TECHNICAL SKILLS:

Operating Systems: Windows 7, Windows XP, UNIX

Database: SQL Server 2008, Oracle 11g/10g, Teradata, Sybase 11.0.

Languages: SQL, PL/SQL, VB Script, C, Java

Database Utilities: TOAD 8.0/7.1, SQL*Plus, SQL Developer, Teradata SQL Assistant.

Data Warehouse Tools: Informatica, Ab Initio

Reporting/Dashboard Tools: OBIEE/BIP

Defect Management tools: HP Quality Center/ALM, IBM Clear Quest, JIRA, TFS

Testing Tools: QTP/UFT, Selenium IDE, Selenium RC, Selenium Remote Control, Selenium Web Driver 2.0, Junit, Test NG, Jenkins, Maven, GIT, GITHUB, Selenium GRID, Cucumber

Other tools: Version ONE, WinScp, Putty, MS Office, MS Visio, SOAP UI

Methodologies: Agile, Scrum, SDLC, Waterfall

ERP: SAP, SAP-TAO, Siebel CRM, SAP CRM

Architecture: SOA

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

QA Lead

Responsibilities:

• Testing of new business process flows in new LOS.
• Requirement analysis for the Implementation of New Loan Originations Platform Empower for Direct, Retail and Lending Space for Correspondent channels
• Ensuring the extracts generated are aligned with the defined format lengths specified in Functional Specification Documents
• Designed Tests Using keyword Driven Methodology for selected areas using QTP/UFT.
• Counts check of the record returned are aligned with the filter criteria (extraction logic) defined in Functional Specification Document
• Ensuring data is accurately returned as per defined in Functional Specification Document using wiring complete queries including SQL Joins.
• Working with the Stakeholders to customize the requirements for new Loan Origination Systems that the Confidential is implementing from other third party vendors.
• Coordinating on various tasks with stakeholders, and getting the work done from Business Analysts, project stake holders.
• Working on creation of various projects artifacts as part of the software lifecycle development
• Testing thoroughly on on mapping the data attributes of existing and new Loan Origination systems for Servicing system.
• Perform functional testing of the new Loan Origination System and assists the Fifth Third resources for User Acceptance Testing
• Working with the senior leadership on business architecture

Environment: Windows - 7, Oracle10g/11g, SQL Server 4.0.3.16, SQL, XML, HTML, QC/ALM 11.0, MS Word, Excel, Business Objects (BO Universe), EDW, PowerPoint, Outlook, MS Visio, MS Project, SharePoint, Jenkins, Maven, Selenium WebDriver, Selenium GRID.

Confidential, Charlotte, NC

QA Lead

Responsibilities:

• Automating the test cases using Hybrid Framework in QTP/UFT
• Maintaining the Business Components and updating the Components as and when required
• Regular Maintenance of Regression automation Scripts
• Developed the automation test scripts using page object model in Selenium Web Driver and Maven
• Leveraged TestNG Framework, and Page Object Model while scripting using Selenium
• Understanding Business Requirement and FSD Documents.
• Daily interaction with offshore team, Business Stakeholders, Project Managers, Business Analysts on projects Day to Day activities
• Estimating the effort needed to design and execute the task.
• Contributing to Test Plan document and design Test Scenarios, Test Cases to validate data.
• Ensure that the Test Coverage is appropriate and meets the Requirement of the project.
• Involved in Project Meetings, Reviews and Team meetings.
• Involved in reviewing of test scenarios and test scripts.
• Expertise in writing simple to complex queries to validate the data and Table structures in both MIDE and MODE platforms.
• Expertise in table checks in database after load of different SORs data in to MIDE and MODE.
• Expertise in preparing Validation summary report and test reports.
• Prepare status summary reports with details of executed, passed and failed test cases and sending this Report to stake holders.
• Communicating with other team members like Development Team, Technical Support, Business Analyst in order to resolve the issues.
• Striving to provide quality work on time.
• Giving the KT to the new team members.

Environment: Windows - 7, Oracle10g/11g, SQL Developer 4.0.3.16, SQL, XML, HTML, QC/ALM 11.0, TFS, MS Word, Excel, PowerPoint, Outlook, MS Visio, MS Project, SharePoint, Jenkins, Maven, Selenium WebDriver, Selenium GRID.

Confidential, Charlotte, NC

Senior QA Analyst

Responsibilities:

• Back-End Testing/Database Testing specifically in developing and executing SQL queries to interact with databases.
• Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
• Performed data quality analysis using advanced SQL skills.
• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Conducted Functional testing, Regression testing, and User Acceptance Testing (UAT) and Data validation testing.
• Used Joins like Inner Join, Outer joins while testing from multiple tables.
• Extensive SQL querying on Staging, Data warehouse, and DataMarts.
• Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Effectively communicating Defects to Development Team
• Proactively getting Source Files for Testing from Business Team, and ensuring Files available in SharePoint.
• Tracking the Defects on day to day basis and generating Defect Reports/Test Summary Reports in QC/ALM

Environment: Windows - 7, Oracle10g/11g, SQL Developer 4.0.3.16, SQL, Informatica, QC/ALM 11.0, TFS, JIRA, QTP/UFT, XML, HTML, SSRS, QC/ALM 11.0, MS Word, Excel, PowerPoint, Outlook, MS Visio, MS Project, SharePoint, Selenium WebDriver, Selenium GRID, MS Word, Excel, PowerPoint, Outlook, MS Visio, MS Project.

Confidential, Tampa, FL

Sr. QA Lead and Analyst

Responsibilities:

• Preparation of Test Approach, and Test Plan
• Estimating the project and submitting Feasibility Estimates, Business Case Estimates
• Preparation of high level Scenarios
• Developed the automation test scripts using page object model in Selenium Web Driver and Maven
• Automated Test Scripts using Cucumber FrameWork
• Providing walk through on Test Approach and Test cases to the stakeholders
• Providing Daily Status Reports and Weekly Status Reports on the projects
• Providing health status on the projects to the Senior Management
• Review of Requirement Documents
• Review of Test Deliverables from team before sharing with the stakeholders
• Coordination with Developers, Business Analysts, and product owners
• Preparation of Project Status Reports/Test Metrics to senior management
• Resolving team clarifications by contacting SMEs on the projects
• Preparation of Test Methodology, Assessment of Functional and Business Requirements
• Preparation of Test Approach, and Test Plan
• Preparation of high level Scenarios
• Providing walk through on Test Approach and Test cases to the stakeholders
• Construct SQL queries with joins, indexes, temporary tables, analytical functions, and Sub Queries linking by Unions, Intersection, and Minus operators
• Database testing to verify data synchronization.
• Involved with ETL test data creation for all the ETL mapping rules.
• Validation of Schema Structure of Tables to be aligned with defined Mapping Document, and Data Models Defect Management using ALM/HP Quality Center and ClearQuest
• Schedule and monitor the test cases execution
• Performed the tests in both the SIT, UAT, and contingency/backup environments
• Worked with ETL group for understating for data loading for both dimensions and facts.
• Worked on issues with migration from development to testing.
• Involved in testing web services of the application using an Open source SoapUI Tool
• Performed SOA / Web Service testing using SoapUI
• Involved in creating the design and technical specifications for the ETL process of the project.
• Prepared extensive set of validation test cases to verify the data
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Scheduling triage meetings to keep track and level of severity defects and communicating it Project Managers with Execution Score Card with defect Status
• Providing Daily Status Reports and Weekly Status Reports on the projects
• Worked closely with Business teams, Anti Money Laundering teams for requirements streamline
• Following Testing Standards, Guidelines, and Testing Methodology as documented in Service Level Agreement
• Managing Defect Review meetings, and explaining the stakeholders defect logged in Quality Center/Clear Quest
• Tracking the Defects on day to day basis and generating Defect Reports
• Identify requirement gaps, conduct meetings and report status to the senior management.
• Developed the automation test scripts using page object model in Selenium Web Driver and Maven
• Leveraged TestNG Framework, and Page Object Model while scripting using Selenium
• Review of Test Deliverables from team before sharing with the stakeholders
• Coordination with Developers, Business Analysts, and product owners
• Preparation of Project Status Reports/Test Metrics to senior management
• Resolving team clarifications by contacting SMEs on the projects
• Involved in Batch processing using CICS
• To get Sign off from business on System testing & Integration Testing
• Create reports (daily status reports and weekly reports) and create testing metrics as requested by senior Management.

Environment: HP Quality Center/ALM, Informatica, SQL Server 2008, Toad, Oracle 10g, AQT, Sybase 11.0, Clear Quest, HPPM, Windows XP/Windows 7, Selenium 2.44, XPath Finder, .NET, J2EE, QTP/UFT, SQL, HTML, XML, SOAPUI, Jenkins, Maven, GIT, GITHUB, Selenium GRID, Cucumber, MS Word, Excel, PowerPoint, Outlook, MS Visio, MS Project, SharePoint.

Confidential, Richmond, VA

QA Lead and Analyst

Responsibilities:

• As a QA Lead and Analyst led a team of 8 members offshore and 4 members onsite
• Automating the test cases using Hybrid Framework in QTP/UFT
• Maintaining the Business Components and updating the Components as and when required
• Regular Maintenance of Regression Automation Scripts
• Given demoes on Selenium tool to the project team
• Creation of test strategy, test plan and test cases.
• Conduct scrum meetings, establish timelines and schedule resources for testing across all the builds.
• Identify requirement gaps, conduct meetings and report status to the senior management.
• Involved in Analysis of Database Business (BRD) and functional (FSD) Requirements
• Analyzing Mapping Transformations, and Rules associated in the Mapping Document
• Worked with Program Managers, Requirement Analysts, Mappers, Developers, and other testers to resolve issues with requirements/mapping transformations
• Validation of counts between Source to Stage, and Stage to Target
• Validation of Schema Structure of Tables to be aligned with defined Mapping Document
• Validation of all fields of the Tables using SQL Queries
• Ensuring new Records Loaded into the Tables by writing Minus Query
• Validation of all fields migrated from Source to Stage by Comparing the Data
• Validation of all fields migrated from Stage to Target by Comparing the Data
• Validated request/response data using SOAPUI.
• Involved in Data Extraction from Flat Files.
• Created Test Plans and test scripts, executed test scripts, and Test Report generation
• Perform back-end testing using TOAD/SQL Developer tool.
• Conduct End-End Integration testing and support UAT testing.
• Defect Management using ALM/HP Quality Center
• Worked on a Business Intelligence reporting system that was primarily functioning on Oracle Applications OLTP environment with Business Objects for Business Intelligence reporting
• Involved with ETL test data creation for all the ETL mapping rules.
• Performed Regression testing of the fixed issues in the new build until no new issues are identified.
• Autosys is used in automated job control system for scheduling, monitoring, and reporting
• Preparing and supporting the QA and UAT test environments.
• Preparation of Test Methodology, Assessment of Functional and Business Requirements
• To get Sign off from business on System testing & Integration Testing
• Create reports (daily status reports and weekly reports) and create testing metrics as requested by senior Management.
• Following testing standards, guidelines, and testing methodology as documented in Service Level Agreement (SLAs)
• Involved in writing the Automation Scripts using Selenium and Web Driver.
• Leveraged Junit Framework scripting in Selenium
• Managing Defect Review meetings, and explaining the stakeholders defect logged in Quality Center
• Tracking the Defects on day to day basis and generating Defect Reports

Environment: HP QC 11/ALM, Ab Initio, SQL Developer, Toad, Oracle 10g, VersionOne, Selenium RC/WebDriver, QTP/UFT, Hybrid Framework, Selenium, .NET, J2EE, Siebel SRM, Siebel UCM, SQL Developer, TOAD SQL, Windows XP/Windows 7, SOAP UI, Service Oriented Architecture, ClearQuest, JIRA, MS Word, Excel, PowerPoint, Outlook, MS Visio, MS Project, OBIEE, SharePoint.

Confidential, San Clemente, CA

Module Lead/ QA Analyst

Responsibilities:

• As a Module Lead, led a team of 2 members onsite
• Preparation of System Integration Testing Strategy
• Preparation of test cases based on the Business Requirements
• Analysis of Change Requests and minor enhancements
• Created automated Selenium scripts using Selenium IDE
• Tested key integration points between Siebel Call Center and legacy systems
• Creation of Test Scenarios, Test Scripts, Reporting and Defect management
• As a Siebel SME, was responsible for creating Siebel Workflows
• Trained and coordinated with offshore team
• Responded to RFPs
• Responsible for identifying test data
• Responsible for Tracking Defects in Quality Center
• Provided with a detailed Sign off report after every testing cycle
• Monitored the Performance of web and application servers

Environment: Quality Center 10, SQL, TOAD, Windows XP, Siebel, Selenium IDE

Confidential, Houston, TX

QA Lead and Analyst

Responsibilities:

• As a QA Lead, lead a team of 8 members offshore. This was an offshore project.
• Coordinate with Application and project managers to schedule testing activities for their teams.
• Maintenance of Business Components that are generated using SAP TAO
• Leveraged SAP TAO Framework and generated Business Components
• Modifying Business Components based on new functionality, and make up to date
• Review of Automation Scripts generated by the team using BPT Approach, SAP TAO, QTP
• Optimising and Re-using the Business Components on various test scripts
• Coordinating with Client and Offshore coordination
• Handling Defect Review Meetings
• Scripting & execution
• Test Report with detail analysis and Sign off

Environment: Quality Center 9.2, QTP, SAP TAO FrameWork, MS Excel, MS Project, Windows XP, Siebel

Confidential, Durham, NC

QA Analyst / Lead

Responsibilities:

• Lead a team 6 members
• Review the Requirements in the Business Requirements document and provide feedback to the Business Analysts.
• Responsible for mapping requirements to the Test Cases using the Requirements Coverage functionality in Quality Center.
• Responsible for creating different Testing Metric Reports in the Dashboard Module of Quality Center.
• Extensively tested Siebel Screens, Views, Applets, MVGs, Pick Lists, Siebel Analytics reports for its Format
• Responsible for testing different modules such as Order Management, Order Fulfillment, Cash Management, Installation Management, Flex Finance, and Customer Service Drivers as defined

Environment: Quality Center 8.2, .NET, J2EE, SQL, Oracle, Windows XP, Siebel

Confidential, Exeter, NH

Automation Tester/QA

Responsibilities:

• Involve in Test planning, Test Case Design, Execution, Defect Tracking, Metrics and Status reporting.
• Test case design
• Test Script Generation using QTP 8.2
• Review Test case designs, Test data creation.
• Involved in Test execution, Defect Logging and Failure Analysis.
• Maintain effective Onsite-Offshore Coordination.
• Involved in Daily Defect Review Meetings with client.

Environment: Quality Center 8.2, J2EE, SQL, Oracle, Windows XP, Guidewire, QTP

Confidential

Automation Tester/QA

Responsibilities:

• Develop Test Strategy, Test Plan and Test cases for the entire application.
• Perform both Manual and Automated Testing at appropriate stages of the application build.
• Based on Business and System Requirements, Created Test Scenarios
• Implemented Business Components Approach using HP Quality Center for creating test cases
• Involved in System Testing & System Integration Testing
• Identified Regression suite and updated the test cases after every release
• Involved in the Integration Testing, System Testing, UAT Testing, Regression Testing
• Responsible for identifying test data for each phase of testing
• Performed Smoke Test and Sanity Test
• Responsible for Tracking Defects in Quality Center

Environment: J2EE, TestDirector, Quality Center, QTP 8.0/8.2