Daphne L.

Daphne L.

Data Engineer/BI Architect

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

About Me

Daphne is a highly skilled Digitalization Architect in Big Data, Machine Learning & AI with strong business information solution delivery skills and 15+ years of progressively responsible OLTP/OLAP database development/architecture experience. She also has over 10 years of experience in OLAP Multidimensional database design/development/performance tuning which includes SQL Server 2005/2008/2008 r2, IBM DB2, and Oracle. Daphne is known for dedicated teamwork, high-energy, excellent work ethic, and commitment to achieving business goals and all-around success. She has a high capability to conduct extensive scale projects and rollouts.

Portfolio

Data Engineer/BI Architect - Tableau Dashboard Development
Data Engineer/BI Architect - Tableau Dashboard Development

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

Data Engineer/BI Architect - City of Jacksonville Dashboard: Fund Analysis
Data Engineer/BI Architect - City of Jacksonville Dashboard: Fund Analysis

The project was a City of Jacksonville Fund Analysis Dashboard from my Finance OLAP Cube. My favorite City Fund Analysis across years against Actual, Carry Over, and Budget. It is an extremely informative page that can help authorities view and keep track of asset allocation, gains, and more across asset classes.

Data Engineer/BI Architect - Financial Data Warehouse
Data Engineer/BI Architect - Financial Data Warehouse

The project was a Financial Data Warehouse OLAP Star Schema Model. There are three types of fact tables in this design. Transaction Details, Headers, and Balance Forward. Dimension tables include Char of Account, Date, Organization, Vendor...etc.

Work history

UpStack
UpStack
Data Engineer/BI Architect
2021 - Present (2 years)
Remote
  • Create and develop complex reports and perform data modeling and analysis according to business needs.

  • Develop Data Science opportunities and identify opportunities to use data science to create customer value.

  • Closely collaborate with developer teams to integrate data analysis into production and operation systems.

CEVA Logistics
CEVA Logistics
Digitalization Architect Big Data, Machine Learning & AI
2015 - Present (8 years)
United States of America
  • Acted as a Machine Learning & Big Data Business Intelligence Architect, working with linear regression, time series, classification, neural network, and machine learning algorithms.

  • Developed a big data analytic platform solution using Pentaho PDI, Cassandra, Elasticsearch, and Grafana.

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

City of Jacksonville
City of Jacksonville
Sr. Business Intelligence Architect/Developer
2013 - 2015 (2 years)
United States of America
  • Worked on architecting Microsoft Business Intelligence Solutions using SQL Server, SSIS, and SSAS, for the largest city in area in the continental United States.

  • Developed an SSAS Cube and MDX to query multidimensional objects. Created Power BI solutions (PowerPivot/Tabular/PowerView).

  • Performed T-SQL Store Procedure ETL development T-SQL Query/OLAP Cube performance tuning.

Crowley
Crowley
BI Architect
2012 - 2013 (1 year)
United States of America
  • Developed a a Microsoft Business Intelligence Solution SSAS Cube for a maritime, energy, and logistics solutions company serving customers in domestic and international markets .

  • Implemented SVN source version control and an SSIS ETL from Oracle and DB2.

  • Performed T-SQL Query Performance Tuning and OLAP Cube Performance Tuning.

Education

Degree Name Bachelor of Science (BS), Management Information Systems, General
Degree Name Bachelor of Science (BS), Management Information Systems, General
Fu Jen Catholic University
Master's degree in Computer Information Science & Engineering
Master's degree in Computer Information Science & Engineering
University of Florida