Skip to content
View 4yuLai's full-sized avatar
πŸ¦‰
πŸ¦‰
  • University College Dublin
  • Dublin, IE

Block or report 4yuLai

Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
4yuLai/README.md

Hi πŸ‘‹, I'm Siyu

πŸ›  About Me

I thrive in building scalable, efficient, and user-friendly internal applications that enhance operational efficiency.
With a strong foundation in JavaScript, SQL, and schema design, I specialize in creating structured, maintainable solutions that empower teams to work smarter.

Technical Skills & Expertise

Retool Development – Built a fully functional suite of internal tools for data validation, input management, and process automation.
Database Design & Management – Extensive experience working with Snowflake, SQL databases, and structured schema development.
JavaScript & System Integration – Proficient in JavaScript, API integrations, and automating workflows with external services.
LLM & AI Integration – Exploring AI-driven automation for internal data processing and predictive modeling.
Process Optimization – Passionate about streamlining workflows through automation and structured data pipelines.

Notable Work

πŸ’‘ Retool Dashboards – Developed internal dashboards for data validation, input tracking, and process automation, improving efficiency for a web investigation team.
πŸ’‘ Database Automation – Designed and managed data pipelines to enhance data consistency and streamline reporting.
πŸ’‘ Web Scraping & Investigation – Led investigations on market trends, e-commerce, and pricing models, supporting data-driven decision-making.
πŸ’‘ AI-Powered Data Processing – Researching how LLMs can assist in automating structured data extraction from diverse sources (emails, PDFs, images).

What I'm Looking For

I'm excited about roles where I can combine Retool development, system integration, and database automation to build high-impact internal applications.
If your team is looking for a problem-solver who can bridge data, automation, and internal tooling, let’s connect!

πŸ— Problem-Solving & Approach

One of my key strengths is the ability to take high-level, ambiguous requests and transform them into well-defined, scalable solutions.

βœ… Understanding Needs – I engage with stakeholders, analysts, and technical teams to clarify project goals and data requirements.
βœ… Breaking Down Complexity – I deconstruct big problems into smaller, structured components, ensuring that each part is well-defined and actionable.
βœ… Building Clear Blueprints – I design logical, scalable architectures, ensuring that tools integrate seamlessly with databases and external systems.
βœ… Iterative Development – I prototype, validate, and refine applications based on user feedback, ensuring long-term usability and maintainability.


πŸ”§ Projects & Case Studies

1️⃣ Data Input & Management Tool

πŸ“Œ Tech Stack: Retool | SQL (Snowflake) | JavaScript | API Integrations

πŸ”Ή Challenge: Teams needed a structured way to input and validate large datasets while reducing human errors.
πŸ”Ή Solution: I designed and built a Retool-powered input tool with real-time validation rules using SQL and JavaScript.
πŸ”Ή Execution:

  • Engaged with analysts to understand the exact data fields and validation requirements.
  • Structured the tool to prevent duplicate entries and enforce consistency.
  • Implemented role-based access controls, ensuring secure data handling.

πŸ’‘ Impact:
βœ… Reduced manual errors and increased data accuracy by 30%.
βœ… Provided a clear, structured input process, making it easy for teams to enter data confidently.


2️⃣ Data Validation & Monitoring Dashboard

πŸ“Œ Tech Stack: Retool | SQL | JavaScript | API Integrations

πŸ”Ή Challenge: Teams lacked a way to efficiently verify and track incoming data for inconsistencies.
πŸ”Ή Solution: Developed an automated validation dashboard, flagging errors and providing real-time status tracking.
πŸ”Ή Execution:

  • Worked with data analysts to define key validation rules.
  • Implemented custom JavaScript scripts for dynamic filtering and automated alerts.
  • Designed a scalable, structured approach, making it easy to add new validation rules as needed.

πŸ’‘ Impact:
βœ… Improved data accuracy and reduced review time by 40%.
βœ… Gave teams real-time insights into data health, allowing faster decision-making.


3️⃣ AI-Powered Invoice Data Extraction

πŸ“Œ Tech Stack: Retool | OpenAI API | Snowflake | JavaScript

πŸ”Ή Challenge: Processing invoices manually was time-consuming, requiring human validation for structured data extraction.
πŸ”Ή Solution: Integrated an LLM-powered invoice parsing tool that extracts key data fields automatically.
πŸ”Ή Execution:

  • Defined a clear prompt structure to ensure high-accuracy data extraction.
  • Designed a human-in-the-loop review system, allowing users to verify AI-generated outputs.
  • Integrated Snowflake storage & APIs, making the extracted data searchable and structured.

πŸ’‘ Impact:
βœ… Reduced manual data entry efforts by 70%.
βœ… Enabled teams to process invoices significantly faster, improving efficiency.


4️⃣ Config Data Editor for Workflow Automation

πŸ“Œ Tech Stack: Retool | SQL | JavaScript | JSON Data Structures

πŸ”Ή Challenge: Manually updating system configurations was inefficient and prone to errors.
πŸ”Ή Solution: Built a Retool-based Config Editor, allowing teams to dynamically modify configurations stored as JSON data.
πŸ”Ή Execution:

  • Structured config data into a scalable schema, enabling flexibility for different workflows.
  • Implemented validation & role-based controls, preventing unauthorized changes.
  • Designed rollback & version control features, allowing teams to restore previous configurations if needed.

πŸ’‘ Impact:
βœ… Made configuration changes 10x faster.
βœ… Reduced downtime caused by manual misconfigurations.

πŸ›  Tech Stack

- 🌐   HTML | CSS | JavaScript | React | Node.js | Express | EJS | API | Authentication | OAuth - πŸ›’   MySQL | PostgreSQL | MongoDB | Mongoose | Firestore | Snowflake - πŸ”§   Python | MATLAB | C | R | Go | Linux

Personal Projects

2022

Ex-Academic Experience

2021

  • Poster for Academic Meeting
  • Bachelor Degree's Thesis

🀝 Connect with Me

Valerie's LinkedIn

Popular repositories Loading

  1. cv cv Public

    HTML

  2. DKeeper DKeeper Public

    Decentralised App version of Keeper

    JavaScript

  3. 4yuLai.github.io 4yuLai.github.io Public

    My personal website.

    HTML

  4. 4yuLai 4yuLai Public

    Github Homepage

  5. amazon-clone amazon-clone Public

    A clone of amazon.

    JavaScript

  6. getAheadWithMe getAheadWithMe Public

    Forked from msdeep14/getAheadWithMe

    Sharing my experiences to help around.