ChelanCountyPUD

CIMasSolu3onforFutureIntegra3onatChelanCountyPUD

AboutChelanCountyPUD

•  CustomerOwnedPublicU4lityLocatedinthecenterofWashingtonState

•  OperateThreeHydroElectricProjectsontheColumbiaRiverTotalingJustUnder2,000MWofGenera4ngCapacity

•  ProvidePower,Water,WasteWater,andHighSpeedFiberInternetServicestoroughly50,000Residen4alCustomers

•  AsaU4litywedon’tdoalotofanythingbutdoaliOlebitofeverything

ITSystems

•  MaximoAssetManagement•  PeopleSoQFinancials/HR•  PrimaveraProjectPlanning•  OSIsoQPISystems(SCADAData)•  Sun-NetTOA(OutageManagement)•  CustominhousesystemsforOpera4onalLoggingand

ManagementoftheFiberNetwork.

StateofIntegra3onsCustomer

Information&Billing

AssetManagement

AssetRisk&Health

MobileWorkforce

OutageManagement

SmartMetering

RealTimeMeasurement

(SCADA)

WorkManagement

Analytics

WhywelookedtotheCIM

•  Exis4ngpointtopointintegra4onsaredifficulttomaintain•  Lackofdocumenta4onmakesupgradeschallenging•  Ques4onsaboutdataintegrityaredifficultorimpossibleto

answer•  Morethanoneversionofthetruthdependingonwhich

systemyouareviewing•  Expec4ngmajorsoQwareupgradesoverthenextfewyears

Wherewewouldliketobe

SemanticIntegration

CustomerInformation&

Billing

AssetManagement

AssetRisk&Health

MobileWorkforce

OutageManagement

SmartMetering

RealTimeMeasurement

(SCADA)

WorkManagement

Analytics IndustryStandards

PilotProject

•  ITlikedtheideaofanEnterpriseServiceBus•  WefelttheCIMwouldgiveusaheadstartandallowustodevelop

toastandard•  ManagementwasnotyetconvincedoftheneedforanESBandwas

worriedthatimplemen4ngsuchalargeprojectcouldslowdevelopment

•  WedecidedtotakeonasmallPilotprojecttoproveouttheconcepts

Genera3onOutagePlanning

•  Planedoutagesarescheduledandstoredinathirdpartydatabase•  Actualoutagesarealsoeventuallyenteredintothatdatabase•  Opera4onsusestheschedulestoplantheirwork•  PowerMarke4ngusestheschedulestopredictgenera4on•  Actualoutagesandcausesmustbereportedtoanumberof

agencies•  Significanteffortwasbeingmadetokeeptheschedulesaccurate

andtotrueupactualdatabeforepublishingreports

FirstSteps

•  Beganmee4ngwithsubjectmaOerexpertstodocumentcurrentBusinessmodelinEASparx

•  Wedocumentedtheen4reprocessofhowanoutageisini4allyplanned,enteredintoTOA,updated,andreported

•  Foranumberofpeoplecloselyinvolvedwithoutagemanagementthiswasthefirst4meseeingtheen4reprocessend-to-end

•  Thisstepimprovedmanagerbyinsignificantly

WithrequirementsgatheredwebeganexploringtheCIM

•  Iden4fiedallrelevantdatapointsinrequirements•  FoundmatchingfieldsintheCIMmodel•  ExpandedtheCIMforafewmissingfields,mostlyrelatedto

ourrepor4ngrequirements•  GeneratedDDLfromourextendedCIMmodeltobuildour

database

Implementa3on

•  WiththedatabaseinplaceweplannedandimplementedanETLprocessfromthesourcesystems

•  TheETLprocessisalldocumentinEASparx•  Wethendesignedananaly4clayerandbeganprovidingupto

theminutereportsthathadpreviouslyrequireddaysofmanualworktoprovide

LessonsLearned

•  Businessprocessmodelingwashugelyimportanttomanagementbuyin

•  Thear4factsproducedhavebeenusefultoITandtoOpera4ons•  TheCIMprovidedasolidbaseandwaseasilyextended•  Whilethisapproachrequiredmoreworkupfrontthansimply

repor4ngdirectlyfromthesourcedatasystem,itreallydidn’tslowusdownmuch

•  Managementhasbeenhappywiththeresultsandweexpecttocon4nueworkingwiththeCIM