Caner Oguzkan
Verified Expert in Engineering
SQL Developer
Caner has been a business analyst, database modeler, SQL and PL/SQL developer, web service developer, and data analyst for six years. In all those years, he worked with various clients and had different roles in IT projects, from analyzing the requirements to developing the software and integrating different platforms. Caner has been a part of a scrum team and adopted Agile and Scrum methodologies in these projects.
Portfolio
Experience
Availability
Preferred Environment
SQL, PL/SQL, Tableau, Microsoft Power BI, Python, Oracle Forms, Oracle EBS, Microsoft SQL Server, PostgreSQL, SOAP
The most amazing...
...project was leading the team to develop the supplier portal with more than 1500 users.
Work Experience
Senior Enterprise Applications Developer
Roketsan
- Integrated Oracle ERP and third-party enterprise applications.
- Worked on data analysis and visualization with Tableau and Power BI.
- Developed Oracle E-Business Suite including Oracle Forms, Oracle Workflow, Oracle Personalization, XML Publisher, and OA framework.
- Acted as a member and the team leader in IT development projects.
- Developed logical and physical data model for enterprise applications and SQL, PL/SQL back-end development.
Experience
Supplier Portal
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.
BI Dashboards for Inventory Management
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.
Oracle ERP and Warehouse Management System Integration Project
Education
Master's Degree in Industrial Engineering
Middle East Technical University - Ankara, Turkey
Bachelor's Degree in Industrial Engineering
Bilkent University - Ankara, Turkey
Skills
Libraries/APIs
Oracle API
Tools
Tableau, Oracle Forms, Oracle Workflow, GitHub, Subversion (SVN), PuTTY, Oracle E-Business Suite (EBS), Microsoft Power BI, Oracle BI Publisher
Languages
SQL, Python, C++, XML, R, Java, GAMS, Excel VBA
Paradigms
Business Intelligence (BI), ETL, REST
Platforms
Oracle
Storage
Microsoft SQL Server, Database Modeling, PL/SQL, Database Architecture, PostgreSQL
Frameworks
Oracle Application Framework (OAF)
Other
Oracle EBS, SOAP, Data Engineering, PL/SQL Tuning, Data Warehousing, Data Build Tool (dbt), Operations Research, Genetic Algorithms, Scheduling, Industrial & Manufacturing
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