Excell
Talha Kastan
Data Analysis Manager
Istanbul,34
Summary
Accomplished Business Intelligence Manager with a proven track record at TÜRK DEMİR DÖKÜM FABRİKALARI A.Ş., enhancing decision-making and operational efficiency through expert application of BI tools and SQL expertise. Spearheaded data-driven culture shifts, achieving significant process optimizations. Skilled in fostering teamwork and collaboration, adept at translating complex data into actionable insights. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals. To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills. Hardworking and passionate job seeker with strong organizational skills eager to secure entry-level [Job Title] position. Ready to help team achieve company goals. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.
Overview
14
14
years of professional experience
7
7
years of post-secondary education
Work History
Business Intelligence Manager
TÜRK DEMİR DÖKÜM FABRİKALARI A.Ş.
08.2021 - Current
- Performed ad-hoc analyses upon request from senior management or other departments requiring specialized support or insight into specific issues or challenges faced by the organization.
- Managed vendor relationships to ensure timely delivery of services while adhering to budget constraints.
- Optimized data warehousing architecture, ensuring seamless integration of multiple data sources.
- Conducted comprehensive market research, enabling informed decision-making on new product launches and expansions.
- Collaborated effectively with IT teams to maintain optimal system performance through regular maintenance activities, updates, and upgrades as needed.
- Established best practices for data governance policies, ensuring compliance with industry regulations and standards while maintaining data integrity across all systems.
- Improved data-driven decision making by implementing advanced business intelligence tools and strategies.
- Spearheaded process improvement initiatives by analyzing current workflows and identifying areas for optimization using BI insights.
- Championed a data-driven culture within the organization, promoting the value of analytics in strategic planning initiatives.
- Identified trends and patterns within data sets, providing valuable insights for strategic planning and decision-making processes.
- Developed custom dashboards and visualizations to provide actionable insights for key stakeholders.
- Championed the use of data visualization tools to effectively communicate complex information and drive meaningful business outcomes.
- Enhanced overall business strategy with the implementation of predictive analytics techniques for better forecasting.
- Streamlined reporting processes for increased efficiency and accuracy in data analysis.
- Managed a team of BI analysts, fostering professional development and continuous learning opportunities.
Business Intelligence Analyst
TÜRK DEMİR DÖKÜM FABRİKALARI A.Ş.
09.2020 - 08.2021
- Reduced manual data entry errors by automating routine tasks using SQL scripts and ETL tools.
- Championed a data-driven culture within the organization by promoting the use of analytics tools and methodologies across departments.
- Standardized best practices in report generation across departments to ensure consistency in presentation formats as well as analysis methodologies employed.
- Increased understanding of customer behavior patterns by analyzing sales, marketing, and demographic data sets.
- Supported strategic decision-making processes by delivering timely and accurate insights from complex datasets.
- Participated actively in stakeholder meetings, presenting data-driven insights and recommendations to support business growth initiatives.
- Optimized database performance through regular maintenance, query optimization, and index tuning.
- Collected data from wide-ranging sources.
- Developed intelligence-sharing dashboards, providing company-wide access to collected data.
- Trained end-users on BI tools usage to maximize adoption rates and improve overall company data literacy levels.
- Evaluated BI tool options, selected best-fit solutions based on cost-benefit analyses, ensuring optimal return on investment.
- Enhanced data quality by conducting thorough analyses, identifying discrepancies, and providing recommendations for improvement.
- Streamlined reporting processes for increased efficiency and accuracy with the development of custom dashboards.
Reporting Specialist
TÜRK DEMİR DÖKÜM FABRİKALARI A.Ş.
06.2018 - 09.2020
- Trained colleagues on best practices for reporting, improving overall team efficiency and performance.
- Enabled informed decision-making by presenting complex findings in clear language using charts or tables during presentations.
- Provided ongoing maintenance and support for critical reporting systems, minimizing downtime and ensuring uninterrupted access to essential information.
- Compiled, maintained and verified data and distributed information through reports and queries to support operations.
- Liaised with senior leadership to identify data needs and interpret existing data for consideration.
- Created user-friendly dashboards and visualizations, enabling stakeholders to easily interpret complex data sets.
- Assessed report and data requirements and determined best technology solution, format and distribution method.
- Streamlined interdepartmental communication through effective collaboration with other analysts.
- Performed ad-hoc analysis as needed, supporting various departments with their specific reporting needs.
- Maintained the accuracy of information in reports by updating the database regularly and ensuring data integrity.
- Synthesized and interpreted relevant data to generate comparisons of current and historical information.
- Conducted thorough data validation and reconciliation exercises, ensuring the highest level of accuracy in all reports produced.
- Collaborated with cross-functional teams to gather data requirements, ensuring timely delivery of accurate reports to stakeholders.
Assistant Specialist
Türkiye Maarif Vakfı
11.2016 - 02.2017
Data Analyst Intern
Philip Morris International Inc.
06.2016 - 11.2016
- Converted raw datasets into meaningful formats by performing extensive pre-processing activities such as normalization and transformation.
- Optimized SQL queries for faster processing times, increasing overall productivity within the team.
- Completed data cleaning and data validation of existing spreadsheets to promote robust data management platform, resulting in accurate data analysis and entry.
- Assisted management in making informed decisions by presenting clear and concise reports detailing analytical findings.
Software Developer
Trabzonspor Sportif A.Ş.
08.2010 - 08.2014
- Improved software efficiency by troubleshooting and resolving coding issues.
- Saved time and resources by identifying and fixing bugs before product deployment.
- Updated old code bases to modern development standards, improving functionality.
- Discussed issues with team members to provide resolution and apply best practices.
- Contributed to a positive team environment through effective communication, problem-solving, and collaboration skills.
- Developed software for desktop and mobile operating systems.
- Optimized application performance by conducting regular code reviews and refactoring when necessary.
- Coordinated with project management on database development timelines.
Education
Associate of Applied Science - Web Development
Anadolu Üniversitesi
Eskişehir, Turkey 09.2019 - 06.2021
BBA - Business Administration And Management
Karadeniz Teknik Üniversitesi
Trabzon, Turkey 09.2010 - 06.2015
Skills
Python Programming
SQL Expertise
Data Quality Management
ETL processes
Data Warehousing
Report Development
Data Governance
BI Tools Mastery
Predictive Analytics
Teamwork and Collaboration
Data and Analytics
SQL and Databases
Effective Communication
Organizational Skills
Project Management
Data Modeling
Data Compiling
Business Intelligence Systems
Software
Word
Power Point
MS SQL
Power BI
Tableu
MS Share Point
MS Teams
SSIS
Python
Web API
SAP
Languages
Turkish
Native language
English
Upper intermediate
B2
Counseling Service
Comprehensive consultancy services in data analysis and data visualization are provided to KiviERP. Within this scope, a data warehouse has been created using the Power BI tool by aggregating data from various APIs. Detailed editing and correction processes have been carried out on the data warehouse to ensure data accuracy and consistency.
Various metrics and measures have been developed on the data warehouse to enable the company to better understand its business processes and make data-driven decisions. These metrics allow for comprehensive analyses aimed at increasing the company's performance and efficiency.
The created metrics and data have been visualized using Power BI, resulting in user-friendly reports and dashboards. These visualizations enable the company's top executives and decision-makers to quickly and effectively comprehend complex data sets.
The consultancy service is ongoing, with continuous improvement and development efforts being made to meet the needs of KiviERP. During this process, continuous support is provided to enhance the company's data analytics capabilities and establish more efficient business processes.
Timeline
Business Intelligence Manager
TÜRK DEMİR DÖKÜM FABRİKALARI A.Ş.
08.2021 - Current
Business Intelligence Analyst
TÜRK DEMİR DÖKÜM FABRİKALARI A.Ş.
09.2020 - 08.2021
Associate of Applied Science - Web Development
Anadolu Üniversitesi
09.2019 - 06.2021
Reporting Specialist
TÜRK DEMİR DÖKÜM FABRİKALARI A.Ş.
06.2018 - 09.2020
Assistant Specialist
Türkiye Maarif Vakfı
11.2016 - 02.2017
Data Analyst Intern
Philip Morris International Inc.
06.2016 - 11.2016
BBA - Business Administration And Management
Karadeniz Teknik Üniversitesi
09.2010 - 06.2015
Software Developer
Trabzonspor Sportif A.Ş.
08.2010 - 08.2014
Similar Profiles
KORAY DARCANKORAY DARCAN
Quality and Final Control Director at Çelikel Aluminyum Döküm San. Tic. A.Ş.Quality and Final Control Director at Çelikel Aluminyum Döküm San. Tic. A.Ş.
Samet ŞEKERSamet ŞEKER
Application Engineer GI TR & Egypt Technical Responsible at Türk Henkel Kimya Sanayi ve Ticaret A.Ş.Application Engineer GI TR & Egypt Technical Responsible at Türk Henkel Kimya Sanayi ve Ticaret A.Ş.
Mehmet Ali SAKCIMehmet Ali SAKCI
Plant Protection Sales Development Specialist at Hektaş Ticaret Türk A.ŞPlant Protection Sales Development Specialist at Hektaş Ticaret Türk A.Ş