Michael Gates Email and Phone Number

Design systems to manage business processes, automate tasks, and improve business efficiency by developing applications using ASP, C#/ASP.Net, MS SQL, JQuery, AJAX, Web Development, Graphic Design, JavaScript, Custom Accounting Solutions, and more.

Pianist - Solo Piano, Solo Piano/Vocal - Yanni, Billy Joel, Elton John, Joshua Kadison, Beethoven, Gershwin.

Built applications expanding mapping and GIS/Geospatial libraries such as Mapbox and Kepler.gl. Built custom add-ons, enhancements, and components using ASP.net, JavaScript, JQuery, React/Redux, Vue/Vuex, and Node.js.- Agile environment with two-week sprints. Jira;- Designed custom components for analyzing real-time and historical geospatial data, tracks, track points, events. Mapbox, Kepler.gl, JavaScript, jQuery, ASP.net, C#, MS SQL, React, MongoDB, Web Services- Expanded Kepler.gl’s capabilities by adding customized components as well as services for subscribing to real-time and external data. Kepler.gl, JavaScript, React, Node.js- Built custom Import/Export/Conversion of Geospatial data. 4607/STANAG, CSV, Geojson, Json, KML - Worked as a team as well as individually, 100% remote with travel as needed.

An amazing experience working with some great people! Thanks to everyone I worked with during my two years at Exelon.Built business applications for Constellation Energy/Exelon Corp--WebAPI; SQL; MVC; Entity Framework; Database Design; Custom Software Design as a Senior .Net Architect V; Web Services; Working with a greatly effective team in an Agile environment.

First, I'd like to thank YGS for the opportunities they have given me. I can't tell you how much I enjoyed working with the team I was involved in. They are an absolutely amazing group of people. From the directors, to the designers, to the developers, to the programmers. All great people. It was a tough decision to move on. Thank you for the experience, the ability to grow and advance in my career, and most of all--the friendship.Worked with clients to provide solutions for marketing automation• Developed Extensions for the Pageflex/Storefront Marketing Automation Portal, website and ordering process, enhancing overall user experience: C#; ASP.Net; JavaScript/jQuery; HTML; CSS;• Designed and programmed cooperative funding system for Aetna, providing dynamic, real-time management of ordering budgets and reporting: Microsoft SQL Server; T-SQL; C#; ASP.Net; JavaScript/jQuery; HTML; CSS• Analyzed existing SQL Database architecture and built customizable reporting for use in the Pageflex Storefront e-commerce system. Built user interface for managing and building custom reports via simple-to-use web-based control panels: Microsoft SQL Server; T-SQL; C#; ASP.Net; Web API; Web Services; JavaScript/jQuery; HTML; CSS• Designed and programmed importing of data from Microsoft Access, Excel, TXT and CSV for use in printing automation. Developed and implemented processes to streamline data transfers and reports securely between multiple networks: Microsoft Access; Microsoft SQL Server; T-SQL, C#; Web API

Spearheaded the concept of project to final product; fully automated education, testing, and grading system; e-commerce; support; customer management; and SEO. Accountable for company’s financials, accounting practices, and reporting. Key Projects include the development and management of:• Designed responsive web site front-end, for use on mobile, tablet, and desktop: PhotoShop; ASP.Net; JavaScript/jQuery; HTML; CSS• Implemented dynamic one-page process for registrations, ordering, and e-commerce: ASP.Net; JavaScript/jQuery; HTML; CSS• Built fully automated e-commerce and accounting system handling real-time transactions: Microsoft SQL Server; T-SQL; C#; ASP.Net; JavaScript/jQuery; Authorize.net;• Developed comprehensive pricing, discount, and ordering system fully-integrated with Authorize.net to handle manual charges, returns, and refunds: Microsoft SQL Server; T-SQL; C#; ASP.Net; • Integrated Digital Rights Management and PDF Security Client/Server (FileOpen), for protecting PDF documents, managing security, print abilities, and computer access limitations: C#; Web Services;• Automated billing System for handling payment plans and subscriptions: C#; Windows Server• Built Windows service for sending email newsletters and other notifications based on triggers and schedules. Throttled emails based on domain, MX record, IP address, and handled retries based on settings in configuration file. Automatic removal of invalid emails: SQL Server; C#; ASP.Net; Windows Server;

Spearheaded the concept of project to final product a transportation logistics company, handling 100’s of transports per day in the U.S. and Canada for companies such as GE Capital Fleet Services, Donlen Corp., Bank of America, and General Motors. Built the company from the ground-up, handling 30,000+ vehicle transports per year, with a valuation of over $6 Million; sold interest in company in February of 2015.• Accountable for company’s financials, accounting practices, and business processes• Oversaw operations of scheduling, transportation, tracking, and reporting of 100’s of vehicles per day• Frequented meetings with operations department to analyze, improve performance of employees, and develop improvements to the system to improve efficiencies within the companyKey Projects include the development and management of:• Built front-end website design and user interfaces: PhotoShop; HTML; CSS; ASP.Net; JavaScript/jQuery• Designed and implemented accounting system and e-commerce system connecting customers, suppliers, and third-party vendors, resulting in real-time transactions via secure web site: Microsoft SQL Server; T-SQL; Microsoft Access/VBA; C#; ASP.Net; Web API; Web Services; JavaScript/jQuery; HTML; CSS• Wrote several hundred stored procedures for handling mission-critical transaction-based accounting functions: Microsoft SQL Server; T-SQL• Wrote comprehensive importing system for pulling data securely from multiple sources including SFTP, FTP, Email, Access, Excel, CSV, and more. Built a Windows scheduler service for handing tasks based on intervals ensuring data was imported when available. Handled adding, updating, and merging thousands of records weekly, into accounting and transportation system: SQL Server; T-SQL; C#• Designed and trained users on user interface for call center, dispatching, transportation, status and tracking, billing and payments: ASP.Net; C#; Web API; JavaScript/jQuery; HTML; CSS

Design custom upgrades, program improvements, and modifications to the People’s Choice Accounting Software in Microsoft Access and VBA. Helped develop their first Microsoft SQL Server version of the software. Continue to have a great customer relationship with the owners and employees, consulting from time to time to help issues with the software, SQL Databases, and other related issues: Microsoft Access/VBA; Microsoft SQL Server;

Built customized accounting system and dynamic sales processes. Increased productivity of employees by utilizing several technologies to allow better communication between departments. Installed network systems and workflow processes to reduce technology distractions and improve employee efficiency. Simplified warehouse structure by developing custom inventory and picking system. Established sales tools to automate the process from sales to installation. Improved company profits by developing custom marketing solutions and building comprehensive advertising tracking and reports: Microsoft Access/VBA; Microsoft SQL Server;