Portrait of me

Portrait of me

Welcome to my personal page! I’m Frank Contrepois, a French/Italian FinOps leader with a passion for cloud technology. With a mix of experience from academia and startups, I have established myself as an expert in both Cloud and FinOps and published several articles. As an AWS ambassador and certified Cloud FinOps professional, I am dedicated to staying at the forefront of my field. I am the Chief Innovation Officer at Strategic Blue.

I have a rich and varied background, having been a part of multiple startups in Italy and the UK, but also having experienced burnout. However, with the help of my supportive wife, Anya, I was able to escape and start fresh on Reunion Island, where I spent a transformative year.

I am a constant learner and share my knowledge through my blog, Zettelkasten, and publications page.

If you want to get in touch or connect, you’ll find all the information you need under the Contact tab.

♦ ♦ ♦

My writing

Getting today and yesterday in AWS Athena (2024)

Interesting links Using Athena from the AWS CLI on Linux Getting today in Athena Getting today in PostgreSQL How to get the metadata of AWS Athena tables Get the number of columns in an AWS Athena table Getting today and yesterday in AWS Athena Dates are always a pain to manage. SQL is no exception with every database doing their way. Today I talk about AWS Athena where the date/time documentation is here, not on the AWS website but the presto one. Read more...

AI and Education: Partnering for Creative Learning Adventures

AI is perfect for discovering kids’ (and adults’) talents and leveraging their amazing creativity. It works like this: We, as parents or teachers, pick a topic. We ask ChatGPT to write an essay on the topic, as a kid of that age would. Yes, you can ask ChatGPT to write as a 6-year-old or a 12-year-old. Print and share the content from ChatGPT with the kids and say, “Your task is to add value to this. Read more...

An AWS pricing website

In 2023 I created aws.frankcontrepois.com a website that generate graphs from AWS pricing data. The data is automatically updated every month. It was also my first time using ChatGPT to create CloudFormation scripts. note: the site is not encrypted because all the data is public and is a little greener by not requiring CPU cycles for useless encryption. Read more...