Elerey M.

Elerey M.

Barcelona, Spain
Hire Elerey M. Hire Elerey M. Hire Elerey M.

About Me

Elerey is a Senior Data Engineer, Data Architect, and BI Developer with 10+ years of industry experience in database and data warehouse design, OLAP Cubes, SQL/T-SQL, data engineering, ETL, SSIS, and report/dashboard development. His current focus is on lakehouse architecture, Databricks, PySpark, Massively Parallel Processing, data architecture, and analytics. Elerey translates business requirements into meaningful solutions, supporting the data needs of multiple teams, systems, and products.

AI, ML & LLM

Neural Networks

Frontend

JavaScript

Backend

Python ASP.NET ASP.NET MVC

Database

SQL T-SQL MSSQL Server Azure SQL Database Database Administration Database Architecture SQL Server Integration Services

DevOps

AWS AWS RDS Azure Services

Other

Data Engineering Business Intelligence MDX SSAS MS SSIS SSRS Kimball Methodology ETL PowerBI Tableau C# .NET OOP Axure Agile software development Data Warehouse Kentico CMS Keras Tensorflow OLAP Web Development Web Services

Work history

UpStack
UpStack
Senior Data Engineer
2021 - Present (4 years)
Remote

  • Building and improving databases, acquiring data, ETL/ELT, Big Data pipelines, and deploying cloud services on projects.

  • Administering infrastructure solutions to improve data models, increase data accessibility, and foster data-driven solutions for clients.

  • Implementing monitoring solutions to ensure data integrity and working closely with engineers, product managers, and other stakeholders.

SQLT-SQLMDXMSSQL ServerSSASMS SSISETLPowerBIBusiness IntelligenceData EngineeringAWSTableauData Warehouse
Plain Concepts
Plain Concepts
Senior Data Engineer
2022 - Present (3 years)
Remote

Working on data platforms, including Sidra, a data lake platform built on Azure PaaS.

Databricks SparkAzure Data FactoryDevOpsSQLPythonETLPower BI PysparkT-SQL (Transact-SQL) SQL Server Analysis Services (SSAS) Azure Data Lake Azure DatabricksData WarehouseSpark Streaming SnowflakeDBTScalaApache Airflow Data EngineeringData ArchitectureAzure PaaS Azure Data Lake
GrandVision Spain
GrandVision Spain
BI/Data Architect
2021 - 2021
Barcelona, Spain

  • Created data-driven solutions for the marketing, sales, finance, and product departments.

  • Managed in-house and vendor-driven data solutions including data warehouses, tabular models, and Power BI dashboards.

  • Built Machine Learning models and predictive analytics solutions for sales and marketing.

Data ArchitectureBusiness Intelligence (BI) Power BI Data Warehousing Machine LearningPredictive AnalyticsETLT-SQL (Transact-SQL) PythonPandasAzure Data Lake Microsoft AzureGoogle BigQuery Azure Data Factory
T4G Limited (now MNP)
T4G Limited (now MNP)
Data Analytics Engineer | Senior BI Developer
2012 - 2020 (8 years)
Toronto, ON, Canada

  • Created BI solutions, designing SQL-based frameworks, OLAP Cube models, and end-user reports using the Microsoft BI Stack (SSAS, SSIS, SSRS, MDX).

  • Designed and developed relational data warehouses, ETL, multidimensional OLAP Cubes, automated reporting, and complex SQL and MDX queries.

  • Created practical AI-infused custom analytics and intelligent applications.

Data EngineeringBusiness IntelligenceETLData WarehouseMS SSISOLAPSQLT-SQLMDXSSASSSRSPythonPowerBITableauOOPAWSData Analytics SQL BI Development Studio
T4G Limited (now MNP)
T4G Limited (now MNP)
Software Developer
2007 - 2011 (4 years)
Toronto, ON, Canada

  • Designed and developed software applications and technology solutions using the most current industry tools and processes.

  • Developed an energy management and conservation system for individual and industrial consumers in the province of Ontario.

  • Led projects and mentored junior developers.

Web DevelopmentJavaScriptC#.NETASP.NETAgile software developmentKentico CMSSQLT-SQLDatabase AdministrationDatabase Architecture
Catholic Principals' Council of Ontario (CPCO)
Catholic Principals' Council of Ontario (CPCO)
IT Manager
2002 - 2006 (4 years)
Toronto, ON, Canada

  • Managed the IT infrastructure including a database server and web servers, responsible for the organization's IT needs.

  • Designed and developed custom web-based learning management systems.

  • Managed and coordinated IT projects with government partners.

SQLT-SQLMSSQLC#JavaScriptASP.NET.NETDatabase AdministrationIT Management Web Servers Learning Management Systems (LMS) IT Projects IT Infrastructure

Showcase

Data Engineer - Internal System Upgrade
Data Engineer - Internal System Upgrade

  • Provided technical assistance for a major internal system upgrade.

  • Managed and updated the entire SQL Server BI suite, including SQL, SSIS, SSAS, and SSRS.

  • Coordinated with global data sources and a parent company during the upgrade.

Senior Developer | Team Lead - Energy Management and Conservation System
Senior Developer | Team Lead - Energy Management and Conservation System

  • Developed a state-of-the-art Energy Management and Conservation System for Ontario's energy distribution companies.

  • The system comprises three core components: an ASP.NET application, a .NET Middleware, and an xRM application utilizing Dynamics CRM.

  • The system serves individual and industrial consumers across the province of Ontario.

Data Engineer - Data Warehouses and OLAP Cubes for eCommerce
Data Engineer - Data Warehouses and OLAP Cubes for eCommerce

  • Developed and deployed Data Warehouses and OLAP Cubes for a major North American Retailer with over 1000 stores.

  • Implemented a comprehensive reporting infrastructure across the organization using SQL Server BI suite (SQL, SSIS, SSAS, SSRS).

  • The project utilized the entire SQL Server BI suite for data warehousing and analysis.

Education

Convolutional Neural Networks || Deep Learning Specialization || Sequence Models || Improving Deep Neural Networks: Hyperparameter Tuning, Regularization and Optimization || Neural Networks and Deep Learning || Structuring Machine Learning Projects
Convolutional Neural Networks || Deep Learning Specialization || Sequence Models || Improving Deep Neural Networks: Hyperparameter Tuning, Regularization and Optimization || Neural Networks and Deep Learning || Structuring Machine Learning Projects
Coursera
2020 - 2020
BSc Computer Science & Engineering
BSc Computer Science & Engineering
University of Victoria (UVic) - Canada
1999 - 2002 (3 years)