PROFESSIONAL SUMMARY:

• Over 9.5 years of IT experience in RDBMS & Data warehousing, experience in testing, requirement analysis, Data analysis, implementation and support.
• Experienced in Requirement Analysis, Data Analysis,Test Design, Test Preparation, Test Execution, Defect Management, and Management Reporting.
• Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema.
• Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
• Hands on experience in developing SQL and Stored Procedure.
• Expertise in querying, analyzing and testing RDBMS such as Oracle, MS SQL Server,SQL Developer,Netezza, Hadoop/Hive using SQL for data integrity.
• Experienced in BI Reporting tools such as COGNOS, MICROSTRATEGY and Tableau Reports.
• Experience in ETL tools - Data stage (iShare), BODI.
• Experience in Big Data/ Hadoop testing.
• Experience in General Ledger module in PeopleSoft.
• Experience in testing the integration between PeopleSoft and Coupa.
• Strong understanding of data quality assurance processes and procedures.
• Experienced in Software Development Life Cycle (SDLC).
• Experienced working with offshore teams and establishing offshore teams and processes.
• Skilled at learning new concepts quickly, can work well under pressure and able to communicate ideas clearly and effectively.
• Excellent team player with an ability to perform individually, good interpersonal and analytical skills
• Clear understanding of business procedures and ability to work as an individual and as a part of a team.
• Facilitated JAD sessions and Interviews.
• Have basic experience in UNIX Shell scripting for triggering of ETL jobs.
• Have experience in scheduling the ETL jobs through Redwood scheduler.
• Experience in working in the agile methodology projects.
• Experience in Web Services testing using SOAP UI.
• Experience in functional testing of the core banking applications like CBS, Flexcube, iMX and testing the integration with the Datawarehouse.

TECHNICAL SKILLS:

Database: Microsoft SQL Server, Oracle, Teradata, SQL Developer, iSeries Navigator,Netezza., Hadoop

Tools: Microsoft SQL Server 2008, Teradata, Toad for Oracle 11, IBM System I Navigator 7, HP Quality Center 11, HP ALM, Cognos Business reporting, Micro strategy Business reporting and Tableau Reports, DataStage, Rally (Agile Tool), SQL Developer, BODI Console, PeopleSoft, Coupa. Redwood Scheduler, UNIX, SOAP UI, Jira, Aginity Workbench for PureData.,Hive

Platforms: Microsoft Windows 7 and Microsoft Windows XP, Windows 10

PROJECT EXPERIENCE:

Test Lead Onsite

Confidential

Responsibilities:

• Worked with Project Team, SME and Internal Business Partners to clarify business requirements and translate the requirements into technical specifications.
• Responsible in estimation and work breakdown structure (WBS) to meet Project Milestone.
• Involved in writing complex SQL statements and PL/SQL code to test data flow and to perform data analysis.
• Involved in writing complex SQL statements to validate the data against the BI Microstrategy reports .
• Involved in writing SQL statements against the Hive to extract the JSON file data.
• Designed, created and executed the manual test cases.
• Conduct end to end functional testing, regression testing, system integration testing, user acceptance testing and production support testing.
• Created SQL queries to perform Data Validation and Data Integrity testing.
• Develop test scenarios and test cases, conduct reviews and execute test cases
• Involved end to end functional testing, regression testing, system integration testing, user acceptance testing and production support testing.
• Participated in sprint planning, grooming and retrospective meetings.
• Ensure in-sprint testing; stay in touch with the daily priorities of the project team with respect to testing.

Test Lead Onsite

Confidential

Responsibilities:

• Worked with Project Team, SME and Internal Business Partners to clarify business requirements and translate the requirements into technical specifications.
• Worked the SME’s from the Core banking applications to confirm on the requirements.
• Involved from beginning of the project such as BRD to post implementation of SDLC process.
• Responsible in estimation and work breakdown structure (WBS) to meet Project Milestone.
• Performed Source system analysis (SSA) to identify the source data that needs to be moved into the target tables.
• Created functional data requirement (FDR) and Master Test Strategy documents based on the reporting requirements.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
• Created Test Plans, Test Cases, and Test Scripts for all testing events such as System Integration Testing (SIT)
• Designed, created and executed the manual test cases.
• Created functional test data in the core banking application to test the functional integration between the different core banking systems in the bank.
• Created SQL queries to perform Data Validation and Data Integrity testing.
• Created test scripts to validate the incoming payments to the core banking system through the SOAP UI tool.
• Involved in Functional and Regression testing.
• Created SQL queries to compare the output of the BODI jobs against the source data.
• Run the ETL tool - BODI console to load the data to peoples soft and then from PeopleSoft to Downstream testing.
• Coordinated with offshore team to help them understand the requirements and also reviewed the test scripts/test execution results.

Test Lead Onsite

Confidential

Responsibilities:

• Worked with Project Team, SME and Internal Business Partners to clarify business requirements and translate the requirements into technical specifications.
• Worked the SME’s from the PeopleSoft team and the coupa team to confirm on the requirements.
• Involved from beginning of the project such as BRD to post implementation of SDLC process.
• Responsible in estimation and work breakdown structure (WBS) to meet Project Milestone.
• Performed Source system analysis (SSA) to identify the source data that needs to be moved into the target tables.
• Created functional data requirement (FDR) and Master Test Strategy documents based on the reporting requirements.
• Worked with the SME’s from our team as well as the upstream team to understand the functionality of the upstream to validate that the data that we are getting are correct, because the data that we consume in PeopleSoft won’t be processed otherwise.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
• Created Test Plans, Test Cases, and Test Scripts for all testing events such as System Integration Testing (SIT)
• Designed, created and executed the manual test cases.
• Coordinated with DEV team to schedule the ETL jobs in the correct sequence through the Redwood scheduler, so that the effort in running the ETL jobs could be minimized.
• Created SQL queries to perform Data Validation and Data Integrity testing.
• Involved in Functional and Regression testing.
• Created SQL queries to compare the output of the BODI jobs against the source data.
• Run the ETL tool - BODI console to load the data to peoples soft and then from PeopleSoft to Downstream testing.
• Coordinated with offshore team to help them understand the requirements and also reviewed the test scripts/test execution results.

Test Analyst Onsite

Confidential

Responsibilities:

• Worked closely with Project Team, SME and Internal Business Partners to clarify business requirements and translate the requirements into technical specifications.
• Involved from beginning of the project such as BRD to post implementation of SDLC process.
• Assisted Client Managers in scope estimation and work breakdown structure (WBS) to meet Project Milestone.
• Performed Source system analysis (SSA) to identify the source data that needs to be moved into the target tables.
• Created functional data requirement (FDR) and Master Test Strategy documents based on the reporting requirements.
• Worked closely with the SME’s from our team as well as the upstream team to understand the functionality of the upstream to validate that the data that we are getting are correct, because the data that we consume is processed and displayed directly through the Cognos to the users.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
• Created Test Plans, Test Cases, and Test Scripts for all testing events such as System Integration Testing (SIT)
• Designed, created and executed the manual test cases.
• Created SQL queries to perform Data Validation and Data Integrity testing.
• Experience in SDLC and Agile methodologies such as SCRUM.
• Involved in Functional and Regression testing.
• Created SQL queries to compare the output of the cognos report to the logic.
• Tested the UI features of the Cognos reports.
• Run the ETL tool - DataStage to load the target tables.
• Coordinated with offshore vendor and established offshore teams and processes for code development.
• Coordinated with execution team to define the batch flow for data validation process.
• Used Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.
• Preparing documentation for some of the recurring defects and resolutions and business comments for those defects.
• Involved in the data quality issue for further analysis and resolving root cause issue for data failure.
• Coordinated with the multiple upstream teams to generate the data from one system to another and then flow into our database as we were at the downstream and dependent on getting the data for our testing purpose.
• Attended the Agile Daily stand up call from the QA team.
• Worked on creating the test data for testing the application when there is no dependency on the upstream.
• Worked on creating the tasks, test cases and defects on the agile tool, Rally

Test Analyst Onsite

Confidential

Responsibilities:

• Developing test plan and test strategy.
• Interaction with the BA’s from the client side to analyze the requirements.
• Involved in Functional and Regression testing.
• Developing and Review of the test cases written for unit and integration level.
• Execution of the test cases written and also the analysis for the results with proper description.
• Analyze and write detailed specifications and Test Requirements and map them to the Quality Centre.
• Analyzing and reporting of Defects.
• Performed data validation testing writing SQL queries.
• Effective coordination between development team and the testing team at the offshore

Test Engineer Onsite

Confidential

Responsibilities:

• Develop test plan and test strategy.
• Involved in Functional and Regression testing.
• Execution of the test cases written and also the analysis for the results with proper description.
• Interaction with the BA’s from the client side to analyze the requirements.
• Develop and Review of the test cases written for unit and integration level.
• Analyze and write detailed specifications and Test Requirements and map them to the Quality Centre.
• Prepare Test scripts and functions wherever necessary for various units of the business modules.
• Analyzing and reporting of Defects.
• Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
• Created SQL queries to compare the output of the Micro strategy report to the logic.
• Tested the UI features of the Micro strategy reports.
• Working on Quality Center for creating and documenting Test Plans and Test Cases and register the expected results

Test Engineer Offshore

Confidential 

Responsibilities:

• Develop test plan and test strategy.
• Develop and Review of the test cases written for unit and integration level.
• Execution of the test cases written and also the analysis for the results with proper description.
• Analyze and write detailed specifications and Test Requirements and map them to the Quality Centre.
• Prepare Test scripts and functions wherever necessary for various units of the business modules.
• Analyzing and reporting of Defects in Quality Center
• Effective coordination between development team, testing team and also with the Onsite team.
• Was Buffer resource in the project for the period May 2008 - Oct 2008.

Test Engineer Offshore

Confidential

• Undergone the 4-month intensive training programme on Java Technology at Mysore, India as part of the Infosys Technologies Limited on job training.
• Training programme in J2EE/JEE work stream contained coursework equivalent to the classes: computer programming, data structures, system analysis and design and relational database management systems.
• Undergone the 2-month intensive training on Testing Methodologies at Mysore, as part of the on job training.
• Training programme in testing included working session experience on HP Quality center, automation tool QTP and Performance test tool Load Runner.