20+
Years Delivered
Sustained enterprise delivery across architecture, engineering, support, and modernization programs.
Cloud Solution Architect - Microsoft
Robert F. Lopes
Cloud Architecture - SharePoint - Copilot - Enterprise Collaboration
I help organizations modernize collaboration, content management, automation, and cloud operations with a practical approach grounded in architecture, governance, user adoption, and execution. More than an online resume, this is where I share what I have learned over years of SharePoint migrations.
20+
Years of Experience
2018
Microsoft - Present
TS/SCI
Security Clearance
MBA
+ BS Computer Info Systems
Outcomes
Business Impact Highlights
9
Major Roles
Progressed from systems analyst to cloud solution architect across defense, aerospace, and enterprise domains.
TS/SCI
Security Posture
Trusted in mission-critical and classified environments with strong governance and compliance discipline.
1000+
Enterprise End Users
Architected and supported collaboration solutions designed for large user populations and operational continuity.
About
Professional Profile
Information Technology expert with more than 20 years of progressive hands-on experience covering application support, user maintenance, network planning, internet architecture, web design and development, SharePoint engineering, and cloud solution delivery.
Recognized for critical thinking, strong communication, team-oriented execution, and disciplined delivery. Brings business education, technical depth, and operational experience across enterprise and government environments.
Security & Mission Readiness
Active Department of Defense Top Secret Security Clearance (SCI)
Differentiators
Key Strengths
20+ years across enterprise IT, cloud solutions, SharePoint, applications, and infrastructure
Current Microsoft role centered on architecture guidance, customer advocacy, and solution delivery
Deep SharePoint background across engineering, architecture, development, governance, and modernization
Experience supporting defense, government, enterprise, and mission-critical environments
Career
Experience
2018 - Present
Cloud Solution Architect, Copilot and SharePoint
Microsoft
Provides customer-facing cloud solution support and architecture guidance for Microsoft business customers. Owns customer experience from issue identification through resolution across phone, web, and collaborative engineering channels.
Previous Roles
Senior IT Delivery and Engineering Roles
Career Progression from Analyst to Architect-Level Leadership
Owned high-visibility initiatives across support, engineering, and architecture functions, driving measurable improvements in service quality, process maturity, and execution speed. Consistently served as a trusted bridge between operations, engineering, and leadership to move complex programs from problem discovery to successful delivery.
Portfolio
Projects & Solution Themes
Architecture
Cloud & Collaboration Modernization
Modernized collaboration platforms and cloud service operations for enterprise Microsoft customers.
Problem
Fragmented collaboration workloads and complex support escalations slowed delivery.
Approach
Applied architecture triage, root-cause workflows, and cross-team engineering coordination.
Result
Improved customer issue-resolution speed and strengthened service adoption guidance.
SharePoint
Enterprise SharePoint Design
Led full-lifecycle SharePoint delivery from architecture through governance and production support.
Problem
Legacy portals lacked scalable governance, consistency, and maintainability.
Approach
Implemented structured site architecture, permissions strategy, deployment standards, and modernization patterns.
Result
Higher platform stability, better lifecycle control, and reduced operational rework.
Defense / Government
Secure Mission Environments
Supported secure collaboration solutions across classified and multi-network defense environments.
Problem
Operational requirements spanned isolated networks and strict security controls.
Approach
Delivered platform support and deployment practices aligned to mission operations and compliance boundaries.
Result
Reliable collaboration capability in sensitive environments with low operational disruption.
Platform Solutions
Automation & Business Solutions
Enabled workflow automation and productivity gains through modern Microsoft platform capabilities.
Problem
Manual routing and fragmented business apps created avoidable delays and errors.
Approach
Designed Power Platform-aligned solutions with repeatable process and governance patterns.
Result
Faster cycle times, clearer ownership, and more scalable operational workflows.
Credentials
Education & Certifications
Education
MBA - Master of Business Administration
Alvernia University
Bachelor of Science - Computer Information Systems
Alvernia University - Business Emphasis
Certifications
CompTIA Advanced Security Practitioner (CASP) 3.0
Microsoft Certified: Azure Fundamentals (AZ-900)
Microsoft Certified: Security, Compliance & Identity Fundamentals (SC-900)
Microsoft 365 Certified: Fundamentals (MS-900)
DoD Top Secret Security Clearance (SCI)
Service
Military Service
United States Army
B Battery 3/27 FA (MLRS) - Fort Bragg, NC
Veterans Preference
Honorable Discharge
Combat Veteran
MOS: 13P - Fire Direction Specialist for MLRS/LANCE Field Artillery Weapons System
Capabilities
Skills
Microsoft 365
Platform
95%
SharePoint Server & Online
Collaboration
98%
Cloud Architecture
Architecture
92%
AI Strategy & Copilot Enablement
AI
90%
Generative AI Solution Design
AI
88%
Responsible AI & Governance
AI
86%
Power Automate / Apps / Pages
Automation
88%
Security & Compliance
Security
90%
SQL Server / IIS / Active Directory
Infrastructure
86%
Application Development
Development
88%
Technical Leadership
Leadership
94%
HTML / CSS / JS / C# / XML / XSLT
Development
85%
Documentation & Delivery
Execution
95%
SharePoint Migration & Modernization
Migration
96%
PowerShell Automation & Reporting
Automation
93%
Incident Response & Root Cause Analysis
Operations
94%
Tenant Governance & Compliance Controls
Governance
91%
Identity & Access Management
Security
89%
Workflow Modernization & Process Redesign
Transformation
90%
Executive Reporting & Stakeholder Communication
Leadership
92%
Platform Operations & Reliability
Operations
90%
Tools
SharePoint Upgrade Scripts
These scripts are part of my SharePoint modernization toolkit. They are designed to be novice-friendly, read-only by default, and focused on producing actionable migration insights.
What
A structured toolkit of 40+ PowerShell scripts that assess SharePoint environments across planning, optimization, build readiness, migration risk, governance controls, and executive reporting.
How
Scripts are executed in a recommended run order, produce CSV-based outputs, and are designed as mostly read-only diagnostics so teams can baseline current state before remediation and migration activities.
Why
The goal is to reduce migration surprises, improve prioritization, and provide clear evidence for leadership decisions with repeatable, transparent, and audit-friendly reporting.
Typical engagement flow: establish baseline inventory first, reduce risk through targeted analysis, then drive migration waves with governance and executive reporting checkpoints.
Example Usage
How to run the scripts
Most of these scripts follow the same operating pattern: run against a single site collection when you want targeted analysis, or run against the full web application when you want broader inventory. The example below uses a site users report pattern, which individuals can adapt to other scripts with similar parameters.
Scan One Site Collection
PowerShell
Use this mode when you want to inspect one specific site collection in isolation.
.\Script_04_SiteUsers_Report.ps1
-WebAppUrl "https://sharepoint.contoso.com"
-SiteCollectionUrl "https://sharepoint.contoso.com/sites/HR"
-OutputCsv "C:\Temp\Site_Users_HR.csv"Scan Full Web Application
PowerShell
Use this mode when you want the script to enumerate all matching scope across the web application.
.\Script_04_SiteUsers_Report.ps1
-WebAppUrl "https://sharepoint.contoso.com"
-OutputCsv "C:\Temp\Site_Users_All.csv"
-NoPromptFor the Top 23 folder, first rename the file from .txt to .ps1 before running it. For the root toolkit, use the existing .ps1 files directly. Parameter names can vary by script, but this is the standard execution pattern users should expect.
Top 23 Useful Migration Scripts
Customer-ready shortlist
This focused script set gives customers a practical migration-readiness baseline across identity, content, dependencies, infrastructure, and blocker detection. Each script is designed to answer a specific planning, cleanup, or modernization question before major migration work begins. The files in the Top 23 folder should be treated as a separate collection from the root scripts folder and not as matching or interchangeable script numbers.
The files in the Top 23 folder are stored as .txt files for safe transfer.
Before running any of them, rename the file extension from .txt to .ps1.
These files are separate from the root toolkit scripts and should be evaluated on their own.
Single Site Use
Rename the file to .ps1, open it in SharePoint Management Shell or PowerShell, and set the target input to one site or web URL. This is the best approach for validating one problem area, one business site, or one migration candidate at a time.
Entire Site Collection Use
Rename the file to .ps1, then run it against the full site collection scope so the script can enumerate all child webs, libraries, users, permissions, and related configuration signals under that collection. Use this mode for complete discovery and migration baselining.
Expected Outcome
These scripts are intended to produce read-only inventory or risk outputs that support dependency mapping, cleanup decisions, rebuild vs retire planning, and executive-ready migration discussions.
End-to-End Coverage
Identity and access, content structure, workflow and versioning impact, customizations, platform services, infrastructure, and migration blockers are all represented in this shortlist.
What It Gives Customers
Full environment inventory, security clarity, dependency mapping, blocker identification, and a more defensible migration-readiness view before execution begins.
Decision Support
The reports help teams decide what to rebuild, what to remediate, what to retire, and where to focus remediation effort first.
Identity & Access Layer
Ownership, users, groups, and authentication baseline
01. Site Inventory Report
01. Site Inventory Report.txt -> rename to .ps1
Purpose: establish a high-level baseline of the target site or site collection before deeper analysis.
Captures
- Site or web URL
- Title and template
- Owner or admin context
- Structural baseline for follow-on scripts
03. Site Collection Admins Report
03. Site Collection Admins Report.txt -> rename to .ps1
Purpose: identify full-control ownership across site collections.
Captures
- Site collection URL
- Primary admin owner
- Secondary admin
- All site collection admins
- Total admin count and risk indicator
04. Site Users Report
04. Site Users Report.txt -> rename to .ps1
Purpose: inventory all users for identity cleanup and governance.
Captures
- User name, login, and email
- Site and web location
- Site admin flag
- Domain group flag
- Risk classification
05. Group Inventory Report
05. Group Inventory Report.txt -> rename to .ps1
Purpose: audit group-based access and permissions.
Captures
- Group name and owner
- Members and member count
- Permission levels
- High-privilege access indicators
- Risk classification
06. Permissions Audit Report
06. Permissions Audit Report.txt -> rename to .ps1
Purpose: baseline effective access and uncover broken inheritance or high-risk permissions.
Captures
- Permission scope by site, list, or library
- Users and groups with assigned roles
- Inheritance status
- Elevated access indicators
11. Orphan User Signal Report
11. Orphan User Signal Report.txt -> rename to .ps1
Purpose: identify stale, unresolved, or potentially invalid accounts that create cleanup risk.
Captures
- User identity signals
- Unresolved or disabled account indicators
- Known site or web context
- Cleanup and governance risk markers
21. Authentication Model Report
21. Authentication Model Report.txt -> rename to .ps1
Purpose: evaluate authentication readiness for modernization and modern auth alignment.
Captures
- Web application URL and zone
- Authentication type such as NTLM, Negotiate, or Claims
- SSL enabled or disabled
- Legacy vs modern risk classification
Content & Usage Layer
Scope, structure, usage, storage, and workflow signals
02. Storage Usage Report
02. Storage Usage Report.txt -> rename to .ps1
Purpose: evaluate storage consumption and likely migration footprint.
Captures
- Site collection size
- Database distribution
- Content growth indicators
- Storage-heavy migration risk signals
07. Lists and Libraries Inventory Report
07. Lists and Libraries Inventory Report.txt -> rename to .ps1
Purpose: identify content structure and usage patterns.
Captures
- List or library name
- Item count
- Last modified date
- Size indicators
08. Large Lists Report
08. Large Lists Report.txt -> rename to .ps1
Purpose: identify lists that exceed performance or migration thresholds.
Captures
- Lists above threshold such as 5,000 items
- Item counts
- Site location
- Risk classification
09. Workflow Inventory Report
09. Workflow Inventory Report.txt -> rename to .ps1
Purpose: identify workflows that may need rebuild, replacement, or retirement.
Captures
- Workflow name
- Type such as 2010, 2013, or custom
- Last run date
- Associated list or site
10. Versioning Audit Report
10. Versioning Audit Report.txt -> rename to .ps1
Purpose: assess versioning impact on storage use and migration size.
Captures
- Library name
- Versioning settings
- Version counts
- Estimated storage or migration impact
Dependency & Customization Layer
Features, custom actions, and platform dependency discovery
12. Feature Inventory Report
12. Feature Inventory Report.txt -> rename to .ps1
Purpose: identify feature dependencies that can affect migration or rebuild planning.
Captures
- Feature ID and name
- Scope such as site or web
- Custom vs out-of-the-box classification
- Risk classification
13. Custom Action Inventory Report
13. Custom Action Inventory Report.txt -> rename to .ps1
Purpose: identify UI and script-based customizations that may need replacement.
Captures
- ScriptLink, Ribbon, and JavaScript customizations
- Script sources such as ScriptSrc and ScriptBlock
- Location and registration details
- Risk classification
14. Search Health Report
14. Search Health Report.txt -> rename to .ps1
Purpose: validate search service readiness and crawl health before migration.
Captures
- Search service status
- Crawl freshness
- Last crawl timestamps
- Risk classification
Infrastructure & Platform Layer
Farm, web app, and certificate configuration baseline
15. Farm Inventory Report
15. Farm Inventory Report.txt -> rename to .ps1
Purpose: baseline farm-level health and structural configuration.
Captures
- Farm name and version
- Servers, roles, and status
- Service instances
16. Web Application Configuration Report
16. Web Application Configuration Report.txt -> rename to .ps1
Purpose: document web application configuration needed for rebuild and modernization planning.
Captures
- URL
- Port, SSL, and host header
- Application pool
- Managed paths
- Authentication settings
17. IIS Certificate Binding Report
17. IIS Certificate Binding Report.txt -> rename to .ps1
Purpose: validate SSL and certificate configuration across web bindings.
Captures
- Port and host header
- SSL enabled or disabled
- Certificate presence
- Risk classification
22. SharePoint Cumulative Updates Report
22. SharePoint Cumulative Updates Report.txt -> rename to .ps1
Purpose: audit the farm's patch level and identify servers running out-of-date CU builds.
Captures
- Server name and role
- Installed build number and mapped CU label
- Out-of-date status vs latest known CU
- Upgrade Ready / Not Ready export flag
Run
.\Script_22_SharePoint_CU_Report.ps1
-OutputCsv "C:\Temp\SharePoint_CU_Report.csv"23. SharePoint CU Install
23. SharePoint CU Install.txt -> rename to .ps1
Purpose: install a SharePoint Cumulative Update on a server using a controlled sequence with PSConfig to complete the upgrade.
Actions
- Applies CU patch from a specified location
- Runs PSConfig to finalise the upgrade
- Logs progress and errors to a specified path
- Run on each server individually as Admin
Run
.\Script_23_SharePoint_CU_Install.ps1
-CULocation "C:\Install\CU"
-LogPath "C:\Temp\CU_Install.log"Migration-Critical Layer
Final readiness, blocker, and dependency evidence
18. Content Database Inventory Report
18. Content Database Inventory Report.txt -> rename to .ps1
Purpose: validate content database readiness and surface attach or migration blockers.
Captures
- Database name and size
- Site collection count
- Feature dependencies
- Migration risk indicators
19. Service Application Inventory Report
19. Service Application Inventory Report.txt -> rename to .ps1
Purpose: identify the platform services that must be recreated, mapped, or validated post-migration.
Captures
- Service application name
- Type such as Search, MMS, or UPA
- Application pool
- Service account
- Endpoint presence and risk classification
20. Site Lock State Report
20. Site Lock State Report.txt -> rename to .ps1
Purpose: identify locked or restricted sites that could block migration execution.
Captures
- Site collection URL
- Lock state such as Unlock, ReadOnly, or NoAccess
- Storage or quota indicators
- Migration blocker classification
Original Root Toolkit Scripts
Independent master toolkit
The section below is the original root script kit. It is separate from the Top 23 folder above. Different filenames, different numbering, and different organization are expected here. Use the Top 23 pack when you want the curated customer script destination; use the root toolkit when you want the full broader script library and phased run-order experience.
Loading scripts...
Reach Out