SUMMARY

• Over 7 years of experience in Software Quality Assurance and Testing of Stand Alone, Client Server, Web Based applications.
• 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)
• Experience in Software ETL and Testing Methodologies, verification and validations in all phases of the SDLC.
• 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 ETL Process.
• Extensively Used Quality Center, PVCS Tracker, Rational Clear Quest for Test Case and defect tracking management.
• Tested numerous SOA XML web services projects using Soap Sonar tool. These were system - to-system functional, regression, integration and performance tests.
• 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: Quality Center 10.0/11.0, PVCS, Rational Clear Quest, Test Director

Test Automation: Quick Test Professional 9.2/10.0/11.0

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

ETL Tools: Informatica Power Center 8.5, Ab Initio, Datastage

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

PROFESSIONAL EXPERIENCE

Confidential, East Providence, RI

Informatica/BI Test Analyst

Environment: DataStage, Ab initio, Oracle 11i, SQL, PL/SQL,SQL Server 2008, DB2, TOAD, Windows XP Professional, Cognos, SoupUI Pro, Data modeling, SAS, Win Runner, IBM Rational Clear Quest, IBM Rational Requisite Pro, Quality Center 11.0, XML, .Net, C#,XSD, Unix Shell scripting.

Responsibilities:

• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• 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.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drilldown and Crosstab reports.
• Validating data present in the Cognos Reports. Developed test cases and scripts for ETL rules in Quality Center Test Plan.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Updated the status of the testing to the ETL team and accomplished tasked for the assigned work
• Created the test data for interpreting positive/negative results during functional testing.
• Tested the ETL Informatica mappings using complex SQL queries.
• Did source identification, data collection, data manipulation and normalization and rule administration for data consolidation.
• Run various Batch jobs using telnet service (Unix)
• 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.
• 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).
• Used Toad for Data Analysts to compare Oracle and Teradata databases
• Performed System Integration Testing and Integration Testing between different modules.
• Heavily involved in interacting with UNIX Shell scripts.
• Good knowledge of Dimensional Data Modeling, Star Schema, Snow-Flake schema, FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Involved in SOAP and Restful web services using SOAP UI, axis client.
• Hands on experience in writing test scripts, preparing test data, testing Informatica Mappings and creating SQL scripts using stored procedures, functions, PL/SQL
• Extensive experience in Quality Assurance&TestingunderCapitalMarketDomain
• 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.
• Involved in Database Testing.
• Responsible for Backend testing with TOAD by comparing the Changes in the frontend FACETS 4.5. Involved in using complex SQL/Joins to query the FACETS Database
• Worked with drill down, prompts, hierarchies, calculations, formulas, sorts, drop down list, breaks etc
• 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.

Confidential, Charlotte, NC

ETL /BI Tester - Credit Card Services (Data Mart ETL Loading)

Environment: ETL (Datastage 8.1), PL/SQL, TOAD 7.0, IBM DB2, Teradata V2R6, Informatica Power Center 7.2 (Power Center Designer, workflow manager, workflow monitor), Cognos 7.0 Series, Oracle8i, SOAPUI AGILE, SQL Server 2000/2005,Java, Erwin 3.5/4.0, IBM Rational Clear Quest, Quality Center 10.0.

Responsibilities:

• Involved in the Business, Functional and ETL Requirement reviews (Deliverables Acceptance Phase).
• I have imparted and organized training to newcomers in the team regarding different technologies like SQL, PL/SQL and different processes.
• Functioned as the Onsite / Offshore coordinator and Team Lead. Participated in business, client and status meetings. Maintain project schedules using Microsoft Project.
• Created test metrics, test strategy, technical test plan, and test scope documents with relevant schedules, resource plans, risk analysis and prioritizations.
• Worked closely with project manager, supporting team and developers to assist in communicating testing results and in resolving test discrepancies across manual, functional automated and performance testing teams.
• Written several complex SQL queries for validating Cognos Reports.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Worked with business team to test the reports developed in Cognos
• Written several shell scripts using UNIX Korn shell for file transfers and clean up process.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Extract data from Mainframe data sets to compare against Target Values.
• Reported bugs and tracked defects using Quality Center 8.2 (Test Director)
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Involved in testing of Universes from different data sources like Oracle/SQL Server.
• Provided project managers with clear and concise status reports concerning the progress of work.
• Conducted walk-through for the testware created by internal / external vendors as well as team members and providing testing leadership and guidance on day-to-day testing activities
• Involved in data warehouse testing by checking ETL procedures/mappings.Trained new team members on the entire testing and report verification process.
• Validated the Web Services (SOAP), both Request and Response messages. Validated the protocols (TCP/IP, HTTP and HTTPS).
• Tested reports in Cognos using Analysis studio, Report studio and query studio.
• Attended defect resolution meetings with the development teams and worked towards bug resolution.
• Validated target table after extracting the data from source tables by running SQL queries using TOAD.
• Designed and documented requirements, scenarios and test cases using Mercury Interactive’s Test Director for a web-based B2B application used by a variety of customers in the Auto Industry.
• Worked extensively in Agile (Scrum) Methodology and participated in Sprint Planning meetings
• Involved in Functional, Integration, System, Performance, Compatibility, Smoke, GUI, Data Driven and Regression testing.
• Performed Defect Quality Analysis by creating Defect Age\Defect life Cycle Charts.
• Used HP Quality Center 9.2 for Requirements, Test case repository; Test execution and Defect Tracking.
• Generated Test Report (Results) from HP Quality Center for Test Plan and Defect Analysis.

Confidential, Wilmington, DE

Informatica Tester - (Anti-Money Laundering & BASEL II Compliance Data Mart)

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

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Attending defect triage meetings.
• Written the SQL scripts to validate ETLs developed by Informatica.
• Testing Datastage ETL jobs using complex SQL queries.
• Used Datastage Director to run and monitor the ETL job status.
• Reviewed log files for ETL jobs in Datastage Director.
• 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 ETL weekly meetings and various other meetings
• Prepared test data to validate ETL rules wherever necessary.
• Tested whether the reports developed in Cognos are as per company standards.
• Discussed Enhancement, and Modification Request issues and defects in the application.
• Tested XML extracts as per the standard schema provided.
• Experienced in writing complex SQL queries for testing data in oracle targets.
• Written several complex SQL queries for validating Business Objects Reports.
• Write SQL to validate Drilldown and Cross-Tab reports developed by Business Objects.
• 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
• Involved in Currency Validation Testing.
• Tested numerous SOA XML web services projects using SoapSonar tool. These were system-to-system functional, regression, integration and performance tests.
• Involved in Data Profiling.
• Involved in Database Testing.
• Involved in Defect prevention, productivity improvement and knowledge management activities
• Preparing metrics and reports. Create/Manage Test Cases and Test Scripts for Financial and Clinical ICD-10 applications
• Developed SQL* loader scripts to load the data into the custom tables.
• Documenting test procedures, test plans, test cases and test results.
• Wrote complex SQL syntax using case, having, connect by etc

Confidential, Cleveland, OH

ETL Tester

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

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.
• Validated ETL jobs using SQL and PL/SQL queries.
• Validated Informatica ETL mappings using Source to Target mapping document.
• 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.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Experienced in data warehouse development works involving data migration, data conversion, ETL operations using Power Center 6.2/5.1
• 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.
• The reports that were created in Business Objects were testing by running the SQL statements
• Involved in rebuild testing of the BI Reports from Cognos to Crystal Reports
• Attending defect triage meetings.
• Involved in Currency Validation Testing.
• Involved in Defect prevention, productivity improvement and knowledge management activities
• Preparing metrics and reports.
• Extensively used Cognos for report generation.
• 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.

Confidential, Cleveland, OH

ETL/BI Tester - Claims Data Processing - EDWH

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

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.
• Experience on ETL MicroStrategy tools in ETL process development, testing and in maintaining ETL codes.
• 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.
• Have the ability to evaluate an ETL/BI specification, verify it with Systems experts and data architects, and assess if it complete and fully understand EDW and ETL Architecture.
• Tested data warehouse ETL process using SSIS (Integration Service).
• Designing, developing and deploying various ETL packages for data loading (SSIS).
• 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 ETL Manager and project manager.
• Involved in production data validations for each change in all releases

Confidential

Test Engineer

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

Responsibilities:

• Created the SIT Test Plan document
• Prepared Scenarios and Test Cases based on the BRD .
• Written the SQL scripts to validate ETLs developed by Informatica.
• 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.
• Design and develop applications using Ab Initio, UNIX scripting, SQL and Autosys.
• Extracted Data from Teradata using Informatica PowerCenter ETL, and DTS Packages to the target database including SQL Server and used the data for Reporting purposes
• Automated and scheduled the Ab Initio & Informatica jobs using UNIX Shell Scripting.
• 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.