ÜMİT EGBATAN
IT Quality Assurance Expert
Kartal
Summary
I managed the project of establishing a reporting system by integrating the performance data of all systems in Türk Telekom IT unit with ODI 12c including ODI installation.
After the installation of open source Metabase, I created interactive dashboards and reports, allowing IT managers to easily monitor system performance.
I applied parallel processing and data compression techniques to deal with large data volumes.
I developed performance queries using SQL and PL/SQL and increased system performance by 20%.
Overview
19
19
years of professional experience
5
5
years of post-secondary education
1
1
Language
Work History
IT Quality Assurance Expert
Turk Telekom
İSTANBUL, TURKEY
12.2010 - Current
- To develop ODI interface, packages and Knowledge Module in order to collect transcation data to calculate KPI
- To develop PL/SQL packages, functions, procedure in order to prepare Dashboards data and also to prepare User Report's
- To develop complex SQL queries, Performance Tuning present SQL queries
- To develop Unix Shell Scripts for executing ODI objects and PL/SQL packages
- To improved present ETL's performance and following PL/SQL package up performance
- To manage Dataquality Problems, solving ETL crashes
- To define the quality standarts of IT services by means of KPIs, KQIs and SLAs in order to meet the subscriber satisfaction
- To monitor and prepare detailed performance and quality reports of each service & platform by using predefined KPIs, KQIs, SLAs, etc
- Preparing special reports and presentation graphics for upper management to periodically present the improvement in the quality of the platforms and services
- Defining IT services quality standards through KPIs, KQIs and SLAs to ensure subscriber satisfaction
- Using defined KPIs, KQIs, SLAs etc
- To monitor and prepare detailed performance and quality reports of each service and platform
- Preparing information about other network and IT departments in order to prevent any performance and quality problems from occurring
- Preparing quality assurance summary data and dashboard for the OPM (Operation Performance Metrics) interface
- Optimizing general test of Quality Assurance Platforms, finding and reporting problems with optimization solutions using performance tools
- Running and managing the performance monitoring tool and similar tools developed by Turk Telekom to prepare reports user friendly and automatic with prepared statistics
- Writing PL / SQL packages to make the data obtained from ETL packages ready for reporting and interpretation
Service Administrator
TURKCELL
İSTANBUL, TURKEY
12.2005 - 12.2010
- Creating and correcting reports for BUSINESS services and VAS information services
- Correction of inconsistencies at finance-business-pricing structure of TURKCELL(SMS-IVR-MMS subscription packets) services
- Develop and implement the strategies, procedures and policies to maintain knowledge management
- Detection of VAS correction, service errors and detection analysis
- Preparing SQL sript/views that prevents for pricing report errors before start-up of services
- Creating improvements for easy acces of Business and other groups to pricing and service subscription details
- Correction of VAS(Value Added Services) Prepaid-postpaid platforms inconsistencies
- Detecting and correcting faulty/missing definations in Charging-Rating and Business finance portal
- Creating scripts to check pricing errors for built-in and third party SMS, MMS, IVR and subscriber services after startup
- Writing SQL codes to test errors for batch billing and configuration changes
- Writing SQL codes to check errors contents before Rating&Charging
Education
System Engineering - Industrial Engineering with scholarship
YEDITEPE UNIVERSITY - FACULTY of ENGINEERING
İSTANBUL 10.1998 - 02.2004
Skills
Data processing
ETL processes
ODI (Oracle Data Integrator) development
BI reporting systems
Oracle
PL/SQL programming
Unix Systems
Unix shell scripting
PYTHON
Open source UI
GSM and telecommunication systems
Project Management
troubleshooting
solving
TCP/IP
switch and router configurations
different routing protocols
Trainingsandseminars
Datascience Bootcamp October 2024 İstanbul Datascience Acedemy
No Code AI Bootcamp December 2023 İstanbul Datascience Acedemy
Control yourself and your stress February 2019 TurkTelekom Academy.
ODI 12c Admin April 2018 Method IT Academy.
Data Science March 2018 Bilginc IT Academy
Oracle Big Data Fundementals June 2017 Method IT Academy
Oracle Shell Scripting April 2017 Method IT Academy
ODI Development September 2016 Kuark Software
PMP exam preparation training May 2016 Turk Telekom Academy
Java Development June 2013 Bilginç IT Academy
ORACLE 11G:SQL&APPLICATION TUNING May 2013 Bilginç IT Academy
Oracle Advanced PL/SQL May 2009 Turkcell Academy
Oracle PL/SQL February 2009 Turkcell Academy
UNİX Administration 1,2,3 December 2007 HP İstanbul
Solaris System Administrator May 2006 Turkcell Academy
Hobbiesandactivities
- Fishing
- Scuba Diving (Two star diver)
Rewards
Turk Telekom Momentary Rewards, By installing the open source code metabase application in accordance with Türk Telekom Security policies, I ensured that the existing 200 reports and dashboards are created on the metabase and the reports and dashboards are presented to the end user with visual graphics.
Turk Telekom Momentary Rewards, Thanks to the work carried out, the metrics that the IT Operations departments self-measured and reported were started to be reported automatically from a single source and with an impartial eye. 919 metrics have been made automatically measurable., Process studies have been made to measure some metrics. Necessary measurements have been started to be made within the framework of the process., As a result of the study, 93.4% of the metrics determined for the mobile side have been automated and the same studies are continuing on the FIX and BB sides. (OPM metrics are still being reported every month in IT Operations Directorate for Mobile, Broadband and Landline)
Timeline
IT Quality Assurance Expert
Turk Telekom
12.2010 - Current
Service Administrator
TURKCELL
12.2005 - 12.2010
System Engineering - Industrial Engineering with scholarship
YEDITEPE UNIVERSITY - FACULTY of ENGINEERING
10.1998 - 02.2004
Similar Profiles
Arda Cem YilmazArda Cem Yilmaz
Customer Experience Specialist at Turk TelekomCustomer Experience Specialist at Turk Telekom
MURAT BOYNUEGRIMURAT BOYNUEGRI
Project Manager at Turk TelekomProject Manager at Turk Telekom
Elena AndroneElena Androne
Purchasing Manager at EUROWEB ROMANIA SRL (TURK TELEKOM INTERNATIONAL GROUP)Purchasing Manager at EUROWEB ROMANIA SRL (TURK TELEKOM INTERNATIONAL GROUP)