My name is William. I'm a data engineer with 7+ years of experience currently working as an consultant at Analytics8.

My LinkedIn Profile here!

• Worked on multiple business cases modeling for a credit union with $3B+ in yearly revenue using SqlDBM. Physical layer was then build in Data Build Tool (DBT) and SnowFlake.
• Developed and maintained the ETL processes for a large brewer's supply chain operations. Was actively working in the migration from QlikSense to PowerBI by using tools in the backend such as Azure Data Factory and Databricks.
• Optimized ETL workflows and pipelines for performance, reliability, and scalability while implementing data quality and data validation processes to ensure data accuracy and consistency.

• Implemented various time series and linear regression models to predict Annual Recurring Revenue (ARR). I then displayed the actionable results in Tableau using the RServe package.
• Collaborated with various executive team members to create and refine Tableau reports. As part of this process, I cleaned data in SQL, R, and Python to enable automation that would ensure source to target data accuracy.

• Worked with the operation’s team to clearly define and design key metrics for floor operations with the end goal of measuring and tracking them (KPI’s) via Tableau dashboards.
• Performed data-driven analysis to answer critical business questions related to sales, demand, and talent behavior on the platform. I used Python and R to conduct the analysis and presented the insights to the c-suite level.

• Automated daily reports and tasks using Python, Excel macros, SQL, and Tableau to deliver critical information to internal clients. This automation helped to reduce the average daily operations time by 30 to 60 minutes.
• Compiled and analyzed data to generate monthly financial forecast and evaluated previous month’s performance to more than 10,000 clients’ locations nationwide while proposing data-driven insights to improve daily floor operations.

• Collected and cleaned structured and unstructured data from various sources to provide vital insights to a department of over 100 employees as well as external clients.

• Databricks Certified Data Engineer Associate (Expires on January 2026)
• Tableau Desktop Certified Associate (Expired on May 2023)

• Master of Science in Analytics

• Bachelor of Business Administration in Information Systems & Applied Statistics