ETL Developer
Hi, I'm Robert Beane, an ETL Developer at PrimeWest Health in Alexandria, Minnesota. I graduated with a BA in Computer Science from the University of Minnesota-Morris in 2022. My passion for technology began with my high school robotics team and designing our team’s website, and has only grown since.
I thrive on solving complex problems, whether independently or as part of a collaborative team. My interests span data engineering, automation, and building solutions that make a difference.
Connect on LinkedInKey Technologies: AWS Lambda DynamoDB REST APIs
(Download the full write up here or visit the GitHub Repository)
Purpose: The purpose of this application was to allow for an evolutionary process to find the best solution to the “Traveling Salesperson Problem,” a problem that figures out the shortest route from a given set of locations and distances.
Solution: The application’s architecture consists of an HTML web app that displays the evolutions at work. Several Lambdas using JavaScript are called via a REST API, with DynamoDB for storage and IAM roles for permissions.
Key Technologies: Typescript Java Angular Agile
(Download the full write up here or visit the GitHub Repository)
Purpose: Provide an easy-to-use web app for students to see the status of laundry machines, report issues, and get notifications.
Solution: Angular frontend, responsive CSS, cookies for preferences, Java Spark backend, MongoDB, hosted on DigitalOcean with CloudFlare HTTPS.
Key Technologies: Python Pandas Scikit-learn Data Visualization
(Download the full write up here or visit the GitHub Repository)
Purpose: Analyze large datasets to extract meaningful patterns and insights.
Solution: Used Python and machine learning libraries to process, analyze, and visualize data for actionable results.
Key Technologies: SQL Server SSIS SSRS PowerBI Python
Building ETLs using SQL Server Integration Services (SSIS) to extract, transform, and load data from various sources. Creating useful reports for end users with SQL Server Reporting Services (SSRS).
Purpose: To streamline data processing and reporting for healthcare analytics.
Solution: Developing robust ETL pipelines that ensure data integrity and availability for business intelligence tools like PowerBI and (SSRS).