SharePoint On-Premise Design and Implementation (Cinema Vendor)

Designed and implemented an intranet for one of the largest cinema chains in the world. With the concepts of content roll-up and audience targeting in mind, the intranet provided a medium where interest holders could share news and current events to only their intended audiences all through the same intranet front page. Companywide, key performance indicators such as attendance and per-cap were collated and surfaced by way of automated background tasks. Analytics about movie performance such as weekend box office grosses and an upcoming movie release schedule were gathered and presented automatically as well.

Migration to SharePoint Online (Cinema Vendor)
Migrated On-Premise SharePoint intranet to SharePoint Online in Microsoft 365. Taking a modern SharePoint approach and leveraging the SharePoint Framework (SPFx) development platform, the intranet featured a common navigation bar to be shared across all site collections where navigational elements could be targeted to individual audiences. The global navigation bar also contained a custom unified search box scoped for documents, people or cinemas.

Azure Application Proxy utilization (Cinema Vendor)
SQL Server Reporting Services (SSRS) is not provided in Azure for Platform as a Service. To work around this issue, it was necessary to present an on-premises SSRS report server in Azure utilizing the Azure Application Proxy. As a result, users were able to access both SharePoint Online and SSRS under the same authentication profile even if they were off premises. This allowed SSRS reports to be embedded seamlessly with-in a SharePoint Online site while keeping the report server and the corresponding data warehouse on-premises.

News Content Roll-up Application Development (Cinema Vendor)
Unfortunately, classic SharePoint content rollup is deprecated in SharePoint Online and furthermore, it does not work across site collections in which SharePoint Online is heavy siloed. To work around this issue, I designed custom news content types that could roll up across site collections by making use of SharePoint’s customizable search engine. Not only can search content be queried across site collections, searching also retrieves results from an indexed data set ensuring for a quick response when page load times are always a concern. However, one feature that is not present with the search engine is SharePoint’s concept of audiences. So, to accomplish audience targeting under this paradigm, a custom audience targeting strategy was required where audience targeting requirements were passed with the search query to affect the desired result filtering.

Calendar Events Roll-up Application Development (Cinema Vendor)
Implemented calendar events content rollup in SharePoint Online for a client-side web part. Like the news content rollup, the search engine was harnessed to provide calendar event surfacing to the front page of the intranet from a variety of child SharePoint site collections.

Node.js Development to synchronize On-Premise data (Cinema Vendor)
The initial adoption of the Microsoft 365 environment provides little data availability to On-Premise data endpoint. To Bridge this gap, it was necessary to implement recurring synchronization scripts utilizing Node.js to push and maintain data in Microsoft 365 where otherwise On-Premise data would be unavailable. These scripts are scheduled to run automatically without human intervention and would email the pertinent individuals if something unexpected happened. With this technique, it is possible to access current data from Active Directory, SQL server, SSRS as well as On-Premise SharePoint from within the Microsoft 365 environment. With the flexibility of Node.js, almost any source could be synced in this manner.