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.
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.
π‘ 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).
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!
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.
π 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.
π 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.
π 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.
π 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.
2022
- Amazon Clone https://clone-7756a.web.app/
- Quiz App https://github.com/4yuLai/quiz_app
- Personal Website
- DKeeper
- DBank
- Todo List http://todolist-valerie.herokuapp.com/
- Secrets
- Newsletter Signup https://peaceful-bayou-64645.herokuapp.com/
2021
- Poster for Academic Meeting
- Bachelor Degree's Thesis