SUMMARY:

• 7 years of IT experience in Quality Assurance for ETL, Business Intelligence, Data Warehousing, Web based, Client/Server applications using Manual and Automated testing tools.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture
• Gathered and articulated business requirements in order to oversee the development of test plans and test scripts.
• Extensive experience with test management and test automation tools like Quality Center Test Director, Quick Test Professional, and Rational Clear Quest
• Extensive experience in ETL and BI testing for many data extractions and data migration projects.
• Excellent skills in Informatica, AB Initio, Teradata, DB2, SQL Server and Oracle 9i/8i RDBMS.
• Well versed with SQL, PL/SQL and can write complex SQL queries to validate the data conditions against any database including Sybase, Teradata, SQL Server, DB2 and Oracle
• Proficient in development, execution, maintenance of Test Plans, Test Cases, Test Scripts, Test Specifications, Test Scenarios and Traceability Matrix
• Experience in testing XML files and validating the data loaded to staging tables.
• Solid analytical and dynamic troubleshooting skills
• Highly experienced in various features of MicroStrategy like managing multiple projects, project migration and defining standards, procedures for development, production environment and maintenance of these environments to ensure the security
• Experience in complex Manual and Automation Testing of GUI and functional aspects of the client - server and web based applications in all phases of SDLC.
• Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Data Stage.
• Experience in Functional, Regression, GUI, Usability, Integration, Exploratory, Smoke, Backend, ADHoc, Load, Performance, Black Box and White Box Testing
• Experience in Mainframe Testing
• Proficient in SQL queries.
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
• All testing engagements completed within project timelines and consistently met live-date project deadlines.
• Experience in writing test plans, defining test scenarios and test cases, developing and maintaining test scripts based on business and functional requirements, documented all phases of QA process.
• Strong in Web application testing and understand architecture in terms of functionality.
• Good experience in Authoring and Reviewing test cases.
• Involved in the Implementation of QA testing Process, and involved in documentation of Test Scenarios, Test Cases, and Test Scripts for Various Applications.
• Excellent Communication, Analytical and Interpersonal skills.

TECHNICAL SKILLS:

Database: Oracle 10g/9i/8i, SQL Server 2005/2008, IBM DB2, Teradata V2R6, Sybase12.5

Change Mgt Tools: Test Director 8.0, Quality Center 10/9.2/8.2, Rational Clear Quest

Data Warehouse Tools: Informatica 8.6/8.1/7.1/6.2/5.1, SSIS, MS DTS Packages, Ab Initio, Data Stage

Functional Test Tools: WinRunner 7.0, Quick Test Pro 8.2/8.0, Load Runner 8.0

BI Tools: Cognos 8.0 Series & Business Objects XIR3

Languages: PL/SQL, T-SQL, SQL, XSLT, Visual Basic, PERL, Shell Scripting

Office Tools: MS Office Suite, MS Project, Microsoft Share Point

Operating System: UNIX, LINUX, Windows, MS-DOS

Rational Tools: Requisite Pro, Clear Case, Clear Quest, Manual Tester

Standards: VSTF 2008, METAL, SQL Server Analysis Server

Tools: TOAD 9.2, Win SQL, Teradata SQL Assistant, SSAS, SSRS, XML Spy 2010

Web Technologies: XML, HTML, JavaScript, VBScript

PROFESSIONAL EXPERIENCE:

Confidential, St.Louis, MO

Sr. ETL QA Tester

Roles & Responsibilities:

• Attended meetings with the Business Team, and Build Teams to gather the information about the project and the design methodology and the testing requirements
• Maintained the Traceability Matrix between Requirements, Design Components, Test Cases and Defects.
• Participate in weekly meeting with the management team and walkthroughs
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
• Involved in developing test cases to test Teradata scripts (Bteq, multiload, fastload).
• Wrote the Insert, Update, Delete and Error Processing test cases in all the stages.
• Wrote PL/SQL stored procedures for certain data validations
• Involved in testing Microstrategy reports including conditional formatting testing and threshold testing.
• Used Quality Center for test planning and execution and Rational Clear Quest was used for defect tracking.
• Validated the interface from Frontend to backend tables.
• Experienced in working with databases like Access, Oracle, DB2 and SQL Server.
• Performed Sanity testing, Security testing, black box and white box testing, web testing and GUI testing
• Performed testing on Java, .NET and on web based applications
• Created Test Cases and scenarios for Unit, Regression, Integration as well as Back - end and System testing.
• Was involved in executing the Regression testing on new Builds
• Participated in various meetings and discussed Enhancement and Modification Request issues
• Developed SQL queries in Toad and DB Artisan to achieve the data transformations
• Managed test environments and schedules
• Tested data feeds from XML to Database.
• Created, updated and ran the QTP scripts.
• Coordinate and tested the deployment procedure for MicroStrategy changes to the Production.
• Validated all the applications and successfully executed and unit tested the jobs with Data Stage director.
• Used Microsoft Excel and Access to test small amount of data imported from different database management systems like SQL Server, DB2 and Oracle.
• Worked with Test Analysts to ensure that defects are tracked and documented and results communicated to developers and stakeholders.
• Expert in writing Complex SQL/PLSQL Scripts in querying Teradata and Oracle.
• Trained the users for the User Acceptance Testing(UAT) and explained about each link, tab and search functionalities to the users
• Extensively worked with Metrics, Filters, Transformations, Custom Groups, and Consolidations using MicroStrategy tools.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Performed testing on web services using SOAP UI 2.0 & 2.5
• Tested the ETL Data Stage jobs and other ETL Processes (Data Warehouse Testing)
• Generated testing reports and metrics, trend graphs according to the test plan
• Created and executed SQL queries in ORACLE and MS SQL server
• Performed tests on various browsers
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: Data Stage 8.0, Teradata V2R6, Microstrategy, MS SQL Server 2008, Oracle 11g (SQL, PL/SQL), TOAD, MS Access, XML, XSLT, DB2, Citrix Server, QTP 9.2, Quality Center 10.0, XML, XSD, XML Spy 2010, J2EE, Rational Clear Quest

Confidential, Buffalo, New York

ETL QA Tester

Roles & Responsibilities:

• Developed unit test cases, configured environments and prepared test data for testing.
• Wrote PL/SQL /Complex SQL queries for system testing.
• Performed data quality test to determine whether processed data is correctly extracted, transformed and loaded.
• Worked with Business analysis team to prepare a detailed Business Requirement documents.
• Involved in writing & implementation of the test plan, various test cases & test scripts.
• Performed Functionality, Stress, Security, GUI & Regression testing of web-based applications.
• As QA Tester, performing responsibilities with both the functionality and back end testing.
• Wrote SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Worked with Production environment to resolve several data issues.
• Tested ad hoc and canned reports for Microstrategy
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Also worked with MS Access database for testing the data from SQL Server, DB2 and Oracle
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• 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.
• Extensively used Teradata load utilities Fast load, Multiload and FastExport to extract, transform and load the Teradata data warehouse
• Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.
• Tested Microstrategy reports for Report layout, Attributes/Metrics, positions, Totals & Grand Totals, Drilling options, Metric Calculations, Drill Maps, and Security filters.
• Tested several reports and automated using Quick Test Pro.
• Written several Stored Procedures and modified existing stored procedures.
• Involved with extraction routines to verify all the required data loaded into target systems.
• Extensively executed SQL queries in order to view successful transactions of data and for validating data.
• Was involved in analyzing scope of testing the application. Test Strategy was created to test the all modules of the Data Warehouse.
• Worked with Quality Center and Clear Quest for Defect Management.
• Design and development of ETL processes using Data Stage ETL tool for dimension and fact file creation.
• Created the test data for interpreting positive/negative results during functional testing.
• Involved in the whole testing life cycle covering the entire project from initiation to completion
• Analyzed and created the bug tracking reporting and summary report in the Quality Center
• Used HP Quality Center to state requirements, business components, test cases, and test runs for every iterations, defects. Also link defects with requirements.
• Reported software mismatches (from the test planning), to the development team using Quality Center.
• Used Microsoft Excel and Access to test small amount of data imported from different database management systems like SQL Server, DB2 and Oracle.
• Evaluated QTP for automation & created various GUI checkpoints using QTP.
• Used SQL queries and custom programs to perform data validation.
• Experience in data analysis and data testing. And verified fields present in the reports are as agreed in the ETL specifications.
• Extensively involved with backend testing by writing complex SQL queries.
• Worked closely with the development teams to replicate end user issues.

Environment: Data Stage, Oracle 10g/9i, SQL Server 2000, Teradata V2R6, Teradata SQL Assistant, SQL, PL/SQL, Stored Procedures, DB2 8.0, HTML, Java Script, Quick Test Pro 8.0, Quality Center 9.0, Points Portal, Autosys, MS Office Suite, PERL, Microstrategy,UNIX.

Confidential, Boston, MA

SQL Tester

Roles & Responsibilities:

• Worked closely with the development teams to replicate end user issues.
• Performed functional test and load test on SQL queries, store procedures and forms.
• Modified the design as per the changes in requirements.
• Interacted with the client on a daily basis and attended status meetings.
• Worked with developer to improve database performance.
• Created and maintained development, QA and audit database environments
• Attended status meetings and sending team status reports.
• Personalized Cognos Connection for specified display options for testing regional options and personal information.
• Use of TOAD to write SQL queries and validate the backend
• Documentation of Test Results, Test Reports and Test Summary Report.
• Performed Database Testing using SQL queries for testing reports.
• Defined QA procedures to plan, design, execute, evaluate and report results of software testing under minimal or no supervision.
• Defect logs were created in Quality Center and coordinated with Development team in fixing the defects.
• Day-to-day Cognos administration activities like monitoring Scheduled jobs like Cube refresh, Impromptu scheduled reports, Backup and recovery maintenance.
• Worked with QA team members and application developers; quickly capture the major business functions and technology to design and implement tests of system functionality that exercise all critical intersystem integration points.
• Reported the defects in Quality Center and documented the report.
• Utilized mercury test suite for requirement management, test case creation, execution and defect tracking.
• Provided training and mentoring to offshore QA team.
• Tested many Ab Initio graphs and tested the functionality of ETL mapping rules.
• Wrote PL/SQL stored procedures for certain data validations

Environment: PL/SQL, SQL, Quality Center, UNIX, Shell Scripting, Ab Initio (GDE 1.12, Co>Op 2.12), MVS, JCL, VSAM Files, XML Files, CSV, COBOL II, Copy Books, Autosys, Crontab, Oracle 10g, Sybase 12.3, Cognos 7.0, TOAD, WinSQL

Confidential, Atlanta GA

SQL/ETL Tester

Roles & Responsibilities:

• Used TOAD to write SQL and validate the backend
• Used SQL Teradata Assistant for data retrieval from Teradata
• Identified bugs and interacted with team lead and developers to resolve the bugs
• Used Back-end testing using SQL queries to validate the data in the back-end Oracle Database
• Test several ETL Ab Initio graphs against ETL transformation rules.
• Maintained the test matrices and reported bugs using Rational Clear Case
• Created Test Strategy and Test plan for the testing effort
• Conducted Smoke, Non Functional, Functional, System and Integration testing.
• Developed SQL and Stored procedures to achieve the data transformations
• Performed back-end testing on the Oracle database by writing SQL queries
• Conducted backend testing using Toad
• Participated in weekly meetings with the management team
• Involved in the Implementation of QA testing Process, and involved in documentation of Test Scenarios, Test Cases, and Test Scripts for Various Applications.
• Performed the back end testing by using SQL Queries and verified the data integrity.
• Coordinated with the developers to resolve defects.
• Involved in documentation in order to maintain and run scripts for future enhancements.

Environment: Ab Initio (GDE 1.12, Co>Op 2.12), Autosys, SQL, Business Objects 6.1,T-SQL, SQL Server 2000/2005, Teradata V2R4, Test Director, MS Office Suite, IE, ASP, Crystal Reports,, HTML, JAVA, JSP, JavaScript Windows NT/XP/2000, Rational Clear Quest/Clear Case

Confidential

QA Tester

Roles & Responsibilities:

• Worked on gathering requirements for loan level and pool level amortization process.
• Prepared detailed business requirement documents.
• Reviewed the Business Requirement Documents and the Technical Specification.
• Developed Test Cases to cover overall quality assurance testing.
• Performed manual testing on different modules of the application.
• Performed System Testing and Integrity Testing using WinRunner.
• Developed, tracked and managed Issues Log created during the test phase using Excel.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Prepared Test Plan from the Business Requirements, detected defects, tracked and reported bugs using Test Director.
• Performed data integrity testing by executing SQL statements and manually verifying the contents.
• Used SQL on UNIX platform to perform Backend Testing on databases.
• Performed extensive database testing.
• Performed Load Testing, Stress Testing and Performance testing using LoadRunner.
• Involved in writing testing methodology by following standards for test documentation, test requirements and test procedures.
• Responsible for weekly status meetings showing progress and future testing efforts to the QA Manager.
• 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.
• Maintain SQL scripts for creation of database objects.

Environment: SQL, PL/SQL, Autosys, Test Director, JSP, Java Script, HTML, Windows NT/2000, UNIX