About Education Experience Projects Coffee by the Porch Contact
Data · Finance · Engineering

Kaydon
Lim

Investment Data Analyst at St. James's Place Asia & Middle East — building portfolio analytics solutions and automating reporting processes.

LinkedIn GitHub Resume
3+ Years of industry experience
78% Index pricing review time cut at JPMorgan
CFA L1 Registered · Exam Nov 2026
Python SQL Apache Spark Power BI Bloomberg AWS ETL Workflows Investment Operations Machine Learning Alteryx Tableau Reference Data Python SQL Apache Spark Power BI Bloomberg AWS ETL Workflows Investment Operations Machine Learning Alteryx Tableau Reference Data
Who I am
Data analyst.
Builder.
Coffee person.

I'm a data analyst based in Singapore, working at the intersection of financial markets and data infrastructure. My work spans building investment dashboards, automating reporting pipelines, and making sense of messy market data - across firms like St. James's Place, JPMorgan, and Caladan.

My background in Information Systems (Business Analytics) from SMU gave me the technical foundation, but it's the time spent inside trading desks and investment operations that shaped how I think about data — not just as output, but as a decision-making input that has to be accurate, timely, and trusted.

Outside of work, I run a home café called Coffee by the Porch — featured in Channel News Asia and The Straits Times — and I'm currently preparing for the CFA Level 1 exam in November 2026. I find the overlap between finance theory and day-to-day market data work genuinely interesting.

Currently
Investment Data Analyst at St. James's Place Asia & Middle East Preparing for CFA Level 1 — Exam: November 2026 Exploring cloud data engineering (AWS, Spark pipelines)
Where I studied

Education

Singapore Management University
BSc Information Systems
Major in Business Analytics
Graduated Jul 2025
Coursework Big Data Architecture (A+) · Social Analytics · Data Mining & Business Analytics
Activities
SMU Blockchain Club — Sector Head SMU Business Intelligence & Analytics SMU FinTech Project Kapawa — Program Lead
What I work with

Skills & Toolset

Technical
Python SQL Spark Hadoop Tableau Power BI AWS Git Alteryx Microsoft Fabric Microsoft Power Platform Machine Learning
Domain knowledge
Investment Operations Reference Data Market Data Analysis Financial Markets Crypto Markets DCF Valuation
Soft skills & certs
Analytical Thinking Project Management Client Engagement Applied ML (Heicoders) DCF Valuation (CFI) CFA L1 — Nov 2026
Where I've worked

Experience

Jan 2026 — Present
St. James's Place Asia & Middle East
Full-time
Investment Data Analyst – Portfolio Management
  • Designed the firm's first Power BI dashboard tracking funds across 7 third-party platforms, giving portfolio managers granular visibility into client fund distribution and concentration risk across £441bn AUM
  • Architect and deliver MI dashboards used in senior stakeholder reviews, translating complex portfolio data into clear, decision-ready reporting
  • Drive automation of recurring data workflows and client statement generation via Python and SQL, eliminating manual bottlenecks in the reporting cycle
  • Shape the investment analytics roadmap, championing data quality, scalability, and governance as the foundation for reliable automation
Jun — Dec 2025
JPMorgan Chase & Co
Contract
Reference Data Analyst – Global Valuation Services
  • Built Python and Alteryx automation workflows that cut Index Pricing review time from 45 min → 10 min, a 78% reduction in manual processing
  • Ensured integrity of pricing and valuation data across equities, fixed income, and derivatives feeding into investment reports and performance analysis
  • Triangulated valuations across Bloomberg, Reuters, and ICE to catch discrepancies before they reached downstream client systems
  • Served as the operational bridge between global teams — Operations, Client Service, and Fund Accountants — to resolve data issues and tighten reporting workflows
May — Dec 2024
Caladan (fmr. AlphaLab Capital)
Internship
Data Analyst Intern – Market Maker (Trading)
  • Co-led the quarterly State of Liquidity Report for institutional clients — restructured the methodology to lift accuracy by 15% and sharpen client-facing research output
  • Designed ETL pipelines to ingest, clean, and normalise on-chain data from disparate sources, forming the data backbone for cryptocurrency valuation analysis
  • Researched and back-tested predictive trading strategies including mean-reversion and trend-following models, applying Linear Regression and PCA to contribute to algorithm development
  • Extended the data stack by integrating alternative signals — GitHub commit activity and social media sentiment — with market APIs via a custom Python ETL framework
Side builds

Projects

Market Sentiment Analysis

Web scraping system extracting market sentiments and financial data from Coinglass and CNN. ETL pipeline aggregates signals to surface correlation between crypto and equity markets.

Selenium Polars ETL Crypto
Coffee by the Porch – POS System

Custom point-of-sale system built from scratch to run a home café, automating order management and syncing to Google Sheets for real-time inventory and operations tracking.

Flask Google Sheets API Python
Featured Venture

Coffee
by the Porch

A home-based café born from a genuine love of coffee and baking. What started as a passion project turned into a media-featured small business — and an engineering challenge. Beyond the brews, a custom POS system was built using Flask and the Google Sheets API to automate order management and operational workflows.

Channel News Asia The Straits Times
Stack: Flask · Google Sheets API · Python — automating orders, inventory, and reporting end-to-end.