Mykola Demediuk Email and Phone Number

Continuously provide Management with structured and up-to-date information about business performance, potential problems and opportunities analysis thus contributing to decision-making process and sustainable growth of business results. Ensure timely analysis and reporting. In colaboration with other functionally departments and territories to realize of new project, reports and systems. The development, coordination and support Regional Sales Analyst. Provide Compliance with Principles & Practices.

✦ Philip Morris Ukraine, as a part of PMI, is one of the largest tobacco companies.✦ The North-West region of Ukraine comprised five areas of over 6 million people, 11.000 stores.● Analyzed quantitative and qualitative data retrieved from various SQL databases, tested hypotheses, identified data trends, outlined problems, and prepared reports (SAP BusinessObjects Business Intelligence platform, Nielsen Answers, Visual Studio)● Reviewed raw data, performed troubleshooting, examined information for consistency, logical or structural problems. Performed data normalization, cleansing and eliminating duplicates.● Designed ad-hoc reports, dashboards for management (Excel, PowerPoint), gave presentations that highlighted gaps and areas of excellence, identified opportunities for improvement.● Assisted and contributed to elaborating metrics to track KPIs, creating YTD/YTG report files.● Monitored trends and changes in patterns for introducing of new brands to the regional market.● Directly supported data audits by Regional Key Account Manager, HoReCa team, territory supervisors.✔ Created data schema (VBA) merging XLS data sources from Retail partners across three regions to create a centralized database system for supporting strategic planning and sales.✔ Designed repeatable SQL reports process to leverage Temporary Point of Sale Materials (TPOSM) distribution and customers’ monthly reward.✔ Provided Level1 helpdesk support. Developed a survival Excel course and trained colleagues. Installed and set up a full suite of Cisco IP-telephony equipment for 25 people in the office.

Develop and maintain comprehensive systems, databases and reporting infrastructure to support information gathering and business analysis.

Function of the position is to conduct thorough check and analysis of collected sales & merchandising data to further generate clear and accurate reports for the assigned region in order to provide regional management and field force with structured, sound, and up-to-date information required for business decision making. My responsibilities are:• Support implementations of sales systems in the regions and contribute to the development of relevant applications• Ensure structured and accurate validation of sales data from the field force• Support sales reporting systems used by field force• Analyse sales performance and provide regional management and field force with key relevant information in terms of brand, customer and incentive scheme performance• Based on completion of each sales cycle, provide regional management and field force with accurate relevant information of the regional scope highlighting cycle performance, key sales indicators and market dynamics• Co-ordinate analysis of market development, regional and brands performance, sales cycles results, compare sales achievements with targets to support management operational and strategic decision-making• Provide user training on sales systems to newcomers and relevant on-going training to end users

Created 2 departanets: Sales and Services IS Equipment with Customer Serviсe part, Sales and Distribution ecologically clean goods

Created sales and service department of Computer and Office Systems and Equipment

Created sales and service department

Developed tool for automate the process of inspections and workflow (DBMS Microsoft Access, VBA)