Chengyi X. Email & Phone Number

Menlo Park, CA, US

Monetization Ecosystem - ads business and core

Plantation, Florida, US

Supply Chain Analytics (Delivery Experience)

Seattle, WA, US

• Work as the DS lead to validate the accuracy of Hi-Fi, 1st high-fidelity visibility concept and tool sets for shipment tracking in the logistic industry, through analyzing current data models, writing data pipelines to.
• Architect, build, and launch new ERD events, data marts, ETL processes, and data pipelines from scratch for a new internal operation system through dbt, PostgreSQL, Apache Airflow, Lucidchart, and Python.
• Design and build out comprehensive metrics and dimensions to measure operational health, enable downstream analysis and predictive modeling, and design Tableau/Metabase dashboards to monitor them daily.
• Discover new opportunities for product roadmap prioritization through understanding pain points with SWEs and PMs, boosting email automation rate of scheduling appointments from 28% to 45% within a quarter.
• Lead the project of Convoy’s data model cost in Snowflake and Airflow, saving 40%+ data model cost for Convoy yearly.
• Re-define >50 product metrics and rebuild data architecture to automate WBR spreadsheets based on business changes.

New York, New York, US

• Horizon Next - A Division of Horizon Media Focusing on Direct ResponseAccount: UnitedHealth Group
• Supported dashboards and ad-hoc analytics through writing SQL queries and creating DBT models to clean, manipulate, and aggregate data from various data sources (DCM, SA360, Google AdWords, Facebook Manager, FTP, etc.).
• Built ETL processes using S3, Python, Amazon Redshift, and Apache Airflow to automate business reports in ODBC files, helping business solution team to leverage daily performance in direct response.
• Helped stakeholders and clients on-boarding new business lines and campaigns through understanding data, creating meaningful KPIs, designing data models in data build tools and building data QA process.

Rochester, NY, US

• Led team of five help to improve tree survival rate by prediction modelling and acquire new donors to plant new trees.
• Cleaned and stored data in MySQL database, including tree variables and donor information.
• Built classification models, including logistic regression, K-nearest Neighbors, Support Vector Machine, Naïve Bayes, Decision Tree models in R to predict tree survival output.
• Integrated with local weather and landscape information to visualize potential tree locations in Tableau and ArcGIS.
• Recommended new media channels and marketing strategies for donor retention and acquisition.

Tokyo, JP

• Conducted competitor analysis, including social listening, share of voice, media buying history through collecting and analyzing data from various platforms, including Baidu Analytics, Adpower, and Telmar.
• Built dashboards for CPG clients including brand awareness, social media engagement, channel acquisition in Excel and Tableau, delivering an accurate overview of media landscape.
• Outsourced and communicated with influencers based on clients’ preferences. Negotiated and under spent budget by 15%. Evaluated omni-channel campaign performance and built closing reports in Tableau.
• Successfully identified multiple data issues and helped with their resolution.
• Built lasting business relationships through performance and credibility. Developed positive rapport with people at all levels of responsibility.
• Highly organized and able to thrive in a fast-paced, deadline-oriented environment. Displays and acts with initiative, integrity, and professionalism.

Chicago, IL, US

• Summarized data into readable and clear formats; provided insights on data trends and anomalies.
• Pitched branding campaign idea for a CPG brand. Conducted market research through interviews, store visits and collecting industry reports to study consumer behavior. Brainstormed different campaign ideas including pop.
• Collaborated with cross-functional teams to compile social listening reports to analyze sentimental, mentioned rate, negative word cloud, competitor news; Recommended opportunities such as increasing word-of-mouth.
• Measured ROI and respectively analyzed users’ characteristics of various social media channels; designed charts illustrating Key Opinions of Leaders through multi-dimensional social network analysis to target.
• Recognized problems, understood business & system process, collected data, established facts & drew valid conclusions

• Extracted detailed product information for medical corporations using Excel; summarized findings and provided key insights related to new products.
• Established and maintained a positive flow of communication with the representatives of the pharmaceutical companies and updated new product information into database.

Master'S Degree, Business Analytics

Master'S Degree, Business Analytics

Bachelor'S Degree, Public Relations