Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Frank Westmoreland

Bartlett,IL

Summary

To utilizes my experience and abilities as a SharePoint Architect to build Enterprise solutions under the Microsoft Power Platform in addition to creating complex SharePoint and Teams sites which provide a great Business need

Migration professional with background in managing complex migration initiatives and enhancing system efficiencies. Consistently ensures seamless transitions and effective integrations while focusing on team collaboration and achieving results. Known for adaptability and reliability in dynamic environments, with strong problem-solving and communication skills.

Experienced with leading intricate migration projects and optimizing system performance. Utilizes deep understanding of migration tools and techniques to ensure seamless transitions. Knowledge of team collaboration and troubleshooting ensures reliable and efficient outcomes.

Overview

24
24
years of professional experience
1
1
Certification

Work History

SharePoint Migration Specialist

Raytheon Government DOD GCC High
06.2023 - Current
  • Currently running Migration project. This entails moving various SharePoint Online versions from one tenant to a new Tenant. Currently we have migrated over 5,000 sites with the end goal of migrating over 35,000+ sites by the end of year.
  • Created new Modern Templates for Communication sites and Team sites for deployment utilizing PNP-power shell scripting.
  • The two main products in use are Avalon Fly where we can batch migrate hundreds of sites at a time and ShareGate which allows us to go back and migrate full sites or just content and document libraries and list.
  • I've written Powershell script to give us reports on all SharePoint site data such as whether the site has subsites, record count for each list and document libraries that run pre and post migrations so we can determine if the migration was successful.
  • Also create scripts to put banners at the top of the page for site that are opted in for migrations, so users are informed that their sites are being migrated.
  • Also performed Hypercare duties to reach out to users who were having problems with their site after migration. I created a power app ticketing system where users could create a ticket that would go to our support team for Hypercare resolution. The app was tied to a Power Automate flow which updated the user via email of any progress done on the ticket with a link back to the ticket.
  • Also worked on various power app applications such as a project tracker to keep track of all SharePoint projects.

SharePoint Architect

Heartland Alliance
01.2023 - 05.2024
  • Configure Ad Connect Sync to Azure and modified and added extended attributes to accommodate capturing additional fields for reporting purpose.
  • Wrote PowerShell scripts to pull in HR employee data to create local Active Directory users and mail boxes that sync to Azure AD.
  • Created Power Bi Dashboards of Active Directory users via an onboarding process which consisted of three power apps forms to capture New Employees, Re-hires, Contractors and Offboarding form for retired or terminated employees. These were Power apps forms tied to SharePoint list which invoked Power automate to send out notifications to various department and to export newly created list items to csv files to then be imported via PowerShell to create, disable, and move users to different groups and departments. These forms also triggered Power Automate approval process which facilitated sending out equipment request for IT and Training schedules for HR to onboard new users.
  • Created various request forms utilizing Microsoft forms which would then be attached to power automate flows to capture the field from the forms to create notifications and start the process of requesting projects approvals were also attached to the forms via Flows as well.
  • Created an Inventory Canvas Power app to facilitate department requesting office furniture. The app consisted of pre-loading images of office furniture inside the app as well as maintain inventory counts via SharePoint list thru Power automate trigger. This allow users to view the furniture and the height and length of the furniture and it allowed the users to select multiple furniture by mimicking repeating tables like info path.
  • Wrote various Power BI reports to track O365 license usage. Active Directory termination and creation reports.
  • Created Power Automate flows to retrieve ADP reports from FTP server to send email attachments and place files in file shares using the on-prim data Gateway.
  • Intranet Solution - Mimic Word press template to give internal solutions the look and feel of Modern web site by creating new templates along with images via the Adobe suite and Bootstrap, CSS, Html to provide custom look and feel.
  • Intranet solution - created document management systems by automating check-in and checkout work flow and approval processes for Word documents to allow customers to convert work documents to pdf while moving documents between secure document libraries.
  • Intranet solutions - Create hub site with top navigation to allow easy access to all departments. Implemented bing maps inside the calendar for meeting where it displays location. Also implement SPFx app that allow users to change language of the entire SharePoint site by clicking on a drop down menu option.

SharePoint Architect

MacLean-Fogg Company
02.2021 - 02.2023
  • Converted Excel Pivot table Report which pulled in data from various source to a Power BI Report. This consisted of configuring a Gateway to get at the SQL data that was being pulled in to excel. All excel formulas were re-written with Dax Queries and Measure formula to provide better performance and then embedded into a SharePoint page.
  • Migrated 100+ site from SharePoint 2013 to Office 365 using the Share Gate Software. This consisted of planning out merging some sites and making decisions on which sites would be communication sites or be created as Team sites. All content was converted to take advantage of the new O365 features. All info path forms and Designer Workflows were converted to Power Automate and standalone Canvas apps as needed or SharePoint integrated list forms.
  • Migrated all Info path forms to Power apps SharePoint integration forms. This involved recreating the forms form Info path in power apps to mimic all info path customizations and enhance the form where needed by adding power automate flows to the process.
  • Migrated all on-premise Designer workflow such as approvals, notifications to Power Automate.

Contractor

Cella Consultant Agency - Client Merck
10.2020 - 02.2021
  • Developed various front-end / JavaScript O365 web applications for Merck clients which consisted of deploying Vue Framework front-end web forms and customizing SharePoint list via and css stylesheets and editing, saving forms with JavaScript.
  • Trained users on how to add content to custom web parts built on O365 sites.
  • Create a Business process standalone Canvas Power app which consisted of Item level security via SharePoint Lists. Security was also provide by pulling in SharePoint Groups and List Categories based on r Business unit to redirect users to proper screens. This applications helped in gathering requirements for business processes and to enable several departments to then push the processes to Microsoft Project server once all the information was gathered was completed.

O365 Architect/Developer/Administrator

Prescient Solutions
03.2015 - 07.2020
  • Various migration from SharePoint 2007 - 2013, 2010- 2013, 2016 - 2019 - O365/SharePoint 2019.
  • Implemented and managed GCC O365 Tenants.
  • Manage, develop and provide administration in SharePoint 2007, 2010,2013, 2016,2019, SharePoint Online 0365.
  • Responsible for the design and development of a wide variety of business applications particularly web-based solutions and relational database design using MS-SQL Server 2000-2017. Technology focus is ASP.Net 2.0/3.0/3.5,4.7, Razor, LINQ, Entity Framework, WebServices, WCF, Workflow, and AJAX.
  • Custom UI Design, Infopath Forms, Workflows, SSRS Reporting, Jquery, Bootstrap, SharePoint apps and Web Parts.
  • Experience building custom apps using the new SharePoint Framework.
  • Utilizing Telerik Kendo-UI for Front-end UI development.
  • Utilizing DevExpress components for Front-end UI development.
  • Re-building Custom SharePoint applications that make calls via webservices to SQL-Backend.
  • Used DevExpress components (ie Grids and forms) embedded Into SharePoint Web Parts.
  • Migrating active directory users to external forms-based authentication to allow both internal and external users to access SharePoint custom applications.
  • Migrated current client from Exchange 2010 to Office 365 Suite and Exchange online.
  • Coded sync api between a .Net custom solutions to a vender API via C#, .Net core, ASP.NET MVC Razor, and Jquery.
  • Responsible for development environment and all production systems (ie Asset tracks, Salamander Live, and various other legacy systems.
  • Created Power BI Dashboards embedded in SharePoint.
  • Convert SharePoint 2010 Workflows to Power Automate.
  • Implement Power app forms to SharePoint List.
  • Implement Power App Gateway.

Senior SharePoint Developer

Inte Q
03.2014 - 03.2015
  • Converted Asp.net Client application into various Web Parts under SharePoint 2013.
  • Install and maintain SharePoint Farms 2010/2013.
  • Wrote custom Web Parts under 2013 that serve up data thru WCF services. Using JQuery to hide and show Web parts.
  • Heavily utilized Dev Express components for various Grids, Panels, and UI for Web Parts.
  • Created SharePoint Master Pages using third party tools.
  • Created application pages using HTML5/CSS3/JQuery.
  • Create custom editor Web part which allows customer to change the way the Web Part works by providing Security restrictions, showing and hiding fields.
  • Wrote SSRS Web Parts to display BI Dashboards and reports.
  • Worked with QA/UAT to gather requirements and writing test scripts.

SharePoint Architect

Draper and Kramer Inc
09.2011 - 02.2014
  • Co-wrote and maintain Commercial Mortgage application which consisted of custom workflows written in Visuals Studio to create an approval system which allow brokers to submit deals to SharePoint. This system also save parts of the SharePoint lists to a SQL backend via custom event receivers for additional reporting utilizing SSRS and Access.
  • Wrote a schedule PowerShell script to pull active Exchange mail box users to a csv file which than was picked up by a custom .net program that ftp the first, Last name and other info to our ecommerce site in the cloud.
  • Wrote custom one-click .net widows form application to read in Bank Lockbox records and parse out and export data to proper format for our Yardi systems.
  • Non-SharePoint related - created Residential and Condo Statements using the Yardi system. This entail using a word template with fields and writing SQL tokens to format the statements.
  • Wrote custom data entry forms using Telerik Kendo UI and to write captured data back to SharePoint List.
  • In charge of all SharePoint infrastructures and development. Including maintenance of all development and production SharePoint Farms and custom SharePoint Application development.
  • Built and maintain 80+ Condo SharePoint sites that provide residential information as well as the ability to opt-in / out to receive online Rent statements that are rendering via SSRS reports in SharePoint. The sites also utilize FBA registration and full administration of user for the onsite property manager.
  • Migrated our Yardi Systems Crystal reports to SSRS Reports and embedded them in to our SharePoint Environment via web parts and dashboards.
  • Launched and maintain Portal for Lombard, IL offices… created various workflows and did custom branding of SharePoint Portal.
  • Launch Chicago office internal portal. In the process of gathering requirements for each department as well as development custom content types to make available for SharePoint Search engines.
  • Corporate portal consist of custom Conference room Scheduler using Telerik controls and a custom Time Off request system that utilizes InfoPath forms and Excel Services to calculate employee holidays and remaining time off via a custom written Workflow.
  • Corporate portal also consist of custom tabbed web part to display department calendars and SSRS web parts that display SharePoint lists and external SQL data as dashboards.
  • Branded corporate Website creating custom master page layouts with CSS utilizing XSLT allowing for multiple tab drop downs.
  • Heading process to migrate Exchange 2003 public folders to SharePoint 2010 utilizing ShareGate product.

SharePoint Developer Consultant

Aspect Software
09.2010 - 09.2011
  • Creating Custom HR SharePoint Site Currently working on custom HR External /Internal Site for Client running on SharePoint Team Foundation Server. In the gathering requirement / design phase.
  • Created custom Site Definition site for client using custom page layouts which utilizes Infragistics Grids that access external SQL tables. Created custom List and custom Security logic for Web Parts. Wrote all store procedures for data access and used Linq to SQL to call all store procs and views.
  • WSS V3 to SharePoint 2010 Foundation Migration Pilot Created processes and documentation for migrating client existing WSS V2 environment to SharePoint 2010 Foundation. This included testing, deploying custom web parts and re-writing web parts where needed. Wrote automated PowerShell script to aid in the migration process.
  • Developed SharePoint 2010 Client Extranet Installed SharePoint 2010 Server and SQL 2008 server on client site. Developed site definition for external hosting site with custom document type, List and SSRS reporting web parts. Also created custom Master Pages and custom content management web parts.
  • Converted WSS V3 Info path driven SharePoint App to pure ASP.NET Application Due to constrain in Info Path…i.e. (forms with over 900 fields) the application had to be converted to a pure asp.net application. This consisted of re-writing existing custom Telerik web parts components as an asp.net application. An external product call Info Jet was integrated in to application to allow all data to be saved to a backend SQL database. All code was re-written to simulate the SharePoint app.
  • Converted Fox Pro Reports to SSRS Report / VB.Net Web Application. Fox pro Banking application was converting to VB.Net application. Over 100 reports were re-written in SQL SSRS report Writer and then tied to a VB.Net Web application.
  • Created custom SharePoint 2010 App for External Client. Consisted of creating custom aspx Layout pages with embedded Infragistics controls grid to allow custom drop down lookups and In-line editing. Customized look and feel of SharePoint site using custom definitions and Templates (onet.xml, webtemp.xml, schema.xml). Design and implemented Data view Web Parts. Configured document libraries and created custom views.
  • Created SharePoint Demo site to showcase customer Solutions. Created SharePoint demo Site to showcase the SharePoint features such as… Configure Performance Point and build KPI against a data cube. Configure Power Pivot for SharePoint and attached Excel Spreadsheets which connected to backend SQL Data sources. Configured User Profile Services to show HR & employee profile Silverlight app that shows the HR org chart and features. Enable all tagging and taxonomy features. Create custom YouTube Web parts to display videos on the site. Enable Storage BLOB feature so clients could see how attachment could be store in SharePoint but saved to the file system. Installed Nintex a third party work flow production and created two workflow demos. Installed NewsGator third party component that enhances the social features of SharePoint.

Senior Developer

Arthur J. Gallagher
11.2001 - 06.2010
  • Develop Document Management system in Moss 2007. Created 50+ branch sites using custom template for document management system. Created custom workflow web part in C# for task management and email alerts. Created indexing application that allowed users to scan documents into SharePoint. Created web services to allow Lotus Notes & Outlook to send emails into SharePoint. Also created lotus script code that would call the web services to convert the Lotus Notes mail object into an email and then forward to SharePoint. Created Microsoft office add-in to all entire suites to save to SharePoint. Created custom grids using third-party components inside embedded web parts. Created various custom event receivers in C# to handle the document libraries for approvals, rejections. Involved in all functional testing, design and code review.
  • Create C# utilities to convert simple Lotus Note databases to SharePoint List. Created utilities to update active directory with Lotus Note address book content.
  • Create external Satellite Sites in SharePoint for external customers. External customized SharePoint sites were created to allow users to Login and input data. Customized look and feel for each site. Create single level document approval workflow in SharePoint. Create administrator web parts in ASP.net to allow administrator to manage permissions of the sites. Create role based web parts.
  • Installed and Deploy Team Foundation Server Install version 2005 of Team foundation server… then migrated it to 2008.
  • Developed Web-Base property Management system. Developed property management system using ASP.net 2.0 and SQL 2005 using ColdFusion report builder for reporting. This was a customer facing website that applied complex property calculation for our clients. Was lead Programmer on this project and design, documented and implement a managed two other programmers.
  • Develop and maintain Lotus Notes / Lotus Domino Applications. Supported and maintain hundreds of Lotus Notes and Domino web applications. Help move these applications to SharePoint Platform.

Education

Programming Certificate -

School of Computer Technology
09.1980

Skills

  • Proficient in ASPNET
  • MVC Razor
  • AJAX integration
  • CSS
  • HTML/XHTML
  • Proficient in HTML5
  • Java
  • Skilled in JavaScript programming
  • JQuery
  • PowerShell command scripting
  • Database querying
  • XML/XSL
  • Telerik Controls
  • SharePoint 2007 expertise
  • SharePoint development expertise
  • 2016
  • 2019
  • Expertise in O365 applications
  • SQL Server proficiency
  • Experience with Power Apps and Flow
  • Net core 60
  • Proficient in Power BI Desktop
  • Team Foundation Server (2005-2013)
  • Skilled in Visual Studio development
  • SQL Server Integration Services
  • Report development using SSRS
  • Crystal Reports
  • LINQ integration techniques
  • Active Directory administration
  • Experience with Lotus Notes versions 20 to 90
  • Adobe Cold Fusion
  • Adobe Flex
  • Adobe Dreamweaver
  • Experienced in Adobe Photoshop
  • Eclipse IDE
  • Proficient in MS Office Suite
  • Dev Express Controls
  • WCF Storm
  • Experience with Bootstrap development
  • Experienced with Angular framework
  • Kendo UI
  • Experience with SharePoint Framework
  • PowerShell scripting
  • SharePoint development
  • Experience with Entity Framework
  • Salamander Live
  • Experience with Azure cloud solutions
  • Windows Server administration
  • Expertise in Power Apps and Power Automate
  • Development and operations
  • Post Man
  • Magic xpi
  • Ivanti Systems
  • Experience with desktop automation tools
  • InTune
  • Efficient application migration management
  • Training facilitation
  • Business requirements analysis
  • Network engineering
  • Full-stack software development
  • Data consolidation
  • Cloud migration execution
  • Analytical problem-solving
  • Detail-oriented approach
  • Proficient in handling multiple tasks
  • Trustworthy execution
  • Effective written communication

Certification

IBM Certified Lotus Notes Developer/ Administrator

Timeline

SharePoint Migration Specialist

Raytheon Government DOD GCC High
06.2023 - Current

SharePoint Architect

Heartland Alliance
01.2023 - 05.2024

SharePoint Architect

MacLean-Fogg Company
02.2021 - 02.2023

Contractor

Cella Consultant Agency - Client Merck
10.2020 - 02.2021

O365 Architect/Developer/Administrator

Prescient Solutions
03.2015 - 07.2020

Senior SharePoint Developer

Inte Q
03.2014 - 03.2015

SharePoint Architect

Draper and Kramer Inc
09.2011 - 02.2014

SharePoint Developer Consultant

Aspect Software
09.2010 - 09.2011

Senior Developer

Arthur J. Gallagher
11.2001 - 06.2010

Programming Certificate -

School of Computer Technology
Frank Westmoreland