SUMMARY:

• Has 8 years of experience in QA testing as backend/ETL tester/automation testing 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 wif data validation between source and target table including Fact and Dimension tables
• Hands on experience in automation testing wif 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 wif good analytical, logical and trouble shooting skills
• Excellent communication skills (in written and in oral )and coordination skills wif cross functional teams and stakeholders
• Energetic wif 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 SKILLS:

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 teh design of teh solution
• Testing requirements for data migration project
• Write and create complex SQL statements ensuring data integrity
• Generate reports, drill down into teh reports and test accuracy of reports
• Test teh 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 teh team members on teh application for smooth flow
• Interactions wif various team members internally as well as cross team and ensure deliverables
• Report any issues identified and work wif 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 wif requirement analyst, developers and other team to ensure proper test coverage
• Analyse interdependencies of each stream and verify teh functionality on high level
• Participate in team meetings. Conduct meetings as and when required for review or discussion
• Provide LOE for teh testing
• Performed end to end tests as per test coverage, interacting wif 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 teh issues and regularly interact wif end users
• Validate teh data mapping using informatica power center
• Documented teh test cases in QC, create necessary defects and tracked them to completion by communicating and co-coordinating wif teh analysts and development team
• Monitor/debug teh workflow sessions / logs using informatica power monitor
• Validate teh data transformation from source to target using SQL’s and verify mappings
• Compare teh 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 for Integration tests

Methodology: Agile - Scrum

Responsibilities:

• Regular interaction wif 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 wif appropriate information of test estimates, developing Traceability Matrix and Gap Analysis
• Contributing status inputs in meetings wif project management - Project Manager, BA, QA Manager, Developers - for daily test status wif 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 TEMPeffective testing to meet deadlines
• Conducting internal team meeting wif onsite offshore team members
• Provide LOE for teh 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 teh system
• Performed end to end Integration tests by integrating fourteen interfaces wif external system wherever needed
• Analyse interdependencies of each stream and verify teh 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 teh issues and regularly interact wif end users
• Worked on two interfaces End to End using integration wif external teams for testing
• Validate teh data mapping using informatica power center
• Documented teh errors using Clear Quest and tracked them in QC to completion by communicating and co-coordinating wif teh analysts and development team
• Generated Testing and Defect Status report and communicated to teh Project Management Team
• Supported Business Users during UAT phase
• Monitor/debug teh workflow sessions / logs using informatica power monitor
• Validate teh 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 teh data transformation from source to target by verifying teh mapping using informatica power center
• Perform data validations in staging and target tables and monitor teh 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 teh requirement mapping
• Documented teh errors in QC and tracked them to completion by communicating and co-coordinating wif teh development as well as teh support group
• Generated Testing and Defect Status report and communicated to teh 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 wif 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 wif project management - Project Manager, BA, QA Manager, Developers, Support team lead - for daily test status wif 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 TEMPeffective testing to meet deadlines
• Provide teh LOE for teh tasks on high level and in detailed level
• Report teh daily status to scrum master and BA’s
• Attend meetings wif development lead, scrum master, BA’s and QA manager to give teh status report and negotiate teh requirements/LOE’s
• Prepared test data and automated backend testing wif data validation wherever required using shell scripts, complex SQL queries and PL/SQL procedures
• Validate teh data transformation from source to target by verifying teh mapping using informatica power center
• Perform data validations in staging and target tables and monitor teh 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 teh reports for various user level roles and verified teh report generation/publishing reports in various formats as required by user
• Implemented White box testing for one of teh 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 TEMPeffective testing reducing manual effort
• Documented teh errors in QC and tracked them to completion by communicating and co-coordinating wif teh development as well as teh support group
• Generated Testing and Defect Status report and communicated to teh 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: - Firm Risk Management - Operational Risk Vision (ORV)

Module Lead and Primary SME

Methodology: - Waterfall

Responsibilities:

• Prepared necessary documents related to application/scripts for better understanding wif daily reports to QA Manager and Project team on test updates / clarifications
• Provide teh LOE for teh 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 TEMPeffectively
• Report teh daily status to scrum master and BA’s
• Attend meetings wif development lead, scrum master, BA’s and QA manager to give teh status report and negotiate teh requirements/LOE’s
• Was involved in daily status meetings wif project management team for testing updates / clarifications and proposed risk mitigation plans
• Prepared and maintained necessary test artifacts, traceability matrix wif 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 TEMPeffective testing reducing manual effort
• Documented and tracked teh defects in QC wif appropriate communication to development and support teams
• Validate teh data transformation from source DB to target DW
• Verify teh mapping between source and target using informatica power center and monitor teh workflows using informatica power monitor
• Used Business Object (BO) tool to test teh generated/published reports using parameters and various role levels
• Comparison of BO generated/published reports wif SQL queries developed to ensure data match
• Perform teh data comparison in teh Qlikview dashboard as per teh 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: - Firm Risk Management - Operational Risk Vision (ORV)

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 teh same using excel sheet and automated using shell and Perl scripts
• Created PL/SQL procedures and functions for testing large set of data
• Debug teh issues wif informatica power monitor
• Documented teh 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

Module: - Firm Risk Management - Operational Risk Vision (ORV)

Team member and Secondary resource

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 teh errors in QC and tracked them to completion by communicating and co-coordinating wif teh development as well as teh support group
• Executed automated scripts and documented teh results in TC
• Report teh status to primary SME of project
• Validate teh reporting data in Qlikview dashboard

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

Confidential, NY

Module: - Firm Risk Management - Operational Risk Vision (ORV)

Team member and Secondary resource

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 wif 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 wif DW tables and views using perl script
• Verified teh mappings using power center and debugged teh issues wif power monitor
• Validate teh reporting data in Qlikview dashboard
• Generated Testing and Defect Status report and communicated to teh 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, INDIA

Team member

Methodology: - Waterfall

Responsibilities:

• Report teh 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 wif DW tables and views using perl script
• Documented teh errors in QC and tracked them to completion by communicating and co-coordinating wif teh development as well as teh support group
• Tracked, Managed and documented teh Functionality, Performance and behavior of teh application during QA
• Generated Testing and Defect Status report and communicated to teh 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

Confidential

Team member UI and DB testing

Methodology: - Waterfall

Responsibilities:

• Report teh status to Team Lead of project
• Prepared test artifacts - Test Scenarios and test scripts by analyzing functional requirement documents, design documents and Test Plan
• Involved in manual UI and backend automation testing – Smoke, Database Validation, Functional and regression testing
• Used DB Artisan to write and executed complex SQL queries and conditions to validate Back-end data
• Automated backend testing for quick test execution using shell scripts
• Documented teh errors in QC and tracked them to completion by communicating and co-coordinating wif teh development team
• Tracked, Managed and documented teh Functionality and behavior of teh application during QA
• Generated Testing and Defect Status report and communicated to teh Project Management Team
• Provided daily status reports on testing
• Coordinating wif Onshore team for testing and reports analysis
• Provided QA sign-off after performing tests

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

Confidential

Team member

Methodology: - Waterfall

Responsibilities:

• Report teh status to Team Lead
• Involved in preparing test scripts using test scenarios document
• Involved in Manual UI testing – Functional and regression testing
• Involved in reporting teh errors found and test them once fixed
• Prepare teh documents of testing approach used in teh involved module

Environment: - DB Artisan – DB2, Windows XP