![Tugba Demirci Kasarci, Developer in Istanbul, Turkey](http://assets.toptal.io/images?url=http%3A%2F%2Fbs-uploads.toptal.io%2Fblackfish-uploads%2Ftalent%2Fprofile%2Fpicture_file%2Fpicture%2F1061068%2Fhuge_272f748b792edbd3d8252b29ef9f79ea-3117a86c7216f4af9c388c76db188527.jpg&width=524)
Tugba Demirci Kasarci
Verified Expert in Engineering
Database Developer
Tugba is a professional data consultant with vast experience in data analysis and visualization. She has data-related experience in big companies with huge amounts of data and has worked as a team leader in an essential company domain. Tugba specializes in data warehouses, Teradata, Oracle, data visualization and reporting, MicroStrategy, Qlik Sense, QlikView, and Tableau. She provides fast, proactive, and high-quality solutions to any problem.
Portfolio
Experience
Availability
Preferred Environment
Slack, SQL, Agile, Azure Databricks, Business Intelligence (BI), Dashboard Design, BI Reporting
The most amazing...
...project was leading an end-to-end project involving the transfer of data to a data warehouse, reporting for one of the main domains of a company.
Work Experience
Data Analyst/Engineer
Zoetis - Main
- Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.
- Managed the migration of the old data warehouse, ensuring data accuracy and consistency. Recreated more than 10 main scripts. Uncovered previously unnoticed errors and deficiencies within the source data by testing report outputs.
- Proactively organized regular meetings with the data warehouse owners to address errors and fulfill their needs.
- Documented scripts for corresponding tables in the new DWH.
- Generated standard and custom reports to provide insights into business performance.
- Utilized data visualization tools like Tableau to present and explain complex data sets.
- Transformed a monthly PowerPoint presentation at the company—which contained sales analysis for a specific group and was used in strategic decision-making—into an interactive dashboard encompassing approximately 50 graphs.
- Analyzed system tables and their relations by using Databricks SQL.
- Collaborated with business unit leaders to identify and prioritize problems and recommended data standardization and documentation for the Net Revenue Management team.
Business Intelligence Specialist/ DWH Analyst
VakifBank
- Managed client meetings to determine requirements and data mapping sessions to understand business needs.
- Analyzed source system tables using SQL, documented detailed business rules and requirements, and modeled the DWH database following standards and reporting processes.
- Played a pivotal role in maintaining and enhancing the data warehouse dictionary, a valuable resource for internal stakeholders.
- Developed database objects using SQL for reporting, including tables, views, and materialized views.
- Leveraged Power BI reporting tools to design, create, and manage dashboards and reports for data visualization.
- Authored comprehensive user guides for projects, conducted end-user training, and provided real-time support for optimal system utilization.
Business Intelligence Specialist/ DWH Analyst
Turkish Airlines
- Worked as a project manager and analyst in the DWH integration project of one of the company's main domains, which consists of a daily data volume of two million end-to-end.
- Modeled the DWH database in accordance with standards and reporting processes and worked on integration projects of multiple source systems while ensuring data integrity.
- Analyzed source system tables and their relations using SQL. Created reports and dashboards with more than 500 metrics/attributes using MicroStrategy.
- Developed database objects using SQL for reporting, including tables, views, and materialized views.
- Managed client meetings to determine requirements and data mapping sessions to understand business needs. Documented detailed business rules and requirements.
- Contributed to data standardization and the data warehouse dictionary for company use.
- Created a documentation system for the business intelligence (BI) team and implemented it in the entire BI department.
- Developed and automated multiple BI reports in the dashboard on MicroStrategy and Qlik Sense. Created ad-hoc reports used primarily for legal purposes.
- Managed projects using Jira, a project management tool.
- Served as an analyst in a data governance project and worked on integrating Informatica, Axon, and Informatica EDC tools into the company.
Business Analyst
Aydinli Group
- Collaborated with the merchandising team and business analytics and system development to ensure that all project details were attended to.
- Recommended operational improvements based on tracking and analysis.
- Met with stakeholders to take business requirements and led meetings while taking requirements.
- Documented business requirements for the development process and designed front-end of programs.
- Arranged document acceptance meetings with developers.
- Implemented user acceptance testing focused on documenting defects and executing test cases.
- Trained the business team about new programs or developments.
- Created dashboards and reports for the business team.
- Fulfilled the tasks of analyzing the program, designing the screen, conducting tests, and providing user training in developing a system (ARES), including forecasting models for end-to-end purchasing, planning, and allocation works.
Merchandise Planner
Aydinli Group
- Planned store product by analyzing sales with parameters that affect sales.
- Made decisions on product price, transfers, and discounts.
- Worked with IT as a business stakeholder to develop merchandising programs.
Experience
Extracting a Main System to a Data Warehouse
The documentation system I established throughout the project laid the foundation for data governance. The user guides I created resulted in an 80% reduction in the need for business unit support for report usage.
Seamless Data Warehouse Transition
I meticulously compared old system tables with new ones, creating detailed data mapping documents. I identified discrepancies and accounted for them when preparing report scripts, ensuring alignment with business needs.
I scrutinized existing report scripts, aligning each with the precise business requirements in the new data warehouse. I proactively addressed source data errors, significantly improving data quality and reporting accuracy.
I achieved 100% accuracy in migrated data, confirmed through extensive testing. This precision ensured the continuity of analytics and reporting functions, which are vital for ongoing business operations.
The project went beyond simple migration by re-confirming report needs with owners, leading to updated and more relevant reports. The successful on-time delivery of the project minimized business disruption.
Transforming Monthly Reports into an Interactive Dashboard for Strategic Decision-Making
Recognizing the critical need for data accuracy, I proactively addressed inconsistencies during the dashboard's development. Liaising with data source owners, I identified and resolved issues, ensuring users had reliable and precise data for strategic decision-making.
Skills
Languages
SQL, T-SQL (Transact-SQL), Python
Tools
Tableau, Microsoft Excel, Jira, Tableau Desktop Pro, Microsoft Power BI, Excel 2013, Power Query, Qlik Sense, GitHub
Paradigms
Business Intelligence (BI), Database Design, Requirements Analysis, ETL, Agile, Data Science
Storage
PostgreSQL, Data Integration, Master Data Management (MDM), Database Architecture, Microsoft SQL Server, Database Modeling, Data Lakes, Data Pipelines, Teradata, Databases, MySQL, Azure SQL, Database Migration
Other
MicroStrategy, BI Reporting, Data Analysis, Documentation, IT Project Management, Dashboards, Data Analytics, Data Visualization, Relational Database Design, Data Architecture, Reporting, Data Modeling, BI Reports, Reports, Dashboard Design, Data, Data Warehousing, Architecture, Financials, Pricing, Warehouses, Data Transformation, Data Reporting, Data Manipulation, Analytics, Data Management, Dashboard Development, Analytical Thinking, Data Engineering, Azure Databricks, Financial Data, DAX, SAP BusinessObjects (BO), Data Governance, Statistics, Azure Data Factory
Platforms
Oracle, Azure, Databricks, SharePoint
Libraries/APIs
PySpark
Education
Bachelor's Degree in Industrial Engineering
Uludag University - Bursa, Turkey
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring