Marek Mitros
Verified Expert in Engineering
SQL Developer
Warsaw, Poland
Toptal member since February 25, 2022
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
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
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
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.
ERP Developer
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.
Lead Business System Analyst and Software Engineer
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.
Member of the Scientific Staff
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.
Experience
Consolidation Component
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 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
Business Performance Product Owner
Education
Postgraduate Degree in Business Intelligence
Warsaw School of Economics - Warsaw, Poland
Master's Degree in Mathematics and Computer Science
Warsaw University - Warsaw, Poland
Skills
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
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring