MINE GEZEN

• Developed Data Models by working with the Business Stakeholders to understand the need
• Developed Data Marts according to analytical needs
• Ensured that data is accessible, up-to-date, secure, consistent and complete
• Designed and implemented end-to-end dwh solutions such as data modeling, data loading.
• Developed data integration solutions for different source system (NoSQL databases-MongoDB, Cassandra, PostgreSQL)
• Improvement of processes such as documentation, data quality, data testing
• Defect Resolution
• Researched new technologies to improve Data Warehouse and Analytic processes
• Testing and Reconciliation (CI/CD Automation, AM/AD Testing Process)
• I work in AGILE and DevOps best practices including deployment automation tools, CI/CD processes, using tools like Jenkins, Bitbucket, JIRA.
• Tooling & Techniques: Oracle DB (19c), PL/SQL, ODI12C, Power Designer, MongoDB, Cassandra, TOAD for Oracle, UC4 Atomic, JIRA
• ACHIEVEMENTS HIGHLIGHTS
• Marketplace & Data warehouse Integration Projects :

VODAFONE - HERŞEY YANIMDA

HEPSIBURADA & VODAFONE E-COMMERCE COLLAB

• Extraction: Extract non-relational data from MONGODB in JSON file using ODI 12C.
• Parsing: Oracle 19c Query in JSON Document.
• Load: Insert data to Oracle Data Warehouse target table.

• Having experience on Data Integration Projects with government agencies to provide reporting (Legal Reporting).
• Knowledge of Banking regulations related to Data Protection- Payment Card Industry Data Security Standards (PCI DSS).
• Applied experience in designing, implementing and supporting PCI DSS compliance for DWH environment (e.g. credit card masking) in collaboration with Payment Systems and a whole BI department.
• Solving technical and data related problems to meet the needs of business units by analyzing data.
• Working in a sprint team in AGILE / Scrum.

• Responsible for design and develop ETL packages for new and evolving sources to enhance TEB's Data warehouse Platform.
• Developing Oracle PL/SQL Blocks (Scripts), Stored Procedures, Functions, and Package Procedures, and using Oracle Database Links and Views.
• Maintaining support and improve the performance of existing PL/SQL procedures and ODI interfaces.
• Supported daily operations including troubleshooting of Data warehouse platform.
• Participating in various Agile ceremonies (Sprint Planning, Daily Stand-ups).
• Tooling & Techniques: ODI (11 g), PL/SQL, Oracle DB, TOAD for Oracle, UC4 Atomic, IBM ClearQuest, Power Designer for Data Modelling

• Responsible for all business intelligence solutions on data warehouse and data marts using Microsoft Tools & Technologies.
• I developed ETL project for modeling data, data quality and improving the performance of reporting and cubes. I was using SSIS for ETL.
• I was preparing data marts from source systems which are mostly oracle and sql server to data warehouse using SSIS (ETL process) on desired time with jobs.
• I was preparing complex reports using SSRS about credit cards, atm cards, banking system, sales performance management, document management, internet banking, telephone banking, portal utilization, campaigns and event management.
• Interacting with the business users directly, gathering business requirements, and analyzing and compiling deliverables for various multi-dimensional queries and reports.
• Scheduling batch jobs data load coming from various source system.
• Monitoring daily and periodic data load using process chains.
• Tooling & Techniques: MS SSIS, Oracle DB, SQL Server DB, TOAD for Oracle, SSRS

• I was analyzing DWH requirements for Project’s business requests and doing developments of ETL processes for BI environments.
• I was responsible for on migration project which is to migrate from SSIS ETL packages to SAP BODS ETL Packages and developed ETL packages on SAP BODS.
• I was monitoring and troubleshooting of SQL Server Agent Jobs.
• I was using version & document control systems in order to transfer to production. GSM (Global Service Management) System, CAB, Service Request Management
• I was collaborating with BI Team and related departments in order to fulfill business and project needs.
• I have experienced monitoring about Front End Technologies (Business Objects, Qlikview) in order to provide data to business units.
• Tooling & Techniques: SSIS, SQL Server 2012, SAP BODS, SSRS, Version Control Systems (GSM, JIRA), Oracle EXADATA.
• ACHIEVEMENTS HIGHLIGHTS
• MCS (Multi Category Selling): I had migrated SSIS packages to SAP BODS Packages and debugging. I had chance to develop ETL with SAP BODS and working in various db’s such as SQL Server, Oracle Exadata (ERP). Also, I helped them to handle this analytical transformation process.

• According to customer needs, I developed ETL process and maintenance. Created data models for the new reports or dashboards, developing existing data models and designed SSIS packages.
• I was a member of various types of projects like migration project, mobile reporting project, dashboard designing and demo meeting with Microsoft team.
• Designed visualization reports using Power BI and I was responsible for doing end to end process of new report development on Microsoft reporting tool for the Board of Directors in a bank.
• As a consultant, I had experience about how to handle consultancy process and I learnt technical specifications. I had migrated SSAS Multidimensional Cubes to Tabular Model. I spent my time for 8 months in a client which is a bank and worked together their business unit.
• Tooling & Techniques: SQL Server 2014, SSIS, SSAS (Multidimensional / Tabular Model), SSRS, Power BI

• Bilge Adam & Republic of Turkey Ministry of Family and Social Policies collaborates to support us about to be Qualified IT Specialist. My goal was to learn programming languages and tools.
• Have training of Microsoft SQL Server, C# programming, Web Form, MVC.NET, OOP, TFS, Entity Framework, HTML, JavaScript, CSS, Bootstrap, Ajax, Query.
• Joined the certificate exams such as Microsoft Certification Program.