v
van_4956

Ivan G

@van_4956

Data Analyst: SQL, Python, Pandas, BI, AB Testing, Statistics

Russland
Russisch
Einige Informationen werden in englischer Sprache angezeigt.
Über mich
I am a Data Analyst specializing in SQL, Python, BI, and product analytics. I help clean and analyze data, calculate business metrics, build dashboards, automate reports, and turn raw data into clear insights. My experience includes PostgreSQL, Pandas, A/B testing, funnel, cohort, retention and churn analysis. You will receive a structured result, clear documentation, and simple explanations.... Mehr lesen

Kompetenzen

v
van_4956
Ivan G
offline • 
Durchschnittliche Antwortzeit: 1 Stunde

Meine Dienstleistungen

SQL- und NoSQL-Abfragen
I will write and fix sql queries for postgresql and bigquery
Ab10 $ / ProjektWeitere Details
Statistische Modellierung & Analyse
I will clean, analyze and visualize your data using python and pandas
Ab10 $ / ProjektWeitere Details

Portfolio

Arbeitserfahrung

Self_Employed

Data Analyst and Python Developer

Self Employed • Selbstständig

Apr 2025 - Present • 1 yr 4 mos

Work on independent data analysis, machine learning, and Python automation projects. Projects include recommendation systems using matrix factorization, regression models with CatBoost, semantic analysis of large text datasets, Telegram bots, data collection pipelines, and computer vision prototypes. I handle the full workflow: data collection, cleaning, exploratory analysis, feature engineering, modeling, evaluation, visualization, documentation, and publishing projects on GitHub and Kaggle. Technologies: Python, SQL, Pandas, NumPy, PostgreSQL, machine learning, statistics, web scraping, data visualization, and automation.

Company

Vollzeit • 3 yrs 11 mos

Data Analyst

Sep 2022 - Feb 2025 • 2 yrs 5 mos

Worked as a Data Analyst at 3Commas, in a B2C SaaS product for crypto trading. Built and maintained SQL and dbt data models, automated reporting pipelines, and dashboards for product, business, and marketing teams. Migrated reporting from Metabase to Amazon QuickSight and reduced the number of dashboards by approximately 50%, making reporting easier to maintain and use. Analyzed product funnels, user behavior, retention, churn, and business metrics. Designed and evaluated A/B tests, checked data quality, and prepared analytical reports for product managers and stakeholders. Technologies: SQL, Python, dbt, Amazon QuickSight, Metabase, Docker, Git, statistics, and A/B testing.

Web Analyst

Feb 2021 - Aug 2022 • 1 yr 6 mos

Worked as a Web Analyst at Gazelkin, a logistics and transportation company. Analyzed marketing and website performance using data from advertising platforms, web analytics, and CRM systems. Combined data from Google Ads, social media traffic, and internal sources, built automated reports in Google Data Studio and Excel, and helped evaluate campaign efficiency. Developed a Telegram bot that delivered hourly performance reports to management, reducing the need for manual monitoring and making key metrics available throughout the day. Technologies: Google Analytics, Google Data Studio, Excel, SQL, Python, API integrations, and Telegram bots.