Data Analyst · Business Intelligence

I turn customer signals into clear business decisions.

I combine 13+ years of customer operations experience at MTN Irancell with freelance experience in revenue analytics, HR analytics, and Power BI reporting, supported by end-to-end data analytics and business intelligence projects.

Open to Data Analytics, BI and Customer Analytics roles in Germany. Relocation and visa sponsorship required.

View projects Contact me
Behnam Shayan
13+
years in customer operations
5
end-to-end projects
SQL · Python · Power BI
core toolkit
Projects

Selected work

Each project starts from a business question, not a dataset. The analysis follows wherever the question leads.

Customer analytics · e-commerce

E-Commerce Analytics & Business Diagnostics

Business question: Which customer segments offer the biggest retention and revenue opportunities?

Solution: A SQL Server star-schema warehouse and Python ETL workflow, customer segmentation and retention analysis, and Power BI dashboards.

Result: An executive diagnostic report with retention scenarios, priorities and a 90-day action plan.

SQL ServerPythonPower BIETL
View on GitHub →
Labor market · data engineering

Germany Job Market Intelligence Platform

Business question: Which skills and regions are in demand for tech and data jobs in Germany?

Solution: A Python collection pipeline, PostgreSQL storage with retry handling, a regex skill-extraction engine and a Streamlit dashboard.

Result: 830+ unique job postings analyzed, covering 50 skills in eight categories.

PythonPostgreSQLDockerStreamlit
View on GitHub →
Data engineering

Automated Excel-to-SQL Market Data Pipeline

Business question: How can market data be refreshed reliably without manual work?

Solution: Excel COM automation loads web market data into SQL Server, with change detection and historical records.

Result: Unattended runs through Windows Task Scheduler that feed Power BI reports.

PythonSQL ServerPower BITask Scheduler
View on GitHub →
Automation · AI

AI-Powered Telecom Competitive Intelligence

Business question: How can telecom news become a regular market briefing?

Solution: An n8n workflow collects RSS news, and an LLM classifies it and writes structured summaries.

Result: Executive reports on market signals, competitor activity and risks, delivered by email.

n8nJavaScriptGPT-5-miniRSS
View on GitHub →
Machine learning · finance

German Credit Risk Classification

Business question: Can an interpretable model match an AutoML baseline for credit-risk classification?

Solution: Logistic Regression and LightGBM, compared with class-imbalance strategies and stratified five-fold cross-validation.

Result: ROC-AUC within 0.009 of the AutoML model, with a more interpretable approach.

Scikit-learnLightGBMAutoGluon
View on GitHub →
About

From customer operations to data analytics

I'm Behnam Shayan, with 13+ years of experience in customer operations at MTN Irancell. My background has given me first-hand insight into customer behavior, recurring service issues and operational challenges.

My work combines business understanding, analytical problem-solving, and technical implementation. I use SQL, Python, Power BI, and data modeling to investigate business performance, identify root causes, uncover revenue opportunities, and turn findings into actionable recommendations.

My focus is on understanding why problems happen, finding meaningful opportunities, and turning analysis into practical business recommendations.

Questions

Questions I work on

01What is the customer doing?
02Why is it happening? What is the root cause?
03Which customers matter most?
04Where is the biggest opportunity?
05What should the business actually do?
Services

What I bring to a team

01

Customer segmentation & retention

Finding high-value customer groups and revenue recovery opportunities with RFM, churn and retention analysis.

E-Commerce Analytics →
02

Root-cause analysis

Investigating repeated problems and the gaps between procedures and real practice, then recommending fixes.

E-Commerce Analytics →Irancell experience →
03

Power BI dashboards

Designing Power BI dashboards and KPI reports for revenue analysis, HR analytics, and business performance monitoring, supported by structured data models and DAX measures.

E-Commerce Analytics →
04

SQL & data modeling

Star-schema data warehouses, ETL pipelines and queries that stay reliable.

E-Commerce Analytics →Excel-to-SQL Pipeline →
05

Python & machine learning

Data cleaning, analysis and interpretable predictive models with pandas, scikit-learn and LightGBM.

German Credit Risk →
06

Workflow automation

n8n and LLM-driven workflows that replace repetitive manual reporting.

Telecom Intelligence →
Experience

Experience & education

Oct 2023 — present

Data Analyst & Business Intelligence Consultant

Barsian Darou · Pharmaceutical import company · Freelance / contract
  • Develop Power BI dashboards for revenue analysis and business performance monitoring.
  • Build HR analytics reports to help stakeholders review workforce-related indicators and departmental performance.
  • Translate business reporting requirements into clear dashboards, KPIs, and structured analytical views.
  • Support data-driven decision-making by improving visibility into revenue trends, HR indicators, and operational performance.
Jul 2013 — present

Omni-Channel Contact Center Representative

MTN Irancell
  • Investigate recurring customer complaints, service issues, and gaps between documented procedures and operational practices.
  • Participate in weekly and monthly operational reviews to identify root causes, clarify process ambiguities, and recommend corrective actions.
  • Evaluate customer responses to products and services to identify improvement opportunities and unmet customer needs.
  • Propose at least five improvement ideas per month, with two recommendations implemented through internal improvement processes.
Education

Education

B.Sc. in Civil Engineering — Saraj University
Associate Degree in Civil Engineering — University of Bonab

Training

Certifications & Professional Training

SQL Fundamentals · Python Programming · Microsoft Power BI (Beginner to Advanced) · Microsoft Excel · Machine Learning Fundamentals · n8n Workflow Automation (MTN Irancell internal training)

Languages

Languages

Azerbaijani (native) · Persian (fluent) · Turkish (fluent) · English B2 · German (A1)

Skills

The toolkit behind the analysis

Data analytics

SQLPythonPandasNumPyEDARoot-cause analysis

Business intelligence

Power BIDAXPower QueryKPI designDashboard developmentExcel

Data engineering

ETLData warehousingStar schemaSQL ServerPostgreSQL

Customer & business analytics

Customer segmentationRFMChurnRetentionRevenue analysisHR analytics

Automation & AI

n8nJavaScriptLLM integrationPrompt engineering

Machine learning

Scikit-learnLightGBMAutoMLClassificationModel evaluation
Approach

Not just charts. Decisions.

I start with the business problem, validate the data, investigate the root cause, and translate the findings into clear recommendations.

In my e-commerce analytics project, I connected customer segmentation and retention analysis to potential revenue opportunities, then turned the findings into prioritized actions and a 90-day plan.

My goal is not simply to explain what happened, but to help decision-makers understand why it happened and what they can do next.

Let's talk about your data.

Open to Data Analytics, Business Intelligence, Customer Analytics and Business Analysis roles.

Email me GitHub ↗ LinkedIn ↗

pybehnamshayan@gmail.com