SUMMARY

• 6 + 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
• Involved in Manual and Automated testing using QTP and Quality Center
• 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 creating ETL test scenarios and test cases and deployment plan by using ETL mappings
• Strong experience in Data Analysis, Data Validation, Data Profiling, Data Verification, Data Loading.
• Working knowledge in Dimensional Data modeling using Star and Snow Flake schema.
• Solid Back End Testing experience by writing SQL queries and executing shell scripts
• Experience in Data Analysis, Data Validation, Data Verification, Data Cleansing, Data Completeness and identifying data mismatch.
• Prepared Informatica test environment and used all ETL components/transformations while testing the ETL flow and ran the jobs on back ground.
• Created ETL test data for all ETL mapping rules to test the functionality of the ETL process based on mapping document.
• Tested the ETL flow and other ETL Processes (Data Warehouse Testing)
• Knowledge of UNIX shell scripting and scheduling and execution jobs through Control M
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica
• Excellent analytical, problem solving, and communication skills, with ability to interact with individuals at all levels.
• Responsible for mentoring resources technically and training other QA Team Members.
• Experience with QA Methodology to ensure the Quality Assurance Control.
• 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.x/8.x/7.1(Power Center/ Power Mart)

Reporting Tools: Business Objects 6.5/XIR2, OBIEE 10g\11g, 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, Columbia, MD

ETL/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
• Managed multiple OLAP and ETL projects for various testing needs.
• Written extensive PERL and UNIX Shell scripting for data parsing and text parsing needs including archiving the old data, running backend jobs & setting up of job dependencies.
• Performed extensive Data Validation, Data Verification against Data Warehouse
• Tested several data migration application for security, data protection and data corruption during transfer
• 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 .
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Experienced Data Quality Testing Data Analysis, Data Validation, Data Verification, Data Cleansing, Data Completeness and identifying data mismatch.
• Developed QA Automation using Excel Macros for the Data Migration Testing
• Tested several BO Reports for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI’s, Grouped List, Cascade and Web Reports.
• Tested and validated the BO reports by running similar SQL queries against the source system(s).
• Tested several Informatica Mappings to validate the business conditions.
• Testing the source and target databases for conformance to specifications
• Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center 10
• Designed and prepared scripts to monitor uptime/downtime of different system components
• Written Test Cases for ETL to compare Source and Target database systems.
• 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
• Involved in preparing test data/ Test script for UAT and participated in UAT signoff
• Interacting with senior peers and subject matter experts to learn more about the data

Environment: Informatica 9.1, Business Objects XIr4, WinSQL, HP ALM 11/10, Teradata 12.0, Teradata SQL Assistant 12.0, Autosys, TOAD, Oracle 11g, SQL,IBM DB2.EDI Notepad.

Confidential, Rochester, MN

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.
• Extensively tested Documents, Publications and Services and assisted the Microstrategy Developer in creating Narrowcast objects.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required and performed smoke tests.
• Involved in testing VBA macros to populate data from Microstrategy Reports to Excel files.
• Performed data validation in Microstrategy reports.
• Involved in comparing the reports and DataMart 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
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Performed database testing with SQL queries to verify data integrity using QTP.
• 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.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• 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: Informatica Power Center 8.6.1,SQL Server 2005, Quality Center 9.2, QTP 9.2,Oracle 10g,SAS, Unix IBM AIX 5.5,T- SQL, XML Files, XSLT, XML Spy 2010, SQL, Autosys, MSTR 9.0.1

Confidential, New York, New York

DWH 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,IBM DB2,SAS, SQL *Loader, Oracle 9i, SQL Server 2005, SSIS, Erwin 3.5, Windows 2000, TOAD 7, Microstrategy 9.0.x