SUMMARY:

• Over 7+ years of experience in Quality Assurance/Software Testing, extensively in ETL/data warehouse testing, and functional manual testing.
• Professional experience in all phases of Software Testing Life Cycle (STLC). In - depth knowledge of Software Development Life Cycle (SDLC).
• Experience in writing Test Scenarios, Test Conditions, Defining Test Cases, Developing and maintaining Test Scripts, Test plans, Defects and Status Reports.
• Expert in SQL and framed queries for complex transformation logic.
• Worked extensively on Brokerage Data warehouse, Enterprise data warehouse and Customer due diligence work flows and data enrichment processes.
• Strong knowledge in ETL testing, Manual testing of GUI, web application and DB testing.
• Proficient in Functionality Testing, User Acceptance Testing, Integration Testing, System Testing, Smoke Testing, End to End testing and Regression Testing.
• Extensive working knowledge in tools like HP ALM, Oracle SQL developer, TOAD, Informatica, Informatica DVO and UNIX putty.
• Worked closely with business and development team for issue analysis and resolution. “Go to person” for the functional/scenario consultation.
• Thorough knowledge in SDLC methodologies such as Waterfall, Agile (Scrum).
• Extensively worked on creating detailed test requirements, test plans, procedures, test cases, test strategies and generating/executing test scripts to meet business and functional specifications.
• Have conducted defect triage meetings with business and development team.
• Helped in production deployment validations - which requires lot of test data set up and involves coordination with multiple testers.
• Self-motivated, works independently and is a good team player. Led and mentored 7 to 12 member offshore team from onsite location.
• Implemented new testing approaches like Shift left approach to find defects early in SDLC cycle.
• Expertise in analyzing requirement specifications and responsible for developing Test Objective, strategies, Scope and Test Matrices.
• Experience in Financial services domain and quick learner to adapt to a newer environment.
• Good ability to anticipate issues and formulate remedial actions.
• Experience in testing business process workflow applications.
• Quick learner and adaptive to new and challenging technological environments.
• Involved in Functional, Non-functional, Regression, Integration, Smoke and UAT testing.

TECHNICAL SKILLS:

• ETL Testing
• Manual testing
• BPM workflow testing.
• SQL Queries
• SQA testing and methodologies
• Test plans and processes
• Test strategies & Coverages
• Scripting and Documentation
• Regression & negative testing
• UI and Compatibility testing
• Data migration testing
• Defect tracking
• Issue resolution
• QA and QC standards

WORK EXPERIENCE:

Confidential, Minneapolis

Technical QA Lead

Responsibilities/activities

• Worked in an agile framework which included offshore team. Led the team from on-site as a POC for testing team.
• Prepared test Plan for each Increment and Release/Production issues, designed test cases based on the transformation, relationship and uniqueness and also based on the stages of transformation.
• Analyzed and reviewed source to target mapping documents to send feedback to the system engineers, business analyst for clarifications
• Presented business reviews with business analysts and developers to review the test cases for different test scenarios covering all aspects of project functionality.
• Framed complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Created test data well ahead the execution for different scenarios in different source systems.
• Forecasting the test data requirements on analyzing the all possible testing scenarios.
• Executed jobs in UNIX and CA Work Load Automation tool, validated data in the database and checked log files in case of failures.
• Performed workflow validation with different roles like recommender, reviewer and approver . This involves making sure that the data loaded through the data enrichment process and other processes are displayed correctly in different tasks in each stage of the customer onboarding workflow.
• Performed schema and exhaustive data validation for each table and regression for modification of a transformation logic for columns.
• Involved in table to file conversion and file to table conversion to move data to other UNIX server and test them in different environments.
• Performed validations for data remediation, data load and data migration.
• Performed validations of batch scans for BSA hotlist, PEP, US Sanction, US Patriot act, credit investigations, background investigations and negative news scans. Also validated that the corresponding tasks are generated to the user notifying them with the data.
• Performed both Positive and Negative Testing for each system build.
• Involved in smoke test on each and every build deployed in development environment to make sure, that there is no major functionality or modules are broken in the builds
• Participated in complete end to end testing of the application
• Executed Functional, System Integration test cases using HP ALM Test Lab module and logged new defects as found using HP ALM defect module and reported to the development team along with screenshots, DB results, error logs and elaborated steps to reproduce the defect
• Responsible for sending daily status reports with defects list, test execution status, update on the current sprint for the existing release.
• Prepared Test Summary Report with the test cases and results.
• Defects were tracked, reviewed, analyzed and compared using HP ALM
• Documentation of key processes for end to end testing
• Environment: Oracle, HP ALM, Informatica, IBM BPM, S QL server 2008, Notepad++.

Confidential

Test Analyst

Responsibilities/activities

• Involvement in analyzing the business and functional requirements and preparing test plan in accordance with the BRD and FSD.
• Analyzed and reviewed source to target mapping documents to send feedback to the system engineers, business analyst for clarifications
• Presented business reviews with business analysts and developers to review the test cases for different test scenarios covering all aspects of project functionality.
• Framed complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Created test data well ahead the execution for different scenarios in different source systems.
• Mainly involved in functional testing which includes data validation of business rules against the data warehouse.
• Performed schema, data and integrity validation of the source and target objects. This involves flat files and tables.
• Involved extensively in testing Type II and Type III slowly changing dimension tables and fact tables.
• Tested target tables loaded from heterogeneous sources like flat files, different DBs. This involves loading the different sources into a temporary table and comparing against the target table.
• Involved in table to file conversion and file to table conversion to move data to other UNIX server and test them in different environments.
• Performed both positive and negative testing for all field and row level validations.
• Participated in Daily Scrum meetings with development and testing team to track, analyze and resolve issues.
• Used efficient methods to optimize the execution of minus queries in test environments. This involves creating indexes on the mostly used columns of temp tables and back up tables. Dropping them when not used.
• Developed simple UNIX shell scripts to automate the loading of flat files into temp tables for the ease of testing team.
• Developed simple UNIX shell scripts to automate the updating the environment process date and notify the teams who are using the environment. This script was then upgraded and used by support team to update and notify users.
• Used simple AWK commands to do file validation. This includes file layout testing and data testing.
• Involved in test co-ordination with different teams and status reporting to higher management.
• Defects were tracked, reviewed, analyzed and compared using HP ALM.

Environment: Oracle, HP ALM, Informatica, DB2, SQL server 2008, TOAD, PUTTY.

Confidential

Test Engineer

Responsibilities/activities:

• Directly involved in all the check-list preparation of testing process and monitor the process to enforce standards
• Requirement analysis, test scenario identification, test case preparation and test case execution.
• Prepared traceability matrix to fill the gap between requirement and the test case covered
• Developed and executed SQL queries for back end testing in SQL server.
• Managing the requirements and test cases using HP ALM.
• Following up the fix logged by test team and give assistance to the development team in fixing defects
• Performed system testing, Functional testing and regression testing
• Organized the status meeting and send status report to clients.

Environment: HP Quality Center, XML, MS Office, Oracle

Confidential

Test Engineer

Responsibilities/activities

• Involved in analyzing the business requirements and preparing test plan in accordance with the BRD and FSD.
• Mainly involved in functional testing which includes data validation of business rules against the data mart.
• Worked on reconciliation Testing - This involves the data testing of JADE system with the legacy systems.
• Main Responsible person for build installations in the QA environment using Octopus build installer and keeping the environment ready for testing.
• Frequently monitoring the ETL run in QA environments and fixing the issues related to ETL.
• Responsible for executing integration and regression test cases
• Documented test results, opened defects for issues discovered during testing
• Analyzed the defects and categorized them based on the severity level and reported bugs using VSTF.
• Interacted with developers regularly to ensure that defects were resolved
• Prepared weekly status report and reported to management
• Attend Status Meetings and internal defect review meeting with team members
• Escalate Interface Environment problems immediately to support teams to minimize impact on testing
• Performed regression testing for build installations in QA environments.
• Worked on Test case preparation and logging bugs in VSTF 2008.

Environment: SQL Server 2008 R2, METaL framework, Visual Studio Team Foundation 2008, Octopus build installer, Windows