SUMMARY:

• Ten (10+) years of experience in Healthcare, Financial, Telecom and Insurance domains performing ETL Testing, Mobile testing, STB testing, Automation testing (UFT, Selenium, & Worksoft Certify), MicroStrategy BI Testing and Data Validation, CRM (Salesforce) testing & SAP TAO testing
• Experience of working in Agile Methodology (Scrum model)
• Experience in mobile app testing for multiple set top box devices, native app, web - based app on iOS, Android and windows platform.
• Experience in Selenium automation using Java & Python in Healthcare (Medicare) domain
• Automated highly transactional e-commerce web application using Selenium WebDriver.
• Implemented Page Objects, Data Driven, Keyword Driven, Hybrid automation frameworks using Selenium WebDriver, JAVA, JUnit
• 5 years of recent experience in leading/managing software QA or development teams; test estimation and reporting test metrics
• Expertise in writing SQL Queries using Oracle, SQL Server and Teradata in validating data into Data Warehouse/ETL applications.
• ETL testing experience using Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• Hands on experience in Automation, ETL System Migration testing, Functional, System/Regression testing and unit testing with JUnit
• Experience in testing MicroStrategy reports along with the data validation for the reports
• Strong experience on database query tools such as TOAD, Aginity Netezza and SQL Plus.
• Analyzing bugs, interacting with QA/Dev teams in fixing errors
• Expert in Test plan, Test strategy, Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Implemented various Test cases for the Functional Testing, smoke testing, re-testing, Regression Testing, Configuration Testing, Performance Testing, Back-End and User Acceptance testing (UAT)
• Effective collaboration with Developers, AGILE Team, Project Management to achieve Selenium automation, high quality, release deadlines and QA processes improvements
• Developed VB Macros and other utilities to save time in performing daily smoke testing, sanity, production and UAT testing which resulted in better ROI for the project

TECHNICAL SKILLS:

RDBMS: Teradata V14.x, Oracle 9i SQL, MS Access 2003, MSSQL Server & Netezza

ETL Tools: Informatica 9.5, Aginity Netezza Workbench, SSIS

Operating Systems: LINUX, Windows OS 7/XP and Windows Server 2008 R2/2012 R2

Change Management: HP Quality Center, JIRA

SDLC Methodologies: Waterfall, Agile

Scripting Languages: VB Script, Python

Automation Testing Tools: Selenium WebDriver/RC/Grid, Cucumber, Maven, HP UFT 11.0, LoadRunner

Bug Tracking Tools: JIRA, BugZilla, HP Quality Center 11.0

Programming Languages: Java, C, C++ & SQL

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, CT

ETL/Automation Test Engineer

Roles & Responsibilities:

• Review test plan requirements simple to high complexity and develop an automation strategy
• Review manual and automation team work (UFT and Selenium tools) and suggest best practices and process improvements along with resource mentoring
• Actively participate in walk-through, inspection, review and user group meetings for quality assurance
• Define strategy for collecting reporting results and develop virtualizations, charts and reports from the data
• Understand and perform risk mitigation to meet deadlines. Create automation test plan, estimations and test schedule, write and execute scripts and report and fix defects in automation suites
• Create daily/Weekly status reports for stakeholder and identify risks & issues and provide mitigation plans

Environment: /Tools: HP UFT 12.5 & ALM, VB Script, .NET, VS.Net & Selenium

Confidential, Charlotte, NC

ETL/Automation Test Engineer

Roles & Responsibilities:

• Work with business partners, systems analyst, designers and programmers to create/analyze required project documents and ensures that quality assurance processes are incorporated
• Worked in an Agile Environment with stringent timelines, Offshore Lead responsibilities varying from Requirement gathering to test sign-off for the complete Flow of the Module.
• Actively participate in walk-through, inspection, review and user group meetings for quality assurance
• Plan, document, evaluate and track testing results with Traceability Matrix to ensure system applications are free from defects
• Participated in project planning, release, Defect Meetings & daily stand up meetings. Developed QA methodologies, test design & strategy, test data
• Managed/coordinated/supported offshore resources and transferring knowledge to/ monitoring of QA team members.
• Experience testing customer facing and Ad hoc MSTR reports.
• Focused on Data Quality issues/problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Involved in maintaining the test environments, like requesting data loads, data base backups, requesting the deployments, troubleshooting issues for QA team.
• Coordinating with source system owners, day-to-day ETL progress monitoring and maintenance of daily batch schedule run on a nightly basis.
• Participated in weekly Test Status meetings to discuss Test Deliverables, Milestones, and Project-Level Issues & Risks
• Involved in getting final signoffs from client & business Managers
• Developed VB macros and utilities to automation manual testing spent on DB testing, reports testing spent on the application.

Environment: /Tools: IBM Aginity Netezza Workbench 4.1, MS Excel for VB macros, IBM MSTR, HP Quality Center 10.0, QTP

Confidential

Sr. QA Analyst

Roles & Responsibilities:

• Performed compatibility testing and cross-browser testing for the stb testing efforts and reported the analysis with the snapshots.
• Involved in testing migration of Coffee (Ordering System Tool) module from desktop application to web applications, mobile versions on the tablets facilitating Data, Video, Fios TV, FDV, HSI and Voice ordering services
• Involved in testing the mobile and set top box testing with Appium.
• Validate existing order Due date and propose recommendations on the future billing plans and cheaper bundle plans to retain customer base.
• Performed STB testing on various iOS and Android on different CDMA, GSM devices and tablets.
• Validation against PSTN and FIOS bundles against the customer address and location criteria.
• Validating backend validation for pending completed and cancelled orders from legacy desktop to web-based application through MS SQL Server database.
• Developing Integration Test strategy and Test Plans for the Voice Video TV bundle ordering system with respect to BQT (Bundle Qualification Test) which is a legacy wizard.
• Reviewing manual guide for all the orders and write or execute test plan for the GUI, functional, Performance and Integration testing
• Involved in testing specific recommendations of integrating exquisite orders of Voice, Video, Wi-Fi and several channels products which are recommended to the product user to ensure adequate product coverage, plan compare and validation process
• Ensure proper order has been placed as per requirement with the respective snapshot for the selected customer options.
• Participated in the bug triage meetings with developers and set priorities for the upcoming releases.
• Handled and managed test reporting and tracking defects using Jira and/or QC.
• Scheduling daily Testing Status meetings to discuss issues found during testing and prepare MOM
• Prepared various types of Metrics, Prepared business continuity and risk mitigation plans. Being core member, prepared checklists and traceability metrics; handled all the management activities, successfully handled the offshore team for 12 releases
• Conducted Black Box (Functionality Testing), User Acceptance, and Regression testing.
• Provided clear concise feedback to Development team on recurring errors both on an individual and team basis with aim of long-term reduction of defects found in final releases

Environment: /Tools .NET, VS.Net, QTP, MS - SQL, QC 10.0 and VB.Net, SharePoint, Appium

Confidential, Hartford, CT

Sr. QA Analyst

Roles & Responsibilities

• Manually tested the application for a few modules for the functionality of the application
• Prepared detailed project plans (in the form of Scope Document)
• Involved in Mainframe application backend testing; review of Test cases and Manual execution of the System and Integration Test Cases
• Involved in Mainframe application backend testing. Defect tracking in Quality Centre Tool. Involved in database Testing.
• Worked on Mainframe emulator QWS3270 PLUS
• Coordinating with the Onsite team and the development teams and conducted knowledge Transition sessions to the team members

Environment: /Tools: IBM DB-2, QWS3270 PLUS, MS Office, QC 10.0

Confidential, Kenexa, KS

Sr. Test Engineer

Roles & Responsibilities:

• Reviewing and understanding Test Requirements and application
• Preparation and review of manual test cases, query log and issue log
• Testing reports by executing
• Writing Test scripts, preparation of test data, test execution and logging bugs
• Responsible for project deliverables to the client
• Responsible for updating the daily and weekly status to the client

Environment: /Tools: ASP.NET 2.0, VB.NET, DHTML, Ajax, JavaScript, Web services, Telerik controls, Reports and SQL server 2005

Confidential, Cleveland, OH

Sr. Test Engineer

Roles & Responsibilities:

• Reviewing and understanding Test Requirements and application
• Preparation and review of manual test cases, query log and issue log
• Writing Test scripts, preparation of test data, test execution and logging bugs
• Responsible for project deliverables to the client
• Responsible for updating the daily and weekly status to the client
• Preparation of MOM of all the meetings

Confidential

S oftware Engineer

Roles & Responsibilities:

• Understanding Test Requirements and application
• Walkthrough of use cases and test artifacts
• Writing Test scripts, preparation of test data, test execution and logging bugs through TeamTrack

Environment: /Tools: .NET, SQL Server 2000, TeamTrack, Excel, HP Quality Center, IBM Lotus Notes, MS Office

Confidential, Hartford, CT

Software Engineer

Roles & Responsibilities:

• Understanding Test Requirements and application from manual testing team and developers
• Walkthrough of manual test cases
• Implementation of Test Automation framework
• Writing Test scripts and preparation of test data
• Preparation of automation regression test suite and Test Suite execution

Environment: /Tools: Mainframe-Host, DB2, Quality Center 8.2, QTP 8.2, VB Script