F8 Bilisim is a company that provides ERP consultancy for customers which conduct their businesses with IFS. F8 integrate potential of IFS into any businesses' specific needs. Although most of the customers are from industry, there are clients from other working fields as well.
Software Developer · Full Time
F8 Bilisim ve Danismanlik Hizmetleri
October 2023 - Present · 2 year 2 months
Beyoğlu, İstanbul, Türkiye
Business Related Experiences
Through my meetings with executives, project planning, and the development process, I've learned about specific customer needs. This experience has improved my understanding of business strategy and operational efficiency. As a result, I can address problems not only by considering the technical aspects but also the underlying workflow processes.
Database Design and Management
- Designed and implemented robust database schemas for various applications, ensuring efficient and scalable database structures.
- I developed a scalable and optimized database structure based on the database architecture and requirements created by my manager.
- Working on ERP business projects with complex interconnected database structures has enhanced my ability to understand, execute, and build sophisticated database systems.
PL/SQL Development
- Developed efficient PL/SQL queries to function like triggers, filtering, and insertion, handling complex data manipulation tasks effectively.
- Integrated pre-written queries from IFS into various projects to meet client requirements.
- Analyzed and optimized existing queries to improve performance and reliability, learning to use and inspect queries from various projects.
- Designed and executed data migration scripts between environments, ensuring data integrity and consistency through validation and control procedures.
Webservice Integration Capabilities
- Developed IFS-based webservices for seamless data exchange with external platforms.
- Integrated and maintained APIs with partners such as Yurtiçi Kargo, Teknosa, and Vatan Bilgisayar.
- Built business logic to process, validate, and transmit data between ERP modules and external systems.
- Created services for WhatsApp support, SMS notifications, web synchronization, and IFS data fetching.
- Performed testing, troubleshooting, and documentation to ensure stable and reliable integrations.
- Collaborated with partner companies to establish and maintain robust communication channels.
- CRUD Operations: Implementing create, read, update, and delete operations in the database
- Data Analysis: Writing complex queries to analyze data sets
- View Creation: Creating virtual tables to shape data sets according to specific needs
- Trigger Management: Writing and managing triggers that automatically run after specific events
- Procedure and Function Development: Developing stored procedures and functions for repeatable and dynamic operations
- Packages: Grouping functionalities to create modular and reusable code structures
- Database Performance Optimization: Optimizing queries, indexing, and resolving performance issues
- ERP Integrations: Developing and testing business logic integrated with the database for ERP solutions
IFS Cloud
Using language of IFS Developer Studio, I developed customized pages for company named EVOFONE which operates as official distributor for manufacturers like Xiaomi.
The developed modules are used in the company's technical service department for operations such as product registration, basic data management, process status monitoring, shipment, invoicing, workshop operations, inventory management, and more.
These units are compatible with standard IFS units to create customized pages that take advantage of the operational components of IFS. I played a crucial role in developing the business logic of those pages using PL/SQL.
Interface Desing and Development
To increase efficiency, user satisfaction, and adoption rates while using the software, I focus on designing pages that meet these needs, thereby enhancing the user experience.
Although visual appeal is less important for users in an ERP system, it is still desired. Therefore, I put effort into designing pages that are not only aesthetically pleasing but also intuitively structured.
This project is developed by using IFS Developer Studio and PL/SQL. It is an ERP system that serves computer repairing business to create orders, managing employee data and more. I developed it to get familiar to the IFS environment in the early stages of my role.