Extensive Customization ERP System Development

FUNCTIONAL MODULES OF POS:

3.1.1 MARINE MODULE:

Marine Module intends to capture, maintain and management of Marine functional data related

to Port Operation. Marine functional data mainly covers vessel related data within Port Water

Limits such as Berthing, Un-berthing, shifting and sailing of vessels within harbour, Single

Point Mooring, anchorage and other related activities. This module helps in defining berth

occupancy, turn-around of vessels, etc in real time which results in ensuring the optimum

utilization of the berth space. It is also responsible for proper accounting of the various services

like Port dues, Berth hire, Pilotage and Towage, Fresh water supply and garbage collection, etc.

This module also covers dredging service record tracking and generation of reports and bills.

This module supports up-gradation, modification and addition/ deletion of Forms and Reports

to accommodate PPA’s changing requirement.

3.1.2 CARGO TRAFFIC MODULE:

This Module intends to capture, maintain and management of different cargo related

information including its documentation and accordingly generation of bill and reports are

automated. All the information related to cargo management functions is integrated and the

data capture is decentralized. This module is further divided into two sub modules i.e. Cargo

Traffic Operation and Cargo Documentation. The 1st sub module takes care of information

management of vessel wise/equipment wise different cargo handled and stock position of

different cargo. Stocks are updated in the plots and the process of centralized updating of stock

data ensures that a very high level of data consistency is maintained. This also simplifies data

management. The 2nd sub-module handles all vessel/cargo related documents like Import,

Export, IGM, EGM, Shipping Bill, Bill of Entry etc. Amendment and Supplements to various

application fields if required by shipping agents are handled in the documentation sub-module.

This module supports up-gradation, modification and addition/ deletion of Forms and Reports

to accommodate PPA’s changing requirement like addition of information of Harbour Mobile

Crane (HMC) & Grab operation, introduction of MGT, Containerized cargo in the commodity

transaction, etc. which were considered after development of application software.

3.1.3 DTR MODULE:

The DTR module is meant to capture and upload Daily Traffic Report based on the decision

made in Daily Traffic Review (DTR) meeting on vessel position, vessel waiting, vessel

expected for different operations, shipping movements, equipment utilization, stock position,

rake movement details (inward/outward), indent position, daily cargo loading/discharge of

vessels, cargo dispatch, etc. the operation of this module needs special attention as the entire

decision and review of Port operation revolves with it. This module supports up-gradation,

modification and addition/ deletion of information to accommodate PPA’s changing

requirement like addition of information of plot vacancy, [login to view URL] is in the process of

developing a system through which the Shipping Agents can update the operational

information online. The vendor is required to download the information and upload the

information from the internal system (POS) on declaration of the vessel.

3.1.4 RAIL MODULE:

The Rail module intends to capture, maintain and management of information related to Rake

operations in the Port including documentation and billing. It covers rail cargo documentation,

haulage, siding, tippling and indent of wagons as well as inward, outward or both movements

of rakes. This modules handles information related to all the operations performed on a rake

from its takeover to its hand over, which consists of forecast, arrival, wagon detail recording,

placement, release, drawn out and railway receipt. Information of single-operation of rakes and

back-loaded rakes are captured in the same way at the user-interface level. The system

distinguishes the two through internal processing. Multiple placement and release memos of

wagons are also taken care. It also manages information on tippling operations that form part of the wagon unloading. It also caters to the outward rake’s documentation like indents,

forwarding notes and the railway receipts. Depending on services rendered by Port related to

Rake operation, generation of bills and reports are automated. This module also auto generates

demurrage calculation. This module supports up-gradation, modification and addition/ deletion

of information to accommodate PPA’s changing requirement.

3.1.5 LABOUR MANAGEMENT MODULE:

Labour Management Module intends to capture, maintain and management of information on

requisitions, attendance, allocations and utilization of various categories of labourers deployed

for Port operation. The process of allocations of the various categories of labourers like Gang

Leader, Mazdoor, Supervisor, Winch man, Signal man, Tally clerk, Deck foreman to the

various vessels that are in operation, are done automatically after the requisition for a shift is

available with the details of suspended, on leave, off-day, absent labourers. This automatic

allocation function itself takes care of the attendance, allocation, off-day allocation of

labourers. The automatic allocation process has been developed and also upgraded from time to

time taking into account the priority rules in practice in the port. Depending on labour

utilizations in vessels and in consideration of priority rules in practice in the port, generation of

bills and reports are automated.

3.1.6 BILLING MODULE:

Billing Module intends for automatic generation of bills as per Port proformas by respective

sections of PPA for different services rendered by PPA through Port Operations System

application software. The automatic bill generation process is developed and upgraded in

consideration with port tariffs (as mentioned in Port scale of rates) and other tables that are

required for accounting the bill for the services provided by PPA. The module also supports the

generation of Advance Bill on the basis of the indents from the port users as well as the actual

bills on the completion of the operations as per services taken. Advance bills get adjusted either

through credit notes or through additional bills, which also get adjusted into the user’s account.

3.1.7 MIS REPORTS:

MIS reports can be instantaneously generated from the POS system based on data already

captured besides some specific statistical data collected and captured from various departments

separately. Just by entering the dates, POS can generate periodic, annual, monthly and

fortnightly reports that are required by the Port, Port Users as well as statutory bodies.

3.1.8 INCENTIVE CALCULATION MODULE:

This module intends for automated incentive calculation based on approved Incentive scheme

for cargo handling employees and port employees engaged for Port operations. This automated

incentive calculation process also supports the changes in Incentive Scheme, booking pattern,

type of commodity, etc from time to time.

3.1.9 FINANCIAL ACCOUNTING MODULE OF RE CELL:

The financial accounting module was developed to maintain the Port user’s service related

accounts, transactions and revenue earning of Paradip Port. It intends to maintain and manage

service wise party ledger, sundry debtors statements, preparation of journal vouchers, letter of

advice, generation of service tax statement-bill/party wise, generation of TDS - bill/party wise, compliance of service tax requirement, compliance to audit requirements etc. This module

supports up-gradation, modification and addition/ deletion of Forms and Reports to

accommodate PPA’s changing requirements. It has also option for manual payment posting

option.

3.1.10 EDI MODULE:

This module intends to handle the information shared between banks and Paradip Port for

financial transaction with respect to services rendered, with the help of electronically data

interchange system. Using this module different payment related messages are generated /

forwarded by Port to banks for financial transaction. This module supports establishment of

communication for new port designated banks, up-gradation, modification and addition/

deletion of Forms and Reports to accommodate PPA’s changing requirements. After

implementation of payment through SAGARSETU, the usability of this module has been

reduced.

3.2 FUNCTIONAL MODULES OF SAGARSETU:

The SAGARSETU application is accessed with the help of User ID and Password provided to

registered users of SAGARSETU. The information shared from both Port side as well as Port

User side through secured message exchange protocol. The message reply from Port side will

be done from the internal computerized application i.e. Port Operation System (POS) for which

Integration interface is developed to process the incoming message from SAGARSETU and

replied back using secured message hub. Some of the modules used in SAGARSETU

Production Server are as follows. The messages are operational in live environment from 1st

January 2008 in PCS-Production Server. The messages are replied using both SAGARSETU

user interface provided by IPA as well as user interface developed by Port and integrating the

same with internal Port Operation System through secure File Transfer Protocol in XML file

format. It supports addition, deletion, alteration of messages as per requirement of Port / IPA or

inclusion of new modules in the SAGARSETU.

Techstack:

Front End (Application Development Platform)-Visual Studio on Windows (Visual

C++ on Windows NT/2000 Pro, VS. Net on Windows2000/XP)

2. Back End (Database) – Oracle 10g on Windows 2003 platform.

3. Networking – Windows Network.

4. Reporting Tools – Crystal Report.

5. Testing Tool – Manual Testing.

6. Data Volume – Approx. 30 GB

7. No. of Tables – Approx. 400

8. No. of Procedures – Approx. 04

Visual Studio Programação C++ .NET Oracle

ID do Projeto: #37797797

Sobre o projeto