1 / 26

MRDigiBoard

MRDigiBoard. ********. Outline. Gain competitive edge Provide excellent customer service Promote profitable business activities Provide affordable living Provide sophisticated living Ensure quality management Efficient maintenance & repair. Improve the flow of information

bluma
Download Presentation

MRDigiBoard

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MRDigiBoard ********

  2. Outline • Gain competitive edge • Provide excellent customer service • Promote profitable business activities • Provide affordable living • Provide sophisticated living • Ensure quality management • Efficient maintenance & repair • Improve the flow of information • Reducework order processing time • Increase maintenance employee accountability • Store critical business data • Accuratereporting • Improve tenant relations • Manage & repair apartments effectively • Improve record keeping • Easy GUI to navigate with • Use reports to make effective business decisions • Enhanced communication between employees with bilingual comments • Section 2 • Section 1 • Section 3

  3. Objectives Summary • Gain competitive edge • Provide excellent customer service • Promote profitable business activities • Provide affordable living • Provide sophisticated living • Ensure quality management • Efficient maintenance & repair • Improve the flow of information • Reducework order processing time • Increase maintenance employee accountability • Store critical business data • Accuratereporting • Improve tenant relations • Manage & repair apartments effectively • Improve record keeping • Easy GUI to navigate with • Use reports to make effective business decisions • Enhanced communication between employees with bilingual comments • User • System • Organization

  4. Financial Impact • Problem - Information on ‘make ready’ board is often outdated and unreliable. • Result - Work order performed more than once or not at all. • Impact - Supply waste - $30 a month • Loss of one tenant - $450 a month

  5. Current System - Impact • Problem - Lack of central data storage • Result - Walking back to office to clarify work • Impact - Average profit loss of 3% annually • 25 minutes added to time or an extra $25 a week

  6. Current System - Impact • Whiteboard is manual = Increase work order processing time • Impact: • 10 minutes added to processing time or $10 a week • 25 minutes added to processing time or $25 a week

  7. Current System - Impact • Lack of accountability = Unable to evaluate employee on work performance • Impact: • Slowest work order time = 4 weeks or $200

  8. Proposed System - Options

  9. Feasibility Analysis

  10. Cost of Ownership

  11. WEIRDOS Design Process

  12. Development Tools • Developed using industry standard software • Microsoft Visual Basic 2008 – Programming and debugging user interface • Microsoft SQL Server 2005 – Programming and debugging database • Adobe Creative Suite 4 – Create and edit graphics for user interface and project documents • … and more.

  13. Project Timeline Aug-Sep 2009 Database planning and architecture begins Early Nov. 2009 GUI finalized, final testing begins Jan 2009 WEIRDOS form partnership with Case Nube Feb-Apr 2009 In-depth analysis of business process begins Feb 2009 ‘M.R. Digiboard’ is born Apr 2009 Project proposal officially presented Mid Nov. 2009 M.R. Digiboard presented and officially released October 2009 Database structure finalized, frontend work started

  14. Implementation Process

  15. Entity Relationship Diagram • Lists all entities, attributes and relationships • Abstract and conceptual representation of database • Generated with Access, Visio and ConceptDraw Pro

  16. Early ERD – September 2009 • 14 Total Entities (Tables) • Multiple many-to-many relationships • Unnormalized Form (UNF)

  17. Final ERD – October 2009 • Entities increased to 50 • Many-to-many relationships broken down • Normalized to 3NF

  18. ERD: Employee • Problem • Unnecessary information • Solution • Remove entity

  19. ERD: Emergency Contact • Problem • Missing Associative Tables • Solution • Add Table that handles the M:N relationship

  20. ERD: Property • Issue– Sending foreign key to both entities • Solution – Remove foreign key from one side of entity

  21. ERD: Problem Table • Issue– Incorrect relationships • Solution – Adjust constraints

  22. Completed Solution • Fully Digital ‘Whiteboard’ • Work order forms with ample space for comments • Work order reports that indicate status • Assignment report for each user • Make-ready reports for each user • Pet information on work order report

  23. User Interface Benefits • Simple, intuitive design • Effortless navigation with minimal user training required. • Dual-Scale Functionality • Quick and simple reports for employees, in-depth edit and lookup forms for managers. • Flexible Design • Developed with future expansion in mind.

  24. Maintenance and Backups • Effortless Backups • Daily, server-wide backups performed by hosting provider automatically – easy. • Off-Site Backup Storage • Backups shipped offsite weekly • Instant Redundancy • RAID-1 disk mirroring to safeguard against individual hard disk failures.

  25. Lessons Learned • Think critically early on – An ounce of prevention is worth a pound of cure. • Work smart, not hard – Consolidate knowledge and save time. • The small mistakes can cost just as much time as the big ones.

  26. Questions?

More Related