SUMMARY

• 7 years of IT experience in testing both Business Intelligence and ETL applications
• Excellent testing experience in all phases and stages of Software Testing Life Cycle (STLC) and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Hands on experience working in Agile and Waterfall process
• Highly skilled in developing Test Plans, Test scripts, Test Matrix and Executing Test Cases
• Worked with Test Management tools like HP ALM/Quality Center 10, IBM ClearQuest, Test Director, Jira, BugZilla etc.,
• Conducted test case review and revision of surrogate key generation in DataStage to uniquely identify master data elements for newly inserted data.
• Working knowledge in Dimensional Data modeling using Star and Snow Flake schema.
• Experience in creating ETL test scenarios and test cases and deployment plan by using ETL mappings
• Extensively Tested ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica, Ab Initio
• Worked with RDBMS Technologies like Oracle 11g, SQL Server 2012, Teradata 13, IBM DB2, Sybase
• Proficient in querying various RDMS like Oracle, Teradata, DB2 and SQL server using TOAD, SQL Server Management Studio, WinSQL, SQL Loader, Oracle SQL Developer
• Solid Back End Testing experience by writing SQL queries and executing 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.
• Experience in Data Analysis, Data Validation, Data Verification, Data Cleansing, Data Completeness and identifying data mismatch.
• Knowledge of UNIX shell scripting and scheduling and execution jobs through Control M
• Responsible for mentoring resources technically and other QA Team Members.
• Experience with QA Methodology to ensure the Quality Assurance Control.
• Excellent analytical, problem solving, and communication skills, with ability to interact with individuals at all levels.
• Good in analyzing risk and issues and able to communicate to Management for determining mitigation plan in timely manner

TECHNICAL SKILLS

Data Warehousing: Informatica 9/8.5/ 8.1 (Power Center/ Power Mart), Ab Initio (GDE 1.14,/3.0.5.1) Co>Op 2.14/3.1.1.0 ), Ab Initio GDE 3.0.5.1

Reporting Tools: Business Objects 6.5/XIR2, OBIEE, MicroStrategy 8.x/ 9.x

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

Testing Tools: Test Director 7.5, HP ALM 11/Quality Center, Rational Tools

RDBMS: Oracle 11/10g/9i/8i/7.x, MS SQL Server 2012/2010/2005/2008 R2, UDB DB2, Sybase, Teradata 13/12/V2R6, MS Access 2008

Programming: UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL*Plus, PL/SQL, TOAD

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

Environment: UNIX, HP-Unix, IBM AIX 4.2/4.3, Hyperion, Win 3.x/95/98/XP/Win 7, NT 4.0, Sun-Ultra, Red Hat Linux

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

QA/DW Test Analyst

Responsibilities:

• Created test case scenarios, executed test cases and maintained defects in HP Quality Center
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Written Test Cases for ETL to compare Source and Target database systems.
• Designed and prepared scripts to monitor uptime/downtime of different system components
• Debugged the reports along with the help MicroStrategy Knowledge Base to troubleshoot some Report / data related issues.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Identifying duplicate records in the staging area before data gets processed
• Extensively written test scripts for back-end validations
• Tested jobs and used Ab Initio as an ETL tool to load the final loads.
• Worked with various Ab Initio components including ROLLUP, SCAN, FILTER BY EXPRESSION, NORMALIZE, REFORMAT, REDEFINE, DE-NORMALIZE, PARTITION components like Partition by roundrobin, partition by key, partition by key and sort, partition by percentage and deparition components like merge, interleave, Concatenate and Gather.
• Tested Customized Auto Styles to allow reports in MicroStrategy Desktop and MicroStrategy Web.
• Performed cross browser testing of MicroStrategy reports in I.E 9.
• Tested the customized Reports as per the business Requirements using MicroStrategy.
• Managed multiple OLAP and ETL projects for various testing needs.
• Performed extensive Data Validation, Data Verification against Data Warehouse
• Loading Flat file Data into Teradata tables using Unix Shell scripts.
• Responsible for ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project using Informatica, Shell Scripting & PERL
• Experienced Data Quality Testing Data Analysis, Data Validation, Data Verification, Data Cleansing, Data Completeness and identifying data mismatch.
• Testing the source and target databases for conformance to specifications
• Tracked the defects using HP Quality Center 10
• Interacting with senior peers and subject matter experts to learn more about the data

Environment: Ab Initio GDE 3.0.5.1, Co>Operating system 3.1.1.0,MSTR 9.3.1, WinSQL, HP Quality Center 10, Teradata 12.0, Teradata SQL Assistant 12.0, TOAD, Oracle 11g, PL/SQL, IBM DB2. EDI Notepad

Confidential, Richmond VA

DWH / ETL Tester

Responsibilities:

• Worked with Data Extraction, Transformation and Loading (ETL).
• Tested Complex ETL graphs based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables.
• Created ETL test data for all transformation rules and covered all the scenarios required for implementing business logic.
• Tested the ETL Ab initio graphs and other ETL Processes (Data Warehouse Testing)
• Tested metadata graphs from legacy source system to target database fields and involved in create Ab Initio DMLs
• Extensively tested Documents, Publications and Services and assisted the MicroStrategy Developer in creating Narrowcast objects.
• Conducted test case review and revision of surrogate key generation in DataStage to uniquely identify master data elements for newly inserted data.
• Created and executed test cases for DataStage jobs to upload master data to repository.
• Defined and implemented approaches to load and extract data from database using DataStage.
• Involved in designing test plans.
• Gained experience in using various Ab Initio graph components.
• Used Squirrel to execute sql queries and to verify the results from Ab Initio graph.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Involved in comparing the reports and Datamarts across different environments and testing them using the MicroStrategy Integrity Manager.
• Used Quality Center to track and report system defects
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Tested several stored procedures.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Involved in testing data mapping and conversion in a server based data warehouse.
• Check the naming standards, data integrity and referential integrity.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: Datastage, SQL Server 2005, Quality Center 9.0, Ab initio, PERL, OBIEE 10.1.3 Oracle 10g, Unix IBM AIX 5.5, T- SQL, XML Files, XSLT, XML Spy 2010, SQL, PL/SQL, MSTR 9.0.1

Confidential, Rosemont, IL

DWH/ETL Tester/BI Tester

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Scheduling the UNIX script from the CRONTAB
• Unit tested the mappings using SQL scripts.
• Tested mappings to load data into Type II slowly changing dimension tables.
• Suggested to create Oracle Indexes on some of the source tables
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Worked with SSIS system variable, passing variables between packages.
• Created cascading prompts at the universe level. These cascading prompts were used within full client and thin client reports to narrow down the selection parameters.
• Tested different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis).
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Designed and supported SQL 2000 Reporting services, Integration services and Analysis services.
• Creating test cases for ETL mappings and design documents for production support.
• Setting up, monitoring and using Job Control System in Development/QA/Prod.
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Worked on issues with migration from development to testing.

Environment: Informatica Power Center 7.1 (Power Center Designer, workflow manager, workflow monitor), Mercury Test Director 6.5, SQL *Loader, Oracle 9i, SQL Server 2005, SSIS, SSRS, Erwin 3.5, Windows 2000, TOAD 7, Microstrategy 9.0.x

Confidential, Danville, CT

DWH Developer/Tester

Responsibilities:

• Gathered business scope and technical requirements.
• Worked closely with development team during the testing phase and fixed bugs that were reported.
• Worked and managed offshore team during the course of project.
• Supported production support activities and experience as an on-call production support for the applications.
• Performed unit testing/system testing and supported user acceptance testing (UAT).
• Performed testing activities related to ETL code migrations & validations.
• Worked with Power Center in developing mappings and mapplets to extract and load the data from flat files and Oracle (source) to Oracle (target).
• Created different transformations for loading the data into targets using various transformations.
• Created reusable transformations and mapplets to use the transformation logic in multiple mappings.
• Scheduled Sessions on the Informatica Server using Informatica workflow Manager.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Involved in fine tuning queries for better performance (includes indexing and pre-joining and materializing views).
• Created views and altered some of the dimensional tables to satisfy their reporting needs.
• Provided 24*7 production supports during release.
• Compared the actual result with expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.

Environment: Informatica Power Center 6.2, Power Exchange, Oracle 9i, Erwin, SQL Server 2000/2005, Business Objects 5.0, UNIX, HP Quality Center 8.2, XML Files, Flat Files, SQL, PL/SQL