SUMMARY:

• Data warehousing and BI Tester with overall 7 years of rich experience in Software Testing/Development
• Good understanding of SDLC and STLC methodologies including Waterfall, Iterative, Agile and Scrum methodologies.
• Good knowledge on different functional areas like Retail, Health care & Banking and Financial Services.
• Solid testing experience of Functional Testing, System Testing, Writing Test Plan, Testing strategy, Testing Scenarios, Functional Test Cases, System Test Cases and Defect Management
• Strong testing Quality Assurance experience within agile environment.
• Involved in preparation of Test Metrics, Status Report and Defect Metrics.
• High degree of analytical skills.
• Worked extensively on BI, DW, Mainframe, client server and web based applications.
• Worked on all phases of Software Testing Life Cycle.
• Good understanding of onsite/offshore work model.
• Good exposure in working various test management and defect management tools like Quality Center, Jira and HP ALM.
• Good knowledge on writing SQL queries for test validation.
• Good knowledge on static/dynamic testing, black box, white box testing techniques.
• Have good understanding of Sprint Planning.
• Flexible and versatile to adapt to a new environment and ability to multitasking and work independently

TECHNICAL SKILLS:

Operating Systems: Windows XP, UNIX

Testing Tools: HP ALM, JIRA

Programming Languages: SQL, XML

ETL Tools: Informatica 9/8.6, SSIS

BI Tools: SAP BO, Cognos

Testing Methodologies: Water fall, Iteration, STLC, Agile

Databases/Database tools: Oracle 11g, 10g, SQL Server 2008, DB2, TERADATA 14

Documentation Tools: MS - Office, MS-Visio, MS Project, PowerPoint

Scheduling Tools: Autosys

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo, NY

SQL ETL Tester

• Extensively involved in understanding the BRD and mapping document.
• Helped with filling the requirement traceability matrix for enhancement of a system to support testing effort in multiple business areas including Asset Management, portfolio management and risk management.
• Developed complex SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
• Performed Regression, smoke, sanity and data quality testing writing complex SQL queries.
• Involved in analyzing the requests for new, enhanced, and modified systems, against user and business requirements.
• Responsible for validating the files availability, format and data on UNIX server
• Executed SQL queries to verify the flow of data between back end and front end.
• Writing complex SQL queries for data validation for verifying the mappings and business Rules.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data.
• Performed ETL testing and extensively used SQL functionalities. Used TOAD to connect to Oracle Database.
• Executed SQL queries to verify the flow of data between back end and front end.
• Performed Data Driven Testing of the Application for different users/data sets
• Developed Test cases for the data warehouse in Oracle System
• Conducted Functional testing to ensure that the application meets the requirements and to ensure usability readiness
• Involved in creation of defect analysis report for system Test and UAT.
• Experience in creating UNIX scripts for file transfer and file manipulation.

Environment: Informatica Power Center 9.6, SQL, Oracle SQL Developer, Oracle 9i/10g/11g, UNIX, Shell Scripting, Facets, HP-ALM 11.5x, Windows 7, SharePoint, WinSCP.

Confidential, St. Louis, MO

QA/ETL Tester

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Batch testing development and execution and done analysis of batch works.
• Written complex SQL queries for querying data against different databases for data verification process.
• Experience in creating UNIX scripts for file transfer and file manipulation
• Involved in regression testing of existing applications to the new enhancements and changes.
• Extensively involved in all phases of SDLC (Software development Life cycle) and followed Agile methodology.
• Extensively written SQL queries to validate source to target validations and data validations on reports.
• Created Test Cases, Test Plan and Test summary documents
• Participated in regression testing on Web Based applications and BI reports.
• Performed End-to-End testing of Applications.
• Extensively used HP Quality Center to create test cases, set up test lab for test execution based on Risk, Priority and Severity.
• Created Requirements traceability matrix to trace the test coverage and test execution summary
• Involved in reviewing and sign-off of the Test Plan and Test Cases.

Environment : Informatica 9.5, MySQL 5.5, Oracle 11g, flat files, SQL Developer, SQL, UNIX, Windows 7, HP-ALM 11.5x, Putty 0.63

Confidential, Walnut Creek, CA

QA/ETL Tester

• Involved in Business analysis and requirements gathering.
• Developed Test Plan and overall Test Strategy for the Application.
• Involved in preparation of technical specifications and Source to Target mappings.
• Created and executed test cases based on test strategy and test plans based.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Creating complex data analysis queries to troubleshoot issues reported by users.
• Deleting the target data before processing based on logical or physical primary key.
• Design and execute the test cases on the application as per company standards.
• Testing of records with logical delete using flags.
• Interacting with senior peers or subject matter experts to learn more about the data.
• Identifying duplicate records in the staging area before data gets processed.
• Ensured that the mappings are correct and effectively communicate testing activities and findings in oral and written formats.
• Implemented various Test cases for the Functional Testing, InterfaceTesting, smoke testing, re-testing, Regression Testing, Performance Testing, Back-End and User Acceptance testing (UAT)
• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.
• Maintaining test cases, test plan, test reports in TestRail.
• Extensively used SQL Loader to load Test data from csv files to tables.
• Reported bugs and tracked defects using JIRA.
• Worked with ETL group for understanding mappings for dimensions and facts.
• Extracted data from flat files.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Written several complex SQL queries for validating Reports.
• Extensively tested several reports for data quality, fonts & headers.

Environment: Oracle 11g, SQL, PL/SQL, flat files, SQL *Loader, Windows 7, TOAD, TestRail, JIRA, UNIX, Putty.

Confidential, El Segundo, CA

ETL Tester

• Reviewed the Business Requirement Documents and the Functional Specification.
• Written Test Cases for ETL to compare Source and Target database systems.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping &Mapplet designer and Transformation.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Tested the ETL process for both before data validation and after data validation process.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Performed Data Analysis during the requirements gathering phase by reviewing the source data model and running SQL queries
• Testing has been done based on Change Requests and Defect Requests.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Involved in integration testing of Informatica mappings.
• Performed all aspects of verification, validation including Functional testing, Unit Testing, System testing, Regression testing, structural testing, Performance, load and Back-End testing manually.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Queried Teradata Database and validated the data using SQL Assistant
• Used Quality Center to track and report system defects.
• Performed Data validity testing for reports and feeds based on client's requirement.
• Created reports that included a general overview, open bugs, new bugs and enhancement requests. Entered new bugs and maintained the current status of those bugs.
• Responsible for communicating Defect Status Reports to business in project meetings.
• Participated and Organized weekly meetings and walkthroughs to improve the testing efforts.
• Worked closely with engineering team to discuss the design and testing aspects of the applications to design the test plans and to isolate the root cause of defects.
• Involved in meetings and walkthroughs.
• Responsible for weekly status.

Environment: Informatica Power Center 8.6, UNIX, Oracle 9i, Teradata V2R5, SQL, SQL Server 2008, TOAD, Windows 7, Quality center 9.2