Following the hackathon, we have came out with additional features that we will be implementing. 














We have planned to implement an e-sign feature that allows users to simply sign directly on the website and upload their signature instead of using a third party app to sign to upload the signature. This enhances user experience by making their creating of application process much simpler. Next, we have an SMS and email system where an email and SMS would be sent to the user when they have any updates, prompting the user to log in to the web or mobile application to view the updates. There is also going to be a dashboard analytics that allows the staff to view the overview of customers' applications. In a glance, they are able to deduce which digital securities account has the most number of applications and which has the least. They are able view the trend of the number of applications created overtime as well as a gauge that shows how many applications that the staff still need to process. Lastly, a mobile application would be created to allow users to simply view their application status on their mobile phones. This is in addition to cleaning up the web application, such as beautifying the user interface, creating an application for new users to apply, as well as improving the staff updating application status process. 

In our team, we have allocated roles based on our skillsets. Ming Feng would continue to make improvements to the web application, Junxi and Yu Zet would be in charge of AWS, while me and Luismika would be in charge of the mobile application. As only Junxi had experience creating both AWS and mobile applications, he was the one who gave our team a rough guideline on how we were going to build our solution.

Sprint 1 ( 9 Jan - 15 Jan)

In sprint 1, our sprint goal was to improve overall web application appearance and implementation of e-signature while moving database from MySQL to Amazon Web Services. Ming Feng continued working on the web application to allow users to create an application through the website and implemented the e-signature feature. Luismika worked on the part where staff is able to update customer's application, I helped to beautify the web application that was rather plain as there wasn't enough time during the hackathon to do so. Lastly, Junxi started working on the database transportation from MySQL to AWS. We had several other assignments to complete during this week, hence, the progress was little. 

Some problems we faced during this sprint was finding a way to connect our web application and mobile application together with a common database. As our web application was done using ASP.NET, it would be a lot of work to migrate the database from SQL to another platform and we were unsure if we could finish that on time. Hence, we had to do a lot of research to find other easier ways to do so.

Our Progress Showcase



















Sprint 2 ( 16 Jan - 22 Jan)

In sprint 2, our sprint goal was to start on the Android Application, a SMS/Email Notification for customers and a Dashboard for Staff. I created the staff dashboard using power Bi and embedded it into our web application. This dashboard is interactive and the values and visualizations changes according to the filters applied. Initially, I did a lot of research, trying to find the most effective way that we could build the dashboard. Many platforms did not offer either the embedding into a web application feature or the data could not be exported from SQL to the platform. Hence, I decided to settle for power Bi, despite the embedded code being a paid feature. Luckily, there was a free 60 days trial which I used to create the dashboard. However, there was still a slight issue, which was that users need to sign into power Bi for the dashboard to be shown on the web application. 

Next, I also started on the mobile application, using Android studios. As I had no experience in building mobile applications and did not take the mobile application development elective (MAD), I had a hard time trying to start the app. I seeked advice from Junxi as well as my other friends who had taken MAD on the steps I should take to start building the app. I took some Linkedin courses on java and how to use android studios and the learning process took awhile before I managed to start on the application. I created the login page where users are able to login with their access code and the password that they have created. If the user is new, they are able to sign up with their access code and create a password. They are able to change their password in the app as well. The status tracker was also created that can show users their applications status as well as the estimated date of completion. Users can also enable the app notifications to receive updates on the application. Additionally, the app also have financial alerts to remind users to be cautious of scams. Luismika assisted me in finding the images and icons needed for the pages as well as gave me advise on the layout.

Junxi managed to deploy the SMS and Email system using AWS and connect the dynamodb to both the web application as well as the mobile application. 

Our Progress Showcase
















 
 
 
 

Recourses I used

I did some self-learning about how to create mobile apps using android studios on Linkedin Learning and it really helped me in understanding and creating the mobile application. 




















Sprint 3 ( 23 Jan - 29 Jan)

In sprint 3, our sprint goal was to do the testing of the android application for bugs and create presentation slides and recording. Me and Luismika finalized the mobile application and asked the team to test the application. The SMS and email system was also being tested and the 3 products are being combined together. As our team was quite busy with other assignments on that week, we only managed to meet up to complete the slides and video recording on 3rd Feb, the day of submission. Luismika helped to complete the group component of the slides together with his individual portion while the rest of us completed our individual portion. The video demo recording was done by Ming Feng, Junxi, and me and I helped to compile the recordings and edit them together.

Our last meetup before the assignment was due





















Our Final Trello board