Position: Data Analyst, BI Analyst, Power BI Developer
Category: Data Analyst
English level: intermediate
Years of experience: 6

- Developed reports on Power BI, Oracle BI using Power Query, DAX language, SQL scripts, worked with DWH.
- Controlled the implementation of KPI on the main parameters of the company. 
- Collaborated with the IT department in the process of coordinating the formation of tables and calculations in DWH.
- Created mathematical models for setting sales plans for the sales department.
- Developed a data model in DAX, which was used to set tasks/plans for the sales department for a certain reporting period, display the trend, and track each stage of the KPI.
- Developed a project to implement a database of an external accounting system, and created a DAX model that combined company data with external data.
- Participated in a project to transfer reports to another company, accepted more than 50% of all reports.
- Daily, weekly and monthly reports are generated.
- For colleagues 2 months taught lessons in writing SQL scripts.
- Wrote more than 20 terms of reference for the development of new reports.
- Prepared presentations (automatic updates) on the company's key performance indicators.
- Implemented a project to develop reports on the Oracle BI platform (it was my idea).
- Received a promotion (specialist, junior analyst, analyst).
Work as a data analyst in the alcohol holding Global Spirits, in the field of telecom operator Vega, as well as in the field of watching football matches.

Highlights:
* Developed automated reporting of the company.
The latest software is used for their development and maintenance.
* He took part in the transfer of all reporting of the company, which passed into our management.
* Accepted the reporting of another company (passed into our management). 
Skills that were needed for this job: knowledge of writing SQL scripts, DAX language, VBA.

Reworked all commercial reporting:
-- Experience in implementing more than 200 different reports.
-- Skills in building automated reports and dashboards with the help of Power BI, Oracle BI, Power View.
-- Practical experience with OLAP, MS SQL, Power Query, MDX, Power BI, DAX tools and systems.
-- Practical experience in building and implementing a B2B, B2C sales funnel.
-- Creation of a new database of tax invoices and creation of working reporting.
-- Strong knowledge of database fundamentals such as multidimensional database design, relational database.
-- For six months, provided data in the form of reports on watching football matches. Provided data to foreign management.