Brought in to assist in bringing the code to .NET Core (later .NET 7), Entity Framework Core and more modern web technology for an extremely large multi-tenant (SQL and web) recent Azure migration: - Worked on Single Sign-on using Azure AD B2C while mostly maintaining the existing login flow including detection of the "third-party sign-on service" that is appropriate for the given tenant user. - Integrated a third-party forms tool allowing for creation of complex data ingress by… Show more Brought in to assist in bringing the code to .NET Core (later .NET 7), Entity Framework Core and more modern web technology for an extremely large multi-tenant (SQL and web) recent Azure migration: - Worked on Single Sign-on using Azure AD B2C while mostly maintaining the existing login flow including detection of the "third-party sign-on service" that is appropriate for the given tenant user. - Integrated a third-party forms tool allowing for creation of complex data ingress by non-developers; due to the JSON structure received, required writing a very complex parser to produce sane, consistent POCOs. This integration was designed as generically as possible and as such was able to be delivered to three other customers within weeks of the first deployment. - Eliminated thousands of SQL queries per request, created complex database tracing tooling (the existing environment offered nothing as useful as .NET Core) and improved database performance across the board in various parts of the system. Show less

Designed various Alexa and Web applications/services for clients with key highlights:- Led in the development of a 3D in-browser parametric CAD tool designed to make it possible for non-technical customers to customize gripper fingers for 6-axis industrial robotic equipment (and other robotic "grippers").- Participated as a developer on the team responsible for the release of a complete robotic vacuum platform commissioned from a global leader in vacuums and kitchen gadgets.-… Show more Designed various Alexa and Web applications/services for clients with key highlights:- Led in the development of a 3D in-browser parametric CAD tool designed to make it possible for non-technical customers to customize gripper fingers for 6-axis industrial robotic equipment (and other robotic "grippers").- Participated as a developer on the team responsible for the release of a complete robotic vacuum platform commissioned from a global leader in vacuums and kitchen gadgets.- Interacted with customers and sales to bring customer's product vision to life.- Worked with a customer to deliver a social networking site for schools.- Worked to convert a Leaderboard for a very popular customer app to be capable of displaying the top 100 leaders in real-time: all time, per year, per month and "per trail" (the app is for tracking ORV trails). Previous operation cached the values due to the requirement to perform a complex query with several function calls over a table with several million records joined to several child tables. I created a few indexed views to eliminate the function calls/optimize joins, added a few indexes and we were able to generate each list in sub 200ms. The previous process for re-generating the list was so impactful that turning it off dropped the database utilization by 20%. Show less

Designed solutions for customers integrating Lync 2013 and later Skype for Business using the UC Client API and Lync Web Services (precursor to Graph API): - Rewrote a tool for automated conference service admission; worked via unofficial/reverse-engineering of the database to allow conferences to "auto-start" when certain dial-in participants joined, but otherwise preventing start until an authenticated user joined (to prevent rampant fraud). - Designed a complex distributed call… Show more Designed solutions for customers integrating Lync 2013 and later Skype for Business using the UC Client API and Lync Web Services (precursor to Graph API): - Rewrote a tool for automated conference service admission; worked via unofficial/reverse-engineering of the database to allow conferences to "auto-start" when certain dial-in participants joined, but otherwise preventing start until an authenticated user joined (to prevent rampant fraud). - Designed a complex distributed call blocking tool for a global Oil company: the requirements involved keeping a global, regional and individual "block list" synchronized with the call manager servers where the call managers and the end nodes may be located in parts of the world with extremely unreliable internet connections in parts of the world where some of those problems involve "government interception/blocking". - Participated in the development of a custom "conference room experience" involving software that interacted with the S4B back-end but presented a UI and features appropriate for a conference room. Show less

Key player in major corporate initiatives: - Part of small team responsible for IT merger activities between Global Crossing and Level 3 - Wrote code to integrate both companies AD systems on merger "Day 1" while rewriting Lync SIP URIs for Global Crossing participants and integrating both companies' on-prem Exchange Services. - Worked to decommission most of Level 3's security audit tooling (purchased from a popular vendor) due to it not meeting our contractual obligations with the… Show more Key player in major corporate initiatives: - Part of small team responsible for IT merger activities between Global Crossing and Level 3 - Wrote code to integrate both companies AD systems on merger "Day 1" while rewriting Lync SIP URIs for Global Crossing participants and integrating both companies' on-prem Exchange Services. - Worked to decommission most of Level 3's security audit tooling (purchased from a popular vendor) due to it not meeting our contractual obligations with the US government resulting in the extension of the auditing tool I wrote to cover database services in Postgres, SSH bastion host connection and a large ingress of data from Solaris and Linux hosts in our environments. The addition of this functionality increased the tool's audit and remediation time to about 10 hours. - Implemented a change management tool that eased the burden of moving things to production without introducing risk: each morning meeting involved visiting a web page where each item was discussed and "approved or denied." The views updated in real-time as the meeting occurred resulting in a 30+ minute meeting per day averaging about 5 minutes afterward. This also included tooling that notified the approver when their action was needed via Microsoft Lync complete with all of the details needed to approve/deny the request that they could simply reply "Y" or "N" to on their mobile device, eliminating "chasing down people for approvals."In addition to regular responsibilities of: - As I had experience in the language and worked closely with security, I performed Secure Code Review for aspects of our conferencing software written in C++ Show less

Worked on several projects as part of Microsoft Super TAP and Microsoft TAP for OCS/Lync: - Designed, Project Managed, selected equipment and technology involved, developed and delivered a "Visitor Access Kiosk" which had tight security requirements in order to limit the need for a receptionist at a new location in Rochester, NY and an existing location in Southfield, MI; it was a locked down OS (carefully stripped of anything that could be removed) which ran a full screen XAML app with a… Show more Worked on several projects as part of Microsoft Super TAP and Microsoft TAP for OCS/Lync: - Designed, Project Managed, selected equipment and technology involved, developed and delivered a "Visitor Access Kiosk" which had tight security requirements in order to limit the need for a receptionist at a new location in Rochester, NY and an existing location in Southfield, MI; it was a locked down OS (carefully stripped of anything that could be removed) which ran a full screen XAML app with a Windows Vista design (given the time) using an SAW touch-screen allowing a visitor to provide their name, who they are visiting, initiate a conversation from the Kiosk with them via Lync (allowing the employee to "approve" the visit) which then let the user take a photo (and re-take if desired) where it printed a badge with a barcode. The employee would let the visitor in and on the way out they'd scan the barcode indicating the end of the visit. The system used a database to log/report visits that did not log out and notified the visiting employee to confirm they are no longer in the building. - A very basic video was put together at the time available here: https://www.youtube.com/watch?v=aV3kaBo4GQM - Designed tooling to allow an application to "ask Lync to write a message to someone asking for approval and return the response to a Web Hook" which allowed tightening up several "Approve/Deny" processes that often were ignored by the people required to approve due to the friction involved in "getting the information required to decide if it's appropriate to approve." By delivering *all* relevant information, most approvals happened within a minute or two of receipt. Show less

Highlights: - We were given a requirement to eliminate all access for leaving employees within 24-hours from every downstream system. This required *auditing* every downstream system in less than 24-hours. I was tasked with coming up with a stop-gap while we found a third-party solution that met our needs. There were none and during the time searching for one, I had managed to write a multi-threaded tool that could read the ACLs on every file on every Windows Server, reachable… Show more Highlights: - We were given a requirement to eliminate all access for leaving employees within 24-hours from every downstream system. This required *auditing* every downstream system in less than 24-hours. I was tasked with coming up with a stop-gap while we found a third-party solution that met our needs. There were none and during the time searching for one, I had managed to write a multi-threaded tool that could read the ACLs on every file on every Windows Server, reachable desktop/laptop, Windows Domain (the entire directory was collected), MS SQL Server ACLs as well as a few custom "home grown system" ACLs. It could handle thousands of hosts, globally (on a fast telecom network) in 6 hours, initially. After adding SSH support and 5,000 unix ACLs as well as Postgres, it completed around 12 hours Designed a distributed multi-threaded security tool still in use, today, which attached to every AD controller, Windows Server, Microsoft SQL Server (database instance) and every host that was turned on in order to collect every permission record that could be collected. It was also capable of revoking and assigning access from the same service. - This tool was integrated with a "request" tool which allowed users or managers to request the access required for a user's role in a simple progressive form "that only asked for things we couldn't get any other way"; many access requests involved checking a box. All required approvals from an SRE and a member of security. These approvals were wired up to an "Approval Bot" which later was tied into Lync. This meant that a manager could request access for an employee, and if the approvers had their phones handy, their employee would receive that access as soon as all of the approvals arrived and the system initiated the access grant. - On exit, any employee with a term date would have their access revoked, comprehensively, from *everything*; This could be "replayed" if the termination was an error. Show less