SUMMARY

• 7+ years of IT experience in Design, Analysis, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications. Specialized in Quality Assurance and testing, worked as ETL Tester, BI Tester and QA Analyst.
• Experienced in all phases of Software development life cycle (SDLC).
• Experience in Ab Initio, Informatica based ETL testing for data warehouse and Business Intelligence Solutions.
• Solid experience in RDBMS technologies like Oracle, DB2, MS SQL Server, Excel and MYSQL, TOAD, SQL Plus, Win SQL, Quest Central for DB2.
• Good at working with SQL Assistant in Teradata environment.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture.
• 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.
• Experience in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience in UNIX shell scripting and configuring Korn - jobs for Informatica sessions scheduling.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.
• Extensive knowledge and experience in producing tables, reports, graphs and listings using various SAS procedures and handling large databases to perform complex data manipulations.
• Experience in using Test management tools like Quick Test Professional, Win Runner, Load Runner and HP Quality Center in Client/Server applications.
• 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.
• Experienced in different Databases like Oracle, DB2, Teradata and Sybase.
• Experienced in Black Box, and White Box Testing of Database and Web applications.
• Good expertise in using TOAD, SQL Plus and SQL Advantage.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Designed data models using Erwin Tool.
• Professional Experience in Financial, Banking, HealthCare applications and strong understanding of Mortgage lending applications.
• Ability to handle multiple tasks and work independently and in a team environment.

TECHNICAL SKILLS

ETL Tools: Informatica (Power Mart/Power Center) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect), Data Stage, Ab Initio, SSIS

Data Modeling: Erwin, Star Schema Modelling, Snow Flake Modelling

Databases: Oracle, MS SQL Server, DB2, Teradata, Sybase

OLAP Tools: Cognos, Microstrategy

Languages: SQL, PL/SQL, Unix Shell Script, PERL, Visual Basic, XML

Tools: Toad, SQL* Loader, Teradata SQL Assistant, WinSQL, BI Studio

Operating Systems: Windows, AIX, Sun Solaris, Linux

Testing Tools: QTP 9.0, Quality Center, Test Director, Bugzilla

Rational Tools: RUP, Rational Rose, Rational Clear Case, Clear Quest, Test Manager, Robot, Rational Requisite Pro

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

ETL Tester

Responsibilities:

• Involved in test planning, writing test cases/scripts, test case automation and test execution.
• Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Used HP ALM as the test management tool for the maintenance of the test cases and to track the defects.
• Created test data at design level based on ETL mapping document for both positive and negative scenarios.
• Tested the reports like Drilldown, Drill Up and Pivot reports generated from OBIEE.
• Managed and executed the test process, using Agile Methodology.
• Tracked the user stories, tasks, product backlog and sprint backlog in Jira
• Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata
• Tune SQL queries and database performance for OLTP and DSS applications within the development environment.
• Involved in Rest service testing using soap UI.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Developed and executed formal test plans to ensure the delivery of quality software applications.
• Worked on both standard alone and out of box model for OBIEE Implemented Data/Object level security in OBIEE.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Extensively written test scripts for back-end validations.
• Extraction of test data from tables and loading of data into SQL tables.
• 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.
• Testing of records with logical delete using flags
• Participated in defining and executing test strategies using agile methodology. performed monitoring of the ETL jobs (Extraction, Transformation and Loading) by using Informatica power center worked on burned down chart and burned up chart in Jira
• Tested several stored procedures.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures in OBIEE.
• Prepared daily/weekly bug status reports highlighting bug fix metrics and tracked the progress of test cycles in Jira.
• Involved in Web services testing using SOAPUI Tool. Validated request and response XML. Added assertions to validate the XML in Web services RESTFUL service.
• Writing Sub Queries, Correlated Sub Queries to retrieve data from multiple tables and used indexes efficiently.
• Working with internal customers to identify requirements for ETL processes
• Identify potential problems, omissions and open issues and attend walkthroughs and attend signoff meetings.
• Wrote numerous Pre and Post session SQL and Unix Scripts.

Environment: Oracle, Informatica Power Center, Agile, JIRA, OBIEE, UNIX Shell Scripting, SQL, TOAD, XML Files, Rest, Soap, SQL Server, TOAD, WinSQL, Teradata

Confidential, Indianapolis, IN

ETL Tester

Responsibilities:

• Involved in understanding the ETL mapping document and Source to Target mappings.
• Prepared the test plans and test cases for different functionalities involved in the application.
• Used Quality Centre as the test management tool for the maintenance of the test cases and to track the defects.
• Extracted Data from Oracle and Flat files using Informatica. Worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformations
• Performed the Smoke, Functional testing, Ad Hoc testing and Regression testing of the application.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Using SOAP UI and REST API to automate tests.
• Involved in Testing Cubes for Data warehouse
• Written several UNIX scripts for invoking data reconciliation.
• Execute and analyze complex test cases and compare the results with expected results and product requirements.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc
• Performed Regression Testing of the affected test cases to confirm that the defect has been resolved when defect corrections are delivered in a build.
• Tested different detail, summary reports and on demand reports
• Extensively used Informatica power center for extraction, transformation and loading process.
• Written several PL/SQL stored procedures. Tested the output of Stored Procedures vs. ETL output.
• Involved in backend testing for the front end of the application using SQL Queries in SQL Server data base.
• Defect Reporting, Analyzing, Tracking and Report Generation, using HP Quality Center.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Tested Transformed data from various sources like excel and text files in to reporting database to design most analytical reporting system.
• Tested the universes and reports in Business Objects
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries
• Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica
• 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.
• Tested UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.

Environment: SQL Server, Informatica Power Center, Rest, Soap, Business Objects, HP/ALM Quality Center, SQL, Oracle, TOAD, Shell Scripting, TOAD, WinSQL, SQL Plus, XSD, XML

Confidential, Bloomington, IL

ETL Tester

Responsibilities:

• Reviewing the business requirements for Data Warehouse ETL process and working with business and requirements team for gaps found during the review.
• Developed a detailed Test Plan, Test strategy, Test Data Management Plan, Test Summary Report based on Business requirements specifications.
• Wrote extensive SQL and PL/SQL scripts to test the ETL flow, Data Reconciliation, Initialization, and Change Data Capture, Delta Processing.
• Proficient in Backend testing for testing data integrity, data validation, testing store procedure and SSIS Packages.
• Prepared Execution procedure document format to prepare the Test cases based on mapping document.
• Ran jobs using the Autosys to load the data from Source to Target.
• Categories and creating new data elements.
• Validated the Data in the Warehouse using SQL queries
• Tested SSIS packages for transferring data from corporate and other non SQL server databases to populate.
• Tested the Reports generated by Business Objects and validated the data on the Reports
• Validated test cases for Source to Target mappings (STM).
• Validated data flow from Source through to FACT tables and Dimension tables using complex queries(left outer Joins, sub queries etc)
• Validated data model for landing zone, staging zone and Warehouse tables for column length and data type consistencies
• Tested whether the reports developed in Business Objects are as per company standards.
• Validated FK failures and data integrity checks for all the tables.
• Validated Business codes, Error process and Purge process.
• Extensively used UNIX shell scripts and compared the files in SAS to make sure the extracted data is correct.
• Coordinated with Different project teams to set up common test environment and common Integration for different applications
• Written several test cases for SSIS Packages and for data flow.
• Conducted defect review meetings with the development team members
• Involved in peer review of test cases, Test Pool meetings and Impact analysis
• Involved in testing the applications in Target host in IBM Mainframe environment
• Used QMF for writing and executing DB2 queries in the host

Environment: SSIS, Windows XP, Oracle, Business Objects, HP/ALM Quality Center, TOAD for Oracle, TOAD, Shell Scripting, TOAD, WinSQL, SQL plus, XSD, XML

Confidential

Software Engineer

Responsibilities:

• Monitor the schedule of testing phases for all projects based on project specifications, scope, and coverage.
• Wrote Shell Scripts for UNIX sorts, concatenation of files, file manipulations and job scheduling.
• Handling user defined exceptions.
• Developed PL/SQL scripts for data loading.
• Analysis of Physical Data Model for ETL mapping.
• Identification of various Data Sources and Development Environment.
• Writing Triggers enforcing Integrity constraints, Stored Procedures for Complex mappings, and cursors for data extraction.
• Worked extensively with mappings using expressions, aggregators, filters, lookup and procedures to develop and feed Data Mart.
• Developed ETL mappings, Transformations and Loading using Informatica Power Center
• Extensively used ETL to load data from Flat files, Excel, MS-Access which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 9i.
• Developed and tested all the Informatica mappings, sessions and workflows - involving several Tasks.
• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
• Designed Universe with data modeling techniques via implementing Contexts, aggregate awareness, hierarchies, predefined conditions, linking, Joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects which are grouped into classes.
• Analyzed the session, event and error logs for troubleshooting mappings and sessions.
• Initiate the data modeling sessions, to design and build/append appropriate data mart models to support the reporting needs of applications.

Environment: Informatica, Oracle, Windows XP, Flat files, VSAM Files, XML Files, XSD, IBM AIX 5.1, PERL, Shell Scripting, Autosys