Daphne L.

Daphne L.

United States of America
Hire Daphne L. Hire Daphne L. Hire Daphne L.

About Me

Daphne is a highly motivated big data analytic architect and SQL/Tableau developer with strong business analytic solution delivery skills and 20 years of progressively responsible OLTP/OLAP database development/architecture experience. She is a frequent seminar speaker and workshop trainer in business intelligence and analytic solutions. Daphne is experienced collaborating with business users in data modeling and business analytic solutions.

Database

T-SQL (Transact-SQL) Microsoft SQL Server SQL Database Design

Other

Work history

CEVA Logistics
Big Data ML AI Architect
2014 - Present (11 years)
Remote
  • Created a dimensional data model on MS SQL Server for supply chain analytics. It includes data preparation and data labeling, model features' selection, model algorithms, and hyperparameter optimization.

  • Designed an enterprise big data analytic platform solution using Pentaho PDI, Cassandra, Elasticsearch, and Grafana. Grafana is a big data visualization tool.

  • Provided data engineering tasks that refresh data to cloud storage using MS SQL Server, relational OLTP to OLAP transformation, and ETL tasks from MS SQL to NoSQL data lakes in Cassandra.

  • Implemented both Tableau and Power BI analytic visualization for supply chain management and a freight management system.

  • Implemented and completed data modeling of an enterprise data warehouse, data lakes, and ML/AI forecast models.

  • Used Facebook Prophet, a time series algorithms, AutoKeras classification, and Google TensorFlow to deliver an ML and AI solution to a logistics ground TMS system.

  • Delivered dashboards using both Tableau and Power BI for different clients/projects.

  • Delivered a data quality solution using PostgreSQL fuzzy string matching and Python FuzzyWuzzy libraries, cleaning data, and creating mapping groups for the machine learning model.

  • Designed and architected a supply chain carrier advisor ML solution that includes data labeling, features' selection, hyperparameter optimization, algorithms training, and carrier selection smart choices advisory to the supply chain management team.

  • Deployed the supply chain carrier advisor ML model based on TensorFlow TF-Ranking, AutoKeras, and Neural Network algorithms. Over a million records were trained in this model, providing a training result API and batch forecast result references.

City of Jacksonville
BI Architect
2013 - 2015 (2 years)
Remote
  • Architected Microsoft Business Intelligence Solutions using SQL Server, SSIS, and SSAS.

  • Built SSAS Cube and MDX.

  • Developed SSIS and designed a data warehouse.

  • Designed and developed a Microsoft Power BI Solution.

MDXMicrosoft SQL Server SQL Server Integration Services (SSIS) SSASMicrosoft Power BI Microsoft ExcelAmazon S3 (AWS S3) Database DesignDatabase Schema Design ReportingBusiness Intelligence (BI) Integration
Crowley Marinetime
BI Architect
2012 - 2013 (1 year)
Remote
  • Built a Microsoft Business Intelligence Solution SSAS Cube for budget and actual.

  • Implemented an SSIS ETL from Oracle and DB2.

  • Created a TSQL for Crowley Vessel Captain log dimensional data model.

  • Developed an SSRS report.

  • Implemented SVN source version control.

Subversion (SVN) SQL Server Reporting Services (SSRS) T-SQL (Transact-SQL) IBM DB2OracleSQL Server Integration Services (SSIS) SSASMicrosoft Power BI Microsoft ExcelDatabase DesignDatabase Schema Design ReportingBusiness Intelligence (BI) Integration

Showcase

Tableau Dashboard Development
  • Developed a dashboard for supply chain carrier KPIs, financial management KPIs (AP vs AR), and shipment on time performance.

  • Implemented Tableau actions, KPI calculated columns, LOD calculations, dynamic slicers, and performance tuning.

  • The dashboard utilizes interactive elements for data visualization and analysis.

Big Data Cassandra & Solr Document Search
  • Solr cloud is designed for vendor EDI document search.

  • The system utilizes Solr data import and Cassandra cluster data.

  • Solr documents are stored in HDFS with shards and replicas.

Big Data Cassandra & Elasticsearch Data Warehouse
  • Designed and implemented a data warehouse using Elasticsearch and Cassandra.

  • Utilized Pentaho PDI for data migration from relational databases to Cassandra.

  • Started in 2017 and deployed in July 2018.

Dimensional Data Model for Supply Chain Management and Financial Management
  • SCM and FM Dimensional models are built on existing SQL Server data store.

  • These models serve as internal or external customer data sources for business analytics.

  • The solution was developed using TSQL, SSIS, and SQL Server 2016.

Supply Chain Carrier Advisor — Machine Learning Model
  • Carrier Advisor is a machine learning project designed to advise carriers in a supply chain management system.

  • The project utilizes an AI and ML model built from OLAP data, including data labeling, feature selection, algorithm selection, and final production deployment using AutoKeras and TensorFlow TF-Ranking.

  • Data transformation from OLAP to prediction models was performed using Python and Pentaho PDI.

Education

Education
Master's Degree in Computer Information Science & Engineering
University of Florida
1993 - 1995 (2 years)