1
Oracle Utilities
Work & Asset Management
(WAM)
We dont transact, we cooperate
www.vayamtech.com
January 29, 2015
What Is Work & Asset Management (WAM) ?
Oracle Utilities Work and Asset Management is a leading asset, work, and supply chain
management application that provide features and functionality to support mission-critical
functions, including:
Asset Management.
Work Management .
Inventory Control.
Purchasing.
www.vayamtech.com
January 29, 2015
Benefits of WAM
For Purchasing
Check PO status and track PO records.
Identify pre defined vendors and their details.
Complete track of material required date in case of LD clause .
Identify required stock quantity & cross check with store room inventory quantity in order
to avoid duplicacy .
Historical rate trends for effective negotiation.
www.vayamtech.com
January 29, 2015
Benefits of WAM
For Assets
Track all the assets records with their location , user name/user department &designation.
Maintain records of an asset like serial no., make, warranty, depreciation, life served etc.
Hold all the details of work order raised on an asset till date.
Maintain the complete ledger record of all assets & generate report for same.
www.vayamtech.com
January 29, 2015
WAM Functionality
Requisition.
Purchase Order.
Service Request.
Work Order.
Asset Creation.
Stock Inventory.
Inventory Issue.
www.vayamtech.com
January 29, 2015
Approach Adopted
System Requirement Study
Preparation of AS-IS document for sign-off
Configuration and Testing in Test Environment
Asset data Captured and uploaded for IT & Electrical as planned
Training conducted for key users & end-users of Vidyut Bhawan
Work completed
All Electrical and IT Requirements are mapped into
the system provided by NDMC.
Civil requirements are mapped into the system and
POC shown to the concerned department.
Data migration completed
Rolled-out at IT Department on 24th June,2011
Rolled-out at Vidyut Bhawan on 23rd Sep,2011
Current Status Report Of WAM
WAM Status Report Details
WAM Functionality Covered as per NDMC processes
WAM Reports Details
Data Status Details
Detailed Data Status Details
www.vayamtech.com
January 29, 2015
Thanks
www.vayamtech.com
January 29, 2015
WAM STATUS REPORT
AS ON: 19 Sep 2011
Sr.No. Activity
Description
Current Status
Remark
To Be Signed
Submitted on Apr,2010 to Director IT
with deemed acceptance
Submitted to NDMC with deemed acceptance, if
NDMC did't reply within a week , then It will be
consider as approved document.
To Be Signed
Submitted to Director IT with deemed
acceptance
A System Configuration Document captures the final state of configuration of the
system being validated.
Submitted to NDMC with deemed acceptance, if
NDMC did't reply within a week , then It will be
consider as approved document.
To Be Signed
Submitted to Director IT
As-Is Document
Document studying the business process of the client
To Be Document
Analysis is going to show the Application implementation structure for configuration
for the clients business rocess
Configuration Document
Dependencies on NDMC
Submitted to NDMC with deemed acceptance, if
NDMC did't reply within a week , then It will be
consider as approved document.
IT Process
4
Test cases mapping
IT Process Mapped for actual working process and shown demo to Director IT
Was To be Approve by NDMC (Dir IT)
In words Accepeted by Dir IT
Accepted then go for Demo
General DEMO
Complete IT Demo Shown to Secretary, FA, Director-IT, DD
Was To be Approve by NDMC (Dir IT)
In words Accepeted by Dir IT
Accepted then go for production
Report Customization
Report customization for IT process
Format was to be Provide By Client
Customized as per requirements
Accepeted By Client
Assets Capturing
All the IT Assets captured in WAM
Data was to be provided by NDMC in soft copies
Cleaned & Mapped the data provided by client
time to time
Stock Inventory
All the stock item from IT store captured in WAM
Data was to be provided by NDMC in soft copies
Mapped the data provided by client
User Training & Mannual
Training provided to IT Dept. Staff
User finalisation and releasing them for training &
Infrastructure
Completed
10
Presentation
Completed and Shown to Director IT
11
Go Live
June 17, 2011
Servers with backup & Networking at user ends.
On Production
Mapped (Successfully import data in
production server as provided by IT
Dept)
Mapped (Successfully import data in
production server as provided by IT
Dept)
User Training conducted in May-June
2011
Completed
First PO generated on June 24, 2011
Electrical Process
12
Test cases mapping
Actual case mapping completed
Was To be approved by client
In words Accepeted by Electrical Deppt.
Accepted then go for Demo
13
General DEMO
General WAM demo shown to EXEN,AEE,JEE of Electrical stores department.
Was To be approved by client
In words Accepeted by Electrical Deppt.
Accepted then go for production on 11
Oct, 2010.
14
Report Customization
Report customization for Electrical completed
Format was to be Provided By Client
Customized as per requirements
Data was to be provided by NDMC in soft copies
1) Cleaned & Mapped the data provided by client
(mostly in hard copies)
1. Master Data Template sumbitted on
2) Even Mapped data through Physical
31Aug,2010
2. Mapped
Verfication & by noteing down from there
Data Sumbitted for verification on
conventional registers. (Successfully import data 25Mar, 2011.
in production server)
Data was to be provided by NDMC in soft copies
Mapped the Inventory from hard copeis as
Mapped (Successfully import data in
provided (Successfully import data in production
production server)
server)
33/66 KV Substation's Assets
11 KV Maintenance South Division -I Substation Assets
15
Assets Capturing
11 KV Maintenance South Division -II Substation Assets
11 KV Maintenance North Division Substation Assets
Distribution North and South
Road Lighting, Energy Meter and Water Meter
BM I and BM II
16
17
18
Stock Inventory
User Training & Mannual
Go Live
All the stock item from Electrical Store -I & II captured in WAM
User training for Electrical Department
Ready for Go-Live since May 13, 2011
User finalisation and releasing them for training &
Infrastructure
Three times user training conducted
1. UAT letter requested on 11 Oct,
2010
2. User
Training from 10 to 13 May, 2011 (69
Users Participated)
3. WAM Training from specialized
person from 9 to 12 Aug, 2011
Servers with backup & Networking at user ends.
Waiting for infrastructure readiness from last 4
months
1. Suggest the locations for
Infrastructure readiness on 15 Mar,
2011
2. Submit
letter for Launch of Production
Enviornent on 03 June, 2011
