Glenn Chon

Key Responsibilities: Data ELT & Integration: Design and implement robust ELT pipelines, integrating data from multiple source systems, including Zoho CRM, Internal Tools, Jira, Personio, and more. Orchestration & Automation: Develop and maintain Airflow DAGs and custom plugins in Python to automate data workflows efficiently. Data Warehouse Management: Manage a PostgreSQL Data Warehouse using dbt (following Data Vault 2.0 methodology for slowly changing dimensions), DBT SQL macros, and ODBC

Data ELT & Integration: Design and implement robust ELT pipelines, integrating data from multiple source systems, including Zoho CRM, Internal Tools, Jira, Personio, and more. Orchestration & Automation: Develop and maintain Airflow DAGs and custom plugins in Python to automate data workflows efficiently. Data Warehouse Management: Manage a PostgreSQL Data Warehouse using dbt (following Data Vault 2.0 methodology for slowly changing dimensions), DBT SQL macros, and ODBC connections for seamless integration.

Application Integration Engineer Integrating a variety of third party applications to be used for decision making, deal pipeline management, historical tracking, and invoicing. Data pipeline creation, data modeling, and monitoring. Power BI report creation.

• Set up WordPress landing pages and configured SPF and DKIM records. • Established Google Analytics for end-user traffic monitoring. • Created Cron Jobs to automate SSL certificate generation in AWS Lightsail’s Linux based servers. • Relational database design mockups for potential client’s app. • Developed Python web scrapers to compile data.

• Creating/running SQL procedures for various reports and invoices. • Adding reports and queries to Microsoft Access, C#, VB, and .Net applications for employee use. • Created member census data visualizations that determine best locations for future clinic locations lowering trust costs over the long-term by using the google maps API, VB.Net, HTML, JavaScript, CSS, and SQL. • Automating monthly reports and emails to local government H.R. contacts. • Automating FTP file downloads and conversions to more leg

Creating/running SQL procedures for various reports and invoices. Adding reports and queries to Microsoft Access, C#, VB, and .Net applications for employee use. Created member census data visualizations that determine best locations for future clinic locations lowering trust costs over the long-term by using the google maps API, VB.Net, HTML, JavaScript, CSS, and SQL. Automating monthly reports and emails to local government H.R. contacts. Automating FTP file downloads and conversions to more legible forma

• Researching potential donors and organizational/foundation based RFPs. • Developing CSR relations for organizations. • Determining proposal concepts by identifying needs and opportunities. • Adapting and editing source information to match RFP terms. • Identifying and communicating risks regarding the successfulness of project outcomes. • Maintaining quality results by openly receiving feedback and following proposal-writing standards including readability, consistency, and tone in RFP requests. • Obtain

Researching potential donors and organizational/foundation based RFPs. Developing CSR relations for organizations. Determining proposal concepts by identifying needs and opportunities. Adapting and editing source information to match RFP terms. Identifying and communicating risks regarding the successfulness of project outcomes. Maintaining quality results by openly receiving feedback and following proposal-writing standards including readability, consistency, and tone in RFP requests. Obtaining approval by

• Website Developer • Brand Recognition • System Development Co-Manager • UX Co-Manager

Being part of an international team of fellows on the Sustainable Cup Challenge in NYC proposed to us by New York City Office of Long-Term Planning & Sustainability. On ground research, brainstorming, prototyping, web development, media management, social media, proposal writing, pitching, business plan development, product research, product acquisition, event planning, etc. Established the Good To Go pilot project with Brooklyn Roasting Company in Dumbo.

The program addresses interpersonal conflict issues and introduces conflict management to the participants. It’s aimed at teens and young adults but it is also applicable to older adults.

Assisting in EU, USAID, and various other proposals to foundations of support for interpersonal, social, and political dialog sessions for Israeli and Palestinian participants. Photographer and video coordinator for NSWAS Primary School. In charge of social media and news articles to keep donors up to date. To date, aided in acquiring $50,000 in grants and waiting to hear back from a few more applications.

Assisting in EU, USAID, and various other proposals to foundations of support for interpersonal, social, and political dialog sessions for Israeli and Palestinian participants. Photographer and video coordinator for NSWAS Primary School. In charge of social media and news articles to keep donors up to date.

Organizing a public information session aimed at promoting education about legal issues within the latino community. Briefing of supreme court cases for online blogging.

Organizing and facilitating a student led dialogue on the topic of racial tension on West Chester University's campus.

Assisting in identifying whole-family factors explaining variability in emerging adults' transition to college and testing to reveal if greater social, emotional, and academic adjustment to college will be predicted by greater cohesion, less conflict, and greater expressivity in triadic and whole-family relationships.

Assisting in identifying whole-family factors explaining variability in emerging adults' transition to college and testing to reveal if greater social, emotional, and academic adjustment to college will be predicted by greater cohesion, less conflict, and greater expressivity in triadic and whole-family relationships.

Field interviewer with a Ukrainian translator addressing the education, health and lifestyle issues within the Roma community in relation to the general Ukrainian community for a proposal that is to be submitted to the European Union. Field Work Data Analysis Interviewing International Cooperation

Outpatient Center Assistant - Tending to comfort and needs of patients File Courier - Delivering patient files from office to designated floors Floor by Floor Assistant - Moving patients, Tending to patient needs, Assisting nurses, Discharging Patients Volunteer Trainer - Assisting new volunteers, Teaching basic hospital codes, Familiarizing new volunteers with procedures and routes.