Ben Elder Email & Phone Number

Portland, Or, Us

Portland, Or, Us

Cincinnati, Ohio, Us

Lake Oswego, Oregon, Us

In addition to the responsibilities of Data Analyst:Created custom metrics, visuals, and reports using Power BI to meet client needs.Developed new ETL processes and improve efficiency of existing processes.Project Work: Led in the creation of a new ETL process using clinical data to help Coordinated Care Organizations track OHA quality health metrics resulting in two new client practices.Automated validation of client data by creating python scripts to compare transformed data stored in SQL and PBI to reports generated from the client practice management and accounting software leading to decreased onboarding time and increase in the number of data points validated.

Lake Oswego, Oregon, Us

Identified and implemented efficient and scalable methods for transforming healthcare and accounting data using Python and MSSQL. Verified accuracy of transformed data and maintain integrity of data stored in MSSQL.Developed functions and triggers to automate ETL processes using Microsoft Azure.Collaborated with software engineering team, business analytics team, clients, and practice management/accounting software vendors.Project Work:Led in creation of ETL process for Denticon dental practice management software.

Chicago, Il, Us

Developed and performed business to business sales process resulting in the first retailer partnership for the company. Streamlined communication between internal designers, factories, and partners resulting in shorter product development cycles. Researched business opportunities as needed resulting in carbon neutral packaging, implementation of a project management software, and new product development.