PROFESSIONAL SUMMARY:

• Have 7.5 years of experience in QA testing as backend/ETL tester in Telecom, Banking and Finance, Investments, Health which also includes print testing
• Extensive experience in Agile - Scrum and Waterfall methodologies - SDLC, STLC and Bug Life Cycle
• Experienced in performing smoke tests, functional tests, regression tests, negative tests, backend testing, database migration testing, cross browser testing, performance and load testing
• Well versed in requirements gathering and analysis, test effort estimation, requirement GAP analysis, requirement traceability matrix and test coverage
• Experienced in conducting walkthroughs of test artifacts - test plan, test scenarios and test scripts, and gathering approvals from various stake holders
• Expertise in creating test data and using testing tools such as Quality Center (QC)- HP ALM, JIRA, IBM Clear Quest
• Well versed in backend automation scripts in UNIX environment using shell scripting - vi editor and UNIX commands
• Well versed in writing and executing basic and advanced SQL and PL/SQL Queries in DB2, Sybase servers for back-end testing including Teradata DB
• Expertise in ETL testing with data validation between source and target table including Fact and Dimension tables
• Hands on experience in automation testing with QTP, TC (test complete) and Selenium
• Experience in scheduling and managing autosys jobs using autosys tools and putty
• Experience in validating reports using Qlikview dash board and Business objects
• Experience working in onshore-offsite business model
• Flexible to learn advancements in technologies with good analytical, logical and trouble shooting skills
• Excellent communication skills (in written and in oral )and coordination skills with cross functional teams and stakeholders
• Energetic with ability to work in teams and independently
• Capable of performing multi-tasking and ability to achieve targets and deliver results in a high-pressure environment
• Knowledge in Big Data concepts - HDFS, HBASE, Map Reduce, PIG, HIVE, SQOOP and ZOO KEEPER

TECHNICAL PROFILE:

Operating System: Windows, Linux and Unix

Methodologies: Agile - Scrum, Waterfall

Testing Tools: Putty, DB Artisan, Rapid SQL, Squirrel, Toad, AQT, CA Workstation, Informatica

Automation tools: QTP, TC, Selenium, Ruby Mine

Test Management Tools: HP Quality Center, JIRA, Bugzilla, Clear Quest

Reporting tools: Qlikview Dashboard, Business Objects

Editors and Scripting: Shell script, VB Script, Perl (basics), vi editor, Ruby

Languages: C, C++, Java (J2SE), PHP, HTML, SQL, PL/SQL

Database: Oracle, DB2, Sybase, MySQL, MS Access, Teradata architecture

Browsers: Internet Explorer, Mozilla Firefox, Google Chrome

Testing: Functional, Smoke/Sanity, Regression, Negative, ETL, Integration, UAT

PROFESSIONAL EXPERIENCE:

Confidential, MI

Test Analyst

Methodology: Agile - Scrum

Responsibilities:

• Involved in the design of the solution
• Testing requirements for data migration project
• Write and create complex SQL statements ensuring data integrity
• Generate reports, drill down into the reports and test accuracy of reports
• Test the migration of data from one data structure to another
• Create comprehensive test plans for wellness & prevention products
• Design and execute manual and automated test cases using JIRA and Selenium
• Conduct functional, system, regression and smoke tests in multiple environments
• Diagnose, report, track and assist in resolving quality issues
• Facilitate code migration between development, test, UAT, staging and production
• Validate smoke tests in prod after deployment
• End to end test cycle includes various testing like functional, regression, smoke, data validation, negative testing, data change, performance on both UI and backend including print testing
• Data validation, font and script validation in print testing, format testing apart from regular testing is done
• Testing for multiple languages like English and Spanish for various users
• Train the team members on the application for smooth flow
• Interactions with various team members internally as well as cross team and ensure deliverables
• Report any issues identified and work with developer on fixing and retesting
• Logging defects as needed in FIT and JIRA

Environment: - JIRA, Oracle - SQL Developer, Windows, Sharepoint, TIDAL batch jobs, various browsers, Selenium, acrobat pro, Teleforms, FIT, Jenkins

Confidential, OH

Test Analyst and Test Lead

Methodology: Agile - Scrum

Responsibilities:

• Prepare test plan and test scenarios as per requirements
• Interact with requirement analyst, developers and other team to ensure proper test coverage
• Analyse interdependencies of each stream and verify the functionality on high level
• Participate in team meetings. Conduct meetings as and when required for review or discussion
• Provide LOE for the testing
• Performed end to end tests as per test coverage, interacting with external system wherever needed
• Execute end to end batch jobs for various batch dates - multi day integration testing
• Prepared necessary SQL’s for testing and performed tests in various environments
• Verified data load into respective tables and interface screens
• Debug the issues and regularly interact with end users
• Validate the data mapping using informatica power center
• Documented the test cases in QC, create necessary defects and tracked them to completion by communicating and co-coordinating with the analysts and development team
• Monitor/debug the workflow sessions / logs using informatica power monitor
• Validate the data transformation from source to target using SQL’s and verify mappings
• Compare the various result sets using Ruby and Ruby mine
• Performed data validations on staging and target data warehouse

Environment: - CA work station (ESP), HP-QC, Oracle - AQT, Windows XP, Ultraedit, sharepoint, Informatica designer and power monitor, Ruby, Ruby Mine

Confidential, VA

Test Lead and Primary SME

Methodology: Agile - Scrum

Responsibilities:

• Regular interaction with end users for integration testing of various application interfaces
• Perform testing in various environments like System Test (ST), Business Operation Tests (BOT) and User Acceptance Test (UAT)
• Took ownership for preparing and maintaining necessary test artifacts with appropriate information of test estimates, developing Traceability Matrix and Gap Analysis
• Contributing status inputs in meetings with project management - Project Manager, BA, QA Manager, Developers - for daily test status with updates on risk / issues identified and proposing mitigation plan
• Conducted walkthrough for review and approval of test artifacts and assigned tasks to team members for effective testing to meet deadlines
• Conducting internal team meeting with onsite offshore team members
• Provide LOE for the tests and report daily status to scrum master
• Provide training to Production support L2 team for end to end executions and high level view of the system
• Performed end to end Integration tests by integrating fourteen interfaces with external system wherever needed
• Analyse interdependencies of each stream and verify the functionality on high level
• Execute end to end executions for various batch dates - multi day integration testing
• Prepared necessary SQL’s for testing and performed tests
• Verified data load into respective tables and interface screens
• Debug the issues and regularly interact with end users
• Worked on two interfaces End to End using integration with external teams for testing
• Validate the data mapping using informatica power center
• Documented the errors using Clear Quest and tracked them in QC to completion by communicating and co-coordinating with the analysts and development team
• Generated Testing and Defect Status report and communicated to the Project Management Team
• Supported Business Users during UAT phase
• Monitor/debug the workflow sessions / logs using informatica power monitor
• Validate the data transformation from source to target using SQL’s and verify mappings
• Performed data validations on staging and target data warehouse

Environment: - IBM-Clear Quest, HP-QC, Oracle - Toad, Windows XP, UNIX, TIBCO services, SIM CORP Dimension application Interface, sharepoint, Informatica power center and power monitor, ETL transformations

Confidential, NY

Test member and secondary resource for testing

Methodology: Agile - Scrum

Responsibilities:

• Validate the data transformation from source to target by verifying the mapping using informatica power center
• Perform data validations in staging and target tables and monitor the workflow using informatica power monitor
• Data validations and few code executions / data extraction were done using PL/SQL procedures
• Aggressive data validations between source file and Teradata DB depending on the requirement mapping
• Documented the errors in QC and tracked them to completion by communicating and co-coordinating with the development as well as the support group
• Generated Testing and Defect Status report and communicated to the Project Management Team

Environment: - HP-QC, Teradata DB, IE, Mozilla Firefox, Google Chrome, Informatica power monitor and power center, sharepoint

Confidential, NY

Test Lead and Primary SME

Methodology: Agile - Scrum

Responsibilities:

• Took ownership for preparing ad maintaining necessary test artifacts with appropriate information of test estimates, developing Traceability Matrix and Gap Analysis
• Mentored new team members and provided knowledge transfer on daily status reports in scrums, designing test plan, test execution scripts, technical assistance and tools used
• Contributing to daily scrum meetings with project management - Project Manager, BA, QA Manager, Developers, Support team lead - for daily test status with updates on risk / issues identified if any and proposing mitigation plan
• Conducted walkthrough for review and approval of test artifacts and assigned tasks to team members for effective testing to meet deadlines
• Provide the LOE for the tasks on high level and in detailed level
• Report the daily status to scrum master and BA’s
• Attend meetings with development lead, scrum master, BA’s and QA manager to give the status report and negotiate the requirements/LOE’s
• Prepared test data and automated backend testing with data validation wherever required using shell scripts, complex SQL queries and PL/SQL procedures
• Validate the data transformation from source to target by verifying the mapping using informatica power center
• Perform data validations in staging and target tables and monitor the workflow using informatica power monitor
• Data validations and few code executions / data extraction were done using PL/SQL procedures
• Performed reports testing where Reports generated from BO is compared using SQL’s
• Validated the reports for various user level roles and verified the report generation/publishing reports in various formats as required by user
• Implemented White box testing for one of the functionalities and monitored and tested batch jobs
• Identified test cases to be automated for regression and created reusable scripts
• Created automated test scripts using QTP for effective testing reducing manual effort
• Documented the errors in QC and tracked them to completion by communicating and co-coordinating with the development as well as the support group
• Generated Testing and Defect Status report and communicated to the Project Management Team
• Provided QA sign-off after performing tests and supported BA and Business Users during UAT phase

Environment: - HP-QC, DB Artisan - Sybase (SQL, PL/SQL), Windows XP, UNIX, Shell and Perl scripts, IE, Mozilla Firefox, Google Chrome, Informatica power monitor, Business Object (BO), DB/DW ETL testing, sharepoint

Confidential, NY

Module Lead and Primary SME

Methodology: Waterfall

Responsibilities:

• Prepared necessary documents related to application/scripts for better understanding with daily reports to QA Manager and Project team on test updates / clarifications
• Provide the LOE for the tasks on high level and in detailed level
• Guided new team members and provided knowledge transfer on daily status reports, test artifacts preparation and maintenance
• Allocated tasks to team members to meet deadlines effectively
• Report the daily status to scrum master and BA’s
• Attend meetings with development lead, scrum master, BA’s and QA manager to give the status report and negotiate the requirements/LOE’s
• Was involved in daily status meetings with project management team for testing updates / clarifications and proposed risk mitigation plans
• Prepared and maintained necessary test artifacts, traceability matrix with gap analysis and conducted walkthrough for review and approval of test artifacts
• Prepared necessary test data and automated backend testing using shell and Perl scripts
• Monitored and tested batch jobs using informatica power monitor wherever required and validated data testing using SQL’s
• Performed UI and backend Manual and Automation testing - Smoke, Functional, Negative, Regression and Performance testing, backend testing, cross browser testing
• Used SQL procedures to test complex set of data during backend automation
• Suggested enhancements in application and prepared reusable scripts
• Created automated test scripts using TC (Test Complete) for effective testing reducing manual effort
• Documented and tracked the defects in QC with appropriate communication to development and support teams
• Validate the data transformation from source DB to target DW
• Verify the mapping between source and target using informatica power center and monitor the workflows using informatica power monitor
• Used Business Object (BO) tool to test the generated/published reports using parameters and various role levels
• Comparison of BO generated/published reports with SQL queries developed to ensure data match
• Perform the data comparison in the Qlikview dashboard as per the filters selected
• Provided QA sign-off after performing tests
• Conducted Sanity Tests in Prod to ensure functionality is deployed as required

Environment: - HP-QC, DB Artisan - DB2 (SQL’s, PL/SQL), Windows XP, UNIX, Shell and Perl scripts, Leela services, IE, Mozilla Firefox, Informatica power monitor, Business Object (BO), Qlikview dash board, sharepoint

Confidential, NY

Module Lead and Primary SME

Methodology: Waterfall

Responsibilities:

• Reported daily status on testing updates / clarifications / issues faced to project management team
• Prepared and maintained test artifacts - Test Plan, Test Scenarios and test scripts by analyzing functional requirement documents, design documents and conducted walkthrough for review and approval of test artifacts
• Involved in backend manual and automation testing - Smoke, Database Migration and Performance testing
• Performed data base migration tests and ETL testing using complex SQL’s in DB Artisan and MS Access, validated the same using excel sheet and automated using shell and Perl scripts
• Created PL/SQL procedures and functions for testing large set of data
• Debug the issues with informatica power monitor
• Documented the errors in QC and reported to necessary development team
• Provided QA sign-off after performing tests

Environment: - HP-QC, DB Artisan - DB2, MS Access, Excel, Windows XP, UNIX, Shell and Perl scripts, Informatica power monitor, sharepoint

Confidential, NY

Team member

Methodology: Waterfall

Responsibilities:

• Involved in UI and backend Manual testing - Functional and Regression testing
• Used DB Artisan to write and executed complex SQL queries and conditions to validate Back-end data
• Documented the errors in QC and tracked them to completion by communicating and co-coordinating with the development as well as the support group
• Executed automated scripts and documented the results in TC
• Report the status to primary SME of project
• Validate the reporting data in Qlikview dashboard

Environment: - HP-QC, DB Artisan - DB2, Windows XP, Mozilla Firefox, Qlikview dashboard, sharepoint

Confidential, NY

Team member

Methodology: Waterfall

Responsibilities:

• Prepared and maintained test artifacts - Test Plan, Test Scenarios and test scripts by analyzing functional requirement documents, design documents and conducted walkthrough of test artifacts
• Manually performed backend Smoke, Database Validation testing with defect logging and tracking in QC
• Involved in ETL testing by comparing source (DB/flat files) and target DB data
• Extensive use of SQL queries for validating and extracting data
• Created test data by modifying feed files and/or DB tables and Scheduled and monitored daily runs of jobs
• Validated feed files data with DW tables and views using perl script
• Verified the mappings using power center and debugged the issues with power monitor
• Validate the reporting data in Qlikview dashboard
• Generated Testing and Defect Status report and communicated to the Primary SME of Project

Environment: - HP-QC, DB Artisan - DB2 (PL/SQL, SQL), Windows XP, UNIX, shell and Perl scripts, Informatica power center and power monitor, Qlikview dashboard, sharepoint

Confidential

Team member

Methodology: Waterfall

Responsibilities:

• Report the status to Team Lead
• Involved in preparing test scripts using test scenarios document
• Involved in Manual testing UI and backend – Functional and regression testing
• Perform testing for quick test execution using shell and Perl scripts
• Perform DB testing like validated feed files data with DW tables and views using perl script
• Documented the errors in QC and tracked them to completion by communicating and co-coordinating with the development as well as the support group
• Tracked, Managed and documented the Functionality, Performance and behavior of the application during QA
• Generated Testing and Defect Status report and communicated to the Project Management Team
• Provided QA sign-off after performing tests
• Conducted Sanity Tests in Prod to ensure functionality is deployed as required

Environment: - Manual Testing, HP-QC, DB Artisan – DB2 (SQL), Windows XP, UNIX and shell scripts