Companies in the financial services industry are being overwhelmed by escalating amounts of data. Yet they must make proactive and informative decisions in a fluctuation situation due to shifting markets and world events. Therefore leveraging business intelligence and performance management solutions is essential to gain valuable insights into their organization, customers, operations, and supply chain. A successful data warehouse system will positively impact their bottom lines, resulting in a sustained - Effective Competitive Advantage.

Clients in the financial service industry include:

First Horizon National (FHN)) / First Tennessee Bank (FTB)
https://www.firsttennessee.com/

First Tennessee Bank is a financial services company based in Memphis, Tennessee. It is a subsidiary of First Horizon National Corporation and the largest full-service provider of financial products and services for businesses and consumers in Tennessee with a genuine influence beyond the borders of its state. In March 2012 DWLOGIC (MyIdea, LLC) was engaged in a contract with First Horizon National (FHN) / First Tennessee Bank (FTB), in which it was required to:
  Define and design the Commercial Work Flow (CWF) data architecture, data modeling and source reverse engineering.
  Be responsible for data integration, with data sourcing and targets including BDW, ODS etc.
  Perform data profiling on BDW Oracle environment and DB2 databases, identify potential and partially hidden FKs within and across data sources.
  Built missing flat files data dictionary and identifying missing data dictionary elements.
  Model the bank’s reference data as a part of the Master Data Management (MDM) team.

Leumi Bank
http://english.leumi.co.il/

Bank Leumi is Israel‛s leading commercial bank, with $85 billion in assets and a presence in USA, Switzerland, UK and other countries. Bank Leumi is mainly in private hands, with the government as the largest single shareholderhe stock. 60% of the bank‛s stocks are held by the public and traded on the Tel Aviv Stock Exchange.
In April 2009, DWLOGIC (Eran Cypris) was engaged in an indirect contract (MalamTeam) with Leumi Bank as a Data Warehouse Architect in which it was responsible for leading and guiding the team in analyzing, mapping and loading the data from Bank Leumi‛s custody services system into Netik InterView Data Warehouse.

Hapoalim Bank
http://www.bankhapoalim.com

Bank Hapoalim is Israel‛s leading financial services group and largest bank. The Bank has a significant presence in global financial markets. In Israel, the Group has over 260 full-service branches, eight regional business centers, and industry desks for major corporate customers.
In December 2008, DWLOGIC (Eran Cypris) was engaged in an indirect contract (MalamTeam) with Hapolaim Bank as a Basel II Data Analyst in which it was responsible for analyzing and mapping of the on and off balance of Bank Hapoalim transactions from their Data Warehouse into FinArch‛s Financial Studio in order to meet the Bank of Israel Basel II regulations and capital adequacy.

Citi Group
http://www.citigroup.com

Citi (part of citigroup) is today‛s pre-eminent financial services company, with some 200 million customer accounts in more than 100 countries. Citibank is one of the largest full service banks in the world since its inception in 1812.
In January 2005 DWLOGIC (MyIdea, LLC) was engaged in a contract with Citigroup in which it was required to:
  Define and design the architecture of a brand new data warehouse to support financial analysis and risk assessment of CBG‛s two million customers.
  Write the CBG‛s Data Warehouse‛s Architecture Guidelines.
  Develope the delivery strategy and the implementation plan of the DW architecture.
  Assist in defining the CBG DW organization support.
  Assist in integrating the DWL CDI solution as the standard source for the Customer Dimension.

Fannie Mae
http://www.fanniemae.com

Fannie Mae was created in 1938, under President Franklin D. Roosevelt, to provides funds to mortgage lenders through the purchase of mortgage assets, and issues and guarantees mortgage-related securities that facilitate the flow of funds into the mortgage market in the United States.
In November, 2005 DWLOGIC (MyIdea, LLC) was engaged in an indirect contract with Fannie Mae in which it was responsible for:
  The restatement system test data and the data movement within the company‛s work streams.
  The new financial data warehouse design and architecture.
  Coordinating the new data warehouse standard within existing data warehouse projects at Fannie Mae.
  Writing the architecture guidelines.

Freddie Mac
http://www.freddiemac.com

Freddie Mac, one of America‛s biggest buyers of home mortgages, is a stockholder-owned corporation chartered by Congress in 1970 to keep money flowing to mortgage lenders in support of homeownership and rental housing.
In June 2003, DWLOGIC (MyIdea, LLC) was engaged in an indirect contract with Freddie Mac to design and implement the data modeling of Data Mart Integration (DMI) in order to match the requirements of Microstrategy. The DMI was the first project that defined and used conformed dimension and then was used as a pilot project for new DW concepts for the entire CDW.
DWLOGIC was also asked to lead 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).
  Create new modeling concepts to improve the OLAP performance.
  Design dimensional model (Snow Flake) for the corporate tax data mart.