SUMMARY

• 7+ years of experience in Software Quality Assurance, Quality Control, and Quick Test Professional.
• Experience using query tools for Teradata, Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Experienced in writing complex SQL queries for data validation for both ETL and BI testing.
• Extensive experience in data mining, analytics, and business intelligence.
• Actively involved in analysis, design and Quality Assurance of web, client - server applications on UNIX and Windows 98/NT/2000 Platforms in Banking, Financial, Brokerage, Investments, Insurance and Retail sectors.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Extensive working knowledge in UNIX environment.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management
• Solid Back End Testing experience by writing and executing SQL Queries.
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing
• Experienced using database query tools for Oracle, SQL and UNIX such as TOAD, Teradata SQL Assistant and SQL Plus
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Experience in testing Business Report developed in Business Objects XIR3/XIR2
• Automated and scheduled the Informatica jobs using UNIX Confidential Scripting
• Experience in testing and writing complex SQL, T-SQL and PL/SQL statements
• Experienced in writing SQL queries to validate input data submitted through GUI with the actual data in the Database Analyzed Test results to meet the end user needs.
• Extensive Experience using Multi-Tire Applications and Client Server Applications.
• Experience in writing Test cases based on Business Requirements and Technical Specifications.
• Worked on User Acceptance Testing (UAT), System testing, Integration testing, Regression Testing, Black Box Testing and Backend or Database Testing.
• Strong knowledge of working with Data Marts (Star Schema and Snowflake Schema).
• Excellent knowledge and working experience in test planning, test execution and test result analysis.
• Excellent analytical, problem-solving and trouble-shooting skills.
• Strong Communication, Self Starter, Quick Learner Multilingual and Interpersonal skills.
• Expert in implementing / suggesting best practices and Understanding the complexity of the application, collecting the client’s requirements and providing the software solution to achieve his quality standards. Vast experience in entire software development process from concept definition of system specification and requirement analysis
• Good interpersonal skills, committed, result oriented and hard working.
• Experience with Mentoring and Coordinating a team of QA resources, Identifying and Managing Risks, Estimating Work, Resource sharing between the projects, tracking project progress, Delivering projects as per the deadlines.

TECHNICAL SKILLS

ETL Tools: Informatica 9.1/8.6/8.1/7.1/6.2/ 6.1 /5.1 (Power Center, PowerMart), DataStage 8.1, Ab Initio (GDE 1.15, Co>Op 2.15), SSIS

Databases: Oracle 11i/10g/9i, SQL Server 2008/2005, IBM DB2, TeradataSybase 12.5

Reporting Tools: Business Objects XIR3/XIR2 Cognos, OBIEE, SSRS, Micro Strategy

Database Tools: Oracle SQL*Plus, SQL Navigator, TOAD, SQL Server Management Studio 2008

Testing Tools: QTP, Quality Center, Test Director

Dimensional Modeling: Erwin 4.0/3.5, Star-Schema Modeling, Snowflake Modeling, Physical Data Modeling

Development Tools: Microsoft Visual Studio 2008, Visual source safe

Office Suite: MS Word, MS Power Point, MS Excel, MS Access

Rational Tools: RUP, Rational Rose, Rational Clear Case, Clear Quest, Test ManagerRational Requisite Pro

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Sr. ETL/SQL BI Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Mercury Quality Center.
• Involved in developing detailed test plan, test cases and test scripts using Mercury Quality Center for Functional and Regression Testing.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Design and development of ETL processes using Informatica ETL tool for dimension and fact file creation
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Reported software bugs to the development team using Rational Clear Quest
• 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.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Experienced in running SQL queries using Toad and SQL Navigator
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application
• Load new or modified data into back-end Oracle database.
• Set-up of Test Environment for GUI testing and Back-end testing
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R3
• Experienced in using Mercury Interactive automated Testing Tools like Quick Test Pro, Load Runner, Quality Center, and Win Runner.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
• Performed UAT (User Acceptance Testing) and executed to verify requirements, look and feel of the applications.
• Extraction of test data from tables and loading of data into SQL tables.
• Developed the test cases for Screen UI testing for all the Screen Labels.
• Interacted with QA and Development Engineers to learn about work flow, analyzed the test process, and helped develop strategies for testing products and services in an agile environment.
• Managed and executed the test process, using Agile Methodology.
• Evaluates data mining request requirements and help develop the queries for the requests.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Tested several stored procedures.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Installed, Administered, Customized and Maintained the Quality Center Environment.
• Manually tested the whole application before going onto automated testing.
• Performed database testing with SQL queries to verify data integrity using QTP.
• Used Message -Oriented Middleware infrastructure for sending and receiving messages and increasing the portability, and flexibility of an application.
• Actively involved in the daily testing status meeting in which the defects identified were discussed.
• Verify development of rule-set test scenarios, test cases, expected results and test scripts using mercury Quality center.
• Experience in Integration of Test Director with Mercury Interactive tools (WinRunner and LoadRunner) and external tools like Rational Clear Quest and Rational Clear Case
• Tested Business Objects reports and Web Intelligence reports
• Worked with Data Extraction, Transformation and Loading (ETL).
• Involved in testing data mapping and conversion in a server based data warehouse.
• Assisted in promotion of Informatica code and UNIX Confidential scripts from UAT to Production.
• Used DataStage to move data to the warehouse using the stored Procedure thereby enabling faster moment of data.
• Developed and executed test cases and verified actual results with expected results.
• Used Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Used Clear Quest for repository, reporting bugs, tracking bugs and updates on resolved bugs.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Conducted manual back-end testing on a reconfigured sales application system.
• Performed extensive Back-End testing by writing and executing SQL queries on the database-using SQL Query Analyzer.
• Contributed to design, analyzed and conducted back-end testing using SQL scripts on a database developed from Data Mining.

Environment: Informatica 9.5/9.1, Business Objects XIR3, SQL, PL/SQL, PERL, Confidential Scripting, SQL Server 2005/2008, SSIS, SSRS, SSAS, Visual Studio, .NET 2008, IBM Rational Tools, Clear Case, Clear Quest, Teradata V2R6, Cognos 8.0 Series, QTP 9.0, Mercury Quality Center 10.0, IBM DB2, Oracle, XML Files, CSV, VSAM Files, ASP.NET, ADO.Net, C#, XML, COM, JavaScript, Visual Source Safe 6.0

Confidential, St Petersburg FL

QA/ETL/SQL Tester

Responsibilities:

• Analyzed the Business and User requirements and Participated in the creation, preparation, and conduct of quality assurance reviews and Functional/Regression testing.
• Reviewed project documentation, business requirements to prepare detailed test schedules and plans.
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for reporting purposes.
• Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle.
• Performed Data mining and worked on Business Intelligence tools.
• Extensively involved in backend testing of reports with the Operational data store (ODS) in Teradata and Facets database in SQL Server.
• Tested Canned/Ad-hoc reports using Business Objects Reporter functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, @Functions, Alerts, Cascading Prompts and User Defined Objects.
• Responsible for different Data mapping activities from Source systems to Teradata
• Worked with the DW Architecture team in Testing complex Delta processing Loads
• Drafted Test Plan for flow of data from front end to back end legacy applications In a team environment, planned testing strategy for end to end flow through the system to link the front end functionality to the back end
• Responsible for testing Business Reports developed by Business Objects XIR2
• Use Business Objects OLAP Intelligence to natively access and analyze OLAP servers. OLAP Intelligence tool helps to Slice, dice, and drill directly on multidimensional sources and deliver workflows via the Web, Windows, and Microsoft Excel
• Wrote test procedures for back end validation via functional specifications
• Prepared SQL scripts for test data preparation for Back End functionality testing
• Involved in developing detailed test plan, test cases and test scripts for Functional, Security and Regression Testing.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Used Clear Quest to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
• Performed quality assurance reviews on all System Development Life Cycle.
• Involved in other test planning meetings and submitted test metrics daily to the management
• Participated in defining and executing test strategies using agile methodology.
• Written and executed the functional and regression test script using Test Script Quick Test Professional.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Worked on data mining of genomics data using and developing multidimensional analytic and visualization techniques.
• Used Quality Center as a Defect tracking tool to report the defects encountered while testing.
• Recorded and programmed quick test scripts through the expert view, by adding conditional statements, loops and other user-defined functions.
• Involved in Performance testing, Regression testing, Unit Testing, System Testing and User Acceptance Testing.
• Ran SQL queries and store procedures for data base testing for the verification of results retrieved.
• Document problem tickets and ensure appropriate follow through to resolution. Develop test automation scripts using Quick Test Professional (data driven) for regression testing.

Environment: Informatica 8.6.1, Informatica Power Center, Windows 2000, Windows XP, Mercury Quality Center, Business Objects XIR2, SQL, PL/SQL, PERL, UNIX Confidential Scripting, QTP, MS Excel, Teradata V2R5, MLOAD, FLOAD, FEXPORT, TPUMP, BTEQ, Teradata SQL Assistant

Confidential, NYC NY

Database/ETL Tester

Responsibilities:

• Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document).
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment
• Developed test cases for ETL process and reporting.
• Involved with Design and Development team to implement the requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results
• Involved in Manual and Automated testing Quality Center.
• Used Informatica Power Center Workflow Manager to run the workflows.
• Used Informatica Power Center Workflow Monitor to review the session log files.
• Conducted Black Box - Functional, Regression and Data Driven.
• Defects tracking, review, analyzes and compares results using Quality Center.
• Created reports using Business Objects functionalities like Slice & Dice, Drill Mode, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Participating in the MR/CR review meetings to resolve the issues.
• Defined the Scope for System and Integration Testing
• Document and publish test results, troubleshoot and escalate issues
• Preparation of various test documents for ETL process in Quality Center.
• Involved in Test Scheduling and milestones with the dependencies.
• Experienced with UNIX environment and VI editor.
• Used Toad to write SQL and query Oracle database.
• Optimizing/Tuning several complex SQL queries for better performance.
• Functionality testing of email notification in ETL job failures, abort or data issue problems.
• Created and executed test cases for ETL jobs to upload master data to repository.
• Responsible to understand and train others on the enhancements or new features developed
• Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
• Modified the automated scripts from time to time to accommodate the changes/upgrades in the application interface.

Environment: SQL, Informatica Power Center 7.1, QTP 9.2, Business Objects 6.1, Mercury Quality Center 9.0, Oracle 9i, Toad, UNIX, Windows XP.

Confidential, Houston, TX

Backend SQL Tester

Responsibilities:

• Perform and schedule administration tasks like Backup and Restore Database.
• Database space management, Monitoring Performance and Alert Management.
• Creation of New user Logins and grant privileges to users/Groups and objects.
• Installing software upgrades for SQL Server.
• Involved in reviewing and designing table additions, changes, deletes according to the Database Change Request form.
• Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also Responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Involved in Data/package Migration from MS SQL Server 2000 instances to 2005.
• Designed various DTS packages to import/export data from heterogeneous files.
• Involved in Creating SSIS packages to integrate the data coming from various data sources.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Involved in generating reconciliation reports using SSRS.
• Implemented and maintained snapshot and transactional replication.
• Working in active 24x7 on call support.
• Monitoring various Jobs for Program Completion Tasks, Task Management and Reconciliation Process running at specified Schedules.
• Trouble shooting the issues incurred while executing the Jobs.

Environment: Java, XML, HTML, DHTML, Web Sphere, Test Director, Toad, Oracle 9i, SQL, PL/SQL, UNIX, Confidential Scripting and Win NT