PROJECT SYNOPSIS
Enterprise Applications
From Legacy to Service Oriented Architecture (SOA) System Upgrade - Mitrais has successfully upgraded the ERP used by Cement Industries of Malaysia Berhad (CIMA). The new system went live at 3 different sites. Although there were a number of challenges associated with the three month project, Mitrais succeeded in bringing the project in on time and on budget. According to Hasni Halim, CIMA Project Manager, the upgrade moved CIMA from a legacy system to a SOA. Now users are able to utilise the updated integrated features of various modules such as Asset & Work Management, Supply Chain Management, Financial Management and Human Resources Management. The project was undertaken by a joint team of 15 staff from CIMA and Mitrais.
back to top
Advanced Funds Sufficiency Checking - Mitrais has successfully developed an Advanced Funds Sufficiency Checking Module for inclusion into Mincom International Limited latest version of the Ellipse ERP system. The Funds Sufficiency Checking module is designed to increase the functionality of the Ellipse product in terms of cost control and is required by Mexican and Colombian government entities. The development includes two new modules of the Entity Budget and Funds Authorization that are required in the funds checking process. This was a major piece of software development done collaboratively with Mincom's office in Brisbane, Australia (project management and architecture) and Latin America (project sponsor and system analyst). The total effort by Mitrais software developers alone was over 2000 man-days.
back to top
Advance Training Management - for ERP developer Mincom International - Mitrais under took customer enhancements to the Mincom's ERP system Ellipse. The enhancements met Learning Management changes requested by Australian utility companies ENERGEX and Ergon Energy. The enhancements extended and replaced existing Training system functionality provided by Ellipse. The front-end of the application was web-based and the back-end developed using COBOL. The total effort by Mitrais developers exceeded 1000 man-days.
back to top
Factory Reporting System - Mitrais has successfully completed a Factory Reporting System (FRS) for Philip Morris Indonesia. The system streamlines and automates data gathering processes from the production floor and provides rich reporting capabilities to supervisors and management groups. Production information, such as tobacco material usage, non-tobacco material usage, filter-maker-packer-ripper production flows, wastage and other vital information are captured by the system. The reporting module gives detailed and accurate views of daily activities, such as machine efficiency, machine utilization, factory utilization, material usage, finished goods, and executive summaries. The system implementation has been rolled out to Philip Morris Malaysia and a local customization has also been undertaken for the version to be used by Philip Morris Korea.
back to top
Shipment Traceability System (STS) - Mitrais has completed a Shipment Traceability System (STS) for Philip Morris Indonesia (PMI). STS is designed as a client-server application dedicated to improve outbound trace ability of finished goods. It provides PMI line management with valuable information in tracing production details (such as production code, machine used, date shipped et cetera) of finished goods. The application is utilised for both export and domestic shipments. This system implementation has been rolled out to Philip Morris Malaysia, Philippines, Vietnam and Korea. This year it will be rolled out further to China and Pakistan.
back to top
Philip Morris Indonesia - Bapeksta - Mitrais has successfully developed a system for Philip Morris Indonesia to manage duty exemption from Bapeksta (the Indonesian Government Agency of Finance Data Processing and Export Facilities). Philip Morris will use the system to monitor, calculate and generate complex Indonesian Government Customs Reports, so that import duties can be tracked and reclaimed as soon as possible. The system has 2-tier application architecture using MS SQL Server 7.0 and MS Access front-end. It runs on MS Windows NT 4.0 clients. It was developed using Mitrais' RUP small project methodology.
back to top
Contract Requisition - Major enhancements to the Contract Requisition module of an ERP application to incorporate new fields and modify business rules to meet company specific requirements.
back to top
Data Migration - For a major utilities operation in the Philippines, Mitrais designed and created batch programs written in VB to migrate data from legacy systems into a new ERP application. The data included Catalogue, Inventory, Purchasing, General Ledger, Journal Holding and Fix Assets data.
back to top
Finance System Enhancements - For the same utilities operation Mitrais developed COBOL batch programs to collect and consolidate Gains/Loss on Foreign exchange in their ERP application. Every month the programs would collect FOREX data and create corresponding journals for reallocation.
back to top
Human Resources System Modification - For the Indonesian operation of a US based multinational, Mitrais enhanced the ERP applications HR system to include additional custom functionality. Mitrais used VB to create the new functionality and integrated to the ERP applications database and security module using the ERP systems toolkit.
back to top
Indonesian Payroll Customization - For a major international EAM application vendor, Mitrais designed and developed the Indonesian version of their Payroll system. Significant modifications were made to increase the field size of amounts to accommodate the Indonesian Rupiah, provide the facility for multi-currency salary disbursements, cater for Indonesian specific tax calculations and add Indonesian statutory reporting capabilities.
back to top
Indonesian Customs and Transport Consolidation - For the same EAM application, Mitrais modified the Customs module to enhance the functionality so it complies with Indonesian requirements. Enhancements include a Transactionless Purchase Order, Insurance Cost Accounting, actual freight/volume cost, change customs terminology, use customs w/- no Freight A/C and the addition of several new interactive processing actions.
back to top
Modify ERP Financials - For a multinational operation in Thailand, Mitrais modified their ERP systems Finance module to accommodate the Thai statutory regulation of cheque numbers being 7-digit. A Thai electricity utility subsequently requested the same solution, adding further enhancements to incorporate additional processing options.
back to top
Indonesian Financials System Customization - Mitrais customized invoice screens in an ERP application for a leading US-headquartered mining company to allow incorporation of faktur pajak (the information the Indonesian Government requires for withholding tax) into the invoice.
back to top
Medical Systems
Company Specific Hospital Information System - Company Specific Hospital Information System - Mitrais has upgraded the hospital information management system used by a large gas processing plant in Indonesia. This system was originally written in house. As part of a major system upgraded Mitrais rewrote the system also implementing many customer specific enhancements and interfaced it to the clients ERP system.
back to top
K-MS Prime Care - 'Mitrais undertook the project to implement K-MS PrimeCare in the Klinik Kardiovaskular (Cardiovascular Clinic) - Hospital Cinere in Jakarta, Indonesia. K-MS PrimeCare is an affordable, high quality software package that integrates all points of care within a hospital, from patient administration and care management, to medical materials control. The implementation in KKV-HC went a step further by enriching K-MS PrimeCare features to cover the cardiovascular treatment and care process. The integration of the system with a 3rd party financial system (MYOB Enterprise V3) provides seamless integration between clinical and financial operations, allowing the client to achieve optimum implementation benefits. Key financial information, such as customer and tariff lists, invoices and purchase information is synchronized between the two systems, ensuring maximum integration between the medical administration and back office financial support. The product is a Java Platform Enterprise Edition (Java EE) based application, ensuring maximum portability of hardware, operating system and supporting software choices, as well as maximum scalability to handle heavy loads. It is a web application which is browser-based, eliminating the need to install client software on multiple PCs, to reduce maintenance and support requirements.
back to top
Medical System - Mitrais has written from the ground up a corporate medical system. The system is designed for organisations which must maintain medical facilities for their staff in remote locations e.g. mining, and oil and gas companies. The system comes in three version Clinic, Standard and Industrial. The Industrial version includes extensive Occupational Health features. The system has been installed for three clients. The system is designed to interface to major ERP systems including SAP, Oracle and Mincom.
back to top
Occupational Health & Safety - See Medical System below.
back to top
Legacy Systems Conversion & Support
Geological modeling and mine design system upgrade using Visual Studio .NET 2008 - Mitrais is currently undertaking a major upgrade from legacy X-windows based application into .NET application using the cutting edge Visual Studio .NET 2008 (previously known as Orcas). Working remotely from Bali, Mitrais set up VPN connection for VS.NET 2008 to be able to work with the Team Foundation Server (TFS) at client premise. The collaborative software development using VS.NET 2008 and TFS provides quality work process and product by utilizing its source control, work item, unit testing, code coverage, code analysis and nightly build integration. When it all comes into one integrated development environment, VS.NET 2008 provides developer efficiency with the enhanced feature, usability and robustness.
back to top
POS System for Innovative Retailing - An Australian Retailer has engaged an outsource project with Mitrais to modify a Web-based Point of Sales (POS) system. The nature of the client's business requires them to constantly expand their list of suppliers and their system as it stood was unable to provide them with the capabilities required. The Mitrais team were successful in providing the company with the capabilities they needed in their system and now the company is in the process of migrating from legacy system to open source .NET solutions.
back to top
Accounting System Conversion - Mitrais has recently completed the conversion of an Accounting System from COBOL to the Microsoft.NET environment for a US Software House. This project involved redesigning to an object oriented architecture and providing a modern graphical user interface while retaining the feel of the application to ease end-user migration to the new product.
back to top
ERP System Support - Mitrais has established & trained a team to provide support for a major ERP system vendor, Mincom International Pty Ltd in Brisbane, Australia. A Frame relay link into the client’s office allows the Mitrais software engineers to work directly on the client’s source code. This is a prime example of a high trust relationship where the Mitrais Team is integrated with that of the client. Some examples of the work are:
- Ellipse Internationalization - Simple COBOL works to remove some embedded literals within the code and replace them with a macro. Some 350 out of 1500 components have been assigned to Mitrais Software Engineers to review and convert. The work has been done in a very short period (just over a week) with proper internal code review for Quality Assurance.
- Mincom SA Payroll - a team for coding and unit testing was formed to support Mincom South Africa for their payroll development. This is a very good example of CSD (Collaborative Software Development) where the project leader is in South Africa, the Software Architect and Designers are in Brisbane while the development team is in Bali. Mitrais has successfully supported the first phase of this project and will be involved in the next phases.
- Ellipse 5.2.3 SP 4 Web View work order resolution - a team of Mitrais staff was sent to Mincom Brisbane to join the development team for bug-busting Web View work orders for an urgent target date release. The team was out placed for one month and sent back home after the number of outstanding work orders has been decreased significantly.
- Ellipse 5.2.3 upgrade projects - a number of Mitrais Software Engineers were seconded to join Mincom APAC team in a number of Ellipse upgrade projects on client sites in Australia. Some individuals were performing like stars as appreciated by the project managers and the clients after a successful go-live.
- Ellipse 5.2.3 WO Purging and XML work - prior to the release of Ellipse 5.2.3 SP2 in October last year, Mitrais was asked to assist in the resolution of a hundred Work Order for this new development. A similar work for the newly developed XML screens was also conducted early last year.
back to top
Visual Classroom Scheduler - Learning Institute Scheduling System Conversion - Mitrais has successfully completed the conversion of Visual Classroom Scheduler from C++ to Java. The application will enable universities or schools to effectively manage timetabling, which involves rooms, teachers, subjects and classes. The rich user interface, which includes its famous drag & drop feature, has made scheduling a very easy task for school administrators. The application also provides a mechanism to detect and solve schedule clashes. Powerful reporting and cost analysis tools are provided to users so that maximum utilization of the resources can be achieved. The demo version is now available for download from the vendor’s web site (www.vss.com.au). Although it has just recently been deployed, its attractive features have created enquiries and downloads by prospective clients.
back to top
Software Development Tools
Gentleware Poseidon 2.0 Plugins - Mitrais has been providing world class quality ‘plugins’ for Gentleware’s main product: Poseidon for UML. Poseidon is a promising, internationally recognized modelling tool which is gaining its acceptance in software developer's community globally. A plugin is simply a program which will extend the core functionality of Poseidon and thus increases software developer’s productivity. Mitrais was chosen to develop plugins for variety of languages such as VB.NET, C#, CORBA IDL, Delphi, and many more. The plugin is developed using Java 2 Standard Edition.
back to top
System Integration
Mitrais has successfully undertaken integration projects for companies wishing to ensure cohesive operations and to maximize ROI on their IT investment. These include:
- Integration of Oracle Financials to the EAM System for a major transportation operation in Hong Kong.
- Integration of an ERP applications inventory system with a Supply Chain Management tool for an Australian software vendor.
- For the Indonesian operation of a US based multinational, Mitrais developed batch interfaces in COBOL to extract Supply journals from an EAM application and feed the data into their financial system.
back to top
Mobile Applications
A Mobile Sales Application - Mitrais has developed mobile survey application for a food processing company to support its sales force throughout Indonesia. The application highlights Mitrais’ ability to both develop software and to integrate leading edge third party software to produce a rich user experience. The mobile survey application involves complicated business processing including route planning, scheduling, interactive mobile data collection, data consolidation, synchronization and reporting. Armed with Microsoft PocketPC based devices the sales force visits retail outlets to gather market and sales intelligence. The surveys are synchronized in real time to the sales center in the region for the supervisor to generate periodic reports as feedback to the sales team, and also synchronized to the head office for management reporting. The application can be highly customized as regards the questions and also the reporting format, making the system flexible enough to collect data for various market segments or whenever the company launches new products.
To provide a rich user experience in the desktop application, Mitrais integrated NetAdvantage software from Infragistics, the market leader in the presentation layer components industry for more than a decade. NetAdvantage provides the most comprehensive set of components for quickly building and styling commercial class user interfaces for Windows Forms, ASP.NET, JSF and WPF applications.
These components are flexible enough to be customized and extended to meet user requirements. The best feature of NetAdvantage is that Infragistics has its own application styling framework. It is a stand-alone function that allows the creation of themes for an application. Themes are read during run-time so users don’t need to re-compile if they want to change the theme of their application.
back to top
K-MS Extension on Microsoft Pocket PC and .NET Web Services - Mitrais has extended the capability of our in-house developed medical system to enable the physician reviews the patient’s condition through mobile device. The system is running on Pocket PC device and connected through the core application of medical system using Microsoft .NET Web Service. In the best scenario, the system will be deployed to hospital where WIFI network is in place. K-MS extension on Pocket PC is developed using Microsoft .NET technology.
back to top
PocketPC Universal ID Card - is developed as a PocketPC application dedicated to PT. Freeport Indonesia employee identification. Completed with barcode scanner, data synchronization with server (includes photo), and policy that each employee has a Barcode-ID Card, the PocketPC becomes a power full tool to give guidance to an officer who is guarding certain areas such as dining hall, explosive area, etc.
back to top
PocketPC Logging System - is developed as a PocketPC application dedicated to do outdoor data logging for Mine Serve International, a PT. Freeport affiliate company. Completed with data validation and data synchronization with server, the PocketPC becomes a very good tool to log data. It decreases the possibility of logging wrong data and does paperless work.
back to top
Shipment Traceability System - Mobile is developed for PT. Philip Morris Indonesia to record movement of finished products from factory to distribution warehouses, especially for off-line area. Each PocketPC is completed with a barcode scanner and a facility to synchronize data to server when connected.
back to top
Financial Services
Financial Services System - Mitrais has rewritten the enterprise system for an Australian Financial Services Company under a fixed price contract. The software was delivered on Time and Budget. The project was valued at $250,000
back to top
e-Business
NRX Global SRL - Mitrais undertook a 10-month project to provide a powerful sourcing facility in its Visual Parts System (VPS) Delivery™, an electronic solution for visual parts catalogue and maintenance documentation. The product interfaces the main NRX suite with various major Enterprise Resource Planning (ERP) and Enterprise Asset Management (EAM) systems, as well as on-line supply chain solutions. The application was developed on the J2EE platform by a team of 9 Software Engineers.
back to top
BICC Website - Bali International Convention Centre (BICC) embarks the year 2002 with a new look on its web site. Professionally designed and developed by the Mitrais web development team, the site portrays the desired characteristics, simple yet elegant. The development took 3 weeks to complete and was followed by deployment to a US based web hosting company. The newly launched site (http://www.baliconvention.com) has attracted more than 15,000 hits in a 3-week time frame, and has created great enthusiasm within its sister companies (BICC is affiliated with the Sheraton hotel chain). Backed up by solid experience, Mitrais has been delivering effective, value-added web applications for its customers and BICC is an example.
back to top
Oniqua Bid Responder - Oniqua Enterprise Analytics is a leader of Business intelligence Software for capital intensive industry. Bid Responder is designed specifically for supplier analysis and consequent business improvement. Mitrais were commissioned to write (to Oniqua's specification) a stand-alone module for RFQ (Request for Quotation) and bidding management. This module is distributed free by Buying Organizations to potential vendors to allow them to respond to RFQ's.
The application was developed in Java 2 Standard Edition in 3 months by a team of 4 Software Engineers. Mitrais used the Rational Unified Process methodology. It proved to be as effective for a light and rapid project as it is for larger projects. Rational Rose was used as the development tool.
Vendor Trader is now available for download from www.oniqua.com
back to top
Development of Mining Market Place - Mitrais has completed development of a Mining Market Place for a major publicly listed mining company. The system has extensive custom designed functionality and features. These include online product information, web orders, web stock and management of request, contracts, orders, stock, prices, invoices, customer relationships and reports. The benefits provided to the client include integration of their worldwide marketing process, expanded market penetration and improved customer service. The system utilizes the Java 2 Platform, Enterprise Edition (J2EETM ) and promotes Collaborative Transactions whereby the client can negotiate with customers prior to commitments being made or approval given.
back to top
V-CAT - An Internet based central materials catalogue that facilitates remote materials cataloguing services for ERP/EAM applications. Developed for an Australian specialist materials consulting firm, VCAT can also be the master catalogue for e-Commerce service providers enabling standardized structure for vendor product data and integration with ERP/EAM applications.
back to top
Specialty Applications
Kiosk License System - For an international provider of mining software and consulting service based on UK, Mitrais has just delivered a system to manage the licensing process of mining software sales through a web application. This would make the licensing process runs in more efficient across consultants and customers worldwide. Kiosk License System maintains the customers of the software, the software products to be licensed, the process of license key generation & recording and the process of software maintenance update. Kiosk License System is developed using Microsoft .NET technology.
back to top
Tunnel Entry System using RFID tags - For an international Manufacturing Execution System (MES) provider based the heart of Silicon Valley of San Jose, California, Mitrais has recently completed and delivered a system to monitor person and vehicle traffic across tunnel system. The system is based on RFID tracking which gives more flexibility on designing the portal and ID card system. The Tunnel Entry System includes a module to produce ID card which include direct connection to camera system, a module to handle real-time data acquisition to RFID scanner, a module to handle the logic and state machine of portals, a module which continuously synchronizes the data across portals and a reporting system which performs status tracking and summary of vehicles and person as well as scanning emergency condition and throws an alert based on that assessment. Tunnel Entry System is developed using J2EE technology.
back to top
Real Time Software - Mitrais has participated in an enhancement of an ActiveX component for Honeywell Singapore. The ActiveX component is called Profile Trend OCX which displays production output in a graphical format. It is a real time application with a set of functionalities to display graph, such as selection of the product type or machine number, right to left graph display selection, adjustment of the intervals, inclusion of zero values and calculations based on specific production formulas. This project was performed in Mitrais Bali office where development and test environments were adequately provided by Honeywell.
back to top
Travel Booking System - A web-enabled itinerary management system, developed by Mitrais for companies with employees who frequently travel so that they can effectively schedule all aspects of travel - from flight bookings and ticket printing to on-the-ground transportation arrangements and accommodation reservations. A web-based version for a remote client has also been developed recently. The system is integrated to the client ERP system in the area of Finance and Human Resource.
back to top
Consulting Administration System - Developed by Mitrais for consulting service providers. Facilitates scheduling consultants for projects, tracks client authorizations, records actual consulting time, and provides visibility of consultants' schedules and the extraction of consulting statistics. The application is web-enabled for remote access and can be integrated with financial systems.
A web-based version for a remote client has also been developed recently. The system is integrated to the client ERP system in the area of Finance and Human Resource.
back to top
Online Recruitment System - initially developed for internal use this product has now excited the interest of a recruitment agency and is being extended to provide a proprietary and enterprise critical application.
back to top
Scholarship Interactive Database - Mitrais has completed Scholarship Interactive Database (SID) for Lembaga Pengembangan Masyarakat Amungme dan Kamoro (LPMAK), an organization established under PT. Freeport Indonesia whose mission is to develop local community, especially Amungme and Kamoro community. SID was designed as a web application dedicated to maintain scholarship participant data.
back to top
Business Intelligence
SkorStor - Designed and developed by Mitrais in association with a Management Consulting firm, the SkorStor is a Performance Management tool based on the Balanced Scorecard. The product consists of a Data Mart to store performance measurement data, ETL routines to extract data from ERP/EAM applications, published reporting and OLAP services. The Data Mart has been developed for both MS SQL Server 7 and Oracle 7.3.
Next development will employ a Microsoft .NET framework for a total solution in Business Intelligence (BI). A release is expected on Q2 2004. Another development using Business Object’s BI tools is under investigation.
back to top
Metallurgical Database - Mitrais designed and developed a Data Mart to contain metallurgical data for a multinationals operation in Indonesia. The Data Mart acts as consolidated standard repository of raw data extracted from real-time systems. The Data Mart is the source for producing summary data to help eradicate the inconsistencies created by individual geologists inputting information.
back to top
Human Resources Data Mart - For the Indonesian operation of a US based multinational, Mitrais designed and developed a HR Data Mart in SQL Server 7. Mitrais also developed the ETL routines to extract data and populate the data mart from an ERP system for published reporting and OLAP.
back to top
Finance Data Mart - Data mart and ETL design for an oil and gas company in Indonesia, enabling users to intuitively access and query finance data.
back to top
Outplacement
Mitrais has placed staff on a temporary basis on our client sites in Australia, Hong Kong, Indonesia, Malaysia, Philippines, South Africa, Thailand, UK, and Zambia.
Our staff enjoy the highest reputation - please see the references under our clients
Ken, thank you for sending us Charles. He was a great assistance to us during his time here and was very professional in everything that he did. He actually made us have to work harder because he was fixing the bugs faster than we could test them. Because of Charles, we will be contacting your company again in the near future for other work that we have coming up. Of course now everyone up there has to live up to the groundwork done by Charles :-) Warren Notley, Managing Director, Paperless Warehouse, Australia.
back to top
