My story
My interests have always spanned from creative to technical.
During high school I exerted my creative energy in the Communications Media shop (photography, graphic arts, radio and TV) where I developed a deep passion for graphics and photography. In my free time I worked with a Nikon F3 High Eye-point film camera system to photograph weddings, events, portrait and modeling photos. I then purchased a digital Nikon D3200 and spent many years creating with Photoshop, Illustrator, and Premiere.
I was once told I missed my calling in psychology but I'd rather apply the insight to advertising instead. While involved in community TV, I conceived ideas for television ads and performed voice overs for several local business commercials.
My professional career was more technical. While studying to becoming a baseband TV Broadcast Engineer, I realized the potential of the Web and that the future belonged to Wireless, Broadband and the Internet. While employed as a Sr Digital Electronics Technician in Engineering, I set out to study business, software development, database and web technologies.
For 13 years I worked full time while attending college and accelerated programs in the evening. I applied what I learned in SQL and software development to my day jobs.
My college pursuits were focused on a(n)
- Associate in Business Administration/Computer Science, Software Development and Database (2006)
- Associates in Applied Science in Web Development (2013)
- Bachelor of Science in Information Systems, Software Development and Database (2012)
I primarily used my software and database skills in the collection and presentation of data for engineering, manufacturing, and business intelligence reports.
- I developed a program to capture data from an electronic device and parsed the data into Excel spreadsheets and text files using Visual Basic and VBA code.
- I develop an SQL database using MS SQL queries and Access tables to inventory assets, metalwork, and electronic components totaling around $5,000,000 and to generate production reports, invoices, packing lists, as well as track shipping histories, and electronics assembly and test data for engineering. Reports were created within Access, and also exported and formatted into Excel using VBA code.
- I utilized my database skills with HubSpot to manage, segment, and edit lists - creatively pushing past the intent of HubSpot's intended capabilities.
- I created a database using MS SQL queries, mathematical equations in SQL, and Access tables to track production data and produce reports for benchmarking and business intelligence.
- I created an Excel spreadsheet and used PowerQuery to pull inspection data in from several other spreadsheets. I then used VBA code to compile the data and format the data in a master sheet of all inspection data. All this was done by the click of a single button in the master sheet.
- I created and produced reports from within Prophet for sales anlaysis and to track performance of the customer service representatives.
- I am currently working with PowerBI Desktop, Python, and R. I also have an understanding of Salesforce from courses I studied in SkillUp.
I was also able to combine my technical and creative skills into Web Design and Development, including Marketing advertisements.
As far back as 2009, I coded websites in my spare time for organizations, my brother's company, and at some of the companies of which I was employed. I focused on Marketing, Semantics, Responsive Design, SEO, Google Analytics and in UX/UI, Web and Accessibility best practices. I coded by hand on LAMP and .NET, and work within WordPress and HubSpot - among knowledge of other CMS.
In the course of my journey, I have coded with
- HTML4, HTM5, DOM, CSS2, and CSS3
- JavaScript frameworks such as jQuery, Knockout.js, and Bootstrap
- JSON, AJAX, XSLT and XML
- VB6, VBA with Excel (with PowerQuery) and using Access for SQL
- .NET: VB.Net, ASP.Net, C# and C++
- LAMP: PHP, MySQL
- SQL: MS SQL, MS Server, MySQL, Oracle
- objective-C, Python
My graphics and photography skills have been used for
- Social Media
- Email Blasts
- Email Newsletters
- Company Newsletters
- Brochures
- Posters
- Technical Illustrations
- Greeting Cards and Invitations
- Print and Web advertisements (adverts)
- Videos
Much of the code I created in engineering and analysis is confidential and I cannot link to nor publish it here. Below are some examples of my public work to explore. Please check back often as I continue to build this site.
Thank you for visiting!