Özer Ilerten Email & Phone Number

• Developed MIS screen reports on Yapi Kredi banking systems by collecting data from integrated databases using data programming tools.
• Created standardized reports for banking financials and score cards to enhance data analysis efficiency.
• Utilized data programming tools to extract and analyze data from various sources to support decision-making processes.

• Prepared Market Risk instrument data for business units using ETL daily, ensuring data quality methodologies were followed.
• Implemented sudden changes in legal or market conditions within the bank to the system.
• Administered all legal reports received through the ERMAS application.

Istanbul, Turkey

• Led the development of PL/SQL and file transfer processes for Yapı Kredi Treasury and Investment Products Department Transformation Project.
• Implemented data quality rules for Yapı Kredi Data Governance Office Data Quality Project using Informatica Power Center.
• Established a new data model for Yapı Kredi Internal Control Unit, ensuring efficient data flow and collection.

Istanbul, Turkey

• Developed and fixed ETL workflows on Informatica PowerCenter for daily ETL processes at TTNET.
• Collaborated with business analysts and development team on necessary developments for efficient data processing.
• Utilized programming skills in Teradata to enhance data processing capabilities.

Istanbul, Turkey

Computer-Assisted Audit and Fraud detection, Data Analysis consultation and user training on Lavastorm audit tool at CarrefourSA Internal Audit.

Following up the DW environment daily ETL window and trace the performance issues and take necessary actions. Analyse design and accomplish operational work requests coming from Business Departments as adhoc reports. Handover and give acceptance to deployment activities and schedule DW jobs on UC4 and AppWorx scheduler tools related to deployements..

Ankara, Turkey

Developing datamart via Informatica Powercenter ETL for the analysis of the processes involved in Acrual and Billing at Revenue Management, designing and reporting data models from the replicated data of CRM Acrual and Collection to be used in the Directorship of Revenue Management. (Programs and Database Used: Informatica Powercenter, Oracle, Teradata)

• Data Quality, Data Integration, Computer-Assisted Audit, Data Quality, Full Text Search, consultation and user training. Completed projects:
• Türk Telekom Customer Singularization Project: Creation of Cleansing and Golden Records with Informatica Data Quality and Informatica Identity Resolution Programs for customers on CRM.
• T.C. Sayıştay Bşk. Computer Aided Audit System Project
• Türk Telekom Revenue Assurance Project

Developing new version of LPack Leasing program via C# and Plsql

Informatics Institute, Information Systems

The Faculty Of Economics And Administrative Sciences, Public Finance

Education record