Calvin Wang Email & Phone Number

- Built and optimized cefi and defi data pipelines & warehouses to ensure data accuracy and quality- Enhanced PnL calculation pipeline stability by building general test cases and edge cases, reducing PnL calculation issue rate by 18%.- Conducted real-time company-wide hedger exposure checker with streamlined data to avoid any potential risk or loss by developing efficient data collection and auto alert notification.- Restructured database schema by separating self-defined data and… Show more - Built and optimized cefi and defi data pipelines & warehouses to ensure data accuracy and quality- Enhanced PnL calculation pipeline stability by building general test cases and edge cases, reducing PnL calculation issue rate by 18%.- Conducted real-time company-wide hedger exposure checker with streamlined data to avoid any potential risk or loss by developing efficient data collection and auto alert notification.- Restructured database schema by separating self-defined data and api returned data into multiple related tables in MySQL database.- Developed tools and interfaces with python scripts to reduce manually operation time and decrease error rate. Show less

- Developed and implemented predictive machine learning models using Python, Sklearnand SQL to increase online CVR by 2 times- Conducted A/B testing on product features such as product recommendation using GoogleOptimizer to determine optimal designs, resulted in 17% AUS growth- Developed and maintained a data warehouse and data lake on GCP for storing, processing,analyzing and reporting from multiple sources including analytics tools such as GoogleAnalytics-… Show more - Developed and implemented predictive machine learning models using Python, Sklearnand SQL to increase online CVR by 2 times- Conducted A/B testing on product features such as product recommendation using GoogleOptimizer to determine optimal designs, resulted in 17% AUS growth- Developed and maintained a data warehouse and data lake on GCP for storing, processing,analyzing and reporting from multiple sources including analytics tools such as GoogleAnalytics- Analyzed customer behavioral data on website and offline shopping data with Python,SQL and R to identify opportunities for growth in revenue and retention rate- Built an automated data pipeline on GCP using Airflow with DBT to ensure data accuracyand dependency before deployment into the production environment- Collaborated with product managers and CRM managers to perform customer segmentations thatidentified potential customer to increase physical event attend rate by 38% and save cost by 14% Show less

- Analyzing receipt data of Taiwan for over 10+ billion with Python and MySQL- Applying statistics model and hypothesis testing to demystify consumer behavior after different campaigns and events, increasing repurchasing rate by 20%

- Produced 15+ reports for e-commerce, sales and supply chain to track KPIs to help decision making, such as reducing advertisement cost and setting product combination which increase revenue by 30%- Overhauled 5+ automatic dashboards with Python, Excel and Tableau, reduced 60% of time to update manually- Obtained 30%+ penetration rate of new product by crawling external data and collecting customer surveys to set the price

- Optimized ads performance by conducting A/B testing and analyzed data from Google Analytics; brought out ads which CTR was over 8% and ROAS over 10- In charge of 10+ clients from different industries, including E-commerce and finance for 600K of advertising budget per month