PROFESSIONAL SUMMARY

• 7 years of experience in software development, Manual and Automation Testing.
• Profound knowledge in Software Test Design, Test Planning, Test Execution and Test Implementation Phases
• Experience in working in Agile Methodologies and have experience in using tools like Jira
• Highly experienced in analyzing the Business Requirement Document BRD and preparing the Test Plan and Estimations based on the requirements.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Experienced in SQL and Different Relational Databases and ETL processes
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Involved in preparing Test Scripts and executing the test cases for System Testing, Functional Testing, Integration Testing, Regression Testing, Automation Testing, UAT and Load Testing
• Experience in designing Test Scenarios from Use cases, BRDs, Business Flows using HP Quality Center
• Good exposure to defect tracking tools - Quality Center.
• Expertise in developing SQL Queries using Query Analyzer and TOAD, testing errors using SQL Statements.
• Expert in Manual and Automation Testing using Automation Testing Tools like QC
• Experience in debugging the issues and defect tracking.
• Expertise in using Interactive Test Management tool Quality Center
• Very good troubleshooting skills and knack for finding application issues
• Strong experience in working end to end execution of test cases in cross technology/cross functional environments
• Good knowledge on TCL automation for file extension of Test scripts.
• Quick learner and excellent team player, ability to meet tight deadlines under work pressure.
• Experienced in Black Box and White-Box Testing.

TECHNICAL SKILL SET

TESTING TOOLS: Quality Center, QTP.

SCRIPTING TOOLS: UNIX Shell Script

OS: Windows NT/2000/Windows XP, UNIX, Sun Solaris, Linux

DATABASE: Oracle 8.0/9i/10G, MS Access 2003, Teradata, SQL Server 2000/2005 and MYSQL 4.

ETL: Informatica 7.1/8.1, Data Stage 7.x

LANGUAGES: Java, C, C , SQL and PL/SQL.

LANGUAGE UTILITY: MS Office 2007, Eclipse, MS Visual Studio .Net

Work Summary

Confidential

QA Tester

Roles and Responsibilities

• Worked closely with BA, key business users to develop major test scenarios, developed detailed test cases to confirm BI report format, expected data results, and proper functioning of backend DW processes ETL, send/receive, etc. .
• The new website was tested by making various transactions. These transactions were then tracked to the transactional database and ETL was run to bring over the transactions to DW. Informatica ETL workflows were run to generate client required data in XML files. These XML files were validated against requirement. Typical defect lifecycle process was followed.
• Developed and executed various manual testing scenarios, test cases, test scripts and covering all aspects of functionality, regression and load testing, including data preparation, test case execution, issue resolution and providing signoff
• Testing Informatica ETL Mappings, performing black box/ white box testing and data validations against Data Warehouses.
• Utilizing Mercury Quality Center to manage test cases, test cases execution and tracking/closing defects.
• Extensively used JIRA to log and track the engineering related issues against business
• Performed full history load, delta load, data validation extensively as part of data migration from MS SQL Server and Oracle, databases. Also, performed data refresh in testing environment with production data to ensure that system functioning correctly
• Development of Informatica Mappings to do automatic validation of data on a daily basis.
• Created excel macro to automate the data comparison between two spreadsheets
• Create several procedures to perform the data quality check between SQL Server DW and Oracle DW
• Created QA mappings informatica to validate the data against source and target databases for monthly engineering releases
• Communicating regularly with QA Manger, BI Architect and BI Developers. Working without close supervision to ensure that the test strategy, test plan are appropriate and achievable.
• Extensive testing/QA experience on data warehouse application development projects.
• Supporting the QA and UAT test environments.

Environment:

Informatica 8.6, Oracle 10g, SQL Server Management studio 9.0,Flat Files, OBIEE, SSRS, MS Excel, UNIX, Windows, Quality Center 9.2,SSRS, OBIEE 11.1,Selenium, Fiddler

Confidential

QA /ETL Tester

Roles and Responsibilities

• Worked with ETL group for understating for data loading for both dimensions and facts.
• Create Project Plan with milestones encompassing Resource requisition, Environment Schedules, Start and End dates for Test Planning, Test Data and Test Execution phases
• Create Test Cases and Test Data from High-level Scenarios
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Found the defects when running the test cases and assign to ETL Developers using Defect Tracking tool.
• Create End-to-End flows for Smoke Testing and User Acceptance Testing
• Testing the different dimension tables to make sure the records are populating as per the expectation
• Upload all the test cases to Test Plan module in Quality Center and assign test cases to respective team member on the Test Lab module
• Responsible for processes like Query Log, Defect Log, Work Allocation Sheets, Daily Status Reports
• First level of Quality checks by reviewing Test Cases
• Running Traceability Matrix and identifying the Requirement gaps
• Test Case Execution for all critical and most frequently used functionalities
• Create Test Cases based on the Mapping and Parsing rules
• Communicate Change Requirements and Schedule changes to all impacted teams
• Involved in testing the new functionalities based on Test cases and coordinated with development teams in fixing the issues
• Create a Performance Test Report and submit the analysis to Test and Project Managers
• Provide input during Release Readiness review sessions
• Participate in UAT Testing, represent test teams while release implementation

Environment:

Informatica 8.6, Test Scripts, Oracle 10g, Terdata V12, SQL, Flat Files, MS Excel, UNIX, Korn Shell Scripting, Windows, QTP, Quality Center 9.2

Confidential

QA /ETL Tester

Roles and Responsibilities

• Responsible for processes like Query Log, Defect Log, Work Allocation Sheets, Daily Status Reports
• Developed Requirements Traceability Matrix RTM to track requirements during the Testing Phase
• First level of Quality checks by reviewing Test Cases
• Running Traceability Matrix and identifying the Requirement gaps
• Test Case Execution for all critical and most frequently used functionalities
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center
• Create Test Cases based on the Mapping and Parsing rules
• Attend trainings to test specific functionalities like Scheduled Diaries, Batch Jobs and Tables in the backend
• Analyze Complex Conversion Reports and Audit Reports that are generated n batch cycles on a daily basis
• Performed data integrity verification by using Perl and SQL to develop test scripts.
• Communicate Change Requirements and Schedule changes to all impacted teams
• Involved in testing the new functionalities based on Test cases and coordinated with development teams in fixing the issues
• Supported multiple teams in Functional and Automation Testing by resolving queries and analyzing automation scripts
• Wrote automation scripts to test report data using Perl scripts.
• Create Project Plan with milestones encompassing Resource requisition, Environment Schedules, Start and End dates for Test Planning, Test Data and Test Execution phases
• Create Test Cases and Test Data from High-level Scenarios
• Create End-to-End flows for Smoke Testing and User Acceptance Testing
• Upload all the test cases to Test Plan module in Quality Center and assign test cases to respective team member on the Test Lab module
• Create a Performance Test Report and submit the analysis to Test and Project Managers
• Provide input during Release Readiness review sessions
• Participate in UAT Testing, represent test teams while release implementation

Environment:

Informatica PowerCenter 8.6.1, Test Scripts, Teradata V12, Oracle 10g, SQL, Flat files, PowerPoint, Quality Center, Oracle 9i/10g, XML, Flat Files, QTP, MS Excel, UNIX, Korn Shell Scripting, Windows, Quality Center 9.2

Confidential

ETL Backend Engineer

Responsibilities

• Created Test Plan and developed a test suite for application.
• Worked with both on-site and offshore development teams for multiple projects.
• Created Manual Test scenarios for various modules of Proar Application.
• Writing the test scripts for Manual/Automation testing.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Loaded data from operational data store ODS to data warehouse tables by writing and executing foreign key validation programs to validate where exactly star schema appears, with fact tables and dimensions/lookup tables.
• Writing Triggers enforcing Integrity constraints, Stored Procedures for Complex mappings, and cursors for data extraction.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries
• Worked with ETL group for understating for data loading for both dimensions and facts.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Involved in creating the design and technical specifications for the ETL process of the project.
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
• Involved in user training sessions and assisting in UAT User Acceptance Testing .
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Developed SQL Stored Procedures and Queries for Back end testing.
• Involved in Functional testing, End to End testing and Regression Testing
• Involved in Front to Back testing for all European and Asia pacific and North Atlantic exchanges
• Preparing and supporting the QA and UAT test environments