← Experience Brian Lee.

ExperienceJun – Aug 2022

IT-Farm

Designing SQL database tooling over million-row semiconductor datasets at a Korean semiconductor smart-factory IT company.

Company

IT-Farm (아이티팜) is a South Korean semiconductor IT-solutions company in Seongnam. It builds AI, image-processing, and smart-factory automation systems (MES/CIM integration, equipment control, and data-collection and quality-analysis tools) for semiconductor and display manufacturers.

What I worked on

  • Designed and implemented a SQL database prototype managing 1M+ data entities (Oracle, SQLite)
  • Processed and organized semiconductor datasets from 20+ client companies, including Samsung, SK, and LG
  • Wrote and optimized SQL queries for faster retrieval across large-scale datasets

Note

The underlying client datasets are confidential, but I can speak to the systems and my process in more detail on request.