Daphne Liu
Verified Expert in Engineering
Data Modeling Developer
Daphne是一位非常积极的大数据分析架构师和SQL/Tableau开发人员,拥有强大的业务分析解决方案交付技能和20年逐步负责OLTP/OLAP数据库开发/架构的经验. 她经常在商业智能和分析解决方案的研讨会上发言和研讨会培训师. Daphne在数据建模和业务分析解决方案方面与业务用户合作经验丰富.
Portfolio
Experience
Availability
Preferred Environment
亚马逊网络服务(AWS)、Azure、谷歌云、大数据、Linux、SQL
The most amazing...
...我是一个数据天才. I am an expert in SQL development, data modeling, data warehouse development, data analytics, and visualization.
Work Experience
Big Data ML AI Architect
CEVA Logistics
- 在MS SQL Server上创建维度数据模型,用于供应链分析. 它包括数据准备和数据标注, model features' selection, model algorithms, and hyperparameter optimization.
- 利用Pentaho PDI设计企业大数据分析平台解决方案, Cassandra, Elasticsearch, and Grafana. Grafana是一个大数据可视化工具.
- 提供通过MS SQL Server将数据刷新到云存储的数据工程任务, 关系OLTP到OLAP的转换, 以及从MS SQL到NoSQL数据湖的ETL任务.
- 为供应链管理和货运管理系统实现Tableau和Power BI分析可视化.
- 实现并完成企业数据仓库的数据建模, data lakes, and ML/AI forecast models.
- Used Facebook Prophet, a time series algorithms, AutoKeras classification, 谷歌TensorFlow为物流地面TMS系统提供ML和AI解决方案.
- 使用Tableau和Power BI为不同的客户/项目提供仪表板.
- 使用PostgreSQL模糊字符串匹配和Python的FuzzyWuzzy库提供了一个数据质量解决方案, cleaning data, 为机器学习模型创建映射组.
- 设计并构建了一个供应链运营商顾问ML解决方案,其中包括数据标记, features' selection, hyperparameter optimization, algorithms training, 并为供应链管理团队提供明智的运营商选择建议.
- 部署基于TensorFlow TF-Ranking的供应链运营商顾问ML模型, AutoKeras, and Neural Network algorithms. 这个模型训练了超过一百万条记录, 提供培训结果API和批量预测结果参考.
BI Architect
City of Jacksonville
- 架构微软商业智能解决方案使用SQL Server, SSIS和SSAS.
- Built SSAS Cube and MDX.
- 开发SSIS,设计数据仓库.
- 设计并开发了Microsoft Power BI解决方案.
BI Architect
Crowley Marinetime
- 为预算和实际构建了微软商业智能解决方案SSAS Cube.
- 从Oracle和DB2实现了一个SSIS ETL.
- 创建了克劳利船长日志维度数据模型的TSQL.
- Developed an SSRS report.
- Implemented SVN source version control.
Experience
Tableau Dashboard Development
http://public.tableau.com/profile/daphne.liu#!/Big Data Cassandra & Solr Document Search
Big Data Cassandra & Elasticsearch Data Warehouse
供应链管理与财务管理的多维数据模型
供应链运营商顾问-机器学习模型
我通过标记数据从OLAP构建了AI和ML模型, selecting features and algorithms, POC using AutoML algorithms, 并使用AutoKeras和TensorFlow TF-Ranking进行最终的生产部署. 使用Python和Pentaho PDI将数据从OLAP转换为预测模型.
Education
计算机信息科学硕士学位 & Engineering
University of Florida - Florida
Certifications
Tableau
Tableau
Skills
Libraries/APIs
熊猫,TensorFlow深度学习库(TFLearn)
Tools
AutoML, Tableau, Grafana, Pentaho Data Integration (Kettle), Microsoft Excel, Amazon QuickSight, H2O AutoML, Apache Solr, Prophet ERP, Solr, Superset, Microsoft Power BI, SSAS, Subversion (SVN)
Languages
Python, T-SQL (Transact-SQL), SQL, Snowflake, Python 3, MDX
Paradigms
OLAP,数据库设计,商业智能,数据科学
Platforms
Dataiku, Linux, Amazon EC2, Azure, SolrCloud, Apache Kafka, Pentaho, Hortonworks Data Platform (HDP), Oracle, Amazon Web Services (AWS)
Storage
Microsoft SQL Server, OLTP, NoSQL, Elasticsearch, Amazon S3 (AWS S3), Redshift, Google Cloud, Cassandra, Druid.io, SQL Server集成服务(SSIS), IBM Db2, SQL Server Reporting Services (SSRS), PostgreSQL
Frameworks
Hadoop, AWS HA
Other
Data Analysis, Apache Cassandra, Big Data Architecture, Data Virtualization, Data Warehouse Design, Data Modeling, Data Architecture, Big Data, Forecasting, Time Series, AWS Database Migration Service (DMS), Database Schema Design, Integration, Data Engineering, Informatica, Artificial Intelligence (AI), Classification Algorithms, ARIMA Models, Machine Learning, Neural Networks, Agile Data Science, Linear Regression, Logistic Regression, Reporting, Feature Selection, AutoKeras, Performance Tuning, Classification, Data, Time Series Analysis
How to Work with Toptal
在数小时内,而不是数周或数月,我们的网络将为您直接匹配全球行业专家.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring