Post Job Free

Resume

Sign in

Sr Sharepoint Consultant

Location:
Toronto, ON, Canada
Posted:
April 12, 2024

Contact this candidate

Resume:

Luis Pedro Del Pozo

*** ******* **

Toronto, ON.

M5T1S2

647-***-****

ad4yn5@r.postjobfree.com

objective

To successfully apply my Sharepoint and Microsoft stack knowledge with a dynamic and innovative employer.

Profile

20+ years in Sharepoint architecture and development in various lines of business

20+ years’ experience in web/content development and management

BSc. (Biochemistry), MCAD (.NET) MCSE and MCAD

Sharepoint architecture and development in various lines of business

Over 12 years architecting, administering and developing sharepoint solutions for enterprise clients in the private and public sector.

skills

Environment

MS Stack, Azure, Sharepoint, Dynamics, PowerFamily. M365, InTune

Relational databases

Microsoft Access MS SQL Server; Oracle ; MySQL; PostGre SQL, DB2

Project Management

MS Project ; MS Visio, PMLC, SDLC

Web Servers

Microsoft IIS; Apache; Websphere

Programming

ASP.NET, Powershell, Javascript and libraries (jquery, react, Angular and bootstrap. Powerfamily PHP/Drupal

Software

MS Visual Studio, MS Visual code, Dreamweaver, PowerApps, Power automate, powerBI, SQL SSRS/SSIS/SSAS, Avepoint, Metalogix, Sharegate

Experience

De Havilland, Toronto ON Jan 2021– Current

Lead Azure- Business Intelligence / M365/Sharepoint Solution Architect

A change in the business between Bombardier and DeHavilland created the opportunity to help build out an Azure portal for DeHavilland. The portal would provide access to on prem applications, a new part procurement application, business functional modeling, business event modeling, business process mapping Authorization and authentication via Azure B2C, Dynamics on prem to Dynamics Online, powershell and the filling of gaps (SSO in MS and not IBM)Azure duties various clients including Installation, configuration and launch of their Azure B2C farm as well as related applications (Teams and its apps creation of lists, ECT from SQL, power automate workflows, .net application creation of data models and development of PowerBI, Microstrategy and SSRS dashboards (daily work, maps of work locations and specifics) PowerApps Forms, CDS, migration of .NET apps to Azure DevOps and administration, gateway for on prem services, InTune duties. 0365 compliance and security was configured (information protection, data governance and ediscovery), Deliverables were Purview development and configuration. Requirements, business process, information Architecture and solution architecture documents

Technology used: MS Azure (farm), MS Office 2013, Sharepoint 2013, Office 365 including SPFX,Teams (installation and configuration) and Dynamics, InTune, MS IAM Flow and Center of Excellence, AD/AzureAD, PowerApps, PowerAutomate CDS, PowerBI, MS SQL 2016 R2, SSRS, ASP.NET, C# Windows 2012 R2, Infopath 2013, Powershell,, PowerGUI, Visual Studio 2017, IIS, Adobe Photoshop and HTML/CSS/Javascript (including Jquery, Typescript/ecma script, D3) Jira for ticketing and Confluence/Teams for collaboration

Reamined, Toronto ON. March 2020– August 2020

Lead Sharepoint- Business Intelligence / M365 Solution Architect

Sharepoint 2019 SME duties various clients including Installation, configuration and launch of their sharepoint farm as well as related applications (Teams and its apps creation of lists, ECT from SQL, .net application creation of data models and development of PowerBI and SSRS dashboards (daily work, maps of work locations and specifics) PowerApps Forms, PowerAutomate workflowsCDS, migration of .NET apps to Azure DevOps and administration duties. Lastly 0365 compliance and security was configured (information protection, governance and ediscovery), Eight weeks of support and customizations/enhancements was included . Cloud infrastructure was designed using Web Apps, Service Fabric, Microsoft Power Platform, Virtual Machines and InTune. . M365 and Azure compliance and security was configured (information protection, data governance and ediscovery), Purview development and configuration

Technology used: MS Sharepoint 2019 (farm), MS Office 2013, Office 365 including SPFX,Teams (installation and configuration) and Dynamics, MS IAM Flow and Center of Excellence, InTune, AD/AzureAD, PowerApps, PowerAutomate CDS, PowerBI, MS SQL 2016 R2, SSRS, Windows 2012 R2, Infopath 2013, Powershell,, PowerGUI, Visual Studio 2017, ASP.NET, C# IIS, Jira for ticketing and Confluence/Teams for collaboration

Adobe Photoshop and HTML/CSS/Javascript (including Jquery, Typescript/ecma script, D3)

KPMG, Toronto ON. Sept 2019 – Feb 2020

Sharepoint / M365 Solution Architect

Sharepoint 2013 SME duties various clients including creation of three tracking applications in Sharepoint 2013 for their global forecasts. Lists, External Content types, workflows, customized infopath and PowerAppps forms, PowerAutomate workflows, data governance and document repositories for Global intake and chosen to the KPMG Centre of Excellence for Microsoft technologies.. Created o365 architecture, configurations and customizations for later migration, Purview development and configuration Development of PowerBI reports for regional managers as well as support to the administrators of the application and end users

Technology used: Win 2019 Server, AD, ADFS, SMS Sharepoint 2013 (farm and sandbox), MS Office 2013, Office 365 including CRM online,AD/AzureAD, JSON, PnP, CI/CD pipelines, MS IAM PowerApps, PowerAutomate CDS, PowerBI, Windows 2008 R2, Infopath 2013, Powershell, Power Apps, PowerGUI, Visual Studio 2017, IIS, Adobe Photoshop and HTML/CSS/Javascript (including Jquery, Typescript/ecma script, D3) and agile. Jira

Softlanding, Vancouver ON November 2018 – June 2019

Lead Sharepoint/ M365 Solution Architect

Sharepoint 2013 SME duties various clients including Bell (upgrade from 2010 to 2016), Teck mining ( Patterns and Practices, Change management from Skype for Business to MS Teams with Adoption best practices), Neptune terminals (external data consolidation, Proof of Concept Teams/ One Drive configuration and launch) and Prospera Credit Union (POC for on premises migration to 0365, Purview development and configuration InTune, Powershell, PowerApps, PowerAutomate workflows Graph and 0365 APIs, security workflows, data governance, requirements gathering, documentation, technical design, development, Azure DevOps, PowerBI and provisioning, completion and o365 compliance set up fpr data governance .and infrastructure DNS, Firewalls, Virtual Networks, Load Balancers, Application Gateways Support and training were offered to new users and managers

Technology used: MS Sharepoint 2013 (farm and sandbox), MS Office 2013, COM, Office 365 ( including Dynamics CRM online), MS Threat Modelling tool, .NET forms, Infpoath forms, JSON SPFXTeams install and config,, Flow, PowerApps, PowerAutomate CDS, PowerBI and CoE, AD/AzureAD, MS Dynamics, Nintex Forms and workflows MS IAM. CI/CD pipelines MS SQL 2012 R2, Windows 2008 R2, Infopath forms 2013, Powershell, PowerApp Forms, CDS, Visual Studio 2017, ASP.NET, C#, IIS, Adobe Photoshop and HTML/CSS/Javascript (including Jquery, Typescript/ecma script, D3) Drupal updates and configuration Agile teams Jira and Confluence

Kinectrics (Ontario Power Generation), Toronto,ON. Sept 2016 – Sept. 2018

Lead Sharepoint Consultant

Acted as an SME for sharepoint 2013 for their intranet, infopath, workflows and Project Management Site Application for Kinectrics phase one launch of sharepoint. Eight existing word documents were translated into infopath (w/ content types and lists/libraries) and business processes were examined, flow charts created and workflows for the Project management template were developed, tested, trouble-shooted and implemented for HR and Finance. A PM site application was developed for project managers to create their own sites (w/ SAP integration) and manage documents with metadata, deliverables and resources. Managed offshore resources (Bulgaria) for development for infopath for Microsoft within the project management application as well as managing data governance and its processes. An adoption plan was put in place to endure the engineers are using the new applications. This includes requirements gathering, conferencing with the resources to explain needs, documenting, reviewing and solutioning with the resources. Sharepoint online was configured to for web content management to offer out of network users access to the same. MS Teams was configured and launched in order to replace Lync with an adoption policy as well as a microsite for proof of concept. Lastly training and support for the applications was completed

Technology used: MS Sharepoint 2013 (farm and sandbox), MS Office 2013, Office 365, PowerApps, MS IAM, Teams,Lync, Skype for Business, AD/AzureAD, JSON MS SQL 2012 R2, Windows 2008 R2, Infopath 2013, Powershell, PowerGUI, Visual Studio 2012, ASP.NET, C#, IIS, Adobe Photoshop and HTML/CSS/Javascript (including Jquery) and agile

Narcom Toronto,ON. June 2016 – Aug 2017

Solution Architect

Acted as an SME for ASP.NET development for a telecommunication company voice over IP application. It consisted of a dialer, database and php application to track all correspondence. All actions were linked to an open source voip application developed by another developer. Everything was embedded in as an app in sharepoint 2013.

Technology used: MS Sharepoint 2013, MS Office 2013, MS SQL 2012 R2, Windows 2008 R2, php, IIS, Powershell, PowerGUI, Visual Studio 2012, IIS, Adobe Photoshop and HTML/CSS/Javascript (including Jquery)

Public Health Ontario, Toronto,ON. Nov 2015 – May 2016

Sharepoint and M365 Consultant

Public Health Ontario, a government agency for disease prevention and control, requested a resource for administration/architecture/development of Sharepoint 2010 Enterprise farm, troubleshooting performance and application issues, development of workflows, infopath forms, libraries and lists, layouts, masterpages, web, record and document management w/ metadata and custom development. Some development was done by offshore resources (India) which needed to be managed, code and work was reviewed, implemented and deployed. This also included installing the proper sharepoint build and updates to all sharepoint and sql servers. Any new services/applications were developed as web services (REST). Creation of Development and Staging environments for Proofs of concepts

-Office 365 was evaluated for the public facing website and a proposal roadmap/POC (technical blue print for production) was created and submitted to management. Powershell and VBscript were used for site, site collection and farm code development

My contract ended before decision was made. Lastly MS Dynamics onsite integration with Sharepoint 2010, creation of ETL process via API for dashboard reporting, a rebrand of Dynamics and Sharepoint and report creation and scheduling as well as Purview development and configuration

Technology used: Win 2008 AD, AD/ADFS, MS Sharepoint 2010 (farm, Central Administratino and sandbox), Drupal/PHP MS Dynamics. MS Office 2010, MS SQL 2008 R2, Windows 2008 R2, Infopath 2010, Powershell, VBScript, Visual Studio 2012, IIS, Adobe Photoshop and HTML/CSS/Javascript (including Jquery) and Agile

SmartReit, Vaughan,ON. June 2015 – October 2015

Sharepoint Architect

SmartReit, a real estate investment firm, requested a resource for the extension/ installation and configuration of Excel services, Performance Point services, SSIS/SSRS/SSAS services, web services and Workflow Manager in their development, QA and production environments. This also included installing the proper sharepoint build and updates to all sharepoint and sql servers. All work was documented in detail and submitted as a development report to the client. End user training was provided for the staff as in class instruction. Lastly, a public facing office 365 sharepoint site was created, branded and launched

Technology used: MS Office 2013, Office 365, COM MS Dynamics ADFS MS SQL 2012 R2, Windows 2012 R2, Infopath 2013, Powershell, Visual Studio 2012, IIS, Adobe Photoshop and HTML/CSS/Javascript (including Jquery) and Outlook

Sigma Systems, Toronto,ON. July 2014 – May, 2015

Sharepoint and Office 365 Architect

Sigma, a telecommunications software company requested a migration of on premise SP2010 to SP Online/365 (content structure and business logic) as well as new CRM functionality (Dynamics)branding implementation and deployment (master pages/layouts and splash pages) and Irecord /document management changes. Project included business requirements gathering and development, a solution proposal, governance document, technical architecture, development, web content management, testing and deployment, The migration was completed. Also a MS Dynamics upgrade and migration was completed as well as sharepoint integration and UI customization.

Technology used: Sharepoint 2010, MS Dynamics, Delve and CRM, Office 365 including Sharepoint online and Dynamics, JSON,COM Sharegate Migration Tool, MS SQL 2008 R2, Windows 2008 R2, MS SQL Business Intelligence Studio, Powershell, SQL Server Management Studio, Visual Studio 2010, IIS, Adobe Photoshop, HTML/CSS/Javascript (including Jquery) and Dreamweaver

Cancer Care Ontario, Toronto,ON. Dec 2013 – May 2014

Sharepoint Administrator Developer

CCO’s, an Ontario government agency in charge of Cancer research, Access To Care department’s needs consisted of creating and deploying a Request for Training application and Wiki, a Risk Issue Tracking Application Proof of Concept and QA Workflow and Task Manager Application, all sharepoint 2010/2013.NET based web service applications. Applied a new brand (4 new content classes) to the public facing site managed by OpenText CMS.All projects included requirements gathering, solution proposal, governance document, technical architecture, development, web content management, testing and deployment. Lastly a MS Dynamics was installed and configured with appropriate documentation.

Technology used: MS Sharepoint 2010/2013 (sandbox and farm), Nintex Workflows, MS SQL 2008 R2, Infopath2013, Windows 2008 R2, MS SQL Business Intelligence Studio, Powershell, SQL Server Management Studio, Visual Studio 2010, IIS, Adobe Photoshop, HTML/CSS/Javascript (including Jquery), and Dreamweaver

LCBO, Toronto,ON. Sept. 2012 – July 2013

Sharepoint Architect/SQL Reporting Analyst

The LCBO requested a SP2010 migration to SP2013 and roadmap, technical solution architecture, governance model, document management solution, taxonomy and Business Intelligence site for their phase one deployment of SP2010 while keeping Microsoft’s best practices as a guideline. The Supply Chain (the Metrics and Analysis team) are responsible for creating high impact reports for executives and upper management. These reports were developed using SSAS (SQL cubes), SSIS, SSRS, Pivot Tables, Performance Point Dashboards, Sharepoint Excel Services and Sharepoint Business Intelligence reporting. A Governance model with security and permissions guidelines was delivered as a document

Technology used: MS Sharepoint 2010, MS SQL 2008 R2, Infopath 2013 K2 Workflow, MS SQL Business Intelligence Studio, SQL Server Management Studio, Powershell, Win2008R2, SSRS, SSAS, SSIS, Visual Studio 2010, IIS, Adobe Photoshop, HTML/CSS/Javascript (including Jquery), and Dreamweaver

Infusion, Toronto,ON Oct 2011 – Aug. 2012.

Sharepoint Architect

Toronto Police Services requested a roadmap assessment for the consolidation of existing stand alone websites into Sharepoint 2010 as well as their intranet and public facing sites. Recommendations were made for infrastructure, and applications.

Also, an oil and gas company. Invitria in Calgary was engaged for a rebrand deployment of their existing 13 companies under a public facing site (new splash page for each company) that integrated and migrated three existing .NET applications. SP2010 sites and Open Text/Vignette CMS (via their AGA product). A BRD, Governance and technical solutions document were created as well as development of the site. Sharepoint 2010 development of new intranet sites, content, structure, permissions, workflows, documentation, master pages, MS SQL 2008 (reporting), analysis, web content management and governance documentation for CCS was completed..

Technology used: MS Project MS Sharepoint 2010/Designer 2010, MS SQL 2008, Windows 2008 R2, Powershell, SSRS, SSAS, SSIS, IIS, Vignette, Adobe Photoshop, HTML/CSS/Javascript (including Jquery), and Dreamweaver

Dell Professional Services, Toronto,ON. August 2011 – Oct 2011.

Sharepoint Architect/Engineer

The COTB requested a roadmap assessment for the migration 64 Lotus Notes Applications to a newly branded Sharepoint 2010 site collection as well as their intranet (sharepoint 2007), file shares and public facing sites. The Quest Tool for migrating Lotus notes to SP 2010 and SP2007 to SP2010 was used to expedite the migration. Sharepoint MOSS 2010 development of new intranet sites, content, structure, permissions, workflows, documentation, master pages, web content management MS SQL 2008 (reporting), analysis and documentation for the City of Thunder Bay. A

Technology used: MS Project MS Sharepoint 2010/Designer 2010, Nintex Workflows Powershell, MS SQL 2008, Windows 2008 R2, SSRS, SSIS, SSAS, IIS, Adobe Photoshop, HTML/CSS/Javascript (including Jquery), and Dreamweaver

RGA Insurance, Toronto,ON. Sept. 2010 – August 2011

Sharepoint Administrator/Developer

Updating the Sharepoint Intranet site using Sharepoint MOSS 2010 (new sites, content, structure, permissions, workflows documentation master pages, MS SQL 2008 (reporting),PMLC, analysis and documentation,

The project was a refresh of look and feel with two new web parts.

Creation of HTML/CSS/Javascript from PSDs for new look and feel

Integration of HTML into master pages as well as configuring the pages for web content management

Creation of 2 custom web parts: Event Calendar with actual summarized month on landing page and a Knowledge Center for Client Questions and Answers

Creation of Infopath 2010 forms to collect and store data for the two parts.

Technology used: MS Project, MS Sharepoint MOSS 2010/Designer 2010, MS SQL 2008, IIS, Vmware, Adobe Photoshop, CSS, and Dreamweaver

Bell Canada, Toronto,ON. January. 2009 – August. 2010

Content Manager/Producer

Consolidating and updating the bilingual bell.ca site using BEA Weblogic (catalogue), Interwoven Teamsite/Site Publisher, Vignette, Salesforce, HTML, javascript/jquery as well as migrating and deploying the support section of the site to MS Sharepoint MOSS 2010.

Task/Duties:

Review of 7 new master pages for the support section for look and feel from Interwoven and Vignette into Sharepoint

Creation of editable web parts for content management within master pages

Data migration - from Weblogic Catalogue to Sharepoint 2010 custom lists/libraries and MS SQL 2008

Contributor training – creation of training collateral and audio/video

Maintenance/Updates/Administration and development of the Solo Coldfusion website

Bell’s facebook integration was planned, developed and executed. Lastly the Solo product line was moved from an ASP application to Vignette: creation of Vignette templates, migration of data and staging environment were completed.

Technology used: Interwoven Teamsite/Site Publisher, Vignette,, Oracle 10g J2EE/Java, ASP.NET 3.5, COLDFUSION 10, MySQL, Sharepoint MOSS 2010, SQL2008, IIS, Vmware, BEA Weblogic, IBM WebSphere portal, Vignette 7, Adobe Photoshop/InDesign/Illustrator, CSS and Dreamweaver



Contact this candidate