Hey, I am Chengyan, also known by Kelly.

I am an AI Solution Architect with diverse expertise and industry experience.

With a strong background in AI and data analytics, I specialize in creating innovative solutions for complex industrial problems. My experience spans multiple sectors, allowing me to bring a unique perspective to each project. I'm passionate about leveraging cutting-edge AI technologies to drive efficiency, reduce costs, and improve outcomes across various industries.

Kelly's professional headshot

Education

  • Business Technology Management, Computer Science, and Data Analytics

Skills

  • Industries: Energy, Industrial Automation, Pharmaceutical, Precision Electronics, Transportation

  • Office: MS Office, Visio, Project, SharePoint, Jira, Confluence, Notion

  • Big Data:

    • Programming Languages: Python, SQL, R, SAS

    • Machine Learning: Scikit-learn, SciPy, PyTorch, TensorFlow

    • NLP: nltk, SpaCy, Vader, Text2vec, BERTopic

    • GenAI: LLM, Diffusion, GPT4-v, Qwen

    • Cloud Services: Azure, AWS, Alibaba

    • Data Visualization: PowerBI, Access, Tableau, Excel

    • Data Management: Lakehouse, Databricks, Arcteryx, Informatica, IBM COGNOS, IBM Netezza, GraphDB, VectorDB

  • Development: Java, Web Frontend, UI & UX Design, Project Management, Solution Architecture Design

Projects

Below is a list of projects I have completed independently or as part of a group. To explore more details about each project, simply click the button provided.

Project 1: Automobile Risk Analysis

Automobile Risk Analysis

Conducted insurance risk analysis using PCA and Random Forest models with R and vehicle data, providing driving and purchasing recommendations to stakeholders.

Project 2: Customer Personality Analysis

Customer Personality Analysis

Applied clustering and causal inference on customer data for segmentation and determining variable causality, enhancing marketing strategies.

Project 3: Party Animal Steam Game Feedback Analysis

Party Animal Steam Game Feedback Analysis

Analyzed game reviews using NLP and sentiment analysis to support investment strategy optimization.

Project 4: Starbucks Promotional Strategy Analysis

Starbucks Promotional Strategy Analysis

Utilized data mining and visualization techniques using Python, analyzed Starbucks consumer behavior and made prediction on offer completion, optimizing promotional strategies to enhanced customer engagement and contributed to revenue growth.

Project 5: Covid-19 Database and Alerting System

Covid-19 Database and Alerting System

Designed and developed a database and alerting system with SQL that records PCR test positive patients and close contacts data by tracking and alerting on positive cases for public health safety management.

Project 6: Herbicide Usage Optimization Project

Herbicide Usage Optimization Project

Achieved a reduction in cancer risk-associated herbicide usage by applying combination of mathematical modelling and optimization techniques, successfully upholding crop production and cost targets within treatment method constraints.

Download My Resume

You can download my resume by clicking the button below.

Contact

Interested in collaborating or learning more about my work? Feel free to reach out!