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 teh 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,

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 teh test management tool for teh maintenance of teh test cases and to track teh defects.
• Created test data at design level based on ETL mapping document for both positive and negative scenarios.
• Tested teh reports like Drilldown, Drill Up and Pivot reports generated from OBIEE.
• Managed and executed teh test process, using Agile Methodology.
• Tracked teh 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 teh development environment.
• Involved in Rest service testing usingsoapUI.
• Tested teh ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Developed and executed formal test plans to ensure teh delivery of quality software applications.
• Worked on both standard alone and out of box model for OBIEEImplemented Data/Object level security in OBIEE.
• Debugging teh 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 teh ETL process for both before data validation and after data validation process.
• Tested teh 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 teh 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 teh repository building and modification procedures inOBIEE.
• Prepared daily/weekly bug status reports highlighting bug fix metrics and tracked teh progress of test cycles in Jira.
• Involved in Web services testing using SOAPUI Tool. Validated request and response XML. Added assertions to validate teh 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, Bloomington, IL

ETL Tester

Responsibilities:

• Involved in understanding teh ETL mapping document and Source to Target mappings.
• Prepared teh test plans and test cases for different functionalities involved in teh application.
• Used Quality Centre as teh test management tool for teh maintenance of teh test cases and to track teh 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 teh Smoke, Functional testing, Ad Hoc testing and Regression testing of teh 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 teh results with expected results and product requirements.
• Tested teh reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc
• Performed Regression Testing of teh affected test cases to confirm dat teh defect TEMPhas 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 teh output of Stored Procedures vs. ETL output.
• Involved in backend testing for teh front end of teh 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 teh front end of teh 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 teh 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 teh 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 teh ETL process, automate teh process of loading, pulling teh 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, Charlotte, NC

ETL Tester

Responsibilities:

• Reviewing teh business requirements for Data Warehouse ETL process and working with business and requirements team for gaps found during teh 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 teh 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 teh Test cases based on mapping document.
• Ran jobs using teh Autosys to load teh data from Source to Target.
• Categories and creating new data elements.
• Validated teh Data in teh Warehouse using SQL queries
• Tested SSIS packages for transferring data from corporate and other non SQL server databases to populate.
• Tested teh Reports generated by Business Objects and validated teh data on teh 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 teh reports developed in Business Objects are as per company standards.
• Validated FK failures and data integrity checks for all teh tables.
• Validated Business codes, Error process and Purge process.
• Extensively used UNIX shell scripts and compared teh files in SAS to make sure teh 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 teh development team members
• Involved in peer review of test cases, Test Pool meetings and Impact analysis
• Involved in testing teh applications in Target host in IBM Mainframe environment
• Used QMF for writing and executing DB2 queries in teh 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 teh 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 teh relational database, which was Oracle 9i.
• Developed and tested all teh Informatica mappings, sessions and workflows - involving several Tasks.
• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to teh 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 teh loops, subdividing into contexts and creating teh objects which are grouped into classes.
• Analyzed teh session, event and error logs for troubleshooting mappings and sessions.
• Initiate teh data modeling sessions, to design and build/append appropriate data mart models to support teh reporting needs of applications.

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