SUMMARY

• Over 7+ years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms. Data Warehouse applications testing using Informatica Power Center and Data stage on multiple platforms. * Expertise in Automated Software Quality Testing & Manual Testing of Web based and Client - Server applications.
• Well versed with various types Software Development methodologies- Waterfall, Agile, RUP, Iterative and Extreme Programming.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experienced in DW projects ETL testing against DW testing with Informatica and data stage tools.
• Extensive experience with Reporting Tools like OBIEE, Cognos, Business Objects
• Experience with Agile Methodology.
• Highly experienced in various features of Micro Strategy like managing multiple projects, project migration and defining standards, procedures for development, production environment
• Experience in Testing BI applications using BO, OBIEE, SSRS.
• Good Knowledge on Business intelligence, OLAP, Dimensional modeling, Star and Snowflake schema, extraction, transformation and loading (ETL) process
• Strong technical Knowledge of UNIX Utilities, Shell Script to automate process.
• Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.
• Experience in data retrieval methods using Universes, Personal Data files, Stored Procedures, and free hand SQL. Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Report Test Plan helps benchmark and compare data and format of OBIEE analysis. It integrates with OBIEE to provide a user friendly mechanism for adding analysis including dashboard prompt values.
• Proficient in SQL, PERL, Shell Scripting and PL/SQL coding and experience in Performance Tuning of SQL and Stored Procedures.
• Experienced with ETL tools like Informatica, SSIS and Data stage.
• Experience in testing Business Report developed in Micro strategy and Cognos
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Well versed in GUI application testing, Database testing and Front-end testing.

TECHNICAL SKILLS

Data Warehousing: Informatica 8.6.1/8.1/7.1/6/5.1.1/1.75 , Data Stage 8.x

Reporting Tools: Business Objects 6.5/XIR3, Cognos 8.0 Suite, Crystal Reports, SSAS, SSRS, Micro Strategy 8.x,OBIEE 10.0.3

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

Testing Tools: Win Runner, Load Runner, Test Director, HP Quality Center, Rational Tools

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

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

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

Environment: UNIX, MVS, HP-UX, IBM AIX 4.2/4.3, Hyperion, Novell NetWare, Win 3.x/95/98, NT 4.0, Sun-Ultra, Sun-Spark, Sun Classic, and SCO

MPP Databases: Netezza NPS 8050

PROFESSIONAL EXPERIENCE

Confidential, Richmond VA

ETL QA Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.2
• Tested ETL jobs as per business rules using ETL design document
• Promoted Unix/Data Stage application releases from development to QA and to UAT environments
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Expert in writing Complex SQL/PLSQL Scripts in querying Teradata and Oracle.
• Defined data requirements and elements used in XML transactions.
• Tested the database schema with help of data architects using ERWIN.
• Involved in the testing of Data Mart using Power Center.
• Identified and Documented additional data cleansing needs and consistent error patterns that could diverted by modifying ETL code.
• Extensively used Teradata load utilities Fast load, Multiload and FastExport to extract, transform and load the Teradata data warehouse
• Worked in an Agile technology with Scrum.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Queried Teradata Database and validated the data using SQL Assistant.
• Tested the messages published by data stage and data loaded into various databases and for extraction, transformation and loading process
• Effectively distributed responsibilities, arranged meetings and communicated with team members in all phases of the project.
• Used import and export facilities of the application to download/upload XMLs of failed test cases so as to re-verify.
• Scheduled the jobs using Auto sys and automated the jobs to be ran at specific time and automated the reports.
• Writing UNIX scripts to perform certain tasks and assisting developers with problems and SQL optimization.
• Tested Complex Reports in OBIEE functionalities like Slice and Dice Drill down Functions Cross Tabs Master/Detail and Formulae.
• Configured Quick Test Pro with Quality Centre and Maintained the project information in Quality Centre.
• Extensively used Autosys for automation of scheduling jobs on daily, bi-weekly, weekly monthly basis with proper dependencies.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries
• Performed Unit testing and System Integration testing by developing and documenting test cases in Quality Center.
• Tested customized and OBIEE reports with Metrics and Filters for Business analysis using Desktop intelligence with features of Drilling options drill up, drill down and drill anywhere .
• Did Unit testing for all reports and packages.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Tested several complex reports generated by Micro Strategy including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Extensively tested several Micro Strategy reports for data quality, fonts, headers & cosmetic
• Involved in testing the Micro Strategy reports by writing complex SQL queries
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Tested complex objects to the universe to enhance the report functionality.
• Responsible for migrating the code changes from development environment to SIT, UAT and Production environments.
• Validated cube and query data from the reporting system back to the source system.

Environment: Data stage, Flat files, Perl, Erwin 4.0, DTS, MS SQL Server 2008, Oracle 10g, SQL, PL/SQL, IBM DB2 8.0, OBIEE,AGILE, Teradata V2R6, Teradata SQL Assistant, Micro strategy, COBOL, HP QTP 9.0, HP Quality Center 10, Autosys, Toad, Unix Shell Scripting, Windows XP/2000

Confidential, San Francisco, CA

ETL QA Tester

Responsibilities:

• Executed the Test cases for Micro Strategy
• Understanding Source Systems used by Confidential Insurance to populate Data Mart.
• Working on defining mapping requirements sources systems used by Confidential Insurance to populate data mart.
• Extracted certain column of data from a number to files using PERL.
• Used PERL for automating all the types of modules at a time.
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with data validation, constraints, source to target row counts.
• Developed automated Test Scripts using QTP.
• Tested several Data stage ETL jobs and ran on UNIX for loading purpose and checking the log files
• Used data conversion to protect the data and prevent data loss.
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Experienced in working with DB2, Terada.
• Tested Canned/Ad-hoc reports using Micro strategy Reporter functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, @Functions, Alerts, Cascading Prompts and User Defined Objects
• Used Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Strong in writing SQL queries and makes table queries to profile and analyze the data in MS Access.
• Formulate methods to perform Positive and Negative testing against requirements.
• Performed Manual Testing of the application Front-End and Functionality. Identified the critical test scripts to be automated.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Perform Functional, Data Validation, Integration, regression and User Acceptance testing.
• Used TOAD, DB Artisan tools to connect to Oracle Database to validate data that was populated by ETL applications
• Involved in testing Unix Korn Shell wrappers to run various ETL Scripts to load the data into Target Database (Oracle).
• Worked on Clear Quest to log defects and track resolution till the closing of defect after retesting.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0.
• Created test cases and executed test scripts using Quality Center and Used to track and report system defects..
• Involved in unit, performance and integration testing of Data Stage jobs.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables

Environment: Data Stage, DB2, Micro strategy, Java, SQL, SQL Server 2000/2005, PERL, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, BTEQ), Win Runner, Load Runner Teradata SQL Assistant 7.0, XML, XSLT, XML Spy 2008, IBM AIX 5.3, UNIX, Shell Scripting, HP QTP v5.5/6.5,WinSQL, Ultra editor, Rumba UNIX Display, HP Quality Center 8.2

Confidential, Boston, MA

ETL /QA 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.
• Wrote complex SQL queries for querying data against different data bases for data verification process.
• Designed the data flow diagrams using MS VISIO.
• 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
• Helped the Testing team by writing SQL statements to validate the reports
• Used multiple data providers, Master/Detail, cross tab, Charts.
• Created several Ad-hoc reports in Business Objects XI R2 to validate the data.
• Written test cases to test the application manually in Quality Center and automated using Quick Test Pro.
• 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 automated test scripts from manual test cases for Regression testing based on the requirement documents using Quick Test Professional.
• Written Test Plans and Test Cases on Mercury’s Test Director Tool.
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director.
• Responsible for different Data mapping activities from Source systems to Teradata
• 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.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
• Scheduling and automating jobs to be run in a batch process.
• Effectively communicate testing activities and findings in oral and written formats.
• Reported bugs and tracked defects using Test Director 6.5
• Extensively used Informatica power center for Extraction, Transformation and Loading process (ETL).
• 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.
• Compared the actual result with expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.

Environment: SAS/Base 8.1, SAS/Macros, SAS/ETL, PERL, UNIX Shell Scripting, Informatica Power Center 7.1 (Power Center Designer, workflow manager, workflow monitor), Business Objects XIR2, Mercury Test Director 6.5, QTP 7.2, SQL *Loader, Oracle8i, SQL Server 2000, Erwin 3.5, Windows 2000, TOAD 7, Teradata V2R4

Confidential, St, Louis, MO

ETL/BI Test Analyst

Responsibilities:

• Wrote SQL Statements to extract Data from Tables and to verify the output Data of the reports
• Performed back-end testing on the Oracle database by writing SQL queries.
• Collected, analyzed and reported testing metrics, executed SQL queries
• Built and maintained effective QA test lab environments
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
• Used Query Studio to test ad hoc reports
• Developed SQL queries in Toad and DB Artisan to achieve the data transformations
• Participated in various meetings and discussed Enhancement Request issues
• Conducted Regression testing after the bugs have been fixed by the development team
• Generated reports from Test Director.
• Responsible for source control, versioning, and configuration management of test scripts, test results, defects
• Developed Test Strategy, Test plan, Test cases, and Test scripts
• Created test plan and executed test cases using Rational Test Manger
• Conducted Functionality, Security, and End to End testing
• Reported bugs using Test Director and generated the defect reports for review
• Defect reporting and tracking was also done using Test Director.
• Maintained the test traceability matrix
• Performed Regression Testing on weekly builds.
• Monitored the workflow transformations in Informatica work flow monitor

Environment: Windows 2000 Server, SQL Server, Oracle 9i, Documentum 5i, Rational Test Manager, Rational Requisite Pro, Rational Clear Case, Rational Robot, ETL Informatica 7.1, Cognos 7.3 Series, Test Director, Toad, Java, J2EE, JSP

Confidential, Bloomington, IL

BI / ETL Test Analyst/Engineer

Responsibilities:

• Tested all the DataStage jobs and ETL flow for data validation.
• Did data reconciliation for all the DataStage jobs for testing needs.
• Wrote test cases based on ETL mapping document for testing the entire ETL wokflow.
• Involved in understanding of business processes to learn business requirements.
• Extracted data from different systems into Source. Mainly involved in ETL developing.
• Defined and implemented approaches to load and extract data from database using Data Stage.
• Worked closely with data warehouse architect and business intelligence analyst in developing solutions.
• Used Erwin for data modeling (i.e. modifying the staging and SQL scripts on Oracle and MS Access Environments).
• Conducted System testing for each phase of the application.
• Involved in preparing Test Scripts and Test cases based on the functional specifications.
• Executed backend testing of the application by writing SQL queries.
• Used Defect Tracking System Test Director to report bugs found in different testing stages.
• Executed Test Procedures and documented Test Results
• Involved in design, source to target mappings between sources to operational staging targets, using DataStage Designer.
• Performed ETL coding using Hash file, Sequential file, Transformer, Sort, Merge, Aggregator stages compiled, debugged and tested. Extensively used stages available to redesign Data Stage jobs for performing the required integration.
• Executed jobs through sequencer for better performance and easy maintenance.
• Used Data Stage Director to run and monitor the jobs for performance statistics.
• Involved in performance tuning of the jobs.
• Used T-SQL for validating the data generated at OLAP server.

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