Total Years of Experience: 14 Years, 1 Months
November 2014
To Present
DWH/BI Senior Specialist
at Vodafone
Location :
Türkiye - Istanbul
Managing Daily ETL that includes 5000 jobs and works daily/weekly/monthly. These Jobs are developed with PL/SQL, ODI, Microstrategy and Appworks for managing. Controlling Business Rules. to prepare Ad-Hoc reports.
Responsible for configuration the changes to the production Environment. Take ownership of criticial issues(technical/business). Migration changes between environment.
Develop and maintain solutions for the new and existing applications based on Oracle Data integrator, PL/SQL.
Design /develop and deployment Oracle PL/SQL code / Packages / triggers/cursors.
Interpret business requirements and assign tasks to other developers, especially analytics reports that includes segment information of all customers.
Manage and prepare document with impact analysis of any changes made to the database objects.
Responsible for configuration the changes to the production Environment. Take ownership of criticial issues(technical/business). Migration changes between environment.
Develop and maintain solutions for the new and existing applications based on Oracle Data integrator, PL/SQL.
Design /develop and deployment Oracle PL/SQL code / Packages / triggers/cursors.
Interpret business requirements and assign tasks to other developers, especially analytics reports that includes segment information of all customers.
Manage and prepare document with impact analysis of any changes made to the database objects.
October 2013
To November 2014
BI/DWH Developer
at Zain
Location :
Iraq - Baghdad
OCDM(Oracle Communication Data Model) Project using ODI, PL/SQL and oracle technologies for Zain(IQ). OLAP, Reporting, ODI Design, ETL, Job Schedule, Job Management, Providing Log Control, Working Under Pressure. Manage of end user Training with the customers.Coding and Documenting Reports components. Deploying reports on the application(ODI).
October 2012
To October 2013
DWH / ETL Developer
at T-Bank
Location :
Türkiye - Istanbul
Preparing 105 Legal Reports for BDDK that is a government's regulation foundation in Turkey. These Reports are daily/weekly/monthly. They are developed with Oracle Data integrator Tool.MDM(Master Data Management), CDC(Change Data Capture). Star and snowflake schema Designing. Master and metadata management.
Fully understand the Application Modules Database Designs and Schemas Ability to develop Functions, Triggers and Procedures.
Coding and Documenting Reports components.
Analyzing and diagnosing Reports problems and Errors.
Presenting Progress and Status Reports to the Section Head on a Regular Basis(reporting to custumers as a consultant).
Carrying out testing, running and finalizing developed Reports.
Deploying Reports on the Application(BO or Microstrategy).
Fully understand the Application Modules Database Designs and Schemas Ability to develop Functions, Triggers and Procedures.
Coding and Documenting Reports components.
Analyzing and diagnosing Reports problems and Errors.
Presenting Progress and Status Reports to the Section Head on a Regular Basis(reporting to custumers as a consultant).
Carrying out testing, running and finalizing developed Reports.
Deploying Reports on the Application(BO or Microstrategy).
April 2011
To October 2012
ETL Developer
at Turkcell
Location :
Türkiye - Istanbul
Preparing many reports using Microstrategy(Dashboard, Scorecard, ETL)
•For the Data Warehouse Team analyzing current data model. Reviewing ETL procedures and determining best path to migrate ETL from PL/SQL to Informatica. Maintaining their data models using Oracle development Tools.
• Created scripts, functions and tables to support the TOAD database application development project using PL/SQL.
• Business Intelligence (BI) reports, cubes, dashboards and analytics developed using Microstrategy.
• Data Warehousing (DW) solutions and know-how (strategy, methodology, full system development, etc.)
• ETL Life cycle, Design and Development with automated ETL processing
• Parameters and Control Tables
• SQL Programming: PL SQL, Transact SQL
•For the Data Warehouse Team analyzing current data model. Reviewing ETL procedures and determining best path to migrate ETL from PL/SQL to Informatica. Maintaining their data models using Oracle development Tools.
• Created scripts, functions and tables to support the TOAD database application development project using PL/SQL.
• Business Intelligence (BI) reports, cubes, dashboards and analytics developed using Microstrategy.
• Data Warehousing (DW) solutions and know-how (strategy, methodology, full system development, etc.)
• ETL Life cycle, Design and Development with automated ETL processing
• Parameters and Control Tables
• SQL Programming: PL SQL, Transact SQL
Share on Facebook
Share on Twitter
Share Via Email