Oleksandr Kashchavtsev

Data sources processing:
— Databases: Oracle, Microsoft SQL, Microsoft Dynamics 365
— Static data sources: CSV files, Excel files, MS SharePoint
— Composing complex database queries: data filtering, grouping, sorting, tables joining, common table expressions (CTEs), window functions

Power BI Dashboards development:
— Power Query M expressions to transform incoming data sources
— DAX expressions
—

Automatic generation of the semantic layer in Looker:
— Parsing data contract created by the data producer. The data contract contains all the Looker project settings, dimensions, measures, and joins.
— Generating LookML project structure that hosts all required views (both primary and joined), explores, models, and manifest file.
— Generating dynamic Liquid logic required in LookML code.
— Syncin

— Active involvement in data analysis solutions on all stages (Requirement Gathering, Scoping, and Development, Maintenance) of the project, using adopted BI technologies of the BI Team.
— Use business intelligence software to design, create, and deliver reports and dashboards that meet to Definition of Done by each project.
— Build end-to-end analytic solutions, including QlikView ETL pipelines,

— Composing / modifying / optimizing QlikView data reload scripts.
— Designing data import from corporate products (keysurvey.com, form.com) and external systems.
— QlikView data models development.
— Designing reports layout (creating and modifying objects using complex formulas, set analysis, variables, triggers, bookmarks, alternate states, etc.).
— Data visualization in QlikView reports using

QlikView development:
— Getting data from corporate database or external sources (i.e., SimilarWeb) in appropriate form.
— Creating reports layout, filtering settings, data visualization.
— QlikView reports are used by wide range of end-users: senior management, marketing department, sales department, training department, technical support department, clients, online media readers etc.

QlikView S

Responsibilities:
— developing new business processes and modifying existing ones in cooperation with other departments of the company;
— developing schemes of new and existing business processes;
— composing specifications for programmer on making changes in 1C 8.2 system according to new business processes in company;
— developing new user interfaces in 1C 8.2 system, improving usability of exis

— Collecting passenger flow data
— Analysis of the city public transport passenger traffic
— Developing recommendations on optimization of the public transport route network
— Justification of using new vehicles on city routes (quantity of vehicle units, schedule, costs calculation, tariff calculation)

Feb 2022