Lim Lee Email & Phone Number

South Pasadena, Ca, Us

South Pasadena, California, United States

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

Washington, District Of Columbia, United States

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… Show more 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.Review code design and integrate software engineering 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, version control, clear code structure and documentation. Utilize project management tools such as Trello, Jira, and Confluence for issue documentation. Research and adopt best practices for the data warehouse migration to snowflake, including establishing a CI/CD pipeline. Show less

Washington, Dc

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… Show more 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. Show less

Washington, District Of Columbia, United States

Provided literature review and statistical analysis using nationally representative survey data for research economists on migration and structural transformation in Sub-Saharan Africa, a medium term evaluation of the Community Based Rural Land Development Project in Malawi, background paper for the World Bank Poverty Assessment in Bangladesh, and Youth and Employment in Sub-Saharan Africa.Coordinated and implemented the questionnaire design and collection of household surveys in Malawi… Show more Provided literature review and statistical analysis using nationally representative survey data for research economists on migration and structural transformation in Sub-Saharan Africa, a medium term evaluation of the Community Based Rural Land Development Project in Malawi, background paper for the World Bank Poverty Assessment in Bangladesh, and Youth and Employment in Sub-Saharan Africa.Coordinated and implemented the questionnaire design and collection of household surveys in Malawi and Pakistan in collaboration with external survey consulting firms, including the training of enumerators. Responsible for ensuring data integrity and usability of survey data for internal and external audiences. Routinely provide statistical tables, econometric regressions, and informative graphs using R and STATA software.Led a focus group discussion and interviewed key stakeholders in Malawi, including senior officials from the Ministry of Agriculture and Food Security, civil society organizations, and private businesses.Produced and implemented capacity building training on research, data cleaning, and statistical analysis using primary data on STATA software.Contributed to State of Food and Agriculture (UN-FAO) Report (forthcoming)Coauthored chapter on Youth and Employment Book (forthcoming)Coauthored two journal articles in World Development and Land Economics Show less

Washington D.C. Metro Area

Performed statistical and econometric analysis on the World Bank’s Country Policy and Institutional Assessment (CPIA) indicators and other internal and external indicators to identify trends in country indicator scores across time, assess the reliability of scores, and determine biases in country scores across regions. Managed the CPIA database and reconciled data inconsistencies using Excel and STATA statistical software.Revised criteria for the World Bank’s Post-Conflict Performance… Show more Performed statistical and econometric analysis on the World Bank’s Country Policy and Institutional Assessment (CPIA) indicators and other internal and external indicators to identify trends in country indicator scores across time, assess the reliability of scores, and determine biases in country scores across regions. Managed the CPIA database and reconciled data inconsistencies using Excel and STATA statistical software.Revised criteria for the World Bank’s Post-Conflict Performance Indicators and researched financial sector development, trade, debt, macroeconomic, and governance indicators in support of the CPIA annual exercise.Researched and compiled background data on World Bank projects for internal operations policy papers. Show less

Seoul, Korea

Revised Asian Pacific Economic Forum (APEC) - Counter Terrorism Task Force (CTTF) Reports to the Senior Officials Meeting, APEC-CTTF agendas, welcoming remarks, talking points, and letters to APEC working groups and the UN for the Republic of Korea’s Ambassador to the APEC-CTTF. Managed revision and update of the International Counter-Terrorism Cooperation Division brochure.

Ma, International Relations And International Economics

Bachelor Of Arts, Honors International Studies, Humanities & Law, Cum Laude