09/06/2022 updated
100 % available
BI Analyst
Krasnodar, Russian Federation
Russian Federation
Master's in Big Data and Business Intelligence,Hospitality and TourismMicrosoft ExcelGoogle DocsPostgreSQLMicrosoft SQL ServersMicroStrategySAP ERPMicrosoft Power BISQL DatabasesSQL Server Integration ServicesSalesforce TableauSQL Server Management Studio (SSMS)
Primary hard skills:
BI: Tableau (Desktop, Prep Builder, Server), Power BI (Power Query, Dax)
DWH: SSMS, PostgreSQL, SSIS, Microstrategy DWH
Excel, Google Sheets, SAP ERP
BI: Tableau (Desktop, Prep Builder, Server), Power BI (Power Query, Dax)
DWH: SSMS, PostgreSQL, SSIS, Microstrategy DWH
Excel, Google Sheets, SAP ERP
Languages
EnglishFluentRussianFluentTurkishGood
Project history
Analytics Specialist at General Data Reporting Department (BI Engineering).
Project-based part-time job:
* Hotel & restaurant chain
* Air Care Solutions Inc
* Analytics Group
* Clean Ducts LLC
Responsibilities:
* Data import and export (MS SQL Server Management Studio, Google Suite).
* Data transformation (Google Sheets, Excel, Power Query).
* Data analysis, search for useful insights for business development.
* Data visualization (Tableau, Power BI).
Key achievements:
* Helped in forming budget for marketing campaigns.
* Identified potentially important areas for further sales.
* Created dashboards for daily tracking of important metrics.
Industries of BI projects: sales & marketing, household utilities, restaurants,
hotels, fintech, blockchain, trading
* Hotel & restaurant chain
* Air Care Solutions Inc
* Analytics Group
* Clean Ducts LLC
Responsibilities:
* Data import and export (MS SQL Server Management Studio, Google Suite).
* Data transformation (Google Sheets, Excel, Power Query).
* Data analysis, search for useful insights for business development.
* Data visualization (Tableau, Power BI).
Key achievements:
* Helped in forming budget for marketing campaigns.
* Identified potentially important areas for further sales.
* Created dashboards for daily tracking of important metrics.
Industries of BI projects: sales & marketing, household utilities, restaurants,
hotels, fintech, blockchain, trading
Responsibilities:
* SQL and Data Mining: retrieving data from different sources using SQL.
Loading data into database, developing ER-diagrams, accomplishing practical
tasks to learn queries: join, except, CTE, view, window function, subqueries,
etc.)
* Analytics and Statistics for Business: basic statistics and analytical tools for
analysis, formulating and testing hypotheses.
* Big Data: general familiarization with noSQL solutions - Hadoop, MongoDB.
Studying and accomplishing practical tasks using such Python libraries as
Pandas and PySpark.
* Metrics, Hypotheses, Growth Points: understanding of Financial, Sales &
Marketing metrics hierarchy and their impact on different types of business.
Familiarization with Google Data Studio and Power BI for reporting.
* Power BI: Data Analysis and Visualization. Working with Power Query, DAX
language and Power BI on real business tasks: importing data from different
sources, data transforming and cleaning, constructing interactive reports and
dashboards for customers.
Key achievements:
* On-time and 100% completion of assigned tasks.
* Receiving excellent marks on diploma projects with the use of SQL, Python
and PBI tools.
Industries of BI projects: sales & marketing, e-commerce, restaurants, airport,
aviation
* SQL and Data Mining: retrieving data from different sources using SQL.
Loading data into database, developing ER-diagrams, accomplishing practical
tasks to learn queries: join, except, CTE, view, window function, subqueries,
etc.)
* Analytics and Statistics for Business: basic statistics and analytical tools for
analysis, formulating and testing hypotheses.
* Big Data: general familiarization with noSQL solutions - Hadoop, MongoDB.
Studying and accomplishing practical tasks using such Python libraries as
Pandas and PySpark.
* Metrics, Hypotheses, Growth Points: understanding of Financial, Sales &
Marketing metrics hierarchy and their impact on different types of business.
Familiarization with Google Data Studio and Power BI for reporting.
* Power BI: Data Analysis and Visualization. Working with Power Query, DAX
language and Power BI on real business tasks: importing data from different
sources, data transforming and cleaning, constructing interactive reports and
dashboards for customers.
Key achievements:
* On-time and 100% completion of assigned tasks.
* Receiving excellent marks on diploma projects with the use of SQL, Python
and PBI tools.
Industries of BI projects: sales & marketing, e-commerce, restaurants, airport,
aviation