Xiaocheng L. Email & Phone Number

Columbus, OH, US

Irvine, California, United States

Cleveland, Ohio, United States

• Data Quality Enhancement: Elevated data quality by 60% by cleaning and validating past 22 years’ GSF data using Excel and Python.
• Text Mining: Extracted 8 key factors influencing education attainment from past 17 years’ scholarship recipient letters by employing LDA Topic Modeling in R Studio.
• Data Transformation: Created 10+ tables (accuracy: 98+%) by transforming GS recipient letter content into numeric features, saving data scientists 80+% in machine learning task preparation… Show more
• Data Transformation: Created 10+ tables (accuracy: 98+%) by transforming GS recipient letter content into numeric features, saving data scientists 80+% in machine learning task preparation time.
• Statistical Analysis: Executed descriptive stats, chi-square test, correlation, visualization to uncover data patterns.
• ETL: Created a NoSQL database by ingesting data from S3 to DynamoDB using Python, contributing to a 70% labor time saving.

Dallas, Texas, United States

• Schema Change Detection: Developed a schema change detection system that helps identify and process schema inconsistencies in advance, reducing data job failures by 60% and cutting data delivery delay cases by 50%.
• Event Delivery: Automated delivery of schema change event captured by Glue Crawler and Data Catalog to services (SNS, SQS, Lambda, SMTP) across 2 AWS accounts and 3 regions, lifting event passing efficiency by 50%.
• Stream Processing: Utilized Kinesis Data Stream to ingest… Show more
• Stream Processing: Utilized Kinesis Data Stream to ingest user activity data (2M+ rows/day) into an S3 data lake.
• Batch Processing: Extracted, transformed, loaded transaction data (19M+ rows/day) in Parquet or CSV format within S3 buckets by PySpark (EMR, Glue).
• Data Security: Configured IAM policies, S3 bucket policies, and KMS encryption to ensure security for critical data in S3.

Shanghai, China

• Dashboard: Automated 9 reports by Tableau that integrate data (50k+ rows/day) and visualize ad KPIs (Spend, CTR, CVR, CPL, etc.), smoothing stakeholder engagement through seamless user experience and streamlining.
• Reporting: Executed SQL queries for 20+ reports and created visualizations showcasing KPIs in 10+ Tableau and Power BI dashboards, ensuring accurate and timely delivery for ad hoc requests across 4 teams.
• ETL: Executed ETL processes using… Show more
• ETL: Executed ETL processes using SSIS to fit data and analytical requests for an analyst team of 4.
• Data Modeling: Built Star Schemas to prepare data marts within SQL Server database for 2 business teams.
• Text Analysis: Extracted audience top keywords and sentiments for ad team by conducting Sentiment Analysis using R Studio to analyze text collected from comment section of various social media platforms. Show less

Shanghai, China

• Marketing Optimization: Generated $4M in annual e-commerce revenue (ROI: 17) for DJI (NA, EU markets) and expanded market share by 6% for Infinix (AF market) by leading 9 digital marketing projects cross functionally.
• KPI Boost: Optimized ad performance by tracking KPIs (ROI, CTR, CPA, etc.) and conducting root cause analysis and AB testing, increasing CTR by 20%, Page Views by 21%, and CVR by 15% in 3 months.
• Marketing Mix Modeling: Enhanced online sales by 13%, CVR by 9%, and ROI… Show more
• Marketing Mix Modeling: Enhanced online sales by 13%, CVR by 9%, and ROI by 10% through ad channel optimization based on marketing mix model.
• Data Validation: Validated data to ensure 99%+ accuracy for IT and Product teams, and advanced the development of automated data report.
• Reporting: Produced ad hoc daily and weekly reports, and collaborated on monthly and annual reports using Excel, Tableau, and Google Analytics, analyzing 5M+ data and communicating recommendations to stakeholders. Show.

Beijing, China

• Data Cleaning: Completed 30+ data tables and 20+ charts of 5 reports in a homestay pricing project by cleaning data of house list dataset (80k+ rows) and performing visualization by Excel and Tableau.
• Data Transformation: Cleaned Houseowner Contact List dataset by Python and summarized possible variation formats of contact method and keyword determination of contact information.

• Reviewed and maintained corporate project accounting ledgers, manipulated financial and budget statements data by Excel to build financial models to forecast and complete annual budget plans.
• Updated accounting sheets and information and checked balance in ERP system.
• Grasped tax declaration rules, procedures, and operated Excel to process and calculate revenue, cost, tax, staff income data (5k+ rows data) and making 11 pay sheets.
• Finished 7 monthly material procurement plans… Show more
• Finished 7 monthly material procurement plans and maintained relationship with suppliers, streamlining the procurement process.
• Reviewed weekly inventory and worked on monthly inventory planning to minimize cost and avoid out of stock by building simulation models for different scenarios in Excel.

• Accurately analyzed and collected data and information for various types of business reports and managed various documents.
• Reviewed the audit working papers, filled in the audit forms, sorted out and bound the audit papers.
• Prepared business and auditing documents to complete the final settlement of enterprise income tax declaration, pre-tax deficit coverage and property loss declaration and enterprise taxation clearing using Excel.

• Processed original taxation certificates collected from different bureaus, filled in accounting documents and stamping stamp-tax seal for taxpayers.
• Typed in taxpayers’ original information and system information material based upon the paper material provided by front desk.
• Assisted in auditing declaration collection materials and sorted out accepted materials.

Master'S Degree, Business Analytics And Intelligence

Bachelor'S Degree, Accounting