Олександр

Alex Zamay
BI Consultant - PowerBI Developer - Data Engineer ​
tel.: [відкрити контакти](див. вище в блоці «контактна інформація»), LinkedIn: [відкрити контакти](див. вище в блоці «контактна інформація») ​

I build decision-ready analytics systems for small and medium-sized businesses.​
My work focuses on turning scattered business data into clear dashboards and reliable data
models that help owners and managers understand what is actually happening in the business.
I design analytics systems that connect data sources, structure the data, and visualize key business
metrics.

Typical problems I solve:

• Sales, marketing and finance data are scattered across different systems
• Reports are built manually in spreadsheets
• Metrics are inconsistent across teams
• Management lacks a single source of truth

My core stack:

• Microsoft Power BI
• Data Modeling (Star Schema)
• DAX
• SQL (PostgreSQL, MySQL)
• ETL pipelines
• API integrations
• N8N Automations
• Data Warehouse design

Typical project workflow:

1. Connect data sources (CRM, databases, APIs, spreadsheets)
2. Build a structured data model or data warehouse
3. Implement ETL pipelines
4. Develop Power BI dashboards
5. Define KPIs and business metrics
6. Deliver a clean and scalable analytics system

Before moving into BI consulting, I spent more than 10 years in business operations and sales management.
This helps me understand how metrics are used for real management decisions, not just reporting.

Typical dashboards I build: • Sales performance dashboards • Marketing analytics dashboards • Financial
performance dashboards • Operations dashboards • Customer analytics dashboards

Tools I work with daily: Power BI, DAX Studio, SQL, PostgreSQL, APIs, Python ETL.

Recent hands-on experience in recent years, briefly: building a data platform tied to a real business
environment — from sources to warehouse layers to Power BI; integrating a CRM via API into a
Neon-hosted PostgreSQL database; internal Telegram digests for the business owner; a customer-facing
Telegram bot orchestrated with n8n and conversation history stored in PostgreSQL; and the studio’s website
and marketing funnel, including deployment, GitHub, GTM container setup, and event tracking for analytics
attribution.

If you're looking for someone who understands both business and data — feel free to reach out!