North American Banking Conglomerate Turns to TimeXtender for Help Automating Revenue Reporting Processes

The North American branch of this global banking conglomerate offers a variety of services to its customers. However, with the constant growth of its offerings, a data management platform was needed to better track revenue.

AUTOMATION AND CONSISTENT REPORTING

Our banking customer has grown into a conglomerate with a global network of financial and business centers servicing both individual and corporate customers.

The customer’s North American branch was hampered with inconsistencies in management reporting on product revenue, department finances, customer information, transaction cashflow, as well as challenges pertaining to data governance, data ownership, and a lack of automation in the company’s reporting process.

Several disparate sources hosted the company’s data. Specifically, our customer retrieved client data from Salesforce. Data was stored in 17 diverse and unstructured Microsoft Excel files that contained multiple pie charts and graphs from different owners in different departments. The numbers in the Excel files would frequently fluctuate, and it was hard to track how occasional data misalignment issues occurred. Each of the files contained different formatting, and no single person owned the process, which resulted in frequent inconsistencies. When a new product was created, our customer would simply create a new spreadsheet for it. The challenge was to take this structured and unstructured data estate from different Microsoft Excel files and Salesforce and aggregate it into one meaningful view.

CONSOLIDATING DATA FOR ONE VERSION OF THE TRUTH

The TimeXtender data management platform was carefully chosen as the solution to transform the bank’s analytical environment to help improve consistency in product revenue reporting. With Axis Group’s support, implementing TimeXtender allows the bank to connect and consolidate its structured and unstructured data, catalog, model, move, and report on the full lifecycle of data – in a single application that supports core analytics, compliance and a modern data warehouse. Since access to this data is vital for day-to-day banking operations, our customer hosts their solution on Microsoft SQL Server Enterprise Edition.

SIMPLIFYING DATA MANAGEMENT

With the implementation of TimeXtender for the bank’s data architecture needs, Axis Group was able to complete a data overhaul, quickly and securely. Formerly five people spent 40 hours per month on the management of the entire process, including collecting spreadsheets and processing them for report outputs – now, the entire process is automated. The bank can now reallocate those five people to other parts of the organization. Further, when a new manager joins the team, the bank can provide them with TimeXtender documentation that clearly shows where the source data is coming from. With the power of automation and AI technologies, our customer now has access to a more streamlined, simplified data management solution and is well-positioned for future migration to the cloud.

More Cases

Colliers International Builds a Data Warehouse Without Programming

Colliers International Builds a Data Warehouse Without Programming

Colliers International Builds a Data Warehouse Without Programming Colliers International is a publicly traded international real estate consultancy that wants to offer forward-looking advice and maximize the value of real estate for real estate owners, real estate...

Cordstrap Safeguards its Data for the Future with TimeXtender

Cordstrap Safeguards its Data for the Future with TimeXtender

Cordstrap Safeguards its Data for the Future with TimeXtender Cordstrap is the global leader in products and systems to protect cargo carried by rail, ship, truck, and air. The company operates three international production centers, has over 500 employees in 22...

The Data Heart of TimeXtender is the Beating Heart of FM Group

The Data Heart of TimeXtender is the Beating Heart of FM Group

The Data Heart of TimeXtender is the Beating Heart of FM Group The FM Group was established in 1968 and is a company in flowers, plants, and accessories. Every day, 1700 employees in 17 countries on six continents work to deliver a wide range of fresh products to over...

TimeXtender Enables Pally Biscuits to Produce Smarter

TimeXtender Enables Pally Biscuits to Produce Smarter

TimeXtender Enables Pally Biscuits to Produce Smarter Pally Biscuits makes over three billion delicious biscuits every year. The company has been around since 1868. From its factory in the Dutch town of Nieuwegein, the biscuits find their way to more than 40...

 

Ready for a demonstration?

X