DWLOGIC (Data Warehouse Logic) | A Data Warehouse Consulting Firm specializes in Architecture.


Clients in other Industries include:

	Business Objects http://www.businessobjects.com/ Business Objects is a global business intelligence (BI) software company, with more than 43,000 customers - including over 80 percent of the Fortune 500 - and a network of more than 3,000 partners and resellers. In November, 2006 DWLOGIC (Eran Cypris) was employed by Business Objects and served as a Principal Consultant (Data Warehouse Architec), as such DWLOGIC was responsible for: Defined the architecture and standards for the BAE corporate data warehouse pilot. Identified the data source elements required for the pilot, (from internal systems, Deltek, People Soft), Integrated and mapped them into the data warehouse and then into the data marts. Defined the conformed dimensions for the project. Designed dimensional model for the BAE corporate data warehouse pilot. Guided the ETL/Report's developers on how to load and use the star schema.

	Sotheby's - Auction Industry http://www.sothebys.com Sotheby's is the world's oldest international auction house in continuous operation. It was founded in London, England on 11 March 1744 by Samuel Baker. Today the firm has an annual turnover of approximately $2 billion. Sotheby's is not just one of the oldest fine art auctioneers in the world, but also now the largest. There are more than 100 Sotheby's offices around the world. In March 2006 DWLOGIC (MyIdea, LLC) was engaged in a contract with Sotheby's in which it was required to: Identify and evaluate issues involving client data quality, related implications, suggest areas of improvement. Identify similar clients/duplicates out of 2 millions client records. Conduct bottoms-up review of all identified data sources, data transformations, and business rules that affect data quality and readiness. Analyze the use of technology to detect and reduce defects in client's data.

	Capitol Advantage http://capitoladvantage.com Capitol Advantage is the nation's pioneer and leading provider of online and offline grassroots solutions for more than 1,500 corporations, nonprofits, associations, educational institutions, media portals, and other organizations. In March 2005 and January 2008 DWLOGIC (MyIdea, LLC) was engaged in a contract with Capitol Advantage in which it was required to: Lead the ETL redesigning effort in order to use bulk and direct loading. Improve performance of corporate data warehouse (remodeling). Define the remodeled data warehouse standards and techniques. Train the data warehouse team on how to implement and maintain the remodeled data warehouse based on their own unique requirements. Define the dimensions and the fact tables for their current report's data elements

	Arbitron - Radio Communications Industry http://www.arbitron.com Arbitron Inc. is a media and marketing research firm serving the media�radio, television, cable, online radio and out-of-home�as well as advertisers and advertising agencies in the United States. Arbitron�s core businesses are measuring network and local-market radio audiences across the United States; surveying the retail, media and product patterns of local-market consumers; and providing application software used for analyzing media audience and marketing information data. The company has developed the Portable People Meter�, a new technology for media and marketing research. From May 2002 until May 2003, DWLOGIC (Eran Cypris) was employed by Arbitron Inc, to improve the design of Arbitron Data Warehouse system. During that time DWLOGIC accomplished the following: Design and tune 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. Lead the benchmark effort to compare the ETL performance between Microsoft DTS 2000 and Informatica Power Mart 5.0. Design the time dimension logical model (15 minutes granularity for multiply time zones as well as local time). Estimate the long-term volume of the Data Warehouse. Design the logical star schema to support the radio rating calculation. Design the Diary Listening logical and physical model of the Persistent Storage Area (PSA) using Designer 6.1

	Oracle Corporation - Healthcare Industry http://www.oracle.com Oracle Corporation is one of the major companies developing database management systems (DBMS), tools for database development, middle-tier software, enterprise resource planning software (ERP), customer relationship management software (CRM) and supply chain management (SCM) software. Oracle was founded in 1977 by Larry Ellison, and has offices in more than 145 countries around the world. It employed more than 50,000 people worldwide and is the world's second largest software company. From May 2000 until June 2001, DWLOGIC (Eran Cypris) was employed by Oracle Corporation. While in Oracle DWLOGIC was assigned to work on CapCure project, to build a Data Warehouse that would effectively support trial data studies needs, from multiple sites . During that time DWLOGIC accomplished the following: Led the design and architecture of the CapCure Data Warehouse. Wrote the use case document for the CapCure Protocol data warehouse for 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 were based on tens of queries and sub queries. Analyzed, designed and developed a security system for the data warehouse.

	Marriott International - Hospitality Industry http://www.marriott.com Marriott International, Inc., is a leading lodging company. Its heritage can be traced to a root beer stand opened in Washington, D.C., in 1927 by J. Willard and Alice S. Marriott. Today, Marriott International has about 3,000 lodging properties located in the United States and 67 other countries and territories. From March 1998 until April 2000, DWLOGIC (Eran Cypris) was employed by Marriott International, to design and implement the Mariott's Reservations Data Warehouse (MRDW) system. During that time DWLOGIC accomplished the following: Enhanced data modeling, Improved performance of the DW, which had over 1,800 properties residing in a 0.4 Terabyte with several millions transaction per night and a daily refreshment schedule. The biggest fact tables contained about 500 million records breaking into 6 vertical partitions per year. Successfully tuned the performance 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. Designed parts of the data warehouse star-schema using PowerDesigner 6.1 Created an application that normalized Marriott's customer's names. Designed and implemented Aggregate tables and their loading process for Impromptu cubes.