Data Warehouse Implementation

Lower risk to bank by decreasing manual end user computing applications
Develop standard and common use of data elements across bank
For each element - Identified system of record and agreed upon calculations for derived values
Increased reporting and data mining capabilities

Outcome

Designed/Implemented 9 of 30 core structures
Developed production reports using SSRS
Implemented ad-hoc reporting with QlikView
Build flexible ETL architecture using SSIS
Flash requirements and review of 500+ spreadsheets

Overview

Industries

Financial Services

Capabilities

Data Architecture & Engineering

Quality Engineering

Scope of service

Project Management

Architecture & Design

Requirement Gathering

Development

Testing

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.

Data Analytics

Implemented a custom tool to help their client manage Cash across their Operations, Treasury, and Finance business units.

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.

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.