Tunay O.

♣ Performed user requirement analysis and improved transformation methodology from digitized maps on CAD to GIS environment. The project steps are summarized below: o Data organization ♣ Sheet name standardization ♣ Vector and raster data type organization o Raster Data Processes ♣ Georeferencing of geological maps ♣ Clipping of geological map according to the sheet border at 1:50000 scale. ♣ Mosaicking of the map o Vector Data Processes ♣ Creation of point and line layers on GIS environment from CAD. ♣ Merging line and point layers one by one according to TPAO region border ♣ Eliminating topological error because of CAD digitizing ♣ Sheet edge matching ♣ Forming polygon layer (geologic formation) by using line layer o Correction of formation borders and faults on GIS environment o Mapping processes ♣ Import the formation name from points of digitizing data into formed polygon data. ♣ Creating thematic maps by using formation layer according to the geologic legend. ♣ Import digitized dip and strike data after the correct notation by using my own script. ♣ Performed user requirement analysis and improved the ArcGIS tool on Tablet Pc for making geologic maps during the field work. ♣ Performed user requirement analysis, designed relational database by GIS and tabular data and improved the field work information system based on querying of the geological map versions and who works which versions on ArcGIS Desktop Environment. ♣ Performed user requirement analysis and improved the design and implementation methodology of recreation of available spatial database based on GIS data belongs to Exploration Department. The steps are: o Spatial Data Selection ♣ Produced spatial data (well, seismic, license, gravity, magnetic, geological data) by TPAO, ♣ Cultural spatial data, ♣ Raster data (satellite images, dem, topographic maps, etc.) o Spatial data access by using versioning technology o Metadata of spatial data creation o Spatial data services creation ♣ Implemented Raster Data Processes (georeferencing, clipping, mosaicking, image processing operations) ♣ Implemented Vector Data Processes (digitizing, coordinate and datum transformation, correction of topologic errors and vector data analyses). ♣ Loaded, manipulated, analyzed, queried and reported of seismic, well, geology, license and other spatial and tabular data. ♣ Assisted in integrating and managing spatial, tabular and raster data from various internal and external data sources into the ArcGIS/ArcSDE environment. ♣ Provided inputs from multiple sources to the design and management of GIS databases, tools and applications. ♣ Developed and performed spatial and tabular data queries for internal and external users ♣ Reviewed data entered into staging database by multiple sources, checking the staged data for completeness, accuracy and compliance with determined data structure standards. ♣ Provided GIS data to Petrobank, Landmark (Halliburton), Geology &Geophysics (Halliburton) and Petrel (Schulumberger) databases. ♣ Perform datum transformation (from International 1924 to WGS84) quality checks of seismic, well and license data for importing to Petrobank, Petrel, etc. databases. ♣ Create statistics ♣ Coordinated the communications between TPAO and relevant governmental departments for the GIS data acquisition. ♣ Implemented GIS operations and analyses such as Overlay, Surface, 3D, Proximity, Geovisualization, Multicriteria Decision Analysis, Spatial. ♣ Obtained statistics from spatial data or tabular data as desired formats (how long seismic lines in a specific license, how many wells in the North Sea, etc.). ♣ Plotted and monitored the spatial, tabular and raster data according to desired cartographic representation. ♣ Provided cartographic representation of well and geologic legend in ArcGIS environment. ♣ Designed print templates according to cartographic standardization for used datum (International 1924 and WGS84) and projection systems (UTM zones and Lambert Conformal Conic) on ArcGIS environment. ♣ Performed complicated data conversion (from aster DEM to .csv, from .dxf to shape file, etc.) and data format conversion (form vector to raster data, etc.). ♣ Created 3D model of General Directorate Department of TPAO campus by ArcScene. ♣ Produced vector and raster data from available data such as created hillshade from SRTM DEM, digitized settlement point from topographic maps, created vector data from tabular data, integrated vector data on GIS environment and related tabular data in excel dbf format, etc. ♣ Created thematic maps for desired purposes (one of these thematic map was prepared according to well condition and the well distribution on TPAO regions). ♣ Created custom symbols on ArcGIS environment for specific proposes. ♣ Performed Automated or Semi-Automated digitizing by ArcScan. Implemented the morphologic operations on raster for clean-up. ♣ Designed the datum conversion tool from International 1924 to WGS84 datum by using ArcGIS Model Builder and 3D Analyst. ♣ Made the Well Planning System Geoportal by using Flex and ESRI software. ♣ Implemented ArcGIS Desktop on PC and tablet Pc, ArcSDE, ArcGIS Server, Oracle, Sql Server on PC setup’s ♣ Performed the ESRI software updates. ♣ Given datum and coordinate reference systems, cartography and GIS training and prepared the training documentation.