Project Profile

Project#1 AoTC [Velpaas Systems]

Title : AoTC (Automation of Transport Company)
Client : CONCOR India Ltd. Noida.
Duration : March 2008 to September 2008
Team size : 5
Software : Oracle 9i, Developer 2000, Windows 2000.

Description
AoTC is an Automation tool for internal process of a transport companies like import, export and domestic cargo handling, container loading, unloading, stacking and transporting from one place to another. This project contains five modules like import cycle, export cycle, Domestic cycle, Transportation and Accounts. Import cycle deals with destuffing of cargo into the containers. Transportation deals with various vehicles like road trailers, cranes, reach stackers and oil product, Account deals with daily expenditure and ledgers of whole process.

Responsibilities
1 Written various PL/ SQL Blocks (procedure, packages, Exception handlings, cursor and functions).
2 Written SQL for various reports
3 Written various sub queries & joins.

Project#2. MRP [Velpaas Systems]

Title : MRP (Material Requirement Planning)
Client : ABC Oil&Gas Company. Bangalore.
Duration : November 2008 to till date
Team size : 3
Software : Oracle 9i, VB. Net, Windows 2000.
Description
MRP project is a database driven project which is used to computerize the orders
Processed by the company. Orders are booked by the customers with the Help of sales representatives. The complete details of the users, orders received, suppliers, products, measurements etc. are stored in the database. The users are allowed to add, modify, view or delete the details. This project contains four modules like Order Acceptance, MRP, Issue of Stock against Indent, Purchase. Once the goods are ready the same will be delivered to the person who has made the order.

Responsibilies

1 Written various PL/ SQL Blocks (procedure, packages, Exception handlings, cursor and functions).
2 Written SQL for various reports
3 Written various sub queries & joins.
4 Designed VB. Net forms and Written Coding in Code Window.