DWLOGIC (Data Warehouse Logic, LLC) specializes in Architecture of Data Warehouse Systems. Site Map
Contact Us

Clients in other Industries include:

Business Objects Logo

Business Objects

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 Logo

Sotheby's - Auction Industry

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 Logo

Capitol Advantage

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 Logo

Arbitron - Radio Communications Industry

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 Corp. Logo

Oracle Corporation - Healthcare Industry

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 Logo

Marriott International - Hospitality Industry

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.

buy viagra cheapest best prices online
buy generic viagra online
guaranteed cheapest viagra
buy viagra per pill
buy viagra cheaply
buy cheap levitra
viagra rrp australia
buy viagra order viagra
ordering cialias
viagra online uk
cialis coupons
buy now levitra
where can I buy cialis 20mg
cheap deal viagra
buy in uk viagra
buy viagra online off pharmacy prices
try viagra for free
viagra suppliers in the uk
buy viagra online
buy viagra over the counter
viagra and cialis cheap
viagra and hearing loss
buy real viagra pharmacy online
viagra professional
buy sildenafil viagra
buy levitra canada
buy viagra prescription
cheap discount viagra viagra
buy generic viagra viagra
buy cialis now
buy viagra onli
cheap genric viagra online
viagra quebec
buy female viagra
buy viagra onlines
buy viagra online at
buy say viagra
brand cialis 20
uk viagra sales
buy real viagra online
cheap viagra canada
natural viagra
buy viagra online paypal
generic viagra
buy now online viagra
ebay + cialis
cheap cialis overnight
viagra uk cheap purchase buy
buy cialis online
ordering viagra onl
buy lexapro
key buy-viagra
buy in online uk viagra
buy low price viagra
cheap levitra online
buy no online prescription viagra
lowest price viagra
buy viagra online au
marijuana and viagra
cheap generic overnight viagra
buy viagra cialis levitra
india viagra cialis vicodin
cheapest uk supplier viagra
cheap no prescription viagra
cheap pharmaceutical viagra
buy viagra online and get prescription
purchase viagra online
viagra alternatives
buy cheap viagra online
cialis voucher
cheap free viagra viagra
cheap prescription viagra
homemade viagra
cheap herbal viagra
cheap viagra generic
cheap generic india viagra
buy online online viagra viagra
buy viagra
non prescription viagra
cialis overnight shipping
buy viagra other drug online
buy viagra cheapest
cheap viagra without a prescription
buy viagra online now buy viagra
buy discounted viagra
buy now cialis
does watermelon have viagra effect
buy real viagra
cheap generic viagra worcester imc
buy viagra online get prescription
cheap viagra in the uk
buy discount viagra viagra viagra
buy viagra powered by phpbb
cost of viagra
cheap generic viagra substitutes
is viagra safe for women
buy viagra online u
viagra over the counter walgreens
buy cialis no prescription
cheap generic substitute viagra
viagra price in india
cheap kamagra uk viagra
cheap man viagra
cheap discount levitra online
walmart cialis price
buy viagra online cheapest
buy line viagra where
buy in online usa viagra
buy now viagra
buy viagra on the internet
cheap sale viagra
viagra without prescription
cialis no perscription
buy 100 mg viagra
cheap generic viagra no script
female viagra
buy viagra online india
buy kamagra viagra india
buy line viagra
buying viagra online
cheap viagra tablets
viagra generic
brand cialis
buy levitra now
free viagra in the uk
cheap generic online viagra
cipro 20
cheap free price viagra
cheap discount viagra
viagrafree samples
viagra coupons and discounts
cheap inexpensive viagra
buy viagra Australia
buy online levitra cialis viagra
viagra and cialis and
buy nexium
buy generic viagra
buy viagra online at lowest price
buy viagra online discount
viagra super active
cheap site viagra
alternative to viagra
buy viagra usa
buy duscount viagra online
canadian levitra vs usa levitra
buy viagra online without prescription
cheap drugs viagra cialas
buy cheap tamiflu
buy discount viagra
cheap drug viagra
shipping viagra to australia
buy viagra online in australia
viagra pro online
viagra pfizer
cheap cialis online
real viagra
buy viagra overnight
buy viagra pills
price of viagra
buying viagra in uk
buy viagra internet
q buy viagra online
buy get online prescription viagra
buy viagra online online pharmacy
viagra and cialis
buy discount soma
buy online drug viagra pharmacy
buy viagra 50mg
cheap generic viagra overnight delivery
buy online online pill viagra viagra
cheap price viagra
buy viagra online no prescription
buy viagra pharmacy online
cheap generic viagra no prescription
cheap prescription viagra without
buy sale viagra
viagra rrp australia cost
buy prescription vaniqa viagra
ed pro trial pack
cheap generic 50 mg viagra
cheap viagra viagra
viagra dosage
levitra 100mg uk
buy viagra online at cheap price
viagra sample
buy viagra alternative
ed. trusted medstore in cialis
cheap free viagra
cheap generic viagra
free viagra
buy viagra online in
cheap herbal viagra viagra
generic viagra from india
accutane for sale online
cheap generic viagra from usa
cheap viagra fast shipping
buy site viagra
cheap molde ticket viagra
buy viagra cialis
cialis no prescription
cheap pill pill sale viagra
buy viagra online order
cialis vs viagra
buy viagra online uk
buy internet viagra
buy kamagra viagra
cialis replacement
buy viagra online in the uk
cheap kamagra viagra
buy generic viagra buy
viagra uk
cheap generic viagra uk
free viagra without prescription
cheap generic viagra substitute
cheap india viagra
watermelon viagra
buy cymbalta
uninsured cost of cialis
free viagra sample
cialis super active review
buy cheap cialis
buy viagra now
buy real viagra online pharmacy
cheap generic viagra online
buy price viagra
cheap soft tab viagra
buy viagra online in uk
buy viagra online a href
viagra for sale
buy cialis canada
cheap viagra india
cheap phizer viagra
buy viagra online order generic viagra
viagra free trial offer
buy viagra over the counter us
buy generic viagra img
buy locally viagra
generic levitra
buy viagra montreal
over the counter viagra
buy viagra prescription america
purchase levitra
female use of viagra
buy cheap viagra online uk
cheap meltabs viagra
cheap mexico viagra
buy prescription viagra
buy generic viagra usa
viagra oral
buy cheap viagra
buy viagra online pharmacy
viagra oral jelly
cheap viagra in uk
buy viagra pill
where to buy viagra in beijing
buy viagra online canadapurchase cialis
cheap discount cialis
viagra for sale without a prescription
buy viagra online paypal vipps
buy viagra and cilas
buy generic viagra online pharmacy online
cheap viagra online canada
discount viagra
buying viagra
cheap viagra
cheap meltabs online viagra
buy levitra viagra online
levitra online
buy viagra using paypal
viagra prices walmart
which is better cialis or viagra
buy viagra pill online
buy prescription viagra without
buy later now pay viagra
buy cialis from india
purchase levitra online
generic vs brand name viagra
buy viagra online ireland
amazon viagra
how can i buy viagra online in canada
cheap pharmacy viagra
buy discount cialis
online overnight viagra
buy generic viagra pharmacy online
Viagra Oklahoma city
buy online order viagra
buy in spain viagra
generic cialis
buy viagra online australia
buy viagra online alternative viagra
buy viagra online web meds
cheap pill viagra