Work
My work mixes software engineering, data engineering, business intelligence and data science.
I write code and work with lots of data.
Sample Projects
A few example projects ranging from applications to analytics.
CRM
Customer Relationship Management to keep track of customer relationships and bring the entire sales and marketing process into a single application. Increased the customer's efficiency and their bottom line.
Work Order Management
Applications that enable customers to request work orders that are able to track the progress and assign work to staff for fulfillment. System featured automated notifications, multiple permission levels and record filtering.
Data Pipeline & ETL
Data pipeline that synced databases across multiple servers that holds similar data with two separate formats. The pipeline used ETL to perform manipulations and timestamps to determine with records to update using both batch and stream processing.
Predictive Analytics
Automatically predict when an order would be completed based on the current queue of orders. Automatically notified the user of the estimate moments after initial request was made.
Recommendation System
Automatically recommend items to users of a work order application with many options based on similarity of the current user to historical requests.
Data Enrichment
Enriched data sets with new information to help the data provide a more detailed picture of the scenario and enhance decision making.
Data Import
Pandas script to process a heavily formatted Excel file received from other teams. Script removed formatting, performed data mapping and ended up with a CSV that could easily be imported into database.
Data Cleaning
Cleaned data from a regular import to ensure that it was property formatted for the destination database. Ensure data used consistent terminology, without missing values and removed duplicate records.
Feature Engineering
As part of an analysis project feature engineering was needed. When data was unavailable from existing sources it was interpolated based on data from adjacent records.