SUMMARY

• 7+ years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/ Server applications
• Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience in UNIX shell scripting and configuring cron - jobs for Informatica sessions scheduling.
• Good working experience on SOAP UI for testing and validating various web services used in the application.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica, SSIS, Data Stage and Ab Initio.
• Expertise in Testing Complex Business rules by creating mapping and various transformations.
• Experience in testing XML files and validating the data loaded to staging tables.
• Experience in testing and writing SQL and PL/SQL statements.
• Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Informatica.
• Experience in Financial, Banking, Brokerage, and Securities industries.
• Extensive testing ETL experience using Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Extensive knowledge and experience in producing tables, reports, graphs and listings using various SAS procedures and handling large databases to perform complex data manipulations.
• Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
• Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Expertise in utilizing Oracle utility tool SQL*Loader and expertise in Toad for developing Oracle applications.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

Sr. ETL Tester

Responsibilities:

• Responsible for Gathering test requirements and scoping out the test plan.
• Written complex SQL queries.
• Designed and tested UNIX shell scripts as part of the ETL testing process to automate the process of loading, pulling the data for testing ETL loads.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Reported bugs and tracked defects using HP/ALM Quality Center
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Tested complex ETL DataStage jobs based on Business requirements and Business rules to load data from source files to target tables.
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• End-to-End maintenance of Netezza Appliance's hardware and software
• Worked with web service testing tools like Soap UI pr -developed and build test cases, execute, and maintain Integration test harnesses, tests scripts as assigned.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Worked with Data Stage jobs and log files to monitor the test runs.
• Created and executed test cases for DataStage jobs to upload master data to repository.
• Used Soap UI for API testing both SOAP and REST protocols in different web services, and wrote Xpath/XQuery language codes to add various assertions for the test.
• Participated in Integration, System, Smoke and User Acceptance Testing and production testing using QTP/UFT.
• Working closely with IBM Netezza support and UNIX team for replacement and for various client related issues.
• Tested ad hoc and canned reports for Business objects.
• Managed and executed the test process, using Agile Methodology.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Worked on the data flow diagrams using VISIO
• Extraction, Transformation and Load (ETL) of data from Legacy systems using DataStage.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning.
• Automated functional, GUI and Regression testing by creating scripts in QTP/UFT.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Tested Business Objects reports and Web Intelligence reports.
• Defined and implemented approaches to load and extract data from database using DataStage.
• Extraction of test data from tables and loading of data into SQL tables.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Worked with Data Conversion projects for testing data quality after migration.
• Experienced using database query tools for Oracle, SQL and UNIX such as TOAD, Teradata SQL Assistant and SQL Plus.
• Validated the reports to make sure all the data is populated as per requirements.
• Responsible for leading and coordinating with offshore team.
• Testing the ETL data movement from Oracle Data mart to Netezza Data mart.

Environment: DataStage, Business objects, SQL, PL/SQL, Agile, Soap UI, Teradata 13, Visio, Teradata SQL Assistant, Netezza, Data stage, ALM/HP Quality Center 11, QTP/UFT, Oracle, UNIX, TOAD, T-SQL, SQL Server, XML Files, XSD, XML Spy, Flat Files

Confidential - Charlotte, NC

ETL QA Tester

Responsibilities:

• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Worked with Data Completeness, Data Transformation, Data Quality, Integration, UAT testing and Regression testing for ETL and BI group
• Write SQL queries to validate that actual test results match with expected results
• Check the naming standards, data integrity and referential integrity.
• Checked the reports for any naming inconsistencies and to improve user readability.
• Compared the actual result with expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Used Business Objects Lifecycle Manager to migrate BI resources from one environment to another.
• Used Clear Quest for defect tracking and reporting, updating the bug status and discussed with developers to resolve the bugs.
• Tested the ETL Data Stage jobs and other ETL Processes
• Written several Netezza SQL scripts to load the data between Netezza tables.
• Worked with Netezza Workbench tool to test and debug SQL query.
• Created data-driven automation scripts for testing API Web Services using SOAP UI.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Preparing Defect Reports and Test Summary Report documents.
• Used DataStage director for running the DataStage jobs and validated them.
• Checking the status of ETL jobs in UNIX and tailing the log files while the loading is under processing.
• Tested Netezza database for Data Validation, Data Verification using NZ SQL.
• Used Business Objects Lifecycle Manager to migrate BI resources from one environment to another.
• Developed the Test Plan and Testing Strategy for Data Warehousing projects.
• Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
• Participated in defining and executing test strategies using agile methodology.
• Prepared documentation for all the testing methodologies used to validate the Data Warehouse.
• Create and executed data driven test scripts in QTP.
• Involved in unit, performance and integration testing of Data Stage jobs.
• Loading Flat file Data into Teradata tables using Unix Shell scripts.
• Conducted test case review and revision of surrogate key generation in DataStage to uniquely identify master data elements for newly inserted data
• Conduct Functionality testing during various phases of the application using QTP.
• Created the Microsoft Visio diagram which represents the workflow and execution process of all the process
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing for different data loading jobs
• Extracted certain column of data from a number to files using PERL.
• Validated cube and query data from the reporting system back to the source system.
• Used Rational Clear Case for version controlling
• Extensively involved with backend testing by writing complex SQL queries.
• Worked closely with the development teams to replicate end user issues.

Environment: Oracle, SQL, PL/SQL, DataStage, Quick Test Pro (QTP), Agile, Soap UI, Teradata, ALM/HP Quality Center, Visio, Business objects, Data Stage, TOAD, Rational Clear Quest, Rational Clear Case, Netezza, XML Files, XSD, XML Spy

Confidential - Charlotte, NC

ETL Tester

Responsibilities:

• Analyzed the Functional requirements using Scenarios & DDD (Detailed Design Document)
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
• Generated the detailed reports of the Bugs, go no go reports and comparison charts.
• Involved in Manual and Automated testing using QTP and Quality Center.
• Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios)
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Used Data Stage Director to run and monitor the jobs for performance statistics.
• Worked on ETL Data Warehousing, database testing using Informatica for Workflow process.
• Defects tracking, review, analyze and compare results using Quality Center.
• Defined the Scope for System and Integration Testing
• Executed Complex SQL queries within UNIX shell scripts in the UNIX environment.
• Involved in Test Scheduling and milestones with the dependencies
• Identify, assess and intimate potential risks associated to testing scope, quality of the product and schedule
• Tested the reports developed in Cognos against the database
• Identified & presented effort estimations related to testing efforts to Project Management Team
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Tested slides for data flow and process flows using PowerPoint and Microsoft Visio
• Used all Teradata utilities including Fast Load, Multi Load, Fast Export, SQL Assistant, BTEQ & TPUMP
• Using Import Wizard deploying the reports from Dev system to QA box.
• Used Sets, Metrics, Productive Analysis and Enterprise Performance Management (Scorecard and Dashboard)
• Written SQL scripts to test the mappings and extensively used Cognos for report generation
• Used T-SQL for Querying the SQL Server2008 database for data validation and data conditioning.
• Tested graphical representation of reports such as Bar charts, Pie charts as per End user requirements.
• Tested Desktop Intelligence and Web Intelligence reports.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.

Environment: Informatica, QTP, SQL Server, Quality Center, Agile, PERL, Oracle, Java, Cognos, T-SQL, SAS, XML, XSLT, XML Spy, SQL, PL/SQL, Teradata

Confidential - New York

ETL Tester

Responsibilities:

• Prepared and Scheduled for Backup and Recovery. Maintenance of backup and recovery plans for system and user databases
• Created roles, and set permissions to ensure that company's security policies are enforced and in effect.
• Created test case scenarios, executed test cases and maintained defects in Remedy
• Tested reports and ETL mappings from Source to Target
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Tested Informatica mappings. Performed data validations against Data Warehouse
• Involved in job scheduling using MS SQL server Agent.
• Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Responsible for extensive data validations on Data warehouse and reports.
• As an ETL/BI Tester responsible for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project.
• Responsible for leading team and co-coordinating with offshore team
• Prepare and set up environment for Disaster recovery.
• Transformation of data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS)
• Optimized, partitioned cubes to speed up report latency and performance optimizations.
• Assisted in Troubleshooting of Report deployment on multiple servers.

Environment: Informatica, Microsoft SQL Server 2008, Enterprise Manager, Database Transformation Services (DTS), VB Script, T-SQL, SQL Profiler, MS Access, XML, XSLT, XSD