HNHacker News
TopNewBestAskShowJobs

polivier

453 karma · joined April 1, 2021

Philippe Olivier

PhD in computer engineering, specializing in optimization and operations research: mixed-integer programming, constraint programming, etc.

Resume: https://github.com/PhilippeOlivier/curriculum-vitae/blob/main/OLIVIER_Philippe_CV_en.pdf

Available for hire: https://www.pedtsr.ca/work.html

Blog: https://www.pedtsr.ca

---

meet.hn/city/ca-Montreal

Socials: - github.com/philippeolivier - linkedin.com/in/philippeolivier

---

submissionscomments
polivier··on Show HN: Huewords, a Word and Logic Puzzle
I wrote a constraint programming model to solve this game. For those interested: https://github.com/PhilippeOlivier/huewords-solver
polivier··on Ask HN: Freelancer? Seeking freelancer? (June 2024)
SEEKING WORK | Canada | Remote

I have a PhD in computer engineering, focusing on operations research (OR). I specialize in developing solutions to OR problems and advising on OR matters for startups and small companies. In other words, I can translate real-world problems into mathematical models that can be solved via integer programming, constraint programming, or other optimization methods. I can implement and provide a production-ready solution for any type of problem you might have related to OR: scheduling, routing, etc.

Recent work includes an optimization model for the selection of indexes in Postgres: https://pganalyze.com/blog/index-advisor-v3

Résumé/CV: https://github.com/PhilippeOlivier/curriculum-vitae/blob/mai...

Website: https://www.pedtsr.ca

polivier··on Ask HN: Who wants to be hired? (June 2024)
Location: Canada

Remote: Only

Willing to relocate: No

Technologies: Various optimization tools (CPLEX, Gurobi, OR-Tools, etc), Python, C++, Bash, Linux, and others

Résumé/CV: https://github.com/PhilippeOlivier/curriculum-vitae/blob/mai...

Website: https://www.pedtsr.ca

Email: See CV or website

I have a PhD in computer engineering, specializing in operations research. I can translate any real-world problem into a mathematical model that can be solved via integer programming, constraint programming, or other methods. I'm the father of four young children, so I'm looking for flexible/remote part-time work. I'm also open to contract work (see my comment in the "Freelancer? Seeking freelancer?" thread for more details).

polivier··on The $21B influencer industry has gone off the rails
A colleague of mine is dating a local influencer. She is well enough known that they get stopped on the street on a semi-regular basis. About a year back, an air carrier gave her two plane tickets, a stay in a high-end hotel for 1 week (or 2?) and some cash, in exchange for a 30s clip that had to make an off-hand mention of them (the air carrier) once. Crazy stuff.
polivier··on Ask HN: Freelancer? Seeking freelancer? (May 2024)
SEEKING WORK | Canada | Remote

I have a PhD in computer engineering, focusing on operations research (OR). I specialize in developing solutions to OR problems and advising on OR matters for startups. In other words, I can translate real-world problems into mathematical models that can be solved via integer programming, constraint programming, or other optimization methods. I can implement and provide a production-ready solution for any type of problem you might have related to OR: scheduling, routing, etc.

Recent work includes an optimization model for the selection of indexes in Postgres: https://pganalyze.com/blog/index-advisor-v3

Résumé/CV: https://github.com/PhilippeOlivier/curriculum-vitae/blob/mai...

Website: https://www.pedtsr.ca

polivier··on Ask HN: Who wants to be hired? (May 2024)
Location: Canada

Remote: Only

Willing to relocate: No

Technologies: Various optimization tools (CPLEX, Gurobi, OR-Tools, etc), Python, C++, Bash, Linux, and others

Résumé/CV: https://github.com/PhilippeOlivier/curriculum-vitae/blob/mai...

Website: https://www.pedtsr.ca

Email: See CV or website

I have a PhD in computer engineering, specializing in operations research. I can translate all kinds of real-world problems into mathematical models that can be solved via integer programming, constraint programming, or other methods. I'm the father of four young children, so I'm looking for flexible/remote part-time work. I'm also open to contract work (see my comment in the "Freelancer? Seeking freelancer?" thread for more details).

polivier··on Tips on how to structure your home directory (2023)
I have found it surprizingly difficult to categorize my files in a way that is elegant and intuitive. I've been meaning to look into FUSE for a tagging-based system instead of the current hierarchical one, although I suspect that the difficulty of categorizing things is unlikely to go away even with tags.
polivier··on Show HN: PostgreSQL index advisor
If anyone has some background in optimization and is interested in the more technical side of things, I gave a talk at JOPT 2023, comparing MIP and CP approaches for this problem. The slides can be found here: https://github.com/PhilippeOlivier/jopt2023
polivier··on Here's a puzzle game. I call it Reverse the List of Integers
The number of variables is not constant in each step so modeling this would be trickier than usual. I feel like there is probably an more efficient DP approach for this though.
polivier··on Ask HN: Freelancer? Seeking freelancer? (April 2024)
SEEKING WORK | Canada | Remote

I have a PhD in computer engineering, focusing on operations research (OR). I specialize in developing solutions to OR problems and advising on OR matters for startups. In other words, I can translate real-world problems into mathematical models that can be solved via integer programming, constraint programming, or other optimization methods. I can provide solutions for any type of problem you might have related to OR: scheduling, routing, etc.

Recent work includes an optimization model for the selection of indexes in Postgres: https://pganalyze.com/blog/index-advisor-v3

Résumé/CV: https://github.com/PhilippeOlivier/curriculum-vitae/blob/mai...

Website: https://www.pedtsr.ca

polivier··on Ask HN: Who wants to be hired? (April 2024)
Location: Canada

Remote: Only

Willing to relocate: No

Technologies: Various optimization tools (CPLEX, Gurobi, OR-Tools, etc), Python, C++, Bash, Linux, and others

Résumé/CV: https://github.com/PhilippeOlivier/curriculum-vitae/blob/mai...

Website: https://www.pedtsr.ca

Email: See CV or website

I have a PhD in computer engineering, specializing in operations research. I can translate all kinds of real-world problems into mathematical models that can be solved via integer programming, constraint programming, or other methods. I'm the father of four young children, so I'm looking for flexible/remote part-time work. I'm also open to contract work (see my comment in the "Freelancer? Seeking freelancer?" thread for more details).

polivier··on Solving domino fit using constraint programming
Well done! My CP formulation is definitely not the best here. I put this model together late one night while drinking a few beers :)
polivier··on Solving domino fit using constraint programming
All my CP-related blog posts show a step-by-step formulation of the model. Here is an example showing my thought process while modeling the generation of crossword grids using CP (note that this is substantially more complex than the Domino Fit model): https://pedtsr.ca/2023/generating-crossword-grids-using-cons...
polivier··on Solving domino fit using constraint programming
This is a solver for the game Domino Fit that was talked about on HN last month: https://news.ycombinator.com/item?id=39420966
polivier··on Nomic
I've been reading about Nomic for ~15 years now, but I've never played a game. It seems somewhat difficult to get enough motivated players to participate. I'm interested in playing though. Maybe we could try to put something together? My contact info is in my profile.
polivier··on Ask HN: Who wants to be hired? (March 2024)
Location: Canada

Remote: Only

Willing to relocate: No

Technologies: Various optimization tools (CPLEX, Gurobi, OR-Tools, etc), Python, C++, Bash, Linux, and others

Résumé/CV: https://github.com/PhilippeOlivier/curriculum-vitae/blob/mai...

Website: https://www.pedtsr.ca

Email: See CV or website

I have a PhD in computer engineering, specializing in operations research. I can translate all kinds of real-world problems into mathematical models that can be solved via integer programming, constraint programming, or other methods. I'm the father of four young children, so I'm looking for flexible/remote part-time work. I'm also open to contract work (see my comment in the "Freelancer? Seeking freelancer?" thread for more details).

polivier··on Ask HN: Freelancer? Seeking freelancer? (March 2024)
SEEKING WORK | Canada | Remote

I have a PhD in computer engineering, focusing on operations research (OR). I specialize in developing solutions to OR problems and advising on OR matters for startups. In other words, I can translate real-world problems into mathematical models that can be solved via integer programming, constraint programming, or other optimization methods. I can provide solutions for any type of problem you might have related to OR: scheduling, routing, etc.

Recent work includes an optimization model for the selection of indexes in Postgres: https://pganalyze.com/blog/index-advisor-v3

Résumé/CV: https://github.com/PhilippeOlivier/curriculum-vitae/blob/mai...

Website: https://www.pedtsr.ca

polivier··on Planner programming blows my mind
No I haven't, but in our case CP-SAT works very well and license-wise it's free.
polivier··on Planner programming blows my mind
I think that you've misunderstood what I said. For large instances of this specific problem (and when the time limit is too short to allow either CP-SAT or CPLEX to prove optimality) the best integer feasible solution found by CP-SAT is generally of better quality (w.r.t. the objective value) than the best integer feasible solution found by CPLEX. Furthermore, in some cases, CP-SAT can offer a certificate of optimality faster than CPLEX.
polivier··on Planner programming blows my mind
> There are plenty of commercial solvers out there that beat the pants off the open source options in terms of performance and in terms of depleting one's wallet :)

While this is generally true, there are some exceptions. I recently compared the performance of CP-SAT vs CPLEX for a problem (linear constraints and objective). For large instances where proving optimality in a reasonable time was out of the question, CP-SAT had much faster convergence to near-optimal solutions than CPLEX when the time limit was small enough (~30s to a few minutes). This is with the CPLEX solver tuned towards improving the upper bound as much as possible (it was a minimization problem).

polivier··on Planner programming blows my mind
It is possible that something like CP-SAT (https://developers.google.com/optimization/cp) would have scaled well in your case. This solver easily handles an absurd amount of variables and constraints, and has excellent heuristics built-in.
polivier··on Planner programming blows my mind
For those interested, HN user hakank (Hakan Kjellerstrand), who is a very active member of the constraint programming community (among others), has a ton of Picat resources and examples on his website: http://www.hakank.org/picat/
polivier··on Ask HN: Who wants to be hired? (February 2024)
Location: Canada

Remote: Only

Willing to relocate: No

Technologies: Various optimization tools (CPLEX, Gurobi, OR-Tools, etc), Python, C++, Bash, Linux, and others

Résumé/CV: https://github.com/PhilippeOlivier/curriculum-vitae/blob/mai...

Website: https://www.pedtsr.ca

Email: See CV or website

I have a PhD in computer engineering, specializing in operations research. I can translate all kinds of real-world problems into mathematical models that can be solved via integer programming, constraint programming, or other methods. I'm the father of four young children, so I'm looking for flexible/remote part-time work. I'm also open to contract work (see my comment in the "Freelancer? Seeking freelancer?" thread for more details).

polivier··on Ask HN: Freelancer? Seeking freelancer? (February 2024)
SEEKING WORK | Canada | Remote

I have a PhD in computer engineering, focusing on operations research (OR). I specialize in developing solutions to OR problems and advising on OR matters for startups. In other words, I can translate real-world problems into mathematical models that can be solved via integer programming, constraint programming, or other optimization methods. I can provide solutions for any type of problem you might have related to OR: scheduling, routing, etc.

Résumé/CV: https://github.com/PhilippeOlivier/curriculum-vitae/blob/mai...

Contact me: https://www.pedtsr.ca/work.html

polivier··on Ask HN: Freelancer? Seeking freelancer? (January 2024)
SEEKING WORK | Canada | Remote

I have a PhD in computer engineering, focusing on operations research (OR). I specialize in consulting and advising on OR matters for startups. In short, I can translate a real-world problem into a mathematical model that can be solved via integer programming, constraint programming, or other optimization methods. My goal is to provide a production-ready solution for any type of problem you might have related to OR.

For example, I've been contracted by a company to create a user-tunable, multi-objective optimization model for the automatic selection of indexes in Postgres databases.

Résumé/CV: https://github.com/PhilippeOlivier/curriculum-vitae/blob/mai...

Contact me: https://www.pedtsr.ca/work.html

polivier··on Mindustry: Open-source automation tower defense game
Mindustry is such a great game. I sunk tons of hours in both campaigns with a friend of mine.

For those who come from a Factorio background, Mindustry has less automation and more combat. Also a Mindustry map does not take 50 hours to complete; rather it will take a few hours and may sometimes take several tries as some maps can be fairly hard. Space is limited as compared to Factorio, so space-efficient designs do matter, especially for defense (you want to pack towers tightly, with the constraint that towers must be fed by a conveyor of ammo or a pipe of liquid, or both). You also need to consider that you often need different combinations of towers in order to defeat different types of enemies.

Overall, a very well-made game and very addictive.

polivier··on Microsoft nears glass storage breakthrough; could make ransomware attacks harder
I think that was the joke.
polivier··on Ask HN: Freelancer? Seeking freelancer? (December 2023)
I understand that there is a lot of hype around ML/DL, but that is not really my field of expertise, and I don't want to oversell my skills :) Optimization solves tons of really interesting real-world problems, though.
polivier··on Ask HN: Freelancer? Seeking freelancer? (December 2023)
SEEKING WORK | Canada | Remote

I have a PhD in computer engineering, focusing on operations research (OR). I specialize in consulting and advising on OR matters for startups. In short, I can translate a real-world problem into a mathematical model that can be solved via integer programming, constraint programming, or other optimization methods. My goal is to provide a production-ready solution for any type of problem you might have related to OR.

As a recent example, I've been contracted by a company to create a user-tunable, multi-objective optimization model for the automatic selection of indexes in Postgres databases. This tool will be available for their clients starting this fall.

Résumé/CV: https://github.com/PhilippeOlivier/curriculum-vitae/blob/mai...

Contact me: https://www.pedtsr.ca/work.html

polivier··on Ask HN: Who wants to be hired? (December 2023)
Location: Canada

Remote: Only

Willing to relocate: No

Technologies: Various optimization tools (CPLEX, Gurobi, OR-Tools, etc), Python, C++, Bash, Linux, and others

Résumé/CV: https://github.com/PhilippeOlivier/curriculum-vitae/blob/mai...

Website: https://www.pedtsr.ca

Email: See CV

I have a PhD in computer engineering, specializing in operations research. I can translate all kinds of real-world problems into mathematical models that can be solved via integer programming, constraint programming, or other methods. I'm the father of four young children, so I'm looking for flexible/remote part-time work. I'm also open to contract work (see my comment in the "Freelancer? Seeking freelancer?" thread for more details).

← PreviousPage 3 of 5Next →