SUMMARY:

• I have over 7+ years of solid IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Experience using query tools for Oracle, Teradata, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• ETL and data integration experience in developing ETL mappings and scripts using Informatica Power Center 7.1/6.2/5.1 and Power Mart 6.2/5.1 using Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor
• Extensive testing ETL experience using AbInitio 2.14, Informatica 8.6/8.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• 5+ years of database experience using Oracle 10g/9i/8i, SQL, PL/SQL, SQL*Loader, Stored Procedures, Functions, TOAD, Constraints, Triggers, Indexes - B-tree Index, Bitmap Index, Views,, Inline Views, IBM DB2 UDB 8.0/7.0 & MS Access.
• Extensively worked on Data Extraction, Transformation, and Loading with RDBMS, VSAM Files, Flat files and XML.
• Experience in testing and writing SQL and PL/SQL statements.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos 7.3 Series and Business Objects XI R3
• Solid knowledge and experience in SQL database and writing SQL Queries for backend/database testing.
• Worked onWeb ServicesTesting usingSOAP UI 4.0/3.0, Apache Axis Client 2.x, Eclipse 3.4 and IBM RAD 7.0.
• Experienced in Automation of Testing activity using QTP 10.x/9.2, Selenium IDE 1.3, and Selenium RC Server
• Involved in writing and executing test cases, enhancing test scripts, reporting, finding defects and documentation.
• Having excellent understanding of Functional and non-Functional testing.
• Performed Functional, and Regression testing.
• Experienced in ETL Testing, BI Testing, and Data Quality Issues & Data Reconciliation process.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Experience in all phases of Software Development life cycle.
• Excellent written and verbal communication skills including experience in proposal and presentation creation.

TECHNICAL SKILLS:

ETL Tools: Ab Initio, (GDE 1.15, Co>Op 2.15), EME, Data Profiler, Informatica 8.6.1/8.1/7.1/6.2/5.1, SSIS, Data Stage 7.5

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

Databases: Oracle 10g/9i/8i, MS SQL Server 2008/2005, DB2 8.x, Teradata 12.0, Sybase 12.5, MySQL

BI/OLAP Tools: Cognos 8.0/7.0/6.0, Business Objects XI R3/R2/6.x/5.x

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

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

Operating Systems: Windows 2003/2000/NT, AIX, Sun Solaris, Linux

Testing Tools: QTP, Win Runner, Load Runner, Quality Center 9.2, Test Director, Rational Clear Quest

Version Control: Rational Clear Case, CVS, VSS, PVCS

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Sr.ETL QA Tester

Responsibilities:

• Data quality checking and interacting with the business analysts.
• Good experience in communicating with offshore team
• Communication with the client for weekly status report
• Created test data that includes all scenarios and created several scenarios to test the referential integrity between tables.
• Prepared Test Plan and Testing Strategy for the project.
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Tested different detail, summary reports and on demand reports developed by Report Studio.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL Test loads.
• Written several shell scripts using UNIX Korn shell for file transfers and cleanup process.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
• Executed SQL statements for data validation to check data integrity, error handling, data redundancy, and data consistency.
• Responsible for UI, Functional, Web Services, cross browser, Automation, ETL, Reports Testing of Web, distributed, SOA, Reporting, legacy, J2EE applications
• Used SOAP UI, WebLogic ANT task to test Web Services running on WebLogic Server
• Testing of Web Services using web services client generated using Apache Axis, SOAP UI, TCP Monitor to track request and response SOAP Messages
• Worked in Automation of two modules using QTP. Developed VB Scripts in QTP which was used later to Automate Check and Deposit processing modules
• Conducted review sessions on test case and regression test scripts in quality center.
• Promoted Unix/Data Stage application releases from development to QA and to UAT environments
• Written complex SQL statements for data reconciliation including comparing record counts between source data, data loaded to the warehouse and rejected records.
• Reported bugs and tracked defects using 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.
• Involved in data warehouse testing by checking ETL procedures/graphs.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Tested the messages published by data stage and data loaded into various databases
• Strong ability in developing advanced and complex 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
• Tested several data migration application for security, data protection and data corruption during transfer
• Tested various Mappings using Aggregator, Joiners, Lookups, Filters, Router and Update strategy
• Unit testing performed on Mappings.
• Tested the ETL process for both before data validation and after data validation process.
• Tested with Front-end functionality for the entire application
• Involved in validating both functional and automated business processes using HP Quality center.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance

Environment: Data stage, UNIX, Shell Scripting, Teradata 12.0, T-SQL, Teradata SQL Assistant 12.0, MLOAD, FLOAD, FEXPORT, TPUMP, BTEQ, SAS/Base 9.1, SQL, PL/SQL, Quality Center 10.0, Oracle 10g, Cognos Series 8.0, Report Net, Impromptu, Report Studio, SQL Server 2008, CA Erwin 7.x, UNIX, Windows 2000, TOAD, WinSQL, Ultra Editor, XML Spy 2010, XSD, XML

Confidential, Buffalo, NY

ETL Test Analyst/Business Intelligence

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Developed Test cases, Test plans, and Test procedures using MS Word and MS Excel.
• Extensively used Informatica Workflow monitor to see session log files and monitor performance of the Workflows.
• Writing SQL queries to validate source data versus data in the data warehouse, including identification of duplicate records. verify the ETL process by running the Informatica workflows (both from Informatica Workflow Manager and through UNIX scripting), monitor the status in Informatica Monitor and verify logs
• Developed test cases to accomplish ETL data migration.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes
• Written Test Plan, Test Strategy, Test Script, Test Cases, Reported bugs and tracked defects using HP Quality Center 10
• Identify the primary key (logical / physical ) and put update or insert logic
• Deleting the target data before processing based on logical or physical primary key
• Design and execute the test cases on the application as per company standards
• Performed data analysis and data profiling using SQL on various sources systems including Oracle and Teradata.
• Created Batch processes using Fast Load, BTEQ, Unix Shell and Teradata SQL to transfer, cleanup and summarize data
• Ran UNIX shell scripts to count the records for EDW source to staging tables.
• Ran SQL queries to verify the number of records and validated the referential integrity rules as per the design specifications.
• Ensured data integrity and verified all data modifications and calculations during database Data migration using ETL tools
• Involved in backend testing with SQL, check the data integrity and referential integrity.
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Experience testing data conversions and migrations in cross platform scenarios Informatica power center
• Tested data migration to ensure that integrity of data was not compromised
• Coordinate and helped in testing the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Walked through and certified all unit test case execution and performed code review with all the developers prior to exiting the construction phase.
• Tested Autosys JILS to automate daily and quarterly batch jobs.
• Involved in system Integration testing (SIT), System Verification Testing (SVT) and User Acceptance Testing (UAT).

Environment: Oracle 10g, Informatica 8.1 power center, DB2, SQL, PL/SQL, T-SQL, DB Aritisan, Teradata VeR6, SQL Assistant, MS Access, XML, XSLT, XML Spy, SQL *Loader, Business Objects XIR2, Windows 2000, TOAD, MS Excel, Flat files, Animate, UNIX- Putty, AutoSys, HP Quality Center 8.0

Confidential, New Jersey

ETL Test Engineer

Responsibilities:

• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs
• Worked with Data Completeness, Data Transformation, Data Quality, Integration testing, Performance, Scalability and Regression Testing.
• Documented the validation rules, error handling and test strategy of the mapping.
• Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.
• Lead team of 6 people in Quality Assurance Team.
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Created temporary tables for validations after understanding the transformation logic.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Tested complex mappings using mapplets and reusable transformations.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Verify development of rule-set test scenarios, test cases, expected results and analysis of XML test scripts
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extensively tested several ETL Mappings developed using Informatica.
• Involved in testing data reports. Written several SQL queries for validating the front-end data with backend.
• Conducted back to back meetings with developers and discussed about all open issues.
• Conducted test case reviews to ensure scenarios accurately capture business functionality.
• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.
• Written several SQL statements to confirm successful data transfers between source and target.
• Worked with data profiling, data scrubbing and data cleansing.
• Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports

Environment: Informatica Power Center 6.1, Quality Center, Windows NT, Micro Strategy, Oracle 8i, SQL Server, SQL, PL/SQL, SQL*Plus, Toad, VSAM Files, XML, XSD

Confidential, Manhattan, New York

DWH / ETL Tester

Responsibilities:

• 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.
• Extraction of test data from tables and loading of data into SQL tables.
• Verify the source to target data movement and verify the target data by writing SQL queries
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Tested several stored procedures.
• 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
• 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.
• Involved in testing data mapping and conversion in a server based data warehouse.
• 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: Ascential DataStage 7.5, SQL Server 2005, DTS Packages, Quality Center 9.0, PERL, Cognos Series 8.0, Unix IBM AIX 5.5, T- SQL, XML Files, XSLT, XML Spy 2010, SQL, PL/SQL, Stored Procedures, Shell Scripting, OLAP, IBM DB2, COBOL II, VSAM, JCL, Teradata V2R5