Erez Gartsman — Product & Data Management Portfolio

About Me

Final-year Data & Product Management student at Bar-Ilan University (Dual-Degree in Information Science & Communication). Proven track record of merging data-driven insights with creative storytelling, leveraging 4+ years of community building and content strategy. Experienced in executing end-to-end data projects, defining product requirements (PRDs), and translating user research into technical solutions. Passionate about bridging the gap between R&D logic and user engagement to deliver measurable impact.

Core Capabilities

Data Analytics

End-to-end data pipelines, ETL automation, and interactive Power BI dashboards. Python, SQL, and AI-assisted analytics that turn engagement logs into actionable KPIs.

Product Strategy

PRD writing, user research (thematic analysis), UX/UI principles, and Agile methodologies. Translating user pain points into clear, testable product requirements.

Growth & Content

Scaled a digital community to 75,000+ engaged followers. A/B tested content formats and executed cross-platform creative strategy from concept to delivery.

Market Research

Competitor benchmarking, SWOT analysis, and AI-driven qualitative research. Translating strategic insights into clear feature prioritisation.

Resume & Experience

Education

Oct 2023 – Jul 2026

Bar-Ilan University

B.A. Dual-Degree — Information Science & Communication

GPA: 97.05

Relevant coursework: Product Management, Data Analysis, HCI, UX Research, Information Retrieval, Digital Strategy, Consumer Behavior, Database Management.

Oct 2025 – Sep 2026

Bar-Ilan University — PM Fellowship

Fellow: Product Management Program

GPA: 98

Intensive fellowship in Product Management — strategy, PRD writing, stakeholder alignment, and go-to-market execution.

Military Service

Mar 2018 – Nov 2020  ·  Reserve: 2023–2024

IDF — 188th Armored Brigade

Tank Commander & Operations Sergeant (Rasp)

Iron Swords — Tzav 8

Commanded tank crews and combat personnel, overseeing operational readiness and personnel management. Directed company-level logistics and complex field deployments. Mobilised for active reserve duty (Tzav 8) during Operation Iron Swords (2023–2024).

Experience

Aug 2021 – Present

Self-Employed

Digital Content Creator & Community Manager

Scaled a digital community to 75,000+ highly engaged followers across multiple platforms. Conducted A/B testing on content formats, analysing engagement metrics to optimise reach and retention. Facilitated 1-on-1 user interviews and coaching sessions to extract qualitative insights.

Nov 2024 – Mar 2026

Maya Karvat Communications & Content

PR Specialist & Researcher

Conducted in-depth qualitative research and client interviews to define brand messaging for leading culinary brands (Taizu, "a" restaurants). Orchestrated cross-functional media operations and stakeholder alignments ensuring seamless PR plan execution.

May 2023 – May 2024

Alfi Productions

Creative Lead & Content Strategist

Directed cross-platform creative strategies, translating client requirements into engaging visual narratives. Collaborated with cross-functional teams to align content with strategic business goals, ensuring high user engagement and brand consistency.

Technical Skills

Data Analytics
Product Management
Creative Strategy
Development (C#, Python, JS)

Tools & Technologies

Python SQL Power BI DAX Selenium Figma JavaScript C# / .NET HTML / CSS Jira MySQL MCP Base44 AI / LLMs

My Projects

PROJECT 01
Instagram Analytics Pipeline
DataPythonPower BI

End-to-End Instagram Analytics Pipeline

Engineered Python/Selenium web-scraping scripts to extract raw engagement logs, establishing an AI-assisted ETL pipeline. Designed a Star Schema data model with complex DAX measures in Power BI and deployed interactive dashboards to production. Leveraged MCP to connect AI tools with local environments and implemented Webhook automations between Jira and Slack.

PROJECT 02
Smartrip Application
ProductUX/UIPrototype

Smartrip — Travel Planning Application

Led product definition and development of a functional prototype for a smart travel planning application in Base44. Conducted in-depth user research to identify friction points in multi-participant trip planning, and designed a goal-oriented UX with zero-friction onboarding.

PROJECT 03
Market Research & AI Analysis
AIStrategyResearch

Market Research & Competitor Analysis

Spearheaded comprehensive competitor research — comparative benchmarking, UX/UI mapping, and value proposition analysis. Integrated AI to automate qualitative and quantitative research. Delivered a strategic insights report with a full competitor matrix, SWOT analysis, and feature prioritisation recommendations.

Contact Me

Phone

+972-546150955

Email

erezkim1234@gmail.com

Location

Hadera, Israel

LinkedIn

linkedin.com/in/erezgartsman

Let's work together.

I'm open to full-time opportunities in Product Management and Data Analytics, as well as freelance and consulting engagements. Drop me a message and I'll get back to you as soon as possible.