Eran Cypris
Data Warehouse Architect
9614 Singleton Drive
Bethesda MD 20817
Email: ecypris@hotmail.com
Phone: (301) 897-8548
Cell:(240)505-4746


Career Overview
Eran Cypris is a Data Warehouse Architect with 15 years of data warehousing, data modeling, analysis, design and development experience in Information Technology. He has been a member and lead on several data warehousing projects in industries including Mortgage, financial, rating, Health Care and Hospitality.

Skills Highlight

Oracle Products:
Designer6.0, Designer6.1, Oracle Warehouse Builder 2.0, SQL*Loader, SQL*Plus, Oracle Enterprise Manager (OEM), SQL*Forms3.0, SQL*ReportWriter2.0, SQL*Menu5.0, Pure*Integrate
Operating Systems:
Windows, Unix
Languages:
PL/SQL, SQL, Unix Shell script, HTML, COBOL, Pascal, Pro*C
Databases:
Oracle 9i, Oracle 8i, Oracle 8.0, Oracle 7.0, Oracle 6.0, DB2/UDB8.X, DB2/UDB7.X, Microsoft SQL Server 2000, VLDB
Design Tools:
ERWin4.X, Sybase PowerDesigner 6.1, Oracle Designer2000, Oracle Designer6.0, ABC, Visio 5.0
ETL Tools:
Informatica Power Mart 5.1, Informatica Power Mart 4.5, Microsoft DTS, Oracle Warehouse Builder 2.0, Pure*Integrate
Management/Leadership Skills:
Project Management and Team lead experience.
Specialty Skills:
Data Warehousing, Training, Development and Network Administration
Other Products:
VI Editor, Just in Time (JIT), SQL*Time, TOAD SQL, Syncsort, PVCS, Impromptu
Verticals:
Mortgage, Financial, Media / Radio rating, Healthcare, Hospitality/Hotels, Inventory, Human Resource

Relevant Project Experience

March 2005 to Current
Capitol Advantage (Consulting)
Fairfax, Virginia
Data Warehouse Architect

RDBMS: Oracle 9i

* Leading the ETL re-designing effort in order to use bulk and direct loading
* Tuning the corporate data warehouse including database tuning, query tuning, ETL tuning and re-modeling.
* Defining the new data warehouse standards and techniques.
* Training the current data warehouse team how to design and implement their data warehouse based on their own unique necessities.
* Defined the dimensions and the fact tables for the current reports data elements.

January 2005 to February 2005
CitiGroup (Consulting) – CBG DW
Harrison, New York
Data Warehouse Architect

* Defined and designed from scratch the data warehouse architecture, database, ETL and modeling methods and techniques for CBG, a CitiGroup division. The data warehouse was designed to support financial analysis and risk assessment of the 2 million CBG’s customers. The main driven data warehouse method is Ralph Kimball’s one.
* Wrote the CBG Data Warehouse Architecture Guidelines. I designed the Guidelines to support pre-selected tools (Oracle 9i,AB Initio, Cognos) based on light business specification and data source assumptions.
* Developed Delivery Strategy and Implementation Planning for the Data Architecture
* Assisted in defining the CBG DW support organization

June 2003 to December 2004
Freddie Mac (Consulting) – Corporate Data Warehouse (CDW)
McLean, Virginia
Data Warehouse Architect

Modeling tool: Erwin 4.1.
RDBMS: DB2/UDB 7.X, 8.X
The data modeling was done to match the requirements of Microstrategy.

* Served as a data warehouse architect at Freddie Mac, a leading secondary mortgage company.
* Leaded the effort to create conformed dimensions for the CDW project (15 terabyte DW with thirty dimensions - some of them contain hundreds of millions of records).
* Leaded the effort to create new modeling concepts to improve the OLAP performance.
* Leaded the benchmark effort for the new concepts.
* Served as the data modeler of Data Mart Integration (DMI). The DMI was the first project that defined and used conformed dimension and was used as a pilot project for new DW concepts for the entire CDW.
* Designed dimensional model (Snow Flake) for the Corporate Tax data mart.

May 2002 to May 2003
Arbitron Inc.
Columbia, Maryland
Senior Data Warehouse Architect

Modeling tool: Erwin 3.5, Oracle designer 2000
RDBMS: Oracle 8i
ETL Tool: Informatica Power Mart

* Served as a data warehouse architect at Arbitron Inc., the radio rating company of USA, Canada and Mexico.
* Designed and tuned Informatica Power Mart ETL mappings for Portable People Meter (PPM) Data Warehouse Pilot. The data warehouse contains two years of data for 1500 panelists. Listening data is aggregated to 15 minutes of exposure.
* Led the benchmark effort to compare the ETL performance between Microsoft DTS 2000 and Informatica Power Mart 5.0.
* Designed the time dimension logical model. (15 minutes granularity for multiply time zones as well as local time)
* Estimated the long-term volume of the Data Warehouse.
* Designed the logical star schema to support the radio rating calculation.
* Designed the Diary Listening logical and physical model of the Persistent Storage Area (PSA) using Designer 6.1


August 2001 to April 2002
Science Application International Corporation (SAIC), HRSA
Rockville, Maryland
Data Warehouse Architect

Modeling tool: Erwin 3.5
RDBMS: Oracle 8i, SQL Server 2000

* Identified the data sources for inclusion in the Data Warehouse and leaded the effort to document all requirements and data sources.
* Compared and evaluated different OLAP tools (Brio, Business Objects, Microstrategy and Cognos).
* Compared between Microsoft SQL Server 2000 and Oracle 8i.
* Compared between Microsoft DTS 2000 and Informatica Power Mart 4.5.
* Created the naming convention for the Data Warehouse.
* Designed a dimensioned data structures (Star Schema) for the Data Warehouse using ERWIN 4.0 and foreword it into SQL Server 2000 database.

May 2000 to June 2001
Oracle Corporation, CapCure Protocol Data Warehouse (PW)
Reston, Virginia
Sr. Principal Consultant - Data Warehouse Architect

Modeling tool: Oracle designer 2000
RDBMS: Oracle 8i
ETL Tolls: OWB 2.0, Pure*Integrate

* Worked on CapCure project as a lead designer and Data warehouse architect. CapCure is a multiple sites data warehouse based on the clinical studies. The DW was developed parallel to the development of the source application.
* Wrote the use case document for the CapCure Protocol DW an Oracle Clinical base project.
* Analyzed, designed and developed the star schema for the Data Warehouse using Oracle Designer6.0.
* Created the SQL scripts to load the data into the Data Warehouse.
* Created the SQL scripts to load the aggregate tables. Some of them base on tens of queries and sub queries.
* Analyzed, designed and developed the security system for the data warehouse to manipulate the data accessed by the sites base on viewing privilege on the record level. Since the extract data statistic calculation for each report was based on data source from more than one site and the privilege to view records was based on a flag values. Each user would view different results on the report.

March 1998 to April 2000
Marriott International
Bethesda, Maryland
Marriott Reservation Data Warehouse (MRDW)
Senior System Analyst/Data Modeler

Modeling tool: Power designer 6.0
RDBMS: Oracle 8

During the Post implementation (Production) phase (06/99 - 04/00):
* Responsible for data modeling modification and data performance improving of the data loading and data extracting for Marriott Reservation Data Warehouse (MRDW) (Over 1800 properties - a 0.4 Terabyte Oracle 8.0 Data Warehouse. Daily refreshment with few millions of transaction per night. The biggest fact tables will contain around 500 million records braking to 6 vertical partitions per year. Data will be save for two full years + one floating.)
* Performance tuning of the MRDW transaction by modifying select statements, adding indexes and hints and balancing the transactions.
* Solved production and data migration database and transaction problems.

During the Y2K testing (03/98 - 05/99):
* Designed and implanted the Y2K test plan for MRDW system including created the Oracle database instance and the data structure, defined the Dates Data Elements (DDE) out of the application and the data dictionary
* Created dynamic SQL report for the Y2K testing
* Fixed Oracle Y2K bugs.

During the Designing and construction phase (03/98 - 02/99):
* Designed and developed the referential integrity Oracle databases triggers (around 80) and stored procedures (around 100) using PL/SQL.
* Analyzed, designed and developed the metadata application including designed the data structure and creating the necessary database stored procedures using PL/SQL.
* Designed parts of the data warehouse star schema using PowerDesigner 6.1
* Created application that normalized the Marriott's customer’s names.
* Designed and implemented Aggregate tables and their loading process for Impromptu cubes.


August 1996 to February 1998
Enterprise Information Services, Inc. (Contractor of USAID)
Roslyn, Virginia
Senior System Analyst

* Responsible for the interface between Acquisition & Assistance (A&A - Procurement System) and AWACS (The finance system).
* Analyzed and developing Oracle database triggers and stored procedures for the interface using PL/SQL.
* Created flow chart diagrams for all the interface models using ABC.
* Provided technical support for the Data correction and data migration groups.
* Provided database structure, SQL and PL/SQL guidance for A&A VB programmers.


June 1995 to July 1996
Techmatics, Inc. (Contractor of the United States Postal Service - USPS)
Washington, DC
Senior System Analyst

* Analyzed, designed and developed the online warehouse information system base on radio frequency (RF) devices using SQL*Forms3.0 .
* Created constraints and indexes for Just In Time (JIT) system.
* Designed and developed forms and reports to support the JIT database.
* Created ER diagrams for JIT database (total of more than 1000 tables) using Erwin.
* Created flow chart diagram for the users operations in the USPS warehouse using ABC.
* Provided technical problems' solution for other SQL*Forms3.0 developers.


April 1992 to May 1995
Technology, Management and Analysis Corporation
Mclean, Virginia
System Analyst

* Developed and maintained the TMA's Corporate Information System (CIS) using Oracle SQL*FORMS3.0, SQL*Menu5.0 and SQL*ReportWriter1.1 on an ORACLE RDBMS v7.
* Provided technical support for client contracts.
* Analyzed and provided technical support for Configuration System of CIS.
* Designed and developed recruitment module using SQL*Forms3.0 .
* Created database triggers and stored procedures.
* Provided seamless system integration and data migration between SQL*Time and the internal system.
* Maintained the CIS database including creating tables, views, constraints, indexes, new users and responded to the database and menu security.
* Assisted in the development of the Security modules of CIS.
* Analyzed, designed and developed database and application security system.
* Managed internal migration from ORACLE v6 to ORACLE v7.
* Developed an application (Veteran Appeals Control & Locator System) for DMDI, using Oracle SQL*FORMS3.0 and SQL*ReportWriter1.1 on an ORACLE RDBMS v7.
* Built on-line project catalog using Impromptu.


January 1984 to December 1989
Weinbaum Printing Plant
Haifa, Israel (part time)
Oracle Programmer

* Designed and developed Purchase Order and Inventory system for internal use.
* Responsible for planning the production of the continuous paper department at the printing plant.




Education

1986 to 1991
Bachelors of Science, Industrial and Management Engineering
Technion - Israel Institute of Technology
Haifa, Israel


Training

October 1998 Learning Tree - Oracle 8 - Database Administration: hands-on
May 2000 Oracle University – Pure*Integrate
June 2000 Oracle University - Implementing Oracle Warehouse Builder
October 2000 Oracle University - Enterprise DBA Part 2: Performance and Tuning
May 2002 Infocrest - Informatica Power Mart: hands-on


Citizenships

US, ISRAELI
??

??

??

??



Eran Cypris
Data Warehouse Architect
9614 Singleton Drive
Bethesda MD 20817
Email: ecypris@hotmail.com
Phone: (301) 897-8548
Cell:(240)505-4746