Hi everyone, how are you?

The purpose of this post is to show my work routine a little, actually a very basic introduction. I want to try to do a shorter daily post or maybe one a week, something like that 😁.

What is my job?

I've been working as a programmer for almost 10 years, I work at a company called "Systec", my first day of work started on 07/01/2011 and I remember how I got here just graduated and afraid of all the news, as this was my first job in the field. We provide system for several stores specializing in "Retail". The main programming language we use is "Visual Basic 6", but we also have projects in "C#" (C-sharp) and "Java".

What is a retail store?

"Retail is considered the type of sale that is made directly to the final consumer, without intermediaries, and where the goods are sold in small quantities"

Source: https://www.significados.com.br/varejo/

As explained above, retail is the term we use to define stores that sell in small quantities and directly to the consumer. It can be a shoe store, auto parts, restaurant, among others.

Our company has more than 80 different customers ("customer" here, in this case it is a company), where each of them has 1 or more stores / branches. To give you an idea, some of our customers have more than 30 branches and our system is in each of these stores.

What is our system?

In this post, I will talk exclusively about our main system, which is called "Systec Smart", developed in the programming language "Visual Basic 6 (VB6)".

"The original Visual Basic (also referred to as Classic Visual Basic) is a third-generation event-driven programming language from Microsoft known for its Component Object Model (COM) programming model first released in 1991 and declared legacy during 2008. Microsoft intended Visual Basic to be relatively easy to learn and use. Visual Basic was derived from BASIC and enables the rapid application development (RAD) of graphical user interface (GUI) applications"

Source: https://en.wikipedia.org/wiki/Visual_Basic_(classic)

The language is a bit old, I admit, but the system is very stable and works well until today. Some of our customers have already used Smart on "Windows" (https://www.microsoft.com/en-us/windows/) XP, Vista, 7, 8, 8.1, 10 and even on 11, since in some customers Windows updated forced 😂.

"Systec Smart" has this name because we think about having a system that does everything in one place, so that you have total control over your store and its entire process. Some examples of what you can do are: issuing sales, creating a budget, printing sales, issuing invoices, inventory control, issuing purchase orders, controlling incoming and outgoing invoices, financial control, administrative control and many others.

What do you do on a daily basis?

My working hours are 8 hours a day, Monday through Friday, where I have 1 hour and 12 minutes of lunch break.

The routine is to keep an eye on a platform called "Mantis Bug Tracker" (https://www.mantisbt.org/) where tickets are created, which can be for example: develop or fix something via source code, check and correct some records in the database, correction of errors, generation of data sheets, backup management, among others.

Mantis example. Image Source: https://www.wikidata.org/wiki/Q1421571

The database we use is PostgreSQL:

"The world's most advanced open source relational database, PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance."

Source: https://www.postgresql.org/

The database management tool we use is "PgAdmin 3" https://www.pgadmin.org/ (Version 4 already exists, but as a matter of preference I still use 3) here you can see visually, the entire database structure, such as tables, columns, views, functions, among others.

PgAdmin 3 example. Image Source: https://pgpedia.info/p/pgadmin-3.html

After improving or correcting the source code, I compile a new version of Smart, attach it to the ticket and send it to a co-worker in the testing department. If it's something in the database, I make the necessary corrections and put in the call what I did and how it solved the problem and close the call (put as solved).

Well, that was the summary of what I do. I love my work a lot and later on I'll post more information and photos showing and explaining better every detail of what happens here!

---

Credits

Text: Made by me.
Some references came from:
https://www.significados.com.br/varejo/
https://en.wikipedia.org/wiki/Visual_Basic_(classic)
https://www.microsoft.com/en-us/windows/
https://www.mantisbt.org/
https://www.postgresql.org/
https://www.pgadmin.org/

Images:
https://www.wikidata.org/wiki/Q1421571
https://pgpedia.info/p/pgadmin-3.html

Post: Made at https://ecency.com/

---

Thanks to everyone for your attention to my post and for your support.