Ilteriş Mutlu

Working on project bases which aims to increase bank profitability in agile methodology. Develop ETL’s via ODI on Datawarehouse and DataMart’s. Develop CDC or incremental tables on ODI according to business needs. PowerDesigner is used for modelling by considering Kimball Model. Enhance performance of main ETL flow. Solve complex SQL performance problems. IBM ClearCase and ClearQuest are used to deploy.

Worked for Istanbul Metropolitan Municipality as ODI, PL-SQL Developer. ETL developed on ODI. ODI Knowledge Modules were improved. Coded and scheduled a package which can automatically add daily, monthly and yearly Range Partition of a table. ODI, KM was updated for truncate partition. Managing, modelling and upgrading of OBI. Several dynamic and static SQL/PL-SQL codes are tuned for performance. By using tuning technics and parallelization total time of main ETL flow was reduce by half.

Worked for ING Bank Turkey as a qualified PL-SQL developer. Coded several ETL with these technologies considering code quality rules of PL-SQL and ODI. Modelled considering Star Schema, Snow flake by using PowerDesigner. Used advanced PL-SQL Statements, objects were used like pipelined functions, analytic functions, loops, bulk processing, user defined exceptions, types, package, partitioning, pivot etc. SQL’s were tuned considering explain plain.

Worked for Izmir Police Headquarters. New features added on existing Central City Surveillance software by using TCL and PL-SQL languages. Bugs were fixed using TCL and PL-SQL languages and customized considering customer needs. Trained end-users on central city surveillance for a month. End-user needs were analyzed and improvements were implemented accordingly. Plate Recognition System runs on Microsoft SQL. I maintained the DB, solved SQL performance issues.