Marek Mitros, Developer in Warsaw, Poland
Marek is available for hire
Hire Marek

Marek Mitros

Verified Expert  in Engineering

SQL Developer

Warsaw, Poland

Toptal member since February 25, 2022

Bio

Have almost 30 years of experience in designing, developing and implementing of the systems for enterprises. Have 25 years of experience in working with ERP system called "IFS Applications". The database part of this system is developed in Oracle SQL and PL/SQL. The client part is developed in Visual Studio C#. Last 2 and half years I have been doing modifications of the application for customers in Poland and US as full-time worker and enterpreneur.

Portfolio

Mitros
Oracle PL/SQL, Business Requirements, Software Design...
Venture Industries Group
Oracle PL/SQL, SQL, SQL Stored Procedures
IFS
Oracle PL/SQL, Jira, Visual Studio, C#, XML, SQL

Experience

  • SQL - 20 years
  • Business Requirements - 20 years
  • Industrial and Financial Systems (IFS) - 20 years
  • Oracle - 20 years
  • Oracle PL/SQL - 20 years
  • PL/SQL Developer - 10 years
  • Jira - 10 years
  • Oracle SQL Developer - 3 years

Availability

Part-time

Preferred Environment

Windows, Unix, Industrial and Financial Systems (IFS), Jira, Visual Studio, SQL, PL/SQL Developer, Oracle SQL Developer, XML, Oracle

The most amazing...

...I developed "custom logic" tool as an extension of IFS Applications (ERP system) allowing developer to add easily enhancements to the logic of the application.

Work Experience

Owner

2020 - PRESENT
Mitros
  • Designed, developed, and installed programs enhancing the IFS applications ERP system. Used Oracle PL/SQL, Visual Studio C# and custom objects functionality.
  • Maintained contact with IFS customers in Poland, offering them modifications of the ERP system, which adapts the software to business needs.
  • Created the new custom logic tool, which helped the customer and system administrator maintain the system. The custom code is automatically merged with the latest version and installed by the software provider.
Technologies: Oracle PL/SQL, Business Requirements, Software Design, Industrial and Financial Systems (IFS), ETL, Databases, Data Engineering, SQL Stored Procedures

ERP Developer

2019 - 2020
Venture Industries Group
  • Designed and programmed modifications of ERP systems like IFS applications. Initiated the improvements of the ERP system and worked in financials, logistics, manufacturing, and HR areas. Used Oracle SQL, PL/SQL and custom objects functionality.
  • Handled issues reported by the user in Poland and abroad and communicated with the software provider.
  • Configured the ERP system according to the company's needs.
Technologies: Oracle PL/SQL, SQL, SQL Stored Procedures

Lead Business System Analyst and Software Engineer

1997 - 2019
IFS
  • Performed analysis of legal and market requirements from several countries. Designed and developed ERP system components, writing functional specifications and testing. Developed interface to Vertex system when working with Brazilian taxes.
  • Developed financial components as the software engineer in the R&D department. Worked with IFS applications versions 99, 2000, 2003, and others. Using Oracle PL/SQL, Visual Studio, C#, and IFS development tools.
  • Developed in financials and supply chain areas as the software engineer in the consulting department.
Technologies: Oracle PL/SQL, Jira, Visual Studio, C#, XML, SQL

Member of the Scientific Staff

1996 - 1997
Nortel Networks
  • Developed software running on a Cellular switch in Pascal and C languages.
  • Worked in Dallas, Texas, USA, in international environments where I learned English fluently.
  • Created a prototype of communication protocol in Unix environment and C language. This was a prototype of the communication between the base station and Cellular switch.
Technologies: Pascal, Unix, C

Consolidation Component

Consolidated balance sheets and the income statement
data were obtained on the accounts of companies from different countries. This information was needed to get each item in the profit and loss account.

Each year, accounts are entered in a table editable by users. The exchange rates for the report are calculated automatically at the end of the period. The NBP exchange rate on the last day of the period is used in the balance sheet.

The NBP weighted average exchange rate for the period is used in the income statement. Data for the report is generated automatically during the process performed at night. Thanks to this, the report for the user is carried out in a few seconds. We can see in the columns on the screen the companies' amounts in the accounting currency of the given country.

We see the consolidated sum previously converted to the parent company's currency in the last column.

Automatic Creation of Customer Orders

The automatic creation of customer orders from the incoming XML file in SOAP IFS format was prepared.

The IT specialist prepared an FTP link for the client. Further handling of the incoming order was ready in multiple steps.
1. The order is created automatically with the appropriate type.
2. It is checked whether items from the customer list have been ordered and if they are in stock.
3. If so, the order is automatically activated, and an email with information is sent to the customer and the merchant.
4. If not, the order is not activated, and we also send an email to the customer and the merchant with information on what is missing.
5. The order is automatically reserved in stock after activation, and shipment is created. The warehouse further handles the order.

This procedure has significantly streamlined the order handling process, which takes place without the participation of a trader.

Italian Electronic Invoice

Electronic invoicing for the Italian market has been implemented in IFS Applications. It is mandatory for public companies and optional for private companies. The possibility to generate an XML file from the application has been added. It conforms to the template described on page Fatturapa.gov.it. I worked on this project during my IFS employment.

Business Performance Product Owner

During work in IFS Marek, I was designated to be the owner of a business performance product. My responsibility was to perform training to colleagues in consulting and help the pre-sales area by presenting the product to the customers. The product was built Scorecard and OLAP cubes. OLAP cubes were defined in Microsoft Analysis Services and presented with ProClarity.
2007 - 2008

Postgraduate Degree in Business Intelligence

Warsaw School of Economics - Warsaw, Poland

1984 - 1992

Master's Degree in Mathematics and Computer Science

Warsaw University - Warsaw, Poland

Libraries/APIs

Custom APIs

Tools

Jira, Visual Studio, Mathematica

Languages

SQL, XML, C#, Pascal, C, XSD, GAP

Platforms

Oracle, Windows, Unix

Storage

PL/SQL Developer, Oracle SQL Developer, Oracle PL/SQL, Databases, PL/SQL, SQL Stored Procedures

Paradigms

Business Intelligence (BI), ETL, OLAP

Other

Industrial and Financial Systems (IFS), Complex Problem Solving, Mathematics, Creativity, Algorithms, Business Requirements, Software Design, Data Architecture, Home Pages, Data Analysis, Statistics, Data Mining, Data Engineering, Data Visualization

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring