PROFESSIONAL SUMMARY:

• Over 7+ years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Extensively worked on databases including Oracle, Teradata, SQL Server, Sybase and DB2.
• Tested the ETL flow and other ETL Processes (Data Warehouse Testing)
• Expert in writing SQL queries and has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience in UNIX shell scripting and configuring corn - jobs for ETL Loads
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Data Stage
• 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.
• Hands on experience in writing test scripts, preparing test data, testing Informatica Mappings and creating SQL scripts using stored procedures, functions, PL/SQL
• Expert in Equity Sales System, Home Mortgage, Security Lending, Compliance and Middle Office Reconciliation
• Solid Back End Testing experience by writing and executing SQL Queries.
• Experience in Data Analysis, Data Validation, Data Verification, Data Cleansing, Data Verification and identifying data mismatch.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Developed Informatica, SSIS, and Data Stage and Ab Initio test environment for UAT testing and used all ETL components/transformations while testing the ETL flow and ran the jobs on back ground.
• Strong Experience on Automation tools like WinRunner,QTP, Quality Center
• Created ETL test data for all ETL mapping rules to test the functionality of the ETL process based on mapping document.
• 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 Data Stage, SSIS, Ab Initio & Informatica

TECHNICAL SKILLS:

Data Warehousing: Informatica, Ab Initio, Data Stage

Reporting Tools: Business Objects, Cognos, Crystal Reports, SSRS, MicroStrategy

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, MS SQL Server, UDB DB2, Sybase, Teradata, MS Access

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

Web Technologies: JavaScript, HTML, 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, Sappington, MO

ETL SQL/ BI Tester

Responsibilities:

• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Analyzed data using set statement merge statement using SAS/Stat
• Tested and validated the Report Net reports by running similar SQL queries against the source system(s).
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS Packages.
• Tested and validated the cube data, ensuring that the data is correct by comparing the data results to comparable source system reports or by querying individual transactions and forms.
• Tested several Informatica Mappings to validate the business conditions.
• Worked with systems engineering team to deploy and test new Hadoop environments and expand existing Hadoop clusters
• Used SAS Proc SQL to extract data from different relational database management (Teradata) systems, used SQL Assistant to analyze and query from the Teradata database
• Testing the source and target databases for conformance to specifications
• Worked with SQL, PL/SQL and functions to test the database integrity (Oracle).
• Design and execute the test cases on the application as per company standards and tracked the defects using ALM/HP Quality Center 11
• Created SAS datasets in local SAS directory.
• Designed and prepared scripts to monitor uptime/downtime of different system components
• Preventing occurrences of multiple runs by flagging processed dates
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records with logical delete using flags
• Interacting with senior peers or subject matter experts to learn more about the data
• Identifying duplicate records in the staging area before data gets processed
• Extensively written test scripts for back-end validations
• Performed ETL Informatica testing and extensively used SQL functionalities. Used TOAD to connect to Hadoop Database
• Created tabular reports using Base & SAS/ SAS Reports procedures.
• Tested Netezza database for Data Validation, Data Verification using NZ SQL.
• Managed multiple OLAP and ETL projects for various testing needs.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Performed extensive Data Validation, Data Verification against Data Warehouse
• Loading Flat File Data into Teradata tables using Unix Shell scripts.
• Tested several Cognos Reports for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI’s and Web Reports.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Involved in testing of Universes from different data sources like Oracle

Environment: Informatica Power Center, SQL Server, QTP, SAS, Quality Center 11/ALM, Hadoop, T-SQL, SQL, Teradata, TOAD, Teradata SQL Assistant, Oracle, PL/SQL, MVS, Cognos

Confidential, Londonderry, NH

ETL Tester

Responsibilities:

• Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios).
• Used SQL and PL/SQL scripts to perform backend database testing.
• Defects tracking, review, analyze and compare results using Quality Center.
• Defined the Scope for System and Integration Testing
• Prepares and submit the summarized audit reports and taking corrective actions
• Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.
• Created reports using SAS/ODS.
• Performed integration testing of Hadoop into traditional ETL, extraction, transformation, and loading of massive structured and unstructured data
• Analyzed the Functional requirements using Scenarios & DDD (Detailed Design Document)
• Create and ran the Informatica workflows to load the data into QA environment.
• Accessed to Informatica session log files to find the root causes for logical bugs
• Extensively worked on Backend using SQL Queries to validate the data in the database
• Involved in Test Scheduling and milestones with the dependencies
• Used SAS Proc SQL to extract data from different relational database management (Teradata) systems, used SQL Assistant to analyze and query from the Teradata database.
• Tested Analytical Data Mart (ADM) of Oracle system and Stored Procedures
• 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.
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
• 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.
• Tested slides for data flow and process flows using PowerPoint and Microsoft Visio
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application Hadoop and Oracle databases.
• Used AL 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 TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Tested ad hoc and canned reports for Business objects.
• Tested reports for various portfolios using universe as the main data provider.
• Tested reports using Business Objects functionality like Queries, Slice and Dice, Drill down, @Functions, Formulae etc.
• 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.
• Worked with SSIS system variable, passing variables between packages.
• Tested Desktop Intelligence and Web Intelligence reports.
• 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, QTP, SQL Server, Quality Center, SAS, Business Objects, Hadoop, Oracle, XML, XSLT, XML Spy, SQL, PL/SQL, Stored Procedures, Shell Scripting, XPath, OLAP, MVS, Teradata

Confidential, PHONEIX, AZ

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.
• 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
• 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 Quality Center
• Defects identified in testing environment where communicated to the developers using defect tracking tool Quality Center
• 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 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 Quality Center
• Extensively used Informatica power center for extraction, transformation and loading process.
• 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.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.
• Compared the actual result with expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.

Environment: ETL, Quality Center, UNIX Shell Scripting, Informatica Power, Cognos, Oracle, SQL Server, Teradata

Confidential

QA ETL Tester

Responsibilities:

• Built the Forms for application using various form modules and windows.
• Participated in gathering Business Requirements and designed the project according to the Business requirement specifications.
• Run batch jobs for loading database tables from flat files using SQL*Loader
• Developed UNIX Shell scripts to automate repetitive database processes
• Work with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Used Clear Quest for defect tracking and reporting, updating the bug status and discussed with developers to resolve the bugs.
• Conducted Bug Review meetings for update on defects from development team and retesting of bug fix. Worked with developers to fix faults found in the structure and functionality of the application.
• Prepared daily/weekly bug status reports highlighting bug fix metrics and tracked the progress of test cycles in Quality Center
• Conducted Training & Knowledge Transfer Sessions on new applications to QA Analysts
• Designed the screens and layout using Visual Basic.
• Used SQL*Plus for updating the database and for data retrieval.
• Design and develop a custom database (Tables, Views, Functions, Procedures, Packages)

Environment: Oracle, SQL*Plus, SQL, Rational Clear Quest, Clear Case, SQL Server, PL/SQL, Windows 95, XML, XSLT