QlikView / Qlik Sense Developer

• Aug 2018 - Present

- Designing, creating reports for end users - Creating data queries using SQL and Excel - Conducting basic data analysis for possible discrepancies, errors and performing data cleansing. - Implemented incremental loading to improve loading time. - Implemented a "star" and "snowflake" scheme to speed up the response time of the dashboard - Implemented sending reports by email to PowerPoint and Excel using NPrinting - Developed a QVD reference book with the ability to edit through the Qlik View application - Developed a mobile version of the report on Qlik Sense (HTML) , Css, bootstrap) - Qlik Sense - working with console and hub, developing mashups - Management of access rights to reports and data using Section Access (QlikView, Qlik Sence) - Part of the functions in the dashboard is implemented using macros in VBScript Show less

QlikView Developer

• Oct 2016 - Aug 2018

- creation of loading scripts - optimization, loading / unloading of reports - work with a database of more than 200 million lines - work with QlikView server. Differentiation of access to reports, formation of optimal download chains. - working with Section Access, delimiting the display of report data for different departments / users - using QVD for incremental loading and updating data - collecting and loading data into Qlikview from various data sources (SQL, Oracle, CSV, Excel, SAP files). Show less

Business Analyst

• Apr 2015 - Oct 2016

Direction of activity - distribution of dairy products in the Kyiv region. Main functional responsibilities: - collection, processing and provision of analytical information; - analysis of sales and inventory; - optimization / planning of purchases according to the sales forecast; - sales planning, admin costs for future periods; - support for 1C users; - control of pricing, discounts; - maintenance of the nomenclature reference book, control of data shipment to Spot2D; - preparation of periodic analytical reviews - preparation of data for payroll sales agents; Show less

Analyst

• Jun 2013 - Mar 2015

Functional responsibilities: - optimizing the company's business processes - conducting market research - ranking companies based on the analysis of financial indicators - developing various analytical models in Excel - competitive analysis of enterprises - compiling financial models for evaluation investment attractiveness of the business - work with the statistics database - optimization of inventory management according to the Theory of System Constraints - development of analytical reports in QlikView Show less

Project Manager

• Jun 2012 - Dec 2012

Financial Analyst

• Oct 2009 - Apr 2012

Equity Analyst

• Mar 2008 - Oct 2009

Real Estate Analyst

• Sep 2006 - Feb 2008

Stock Market Analyst

• Sep 2005 - Sep 2006