Business planning and Treasury supervisor
LLP JV Coca-Cola Almaty bottlers
Total des années d'expérience :13 years, 10 Mois
Kazakhstan market. Team of 3 direct reports.
1) Treasury.
a) internal:
- implemented reporting processes (daily cash position, weekly cash flow, short-long term cash flow).
- period end close (SAP).
- PL and CF variance analysis.
b) banking (Citibank, Halyk bank):
- loans (revolving/ investing credit lines).
- trade financing (letters of credit, letters of guarantees).
c) automation:
- automation projects with Citibank:
- account balance statements and reports sending.
- automation of FX conversion.
2) Supply chain.
a) internal:
- supply chain finance project to improve net working capital.
- COGS (raw materials, manufacturing overheads) analysis.
- improvement of reporting process and reports.
b) external:
- cooperation with procurement team to forecast risks and opportunities.
- regular visits to plants to monitor cost optimizing initiatives.
PepsiCo HQ. New-York. 100% remote work. Data Analytics Team. Markets: US, CIS, Asia, Middle East and South Africa.
- Established and managed key performance indicators to measure and improve processes, systems, and data.
- Supported establishment, adoption, and application of data standards across systems and processes related to product master data.
- Collaborated with multi-functional teams (Data Scientists, Data Modelers, Data Ingestion) to communicate and align development efforts.
- Built the workflow of processes and roles in Azure DevOps.
- Worked in SaaS: Numerator, IRI Unify, Alation.
- Led process of Net Revenue management for US and RU markets.
Central Asia markets: Kazakhstan and Kyrgyzstan.
- budgeting & planning: Annual Commercial plan, Annual Operating plan.
- period end closing (full P&L, uploading financial data to HQ via Oracle HFM.
- variances analysis (cause of change, top & bottom line, vs. Budget, vs. PY).
- short-term (weekly) and long-term (Forecast 1 (in April), Forecast 2 (in October)) forecasting.
- productivity projects assessment and tracking.
- monthly business review (corporate decks).
www.pepsico.com
Central Asia markets: Kazakhstan and Kyrgyzstan.
1. Revenue Governance and Strategy.
- discounts and allowances (rebates) accrual.
- gross revenue, discounts and allowances check and confirmation.
- developing rebates guidelines
- modeling P'n'L of client
2. Pricing.
- prices setting in local system (1c).
- pricing effect variance analysis (vs. PY, vs. Budget)
- price pack architecture (compared to competitors)
3. Reporting.
- period end closing (collaborating with Reporting team).
- volume & net revenue by channels.
- gross profit variance analysis (vs. PY, vs. Budget).
- volume mix dashboard.
- corporate internal reports and decks (for local and sector management team).
4. Financial planning & analysis.
- P'n'L modelling (Annual Commercial plan, Annual Operating plan).
- P'n'L updating (Forecast I (Mar-Apr), Forecast II (Sep-Oct).
- uploading financial data to HQ via Hyperion.
Achievement:
- internal award "Bravo" for "Net revenue realization" report automation
www.avon.com
Central Asia markets: Kazakhstan and Kyrgyzstan
1. Reporting.
- daily sales KPI report for Management and Field.
- regular reports for Field Force on various Incentive Programs.
- information decks for Management (Business Review, etc.).
2. Analysis.
- calculation of business-cases for Incentive programs and business initiatives (trade and digital marketing).
- post-evaluation of incentive programs.
- analysis and implementation of changes into business-model.
3. Budgeting.
- budgeting of incentive programs (quarterly, annually).
- collaboration with Finance team in budgeting issues.
- budget tracking of few departments (Trade marketing, Sales support).
- cost forecasting (value chain).
4. Reporting to HQ.
- corporate reports for HQ.
- information decks for exchange in experience and best practice.
- working in PL/SQL Developer (queries), Concorde (billing software).
Achievement:
- internal award "Master" for Field support by various Incentive Programs
- internal award "Master" for contribution into return of sales growth via Incentive Programs.
1. Reporting.
- reporting from scratch, according to IFRS standards.
- P'n'L and balance reporting (according to corporate reports).
- management reports preparing (stock position/ consumption, etc.).
- reports for state authorities preparing.
- corporate reports preparing for Finance Director and Country Manager.
- preparing upload files (transformation from 1c to AARO (reporting software).
2. Budgeting.
- budgeting (OPEX, CAPEX).
- variance analysis (vs. PY, vs. Budget).
- cost accounting optimization in 1c.
3. Treasury.
- liquidity report (on a weekly basis).
- cash position report (on a daily basis).
- payment process to local and foreign counterparts.
- currency control.
- cash flow management.
4. Other.
- internet-banking (issuing keys, tokens).
- business-processes optimization.
www.kazstroyservice.com
Headquarters, Almaty.
1. Reporting.
- daily reports package preparing (cash position, loan portfolio, receivables aging).
2. Treasury.
- cash position report.
- payment process to local and foreign counterparts.
- depositing free cash (overnights).
- negotiating with banks on decreasing commission fees.
- receivables/payables analysis.
- currency control.
3. Financial management.
- trade and classic financing (loans/ letter of credits/ guarantees).
- administration of intercompany loans.
- cash flow forecast.
- financial liabilities monitoring.
4. Investing activity management.
- CAPEX monitoring.
- pledge monitoring/pledge disposal.
5. Other.
- corporate cards (issuing/ prolongation/ closing).
- internet-banking (issuing keys, tokens).
Achievements:
1. Workflow optimization.
2. Optimized bank commission fees.
International projects: Asia Gas Pipeline (AGP), Caspian Pipeline Consortium (CPC), Bitument plant in Aktau, Atyrau Refinery Plant upgrade, Beineu-Bozoy-Shymkent pipeline (BBSh), Kazakh-Chinese pipeline (KCP).
www.kkb.kz
Headquarters, Almaty.
1. Credit/ Trade financing:
- credit, financial risks analysis.
- pledge analysis.
- issuing loans/ letter of credits.
2. Financial analysis of projects.
- investment projects (CAPEX, leasing).
- merge & acquisitions (telecommunication company).
3. Preparing of loan proposal for Credit Committee.
4. Preparing credit procedures.
5. Approving and monitoring of covenants.
Achievements:
1. Closed deal for the sum of USD 13 mln. of refinancing corporate client.
• Chief editor of university magazine «Munara» (2008-2009). 3 persons in my submission. • Won state scholarship at KBTU. • Graduated from school with golden medal «Altyn Belgi» (sign of excellence).
