Robert is available for hire
Hire RobertRobert Ellsworth
Verified Expert in Engineering
数据架构开发人员
Location
加拿大安大略省的马卡姆
至今成员总数
June 18, 2020
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在线
TD Canada Trust
IBM Db2, SQL, SAS, Windows, Unix, Impala, Apache Hive, Hadoop, PySpark, Python...
Johnson & Johnson
SharePoint在线, Tableau, SharePoint
Experience
Availability
Part-time
首选的环境
GitLab, SQL
The most amazing...
...thing I've created was a customer profitability model that include the current and future value.
Work Experience
SharePoint顾问
2020 - 2020
Clickstop Inc
- Aided in establishing SharePoint communications sites for the company as a whole and for each of the divisions.
- 为每个工作组的SharePoint团队网站提供咨询.
- 在开发访问权限模型时参考.
- Constructed Microsoft Flow processes to integrate SharePoint with teams and outlook.
- 构建PowerShell脚本修改SharePoint权限, 创建SharePoint页面, 并修改Outlook组设置.
- Constructed SharePoint framework extensions and web parts to enhance the SharePoint site's look and feel.
技术:Office 365, Microsoft Flow, SharePoint在线
流程架构师
2019 - 2020
TD Canada Trust
- 建立了现在和未来价值的产品贡献模型.
- Established processes and standards for conversion of existing reports in a SAS, SQL/DB2环境到Hadoop, PySpark环境下使用Tableau和Power BI进行报表.
- 转换SAS中的现有报表, SQL/DB2环境到Hadoop, PySpark环境下使用Tableau和Power BI进行报表.
技术:IBM Db2, SQL, SAS, Windows, Unix, Impala, Apache Hive, Hadoop, PySpark, Python, Microsoft Power BI, Tableau
SharePoint开发人员
2018 - 2018
Johnson & Johnson
- 设计了一个带有嵌入式Tableau报表的SharePoint站点, which captures report commentary and allows historical viewing of reports and commentary.
- 培训员工维护和使用场地.
技术:SharePoint在线, Tableau, SharePoint
流程架构师
2014 - 2018
TD Canada Trust
- 为个人业务线设计了一个整体报告套件.
- 指导员工进行报告制作的最佳实践.
- 为业务报告设计自动化流程.
- Designed interfaces and the distribution process for data and reports.
- 为现在和未来的价值建立了客户贡献模型.
技术:SharePoint在线, Tableau, SharePoint, Microsoft 365, Microsoft SQL Server, IBM Db2, SQL, SAS, Windows
数据仓库架构师
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.
技术:Microsoft 365, Oracle, SQL, SAS, Windows
数据仓库架构师
2013 - 2014
Aimia
- 设计并构建了一个事务性数据集市和报告套件.
- 指导员工进行报告制作的最佳实践.
- 设计数据和报告的界面和分发流程.
Technologies: SharePoint, Microsoft 365, IBM Db2, SQL, SAS, ParAccel, Windows
数据仓库架构师
2011 - 2013
新斯科舍银行
- 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.
- 设计数据和报告的界面和分发流程.
技术:SharePoint在线, SharePoint, Microsoft 365, Microsoft SQL Server, SQL, SAS, AS400, Windows
高级系统顾问
2010 - 2011
Bell
- Worked with a widely distributed team to port a mission-critical application to a new environment.
- 制定项目计划并管理项目完成.
- 连接性和数据资源的协调变化.
- 为支持人员提供培训.
- Executed, tested, and validated results with a cross-functional team.
- 提供实施后支持.
技术:Microsoft 365, SQL, SAS, AIX, Windows
数据仓库架构师
2006 - 2010
新斯科舍银行
- 设计并构建一个流程, data repository, 还有一个自动信用卡竞选报告的门户网站.
- 设计并构建了一个保留报价管理应用程序. 该应用程序为入站呼叫提供特定优惠, 跟踪通话结果, 提供实现能力, 并报告结果.
- 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
高级系统顾问
2005 - 2006
加拿大皇家银行资本市场
- 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企业指南, SAS, AIX, Windows
数据仓库架构师
2005 - 2005
新斯科舍银行
- 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.
- 设计数据和报告的界面和分发流程.
技术:SharePoint在线, Microsoft 365, Microsoft SQL Server, SQL, SAS, AIX, Windows
高级系统顾问
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.
- 培训用户理解和执行报告.
Technologies: Microsoft 365, IBM Db2, MicroStrategy, SQL, SAS, AIX, Windows
高级系统顾问
2004 - 2004
道明金融集团
- Constructed an automated process to sample data to match their campaign models.
- 培训系统人员运行流程.
- 执行实施后支持.
技术:Microsoft 365, IBM Db2, SQL, SAS, AIX, Windows
高级系统顾问
2003 - 2004
艾伯塔省市政事务
- 制定评估报告和分析.
- 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.
技术:Microsoft 365, Oracle, SQL, SAS, Windows
高级系统顾问
2003 - 2004
新斯科舍银行
- 设计并执行市场营销活动.
- 与业务用户一起获得活动需求.
- 在Affinium环境下建立活动客户选择.
- 向邮局提供邮件文件.
- 与系统对接，报告结果.
技术:SharePoint在线, Microsoft 365, IBM Db2, SQL, SAS, AIX, Windows
高级系统顾问
1998 - 2003
The Royal Bank
- Designed and built a reporting suite, working with a cross functional team.
- 调查并获得信用卡数据.
- 构建定期报告.
- Designed and developed a user interface to a data warehouse using SAS.
Technologies: Microsoft 365, IBM Db2, MicroStrategy, SQL, SAS, AIX, Windows
高级系统顾问
1996 - 1998
新斯科舍银行
- 评估和测试数据仓库的设计和组合.
- Designed and developed a user interface for a data warehouse using SAS and VB.
- 调查数据仓库负载的来源.
Technologies: Visual Basic, Microsoft 365, IBM Db2, MicroStrategy, SQL, SAS, AIX, Windows
高级系统顾问
1993 - 1996
AXA Insurance
- Designed and programmed enhancements to the billing and rating subsystem.
- Designed and programmed the enhancements to the underwriting decision subsystem.
技术:项目管理系统(PMS), SAS, COBOL, CICS, ISPF, TSO, IBM信息管理系统
高级系统顾问
1993 - 1993
Bell Sigma
- 设计并编写了一个大型客户计费系统.
技术:SAS, OS/2
Experience
使用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
计算机科学学士学位
多伦多大学-多伦多，加拿大
Certifications
2012年5月至今
项目管理专家(PMP)®
PMI |项目管理协会
Skills
Libraries/APIs
PySpark
Tools
SAS企业指南, Tableau, Microsoft Power BI, Microsoft Excel, IBM信息管理系统, ISPF, Impala, Microsoft Flow, Apache Impala, GitLab
Frameworks
SharePoint Framework (SPFx)， Windows PowerShell, Hadoop
Paradigms
Iterative Development, Agile Software Development, ETL, 商业智能(BI)
Languages
COBOL, t - sql (transact - sql), VBScript, Excel VBA, SAS, SQL, Visual Basic, HTML, Visual Basic for Applications (VBA), Java SE, C, 活动服务器页面(ASP), Python, CICS
Platforms
Windows、SharePoint、AIX、Unix、ParAccel、Oracle
Storage
Microsoft SQL Server, SQL Server 2014, SQL Server 2010, IBM Db2, Apache Hive, Teradata
Other
SharePoint在线, Data Analytics, Data Analysis, Data Reporting, 数据可视化, 项目管理系统(PMS), Office 365, 工程数据, 项目管理专业人员(PMP), SAS Macros, 数据架构, Microsoft 365, TSO, MicroStrategy, AS400, OS/2
有效的合作
如何使用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
选择你的才能
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
开始你的无风险人才试验
与你选择的人才一起工作，试用最多两周. 只有当你决定雇佣他们时才付钱.
对顶尖人才的需求很大.
Start hiring