Our Past Works
Discover how we solved various business challenges through the use of tailored software and data analytics.
- All Projects
- Software Development
- Business Intelligence
Web Portal for a National Compliance Company
PHP, Mongo DB, Firebird, Google Maps API, Xero API
Back-office and Customer Portal
Problems:
- Slow, poorly designed, and unstable job management system
- No self-service portal for the customers and technicians
- Too much effort to maintain and extend the system
- No reporting and business intelligence available
Solutions:
- In-place gradual upgrade and replacement of the existing system
- Integration with online accounting system and geolocation API
- Automated business processes and maintenance routines
- Integrated change tracking based on no-SQL solution
- New secure self-service portal for the customers
Benefits:
- Increased efficiency and accountability of staff members
- Significantly higher system performance and stability
- Improved customer satisfaction and higher sales
- All critical business processes automated
BI Dashboard for an Online Retailer
Power BI, DAX, MySQL, Magento
Business Intelligence Dashboard
Problems:
- Large amount of data accummulated from online sales
- No business intelligence available to the management
Solutions:
- Comprehensive dashboard based on data from the online store
- Data extracted from Magento and processed with DAX
Benefits:
- Improved business efficiency via analysis of product performance
- Identified potential markets based on sales dynamics
Custom ERP Solution for a Furniture Vendor
ASP.NET, C#, SQL Server
Custom ERP Solution
Problems:
- Obsolete system to manage clients, suppliers, products and sales
- Issues with the increasing amount of users and transactions
- Manual calculation of the manufacturing costs
Solutions:
- New comprehensive data structures for operational and financial data
- Robust ASP.NET web application with SQL Server database back-end
- Custom permission system, easily managed by non-technical users
Benefits:
- Fully automated workflows, no more manual processes
- Instant access to all operational data and reports
- Reliable and efficient product cost calculation
Dealer Portal for a Wallpaper Manufacturer
PHP, MySQL, Xero API, eWAY API
Online Dealer Portal
Problems:
- Many manual processes and double-entry operations
- No IT system to manage dealers, available products and pricing
- No self-service portal for dealers, with integrated online payments
Solutions:
- Web app for dealers to customise and order products online
- Integration with accounting system and payment gateway
Benefits:
- Central place to manage products, pricing and discounts
- Increased sales and improved business efficiency
- No more manual wholesale order processing
- No more double-entry of sales order data
BI Warehouse for a Transport Company
Power BI, DAX, SQL Server, ASP.NET
Data Warehouse and BI Reports
Problems:
- Multiple disconnected data sources with no BI capabilities
- No business intelligence available to the management
Solutions:
- Data warehouse aggregating the data from the multiple systems
- Data cleansed and pre-processed using T-SQL and DAX queries
- Interactive reports and dashboards published to Power BI
Benefits:
- Improved business efficiency via analysis of the aggregate data
- BI reports and dashboards immediately available online
Quoting Tool for a Mining Equipment Supplier
SharePoint Solution
Intranet Quoting Tool
Problems:
- Manual quoting process with no history records
- Large amount of unstructured product and client data
Solutions:
- A SharePoint solution to store the information in a structured format
- New workflow with customisable rules, versioning and history
- Minor customisations to SharePoint’s standard features
- Employee groups with appropriate permissions
Benefits:
- Quoting workflow intuitive to non-technical users
- Predictable quoting process, reliant on historical data
- Central, secure location for all client information and product data
BI Reports for a Managed Services Firm
Power BI, Power Query, Excel, SQL Server
Business Intelligence and Reporting
Problems:
- Job management software with limited reporting capabilities
- No business intelligence available to the management
Solutions:
- Comprehensive reports based on data from the job management system
- Interactive charts and dashboards published to web and Power BI
- Data pre-processed in MS SQL Server and DAX / Power Query
Benefits:
- Improved business efficiency via analysis of the report data
- Business intelligence data immediately available online
Discount Management for an Online Retailer
PHP, MySQL, eBay API
Discount Management System
Problems:
- Manual business process to manage discounts at eBay store
- No central place to view and manage online sales prices
Solutions:
- Custom web app to host and manage information about product sales
- Integration with eBay API to sync products and publish sales to eBay
- Background workflows to apply tiered discounts automatically
Benefits:
- Increased sales via providing consistent discount policy
- Eliminated human errors by automating all manual processes
Booking System for a National Lawyer Agency
SharePoint, SQL Server, NAB Bank API, AdWords API
Back-office Booking System
Problems:
- Too many manual processes that need to be automated (like credit card payment processing and follow-up reminders)
- Obsolete system not suitable for multi-user opeation and increasing number of enquires/transactions
- No business intelligence tools or reports available
Solutions:
- Custom SharePoint solution with forms, views and data structures optimised for new business workflows
- Background processes running on a schedule to inform customers and employees of their case/task updates
- Integration with external systems: public website, practice management software, NAB bank API, and Adwords API
Benefits:
- Legacy data migrated and used for historical analysis
- Fully automated routine business processes and workflows
- Increased employee performance and overall business efficiency
- Aggregated data, BI and reporting available at one central location
HR Survey Platform for a Health Services Centre
SharePoint Enterprise
Custom Survey Platform
Problems:
- Paper-based annual performance reviews
- No integrated IT system to support HR's activities
Solutions:
- Comprehensive data structures and forms to collect the survey data
- Custom workflows for outstanding task alerts and status changes
- Complete solution integrated with the existing SharePoint portal
Benefits:
- Structured survey data available for analysis
- Follow-ups and comparison with previous periods
- Improved efficiency of employee performance reviews
Back-office System for an Optical Lab
PHP, MySQL, Innovations, Xero API
Complete Back-office System
Problems:
- Obsolete system for managing customers and job orders
- Repetitive manual processes and double-entry scenarios
- No tools available for business analysis and reporting
Solutions:
- Web-based app providing a complete lab management solution
- Comprehensive reports covering different aspects of the business
- Integration with an accounting system and lens-cutting machinery
Benefits:
- Complete back-office platform with integrated business intelligence
- New automated workflows eliminating the old manual processes
- Less human error from manual and double-entry operations
Job Management for a CNC Workshop
C#, WPF, WCF, ASP.NET, SQL Server
Job Management System
Problems:
- Manual job allocation, resulting in double-booked or missed jobs
- Paper-based job management with no history of completed jobs
- Software licensing and distribution via physical USB dongles
Solutions:
- WPF app for managing / tracking jobs on a connected CNC machine
- ASP.NET app and WCF service to manage and distribute CNC licenses
Benefits:
- One central place for managing and allocaitng jobs
- Complete job history available for review and analysis
- No more time and money wasted on CNC software licensing
