Posted by on May 09, 19102 at 13:47:45:

Jayanta Goswami,
NRL Township, Bhairabi-12, Numaligarh - 785699,
Assam, India.
Phone (R) : 091-376-2665413*4244 (Extn.)
e-mail : jayanta_goswami@yahoo.com

SUMMARY
***********

* ERP Material Management and Oil Production
functional professional with technical knowledge
seeking career change as SAP / ORACLE / RAMCO
MARSHAL Consultant in an organization providing
new challenges, growth and vision.

* Eight years of experience in the petroleum
industry with outstanding track record in ERP,
Commercial and Construction departments. In depth
front-end, back-end knowledge in Ramco MARSHAL ERP
suit of Applications (Home Page :
http://www.ramco.com) and familiar with SAP R/3 MM
features, particularly Purchasing, Inventory
Management, Warehouse Management and Invoice
Verification.

* Four years of experience in ERP starts from
involvement in conducting scoping studies, making
gap-analysis, identifying areas of customization,
laying down modeling cases, signing of business
mapping report, rigorous testing, configuring
reports, rectifying procedures, building masters,
initiating and sustaining live run and post
implementation support.

* Comprehensive functional skill appropriately
augmented with technical skill in the area of SQL,
SQL Server, SQL Server Profiler, Query Analyzer,
Enterprise Manager, Report Writer among others.

* Extensive hands-on experience in the implemented
modules with a quest for continuous feature
enhancement.

COMPANY PROFILE
*************************
Served in various capacities at Numaligarh Refinery
Limited (NRL) since September 1994 till present.

NRL is a state-of-the-art petroleum refinery located
in Assam, India, a Government of India enterprise
and subsidiary of oil major Bharat Petroleum
Corporation Limited. It holds the distinction of
being the first refinery in India to have
successfully implemented ERP for all business
transactions, which are audited among other
agencies, by Price Waterhouse Coopers. The company
is currently pursuing ISO 9001, 14000 & 18000
certifications.

NRL have successfully implemented Ramco Marshal ERP
without any outsourcing. This have been possible
through extensive functional as well as technical
training to the core group responsible for ERP
implementation, in which, self has been an active
member since inception.

Other prominent companies where Ramco Marshal ERP
have been implemented include ‘Boeing-USA’,
‘Columbia Helicopters-USA’, ‘ETA SA-Switzerland’,
‘Swatch-Switzerland’, ‘Indian Airlines-India’,
‘Hyundai Motors-India’, ‘Madras Cements-India’,
Chennai Petroleum Corporation Limited-India
(Reference web site :
http://www.ramco.com/customer/default.htm ).

SKILLS & ACCOMPLISHMENTS
*********************************

Served as an accomplished functional lead for three
plus years in implementing Purchasing, Service
Contracts, Inventory Management, Warehouse
Management, Invoice Verification and Oil Continuous
Process Production modules.

Handled entire aspect of implementation including
project planning and monitoring, configuration,
customization, specifications, modeling, master data
creation, interfaces, creation of custom queries,
report configuration, audit trail analysis.

The massive material and vendor masters were created
in a period of less than four months prior to going
live. Utilizing independent Report Writer skills,
generated over 15 major reports, which have
effectively permitted ready availability of all
pertinent information on-line.

Ensured live run of the modules within stipulated
time frame despite several practical constraints,
bottlenecks and major oil industry specific
customization requiring repeated regression testing.

Optimized workflow among purchase, inventory and AP
modules resulting in reduced downtime in releasing
vendor payment by over 75% and immediate clearing of
through Bank payments, which have considerably
enhanced the company’s image in business circles.

Assisted Price Waterhouse in ERP audit trail
analysis. Associated with ISO implementing
consultants in ensuring overall product conformity
with best international business practices.

Ensured sustained trouble-free operation of all the
implemented modules. The customized applications
have gained ready user acceptance and have been
widely appreciated at all levels. Extensively
trained more than 20 end-users, who are now experts
in their field and, in turn, are training others.

EXPERIENCE PROFILE (In Reverse Chronological Order)
*******************************

Jan 2002 - Current
------------------

* Rendering post implementation ERP support and have
been persistently involved in problem
identification and solution development.
* Associated with petroleum product pricing and
formulating marketing strategies in the oil sector
post Administered Price Mechanism scenario.
* Designing and configuring statutory / MIS ERP
reports.

March 2001 - Jan 2002 (ten months)
------------------------------------

* Ensured successful live run of the oil production
module in nine months.
* Analyzed customizations and rigorously tested the
related applications.
* Rectified 59 back-end procedures to perfect the
production module.
* Evaluated performance on the interface with
Distributed Control System for Real Time data from
plant automation system.
* Configured the system, checked inter-module
integration, ported all production related master
data.
* Conducted parallel run for one month.
* Compiled the Production module user manual and
imparted user hands-on training.

Dec 2000 - March 2001 (three months)
------------------------------------

* Carried out audit analysis of purchasing,
inventory and invoice verification.
* Assisted in completing physical inventory
exercise.
* Streamlined the management and reconciliation of
items issued from company’s stock to contractors
against service contracts.

Aug 2000 - Dec 2000 (four months)
---------------------------------

* Streamlined warehouse and inventory management
involving complex warehouse structure, MRP, ABC,
XYZ, FSN & VED analysis, Re-order, Min-Max,
Forecast Planning, Batch control, Material
costing, Physical inventory.
* Compiled the Inventory and Warehouse management
user manual and imparted end-user training.
* Assisted in project capitalization and account,
cost center reconciliation.

July 1999 - Aug 2000 (13 months)
--------------------------------

* Ensured successful live run of the Inventory and
Warehouse Management modules in twelve months.
* Created batch data conversion compliant excel
spreadsheet, wrote queries in MS Visual Test to
carry out data import efficiently. The material
master currently holds over 40,000 well defined
items out of which, over 90% have been codified by
self.
* Analyzed customizations, carried out procedure
rectification and thorough testing.
* Conducted parallel run for one month.
* Compiled the Inventory and Warehouse management
user manuals, imparted end-user hands-on training.

July 1998 - July 1999 (12 months)
----------------------------------

* Ensured successful live run of the Purchasing and
Service Contracts Management module in ten months.
* Assisted in conducting scoping studies, making gap
analysis, laying down modeling cases.
* Worked closely with team members to evaluate
business requirements, architecture and finalizing
implementation strategies.
* Designed and configured several essential User-
Defined screens with cross-application postings
and validations.
* Designed custom reports.
* Assisted in finalizing cross-application
configuration involving GL, AP, Fixed Asset, Plant
Maintenance, conducted subsequent integration
testing.
* Compiled purchasing user manuals depicting step-
by-step procedures with graphical and screen
representations.

April 1998 - July 1998 (three months)
-------------------------------------

* Attended extensive training program on ERP
implementation for all modules conducted by a
specialized team of experts from Ramco Systems.
* Attended corporate training by NIIT, Calcutta on
SQL Server, SQL, Query Analyzer, SQL Server
profiler, Windows NT, MS Office.

COMMERCIAL FUNCTIONS, May 1996 - April 1998 at NRL
**************************************************

* Responsible for handling of both Indigenous &
Imported purchase during the key refinery project
construction period.
* Placed over 200 purchase orders.
* Independent responsibility in analyzing indents,
creating vendor database, vendor evaluation,
issuing request for quotation, bid evaluation,
price negotiation, placement of orders, post order
follow-up and related activities. Ensured timely
release of payment to vendors.
* Reconciled material requirements furnished by
Engineers India Ltd. (EIL) - refinery project
consultant, and ensured timely receipt of
materials at the project site. There has never
been stock-out situation of any critical item
during my tenure in the Commercial department.
* Compiled the company’s General Purchase
Conditions, Standard Quotation Questionnaire,
Packing, Marking, Shipping and Documentation
Specifications for both indigenous and imported
materials.

PROJECT CONSTRUCTION, Sept. 1994 - May 1996 at NRL
**************************************************

* Worked with EIL in the refinery project execution
& supervision. Handled turnkey contracts like
Water Line Network, Product Tank Fabrication and
Power Plant Erection.
* Delivered desired results under challenging
environmental and labor conditions. Inspected
executed jobs as per strict International
Standards and maintained extensive documentation.

EDUCATION
*********
Bachelor in Mechanical Engineering
1989 to 1993
Gauhati University, Assam, India

Bachelor of Science with major in Physics and minors
in Chemistry, Mathematics.
1987 to 1990
Gauhati University, Assam, India

TECHNICAL
*********

SQL, SQL*Plus, SQL Server, SQL Server Profiler,
Query Analyzer, Enterprise Manager, ORACLE, Report
Writer, MS Visual Test (Developer Studio), Windows
2000 / ME / NT, MS Office.

REFERENCES
**********

Shall be furnished on request.