SUMMARY: Sr. certified professional SAP Business Objects Data Integrator ETL Developer/Architect. And data modeler with extensive experience in ETL development, design , data architecture, data quality, database development ,administration and data modeling. Extensive experience on SQL Server, Oracle and DB2 databases. Possesses excellent communication skills.

TECHNCIAL SKILL SUMMARY

Operating Systems: Windows NT, 2000, 2003,Unix (Ultrix, Linux). 
Programming Languages: VB.NET, C, C++, Java, Java Script, HTML, PHP 4, ASP, SQL, VB Script. 
RDBMS: SQL Server 2005/2000/7.0, DB2 (V7.1, V8.0), Oracle 9i/10g, 
ETL : Business Object Data Integrator 11.5/11.7/Data Services , MS SQL Server SSIS/DTS, Informatica POWER CENTER 7.1 
REPORTING: Business Object 6.5/XI, MS SQL SSRS
ERP: Oracle PeopleSoft 8/9, Oracle DEMANTRA.Tools: TOAD 9 , Erwin 3.x/7.xMDM tools Orchestra, SAP NetWeaver 5.5

EXPERIENCE:

Confidential Charlotte NC 12/2009- Now 
Senior Business Objects Data Services Architect/Developer

Responsibility:

• Transforming all PL/SQL scripts to Business Objects Data Services.
• Developing a Change Data Capture strategy using Business Objects Data Services.
• Developing ETL jobs for financial services using Business Objects Data Services.
• Confidential San Leandro Ca 08/2009 – 12/2009

Responsibility:

• Reverse engineering data models
• Validating ETL design and development.
• Responsible for data dictionary and meta-data.

Confidential San Francisco Ca 04/2007 – 04/2009

Responsibility :

• Responsible for all aspects of using Business Objects Data Integrator XI (11.7) on SQL Server 2005 platform.
• Designing and developing a financial Data mart using for PeopleSoft returns.
• Leading the Data modeling (conceptual, Logical and Physical) effort.
• Designing and developing a data mart for Oracle Demantra Forecasting using Business Objects Data Integrator, source system PeopleSoft.
• Leading the DWH ETL Architecture.
• Leading the ETL offshore group.
• Defining the DWH standards and naming conventions.
• Supporting and improving the architecture of the existing DWH.
• Leading a migration analysis project: analyzing the impact to the DWH of the migration source system from PeopleSoft 8.0 to PeopleSoft 9.0.
• Leading a data migration project from MS SQL 2000 to MS SQL 2005.
• Leading a pilot real time ETL project.
• Participating in the enterprise MDM project.
• Re-architecting the Order Management data mart.
• Leading the data quality effort for the company.
• Model the PeopleSoft source tables for: OM, AR, AP, INVENTORY, BILLING, PO and EPRO.
• Developing the source to target mapping.
• Establishing methods and procedures for tracking data quality, completeness, redundancy, and improvement.
• Managing the metadata.

Environment: MSSQL SERVER 2000/2005, SSIS, BUSINESS OBJECTS DATA INTEGRATOR 11.7, BUSINESS OBJECTS REPORTING 6.5/XI , WINDOWS,ERWIN , SSIS, ORACLE 10g, DEMANTRA, PEOPLESOFT 8/9,TOAD 9, SAP NetWeaver, Orchestra

Confidential NY, New York, 04/2006 – 02/2007

Senior Business Objects XI ETL Designer/Developer and Data Warehousing Modeler

Project Description:

• Designing and developing Financial Data Marts for source Media a media company.
• Developing financial conceptual, logical and physical data mart models. Extensively utilized Business Objects Data Integrator 11.5
• Designing and developing data marts using SSIS and BO data Integrator. The backend database was SQL Server 2005
• Reviewing the ETL design for junior colleagues.
• Defining the data naming conventions.
• Testing and deploying the solutions.
• Developing Business object Universes.
• Leading the MDM project.
• Developing the source to target mapping.
• tracking data quality, completeness, redundancy, and improvement using Business Objects First Logic.

Environment: MSSQL SERVER 2005, SSIS, BUSINESS OBJECTS DATA INTEGRATOR 11.5, ORACLE, BUSINESS OBJECTS REPORTING 6.5, WINDOWS, ERWIN

Confidential, New Jersey , 11/2005 – 02/2006

Project description : Modeling an inventory data mart for Johnson & Johnson Suppliers.

• Developing the conceptual, logical and physical data model for an inventory data mart.
• Developing the source to target mapping.

Environment: INFORMATICA POWERCENTER 7.1.1, ORACLE 9i, WINDOWS, COGNOS,ERWIN

Confidential Harvard, Massachusetts, 09/2005 – 11/2005
ETL Architect (MS SQL Server DTS)

Project Description: ETL Design of a Risk Management Data Mart for Harvard Risk management service.

• Responsible for the ETL architecture.
• Supervising the ETL developer.

ENVIRONEMENT: MSSQL SERVER 2000, MS OLAP, MS SQL Server Analysis, DTS, WINDOWS, ERWIN, BUSINESS OBJECTS

Confidential Boston, MA , 12/2004 – 09/2005

Project Description: The project consists on a conversion of 2 payrolls and human resource systems from Adabas to MS SQL Server-based Commonwealth Information Warehouse.

• Leading the data modeling effort for the project.
• Developing migration scripts from Adabas files to MS SQL Server.
• Developing end user views.
• Testing the new data mart.

ENVIRONEMENT: MSSQL SERVER 2000, MS OLAP, MS SQL Server Analysis, DTS, WINDOWS, ERWIN, BUSINESS OBJECTS, INFORMATICA.

Confidential 03/2003 – 12/2004

• Helping different CAE IT groups with their ER design. Advised them on the best modeling practice and validated their ER Model.
• Responsible for design and maintenance of the enterprise dimensional models.
• Helping the ETL group with ETL development (IBM Warehouse Manager).
• Developing a data mart solution for piece defection using MS SQL Server DTS and Erwin.
• Managing the IBM metadata Information manager.

ENVIRONEMENT: DB2 7,IBM WAREHOUSE MANAGER MS OLAP ,MS SQL Server Analysis, UNIX, WINDOWS,ERWIN,BUSINESS OBJECTS,MS SQL SERVER 2000 DTS

Education and Trainings:

• Business Objects Certified Professional — Business Objects Data Integrator
• Business Objects XI ETL data integrator DMDI301 (Level 2) Certified.
• Business Objects XI ETL data integrator DMDI201 (Level 1) Certified.
• ETL Architecture in depth
• IBM DB2 Warehouse Manager
• Microsoft MCDBA
• MS SQL Server 2000 Data Warehousing Certification
• MS SQL Server 2000 Administration Certification
• MS SQL Server 2000 Design Certification
• Bachelor Computer Science
• Software Engineer