Priman 2000 Ltd Logo

CURRICULUM VITAE

Personal Information

Name Surname Mr. Gürsel KAIS
Qualifications B.Sc. in Computer Engineering
M.S.c in Computer Technology in Manufacture
Nationality British
Contact Details Click to E-mail

Experience Summary

An IT professional with a comprehensive working knowledge of data warehousing using ORACLE, SQL Server, OWB, SQL, PL/SQL for Extract Transform and Load (ETL) processes and the COGNOS BI toolset for reporting (Impromptu, PowerPlay, PowerPlay Transformer, IWR, PowerPlay Enterprise Server, Upfront, Decision Stream, Access Manager).

Work Experience

APR10 – MAY10 : AQA - Guilford, UK

Data Warehouse Developer

I have worked as a Data Warehouse (ORACLE 11g, ETL, PL/SQL, OWB11g, SQL) developer for AQA in Guilford, Surrey.

As a developer, I was involved in enhancement and tuning of Results Re-Engineering project, modifications made to existing tables to support the new requirement.

Software and Tools Used :

ORACLE, DATA WAREHOUSE, SQL, PL/SQL, OWB

MAR09 –OCT09 AQA - Guilford, UK

Data Warehouse Developer

I have worked as a Data Warehouse (ORACLE 11g, ETL, PL/SQL, OWB11g, SQL) developer for AQA in Guilford, Surrey.

As a developer, I was involved in two projects, Results Re-Engineering and Enhanced Results Analysis. I used OWB and PL/SQL to populate tables in the data warehouse and created some Materialized Views and Views to support the Java front end for reporting.

Software and Tools Used :

ORACLE, DATA WAREHOUSE, SQL, PL/SQL, OWB

OCT08 – JAN09 KINGSWAY COMMUNICATIONS LTD - Eastbourne, UK

Data Warehouse Developer

I have worked as a Data Warehouse (MySQL, SQL, MS Access and BI report) developer for Kingsway Communications Ltd in Eastbourne, East Sussex.

As a developer, I was involved in Reporting Database (Data Warehouse) enhancement project and designed and developed some parts of the MySQL dimensional database and Access forms and reports in order to fulfil the gathered new user requirements.

Software and Tools Used :

DATA WAREHOUSE, SQL, MySQL, MS ACCESS, VB

OCT07 – FEB08 KINGSWAY COMMUNICATIONS LTD - Eastbourne, UK

Data Warehouse Developer

I have worked as a Data Warehouse (MySQL, SQL, MS Access and BI report) developer for Kingsway Communications Ltd in Eastbourne, East Sussex.

As a developer, I was involved in New Reporting Database (Data Warehouse) project and designed and developed some parts of the MySQL dimensional database and Access forms and reports in order to fulfil the requirements gathered by one to one consultation with the users.

Software and Tools Used :

DATA WAREHOUSE, SQL, MySQL, MS ACCESS, VB

NOV06 – MAR07 TOUCAN.BIZ LTD - Brighton, UK

Data Warehouse Developer

I have worked as a Data Warehouse (MySQL, SQL, VB and MS Access form and report) developer for Toucan.Biz Ltd in Hove, Brighton.

As developer, I was involved in one data warehouse project and designed and developed some parts of the MySQL dimensional database, Access forms and BI reports in order to fulfil the requirements.

Software and Tools Used :

DATA WAREHOUSE, SQL, MySQL, MS ACCESS, VB

APR06 – MAY06 TOUCAN.BIZ LTD - Brighton, UK

Data Warehouse Developer

I have worked as a Data Warehouse (MySQL, SQL, VB and MS Access) developer for Toucan.Biz Ltd in Hove, Brighton.

As developer, I was involved in one data warehouse project and designed and developed some parts of the MySQL dimensional database and Access forms.

Software and Tools Used :

DATA WAREHOUSE, SQL, MySQL, MS ACCESS, VB

OCT05 – FEB06 SOUTHERN WATER PLC. - Brighton, UK

Data Warehouse Developer

I have worked as a Data Warehouse (ORACLE, ETL, PL/SQL, Cognos Decision Stream, Cognos Impromptu and Cognos Powerplay Transformer) developer for Southern Water Plc in Falmer, Brighton.

As developer, I was involved in one project (EA Landfill Datamart). I designed and developed ETL scripts (used TOAD to tune the scripts) and Cognos Decision Stream catalogues to create the required datamart based on Kimball’s Dimensional Model. And I successfully delivered Improptu reports and powerplay cubes to meet users’ reporting requirements gathered by one to one consultation with the key users.

Software and Tools Used :

ORACLE, DATA WAREHOUSE, PL/SQL, SQL, DECISION STREAM (7.1), IWR, POWERPLAY ENTERPRISE SERVER, IMPROMPTU, POWERPLAY TRANSFORMER, UPFRONT (7.3)

OCT04 – JUL05 SOUTHERN WATER PLC. - Brighton, UK

Data Warehouse Developer

I have worked as a Data Warehouse (ORACLE, ETL, PL/SQL, Cognos Decision Stream, Cognos Impromptu and Cognos Powerplay Transformer) developer for Southern Water Plc in Falmer, Brighton.

As developer, I was involved in three different projects (Waste Water Compliance Data Mart, DWI reports and Financial Data Mart). I designed and developed ETLs and Cognos Decision Stream catalogues in order to populate the data marts based on Kimball’s Dimensional Model. I wrote improptu reports and created powerplay cubes with the aim of meeting user requirements gathered by one to one consultation with the key users.

Software and Tools Used :

ORACLE, DATA WAREHOUSE, PL/SQL, SQL, DECISION STREAM (7.1), IWR, POWERPLAY ENTERPRISE SERVER, IMPROMPTU, POWERPLAY TRANSFORMER, UPFRONT (7.3)

AUG03 – AUG04 SOUTHERN WATER PLC. - Brighton, UK

Data Warehouse Developer

I have worked as a Data Warehouse (ORACLE, ETL, PL/SQL, Cognos Impromptu report and Cognos Powerplay Transformer) developer for Southern Water Plc in Falmer, Brighton.

As developer, I was involved in four different projects (Lab Systems Upgrade, PI Data Mart, CSO - Combined Sewer Overflow Data Mart, Decision Stream Upgrade) and designed and developed ETLs, Decision Stream catalogues, improptu reports and powerplay cubes.

Software and Tools Used :

ORACLE, DATA WAREHOUSE, PL/SQL, SQL, DECISION STREAM (6.5, 7.0), IWR, POWERPLAY ENTERPRISE SERVER, IMPROMPTU, POWERPLAY TRANSFORMER, UPFRONT (7.0)

SEP02 – MAY03 SOUTHERN WATER PLC. - Brighton, UK

Impromptu, Powerplay Developer / IWR, PPES and Upfront Administrator

I have worked as a Cognos Impromptu report and Cognos Powerplay cube developer and IWR, PPES and Upfront Administrator for Southern Water Plc in Falmer, Brighton.

As developer, I was involved in two different projects (Lab Systems Data Mart, NRSWA - New Roads and Street Works Act Data Mart) and designed and developed reports and cubes which run against an Oracle data warehouse and SQL Server 2000 database. As IWR, PPES and Upfront (7.0) Administrator, I published the reports on the intranet, created users and user groups in Access Manager and dealt with daily problems.

Software and Tools Used :

IWR, POWERPLAY ENTERPRISE SERVER, IMPROMPTU, POWERPLAY, UPFRONT (7.0), ORACLE, SQL SERVER, DATAWAREHOUSE

OCT01 – MAR02 SOUTHERN WATER PLC. - Brighton, UK

Impromptu Developer / IWR and PPES Administrator

I have worked as a Cognos Impromptu report developer and IWR and PPES Administrator for Southern Water Plc in Falmer, Brighton.

As an impromptu report developer, I designed and developed impromptu reports. The reports run against an Oracle Data Warehouse. As IWR and PPES Administrator, I published the reports on the intranet, created users and user groups in access manager and dealt with the problems.

Software and Tools Used :

IWR, POWERPLAY ENTERPRISE SERVER, IMPROMPTU, ORACLE, DATA WAREHOUSE

JAN01 – JUN01 SOUTHERN WATER PLC. - Brighton, UK

Impromptu and PowerPlay Developer

I have worked as an Impromptu and PowerPlay report developer for Southern Water Plc in Falmer, Brighton.

As an impromptu and powerplay report developer, I analysed user requirements, designed and developed impromptu reports, transformer models, created powercubes and powerplay reports and published them on the Web. The reports run against an Oracle Data Warehouse.

I was a member of data warehousing team. I have designed and created (written) all the SQL scripts for one of the data marts (NRSWA- New Road and Street Work Assets Data Mart).

Software and Tools Used :

IWR, POWERPLAY ENTERPRISE SERVER, IMPROMPTU, POWERPLAY TRANSFORMER, DATAWAREHOUSING, DECISION STREAM, ORACLE, DATA WAREHOUSE

NOV99 – DEC00 SPECTOR PHOTO GROUP - Wetteren, Belgium

Impromptu, Powerplay Enterprise Server and PowerPlay Administrator/Developer

I have worked as an Impromptu Web Report Administrator, Powerplay Enterprise Server Administrator and Impromptu and PowerPlay report developer for Spector Photo Group in Wetteren, Belgium.

I was responsible for installation and maintanence of Impromptu Web Reports (V6.0), Powerplay Enterprise Server (V6.5 and V6.6), Access Manager and Netscape Directory Server.

As an impromptu report developer, I analysed user requirements, designed and developed impromptu reports and published them on the Web. The reports run against a live SAP database, which resides on Microsoft SQL Server.

I have also involved in the design of the data warehouse. As a member of data warehousing team, I worked on the creation of three data marts - stock and purchase, sales and statistics. I developed the transformer models for the three data marts and created PowerPlay reports based on the user requirements.

Software and Tools Used :

IWR, POWERPLAY ENTERPRISE SERVER, IMPROMPTU, POWERPLAY, SQL SERVER, DATA WAREHOUSE

APR99 – OCT99 IN-FORMATION - Chester, UK

Whilst with In-Formation based in Chester, I worked on the following projects:

RAC, Bescot

Implementation of Patrolman Performance Impromptu reports. The reports run against an Oracle datamart.

George Wimpey, London

Implementation of Payroll related Impromptu reports. The reports run against an SQL Server database

Eccles Savings & Loans, Manchester

Analysing the business and establishing system requirements by consultation with system users, - design of data mart based on a SQL Server database, - design, development and implementation of Impromptu reports and the integration of the reports into the software system written in Visual Basic

RCS, Stoke on Trent

Establishing report requirements and design and implementation of Impromptu reports based on a SQL Server database.

Software and Tools Used :

IMPROMPTU, POWERPLAY, ORACLE, SQL SERVER, DATA WAREHOUSE

MAR 98 – MAR 99 ALLIED DOMECQ SPIRITS & WINES - Bristol, UK

I worked as a Cognos IT contractor for ADSW in Bristol from March 1998 to March 1999.

I completed the following projects successfully:

  • Service Level Reporting (design, development and implementation)
  • Creating weekly impromptu reports against AS400. They are automated using macros and Scheduler. (March 98-June 98)
  • Defensible Trading Project (development and implementation)

  • Creating monthly PowerPlay reports against SQLBase database. They are automated using macros and Scheduler. (June,98- September,98)
  • Field Sales Support Reporting (development and implementation)

  • Establishing the user requirements, designing of data mart based on the requirements, and creating daily Impromptu and PowerPlay reports against Oracle data mart. They are automated using macros and Scheduler. It was rolled out in three European countries in different versions. (October, 98-March, 99).

Software and Tools Used :

IMPROMPTU, POWERPLAY, ORACLE, DATA WAREHOUSE

SEP97 – FEB98 THE FDM GROUP - Mountfield Software - Brighton, UK

I joined Mountfield Software in 1997 and attended an intensive training program, then proceeded to work on the projects below.

Attendance Reports System:

Employee Log-in and Log out Form

In this project a Log- in Log out form is used to generate attendance reports for employees using Access.

Software and Tools Used :

VBA, MS ACCESS, OUTLOOK

Automated Purchase Order Form:

The project is to generate a purchase order by using e-mail forms. A purchase order empowered individual raises the purchase order and sends it to the next person to be authorised and approved. E-Form knows correct routing for the individual who initiated E-Form to gain approvals. Provision has been made for re-routing if required. To develop this application, Visual Basic for applications, Outlook and Access are used.

Software and Tools Used :

VBA, MS ACCESS , OUTLOOK

Stock Control Program:

In this project, a MSAccess Database was used alongside Visual Basic 6 to control the stock movement and generate invoices, ledgers and some BI reports based on those movements.

Software and Tools Used :

MS ACCESS, VISUAL BASIC 5

JUN 97 - AUG 97 YAVER LTD - London, UK

I worked part time as a Web Designer for a company in London. My duties included designing and maintaining the Web Pages and also creating on line forms and searchable database using Perl.

Software and Tools Used :

HTML, CGI

APR 93 - MAY 97 UNIVERSITY OF SUSSEX - Brighton, UK

Laboratory Demonstrator

While I was working as a Laboratory Demonstrator, I attended the preliminary year physics, first year introduction to computing and second year microprocessors laboratories.

Education

University of Sussex, Brighton, UK

M.S.c in Computer Technology in Manufacture

Bogazici University, Istanbul, TR

B.Sc. in Computer Engineering

References

Full contact details of referees available on request [Click to Request Information]



Get Firefox!

| HOME | Automated Testing | Datawarehousing | Hardware | Web Services | Downloads | Links | About Us | Contact | Employment | Returns | Sitemap |


Copyright 2001-2011 Priman2000Ltd All rights reserved

All trademarked and copyrighted products and services mentioned in these pages are property of their respective right holders.
Site Design By:Priman2000Ltd, Last Update : 25/02/11 23:14