Case Studies

Production Management System
Developed an application to better control and schedule production, which includes job costing, enabling efficient management for the production of food items like soy sauce and cooking oil for a major Japanese food manufacturing company. Created using a DB2/400 database, the system generates production orders and schedules all manufacturing according to the customers' delivery dates and available capacity. Making automatic deductions from stock, it calculates unit cost based on the current cost of materials used. The system also has an inventory control for both raw materials and finished products. It also handles all aspects of sales and purchases, producing the relevant documents like purchase orders, sales order confirmations, picking and packing lists, delivery notes and invoices.
Project Size: 80 man-months
Operating System: AS/400
Database: DB2/400
Tools: RPG

Loans Operation System
Implemented an ACBS system for a major international bank for its global loans operation. The new system was customized in order for it to be interfaced with the company’s existing front and back office systems. Tasks undertaken include business analysis, systems implementation, and data conversion.
Operating System: AS/400, NT
Database: DB2/400, Oracle
Tools: Delphi, Lansa

Net Trading System
Developed an Internet based trading system for a leading Japanese security firm. Technologies such as EJB, J2EE, Weblogic were used for the implementation. The system was designed to be functional, as well as to achieve shorter response time for on-line trading.
Operating System: HP UNIX
Database: Oracle
Tools: Java

Pharmaceutical Distribution System
Converted the existing system of a top pharmaceutical company enabling it to become Internet based. Sales agents are now able to access the company’s central database for resource information, sales channels identification, and distribution results confirmation.
Operating System: Windows 2000 Server
Database: Oracle
Tools: VB, ASP

Accounting System
A 16 man-month project to develop an enhanced Accounting System for a Japanese Government Agency. Functions include creation of report forms and collection bills, claims management, and workflow monitoring.
Technology Used: Oracle EBS, PL/SQL, KShell

Cash Flow Management System
A system being developed for a leading international bank that would enable efficient monitoring, analyzing, and adjusting of the company's cash flows to avoid extended cash shortages. The application would be able to perform a cash flow analysis on a regular basis and use cash flow forecasting in order for the company to head off cash flow problems. The system would also have built-in reporting features to make cash flow analysis easy, and for better cash flow management.
Project Size: 70 man-months
Operating System: Windows 2000
Database: SQL Server
Tools: ASP, .net

China National Advanced Payment System
Currently developing an advanced payment system for a major international bank to conveniently facilitate authorized claims from contract traders. The system would ensure immediate and direct disbursement to contractors to help raise capital for small and mid-sized construction traders having a hard time securing business-operating capital.
Project Size: 30 man-months
Operating System: UnixWare
Database: Sybase
Tools: PowerBuilder, C, C++

HR Management System
Helping a multinational pharmaceutical company develop a human resources management system to better handle critical employee and company financial data. The application would include advanced accounting and operations systems for the company's payroll processing, simplifying their complex HR operations, also enabling them to quickly summarize and analyze employee data and make informed decisions to control insurance costs.
Project Size: 20 man-months
Operating System: IBM Websphere
Database: SQL Server
Tools: Java, Servlets

Budget Management System
Developing a budget management system for a multinational pharmaceutical company that would help streamline and coordinate their budget preparation and maintenance cycle by keeping track of the budget process as well as automating allocations, calculations, and cost-splitting. The system will be interfaced with their existing Finance and HR Management Systems.
Project Size: 20 man-months
Operating System: IBM Websphere
Database: SQL Server
Tools: Java, Servlets

CRM Workgroup Module
A German CRM company wants to enhance its solution by adding a workgroup module, enabling better communication. The improvement enables users to create and view appointments for both internal and external contacts. An added feature allows people creating appointments to view the availability of prospective participants to a meeting before creating an appointment to ensure availablity. This new feature hopes to help small- to medium sized companies to better manage their business relationships.
Project Size: 10 man-months
Operating System: Windows 9X/2000
Database: SQL Server
Tools: Java, Servlets

Retirement Fund Management System
A 150 man-month project being undertaken to develop a new retirement fund system for a large Japanese trust company. Functions include systems management, account management, and accounts receivable/payable system.
Technology Used: VB, .net, SQL Server

Insurance Claims System
A 4-man 12-month project to develop an enhanced Insurance Claims System for a US based investment company. Functions include creation of report forms, customer feedback/response workflow monitoring, and claims computation.
Technology Used: Lotus Notes

Retail Management System
A 20 man-month project to develop a Retail Management System for a Japanese based pharmaceutical company. Functions include systems management, retail planning and distribution and reports generation.
Technology Used: JSP, Java Beans, SQL Server