An Investment and Private Equities Specialist

The client


A young investment and private equities specialist dealing specifically in mortgage backed securities.

The challenge

This startup company needed systems that would enable it to operate in the equity trading industry while avoiding a large broker and operations staff.

They wanted not only to integrate their trading, pricing, settlement and risk analysis systems, but also to transmit data to market and banking institutions using their own custom software.

Without fully automated systems, the sheer volume of data would have been impossible for our client to manage and thus made it impossible for them to open for business. The stakes were high, and the project risks were significant.

What WCI did

Using ETL (Extract, Transfer, and Load) and integration tools, WCI developed a unique way of connecting diverse source systems.

Such a project has its own set of unusual problems that require unique and creative solutions. For example, we implemented reporting and analysis tools to gauge the effectiveness of the systems and evaluate performance of the trading operation.

Scope of solution


The project engaged a WCI team during a 9-month period. For the last 2 months, after completion of the development phase, the team was halved to complete the remaining analytic work, system maintenance, and coaching/transition.

The technologies used on this project included ETL & integration tools, Automate, PGP, SQL Server, and report development and metadata management studios.

WCI also instituted processes for change of scope/functionality, test scenarios, and auditing of all software outputs. We coached the client's staff on development and maintenance of ETL jobs and submitted full documentation with process flows and data mappings.

The Result


Our client was able to open and begin trading on time, with all systems operating as intended in the fault intolerant industry of equity trading.

See what more WCI clients have to say about our services.

Get Started

Want a FREE on-site discovery session with your team?  Receive a FREE data management evaluation session with one of our veteran data architects. Reap the benefits of an expert’s outlook on taking control of your business insights and data. Stop missing out on data-driven opportunities,  and start making smarter, more profitable decisions today.