John Sumaraga
Verified Expert in Engineering
Software Developer
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.
Portfolio
Experience
Availability
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
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.
Senior SharePoint Developer and Technical Lead
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.
Senior SharePoint Architect
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.
Senior Software Architect
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.
Software Engineer
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.
Solution Architect
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.
Senior .NET Developer
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.
President | CEO
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.
Senior Web Developer
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.
Experience
CalFresh Healthy Living | Automation Applications
http://calfresh.dss.ca.gov/healthyliving/state-planThe 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.
Skills
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
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring