minicode

Challenges:

• Outdated custom-built system for managing customers and jobs
• 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
• Export of invoices and bills to an accounting system (Xero)
• Individual user logins with configurable permission levels
• Integration with lens-manufacturing lab equipment

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
• Increased efficiency and accountability of staff members
• Significantly better system performance and data integrity

Technologies:

Linux, Apache, PHP, MySQL, Google Maps, Power BI, Xero

Challenges:
• Obsolete 3-rd party desktop software for job management and costing
• No multi-user access, no individual logins, no logging of user actions
• No online access to the software, no reporting, no integrations
• Local data and file storage, high risk of data loss or corruption
• No room for customisation to suit the ever-growing business needs

Solutions:
• New secure web application, hosted internally on a virtual server
• Complete solution for the job lifecycle and customer invoicing
• Integrated inventory management (with BOM) and purchasing
• Timesheets and contract labour tracking and costing
• Integrated change tracking for all database entities
• Individual user logins with configurable permission levels
• Export of invoices and bills to an accounting system (MYOB)

Benefits:
• Increased efficiency and accountability of staff members
• Significantly better system performance and data integrity
• Fewer human errors with costing, purchasing and invoicing
• Major security improvements (application access, backups)
• Baseline for future improvements, new features and reports

Technologies:
Linux Apache PHP/MVC (Laravel) MySQL MYOB Export

Challenges:
• Outdated custom-built software for contract management (MS Access)
• Data integrity issues due to poor DB design and lack of data validation
• No multi-user access, no individual logins, no logging of user actions
• Local data and file storage, high risk of data loss or corruption

Solutions:
• Streamlined and improved data model
• A data migration tool (MS Access to Azure SQL)
• New secure web application hosted at Microsoft Azure
• Integrated change tracking for the most critical entities
• User accounts with Microsoft Single Sign-On (SSO) integrated
• A light-weight mobile version of the web app for using in the field
• Outlook Add-in for easier management of contract-related correspondence
• Comprehensive search options for easier access to the required information

Benefits:
• Significantly better system performance and data integrity
• Increased efficiency and accountability of the application users
• Major security improvements (app access, data storage, backups)
• Baseline for future improvements, new features and reports

Technologies:
Microsoft Azure Azure SQL Server Azure App Service Application Insights ASP.NET Core MVC Entity Framework Outlook Add-in Microsoft SSO

Challenges:
• Slow and unstable job management system built on outdated components
• No online access to the portal for customers and field technicians
• Poor architecture resulting in slow and costly maintenance
• No reporting or business intelligence insights available

Solutions:
• In-place gradual upgrade and replacement of the existing modules
• Integration with an accounting system (Xero) and geolocation API
• Automated business processes and maintenance routines
• Integrated change tracking based on a no-SQL solution
• Comprehensive map-based service scheduling tool
• New secure self-service portal for customers
• New portal-integrated mobile app for field techs
• Real-time integration with property management systems
• Full-day route optimisation for inspections and key collections
• ML-powered two-way SMS messaging for automated scheduling

Benefits:
• Increased efficiency and accountability of staff members
• Major security improvements (access, storage, backups)
• Significantly better system performance and stability
• Improved customer satisfaction and higher sales
• All critical business processes automated

Technologies:
AWS (EC2, RDS, S3) PHP/MVC (CodeIgniter) DocumentDB (MongoDB) PostgreSQL (RDS) Google Maps API Xero API PropertyMe API PropertyTree API Console Cloud API Power BI SMS Central Elastic Email RouteXL Optimisation MailChimp API Mobile App (PWA) Machine Learning