Robert Ellsworth
Verified Expert in Engineering
数据架构开发人员
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
Experience
Availability
首选的环境
GitLab, SQL
The most amazing...
...thing I've created was a customer profitability model that include the current and future value.
Work Experience
SharePoint顾问
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.
流程架构师
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进行报表.
SharePoint开发人员
Johnson & Johnson
- 设计了一个带有嵌入式Tableau报表的SharePoint站点, which captures report commentary and allows historical viewing of reports and commentary.
- 培训员工维护和使用场地.
流程架构师
TD Canada Trust
- 为个人业务线设计了一个整体报告套件.
- 指导员工进行报告制作的最佳实践.
- 为业务报告设计自动化流程.
- Designed interfaces and the distribution process for data and reports.
- 为现在和未来的价值建立了客户贡献模型.
数据仓库架构师
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.
数据仓库架构师
Aimia
- 设计并构建了一个事务性数据集市和报告套件.
- 指导员工进行报告制作的最佳实践.
- 设计数据和报告的界面和分发流程.
数据仓库架构师
新斯科舍银行
- 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.
- 设计数据和报告的界面和分发流程.
高级系统顾问
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.
- 提供实施后支持.
数据仓库架构师
新斯科舍银行
- 设计并构建一个流程, 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.
高级系统顾问
加拿大皇家银行资本市场
- 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.
数据仓库架构师
新斯科舍银行
- 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.
- 设计数据和报告的界面和分发流程.
高级系统顾问
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.
- 培训用户理解和执行报告.
高级系统顾问
道明金融集团
- Constructed an automated process to sample data to match their campaign models.
- 培训系统人员运行流程.
- 执行实施后支持.
高级系统顾问
艾伯塔省市政事务
- 制定评估报告和分析.
- 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.
高级系统顾问
新斯科舍银行
- 设计并执行市场营销活动.
- 与业务用户一起获得活动需求.
- 在Affinium环境下建立活动客户选择.
- 向邮局提供邮件文件.
- 与系统对接,报告结果.
高级系统顾问
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.
高级系统顾问
新斯科舍银行
- 评估和测试数据仓库的设计和组合.
- Designed and developed a user interface for a data warehouse using SAS and VB.
- 调查数据仓库负载的来源.
高级系统顾问
AXA Insurance
- Designed and programmed enhancements to the billing and rating subsystem.
- Designed and programmed the enhancements to the underwriting decision subsystem.
高级系统顾问
Bell Sigma
- 设计并编写了一个大型客户计费系统.
Experience
使用VBScript发送邮件
Education
计算机科学学士学位
多伦多大学-多伦多,加拿大
Certifications
项目管理专家(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.
Share your needs
选择你的才能
开始你的无风险人才试验
对顶尖人才的需求很大.
Start hiring