Ivan Reznikov Email & Phone Number

St Petersburg City, Russia

Responsibilities:- Conducting in-depth research for multiple departments, providing valuable insights and recommendations.- Streamlining and optimizing business processes to enhance efficiency and productivity.- Assessing tasks critically, identifying areas for improvement, and implementing effective solutions.- Managing databases by collecting, cleaning, and analyzing data using SQL queries in a corporate environment. Loading data into PowerBI for visualization purposes.- Creating visually appealing and informative diagrams, charts, graphs, and dashboards to present data-driven insights.- Automating repetitive tasks using Python, such as email sending and data collection, to improve operational efficiency.Accomplishments:1. Led the reporting efforts for a government-sourced project with a total budget of $30M, overseeing both financial and statistical aspects.2. Conducted comprehensive research for various departments, resulting in a 7% increase in efficiency and a 12% reduction in costs.3. Utilized SQL to analyze diverse datasets, delivering an updated analysis summary with precise and reliable standards, surpassing outdated approaches.4. Restructured data into intuitive and easily navigable categories, benefiting not only the team of data analysts but also individuals across the organization, from data entry personnel to upper management and financial officers.5. Systematized error detection in reports and developed robust database solutions to rectify deficiencies, significantly reducing the chances of recurring errors.6. Implemented a wide range of new measures and metrics across different departments, enhancing management efficiency and optimizing employee workflows.

Moscow, Russia

Responsibilities:- Conducted comprehensive demand forecasting for frozen categories of goods across the Russian Federation, utilizing advanced statistical models and data analysis techniques.- Analyzed sales and market data to identify trends, patterns, and insights, contributing to informed decision-making and strategic planning.- Automated goods ordering and reporting processes using a combination of Python, SQL, PowerBI, and Excel, streamlining operations and improving efficiency.- Monitored and ensured the availability of necessary stocks in shopping centers, investigating and resolving issues related to stock shortages or excesses.- Fine-tuning order parameters and utilizing advanced algorithms such as Lewandowski, Holt-Winters, and AVS-Graves.- Collaborated closely with Category Managers, Department/Store Managers, and Sales teams to optimize customer service and align demand planning strategies with business goals.Accomplishments:1. Successfully automated the process of calculating the required volume of special categories of goods centrally in the Russian Federation, leveraging Python, SQL, Teradata, and Oracle technologies. This automation significantly improved efficiency and accuracy in demand planning.2. Implemented automated reporting solutions for the Demand Forecasting Department using Python, SQL, and Teradata, streamlining reporting processes and enhancing data accuracy.3. Achieved a remarkable increase in forecast accuracy from 44.7% to 57%, by reducing forecast deviations and addressing bias-variance issues. This improvement resulted in more precise and reliable demand forecasts.4. Significantly improved forecast accuracy for promotional activities, increasing it from 47% to 59%. This enhancement optimized inventory planning, improved sales effectiveness, and optimized promotional campaigns.

Russia, China, Mauritius

June 2013 - June 2014 – Crowne Plaza Hotel (Russia), receptionistJune 2014 - October 2016 – Sokos Hotels (Russia), MICE coordinatorOctober 2016 - May 2018 – Howard Johnson Hotel (China), asst. Guest Service managerMay 2018 - May 2020 – Constance Prince Maurice (Mauritius), Asia-Pacific sales manager