Sql Server
Resume:
BERK TUN Ç EL
SE NI O R TEC HNI CAL CO NS ULTANT BUS İ NE SS I NTE LLI GE N CE DEPARTME NT
Birth Date: 27/07/1987 Telephone: +90-212-***-**-** Mobile: +90-535-***-**-**
E-Mail: **********@****.*** Driver’s License: B Class
Linkedin : www.linkedin.com/in/berktuncel
SUMMARY
Ambitious and self-motivated Technical Consultant with a strong technical background and 2.5 years
of work experience. Also have experience working for major corporate clients in several challenging
projects. Proficient in the development of ETL (Extract, Transform, Load) processes with a good
understanding of source to target data mapping, ability to define. Very good knowledge in SQL,
PL/SQL and in Data Warehousing concepts.
EDUCATION
YEDITEPE UNIVERSITY Istanbul, TURKEY (2005 2013)
Computer Engineering ( Computer Science )
HASAN POLATKAN HIGH SCHOOL Istanbul, TURKEY (2001 2005)
LANGUAGE SKILLS
English : Advanced
Deutsch : A1
COMPUTER SKILLS
MS SQL SERVER (2008 2012),RDBMS Oracle 10g, Oracle APEX, SSIS, SSRS, SSAS, C, C++, C#
SQL, PL and SQL, MySQL, Beqom, Excentive, MS Office, SQL Developer, MS Visual Studio 2012,
T SQL, MS Reporting Services
EXPERIENCE
SMARTIKS IT SERVICES INC (10, 2012) Present
Business Intelligence Consultant, Technical Consultant
PROJECTS
TURKCELL (Turkish Telecommunication Company)
Worked on Excentive(Beqom) platform
Plan, design, and implement application databas e code objects
Develop SQL scripts, indexes, and complex queries.
Identify business requirements and provide solution options.
Identify the data issues and provided solution options for resolution.
Involved designing and debugging SSIS packages.
Performed unit testing of developed solutions.
Developed and maintained SQL scripts in Microsoft SQL Server.
Identified and specified complex business requirements and processe s.
As part of a team, created various reports according to the business requirements
for the company.
Meeting clients face to face and on site to ascertain requirements.
S UNRISE COMMUNICATION AG ( Switzerland )
Involved in the support, maintenance and development of critical systems
Worked on Excentive platform
Designed, developed, tested, tuned, and implemented relational databas es and
procedural databas e code.
Ensured that the existing data warehouses, reporting systems and various tools
w ere adequately supported
Deployed and managed reports using SSRS.
Developed and maintained SQL scripts in Microsoft SQL Server.
Creating ETL/SSIS packages to extract data from various sources like Excel, Flat
files to SQL Server systems using different SSIS components and used dynamic
c onfiguration files and variables for production deployment.
Creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views
a nd SQL joins for applications
FRITOLAY PEPSICO.
Created various reports according to the business requirements for the company.
Meeting clients face to face and on site to ascertain requirements.
Created complex Stored Procedures
KKTCELL ( NORTH CYPRUS TURKCELL TELECOMMUNICATION )
Involved designing and debugging SSIS packages.
Worked on Excentive platform
Developen and deployed reports using SSRS
Handled SQL s erver 2008 databas e and created many procedures.
Developed SQL scripts, indexes, and complex queries
UNDERGRADUATE PROJECT (TELECOM OPERATOR DATA WAREHOUSE
SIMULATION)
Created PL/SQL stored procedures, functionsandpackages for moving the data
from staging area to data mart.
Created indexes on the tables for faster retrieval of the data to enhance database
p erformance.
Used PL/SQL to create Packages, Functions, and Procedure.
Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and
e rror capturing into log tables.
Extensively used the advanced features of PL/SQL like Records, Tables, Object
types and Dynamic SQL.
Creation of databas e objects like tables, views, materialized views, procedures and
p ackages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
Created various reports using ORACLE APEX
REFERENCES – Available on request.
Contact this candidate