Oyku Turksel
Business Analyst
Kucukcekmece,34
Summary
Tech-savvy innovator with hands-on experience in emerging technologies and a passion for continuous improvement. Proven ability to identify opportunities for technological enhancements and successfully implement effective solutions. Skilled at leveraging new tools and methods to solve problems and enhance productivity. Thrives in fast-paced environments, driving technological advancements to propel organizational success.
Overview
3
3
years of professional experience
4048
4048
years of post-secondary education
4
4
Certifications
3
3
Languages
Work History
Junior Business Analyst
İGA Havalimanı İşletmesi A.Ş
Arnavutkoy, Istanbul
09.2023 - Current
- Analyzed business user needs in digital product development, gathering requirements, conducting detailed analysis, and documenting functional features
- Created workflows and prototypes using MS Visio and Figma to visualize business requirements
- Evaluated and approved technical specifications, clarifying technical concepts for users, and provided documentation support
- Defined test conditions, prepared scenarios, supported UAT (User Acceptance Testing), and tracked issues
- Collaborated with project managers on backlog prioritization and development planning using Jira
- Delivered effective feedback and updates to customers during and post-project
- Applied practical knowledge in SQL databases, REST API, Balsamiq, and business modeling (BPMN, UML)
- Contributed to system execution, design of new processes, and enhancement of existing systems
- Increased collaboration between departments by developing cross-functional data sharing procedures, resulting in more informed decision-making.
- Designed custom dashboards for tracking key metrics across various departments, increasing transparency in performance evaluation efforts.
- Collaborated with cross-functional teams to optimize workflows and drive process improvements.
- Enhanced stakeholder communication by creating easy-to-understand visualizations of complex data sets.
- Created comprehensive documentation for business processes, enhancing overall organizational efficiency and knowledge sharing.
- Streamlined reporting methods by automating data collection and analysis procedures.
- Supported project managers in achieving project goals through timely and accurate data insights.
- Evaluated software solutions, participating in vendor selection processes to choose systems that best aligned with company needs.
- Implemented quality control measures, ensuring the accuracy and integrity of data used in critical business decisions.
- Mentored junior team members on analytical techniques and best practices, fostering a culture of continuous learning and improvement.
- Identified trends within large datasets, providing valuable insights for management review and action planning.
- Improved business processes by identifying inefficiencies and proposing data-driven solutions.
- Interacted with internal customers to understand business needs and translate into requirements and project scope.
- Implemented business intelligence solutions to increase operational efficiency.
- Provided technical support for troubleshooting analytics and reporting issues.
- Generated ad-hoc reports to evaluate specific business requirements.
- Generated standard and custom reports to provide insights into business performance.
- Deployed predictive analytics models to forecast future trends.
IT Intern
İGA Havalimanı İşletmesi A.Ş
07.2023 - Current
- Conducted tests across platforms (istairport.com, akademi.igairport.aero, mobile app) and prepared reports
- Identified errors and performed root cause analysis for core issues
- Gathered and documented requirements for various projects
- Tested mobile app performance and participated in UI/UX and functionality discussions
- Performed comparative analysis of aviation websites and mobile apps, producing reports aligned with team objectives
- Completed assigned tasks ahead of schedule, demonstrating strong time management skills and commitment to project success.
- Delivered assistance and support for team-based IT projects.
- Conducted thorough testing of application features, ensuring functionality and reliability before deployment.
- Developed comprehensive documentation for internal use, simplifying knowledge transfer among team members.
- Supported development of custom software solutions, aligning with specific business needs and objectives.
- Conducted thorough testing of new software applications to ensure compatibility and efficiency across different operating systems.
- Participated in evaluation of new technology solutions, contributing to decisions that drove technological advancement and efficiency.
- Contributed to IT project planning sessions, offering insights that helped in shaping technology strategy and objectives.
Marketing Intern
TriCreativity
Beylikduzu, Istanbul
06.2022 - 12.2022
- Handled administrative tasks, preparing marketing materials, proposals, and reports
- Generated and presented new social media campaigns for approval
- Acted as page admin, posted content, responded to queries, and monitored trends across social platforms
- Conducted weekly and monthly data analysis for reporting purposes
- Tracked social media trends and adapted to attract target follower demographic.
- Assisted in creating visually compelling graphics for social media platforms, increasing engagement among followers.
- Designed and presented social media campaign ideas.
- Improved brand awareness by developing and implementing targeted social media campaigns.
- Participated in brainstorming sessions to generate innovative ideas for new marketing campaigns that resonate with target audiences effectively.
- Assisted in tracking and reporting marketing campaign performance, identifying key trends for continuous improvement of future efforts.
- Prepared weekly updates and reports to track growth and success rates of marketing campaigns.
- Enhanced customer retention rates, managing a consistent content calendar for blog posts and social media updates.
- Drafted weekly e-newsletters to subscribers and set up campaigns in MailChimp.
- Used Adobe Creative Suite to design initial campaign concepts.
- Researched interesting and relevant content to capture interest and improve site traffic.
- Researched competitor trends and interpreted findings to report conclusions to supervisors.
- Created customized marketing materials to increase product awareness.
- Optimized website content and images to improve search engine rankings.
- Completed keyword research and analyzed competitor SEO and PPC campaigns to identify gaps and opportunities.
- Collected and analyzed Web metrics such as visits, time on site and page views per visit.
Data Intern
HAGE INTERNATIONAL EXHIBITIONS
Beylikduzu, Istanbul
02.2022 - 06.2022
- Organized customer data, created databases, and managed customer outreach on exhibitions
- Supported CEO and Sales Manager in areas related to exhibitions and data management
- Maintained strict confidentiality while handling sensitive client information according to company guidelines and legal regulations.
- Contributed to a positive work environment by proactively assisting colleagues as needed, fostering strong professional relationships and a collaborative atmosphere.
- Supported team members with timely and accurate data entry, enabling them to focus on higher-level tasks.
- Gained valuable insights into industry trends through research assignments, further informing data-driven decision making within the organization.
- Reduced errors in reports by thoroughly reviewing entered data and making necessary corrections before submission.
- Prioritized daily workload effectively, managing multiple projects concurrently while maintaining a strong commitment to deadlines and quality standards.
- Assisted in the creation of user-friendly documentation for internal use, simplifying complex procedures for more accessible understanding across teams.
- Increased efficiency by automating repetitive tasks using Excel macros and formulas.
- Demonstrated adaptability by quickly learning new software programs and adjusting to changes in database structures or requirements.
- Served as a reliable point of contact for colleagues seeking assistance with database-related issues or queries on specific projects or tasks.
- Corrected data entry errors to prevent duplication or data degradation.
Education
Bachelor’s - Marketing
İstanbul Bilgi University
Eyüpsultan, İstanbulBachelor’s - Management Information Systems
İstanbul Bilgi University
Eyüpsultan, İstanbulSkills
SQL
REST API
MS Visio
Figma
Balsamiq
Jira
BPMN
UML
HTML
JavaScript
PHP
CSS
MySQL
Software development life cycle
Data analysis
Python programming
Business process improvement
Stakeholder management
SQL proficiency
Requirements gathering
Business process mapping
Needs assessments
Workflow optimization
Test case scenarios
Change management
Power BI
Certification
IT Management, European Institution of Leadership and Management, 2024
Volunteer Experience
Gelişim Kuşağı, Executive Assistant, Online, Turkey, 01/01/20, 12/31/20, Managed daily and weekly activities on digital platforms (Zoom)., Prepared schedules for the founder, organized meetings with educators, and ensured smooth execution of online courses., Communicated with learners to address questions and provide assistance.
Timeline
Junior Business Analyst
İGA Havalimanı İşletmesi A.Ş
09.2023 - Current
IT Intern
İGA Havalimanı İşletmesi A.Ş
07.2023 - Current
Marketing Intern
TriCreativity
06.2022 - 12.2022
Data Intern
HAGE INTERNATIONAL EXHIBITIONS
02.2022 - 06.2022
Bachelor’s - Marketing
İstanbul Bilgi University
Bachelor’s - Management Information Systems
İstanbul Bilgi University