UBS Web Automation Developer

Oleksii Gavrylenko

Data Scraper
Data Analyst
Data Engineer
Microsoft Power BI
Oracle SQL
Python
UBS Capital Americas

My relations with UBS

How did I come across UBS?

Before I came across UBS, I was working as an individual, developing scripts and automation solutions for a streetwear company that used to create automated solutions to provide its users with more options and up-to-date information.

What does it look like from inside?

Generally speaking, it was quite a good experience; the people there are kind and welcoming and could help and assist if any unexpected issues pop up. The environment, salary, and HR are the topics that are most interesting about this project.

Team

The team there was on another level. 95% of the people I worked with there were kind, smart, and creative, which allowed us to create unique and desired solutions. These solutions helped hundreds of people optimize their processes and gain data faster and in a more reliable way.
During the time I was there, I worked in or with different departments, which allowed me to grow my technical experience in various ways.

Environment

If I were to characterize the environment at UBS, I would say "slow" and "fragile". Even though the company does its best to create unique and innovative solutions, they are mostly blocked by the internal policies, which are needed, but I wouldn't say that they are that much needed in many fields. Your every move requires acceptance by someone above you, and it can take some time (sometimes up to two weeks). It changes, but because of the number of people who have the time and knowledge to change the system, new solutions can quickly become outdated in the outside world.

Salary

I wouldn't say the salary was competitive, but it could change from time to time. You can also change teams, which can lead to advancement in the pay received. Half of the main changes are done by interns; seniors are busy complying with security and risk standards.

HR

This is the topic that I don't like and the reason I left UBS. Not by choice, if you ask. I was on an intern contract for 1.5 years and was receiving an hourly rate that was the maximum at the company but fairly low if you compare it to other tech positions out there. My contract was ending and the company wouldn't give me a normal contract just because I haven't finished the university by the time (4 months were left), and they couldn't renew the existing one (becaue of the policies inside of the company). Worth mentioning that my team tried its best to leave me in the company and was very satisfied with my performance.

It is what it is...

Technologies I used

Because of the fact I worked at this position the most, I gained the most experience from it and worked with many languages and programming environments.
Here are the technologies I came across:
Python
JavaScript
TypeScript
JWT token authentication
VBA
Linux
GitLab
Power BI

What tasks did I do?

At first, I was gaining experience and becoming familiar with the team and environment. UBS offers free Udemy courses, which did indeed help me, but later I had almost no time to take them. Keep in mind that I was in the last year of my university degree and was actively writing my diploma.

React Web Page

Me and my team created a fully React-based interface for the web app called Copernicus, which was previously hosted with the web2py framework. At first, we used JavaScript, but then switched to TypeScript for more reliable and secure behavior.

Bing Maps Integration

I've also worked on integrating Bing Map with the data I collected about World Wide Exchanges (all available exchanges), which I used to search for information about holidays, operating hours, addresses, and coordinates. This was an interesting project, which mainly relied on the representation of the data I received from the API endpoint, which I created, and a bunch of conditions to display this data.

VBA Excel Outlook

To help a friend of mine at UBS send emails and save a bunch of time for workers that were below my level, I created a solution for automated email sending based on the data in an Excel sheet and variables specified by the user that runs the program. I was constantly updating the script and adding more error handling and functionality, so in the end, we had a pretty reliable solution that could be used across the company.

Power BI Workplace

There was a brief moment that I worked with Power BI, when I managed to learn that tool and create our first workplace. The project eventually got bigger, and more developers stepped in.

Tableau to SQL db

I automated Talbeau authentication and data collection to transfer different tables from Tableau to our local database, which was needed to constantly refresh the data in our table based on the changes in Tableau.

Is there anything specific I am proud of?

Yes, everything I've created. If I'm not proud of my work it means I haven't perfected it.
Partner With Oleksii
View Services

More Projects by Oleksii