d
derrick_chia

Derrick

@derrick_chia

Data Analyst

Singapour
Anglais
Certaines informations sont présentées en anglais.
À propos de moi
I’m a Data Analyst with hands-on experience in Excel, Power BI, Power Query, HubSpot CRM, and marketing data analysis. I specialize in turning raw and complex data into clear dashboards, reports, and actionable business insights. I can help with data cleaning, Excel automation, dashboard creation, sales and marketing funnel analysis, conversion tracking, and performance reporting. I focus on creating practical and easy-to-understand solutions that help businesses make better decisions from their data.... Plus d’infos

Compétences

d
derrick_chia
Derrick
hors ligne • 

Voir mes services

Nettoyage des données
I will analyze and create professional excel dashboards from your business data

Expérience professionnelle

Babilala

Performance Marketing Analyst

Babilala • Temps plein

May 2025 - Present1 yr 3 mos

Developed executive dashboards and KPI reports for senior management, monitoring marketing and enrolment performance across 60+ preschool centres. Built end-to-end funnel reporting covering Leads, Qualified Leads, Tours, Contracts, and Commencement. Consolidated and analysed data from HubSpot, LittleLives, ManyChat, and multiple marketing channels to evaluate campaign performance, conversion rates, lead quality, and customer behaviour. Automated reporting and business processes using Excel, VBA, Google Apps Script, Zapier, and AI-assisted workflows, reducing repetitive manual work by approximately 50%. Conducted funnel leakage, withdrawal trends, budgeting, forecasting, and data quality analysis to support management decision-making. Also developed predictive planning models using historical data and centre benchmarks to improve forecasting and performance planning.

Accounting_Direct

Data Analyst

Accounting Direct • Temps plein

Feb 2024 - Present2 yrs 6 mos

Built and maintained business dashboards using Superset, Metabase, and Looker Studio, covering MRR, churn, growth, NDR, sales, marketing, and CRM KPIs. Developed and optimized SQL queries for complex subscription and revenue analysis. Built Python and Airflow ETL pipelines integrating data from Chargebee, HubSpot, Google Ads, and Google Analytics. Automated recurring reports and provided customer segmentation and performance insights to support business decision-making.