Banking / Leasing Success Stories

Data Warehousing

Redesign an existing data warehouse in order to optimize performance and reduce the need for additional hardware due to additional customers and increased utilization by existing customers. Read more...

Project Accomplishments

  • Developed a new architecture to minimize data movement and streamline the batch process responsible for loading the warehouse.
  • Wrote new modules and modified existing programs to optimize the database I/O.
  • Developed automated testing procedures to compare existing warehouse data elements with the re-engineered implementation.
  • Reduced processing time and storage requirement significantly.
  • Successfully rolled out the changes with no adverse impact to existing customers through thorough testing and validation procedures.

Project Synopsis

CTS re-engineered an existing data warehouse to reduce the processing time and storage requirement. Growth in the customer base and the addition of new functionality since the inception of the warehouse caused the hardware to approach capacity and placed excessive demands on the team supporting the warehouse. A significant reduction in processing time of about 75% was achieved. In addition to processing speed, desk space utilization was reduced by 30%. Moreover, the goal of tuning the existing warehouse without compromising the data processed was met. With this project completed, customers could be added to the warehouse while the purchase rate of new hardware was reduced.

Technologies

UNIX, PL/SQL, C, K-Shell

Customer Profitability

Provide bank management with tools to monitor and analyze the profitability of a customer relationship to better manage the relationship; assist in focused marketing efforts and manage the compensation of officers. Read more...

Project Accomplishments

  • Developed and designed a data-mart in order to capture customer demographic information in addition to capturing the profitability of an account, customer, household, corporate household, branch, and officer.
  • Designed and developed a data-gathering process to collect inputs, needed for the profitability model, from multiple sources.
  • Designed and developed an analysis engine to operate on the gathered inputs and produce profitability information for each account in the format of an income statement.
  • Summarized the data from the account level to the customer, household, corporate household, branch and officer levels.
  • Produced trending information over 13 months for all levels.

Project Synopsis

CTS helped its client develop the functional specification as well as the data model for the profitability system. In addition, CTS developed and implemented the batch application. This system allows banks to gain a better understanding of their customers. The customer relationships with the bank were presented in a consistent format using an easily understood income statement format. Customers are ranked and householded. In addition, they are divided between individual, retail, and commercial customers. Products in the profitability analysis include: Deposit, Loan, Credit Card, Mortgage, Account Analysis, and Investments.

Technologies

UNIX, PL/SQL, C, K-ShellUNIX, PL/SQL, C, K-Shell

Leasing

Evaluate the processes involved in the processing of a lease and identify ways to improve it through the introduction of new technologies and process re-design. Read more...

Project Accomplishments

  • Fully documented all current business processes.
  • Designed new processes around enabling workflow and document management technologies.
  • Evaluated and recommended document management and workflow tools that best met the needs of the client.
  • Estimated the costs of implementation including hardware, software, and customization.

Project Synopsis

Our client needed to improve its turnaround time for processing a loan in order to better compete with other leasing firms in the marketplace. CTS worked with the client to document the current business processes and found that the current methods relied heavily on paper documents that traveled from one desk to the next resulting in the serialization of a process that lent itself to greater parallelization. In order to address this, CTS designed a revised business process that leveraged workflow and document management. This would enable the company to work in parallel and reduce the processing time of a lease by several days. Additionally, it would also allow the company to handle more volume and retain smaller leases that were being sold-off due to capacity constraints.

Technologies

UNIX, PL/SQL, C, K-ShellUNIX, PL/SQL, C, K-ShellWindows NT, MS Exchange, Treev, PC-Docs, KeyFile, Optika, FileNet, MS SQL Server