SUMMARY

• 7+ of IT experience in the testing of Business Intelligence solutions using Data Warehouse/Data Mart,ETL, OLAP, and Client/Server Applications.
• Expertise in creating Test Plan documents and developing teststrategy documents and preparing the Traceability Matrices.
• Experience with MS Office software, Visio, relational DBMS (Oracle, MS SQL Server), SQL, Doors, Quality center, Share point.
• Expertise using Wiley, Dynatrace, Loadrunner,QTP for Performance monitoring.
• Expertise in Datacentric Testing.
• Expertise in testing involving ETL systems (Data stage and Informatica)
• Expertise in QA process and different levels of testing like unit, Functional, Regression, and Integration testing with business scenarios.
• Expertise using AML in Bank systems and Technology. .
• Expertise using winrunner for Interface Testing.
• Experience in testing involving ETL systems (Data stage, SSIS and Informatica)
• Experienced in Onsite - Offshore Co-ordination, Test Management, Test Automation, Onsite Offshore Model Process Consulting, Requirements Management, Defect Management, Release Management and Team Management. Has performed planning and testing of Client/Server and Web applications
• Strong knowledge of different development lifecycles and methodologies, including SDLC, and Agile development approach.
• 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 Oracle, SQL Server 2008, SQL Server Integration Services,
• Strong experience in test management tools like Test Director, Quality Center.
• Expertise in testing and writing SQL and PL/SQL statements.
• Good expertise in using SQL*PLUS, WinSQL, TOAD, SQL Server Management Studio.
• Experience in testing and writing complex SQL, T-SQL and PL/SQL statements.
• Experience in all aspects of project development life cycle.
• Experience with Integration testing of the applications using various sources like flat files, Sybase and oracle databases.
• Experience in debugging the issues using Informatica Workflow manager, Informatica Workflow monitor, Autosys and database.
• Proficient in working with UNIX shell scripts using PUTTY Environment.
• Involved in jobs scheduling using Autosys, monitoring and application support.
• Excellent communication skills and Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.
• Experience working on cross browser testing for various browsers Internet Explorer, Fire Fox, Google Chrome etc.
• Experience in designing, creation and execution ofTest Plans, Test Cases andTest Scripts based on defined testing standards.
• Experience inFunctional Testing, Integration Testing,Regression Testing, GUI Testing, Smoke Testing,System Testing.
• Experienced in GAP analysis and developing traceability.
• Experience in BI Reports testing usingSAS, Cognos, Business Objects andCrystal Reports.

TECHNICAL SKILLS

Operating Systems: Sun Solaris and Windows NT/2000/XP/

Programming Languages: SQL, PL/SQL, JAVA, Unix Shell Scripting, Java scripting.

Database Technologies: Oracle 10g/9i/8i,DB2 and SQL server 2005,2008

GUI: Toad, WinSQL, SAS Enterprise Manager and SQL Developer

Version Control Tools: VSS, SVN

Tools: & Utilities: Informatica, Data stage, Abintio, SAS, Cognos, Crystal Reports, Business Objects, SQL*Loader, SQL Server DTS and BCP and Import/Export, ALM

Others: SharePoint, MS Office, MS Visio, MS Project, Visual Source Safe

CASE Tools: ERWIN

Bug Tracking tools: Bugzilla, Jira, Mantis

Testing Tools: Test Director 7.0, 8.0,Quality Center 10.0,11.0, RQM

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, Delaware

ETL Tester

Responsibilities:

• Currently working with Agile development approach.
• Developed Test Plans, Test Cases, and Test Scripts for UAT tests.
• Developed shell scripts to run Datastage jobs
• Executed Datastage jobs from Windows and UNIX server.
• Used Cognos as reporting tool for testing the BI Reports.
• Generated Adhoc reports from Cognos to validate logic.
• Works for QA processing and different levels of testing like unit, Functional, Regression, and Integration testing with business scenarios.
• Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.
• Worked with Business analysts to understand Business/System requirements in order to transform business requirements into functional test cases.
• Designing, creation and execution ofTest Plans, Test Cases andTest Scripts based on defined testing standards.
• Loaded data to different databases using SQL scripts to create required test data
• Used Shell scripts extensively for automation of file manipulation and data loading procedures.
• Execute batch processing and verify the jobs status and data in database tables.
• Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required.
• Created Test Cases in Quality Center and mapped Test Cases through developed Tractability Matrix and Test Coverage reports
• Executed Test Cases using positive and negative data.
• Tracked the defects using Quality Center and generated defect summary reports
• Running the ETL Jobs for refreshing the data in Cognos reports. Running the IQ for every new or sub release for the defects fixed in Dev.
• Executed shell scripts to run PL/SQL programs, Cognos reports from Autosys and jobs.
• Validated the source system data with the staging data using SQL and Pl/SQL scripts.
• Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability.
• Tested several UNIX shell scripting for File validation.
• Provided daily and weekly status reports.

Environment: Quality Center 11, Ms Excel, Cognos 8.4.1., Data Stage, Oracle /11g10g/9i, SQL, PL/SQL, Teradata utilities, TOAD, UNIX, SQL Server Integration Services, HP Quality Center, Rational Clear Quest, Rational Clear Case, SQL SERVER 2000 and 2008

Confidential

ETL Tester

Responsibilities:

• Worked with Business analysts to understand Business/System requirements in order to transform business requirements into functional test cases.
• Responsible for reviewing Functional specs, user documentation and use cases and developing manual test cases out of it.
• Responsible for planning and directing Quality Assurance and Software change control policies.
• Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types
• Coordinated in setting up Test Environments and Test Plan needs with team members.
• Developing various Test Scripts, Test Execution using Quality Center based on the Functional Specifications.
• Executed Test Cases using positive and negative data in Quality Center’s Test Lab and reported results and defects using Quality Center’s Defects tool.
• Involved in validating the Data mart tables as per the business logic applied to the staging tables.
• Executed the test scripts against Teradata source and validated the rules according to mapping documentation.
• Testing and validation of the developed Informatica mappings.
• Testing and Validation by Datacentric Testing using Checksum comparison and Domain comparison.
• Expertise using QTP, Loadrunner, Wiley, Dynatrace for performance testing.
• Expertise in using SSIS for high performance data integration solutions.
• Expertise in using winrunner for Graphical User Interface Testing.
• Worked with Testing of Flat File and source data.
• Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.
• Validated the source system data with the staging data using SQL and Pl/SQL scripts.
• Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability
• Expertise with System Testing, Functional Testing, Regression Testing.
• Experience in writing tests with Selenium, used for load and performance tests. Used to identify functional issues. Debugging the tests.
• Prepared Traceability Matrix with requirements versus test cases.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Involved in identifying the defects and developed Defect Tracking report using HP Quality Centre which involved Bug life cycle.
• Provided daily and weekly status reports.

Environment: Quality Center 11, Selenium, SSIS, WebDriver 2.42.0, 2.43.0, Informatica Power Center 7.1.3/8.1, Loadrunner 11.52/11.51 , QTP 11/10, Fitnesse, Erwin,winrunner, Ms Excel, Oracle /11g10g/9i, SQL, PL/SQL, Teradata utilities, TOAD, UNIX, Cognos 8.4.1, SQL Server Integration Services, HP Quality Center, Rational Clear Quest, Rational Clear Case, SQL SERVER 2000 and 2008, Gateway, Master Control, IQ Assistant, Test Data Creation Tool, Altova XMlSpy

Confidential, New York

ETL/DWH Analyst

Responsibilities:

• Develop Test plans, Test Strategy, Test Cases & decided on automation when required.
• Involved in the entire project life cycle from analysis, installation, development, testing, production and end user support
• Developed Test Plans, Test Cases, and Test Scripts for UAT tests.
• Created Test Cases in Quality Center and mapped Test Cases to Requirements in Req Pro.
• Developed Tractability Matrix and Test Coverage reports.
• Managed and conducted System testing, Integration testing, Functional testing, and UAT and Regression testing.
• Loaded data to different databases using SQL scripts to create required test data.
• Used Shell scripts extensively for automation of file manipulation and data loading procedures.
• Execute batch jobs and verify status and data in database tables.
• AML used for pre and post- implementation times for data capture and monitoring.
• For fine tuning of rules to reach the desired balance between the suspicious activity alerts and false positives.
• Tracked the defects using Clear Quest and Quality Center and generated defect summary reports.
• Executed shell scripts to run PL/SQL programs and jobs.
• Executed Informatica sessions and tasks from Informatica workflow manager and validated results from database and informatica workflow monitor.
• Prepared status summary reports with details of executed, passed and failed test cases.
• Validated report layout, data with requirements.
• Validated the data using datacentric Testing with Multi-value comparisons and Domain comparisons.
• Validated report security and performance matches SLA.
• Participated in regular project status meetings related to testing

Environment: Datastage, AML, Crystal Reports, Teradata, Manual testing, Quality Center, Oracle 9i, SQL, TOAD, Java, J2EE, Java Script, HTML, XML, WebSphere5.1,SSIS,SSRS, Clear Quest,QNXT, Facets,QTP, MS Office and Windows XP,Jira

Confidential, Simi Valley, CA

QA analyst

Responsibilities:

• Developed Test Plan, Test Cases based on Functional Requirement Specifications (FRS) and System Requirement Specifications (SRS).
• Developed Test specifications and test plans for ETL and BI Reporting.
• Tested and documented Data Mappings/Transformations, and Informatica sessions as per the business requirement.
• Utilized INFORMATICA Power Center designer to analyze mapping, sources, source transformations, expressions, sequencers, normalizes, filters and targets
• Tested several Informatica Mappings which will populate the data into dimensions and Fact tables.
• Validated workflows, sessions and WORKLET to check in and check out and verifying the data loaded into the Data Warehouse.
• Validating the reports like List, Crosstab and charts. Testing the reports for number of Filters, Prompts, Calculated expressions, Drill Throughs, Master Detail Relationships.
• Checking for the sorting order and Grouping applied on the columns. Running the SQL queries against the database using Toad and checking the data integrity.
• Responsible for Testing, Defect Tracking, Logging and Regression activities
• Checking the formatting and standard fonts through all the report pages.
• Wrote SQL Queries using TOAD to ensure data quality and data integrity for Back-end testing.
• Tested Stored Procedures for the application using SQL Server 2005.
• Logged and tracked defects using IBM Rational ClearQuest.
• Worked extensively with Business Analysts, Developers and Project Managers in resolving issues critical to the business.
• Tracked and reported upon testing activities, including testing results, test case coverage, required resources, defects discovered and their status, performance baselines, etc.
• Prepared and submitted various metrics for the project

Environment: Windows 2000, Quality Center 9.2, Cognos 8.4BI, Cognos v8.1BI, PowerPlay Transformers, Informatica 8.1.1, SSIS & SSRS, Unix, Teradata, SQL Server 2000 & 2008, MS Office Tools.

Confidential

Tester

Responsibilities:

• Creating test case and test data, executing test case, reporting defects. Developed script in Winrunner.7.2.
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
• Tested all the compliance reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
• Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
• Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Tracked defects to closure by coordinating with the dev team.
• Tested source data for data completeness, data correctness and data integrity.
• Performed End to end testing starting from the source to the report.
• Conducted and coordinated integration testing and regression testing.
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Worked with the DSO team to understand the source to target mapping document and accordingly helped them to clean the source data to decrease the defects and to ensure that final data matches with the data warehouse standards.
• Prepared test data to cover all the test scenarios.
• Prepared UNIX scripts to run the informatica ETL jobs from command line.
• Maintained all the test cases in HP Quality Center and logged all the defects into the defects module.
• Tested the migration of reports from Business objects XIR2 to XIR3.
• Provided the management with weekly QA documents like Test metrics, Daily status reports, Test schedules and Test Exit Report.

Environment: Oracle 10g/11g, Business Objects, SQL Developer, SQL Server 2008, TOAD, Informatica Power Center 8.6.1, HP Quality Center,QTP, PL/SQL, UNIX, Putty, Session log files, Flat files, XML files, Remedy, SnagIT, CompareIT, MS Office, Clear Quest (CQ) and Clear Case. ASP, IIS, Javascript, HTML, Ms Access.

Confidential

QA Tester

Responsibilities:

• Performed Manual Testing on the Web Application
• Prepared Test Plan by analyzing the business requirements.
• Written test cases and functions for performing these tests using technical document.
• Performed execution of test cases manually to verify the expected results.
• Performed integration, system, functional and regression testing.
• Performed backend testing using SQL Queries.
• Performed Data Validation and Data Integrity during Backend testing.
• Figuring out problematic areas of the application that are to be tested to improve quality.
• Conducting tests using QTP as per the Test plan.
• Comparing Test results and documenting the find-outs of the test conducted.

Environment: Manual Testing, QTP, Rational Quality Manager, Java, J2ee, Oracle8i/9i, HTML, JavaScript, Weblogic and Win2k, Windows 2000, Quality Center 9.2, Impromptu v7.4, Cognos 8.4BI, Cognos v8.1BI, PowerPlay Transformers, Informatica 8.1.1, SSIS & SSRS, Unix, Teradata, SQL Server 2000 & 2008, MS Office Tools.

Confidential

QA Tester

Responsibilities:

• Designed and prepared test cases based on use cases and Functional specification.
• Executed test cases manually.
• Involved in Screen Navigation Testing.
• Functionality testing on all screens to make sure that all the objects, buttons and icons are performing according to all the specified functional requirements.
• Involved in Integration Testing, System Testing, Regression Testing, GUI Testing, Installation Testing, Compatibility Testing, Performance Testing and Smoke Testing.
• Participated in Functionality and Regression Testing.
• Bug Report generation using Test Director.
• Coordinating with the developer in fixing bugs.
• Involved in Test Cases Review for multiple MCR’s (Maintenance Change Request).
• Execution of defined test cases on each build.
• Used Client’s Bug Tracking system Remedy to reporting and track the bugs to closure
• Experience on SCD’s (Slowly Changing Dimension) to handle data for Dimension tables, Fact tables.
• Involved in data Migration testing from source to target Destination
• Participated in Test Plan Walkthrough meetings periodically with Development team and SMEs (Subject Matter Expert).
• Analyzed Test results on each phase using Quality Center.
• Worked on a Business Intelligencereporting system that was primarily functioning on Oracle Applications OLTP environment with Business Objects for Business Intelligence reporting
• Involved in rebuild testing of the Business Intelligence Reports For Business objects
• Used SQL scripts to perform backend database testing.
• Checked the reports for naming inconsistencies.
• Involved in Use Case Reviewing and BPT.
• Created Code Standard Review documents

Environment: Manual Testing, QC, Db2, TestDirector5.0, Java, JavaScript, HTML, Oracle, Weblogic and Windows NT, XML, Oracle8i, SQL Assistant, Toad, Win Runner 7.5, Quality Center 8, LoadRunner7.5, Java/J2EE, HTML, Web Logic, Unix, Windows NT.