Project Budget Management Solution

Challenge

Our client does not have a standardized tool to track and manage client engagement financials. As a result, each consulting team develops its own highly manual spreadsheets to track financials of their projects (in some cases multi-year multimillion-dollar engagements with overlapping contracts). This leads to increased risk for human error and untimely identification of over-budget and high-risk scenarios.

solution

Soleox developed and implemented a solution with a high degree of automation to assist end users with estimating, tracking, managing, and reporting financials of small, medium, and multi-year, multimillion-dollar projects.

impact

The client socialized the application with a high rate of success. Within the first week, it uncovered over-budget and high-risk scenarios, as well as errors in the company’s internal financial systems.The tool provided an accurate view of client engagements' financials which triggered executive decisions that increased margins by, at least, 10% on all engagements.

Lease Financing Tracking Solution

Challenge

Our client provides a high-volume (thousands) of medium-term (2-3 years) leases to end consumers. These leases are packaged in tranches and sold to investors (each tranche containing multiple leases). One of our client's requirements to their investors is to report all submitted lease payments on a weekly basis.

solution

Soleox developed and implemented a fully automated solution that provides investors with an accurate and clear view of the status of each lease in their tranches.

impact

The solution reduced the time spent by our client to track the status of all tranches by more than 99% (from 10+ hours every week to less than 1 minute). The tool has significantly increased the client’s ability to prove to their investors that they are receiving the agreed return on investment. This has, in turn, enabled the client to regain investors’ trust and increase the volume of sales.

Resource Allocation Solution

Challenge

Several multi-year projects have failed at the client due to unforeseen staffing constraints (over-utilization of key personnel), causing multi-million dollar losses. Internal Audit has asked our client to implement a solution that provides evidence that no resources are allocated more than 8 hours per day across all projects.

solution

Soleox developed and implemented a solution that imports multiple project plans and identifies resource over-utilization constraints across multi-year, highly-staffed, and simultaneous projects.

impact

Internal Audit has enforced the solution as a compliance requirement in the approval process for all project plans at the client. The client estimates that the use of the Resource Allocation Tool saves $600,000 in potential losses annually.

Metadata Validation Solution

Challenge

The client is migrating to a new user access management system and must ensure all metadata (consisting of millions of records) is clean before importing it into the new system. Importing unclean data into the new system would result in loss of or inadequate user access, which will lead to noncompliance and high remediation costs.

solution

Soleox developed and implemented a solution that imports, analyzes and identifies errors in large amounts of metadata. The tool also guides end users through the process of cleaning up the metadata prior to importing it into the new system.

impact

The solution was used to validate and clean up all metadata and the migration was completed without incidents. Moreover, this solution has become a go-to application at the client for cleaning up other types of sensitive metadata. The client estimated the cost savings at $180,000 and time savings of over 4,000 working hours in the process of validating and cleaning up metadata. ​

Enterprise Active Directory Cleanup Solution

Challenge

Internal Audit has required our client's Information Security department to perform the full cleanup of the 200,000+ Active Directory groups that define most of the company’s user access. The client has staffed 12 FTEs for over 10 months to perform and track this cleanup effort. The lack of an automated solution has resulted in thousands of data integrity issues and the impossibility to meet the required timeline imposed by Internal Audit.

solution

Soleox developed and implemented a full suite of tools that automatically analyze, extract and validate data from thousands of spreadsheets received from AD group owners.

impact

The solution provides Executives with progress reports on a monthly basis that are generated automatically. 11 of the 12 FTEs that used to be dedicated to this project have been assigned to new roles. Data quality is now consistently measured above the 99.99% threshold, and the client is able to audit and track the cleanup status of every AD group in the enterprise.

Automated SMS Notification System for Customers

Challenge

The client needs to cut costs related to its call center. The call center receives, on average, 120 daily calls from customers regarding the status of their repair orders. Five (5) FTEs are staffed full time to answer these calls.

solution

Soleox developed and implemented an SMS Notification System that sends automated SMS notifications in real-time to customers to keep them informed on the latest status of their repair orders.

impact

The client's call center receives now, on average, less than 15 daily calls from customers regarding the status of their repair orders. Only one FTE is currently dedicated to answering these calls. The client has realized savings in excess of $120,000 per year and exponential increase in customer satisfaction.

CSV-to-SQL Import Application

Challenge

The client staffs one FTE senior resource to open a raw report from a third-party provider, convert the data in the report manually based on a set of rules and import the converted data into an SQL database. Human error has negatively impacted the data integrity in the database which has cost the client hundreds of thousands of dollars in compliance penalties over the last 5 years.

solution

Soleox built an autonomous application that takes in the raw report from the third-party provider, manipulates the data based on a specific set of rules, and imports it into the database for use by other systems. The entire process is performed without human interaction.

impact

The senior resource was reassigned to a different role. Moreover, the integrity of the data is now guaranteed with no possibility for human error. On top of not incurring in subsequent compliance fines, the new automated business process for converting the raw data and importing it into the SQL database costs the client 92% less than the previous manual process.

Customer SMS-to-Chat Application

Challenge

The client is struggling to find an off-the-shelf tool that can allow them to effectively communicate with their customers via text messaging. Key requirement: Customer service agents need to interact with multiple clients simultaneously.

solution

Soleox developed and implemented a chat solution that allows customer service agents to communicate in real-time with multiple clients simultaneously through a user-friendly interface.

impact

Customer satisfaction significantly improved when the new solution was deployed and reduced the volume of calls to the call center.

Portfolio Management Solution

Challenge

The client does not have a process or tool in place to select, prioritize or measure the impact of projects of various sizes and complexities. Currently, all projects proposed by the business units make it into the company's portfolio.

solution

Soleox developed and implemented a solution that allows our client to prioritize and schedule all projects from all business units on an enterprise-wide 7-year portfolio plan based on the company's strategic values, target quarterly expenditures and talent needs.

impact

The solution has enabled Leadership to measure the impact of all projects on the organization's vision, strategic objectives and capital needs. Leadership has used the solution to create the 7-year enterprise project plan and update it as new projects are brought into from all business units' pipelines.

Purchasing & Invoicing Tracker

Challenge

The client has decided to increase its capital project spending from $100M to $1B annually. In order to do so, shareholders require that the client builds solid project management controls around purchasing and payment processes. They have staffed one FTE to manually input all purchase orders and invoices in a manual spreadsheet with no data quality controls.

solution

Soleox developed and implemented an automated and user-friendly purchasing and invoicing tracking solution. This solution provides our client with real-time visibility on the status of all purchase orders and invoices, as well as Key Performance Indicators (KPIs).

impact

Since the tool was implemented, the client identified and remediated bottlenecks within their processes and experienced a tenfold reduction in their processing cycle times. The client also repurposed part of the FTE to other tasks.

Contact us

Schedule a demo

These reports are not available right now.