Dilara Karatas

Tech stack: Snowflake, DBT, Airflow, Git, Copilot, Python • Building dbt data models and transforming raw data through staging and intermediate layers into production-ready Data Marts. • Optimizing high-cost Snowflake workloads, improving query performance • Preparing Python-based data lineage scripts to track table, view, and column dependencies. • Building and maintaining Streamlit, Tableau and Gsheet dashboards. • Handling cross-department stakeholders and coordinated requirements.

Tech stack: GreenPlum, MySql, Talend, Crontab, Task Scheduler, Python • Turk Telecom Project: Data Analytics Lead. Data discovery, building join logic, sp/etl job/sensor/report preparation, job scheduling, production monitoring and maintenance. Mentoring team members, when they were stuck helping them to solve problems (Deployed 2 projects) • Bouygues Project: Monitoring daily jobs and data sanity, understanding, and solving daily issues, meeting new requests.

Tech stack: Oracle, MS SQL Server, Qlik Sense • Factoring Analytics& HR Analytics: Built DWHs from scratch for BIS's products. Core DWH, Data Mart, Dashboard preparation. Data modelling, sp coding, regular data sanity check through pipelines. Leading its implementation to the customer. • Unicredit Italy HR Transformation: In this project worked as business analyst for Payroll and Time Management Modules. Sole responsible of tasks like Meal Ticket, Shift Worker Allowance, Carfare, and Tax Deduction.

Tech stack: Sybase, Oracle • Yapı Kredi Bank SME Boosting Projects (Project1: Pricing, Project2: Service Model): Main responsible of the 2 projects' all DWH related tasks like data preparation for optimization team, KPI creation, sp coding for pipelines.