Senior Fullstack BI/DWH Developer

Insurance - Allianz – Anti Money Laundry (Oracle/Informatica)

• Build Dwh architect to catch money laundry transactions with 100% unique data
• Create approximately 400 Etl pipelines to get core data to Dwh with Oracle Pl/Sql Package/Sp to feed DataMart
• Collect Customer's money related transactional billions of data from 6 different LOB. By this way We have managed to reduce the leaks in money laundering activities to 10%
• Redesigned customer segmentation data according to country transaction and risk groups. Thus, we reduced the record multiplexing to 0.
• Calculate the risk finding algorithms over customer transaction data. With these calculations, the risk was reduced to 2 percent.
• Accelerated Query Performance
• Working with PO, key users, core dev teams to coordinate business development/ Agile
• Pipeline the data with Informatica to generate alerts on ActOne tool

Banking- Akbank -BI/DWH/ETL/Pl/Sql-QlikSence

• Setting architectural standards for informatica Power Center development teams.
• Maintenance-performance-health for Dwh(Exadata) environments.
• Qlik Sence /BO reports architectural standards.
• Implementing best practices in ETL tasks
• Documentation ETL standards on Confluence
• Dynamic Data Masking rules for GDPR/KVKK regulations by using Informatica DDM tool
• Dwh Data model Power Designer
• Upgrade QlikSence versions
• Merge all informatica server's repository databases on one Oracle db.

Telecommunication – Turkcell (SSIS-SSRS-T-Sql):

• Maintenance BI application named Beqom- agency premium system
• Build and maintenance SSIS ETL jobs with T-SQL
• Designed Reports with SSRS

Telecommunication-Vodafone (Pl/SQL-ODI-Informatica):

• Etl (SQL To Oracle – Oracle to Oracle)
• Data load to Dwh system with ODI and Oracle Pl/SQL packages
• Maintain for performance of Dwh (Pl/Sql)

Telecommunication -Turkcell (MSTR):

• Expanded reports by business units
• Transform Business needs to the self-service reporting platform
• Design MSTR reports with consider MSTR model structure
• Add new data sources into the MSTR structure

Retail-Cosmetics - Avon (Snowflake-PostgreSQL-Oracle):

• Migrate various data sources to dwh PostgreSQL, Greenplum with Wherescape Red
• Convert BI-DWH(Oracle) to Snowflake project. We reached many more users with fewer license costs.
• Make user role matrix
• Making snowflake datamarts,SQL scripts for reporting environments

Insurance MetLife (Informatica-Pl/SQL - QlikView-QlikSence-SSRS-SSIS):

• ETL pipelines with Informatica PowerCenter and SSIS. Design Dwh structure
• Design Reports/Ad-hoc query performance
• Making QlikView/Sense, SSRS, Power BI(Dax) reports/dashboards

Projects I have completed:

• Informatica Pwc 9 to 10.4 version migration
• Split Dwh into layers, ODS, STG, DWH, DataMart
• QlikView to QlikSence migration
• Smart massage (Crm loyalty): sending company announcements email /SMS with their permission

Healt Insurance In-house software (Pl/SQL, Oracle Forms-Reports)

Projects I have completed:

• Migrate Oracle Forms-WebLogic
• Maintenance Pl/SQL codes performance improving
• Control printing spool system for insurance contracts
• Agile/Scrum

• MDM:B2B/B2C-Etl (Pl/SQL/Oracle, Talend)
• CRM (loyalty card):
• Net Transformation Team