BAR360 ENGAGEMENTS: Power, Utilities, and Telecommunications
Telco
Problem to be solved
- Build the infrastructure platform for Big Data to ensure scalability, availability and security
- Liaise with Unico as the primary supplier
- Computed insights
- Common data formats
- Self-service interactive analytics
Action taken
- Hortonworks NiFi platform was installed and configured with Kerberos securitisation
- Established multiple environments
- Development, Test and Production
- Completed platform testing and launched into production
Business outcome
- Integrated data streams originating from multiple high-volume network information sources
- Automated real-time decisions for network configuration
- Reduce storage cost
Utilities - Energy
Problem to be solved
- To increase accuracy, provision of audit trail and reduction of time in responding to RINs (Regulatory Information for Notices generated by the Australian Energy Regulator) for power utilities companies
- Decrease cost of audits
Action Taken
- Defining and implementing BI architecture to enable management/monitoring/control of data sources to collate information and maintain a governance structure
- Streamlining and automation of data handing involving data lineage, business rules for ETL & quality, risk assessment
Business outcome
- Reduction of manual data handling by staff resulted in increased accuracy and accountability
- Internal cost for responding to RIN’s decreased [40 staff over 3 months, in addition to their primary work responsibilities]
- Remove the need for on-site audits
Utilities - Gas
Problem to be solved
- Contain high volume of inbound support calls from customers with requests for leasing information
- Streamline and simplify day to day management and overview about fleet operations for the 2,400 customers
- Focus on fraud detection
Action taken
- Business requirements and operational logic were aligned with industry standard framework
- The model was then used to build a self-service reporting platform that provides dynamic dashboards based on each customer’s preferences
- The customers were provided a rich catalogue of analytics reports including finance, accounting and logistics enabling self-service
Business outcome
- Driven cultural change with customer engagement with the self-service portal for 2400 customers with a robust architecture to handle up to 700 concurrent users
- Reduced support team staff by 75%
- Inbound call volumes diminished by 60%
Utilities - Energy
Problem to be solved
- Provide field officers with appropriate information for capital works and break-fix maintenance programs whilst in the field
- Build sophisticated content workflows involving unstructured data (GIS-lidar data, CAD data)
Action taken
Phase 1:
- Upgrade of OpenText server
- Migrating data and configuration
- Performance, load testing
Phase 2:
- Designing workflows
- Migrating and storing digital assets into workflows
- Developing web reports for field officers
Proposed business outcome
- Remote access to engineering documentation
- Collaboration tool for sharing content across multiple parties
- Improving performance in reporting & analysis
Utilities - Water
Problem to be solved
- Mobile based workforce management for 3rd party vendors
- Use of business intelligence to ensure security levels are maintained for appropriate access to data
Action Taken
- Built a data mart exposed as a secure webservice to enable workforce to consume work orders
- Jobs allocated on geographical location and skills required
- Training provided to field workforce as well as internal IT staff
Business outcome
- End to end work order management from allocation to completion
- Provide visibility of break-fix work orders across the business
- More effective resource allocation through Business Intelligence and Analytics
Logistics
Problem to be solved
- Identify process inefficiencies
- Preventive and corrective maintenance – Enhanced GIS solution
- Mobility solution to increase field staff efficiency
- Roadmap for BI/advanced analytics to IoT for process optimisation
Action taken
- Current state assessment of complete reporting and analytics capability
- Depict high-level architecture and conceptual data model
- Benchmarking against industry standard maturity model
- Designed the future to-be architecture leading to advanced analytics state
Business outcome
- The ability to mine and explore meaningful patterns from large volumes of enterprise data for decision-making, prediction, and other inferences
- Enable fast search across unstructured data especially free text in work orders