Download - Turn your IVR into a CRM tool with SAS
![Page 1: Turn your IVR into a CRM tool with SAS](https://reader035.vdocuments.us/reader035/viewer/2022062510/548d7793b47959ac488b47ff/html5/thumbnails/1.jpg)
söndag den 22 juni 2008
LYNX Information Engineering
Automated Call Handling & Routing through SAS
(with a bit of SQL …)
October 2008
Brian Coughlan
![Page 2: Turn your IVR into a CRM tool with SAS](https://reader035.vdocuments.us/reader035/viewer/2022062510/548d7793b47959ac488b47ff/html5/thumbnails/2.jpg)
söndag den 22 juni 2008
LYNX Information Engineering
Contents
• Reasons• JEDI Overview• SAS Detail
– Foundation– Building Blocks– Superstructure
• Outcomes• Key Resources• References
![Page 3: Turn your IVR into a CRM tool with SAS](https://reader035.vdocuments.us/reader035/viewer/2022062510/548d7793b47959ac488b47ff/html5/thumbnails/3.jpg)
söndag den 22 juni 2008
LYNX Information Engineering
• Choice
• Confusion
• Cost
Reasons
![Page 4: Turn your IVR into a CRM tool with SAS](https://reader035.vdocuments.us/reader035/viewer/2022062510/548d7793b47959ac488b47ff/html5/thumbnails/4.jpg)
söndag den 22 juni 2008
LYNX Information Engineering
• Broadband, Narrowband, HomeNetwork
• Orders and MAC codes• Issue or Fault• Cancelled & Confused• Restarts, Spyware,
Vista
More reasons
![Page 5: Turn your IVR into a CRM tool with SAS](https://reader035.vdocuments.us/reader035/viewer/2022062510/548d7793b47959ac488b47ff/html5/thumbnails/5.jpg)
söndag den 22 juni 2008
LYNX Information Engineering
JEDI OverviewORGANISATION DATA CLOUD
BB DETAILNB DETAIL
CRMAVAYA
CUSTOMER INTERACTIONSPHONE NUMBER SOURCES
Daily & Intraday extracts
SAS
Po
pula
tes
rout
ing
look
ups
SQL
Passes CLI, CED, UCID, VDN information
Passes routing information (5 digit VDN)
TELCO CLOUDAVAYA
CCE SERVERCCE SOFTWARE
Overnight
Extraction
of
Telco JEDI Server
interaction
Facilitates Analysis
Improves Call
Match Rate
Ongoing Review and
Analysis
Revie
w of h
andlin
g
and re
solu
tion ra
tes
Review of match
CLI/CED Rates
Routing Changes
Process KnowledgeOperations
Online
Operations input
![Page 6: Turn your IVR into a CRM tool with SAS](https://reader035.vdocuments.us/reader035/viewer/2022062510/548d7793b47959ac488b47ff/html5/thumbnails/6.jpg)
söndag den 22 juni 2008
LYNX Information Engineering
SAS - Foundation
• Base SAS ANALYTICS PRO
• SAS/CONNECT
• SAS/ACC-PC File Formats
• SAS/ACC-ODBC
![Page 7: Turn your IVR into a CRM tool with SAS](https://reader035.vdocuments.us/reader035/viewer/2022062510/548d7793b47959ac488b47ff/html5/thumbnails/7.jpg)
söndag den 22 juni 2008
LYNX Information Engineering
SAS – Building Blocks
– Standardised Modular Macros– General
• ODBC Extractions• FTP Communications• Library Allocations• Sorts & Loads• Email and SMS Alerts
– System Specific• Extractions and Builds• SQL Lookup Table Population• “Drop In Routing” Process
![Page 8: Turn your IVR into a CRM tool with SAS](https://reader035.vdocuments.us/reader035/viewer/2022062510/548d7793b47959ac488b47ff/html5/thumbnails/8.jpg)
söndag den 22 juni 2008
LYNX Information Engineering
SAS – Superstructure
– Daily Scheduled Sequence– Polling– Extractions
• Raw Data Tables in SAS– Phone Number/CLI/CED integration and
standardisation– Informat & Format creation
• Networks• Connectivity • Offers• Service Providers• Order, Account, Service, CLI, CED and Login cross
referencing– Builds
• Snapshot Tables • Criteria to Routing Associations• Lookups
– Loads• Audit Tables in SAS• Lookup Tables on SQL Server
![Page 9: Turn your IVR into a CRM tool with SAS](https://reader035.vdocuments.us/reader035/viewer/2022062510/548d7793b47959ac488b47ff/html5/thumbnails/9.jpg)
söndag den 22 juni 2008
LYNX Information Engineering
Reduced:• Choice• Confusion• Cost
Outcomes
![Page 10: Turn your IVR into a CRM tool with SAS](https://reader035.vdocuments.us/reader035/viewer/2022062510/548d7793b47959ac488b47ff/html5/thumbnails/10.jpg)
söndag den 22 juni 2008
LYNX Information Engineering
Key Resources
– Telecoms Team
– Directors
– Knowledge Team
– Process Team
– Project Team
– Online Help Team
![Page 11: Turn your IVR into a CRM tool with SAS](https://reader035.vdocuments.us/reader035/viewer/2022062510/548d7793b47959ac488b47ff/html5/thumbnails/11.jpg)
söndag den 22 juni 2008
LYNX Information Engineering
![Page 12: Turn your IVR into a CRM tool with SAS](https://reader035.vdocuments.us/reader035/viewer/2022062510/548d7793b47959ac488b47ff/html5/thumbnails/12.jpg)
söndag den 22 juni 2008
LYNX Information Engineering
References• Call Automation - Cost Savings
– http://spotlight.ccir.ed.ac.uk/public_documents/Voice%20white%20paper%20UK.doc– http://www.speechtechmag.com/Articles/Column/Talking-Tech/Speaking-with-One-Voice-31216.aspx– http://ieeexplore.ieee.org/Xplore/login.jsp?url=/iel2/1137/7989/00341553.pdf?tp=&isnumber=&arnumber=341553
• Why too much choice is bad for us– http://www.ted.com/index.php/talks/view/id/93