Ladislas The Analyst
Portfolio

Financial Analyst well versed in SQL, Python, HTML - @Ladislas.Pham

Automate the emission of invoices
With Python

In this project I created a bot to automate a repetitive and annoying task.

Description

As responsibilities and product exclusive expertise were pilling up, the workload of my job was constantly heavier.
Thanks to some research and a friend ́s insight, I saw the opportunity to lighten my operative burden by automating a highly manual task of relatively low additional added value.
At that time, the company was getting about 100 new purchases per week; an invoice had to be generated and sent for each.
I decided to establish an ambitious target, take 1 full day and a half to automate the process.
After learning how to use Selenium to get into a Brazilian government ́s website with a bot, I manage to hit the target with a 2-hour delay.
The code of the automation is at the bottom.
It contains scrapping technics, a loop to repeat the process, and actions such as reading and cutting a URL link.

Bulk personnalized emails
With HTML and Javascript

Using Google Script, I sent effortlessly personalized emails to all of our customers with an upcoming due payment.

Description

Seven days before the instalment due date, we had to send an email to each client as a reminder of the purchase previously done.
The email was highly personalized with information of the clients such as the name and the id of the company, and information about the purchase as the overall price, the number of installments, the place it was executed and other variables.

Financial operation tracker
With SQL

This is the most advanced piece of SQL I have dealt with. It´s used to track and analyse financial performances.

Description

This query goes and fetch all the necessary financial pieces of information that the company needs to operate and take adapted decisions.

Top Business news
With Python

I created a shortcut on the desktop of my professional computer to get the 10 main business headlines of the US.

Description

With my growing envy to be up to date easily with what is happening in the world, I decided to onboard on a small project that would retreive the main business headlines from an app on my computer desktop.
I used the amazing NewsApi tool to get to the desired result. Then i had to create a simple tkinter interface to present the final UI.

Address

Brazil, France

Phone

+55 (11) 94393-3366

Email

ladpham@gmail.com

Social