Operations and Production Management

Abstract or Summary

Security By Design, Inc. i.e. SBD is in the business of installing alarms and CCTV cameras for different clients for safety and security and also offers Alarm monitoring and other security services. Despite being an authorized dealer of the world’s largest security services company, it is facing few challenges in better servicing current customers and attracting new ones. The purpose of this project is to find opportunities for SBD and how its current database can help to generate more revenue following a systematic and more efficient way of data collection and new clients’ information for expansion of its business. Generally, the investment requirements for database management is quite large but SBD does not need to invest heavily although necessary, since there are numerous low cost options are available. It needs to explore data gathering process that best suits its need and budget and should be making use of important data to its firm to use for MIS. Data analysis will assist to plan its business strategy roadmap. Current data structure modification will help accommodate changes as per its revised business plan. SBD should focus on database modification to collect more data to extract behavioural pattern by using reports. Risk assessment and risk management is key for them but should be more cautious about it, as it involves personal information about their clients. It should assess the need for data archival based on their transactions, frequency of analysing the user data. The cost and security of the chosen archival process is important too. SBD always makes sure that client enquiry will not only be given priority but will be expertly administered at all stages. Therefore, there will always be an opportunity to get the repetitive business from existing client. Improvisation of its database would greatly assist to investigate integration of data and application changes, regulatory compliance requirement and most important managing database change requests