Summary
Overview
Work History
Education
Skills
Certification
Software Skills
Affiliations
Languages
Timeline
Generic
Orkhan Shikhaliyev

Orkhan Shikhaliyev

Baku,AZE

Summary

I am a business and sales analyst, specialized in banking and commercial area!

Overview

14
14
years of professional experience
1
1
Certification

Work History

Trade Manager

"Avrora" LLC
Baku
03.2022 - Current
  • Developed monthly sales plans for products and sales staff.
  • Performed meticulous analysis of sales on various time intervals to generate comprehensive report forms.
  • Prepared promotional conditions for trade points to enhance sales loyalty, while consistently monitoring their monthly implementation.
  • Conducting periodical comparative analyzes of competitors to expand product distribution.
  • Monitoring of compliance with discount sales conditions in accordance with the contract conditions for network markets.
  • Conducting monthly reconciliations according to the contract conditions for networks and calculating bonuses and processing them into the system.
  • Monitoring of monthly discounts according to the approved annual budget.
  • Analyzing and processing into the system the gifts that will be given for placing refrigerators at trading points for sales loyalty.
  • Periodic analysis of sales and preparation of plan revisions for the next months.

Sales Analyst

“ABC-Telecom” MMC (Kontakt Home)
Baku
12.2020 - 03.2022
  • Set monthly, quarterly turnover, average check, and service targets for regional and store managers.
  • To implement daily, weekly, monthly and quarterly control of the assigned targets.
  • To determine the monthly bonus calculation algorithm for the regional and store managers, store sales staff and to monitor the calculation process on a monthly basis.
  • Prepare daily, weekly, monthly, quarterly reports for management on store turnover, store traffic, store conversion, service indicators sold on products.
  • Determine the sales priority of the product range and set the sales map for the stores.
  • Analysis of loan and cash sales portfolio.
  • Calculation of monthly margin, analysis of profitability of stores

Leading Expert on Credit Risks

Bank "BTB" OJSC
Baku
09.2019 - 12.2020
  • To carry out daily control of the loan portfolio.
  • Reports on loans falling within the sphere of influence of the Financial Markets Control Chamber of the Republic of Azerbaijan in connection with the implementation of the Decree of the President of the Republic of Azerbaijan dated February 28, 2019 "On additional measures related to the resolution of problematic loans of natural persons in the Republic of Azerbaijan".
  • Preparation of ADD1 report in addition to Prudential to the Financial Markets Control Chamber of the Republic of Azerbaijan.
  • Preparing a quarterly survey report on the assessment of the state and perspective of the consumer credit market for the Financial Markets Control Chamber of the Republic of Azerbaijan.
  • Migration matrix and consumer credit vintage report on credit risk assessment to the Financial Markets Control Chamber of the Republic of Azerbaijan
  • When allocating credit limits, give their proposals to the head of the Credit Control Department and the Director of the Risk Management Department.
  • To control the integration of the loan portfolio into the MKR (Credit Bureau) service.
  • Supervise branches in the implementation of loan portfolio plans, provide support if necessary.
  • Correct classification of all loans issued by the bank and daily monitoring of provisioning.
  • To analyze the data received from other structural divisions of the bank for the purpose of risk management.

Sales Coordinator-analyst

"Avrora" LLC
Baku
03.2018 - 09.2019
  • Preparation and monitoring of daily, monthly sales and payment plans for sales managers, regional managers and sales representatives.
  • To organize and monitor the preparation of sales plans for products.
  • Monthly, daily sales and cash forecasts based on the annual sales plan presented to the management.
  • Analysis of monthly interest rates (customer interest) presented by sales managers and presentation to management.
  • Development of a project for automating the calculation of KPI indicators for the sales staff together with the IT Department and monitoring the implementation of software development.
  • Preparation and calculation of monthly KPI indicators for sales managers, regional managers and sales representatives.
  • Preparing and presenting a comparative analysis of sales and fundraising indicators to the management.

Deputy Head of Financial Analytics Department

"Panda kids" (3V) LLC
Baku
06.2017 - 03.2018
  • Considering the company's sales policy and financial situation, analyze financial information and present it to the management.
  • Provide alternative and new recommendations for cost reduction and improvement of financial indicators.
  • Collection of information on financial situation and risks, preparation of periodic sales trends reports and submission to management.

Senior Analyst

"Demirbank" OJSC
Baku
12.2015 - 03.2017
  • Creation and optimization of MIS reports for credit and non-credit products.
  • Regular optimization and calculation of the bonus system for branch employees.
  • Deposit project with GNI group.

Lead Analyst

"Demirbank" OJSC
Baku
02.2013 - 12.2015
  • Calculating monthly bonuses for branch employees and preparing reports for management.
  • Preparation of reports on credit and deposit portfolio management.
  • Analysis of profitability rates of credit and deposit products and preparation and presentation of proposals for the creation of new products.
  • Creation and control of the loan and deposit portfolio analysis and dynamics management system.
  • Create and update the motivation system of branch employees based on KPI.

Credit Analysis Specialist

"Demirbank" OJSC
Baku
04.2010 - 02.2013
  • Management of credit delay control system in branches.
  • Created plans to propose solutions to problems related to efficiency, costs or profits.
  • Dynamics of monthly credit interest rates for branches.
  • Preparation of loan portfolio for weekly and monthly loan sales and sold loan products.
  • Preparation of proposals for the creation of potential reserves in order to cover possible losses and discussion with the management.

Education

BBA - International Economic Relations

Azerbaijan State Economic University
Baku
06-2010

Skills

  • Account Servicing
  • Trade Show Marketing
  • Operations Management
  • Contract oversight
  • Service Delivery Management
  • Cross-functional team leadership
  • Market Trends Analysis
  • Contract Negotiation

Certification

  • AMFA training: Planning for the future of financial literacy
  • ABTC training: Cash flow and credit for entrepreneurs

Software Skills

  • MS Office suite (Excel Macros and etc.)
  • MS Power Query
  • MS Power BI
  • SAP Software & Solutions
  • SINAM
  • 1C
  • Micro

Affiliations

  • Deputy head of the Student Youth Organization (2008-2009)

• Organization of trainings for students;
• Organization of knowledge competitions among faculties;
• Participation in inter-university competitions.

Languages

Azerbaijani
First Language
English
Intermediate (B1)
B1
Russian
Upper Intermediate (B2)
B2

Timeline

Trade Manager

"Avrora" LLC
03.2022 - Current

Sales Analyst

“ABC-Telecom” MMC (Kontakt Home)
12.2020 - 03.2022

Leading Expert on Credit Risks

Bank "BTB" OJSC
09.2019 - 12.2020

Sales Coordinator-analyst

"Avrora" LLC
03.2018 - 09.2019

Deputy Head of Financial Analytics Department

"Panda kids" (3V) LLC
06.2017 - 03.2018

Senior Analyst

"Demirbank" OJSC
12.2015 - 03.2017

Lead Analyst

"Demirbank" OJSC
02.2013 - 12.2015

Credit Analysis Specialist

"Demirbank" OJSC
04.2010 - 02.2013

BBA - International Economic Relations

Azerbaijan State Economic University

Similar Profiles

CREATE PROFILE
Orkhan Shikhaliyev