Download PDF
Workflow Engine Gives Managers More Control Over Budgeting Tasks
Technology Category
- Functional Applications - Enterprise Resource Planning Systems (ERP)
- Analytics & Modeling - Predictive Analytics
- Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries
- Professional Service
- Software
Applicable Functions
- Business Operation
- Quality Assurance
Use Cases
- Predictive Replenishment
- Process Control & Optimization
- Remote Collaboration
Services
- System Integration
- Software Design & Engineering Services
The Challenge
The Finance team was manually creating, distributing, collecting, and consolidating budgeting spreadsheets from 60 users. Email overload led to issues with version control and made variance analysis exceedingly difficult. Received spreadsheets were arranged differently, and the Finance team had to manually manipulate each one to ensure they were all in the same format. The Finance team could not confirm the accuracy of received data without manually comparing spreadsheets to the data contained in the GL. It was difficult for Finance to determine the status of each task without exchanging phone calls and emails with users, which prolonged the budgeting cycle and increased the possibility that data would be lost.
About The Customer
One of the leading staffing firms in Canada was manually creating, distributing, collecting, and consolidating Excel budgeting templates for 60 users across multiple regions. This process was time-consuming, error-prone, and could not give management insight into user activity or the status of the project as a whole. The company needed a more efficient and accurate way to manage its budgeting process, which led them to seek a solution that could automate and streamline these tasks.
The Solution
Vena automatically consolidates all the company’s data in a single, secure repository, eliminating the need to manually link spreadsheets or run macros. Relevant spreadsheets are automatically pre-populated with data from the repository. A powerful workflow engine allows management to assign tasks and deadlines to particular users and monitor their status in near real-time. The workflow engine gives management control over input drivers and assumptions, so they can model their unique business needs. An audit trail records all user activity and enables management to instantly roll back and view previous versions to compare differences over time. Management can set business and data validation rules, preventing users from entering data that falls above or below a certain threshold.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Factor-y S.r.l. – Establishes a cost-effective, security-rich development environment with SoftLayer technology
Factor-y S.r.l., a web portal developer, was faced with the challenge of migrating its development infrastructure to a reliable cloud services provider with highly responsive technical support. The company needed a solution that would not only provide a secure and reliable environment but also support its expansion by providing resources to create and deliver innovative offerings.
Case Study
UBM plc: Taking the pulse of the business and engaging employees with a far-reaching strategic transformation
UBM, a leading global events business, was undergoing a significant strategic transformation named 'Events First'. As part of this transformation, the company was preparing to complete the largest acquisition in its history - Advanstar, a US-based events and marketing services business valued at more than USD970m. The company faced the risk of human capital flight if it was unable to effectively engage top talent with the new strategic direction. UBM needed to make significant structural, process and systems changes, uniting its previously autonomous regional businesses. The challenge was to ensure all of its employees were engaged and aligned with the new future vision.
Case Study
Darwin Ecosystem: Accelerating discovery and insight through cutting-edge big data and cognitive technologies
Darwin Ecosystem was founded with a unique vision of harnessing chaos theory mathematics to uncover previously hidden connections in unstructured data. The company’s algorithms can look at all the data generated by any source (such as news, RSS feeds and Twitter), and analyze how a specific set of concepts within that data are evolving over time. This is particularly valuable in situations such as business and competitive intelligence, social research, brand monitoring, legal discovery, risk mitigation and even law enforcement. A common problem in these areas is that a regular web search will only turn up the all-time most popular answers to a given question – but what the expert researcher is actually interested in is the moment-tomoment evolution of the data available on that topic. Darwin’s algorithm is computationally intensive, and the sources of data it correlates can be vast. To bring its benefits to a larger commercial audience, Darwin needed to find a way to make it scale.
Case Study
Wittmann EDV-Systeme launches IT monitoring services
Small and medium-sized businesses often lack the know-how and resources required for thorough IT system monitoring. Wittmann EDV-Systeme wanted to launch a solution to plug the gap – enabling it to improve its own competitiveness and that of its customers. IT landscapes are becoming ever more complex and outsourcing is gaining popularity, IT systems must nonetheless remain easy-to-use and extremely reliable at all times. Automated, round-the-clock system monitoring therefore represents an immensely valuable proposition for companies: downtime for business-critical applications can be avoided, and IT systems remain available at all times.
Case Study
Zend accelerates, simplifies PHP development
Zend Technologies, a major contributor to the PHP open source community, needed to keep pace with emerging trends such as mobility, agile development, application lifecycle management and continuous delivery. The company needed to provide the right tools to the worldwide community of PHP developers. The challenge was to support enterprise-class capabilities from end to end, including mobile, compliance and security. The pace of business required developers to show results fast across a variety of devices without compromising quality or security.
Case Study
Delivering modern data protection with cloud scale backup from Cobalt Iron and IBM
Organizations are struggling to modernize their legacy data protection environments in the face of growing demands around new infrastructure, new applications, and budget consolidation. Virtualization and modern application development processes have significantly outgrown legacy backup architectures. In response, infrastructure teams have created multiple backup solution types to handle the varying SLAs (performance, scale, cost) required by their business sponsors. However, the sheer number and variety of solutions in this uncontrolled expansion creates huge amounts of work, threatening to overwhelm the IT team in many organizations. Today, developers may add new applications and virtual server instances by the hundreds per day without accounting for the restrictions of the existing backup infrastructure. They leverage the cloud for immediate compute and storage resources, yet rarely communicate succinctly with corporate IT to ensure that the appropriate data protection services are in place.
