Scroll To View More
Daphne Liu, Data Modeling Developer in Jacksonville, FL, United States
Daphne Liu

Data Modeling Developer in Jacksonville, FL, United States

Member since June 20, 2018
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 intelligent and analytic solutions. Daphne is experienced collaborating with business users in data modeling and business analytic solutions.
Daphne is now available for hire

Portfolio

  • CEVA Logistics
    Big Data Analytics, Pentaho PDI, Cassandra, Elasticsearch, Grafana...
  • City of Jacksonville
    Microsoft Business Intelligence Solution PowerBI, SSAS, SSIS, SQL Server, MDX
  • Crowley Marinetime
    Microsoft Business Intelligence Solution, SSAS, SSIS, Oracle, DB2, TSQL, SSRS...

Experience

  • SQL, 15 years
  • Data Modeling, 15 years
  • Microsoft SQL Server, 15 years
  • Data Warehouse Design, 8 years
  • Big Data, 5 years
  • Tableau, 5 years
  • Data Virtualization, 5 years
  • Apache Cassandra, 4 years
Jacksonville, FL, United States

Availability

Part-time

Preferred Environment

SQL, Linux, Big Data, AWS, Google Cloud

The most amazing...

...thing about me is that I am a data prodigy. I am an expert in SQL development, data modeling, data warehouse development, data analytics, and visualization.

Employment

  • Big Data Analytic Architect

    2014 - PRESENT
    CEVA Logistics
    • Developed an enterprise EDI document free text search engine solution using Hortonworks 2.6, Cassandra and Solr.
    • Designed an enterprise big data analytic platform solution using Pentaho PDI, Cassandra, Elasticsearch, and Grafana. Grafana is a big data visualization tool.
    • Served as an Enterprise Cassandra Data architect and set up a cluster implementation for a warehouse management and freight management project.
    • Implemented a Tableau analytic visualization for supply chain management and a freight management system.
    • Created SQL Server dimensional data modeling for supply chain analytics.
    • Compiled a Druid and Superset big data analytic solution POC. Druid is used for big data analytic model and Superset is a big data visualization tool.
    • Implemented SQL Server and completed data modeling of an enterprise data warehouse.
    Technologies: Big Data Analytics, Pentaho PDI, Cassandra, Elasticsearch, Grafana, Hortonworks 2.6, Solr, Tableau, SQL Server, Druid, Superset
  • BI Architect

    2013 - 2015
    City of Jacksonville
    • 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.
    Technologies: Microsoft Business Intelligence Solution PowerBI, SSAS, SSIS, SQL Server, MDX
  • BI Architect

    2012 - 2013
    Crowley Marinetime
    • 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.
    Technologies: Microsoft Business Intelligence Solution, SSAS, SSIS, Oracle, DB2, TSQL, SSRS, SVN

Experience

  • Tableau Dashboard Development (Development)
    https://public.tableau.com/profile/daphne.liu#!/

    Tableau dashboard design for a supply chain carrier KPI, financial management KPI (AP vs AR), and shipment on time performance. Implemented Tableau actions, KPI calculated columns, LOD calculations, dynamic slicers, and performance tuning.

  • Big Data Cassandra & Solr Document Search (Development)

    Solr cloud free text search engine design for vendor EDI documents using Solr data import module with Cassandra cluster data stored. A Hadoop HDFS file system was implemented for Solr document index storage. Six Solr collections with shards and replicas. Deployed in March 2016

  • Big Data Cassandra & Elasticsearch Data Warehouse (Development)

    Big Data NoSQL Cassandra and Elasticsearch cluster solution design and implementation. Elasticsearch search engine was built on top of Cassandra cluster, Using Pentaho PDI ETL tool moving data from relational databases to Cassandra NoSQL clusters for enterprise data warehouse. Started in 2017 and deployed in July 2018.

  • Dimensional Data Model for Supply Chain Management and Financial Management (Development)

    SCM and FM Dimensional models built on top of current SQL server data store. These models provide internal or external customers data sources for business analytics. The solution was developed in TSQL, SSIS, and SQL server 2016.

Skills

  • Languages

    T-SQL, SQL, Python 3
  • Libraries/APIs

    Pandas
  • Tools

    Tableau, Grafana, Pentaho Data Integration (Kettle), Apache Solr
  • Paradigms

    OLAP, Data Science
  • Platforms

    Linux, SolrCloud
  • Storage

    Microsoft SQL Server, OLTP, NoSQL, Elasticsearch, AWS S3, Redshift
  • Other

    Apache Cassandra, Big Data Architecture, Data Virtualization, Data Warehouse Design, Data Modeling, Data Architecture, Big Data, Forecasting, Timeseries, ARIMA Models
  • Frameworks

    AWS HA, Hadoop

Education

  • Master's degree in Computer Information Science & Engineering
    1993 - 1995
    University of Florida - Florida
Certifications
  • Tableau
    MARCH 2014 - MARCH 2016
    Tableau
I really like this profile
Share it with others