Get In Touch
Menu

Hello.

Good to meet you, I'm Yuka.
Learn more about me!

Scroll Down

A little bit about me

I am deeply curious and driven to solve complex problems.

In 2020 I made a major shift in my career by learning Python and SQL. I was captivated by the innovations in data technology and motivated by a future career in data science. After working as a dietitian in the health care field for 5 years, I moved into a data analyst role to begin my path towards data science.

Four years later, I’ve developed the foundational skills in SQL, data analysis, and visualization. And now as a Data Engineer, I have substantial experience with data infrastructure, ETL/ELT pipelines and data integrations, database management, and automation and orchestration. I’m excited to advance my career and expand my expertise to machine learning algorithms and statistics.

Recent Works

Here are some of my projects. Feel free to check them out.

Self-taught through online bootcamps and training courses led by industry experts.

Absenteeism Problem

Developed a model that predicts the probability of excessive absenteeism from work. Preprocessed absenteeism data, applied a logistic regression model, deployed with a Python module, and then analyzed with Tableau.

View Project

MNIST Classification

Tackled the MNIST Handwritten Digit Classification Dataset. Developed a deep neural network for this image classification task using Python and Tensorflow 2.0.

View Project

Audiobooks Machine Learning

Built a machine learning algorithm for a business case study with data from an Audiobook company. This is a classification problem that predicts if a customer will buy another audiobook. Python and Tensorflow 2.0 were used.

View Project

On the job real world projects

Data Integration with Wells Fargo Development Gateway API for Account Validation using Python Application

I inherited legacy code for an account validation application that the accounting team uses for reducing transaction fraud. After weighing the benefit of rewriting the application, I determined it was far more effective to update the Python code and reconfigure the API. I worked with the Wells Fargo Developer Gateway team and was able to deploy the account validation application with minimal downtime for the accounting team. I continue to monitor and manage this application.

Design and Build a New ELT Pipeline of Payroll Data for Analytics and Reports

I integrated wage deduction data from the company’s HR vendor to the on-prem HR database (SQL Server). I designed and implemented a new ELT pipeline, incorporating PowerShell scripting to automate the SFTP connection and data extract. An SSIS package was implemented for loading and transforming the data into the HR database. A complex SQL SP was created for the reporting and analytics that the executive team needed for analyzing the cost of company paid benefits for each employee.

Lawson ERP Software Upgrade and Migration

I collaborated with the Lawson consultants and SQL DBA to upgrade and migrate SQL Server and the Lawson application. It involved reconfiguring multiple data integrations and connections between Lawson and other finance and accounting systems. I also designed and implemented a new role and security class based system in Lawson Security Administrator to cleanup an outdated and cluttered security setup.

IBM Planning Analytics Cloud Migration

I oversaw and managed the migration of the on-premise TM1 database to the cloud platform. The migration included configuring the IBM Satellite Connector for establishing secure connections between IBM Cloud and on-premise data sources.

TM1 TurboIntegrator and CRM Data Integration

Implemented a new ELT pipeline for CRM data into the Finance’s TM1 database involved writing code in MDX in order to utilize the TM1 TurboIntegrator tool. I created a new TurboIntegrator Process for the automation of data extraction, transformation, and load to the TM1 cubes and dimensions.

Skills and Tools

My repertoire of programming languages, developer tools, and libraries.

Programming Languages: Python, SQL, PowerShell, MDX

Data Tools: Airflow, dbt, SQL Mesh, SSIS

Databases: PostgreSQL, MySQL, SQL Server, Snowflake

Cloud Platforms: AWS, Azure

Version Control: Git, GitHub, Bitbucket

Visualization: Tableau, Power BI, SSRS

Other Data Tools: Docker, Jupyter Notebook, Google Colab

Other Technologies: Jira, Flask (Python), REST API, HTML, CSS, Peewee ORM

Machine Learning: Matplotlib, Statsmodels, Seaborn, Scikit Learn, Pandas, Numpy, TensorFlow, Keras, Pytorch

Career

Professional Experience

Data Engineer

Trust for Public Land

November 2022 - Present

Lead the design and implementation of scalable ETL/ELT pipelines to process donor/funding, employee, and payroll data

Build and maintain database schemas to support advanced analytics and reporting for HR, Finance, and Accounting teams

Collaborate with leadership teams to define data requirements and deliver analytics-ready datasets

Data Analyst

Trust for Public Land

November 2021 - November 2022

Created complex SQL queries to extract, clean, and analyze data, including combining data from multiple databases

Designed and maintained reports and visualizations for the finance and accounting teams

Led the database management and data integrations from internal and external data sources

Senior Dietitian Nutritionist

Levine Cancer Institute at Atrium Health — Charlotte, NC

June 2019 - November 2021

Supported four surgeons in the Hepato-Pancreato-Biliary Surgery clinic, specializing in providing nutrition care for patients after surgery

Supported three GI Medical Oncology clinics, providing nutrition care for patients undergoing chemotherapy or chemoradiation

Registered Dietitian II

Kaweah Delta Health Care District — Visalia, CA

September 2016 - May 2019

Clinical inpatient dietitian at Kaweah Delta Medical Center, providing nutrition therapy for critically ill patients in ICU, Cardiovascular-ICU, and Oncology units

Outpatient oncology dietitian at Sequoia Regional Cancer Center-Radiation Oncology, specializing in enteral and parenteral nutrition support for patients undergoing chemoradiation

Education

Dietetic Internship Rotations

Iowa State University

January - July 2016

Bachelor of Science in Nutrition

Bastyr University

Kenmore, WA

Graduated June 2015

Get In Touch

I'd love to hear from you!