HeaderSIS.jpg

Difference between revisions of "IS480 Team wiki: 2017T1 Enigma Final Wiki"

From IS480
Jump to navigation Jump to search
 
(37 intermediate revisions by 3 users not shown)
Line 30: Line 30:
 
<br>
 
<br>
  
===Deployment Links===
+
===Final Slides===
[[Image: Enigma-View-Website.png|center|200px]]
+
[[Media: Final_Presentation_V1_Enigma.pdf| Final Presentation]]
<center>http://128.199.207.181/aenonpharm/index.php</center>
 
  
[[Image: Enigma-View-CCMS.png|center|200px]]
+
===Project Highlights===
<center>http://128.199.207.181:8080/campaign-portal</center>
+
*Delay in campaign launch due to unfortunate unforeseen events for our sponsor. Had to reduce period campaign ran and as a result, reduced our x-factor from 200 redemptions to 170 redemptions
  
[[Image: Enigma-View-Clinic-Portal.PNG|center|200px]]
+
===Project Challenges===
<center>http://128.199.207.181:8080/Clinic_Portal</center>
+
*Familiarising ourselves with new programming languages (e.g php and javascript)
 +
*Learning to use off-the-shelf CMS (ExpressionEngine) to build a website for our client (e.g familiarising ourselves with the syntax). Used online guides and tutorials to learn PHP as well as how to use ExpressionEngine (CMS)
 +
*Learning how to utilise open-source API such as Chart.js and MailChimp
 +
*Blacklisting of IP address for some email clients due to previous owner. Liaised with server provider, DigitalOcean, to resolve the issue by getting a new server
 +
*Faced issue of email ban on the server due to DigitalOcean's policies. Had the ban removed by communicating our project and situation to DigitalOcean to ensure no malicious intent
 +
*Last minute changes of project scope requests from sponsor. Weighed the feasibility to accommodate to the changes according to the project timeline.
  
===Project Highlights===
+
===Project Achievements===
*Delay in campaign launch due to unfortunate unforeseen events for our sponsor.
+
*Ability to generate customer database for clients from 0 to 177
*Team's idea of having a clinic portal for partner clinics involved in campaigns for accountability purposes approved by sponsors.
+
*Ability to gather feedback for voucher redemption process from real users for UAT 3
*Learning and customising an off-the-shelf CMS (ExpressionEngine) to build a website for our client without any prior experience with it.
+
*Ability to improve voucher redemption process (survey results on ease of use of voucher redemption from an average of 3.75/5 to 4/5)
  
 
==Project Management==
 
==Project Management==
Line 82: Line 86:
 
|style="text-align: center;"| 5
 
|style="text-align: center;"| 5
 
|Campaign Management Module
 
|Campaign Management Module
|Create/edit campaign with vouchers
+
|Create/Update/Delete campaign with vouchers
 
|100%
 
|100%
 
|Completed
 
|Completed
Line 88: Line 92:
 
|style="text-align: center;"| 6
 
|style="text-align: center;"| 6
 
|
 
|
|Generate QR Code for voucher redemption
+
|View total vouchers redeemed all time/per month/today
 
|100%
 
|100%
 
|Completed
 
|Completed
Line 94: Line 98:
 
|style="text-align: center;"| 7
 
|style="text-align: center;"| 7
 
|
 
|
|View campaign overview
+
|View average vouchers redeemed per month
 
|100%
 
|100%
 
|Completed
 
|Completed
 
|-
 
|-
 
|style="text-align: center;"| 8
 
|style="text-align: center;"| 8
 +
|
 +
|Generate QR Code for voucher redemption
 +
|100%
 +
|Completed
 +
|-
 +
|style="text-align: center;"| 9
 +
|
 +
|View Campaign details and status
 +
|100%
 +
|Completed
 +
|-
 +
|style="text-align: center;"| 10
 
|
 
|
 
|Generate campaign report
 
|Generate campaign report
Line 104: Line 120:
 
|Completed
 
|Completed
 
|-
 
|-
|style="text-align: center;"| 9
+
|style="text-align: center;"| 11
 
|Voucher Redemption Module
 
|Voucher Redemption Module
 
|Automated email to send personalised voucher
 
|Automated email to send personalised voucher
Line 110: Line 126:
 
|Completed
 
|Completed
 
|-
 
|-
|style="text-align: center;"| 10
+
|style="text-align: center;"| 12
 
|
 
|
 
|Redeem voucher
 
|Redeem voucher
Line 116: Line 132:
 
|Completed
 
|Completed
 
|-
 
|-
|style="text-align: center;"| 11
+
|style="text-align: center;"| 13
 
|
 
|
 
|Automated thank you email
 
|Automated thank you email
Line 122: Line 138:
 
|Completed
 
|Completed
 
|-
 
|-
|style="text-align: center;"| 12
+
|style="text-align: center;"| 14
 +
|Customer Management Module
 +
|View clinics
 +
|100%
 +
|Completed
 +
|-
 +
|style="text-align: center;"| 15
 +
|
 +
|Add/Update clinics
 +
|100%
 +
|Completed
 +
|-
 +
|style="text-align: center;"| 16
 
|
 
|
 
|Search clinics
 
|Search clinics
Line 128: Line 156:
 
|Completed
 
|Completed
 
|-
 
|-
|style="text-align: center;"| 13
+
|style="text-align: center;"| 17
 
|
 
|
 
|Sort clinics in alphabetical order
 
|Sort clinics in alphabetical order
Line 134: Line 162:
 
|Completed
 
|Completed
 
|-
 
|-
|style="text-align: center;"| 14
+
|style="text-align: center;"| 18
 
|
 
|
 
|Export patient emails to MailChimp mailing list
 
|Export patient emails to MailChimp mailing list
 +
|100%
 +
|Completed
 +
|-
 +
|style="text-align: center;"| 19
 
|
 
|
|To be completed in Sprint 8
+
|Export patient emails to CSV File
 +
|100%
 +
|Completed
 
|-
 
|-
|style="text-align: center;"| 15
+
|style="text-align: center;"| 20
 
|
 
|
|Campaign reimbursement
+
|Select emails to export based on gender/product/age
|
+
|100%
|To be completed in Sprint 8
+
|Completed
 
|-
 
|-
|style="text-align: center;"| 16
+
|style="text-align: center;"| 21
 
|Clinic Admin Module
 
|Clinic Admin Module
 
|Register clinic information
 
|Register clinic information
Line 152: Line 186:
 
|Completed
 
|Completed
 
|-
 
|-
|style="text-align: center;"| 17
+
|style="text-align: center;"| 22
 
|
 
|
 
|Login/Logout
 
|Login/Logout
Line 158: Line 192:
 
|Completed
 
|Completed
 
|-
 
|-
|style="text-align: center;"| 18
+
|style="text-align: center;"| 23
 
|
 
|
 
|Reset password
 
|Reset password
Line 164: Line 198:
 
|Completed
 
|Completed
 
|-
 
|-
|style="text-align: center;"| 19
+
|style="text-align: center;"| 24
 
|
 
|
 
|Update clinic information
 
|Update clinic information
Line 170: Line 204:
 
|Completed
 
|Completed
 
|-
 
|-
|style="text-align: center;"| 20
+
|style="text-align: center;"| 25
 
|
 
|
 
|Generate campaign report
 
|Generate campaign report
Line 176: Line 210:
 
|Completed
 
|Completed
 
|-
 
|-
|style="text-align: center;"| 21
+
|style="text-align: center;"| 26
 +
|
 +
|View number of vouchers redeemed per campaign by last 7 days/month/overall
 +
|100%
 +
|Completed
 +
|-
 +
|style="text-align: center;"| 27
 +
|
 +
|View total vouchers redeemed all time/per month/today
 +
|100%
 +
|Completed
 +
|-
 +
|style="text-align: center;"| 28
 +
|
 +
|View demographic info of patients age/gender per campaign
 +
|100%
 +
|Completed
 +
|-
 +
|style="text-align: center;"| 29
 
|Analytics Module
 
|Analytics Module
|View number of vouchers redeemed per campaign/month/year/clinic
+
|View number of vouchers redeemed per campaign by last 7 days/month/overall
 +
|100%
 +
|Completed
 +
|-
 +
|style="text-align: center;"| 30
 +
|
 +
|View demographic info of patients age/gender per campaign
 
|100%
 
|100%
 
|Completed
 
|Completed
 
|-
 
|-
|style="text-align: center;"| 22
+
|-
 +
|style="text-align: center;"| 31
 +
|
 +
|View dollar amount redeemed by clinics per campaign
 +
|100%
 +
|Completed
 +
|-
 +
|style="text-align: center;"| 32
 +
|
 +
|View campaign leaderboard by top 5 clinics overall/per campaign/per product
 +
|100%
 +
|Completed
 +
|-
 +
|style="text-align: center;"| 33
 
|
 
|
|Campaign performance
+
|View campaign performance (Growth/ROI)
 +
|100%
 +
|Completed
 +
|-
 +
|style="text-align: center;"| 34
 
|
 
|
|To be completed in Sprint 8
+
|Bootstrap monthly product sales
 +
|100%
 +
|Completed
 
|-
 
|-
|style="text-align: center;"| 23
+
|style="text-align: center;"| 35
 
|
 
|
|Website analytics
+
|Website Google Analytics
 
|100%
 
|100%
 
|Completed
 
|Completed
 
|-
 
|-
|style="text-align: center;"| 24
+
|style="text-align: center;"| 36
 
|Communication Module
 
|Communication Module
 
|Send enquiry to admin (website)
 
|Send enquiry to admin (website)
Line 200: Line 277:
 
|Completed
 
|Completed
 
|-
 
|-
|style="text-align: center;"| 25
+
|style="text-align: center;"| 37
 
|
 
|
 
|Send testimonial to admin (website)
 
|Send testimonial to admin (website)
Line 206: Line 283:
 
|Completed
 
|Completed
 
|-
 
|-
|style="text-align: center;"| 26
+
|style="text-align: center;"| 38
 
|Clinic Locator Module
 
|Clinic Locator Module
 
|View clinics per product
 
|View clinics per product
Line 212: Line 289:
 
|Completed
 
|Completed
 
|-
 
|-
|style="text-align: center;"| 27
+
|style="text-align: center;"| 39
 
|
 
|
 
|Tag clinic location to Google Maps
 
|Tag clinic location to Google Maps
|50%
+
|100%
|To be completed in Sprint 8
+
|Completed
 
|-
 
|-
|style="text-align: center;"| 28
+
|style="text-align: center;"| 40
 
|Campaign Search Module
 
|Campaign Search Module
 
|Search campaign
 
|Search campaign
Line 224: Line 301:
 
|Completed
 
|Completed
 
|-
 
|-
|style="text-align: center;"| 29
+
|style="text-align: center;"| 41
 
|
 
|
 
|Filter by month/active/ended
 
|Filter by month/active/ended
|60%
+
|100%
|To be completed in Sprint 8
+
|Completed
 
|-
 
|-
 
|}
 
|}
 
  
 
===Project Scope (Planned vs Actual)===
 
===Project Scope (Planned vs Actual)===
Line 247: Line 323:
 
<br>
 
<br>
 
<center><div style="padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:helvetica;"><font color= #000000>Actual Project Timeline</font></div></center>
 
<center><div style="padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:helvetica;"><font color= #000000>Actual Project Timeline</font></div></center>
[[Image:Actual Project Timeline_V3.PNG|center|1000px]]<br>
+
[[Image:Actual Project Timeline_V3.PNG|center|800px]]<br>
  
 
<br><b>Main Changes to Timeline</b>
 
<br><b>Main Changes to Timeline</b>
Line 255: Line 331:
 
*Changes made to campaign start date from 11 September to 21 September
 
*Changes made to campaign start date from 11 September to 21 September
 
*Shifting of Campaign Search Module to Sprint 7
 
*Shifting of Campaign Search Module to Sprint 7
*Addition of campaign reimbursement functionality to Sprint 8
+
*Addition of feature to select emails to export based on gender/product/age
 +
*Shifting of campaign performance module to Sprint 8
 
<br>
 
<br>
<!--
+
 
 
===Project Metrics===
 
===Project Metrics===
 
The team is using Sprint Velocity, Sprint Burndown and Bug Metrics to ensure effective planning for our subsequent sprints. Each sprint is reviewed after completion and taken into consideration to gauge the number of tasks / story points the team can complete next sprint.<br>
 
The team is using Sprint Velocity, Sprint Burndown and Bug Metrics to ensure effective planning for our subsequent sprints. Each sprint is reviewed after completion and taken into consideration to gauge the number of tasks / story points the team can complete next sprint.<br>
 
====Sprint Velocity====
 
 
<br>
 
<br>
[[Image: Enigma Sprint Velocity Sprint 6.png|center|800px]]
+
[[Image: Sprint-Velocity-Enigma.png |center|300px]]
 
<br>
 
<br>
====Sprint Burndown====
+
[[Image: Enigma Sprint Velocity Sprint 7.png|center|800px]]
 +
 
 +
 
 +
 
 +
[[Image: Enigma Burndown Chart.png |center|300px]]
 
<br>
 
<br>
[[Image: Enigma Burn Down Chart Sprint 6.png|center|800px]]
+
[[Image: Enigma Burn Down Chart Sprint 9.png|center|800px]]
 
<br>
 
<br>
<center>
+
 
{| class="wikitable"
+
[[Image: Enigma_Task_Metrics_Title.png |center|250px]]
|-
 
|  [[Image: Enigma Burn Down Chart Sprint 1.PNG |thumb|100px|center|Sprint 1]]
 
|  [[Image: Enigma Burn Down Chart Sprint 2.PNG |thumb|100px|center|Sprint 2]]
 
[[Image: Enigma Burn Down Chart Sprint 3.PNG |thumb|100px|center|Sprint 3]]
 
|  [[Image: Enigma Burn Down Chart Sprint 4.png |thumb|100px|center|Sprint 4]]
 
|  [[Image: Enigma Burn Down Chart Sprint 5.png |thumb|100px|center|Sprint 5]]
 
|}
 
</center>
 
<br>
 
====Task Metric====
 
 
<br>
 
<br>
[[Image: Enigma Task Metric Sprint 6.png|center|800px]]
+
[[Image: Enigma Task Metric Sprint 7.png|center|800px]]
 
<br>
 
<br>
====Bug Metric====
+
[[Image: Bug-metrics-enigma.png |center|300px]]
 
<br>
 
<br>
[[Image: Enigma-Bug-Metrics.png|center|800px]]
+
[[Image: Enigma Bug Metrics Sprint 7.png|center|800px]]
 
<br>
 
<br>
-->
 
 
===Project Risks===
 
===Project Risks===
 
<br>
 
<br>
Line 329: Line 397:
 
*We then converted this byte array key to a secret key using SecretKeySpec with AES encryption defined as its algorithm.<br>
 
*We then converted this byte array key to a secret key using SecretKeySpec with AES encryption defined as its algorithm.<br>
 
*A cipher object is then created using Cipher class that would implement AES Encryption and is used on the password to encrypt it.<br>
 
*A cipher object is then created using Cipher class that would implement AES Encryption and is used on the password to encrypt it.<br>
*The result is then converted and returned as a String.<br>
+
*The result is then converted and returned as a String.<br><br>
  
 
<b>3. Stacked Bar Charts (Chart.js)</b><br>
 
<b>3. Stacked Bar Charts (Chart.js)</b><br>
Line 342: Line 410:
 
*Script will use dataset to display the data for the specific campaign of the clinic in the form of stacked bar charts<br>
 
*Script will use dataset to display the data for the specific campaign of the clinic in the form of stacked bar charts<br>
  
 +
<br><b>4. Campaign Performance</b><br>
 +
Initial Idea: Create campaign profitability predictor<br>
 +
Problems:<br>
 +
*Clinics involved in campaigns don't have sufficient past data to build a predictor on (as these clinics are new clinics for our clients)<br>
 +
Intermediate Idea: Allow portal user to get gauged profitability and breakeven point of a campaign based on input values.<br>
 +
Problems:<br>
 +
*Different clinics have different profit margins<br>
 +
*Undesirable to our clients to share such sensitive information (i.e. profit margins)<br>
 +
*Even if the programme did allow for the different profit margins to be entered, it would lead to increased manual work on the portal user's end.
 +
Final Idea: Sales growth for clinics participating in campaign<br>
 +
Why the idea was accepted:<br>
 +
*Did not require profit information (only needed sales information)<br>
 +
*Did not require a lot of past data<br>
 +
*Created a direct link between campaign and sales as Aenon did not perform other marketing efforts with the clinics involved in the campaign<br>
 
==Quality of product==
 
==Quality of product==
  
===Intermediate Deliverables===
+
===Project Deliverables===
  
 
<center>
 
<center>
Line 385: Line 467:
 
|}
 
|}
 
</center>
 
</center>
 +
 +
===Deployment===
 +
[[Image: Enigma-View-Website.png|center|200px]]
 +
<center>http://128.199.207.181/</center>
 +
 +
[[Image: Enigma-View-CCMS.png|center|200px]]
 +
<center>http://128.199.207.181:8080/campaign_portal/</center>
 +
 +
[[Image: Enigma-View-Clinic-Portal.PNG|center|200px]]
 +
<center>http://128.199.207.181:8080/Clinic_Portal</center>
  
 
===Testing===
 
===Testing===
  
====User Acceptance Testing 1====
+
<b><i>User Acceptance Testing 1</i></b><br>
 
 
 
<b>Test Plan</b><br>
 
<b>Test Plan</b><br>
 
 
Objectives<br>
 
Objectives<br>
 
*Ensure that flow of website and voucher redemption process behaves as expected<br>
 
*Ensure that flow of website and voucher redemption process behaves as expected<br>
Line 415: Line 505:
 
2. Revise the voucher redemption process to remove/reduce the role of clinic receptionists in the voucher redemption process.<br>
 
2. Revise the voucher redemption process to remove/reduce the role of clinic receptionists in the voucher redemption process.<br>
  
====User Acceptance Testing 2====
+
<br><b><i>User Acceptance Testing 2</i></b><br>
 
<b>Test Plan</b><br>
 
<b>Test Plan</b><br>
 
Objectives<br>
 
Objectives<br>
Line 422: Line 512:
 
<b>Date: </b>25 September 2017<br>
 
<b>Date: </b>25 September 2017<br>
  
=====Aenon Admin Portal=====
+
Aenon Admin Portal<br>
 
<b>Key Findings/Improvements to be made</b><br>
 
<b>Key Findings/Improvements to be made</b><br>
 
1. 1/4 of participants felt that there was a need for a breakdown of the number of redemptions for each day<br>
 
1. 1/4 of participants felt that there was a need for a breakdown of the number of redemptions for each day<br>
Line 428: Line 518:
 
3. 1/4 of participants highlighted that the clinic name tagged to the QR code is useful<br>
 
3. 1/4 of participants highlighted that the clinic name tagged to the QR code is useful<br>
  
=====Clinic Admin Portal=====
+
Clinic Admin Portal<br>
 
<b>Key Findings/Improvements to be made</b><br>
 
<b>Key Findings/Improvements to be made</b><br>
 
1. 1/4 participants mentioned the graph in home page should indicate the promotional value<br>
 
1. 1/4 participants mentioned the graph in home page should indicate the promotional value<br>
Line 434: Line 524:
 
3. 2/4 participants highlighted that the total amount to reimbursed was clear and useful<br>
 
3. 2/4 participants highlighted that the total amount to reimbursed was clear and useful<br>
 
4. All participants generally feel that the clinic portal is simple and user-friendly<br>
 
4. All participants generally feel that the clinic portal is simple and user-friendly<br>
<!--
+
 
 +
<br><b><i>User Acceptance Testing 3</i></b><br>
 +
<b>Test Plan</b><br>
 +
Objectives<br>
 +
*Gather feedback from admin users regarding usability of Aenon admin portal.<br>
 +
*Gather feedback from real campaign participants regarding user-friendliness of voucher redemption process.<br>
 +
*Gather feedback from real campaign participants (patients) about usefulness and user experience of Aenon website.<br>
 +
*Gather feedback from general public about usability and user experience of Aenon website.<br>
 +
<b>Participants:</b> <br>
 +
Website: 10 participants are from the pharmaceutical industry, 10 participants are from the general public aged 30-60, 20 participants are SMU students <br>
 +
Voucher Redemption Process: Out of 177 voucher redeemers emailed, 6 responded <br>
 +
Aenon Admin Portal: 3 Aenon employees <br>
 +
<b>Date: </b>6 - 19 November 2017<br>
 +
 
 +
Website<br>
 +
<b>Key Findings/Improvements to be made</b><br>
 +
*Participants confused with distributor's contact being on contact page instead of Aenon's contact (Accepted)<br>
 +
*To have more images showing people using the products<br>
 +
 
 +
Voucher Redemption<br>
 +
<b>Key Findings/Improvements to be made</b><br>
 +
*Redeem Now button in email is too small (Accepted)<br>
 +
*Subsequent redemptions should have vouchers sent directly to the patient's email<br>
 +
 
 +
Admin Portal<br>
 +
<b>Key Findings/Improvements to be made</b><br>
 +
*Campaign profitability information was unclear. (Accepted)<br>
 +
*Unable to track the number of vouchers redeemed and the status of each campaign. (Accepted)<br>
 +
*Leaderboard does not show action plan for Aenon when running campaigns. (Accepted)<br>
 +
*In create campaign, allow 0 as an input amount for discount<br>
 
==Learning Outcome==
 
==Learning Outcome==
<br>
+
===Team Reflection===
[[Image: Enigma-Learning-Outcomes.PNG|center|600px]]
+
[[Image: Team reflection enigma.PNG|center|800px]]
-->
+
 
 +
===Individual Reflection===
 +
[[Image: Personal reflections one enigma.png|center|800px]]
 +
[[Image: Personal reflections two enigma.png|center|800px]]

Latest revision as of 23:15, 22 November 2017

LogoE.png


Home-enigma-active.png
Aboutus-enigma.png
Projectoverview-enigma.png
Projectmanagement-enigma.png
Documentation-enigma.png


Main Wiki Mid Term Wiki Final Wiki


Project Progress Summary


Enigma-Main Wiki.png


Final Slides

Final Presentation

Project Highlights

  • Delay in campaign launch due to unfortunate unforeseen events for our sponsor. Had to reduce period campaign ran and as a result, reduced our x-factor from 200 redemptions to 170 redemptions

Project Challenges

  • Familiarising ourselves with new programming languages (e.g php and javascript)
  • Learning to use off-the-shelf CMS (ExpressionEngine) to build a website for our client (e.g familiarising ourselves with the syntax). Used online guides and tutorials to learn PHP as well as how to use ExpressionEngine (CMS)
  • Learning how to utilise open-source API such as Chart.js and MailChimp
  • Blacklisting of IP address for some email clients due to previous owner. Liaised with server provider, DigitalOcean, to resolve the issue by getting a new server
  • Faced issue of email ban on the server due to DigitalOcean's policies. Had the ban removed by communicating our project and situation to DigitalOcean to ensure no malicious intent
  • Last minute changes of project scope requests from sponsor. Weighed the feasibility to accommodate to the changes according to the project timeline.

Project Achievements

  • Ability to generate customer database for clients from 0 to 177
  • Ability to gather feedback for voucher redemption process from real users for UAT 3
  • Ability to improve voucher redemption process (survey results on ease of use of voucher redemption from an average of 3.75/5 to 4/5)

Project Management

Project Status


S/N Module Function/Features Completion Remarks
1 Admin Account Module Login/Logout 100% Completed
2 Reset password 100% Completed
3 Product Search Module Search Product from global search 100% Completed
4 Filter search by brand, condition, category 100% Completed
5 Campaign Management Module Create/Update/Delete campaign with vouchers 100% Completed
6 View total vouchers redeemed all time/per month/today 100% Completed
7 View average vouchers redeemed per month 100% Completed
8 Generate QR Code for voucher redemption 100% Completed
9 View Campaign details and status 100% Completed
10 Generate campaign report 100% Completed
11 Voucher Redemption Module Automated email to send personalised voucher 100% Completed
12 Redeem voucher 100% Completed
13 Automated thank you email 100% Completed
14 Customer Management Module View clinics 100% Completed
15 Add/Update clinics 100% Completed
16 Search clinics 100% Completed
17 Sort clinics in alphabetical order 100% Completed
18 Export patient emails to MailChimp mailing list 100% Completed
19 Export patient emails to CSV File 100% Completed
20 Select emails to export based on gender/product/age 100% Completed
21 Clinic Admin Module Register clinic information 100% Completed
22 Login/Logout 100% Completed
23 Reset password 100% Completed
24 Update clinic information 100% Completed
25 Generate campaign report 100% Completed
26 View number of vouchers redeemed per campaign by last 7 days/month/overall 100% Completed
27 View total vouchers redeemed all time/per month/today 100% Completed
28 View demographic info of patients age/gender per campaign 100% Completed
29 Analytics Module View number of vouchers redeemed per campaign by last 7 days/month/overall 100% Completed
30 View demographic info of patients age/gender per campaign 100% Completed
31 View dollar amount redeemed by clinics per campaign 100% Completed
32 View campaign leaderboard by top 5 clinics overall/per campaign/per product 100% Completed
33 View campaign performance (Growth/ROI) 100% Completed
34 Bootstrap monthly product sales 100% Completed
35 Website Google Analytics 100% Completed
36 Communication Module Send enquiry to admin (website) 100% Completed
37 Send testimonial to admin (website) 100% Completed
38 Clinic Locator Module View clinics per product 100% Completed
39 Tag clinic location to Google Maps 100% Completed
40 Campaign Search Module Search campaign 100% Completed
41 Filter by month/active/ended 100% Completed

Project Scope (Planned vs Actual)


Planned Project Scope


Enigma-Original-Scope.PNG


Actual Project Scope
Enigma-Scope.PNG


Project Schedule (Planned vs Actual)


Planned Project Timeline
Enigma Project Timeline V1.JPG



Actual Project Timeline
Actual Project Timeline V3.PNG



Main Changes to Timeline

  • Bringing forward of Analytics Module from Sprint 8 to Sprint 5 to 7
  • Addition of Web Analytics Module into Sprint 7
  • Introduction of new feature for Customer Mgt Module - Notification of vouchers fully redeemed in Sprint 7
  • Changes made to campaign start date from 11 September to 21 September
  • Shifting of Campaign Search Module to Sprint 7
  • Addition of feature to select emails to export based on gender/product/age
  • Shifting of campaign performance module to Sprint 8


Project Metrics

The team is using Sprint Velocity, Sprint Burndown and Bug Metrics to ensure effective planning for our subsequent sprints. Each sprint is reviewed after completion and taken into consideration to gauge the number of tasks / story points the team can complete next sprint.

Sprint-Velocity-Enigma.png


Enigma Sprint Velocity Sprint 7.png


Enigma Burndown Chart.png


Enigma Burn Down Chart Sprint 9.png


Enigma Task Metrics Title.png


Enigma Task Metric Sprint 7.png


Bug-metrics-enigma.png


Enigma Bug Metrics Sprint 7.png


Project Risks


Enigma-Risk-Top3.PNG


Change Management


Enigma Project Change Management.JPG


Project Complexity


1. Changes in Voucher Redemption Flow
After analysing the business requirements of our sponsor, the voucher redemption process went through 2 rounds of revision to improve the efficiency and suitability of the process.

Enigma-VR-Initial.PNG


Process was not suitable because:

  • Requirement to download Aenon’s app to scan qr code posed as a resistance to redeeming the voucher
  • Aenon is not growing their customer database as no information from patients are collected

Process was inefficient because:

  • Clinic staff had to conduct manual work to keep their own record of vouchers redeemed

Enigma-VR-V2.PNG


Process was suitable because:

  • Collected basic customer data such as email, age, gender
  • Did not need patients to specially download a Aenon's application

After getting feedback from real users, process was deemed inefficient because:

  • Clinic staff is still involved in the process took unnecessary time (even though they are not doing manual work of recording transactions)

Enigma-VR-Current.PNG


Process was suitable because:

  • Maintains accountability for all vouchers redeemed for all campaigns
  • Collected basic customer data such as email, age, gender
  • Did not need patients to specially download a Aenon's application

Process was efficient because:

  • Removed clinic staff completely from the process

2. Password Encryption

Enigma-encrypt-1.PNG


EncryptText method was created by combining methods hexStringToByteArray and byteArrayToHexString which are existing methods found on the internet with our own codes that use Java api’s javax.crypto (SecretKeySpec and Cipher classes).

  • Before performing the encryption, we need a random key which we already pre-generated online and copied it into our application.
  • This random key is then converted to a byte array.
  • We then converted this byte array key to a secret key using SecretKeySpec with AES encryption defined as its algorithm.
  • A cipher object is then created using Cipher class that would implement AES Encryption and is used on the password to encrypt it.
  • The result is then converted and returned as a String.

3. Stacked Bar Charts (Chart.js)
Example below (Last 7 day performance of a clinic for a campaign):

Enigma-chart-1.PNG
  • Retrieve data of the performance of the clinic for a campaign for each day of the week
  • Place these values into integer arrays
  • Place arrays into JSONObject with related labels to be displayed for the charts.
Enigma-chart-2.PNG
  • JSONObjects are then stored in a JSONArray and sent to a javascript
Enigma-chart-3.PNG
  • Script will use dataset to display the data for the specific campaign of the clinic in the form of stacked bar charts


4. Campaign Performance
Initial Idea: Create campaign profitability predictor
Problems:

  • Clinics involved in campaigns don't have sufficient past data to build a predictor on (as these clinics are new clinics for our clients)

Intermediate Idea: Allow portal user to get gauged profitability and breakeven point of a campaign based on input values.
Problems:

  • Different clinics have different profit margins
  • Undesirable to our clients to share such sensitive information (i.e. profit margins)
  • Even if the programme did allow for the different profit margins to be entered, it would lead to increased manual work on the portal user's end.

Final Idea: Sales growth for clinics participating in campaign
Why the idea was accepted:

  • Did not require profit information (only needed sales information)
  • Did not require a lot of past data
  • Created a direct link between campaign and sales as Aenon did not perform other marketing efforts with the clinics involved in the campaign

Quality of product

Project Deliverables

Topic of Interest Link
Project Management Project Schedule
Metrics
Risk Management
Change Management
Project Overview Project Overview
Project Scope
Project X Factor
Project Technologies
Project Documentation Diagrams
Sprint Stories
Minutes
Prototype

Deployment

Enigma-View-Website.png
http://128.199.207.181/
Enigma-View-CCMS.png
http://128.199.207.181:8080/campaign_portal/
Enigma-View-Clinic-Portal.PNG
http://128.199.207.181:8080/Clinic_Portal

Testing

User Acceptance Testing 1
Test Plan
Objectives

  • Ensure that flow of website and voucher redemption process behaves as expected
  • Gather feedback regarding user experience and developed functions from real users
  • Proof of concept for voucher redemption process

Number of participants: 27 (17/27 respondents are from the pharmaceutical industry)
Date: 13-16 August 2017

Results/Key Findings for Website

  • Website (Ease of use): 4.15/5 (Goal: 4/5)
  • Website (Visually appealing): 3.89/5 (Goal: 4/5)

1. Some participants feel that the colour scheme of the website can be improved.
2. Some participants feel that the length of articles in the website is too long. Scrolling can be minimised.

Results/Key Findings for Voucher Redemption

  • Voucher (Ease of redemption): 3.74/5 (Goal: 4/5)
  • Voucher (Likeliness of using the process): 3.63/5 (Goal: 4/5)

1. Some participants feel that the voucher redemption process is too tedious.
2. Some participants feel that the involvement of clinic staff in the redemption process is unnecessary.

Future Actions
1. Improve colours and layout of the website to increase attractiveness and minimise scrolling.
2. Revise the voucher redemption process to remove/reduce the role of clinic receptionists in the voucher redemption process.


User Acceptance Testing 2
Test Plan
Objectives

  • Gather feedback from users regarding usability of Aenon admin portal and clinic portal.

Participants: 4 Aenon employees and 4 clinic staff
Date: 25 September 2017

Aenon Admin Portal
Key Findings/Improvements to be made
1. 1/4 of participants felt that there was a need for a breakdown of the number of redemptions for each day
2. 1/4 of participants faced difficulty in navigating to the page where they can download the QR code
3. 1/4 of participants highlighted that the clinic name tagged to the QR code is useful

Clinic Admin Portal
Key Findings/Improvements to be made
1. 1/4 participants mentioned the graph in home page should indicate the promotional value
2. 1/4 participants were confused by the labelling of dates on “the last 7 days” bar chart
3. 2/4 participants highlighted that the total amount to reimbursed was clear and useful
4. All participants generally feel that the clinic portal is simple and user-friendly


User Acceptance Testing 3
Test Plan
Objectives

  • Gather feedback from admin users regarding usability of Aenon admin portal.
  • Gather feedback from real campaign participants regarding user-friendliness of voucher redemption process.
  • Gather feedback from real campaign participants (patients) about usefulness and user experience of Aenon website.
  • Gather feedback from general public about usability and user experience of Aenon website.

Participants:
Website: 10 participants are from the pharmaceutical industry, 10 participants are from the general public aged 30-60, 20 participants are SMU students
Voucher Redemption Process: Out of 177 voucher redeemers emailed, 6 responded
Aenon Admin Portal: 3 Aenon employees
Date: 6 - 19 November 2017

Website
Key Findings/Improvements to be made

  • Participants confused with distributor's contact being on contact page instead of Aenon's contact (Accepted)
  • To have more images showing people using the products

Voucher Redemption
Key Findings/Improvements to be made

  • Redeem Now button in email is too small (Accepted)
  • Subsequent redemptions should have vouchers sent directly to the patient's email

Admin Portal
Key Findings/Improvements to be made

  • Campaign profitability information was unclear. (Accepted)
  • Unable to track the number of vouchers redeemed and the status of each campaign. (Accepted)
  • Leaderboard does not show action plan for Aenon when running campaigns. (Accepted)
  • In create campaign, allow 0 as an input amount for discount

Learning Outcome

Team Reflection

Team reflection enigma.PNG

Individual Reflection

Personal reflections one enigma.png
Personal reflections two enigma.png