Caner Oguzkan

A web-based application for the suppliers of the company to become a member of the supplier network in order to monitor and sustain their procurement operations.

I was the team leader of the development team, and we adopted Agile methodologies throughout the project. In the project, we analyzed the client requirements and modeled the database. We also made back-end development by using PL/SQL.

The application has 1500+ users now, and it was sold to two defense industry companies, besides the fact it was designed just for the company I worked for.

I created many dashboards for internal clients in my previous job.

I used Tableau as a BI tool in this project. I created dashboards for so many areas, such as procurement, manufacturing, quality, and more. My experience in this project involves creating the data source by using SQL, creating the view with necessary queries and preparing the data for analysis, publishing the data source from Tableau Server to the specific users or roles, and finally data visualization by creating dashboards for the end-user.

This project was an integration project between a third-party warehouse management system software and Oracle ERP. I was the leader of this project. First, I determined the integration points of two systems, such as item information, receivables, inventory transactions. Then, I coordinated my team and we coded necessary SQL queries, and developed the web services that we needed for integration. Afterward, we developed the PL/SQL procedures and used Oracle APIs to pass the data into the Oracle ERP system.