• Peyman Farahani

    Data Scientist

  • Summary

    High performing data scientist with a passion for business analytics and a strong background in machine learning and programming with Python. Possess a track record of delivering positive outcomes for organizations through the application of data-driven solutions.
    Skilled in collaborating with cross-functional teams to solve complex, high-stakes problems. Committed to continuous improvement and always striving to contribute to team success.

    Contact

    +98 939 177 4443
    peymanffarahani@gmail.com
    pfarahani.github.io
    peymanfarahani
    live:payman_fara
    PFarahani

    Certificates

    BI Foundations with SQL, ETL and Data Warehousing Specialization

    IBM

    Dec 2023

    Machine Learning Specialization

    University of Washington

    Oct 2022

    Deep Learning Specialization

    DeepLearning.AI

    Aug 2022

    The Complete Python 3 Course

    Udemy

    May 2020

    Python Programming with Data Science Approach

    K. N. Toosi University of Technology

    Dec 2019

    Languages

    English

    German

    Persian

    Hobbies

    Santoor

    Skiing

    Movies

    Swimming

    Gaming

  • Work Experience

    Business Intelligence Developer

    Riton

    Mar 2024 - Present

    • Optimized SSIS ETL packages by tuning execution, indexing OLTP sources, and compressing data, cutting processing time by 80%.
    • Redesigned data warehouse with 3 business-aligned data marts and 117 OLAP views, reducing ETL time by 4 hours and boosting report speed by 98.66%.
    • Built 65+ DAX-powered Power BI dashboards, delivering real-time analytics and actionable insights for clients.

    Key Projects

    • "SSIS Package Auto Reviewer": Automated SSIS compliance reviews, cutting review time from 45 mins to <1 sec and removing manual errors. Link
    • "Version Control for BI Artifacts": Introduced Git-based control for SSIS/SSAS/Power BI by reverse-engineering project structures to enable conflict-free collaboration.

    Business Intelligence Developer

    SnappTrip

    Aug 2022 - Aug 2024

    • Created pipelines using SQL and Spark, enabling efficient reporting from ClickHouse, Trino, and PostgreSQL.
    • Forecasted SnappPay's demand using time series modeling, increasing revenue by 138% in 2 weeks.
    • Automated failed tax resubmission with Spark, saving 77.3 minutes of weekly manual effort.
    • Archived underused Metabase dashboards, cutting load time by 21% (66.5s → 52s).
    • Reverse-engineered APIs for flight pricing insights, leading to a 13.7% revenue boost.
    • Automated analysis tasks with PySpark and PostgreSQL, improving team productivity.

    Key Projects

    • "CV-Person Detector": A script to detect and flag people in images for international hotel landing pages, ensuring compliance with content guidelines
    • "Cron Task Scheduler": A script to optimize task scheduling and eliminate overlapping. Link
    • "Flight Data Crawler": Crafted scripts to gather competitor flight data, providing insights into pricing trends
    • "Hotel Guarantee Code Checker": Created a script automating manual code verification, ensuring accuracy within a specified date range
    • "Free RoomNight Lookup": Innovated a program automating the manual process of extracting and comparing booking information

    Data Analyst & Business Process Analyst

    SAIPA

    Aug 2020 - Apr 2021

    • Designed and corrected system processes using BPMN 2.0 tools, enhancing efficiency and accuracy
    • Updated regulations for the QC department, ensuring improved compliance through analysis and implementation
    • Designed Power BI dashboards, improving data visualization and boosting informed decision-making

    Key Projects

    • Vehicle Specification Clustering: Implemented k-means algorithm and PCA analysis to segment cars' specifications, providing actionable insights from data by the Center of Strategic Studies of SAIPA
    • SAIPA Financial Dashboard: Developed a comprehensive financial dashboard using data from 2015 to 2020, presenting key insights to senior management

    Education

    B.Sc. Industrial Engineering

    Amirkabir University of Technology (Tehran Polytechnic)

    Sep 2017 - Feb 2022

    Skills

    Industry
    Knowledge

    Machine Learning

    Deep Learning

    Web Scraping

    Business Analysis

    Version Control (Git)

    Business Intelligence

    Data Modeling

    Programming

    Python

    SQL

    Spark

    Python
    Library

    Pandas

    NumPy

    Matplotlib

    Seaborn

    Plotly

    Scikit‑learn

    PyTorch

    TensorFlow

    Spacy

    Scrapy

    Selenium

    Requests

    Asyncio

    Software

    SSIS

    SSAS

    ClickHouse

    Excel

    PowerBI

    Tableau

    Metabase

    Weka

    Apache Airflow

    Apache Kafka

    SPSS Modeler

    SPSS

    MS Access