Dmitriy Tselyakov Email & Phone Number

Moscow, Ru

Москва, Россия

Contributing to Digital Business sales performance by turning data into value.Working on Digital Sales KPIs methodologies & definitions (Retention Rate, LTV, ARR, etc.).Creating deep-dive dashboards from scratch:• Data exploration & complex SQL queries to create datasets;• Building data models & coding DAX;• Designing fitting layouts and visualizations.Cross-functional collaboration with• Web Analytics team for developing sales end-to-end analytics;• RnD BI Team for customer analytics;• DWH Team for constant development of data frameworks & datasets.Challenging & calculating business cases, analyzing promos & A/B tests.Automating analytics and financial routines.Mentoring younger specialists.

Москва, Москва, Россия

Finace partner for local management & global HQ for Russian Royal Canin factory:• Budgeting, forecasting and analysis of manufacturing costs incl. payroll• CVM analysis of local prime costs, unit cost control• CAPEX projects finance control & reporting• Factory KPI (non quality costs, productivity, stock turnover) calculation and analysis• Periodic perfomance reviews and action plan development with stakeholders• Participation in closing activities - reserves calculations, accruals check• Participation in internal audit and governence processes• Budget and write-offs approvals in ERPImproving FP&A related processes & corporate reporting through:• Full design of PBI reports with DAX calculated metrics (manufacturing costs, budget conrolling, non-quality costs, stocks, etc.) based on ERP SQL database as main datasource• Revamping existing Excel finance models from scratch with Power Query & Power Pivot

Москва, Россия

• Management accounting, follow-up, analysis and supporting calculations for assigned business units (Yandex Music, Kinopoisk, Afisha, Zen)• Preparing performance reports and presentations of financial results for management• Design and keeping up-to-date financial models for BU PnL management • Performing various financial reconciliations for internal audit

Москва, Россия

Financial BP for shopping malls management teams:• Factor analysis of financial performance, identification of risks and opportunities for their development, internal benchmark analysis across the portfolio of shopping malls.• Financial expertise of operational decisions, projects evaluation (DCF, NPV, IRR, ROI), design of feasibility models.• Preparing summaries, recommendations and presentations for management.• Budgeting and follow-up processes coordination in shopping malls.• Financial support and guidance for non-financial colleagues.• Design and keeping up-to-date automated analytical reports (Excel/PowerPivot/Access).• Leading the enhancement of budgeting module - scope definition, cooperation with contractor, testing, training colleagues, launching process. • Participation in design and improvement of FP&A processes (e.g. Investment Portfolio planning, evaluation and tracking of actual workload costs of project teams, etc.).

• Tracking and analysis of Project Portfolio in terms of timing/resources, reporting to Management teams, participation in steering forums.• Supporting planning process for internal resources for development projects. • Project Management trainings, incl. internal rules and process, project time scheduling, MS Project.• Administration of MS Project Server, support for users, setting reports, managing technical contractor.

Москва, Россия

• Leading Project Portfolio budgeting & cash flow planning process, monthly follow-up and analysis, reporting and presentation to Management.• Participation in development of investment feasibility model for R&D projects, supporting projects feasibility calculations.• Managing small R&D projects for lightning solutions – project scope and goals definitions, feasibility calculation, coordinating project team, budgeting and scheduling, presenting project on steering forums.• Project Management methodology enhancement in terms of resource planning, managing weekly resource allocation process between many projects.

Project Coordinator for launching manufacturing plant project (JV w. European partners):• Supporting project manager - negotiations with 3rd parties, managing internal HR, conducting market researches, choosing equipment, contracting, etc.• Responsible for detailed project scheduling and internal HR planning, reporting progress to Management on a weekly basis.Apart from project:• Other construction projects calendar planning, progress follow-up and reporting to Management.• MS Project Server administration.• Supporting project managers in terms of project scheduling.

Bachelor'S Degree, Financial Management

Engineer, Civil Engineering