Client Description

TD Ameritrade Holding Corporation provides online brokerage services. The Company, through its private client and institutional client divisions, provides tiered levels of brokerage products and services tailored to meet the varying investing, trading, and execution needs of self-directed individual investors, financial institutions, and corporations.

Through several subsidiaries, it provides electronic discount brokerage and related financial services that enable retail investors to trade common and preferred stocks of US companies, exchange-traded funds (ETFs), mutual funds, bonds, options, futures, and foreign currencies. TD Ameritrade also runs the Investools investor education program. In addition to its online offerings, the company provides services through a retail network of more than 100 branches nationwide. TD Ameritrade holds more than $773 billion in client assets across 6.9 million funded client accounts.TD Ameritrade purchased rival Scottrade for $4 billion in 2017.

Beyond its core online service for active traders, TD Ameritrade also offers online education platform thinkorswim Group, which specializes in options trading and investor education; Red Option Advisors, which provides options advisory for self-directed investors; Amerivest, which develops portfolios of ETFs and mutual funds for clients based on their investment goals; and TD Ameritrade Corporate Services, which provides self-directed brokerage services to corporations and their employees, either directly or through a third-party relationship such as a 401(k) plan. Other trading and investing platforms include Trade Architect for options trading, and TD Ameritrade Mobile for investors looking to trade on-the-go.

Omaha-based TD Ameritrade’s national retail network includes more than 100 branches in large metro areas in 33 US states and the District of Columbia. Its data center facility is located in Richardson, Texas, while its operation centers and facilities are located in Jersey City, Fort Worth, California, Colorado, Illinois, Maryland, Michigan, Texas and Utah. The firm derives substantially all of its revenue from operations in the US.

The firm targets a broad market of independent, value-conscious retail investors, traders, financial planners and registered investment advisors (RIAs), and institutions.

Challenge

TD Ameritrade needed to identify, outline and implement performance tuning measures against existing IBM Netezza Servers (Twinfin 24).

Solution

iOLAP implemented best-practice architecture to achieve efficient query retrieval on existing, high-usage installations, including Skimmer IBM Netezza Servers (Development), Twinfin24 IBM Netezza Server, and a new Striper (N2001).  The iOLAP team defined and implemented a new ‘Statistics and Groom Strategy’, to increase performance lift and lessen impact on users.  This included a proof of concept to change data types from numeric to appropriate integer size.  The team also reviewed current security implementation and worked with DBA to implement improvements to take advantage of GRA.

Benefit

TD Ameritrade now has DBAs trained in Netezza best practices, and installations fully optimized to deliver operation efficiency to various business units.

  • Tools: Netezza
  • Categories: Big Data, Strategy
  • Tags: Financials