Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
OxagileLooker Engineer
May. 2021Automatic 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.
— Syncing generated structure with Looker's Git project.
— Setting up new or modifying existing Looker project, altering its settings if needed.
— Launching LookML validator programmatically to check if there are any errors in LookML code.
— Configuring Looker model automatically.
— Deploying Looker project to production. The new BI system based on Looker for the global software platform focused on digital media measurement, data, analytics, brand safety, and performance:
— Scoping of the new reporting platform with a customer.
— Analyzing data structures in Snowflake DWH, connecting Looker to the DWH using SQL and LookML queries.
— Arranging dimensions and measures with a customer and implementing them in Looker.
— Creating LookML views, explores, models, and dashboards as per client's requirements.
— Implementing data drill-in features into dashboards and explores.
— Using native and SQL-based derived tables while building Looker data models.
— Implementing incremental data updates via persistent derived tables (PDT).
— Setting up user access logic using access grants and user attributes.
— Version control in GitLab.
Form.comSenior QlikView Developer
Feb. 2019 - Apr. 2021— 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, integrations between different data platforms, and business intelligence visualizations.
— Take part in code reviews and suggest optimization options for improved maintenance and performance where possible.
— Take part in defining code requirements, best practices, and template library discussions and implementation with the team.
— Implement automatic data load errors handling system for all projects.
— Improve incremental reload logic in line with core platform development.
— Technical assistance for development and QA members within the scope of ongoing and maintained solutions.
— Support and guidance work with Project Managers and stakeholders on the proposed solution structure and necessary components for successful delivery.
— Analysis of existing and upcoming technologies and new releases for data analytics tools and presenting the required tools/changes to company teams.
— Support operations by identifying, researching, and resolving performance and production issues.
Form.comQlikView Developer
Sep. 2016 - Jan. 2019— 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 filters, pivot tables, charts.
— Managing QlikView reports automatic reload and distribution on the QlikView server.
— Managing user access via Section Access / on server level.
— Understanding client’s business logic and the best ways of its reflection in BI solutions.
— Working with clients on preliminary scoping and dashboard architecture
— Writing technical specifications for the developed dashboards (instructions for the end-users, manuals for QA).
— Optimizing dashboards for better performance.
— Reviewing dashboards with legacy back-end or front-end.
— Implementing ETL logic in the data reload process.
— Tracking development process in the GitLab versioning system.
eScore TechnologiesBusiness Intelligence Engineer
Dec. 2013 - Sep. 2016QlikView 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 Server administration: distributing documents to end-users, setting up reports autoupdate, user access rights. Large datasets aggregation and analysis: receiving raw data from MySQL database, further analysis using QlikView, MS Excel (VBA, Pivot Tables, PowerPivot). Analytical reports and articles composition (used on a corporate site and distributed via online media).
Галерея Мобильной СвязиBusiness Analyst
Aug. 2010 - Dec. 2013Responsibilities:
— 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 existing ones;
— testing specifications developed by the programmer, working with programmer on fixing bugs during software development;
— consulting 1C8 end-users on all questions related to the system functioning (office staff consulting, sales managers remote consulting, composing manuals for end-users);
— analysis of online stores effectiveness (website traffic data from Google Analytics analysis, automation of data download from Google Analytics, costs of online stores promotion analysis, analysis of online stores profitability indicators);
— developing the purchase need model, which automatically creates the list of goods, which need to be purchased from external contractors, basing on such requirements as goods distribution between retail stores, actual surpluses and provisions at stocks, purchasing volumes of previous periods, purchase and wholesale prices;
— developing the goods balance volume at company remote stocks (transit stock model);
— tasks on primary processing and further analysis of large data sets obtained from accounting system 1C 8.2.
Kharkiv MetroPassenger Traffic Analyst
Feb. 2010 - May. 2010— 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)
Intch is a Professional Networking App for the Future of WorkSee more people like Oleksandr on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
489368 people
22
C++ / iOS / Flutter / Go developer @ Teramind
15
Director @ Inclusive IT
17
Senior Software Engineer
75970 people
19
CEO @ Code-Construct
19
CEO @ Lonch
15
Software Developer @ Conscensia