SharePoint Consultant
2020 - 2020Clickstop Inc- Aided in establishing SharePoint communications sites for the company as a whole and for each of the divisions.
- Consulted on SharePoint team sites for each workgroup.
- Consulted in developing a permissions model for access.
- Constructed Microsoft Flow processes to integrate SharePoint with teams and outlook.
- Constructed PowerShell scripts to modify SharePoint permission, create SharePoint pages, and modify Outlook group settings.
- Constructed SharePoint framework extensions and web parts to enhance the SharePoint site's look and feel.
Technologies: Office 365, Microsoft Flow, SharePoint OnlineProcess Architect
2019 - 2020TD Canada Trust- Built a product contribution model for present and future value.
- Established processes and standards for conversion of existing reports in a SAS, SQL/DB2 environment to a Hadoop, PySpark environment using Tableau and Power BI for reporting.
- Converted existing reports in a SAS, SQL/DB2 environment to a Hadoop, PySpark environment using Tableau and Power BI for reporting.
Technologies: IBM Db2, SQL, SAS, Windows, Unix, Impala, Apache Hive, Hadoop, PySpark, Python, Microsoft Power BI, TableauSharePoint Developer
2018 - 2018Johnson & Johnson- Designed a SharePoint site with embedded Tableau reports, which captures report commentary and allows historical viewing of reports and commentary.
- Trained staff on maintenance and use of the site.
Technologies: SharePoint Online, Tableau, SharePointProcess Architect
2014 - 2018TD Canada Trust- Designed a holistic reporting suite for personal business lines.
- Mentored staff on best practices for report production.
- Designed automated processes for business reporting.
- Designed interfaces and the distribution process for data and reports.
- Built a customer contribution model for present and future value.
Technologies: SharePoint Online, Tableau, SharePoint, Microsoft 365, Microsoft SQL Server, IBM Db2, SQL, SAS, WindowsData Warehouse Architect
2017 - 2017CGI- Designed an analytics-ready layer that embeds business logic and standard reporting templates into the data warehouse and reporting environment.
- Consulted on SAS installations to maximize data privacy protection and environment functionality.
Technologies: Microsoft 365, Oracle, SQL, SAS, WindowsData Warehouse Architect
2013 - 2014Aimia- Designed and built a transactional datamart and reporting suite.
- Mentored staff on best practices for report production.
- Designed interfaces and distribution process for data and reports.
Technologies: SharePoint, Microsoft 365, IBM Db2, SQL, SAS, ParAccel, WindowsData Warehouse Architect
2011 - 2013The Bank of Nova Scotia- Designed and built a data mart and reporting suite and working with a cross-functional team.
- Investigated and obtained product data across a variety of legacy systems.
- Constructed a data repository to facilitate both ad-hoc and periodic reporting requirements.
- Designed interfaces and distribution process for data and reports.
Technologies: SharePoint Online, SharePoint, Microsoft 365, Microsoft SQL Server, SQL, SAS, AS400, WindowsSenior Systems Consultant
2010 - 2011Bell- Worked with a widely distributed team to port a mission-critical application to a new environment.
- Developed the project plan and managed the project to completion.
- Coordinated changes in connectivity and data resourcing.
- Provided training to support staff.
- Executed, tested, and validated results with a cross-functional team.
- Provided post-implementation support.
Technologies: Microsoft 365, SQL, SAS, AIX, WindowsData Warehouse Architect
2006 - 2010The Bank of Nova Scotia- Designed and constructed a process, data repository, and a portal for automated credit card campaign reporting.
- Designed and built a retention offer management application. The application provides specific offers for inbound calls, tracks the results of the calls, provides fulfillment capabilities, and reports results.
- Constructed a portal that allows the distribution of reports to a widely distributed user base without emailing the reports. The solution was constructed based on requirements gathered from the diverse user group.
Technologies: SharePoint, Microsoft 365, IBM Db2, SQL, SAS, AS400, WindowsSenior System Consultant
2005 - 2006RBC Capital Markets- Designed and built a robust solution that can load data files of varying structures into Teradata tables. The process constructed a table on Teradata then verifies and loads the data.
Technologies: Microsoft 365, Teradata, SQL, SAS Enterprise Guide, SAS, AIX, WindowsData Warehouse Architect
2005 - 2005The Bank of Nova Scotia- Designed and built a datamart and reporting suite, working with a cross-functional team.
- Investigated and obtained credit card data across a variety of legacy systems.
- Constructed a data repository to facilitate both ad hoc and periodic reporting requirements.
- Designed interfaces and distribution process for data and reports.
Technologies: SharePoint Online, Microsoft 365, Microsoft SQL Server, SQL, SAS, AIX, WindowsSenior System Consultant
2004 - 2005Loyalty Group- Designed and constructed a micro-strategy solution that can report on product interaction in the food sector.
- Constructed schema and metrics to facilitate the user requirements.
- Trained users in understanding and executing the reports.
Technologies: Microsoft 365, IBM Db2, MicroStrategy, SQL, SAS, AIX, WindowsSenior System Consultant
2004 - 2004TD Financial Group- Constructed an automated process to sample data to match their campaign models.
- Trained the systems personnel to run the process.
- Performed post-implementation support.
Technologies: Microsoft 365, IBM Db2, SQL, SAS, AIX, WindowsSenior System Consultant
2003 - 2004Alberta Municipal Affairs- Developed assessment reporting and analysis.
- Constructed a process to update the Oracle database with change records based on requirements obtained from the business users.
- Designed and built a process to produce PDF statements for property holders.
Technologies: Microsoft 365, Oracle, SQL, SAS, WindowsSenior System Consultant
2003 - 2004The Bank of Nova Scotia- Designed and executed marketing campaigns.
- Worked with the business user to obtain campaign requirements.
- Built the campaigns customer selection in Affinium environment.
- Provided mail files to the mail house.
- Interfaced with systems to report on results.
Technologies: SharePoint Online, Microsoft 365, IBM Db2, SQL, SAS, AIX, WindowsSenior System Consultant
1998 - 2003The Royal Bank- Designed and built a reporting suite, working with a cross functional team.
- Investigated and obtain credit card data.
- Constructed periodic reports.
- Designed and developed a user interface to a data warehouse using SAS.
Technologies: Microsoft 365, IBM Db2, MicroStrategy, SQL, SAS, AIX, WindowsSenior System Consultant
1996 - 1998The Bank of Nova Scotia- Evaluated and tested a data warehouse design and composition.
- Designed and developed a user interface for a data warehouse using SAS and VB.
- Investigated sourcing for the data warehouse load.
Technologies: Visual Basic, Microsoft 365, IBM Db2, MicroStrategy, SQL, SAS, AIX, WindowsSenior System Consultant
1993 - 1996AXA Insurance- Designed and programmed enhancements to the billing and rating subsystem.
- Designed and programmed the enhancements to the underwriting decision subsystem.
Technologies: Project Management System (PMS), SAS, COBOL, CICS, ISPF, TSO, IBM Information Management SystemSenior System Consultant
1993 - 1993Bell Sigma- Designed and programmed a large customer billing system.
Technologies: SAS, OS/2