Computer Programmer Systems Analyst
Professional Computer Wrangler. YeeHaw!
Professional Computer Wrangler. YeeHaw!
A WordPress website offering with a completely custom template, using custom functions, widgets and features developed in PHP for the proprietary theme. All features of the website were designed with S.E.O. in mind out of the gate, and all aspects from design, content, and functionality involved the client to their liking. Additional Domain based management was included - such as multi-domain linking with Microsoft (Office) 365
The ever-more restricting Facebook-Instagram API was utilized for this website to provide as a news feed for the latest work performed by this new company called Sturdy Projects. The website focuses on maintaining industry presence on the web in a very easy to find, and easy to acquire fashion. A project done in PHP, as a substitute for my years of PERL use - as API's for OAuth and Facebook become scarce in the PERL world.
A light weight version of Skyway Park's major website, stripped down, redesigned from the bottom up. Many firsts fulfilled in a extremely short deadline, as the web based business, from idea to launch was only 1 month of development. The website itself is hosted on AWS, features prepaid reservations, uses self hosted email, and was (and still is) fully managed and developed by yours truly. Did I mention that the entire stack: from database to domain name took only one month to develop?
A hardware store fulfilling a need to have a website that matches their email. The website was built with a clean design by Anthony Pretezzani, as well implementing new SEO features providing great SEO resonance with Google, Bing, Google Maps, Yellow Pages. Facilitating a very competent web presence out of the gate. It does help that the business was well established and liked by it's clientele. The website also features informative pages, and product features.
A full feature website upgrade, with new sitemap management and SEO capabilities built in. Fully designed from the ground up - refresh of the Skyway Park website. The website includes a reservation system and an administration portal with open development backend to allow for new services and features to be provided on demand. It also connects directly to a cloud based SQL Server instance on Azure, for better customer management capabilities.
A very competitive simple website, with strong SEO out of the gate. The website is also a good example of an approved design forced into a readjustment. A logo was designed independently with a different colour/style intent than the original design. This forced colour switch and dimension switch was easy to execute but did affect the overall look negatively. None the less, the ease of use - content focused - Search Engine Optimized website provides the company with a significant number of leads, reliably allowing them to sustain their business.
Website Redesign for SVLaCosta for a simpler more compliant standard customizable catalogue based website. Special administrative features were added to allow for catalogue management for the client, that allowed for compressed and SEO compliant product pages to be uploaded fully integrated with the website. Some aesthetic modifications changed original design specific to the clients request, however, versatility and ease of use provides a competitive advantage for the online presenceof S.V.La Costa
Branding change for FM Embroidery to include new logo, style, and customized online retail for specific teams and schools. Due to financial restraints of the client, most work was executed on a demo only/trial basis.
An in-place upgrade for the Wadima imports, renaming the storefront to Wonen and upgrading the site to facilitate Catalogue management. This extended my skillset in both DNS competency, apache server rewrites, and providing low-cost database solutions.
ICG Business international portal website. Each partner country within IC Group of businesses required separate functional portals to access services that met their key needs first. The ICG website also serves as a CDN for the CMS system for other websites.
A website that contributed to the success of the Irish Pub (prior to changing owners in 2016 and going out of business of course after switching away from my website). The website used the twitter API and an internal scheduling tool to post social updates with pictures of current events, as well an internal scheduling system for party room booking and reservations.
Needing a quick, fully functional, campaign website with images, blogging, custom design, and a very contrained budget of $500; Robert Pella needed a solution that would
provide a strong online presence for his campaign. His website and word-of-mouth campaign garnered him a close second place finish on election day with a significantly lower campaign spend
Savings aside, it can be argued that he had the best campaign website
A second edition, upgrade from previous name fmembroidery.com website. Affordably developed embroidery store website with PayPal integration, custom product lists for teams, and custom in-house design.
Custom Version 2 Design of SvLaCosta website, produced by a third party designer with an experimental horizontal scroll layout. This early generation HTML5, JQuery website, provided a product catalogue and management interface to better highlight S.V.La Costa's range of products.
A complete upgrade of the existing website and web framework. The upgrade included a complete design update, content port to full HTML5 compatibility, mobile and cross platform access, latest security and performance enhancements, and new SQL Server database connectivity across all existing systems. This upgrade included full web server script rewrites of their Reservation Engine, Administration Portal, and Partner access program.
Small corporate website developed for Proline Hardware using updated and recent HTML5 standards for maximum compliance
Personal website using custom CSS and CDN filesharing to maximize the potential of a standard blogger website. The website's original purpose was to serve as a campaign website for my 2011 election run for York Region School Board Trustee.
A stand in replacement website for a Mississauga based restaurant, re-designed and rewritten to maximize SEO and multiple language support
Corporate website with a custom project portfolio developed with all the latest available web standards (for 2011)... Considering that the company has yet to update this website I can confidently say that my websites are coded to last a decade - not recommended in any way as back then, Internet Explorer still was the leading browser and viewing the web with a mobile device was still an obscure concept. Feel free to Contact them and suggest that they have me update their website!
Complete design and development of a Small Business website for FM Embroidery, including a low cost catalogue solution for their products.
Developed both a Website Administration and Content Management system for small business. Served as a redistributable CMS and CDN for all client websites.
Company requested decompile and rebuild of their website, including moving the site from different hosts with little down-time. Visual upgrades were made to the flash portion in minimal time.
Small visually intensive and standards compliant website outlining activities, photography, and all council activities. Job involved producing annual versions of the website to meet the needs of the Italian Association and their events.
Designed and developed a complete C#.NET website on a SQL Server Back End. The project involved managing a team of programmers as Project Manager.
Complete Website for Skyway Park with an easy to use administration system written in PERL. The website featured an online reservation system that bolstered sales for the company.
Complete self-managed website with forum, an online community, messaging, audio streaming, and several other features. Designed and maintained for 3 years reaching a peak of 50 thousand visits per month.
A competitive advantage comes with custom solutions, lost if you are running your business with the same software as your competition. A Systems Analyst can help you spot inefficiencies, technical improvements, or new technology that can benefit your business - and a Software Developer can bring that solution to life. Take a look at some solutions I have developed
A robust SQL Server database on Azure Cloud, connecting live with a local client Point of Sale system with custom receipt printing, special rates, custom credits and discounts with a whole slew of proprietary features. The Skyway Park System (SKDB2) provides a custom business proprietary solution which allows for fine-grain and relevant customer management and effective competitive capabilities including flight tracking, rate management, customer tracking - all for the key goals of a 5 star service company.
The system was originally designed using a rapid development / early deployment model so that core features could be implemented and put into production while other features as needed could be developed over time. This provides both as a blessing and a curse: For example, WinForms software appears antiquated on newer machines, but years of business logic built into the forms really make it too valuable to upgrade away. Ironically, this was some of the biggest hurdles Microsoft was faced with when introducing the XAML based development knee-capping Windows Phone and Windows 8 in the process.
ICG Business is a international conglomerate management company, based out of Osaka Japan the company provided
various Energy, Logistics, Travel, and Construction solutions. As systems analyst in the Canadian office -
it was important to provide many unique solutions for each of those fields. Example projects included
data-mining from US Census and Markets data, employee management systems, and logistics efficiency systems.
The long term as well as a provider of IT Solutions for their clients and partners. With ICG, I personally
worked with various clients and partners of ICG Business in developing and designing specific IT Solutions.
There I also help develop and deliver two commercial Web Based Content Management System products:
ICG CMS and
Serving internal use only, the Car Tracker App was a preliminary application designed to test the limitations of Progressive Web Apps as a viable alternative to atypical Andorid and iOS Apps. This project was unusually successful, with quirkly bugs, in facilitating access to Databases, mobile device cameras, and native system resources on a mobile device through an easily distributed web platform.
Creating a secondary data access framework for Skyway Park's database system that enabled e-commerce and web based dispatching, provided Skyway Park a discount option for their business. The execution of the project was done in extremely short order and delivered successfully.
During the process of upgrading all computers at Uptown Hardware to Office 365, an upgrade of their Access Database Software was required to be made more current. Future proofing their quotes database which has been in use for nearly 30 years required significant changes, while maintaining the core software.
Multiple Phase Customer retention and sales tracking system for a Florida base marketing group. The project focused on moving massive record-keeping from shared Excel sheets to a online portal with SQL Server operating in the background. Poorly managed project forced some unusual constraints including mass enqueued faxing through a web interface, but delivered on each provided project charter on each phase as approved. An excessive amount of R&D was involved however, I was never responsible for seeing through the final phase needed for implementation.
What began as an experimental side-project, quickly evolved into a full featured and fully functional robust
barcode scanning interface common with most Point of Sales systems today. Please note the year, this preceded both
StarBucks and MacDonald's adoption of the very same Motorola imaging scanners they use, to a more integrated extent.
Point of Interest: Few people are aware that the barcode scanners can operate as full-fledged flashless cameras.
One of the few software development projects I wasn't a lead developer of, Systems Analyst or Project Manager for. Some work simply requires an extra programmer to get the job done - Conexsys needed to extend the feature set of their system that I was already previously familiar with. Small clean job.
An evolution of the SavourySavvy project. The EatWell nutrition tracking system was a bold step at providing consumer friendly nutrition information within meals, recipes, meal-plans alike. This project was ambitious and eventually failed due to it's vagueness. My efforts as a systems analyst and project manager was an attempt to rationalize the Project Sponsor's ideas - narrow the key competencies and make it work without sacrificing any core designs.
I was able to facilitate a PHP based Content Management System that can platform any utility described, and was able to get the project sponsor to agree to get an artist to develop mock-ups. Unfortunately, the project sponsor went rogue hijacking my recommended designer and created mock-up plans for web functions above any reasonable development expectation, as well as iPhone and Android apps that provided different functionalities of the core product, describing a diverse set of utilities that lacked the business logic, expertise, or professional technical information required to make any of these tools functional.
I would eventually take the fall for the failure of this project for reasons unknown and watched as the project moved on without me and my codebase - to another web development team's code-base, then back to my code-base within the following months. I'm not sure what came of the project sponsor, but, i made some life-long friends with a few software developers and remained with some great PHP utility code that I still use in many of my web projects today.
Savoury Savvy was a concept project for restaurant and food service companies to provide meal plans based on nutritional needs of customers.
The project was introduced to me with some code and demos etched out, and whiteboard ideas being prepared. It didn't take long before
I assumed role as project manager, as I'm keen on planning thoroughly before developing any software.
The project required a custom PHP based Content Management System that enabled a MVC (Model-View-Controller) framework for development. This allowed us to quickly deploy, and pivot, any function or data view as required while the
details of those ideas were being worked out.
An upgrade to the existing local db SQL Server Database and Point of Sale customer management system, providing a significant improvement of capabilities and increasing overall capacity for the Skyway Park operation. This full system overhaul springboarded the company in a more agile approach toward the operation leading to many years of solid growth. The in-house develop when we need it system provided Skyway Park analyst advantage over the competition that still holds true to this day.
One of the biggest hurdles of this system was to move an existing Microsoft Access database to a SQL Server Locally hosted database. Then operate multiple versions of the database connected through a mix of protocols (local, LAN network, or internet). The upgrades afforded an opportunity to better normalize the database design, and future proof the capacity of the system for potential features and upgrades.
Canada's leading event registration company required a system where they could provide online web registrations alongside with the offline event services they provided. Creating a new system from scratch as a co-project manager using the latest technologies from Microsoft, we created a system where registration websites could be made and designed dynamically connecting to any e-commerce gateway as needed. Challenging project with undesirable timelines and budget constraints.
This project was extremely client focused, working with a friend on the system design, his focus was creating more utility for customers of Conexesys first, then, intending on rounding out the management interface afterwards. Constraints on the project failed in having the management interface ever become whole. However --- the project without any significant development managed to be a favourite for Conexsys clients for approximately 10 years after it's development. Much longer than the intended shelf life, processing many millions of dollars in transactions during it's tenure.
Joining as a junior software developer in a small dev team project which allowed companies to use proximity text message advertising to potential customers. Developing various WWW to SMS utilities using the .NET framework as well as driver development for some proprietary technology.
Looking back on this work, this was a great project that I'm not too proud of - 2008 was a year where technology took a leap above privacy concerns and individual rights. Developers often are so amused at investigating possibilities, that they often forget the social implications of the technology itself. I'm not personally aware where the project went after my time working on it - but considering that by 2014 SMS advertising became a $100 billion market. I'm certain it was leveraged somewhere
A local newspaper looking to compete in a dense market contracted me to provide them a system that allows them to collaborate easily between journalists, writers, and editors. The unique collaborative environment allowed for graphic designers and editors to easily access, modify, and print files across various computers of various operating systems, computers, and lap tops within their network.
Developed and deployed two versions transaction system and database which carries and maintains all records of daily business activities for Skyway Park, as well provides web services for reservations made by customers on their website.
Received highest mark possible in the FLASH programming course at Seneca College, while developing a prototype cloud computing system in 2005-2006 as my thesis involving a varied array of software platforms including: VB.NET, ASP.NET, C#.NET, Windows COM+, MFC, C++, Bash Shell Scripting (Linux), and SQL SERVER.
I've always participated in a significant manner in various communal, public, or volunteer activities. With a variety of roles intended for the public good. More often than not, it is the non-technical skills from my experience in these roles that serve more important in my undertakings.
Longest Serving uninterrupted executive of Council #13164 of the Knight's of Columbus. The local chapter of the Knight's of Columbus serves as a non-profit charitable and community group. Positions held within the council include:
Presented by Fr. James Chitteth. CFIC recognizing exceptional service to the community
Presented by Vaughan Mayor Maurizio Bevilacqua, an award honouring the uncountable amount of community service I had undertook over the years.
Performed youth outreach, community service, as well as social and spiritual development of the youth of Immaculate Conception Parish and extended area community.
The key undertakings of the group included:
Worked as an Emergency Supply Teacher for a local area high school where I was contacted regularly when unionized supply teachers were unavailable or for other emergencies.
Responsible for scheduling, booking, and organizing entertainment at a newly founded two day carnival in Woodbridge. Worked closely with regional councillors of the City of Vaughan in the production of this highly successful event.
One of North America's biggest Russian festivals, an annual event at Canada's Wonderland. Participated in day-of, back stage activities in organizing the talent, the media, advertising, and filming of the event.
Educating adolescents between 13-15 to prepare them for confirmation into the Roman Catholic Church.
Assisted customer needs in the areas of Plumbing, Electrical, Paint, Tools, Carpentry, Household repairs, and other hardware related activities. Was consistently working across various departments and training an array of new staff.
Overlooked and taught children from 4 to 15 in a "learn to skate" program at the Woodbridge Figure Skating Club. I contributed greatly in helping the club reach its peak membership during those years.
Received top honours and recognition for my proactive coaching abilities for the Woodbridge Figure Skating club for their CanSkate / Learn to Skate program.
Was voted (not acclaimed) to the role as one year owner-occupied position at a turn over meeting of a new condominium in Woodbridge. In my role, I focused my efforts in ensuring the most responsible reserve fund and a strong audit of assets.
Unlike past board positions and meetings I took part in, this was the most mandated and legally defined roly yet, counter-intuitively, the least professional environment I ever took part in. Hopefully, in future years for the sake of the shared assets I'm invested in - this board will involve more persons or operate more formally.
Provided tutoring services for Advanced/Expert level Microsoft Office Word and Excel both in person tutoring and online only tutoring, assisting all students in achieving marks above 80% in their respective programs.
Worked a countless number of side jobs repairing and maintaining computers. Comes with the territory of being a
Computer Guy I guess....
Achieved highest election result without having an advertising budget, learned various particulars about public office and elections in general.
The experience was wildly interesting and enlightening. Understanding advertising and power dynamics in the public theatre serves valuable in assessing success of an endeavour. Learning also about human behaviour in competitive environments provides experience that can't be replicated through regular paid work alone.
Achieved highest election result without having an advertising budget, learned various particulars about public office and elections in general.
Placed top in school for each math/problem solving competition undertook in high school, receiving provincial recognition in each contest.
First formal job in which I acquired the sense of responsibility at a young age.