Projects
Projects build skills and skills are developed and made better with experience. Many of my skills have been developed as I have solved a wide variety of technical challenges.
Here is a high-level summary of some of the projects that I have been asked to complete.
Network Infrastructure Maintenance
- Create a system server to host monitoring software
- Configure to include servers, HVAC systems Network Switches, Communication routers, Phone systems and Security systems
- Define a LAN addressing scheme that includes VLANs
- Add a virtual switch port for the VMWare client that will be moved from the corporate LAN to the DMZ
- Re-program the switch ports and trunk lines (Cisco IOS) to function as part of the VLAN used for the DMZ
- Define firewall rules to allow access to this system from the local LAN but prevent access from the local LAN from this system.
Systems Administration
- Create a scheme and structure to roll out WSUS in a trial to a limited number of systems
- Create Active Directory security groups and Microsoft Group Policies to implement update services
- Gradual roll out of solution
- Research and find options for self-hosting of LAMP websites
- Install and configure Linux Virtual Machines on Azure Services
- Port site content
- Update DNS and other site services
- Create a project plan for upgrade with uninterrupted services
- Work with third-party vendor to implement plan according to timeline and budget constraints
Database and SQL
- Write and debug an SQL query against an SQL2008 database
- Use Microsoft Visual Studio to design, test and debug the report
- Deploy the report to a SRSS Server
- Create a schedule to distribute the report each night via email.
API and Application Programming
- Write and debug an SQL query against an applications database
- Create a PhP program that makes REST calls to an API to extract and format data
- Create a wrapper to implement the solution as a WordPress plugin.
- Create responsive CSS and HTML pages
- Test and rollout
- Understand how Mandrill handles failed email deliveries and the requirements for a Webhook
- Create a PhP program to collect failed delivery information, format it and send notification emails.
- Design and create scheme for a set of digital signs and content that can be updated by event and officemanagers
- Acquire and install hardware and network scheme to support digital signage
Classroom Instruction and Training
- Create the content outline
- Author presentations and support material
- Present training to 60+ employees over two sessions
- Create the content outline for the course
- Author presentations and code examples for 15 hours of instruction
- Research and add supplemental content to the class website