• 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 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 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.• Database Change Detection: Built a database monitoring pipeline that triggers automated notification email to the data team upon detecting DynamoDB table change, reducing rework cases due to untimely data sync by 40%.• Data Lake: Constructed a tiered S3 data lake to efficiently manage raw, cleansed, and application-specific data, enabling scalable analytics solutions and reducing data search time by 50% for 3 researchers and a data team of 9.• Data Security: Configured policies for S3 buckets and IAM roles to ensure data security and access control. Show less

• 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 • 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 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.• Anomaly Detection: Executed SQL-based anomaly detection model on Snowflake, monitoring user electricity usage records (220M+ rows/day), identifying electricity theft risks, and ultimately recovering $2M in revenue loss.• Dashboard Reporting: Maintained 2 Tableau and Power BI dashboards (DNP, Account Switch) tracking and presenting anomaly detection KPIs, saving decision-making time by 20%. Show less

• 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 decision-making workflow by 50%.• 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 • 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 decision-making workflow by 50%.• 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 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

• 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 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 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 less

• 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 • 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 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.• Completed monthly reporting and communication of financial performance against project objectives to stakeholders. Show less

• 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.