From auditor to IT and back to auditors

From auditor to IT and back to auditors

Hello everybody!

My name is Oleksandr Nikolaev. I have been in retail for 18 years, mainly specializing in FMCG. Now I work with such products as clothes, shoes, equipment and sports nutrition. Another 2 years of experience in IT as a tester, system administrator and head of software maintenance. Participated in hackathons in the positions of PR, QA and UI designer. After the departure of many companies from the Russian Federation, he returned to auditors.

What does an auditor do?

The auditor’s job is to conduct a high-quality recount in the store, and after that, a high-quality closing. This is necessary so that the business has up-to-date information on the availability of goods and material values ​​in the store.

In my free time, I am working on several projects that I hope will help me and my colleagues. Since I really like programming in Delphi and C#, I want to talk about a couple of projects that I have developed in demo versions so far. There will be a post about them.

“SC Catalog” project

The purpose of the project:

During the audit, we do not know what this or that SKU (Unique Product Unit, which has its own distinctive code) looks like, this creates certain difficulties during the inventory of the SC (Service Center). I am currently working on the project in Delphi 10.4 and C# programming languages ​​(experience is a plus).

Problems that occurred at work need to be loaded with a picture into the database and calculated from it. Since there are few lessons and information about this, you have to use the trial and error method.

Project “Educational Game” (Novel)

I was inspired to create such a game by the tutorials on our internal portal SM Daily. The game is based on the RenPY novel engine.

Plans for the educational game “Sportmaster is simple”

  • General information about Sportmaster

  • The basics of working with Denso

  • Basics of working with CIS

  • Preparation for inventory for various businesses (Demix, Sportmeister, Urban, Austin, Fanday).

  • other

The sections “General information” and “Basics of working with Denso” have been implemented so far.

What features and tasks are planned for the game:

  1. Mini-games

  2. Tests

  3. Feedback

  4. Choice of music.

The purpose of the game is to help the employee to prepare well for the inventory and to easily learn our regulations in a playful way.

Inventory calculation calculator for planned inventory

One weekend I was studying the regulations in preparation for a planned inventory. It was necessary to calculate the number of inventory holders in order to know how much to take from Denso. An idea came to mind – why do I have to search for calculators all over the disk, maybe there is a way to simplify everything somehow? Sat on Saturday evening, read how Textbox, ComboBox, Label works. I wrote out all the formulas that were there and parted for programming in the C# language.

I saw how the operators work if, else mathematical functions. I assembled a simple version in 3 hours.

It works simply: in the first cell, you enter the amount of leftovers and the working time. Depending on the business, the necessary number of colleagues who need to be involved in the planned inventory is calculated. There is also an Other tab where all fields can be entered manually.

Here are three tasks I came up with that can be useful for work as an auditor. I hope to implement and implement it in our work in the near future.

Here you can watch a video with an example.

Have you had to do this sort of thing for internal work portals? I will be glad if you share your experience in the comments.

Related posts