SUMMARY

• Over 8+ years of experience in Software Quality Assurance and Testing of Stand Alone, Client Server, Web Based applications, Data Warehousing, BI and ETL Testing.
• Expertise in Business Requirement gathering through JAD sessions, interviews, workshops and walkthroughs, and main concentration in Business Process Flow and Business modeling tools as a Business analyst
• In depth technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Experience in Software QA and Testing Methodologies, verification and validations in all phases of the SDLC.
• Expert in review and analyze requirements, use cases, technical specifications and database designs.
• Expert in Develop Test Plans, Test Designs, Specifications, Test Cases and Scenarios.
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Experienced in documenting defects, generate defect and test progress graphs with overall test summary.
• Knowledge of and ability to apply a wide range of software test engineering concepts: testing principles (Testing Methodology) and concepts, building a test environment, tracking defects in Quality Center
• Strong technical Knowledge of UNIX Utilities, shell Script to automate process.
• Ability to manage multiple project in testing by managing team, automate process and delivered all task.
• Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.
• Extensively involved in SIT and UAT by supporting Testing and implement QA Process.
• Extensively Used Quality Center, PVCS Tracker, Rational Clear Quest for Test Case and defect tracking management.
• Expert in working with various cross geo teams across the world with various time zones.
• Excellent interpersonal and communication skills with good learning curve in short span of time.
• Ability to work in a Team or individually and very flexible to work in complex environment with tight schedules

TECHNICAL SKILLS

Operating Systems: Windows XP/ 2000 Professional /98/NT, Unix, MVS

Languages: PL/SQL, Shell Scripting, PERL, Java, SQL

Database: ORACLE, SQL Server, Teradata, Sybase, DB2 and MS Access, OLTP, OLAP

Application Servers: WebLogic, Web Sphere

Testing Tools: PVCS, Rational Clear Quest, Test Director, Quality Center

Test Automation: Quick Test Professional

ETL Tools: Informatica, Data Stage, SSIS, Ab Initio

BI Tools: Business Objects XIR4, Cognos Series 8.0, Crystal Reports, Hyperion, OBIEE

Hardware: IBM ES/9000 and IBM compatible PC’s

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, OH

SR SQL Database Test Analyst

Responsibilities:

• Retested resolved bugs on each build release
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems
• Performed Functional Testing and Back - end Testing using the database comparable results Manually
• Tested the messages published by Informatica and data loaded into various databases
• Generated/Tested reports using free-hand SQL which had complex Business Logics for testing environment.
• Was involved in analyzing scope of testing the application.
• Test Strategy was created to test the all modules of the Data Warehouse.
• Validating data present in the Cognos Reports.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments.
• Performed data analysis and data profiling using SQL and Informatica.
• Ported all QTP test cases to Quality Center.
• Prepared reusable function in QTP to use across the automation scripts.
• Experienced with automated software testing tools Quick Test Professional (QTP),
• Data Explorer on various sources systems including Oracle and Teradata.
• Extensively used Informatica power center for extraction, transformation and loading process
• Extensively used Informatica power center for extraction, transformation and loading process.
• Updated the status of the testing to the QA team and accomplished tasked for the assigned work
• Created the test data for interpreting positive/negative results during functional testing.
• The reports that were created in Business Objects were testing by running the SQL statements against the tables in the Oracle Database.
• Managed the QA Team of the Project in an Offshore - Onshore Model
• Ran various Batch jobs using telnet service (Unix)
• Participated in Web services testing using SOAP UI for BOA private banking project.
• Tested web services using SOAP UI (SOAP Web Services).
• Tested the Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Automated the entire Aggregation module using Win Runner, for Regression Testing.
• Used Bugzilla and HP Quality Center for Bug Reports and Defect Tracking.
• Performed Risk Analysis based on Defect Severity and Priority.
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries
• Validated the data of reports by writing SQL queries in PL/SQL Developer
• Tested User Interface inconsistency and application functionality.
• Developed test scenarios for testing EDWH and Credit Data Mart data in Oracle environment.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Performed System Integration Testing and Integration Testing between different modules.
• Heavily involved in interacting with UNIX Shell scripts.
• Hands on experience in writing test scripts, preparing test data, testing Informatica Mappings and creating SQL scripts using stored procedures, functions, PL/SQL
• Analyzed Business Requirements and Developed the Test Plan, Test Scripts and Test Cases
• Developed Test Plan and Test Cases for the entire module of Data mart.
• Identified the Test Cases to be automated and lead the effort for automating the product.
• Ran test cases for the warehouse in Oracle.
• Worked with drill down, prompts, hierarchies, calculations, formulas, sorts, drop down list, breaks etc
• Worked with business team to test the reports developed in Business Objects
• Well versed with SQL performance tuning techniques and suggested effective SQL scripts to DBA’s for faster retrieval of data in QA database.
• Accelerate the rate of adoption of the system, improve the quality of the data being input and generated, and promote accountability amongst the staff and users.
• Made recommendations on potential functional and technical improvements to planned or existing system components and applications.
• Tested whether the reports developed are as per company standards.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: Informatica 8.6.1, Oracle, SQL, PL/SQL, DB2, TOAD, ERWIN, Windows XP Professional, Business Objects XIR3.1, Cognos, Win Runner, Bugzilla, Quality Center 10, XML, XSD, Unix, Shell scripting.

Confidential, Buffalo, NY

QA /PL/SQL Test Analyst

Responsibilities:

• Reviewed and analyzed Business Requirements and clarified with Business Analyst.
• Written several UNIX scripts for invoking data reconciliation.
• Used SQL queries to retrieve data from tables and to perform back-end testing.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Reviewed High Level and Lows level Design docs and clarified design solutions with Developers
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing.
• Developed the ETL and BI testing strategy.
• Extensively used Informatica client tools.
• Tested web services using SOAP UI (SOAP Web Services).
• The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• 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.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Involved in testing the Cognos reports by writing complex SQL queries
• Extensively executed T-SQL queries in order to view successful transactions of data.
• TOAD is used to perform manual test in regular basis.
• Creation of automated test scripts using QTP.
• Evaluated QTP for automation & created various GUI checkpoints using QTP.
• UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
• Wrote SQL queries to validate source data versus data in the data warehouse
• Identified duplicate records in target tables.
• Tested several reports developed using Business Objects.
• Experienced in writing test cases, test scripts, test plans and execution of test cases
• Involved in all walk throws for test designs, data designs and code reviews.
• Developed Test Plan, Test cases & Test Scenarios for new features.
• Validating BEX Reports and Cognos Reports.
• Updated existing Regression Test cases for impacted features due to new features.
• Tested the Application in UNIX Environment and collecting the Test data from the Business Team
• Identified the Test Environment for Database Testing.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Used T-SQL for Querying the SQL Server database for data validation.
• Writing the test scripts for manual testing.
• Understand the database development for this project.
• Reviewing the database Test cases and performs the Database Testing when writing the SQL queries.
• Executed the Stored procedure when passing the valid/Invalid Parameters.
• Involved in Data migration and Data distribution testing.
• Execute the database Test cases according to release.
• Analyze the results and log the defects in bug tracking tool
• Retested resolved bugs on each build release
• Communicate with Db Developers and DBA

Environment: SQL Server 2008, SSIS, Informatica Power Center 7.2, HP Quality Center 10.0, PVCS, SQL, PL/SQL, T-SQL, Data Stage 8.1, XML, XSD, UNIX, IBM AIX 6.1, Shell Scripting, PERL 5.12.1, XML Spy 2008, Flat Files, Main Frame VSAM Files, CSV Files, Excel, Oracle 10g, Teradata V2R6, Business Objects XIR3, TOAD

Confidential, Boston, MA

Database Test Engineer

Responsibilities:

• Attending defect triage meetings.
• Wrote PL/SQL /Complex SQL queries for system testing.
• Extensively executed SQL queries in order to view successful transactions of data and for validating data.
• Extensively used Informatica tool to extract, transform and load the data from Oracle to DB2.
• Participated in QA weekly meetings and various other meetings
• Discussed Enhancement, and Modification Request issues and defects in the application.
• Tested XML extracts as per the standard schema provided.
• Tested XML for correct values, tags, data elements, sequence and order.
• Used XML spy to validate XML against the Standard XML schema.
• Tested the application if the correct values are displayed after a change made in XML and the functionality
• Validated the data in the database using database checkpoints
• Involved in Currency Validation Testing.
• Involved in Data Profiling.
• Involved in Defect prevention, productivity improvement and knowledge management activities
• Preparing metrics and reports.
• Documenting test procedures, test plans, test cases and test results.
• Wrote complex SQL syntax using case, having, connect by etc

Environment: SSIS, SSAS, SQL Server 2008/2005, SQL Navigator 5.0, Informatica 8.1, Cognos 7.0 Series, Quality Center 9.0, Oracle 10g, DB2 8.x, IBM AIX 5.5, MVS, ISPF, VSAM Files, Flat Files, XML Files, Shell Scripting, PERL, XML, XSD, TOAD, WinSQL

Confidential, Beaverton, Oregon

DWH Tester

Responsibilities:

• Interacting with Business Analysts and Development teams to understand the business requirements and giving the estimates from testing prospective.
• Test plan preparation, preparing daily status reports and defect reports.
• Involved in prioritizing the requirements according to business needs and putting all the requirements in QC.
• Involved in writing and executing the test cases.
• Involved in Defect reporting and verification.
• Involved in identifying the cause of Defect and reporting the same to developers.
• Validating the data between SAP R3 and Tera Data Staging.
• Validating the data between Tera Data Staging and EIS Data Store by using SQL Statements.
• Testing the data present in fact tables and dimensions tables.
• Involved in Data Validation, Data Conversion and Data Reconciliation Testing.
• Involved in HUT (Hard unit testing), SIT (System Integration Testing) and WIL (Week in Live Testing) Testing.
• Attending defect triage meetings.
• Involved in Currency Validation Testing.
• Involved in Defect prevention, productivity improvement and knowledge management activities
• Preparing metrics and reports.
• Documenting test procedures, test plans, test cases and test results.
• Wrote complex SQL syntax using case, having, Group by etc
• Excellent knowledge on Agile Methodology.

Environment: SAP BW, SAP R3, SQL Navigator 5.0, Tera Data V5R12, SQL Assistance, Cognos 7.0, Quality Center 9.0, Oracle 10g, UNIX, Informatica 7.1, XML, XSD, XML Spy

Confidential

ETL Tester

Responsibilities:

• Reviewed Client Requirements, Use Cases, and High Level and Low level Design documents for the changes in each release.
• Reviewed Mock Ups, Technical specifications, and Data design documents for data changes.
• Developed Test Plans, and Test cases based on requirements, and technical and design specifications
• Wrote and ran UNIX Scripts for batch jobs.
• Ran UNIX shell scripts to count the records for EDW source to staging tables.
• Ran SQL queries to verify the number of records and validated the referential integrity.
• Developed Test data requirements and data dependencies, and conditions for all test cases.
• Performed Functional, Integration, and Regression testing
• Testing ETL sessions and PL/SQL scripts for multiple feeds and multiple LOB’s
• Identified Test scenarios for Automation for critical functionality.
• Developed Automation test scripts, and run the scripts as part of regression testing.
• Quality Center used for Test Cases development and test execution status tracking.
• Validating the data between Tera Data Staging and EIS Data Store by using SQL Statements.
• Testing the data present in fact tables and dimensions tables.
• Performed Data Validation, Data Conversion and Data Reconciliation Testing.
• Coordinate with the development team in test case execution and collecting test results
• Preparation of Traceability Matrix
• Coordination with UAT team
• Defects found tracked and managed in Quality Center and disposition in defect scrub meetings.
• Represented in Project and Defects scrub meetings, and provide status on assigned tasks.
• Testing status reported to QA Manager and project manager.
• Involved in production data validations for each change in all releases

Environment: Windows XP, Unix SQL Navigator, Oracle Web Cache server, Oracle Application Server, Oracle 10G database, Oracle Reports Generator, Test Director, PL/SQL, and ITG HP. Data Migration, XML, Teradata V2R5, Informatica 7.x

Confidential

Test Engineer

Responsibilities:

• Created the SIT Test Plan document
• Prepared Scenarios and Test Cases based on the BRD
• Prepared MIS reports for the Senior Management
• Weekly Project Status Meeting with Senior Management
• Daily SIT Issue meeting with BA’s and Development Team
• Log defects in Defect Log sheet
• Written SQL queries to access the data in the Mainframe DB2 database to execute back-end testing.
• Submitted batch jobs using JCL.
• Retested defect fixes and report to Development
• Coordinated with the BA and Development team in defect fixes
• Coordinated with the development team in test case execution and collecting test results
• Verified traceability of Test Conditions to Test Cases.
• Tracked all defects in the Test Director and update status test life cycle and disposition
• Developed Defects, Test Status reports with Charts from Test Director and provide to team
• Production test data created early, for the production test case execution.

Environment: VB Script, XML, Mercury tools (Win Runner, QuickTestpro, LoadRunner, FACT), Windows 2000, Windows XP SP2, VM Ware 6.0, VM Lab Manger, Java, JSP, JDBC, C ++, Web Logic 7.0, and Oracle 9i, HP Quality Center