Data Warehouse Implementation

Data extractions from Front and Backoffice Applications
Creation of 300+ custom reports
Reporting supports 100+ number of users

Outcome

Data sourced from Fail Over region (real time backups of Production) in Azure Platform allowing for near real time data extraction without impacting production
SSIS used for data extraction with Power BI and Spotfire tools customized per Business Unit for data presentation
SharePoint integration for auto generated reports

Overview

Industries

Financial Services

Capabilities

Data Architecture & Engineering

Technology Platform

Data Visualization & Analytics

Quality Engineering

Scope of service

Program Management

Architecture & Design

Requirement Gathering

Development

Manual 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.

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.