Kovalchuk Viktor

§ Development and Formation of analytics in Power BI, Power BI RS
§ Organize and configure the display of analytics on the Report Server
§ Working with SQL databases
§ Creating SQL queries from 1C-Accounting databases 8.3
§ Formation of Management reports according to 1C data with their automatic updating
§ Focus sales, forecasting financial performance
§ Plan-Fact analysis of Procurement and Sales
§ Analysis of Purchase Orders
§ Analysis of the Distribution Market of Ukraine and Manufacturers / Importers in the field of Alcoholic Beverages
§ Creating a "Client Card"
§ ABC and XYZ categorization of existing and market customer base and products
§ Creating "hybrid" reports in Power BI based on data from: 1C, Excel files, Access, sites, etc.

• Developing and shaping analytics in Power BI
• Working with SQL databases
• ETL process control
• Made an analysis (Power BI) of the market of Distribution of Ukraine and Manufacturers / Importers by directions: Plant Protection Products, Seeds, Microfertilizers, Fertilizers and agricultural machinery
• Analysis and ranking of the Ukrainian market by acreage
• Created a customer card
• Categorized existing and market customer bases
• Created an Analytics website on the Sharepoint platform
• Development, optimization and support of management reports
• Analysis of customer orders
• Plan-fact analysis of purchases and sales
• Improvement of existing Financial Analysis and Financial Control
• Created hybrid reports based on data from various sources (1C-Accounting, Excel, Access, websites and others)
• Built library of models and reusable knowledge-base assets to produce consistent and streamlined business intelligence results.

• Optimized and ranked the client base in Power BI.
• Worked with active and passive customer base.
• ABC-analysis of the customer base and product range in Power BI.
• Negotiated with new clients.
• Identification of problem clients, analysis and search for problem solving methods.
• Supervised the work of sales representatives.
• Determined the optimal range and venues for promotions.
• Controlled accounts receivable.

• Control of focus sales.
• Analysis and scheduling of system outlets.
• Work with active and passive customer base.
• Conducted sudden comprehensive on-site inspections of the effectiveness of branches.
• Analyzed the efficiency and increased the efficiency of the routes of sales representatives of branches.
• Made decisions on identified problems of branches.
• Did an analysis of the performance of branches in Power BI.
• Visualized routes of sales representatives in Power BI.

• Enterprise management in the field of wholesale trade in petroleum products.
• Focused teams on developing innovative and cutting-edge approaches at all levels with effective resource allocation and strategic planning.
• Added a new direction to the company's field of activity - wholesale trade in soy seeds of Prograin (Canada)

• Management of the enterprise in the field of wholesale trade in oil products.
• Official representative of NPC "REACOM" Dnepropetrovsk for trade in chelating fertilizers
• For six months increase in profit of the enterprise by 30%