John Gemkow
Senior Consultant at Microsoft

Architect and lead delivery of custom agentic AI and modern business process solutions for Microsoft Industry Solutions Delivery (formerly Microsoft Consulting Services) customers across the Microsoft 365, Power Platform, and Azure clouds.

• Progressed from individual-contributor development roles to leading distributed onshore/offshore teams of up to 10 engineers, owning solution architecture and technical quality across multi-workstream engagements
• Deliver customer-focused solution engagements that extend client investment in the Microsoft cloud platform: 30+ to date across the public sector (US/Canada), global financial services and insurance, education, healthcare, energy, and professional services verticals
• Provide delivery technical quality assurance and pre-sales technical expertise in agentic AI, Copilot extensibility, Teams application development, SharePoint Framework, and custom intranet applications, contributing to $3.6M of New Work Sold over 5 fiscal years
• Serve as a global subject matter expert for standard practices and training in Leading Edge Delivery, consumed by 1,200+ staff
• Own the IP for 3 reusable solutions within the Modern Work Employee Experience portfolio, delivered globally
• Present at internal conferences to audiences of 100+ attendees on custom development for the Microsoft 365 platform
• Mentor and coach early-in-career consultants and participate in hiring and screening of intern, full-time, and partner vendor resources for the ISD business

Client delivery highlights:

Earlier engagements (2018 - 2022):

• 2022: Professional services firm (US). As intranet portal design lead, guided envisioning and development of a transformative SharePoint Online and Viva Connections intranet for a company new to the Microsoft cloud, replacing a homegrown solution for 135K+ employees across a multi-geo tenant; also built M365 DSC and Azure DevOps CI/CD tenant configuration management to minimize drift across 4 tenants and 5 geographies
  TechSharePoint Online, Microsoft Viva, Power Apps, Power Automate, Microsoft 365 DSC, PowerShell, Azure DevOps, Azure AD
• 2022: State of California government agency (US). As lead assessment consultant, created an automated approach for analyzing Microsoft Access database applications that enriched SharePoint Migration Manager reporting and narrowed the transformation backlog from 3,600 databases to 81 (98% scope reduction), then delivered a first-mover Power Apps pilot as a reference architecture
  TechSharePoint Online, Microsoft Access, Power Platform
• 2022: Financial services & insurance company (US). As integration and development consultant, designed and deployed an Azure Functions integration streaming Exchange Online log data to Splunk for alerting and monitoring, removing a key blocker to the client's Exchange Online migration
  TechAzure Functions, Azure private link, Azure Blob Storage, Exchange Online, Splunk, PowerShell, Azure AD applications
• 2021, 2022: Private research university (US). As lead developer, led three offshore consultants across two workstreams building SharePoint security and permissions reporting tooling (scheduled PowerShell reporting plus real-time SPFx field customizer indicators) in a Microsoft 365 GCC High tenant, and advised on Azure private networking and IaC hardening
  TechSharePoint Online, SharePoint Framework, React.js, PowerShell, Microsoft Graph, Azure Storage, Azure App Service, ARM templates, Azure private link
• 2021: State of Oregon government agency (US). As lead consultant, led information architecture through deployment of a new SharePoint Online (GCC) intranet portal with a PnP-based site provisioning solution that cut time to stand up new sites by 50%
  TechSharePoint Online, site designs and site scripts, PnP provisioning templates, PowerShell
• 2021: Local government law enforcement agency (US). As assessment lead, delivered transformation guidance for 80+ InfoPath applications on SharePoint 2010 targeting Power Platform, SharePoint Online, and Azure PaaS, including farm-wide migration blocker analysis
  TechSharePoint Online, SharePoint 2010, InfoPath, Power Platform, Azure PaaS
• 2021: Financial services & insurance company (Latin America). As Power Platform implementation lead, guided a first-in-class Power Platform Center of Excellence rollout that aligned security governance with adoption while reducing low-code development costs
  TechPower Apps, Power Automate, Power BI, Dataverse
• 2020, 2021: US Federal government agency (US). As lead development consultant, led design and development of a modern intranet communications portal on SharePoint Online with custom SPFx web parts, Power BI usage telemetry, and Power Apps request automation, now used daily by ~10K employees; separately reduced content migration retry rate by 70% and cut migration time from 2 weeks to 3 days
  TechSharePoint Online, SharePoint Framework, React.js, Power Apps, Power Automate, Power BI, Application Insights, Metalogix Content Matrix
• 2019: Government agency (Latin America). As search application co-lead, developed an AI-powered crawling and content processing subsystem that enriched searchable metadata for documents indexed by SharePoint 2016 search as part of an intelligent search portal
  TechSharePoint 2016, Azure Functions, Cognitive Services, Azure Storage
• 2018, 2019: US Federal government agency (US). As delivery architect and technical lead, led multi-phase re-architecture of a provider-hosted SharePoint add-in for idea and project management that realized $10M in cost savings across multiple fiscal years and scaled to 60% more users
  TechSharePoint Online add-ins, ASP.NET, C#, Angular.js, SharePoint CSOM, PowerShell, Azure App Service
• 2018: Financial services & insurance company (US). As development consultant, re-wrote a custom SharePoint Search BCS crawling connector to reduce relevancy variability by 95%, and led a hybrid search strategy workstream identifying a path to 87% on-premises footprint cost reduction
  TechSharePoint 2013/2016/Online, SharePoint search, Business Connectivity Services

Served as a second level/advanced technical support associate for students, faculty, and staff in the McCombs School of Business; Directed an average of 20 support tickets per day to the correct teams and responded to support requests made by faculty and staff; Managed the department’s knowledge management system to improve understanding of technical operations; Developed process improvements using automated scripting in Windows-based PowerShell and Mac OS X AppleScript; Assisted with Active Directory remediation using Microsoft SQL Server

Former Teaching Assistant for MIS 374: Business Systems Development assisting Professor Clint Tuttle [Fall 2016]

Former Teaching Assistant for MIS 373: Mobile Apps and Web Services (formerly MIS 365: Data Communications) assisting Professor Joshua Rock [Spring 2016]

Developed course content for MIS 373, a survey course covering mobile applications, networking, and web services; Led an initiative to add new topics covering object-oriented Swift iOS development using an application-based learning method; Assisted students with concepts and exercises during office hours and graded assignments with an average turnaround of 0.46 days

Guided development of use cases and business functional requirements for payment functionality in a Force.com based system; Researched package solutions for integration with new system and created proof-of-concepts to ensure implementation feasibility; Owned formation of key client deliverables relating to the functional and technical design of the replacement to a legacy system

Facilitated project initiation by developing core project management deliverables for a custom Salesforce.com implementation; Created a comprehensive approach for implementing an externalized rules engine for a state Integrated Eligibility system; Engaged in defect validation, smoke test and pre-user acceptance testing for a new digital state Salesforce.com system

Worked on webpage improvement and development for new modules of the Trabajator online web applications using PHP/HTML; Created manuals for API integration with other organizations and generated audiovisual content to explain videos and tools; Led and directed a development team of 3 individuals in development of a Spanish-language based website for a white label client

Developed solutions for consumer and small business computer issues; Assisted with management of client accounts; Created invoices and processed payments for services rendered; Coordinated and trained a new intern for the firm’s high school internship program during the summer of 2013

Certified in basic, advanced, and health savings account tax return preparation to prepare and file returns at no cost for our low-income clients; Prepared over 53 unique tax returns, saving clients $14,363.00 in tax preparation fees and generating $91,869.14 in tax refunds

Developed a new PHP/MySQL-based website featuring database-driven web applications that facilitate more efficient chapter operations. The site uses the Bootstrap 3 CSS framework, HTML5, and a variety of APIs. Development was planned using a software development lifecycle with a "big bang" implementation method. Also audited, secured, and optimized a variety of chapter IT assets, and secured a sponsorship deal in exchange for virtual server hosting services, saving the chapter nearly $600 annually.

Selected as one of 83 students out of a pool of 1,500 applicants from the best universities spread out across the United States; Won first place out of 10 teams in the Building Bridges competition, comprised of team-building and project execution exercises; Improved and applied public speaking skills, communicational skills, strengths-based collaboration and project management; Gained valuable insight into the functions of Deloitte’s Audit, Tax Advisory, Financial Advisory Services and Consulting practices