Sysco : ERP Implementation Good things come from Sysco Pr es ent edBy, Che r r yJ os e-3 0 0 7 73 3 7 3 Shahadat-300718941 Sa t he e s hFr a nc i s-3 0 07 6 59 1 6
Background information about SYSC •
•
•
•
•
•
S YS CO i samu mul t i bi l l i ondol l a rf ooddi s t r i but i onc o mp mpa ny , ba s e di nHous t on,T e xa s . CanadaandUni t edSt at esar et het woma mai nc ount r i eswher eSYSCO obt ai nand di s t r i but e sf ood, f oodpr oduc t sa ndf oods e r vi c e s . Theb as i cc us t o me me r sf orS YS CO a r er e s t a ur a nt swhi c hi sa bo ut4 0 0 , 0 0 0i nc l udi ngwe we l l kno wn wnr e t a i lc ha i nsl i keChi l i ' sa ndWe ndy' st oi ndi vi dua l l yowne dr e s t a ur a nt s . Ov e rt wot hi r dso ft he i rc us t ome r sa r er e s t a ur a nt s . I n2 00 9t h e i rr e v e nue swe r e $ 3 6 , 8 5 3 . 3mi mi l l i o n, pl a c i ngt he m numb e r5 5i nr e v e nue si nt heF or t une5 0 0 ,upf r o m 2 0 0 6wh whe nt he ywe we r e6 5 t hi nt hec o mp mpe t i t i o n. S YS CO us e st heda t awa wa r e hous ea ndbus i ne s si nt e l l i ge nc ec a pa bi l i t i e st oi nt e gr a t e wi t hc us t o me me r si ns u ppl yc ha i na ndi mpr o vei ns i ght si nt oc us t ome rs a l e s . Thi sb us i ne s si nt e l l i ge nc ec o me me sa sapa r toft hee nt e r pr i s er e s o ur c epl a nni ng s ys t ems msi mpl eme ment edt hr oughouti nSYSCO.
Problem Statement •
•
•
S YS COi sh i g hl yde c e nt r a l i z e d, wi t ha l mo s t2 0 0c om mp pa ni e sa nd di s t r i but i onc ent e r s . Co ns i s t e ntwi t hb e i ngi nde pe nde ntb us i ne s suni t s , S YS COdo e sno tdo a l li t st r a ns a c t i onpr oc e s s i ngi nac e nt r a ll oc a t i on, nordoa l lS YSCO c o mp mpa ni e sc ur r e nt l yha v et hes a me mei ns t a nt i a t i onoft hes a me mee nt e r pr i s e r e s o ur c epl a nni ngs ys t e m m. . Unt i lr e c e nt l y , a ppa r e nt l yi ndi vi dua lc o mp mpa ni e sc oul dc hoos et he i ro w wn n s y s t e ms msa nda r t i f a c t st os uppor tt hos es ys t e ms ms . Asar e s ul t , t he r ewe r eno c ommona r t i f a c t s , s uc ha sve ndorl i s t s , c us t ome rl i s t sorc ha r t sof a c c ount s .
Customer Ser!ice "anagement
#se Case $iagram
Employee "anagement
%R" & #se Case $iagram
Sales "anagement
#se Case
"arketing "anagement
"arketing "anagement & #se Case
Business Intelligence •
•
Thet e r m“ bus i ne s si nt e l l i g e nc e ”( BI )a ppa r e nt l ywa si nv e nt e db yt he Ga r t ne rGr oupi n1 9 8 9( e . g. ,La wt wt on2 0 0 6) . Hi s t or i c a l l y ,BIwa sonl yf ort het e c hnol ogi c a l l ys ophi s t i c a t e d, s i nc e us e r swo ul dha v ene e de dt owr wr i t et he i ro wn wnda t a b as eque r i e s , o r de v e l o pt he i ro wn wnpr e di c t i onmo de l s , e t c .
Ho we we v e r ,i nc r e a s i ngl y , BIi sbe c omi ngea s i e rt ous e , a smo mor e c a pa bi l i t i e sa r ebundl e di nt ot hes of t wa r e , a ndt he r ei saf oc uso n br oadl yus i ngBIt os uppor tor gani zat i onde c i s i onmaki ng. •
•
•
Da t awa wa r e hous i nga ndbus i ne s si nt e l l i ge nc eul t i ma t e l ya r et i ght l y i nt e gr a t e d( e . g. ,Wa t s o na ndWi x om 2 0 0 7) . Some mear guet hateveni ft her ewa wasnodat awa war ehous emo model ,i nor der t ous eBI , as e ma ma nt i cmo mo de ll i k et ha tde v e l o pe df o rada t awa wa r e ho us e de s i g ne dt oa g gr e g a t eo rs t o r eda t awo wo ul dne e dt ob ede v e l o pe d.
•
Rec omm mmendoneormor eoft hes t r at egi es .
•
S umma r i z et her e s ul t si ft hi ngsgoa spr o po s e d.
•
Whatt odonex t .
•
I de nt i f ya c t i oni t e ms ms .
ne 'ink : $ata (arehouse )ccess •
•
•
•
S YS CO sOne Li nkpr o vi de sus e rf r i e ndl ya c c e s st oda t awa r e ho us es a l e s b a s e d i nf or ma t i oni nt e r na l l ya ndt oc us t ome r st hr ougha c c e s st oada t awa wa r e hous e ‟
Aque r ywi z a r dt ha the l psus e r sf or mul a t eque r i e sf ora c c e s s i ngt he i rda t awa wa r e hous e i nf or ma ma t i on. Asar e s ul t ,no tonl ydoe sS YS COs uppl ys pe c i ficf oodpr oduc t sa n ds e r vi c e s , butt he ya l s o l i nkt he i rc us t ome r swi wi t hi nf or ma t i ont ha tc a nhe l pt he m be t t e runde r s t a ndt he i rb us i ne s s . Asar e s ul t ,c us t ome r sc a na c c e s ss uppl yc h ai ni nf or ma t i o na boutt he i rS YS COpur c h as e s , a c c or di ngl y , t he ya r epr o vi de dwi t hada t awa wa r e hous eofi nf or ma t i ont ha tt he yc a nus et o a na l yz et he i ro wn wnpur c h as e s .
F ur t he r , i nf or ma t i o nc a nbedo wn wnl oa de dt oe x c e l wor ks he e t ss ot ha tc us t ome r sc a nbe t t e r unde r s t a nda nda na l yz eda t aus i ngt o ol swi t hwhi c ht he ya r ec o mf mf or t a bl e . Thi sa ppr o ac h br e aksa wa yf r om t het r adi t i onalappr oac he swhi c honl yl e t st hec ompanyge ne r at i ngt he da t a ba s ea c c e s sa ndus et heda t a . •
E*ample : +yndham %otels •
•
•
Wyndham Hot el sc angener at ei nf or mat i onaboutwhi c hSYSCO pr oduc t st heybuy , f r om whi c hSYSCOc omp mpany , andwhomanuf ac t ur es t hepr oduc t . I npa r t i c ul a r ,i nf or ma t i ona va i l a bl ef r om t heda t awa wa r e hous ei nc l ude sa numb e ro fdi me ns i o ns , i nc l udi ng“ c us t o me me r ”( gr o upna me meo rs t o r e na m me e ) , “ t i me ”( e . g. , y e ar ) , “ m me e a s ur e s ”( e . g. , pr i c e ) , S YS COc o mp mpa ny( b y c o mp mpa nynumbe r ) , i t e m( e . g. , i t e m numbe r )a ndo t he r s . Cus t ome mer ss i mpl yc hoos eandc omp mput eb ydi mens i on. Wyndham Hot el s c a nus et hi si nf or ma t i ont obe t t e runde r s t a ndt he i rpur c ha s e s , whi l e S YS COc a ng e ne r a t eac us t o me me rpr o fil eo fpur c ha s e s . Thus , t hes y s t e m pr o vi de sbus i ne s si ns i ght s , notonl yt oS YS CO,buta l s ot ot he i r c us t ome r s .
,uery +i-ard.s )pproach •
Re po r ti t e ms ms
ofi nt e r e s ta r ec hos e n
,uery +i-ard.s )pproach •
Some meoft hedr opdown wnmenusf ort he di ffe r e nti t e m ms sa r epr e s e nt e d. Us e r st he n c hos et hepa r t i c ul a ra t t r i but e st ha tt he ya r e i nt e r es t e di n.
,uery +i-ard.s )pproach Thepa r t i c ul a rs or t sa nd“ s e c t i onbr e a ks ” ( e . g. , byc us t ome r so rpr oduc t s )a r ec h os e n byt heus e r . •
Business Intelligence Implementation •
•
•
•
Ul t i ma t e l y , S YS CO sb us i ne s si nt e l l i g e nc ei mpl e me me nt a t i o nl o ade dt woy e a r so fda t at o s uppor t3 5di ffe r e nta na l yt i cme me a s ur e s , i nt hef or m of1t e r a byt eofda t a . ‟
S i xwe we e k swe r et a ke nt oc h oos ea ndde finet hea na l yt i cme me a s ur e s ,us i ng3j oi ntde s i gn s e s s i ons . Thei mpl e m me e nt a t i ont ookr oughl ys e v e nmont hst ode l i v e rb us i ne s si nt e l l i g e nc ei na hi gha va i l a bi l i t ye nvi r onme ntt or oughl y2 00 0us e r s . S YS CObus i ne s si nt e l l i g e nc ei mpl e me me nt a t i o na sha v i ngt hr e epha s e s : de fini ngand de s i gni ngt hebus i ne s sc o nt e nt , pr e pa r i nga ndbui l di nga na l yt i c sa ndde pl o yme nt
Implementation E/ects •
1 .Cr e at es t r a t e gi cc ompe t i t i vea dva nt a ge
2 .Opt i mi z et hec o r ebus i ne s sb yr e duc i ngc ompl e x i t y , r e dunda nc ya ndi ne ffic ffic i e nc yof bus i ne s spr oc e s s e sands uppor t i ngt e c hnol ogi e s •
•
3 .Ope r a t easas e aml e s ss i ngl ec ol l a bor a t i veent i t y
•
4 .Re de finet hec us t ome re x pe r i e nc et of ur t he rdi ffe r e nt i a t eourpr oduc t sa nds e r vi c e s
•
5 .I mpl e me me ntpr o c e s s e sa ndt e c hno l ogyt oe na bl ef ut ur eb us i ne s sgr o wt wt h
0hank You 1 ,uestions2 •
•
•
•
•
Re f e r e n c e s
Ande r s onLe hma n, R. , Wa t s o n, H. , Wi x om,B. , “ Co nt i ne nt a lAi r l i ne sF l i e s Hi ghwi t hRe a lTi meBus i ne s sI nt e l l i g e nc e , ”2 00 4 ,Ma na g e me me nt I nf o r ma ma t i o nS ys t e ms msQua r t e r l yEx e c ut i v e ,Vo l ume3 , Numb e r4 , pp.1 6 3 1 7 6 . Ber nar dSands , “Comp mpanyPr ofil e: SYSCOCorpor at i on, 2006, ht t p: //www. ber nar ds ands . c om/ m/pdf /Samp mpl ePi . pdf Ca r r i g ,K. , “ Le v e r a g i ngHu Huma nCa pi t a l , ”S YS COCo r po r a t i o n, 2 0 0 5 Ana l ys tF i e l dTr i p, Unpubl i s h e dpr e s e nt a t i onma det oBe a r sS t e a r ns , 2 0 05 . T a y l o r ,B. , “ Cus t o me me ra ndPr o duc tAna l yt i c sa tS YS CO, ”No No v e mb mb e r2 0 0 3 , Bus i ne s sObj e c t s2 0 0 3I nt e r na t i ona lUs e rConf e r e nc e
