Download PDF
Workflow Engine Streamlines Variance Reporting and Analysis
Technology Category
- Application Infrastructure & Middleware - Data Exchange & Integration
- Application Infrastructure & Middleware - Data Visualization
- Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries
- Pharmaceuticals
- Finance & Insurance
Applicable Functions
- Business Operation
- Quality Assurance
Use Cases
- Process Control & Optimization
Services
- System Integration
- Software Design & Engineering Services
The Challenge
The Finance team was manually aggregating budgeting and forecasting data from a variety of sources through a series of daily emails. This manual aggregation led to issues with version control and email overload. Additionally, the Finance team had to manually extract historical figures from their GL and paste them into reports to perform analyses. The client could not provide explanations for budget discrepancies within their Excel templates and needed to document details about the discrepancies in separate reports.
About The Customer
A leading pharmaceutical company was manually aggregating budgeting data and forecasting at a very granular level – by month, deal, product, and customer. The company's Finance team faced significant challenges due to the lack of a structured data aggregation process, making it difficult to compare budgets to actuals and determine the reasons for data discrepancies. The manual processes involved in data aggregation and analysis were time-consuming and prone to errors, leading to inefficiencies and delays in financial reporting and decision-making. The company sought a solution to streamline its budgeting and forecasting processes, improve data accuracy, and enhance the ability to perform in-depth analyses.
The Solution
Vena seamlessly integrates with the client’s GL and stores all data in a central, secure repository. This central data repository automatically pre-populates relevant spreadsheets with up-to-date data, eliminating the need for manual data aggregation. The commentary input feature allows users to embed written explanations of figures directly into Excel spreadsheets, facilitating more accurate and timely analyses. The powerful drill-through feature enables the Finance team to uncover the transactions and source details behind reported numbers with the click of a button. The workflow engine allows management to assign tasks and deadlines to particular users and monitor their status in near real-time. Email notifications are automatically sent to both managers and users when a deadline has passed and when a task has been completed and a template is ready for review and approval. The audit trail feature date-, time- and user-stamps each change made to a spreadsheet and records information about user activity in an easy-to-read log.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Case Study: Pfizer
Pfizer’s high-performance computing software and systems for worldwide research and development support large-scale data analysis, research projects, clinical analytics, and modeling. Pfizer’s computing services are used across the spectrum of research and development efforts, from the deep biological understanding of disease to the design of safe, efficacious therapeutic agents.
Case Study
Fusion Middleware Integration on Cloud for Pharma Major
Customer wanted a real-time, seamless, cloud based integration between the existing on premise and cloud based application using SOA technology on Oracle Fusion Middleware Platform, a Contingent Worker Solution to collect, track, manage and report information for on-boarding, maintenance and off-boarding of contingent workers using a streamlined and Integrated business process, and streamlining of integration to the back-end systems and multiple SaaS applications.
Case Study
Process Control System Support
In many automated production facilities, changes are made to SIMATIC PCS 7 projects on a daily basis, with individual processes often optimised by multiple workers due to shift changes. Documentation is key here, as this keeps workers informed about why a change was made. Furthermore, SIMATIC PCS 7 installations are generally used in locations where documentation is required for audits and certification. The ability to track changes between two software projects is not only an invaluable aid during shift changes, but also when searching for errors or optimising a PCS 7 installation. Every change made to the system is labour-intensive and time-consuming. Moreover, there is also the risk that errors may occur. If a change is saved in the project, then the old version is lost unless a backup copy was created in advance. If no backup was created, it will no longer be possible to return to the previous state if and when programming errors occur. Each backup denotes a version used by the SIMATIC PCS 7 system to operate an installation. To correctly interpret a version, information is required on WHO changed WHAT, WHERE, WHEN and WHY: - Who created the version/who is responsible for the version? - Who released the version? - What was changed in the version i.e. in which block or module of the SIMATIC PCS 7 installation were the changes made? - When was the version created? Is this the latest version or is there a more recent version? - Why were the changes made to the version? If they are part of a regular maintenance cycle, then is the aim to fix an error or to improve production processes? - Is this particular version also the version currently being used in production? The fact that SIMATIC PCS 7 projects use extremely large quantities of data complicates the situation even further, and it can take a long time to load and save information as a result. Without a sustainable strategy for operating a SIMATIC PCS 7 installation, searching for the right software version can become extremely time-consuming and the installation may run inefficiently as a result.
Case Study
Real-time In-vehicle Monitoring
The telematic solution provides this vital premium-adjusting information. The solution also helps detect and deter vehicle or trailer theft – as soon as a theft occurs, monitoring personnel can alert the appropriate authorities, providing an exact location.“With more and more insurance companies and major fleet operators interested in monitoring driver behaviour on the grounds of road safety, efficient logistics and costs, the market for this type of device and associated e-business services is growing rapidly within Italy and the rest of Europe,” says Franco.“The insurance companies are especially interested in the pay-per-use and pay-as-you-drive applications while other organisations employ the technology for road user charging.”“One million vehicles in Italy currently carry such devices and forecasts indicate that the European market will increase tenfold by 2014.However, for our technology to work effectively, we needed a highly reliable wireless data network to carry the information between the vehicles and monitoring stations.”
Case Study
Drug Maker Takes the Right Prescription
China Pharm decided to build a cloud-based platform to support the requirements of IT planning for the next five to ten years which includes a dynamic and scalable mail resource pool platform. The platform needed to have the following functions: all nodes support redundancy, ensuring service continuity and good user experience, simple and easy-to-use user interfaces for end users and administrators and good compatibility and supports smooth capacity expansion.
