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)
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.
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
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.
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
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 (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
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 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
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, 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.