SUMMARY

• Around 7 years of IT experience in System Analysis and Design, Applications Testing; both Manual and Automated Testing of Data Warehousing, Client Server and Web Applications.
• Extensive experience in PL/SQL stored Procedures, functions, Packages (back end), Users/Privileges/Roles, Database Triggers for updating of daily transactions, reports extractions and handle validation of source data, creation of DB objects like tables (regular/partitioned), views, triggers, users, roles, index etc.
• Experienced in analyzing business requirements, system requirements, data mapping requirements and specifications.
• Experienced in writing complex SQL queries for data validations and data verifications for both ETL and BI testing.
• Superiorly well versed in the art of oral communication in coordinating technical issues between Tester and Developers.
• Extensive experience in ETL tools like Data Stage, Informatica and Ab Initio.
• Excellent knowledge of data warehouse architecture, concepts and technologies.
• Proficient in Dimensional Data Modeling using Star Schema and Snow Flakes Schema Methodologies.
• Proficient in understanding of Business Intelligence and experienced with SDLC including requirement analysis, design, development, testing and implementation.
• In depth understanding in Data Modeling, Entity - Relationship Modeling, Slowly Changing Dimension Modeling.
• Experienced in various testing like Functional, Regression, System, and User Acceptance.
• Expertise in QA process and different level of testing like Functional, Regression, System and User Acceptance testing with business scenarios.
• Experienced in creating Test Plan documents, developing test strategy documents and preparing the Traceability Matrices.
• Excellent interpersonal skills with ability to multitask and complete the project within time and budget constraints.
• Excellent team player with an ability to grasp new technology and business processes quickly and work efficiently.

TECHNICAL SKILLS

ETL Tools: Informatica 6.1, 7.1, 8.1 and Data Stage 6.x/7.x/8.x, Ab Initio (GDE 1.15, Co>Op 2.15)

Tools: Oracle SQL DEVELOPER, TERMINAL,ULTRA- EDIT,OEM(ORACLE ENTERPRISE MANAGER),Eclipse, SQL Plus, TOAD, SQL Query Analyzer, SQL Plus

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Testing Tools: Quick Test Pro 8.0, 8.2, 9.2, HP Quality Center (formerly Test Director) 8.2, 9.0, Win Runner 7.0, 7.5.

Defect Tools: Extraview, PVCS Tracker, BugZilla, Clear-Quest.

Languages: SQL, PL/SQL, JAVA,XML, Visual Basic

Databases: Oracle 8.1/9i/10g,,SQL Server 2008 R2, MS Access

Web Technologies: JavaScript, HTML 4.0, and DHTML, .NET, Java, J2EE, XML, XSD, XSLT

Scripting Languages: XML, HTML, XHTML, Shell Scripting

Operating Systems: DOS, WINDOWS XP/VISTA/7, UBANTU,LINUX

PROFESSIONAL EXPERIENCE

Confidential - Los Angeles CA

SQL/ETL Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirements specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.2
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Expert in writing Complex SQL/PLSQL Scripts in querying the database for data validation and verification.
• Defined data requirements and elements used in XML transactions.
• Tested the database schema with the help of data architects using ERWIN.
• Identified and Documented additional data cleansing needs and consistent error patterns that could diverted by modifying ETL code.
• Extensively used Data Stage for Extraction, Transformation and Loading process.
• Extensively tested several ETL Mappings developed using Datastage.
• Used import and export facilities of the application to download/upload XMLs of failed test cases so as to reverify.
• Involved in extensive validation using SQL queries and back-end testing.
• Created Test Cases and developed Traceability Matrices and Test Coverage reports.
• Read and understand the Log files to verify the process of debugging and/or test data verifications.

Confidential - Chicago

ETL Test Engineer

Responsibilities:

• Writing complex SQL queries to validate the data against the target based on ETL mapping specifications.
• Tested complex mappings and SCD type-I, SCD type II, SCD type III mappings in Data stage to load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations.
• Created complex applets for reusable purposes.
• Performed backed testing in Oracle / SQL Server My SQL database and analyzed the log files for different error codes for ETL processing.
• Wrote many SQL/PLSQL scripts to verify data in the DB and verify consistency with Web Portal BI reports.
• Extensively coordinated with the Engineering team /Product team/QA to discuss challenging issues, bugs, features faced while testing the products.
• Responsible for developing test plans, testing strategy, test cases and execution of complete test cycle for the backend for ETL and BI needs.
• Interacting with developers and trying to track/verify bugs in the corporate Bug database and ensure smooth progress and completion of the QA cycle.
• Involved in testing universes and reports for correct mapping of the objects and data correctness.
• Experience in documenting Functional, Technical Specifications and Test Cases.

Environment: IBM Datastage, Oracle 11g, SQL DEVELOPER, PL/SQL, HP Quality Center 10.0, Windows 2000/XP, Linux, XML files

Confidential

QA Analyst

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating facts and dimensions table implementation in Star Schema model based on requirements.
• Tracked defects through Quality Center and Clear Quest.
• Develop ETL test plans based on test strategy.
• Created and executed test cases and test scripts based on test strategy and test plans on ETL mapping documents.
• Tested design strategy of the Extract, Transform and Load for various ODW tables.
• Tested mappings with the Design Documents and also performed testing for various sample data.
• Created test suites for functional and regression testing.
• Use Quality Center for all test phases as a repository, test management, test execution, and test reporting activities.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Developed scripts, utilities, stimulators, data sets and other programmatic test tools as required executing test plans.
• Extensively used DataStage designer and director for extraction, transformation and loading process.
• Worked with ETL group for understanding mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL.
• Designed and developed UNIX shell scripts as part of ETL process, automate the process of loading, pulling the data.
• Validated cube and query data from reporting system back to the source system.

Environment: Oracle 8.0, SQL*Plus, SQL, Test Director, Rational Clear Quest, Clear Case, SQL Server 2000, PL/SQL, Visual Basic 6.0, Windows 95, Test Director, XML, XSLT, Java and UNIX, Korn Shell scripting, PERL