Selected products built by Christopher Yiangou 1982 - 2018.
 
Expedite - Job Scheduling & Performance Measurement
Allows scheduling of jobs to 15+ CNC machines job-shop environment. Closed-loop reads machine production data through open-source MTConnect automation technology. Implementation allows the correlation between scheduled jobs and actual production activity, thus enabling excellent performance measurement and post-production analysis. Visual Basic.Net, SQL Server, MTConnect, Fanuc		 2017-2018

FabDraw - Drawing Repository
A repository for technical drawings, providing secure access, version control, watermarking, and other features designed to streamline and control the use and deployment of drawings for manufacturing, while protecting the intellectual property of the client. Visual Basic.Net, SQL Server, iTextSharp (PDF dll library)		 2017
FabSys - Business Backup
Custom backup software to automate the specific backup requirements and system architecture of the client. Initiates or performs folder share and system state backups, and managing backup versions. Visual Basic.Net, SQL Server		 2017
FabTrac - Task and Workflow Processing
Workflow engine that allows common business processes to be implemented as plug-in templates to be routed for completion and sign-off. New processes can be added as required, without program changes. Visual Basic.Net, SQL Server		 2016
Transport Network Cost Optimisation
During the development of a rates reporting and management system, I identified severe inefficiencies in the  allocation of transport between source and destination sites, in the order of 10s of millions of rands annually. I built models to evaluate these costs and show sensitivity to various optimisation scenarios. Since my profession is based in the principle "the identification of the problem is half the solution", I can claim to have saved the client at least half of these costs. Microsoft Excel, VBA, SQL Server, MSAccess		 2015
Dynamic Competition Scheme
The DCS Model was developed for the Bank of Namibia to enable it to survey banking products, collect data, and analyse and compare the pricing of banking services in the retail banking market in Namibia. Built sophisticated model to simulate and evaluate the performance of various banking products to the consumer, under organically changing conditions. Microsoft Excel, VBA, MSAccess.		 2015
MPS Purchasing System
Enterprise procurement system. Ensures users capture all requests for items required for purchase. All requests follow a workflow through various levels of approval and management. Each approver has assigned levels of authority and a maximum monthly budget. Incorporated in this system is a comprehensive inventory catalog and management controls. The system triggers reorder points for stock replenishment. Visual Basic.Net, SQL Server 2005
2009

ISP System
A stock management system that allows stock levels and counts to be recorded, assessed and gains and losses accounted for. For simplicity of deployment, the system was written in Visual Basic for Applications, with an Excel capture template. Excel, Visual Basic.for Applications, SQL Server 2000



Customer Key Model
In order to determine the impact of individual customers on depot operation and delivery cost, an activity-based costing (ABC) model was commissioned. Only direct activities, ie those clearly attributable to the delivery of fuel to the customer, were used to build the keys.

In this study, an ABC approach was taken to identify appropriate drivers, and from this the determination of the weighting keys. Once determined, these keys are used within the client's ERP system to equitably allocate depot and transport costs. Excel, Visual Basic.for Applications, SQL Server 2000



E-Schedule
A web-based application that enables the various role players that facilitate the dispatch of daily bulk fuel deliveries, to update and manage the execution of the delivery schedule. This is achieved by a combination of imported data from GSAP, links to vehicle positional data generated by GPS devices, as well as manual inputs.

Many of the features of this application are identical to, or inspired by the application 'Triplogic Scheduler' as described below, except that it is web-based. It uses a highly-graphical user interface to provide a real-world, real-time view of vehicle progress and delivery execution as it occurs. Visual Basic.Net, SQL Server 2005


Transport KPI
This system records and reports fuel delivery statistics to customers in the distribution network.

This company subcontracts its fuel distribution operation to external transport contractors. It nevertheless closely monitors these contractors for contract assessment and review purposes. It therefore has a unique set of requirements in that the user base are not on the client's network. The users are in fact members of other companies and their software platforms differ significantly from each other. 

The software, therefore, had to avoid these differences and provide a universal solution regardless of the software platform used. Only a few common features could be relied on: A Windows OS, the use of Microsoft Office, and an email program of either MSOutlook or Lotus Notes. 

The end result was a client capture program based on Excel with local data stored in a MSAccess database. Captured data is sent daily to the client's server via customized package transfer using email attachments. On the server side, the data is imported automatically by an unattended Windows  service, into a SQL Server database. Once imported, users on the internal network are able to run reports and analysis. Excel, Visual Basic.for Applications, SQL Server 2000


Triplogic - Scheduler
Logistical tool for the bulk fuel distribution industry. Management of geocoding of all depots and outlets using geographical information system (GIS) technology. Replay and analysis of satellite tracking data feeding live from vehicles. Generation of delivery schedules from order book. Routing and scheduling engine considers constraints of destination outlets such as delivery time windows, vehicle configuration acceptance limitations, etc. Highly graphical/visual interface using vector based maps. Contains a strategic scenario modeller. Based on operations research optimization techniques, this evaluates and tests the various strategic decisions that are often necessary in a dynamic marketplace. The model reports its findings in terms of monetary impact, and also expresses these graphically as geographic ‘win’ zones. See animated demo by clicking the above link. Visual Basic.6, SQL Server 2000




Triplogic - Depot Operations Management
Application for the day to day management of a bulk fuel transport industry. Event driven task planner management of depot activities such as vehicle services, staff medicals, meetings, discipliniary hearings, etc. Capture of daily delivery times, volumes, and order fulfillment, and analysis and reporting of these. Strong HSEQ component including the capture and analysis of incidents. Visual Basic.6, SQL Server 2000


Contractor KPI
A system design for the central collection of ongoing operational data from independent transport contractors providing services to the client. These are used for the generation and analysis of key performance indicators for the management of its contractors. Since capture is done on different networks, system uses email to issue blank templates and receive completed forms. Received data is imported to database format for analysis and reporting. Visual Basic.6, SQL Server 2000


Chatbox
Chatbox is intended to be a fun virtual 'toy' for use on the internet. Allows users to communicate with each other via email, sms, online chat, video conferencing. Allows for contacts maintenance, personal audio and video libraries, and photo albums. Has games, public notice boards and media players. This was a collaborative effort, follow the link above for more details. Visual Interdev, HTML, XML, DHTML, VbScript


Export Management System
Design and development of system to assist in the order capture, quotation, shipping and invoicing process of the business. Program has inbuilt forex calculator and generates documents in English and French.		  


Debtor's Reconciliation Project
Creation of toolset to assist in large scale reconciliation process. Involved downloading data from AS400 based accounting system into Access database, processing this using a series of auditing queries, and then output formatted, formula driven spreadsheets for further manual analysis and / or verification. Excel, Visual Basic, SQL Server 2000

  


 
Learner Management System
A system built to facilitate the management of students and faculty for a business school. The school provides courses in management training including MBA degrees. The system incorporates features of workflow, scheduling, costing, contact management, as well as ad-hoc queries and document generation. Visual Basic.6, SQL Server 2000		  


RAb2000 (Risk Assessment System)
A system designed to measure, evaluate and record the degree of exposure of workers to stress factors in the work environment. Visual Basic, SQL Server 2000

  


LPData (Logistics Model Data Maintenance)
An Oracle data repository and user interface to provide the input source data for a Linear Programming (Operations Research) model designed to optimise the cost of distribution of product from many supply points to many destination points. Visual Basic.6, Oracle

 


Budcom (Budgeting System)
Corporate-wide budget planning System (Budcom). Custom data replication engine capable of handling 500-1000 users (each business unit compiles budgets at their remote location). Local data cached in MS Access is then replicated to and mastered on a central Oracle database. Business rules encapsulated in plug-in user designed spreadsheet templates. Generically built budgeting shell, most new business rule additions require no code changes. Allows online or offline modes of operation, facilitating mobile usage. Visual Basic, SQL Server 2000		  


Netman (Retail Network Management)
Network management system (Netman), a system which allows field reps to collect market intelligence data pertaining to own and competitor service stations in each sales area. Local data stored on Personal Oracle databases, replicated to central Oracle database. Visual Basic, Oracle

  


Contact Management System
A contact management system designed for use by a vendor of mining equipment. Highly intuitive interface to facilitate making connections between potential clients making enquiries, and the specific equipment available. Invoice, quotation and other automated document generation, amongst many useful features. Visual Basic, SQL Server 2000

 


RAS (Risk Audit System)
Corporate risk auditing system (RAS) which provides a repository of safety and health related questions, which can be user selected from a hierarchical list of subject areas. These can be collated to form questionnaires which can be issued to remote sites for completion. Results are processed and summarised then published as reports and graphs. Visual Basic, SQL Server 2000

  


PCIntcon (Interdepot Control System)
Inventory management system / load planning. This is a Client / Server application which assists the planning staff to perform their depot stock replenishment functions by prescribing how trucks should be loaded for delivery. Visual Basic, SQL Server

 


Financial Management Toolkit
Financial management toolkit allowing the evaluation of interacting variables and their impact on an organisation. Business modelling tool. Visual Basic, SQL Server 2000

 


Inquiries (Client Enquiry System)
Development of generic executive information system (EIS) engine, for query of client databases. Several smaller programs to automate the daily dealing and administrative activities of the organisation. Soft-driven - views of data are defined by user, and do not require design changes. Visual Basic, Sybase		  


S15 Raw Material Preparation Automation
The purpose of this application was to automate the raw material preparation plant that produced building materials such as ceiling boards and roofing sheets. It was built on an event-driven multitasking operating system platform, and it controlled the measurement, dosing and mixing functions of the plant though devices such as mass transmitters, limit switches, motors and solenoid valves. The entire software design, development and implementation was done by myself. This software ran the plant for a period of about 5 years.RMX/86, PLM/86		  




Home Computing / Hobby Stuff