Dmitry Shkolin, Category Financial Analyst

Dmitry Shkolin

Category Financial Analyst

Procter & Gamble

Location
United Arab Emirates
Education
Master's degree, Finance
Experience
6 years, 1 Months

Share My Profile

Block User


Work Experience

Total years of experience :6 years, 1 Months

Category Financial Analyst at Procter & Gamble
  • Russian Federation - Moscow
  • My current job since May 2022

o Improved financials of the Feminine Care category by 12% by analyzing key business drivers and
identifying profitable opportunities
o Forecasted revenue for multimillion-dollar category, including reconciliation of financial impacts on
the forecast and advised board members on the financial performance in Eastern Europe
o Assessed short- and long-term financial impact of initiatives and investments on the revenue
o Controlled budget spendings, pricings, forecast accuracy, and compliance with local regulations

Distributor Operations Financial Manager at Procter & Gamble
  • Russian Federation - Moscow
  • April 2021 to April 2022

o Promoted delivery of sales targets by creating the first sell-in / sell-out ecosystem for key regional
customers with KNIME forecasting flow and PowerBI visualization
o Supported 5 customer teams on their performance, target setting, and troubleshooting
o Improved P&G margin by calculating customer-tailored commercial terms, uploading them to SAP,
and controlling their correctness in Price Lists
o Developed 3-year Belarus growth plan on how to improve structural financials by category

Transfer Pricing Compliance Manager at Procter & Gamble
  • Russian Federation - Moscow
  • December 2019 to March 2021

o Ensured 100% compliance to transfer pricing principles for intercompany operations
o Prepared annual transfer pricing report (TP Notification) and defense documentation
o Designed and conducted several in-house transfer pricing cross-functional audits

Financial Officer at Tuli Health
  • United Kingdom - London
  • September 2019 to November 2019

o Estimated required number of customers and cost of services by building the P&L model at the seed stage of the startup
o Scripted Python chatbot aimed to predict an illness based on a free text entry

Intern Project Manager at Ernst & Young
  • United Kingdom - London
  • June 2019 to September 2019

o Developed strategic recommendations and mathematical models for the UK-based E&Y clients by leading the project team of 5 students and assessing clients’ major challenges

Part-Time Intern at McKinsey & Company
  • Russian Federation - Moscow
  • August 2017 to August 2018

o Assisted one of the biggest insurance companies in Russia in process optimization by decreasing required completion time by 15% via flowchart SWOT analysis

Education

Master's degree, Finance
  • at University College London
  • November 2019

Distinction

Bachelor's degree, Applied Mathematics and Physics
  • at Moscow Institute of Physics and Technology (SU)
  • July 2018

Specialties & Skills

Compliance
Analysis
Reconciliation
Forecasting
FINANCIAL
PRESENTATION SKILLS
PRICING
FORECASTING
CUSTOMER RELATIONS
DOCUMENTATION

Languages

English
Expert
Russian
Expert