Robert Vardanian Email & Phone Number

Moscow, Ru

Moscow, Moscow City, Russia

Product/Project/DepartmentAnalytics direction "Finance"Responsibilities• Search, analysis, data prototyping;• Development of a prototype of the final table;• Participation in the development of an automated data delivery process (data pipeline);• Development of a monitoring system for data quality checks;• Implementation of the company's innovative products;• Development of incoming requirements for data marts and preparation of accompanying technical documentation;• Interaction with key IT and business divisions of the company.

Moscow, Moscow City, Russia

Department of Products, Tariffs and PromotionResponsibilities• Development of regular reporting on the effectiveness of marketing campaigns, a report on customer interactions, SAP HANA DBMS.• Operational reports, ad-hoc analytics.• Development, revision of python scripts to automate processes, run procedures, codes, process files, send emails on a schedule.• Running jobs through SAP Data Service.

Krasnodar, Russia

Demand Forecasting Division, Planning and Logistics DirectorateResponsibilities:• Development from scratch and finalization of reporting (Teradata SQL) for management, a team of analysts and external departments• Regular creation of presentations based on the results of the week (forecast and actual indicators, the results of the work of departments) for management.• One-time assignments of management (development, analysis)• Ad-hoc tasksAchievements:• Promptly carry out the assigned tasks from the management. Based on my reports, the management makes management decisions, decisions on changes in demand forecasting algorithms, improvement of the company's business processes, .At the end of 2019, I received a diploma from the director of the directorate for "reporting that improves business processes"

Krasnodar, Russia

Lead SQL Developer• SQL code development, reporting• MS SQL, Teradata SQL, OLAP

Krasnodar, Russia

Investment Analysis Sector, Department of EconomicsResponsibilities:• Development of SQL codes, macros• Agreement of the budget of new, redesigned stores• One-time management assignments• Working with an economic model (calculation of economic indicators NPV, IRR, payback), large Excel files, complex formulasAchievements:• Automation of business processes• Minimization of "manual" labor in the calculation of the economy

Krasnodar, Russia

Department for Control and Development of Management Systems for Markups and Targets of stores, Sales DepartmentResponsibilities:• Approval of markups for new, redesigned stores• Changing the markup when the competitive environment changes• Other business-processes related to markup• Ad-hoc tasks from managementAchievements:• Improved my level of development of VBA macros, SQL codes• Optimized my regular business-processes and reports with management approval.• Automated business-processes, which were made manually before me