Finance BI

We build modern data infrastructure on Azure

Building on the cloud is hard. But it can give your company the flexibility it needs to do business in this fast changing world.

We can help you build a solid, flexible and cost-effective solution.

We are experts in Microsoft Azure and Databricks solutions, and have helped over 50 companies in their transformations across the years.

Ready for data to speed up your business instead of slowing it down? Let’s chat

Owner and Azure Data Consultant

Data Walnut

You worked hard to get your B2C e-commerce store off the ground. And now it’s doing well

But what is the potential of your store: how much better can it do ?

What would happen if you knew the customer lifetime value and could segment your customers ? 
And then find the best action for each segment?
What would happen if you knew the ROI of your marketing campaigns ?
What would happen if you knew the customers at risk of churn and how to retain them ?

You already have all the data, now it’s about getting your data to work for you.

Let’s take your store to the next level together

Founder

L'Oréal

Data and Finance Manager

Unilever

Strategy Analyst

Golder Associates (Italy)

Controller

Academy of Math and Science (USA)

Accountant/Controller

CPA turned Data Engineer: cut data crunching by 10 hours/week with automated processing and data quality checks ⚡️Azure - Databricks - Power BI

I can help you leverage your data in 2 ways:

1- Consulting activity: Azure data consulting
I help companies build a modern data infrastructure (data lake, data warehouse) on the Azure cloud.
Expertise: Azure, Synapse, Databricks, SQL, Python, Power BI

2- Data product: help e-commerce sites with customer retention
My solution helps e-commerce sites segment their customers, approach the segments differently and increase retention.
Expertise: Customer lifetime value, customer retention, customer upsell, B2C e-commerce.

Luca Zanna

Handshakes by DC Frontiers

New Product Analytics:
• Built the analytics of a new product, Datamart from scratch by setting up the click trackers at strategic points in the web application and combining data from different sources such as SQL server, MongoDB, Google Analytics, LinkedIn and Facebook Posts, Google Ads and EDMs into one single Power BI dashboard, allowing stakeholders to monitor users at different stages: from awareness to interest to engagements such as sign-ups, logins, and user interactions on the Datamart app

Data Scientist

Dashboards and Analytics
• Initiated a data-driven culture by introducing dashboard tools (Power BI) and built dashboards for products and sales teams to understand user behaviour on the company's 2 web applications (handshakes and scoutasia) in order for them to make informed business decisions on product enhancements and customer segment penetration

Data Reporting:
• Serviced ad-hoc data requests for both internal and external stakeholders and generated (some amount) through external clients data sales requests alone

Analytics Engineering
• Automated and maintained the analytics ETL pipeline, combining data from various and transforming them into a single data warehouse that is analytics ready to display in dashboards and data reports

Data Analyst

AlphaSwap

AlphaSwap is a first-of-its-kind investment platform that redefines the asset management industry by bundling the community's best stock picks into Data-as-a-Service. Aspiring investment analysts and asset managers can build a track record of equity ideas and get paid based on their individual portfolio's performance

•	Analysed the company’s portfolio to determine its active share, diversification and concentration risk and presented these insights and recommendations on how to improve their portfolio positions. The analysis was subsequently productised into a portfolio factsheet
•	Analysed their users based on performance, investor type, years of experience and number of submitted ideas and determined if there are any correlation between the community’s performance with each of the other variables and presented these insights on Tableau and provided recommendations on customer segment that they should incentivise and focus on
•	Analysed 200 equities proposed by investors on the platform using the DCF, dividend discount and price multiples valuation methods and crafted thesis statements to summarise each equity’s investment decision
•	Generated a portfolio of equity investments on the platform focusing on the U.S., Chinese and South Korean information technology, banking, airline, renewable energy and automotive industries
•	Researched and analysed the effects of ESG and alternative data such as market sentiment and crowdsourcing on performance to generate superior alpha for the company’s portfolio
•	Conducted a top-down market sizing due diligence analysis on hedge funds, neobanks and wealth techs to determine their AUMs and potential profit penetration, which were subsequently pitched to venture capitalists for funding
•	Researched and created content for an investment resource page similar to Investopedia to help investors learn how to use indicators, instruments and benchmarks to make better investment decisions

Business Development Analyst

Research write-ups of 12 of my highest conviction stock picks down in the google drive link below. Do check it out if interested!

Idea Generator

Singapore Management University

Teaching Assistant (FNCE6006 Equity Analysis & Portfolio Management)

Teaching Assistant (QF623 Portfolio Management)

SMU Piano Ensemble "Ivory Keys"

- Directed an executive committee of 6 members in organising performances and showcases throughout the year.
- Spearheaded the organisation and execution of 2 school recitals in January and June 2019 and an annual production at the Esplanade Recital Studio on January 2020.
- Collaborated with National Parks Board to perform at iLight Singapore 2019's Keys of Light installation.
- Collaborated with Jurong Community Hospital to organise a Father's Day themed performance for 40 elderly patients
- Pitched the club to the student body during the recitals and annual general meetings.

President

First Data Corporation

- Analysed the company’s financials to project its revenue growth for the next five years.
- Scrutinised the critical revenue drivers and key trends of the payment industry and proposed a future direction for the company that would boost revenue by up to 20%
- Analysed and compared the old and new merchant rates and conducted a cost-benefit analysis to determine the appropriate merchant discount model that would provide a win-win situation for both the company and its clients
- Analysed financial statements and assisted in processing invoices and claims on a daily basis

Finance Intern

Singapore Armed Forces

- Trained as a medic with basic first aid and life saving skills for 3 months 
- Provided medical screening for pre-enlistees coming for their national service medical check-up
- Trained 4 medics in handling the X-ray department within a span of two years that I was in service
- Managed a team of 4 medics to execute the annual Medics Training Drill

Service Medic

Collins Aerospace

- Designed the layout of a client airport with the company’s new system installations using SketchUp design software
- Pitched the design to the client and the contract was renewed
- Designed a sleek presentation on Prezi for the annual regional summit

Airport Solutions Contract Staff

- Conceptualized a new idea specific to improving efficiency in end-to-end passenger processing in airports as part of project work assigned
- Presented this new idea to the hiring managers
- Directed a team of 3 in a major project for the company 
- Successfully compared the functions and user experiences of two departure control systems that the company is intending to pitch to a potential airport customer.
- Designed a 3D airport model and walkthrough video using SketchUp with the company's new installations and systems to be pitched to a new client airport.
- Conducted a market research analysis of major competitors' technologies and achievements and proposed ways to drive the company's innovations forward.

Airport Solutions Intern

I am a Singapore Management University Bachelor's of Business Management fresh graduate who majored in Quantitative Finance and Economics.

As a self-driven individual with a strong passion for statistical and data analytics, I have acquired data analytics skills in Excel, SQL, Python and R, predictive analytics skills and machine learning in Python and R, as well as data visualization skills in Tableau and Power BI. I have also built up a data science portfolio, analysing different types of dataset from Kaggle through various perspectives and have experienced building machine learning algorithms and visualisation dashboards to convey sizable and relatable stories and insights from data. 

Check out my data science portfolio here: 
Github Codes: https://github.com/itzhongee/PortfolioProjects
Tableau Public profile: https://public.tableau.com/app/profile/hong.ee.leow

taplio

The Battle

Luca Zanna

Hong Ee Leow

Followers

Posts

Engagements

Likes

Ready to grow your LinkedIn presence?