Oracle Transaction Database
A fully working Oracle transaction database that allows new orders, shipping warehouse and inventory updates, along with aging and sales report generation.
FLARE
A tool built while interning at Blizzard, designed to consolidate numerous independent internal tools into one clean page with full functionality and room for expansion.
Oracle Transaction Database
The goal of this project was to create a fully working Oracle transaction database that allowed new orders, queries, shipping and warehouse updates, inventory updates, aging and sales report generation, spanning six programs.
https://github.com/ArnoAlford/My-SQL-Database-Project
About Me
I am a Site Reliability Engineer and recent new grad pursuing a love for everything DevOps. I have been building and tinkering with computers since I was 13 years old, and it is this passion that has pushed me into the tech world. Since working in the Network Operations Center at Blizzard, this firsthand experience has focused my passion on automation, monitoring, cloud and deployments.
In my free time I love to experiment whether it be my homelab, my keyboard, or my OS; I really enjoy creating things from scratch. I have also been spending a lot of time learning through DevOps books such as The Phoenix Project, The Google SRE book, and my current book: The DevOps Handbook. Thanks for visiting. If you have any questions or would like to reach me, please do so.
I am a Site Reliability Engineer and recent new grad pursuing a love for everything DevOps. Since working in the Network Operations Center at Blizzard, this firsthand experience has focused my passion on automation, monitoring, and deployments. Thanks for visiting. If you have any questions or would like to reach me, please do so.
Contact
arno.alford@runbox.ch
(714) 325-8213
Placing the Order
First we'll generate a sales order by running order.sql and inputing the Customer's ID, the product they want to buy, the quantity they want to buy and what warehouse they will order from.
The Result
Shipping the Order
The sales order number is entered along with ship date and ship quantity. From here the program stores these shipping variables and adjusts inventory levels for the now shipped goods.
The Result
Querying the Order
In case we need to review the order, we have a query program that shows an easy-to-read
view of the the selected sales order.
Generating Aging Reports
Some orders may get caught in the system and not actually ship. We run Aging.sql to generate an aging report to see which orders have perhaps been open for a bit too long.
The Result
Generating Sales Reports
Lastly we generate a sales report to see how much of each product we sold each month by running SalesReport.sql
The ResultNetwork Observability with pfSense
A project to use monitoring, automation and metrics to evaluate and improve my home network's performance on a pfSense router.
Who Am I Communicating With?
Using the ntopng package, I am able to grab traffic statistics from my router. From this I can see impactful information such as what IP's I am connecting with, how much of my traffic is going towards each IP, and what ports I am communicating on the most.
Who Am I Communicating With?
Using the ntopng package, I am able to grab traffic statistics from my router. From this I can see impactful information such as what IP's I am connecting with, how much of my traffic is going towards each IP, and what ports I am communicating on the most.
What Applications are Doing the Communicating?
One of the most useful metrics I can grab from ntopng is application protocol traffic. Here I can see exactly what applications are talking on my network, how much bandwidth they've used, and how long they've been up. This opens up some interesting questions such as "Why am I talking with Facebook if I don't have an account with them? Where is that traffic originating from?"
What Applications are Doing the Communicating?
One of the most useful metrics I can grab from ntopng is application protocol traffic. Here I can see exactly what applications are talking on my network, how much bandwidth they've used, and how long they've been up. This opens up some interesting questions such as "Why am I talking with Facebook if I don't have an account with them? Where is that traffic originating from?"
Increasing Performance Through Caching
Through the use of Squid as a transparent proxy I am able to analyze and cache frequently visited pages. What does this mean? It means that the assets for frequently visited websites are stored on my server and used in place of redownloading them on each page load. This means reduced page load times and reduced bandwidth usage on every page I visit frequently.
Increasing Performance Through Caching
Through the use of Squid as a transparent proxy I am able to analyze and cache frequently visited pages. What does this mean? It means that the assets for frequently visited websites are stored on my server and used in place of redownloading them on each page load. This means reduced page load times and reduced bandwidth usage on every page I visit frequently.
Caching Encrypted Traffic
If left default, the only traffic my proxy could read and cache would be HTTP; however most taffic today is over encrypted HTTPS. To get around this I had to make a CA (Certificate Authority) to issue certificates that allowed me to splice HTTPS packets. This means that all web traffic, even the encrypted, will now be cached.
Caching Encrypted Traffic
If left default, the only traffic my proxy could read and cache would be HTTP; however most taffic today is over encrypted HTTPS. To get around this I had to make a CA (Certificate Authority) to issue certificates that allowed me to splice HTTPS packets. This means that all web traffic, even the encrypted, will now be cached.Automating Backups
One of the features not natively supported in basic pfSense is automatic backups, so I wrote this script to automatically create a backup once a day. The script is run on a remote server, and it pulls the backup from the router using the login form and a token. In addition, I have the script check and delete any backups older than 10 days.
Automating Backups
One of the features not natively supported in basic pfSense is automatic backups, so I wrote this script to automatically create a backup once a day. The script is run on a remote server, and it pulls the backup from the router using the login form and a token. In addition, I have the script check and delete any backups older than 10 days.
Automating Updates
Another important feature for me was updating the router. I always forget to install updates when they come out, so I wrote a script to automatically check and install any updates that are avaliable.
Automating Updates
Another important feature for me was updating the router. I always forget to install updates when they come out, so I wrote a script to automatically check and install any updates that are avaliable.Flare
Built on Python, Flask, and MySQL for the back-end, and HTML, CSS, and JavaScript for the front-end, FLARE allows numerous internal tools to be accessed and reshaped from one central page with full functionality.
https://github.com/ArnoAlford/FLARE
