Business Intelligence Repository
Citigate Hudson custom built for ABN AMRO's Global Trade Advisory group a web-based data warehousing and business intelligence solution to enable
management to effectively track operational trade activity interactively throughout the day. Utilizing the solution's unique Business Intelligence
Repository and powerful data visualization tools including an Executive Dashboard, ABN AMRO is able to track trends, proactively identify and resolve
problem areas, balance workload among its global operation centers, minimize risk exposures, and manage costs in its various business groups around
the world.
Customer Intelligence Repository
In order to improve its global call center operations, ABN AMRO's Trade division has replaced its local branches' paper-based call-logging
and workflow process with a more efficient system for predicting workload and analyzing service level compliance and customer satisfaction. The Customer
Intelligence Repository, designed and developed by Citigate Hudson, consists of a web-based application to log inquiries, route and/or escalate
them through a managed workflow to resolution, and proactively auto-email additional interested parties (sales, front office, etc.) regarding status.
Regional managers obtain real-time data enabling them to more efficiently balance workload across different regions. The system tracks and feeds metrics
to an executive dashboard and business intelligence system, providing senior management with hourly "snapshots" of global activities. Color-coded volume
and trend charts (by type, cause, region, etc.) allow drill-down analysis of customer behavior, workflow analysis by region and group, and service level
compliance. Users can customize their dashboards to match up call center activity with customer transactions fed from operations for a single complete
view of the client account.
Citigate Hudson helped Arts International bring artists, funding organizations and event sponsors together through creation a web-based knowledge system. Citigate Hudson quickly designed and populated a centralized database to consolidate and replace various existing, redundant MS-Access and paper-based systems managed by individual Arts International staff. Citigate Hudson's solution allows Arts International to manage multiple artists' performance schedules, improves data quality and timeliness, and enables fast, user-friendly searches.
Bear Stearns engaged Citigate Hudson to develop a web-based data warehousing and business intelligence solution for its proprietary trading system. Utilizing data visualization tools customized by Citigate Hudson, Bear Stearns is able to more effectively track, analyze, and manage portfolio positions and revenue streams across multiple business lines.
For Incepta Online affiliate, Capital Bridge, Citigate Hudson created an innovative web-based, online investor relations portal system that enables researchers, analysts, consultants and clients to access the same financial market and investor contact and research database. This leading-edge technology solution assists corporate investor relations professionals by offering such features as a sophisticated investor screening tool; road show/event/IR calendar organization; list management of contacts, firms, funds, events and shareholdings; and board-quality report generation.
When Clark/Bardes Consulting needed to design and implement the network infrastructure for its new Park Avenue office, they chose Citigate Hudson. Citigate Hudson established LAN/WAN connectivity and customized the Clark/Bardes' Exchange e-mail system to provide seamless interaction with the company's head office in Chicago and satellite offices in Boston and Los Angeles.
Citigate Hudson developed various secure, proprietary intranet database applications for CSFB's Investment Banking Division and its predecessor at Donaldson, Lufkin & Jennerette. The objective was to create secure web-based enterprise management applications that serve the diverse business needs of investment bankers and accounting group users alike. We worked with CSFB to integrate their legacy databases into unified, high-performance systems that reduced daily IT staff intervention in accounting activities, manual data reconciliation and analysis, and select forecasting/reporting projects.
Tech Poll
CXO Media Inc. provides extensive information technology (IT) industry data and services to top corporate executives. The company publishes leading
magazines including the monthly CIO magazine. The magazine's "Tech Poll" provides its readers with a tool to gauge technology growth trends and assess their
impact on the overall economy. Citigate Hudson manages all of the technical and production processes that support the poll. This includes implementing the
software for tabulating and analyzing results of the poll. One of the chief business benefits of the Tech Poll has been enhanced visibility for CXO Media
and CIO magazine. For example, the Tech Poll has received publicity coverage in media including CNN, Reuters, Associated Press, USA Today, Business Week,
the International Herald Tribune, and many others.
Datamonitor is a business information company that specializes in industry analysis. Through its research expertise and proprietary databases, Datamonitor provides leading enterprises with analysis, in-depth forecasts, and reports in a variety of industry sectors. Datamonitor engaged Citigate Hudson to create an online subscription service that uses advanced Business Intelligence technology to allow Datamonitor customers to analyze the company's proprietary research. Subscribers can easily search and navigate content, and quickly custom-build their own reports in applications including Excel, Word, or PowerPoint. By selling this system as a subscriber service, Datamonitor entered into an entirely new market.
Citigate Hudson created a web-based calendar and reporting extranet application called Citigate Ad Trac (CAT), which enabled the Gate Worldwide to track advertising coverage across media for its clients. The application is integrated with the Gate Worldwide's accounting database to automate client billing and revenue forecasting and tracking operations.
Citigate Hudson provided on-site long-term development assistance for Hess's commodities trading and market data systems (including P&L and equity reporting, trade matching and liquidation, and back-office reconciliation), as well as expertise on SQL Server configuration and tuning. Our custom network management platforms provided immediate notification of system and network events through various methods, including auto-faxing, paging, wireless email, and voice synthesis telephony.
Purina partnered with its largest customer, Wal-Mart, to provide shelf space management and unit sales tracking for all its pet product sales across all Wal-Mart's 3,200 US facilities. Citigate Hudson developed an OLAP solution that enabled Purina to quickly analyze, understand and manage Wal-Mart's point-of-sale sales data. The business intelligence solution enabled Purina and Wal-Mart to make more informed category and product management decisions. Citigate Hudson's solution reduced the time and effort required to provide actionable reports to Wal-Mart and the ability to quickly correlate product cross-sells.
Citigate Hudson is working at NewYork-Presbyterian Hospital to create a data warehouse and business intelligence solution that will provide up-to-date financial and clinical data including operational metrics, as well as patient occupancy, quality measures, and discharge information.
Citigate Hudson developed a customized data transformation application to clean and transform raw inventory data from Next Planet Over's inventory suppliers for its online e-commerce product database. Streamlining the supply process enabled Next Planet Over to ramp-up to meet increased consumer demand from the company's web site.
Document Management and Publishing System
The National Football League Management Council (NFLMC) oversees Player/Club relations and the Collective Bargaining Agreement for the member clubs
of the NFL. A mandate of the organization is to provide senior management of member teams with access to highly confidential Management Council-related
documents. The previous manual system of requesting and sending documents was both time-consuming and labor-intensive. Citigate Hudson custom-built
a document management and publishing system that enables users to save and display documents and Web pages while still maintaining centralized control
over site administration and security.
Interactive Reporting System
The National Football League's Finance Division is responsible for the financial management of the League's subsidiaries, such as NFL Europe. With the
consolidation of the NFL's 13 business entities, the Finance Division determined that the previous analytical tools could not effectively support the
analysis and reporting requirements of the division. Citigate Hudson developed an Interactive Reporting system using online analytical processing (OLAP).
The new system enables the Finance Division to more quickly and effectively provide NFL upper management with consolidated financial reports and
comprehensive analysis of the League's finances.
SmartMoney.com's Map of the Market is a cutting-edge technology that allows investors to visualize movements of securities and sectors in the form of a heat map. Citigate Hudson was critical in developing SmartMoney.com's robust back-end architecture, capable of quickly serving accurate, up-to-the-minute financial information. Citigate Hudson provided architectural expertise to build the Map of the Market's underlying dynamic database refreshed from multiple market data feeds while maintaining maximum speed and reliability. Citigate Hudson also helped develop the company's subscription-based, online investor product, MapStation, integrating real-time quote data feeds,and optimizing performance to support 10 times as many concurrent users as competing products.
Citigate Hudson developed Société Générale Investment Bank's (SG-IB) portal site, which highlights current deals, provides up-to-date global contact information, and links the disparate web-sites run by other SG Group organizations. Deal information from a proprietary data store is fed to the web site and updated automatically on a daily basis. The deals database is searchable, enabling site users to quickly locate specific deals and learn about bank activities.
Citigate Hudson designed, developed, and deployed global client profiling systems, providing the foundation for effective client relationship management and enabling users to identify, segment, and target specific clients for marketing materials, business development, and event planning. Our migration interfaces and cleansing routines leverage existing legacy data stores, providing refreshed information on buyer/seller behavior, as well as updates on current client addresses and contact information. Dynamic querying against the data mart enables users to do historical tracking, reporting and trend analysis, and data mining.
Stolt-Nielsen S.A. provides integrated transportation services for its customers. These operations require Stolt to manage a global fleet of ships supported by agents in ports around the world. Citigate Hudson worked with Stolt to develop an OLAP reporting system to evaluate the performance of those agents. The capabilities of the reporting system allowed Stolt to decrease their financing costs by approximately $2MM per year, and drastically reduced the amount of time between the issuance of an advance and the receipt of the agent's actuals.
Citigate Hudson's database performance tuning decreased the processing time of TV Guide's forecasting data warehouse application from 60 minutes to 3 minutes, greatly increasing efficiency. In addition, Citigate Hudson provided advanced MS SQL Server on-site training to the TV Guide IT staff.
United Online engaged Citigate Hudson to help formulate and develop a business intelligence OLAP application for Subscriber Revenue Analysis for its consumer internet subscription service, Juno. Citiagte Hudson worked with United Online developers to refine the code required for determining the financial expressions necessary for analysis and trained these developers on advanced OLAP architecture and development.
VNACJ engaged Citigate Hudson to evaluate the hardware and software components of one of the organization's mission-critical application systems. Citigate Hudson provided strategic advice on OLAP solutions and SQL code optimization recommendations to enhance the performance of the application and its reporting components.
XL Capital Assurance, a Financial Guarantor Insurance Company, engaged Citigate Hudson to develop a quotation system to allow its Secondary Market Desk to issue underwriting quotes in less than a minute. The system allows the desk to process a greater volume of business more quickly and safely by automating processes that were previously manually implemented. The system also provides risk management capability by highlighting material events that adversely affect a securities valuation.
Zest is a Tokyo-based provider of custom software solutions. The company employed Citigate Hudson to help develop a sales order system that allows Zest clients to improve the way they maintain customer, inventory, shipping, and billing information. Built on a custom framework that centralizes common functionality, the system allows developers to quickly and easily build new forms. Another feature is a library of common user controls and business classes that allows developers to use common functionality instead of being required to rewrite unnecessary, redundant code. This helps make future system development faster and more efficient.