Learn Data Skills
Taehoon Lee

Taehoon Lee

AI Solutions Engineer

Heaven Hills Brands

Technologies

My Portfolio Highlights

My New Track

SQL Server Fundamentals

Data philosopher, pondering the mysteries of existence through statistical analysis.

My Work

Take a look at my latest work.

course

Data Manipulation in SQL

course

Introduction to Relational Databases in SQL

course

Intermediate Python for Developers

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

eBlu Solutions | May 2022 - Present

Data Analyst

- Used ETL (Extract, Transform, Load) principles to establish dbt data pipeline models from raw to reporting database with appropriate data catalog to be used in executive-level reports. - Created live-feed reports using Google Big Query and Looker for the Operations team and company executives to provide data-driven insights on the company's trajectory and current health. - Maintained the Source of Truth by performing quality testing on the business logic embedded in the database. - Refactored legacy data reports from PowerBI to Looker Studio/Looker. - Utilized dbt to structure complex data flow and aggregation, collecting transactions from multiple clients and organizing them according to specific Service Level Agreement (SLA) standards. - Automated invoicing reporting process, creating monthly invoices with a breakdown of each transaction and trends for each client.
Show More

The Rawlings Group | Feb 2022 - May 2022

Pharmacy Recovery Analyst

- Used the ETL (Extract, Transform, Load) principles to clean up, organize, and create spreadsheets from the central database that contains $200+ billion of claim information related to both commercial and Medicare pharmacy Coordination of Benefit (COB) demands, based on the batch standards of each Pharmacy Benefit Manager (PBM). - Sent and followed up on the batch submission to help resolve rejections from the PBMs. - Wrote SQL Server (T-SQL) queries to optimize the efficiency of the ETL process to achieve a higher hit rate of the submitted claims.

POSCO AAPC | Apr 2021 - Feb 2022

Sales Coordinator

- Managed the sales of carbon steel coils to fastener companies of Ford, GM, and Toyota by coordinating international supply purchasing, customer interactions, purchase order due dates, and plant production schedules to meet the customer's JIT logistic schedules. - Performed administrative duties such as invoicing, managing account receivables, record-keeping, and inventory management. - Initiated and coordinated the development of new business relationships with companies such as NITCO, Brugola, and J-TEKT.

D and D, LLC | Sep 2019 - Mar 2021

Assistant Property Manager

- Set up a security network in a building including setting up secured access points via VPN and a security camera network that can be accessed through a cloud system. - Procured and managed building supplies in a cost-effective and organized fashion. - Coordinated schedules with service contractors on improvements, repair projects, and inspections. - Performed periodic basic maintenance on building fixtures, including lights, ceiling tile, drywall, HVAC, etc. - Contributed to strategy discussions regarding capital improvements and potential acquisitions. - Contributed to developing a streamlined system to manage tenant work orders. - Contributed to developing a database system to keep track of internal information

Cru | May 2019 - Feb 2021

Field Staff

- Mentored international university students one-on-one and in small groups through effective cross-cultural communication and cultural awareness - Initiated the formation of an international student outreach organization, Bridges International, and developed methods for student involvement and community formation. - formed and mentored a leadership team through coaching and delegation of weekly and monthly tasks regarding Bridges International. - Maintained relationships with donors through a regular newsletter - Contributed to campus outreach strategy - Initiated organizational restructuring within the Cru staff team

Rainbow Design Services, Inc. | Jan 2019 - May 2019

Drafter 1

- Precisely drafted strand information onto a digitized grid on a MicroStation. This required extensive knowledge of pole types and properties of strands, as well as attention to detail on differences between the source and the grid. - Shown to be a quick learner and a dedicated employee by breaking the department record for the most miles drafted per week

My Education

Take a look at my formal education

Master of Divinity - MDiv, International Church Planting  · (January 2019 - MayThe Southern Baptist Theological Seminary | 2024
Bachelor of Science - BS, PhysicsUniversity of Louisville | 2018

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free