Bruno Jagic, Entity-relationships Model (ERM) Developer in Nuremberg, Bavaria, Germany
Bruno Jagic

Entity-relationships Model (ERM) Developer in Nuremberg, Bavaria, Germany

Member since February 12, 2015
Bruno is a data engineer with over five years of experience in data engineering and analysis, modeling, and quality as well as complex SQL queries. He has spoken at conferences and trained internal employees in SQL, Exasol, and Alteryx as part of his work with Adidas. He has top ratings in his freelance work with on focus data and SQL, and he is looking for new remote opportunities to add value and put his past experience to good use.
Bruno is now available for hire

Portfolio

  • Adidas
    Alteryx, Confluence, Jira, T-SQL, Microsoft SQL Server, Lua, Exasol
  • CROZ
    Talend, SQL Server Integration Services (SSIS), IBM Db2, Microsoft SQL Server
  • Self-employed
    T-SQL, SQL Server Integration Services (SSIS), Microsoft SQL Server, Talend

Experience

  • Entity-relationships Model (ERM) 6 years
  • Database Design 6 years
  • SQL 6 years
  • Lua 3 years
  • Jira 3 years
  • Alteryx 3 years
  • Exasol 3 years

Location

Nuremberg, Bavaria, Germany

Availability

Part-time

Preferred Environment

PostgreSQL, MySQL, Lua, Exasol, ETL, Microsoft SQL Server

The most amazing...

...thing I've done is build Consumer DNA, a product for Adidas that became a core element of their email marketing and data science models.

Employment

  • Data Engineer

    2016 - PRESENT
    Adidas
    • Integrated payment data for fraud analysis, designed databases, built automated solutions, and presented to the business.
    • Built a data quality framework for main integration topics like sales and clickstream data in an automated fashion.
    • Built and maintained Consumer DNA, a set of attributes from all digital touchpoints like clicks from the website, sales, registration, email marketing, paid media, NPS, bazaar voice, and subscriptions; it is now a core product used in email marketing and website personalization that enables us to target a specific percentile of users per specific campaign.
    • Spoke at conferences including Alteryx Inspire 2018 in London, where I presented how we use Alteryx in Adidas. In March 2019 I will attend as an invited guest to speak on a similar topic.
    • Built Alteryx applications and workflows such as a workflow that connects to different APIs to get data relevant to our apps, including the number of downloads, active users, and installations.
    • Created applications that helped our database administrators to automate their work like, for example, Alteryx, which creates users, grant them priviliges, and automatically emails the users with relevant information.
    • Developed multiple workflows and applications for ad-hoc analysis, data quality, data integration, and database administration.
    Technologies: Alteryx, Confluence, Jira, T-SQL, Microsoft SQL Server, Lua, Exasol
  • Database Developer

    2014 - 2016
    CROZ
    • Developed a data warehouse for Croatian tax authorities where the goal was to centralize all the relevant data that our government has to be able to provide them the ability to detect tax fraudsters.
    • Built a warehouse for the Croatian Bureau of Statistics for data integration and analysis of all the relevant data about high school education in Croatia.
    Technologies: Talend, SQL Server Integration Services (SSIS), IBM Db2, Microsoft SQL Server
  • Database Developer

    2013 - 2015
    Self-employed
    • Used MySQL to store all data about properties in the US with a goal of estimating a value of specific property. My tasks included responsibilities for data quality in each step, such as integration, insertion to dimensional model, and preparation of reports for senior management.
    • Built databases for students and small companies including everything from the collection of requirements to the design of solutions up to building a solution in a specific database (MySQL, MS SQL, Postgre).
    • Created an integration process for loan reporting; the client had a collection of companies that have provided loan services, and all of them came to the system from which I had to build integration steps to provide insights.
    • Used Alteryx to analyze the data, preparing insights and doing data cleanup.
    • Provided data analysis for a client that wanted to predict the stock market; my part was to build SQL queries for a specific business use case and stock market items.
    Technologies: T-SQL, SQL Server Integration Services (SSIS), Microsoft SQL Server, Talend

Experience

  • Consumer DNA

    Built and optimized Consumer DNA, a solution that is core for digital business in Adidas. The goal of the solution was to create consumer attributes for each consumer so that it is easily accessible and usable by the end systems for website personalization and email marketing. A large percentage of emails sent by Adidas is now triggered by this solution.

  • DWH for Croatian Tax Authorities

    A data warehouse for Croatian tax authorities to detect tax fraud. it was a massive collection of data that is owned by the Croatian government and is very sensitive; I was part of the team that was able to deliver this project within one year.

  • DWH for Croatian Bureau of Statistics

    A warehouse for the Croatian Bureau of Statistics for data integration and analysis of all the relevant data about high school education in Croatia.

  • Payments Data Integration

    Integration of payments data for fraud analysis where the first step was to migrate existing data from SQL Server into Exasol and the second was to connect to the payment service provider and integrate the data on an hourly basis into the same database.

    I was brought to Adidas for this. It was a one-man project for eight months, in which I was able to deliver a hyper-automated solution that works even now after two years of operation and optimization without an issue.

Skills

  • Languages

    SQL, Lua, T-SQL, Python
  • Tools

    DbVisualizer, Jira, AWS Athena, Amazon QuickSight, Sisense, Excel 2016, Confluence, Adobe Analytics
  • Paradigms

    Database Design, Agile, Scrum, ETL
  • Platforms

    Alteryx, Talend, Jupyter Notebook
  • Storage

    Exasol, SQL Server 2016, MySQL, SQL Server Management Studio, PostgreSQL, SQL Server Integration Services (SSIS), Datastage, Microsoft SQL Server, IBM Db2
  • Other

    Entity-relationships Model (ERM), Data Analysis, Office 365, Complex Data Analysis

Education

  • Master's degree in Computer Science
    2010 - 2016
    University of Zagreb - Zagreb

Certifications

  • Alteryx Advanced Certified
    FEBRUARY 2019 - FEBRUARY 2021
    Alteryx
  • Exasol Certified Database Developer
    NOVEMBER 2018 - PRESENT
    Exasol AG
  • Exasol Certified Scripting Expert
    NOVEMBER 2017 - PRESENT
    Exasol AG
  • Exasol Certified Performance Expert
    NOVEMBER 2017 - PRESENT
    Exasol AG

To view more profiles

Join Toptal
Share it with others