YY

Yigit Yukselir

available

Last update: 15.09.2014

Principal Consultant

Graduation: Bachelor(4)'s in Computer Studies and Information Technology
Hourly-/Daily rates: show
Languages: English (Full Professional) | Turkish (Native or Bilingual)

Keywords

Microsoft SQL Servers Agile Methodology Apple IOS Business Intelligence Data Warehousing Oracle Applications SQL Databases SQL Server Integration Services Telecommunications Unix + 26 more keywords

Skills

Cognos, Oracle, SQL Server, Data Warehousing, Business Intelligence, Software Project Management, Agile, Scrum, Visual Basic, ODS, Abinitio, People Management, Telecommunications, OLAP, ETL, Oracle Warehouse Builder, Crystal Reports, Shell Scripting, Teradata, Mac OS X, Microsoft SQL Server, Agile Methodologies, Microstrategy, Requirements Analysis, Data Marts, SQL, Performance Tuning, Unix, PL/SQL, Testing, Data Modeling, Management, OS X, HP Database Archiving, HP Application Information Optimizer, SSAS 2008, Toad, SSIS, Data Quality, Data Integration

Project history

Kafein Software
DWH/BI Consultant
05.2012 - today
I'm working at Kafein as a DWH/BI consultant. As an consultant I participate in many projects. You may find brief descriptions about them.

I’ve worked at Turk Telekom project as a consultant for Teradata Turkey. My role heavily depended on my SQL development skills. As an experienced programmer within Telecommunications sector I mainly work on Subscription and CDR records. During my time at the project I was responsible of migrating existing T-SQL, PL/SQL and C# codes and Stored Procedures to Teradata and developing new requests as necessary. I was also developing test scripts with SQL for testing.

I've also completed a project at Turkcell as a consultant for Teradata Turkey. I worked as a Cognos developer and with Framework Manager (10) for n-tier modeling. My point of interest was 2G and 3G network data modeling for BI purposes.

I'm currently working at Turkcell, on the data archiving project. I develop models to archive cold data to the archiving server. Currently the developing medium is HP Application Information Optimizer also known as HP Database Archiving.
Computer Software
51-200 employees

Turkcell Teknoloji - TURKCELL
Specialist - Quality Assurance
02.2009 - 05.2012
My role at Turkcell Technology (present employer - http://www.turkcellteknoloji.com.tr/) requires me to work on huge amounts of data to maintain quality assurance for BI projects and use Oracle (PL/SQL, Oracle Warehouse Builder, Oracle Data Integrator) extensively. As a QA Engineer I’m responsible for data quality, software quality and examining if the project needs customer requirements. I both run glass box and black box tests to do so. I participate in Agile Scrum projects and work cross functional as developer, analyst and test roles. I also use other tools such as Sybase Power Designer to read the analysis documents, TOAD as an IDE, Microstrategy for end user reports, HP Quality Centre for test reports and issue management and Maximo for incident management and HP Project and Portfolio Management for project management.
Telecommunications
201-500 employees

Ereteam
Senior Cognos BI Consultant
09.2007 - 02.2009
Ereteam Consulting was the sole distributor of Cognos products before IBM buyout and continued to be a primary partner after IBM. My role as a Senior Consultant was to give consultancy and work as a project resource in given projects. I was responsible of all Cognos Studios (Report Studio, Analysis Studio, Query Studio, etc.) and Transformer for creating OLAP cubes. I also worked in joint projects for giving a complete solution to customers using Cognos Planning and BI packages. I’ve worked in many projects including companies like Vak?fbank (Banking), Vodafone (Telecommincations), Fevzi Gandur Denizcilik (Shipping), Domino’s Pizza (Retail), Estee Lauder (Retail), Akkok Holding (Energy). I’ve used Cognos BI products & OLAP for business intelligence needs, Oralce, MS SQL Server, SSIS for datawarehouse and ETL (SSIS, DTS) needs and Cognos SDK(Visual Basic .NET) for customizing whenever necessary. I’ve also given much official training like Transformer, Fast Track from small groups to large audiences.
Information Technology and Services
11-50 employees

IPER Ltd. Sti. Istanbul
Programmer/Analyst
01.2002 - 02.2005
Developed and maintained adidas-Salomon Turkey's POS and Inventory system with VB 6.0, MS SQL Server 2000, MSDE and Crystal Reports 8.0 and 9.0. Developed and maintained adidas-Salomon Turkey's pre-ordering tool with VB 6.0, SQL Server 2000, MSDE and Crystal Reports 8.0 which is also being used in Bulgaria, Romania, Cyprus and Israel. Developed and maintained an Automatic Data Transfer program with VB 6.0, MS Access and RAS which synchronieses over 25 shops to the headquarters of our customers daily after the shops are closed. Developed and maintained a inventory and price control program with OVAL to be used at PSION PTC handheld devices. Also created help files with MS Help compiler for these programs and give phone and onplace support when necessary.
Computer Software

Local Availability

Only available in these countries: Turkey
Avaliable from November 2014
Profileimage by Anonymous profile, Principal Consultant Principal Consultant
Register