Julio CaesarData & Analytics

Julio Caesar · Berlin

Data & AnalyticsProfessional

Business Intelligence Consultant at InfoFabrik. I use data to answer business questions, solve complex problems, and support informed decisions.

Explore my workGet in touch
Julio Caesar

About me

My background spans analytics and data engineering, alongside experience guiding teams and coordinating technical projects from business requirements to implementation.

Alongside my work, I’m pursuing a part-time Data Science master’s focused on finance and insurance management.

  • Part-time MSc in Data Science. Expected completion: summer 2027.
  • Based in Berlin. Fluent in German and English; native Indonesian.

02 / Selected work

Selected work

Solving practical problems through analytics, data science, and technical ownership.

Entity matching

Public demos

Sanctions screening

Name matching and pipeline monitoring using the official EU sanctions list.

  • Compare spelling variants and aliases.
  • Inspect the evidence behind candidate matches.
  • Check source age, ingestion status, and alias coverage.
  • NLP
  • Levenshtein
  • TypeScript
  • Node.js
Open the matcherView pipeline status

Data science

Case study

Credit card fraud detection

Finding fraud with XGBoost and measuring the tradeoff in manual reviews.

  • 41 of 52 fraud cases detected in the final test.
  • 175 legitimate transactions flagged for review.
  • Python
  • DuckDB
  • XGBoost
  • FastAPI
Read the case study

Pro bono

In progress

GBI Berlin Serve

A pro bono app for church analytics and shared calendars.

  • Attendance KPIs, people insights, and role-based access.
  • Own architecture, SQL reporting, and deployment.
  • Next.js
  • Supabase
  • PostgreSQL
  • Render

Personal project

Caesar’s Fret Lab

An interactive guitar neck for identifying chords, exploring voicings, and practising scales.

Open Fret Lab

03 / Experience

Experience

Business analytics, data engineering, and delivery across teams.

InfoFabrik GmbH / Berlin, GermanyNovember 2024 to Present

Business Intelligence Consultant

Translate business requirements into reporting solutions for German development banks, with responsibility for data quality, releases, and reliable BI operations.

Client engagements

  • Investitionsbank Berlin (IBB)
  • Investitions- und Förderbank Niedersachsen – NBank
Reporting & data integration
Develop reporting solutions from business requirements through source integration, data preparation, and delivery.
Regression testing & discrepancy analysis
Test code and releases for unintended changes. Investigate data and reporting discrepancies in test and production environments.
Financial data validation
Analyse budgets and reconcile figures across systems. Investigate technical and business discrepancies and perform plausibility checks.
Screening & data protection
Support sanctions screening. Define anonymisation and pseudonymisation rules, implement the SQL logic, and validate the results.
DataOps & performance tuning
Monitor batch processes, data ingestion, and database performance. Coordinate issue resolution and tune processing performance.
DevOps & release management
Coordinate releases and database, server, and Tomcat patches across test and production environments. Administer NBank’s ReportServer on Tomcat and analyse logs.

Tools & focus

  • Oracle
  • PL/SQL
  • ReportServer
  • Tomcat
  • Azure
  • Microsoft SQL Server
  • Python
  • VBScript (VBS)
  • Java
  • Groovy

Magaloop GmbH / Berlin, GermanyApril 2021 to September 2024

BI / Data Analyst

Delivered dashboards, product analytics, and data pipelines for product and customer reporting.

  • Built Tableau dashboards and analysed product and customer trends to support business decisions.
  • Built and maintained an ETL pipeline with Python and Airflow, using BigQuery and Google Cloud Storage on GCP.
  • Analysed A/B test results to evaluate product changes.

Tools & focus

  • Python
  • SQL
  • Airflow
  • BigQuery
  • Google Cloud (GCP)
  • Google Cloud Storage
  • PostgreSQL
  • Tableau

Hotel Santika Premiere Jakarta / Jakarta, IndonesiaNovember 2014 to May 2015

Accounting & E-Commerce Intern

Supported accounting and invoicing, with price comparison and exchange-rate analytics for e-commerce operations.

Tools & focus

  • Accounting
  • Invoicing
  • Price comparison analytics
  • Exchange-rate analytics

04 / Skills

Tools & methods

From business questions to analysis, delivery, and operations.

Programming

  • Python
  • SQL / PL/SQL
  • Java
  • Groovy
  • VBScript

BI & analytics

  • Tableau
  • ReportServer
  • A/B testing
  • Budget analysis

Data platforms

  • Oracle
  • PostgreSQL
  • SQL Server
  • BigQuery
  • GCP / Cloud Storage
  • Azure

DevOps & DataOps

  • Airflow
  • Tomcat
  • Releases
  • Batch monitoring
  • Performance tuning

Data quality & screening

  • Regression testing
  • Reconciliation
  • Sanctions screening
  • Anonymisation
  • Pseudonymisation

Data science · studies

  • Regression / classification
  • XGBoost
  • Anomaly detection
  • Clustering
  • Model evaluation
  • Statistics

05 / Contact

Let’s connect

For data science, analytics, and technical delivery opportunities, contact me by email or LinkedIn.

LinkedInGitHub