Hakan Özden Email and Phone Number

• Designed, developed and implemented ODI/SSIS packages to load and transform operational data to the company's enterprise Data Warehouse and Data Mart. Develop and implement ETL routines according to the DWH design and architecture.• Analysis of the data sources, data profiling • Logical and physical design of the DWH • Experience in analyst ,design, development and test (end2end SDLC)• Preparing data pool for Data Mining projects• Tuned the ODI mappings for optimal load performance.• Implemented several Operational BI projects for service optimization and customer satisfaction• Created models for new data warehouses and changes to existing ones.• Ensuring the data warehouse data quality• Developed unit, system, and integration test plans.• Developed reports with Business Objects / Microstrategy and administration of Business Objects / Qlikview / Microstrategy• Upgrading ODI 10.1.3.4 to ODI 11.1.1.7• Upgrading and managing SAP BI 3.1 to SAP BI 4.0• Upgrading and managing SAP BI 4.0 to 4.1• Maintained daily ETL processes

• Management of outbound call (IVR – PDS)• Developing projects that will increase IVR usage• Developing scenarios to satisfy end user and customer requirements, and support for the updated content• Increasing the service variety• Creating new scenarios to increase channel usage and monitor these processes• Performance testing for new developed projects

Application Developer• Developing and managing EVTURKCELL (8008) IVR service. (PL/SQL, Wingspan )• Developing IVR and SMS services with Wingspan SCE on MSP using PL/SQL• Writing the base reporting component for 3rd party firms with Java Servlet, JSP and PL/SQLMobile Operation Manager• As a Project Manager;• Managing relationship with third parties• Preparing monthly reports • Defining the project scope• Time-cost-scope management• Closing projects and reporting

Software Developer• Cep Dünyası is one of the biggest partners of Turkcell, developing VAS (value added services) for Turkcell. • Developing IVR services with Miracle using T-SQL• Writing the base reporting component, customer relation management system and content management gui for melody services which serves inside the local network and also for the other 3rd party firms. (T-SQL, Java Servlet, ASP)• Install , Maintain and Backup of Servers and services including SQL Servers, IVR servers (15 servers,2750 ports) • Developed Service like SekretercellÖzel which is one of the most called service in the Turkcell. With SekreterCellÖzel it is possible to be greeted with a special message according to subscribers choice(mobile is busy, not responding etc) and the messages are kept in the voice mail system. • MOBILARKADAS is the biggest chat IVR application inside the Turkcell network. Responsible for developing, maintaining and backuping in Turkcell,Avea and Telsim networks. Also developed familiar chat services like Chatwalk, ChatMagic, ChatFriend and MobilArena.• Voting Services : Akademi Türkiye, Anadolu Ateşi, Bu Toprağın Türküsü,Size Anne diyebilirmiyim,İkinci Bahar for Turkey’s most watched TV channels KANALD and ATV.• Creating WAP pages for cepdunyasi.com.tr domain wap.cepdunyasi.com.tr and wap.mobilarkadas.com