Difference between revisions of "IS480 Team wiki: 2010T1 Veritaz"
|Line 228:||Line 228:|
==== ER Diagram ====
==== ER Diagram ====
Revision as of 11:20, 1 October 2010
- 1 Team Veritaz
- 2 Company Background and Formation
- 3 Project Overview
- 4 Preliminary Storyboard
- 5 Assumptions
- 6 Project Management
- 7 The Minutes
- 8 Project Acceptance PPT
- 9 Usability Feedback form & Test
- 10 The Shipping Solutions FYP Proposal
- 11 Updated Schedule V2
Members (Roles and Responsibilities)
|Primary Role||Secondary Role||Name|
|Project Manager||Secretary||Ernest Cai Kunrongemail@example.com|
|System Developer||Project Manager||Cheong Wei Hsienfirstname.lastname@example.org|
|Secretary||Tester||Elizabeth Chin Yun Wenemail@example.com|
|Tester||Design Analyst||Reena CHIN Hwei Yingfirstname.lastname@example.org|
|System Analyst||System Developer||Jolene CHIA Shi Mingemail@example.com|
|Design Analyst||System Analyst||Loh Wei Yifirstname.lastname@example.org|
|ZHENG Baihua||Assistant Professor||Singapore Management Universityemail@example.com|
|Barry Lim||Managing Director||The Shipping Solutions Pte Ltdfirstname.lastname@example.org|
|Jason Goh||Sales Director||The Shipping Solutions Pte Ltdemail@example.com|
Company Background and Formation
Overview of Company Detail (Client/Sponsor)
- The Shipping Solutions is a new Electronic-Solutions and Media organization with an extensive background in logistics.
- The core of our business is to aid the Singapore shipping industry to excel in terms of improved efficiency, and productivity, through the provision and advertisement of vital information of the services that these companies provide, to the public.
- The Shipping Solutions understands the demanding process faced by Shipping Lines (Carriers) when they handle their service lanes enquiries from their logistics partners (Co-Loaders, Forwarders, Direct Shippers). In the current globally competitive logistics market, there is a constant need to make necessary changes and strategically plan for vessels' sailing schedules in order to cater to the ever changing, fast-paced, and dynamic market's needs. Hence, the operations or sales department have dedicated a lot of time to the answering and clarification of their clients' enquiries.
- www.TheShippingSolutions.com was designed and developed especially for the sole purpose of compiling and streamlining your service lanes and sailing schedules. These data will be distributed and shared with the relevant members of the portal, to provide a one stop solution centre to cater to all your clients' needs, as well as to answer all their queries as to the details of the services you provide.
We are proposing to develop a one-stop logistics platform,a Freight Management Portal .In order to understand the reasons and motivations behind our choice of project,we would provide you a brief introduction of the background of the shipping industry in Singapore
There are 3 main groups in the shipping industry and they are the Carriers,Direct Shippers and Forwarders.Below is a brief and simplified description of each group.
Root Cause Issues and Problems
1) Lack of Auto-Mated process & Real Life Information
Problem Description: Currently,a lot of manual labours are required when placing a request.Firstly,the direct shipper will make his logistical request via the forwarder.The forwarder will then match the direct shipper's logistical request with the sailing schedule of the carrier.If the carrier is unable to accede to his request,he will then have to check with several carriers until he finds a match and then place a booking.
Solution: The Shipping Solutions is our client and they have proposed a idea on resolving this huge inefficiency by developing a portal that provides a Fast and efficient means of searching for the most appropriate schedule and we have chosen the development of this portal to be our project.This will provide Real time Information update.'We are going to set a avenue for the clients to Advertise.
Business Impact: Reduce the tedious manual process time, Reduce probability of human error propagation which will in turn increase the efficient level.
As mentioned earlier,our main purpose is to deliver the Freight Management Portal which is deployed on a web server to the sponsor.Beside the main functionalities that the client has proposed,we have also proposed several additional functionalities which we strongly believe will strengthen the usability and attractiveness of the portal.
- Overview: Develop a Freight Management Portal to replace manual based operation
- Ease of Use: Usable by people of minimal IT Skill Knowledge
- Time:Working Function to be completed by every iteration
- Accuracy: UAT to be completed before passing to clients
Our Scope comprises of a development of a one-stop logistics portal.It constitutes the following functionalities:
|Roll Back Function||
|Member Administrative Control Panel||
|Advertisement Management Function||
Search Engine Function:
- Appear at different tabs for different purposes. Several search capabilities for different user tiers - Carriers, Forwarders and Lane Management.'
- Different categories of search, returns different fields.
- This search allows one to search from Port of Loading and Port of Discharge and returns a Carrier/Forwarder which have such a service lane.
- Individual Carrier/Forwarder which holds an account in this portal, to perform a search of current lanes they have for administration purposes.
There are 3 different searches:
- Forwarder search - a simplified search with just the POL and POD returning the Forwarder that provides this service lane. This action can be performed without logging in.
- Carrier search - a search with just the POL and POD with keyword search and day search returning the Carrier that provides this service lane. This action cannot be performed without logging in.
- Lane administration - this search allows registered users be it Carrier/Forwarder to search for their sailing schedule entries.
- This functions allows us to allow suggestions of traveling from various ports. For instance, if there isn’t any existing lanes from Singapore - Dubai. The search results will show our various alternatives how can the shipment goes from Singapore - Dubai. Results may be in the form of such possibility: Singapore - Thailand - Dubai or Singapore - Indonesia - Philippines - Dubai.
Member Administrative Control Panel
- Members will be allowed to update the various fields within the profile such as company address, telephone number and fax number. They can also add, delete or update the contact person details. These information will be then put up on the company profile page.
- A tool necessary for members to change their password for confidentiality purposes.
- Members will be allowed to update existing lanes schedule if there is a change. Delete existing lane schedule if there is a mistake or even add new lane schedules.
- Add new members that carry the company’s information and the different profile types and member types.
- Administrator will be allowed to deleted any members if they post up any false information.
- Once a member is created, then can users for that particular company be created.
- Administrator will then be able to assign new user accounts. He can also be able to deleted or update the password if one has forgotten the password.
Member/Profile Type (CRUD):
- Creation of new profile/member type with ability to assign specific access rights.
- Ability to make changes to any lanes if client is unable to log into the system
- Ability to create/approve news broadcast on the portal.
File Upload Function:
- Allow the members to upload different excel formats of schedule to be input into the system without keying each and everyone in.
Roll Back Function
User Tracking Function:
- It is an important function to track users movement. If someone intentionally deleted all the information pertaining to the company’s schedule, we would be able to track them out without any hassel. All the actions will be recorded and overwritten. 7 days of actions will be tracked and in it is more than enough reaction.
- In any case of failure to backup the information in the system, in any event that crashes.
Advertisement Management Function
- It is an aspect for company to generate revenue for the company.It can let customer post advertisement on portal. They will also provide another outlet for customer to promote their brand especially for newly setup.
- This module allows the administrator to change the main page/lane search advertisements
- Carrier/Forwarder will then be able to view the progress of the different users.
Statistical Report Function:
- Statistical reports on the frequency of searches from various ports of loading to port of discharge. This information will let companies have a easier time for planning their following sailing routes.
|If the RTC Server is down,We would be unable to view our work schedule,would lose track of our deadlines||
Our Backup plan allows us to still track our work schedule using excel sheets with the stipulated time and deadlines.
|If the RTC Server is down, not able to monitor our task assigned easily||This would be mitigated with the help of our minutes in accordance to our meetings.|
|If the RTC Server is down, we will not have any access to source code||Backup of codes on an external hard-disk after every iteration.|
|We will be using the server provided by the client that uses PLESK - the server control panel, we assume that PLESK has the appropriate Tomcat and MySQL software that we intend to use for the portal.||If PLESK does not have the required software,we would have to upgrade to the latest PLESK or we will decide to bypass the panel(worst case scenario)|
|None of us have prior knowledge in using AJAX and we assume it will be easy to learn through resources available on the Internet and reference materials from the library.||If AJAX proves to be difficult to learn via online resources alone,we will be contacting friends who have prior experience with AJAX and they are willing to spend some effort to guide us in using AJAX|
|We assume the learning curve for RTC(Rational Team Concert)is not steep.||If the learning curve for RTC is too steep,we might drop the idea of using it to aid the development process and use a simpler tool such as Microsoft Live Small Business|
|We assume that all change of requirements by our supervisor and project sponsor will not hamper our project schedule||If the change of requirements is too huge,we will re-evaluate our current situation.If we are unable to accommodate to the change in schedule,we may reject it completely.However,if the change is critical to the client then we may drop an existing functionality in the place of the new change.|
Resource and reference
1) Web resources in using RTC,AJAX
2) A Web server to host and deploy our portal
1) Client Management: Ability to understand functional requirements from clients
2) Buiness-IT Value Linkage Skills: Ability to analyze the operations and business process of the logistics industry and use IT to drive it
3) Ability to provide documentation understandable by users(Requirements specification,risks management plan,assumptions,constraints,architecture choices,design choices etc.)
4) Ability to implement the change of requirements from our supervisor and project sponsor and to sustain the change over time
5) Ability to analyze the operations and business process of the logistics industry and use IT to drive it
6) Ability to identify,prioritize, mitigate and document the necessary project risk
7)Establish a proper work breakdown structure, time and effort estimates,resource allocation and precise scheduling
8)Use Proper tools to manage the teams' development and management progress
Joint Initiative of Project Sponsor
The Shipping Solutions is a new Electonic-Solution and Media organization with an extensive background in logistics.The core of our business is to aid the Singapore Shipping industry to excel in terms of improved efficiency and productivity,through the provision and advertisement of vital information of the services that these companies provide,to the public.
The Shipping Solutions understands the demanding process faced by Shipping Lines(Carriers) when they handle their service lanes enquiries from their logistics partners(Co-loader,Forwarders, Direct Shippers).In the current globally competitive logistics market,there is a constant need to make necessary changes and stratgically plan for vessels' sailing schedules in order to cater to the ever changing fast-paced and dynamic market's needs.Hence,the operations or sales department have dedicated a lot of time in answering and clarification of their clients' enquirers
1 .Identify training requirements for all team members and ensure everyone possesses the know- how to use all software and programs involved in the portal development.
2. Confidential information must not be disclosed to anyone and must be kept within our team. The information includes all non-public information concerning our client, its clients and/or its shippers, that might be of use to competitors or harmful to its business partners.
3. Meeting must be held at least once a week. Minutes to be done and uploaded within 24 hours after every meeting to keep everyone updated.
4. To keep our client updated on our progress, we will need to submit a report on the modules that we have completed every fortnightly.
5. Team would have to follow closely and track the timeline as per scheduled so as to deliver our work promptly.
6. .It is everyone’s responsibility to ensure that he/she is committed to complete tasks assigned on time.
7. Punctuality should be observed for supervisor, client, and group meetings at all times.
1. Develop a portal which fits the requirements of the company and implement solutions to improve the portal based on feedback received.
2. Facilitating easy access and locating resources on the portal for our client, ensuring that it is sustainable in the long run.
3. Working with an external client would gear us with better knowledge and determination to not only complete our tasks, but to produce quality deliverables.
4. Fostering strong bonds among our team would allow us to learn from one another, and be receptive to opinions and advises as a team.
5. We should not only apply what we have learnt in our course work. It is essential for each of us to learn something new in the midst of developing the portal as a takeaway in order to enhance our skill set.
6. Learning to establish healthy working relationship within our team and most importantly with our client.
We are employing 8 Iteration.
Phases in each iteration
- Review planned tasks
- Development of functionalities
- Integration of functionalities
|Iteration||Task to be completed|
|Iteration 1: 18 May - 14 June||
|Iteration 2: 15 June - 12 July||
|Iteration 3:13 July - 9 August||
|Iteration 4: 10 August - 2 September||
|Iteration 5: 3 September - 23 September||
|Iteration 6: 24 September - 14 October||
|Iteration 7: 15 October - 4 November||
|Iteration 8: 5 November - 22 November||
- Goal: To ensure prompt delivery of project.
- Question: How many days are we ahead or behind schedule?
- MetricPlanned Day - Actual Day.
- Use:: Help us to manage our time better to meet deadlines
- Goal: To ensure our clients to be able to carry out their intended tasks on our portal efficiently, effectively and satisfactorily.
- Question: How easy is it for users to use our portal?
- MetricNumber of points given to each category[Performance,Comfort,Navigation] by different users.
- Use:: Help us manage our usability of our portal.
Usability Metric: Performance
Usability Metric: Comfort
Usability Metric: Action Plan
|All >= 4 points||
|One < 4 points||
|Two < 4 points||
|All < 4 Points||
Minutes - 01 June 2010 (Media:Veritaz_MeetingMinutes004.doc)
Minutes - 04 June 2010 (Media:Veritaz_MeetingMinutes005.doc)
Minutes - 06 June 2010 (Media:Veritaz_MeetingMinutes006.doc)
Minutes - 12 June 2010 (Media:Veritaz_MeetingMinutes007.doc)
Minutes - 14 June 2010 (Media:Veritaz_MeetingMinutes008.doc)
Minutes - 26 June 2010 (Media:Veritaz_MeetingMinutes009.doc)
Minutes - 30 June 2010 (Media:Veritaz_SupervisorMeetingMinutes001.doc)
Minutes - 01 Aug 2010 (Media:Veritaz_MeetingMinutes013.doc)
Minutes - 03 Aug 2010 (Media:Veritaz_MeetingMinutes014.doc)
Minutes - 05 Aug 2010 (Media:Veritaz_MeetingMinutes015.doc)
Minutes - 06 Aug 2010 (Media:Veritaz_MeetingMinutes016.doc)
Minutes - 08 Aug 2010 (Media:Veritaz_MeetingMinutes017.doc)
Minutes - 11 Aug 2010 (Media:Veritaz_MeetingMinutes018.doc)
Minutes - 17 Aug 2010 (Media:Veritaz_MeetingMinutes019.doc)
Minutes - 26 Aug 2010 (Media:Veritaz_SupervisorMeetingMinutes002.doc)
Minutes - 01 Sept 2010 (Media:Veritaz_MeetingMinutes021.doc)
Minutes - 02 Sept 2010 (Media:Veritaz_MeetingMinutes_CLIENT.doc)
Minutes - 06 Sept 2010 (Media:Veritaz_MeetingMinutes022.doc)
Minutes - 13 Sept 2010 (Media:Veritaz_MeetingMinutes023.doc)
Minutes - 20 Sept 2010 (Media:Veritaz_MeetingMinutes024.doc)
Minutes - 23 Sept 2010 (Media:Veritaz_SupervisorMeetingMinutes003.doc)
Project Acceptance PPT
Project Acceptance PPT (Media:FYP Acceptance.ppt)
Usability Feedback form & Test
The Shipping Solutions FYP Proposal
The Shipping Solutions FYP Proposal(Media:The Shipping Solutions FYP Proposal.pdf)
Updated Schedule V2
Updated Schedule V2(Media:Schedule v2.pptx)