Robert Ellsworth, Developer in Markham, ON, Canada
Robert is available for hire
Hire Robert

Robert Ellsworth

Verified Expert  in Engineering

Bio

Robert brings technical and business expertise that he's developed during his two decades of consultant work for major institutions, where hundreds of projects have been completed to the clients’ full satisfaction. He excels at architecting solutions with complex requirements that may cross disparate types of technologies. He's also quick to assimilate information for high productivity and quality outcomes within an intense high-tech environment.

Portfolio

Clickstop Inc
Office 365, Microsoft Flow, SharePoint Online
TD Canada Trust
IBM Db2, SQL, SAS, Windows, Unix, Impala, Apache Hive, Hadoop, PySpark, Python...
Johnson & Johnson
SharePoint Online, Tableau, SharePoint

Experience

  • Data Architecture - 20 years
  • SQL - 20 years
  • Business Intelligence (BI) - 20 years
  • SAS - 20 years
  • SharePoint - 9 years
  • Project Management Professional (PMP) - 7 years
  • Tableau - 4 years
  • Python - 1 year

Availability

Part-time

Preferred Environment

GitLab, SQL

The most amazing...

...thing I've created was a customer profitability model that include the current and future value.

Work Experience

SharePoint Consultant

2020 - 2020
Clickstop 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 Online

Process Architect

2019 - 2020
TD 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, Tableau

SharePoint Developer

2018 - 2018
Johnson & 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, SharePoint

Process Architect

2014 - 2018
TD 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, Windows

Data Warehouse Architect

2017 - 2017
CGI
  • 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, Windows

Data Warehouse Architect

2013 - 2014
Aimia
  • 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, Windows

Data Warehouse Architect

2011 - 2013
The 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, Windows

Senior Systems Consultant

2010 - 2011
Bell
  • 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, Windows

Data Warehouse Architect

2006 - 2010
The 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, Windows

Senior System Consultant

2005 - 2006
RBC 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, Windows

Data Warehouse Architect

2005 - 2005
The 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, Windows

Senior System Consultant

2004 - 2005
Loyalty 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, Windows

Senior System Consultant

2004 - 2004
TD 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, Windows

Senior System Consultant

2003 - 2004
Alberta 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, Windows

Senior System Consultant

2003 - 2004
The 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, Windows

Senior System Consultant

1998 - 2003
The 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, Windows

Senior System Consultant

1996 - 1998
The 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, Windows

Senior System Consultant

1993 - 1996
AXA 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 System

Senior System Consultant

1993 - 1993
Bell Sigma
  • Designed and programmed a large customer billing system.
Technologies: SAS, OS/2

Experience

Send Emails Using VBScript

Designed and built a SAS program that constructs a Microsoft Visual Basic Script (VBScript). This SAS program creates a temporary VBScript file to send an email using Outlook on a Windows platform.

Education

1980 - 1985

Bachelor of Science (BSc) Degree in Computer Science

University of Toronto - Toronto, Canada

Certifications

MAY 2012 - PRESENT

Project Management Professional (PMP)®

PMI | Project Management Institute

Skills

Libraries/APIs

PySpark

Tools

SAS Enterprise Guide, Tableau, Microsoft Power BI, Microsoft Excel, IBM Information Management System, ISPF, Impala, Microsoft Flow, Apache Impala, GitLab

Languages

COBOL, T-SQL (Transact-SQL), VBScript, Excel VBA, SAS, SQL, Visual Basic, HTML, Visual Basic for Applications (VBA), Java SE, C, Active Server Pages (ASP), Python, CICS

Frameworks

SharePoint Framework (SPFx), Windows PowerShell, Hadoop

Paradigms

Iterative Development, Agile Software Development, ETL, Business Intelligence (BI)

Platforms

Windows, SharePoint, AIX, Unix, ParAccel, Oracle

Storage

Microsoft SQL Server, SQL Server 2014, SQL Server 2010, IBM Db2, Apache Hive, Teradata

Other

SharePoint Online, Data Analytics, Data Analysis, Data Reporting, Data Visualization, Project Management System (PMS), Office 365, Data Engineering, Project Management Professional (PMP), SAS Macros, Data Architecture, Microsoft 365, TSO, MicroStrategy, AS400, OS/2

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring