And this is my Professional Website, a place to showcase my programming skills and experiences as a data and analytics engineer, by focussing on areas that are of particular interest to me including: open source technologies, data automation, the impacts weather has on your body and most importantly good food.
Click here to discover my capabilities!Equipping decision-makers with the tools to make sense of the data.
Building and managing relational and non-relational databases including Postgresql, MySQL, Sqlite and MongoDB.
Ingesting and transforming information from various formats: JSON, CSV, PARQUET, XML and YAML.
Leveraging Python, SQL and Bash data scripting to optimize each stage of the ETL and EtLT process. Building automated data pipelines utilizing the cloud (AWS).
Click here to go to my REST API apps!
Harnessing the power of Python and its standard and third-party libraries (Pandas, Polars, PySpark, SQLAlchemy) to build robust data models. Applying the latest SQL advanced querying techniques (CTE's, Window Functions, CASE statements) to summarize the data for the hard questions. Utilizing relevant statistical concepts and aggregation methodologies to make valid inferences from the results.
Organizing information in a way that is clear and concise - allowing for iterative discovery, driving towards refined analysis and informative data visualizations.
Building data reports and dashboards (hosted via the Cloud on AWS and Heroku) to synthesize complex datasets into digestible information.
Click here to go to the data viz website!
Including automated and managed data pipelines for the purpose of feeding interactive data visualizations, apps to assist in educational goals, personal web apps
and a portfolio project from the Codecademy Data Engineering Career Path.
Click any of the images below for the full README docs, and also the link to my GitHub repo.
Apple Weatherkit REST API... to an AWS RDS Postgresql Database: 4 Hour Sequence (Lambdas and EventBridge)
An AWS RDS Postgresql instance of historical hourly weather data for 112 US Airports locations, regularly ingested and transformed from .csv files.
Need the data from the two AWS RDS instances that drive the data visualizations (projects to the left). These REST API's allow you the opportunity to get it in a standard format (json).
Full-stack Web Application built utiizing Flask, Python and Postgresql.
Click for site: Recipe Website
Two desktop apps -> one for notetaking and a second for studying to aid in passing the PCPP1 certification exam.
A project intended to automate the data ingestion of subscriber cancellations for an online learning company. Ultimately providing a tidy, analytic ready csv file and sqlite database
I am available to do freelance work in the programming domain, no project too small.
Email, Phone or Text me...