ALI AKTEPE

Game Provides a unique Logistic Company simulation to it's users. Instead of generic games that found in the market, there are no limitiations forced to players like energy or mandatory advertisement.

As government website did not provide any API, I have used webscraping techniques to obtain information about status of user's vehicle's taxes and traffic fines. Application was automatically collecting information and was showing to user as summary.

Website that I was scraping from was updated and I did not had time to update my application. Therefore application is unpublished.

My first application to understand Java and Android Ecosystem. Application was developed to help indecisive users make a decision. Application was unpublished as there was little to improve and I did not have time.

Management of Punches (Exception Item Lists) in infinite categorization

Responsibles from each department (Construction, Engineering, Quality Control, Procurement) has access to TOMS to see live status of the punches and take action on them cooperatively to close punches and finalize the project.

To simply put, all permitted users can check, review and close punches. While doing so they have the ability to add their comments, add documents (drawings, pictures etc) to related punch items.

Users can filter punches by Unit (PMCC for this specific project), Subsystem, Category, Discipline and Department. Also system for appointing specific users to punches is under beta testing and will be live soon.

As per site requirements, an offline mode has been implemented to the system. So that users can go to site with their mobile devices, check and take action on punches without an active internet connection with help of PWA.

Live Punch Status Reporting

System is generating live reports any time a user wants to access them.

Certification Status Reporting

Based on Quality Department's data, TOMS is providing certification reports based on unit, subsystem and discipline.

Test Pack Management

Specifically for O&G projects, system has ability to manage and follow test packs inside the project. Including the punches generated under the test packages.

With aim to help the enviroment, test packs has been digitalized. Using TOMS, we have generated a detailed system for managing test packs, so that we prevented print-out of the test packs. Instead all walkthroughs for test packs are done using tablets connected with TOMS, which can work in offline mode. As this system contains most up-to-date information on test packs (like isometrics and P&IDs) users are able to access them on site with ease.

Loop Folder Management

Similiar to the test pack system, we are implementing a system for loop folders. As project is progressing, we will start beta testing for this new system.

Summary

TOMS is a total system for completion of the projects. With four main objective:

• Help coordination in-between departments
• Real-time reporting for management
• Help enviroment by preventing unneccesary usage of paper
• Centralizing all information on project to synchorize the team

Generation and Follow-up of Project Schedule

As Primavera is an industry standard, this was the most challenging step. I did not want to re-invent the wheel by writing a software doing the same things as Primavera is doing but still the software should have helped it's users to generate and follow the schedule without an extra effort. Solution for this problem was to use both Racoon and Primavera in synchorization.

In Racoon, users can generate areas and work tasks under each area among with quantities for each task. In Racoon managing users will input the factors (Qty/MH) for each specific task. Or if they want, they can appoint specific factors for each area/work.

Based on this data, Racoon is able to generate an .xer import file for Primavera to use. Then user can link these activities in Primavera (as P6 is already doing this task perfectly) and export->import to Racoon the updated .xer file.

After this first synchorization, users will follow the delays and critical paths through Primavera, while Racoon is feeding Primavera with actual completion percentages.

Note: Based on needs, it's possible to completely bypass Primavera and develope a module for Racoon to handle tasks handled by Primavera..

Generating Reports

Users with related permission can generate daily, weekly or monthly reports. To generate the report user only needs to select report related area, work and responsible person. System is automatically generating periods based on selected criterias and follow them.

Racoon will send reminders to responsible users to complete their reporting. When responsibles complete their part, another responsible (assuming Project Control Department) will check these reports and approve them.

Reports will be dynamically generated and will be accessable through Racoon. No need to generate excel files and fill inboxes with report mails. Any user (with enough permission) can check any report with any cutoffdate at anytime.

In case of any delay in the reporting, Racoon will show the bottleneck of the report. Whoever did not complete their responsibility on the report, will be shown on the report screen as cause of the delay.

Progress Payments (Under Development)

As all works are reported through Racoon, system will be able to generate one-click progress payment calculations with or without price.

Cost Control (Under Development)

With the assistance of the Progress Payment module, Racoon will be able to help Cost Control teams with their analysis.

Summary

Racoon will be a software to help the team on Construction Projects with Progress Monitoring, Scheduling, Payments and Cost Control.

In the project I started as Turnover Coordinator (Deputy Manager), as actual Turnover Manager did not report to site, project director has given me the responsibility to manage the Turnover Department.

• Handpicked and managed all thirteen members of the department,
• Developed web based Turnover Management System (TOMS) to manage project completion and turnover,
• Helped develop other in-house system by interfacing with the departments,
• Represented the department in Management and Client meetings,
• Proudly assisted in development of new generation systems like tablet punch management system,
• Handled Turnover procedures and Commissioning of the units,
• Prepared Turnover Dossier structure.

• As the HCS Leader, I acted as Deputy Manager in the project,
• Led a team of four to handle Handover Completion System (HCS),
• All departments were using seperate databases and were sharing weekly excel reports. I linked all the databases under one unified system to provide project wide real time completion reports instead of weekly excel reports,
• Managed Handover Database as leader of the team,
• Prepared a MS Access tool to handle registrations of official communication documents,
• Prepared system for automatically generating Handover Dossiers to clien,
• Helped commissioning department to coordinate with construction department,
• Arranged meetings with Construction Team to make sure they are aligned with commissioning priorities.

• As the HCS Leader, I acted as Deputy Manager in the project,
• Led a team of four to handle Handover Completion System (HCS),
• Started in the middle of a delayed project. Was part of a backup team send to recover the delays,
• Build a local database for easier data management from scratch,
• Prepared detailed reports to analys the status with commissioning and construction teams,
• Provided completion progress forecast schedules to recover from the delays,
• Re-arranged structures of existing reports to use database links instead of excel macros which were taking hours to complete.

In this mega project, I worked in two different roles. I started as Project Control Engineer. My old collegues from Project Control Department were building up the Handover department and they asked me to join them as Database Analyst (System Completion Analyst).

• I handled progress monitoring and reporting of three units in this role,
• Handled weekly and monthly updates of Primavera schedules,
• Prepared some basic excel macros to automatize my tasks,
• Prepared an excel macro for Construction Piping team to visualize status of spooling of the pipes,
• Built a web based reporting system (PHP, MySQL, JavaScript) to provide fully automated reporting for our manager in the meeting. System was automatically collecting information from all reports and site photo archive to generate most up-to-date report in real time. As this tool was small my opinion, I did not given it a name and it's not actually included in my portfolio.

• I started as Database Analyst in the department. But as Database Leader take other responsibilities, I took over his role,
• Generated system completion reports for commissioning teams,
• Developed a small tool using VB.Net for our team. Instead of searching for signed inspection documents (each inspection contained hundreds of page) for each equipment under a subsystem, using this tool our team was able to only put subsystem number and tool generated Handover Dossiers automatically. It checked for status of each punch item, and pulled all related documents from QC File server. Then using QR Recognotion it find and pulled related single page in the inspectons. This tool saved countless valuable hours for our team,
• As usual, I automatized every task I had. Then spoke with the manager to take more responsibility as System Owner (Handover Coordinator). He has given me responsibility of three units and while also completing my tasks as System Completion Analyst, I succesfully delivered three units to the client.

As sole Project Control Engineer responsible of planning in this project;

• Handled quantity surveying,
• Prepared daily, weekly and monthly reports for the client,
• Prepared excel macro for progress payment department to calculate payments of piping discipline,
• Prepared Primavera schedule updates,
• Solved problem of having three different weldng report from three different source by preparing an automated excel tool which was crosschecking all joints in each seperate report and preparing a final trustable report.

As sole Project Control Engineer responsible of planning in this project;

• Handled quantity surveying,
• Prepared daily, weekly and monthly reports for the client,
• Prepared Primavera schedule updates,
• Prepared 3D drawings of the project in AutoCAD and then REVIT to present a 3D progress report,
• Noticed three critical production mistakes and made sure they are fixed.