Data Engineer

TSQL

ETL - SSIS

On this project aim is calculating Banking portfolio managers bonus accurately. We developed this Projects using Microsoft Technologies . We used SSIS tool for ETL Operations, VisualStudio 2008 for developing User Interface, TSQL stored procedures for Business and Logic calculations .

Early Warning and Monitoring Project
We developed Enterprise , Near realtime Data Marts and ADHOC reports for SME . Aim of the project is giving Intelligence and warning about risky banking customers. For reports we have developed datamarts using customer credits, cheque and financial transactions. On this project we used SSIS for ETL operations. For building adhoc reports and dasboards we used IBM cognos BI tool

With this projects we aim calculating Banking portfolio managers’ , Branch Lines’ and Bank Branches’ targets and realizations . Every banking product depends on budget . On this project we calculated each portfolio manager has achieved targets and his realization. We also calculated effect of this numbers to Branch and Business Line’s. We developed this Projects using MS SQL Server as a Database, Oracle BI 10g BI Tool for Dashboard and ADHOC Reports . We used Informatica tool for ETL Operations . T-SQL , stored procedures for Business and Logic calculations . For Database Modelling We used SAP Sybase Power Designer.

Customer Scoring and Data Quality Reports.
With this projects we aim scoring Bank customers from CRM Data. We have also designed and created Quality and reliability reports. We used Oracle BI 10g for reports and dashboards.

Audit and Customers Risk Reports.
With this projects we aim choosing and finding high risk customers for whom is auditing portfolio managers and branches . We used TSQL , stored procedures for reporting . We used Oracle BI 10g for reports and dashboards.

Mobile Business Intelligence Implementation.
With this projects we aim preparing new reports and dashboards for Mobile platforms such as Ipad, Iphone . On this project I used Oracle BI . We have migrated Oracle BIEE 10g to 11g to without any consulting company.

We develop software for hospitals with using Oracle DBMS , Sybase Power Builder and C# .

Document and Archive Managemet Systems Projects
 We developed archive and document management projects with using c# , delphi and oracle dbms.Hospital Information Systems Project We develop software for hospitals with using Oracle DBMS , Sybase Power Builder and C# . Document and Archive Managemet Systems Projects We developed archive and document management projects with using c# , delphi and oracle dbms.

Eroglu Software logo

Computer Engineer