DWH/BI Senior Specialist
Vodafone
Total years of experience :13 years, 1 Months
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.
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).
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).
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
Computer Engineering in University of Sakarya. My thesis was to provide environment Oracle RAC(Real Aplication Cluster for 3 nodes)