2021 - ongoing: Automate weekly singleview report on the status of all of NBI operations

Role: AWS Data Architect

Customer: National Broadband Ireland, Dublin, Ireland (100% remote)

Tasks:

Use AWS Athena to report all metrics from all systems supporting the design, build and operation of the NBI network. In addition typically ERP data like finance and HR and Salesforce for marketing. This involved...

• Reverse engineer the logic from the snapshots that are copied to the data lake daily for design, building and operation of the network using Athena
• Build semi-automatically interfaces to ERP and marketing systems.
• Weekly reconciliation and explanation of the numbers with all stakeholders.

Skills:

Systems: AWS, SQL, S3, Athena and Tableau

2023 - 2024: Localise global Data Vault implementation, Consolidating the merged company onto Snowflake/Databricks

Role: Snowflake Data Engineer

Customer: Ayvens (former Leaseplan taken over by ALD), Almere and Hoofdorp, Netherlands (Hybrid)

Tasks:

Initially brought on to localize a global Data Vault 2.0 implementation. LeasePlan was a front-runner and needed to consume certain data available only from the global platform but lacked trust in the data quality and the data-vault modeling of the implementation. Worked closely with a Data Vault expert and delivered the localized solution in three months. Based on this successful delivery, I was retained to build the Leaselink and Robnet implementations on the Snowflake platform to combine the data of ALD and LeasePlan. The global Snowflake project was eventually canceled, and the NL branch decided to move to Databricks as their analytics platform I then migrated the Robnet implementation to Databricks. This involved...

• Localized the global Data Vault 2.0 model for the NL and created the data mart with business logic in Snowflake.
• Developed a Snowflake pipeline using Snowpark UDTFs to retrieve raw data from a REST API for Leaselink. Leaselink is a platform for purchasing and delivering cars. The data is used for tracking the KPIs of vendors.
• Created a PoC in Snowflake for Robnet, replicating and reconciling the current Oracle solution. This included flattening a JSON that contains the end-to-end processing and details of all repairs, maintenance, and tire jobs from request, approvals to invoicing.
• The PoC was transitioned into a native Data Vault 2.0 model in Databricks, including replicating the reporting previously done in Oracle. The data is used for tracking KPIs of approvals and garages as well as bonus targets with tire vendors.

Skills:

Systems: Snowflake, Snowpark (Python), Databricks, Data Vault 2.0, GitLab. SQL

2022 - 2023: Analyze and mitigate impact of mass-migration of fixed customers

Role: Sr. AWS Data Analyst

Customer: VodafoneZiggo, Utrecht, Netherlands (Hybrid)

Tasks:

Use AWS Athena and Glue to analyze impact of all data sources consumed by AAP prior to the mass-migration of fixed customers from fixed-stack (Ziggo) to mobile-stack (Vodafone). This involved...

• Analyst impact on over 100 data sources ingested by the AAP platform.
• Re-designed and tested new billing topology data pipeline.

Skills:

Systems: AWS, SQL, pySpark, S3, Athena and Glue

2021 - 2021: Create point in time data for the activity in their app using SQL in Snowflake

Role: Snowflake Data Engineer

Customer: Speakap.com, Amsterdam, NL (100% remote)

Tasks:

Use Snowflake to create history and usage profiles for the users of the platform. To gain more insight in how the user are using the apps and how the usage of the app grows over time. This involved...

• Reverse engineer the usage of the app based on database log that is feed into Snowflake using Kinesis.
• Identify gaps in the architecture (on a data level) that could help improve query times and hence the throughput time in Snowflake.
• Produce around 40 metrics to be shown to customers on the usage in close to realtime and feed them to Posgress for direct consumption in their BI tool that will embed the metrics in their app.

Skills:

Systems: Snowflake, SQL, S3 ( Maria DB, Kafka, Node.js, Postgres and BI application)

2020 - 2020: Testing of BO suite prior to go-live of upgrade

Role: Testing BO

Customer: MVV Energie, Mannheim, DE

Tasks:

Scope of work to test the full functionality of Aligne BO in order to go live with upgraded version. This involved...

• Worked together with key-users in BO to reconcile new versions running in parallel with production.
• Identify gaps in the trade capture between production and parallel version.
• Enabled them to go-live as planned during the lock-down

Skills:

Systems: Aligne | Markets: DE power, coal, gas and emissions.

2017 - 2018: Front office transition for ISEM

Role: Business Analyst

Customer: ESB, Dublin, IR

Tasks:

Scope of work to implement and enable the front office to operate in ISEM. This involved...

• Designed tool to capture and manage the capacity auction results
• Redesigned tool to capture new CFD contracts in ISEM
• Based on intial solution from Baringa. Designed a tool to control and manage pumped storage assets (Turlough Hill Power Station). Prior to ISEM the assets were operated by Eirgrid. In ISEM ESB would control the assts directly themselves. Using Excel as front end and nMarket as backend. The tool incorporate all physical constraints for operating the 4 pumped storage turbines and to facilitate the optimization and control of the assets for the dispatcher.
• Reviewing design for Aigne implementation

Skills:

Systems: Aligne, ABB nMarket, Bid Manager, In-house development | Markets: ISEM

2016 - 2016: Impelment futures portfolio for Power, EUA and Coal

Role: Aligne Consultant

Customer: AET, Bellinzona, CH

Tasks:

Scope of work to implement and enable the organization to trade futures. Prior to the implementation AET did not trade any futures.In addition to the futures implementation we also ensured that all physical power processes (EPEX Spot) would not be impacted. This involved...

• Created cascading process for power futures
• Validate valuations and settlement for futures
• Create margin report for back office and risk
• Modify all reports for front office, risk, back ofice and scheduling

Skills:

Systems: Aligne | Exchanges: EEX, EPEX spot and ICE

2015 - 2015: Upgrade from Zainet to Aligne

Role: Zainet Analyst

Customer: E.On, Coventry, UK

Tasks:

Scope of work regression testing of the new version of Aligne. This involved...

• Regression testing of all Aligne functionality.

Skills:

Systems: Zainet/Aligne

2014 - 2015: Proof of concept

Role: Zainet reporting architect

Customer: E.On, Coventry, UK

Tasks:

Scope of work proof of concept of PnL reporting. This involved...

• Successfully completed a proof of concept for PnL reporting of a large power portfolio.
• Input used to make decisions for future PnL reporting. In the end another solution was selected.

Skills:

Systems: Zainet

2013 - 2014: Migrate power and gas futures portfolio

Role: Aligne Consultant

Customer: Shell Trading, London, UK

Tasks:

Scope of work migrate power and gas futures portfolio from trade type physical to futures. This involved...

• Create migration and reconciliation batches.
• Validate valuations for futures.
• Create an automatic report driven solution for splitting, cascading and physicalization of futures.
• Modify all reports front-office power/gas reports, risk, finance, derivops and gas operations.

Skills:

Systems: Aligne, STP (in-house) | Exchanges: EEX, Endex, ICE, OMIP and Powernext

more Projects on request