Ting Lan Email & Phone Number

Canada

Toronto, On, Canada

- Integrated multi-dimensional e-ticket sales data with SQL to construct post-campaign analytics dataset- Preprocessed and cleansed digital-marketing impression data, response record and relevant information from label inventory; illustrated corresponding uni-variable correlations with CTR and CVRPerformed exploratory data analysis utilizing GCP to construct generalized portrait of customers with high LTV- Generated strong-potential customers list applying both rule-based and machine learning strategies for subsequent campaigns, which led to a 25%+ increase in sales - Aggregated multi-source data from vendor APIs and transformed raw data into standard schema; automated the ETL pipeline utilizing Python numerical programming skillsEvaluated marketing campaigns from multiple assessing metrics and composed ad-hoc reports on GCP to illustrate business insights

Chicago,Il

Chicago,Illinois

• Validated propensity models and measured performance by using model evaluation tools• Rebuilt machine learning model by using Python to support target customers selection • Built large dataset for machine learning with Hive • Created a prototype for a new feature on mobile app to improve customer experience• Visualized output of predictive model to provide reliable insights of project and worked closely with cross-functional team

Toronto, Canada Area

- Made successful recommendations to existing customers based on their portfolios by‘story-telling’ strategy- Completed transactions such as deposits, withdrawals, and bills payment for customers in a timely and efficient manner- Analyzed 10,000+ data points to interpret customer behavior patterns and identified sales opportunities- Built a personal connection with customers by engaging them in conversations to understand their needs deeply- Handled customer complaints in a time- and money-saving manner while being courteous 100% of the time

California

- Conducted strategic research and wrote reports of different industries according to clients’ demand by using Bloomberg terminal and Excel/VBAMade cold calls to potential buyers ,drafted and offered memorandum

Guangzhou, Guangdong, China

-Created a regression model of 5 options of significant benchmarks to evaluate their correlations- Built up a model within Excel to evaluate importance of the 7 segmentations of Big Data industry (database management, data visualization, data mining, stream,etc), and visualized the result by Python- Presented recommendations on promotion methodology of military technology to audience (20 people )

Greater New York City Area

- Customized DCF and Comparable Company Analysis model for valuations under varying operating scenarios and performed valuation analysis with Excel- Generated investment reports supported by in-depth industry analysis and fundamental research - Presented investment recommendations to managers with the derived financial estimated

Toronto, Canada Area

- Serve exiting accounts, obtaining orders new accounts for potential new customers- Delivered products to customers throughout Canada- Wrote blogs to promote Nu skin products through social network platforms in North America- Recommended new products to customers based on their skin type, answered inquiries

Guangzhou, Guangdong, China

- Assisted handling daily complains from Fx transactions issues- Identified errors and discrepancies in applicants’ documents during approval process- Drafted the acceptance policies and related documentations of Letter of Credit for different clients

Shenzhen, Guangdong, China

-Analyzed client’s feedbacks based on 400 service surveys- Handled and resolved customer complaints ,promoted company’s service through sales calls

Master Of Management In Artificial Intelligence, Artificial Intelligence

Master Of Science - Ms, Business Analytics

Master of Business Analytics in 2017 Big Data Data mining, Advanced Database management, Data visualization for Business, Business.

Bachelor Of Science, Mathematics And Economics

Activities and Societies: THECREW Urban DanceSpecialization in fields of Mathematics, Microeconomics,Macroeconomics, International Finance.

High School Diploma, Economics

Activities and Societies: Sparkling Dance Crew