Hello, I'm Lim.

Concentration in Conflict Management

Graduated with Honors; Minored in Humanities & Law

• • Architect and deploy backend and front end solution for NextJS website and express api service AWS Cloudfront, VPC, Application Load Balancer, NAT Gateways, ECS Fargate, and Supabase.
  • Architect and deploy data pipelines utilizing AWS lambda, S3, Glue and Athena to scrape, extract, and load data into Apache Iceberg tables. Utiilize dbt, duckdb to manage table transformations to analyze client datasets.

• • Build and deploy serverless website using typescript and svelte, utilizing AWS cloud services (s3, api gateway, dynamodb, lambda functions) and single sign-on. Implement continuous integration/continuous delivery pipeline with integration tests and end-to-end tests using playwright.
  • Direct and integrate new features by developers such as end-to-end testing and UX design.

• • Principal lead in the ingestion, validation, and transformation of administrative and external data for analysis and for web products. Responsible for creating and maintaining code and architecture for core office data pipelines and deliverables, including 108 data tables and 1566 table tests, using prefect, DBT, and AWS cdk
  • Creator and maintainer of code repository for calculating and producing, annually, $500 million total grant awards payments for 131 grantees and using appropriations and census data, reducing days of effort to a few hours including review.
  • Principal lead in writing application code for the office’s annual By the Numbers report tables in a modular, reproducible manner, thereby reducing total labor hours spent by roughly 75 percent.
  • Co-Creator and Maintainer of the organization-wide Risk Assessment, a ranking of 131 grantees based on 44 indicators and 60+ data points across 3 organizational offices, that is utilized by the staff members to select the end of the year site visits.
  • Actively engage in code review, design, and integrating DevOPs best practices into the architecture and operational workflow of data pipelines,including continuous integration/continuous delivery using containerization, Infrastructure as Code (aws cdk), test driven development, data modeling, and reliance on project management tools such as Trello, Jira, and Confluence, thereby reducing bottlenecks in development and information for projects such as the central data lake for civil court cases nationwide.

• • Delivered key statistics and figures for congressional budget request reports, budget memos, and allocation of congressional appropriations to grantees. Led team on developing new metrics to disburse $50 million COVID-19 support funds that resulted in one of the fastest delivery of ad-hoc funds to grantees in the organization’s history.
  • Advised on and implemented new statistical models for the organization-wide risk assessment, developing data pipelines from Salesforce, Smartsheet, and SQL databases, computing indicators scores in Python, and refactoring and re-organizing the code to be modular.
  • Successfully overhauled the composition and workflow of the organization’s Annual By the Numbers report project with new content, visualizations, and project management using Trello, the office’s first successful team usage.
  • Analyzed the effect of adopting the Chained Consumer Price Index on the eligible target population for legal services as a brief for the CEO and evaluated the quantitative impact of the organization’s Loan Repayment Assistance Program (LRAP) on staff tenure of beneficiaries using R, Python and Stata that was used as evidence for additional funding requests.