Jiachong Lai

I specialize in automating workflows, optimizing processes and implementing LLM. My expertise includes: -Designed and implemented an internal Python module using PySpark and impala-shell to automate data extraction, transformation, and cleaning from a Hadoop-based data warehouse. The module supports dynamic customization through Excel-based input, allowing nontechnical users to define project specifications without modifying code. It enables complex operations, such as tracing patient history across multiple medical codes, which would otherwise require developers to manu- ally write complex SQL overlay logic for each use case. The module reduces the development time by 90%. With a single-line execution interface, it is accessible to users with no programming experience. GitLab was used for version control to ensure collaboration and consistent code management. -Performed prompt engineering to train an internal Generative AI (GenAI) model, enabling users to interact with Python modules through natural language commands, eliminating the need for programming expertise. -Automated existing SQL scripts using Python, reducing development time by 80% and saving over 100 hours previously spent manually generating quality control (QC) files.

• Developed a web-based user interface for automating data gathering and acquisition process by Django Framework, generated valuable business intelligence by increasing 50% efficiency of the data acquisition process. • Conducted cloud-based data acquisition process by creating python automation codes, built-in conversion, and modification of customer data in SQL, and participated development of company-specific documentation during conversion. • Worked closely with IT, Document Control, and purchasing and created last time buy tool/database and automated the last time buy process within Oracle, simplified the operation steps to eliminate trivial steps. • Managed reconciliation adjustments to Oracle database to maintain inventory accuracy on company data dashboard. • Acquired related news and tendering information data on specific keywords, integrated the acquired data via multi resources (Excel, txt., CRM), transformed acquired data by required format onto the database. • Ensured correct adoption of required data standards to guarantee consistency across company relevant news and marketing areas, and provided oversight on external partners performing data management activities on the company’s behalf or executing the data management activities internally.