lauhw2000

WHAT I HAVE DONE - IT PROJECTS Sales Order System (1998): (Freelance job) Role: Programmer Development Tools: • MS SQL 6.5 - database engine • VB 5 - develop user interface • Crystal Report - create reports Client Background: • Paper/plastic bag manufacturer who is operating their business in Penang Island, Malaysia. Features of the system: • Customer Information Maintenance Module • This module will keep track the customer information, which includes a small module called tax exemption maintenance module. This small module will keep the details of tax exemption applied by their customers. • Product Information Maintenance Module This includes the maintenance on product color, product type and product code. Each product type will have a different kind of input mask. Such as, yarn is 'Y#999.99c' where Y represents yarn, # represents optional digit and 9 represents fixed digit and c represents a color code. So, I created a control to handle different input mask and it allows the user to define new input mask (the control will change according to the mask). • Sales Order Entry Module • Once the user received the purchase order from their customer, they will enter the details to the system. • The factory supervisor will retrieve this data. • Fulfillment Entry Module Enter the data when the goods is ready to deliver. • Delivery Entry Module • Enter the lorry details and the sales order details, then, print the D/O for lorry driver. Invoicing Entry Module • The accounts department will print the invoice when the goods are delivered to their customer. • User Login Maintenance Module - maintained by System Administrator • The system administrator will add, update or disable the user login through the simplified version of security control module. • Report Module • This includes product listing, customer listing, sales order entry listing, etc. v This project was completed within 3 months and I am actively involved in system analysis, design, coding and testing. The implementation of this system was take care by a company. All database transactions are done using stored procedure and trigger that written in SQL statement. This system is running on a local area network and it has 10 workstations. v Achievement: • Provides a better way to control over the production schedule and reduce the idle time. This is because the user can print the pending fulfilling order sorting by estimated delivery date. • Shorten the learning cycle of handling sales order, fulfillment, delivery order and invoice. • Allows the user to expand the system easily. Accounting system for a legal firm (1999): (Freelance job) Role: Analyst Programmer Development Tools: • MS ACCESS - database engine • VB5 - develop user interface • Crystal Report - use to create report Client Background: • A legal firm who is operating in Jalan Ipoh Kuala Lumpur, Malaysia. Features of the system: • Client Profile Maintenance Module This module will keep track all the client information, the appointment or meeting details court case details, etc. Turnkey historical data checking which increase the response time to client through phone call or interview. • Billing Module • This module provides an easy way to issue a bill and keep tracks all the bills. • Enable the user to print the bill listing and create exceptional report using Crystal Report, such as summary of disbursement fee and legal fee for each client. • Cash/Cheque Receiving Module This feature will automatically deduct the amount of settlement or issue an official receipt upon receiving deposits from the client. • Client Account Module Maintaining client accounts for all transaction like bills and payments. • Office Account Module • This module maintains the General Ledger transaction and final reports (such as Profit & Loss Account and Balance Sheet). v I am actively involved in system analysis, design, coding, testing, implementation and training. This system is running on network with 5 workstations. The whole project was completed within eight months. Partially of the transactions are maintaining through the uses of query provided by ACCESS. Achievement: • After using the system, they are able to speed up the response time to their clients. Such as, issuing bill, official receipt and retrieving historical data from the system. • Since the billing module allows the user to customize or predefined the billing item, it reduces the typo mistake and shortens the learning cycle of handling bill and official receipt. • Able to provide exceptional reports within 2 hours. Point Of Sales in Outlet + Inventory Control System in HQ (2000) Role: Analyst Programmer Development Tools: • MS ACCESS - database engine • VB6 - develop user interface • Crystal Report - use to create report Client Background: • A retailer who is operating their business in Petaling Street Kuala Lumpur, Malaysia. Having about 4 outlets in Petaling Street. • The system has been implemented since year 2000 and the client is still using it in year 2008. Features: • Inventory Control System in HQ • Able to keep tracks the stock movement such as purchase of goods, goods return to supplier, goods return from Outlet, goods return from customer, stock adjustment, issue Invoice, issue Credit Note, etc. • Able to print bar code from bar code printer. • Able to export invoice to diskette for Outlet system. • Able to import sales data, credit note and adjustment in diskette (from Outlet). • This is a multi-company enabled system that means it is able to exchange data among the company. Such as export invoice to another company database and export product information. • Point Of Sales System in Outlet • Able to print official receipt from receipt printer. • Able to import invoice in diskette (from HQ system). • Able to export sales data, Credit Note and adjustment to diskette for HQ system. • Able to control cash drawer. Point Of Sales System located in multi-locations that replicate the data back to HQ office (2001) (Freelance job) Role: Lead Developer Development Tools: • MS SQL 2000- database engine • VB6 - develop user interface • Crystal Report - create report Client Background: • The client is operating airport lounge in KLIA (Malaysia), Hong Kong, Singatpore, Australia and Shanghai (China). Features: • The business nature of the company is lounge business that running on 24 x 7 and located in the airport. For example, Malaysia, Singapore, Hong Kong, China and Indonesia. Each lounge will install with a MS SQL 2000 server to store all sales transaction. The sales transaction will be replicated back to HQ office located in Kuala Lumpur, Malaysia during off peak through their Virtual Private Network VPN. • Support multi-currencies and has individual exchange rate that controlled by the management. • All POS users have their own SQL user login that allows the system administrator to monitor the connected users. • This system also stores the instructions in the contract between airline and the lounge. So, the POS users do not have to manually flip through the instructions book as they have done it in the past. With the POS system, they have to select the contract airline and the instructions will be on the screen. This improves the responsiveness to their customer. • Besides receiving cash in multi-currencies and various credit cards, the system also designed to accept voucher. The voucher is distributed by the lounge to the contract airline and the airline company will pass the voucher to their regular passengers. So, the passenger can consume the services in the lounge by just submitting the voucher. • The system was designed to cater for shift and daily sales closing. Only authorized personnel (normally supervisor) are allowed to perform the sales closing. After shift or daily sales closing, the receipt number will run on different series of number which constituted by transaction date, shift number and 5 digits running number. The supervisor will have to enter the sales variance after the sales closing has been done. Whereas, the system does not block the POS operator from entering new sales transaction. E-Billing System for a construction company (2001 – 2005) (Freelance job) Role: Lead Developer Development Tools: • MS SQL 2000- database engine. • VB6 - develop user interface. • Active Report – for creating reports. Client Background: • The client is operating their business in Sunway, Kuala Lumpur Malaysia. • The entire project has gone through two enhancements due to the changes in the business rules. • The system is still running since year 2001. Features: • Machinery Booking – allows the customer to make booking on the requested machine. • Fixed Asset Transfer (FAT) – allows user to issue FAT upon delivery of machines to the construction site. • Re-rent – allows user key in the re-rent machine to the system. • Rental termination – this module allows user to enter the termination of rental agreement when the customer returns the machine. • Generating invoice twice a month – the system will generate invoice based on FAT. Once the machine has been returned, the invoice will no longer been generated. • There are total 4 outputs from this project: o 2 ActiveX DLLs – security DLL & data-tier DLL. o 1 OCX – some customized VB controls to speed up the development. o 1 Standard EXE – this is the main program that provides. Guest Survey System running on Palm Pilot (2001) (Freelance job) Role: Lead Developer Development Tools: • MS Access 2000- database engine • VB6 - develop user interface for desktop application • AppForge to develop palm pilot application • Active Report to generate the statistic reports. Client Background: • The client is a hotel management company who is doing the guest survey regularly. Features: • Perform survey through Palm Pilot (as data collector) in the hotel front desk. After the survey, the palm user will have to synchronize the data back to desktop application. • A few set of questionnaires can setup and transfer to the palm through HotSynch manager. • The system allows the management personnel to generate report at anytime that really improves the responsiveness to the key problem area. Drugs Inventory Control System For Clinic (2003) (Freelance job) Role: Lead Developer Development Tools: • MS ACCESS - database engine • VB6 - develop user interface • Active Report – for creating report Client Background: • The client is a clinic who is operating their inventory store in Shah Alam, Malaysia. • The system has been implemented since year 2003 and they are still using this system. Features: Inventory Control System in HQ • Transaction history: able to keep tracks the drugs movement. • FIFO costing method: the costing method for this system is FIFO (first in first out). The system will be able to track how many drugs are located in the drug store and the actual cost for each drug. • Dynamic markup: the selling price for the drug to other branches is based on the markup of actual cost. This means that the selling price is calculated upon issuing delivery order. • Best offer: the system keeps track the bonus quantity (i.e., promotion item) offer by the supplier. When the user wants to issue Purchase Order, the system will show the best offer among the offers by the supplier. This assists the user to make a better decision and reduce the time of comparing the offer from each supplier. OTC System in sales Counter This system is installed in the counter of the clinic to record the drugs sold to the patient. The quantity status will be updated immediately upon issuing an official receipt to the patient. This allows the drugs keeper to reallocate the drugs from one branch to another. There are 2 types of selling price that includes consultation price and OTC price. Both prices are marked up based on standard cost of the drug. Front Office Systems (2003 – 2004) (Freelance job) Role: Lead Developer All 3 systems are for the same customer who required the systems in separate EXE. Customer Relationship Management – this system is responsible for recording all customers’ detail. All scanned contracts between the customers will be stored in the system as well for future references. Resource Management System – this system is responsible for tracking the details of all resources that can be rent to the customer. An inventory control system has been incorporated to consumable items. The sub modules for the inventory control is issuing Purchase Order, handling stock adjustment, receiving goods and returning goods. Front Office System – this system is responsible for handling incoming calls, enter job details (i.e., charges), maintaining customer preferences and resource booking. Besides that, it also generating recurring bill for the customer. Development Tools: • MS SQL 2000 - database engine. • VB6 - develop user interface. • Active Report – for creating reports. Client Background: • The client is operating business centers in Kuala Lumpur (Malaysia), Singapore, Hong Kong and China. Mail Client Program (2003) Role: Lead Developer Development Tools: • MS ACCESS - database engine • VB6 - develop user interface • Active Report – for creating report • Mail server – mail server that supports POP3 and SMTP. Client Background: • The client is a hotel management company. Features: • The main feature in this program is that the global address book for the entire organization will be automatic downloaded to the mail client. • It has automatic program update feature which will download the latest version and upgrade itself. • It is a multi-threading program – this means the user is able to continue to work while sending/retrieving emails. • This program is pending for integrate with other management systems. Evotech Dynamic Virtual Machine (Since 2003) (For internal used) Role: Lead Developer Development Tools: • VC++ 6 using MFC. • MS SQL Server 2000. Client Background: • We develop this program for in-house research purposes. Features: • The main idea of building the virtual machine is to § Speed up the development of customized project. Targeted 50% codes will be written manually for each customized system. § Updating the system without shutting down the core engine. § Reduce the technical support costs on troubleshooting the runtime environment (such as, conflict in the libraries). § Freedom to incorporate new features due to the environment changed (in Windows) without recompile all customized systems (i.e., the customized system remains untouched). • Virtual Machine – this is the core engine written in MFC from scratch that consists of script engine, reporting engine and tightly integrated with MS SQL 200 Server. The only dependency is ADO library. Distribution does not require installation. Currently, the size of this virtual machine is 1MB EXE. • System Designer – this module is built from scratch using MFC. It allows the programmer to perform screen design, settings up the business rules and calling reports. Multi-languages interface can be design using this System Designer. • Report Designer – this module is built from scratch using MFC. It allows the programmer to design the report that is database independent. The reporting engine was integrated into the virtual machine. Projects that is using Evotech Dynamic Virtual Machine: • Inventory Control System for Electrical Shop: • Supports FIFO, LIFO, weighted average and actual cost (based on the serial number). • The system runs in a multi-users environment. • The database is MSDE (Microsoft Desktop Engine). • Allows tracking the stock level, issuing invoice, etc. • Allows printing monthly statement for the customer. • Accounting System (under development): • Able to handle fullset accounts including GL, AR, AP and cashbook. • Does not require year-end closing. • Able to integrate with the above mentioned Inventory Control System. Price Enquiry System (2004) Role: Lead Developer Development Tools: • MS ACCESS - database engine • VB6 - develop user interface • Active Report – for creating report Client Background: • This is a standard package that is targeted for the SOHO (Small Office Home Office) businesses. Features: • Able to issue quotation, invoice and delivery order. • Able to stores the customer database and the product information. • Able to keep track the pay status of the invoices. • The format for quotation, invoice and delivery order is customizable. • Able to generate sales reports. Warehouse Management System (2005) Role: Lead Developer Development Tools: • MS SQL 2000 - database engine • VB6 - develop user interface • Active Report – for creating report Client Background: • The client is operating a cold storage warehouse services to their client. Features: • Able to track the receiving and issuing of pallet of stock. • Able to generate monthly rental charges based on the space occupied. • Able to show the location map for the given pallet. • Able to manage multi-warehouse and multi-location. • For the in-house stock, • The system is able to print the invoice and delivery order to bill the customer. Online Reservation System for Hotel (2007) Role: Lead Developer Development Tools: • MS SQL 2005 - database engine • ASP.NET & C# - develop user interface • DevExpress XtraReport – for creating report Client Background: • The client is a hotel management company who operates 8 hotels in Malaysia. Features: • This is a web base system. It is accessible through [login to view URL]. • In general, it has 2 modules: guest module and admin module. • Guest Module: • Able to track and keep the guest record in the database. • Allows guest to register themselves in the system for e-marketing purpose. Such as, sending them the promotion information, updated event, etc. • The guest will be able to manage their reservations and communicate with the hotel through the built-in messaging system. • Upon confirmation, the guest will receive the confirmation email with the PDF file that contains the confirmation. • The guest is able to pay the reservation by their credit card. The system is interface with the online credit card payment gateway provided by Maybank. • Admin Module • Allows the admin (staff) key in the room inventory in the system. • Allows the admin to key in dynamic pricing for the room inventory. For example, 2 rooms that is selling at RM8.00 and 3 rooms that is selling at RM20.00. The system will automatically moving the selling price up by 1 level once the room has been sold out. • Allows the admin to manage to the reservations. • Allows the admin to block off the rooms during peak period. • Allows the admin to key in rates for peak and non-peak. • Able to generate sales reports. • Able to give special rates for a particular group of guest. For example, corporate guest and travel agents. Event Management System (2007) Role: Lead Developer Development Tools: • MS SQL 2005 - database engine • ASP.NET & C# - develop user interface • DevExpress XtraReport – for creating report Client Background: • The client is a event organizer in the education industry. Features: • This is a web base system. It is accessible through [login to view URL]. • In general, it has 3 modules: the web portal, guest module and admin module • The Web Portal • Allows the admin to customize the home page and about us page. • All events will be shown in the web portal and accessible by the public. This includes the location map for the venue, additional information for the event (such as, PDF file of the event in previous year). • Guest Module • Allows the guest to open an account with the event organizer at anytime. • Allows the guest to register any available event at anytime without using fax. • An invoice will be sent through email immediately once the guest has confirmed the event registration online. • An official receipt will be sent once the payment has been received by the organizer. • Allows the guest to manage the registered event including switching of event and withdrawing of event. • Allows the guest to reprint the invoice at any time. • Admin Module • Allows the admin (staff) to key in the events details, uploading files and photos at anywhere and anytime. • Allows the admin to key in additional request for the particular events. For example, power extension cord, projectors, etc. The additional request can be free or chargeable. • Allows the admin to set the maximum available seats in the event. The system will automatically deduct the available seats once the guest has registered to the event. • The waiting list is a system setting and it allows the admin to change it at anytime. • The admin is able to resend the invoice, official receipt and mail merge email at anytime. • Upon requesting of opening a new account by the guest, the admin will have to manually approve it. This allows the organizer to have full control over the guest account. Celestial Windows Service (2007) Role: Lead Developer Development Tools: • MS SQL 2005 - database engine • C#, Windows Service & Socket programming - develop user interface Client Background: • The client is a hotel management company who operates 8 hotels in Malaysia. Features: • This module is a backend process that was developed using Windows Services and socket programming. It was installed in the server in each hotel and scheduled to send the reports. (The report was generated by other systems.) • The main idea of developing this module is to provide a base service for other modules that communicate through Socket using TCP protocol. • The Windows service consists of the following modules: • Service Loader & Extensible Service – this module loads the standard modules (such as Task Queuing module, Mail Router, etc) to the memory and the follow by the extensible modules (i.e., the modules develop by third party). • Task Queuing Module – the Windows service is implemented using FIFO (First In First Out) concept. All requested tasks are queued before processing. This allows asynchronous call in other modules. • Mail Router – allows other module to request the Windows service to route the email to the internet. • Task Scheduler – allows the admin to schedule the task to be run at certain hour and/or day. • Audit Log Service – allows other module to send the audit log to be saved into the database. User Access Control System for Hotel (2008) Role: Lead Developer Development Tools: • MS SQL 2005 - database engine • ASP.NET & C# - develop user interface • DevExpress XtraReport – for creating report • WCF (Windows Communication Foundation) to develop the interface for other modules. Client Background: • The client is a hotel management company who operates 8 hotels in Malaysia. Features: • This is a web base system. It is accessible through [login to view URL]. • Allows the admin to manage the user’s access permissions. For example, user A allows accessing the weekly report module but not allowed to access check list module. • Allows the admin to manage multi-organization and multi-company. • Allows the admin to manage the user access permission by defining user roles. • It has a WCF interface that has been developed for the integration with other modules. Such as, weekly report, checklist system, etc. This interface module is a DLL (i.e., Windows Library) that provides the access to the security information by other module. Weekly Report System for Hotel (2008) Role: Lead Developer Development Tools: • MS SQL 2005 - database engine • ASP.NET & C# - develop user interface • Integrate the security module through WCF (Windows Communication Foundation). • DevExpress XtraReport – for creating report Client Background: • The client is a hotel management company who operates 8 hotels in Malaysia. Features: • This is a web base system. It is accessible through [login to view URL]. • This system allows the staff to key in their weekly report at anytime and anywhere. • The system is able to help the staff to organize their weekly schedule on when to do. • Able to delegate the task to sub-ordinate. • Able to view the task progress. • Allows the staff to comment on task done by other. • The security module is integrated with User Access Module that was developed in WCF. Fixed Asset Register System (2008) Role: Lead Developer Development Tools: • MS SQL 2005 - database engine • ASP.NET & C# - develop user interface • Integrate the security module through WCF (Windows Communication Foundation). • DevExpress XtraReport – for creating report Client Background: • The client is a hotel management company who operates 8 hotels in Malaysia. Features: • This is a web base system. It is accessible through [login to view URL]. • This system allows the company to keep track their fixed asset through a web base system. • It allows the admin to upload multiple photos, PDF files, user guide, etc of the fixed asset to the server. • Able to generate depreciation schedule for each asset. • Able to generate depreciation report for the given period. This report is useful for the Accounts department to post the depreciation. • Able to generate the asset location report. • It has a built-in audit log to track the changes of the fixed asset. • It is able to keep track the fixed asset for multi-organization and multi-company.