Ольга Гонца

Greetings!

Data is my passion.
I know that one of the strongest business pain is: a lot of data but no information.
I believe that my job is to make clear, easy understandable information that will help you to achieve your business goals.

Some technical details:
- Visualisation tools (Power BI - high level. I'm good in DAX, Power Query, data transformation, data model building.
- SQL - high level.
- Python (working with data) - middle level.
- ETL tools (MS SSIS) - junior level.
- MS Excel - high level.

Domains:
- 10 + years of e-commerce experience
- 5 + years of horeca experience
- 1 + year in GIS
- deep understanding of financial/economic business indicators

I'm very responsible, result-oriented person. Extremely quick learner - I work on my qualification every day.

My previous job positions:

march 2024 - now Business Intelligence Analyst (Sunrise food)

Executing local business intelligencce projects.
 Callcenter dashboard:
-row data about calls
- row data with client`s chats
- getting data fromdifferent API, transforming with M and Power Query
- building data model in Power BI
- calculating different metrics for estimation the efficiency of callcenter operators
- developing the dashboard in Power BI 

august 2023- march 2024 Junior Software Developer (EMNOTION Ltd)

EMNOTION - start-up that investigates and forecast climate.
- devepoling web-application for customers, where they can see climate forecast, validation. (MS SQL, Python libraries: SQLAlchemy, numpy, pandas, dash, plotly)
- getting data, data processing for mathemathicians different queries (pandas, numpy, SQLAlchemy)
- diferent SQL tasks (writing scripts for getting, inserting, indexing, copying data)
- different tasks like getting data from geo portals by API, putting the data to SQL db.

march 2023- august 2023 Power BI Developer (EMNOTION Ltd)

- Power BI dashboards development (UX/UI, DAX, mobile version, data model)
- Power BI administration (PB service, user roles/access)
- SQL DB maintain - according to Power BI optimal data model
- Python scripts writing - connection to different API services
- Python dashboards development