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.
• 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, BUFFALO, NY

Sr.ETL/ DWH Developer

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.
• 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, Florida

Sr. ETL Test Analyst

Responsibilities:

• Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Used HP Quality Center 9.0 for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result.
• Co-ordinate testing efforts between onsite and offshore teams.
• Performed SQL validation to verify the data extracts and record counts in the database tables by Writing complex SQL minus queries.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Experience in ETL Data Warehousing, database testing using DataStage for Workflow process.
• Designed policies, standards and procedures for testing life cycle for the data warehouse and Datamarts.
• Prepared test cases by understanding the business requirements Data Mapping documents and Technical specifications.
• Tested the ETL Data Stage jobs and other ETL Processes (Data Warehouse Testing)
• Tested the ETL process for both before data validation and after data validation process. Tested.
• Responsible for different Data mapping activities from Source systems to Teradata
• Extensively used Informatica power center for extraction, transformation and loading process.
• Wrote and implemented manual automated test scripts for Risk Warehouse decision support System using HP Quality Center.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the Target
• Coordinated with development team in system integration test and services level unit testing.
• Responsible for identifying and defining the Key Performance Indicators in SSAS 2008.
• Exported Manual Test Cases from MS Excel template directly to HP Quality Center and executed all the Test Cases in Quality Center with Pass/Fail/Blocked status.
• Extensively worked with backend activities for testing several reports developed by BI tools. Written several complex SQL queries.

Environment: IBM Web sphere Data Stage 8.5/ 8.0.1/8.0/7.5/7.1, HP Quality center 10.0, QTP 10.0, OBIEE10.1.3, Oracle 10g, Teradata V2R6, SQL server SSIS (2008), SQL server SSRS (2008), SSAS, PL/SQL, Toad, XML, XSD, PERL 5.12.1, XML Spy, Flat Files, Excel, Ms PowerPoint, Autosys, UNIX, IBM AIX 6.1, Shell Scripting, Windows server, SQL Server 2008 Management Studio.

Confidential, MA

ETL Test Engineer

Responsibilities:

• Involved to create Business Risk Levels to determine Test Priorities.
• Analyzed Test Plans and Test Cases based on Requirements and General Design Documents, Involved in both Manual and Automation Testing.
• Performed Regression testing using Test Director.
• Extensively used SQL Queries to verify and validate the Database Updates.
• Used Test Director a workflow automation tool for defect tracking and product automation.
• Created User Defined Functions and procedures in Test Director Library to re-use them in Different tests.
• Performed data analysis and data profiling using SQL and Informatica on various sources systems Including Oracle and Teradata.
• Responsible for full testing life cycle, system testing and validating the Informatica mappings against the pre-defined ETL design standards.
• Designed and supported SQL 2000 Reporting services, Integration services and Analysis services
• Created variety of reports from SSAS cubes
• Defining and performing the Test strategies and associated scripts for the verification and Validation of the application and ensuring that it meets all defined business requirements and Associated functionality.
• Designed the Load Runner scenarios with various user-mix incrementing in constant ratios, till the peak load is achieved.
• Tested SSRS reports based on SSAS Cubes and OLTP with drill through and drill down.
• Tested OLAP cubes and SSRS reports for various business needs.
• Worked with SSIS system variable, passing variables between packages.
• Tested the created SSIS packages to transfer data from various sources like Oracle, Excel,
• Created high level test cases and test procedures for Unit Testing on reinsurance and documented them.
• Created VUser scripts using Load Runner by recording, incorporating Transactions, and think time.
• Used Test Director to create test plans, gathering requirements, analyzing the results and reporting.
• Responsible for Reviews and documentation for reporting the status to the project manager.
• Played a significant role of QA testing at various stages of the project including Data Quality Testing, Data load Testing, Data Integrity testing, Business Objects Reports Testing etc.
• Tested Complex metrics, Nested Filters, Nested Prompts, Custom Drill Maps, Templates for Graphs and Templates for Drilled reports.

Environment: Informatica 8.1, Test Director 8.0, Win Runner 5.0, Load Runner, Business Objects 6.x, Rational Clear quest, SQL Server 2000,2005, SSIS, SSAS, SSRS, Teradata V5R12, UNIX and XML, Quality Center 9.0, QTP 9.0

Confidential, Somerset, NJ

DWH / ETL Tester

Responsibilities:

• Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Used HP Quality Center 9.0 for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result.
• Co-ordinate testing efforts between onsite and offshore teams.
• Performed SQL validation to verify the data extracts and record counts in the database tables by writing complex SQL minus queries.
• Experience in manual testing which involves web-based application testing for provider and claims system.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• 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.
• Experience in ETL Data Warehousing, database testing using DataStage for Workflow process.
• Create various test Batch jobs to run and monitor group of jobs with DataStage Director.
• Written test cases for checking the populated data correctly into fact and dimension tables.
• Created Test Case documents in MS Excel template from the Test Plan and the Business Requirements documents.
• Designed policies, standards and procedures for testing life cycle for the data warehouse and datamarts.
• Used Control-M scheduler to schedule the ETL processes
• Prepared test cases by understanding the business requirements Data Mapping documents and technical specifications.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata.
• Tested the ETL Data Stage jobs and other ETL Processes (Data Warehouse Testing)
• Tested the ETL process for both before data validation and after data validation process. Tested.
• Tested reports using SSRS functionality like Queries, Slice and Dice, Drill down, @Functions, Formulae etc.
• Responsible for different Data mapping activities from Source systems to Teradata
• Extensively used Informatica power center for extraction, transformation and loading process.
• Wrote and implemented manual automated test scripts for Risk Warehouse decision support system using HP Quality Center.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target
• Coordinated with development team in system integration test and services level unit testing.
• Responsible for identifying and defining the Key Performance Indicators in SSAS 2008.
• Exported Manual Test Cases from MS Excel template directly to HP Quality Center/ALM and executed all the Test Cases in Quality Center with Pass/Fail/Blocked status.
• Extensively worked with backend activities for testing several reports developed by BI tools. Written several complex SQL queries.
• Tested SSRS reports based on SSAS Cubes and OLTP with drill through and drill down capability to confirm with production reports run in Business objects/Crystal reports for cross verification
• Experience in testing SOA and Web services using tool tools like SOAP UI/XML Spy
• Published and Tested SSAS Cubes to Upfront by using Power play Enterprise Server
• Extensively used SQL Queries to verify and validate the Database Updates.
• Actively participated in creating requirements Traceability matrices and Test plans
• Prepared test requirements, test plan approach document and test cases.
• Performed Unit and functional testing for all the Mappings and Sessions.
• Tested Complex Reports in OBIEE functionalities like Slice and Dice Drill down Functions Cross Tabs Master/Detail and Formulae.

Environment: IBM Web sphere Data Stage 8.5/ 8.0.1/8.0/7.5/7.1, HP Quality center 10.0, QTP 10.0, OBIEE10.1.3, Oracle 10g, Teradata V2R6, SQL server SSIS (2008), SQL server SSRS (2008), SSAS, PL/SQL, Toad, XML, XSD, PERL 5.12.1,SOAP-UI, XML Spy, Flat Files, Excel, Ms PowerPoint, Autosys, UNIX, IBM AIX 6.1, Shell Scripting, Windows server