My Project and Portfolio

 My Project and Portfolio



Hello everyone, I am Nabil, I am an Actuarial Science graduate. In this post, I will share some of the projects that my colleagues and I have worked on. The scope of this project includes the fields of Actuarial, data analytics, data science, and product design. Here are some of my projects:

1. Dashboard dan Pemodelan Data Pariwisata Jawa Barat

This project is a project made by me and my friend in the 2021 National Data Science Tournament (TSDN) competition organized by Cyber Trend Data Academy. In the competition, participants are required to analyze and get insights from several available datasets. Our team decided to use tourism data in West Java. The purpose of using tourism data is to assist the government in restoring tourism affected by COVID-19. From our analysis, the government can find out the tourism potential of each region that can be promoted again after COVID-19. In addition, the government can also find out which regions have not maximized their tourism potential based on the classification model formed. 

In full, this project can be seen at the following link: 
  • Details and explanation: https://bit.ly/Persentasi_TSDN
  • Notebook: https://bit.ly/Notebook_Klasifikasi
  • Dashboard: https://bit.ly/Dashboard_TSDN

2. Asia Student Paper Competition

In 2021, my colleagues and I had the opportunity to participate in the Asia Student Paper Competition organized by Universitas Islam Indonesia (UII). The competition was attended by students from various countries in Asia. In this competition, participants were given a challenge to make an academic paper within the scope of statistics and its application. 



The competition begins with abstract submission, abstract acceptance, full paper submission, selection of the 30 best papers, and final determination of the 3 best papers through presentations held online on July 23, 2022. Long story short, my team and I, who are all from the actuarial department, decided to make and submit a paper entitled "Estimation of Prospective Benefit Reserve Based on Gross Premium Valuation Method using Indonesian Mortality Table IV and De Moivre Assumptions". 

The paper that my colleague and I made in this competition, the details can be seen at the following link
https://www.researchgate.net/publication/367644173_Estimation_of_Prospective_Benefit_Reserve_Based_on_Gross_Premium_Valuation_Method_using_Indonesian_Mortality_Table_IV_and_De-Moivre_Assumptions.

3. Classification Project



In 2022, I, my lecturers, and my colleagues made a data science paper entitled "Pengelompokan Tingkat Pengangguran, Kemiskinan, dan Pendapatan di Kabupaten/Kota Provinsi Jawa Barat Menggunakan Metode K-Means dan Metode Fuzzy C-Means". In the paper, we conducted clustering of cities in West Java based on several economic indicators using K-Means Method and Fuzzy C-Means Method analysis. The purpose of grouping these regions is so that the government can make policies according to social and economic conditions so as to reduce inequality and advance the province of West Java.

In full, this paper can be seen at the following link: https://bit.ly/KMeans_FuzzyCMeans

4. Paper project with my lecturers

In August 2022, my lecturer told me to assist her in making a paper with the scope of stochastic modeling. The paper was titled "Jump Diffusion Model for Stock Market Price of Small and Medium-Size Enterprises". In 2022, the paper was successfully published in the American Institute of Physics (AIP) proceedings.

In full, this paper can be seen at the following link: 
https://pubs.aip.org/aip/acp/article-abstract/2982/1/020018/2933228/Jump-diffusion-model-for-stock-market-price-of?redirectedFrom=fulltext

5. Normal Cost and Actuarial Liability Calculation Application


The next project I have is an application project for calculating Normal Costs and Actuarial liabilities of pension funds using the Python programming language. This project was made with my colleagues with the aim of making it easier for companies to calculate Normal Costs and estimate Actuarial Liabilities for each existing pension fund participant. In addition, this application can model moving interest rates using the CIR interest rate model. The application is expected to be useful in the industry, especially the pension fund industry.

The links of the application prototype are as follows: https://bit.ly/NC_AL

6. Scientific writing project


The project of making scientific papers this time was made together with my colleague. This project is about actuarial calculations in the pension fund industry. The scientific paper that my colleague and I made was entitled "Estimasi Iuran Program Pensiun Normal Menggunakan Rantai Markov dan Suku Bunga CIR". This scientific paper discusses the application of Markov chains and moving interest rates in the Pension Fund Industry.

More details can be seen directly in the scientific paper file that my colleagues and I have compiled at the following link: https://bit.ly/Paper_Dapen

7. My Last Competition as A Student


At the end of 2023 until February 2024, my friends and I again had the opportunity to participate in a competition, this time the Actuarial Case Competition organized by Logika 2024, Department of Mathematics, Universitas of Indonesia. In the competition, participants were challenged to design an insurance product that could solve or at least reduce the social problem of child labor.

My team and I made a paper entitled "Perancangan Produk Asuransi untuk Mengatasi Masalah Pekerja Anak di Indonesia".  In addition to designing the product, we also need to calculate the amount of premiums that must be paid by prospective participants and their reserves.

The following is the paper we made: https://bit.ly/ACUI_Competition

8. My Works During My Internship 

When I did an internship program at one of the banks in Indonesia, I had the opportunity to directly participate in designing some of the Digital Bank features of the bank. I had the opportunity to use Figma as a tool to design the UI/UX of the features being created. The following are some of the preview designs that my seniors and I made at the internship site.


From this internship experience, I learned a lot about the banking system, especially in the digital banking department. I also learned valuable lessons from my seniors about product development processes in banking.

9. Dynamic Dashboard in Excel

This project was built using Excel 2019 and features a dynamic dashboard created from raw Superstore data. The dashboard is designed to be highly interactive, providing users with the ability to scroll and spin through data, as well as integrated slicers for easy data filtering. One of the standout features of this dashboard is the dynamic title that changes automatically based on the slicer selection, offering a customized and context-sensitive user experience.


To create this dashboard, various powerful features of Excel were utilized, including pivot tables for data summarization and analysis, pivot charts for visual representation, and slicers for interactive data filtering. Additionally, form controls such as scrollers and spinners were employed to enhance interactivity, along with several other Excel functions that contribute to the overall functionality and user experience of the dashboard. This comprehensive and interactive dashboard allows users to seamlessly navigate and analyze key metrics from the Superstore data.
This is my Dashboard: https://bit.ly/ProjectDynamicDashboard* *Better accessed in Excel desktop for more features (In Excel Web version, form control feature is not available)

10. VBA Project Automation for Amortization Table and Credit Life Insurance Premium Calculation

This project was created to fill my free time and to improve my skills in using Excel, particularly Macro-VBA. Banks and finance companies often need automated tools to calculate loan installments for borrowers. This project creates a tool that can determine the installments a borrower needs to pay and provides a detailed amortization table. This table shows each payment period, the amount of interest and principal paid, and the remaining loan balance after each payment.

Additionally, banks and finance companies often use life insurance services to insure their borrowers. This ensures that if a borrower passes away during the loan period, the remaining loan balance (outstanding balance) can be covered by the insurance. Therefore, this project also includes an estimate of the net single premium for Credit Life Insurance that the borrower needs to pay. This project utilizes Visual Basic for Application (VBA) for calculations and assembling the amortization table. The installments in this project are annual and can be updated for monthly use with minor adjustments to the VBA code.

Project's File: https://bit.ly/ProjectVBANabil


Those are some of the portfolios and projects I've made, I still want to work on and make other works. See you soon!








Comments

Popular posts from this blog

Natural Phenomenon( A sun dog)