FYP ACCEPTANCE PRESENTATION Fortune Cookies Dustin Ng Yu

FYP ACCEPTANCE PRESENTATION Fortune Cookies Dustin Ng Yu Jane Iskandar Lau Leow Si Wee Hayden Lilian Young Teng Aladdin Young Supervisor Benjamin Gan Client Lodstone Management Consultants Pte Ltd Michiel Roosjen Rachel Tann

Overview INTRODUCTION � Project Team: Fortune Cookies � Roles & Responsibilities � Our Client: Lodestone Management Consultants Pte Ltd PROJECT � Project Overview � Project Motivation � Project Goals � Project Scope � Project Resources PROJECT MANAGEMENT � Project Timeline � Agile Software Development � Project Risk DESIGN - ER Diagram Demo

Project Team Jane Lilian Dusti n Hayden Aladdin

Roles & Responsibilities Member Management Role Development Role Hayden Project Manager Software Architect Jane Requirement Gathering Secretary Implementer / Reviewer Dustin System Analyst Database Manager Lilian System Analyst User-Interface Designer Aladdin Technical Reviewer Lead Developer

Our Client Lodestone Management Consultants Pte Ltd • • Global Consulting Firm that aims to bring excellence to its customers and measurable business benefits Focus on Strategy, Business Optimization and IT transformation Client-Driven Clients handles businesses from life sciences, chemical, finance industry, etc.

8 Pillars of Delivery Excellence 1. 2. 3. 4. 5. 6. 7. 8. Stakeholders are Committed Business benefits are Realized Risks are Mitigated Issues are Managed Scope is Realistic and Managed Program Planning is Highly Disciplined Team is Highly Skilled and Motivated Engagement in Performing to Expectations

Project Overview Delivery Excellence Dashboard • • Ensure projects handled adhere to the 8 Pillars of Delivery Excellence Provide quality assurance to client’s project Enhance visibility to partners globally and regionally Create a common base for status reporting as well as input for internal monthly steering meetings

Project Motivation Create a platform locally for: � Higher Management to monitor the status of projects based on the 8 Pillars of Delivery Excellence � Project Managers to benchmark their current progress against other similar projects using a common questionnaire

Project Goals Usability � Scalability � Aims to provide an easy to use and convenient platform for higher management to monitor the projects handled by Lodestone MC. Aims to accommodate an increasing number of users and projects Flexibility � Caters specifically for different users (Admin/ Project Manager/ Country Lead/ Regional Lead/ Engagement Partner)

Project Scope Core Functionalities � CRUD Users � CRUD Project � CRUD Questionnaire Intermediary Functionalities � Interactive Map � Generate Status Report to MS Office

Project Scope: Admin Dashboard CRUD Project CRUD Questionnaire CRUD Users

Project Scope: Project Manager Dashboard View assigned projects � View and Update Project Details

Project Scope: Project Manager Dashboard View assigned projects � Viewing and Update Project Details Answer Questionnaires

Project Scope: Project Manager Dashboard View assigned projects � Viewing and Update Project Details Answer Questionnaires Generate Report

Project Scope: Higher Management Dashboard View Interactive Map � View World Map/ Regional Map/ Country Map

Project Scope: Higher Management Dashboard View Interactive Map � View World Map/ Regional Map/ Country Map View Project List � Assigned Region/ Specific Country

Project Scope: Higher Management Dashboard View Interactive Map � View Project List � View World Map/ Regional Map/ Country Map Assigned Region/ Specific Country View Project Details � Latest Status Report

Project Resources Web Application Framework � Stripes Framework Database � My. SQL Server � Apache Tomcat Repository � Tortoise SVN Libraries � Apache POI � JQuery Software � Microsoft Office

X-Factor Usability � Our application aims to provide an efficient, easy to use and satisfying experience that brings business value to Lodestone in monitoring its projects as part of the 8 Pillars of Delivery Excellence � Functions include: Interactive map for higher management to monitor projects Generation of report to export results in MS Office User interface is made intuitive, making it a sufficient and suitable application in the long run

Timeline INSIGHT PHASE: 25 April – 24 June 2012 (8 weeks) Iteration 1: Meeting with steering committee Iteration 2: High level use case diagram, scenario, solution overview, Project Charter Iteration 3: Stakeholder’s interview, identify risk, revise project charter, INSIGHT (25 Apr – 24 Jun SMU 2012) Proposal Iteration 1 2 Lodestone Project Charter Submission (11 May) 3 SMU Proposal Submission (20 Jun)

Timeline DESIGN PHASE: 25 June – 14 August 2012 (8 weeks) Iteration 1: Project Shell Setup Iteration 2: Admin, User Management Iteration 3: Create, Read, Delete Projects, Heuristic Evaluation Iteration 4: Vacation break, buffer, SMU Acceptance Presentation *Currently in this Iteration DESIGN (25 June – 14 Aug 2012) Iteration 1 2 Iteration 3 Iteration 4 SMU Acceptance Presentation (14 Aug)

Timeline EXECUTE : 21 August – 26 October 2012 (9 weeks) Iteration 1 (week 1&2) : Edit Project Data / Geographic Map GUI + Interactive Map Iteration 2 (week 2&3) : CRUD Questionnaires Iteration 3 (week 4 -6) : Generate report, and prepare for UAT Iteration 4 (week 7) : Mid term review Iteration 5(week 8) : Review codes based on feedback given Iteration 6(week 9&10): Buffer/Additional Requirements EXECUTE (21 Aug – 26 Oct 2012) Iteration 1 Iteration 2 Iteration 3 Iteration 4 Iteration 5 Iteration 6 UAT 1 (24 Sep) SMU Midterm Presentation (1 Oct)

Timeline ACHIEVE: 29 October – 7 December 2012 (6 weeks) Iteration 1 (week 11&12) : UAT 2 + server deployment solutions Iteration 2 (week 13) : Revision base on feedback / go LIVE Iteration 3 (week 14&15) : Final revision and presentation ACHIEVE (29 Oct – 7 Dec 2012) Iteration 1 2 3 UAT 2 (5 Nov) Poster Submissio n (12 Nov) SMU Final Presentatio n (29 Nov) Poster Day (7 Dec)

Project Management: Agile Software Development Individuals and interactions over processes and tools How we applied it? � By adopting a cross functional roles for each members, it allows more interactions between different areas of development and the team will gain a good understanding of changes and requirement over such iterations.

Working software over comprehensive documentations How we applied it? � Working prototype and deliverables planned at different stages iteratively along with Heuristic and user acceptance test.

Customer collaboration over contract negotiation � Project requirements cannot be fully collected at the beginning of the software development cycle, therefore continuous customer or stakeholder involvement is very important. How we applied it? � Monthly meeting with stakeholders � Stakeholder interviews � UAT � Bi-weekly status reports and clarifications

Responding to change over following a plan How we applied it? � Time and schedule planned based on risks. Simplified schedule timeline, more elaborated tasking is only worked out before the iteration starts. � Schedule is modified and tailored after reviewing schedule metric and getting a good understanding of team dynamics. � Buffer time planned after each iteration and a specific iteration to cope with change management.

Client Risk S/N Risk Description Probability Impact Overall Mitigation 1 Managing Client Expectations • Change of Scope / Requirements made by Client • Additional functionalities Medium High Medium • Team will need to regularly meet with client to update and address client’s expectations • Team will need to send status reports every 2 weeks 2 Different approach of reporting process between different project managers and across different countries • Project Managers resist change • No standardized process Low Medium • Gather user feedback from client • Create Standardized process 3 Business interruptions or reorganizations in the midst of the project • Uncertain economic times or business conditions, resulting in lack of resources for project implementation Low Medium • Communicate thoroughly regarding project requirements • Assess team skills and resources

ER Diagram

DEMO

Learning Outcomes ALIGNING BUSINESS AND IT REQUIREMENTS Fortune Cookies will have a better understanding of how the management consultants works with specific project management standard and 8 Pillars of Delivery Excellence Lodestone is using ALIGN WITH CLIENT’S EXPECTATIONS Conduct meetings and submit status reports every two weeks Clarify any doubts with Lodestone as soon as possible EXPLORING NEW TECHNOLOGIES Creating an interactive map that shows different geographical regions with the project status Generate report via Ms Office

Q & A

The End