Constantine Eliades

 

Business Intelligence Developer,

Data Scientist 

Highly Experienced in Azure Data Factory, Azure functions, python, SQL Server,  Power-Query, Power Pivot, Power BI, ETL - SSIS, SSAS Tabular, Data Warehouse, Devops,  Gitlab, GitHub, Power Apps, Power Automate, etc.

Experience

EPAM

Europe - Remotely

Tech Leader – BI Developer

Responsibilities:
  •  Leading a team of 4 developers working in Data Integration - Azure Functions - Snowflake - Logic Apps - SQL Server

  • Developing in Azure Functions python (Durable Functions, Azure Functions API, Purview, Connectors to Snowflake, PostgreSQL, MSSQL)

Experience:
  • SQL Server
  • Snowflake
  • Azure Functions
  • Data Factory
  • Azure Devops
  • Logic Apps
  • Python

IQVIA

Europe - Remotely

Tech Leader – BI Developer

Responsibilities:
  •  Leading a team of 4 developers working in ETL Informatica and Python scripts with Jira and Oracle Database.

  • Developing in Reltio (MDM application-Web-Rest API)

  • Developing in Power BI and VBA Excel with Power Pivot tables, Power Query and DAX Language a connection with Reltio API

  • Power BI connection with Reltio API with M Language.

  • Developed CI/CD Pipelines in Gitlab deploying with Python Scripts json files to Reltio API.

     

Experience:
  • SQL Server
  • Snowflake Certified
  • Reltio Certified
  • Power Automate
  • Gitlab
  • Power Query - Power BI - DAX - M
  • Python
  • Jira


Asos.com - Adatis 

UK - Remotely

UK London Working remotely for asos.com – BI Developer 

Responsibilities:
  • ·         Implementing Data Unit Tests with Visual Studio c# Specflow.

  • ·         Working with Visual Studio 2019 – Devops – Github.

  • Developing T-SQL Stored procedures in Azure SQL Databases
  • ·        Developing Pipelines in Azure Data Factory.

  •       Developing in Azure Analysis Services and Power BI

Experience:
  • Azure Data Factory
  • T-SQL Stored Procedures in Azure SQL Databases
  • Kusto Query Language - Azure Alerts
  • Devops 


Accenture

Greece Athens

Team Leader – Senior Developer

Responsibilities:
  • ·         Design DW (Data Vault) from raw data in visual paradigm

  • ·        Implementing ETL (Pipeline Dataflows) with Azure Data Factory.

  • ·         Developed in C# Azure Function, type blob trigger converting excel files to csv.

  • ·        Working with Visual Studio 2019 and DevOps.

  •       SQL developing in Azure Synapse Datawarehouse.

     

Experience:
  • Azure Data Factory
  • T-SQL Stored Procedures in Azure SQL Databases
  • Azure Functions 


TCS

USA Chicago

Team Leader – Senior Developer

Responsibilities:
  • ·       Optimize Production Cube on an SSAS Multidimensional Model,

     

  • ·       Setup-Developed PowerPivot on SharePoint and PowerPivot on Excel

     

  • ·       Optimize SSIS ETL processes for Datawarehouse

  • ·       Optimize code in MDX Language

     

  •      Optimize VBA Excel Code and CUBEVALUE functions

     

     

  •       Developing Power BI Reports

Experience:
  • SSAS
  • Power BI
  • ETL - SSIS - Power Pivot - SSAS Tabular


Heitman

USA Chicago

ETL SSIS, Power BI, SQL Developer, C# and Script Developer

Responsibilities:
  • ·        Upgrading SSIS Packages written in VB.Net and being on SQL Server 2005 and converted to C# and transferred to SQL Server 2016.

     

  • ·        I developing, upgrading, optimizing performance, refactoring stored procedures, SQL queries, tables and views.(Data cleansing) Developed stored procedure cleaning all the wrong values from Excel and csv files to be imported to SQL server tables.

  •           Developing Powershell scripts for connecting to SFTP, FTP, auto download and upload csv and ascii files.

     

  • ·        I was maintaining Excel files replacing VBA code and connections with SQL Server and Pivot tables.

     

  • ·        Developing SSAS Cube and Power BI Reports.

     

  •       Connect with Active Directory and get sync All data utilizing SSIS Package.

     

     

Experience:
  • SSAS, SSRS,ETL, SSIS, Cozyroc
  • SQL Server - T-SQL
  • Powershell


Cook County, Government of USA 

Chicago

Team Leader – Senior Developer

Responsibilities:
  • ·        Enhanced index and defragment on Query speed for all property taxes queries, driving efficiency.

     

  • ·        Repaired and maintained SQL Server clusters across organization.

     

     

  • ·        Developed custom script in SQL Server syncing 3 SQL Databases with LAN Active Directory.

     

  • ·        Developed application SQL SSIS and Vb.Script that daily notifies the managers of any unclosed cashier system.  

     

     

  •       Setup Document Management Application (Onbase) in SQL Server 2008,2012,2014, 2016 with Stored Procedures and SSIS.

Experience:
  • SQL T-SQL Stored Procedures optimization
  • SSIS
  • VB.Script
  • VBA
  • Onbase

Education

  • undefined30.06.2014USA

    Equivalency Master Degree
  • undefined25.06.2013University in Patra

    Bachelor's Degree in Computer Science
  • undefined28.06.1997University in Thessaloniki

    Bachelor's Degree in Business Administration and Economics.

Certifications

  • Snowflake

  • Reltio

  • Azure Fundamentals

  • Microsoft Certified Professional

  • SQL Server Certified

  • Onbase API Certified

    Memberships

    • Member of PMI

    • Member of ACM

      Additional Courses

      • Project Management

      • Corporate Social Responsibility and Decision making