![肖恩·麦肯齐,加拿大不列颠哥伦比亚省维多利亚的开发商](http://assets.toptal.io/images?url=http%3A%2F%2Fbs-uploads.toptal.io%2Fblackfish-uploads%2Ftalent%2F480785%2Fpicture%2Foptimized%2Fhuge_fb110b1e98c354745e02994bb3f94c84-948e4154b80f59e4c6575125c9c1eaa1.jpg&width=524)
Sean MacKenzie
Verified Expert in Engineering
Database Developer
Sean is a data professional with over 20 years of experience. 他在医疗等行业的关键任务设置中设计并构建了数十个端到端解决方案,涉及广泛的技术, aerospace, finance, logistics, and retail. 他拥有数据工程硕士学位, 经济学学士学位, and was certified in Data Analytics at Cornell University. Sean还有一个关于数据工程技术的YouTube频道,有数千名订阅者.
Portfolio
Experience
Availability
首选的环境
Windows, Python, VB.NET, ASP.. NET, Oracle, Microsoft SQL Server
The most amazing...
...我设计和编码的东西是一个全省范围的门户网站和数据仓库,为卫生机构的消费者提供与911相关的报告和统计数据.
Work Experience
Data Engineer
Musi
- 为AppStore上的一个流行音乐应用程序构建了一个Snowflake仓库和数据库,每天处理数十亿行数据. 设计事实表和维度表来支持分析.
- 用JavaScript设计和开发Snowflake存储过程,方便数据处理.
- Designed and deployed operational dashboards in Power BI and Tableau.
仪表板开发人员(财务背景)
Everstell
- 在Azure SQL上构建和编码关系数据库系统,以支持复杂的SaaS金融科技应用程序, 包括支持Power BI报告的数据仓库.
- Architected and designed a SaaS web application on Azure using ASP.. NET和Visual Basic (.在Power BI发布的服务上提供一个处理财务数据和综合报告的用户平台.
- Led a technology team including data analysts, programmers, and designers. Guided the team through three successful SaaS customer onboarding experiences.
Consultant
MacKenzie & 麦肯锡咨询
- 创建了一个关于技术主题的YouTube频道,包括推广、SEO和其他因素.
- 创建了一个名为BillZone Systems的完整SaaS解决方案,用于项目管理和顾问计费. 该系统在十年间被五家公司使用.
- 20多年来,作为开发人员和设计负责人,监督了10人以下团队的技术项目.
高级SQL开发人员
不列颠哥伦比亚保险公司
- Performed complex data extracts from IBM Db2 and other databases and warehouses.
- Implemented ETL on data for use with new reporting platforms (Tableau).
- 在SQL和架构转换到新报表系统的Legacy businessojects设计中进行报表设计调查.
MRP运营和分析开发人员
西南研究院
- Developed a complex ETL procedure for MRP data in SQL Server.
- 在Excel和VBA中编写复杂的MRP装配树提取和浏览用户界面.
- 通过ODBC直接将采购订单和制造订单MRP更新程序写入Misys, using T-SQL.
自由职业高级报道开发人员
不列颠哥伦比亚省紧急保健服务
- Integrated, 作为新数据仓库的架构师, large Oracle and SQL Server systems and build data pipelines using ADO.NET with VB.NET.
- 在仓库上设计和构建SSRS和网络报告系统,供外部使用.
- Oversaw production deployment to thousands of users of portal functionality.
- 对技术实现进行培训,并编写支持解决方案的技术文档.
自由职业高级开发分析师
Work Comp. Tech Ltd.
- 使用SQL Server创建和管理第三方残疾管理系统的变更; .. NET和MS Access.
- Designed, coded, and deployed data pipelines and overnight batch programs for data warehousing purposes.
- Designed, coded, 使用复杂的统计数据, forecasting, 使用SQL Server进行操作报告, MS Access, MS Excel, and VBA.
- Advised senior executive on technical direction and strategy.
- Integrated other medical environments into a proprietary case management system.
高级数据分析师
BC省相互火灾保险
- 为P设计、编码并部署了一个数据仓库&C保险制度.
- Created, coded, and deployed SSRS reporting for users in a P&C保险环境.
- 为执行管理架构、编码和部署Power BI在线交互式报告.
- Provided technical training for junior and intermediate staff.
- Wrote technical systems documentation for warehouse, SSRS, and online Power BI systems.
- 使用ADO开发广泛的数据管道.PostgreSQL数据库和SQL Server系统之间的。NET连接.
自由职业资深ETL开发人员
Metrie, Inc.
- Led the integration development to migrate dozens of companies onto SAP.
- Created loading scripts to load the materials management SAP module with products, 处理和设置时间, and other data.
- Oversaw the loading of production systems using ETL procedures.
- Composed project reports on the progress of loading as well as other successful KPIs.
自由Oracle开发员
比尔斯兰·格里菲斯福利管理机构
- Supported a benefits and pension system hosting various union pensions.
- Created benefits and pension system enhancements in Oracle as required.
- 将旧的MySQL和PHP系统迁移到更新的系统 .NET technologies.
- Provided technical strategy and leadership advice to senior executives.
自由Oracle数据库开发员
卡车司机全国福利计划
- Provided Oracle support work for pension systems used by TNBP.
- Implemented enhancements to the Oracle pension system as required.
- Created technical and support documentation for the pension systems.
自由职业高级数据库开发人员
国际水卫工业有限公司.
- 指导和建议采用ERP和MRP系统的航空生产制造.
- Created and coded several data applications for data management of sales and compliance, among others.
- Provided regular user application support for system downtime.
- Designed and coded system updates and user reporting as required.
自由移动系统开发员
英属哥伦比亚大学
- Designed, coded, and deployed mobile data collection systems for pediatric research.
- Oversaw the deployment of mobile systems for data collection and monitored data pipelines.
- Integrated two very different, complex research databases.
- Provided technical strategy and guidance to the leadership team.
自由MRP报告分析师
Viking Air
- 设计并编写了一个下钻工具,使用户可以轻松地下钻到单个组件(例如.g.(机翼或尾翼组件).
- 为钻取工具创建并编码度量标准,以允许对产品或交货时间不足进行监督.
- Drafted technical documentation and advised on how to implement the solution.
自由职业高级技术分析师
温哥华海岸卫生局
- 担任高级技术分析师,负责在温哥华地区的四家医院部署现成的病床管理和物流系统.
- Designed, coded, and deployed a plug-in solution to fill a gap in superbug (MRSA, VRE) reporting shortfalls in certain rooms in each hospital.
- Composed the project technical documentation and led technical development teams.
- Led vendor technical teams in the deployment of their solutions.
- 指导负责医院传输软件部署组件的部署团队.
自由数据库开发人员
召回(现为铁山)
- 将六个办公地点集成到SQL Server上的一个系统中,用户中断最小, 使用相同的MS Access物流数据库.
- Provided ETL support and code for migration to PeopleSoft.
- Drafted system documentation and provided user technical training.
自由撰稿人
Teleflex加拿大公司. (现为Seastar Solutions)
- 设计、编码和部署一个系统来评估MRP主调度和销售历史.
- Performed data analytics and forecasting for sales activities.
- Drew up the project documentation and provided deployment support.
自由数据库开发人员
Avcorp工业公司.
- Designed, coded, and deployed a database system to validate and rate aerospace suppliers.
- Wrote operational and statistical reports for supplier quality initiatives.
- Composed systems documentation and performed user training.
- 围绕工程质量保证构思、编码和部署数据捕获系统.
自由商业和技术分析师
不列颠哥伦比亚省保险公司
- 创建、编码和部署一个系统,用于查询和显示新的高级系统的崩溃数据.
- Acted as a business and technical analyst on the rollout of a new insurance product.
- Wrote business and technical documentation to support various projects.
运营协调员|开发人员
BC Rail
- Designed, coded, 并开发了5个系统来加强客务部门的数据收集.
- Ideated, coded, 并开发了一个车载销售点系统,该系统利用复制和ETL程序供员工在长途铁路旅行中使用.
- Provided strategy and decision-making support for various projects.
Experience
SaaS Project Management System with Time Collection, Invoicing, and PDF Reporting
http://mackenziemackenzie.com/what-is-billzone-systems.html作为一个功能齐全的解决方案,它具有通过PDF到桌面的发票和统计报告功能. 它需要一个人力资源支持模块, 包括假期和病假监督, 周年薪酬和加薪跟踪. 它还有一个辅助生活和家庭护理的插件系统,供需要在这些领域收集专门数据的公司使用. 在它的生命周期中,它支持了来自世界各地的数百个用户.
点击链接查看我的博客页面,详细介绍了BillZone的历史,以及它在成立之初为它制作的一个非常有趣的宣传视频!
运行状况分析和报告门户
从业务中获取需求, 我设计并编码了整个端到端的解决方案, documented it, 并指导内部员工交接.
分析和数据仓库基础
在Power BI中设计和部署了Analytics,用于交互式分析和SSRS,用于打印和自动分发报告(PDF到电子邮件)。. 该解决方案包括设置和配置Power BI On-premise网关,以执行云数据集的定期更新.
An on-site web portal to coordinate all of the reports was created in ASP.NET.
Education
数据工程硕士学位
爱丁堡纳皮尔大学-英国爱丁堡
经济学学士学位
英属哥伦比亚大学-温哥华,BC,加拿大
Certifications
Data Analytics
Cornell University
Skills
Libraries/APIs
ODBC, ActiveX数据对象(ADO), Pandas,斯坦福NLP
Tools
Microsoft Access, Microsoft Power BI, Microsoft Excel, Visual Studio, SAP物料管理(MM), SugarCRM, Oracle 11g Forms, Oracle Forms, Squirrel, Tableau, Google Analytics, Camtasia, Apache Airflow, Oracle SQL数据建模器, C#.NET WinForms
Frameworks
ASP.NET Web Forms, ADO.. NET,经典ASP, ASP.NET, .NET
Languages
Visual Basic for Applications (VBA), Visual Basic .NET (VB.NET), VB.NET, t - sql (transact - sql), SQL, Excel VBA, Python, Snowflake, Python 3, JavaScript, HTML, PHP, R, Java, C#, C#.NET, Visual Basic
Paradigms
数据库设计,ETL, ETL实现 & Design, 商业智能(BI), 数据库开发, 数据驱动的设计, HIPAA Compliance, Data Science, DevOps, Agile
Platforms
Azure、Windows Server、Ubuntu、Oracle、Windows、Windows Mobile、亚马逊网络服务(AWS)、YouTube
Storage
Microsoft SQL Server, 数据库体系结构, Database Security, Databases, Data Integration, Database Modeling, SQL Server 2012, SQL Server 2016, SQL Server 2008 R2, SQL Server 2017, SQL Server 2000, PL/SQL, SQL CE, SQLite, PostgreSQL, Oracle PL/SQL, Data Pipelines, Oracle 11g, Oracle 12c, Oracle9i, SQL Server 2014, MySQL, IBM Db2, SQL Server报表服务(SSRS), SQL Server集成服务(SSIS), JSON, Azure SQL
Industry Expertise
Healthcare
Other
Data Analysis, Data Architecture, Data Modeling, Reporting, Data Analytics, Data Management, Data Mining, 软件架构, Data Profiling, 数据可视化, Data Wrangling, Consulting, Architecture, IIS, Data Warehousing, Data Engineering, Big Data, Data Governance, SaaS, 性能调优, ELT, APIs, 企业架构, 解决方案架构, Forecasting, 统计分析, 后端开发, 数据仓库设计, 电子病历(EMR), 电子健康记录(EHR), DAX, PeopleSoft, ERPlite, BaaN, SAP, BAPI, 统计建模, Economics, Machine Learning, 自然语言处理(NLP), Neural Networks, 卷积神经网络(CNN), Computer Vision, Deep Learning, 财务报告仪表板, GPT, 生成预训练变压器(GPT)
如何使用Toptal
在数小时内,而不是数周或数月,我们的网络将为您直接匹配全球行业专家.
Share your needs
选择你的才能
开始你的无风险人才试验
对顶尖人才的需求很大.
Start hiring