Kaan Alpagut

Kaan Alpagut

Intern

Followers of Kaan Alpagut927 followers
location of Kaan AlpagutIstanbul, Türkiye

Connect with Kaan Alpagut to Send Message

Connect

Connect with Kaan Alpagut to Send Message

Connect
  • Timeline

  • About me

    Sales Business Analyst | Certificated Data Scientist | Power BI Developer

  • Education

    • Mustafa Saffet Anatolian High School

      2008 - 2011
      High School Diploma PHYSICAL SCIENCES
    • Sakarya Üniversitesi

      2011 - 2017
      Bachelor of Engineering - BE Mechanical Engineering

      Activities and Societies: SAUBIT (Sakarya Üniversitesi Bisiklet Topluluğu - Sakarya University Bicycle Community)

  • Experience

    • Birleşim Mühendislik Isıtma Soğutma Havalandırma San. ve Tic. A.Ş.

      Jul 2013 - Aug 2013
      Intern
    • MEP Mekanik Proje ve Müşavirlik A.Ş.

      Mar 2016 - Mar 2020
      Project Engineer

      • Managed the design process of buildings from scratch, overseeing HVAC, firefighting, and sanitary systems.• Conducted heat load and loss analysis, as well as pipe & duct pressure calculations.• Led the technical drawing team to ensure project accuracy and efficiency.• Prepared bill of quantity and offer files for project ownership or contractors.

    • ISIDEM Yalıtım Sanayi ve Ticaret A.Ş

      Oct 2016 - Nov 2016
      Intern
    • SOEM Mühendislik

      Mar 2020 - Sept 2020
      Project Engineer

      • Managed the design process of buildings from scratch, overseeing HVAC, firefighting, and sanitary systems.• Conducted heat load and loss analysis, as well as pipe & duct pressure calculations.• Led the technical drawing team to ensure project accuracy and efficiency.

    • Wilo Group

      May 2021 - now

      * Monitored and reported on sales data quality by extracting from Microsoft CRM into Power BI, refining in Power Query, and identifying missing or inaccurate entries.* Transitioned from static Excel to real-time Power BI dashboards, generating monthly Data Quality and Sales Excellence reports to track key KPIs (e.g., CRM opportunities) vs. regional targets.* Automated bi-weekly “Overdue Opportunity” and monthly “Sales Excellence Reports” distribution using Power Automate for faster, more reliable insights.* Acted as the go-to expert on Sales Excellence reports and KPIs, resolving queries, providing detailed breakdowns, and creating dashboards (e.g., “Location & Asset Screening,” “Quote & Opportunity Screening”).* Trained subsidiary teams (in-person and online) on CRM report and dashboard creation, ensuring widespread adoption of data-driven practices.* Collaborated with cross-functional teams (Digital Business, Sales Controlling, GIM) to develop QlikView/Tableau solutions, integrating SAP data for comprehensive analysis.* Resolved data discrepancies by engaging subsidiaries and IT, cutting the “Overdue Opportunity” rate from 80% to 9% and significantly enhancing forecasting accuracy.* Supported the Sales Governance Manager by refining CRM processes, dashboards, and KPIs based on real-world feedback.* Designed and maintained daily “Sales Excellence Reports,” providing near real-time visibility for regional and country managers.* Improved sales tracking, forecasting, and lead generation through dedicated dashboards and KPI developments.* Built targeted Power BI dashboards (e.g., “Location & Asset Screening,” “Quote & Opportunity Screening”) to visualize historical sales data and guide strategic decisions. Show less

      • Sales Business Analyst (Global)

        Apr 2024 - now
      • Project Sales Engineer

        Oct 2020 - Apr 2024
      • Product Management Specialist

        Nov 2023 - Feb 2024
      • Internal Sales Engineer

        May 2021 - Oct 2021
  • Licenses & Certifications