John Sumaraga, Developer in Elk Grove, CA, United States
John is available for hire
Hire John

John Sumaraga

Verified Expert  in Engineering

Bio

John is a versatile, results-driven tech leader with 20 years of leadership, program, and business operations experience. He has demonstrated expertise in designing, implementing, integrating business solutions, and directing mission-critical enterprise projects. John is a hands-on contributor in system analysis, process improvement, governance, compliance, cybersecurity, software development, network infrastructure administration, and knowledge of SharePoint solutions on-premise/cloud.

Portfolio

California Department of Corrections and Rehabilitation
IIS 8, SQL Server, Governance, SharePoint Development, SharePoint Development...
California Department of Social Services (DSS)
Azure DevOps, Azure Active Directory B2C (ADB2C), Microsoft Flow...
California Department of Consumer Affairs (DCA)
JavaScript, Azure Active Directory B2C (ADB2C), Microsoft Development...

Experience

Availability

Part-time

Preferred Environment

REST, Web API, Azure, Microsoft SQL Server, SharePoint, C#, Windows PowerShell, Microsoft 365, Microsoft Forms, Microsoft Power Platform

The most amazing...

...thing I've developed was a reverse logistics service-oriented system for Flextronics which grew to become a multimillion-dollar business line.

Work Experience

Senior SharePoint Architect

2014 - 2024
California Department of Corrections and Rehabilitation
  • Led the migration of SharePoint on-premise to SharePoint O365 for more than 60,000 users and 3,000 sites.
  • Managed the rollout of the Microsoft Teams strategy and implementation with SharePoint online for the department.
  • Migrated SharePoint 2010 to 2013 for more than 60,000 users and 3,000 sites with no downtime.
  • Maintained a 99.99% uptime for all three production on-premise SharePoint environments for the last five years. Currently, it is the second most critical application in the department.
  • Wrote, tested, and deployed several PowerShell scripts for disaster recovery and build automation, which ensured the recovery of three-terabyte production environments within a 2-hour window.
  • Architected and implemented all three environments, as well as the training of technical staff on SharePoint administration, automation, performance, and capacity planning.
  • Provided governance and technical leadership for CDCR with CCHCS. Developed custom solutions for the Division of Rehabilitative Programs (DRP) group and provided support for their existing environments.
  • Developed custom reports with SQL Reporting Services Integrated Mode and Business Intelligence Center.
Technologies: IIS 8, SQL Server, Governance, SharePoint Development, SharePoint Development, SharePoint Development, Microsoft Power Apps, Business Intelligence Development, Microsoft Project Server, .NET, Visual Studio .NET, AvePoint, Metalogix, Windows PowerShell, Azure Active Directory B2C (ADB2C), Azure, Microsoft Teams Development, SharePoint Development, Business Intelligence Development, SQL Server, SharePoint PnP

Senior SharePoint Developer and Technical Lead

2019 - 2021
California Department of Social Services (DSS)
  • Developed and supported the new budget submission and review app modernization from Excel to the web. The budget app uses rules to allow only qualified data to be entered, validated, and submitted.
  • Developed an application for budget approval, rejection, or modification used by local and state implementing agencies. It additionally provides reporting for federal, state, and local agencies.
  • Created a system that allows for budget adjustments during the year and updates budgets accordingly. Each budget is printable as an Excel document. The Excel report and SharePoint custom solution meet current ADA standards.
Technologies: Azure DevOps, Azure Active Directory B2C (ADB2C), Microsoft Flow, Azure Functions, React.js, TypeScript, REST API, SharePoint Framework (SPFx), C#

Senior SharePoint Architect

2018 - 2019
California Department of Consumer Affairs (DCA)
  • Responsible for the migration of the SharePoint 2010 on-premise environment to SharePoint Online. Developed the project and communication plan for the end-user community and built a system to provide label generation for the mailroom team.
  • Provided training and mentoring to technical staff on the SharePoint O365 tenant and Azure environment. Responsible for setting up and configuring tenants for the development of new SharePoint Framework web parts.
  • Developed the current iteration of the product with C#7.0 and implemented it with SharePoint Framework 1.7.x, REST API, TypeScript, React, Azure Functions, MS Graph API, and Azure AD.
  • Migrated 200+ SharePoint sites to SharePoint Online using ShareGate.
  • Managed department-wide communication and training to users.
Technologies: JavaScript, Azure Active Directory B2C (ADB2C), Microsoft Development, Azure Functions, React.js, TypeScript, REST API, SharePoint Framework (SPFx), C#

Senior Software Architect

2016 - 2018
Nuix
  • Developed new REST/OData Web APIs and client applications using WinForms, WPF, and modern web technologies.
  • Played a key role in structuring Visual Studio projects/solutions for managing the components of the application such as application/API logic, model objects, database migrations, and background applications.
  • Learned new technology stacks such as MySQL, Adaptive Threat (ATP), and behavior datasets/concepts, along with assisting in development with a full server installer MSI package, which required special serve/user licensing.
  • Created a software installer package for Windows Server 2012, IIS, and MySQL implementation for a software solution suite.
Technologies: JavaScript, Scrum Master Consulting, Web Development, Web API 2, Windows Presentation Foundation (WPF), Windows Development, Windows Server 2012, IIS 8, Windows Development, Windows PowerShell, Visual Studio .NET, C#, Entity Framework Core, ASP.NET MVC, OData, MySQL, Windows Development, .NET

Software Engineer

2012 - 2013
ManTech Cyber Solutions International
  • Developed and maintained a commercial enterprise software package to manage the deployment, monitoring, and maintenance of agent nodes. Also updated and maintained the agent codebase in C++.
  • Developed the architecture and patterns for future implementation of service-oriented architecture in future releases.
  • Developed patterns for unit tests for each tier of the application.
  • Worked under the project management methodology of Scrum/Agile.
Technologies: C++, IIS 7, IIS 8, Entity 4, Ajax, LINQ, SQL Server, Windows Development, WCF Web Services, ASP.NET, C#

Solution Architect

2011 - 2012
UC Davis Crocker Nuclear Laboratory
  • Developed a custom portal for the IMPROVE network reporting samples, lab operations, lab devices calibrations, and custom reports.
  • Built a custom Windows service for XRF devices to alert users if a problem occurs with the devices.
  • Created custom integration service with XRF devices and lab operations. This service automatically loads data for the tray to be analyzed and return analyzed results to the central portal solution via WCF.
  • Architected and implemented a physical tier split of the web, application, and database from an existing 2-tiered (web, database) solution to service-oriented architecture.
Technologies: SharePoint Development, Entity, jQuery, Ajax, LINQ, Windows Development, WCF Web Services, ASP.NET, ASP.NET MVC, ASP.NET, C#

Senior .NET Developer

2010 - 2011
Wells Fargo Insurance Services
  • Developed a custom portal for the Global Broker Network solution to facilitate collaboration between national and international brokers (for Wells Fargo insurance brokers and non-Wells Fargo insurance brokers and affiliates).
  • Re-architected and implemented a physical tier split of web, application, and database from an existing 2-tiered (web, database) solution to service-oriented architecture.
  • Developed patterns for unit tests for each tier of the application.
  • Worked in an Agile/Scrum environment on the above-mentioned projects.
Technologies: Scrum Master Consulting, Agile Development, Entity, jQuery, Ajax, SQL Server, WCF Web Services, ASP.NET MVC 2, VB.NET

President | CEO

2003 - 2011
Synnetix
  • Headed the development of all web projects including designing and supporting the web and database infrastructure for the company.
  • Led security and audit practices and developed security best practices and procedures for the web and database environment.
  • Gathered and defined project requirements, prepared system documentation and road maps, and worked with stakeholders to establish project milestones/timelines to ensure on-time delivery.
  • Established user acceptance and system testing guidelines and directed local and remote development teams on all software development initiatives.
  • Manage the web environment, including the administration of database servers, extranets, and internet sites.
  • Worked as a major contributor to application development and system integration using various Microsoft technologies.
  • Developed and launched several customer websites using SharePoint, DotNetNuke, ASP, ASP.NET, and Flash.
  • Built and tuned SQL Server clusters and load-balanced web and application servers.
  • Designed the overall look and feel of Intranet and various customer websites; also developed standards development practices and failover and disaster recovery plans.
  • Configured the firewall, routers, and switches for particular application infrastructures; also collaborated with the operations team to design and implement the hardware infrastructure.
Technologies: Microsoft Development, Flash, ASP.NET, Active Server Pages (ASP), SharePoint Design, DotNetNuke (DNN)

Senior Web Developer

1999 - 2004
Flextronics International
  • Headed the development of web-based enterprise application projects and supported the web infrastructure for international operations of 10 to 40,000 employees spanning 29 countries.
  • Gathered and defined project requirements, prepared system documentation and road maps, and worked with both local and global stakeholders to establish project milestones/timelines to ensure on time delivery.
  • Established user acceptance and system testing guidelines and directed local and remote development teams on all web initiatives.
  • Majorly contributed to application development and system integration using ASP, PL/SQL, VB, VBScript, XML, XSL, CSS, COM/DCOM, JavaScript, Flash, ASP.NET, and VB.NET.
  • Designed the overall look and feel of Intranet and various applications.
  • Developed and launched a web-based 5,000-user CRM system integrated with a 40,000-user employee directory system.
  • Built a web-based automated quarterly bonus system and UI supporting 1,000 users.
  • Worked as a member of the BizTalk implementation and design team; also designed and developed a BizTalk reporting tool.
  • Managed the web environment, including the administration of servers databases, Intranet, extranets, and Internet sites. Implemented and maintained high-availability and scalable hardware architecture for the corporate web environment.
  • Built SQL Server clusters and load-balanced web and application servers; also configured and tuned SQL and IIS servers.
Technologies: VB.NET, ASP.NET, DCOM, COM, CSS, XSL, XML, VBScript, Visual Basic, PL/SQL, SQL Server, Active Server Pages (ASP)

CalFresh Healthy Living | Automation Applications

http://calfresh.dss.ca.gov/healthyliving/state-plan
A suite of SharePoint Online hosted modern web applications—built in React and TypeScript—and are managed by the California Department of Social Services agency.

The applications are used by internal and external users throughout California and hosted in Microsoft 365 environment. Users originally managed their content using multiple Microsoft Word documents and Excel files, which proved problematic. The new applications have streamlined data entry using modern web forms and greatly increased user efficiency and reporting to the federal government.

Libraries/APIs

SharePoint Development, Web API 2, Web API, REST API, React.js, Windows Development, jQuery, LINQ

Tools

Visual Studio .NET, Microsoft Teams Development, Visual Studio Development, Microsoft Flow, Azure Active Directory B2C (ADB2C), Business Intelligence Development, Microsoft Power Apps, Flash

Languages

C#, JavaScript, TypeScript, .NET, Active Server Pages (ASP), Visual Basic, VBScript, XML, XSL, CSS, VB.NET, C++

Frameworks

ASP.NET MVC, Windows PowerShell, Web Development, Entity Framework Core, Windows Presentation Foundation (WPF), SharePoint Framework (SPFx), ASP.NET, ASP.NET MVC 2, Entity, Entity 4, ASP.NET

Platforms

SharePoint Development, SharePoint Design, Windows Server 2012, SharePoint Development, Azure Functions, Windows Development, Windows Development, Azure, DotNetNuke (DNN), Microsoft Development, Windows Development, SharePoint Development, Microsoft Power Platform

Paradigms

REST, Azure DevOps, Business Intelligence Development, Scrum Master Consulting, Agile Development

Storage

SQL Server, MySQL, SQL Server, SQL Server, PL/SQL, SQL Server

Other

Microsoft Development, OData, Microsoft Project Server, Governance, Office 365, Windows 10, IIS 8, Metalogix, AvePoint, SharePoint Development, COM, DCOM, WCF Web Services, Ajax, IIS 7, Microsoft 365, Microsoft Forms, SharePoint PnP

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring