Ozan Şen

Berufserfahrung von Ozan Şen

• Bis heute 1 Jahr und 6 Monate, seit Dez. 2022

  DWH Engineer - ETL Developer

  Generali Insurance

  I take care of reporting processes(IFRS, SAS), management of data warehouse, designing dynamic SSIS packages to automate tasks, Advanced SQL Coding, debugging SSIS packages(ETL Integration), scheduling & jobbing SSIS Packages (SQL Server Agent). We get data from lots of resources (Live systems -PL/SQL, Call Center(ININ), Web, Flat Files, Excel, OLEDB, XML) and send into requested destinations and reporting tools(Power BI, Spotfire), designing flow steps (Source – Staging – Destination)

• 4 Jahre und 10 Monate, März 2018 - Dez. 2022

  Data Engineer

  Freelancer

  I completed over 30+ BI projects, mostly for companies servicing in the healthcare, retail, manufacturing, online-igaming - betting , and e-commerce sectors. I led data analytics, ETL, visualization, testing, and small-scale data-warehousing projects. I created a road map to build data pipelines, perform data transformations, model data(star schema/snowflake), build DWH.In each step, I used tools such as Power BI, DAX, Power Query(M), MS SQL Server, MySQL, SSIS, Python and Excel.