Istanbul, Türkiye
Experienced analyst and Anaplan developer with experience in business process analysis and automation. I strive for maximum transparency and clarity of actions in the company, elimination of redundant and duplicating processes, and maximum reduction of the influence of the human factor. Developed logical thinking and the desire to drill into data and existing processes allows me to build a clear picture of business unit interconnections and find problem areas in existing data and algorithms.
Development of the Demand planning model 1. System architecture and optimization - Managing predictable products and customers - Combining forecast calculation results for new and rotated products with the main forecast - Creation, organization and management of the data warehouse - Creation of a system of demand planning models by regions and large national clients and connections between data warehouse, planning models, consolidating model and new product's planning model - Creation of customer hierarchy including dinamic large regional customers 2. New functionality - Tool and optimization of the business process for generating, adjusting, comparing and transferring demand forecast to other functions - Tool and business process for generating demand forecast for new products - Tool and business process for generating demand forecast for sales&marketing activities - Tool for rotating products from old to new - Tool for creating an additional non-statistical influence on the forecast - Management of the time of delivery of goods to the client's warehouse in terms of time, product and client with the possibility of manual adjustment - Decrease of forecast by production capacity limits and customer&product prioritization - Tool for promo forecast creation 3. Reporting - Report on the main forecast demand metrics - Detailing of the non-statistical forecast part of demand forecast - Forecast by individual warehouses - Report of new product's forecast
1. Internal projects a. Development of a model for accounting for labor resources on projects - Accounting for available labor resources - Calculation of financial costs for personnel in the context of time and projects - Accounting for personnel employment in the context of plan-fact according to the staffing table and according to real labor opportunities - Recruitment Needs Calculation 2. Pre-sale projects a. Creating a demo model for customer-centric sales analysis - Analysis of key customer indicators (sales volume, revenue, profit, costs, discounts, etc) - Calculation of indicators of importance of customers - Analytics by clients, segments, time, set by kpi b. Participation in the preparation of a demo model for the sales forecast c. Creating a demo model for online sales forecast for the marketplace - Calculation of revenue and costs by time, customers, sales channels 3. External projects a. Development of a promo sales forecasting model - Planning new promotional activities in the context of the client, promo and products - Calculation of the financial efficiency of launched promotional activities - Creation of a mechanism for coordinating planned promotional activities - Integration with existing models and data sources - Creating reports on the effectiveness of launched promotional activities b. Participation in the creation of a sales forecast model i. Setting up a data warehouse, updating, processing and generating master data, delivery to a predictive model
I. Restoration of the lost reporting system: 1) clarification of business processes supported by pre-existing reporting 2) identification of key users of reporting 3) finding out the source and data structure 4) filling in the directories for analytics that are missing in the database in the sections required by the business 5) finding out the most common errors in primary documents and developing methods for smoothing them out in analytical reports 6) standardization of the structure of reports 7) finalization of reports under the changed requirements of the customer 8) reporting automation 9) creation of standards and algorithms for reporting 10) group management in terms of setting tasks in the search for a data source, a method of modeling / transforming data for reporting, communications with the customer and it. II. Creating new reports: 1) development of analytical models for the analysis of the plan and sales data, according to the sales forecast by products, product groups, customers and time 2) creating a report on the effectiveness of the use of product samples 3) collecting data and building visual analytics for meetings with large national clients 4) management of the analytics group III. Calculation of KPI employees of the trade department: 1) updating external data and settings for their delivery, kpi calculation for the implementation of the sales plan 2) creation of methods and models for calculating the KPI of employees 3) search for the causes of regularly non-fulfilled KPIs IV. Working with pricing 1) calculation and automation of the calculation of price adjustments for the company's transition to new pricing conditions
-Planning inter-warehouse movements to maintain the required level of stock of finished products in intra- and inter-country directions (9 directions); - Development of forecasting systems for production and stocks of finished products in Anaplan; - Calculation of interwarehouse movements; -Development and analysis of various scenarios for logistics, production, stocks; - Leading the processes of automation of calculations; -Development, development and support of accounting and control models; -Development and implementation of visual analytics; -Short-term planning; -Training employees to work in a new BI tool; -Participation in cost optimization processes in the movement of finished products