BIKRAMJIT SINGH KAHLON
Delivery Manager
|Contact Details
Mobile: +971-50-6457231
Residence: +971-6-5312645
Email:
[email protected] | |
DOMAIN Shipping and Logistics Systems
DPW is one of the major Company of Dubai World holding has largest
marine terminal operators in the world with a network of 44 terminals and
13 new developments across 28 countries. DPW provide quality services
designed to enhance customers' supply chain efficiency, including bringing
together container and other terminals, free zones, logistics facilities,
infrastructure developments and consultancy services where these services
add value for customers. DPW is committed to providing an environment that
is safe for all and, together in taking personal accountability with there
employees for making safe decisions at all times to achieve there goal.
I have 9 years of strong IT experience in managing the DP World operational
and commercial systems. Starting my career with DPW as programmer Analyst I
have achieved to be the solution expert of its primary systems MDS and then
Team Lead for entire Oracle Suit and then Solution Delivery Manager for
logistics and Supply chain solutions. During my carrier with DP world, I
had received a tremendous growth and had the opportunity to work various
both in-house and out-source projects.
SOLUTION DELIVERY MANAGER
In the capacity of Solution Delivery manager I am responsible for the full
software development cycle and ensure that a quality product is delivered.
I am also responsible to manage the in-house and out source applications
and effectively liaise with the vendors to deliver solutions meeting
growing business demand.
Being over all in-charge of the project, I participate in business
discussions for requirement Analysis, functional designing and over
view/participate in the performance testing, project management and quality
management.
TECHNICAL ENVIRONMENT
|OPERATING SYSTEMS |HP-UNIX, VMS, Window 2003/NT/XP/95 |
|LANGUAGES |SQL, PL/SQL, C, JAVA, FORTRAN, COBOL |
|SOFTWARE TOOLS |Oracle 10g, Developer Suit 10g, JDeveloper |
| |10g |
|IMPLEMENTATION |DP World Port applications, COVEMA commercial|
| |application |
| STUDY & DESIGN |Study of Functional Specification of an |
| |application, designing of application, |
| |complete understanding of business rules, |
| |Implementation of application |
WORK EXPERIENCE
NOV'99 to Till Date Information Technology Center, Dubai World
MAR'99 to NOV'99 Covema Filaments Limited, Cochin.
JUN '97 to MAR '99 Logic Point, Chandigarh
Designations Work on
JAN'08 to Till Date Delivery Manager
MAY'06 to JAN'08 Team Lead
MAY'02 to MAY'06 Solution Expert
NOV'99 to MAY'02 Programmer Analyst
MAR '99 to Nov'99 Software Engineer
NOV '98 to MAR '99 Sr. Programmer
DEC '97 to NOV '98 Programmer
JUN '97 to DEC '97 Jr. Programmer
PROJECT DETAILS
Project Title: DP world B2B partner Gateway
Client: DP World
Role: Delivery Manager
S/W Used: IBM WPG, WTX & WMB
Duration: SEP'08 to Till Date
Status: In progress
Description:
B2B project facilitate to establish strong B2B integration gateway for
shipping agents with DP world Dubai terminals Jebel Ali and Port Rashid.
The B2B framework is developed using IBM advance B2B technologies and this
project help to standardize and use best shipping logistics practices to
integration with DP world logistics partners using EDIFACT messages. B2B
gateway provide alternate channel for shipping agents to DP world portal
Dubai Trade for services such as DO, invoice, manifest/Disch/Load file
uploads etc using AS1/AS2/AS3 communication protocols.
Responsibilities:
Business requirement gathering, Vendor Management and Complete solution
delivery
Project Title: PoRt Operation Management Information System (PROMIS)
Module: Import and Gate
Client: DP World
Role: Module Lead for Import and Gate
S/W Used: Java, Oracle/D2K
Duration: AUG'08 to Till Date
Status: In Progress (UAT)
Description:
PROMIS re-engineer the existing port applications and provides a state of
art logistics application for DP world. This system would reengineer the
existing cargo clearance and operator process to optimize the use of Port
resources and help in reducing the port gate and yard congestion.
This system will help to get rid of the extra process and help DP world
vision to cut short the cargo delivery time and increase the throughput.
Responsibilities:
Business requirement gathering and Solution delivery
Project Title: e-Payment
Client: DP World
Role: Delivery Manager
S/W Used: Java, Oracle/D2K
Duration: MAR'08 to AUG'08 Date
Description:
This project extends the use of online e-Services and reduces the cargo
clearance time. Online payment service facilitates the consignees to pay
cargo storage charges using credit, advance deposit and online payment
gateway CePG.
Using online payment clearing party can make payment for FCL, LCL import
deliveries and delivery from PBA and Exports shipments.
Responsibilities:
Project management, Business requirement gathering and solution delivery
Project Title: e-Token
Client: DP World
Role: Team Lead
S/W Used: Java, Oracle/D2K
Duration: NOV'07 to JUL'08
Description:
e-Token provides online access to Haulier to book the appointment with DP
world for container IN/OUT movement, this system has facilitate DP world to
reduce the gate congestion and counter transactions.
Responsibilities:
Business requirement gathering and solution delivery
Project Title: e-Services
Client: DP World
Role: Team Lead
S/W Used: Java, Oracle/D2K
Duration: JUL'07 to FEB'08
Description:
e-Service projects introduces new online services for DP world customers to
do Voyage Enquiry on Dubai Trade Home Page, post miscellaneous services
request, Line wise Consolidated Statistics (Container Moves), Cut-Off Time
Report for Expected Vessel, Vessel Bay Plan, Agent's profile with Shipping
Service routes and frequency, Container HOLD & RELEASE online, Container
exception report - Shut out container list, Manifest Uploading, B/L Error
corrections.
Road Received Rotation - Enquiry & Amendment.
Responsibilities:
Solution delivery management
Project Title: DPP Integration
Client: DP World
Role: Team Lead
S/W Used: MQ, Oracle (AQ)/D2K
Duration: SEP'07 to FEB' 08
Description:
DPP integration provide integration between Customs Mirsal - 2 and DP world
system using Oracle AQ, this facilitate port and customs to achieve real
time integration between there system.
Responsibilities:
Business requirement gathering and solution delivery
Project Title: Oracle Finance Management System (FMS) Maintenance
Role: Oracle Team Lead
S/W Used: Oracle Applications
Duration: MAY'06 to AUG' 07
Description:
Oracle Financial system is used by Dubai World organization to
consolidating account receivable, account payment, asset management and GL.
It supports multi organization and use chart of accounts to segregate the
revenue.
Responsibilities:
Business requirement gathering and solution delivery
Project Title: Container Terminal Management System (CTMS) Maintenance
Client: DP World
Role: Team Lead
S/W Used: Oracle Applications
Duration: MAY'04 to JUN' 06
Description:
CTMS is a key system of DP world used for container operation and Shipping
agent billing, this system records the containers moves and has interface
with MDS, oracle financial and SPARACS.
Responsibilities:
Business requirement gathering and System analysis and Solution Delivery
Project Title: DP world Terminal - 2 system readiness
Client: DP World
Role: Team Lead
S/W Used: Oracle Applications
Duration: MAY'06 to JUN' 06
Description :
In order to meet the growing business, DP world opened Terminal - 2 at
Jebel Ali for which all port applications including CTMS and MDS were re-
engineered to support multi terminal concept.
Responsibilities:
Business requirement gathering and Solution Delivery
Project Title: Oracle 10g Application and database Migration
Client: DP World
Role: Team Lead
S/W Used: Oracle Applications
Duration: AUG'06 to NOV' 06
Description:
CTMS, MDS and other port application were migrated from Oracle 8i to 10g
database and Screens were migrated from forms 4.5 Character mode to forms
10g.
Responsibilities:
Solution Lead
Project Title: Cargo Management Solution (CMS) Maintenance
Client: DP World
Role: Solution Expert
S/W Used: Oracle Applications
Duration: MAY'01 to AUG' 04
Description:
CMS includes manifest (MDS), Consignee charges clearances (OPBE) and
Landing Certificate system. These systems are used for Cargo documentation
and commercial for documentation and charges collection from shipping
agents and consignees.
Responsibilities:
Business requirement gathering and System analysis
Project Title: myDPA
Client: DP World
Role: Programmer
S/W Used: Java and Oracle
Duration: MAY'02 to JUN' 02
Description:
myDPA was the DP world portal which was renamed to today's Dubai Trade.
This portal is used by DP world customers and provides them online facility
for real time transaction.
Responsibilities:
Oracle PL/SQL and forms Coding
Project Title: DPW - Custom Interface
Client: DP World
Role: Team Lead
S/W Used: MQ and Oracle
Duration: FEB'02 to MAY' 02
Description:
DP World - Custom Interface facilitate real time integration between DP
world MDS and Dubai Customs Mirsal system. This helped both Port and
Customs organization to achieve speedy clearance of cargo.
Responsibilities:
Oracle PL/SQL and forms Coding
Project Title: Manifest & Documentation System (MDS) Maintenance
Client: DP World
Role: Programmer Analyst
S/W Used: Oracle Applications
Duration: AUG'01 to AUG' 04
Description:
Manifest Documentation System captures the documentation requirements for
the Containerized and non-containerized cargo, this system is used by
shipping agents to provide cargo release orders to the consignee and
freight forwarders.
Responsibilities:
System Analysis and Coding
Project Title: Free Zone Personnel Systems
Client: DP World
Role: Programmer Analyst
S/W Used: Oracle Applications
Duration: NOV'99 to AUG' 01
Project Title: COVEMA
Client: Covema filaments Ltd., Cochin. (ISO 9002 Company)
Role: DBA
Duration: MAR '99 to Nov'99
Description:
COVEMA is an Enterprise Automation package having Sales Order
and Invoicing, Production planning, Production, Inventory, Purchase,
Finance, Payroll and Shares Management. COVEMA is an integrated solution
for
managing the complete Information Technology requirements of a
manufacturing
operation.
It offers powerful capabilities for manufacturing and improving all
aspects of the manufacturing organization.
COVEMA has been developed under the client - server technology
using Oracle 7 and Forms4.5, Reports 2.5, Graphics 2.5. COVEMA is extremely
user-friendly package and has a Graphic User Interface supported by Window
95/NT.
COVEMA provides an open architecture with flexibility for adding new
functionality or tailoring the system to meet the specific needs of
the company's unique environment.
Responsibilities:
Responsible for functional analysis, designing the database, application
development and writing the program specifications. Also responsible for
Client/Server Installations and Networking
Being DBA I am responsible for creating schema, enforcing integrity
constraints, managing users, security management by roles.
I have written stored procedures and database triggers for the project. I
was also responsible for monitoring and performance tuning.
Responsibilities as Oracle DBA:
Installation of Oracle 7.1,8.0
Installation of New Server & training to Clients.
Designing and creation of the databases.
Creation of users, login, Assigning Roles and privileges.
Implementation of Security on the databases.
Database Reorganization.
Deciding backup and Recovery strategy.
Performance Tuning, memory (SGA) tuning.
Database sizing, Tablespaces and rollback segment management.
Deciding the naming convention and proper placement of data files redo
log file, control files.
Database Triggers used to enforce integrity constraints.
Project Title: COVEMA
Module: Material Requirement Planning, Purchase System & Store Accounting
system
Client: Covema filaments Ltd., Cochin.(ISO 9002 Company)
Role: System Analysis & Application Development
S/W Used: Window- NT, Oracle -7.1 & Developer -2000
Duration: NOV '98 to MAR '99
Status: Developed and implemented.
Description:
This module covers the purchase System for Covema Filaments Ltd. This
includes domestic and foreign purchases (covered under import). The Module
starts with preparation of material requirement planning sheets based on
previous purchase orders, inventory and forecasted sale orders. After that
requisitions are prepared and approved from the approval authority that is
authorized to approve desired amount of material. An online stock of
material is available for help. For preparation of purchase orders the
complete data bank of vendors is available. Also a detail comparison sheet
of rate analysis is prepared to ease decision making in purchase.
Vendor rating is also done considering the quality, delivery and price
factor
as per the ISO 9002 Rules. The Purchase Module is completely integrated
with Store Module. On line availability of status of Purchase order and
indent is a marked feature of this module.
Responsibilities:
Responsible for functional analysis, designing the database, application
development and writing the program specifications.
Responsible for creating schema, enforcing integrity constraints, managing
users, security management by roles
I have written stored procedures and database triggers for the project. I
was also responsible for monitoring and performance tuning.
Totally responsible for the Implementation of this module at client side
Project Title: COVEMA
Module: MARKETING
Client: Covema filaments Ltd., Cochin. (ISO 9002 Company)
Role: Application Development S/W Used: Window- NT, Oracle -7.1 &
Developer -2000
Duration: JUN '98 to NOV '98
Status: Developed and implemented.
Description:
This module takes care of sales and order management System for Covema
Filaments Ltd. This Module takes care of Enquires & Orders from customer,
Check product DB for details, Dispatch material, Monitor dispatches pending
or with respect to the dispatch dates, Monitor competitors, Maintain sails
book, Monitor receipt from collection register, monitor sales quantities
value and budget (Party wise, product wise, dealer wise, zone wise).
Further party wise sales quantities value and budget is monitor party +
product wise. Dealer wise is monitor Dealer + Party wise, Dealer + Product
wise, Monitor dealer network. Zone wise is monitor Zone + Dealer wise, Zone
+ Party wise, Zone + Product wise.
Responsibilities:
Responsible for application development and writing the program
specifications.
I have written stored procedures and database triggers for the project.
Totally responsible for the Implementation of this module at client side
Project Title: COVEMA
Module: PAYROLL
Client: Covema filaments Ltd., Cochin. (ISO 9002 Company)
Role: Application Development
S/W Used: Window- NT, Oracle -7.1 & Developer -2000
Duration: DEC '97 to JUN '98
Status: Developed and implemented.
Description:
COVEMA Payroll takes care of generating monthly salary statements,
increment details, bonus, arrears and tax deductions. The system also takes
care of annual and monthly reimbursements leave encasement, gratuity and
retrenchment compensation.
Responsibilities:
Responsible for application development and writing the program
specifications.
I have written stored procedures and database triggers for the project.
Totally responsible for the Implementation of this module at client side
Project Title: COVEMA
Module: Human Resource Management
Client: Covema filaments Ltd., Cochin. (ISO 9002 Company)
Role: Application Development
S/W Used: Window- NT, Oracle -7.1 & Developer -2000
Duration: JUN '97 to DEC '97
Status: Developed and implemented.
Description:
COVEMA HRM automates all personnel related functions from manpower planning
to separation of an employee. It also performs other function like creation
of data bank, preparing interview action plan induction program,
maintaining personal details of employees, appraisal details etc. Various
types of fixed format letter also are generated.
Responsibilities:
Responsible for application development and writing the
program specifications.
I have written stored procedures and database triggers for the project.
Totally responsible for the Implementation of this module at client side
PERSONAL DETAILS
AGE : 35 years
MARITAL STATUS : Married
ADDRESSES:
Email :
[email protected]
Permanent Vill : Khanowal, P.O. : Bhagowal, Distt. Gusdaspur (Pb.),India.-
143511
Correspondence : Dubai, UAE.
Tel: 971-50-6457231.
DATE OF BIRTH : 18th March 1973
PASSPORT NO. : S - 362704
HIGHEST EDUCATION : M.Sc. (Statistics)
Punjab University, Chandigarh.
SPORTS : Swimming and Chess
HOBBIES : Reading Business magazines
[pic]