•Data Management: Creating database of financial performance data that updates semi-automatically, increasing work productivity by cutting down time needed if the update is performed fully manually.•Data Analysis: Perform necessary analysis to supply information for two periodic reports powered by the company. Also perform necessary analysis to create charts that showcase the performance of the client’s portfolio against benchmarking indices and selected funds. The performed analysis are:calculating cumulative return of companies, calculating risk related ratios such as Sharpe ratio and CVaR, and creating a scoring system based on various parameters regarding the performance ofcompanies.•Data Visualization: Create dashboards that helps better visualize the financial performance of more than 3000 companies worldwide. Also create dashboards to visualize the periodical rebalancing model of client’s portfolios. All works involving data are done with advanced usage of Microsoft Excel.•Research: Perform research on potential outstanding companies to be included in the report. Also perform research to provide client with earnings call schedule calendar for companies in their portfolio.•Portfolio Optimization: Getting involved in the portfolio making process for the client, optimizing the expected return with the help of Microsoft Excel. Also involved in analyzing the best possible allocations for each portfolio constituent given the investment risk and the optimum expected return as stated previously.

-Developed spreadsheet-based project tracker to manage the database of projects uploaded to the platform from Indonesia.-Performed analysis from the obtained data to find insights.-Performed community research through social media to collect data on potential collaboration markets.-Held meetings with collaborating communities to explain how the platform works, or troubleshooting when there are problems on their side.-Helped communities uploading their projects by providing project descriptions in English.

-Observed the work sequence of road dismantling and site leveling.-Observed the geotechnical survey method to check on planned pavement elevation.-Involved in Indikator Kinerja Jalan (IKJ) inspection.-Performed measurement on work volume and dimension to check whether the work done is in accordance to technical drawing and designed plan.-Observed laboratory testing (compressive strength test of concrete) and site testing (sand cone test)-Observed the rigid pavement paving work sequence, from preparation works to finishing works.-Compiled daily and weekly report based on the observation on site.-Observed the management aspects (HSE, scheduling, and budgeting) of road preservation project.