Maksim Blekhshtein

Consultant (Data Scientist Data Researcher) @Eufomex

Munich, DE

Project 1: Automated Task Tracking & Performance Insights- Developed a Python-based resume ranking system using OpenAI API, recruitment platform API, and GPT-3.5 to automate parsing, ranking, and candidate-job matching- Used Python (Requests, JSON, Pandas) to structure and analyze candidate data, generating rankings in a DataFrame with IDs, names, and match scores- Automated Power BI dashboards, integrating Microsoft Planner & Excel for real-time performance tracking. Scheduled batch updates (every 2 hours)- Integrated Adaptive Cards in MS Teams for real-time task updates, automated reminders, and notifications, improving coordination and transparency- Optimized workflow, reducing manual coordination by 5+ hours/month, tracking KPIs like task completion rates and backlog status.Project 2: Cloud-Based BI Platform for Marketing Analytics- Developed a cloud-based BI platform on GCP, integrating marketing analytics and search performance data- Built a BigQuery-based data warehouse with Star Schema modeling for optimized storage & analysis- Automated data ingestion & transformation using Apache Airflow (Cloud Composer), processing data from Google Search Console & external platforms- Used PySpark to enhance query efficiency in BigQuery- Created an interactive Looker Studio dashboard for real-time traffic & engagement monitoring.Project 3: Data Quality & Performance Attribution for a German Asset Manager- Validated transactions, resolving investment classification & reporting errors using SQL- Analyzed 4 years of historical data to verify a performance attribution tool, identifying discrepancies- Developed a reconciliation process to map metrics between legacy & new systems, reducing inconsistencies- Tracked data upload KPIs, delivering weekly/monthly reports for process improvements.