KIVANC OZYILDIRIM
************@*****.***
Business Intelligence Analyst
Business analyst with 10+ years of experience utilizing data to optimize processes, inform strategic decisions, and enhance operational efficiency across technology and retail sectors.
Analyzes business processes and requirements and facilitates cross-functional collaboration to define key priorities, KPIs, and action plans that drive sustainable growth.
Develops requirements documentation, use case scenarios, test artifacts, and report mock-ups to define project objectives, validate solutions, and align business needs with stakeholder expectations.
Oversees project and business research planning, including scope, budget, and timelines to meet client expectations and boost satisfaction.
Leads high performing teams and facilitates training on advanced systems for junior team members and clients, outlining algorithms, system operation and capabilities, and software maintenance.
Oversees the creation of database plans and system interfaces, leading development teams through testing and coding processes to achieve seamless functionality and user experiences.
Performs root cause analysis to identify and resolve data and reporting issues, improving accuracy and streamlining processes.
Utilizes predictive modeling and data visualization to identify trends, inform strategic decisions, and deliver actionable insights that elevate business performance.
Technical Proficiency
Power BI SQL Jira Confluence Python SAS Oracle OBIEE SSIS / SSRS Tableau Visio UML & Activity Diagrams Teradata MapInfo (GIS) Microsoft Project Microsoft Office
Career History
THE SOURCE (a division of Bell Electronics Inc.), June 2019 – December 2024
Owned by BCE, The Source is Canada’s largest tech retailer supplying consumer electronics and cell phones across in-store and e-commerce settings.
Business Intelligence Analyst
Synthesized large data sets to translate insights into impactful strategies and recommendations for merchandising, supply chain, and marketing departments.
Built relational databases using Oracle, SQL, SAS, and Excel, incorporating analysis feedback to refine reporting accuracy and optimize data storage, retrieval, and analysis processes.
Conducted quantitative and spatial data analysis to implement improvements to SKU parameters, store module sizes, and space planning for inventory allocation and store layout optimization.
Partnered with stakeholders to define KPIs and objectives, performing ETL processes, data modeling, and trend analysis to inform short- and long-term planning.
Developed a real-time inventory performance tracker, incorporating predictive models to flag at-risk products, shortages, and aged inventory, enhancing inventory management capabilities.
Created interactive dashboards, visualization tools, and executive summaries to evaluate sales performance, suggest high-performing channels, and drive workflow automation.
Conduced quarterly road map analysis and data models, translating technical findings into actionable product and business strategies.
Reviewed data management processes and historical strategies to mitigate issues in data movement and record handling.
PROLINE, July 2015 – July 2017
Proline is a research and development center that develops biometric and document security hardware and software products.
Sr. Business Analyst & Project Manager
Liaised with clients, stakeholders, and development team technicians, streamlining communications to maximize the efficiency of company and project operations.
Led meetings with external stakeholders to understand requirements and gain insight to negotiate favorable terms and mutually beneficial results.
Prepared handover and training documentation at project closeout, enabling clients to maintain seamless operation of equipment and software.
Highlights:
Managed the implementation of a $4M AI-driven security software and camera installation project for Expo 2016, utilizing advanced video algorithms to enhance incident detection and response.
Led a team of business analysts to develop an import reporting portal for the Ministry of Türkiye, enhancing accessibility to departmental records and improving data tracking and analysis.
ÜLKEM, September 2012 – June 2015
ÜLKEM is a technology solutions provider specializing in transportation safety, public security, and custom system integration.
Sr. Business Analyst & Team Leader
Consulted with clients and led teams to conduct comprehensive business analysis and develop project plans, ensuring software solutions aligned with the business needs of high-profile clients.
Collaborated with department representatives to map roles, analyze needs, and optimize responsibilities and processes to drive operational efficiency across the organization.
Developed and maintained protocols, data coding standards, and documentation to enable efficient data mining and management of large relational databases.
Led functional and user acceptance testing, overseeing external test creation to achieve software functionality and module stability.
Highlights:
Directed a team of three to analyze processes across 16+ ministry departments, delivering database plans and system interfaces that enhanced operational efficiency and user accessibility.
Business Analyst, BASARSOFT, May 2010 – September 2012
Basarsoft is a pioneering geographic information system solutions provider in Turkiye.
Education & Training
Master of Business Administration, Ufuk University, Ankara, Turkiye, 2016
Bachelor of Business Administration, Anadolu University, Eskisehir, Turkiye, 2014
SQL Essential Training Certification, NASBA, 2024
SQL Data Reporting & Analysis Certification, LinkedIn Learning, 2024
Python Essentials Certification, LinkedIn Learning, 2024
SQL Learn Certification, Codecademy, 2022
Python 101 for Data Science, IBM, 2018
Graduate Certificate in Big Data Analytics, Georgian College, 2018
Project Management Professional, MCM Group, 2012
Additional information and excellent references available upon request