A client that trades both US and foreign securities was having difficulties with their matching of security IDs.  Most of their global custodians were providing a separate field for each type of security ID, but their primary security ids usually defaulted to either a CUSIP or an internal security ID.  In response, we set up rules for client’s files to default the primary security ID to CUSIP for US securities and SEDOL or ISIN for foreign securities, allowing client to have a higher original match rate when reconciling the bank holdings vs. the their own client holdings.

(Andy Gnibus, Manager of Data Services)

Electra File Transfer is a utility included free with Electra Data and Electra Data+.  It makes it easy for you to receive your daily files. Installed locally at your site, this utility is something for which competitors charge thousands of dollars. Take a look at the features/benefits of the product, below, and a screenshot of the warning you would see if our system discovers you have a network problem:

A client recently spoke about the challenges of managing the daily exceptions across a large operational team.  Who is working on what? What is the status of the breaks in question?  And who is signing off on their work were the top concerns of the director of operations.

The Electra consulting team addressed each item by simulating a user accessing the real time dashboard that highlighted the number of breaks across all accounts, the status, and who in her management group was responsible for approving the day’s work.  In addition to the dashboard, ad-hoc reports on specific types of breaks can be generate by the end-user giving them added flexibility to mine for the specific information required to resolve a break.  All this can be achieved using the Electra Reconciliation software in real time.  No static reports need to be generated.

The dashboard feature resonated with not only senior management but with the reconcilers themselves.  Having a central digital repository of reconciliation information without reverting to spreadsheets or printouts would allow the operations team to streamline and expedite their daily work exponentially.

(Paul Chung, VP of Client Services)

Here at Electra, we are thrilled to have Paul Chung on our team in the inaugural role of Vice President of Client Services. Years of constant client growth and expansion in the application of our products and services, have created the undeniable need for Paul – an accomplished industry expert who will fully embrace Electra’s dedication to a superlative client experience. He comes to us with much welcomed zeal and fresh ideas for the future of Electra’s clients.
Expect a blog entry from Paul soon!

The use of filters serve as helpful tools for the data reconciliation process as it allows for data conditioning before the reconciliation step begins. There are wide ranges of data filtering techniques that aid in the refining of data sets. In Electra Reconciliation, administrators have access to the table browser, which displays the table and column names along with data type, length and a brief description of the tables within the database. By cross referencing this table to the workspace, users can use the underlying logic to better customize filters to meet their specifications.

(Steve Delgado, Senior Application Engineer)

Table browser w/ underlying elements for holdings table:

Electra Wins Best Reconciliation Management Provider in Waters Rankings 2016

A new client that uses TLM for reconciliation asked us to develop files to load into the latest version of TLM.  Our current group of clients that use TLM have us convert files into SWIFT MT535 and MT950 messages in order to load into TLM.  For this latest version of TLM, we developed 3 new pipe delimited files per TLM’s requirements.  This was the first time we developed a transaction file that also contained the opening and closing balances on every transaction record.

(Andy Gnibus, Manager of Data Services)

New TLM Files

SOT – Security Transactions
SOP – Security Positions
SOC – Cash Transactions and Cash balances

A New York City-based Institutional Manager using Electra Data to feed audited market data values from their custodians into Electra Billing is realizing the benefits that the integration these products can bring.  The automated loading of reconciled/audited market values is decreasing the time needed to invoice clients, and reducing manual steps at the same time.  Additionally, Electra Billing’s message notification alerts clients as the market value data is loaded. The client reports that this real-time communication from Electra Billing is vital to the timely execution of their billing cycle.

One of our institutional investment managers has expressed a need to calculate fees for a group of accounts in a household, but with a slight twist. The functionality for grouping accounts is native to Electra Billing—the added twist being the need to calculate sub-groups within the household in a specific sequence and furthermore, ensuring that specific accounts bear the brunt of the lower tier fees. Utilizing the Subset & Floor functionality within Electra Billing, our client was able to satisfy the new request, and calculate the accounts in the exact sequence needed. This functionality is referred to as Stacking & Tiering, which is also native to Electra Billing. The client was thrilled to learn they could accommodate this request seamlessly and without the need for any special development.

(Doug Fritz, Product Manager — Electra Billing)

Electra Wins Best Reconciliation Solution in the FTF News Technology Innovation Awards 2016