Hello! I'm Clay
I'm an experienced data engineering and analytics consultant based in Auckland, New Zealand, with over 18 years of expertise in data engineering, migration, and analysis, holding multiple certifications and having contributed to significant data modernization and migration projects for many clients, utilizing a wide range of tools and platforms.
EXPERIENCE
2022-Current
Senior Consultant
Spark / Qrious
As a skilled Data Engineer with a strong background in data architecture, I specialize in designing and implementing cloud-based data platform solutions. My expertise includes working with industry-leading technologies like Snowflake, Microsoft Fabric, Azure resources and transformation tools such as dbt, Coalesce and IBM StreamSets. I have hands-on experience in both developing new analytics solutions and migrating legacy on-premises systems, like SSIS and WhereScape RED to the cloud, ensuring seamless transitions and enhanced performance. My focus is on optimizing data workflows, enabling organizations to make data-driven decisions with scalable, efficient, and reliable solutions.
2020-2022
Accenture / Zag
Analytics Senior Consultant
With extensive experience in SAP Data Migration projects, I have successfully guided clients through the migration of their legacy ERP systems to SAP S/4HANA. My expertise includes the use of tools such as LTMC, LTMOM, LSMW, IDocs, and SAP Data Services, for which I hold certification. I was responsible for migrating both master and transactional data, including Customer, Vendor, Material Masters, Bill of Materials, and EWM stock.
2015-2022
Analytics Senior Consultant
Exxon Mobil US / Disys Brazil
I contributed to several data migration projects, utilizing SAP Data Services, LSMWs, and IDocs. Upon the successful completion of these projects, my performance and expertise were recognized by Exxon Mobil, who extended an offer for a permanent position. In this role, I integrated into their downstream team, where I was responsible for developing data solutions using SAP HANA, Calculation Views, SDI, and Flow Graphs.
QUALIFICATIONS
2025
Certification
dbt
dbt Analytics Engineering Certification
2024
Certification
Snowflake
Snowflake SnowPro Core Certification
2020
Training
SAP
Data Migration to SAP S/4 HANA - New Implementation Scenario
2015
Certification
IBM DataStage
IBM Certified Solution Developer - InfoSphere DataStage v9.1
2009
Certification
SAP Data Services
SAP Business Objects Certified Professional - BODI XI
2004-2008
Bachelor's Degree
UNIVERSITY
Computer Information Systems
CLIENTS
Some of the clients I have worked with on data-driven projects.
SKILLS
Snowflake - Certified
SAP Data Services - Certified
Power BI - Advanced
WhereScape RED - Advanced
Microsoft Azure - Advanced
SAP LSMW, IDocs, LTMC - Intermediate
IBM DataStage - Certified
dbt - Certified
IBM StreamSets - Expert
Python - Advanced
Microsoft SSIS - Intermediate
Coalesce - Expert
Microsoft Fabric - Advanced
TECH
EXPERTISE
Data Engineering
My core strength and primary area of experience, including
comprehensive skills in designing, implementing, and optimizing data engineering processes. I have strong coding and SQL skills.
Data Migration
I have extensive experience in migrating data across various platforms, including both SAP and non-SAP systems, ensuring seamless transitions and data integrity.
Data Analysis
I'm proficient in delivering high-value analytical reports using Power BI, with a strong ability to translate complex data into actionable insights for enhanced business
understanding.
PORTFOLIO
Dental Clinic Report
This portfolio showcases an end-to-end analytical solution, demonstrating the type of product I can deliver. I created a Power BI report that provides analytical insights for a fictional dental clinic business. What sets this solution apart is that I configured all the necessary Azure resources, ETL processes, and even generated the source data using Python, rather than relying on pre-existing data samples.
The platforms and software used in this solution include Python, Azure, Snowflake, dbt, Git and Power BI. ​Chech the details below:
-
First, all the data was randomly created using Python.
-
Then, the data was uploaded to a Microsoft Azure Blob container and automatically ingested into Snowflake using Snowpipe.
-
Once the data was in Snowflake, I used dbt to transform it into a dimensional model.
-
Finally, the data was analyzed and presented using Microsoft Power BI.
