Transcript Northwestern Mutual - Enterprise Content Management

Northwestern Mutual:
Providing Content
Services to the Enterprise
Michael Grimes
I.S. Consultant
Enterprise Content Management
Competency Center
Agenda








Background
Challenge
Solution options
Enterprise Document Management Service
Benefits
Lessons Learned
Next steps
Other Documentum Solutions at
Northwestern Mutual
 Questions
Northwestern Mutual





Northwestern Mutual is the leading direct provider of
individual life insurance in United States
Northwestern Mutual receives the highest possible ratings
for financial strength from all four major financial ratings
agencies
As a mutual company, Northwestern Mutual leads its
industry in dividends and expects to pay a record $3.77
billion in dividends to participating policyowners in 2004
Northwestern Mutual has more than:
– 3 million policyowners and clients
– $16 billion in annual revenues
– $113 billion in assets
Headquarters are in Milwaukee, Wisconsin
Northwestern Mutual Financial Network
 The Northwestern Mutual Financial Network is
the marketing name for the company's sales and
distribution arm
 The Network has 350 offices and 7,900
representatives across the United States
 Representatives have access to a network of
specialists who together provide advice on:
– Asset & Income Protection
–
–
–
–
–
–
–
–
Personal Planning
Education Funding
Business Planning
Investment Services
Estate Planning
Trust Services
Employee & Executive Benefits
Retirement Solutions
Challenge
 Entering 2003, Northwestern Mutual had
only implemented a couple of
Documentum solutions
– Documentum Desktop interface
– Captiva Software’s InputAccel
 Three large corporate projects got
funded in 2003 which require
Documentum to be integrated with Line
of Business (LOB) applications
– No experience integrating Documentum
into LOB applications!
Project #1 - Requirements Ordering
Service System
 This project implemented a scanning and
ordering system for Attending Physician
Statements (APS) and eliminated redundant
data entry by automatically retrieving data
from existing systems.
 The new system required a solution that
allowed them to image and electronically
store Medical Authorization documentation
which would be electronically transmitted to
vendors for processing.
 ~300 users with a 90 day retention period for
documents
Project #2 – Disability Income
Processing Platform
 Managing disability claims is a critical function
for our company and the Disability Income
Benefits processing and service systems were
out of date and not poised to meet future
service demands.
 The new system required a solution that
allowed them to electronically store case and
claim documentation.
– Letters sent to the insured
– Completed forms received from the insured
through fax and mail
– Details of telephonic conversations related to
the case
– Any other notes related to a case.
 ~250 users
Project #3 – Franklin Workflow E-Files
 In 2002, Northwestern Mutual announced a major
expansion program to build an additional campus in
Franklin, a suburb of Milwaukee
 Three business areas relocated to the new campus
– Represented almost 15% of the Home Office
organization
 In the existing environment, most of the file
documentation used for underwriting resided in paper
format.
 If only paper remained after the move to Franklin, the
existing service level goals would be compromised.
 The system required a solution that electronically
captured and stored documents that would be need
by underwriting areas at both locations.
 ~600 users / ~800GB of content per year
Application Infrastructure
 All three solutions would be Javabased web applications running on
IBM WebSphere
 Client interface would be through
Internet Explorer
 Content would consist mostly of
images stored in PDF format
– Adobe Reader and Acrobat Standard
Documentum Infrastructure
 Documentum 4i Content Server (v4.2.8)
– Application Server
• HPUX 11.00
• HP9000 N4000-55 server
• 8 CPUs / 16GB of memory
– Sybase Database Server
• HPUX 11i
• HP9000 rp8400-16 server
• 8 CPUs / 16GB of memory
– Storage
• Network Appliance FAS960c
• 24 TB
• SnapLock Compliance software (WORM)
 Documentum Foundation Classes (v4.2.8)
– Network Appliance's Filer
• Network Addressable Storage (NAS)
• Mounted on multiple servers
Solution Options for Documentum
Interface
 Desktop
– Projects required Internet Explorer interface
 Webtop
– Projects wanted custom interface /
experience
– Integration with LOB applications
 WDK or direct Documentum Foundation
Classes (DFC) calls
– Engineers wanted to insulate applications
from Documentum-specific components and
API calls
 Internally develop “Service”
– Methodology had precedent within company
for data access and email integration
Enterprise Document Management
Service (EDMS)
 Java program which provides a
“wrapper” around the Documentum
DFC
 MQ Series-based communication
 Java “proxy” available for applications
 Client interfaces
– MQ Series / XML
– Java objects
Services provided by EDMS








AddCustomFolder
AddFolder
AddDocument
CheckInDocument
CopyDocument
CopyMoveFolderAllVersions
CopyMoveDocListAllVersions
DeleteDocument

GetCurrentDocument







GetDocument
GetDocumentList
GetDocumentListQuery
ModifyFolderAccess
UndoCheckOut
UpdateAttributes
UpdateAttributesQuery
<AddDocumentRequest nml-type="Structure" nml-version="001">
. . . . . .
<OperatorNam nml-type="String">di_monitor</OperatorNam>
<DocTypeTxt nml-type="String">di_correspondence</DocTypeTxt>
<CreateFolderInd nml-type="String">Y</CreateFolderInd>
<FolderPathNam nml-type="String">/DI BENEFITS/CASE/0000877388</FolderPathNam>
. . . . . .
<Attributes nml-type="Array">
<object_name nml-length="10" nml-type="String">Preliminary
Notice</object_name>
<di_title nml-length="10" nml-type="String">Preliminary Notice</di_title>
<authors nml-length="10" nml-type="String">Sachin</authors>
<dept_div_cde nml-length="10" nml-type="String">DIB</dept_div_cde>
<di_doc_status_cde nml-length="10" nml-type="Number">1</di_doc_status_cde>
<case_num nml-length="10" nml-type="String">0000877388</case_num>
<online_doc_ind nml-length="10" nml-type="Number">1</online_doc_ind>
<significant_ind nml-length="10" nml-type="Number">0</significant_ind>
<doc_type_cde nml-length="10" nml-type="Number">4</doc_type_cde>
<commun_mode nml-length="10" nml-type="Number">0</commun_mode>
<intrnl_pro_doc_ind nml-length="10" nmltype="Number">1</intrnl_pro_doc_ind>
<owner_create_dte nml-dateformat="MMDDYYWithSlash" nmltype="Date">05/14/2004 09:28:04:349</owner_create_dte>
<prim_doc_catg_cde nml-length="10" nml-type="Number">1</prim_doc_catg_cde>
</Attributes>
<ACLNam nml-type="String"></ACLNam>
</AddDocumentRequest>
<GetCurrentDocumentRequest nml-type="Structure"
nml-version="001">
. . . . . .
<OperatorNam nml-type="String">lep03</OperatorNam>
<FolderPathNam nml-type="String">/New
Business/Policy/</FolderPathNam>
<DocumentId nmltype="String">090060ed801011fc</DocumentId>
<DocTypeTxt nml-type="String"> nb_document
</DocTypeTxt>
<URI nmltype="String">file://NAS/directory/data/nb/view/P
ersonal_History_Interview_08_27_2004_15_07_22_zIY
vk9sP6_ZhSJNQvBYDXkI_1093961689360.pdf</URI>
. . . . . . .
<DocCheckOutInd nmltype="String">N</DocCheckOutInd>
</GetCurrentDocumentRequest>
Enterprise Document Management
Service – Technical Design
 Enterprise frameworks and class libraries
– Written in Java for use within Northwestern
Mutual business application software
– Core frameworks and libraries provide:
•
•
•
•
•
base data types
string utilities
file utilities
XML parser
data structure framework for mapping objects to
strings/XML
• application logging/tracing facilities
• application .ini framework classes
– Object-oriented abstraction of queue-based
messaging systems (MQ Series)
Enterprise Document Management
Service – Technical Design
 Customized dm_check_password to
support single sign-on
 Run multiple JVM instances of the service
– Multi-threaded
– Runs from Network Appliance's Filer which
is mounted on multiple servers
 Two different methods of execution:
– Online access
– Batch processing
• Instance is tuned for large batch processing of
documents
• Does not interfere with online performance
• Does not wait for reply
Document Management System Retriever
Application Document List
This screen displays all the documents associated with an application. The
search feature can be used to fetch documents for a specific policy number,
insured name, etc..
Benefits
 Lower costs for DFC upgrades /
changes
 Insulates project / support teams from
DFC knowledge
 Lower development costs for future
projects
 Isolates Documentum code and
infrastructure from client applications
– EDMS is fairly portable
Lessons Learned
 Aggressive approach when considering our
Documentum experience
– Tried to run before we knew how to walk
 Performance tuning
– Created indexes
– Modified client connections
– Separated batch processing
 Managing shared infrastructure
 Manage DFC versions better
 Maintaining dm_check_password
Next steps
 Support upgrade of Content Server to 5.2.5
SP2
 Upgrade to DFC 5.2.5 SP2
 Support migration of Content Server to AIX
/ DB2
 Maintain performance
 Enhancements
– XML processing
– Session pooling
– Remove application / Docbase references
Other Documentum Solutions at
Northwestern Mutual
 Enterprise Resource Library
– Managing large manuals in XML format presented
through FAST’s (formerly NextPage’s) NXT web
publishing solution
 Trust Services
– Office document management (Word, Excel,
PowerPoint, Images) with Documentum Desktop
 Private Placements
– Imaging (InputAccel) deal documentation for online
reference
 Customer Identification Program (CIP)
– Compliance solution storing XML content on Network
Appliance’s SnapLock (WORM) technology
– Utilizes EDMS Service
 Payroll
– Imaging (QuickScan Pro) employee payroll
documentation
Organization
 Enterprise Content Management
Competency Center
 Content Management Infrastructure
Team
 Engineering Competency Center
Summary
 Decided to “wrap” the DFC to insolate
applications
 Supports single sign-on
 Upgrades of DFC more manageable
 Costs for future Documentum
projects have been reduced
Questions
Michael Grimes
Northwestern Mutual - I.S. Consultant
Voice: (414) 665-5095
E-Mail: [email protected]