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

John Sumaraga

Verified Expert  in Engineering

Software Developer

Location
Elk Grove, CA, United States
Toptal Member Since
December 2, 2020

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.

C#Visual StudioASP.NET MVCWindows PowerShellASP.NET Web APISharePoint 2013SharePoint APIMicrosoft Graph APISQL Server 2012SQL Server Reporting Services (SSRS)SharePoint 365MySQLSharePoint OnlineMicrosoft SQL ServerC#.NET

Portfolio

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

Experience

Visual Studio .NET - 20 yearsC# - 20 yearsMicrosoft SQL Server - 20 yearsSharePoint - 18 yearsASP.NET MVC - 10 yearsWindows PowerShell - 9 yearsSharePoint API - 7 yearsSharePoint 365 - 6 years

Availability

Part-time

Preferred Environment

REST, Web API, Azure, Microsoft SQL Server, SharePoint 365, SharePoint, C#, Visual Studio, Windows 10

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 Developer Technical Lead

2019 - PRESENT
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 application for budget approval, rejection, or modification. Used by a local and state implementing agencies. Additionally provides reporting federal, state and local agencies.
  • Created a system that allows for budget adjustments during the year and update 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, TypeScript, REST APIs, SharePoint Framework (SPFx), C#

Senior SharePoint Architect

2014 - PRESENT
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 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 and with no downtime.
  • Maintained a 99.99% uptime for all three production on-premise SharePoint environments for the last five years. Currently 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 2012, Governance, SharePoint Online, SharePoint 365, SharePoint API, Microsoft Power Apps, Microsoft Power BI, Microsoft Project Server, C#.NET, Visual Studio .NET, AvePoint, Metalogix, Windows PowerShell, Azure Active Directory B2C (ADB2C), Azure, Microsoft Teams, SharePoint 2013, Business Intelligence (BI), SQL Server Reporting Services (SSRS)

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 Graph API, Azure Functions, React, TypeScript, REST APIs, 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, ASP.NET Web API, Web API 2, Windows Presentation Foundation (WPF), Windows Server 2016, Windows Server 2012, IIS 8, Windows, Windows PowerShell, Visual Studio .NET, C#, Entity Framework Core, ASP.NET MVC, OData, MySQL, Windows Forms (WinForms), C#.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, Microsoft SQL Server, Windows Server, 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 2010, Entity, jQuery, Ajax, LINQ, Windows Server, WCF Web Services, MVC Razor, 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, Agile, Entity, jQuery, Ajax, IIS 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, Flash, ASP.NET, ASP, SharePoint, 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, VB, PL/SQL, Microsoft SQL Server, 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.

Languages

C#, JavaScript, TypeScript, C#.NET, VB, VBScript, XML, XSL, CSS, VB.NET, C++

Frameworks

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

Libraries/APIs

SharePoint API, Web API 2, Web API, REST APIs, React, Windows Forms (WinForms), jQuery, LINQ

Tools

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

Platforms

SharePoint 2013, SharePoint, Windows Server 2012, SharePoint 365, Azure Functions, Windows, Windows Server 2016, Azure, DotNetNuke (DNN), Microsoft, Windows Server, SharePoint 2010

Paradigms

REST, Azure DevOps, Business Intelligence (BI), Scrum, Agile

Storage

SQL Server Reporting Services (SSRS), MySQL, SQL Server 2012, Microsoft SQL Server, PL/SQL, IIS SQL Server

Other

Microsoft Graph API, OData, Microsoft Project Server, Governance, Office 365, Windows 10, IIS 8, Metalogix, AvePoint, SharePoint Online, COM, DCOM, ASP.NET MVC 2, WCF Web Services, Ajax, IIS 7