Data Analytics

Ability to trace all inbound and outbound cash in near real time.
Designed utilizing inhouse products like MS SSIS for data extraction and Spotfire for Analytics

Outcome

Reports presented through Spotfire and excel
Data sourced from Misys Loan IQ, Microsoft Dynamics AX, and G-Treasury
Custom ETL Packages and scheduled jobs to refresh data near real time
Auto email notification of new payments received
Audit of payment transactions between Treasury system and Subledger system

Overview

Industries

Financial Services

Capabilities

Data Architecture & Engineering

Data Visualization & Analytics

Technology Platform

Quality Engineering

Scope of service

Project Management

Architecture & Design

Requirement Gathering

Development

Testing

Production Support

Technology

1TrakIt Cloud Application Modules:

No items found.

Related cases

Custom Web Application Development

Allow the insurance agents to build a professional proposal booklet in a fraction of minutes that includes product information targeted to each specific client.

Automation of GL maintenance

Automated NAC's monthly process of maintaining general ledger in NetSuite using UiPath.

CMS Implementation

1Rivet created a website that helps NAC users to create, manage, and modify content on a website without the need for specialized technical knowledge.

Implement new app to track the location of employees that are working from (between the hours of 9-5 Mon-Fri) outside of the registered work state to be compliant with state payroll tax withholding requirements for employers. Limiting audit exposure

Integrated Risk Management Implementation

Migrate from legacy system to a net-new cloud-based Integrated Risk Management application.

OneStream Implementation & Support

Migrate from excel based manual Close and FP&A processes to an automated Future State Financial Corporate Performance Management solution to provide capabilities to analyze financial data, automate account reconciliations, consolidations and close processes workflow, and provide enriched FP&A reporting, drastically reducing manual intervention and time to completion.

Migration to D365 & Production Support

Migrated over $120B in syndicated financing deals from legacy systems to a net-new Azure-based application.

Cash Matching Automation using RPA & Machine Learning

Automated end-to-end process for matching cash using wire instruction received from their treasury system

Testing Automation

Implementation of test automation framework and automate key manual test scenarios/case for LoanIQ Functionality to reduce regression test cycle and increase test coverage.

Custom Amortization (Integration) Engine

Cloud-based custom Amortization Engine for Intercompany Asset Transfers (IAT) to combine the financial results for several subsidiary legal entities results into a single, consolidated organization.

Migration & customization to Microsoft Dynamics AX

Helped the client deliver a new general ledger system and migrate legacy data due to the divestiture of the parent company (GE Capital).

Divestiture Integration

Migrate off General Electric Capital's business applications upon GE's divestiture of its equity line of business.

Data Warehouse Implementation

Helped the client create a custom Data Warehouse to enable enterprise-wide reporting including the measurement of risk and performance (to existing and potential investors)

Custom Web Application Development (LoanIQ)

Helped the client design and develop a custom application to produce monthly banking statements from each of the client's Borrower using data from the client's newly implemented applications including LoanIQ.

Modernization of Legacy App

Helped the client re-platform their aging PowerBuilder applications to Java/Angular to reduce maintenance costs by removing the physical hardware and refresh the look and feel of the systems.

Data Migration QA Automation

Helped the client successfully test and migrate from its legacy Sybase Database platform used by a large number of applications over to SQL Server. Thus, reducing operational/migration risks, and zero downtime with smooth transitioning during the migration process.