Position: Data Analyst
Category: SQL
English level: fluent
Years of experience: 1

You can check out my work at kaggle.com
Profile: xenexx
“BrightHouseUA”, Odesa, Ukraine — Instagram Shop
February 2021 - June 2023
Applied XLOOKUP and multiple aggregation functions to create an auto-updating spreadsheet. 
Used Meta Ads to analyze advertisement campaigns and promote products on Instagram with a total reach of 70,000 users weekly.
Managed and standardized multiple spreadsheets like client base, inventory, and accounting book.
Philip Morris Ukraine, Odesa, Ukraine — Internship, Data Analyst
June 2023 - Present
Using Power BI prepared user-friendly visualizations for the gamification project. Analyzed, cleaned, and created metrics through Power Query and DAX

First, I have achieved the Google Data Analytics Professional Certificate. During the 6-month course, I learned to clean, analyze and visualize data using different tools.
Used SQL queries and spreadsheets to clean and fillet data. 
Build code in R to analyze and visualize data in my case study.
Illustrated data using Tableau, Excel, and Looker Studio.

But most importantly, I have applied my new skills to my business problems. I have built new Excel spreadsheets using multiple aggregate functions, conditional formatting, and other functions. Using the LOOKUP function, I have automatized many processes that I used to do manually. Currently, I am working on the macro that would complete most of my job in Excel. 

At this point, I have finished three case studies that showcase my analytical skills. All of them are applied to find real-world solutions. For example, one of my works demonstrates the difference between two groups of customers for the company based on their use of the products, age, gender, etc. Another case project demonstrates how we can improve customers' experience based on the information from smart devices. All of my case studies use varieties of tools like Excel, SQL, R, Power BI, and Tableau. You can find links to my case studies in the list of my projects or on my LinkedIn. 

Last month I achieved another certificate - Data Analyst Associate Certificate. This time I have sharpened my hard skills in SQL and Excel to the point that I feel confident about my knowledge. It is just the beginning. I am enrolled in the Data Analytics course at the DataCamp, where I am expanding my skills in Python.

Currently, I am a part of the Philip Morris Internship Program where I assist in the gamification project as a Data Analyst. My responsibility is to create visualizations in Power BI and enhance user experience.
Young and friendly team. Ability to improve and apply my hard skills. Remote work. Opportunity for growth.