Report from a Building Company Internship

Reflections on Business Data Analytics Learning
August 14, 2022
Reflections on Business Data Analytics Learning
August 14, 2022

Report from a Building Company Internship

Abstract

This is a report of projects undertaken, and the experience gained while doing the internship at Fletcher Building. Multiple projects revolving around designing business processes, master data management and analyzing cost savings were conducted to support the concrete division of the Company. This helped them lay out a financial plan for the year 2020. Detailed research on the existing technologies that could support the company’s business unit was conducted. Master Data cleaning and business process were designed. This helps the company for providing effective customer service Cloud-based solution was designed to support the three business units of Concrete. This supports the company’s growth by being advance in the market. Cost analyzing around hardware devices was done and the costsaving process was implemented. This provides a way for the company to reduce a 2% cost reduction around business units. Implementing the same business process across the other division unit of the company will be incorporated in the future. Reflection on the knowledge gained is also presented in the report.

Home

Index Terms – Data Analytics, Machine learning, Visualization, Concrete, Cloud Computing, Master data

I. INTRODUCTION

The report is a summary of 10 weeks internship conducted at Fletcher Building, New Zealand. The company has six main divisions and has 36 business units under it. This leads to high management of customer data and providing efficient fast services to its customers on a daily basis. My internship was carried under the Concrete division of the Company which has three business units under it, named Firth, Golden bay Cement, and Winstone Aggregates. The Business Units of Concrete faces a problem by having discrepancies in Master data which links to a chain of subsequent problems for the company during the business line in terms of billing, delay in support, and time delays to process the order. Fletcher building being the largest construction company of New Zealand is highly reliable on providing the best customer service to its customers in a fast and efficient way. Every time a customer is on board, a sales representative is assigned to the customer based on the customer’s location. The Sales Representative is then responsible to take correct details from the customer in terms of billings, product and product drop off location. This creates a problem when sales representative leaves the company, as the site managers become unaware of what correct location of the product is, the wrong product being loaded, the wrong customer being charged for the wrong product and long queues at Quarry to pick the product. The company does not have a provision of having real-time data to correct the discrepancies in the customer data or add/modify customer details. The delay in sorting the issue causes the company a high waste of resources in terms of time and poor customer service. Besides that, the company wishes to get rid of obsolete technologies in the business process and bring in new technologies to provide an efficient way of customer service. Apart from that, the three business units under concrete divisions want to perform some cost savings around 470 printers spread across New Zealand and also around landline/mobile billings.

The Concrete Division needs a system in line to do a) cost savings, b) a business process to manage master data and c) new technologies to support the customer by providing efficient customer service. However, keeping in mind the time-bound of 10 weeks internship, realistic multiple project goals were laid in terms of all the different projects which are:-

  1. Establish criteria to identify data that is outside of expectation or norm
  2. Put in place data quality guidelines
  3. Put in place a mechanism for following up discrepancies both with the customer and within the business
  4. Designing a Cloud-Based System for efficient Product Delivery
  5. Analyze the data on usage of printers and Phones and achieve at least 2% cost reductions in terms of energy and services usage purely by analyzing and understanding the data and chasing discrepancies.

The existing report is set in terms of reviewing the existing technologies related to the problem followed by the design and implementation of the business process built to cater to the goals. Lastly, the reflection on lessons learned during the project and the future scope will be discussed.