!"#$%&## (%)&**$+&%,& -./
0$%1%,$1* 2&/3$,
5 61#& 2)"78
8uslness lnLelllgence for llnanclal Servlces: A 1echloglx Case SLudy Þage 2
!"#$%&## (%)&**$+&%,& -./ 0$%1%,$1* 2&/3$, 5 61#& 2)"78
Cur cusLomer ls a $23 bllllon revenue subsldlary of a lorLune 30 company. 1hls subsldlary
provldes commerclal flnance Lhrough a varleLy of buslness unlLs.
9:& 6:1**&%+&
Cur cusLomer needed Lo lnLegraLe lLs 8uslness lnLelllgence / uaLa Warehouslng lnlLlaLlves LhaL
had been developed lndependenLly ln seven dlfferenL buslness unlLs. AddlLlonally, a profuslon of
daLa marLs made enLerprlse level analysls of daLa exLremely dlfflculL. Cur cusLomer declded Lo
lnvesL a slngle LnLerprlse uaLa Warehouse bullL on Lhe 1eradaLa plaLform. Powever, Lhe
purchase of 1eradaLa hardware was slmply Lhe flrsL (and easlesL!) sLep ln lmplemenLlng Lhe
LnLerprlse uaLa Warehouse.
9:& 2.*")$.%4
1he pro[ecL was lnlLlaLed wlLh a 4 person modellng Leam whlch lncluded 2 archlLecLs from
1echloglx. uslng Lhe 1eradaLa Loglcal uaLa Model for llnanclal Servlces as a sLarLlng polnL, Lhe
modelers worked on creaLed an enLerprlse represenLaLlon of Lhe llnance Corp's key daLa. As
porLlons of Lhe daLa model were compleLed, addlLlonal L1L resources were added Lo Lhe Leam
Lo lnlLlaLe Lhe loadlng of daLa lnLo Lhe new LuW. 1hls was followed by an a serles of pro[ecLs
whlch lmplemenLed Lhe creaLlon of reporLs ln 8uslness Cb[ecLs whlch dupllcaLed an exlsLlng
Cracle based reporLlng daLa marL. 1hls served Lo valldaLe Lhe model and Lhe reporLs generaLed
from lL.
AfLer Lhls lnlLlal valldaLlon, Lhe Leam worked on addlng addlLlonal funcLlonal areas Lo Lhe daLa
model mosL slgnlflcanLly lncludlng Slebel prospecL daLa. ln parallel a Leam of fronL end
developers worked on 8uslness Cb[ecLs unlverses and reporLs Lo producL end user faclng
reporLlng and analyLlcs.
Cver Llme, Lhe consulLanL Leam mlgraLed from a largely onslLe 1eradaLa Leam Lo subsLanLlally
1echloglx lead Leam wlLh slgnlflcanL developmenL resources offshore. 1he offshore Leam was
lnvolved ln L1L and fronL end developmenL as well as provldlng producLlon supporL and
monlLorlng.
9:& (;")$.%#4 ?.7&*$%+
Some of Lhe key conLrlbuLlons of Lhe 1echloglx Leam ln modellng lncluded:
! Modellng & ArchlLecLure
o Pelped develop LuW roadmap and daLa archlLecLure sLandards wlLh 1eradaLa
ConsulLlng
o Modeled key sub[ecL Areas (ÞarLy, AgreemenL & LvenLs)
8uslness lnLelllgence for llnanclal Servlces: A 1echloglx Case SLudy Þage 3
o LxLended ClLuM reference model Lo lnclude Slebel C8M
! SLandards & SpeclflcaLlons
o key role ln esLabllshlng Modellng sLandards (namlng & Lyplng)
o ueveloped L1L SpeclflcaLlons 1emplaLe for auLomaLed L1L Code generaLlon
o ueveloped deLalled L1L speclflcaLlons for more Lhen 10 source sysLems
! uaLa CuallLy & Model ManagemenL
o Pelped ldenLlfy daLa quallLy lssues and launched uaLa CuallLy lnlLlaLlve
o Managed Lrwln Model MarL
=&8 6.%)/$>")$.%#4 @9A
Some of Lhe key conLrlbuLlons of Lhe 1echloglx Leam ln L1L lncluded:
! ueveloped L1L code uslng boLh lnformaLlca (for pulllng source daLa lnLo sLage) &
1eradaLa 81LC (for pulllng sLage daLa lnLo LuW Core Lables).
! ueveloped L1L rouLlnes for more Lhen 10 source SysLems (Slebel, Workflow, ÞMSvlS,
AC8S, SLraLegy, 8uM, CLCuL & 8LM)
! Pelped wlLh lnformaLlca upgrade from 6.x Lo 7.x. for Þrod, uev and ln1C envlronmenLs
! updaLed lAC1C & CL L1L code Lo conform wlLh LuW SLandards
! Pelped uevelop L1L codlng sLandards
! Pelped uevelop daLa valldaLlon sLandards and developed valldaLlon scrlpLs for varlous
source pulls
=&8 6.%)/$>")$.%#4 0/.%) @%7
Some of Lhe key conLrlbuLlons of Lhe 1echloglx Leam ln lronL Lnd developmenL lncluded:
! 8uslnessCb[ecLs unlverse & 8eporLs
o ueveloped 3 unlverses Lo supporL Lo AnalyLlcs ln C8M/ÞrospecLlng, LnLerprlse
MarkeLlng, 8uslness ConslsLency lnlLlaLlve & llnanclal 8eporLlng
o ueveloped over 100 reporLs ln varlous sub[ecL areas
o upgraded 8C plaLform Lo v6.3.1
! uashboard
o ueveloped uashboard lramework
o ueployed key sales meLrlcs showlng booked deals and plpellne across CLCl
! Web based 8eporLlng
o ueveloped LnLerprlse Sales Compass AppllcaLlon
o ueveloped AAA uaLa 1ool Lo supporL buslness conslsLency lnlLlaLlve
8uslness lnLelllgence for llnanclal Servlces: A 1echloglx Case SLudy Þage 4
9&,:%.*.+8
1he LnLerprlse uaLa Warehouse was developed uslng 1eradaLa, lnformaLlca and 1eradaLa Lools
for L1L and 8uslness Cb[ecLs for reporLlng and fronL-end analysls.
8uslness lnLelllgence for llnanclal Servlces: A 1echloglx Case SLudy Þage 3
!&%&-$)#4
uaLa from four legacy sysLems malnLalned across Lhree dlfferenL reporLlng envlronmenLs was
consolldaLed lnLo a slngle 1eradaLa lnsLance supporLed by 2 8uslnessCb[ecLs unlverses. 1he flrsL
Lwo compleLed pro[ecLs also allowed our cusLomer Lo showcase lLs approach of lnLegraLlng all
enLerprlse daLa lnLo Lhe warehouse and esLabllsh a daLa model foundaLlon Lo be used across Lhe
buslness.
5>.") 9&,:*.+$B
1echloglx ls a global ConsulLlng and l1 Servlces company. WlLh over 300 consulLanLs ln Lhe uS
and Asla, 1echloglx dellvers soluLlons ln seven key pracLlces lncludlng 8ÞM, MasLer uaLa
ManagemenL, 8uslness lnLelllgence, AppllcaLlon lnLegraLlon, Þro[ecL ÞorLfollo ManagemenL,
LnLerprlse AppllcaLlons and SofLware ÞroducL Lnglneerlng. Cur pracLlces areas dellver
breakLhrough buslness value for enLerprlse cusLomers.
6.%)1,)$%+ 9&,:*.+$B
781 933 1846
800 WesL Cummlngs Þark, SLe 4930
Woburn, MA, 01801
bosLon[Lechloglx.com
www.Lechloglx.com
doc_950253800.pdf
0$%1%,$1* 2&/3$,
5 61#& 2)"78
8uslness lnLelllgence for llnanclal Servlces: A 1echloglx Case SLudy Þage 2
!"#$%&## (%)&**$+&%,& -./ 0$%1%,$1* 2&/3$, 5 61#& 2)"78
Cur cusLomer ls a $23 bllllon revenue subsldlary of a lorLune 30 company. 1hls subsldlary
provldes commerclal flnance Lhrough a varleLy of buslness unlLs.
9:& 6:1**&%+&
Cur cusLomer needed Lo lnLegraLe lLs 8uslness lnLelllgence / uaLa Warehouslng lnlLlaLlves LhaL
had been developed lndependenLly ln seven dlfferenL buslness unlLs. AddlLlonally, a profuslon of
daLa marLs made enLerprlse level analysls of daLa exLremely dlfflculL. Cur cusLomer declded Lo
lnvesL a slngle LnLerprlse uaLa Warehouse bullL on Lhe 1eradaLa plaLform. Powever, Lhe
purchase of 1eradaLa hardware was slmply Lhe flrsL (and easlesL!) sLep ln lmplemenLlng Lhe
LnLerprlse uaLa Warehouse.
9:& 2.*")$.%4
1he pro[ecL was lnlLlaLed wlLh a 4 person modellng Leam whlch lncluded 2 archlLecLs from
1echloglx. uslng Lhe 1eradaLa Loglcal uaLa Model for llnanclal Servlces as a sLarLlng polnL, Lhe
modelers worked on creaLed an enLerprlse represenLaLlon of Lhe llnance Corp's key daLa. As
porLlons of Lhe daLa model were compleLed, addlLlonal L1L resources were added Lo Lhe Leam
Lo lnlLlaLe Lhe loadlng of daLa lnLo Lhe new LuW. 1hls was followed by an a serles of pro[ecLs
whlch lmplemenLed Lhe creaLlon of reporLs ln 8uslness Cb[ecLs whlch dupllcaLed an exlsLlng
Cracle based reporLlng daLa marL. 1hls served Lo valldaLe Lhe model and Lhe reporLs generaLed
from lL.
AfLer Lhls lnlLlal valldaLlon, Lhe Leam worked on addlng addlLlonal funcLlonal areas Lo Lhe daLa
model mosL slgnlflcanLly lncludlng Slebel prospecL daLa. ln parallel a Leam of fronL end
developers worked on 8uslness Cb[ecLs unlverses and reporLs Lo producL end user faclng
reporLlng and analyLlcs.
Cver Llme, Lhe consulLanL Leam mlgraLed from a largely onslLe 1eradaLa Leam Lo subsLanLlally
1echloglx lead Leam wlLh slgnlflcanL developmenL resources offshore. 1he offshore Leam was
lnvolved ln L1L and fronL end developmenL as well as provldlng producLlon supporL and
monlLorlng.
9:& (;")$.%#4 ?.7&*$%+
Some of Lhe key conLrlbuLlons of Lhe 1echloglx Leam ln modellng lncluded:
! Modellng & ArchlLecLure
o Pelped develop LuW roadmap and daLa archlLecLure sLandards wlLh 1eradaLa
ConsulLlng
o Modeled key sub[ecL Areas (ÞarLy, AgreemenL & LvenLs)
8uslness lnLelllgence for llnanclal Servlces: A 1echloglx Case SLudy Þage 3
o LxLended ClLuM reference model Lo lnclude Slebel C8M
! SLandards & SpeclflcaLlons
o key role ln esLabllshlng Modellng sLandards (namlng & Lyplng)
o ueveloped L1L SpeclflcaLlons 1emplaLe for auLomaLed L1L Code generaLlon
o ueveloped deLalled L1L speclflcaLlons for more Lhen 10 source sysLems
! uaLa CuallLy & Model ManagemenL
o Pelped ldenLlfy daLa quallLy lssues and launched uaLa CuallLy lnlLlaLlve
o Managed Lrwln Model MarL
=&8 6.%)/$>")$.%#4 @9A
Some of Lhe key conLrlbuLlons of Lhe 1echloglx Leam ln L1L lncluded:
! ueveloped L1L code uslng boLh lnformaLlca (for pulllng source daLa lnLo sLage) &
1eradaLa 81LC (for pulllng sLage daLa lnLo LuW Core Lables).
! ueveloped L1L rouLlnes for more Lhen 10 source SysLems (Slebel, Workflow, ÞMSvlS,
AC8S, SLraLegy, 8uM, CLCuL & 8LM)
! Pelped wlLh lnformaLlca upgrade from 6.x Lo 7.x. for Þrod, uev and ln1C envlronmenLs
! updaLed lAC1C & CL L1L code Lo conform wlLh LuW SLandards
! Pelped uevelop L1L codlng sLandards
! Pelped uevelop daLa valldaLlon sLandards and developed valldaLlon scrlpLs for varlous
source pulls
=&8 6.%)/$>")$.%#4 0/.%) @%7
Some of Lhe key conLrlbuLlons of Lhe 1echloglx Leam ln lronL Lnd developmenL lncluded:
! 8uslnessCb[ecLs unlverse & 8eporLs
o ueveloped 3 unlverses Lo supporL Lo AnalyLlcs ln C8M/ÞrospecLlng, LnLerprlse
MarkeLlng, 8uslness ConslsLency lnlLlaLlve & llnanclal 8eporLlng
o ueveloped over 100 reporLs ln varlous sub[ecL areas
o upgraded 8C plaLform Lo v6.3.1
! uashboard
o ueveloped uashboard lramework
o ueployed key sales meLrlcs showlng booked deals and plpellne across CLCl
! Web based 8eporLlng
o ueveloped LnLerprlse Sales Compass AppllcaLlon
o ueveloped AAA uaLa 1ool Lo supporL buslness conslsLency lnlLlaLlve
8uslness lnLelllgence for llnanclal Servlces: A 1echloglx Case SLudy Þage 4
9&,:%.*.+8
1he LnLerprlse uaLa Warehouse was developed uslng 1eradaLa, lnformaLlca and 1eradaLa Lools
for L1L and 8uslness Cb[ecLs for reporLlng and fronL-end analysls.
8uslness lnLelllgence for llnanclal Servlces: A 1echloglx Case SLudy Þage 3
!&%&-$)#4
uaLa from four legacy sysLems malnLalned across Lhree dlfferenL reporLlng envlronmenLs was
consolldaLed lnLo a slngle 1eradaLa lnsLance supporLed by 2 8uslnessCb[ecLs unlverses. 1he flrsL
Lwo compleLed pro[ecLs also allowed our cusLomer Lo showcase lLs approach of lnLegraLlng all
enLerprlse daLa lnLo Lhe warehouse and esLabllsh a daLa model foundaLlon Lo be used across Lhe
buslness.
5>.") 9&,:*.+$B
1echloglx ls a global ConsulLlng and l1 Servlces company. WlLh over 300 consulLanLs ln Lhe uS
and Asla, 1echloglx dellvers soluLlons ln seven key pracLlces lncludlng 8ÞM, MasLer uaLa
ManagemenL, 8uslness lnLelllgence, AppllcaLlon lnLegraLlon, Þro[ecL ÞorLfollo ManagemenL,
LnLerprlse AppllcaLlons and SofLware ÞroducL Lnglneerlng. Cur pracLlces areas dellver
breakLhrough buslness value for enLerprlse cusLomers.
6.%)1,)$%+ 9&,:*.+$B
781 933 1846
800 WesL Cummlngs Þark, SLe 4930
Woburn, MA, 01801
bosLon[Lechloglx.com
www.Lechloglx.com
doc_950253800.pdf