PROFESSIONAL SUMMARY:

• Over 8 years of progressive experience in manual and automation testing on client server and web applications, Provisioning STBs in CSG and AMDOCS billing system and ETL/ Data warehouse backend testing.
• Extensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development, Testing and Implementation.
• Involved in different types of methodologies like Agile/Scrum and Waterfall methods.
• Experience in designing, documenting, and executing test plans, test data, test scenarios/scripts & test cases for manual, automated & bug tracking tools.
• Hands on experience on different kinds of testing like Back - End Testing, Positive/Negative Testing, Data Driven Testing, Black-box/White-Box Testing, End to End Testing, Functional, Integration Testing, System Testing, UAT Testing and Regression Testing
• Experience in developing optimized UFT/QTP scripts for regression testing with data sources.
• Expertise in querying and testing using RDBMS tools like Oracle, MS SQL server, PL/SQL, DB2, TOAD, and MS Access for Data integrity
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Standardization, Data Verification and identifying data mismatch.
• Excellent knowledge of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Experience in the Analysis, Design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Possess strong analytical and problem solving skills with the ability to rapidly adapt to changes, new environments and deadlines.
• Hands on expertise on HP QC, HP ALM, Zephyr for writing and executing Test Cases, Test plan, defect tracking, prioritizing defects and disposition in defect scrum meetings.
• Participated in design Walkthroughs and Inspection meetings to review Test scripts and results.
• Ability to quickly understand and interpret business requirements.
• Excellent in communication, presentation, and interpersonal skills. Good team player with the ability to lead, manage and work independently in a time sensitive environment.

TECHNICAL SKILLS:

OS: Windows 7, UNIX, IOS

Languages: VB Script, C, java, ASP.Net, SQL, Visual Basic 6.0, PL/SQL

Databases: SQL Server, Oracle, MS Access, MySQL, IBM

Web Browsers: IE, Mozilla Firefox, Chrome, IPAD, Google tablet, Android on mobile.

Business Mgmt. Tools: Rational Requisite Pro, MS Office, MS Visio.

DWH Tools: SSIS, SSRS, Informatica Power Center 8.1/9.1

Testing Tools: HP Quality Center 9.2-10-11, QTP 10, Selenium IDE, HP ALM 12.0, Zephyr

Bug Tracking Tool: Bugzilla, JIRA, HP Quality Center, HP ALM

PROFESSIONAL EXPERIENCE:

Confidential, Downingtown, PA

Software Test Engineer

Responsibilities:

• Involved in development of test plan, test schedules, test cases based on high-level and detailed designs.
• Created Test Plan, Test Cases and Test scripts for some of the modules of the application under test AUT) using HP ALM.
• Carefully examined existing Test Plans for gaps in coverage.
• Responsible for installing, configuring and testing DOCSIS, Wi-Fi, and Cable modem devices on X1 platform.
• Performed and validated code download on various STBs using TFTP, HTTP, SNMP trigger, config file trigger with both IPv4 and IPv6
• Worked on end-to-end functional testing with various vendors’ devices and billing systems.
• Performed SIK/BSE Warehouse testing with every GA release build. Verified customer settings and data, account activation after WH process test.
• Developed, implemented and maintained development best practices for within ETL environments.
• Analyzed and solved problems and recommended improvements to existing systems and processes.
• Ensured data security, data quality and governance of data.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
• Reviewed Informatica mappings and test cases before delivering to Client.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Wrote several SQL queries for validating and verifying the data across different databases.
• Worked on SQL scripts to load data in the tables.
• Used Unix to gather and analyze logs; Vi to edit files for testing and defect analysis.
• Track issues/defects found during test executions and participated in bug review process.
• Actively participated in daily scrum meeting, weekly meetings with team members, project engineers. Prepare documents, generate reports and also document test procedure used in executing the test case.

Environment: HP ALM 12, HP UFT, MS SQL Server, Atlassian Jira, Selenium Web Driver, UNIX, AMDOCS, CSG Billing system, Informatica 9.1, Java, Teradata, WinSCP, WireShark, TeraTerm, Rally.

Confidential, Downingtown, PA

QA Tester

Responsibilities:

• Review business requirements, functional specifications, project schedules, documentation and test plans.
• Preformed Regression and functional testing on Standard Def. and HD boxes as well as DVR and Non- DVR boxes.
• Manual testing on Guide, VOD, premium packages on VOD, PPV, Parental Control, Closed captioning, EAS, and DVR recordings.
• Performed Regression testing on eTV/EBIF applications- Caller ID Settings, Home Shopping Network (HSN), RRR, and Swap Applications on both legacy and Tru2way set top boxes.
• Involved in validating user input data for Swap applications.
• Validated logs in Unix and SOAPUI for eTV/EBIF applications testing on both SA/Cisco and Motorola set top boxes.
• Provisioned new set top boxes in CSG and AMDOCS billing systems and authorized, initialized and reset boxes via Controller systems.
• Validated automation test scripts in QTP and worked with offshore vendors (TCS) effectively and efficiently.
• Performed Smoke, Regression and Functional Testing for Cavalry Project on DTA Devices.
• Setup and configure test environments for DTA devices and extensively tested manually as per Test Plan.
• Validated and analyze logs in Unix for impairment, B-DRI and functional testing on all Settop devices.
• Track issues found during test executions and participated in bug review process.
• Actively participate in daily scrum meeting and weekly Cisco meeting with Project Team Lead and Manager.
• Document test results and report the status of assigned test tasks and issues to project Lead.
• Involved in understanding the current business process, defining scope of the project along with the position statement.

Environment: HP Quality Center, HP ALM, UNIX, QTP, SOAPUI, JIRA, CSG and AMDOCS billing system

Confidential, Pittsburgh, PA

ETL QA Tester

Responsibilities:

• Involved in developing detailed Test plan, Test cases and Test scripts using Quality Center for Functional and Regression Testing.
• Performed Functional and Regression testing manually. Managed and executed the test process, using Agile Methodology.
• Executing SQL queries while performing database testing.
• Tested ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Developed Test Cases and Test Scripts for System and UAT Testing.
• Extracted test data from tables and loaded data into SQL tables.
• Helped the System Test Lead in developing the Test Plan and Testing Strategy for ETL/BI.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Used Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Used Informatica Data Validation that reduces the time required for data validation and production data auditing and verification.
• Conducted manual back-end testing on a reconfigured sales application system.
• Used SQL for Querying the SQL Server database for Data validation and data conditioning.
• Designed Traceability Matrix to match the test scripts with the Functional design document.
• Participated in status meetings to report issues. Communicated with developers through all phases of testing to prioritize bug resolution

Environment: HP QC, MS SQL server, Visual Studio, Atlassian Jira, UNIX, Informatica, Java, WinSCP, TeraTerm, Rally.

Confidential, Minneapolis, MN

QA Tester

Responsibilities:

• Involved in creating the test strategy document that defines the test environment, phases of testing, entrance and exit criteria into different phases of testing and resources required conducting the effort.
• Created Test Plan, Test Cases and Test scripts for some of the modules of the application under test AUT) using Test Director.
• Executed test cases and participated actively in Functional Testing, System testing and Regression testing using Win Runner with different checkpoints.
• Tested Open ID Technology under major browsers and their latest releases, tested login functionality with different accounts, created and executed positive and negative test cases.
• Interacted with Business teams and Developers to understand business requirements and bug fixes.
• Defined and performed the test strategies and associated scripts for the verification and validation of the application and ensured that it meets all defined business requirements and associated functionality.
• Responsible for defect tracking and management metrics, defects are logged and change requests are submitted using Test Director.
• Performed Data Analysis, wrote SQL Queries for testing and troubleshooting against Data Warehouse.
• Participated in status meetings to report issues. Communicated with developers through all phases of testing to prioritize bug resolution.
• Performed System and Regression Testing for new releases using win runner.
• Coordinated between various teams to insure consistency and accuracy across test plans, user manuals and training materials.

Environment: Win Runner, Test Director, Quality Center, MS Office Suite, Windows XP, XML, SQL, Oracle 9, Windows