Talk to our team
Back to Case Studies

Olivine – Air Travel Solution

Financial Services & Custom Automation Solutions INTRODUCTION Olivine Industries is Zimbabwe's leading manufacturer of Fast-Moving Consumer Goods (FMCG), producing trusted household brands across edible fats, margarine, baked beans, and soaps. Looking to modernize its internal corporate travel operations and operational workflows, the brand partnered with Wisethink Information Solutions—an ISO 9001:2015 certified ICT consulting firm.The company […]

Financial Services & Custom Automation Solutions

INTRODUCTION

Olivine Industries is Zimbabwe's leading manufacturer of Fast-Moving Consumer Goods (FMCG), producing trusted household brands across edible fats, margarine, baked beans, and soaps. Looking to modernize its internal corporate travel operations and operational workflows, the brand partnered with Wisethink Information Solutions—an ISO 9001:2015 certified ICT consulting firm.

The company is shifting away from fragmented manual processes by leveraging Zoho Creator, a powerful low-code, cloud-based application development platform. The brand aims to build a centralized, secure infrastructure to seamlessly monitor travel requests, host blind bidding for vendors, and track automated accounting approvals across lender codes and cost centers.

PROBLEM STATEMENT

Before exploring automated cloud solutions, Olivine Industries faced critical daily corporate travel and workflow challenges:

  • Manual Data Dependency: Relying heavily on manual Excel sheets to maintain the corporate employee database, manually input itineraries, and record quote details, which risked severe operational errors and slower bookings.
  • Fragmented Visibility: Difficulty in obtaining an instant, unified view of total funds requested for corporate travel versus the actual lowest market prices distributed by competing agents.
  • Security & Authorized Tracking: High risks surrounding sensitive travel profiles, data visibility, and vendor quotes leaking without specialized role-based access control or dedicated vendor segmentation.
  • Calculation & Policy Complexities: High manual effort required to systematically flag immediate travel compliance (under 7 days), check quote differences against minimum bidding baselines, and cross-reference multi-tier GL codes across different departments.

OBJECTIVES

The implementation of the custom Zoho Creator system is guided by these key business objectives:

  • Transitioning operations into a unified Mobile App + Web App ecosystem for all corporate employee travel requests.
  • Eliminating manual spreadsheet calculations via automated interest, quote routing, compliance checks, and exception alerts.
  • Empowering management to make corporate travel budget decisions instantly using real-time comparison data insights.
  • Ensuring absolute security where only authorized internal users and isolated vendors view sensitive financial and booking files.

FEATURES OF THE IMPLEMENTED SYSTEM

Product & Services Portfolio (Core Architecture)

A customized array of tracking modules designed on Zoho Creator, including:

  • Business Dashboard: Comprehensive summary of active travel queues, emergency requests, and pending actions.
  • Employee Master: Centralized repository sync linking employee profiles with active departmental managers.
  • Vendor Portal: Secure gateway allowing outbound travel agencies to submit data into the database in real time.
  • Travel Request Logs: Detailed timeline archive storing historical destination logs, itineraries, and booking IDs.
  • Repayment Tracker: Automated cross-reference map mapping tracking details to underlying cost accounts.

Tailored Solutions by Application Phase

Tailored application architecture categorized by deployment phase:

  • Phase 1 – Documentation: Requirement gathering for employee workflows, policy definitions (7-day rule), and project planning.
  • Phase 2 – Development: Cloud configuration of dashboards, role profiles, matrix views, and background workflow logic.
  • Phase 3 & 4 (UAT & Go-Live): Complete QA system testing, vendor onboarding validation, legacy Excel database upload, and structural deployment.

Deployment Standards

  • Feasibility Engineering: Adherence to standard Zoho cloud capabilities, with custom middleware and Deluge scripting logic built around blind competitor queries and multi-party workflows.

Quality Assurance

  • Data Upload Setup: Structured data parsing to securely migrate existing records from spreadsheet legacy masters straight into live Zoho lookup tables.

PRIVACY & DATA PROTECTION

  • Role-Based Access Control: Five-tier application security rules dividing data clearance smoothly between Requesters, HODs, Travel Agents, Travel Desk teams, and the CFO.
  • Admin Controls: Granular database restriction models isolating vendor queries so external agents only view their custom Agent_ID responses.
  • Encryption: Secure cloud encryption protocols safeguarding traveling personnel profiles, cost metrics, and corporate financial data.
  • Data Security: Complete restriction of system access preventing unauthorized competitive espionage among participating bidding agents.
  • Automated Backups: Regular scheduled updates to verify continuity of accounting ledgers, ticket archives, and routing rules.

BENEFITS

For Customers (Employees & Vendors)

  • Transparent tracking of active ticket requests with visible real-time balance or status confirmation updates.
  • Higher data privacy over sensitive identity details and payment records.
  • Systematic registration of varying travel timelines with red flags prioritizing emergency or short-notice requests.

For the Business

  • Instant data access for strategic cost choices using a real-time smart vendor comparison dashboard.
  • Clear clarity on exact outstanding expenses owed to corporate travel agencies.
  • Reduced risk of capital leakages via a systematically monitored expense process that catches and escalates higher-priced bids directly to the CFO.

For the Operations Environment

  • Elimination of human error by moving calculations, notifications, and workflow handoffs away from static spreadsheets.
  • Consolidated platform available via desktop browser and active mobile applications.
  • Comprehensive post-deployment user training providing step-by-step guidance across all internal and external roles.

CHALLENGES

  • Dependency on Input Realities: Project timeline estimates depend heavily on the prompt availability of employee corporate directories and third-party configuration lists.
  • Native Structural Guardrails: Adapting complex business calculations within standard native Zoho cloud boundaries requires expert technical logic overrides—specifically to isolate competitor rows inside common bidding modules.
  • Scope and Policy Updates: Addressing operational updates or change requests past the finalized blueprint phase requires structured Change Request (CR) processing for proper corporate governance.

FUTURE SCOPE

  • Subscription Scalability: Moving effortlessly into advanced tiers of Zoho Creator plans as transaction volumes and internal personnel counts expand over time.
  • Extended Customization: Implementing continuous operational modules such as automated hotel stays and vehicle rentals via sequential development frameworks.
  • Third-Party Platform Integrations: Potential direct linking of system databases with external banking software, ERP ledgers, and live airline booking APIs via custom middleware.

CONCLUSION

By deploying Zoho Creator, Olivine Industries is effectively transitioning into an automated, highly secure cloud management infrastructure. Eliminating manual Excel workflows and adding a real-time comparison matrix dashboard empowers corporate supervisors with excellent control, budget transparency, and structural data privacy. This automated transformation optimizes inner workflow productivity across operational departments while establishing an enterprise architecture ready for rapid market scaling.

PREVIOUSNEXT