Case Study - Supply Chain in Utility Client UK
.pptx
School
IIT Kanpur**We aren't endorsed by this school
Course
BUSINESS PPT001
Subject
Information Systems
Date
Dec 20, 2024
Pages
3
Uploaded by SuperMousePerson1227
© 2015 Cognizant Supply Chain of assets management using Qlikview@ British Multinational Utility Company1Key HighlightsBusiness Drivers Supply Chain of assets a complicated system, movement of every asset is stored in SAPEach asset moved multiple times from one storage location to the other within its life cycleCumbersome to manually track the status of each asset for logistic purposesCentricaDashboard = 1No of records ~ 90 MNo of Source System = 3 (Hadoop ISU, Hadoop EWM and External File)Number of Users~15Solution HighlightsQlikview dashboard was chosen to display the volumetric counts of assets at various stagesData was fetched from SAP ISU source systems that generated the source qvdsTransformation file was generated by applying all the business requirements which in turn generated the data modelReports can be viewed in QlikviewBusiness OutcomeEnsured to fix the smart meters/assets onto customer property at the earliest which facilitated huge returns Margin EnhancementCost Reduction and Cost AvoidanceTechnology Stack: Qlikview SR6 11.20 (BI Reporting Tool)|Sap ISU|SAP EWMNumber of QlikView Dashboards – 1KPI’s - 38Number of Users ~ 15Data Size - ~ 90M
© 2015 Cognizant Supply Chain of assets management using Qlikview@ British Multinational Utility Company (2/2)2Challenges FacedSolution DetailsCentricaQlikView Connectivity to source systemNon availability of DataPerformance problemSince the requirement was to show full history data for some KPIs and 2 years data for rest of the KPIs we faced some complexity in building the data model.
© 2015 Cognizant 3Supply Chain of assets management using Qlikview@ British Multinational Utility Company (Addendum – For internal use only)Project DetailsProject start and completion date/ Duration Nov-2014 to till date (12 months), ongoingProject Manager (Onsite/Offshore)/POCs Pennem Satish Portfolio Director - needs to sign off on the case studyKolhatkar, RajivPeak team size4Service line involvedBICOE involvedInvolved during code review onlyOnsite/offshore Ratio1:3Location of the projectStains, ChennaiKey themesQlikview, Program managementAny unique highlights of the projectNot ApplicableClient LoBs/ BU involvedAsset Management, Ops and TriageCentrica