Caroline Wang

đź‘‹ Hey, I'm Caroline

I'm a data and technology enthusiast who loves turning curiosity into insights and creations. This site is where I capture the sparks, lessons, and stories I discover along the way.

Skills

Programming
PythonSQLRNoSQLJavaScriptHTMLGitDocker
Data & Analytics
PySparkSpark SQLETL PipelinesData ModelingData VisualizationA/B TestingMLOps
Cloud & Tools
AzureDatabricksPower BITableauCollibra
Business & Finance
Excel (VBA, Financial Modeling)Risk AssessmentPortfolio AnalysisForecasting & Scenario Modeling

Blog

Work Experience

Enbridge logo

IT Analyst

Enbridge

Aug 2025 - Present

Leading data analysis initiatives and developing advanced analytics solutions using Python and SQL. Creating interactive dashboards and reports to drive strategic business decisions and operational efficiency.

Enbridge logo

Data and Analytics Intern

Enbridge

May 2025 - Aug 2025

Building ETL pipelines in Azure Databricks and modernizing legacy SAS workflows. Strengthening data governance and supporting AI innovation projects.

China CITIC Financial Asset Management logo

Business Manager

China CITIC Financial Asset Management

Mar 2020 - Jun 2024

Led large-scale analytical modeling and forecasting initiatives on asset portfolios, delivering strategic insights and standardized frameworks for executive planning.

China CITIC Financial Asset Management logo

Deputy Business Manager

China CITIC Financial Asset Management

Jul 2017 - Mar 2020

Developed portfolio models and KPI frameworks, integrating financial and operational data to drive transparency and cross-department decision-making.

China CITIC Financial Asset Management logo

Assistant Business Manager

China CITIC Financial Asset Management

May 2015 - Jul 2017

Applied stress testing and scenario analysis on asset portfolios, building dashboards and reports to support risk monitoring and financial oversight.

Standard Chartered Bank logo

RM Operating Model & Sales Tool Manager

Standard Chartered Bank

Feb 2014 - May 2015

Developed customer segmentation models and optimization tools with interactive dashboards to improve client targeting, RM productivity, and cross-border reporting consistency.

Standard Chartered Bank logo

Management Trainee

Standard Chartered Bank

Aug 2012 - Feb 2014

Consolidated multi-market data into standardized KPI scorecards and streamlined reporting workflows to support personalized marketing and strategic growth analysis.

Projects

Recipe Finder

Developed an intelligent recipe search and recommendation system using Streamlit, PostgreSQL, and TheMealDB API. The application enables smart recipe discovery by name, ingredient, category, or region, with automatic data synchronization, card-based rich display of recipes, and a responsive modern interface for seamless user experience.

StreamlitPythonPostgreSQLSQLAlchemyTheMealDB APIHTML/CSSData SynchronizationRecommendation System

Shopify Sales & Customer Funnel Dashboard (Power BI)

Designed and developed an interactive Power BI dashboard to analyze Shopify sales performance and customer funnel behavior. Integrated multiple datasets, applied advanced DAX calculations, and implemented data modeling to deliver insights on KPIs, customer segmentation, payment methods, and regional sales distribution.

Power BIDAXPower Query (ETL)Data ModelingInteractive VisualizationsGeospatial Mapping

Dynamic Sales Dashboard (Tableau)

Developed an interactive Tableau dashboard to monitor sales, profit, and quantity performance across multiple segments and regions. The visualization highlights KPI trends, state-level sales distribution, customer segment patterns, and manager-level performance, enabling quick identification of growth opportunities and underperforming areas.

TableauData VisualizationKPI TrackingGeospatial AnalysisTrend & Segmentation Analysis

Electric Vehicle Data Analysis (Tableau)

Built an interactive Tableau dashboard to analyze the adoption of electric vehicles (EVs) across the U.S. The dashboard tracks total vehicles, BEV vs. PHEV share, average electric range, and CAFV eligibility. It provides insights into trends by model year, leading manufacturers, top-selling EV models, and state-level distribution, supporting data-driven evaluation of EV market growth.

TableauData VisualizationTrend AnalysisMarket SegmentationGeospatial Mapping