Elerey M.

Elerey M.

Senior Data Engineer

Spain
Hire Elerey M. Hire Elerey M. Hire Elerey M.

About Me

Elerey is a Senior Data Engineer and Business Intelligence Engineer with over 10 years of industry experience. He has extensive expertise in Database and Data Warehouse design, OLAP Cubes, SQL/T-SQL, Data Engineering, ETL, SSIS, and Report/Dashboard development including an innate ability to understand business requirements and translate them into meaningful solutions. Elerey is self-directed and comfortable supporting the data needs of multiple teams, systems, and products.

Data Engineering 9 years Business Intelligence 9 years SQL 18 years T-SQL 18 years MDX 8 years MSSQL Server 18 years SSAS 8 years MS SSIS 8 years SSRS 8 years Kimball Methodology 8 years ETL 8 years PowerBI 4 years Tableau 2 years C# 15 years JavaScript 15 years Python 3 years ASP.NET 16 years .NET 16 years ASP.NET MVC 5 years OOP 18 years Axure 4 years AWS 4 years AWS RDS 3 years Agile software development 13 years Azure SQL Database 5 years Azure Services 3 years Data Warehouse 8 years Database Administration 18 years Database Architecture 18 years Kentico CMS 5 years Keras 1 year Tensorflow 1 year Neural Networks 1 year OLAP 8 years SQL Server Integration Services 8 years Web Development 10 years Web Services 5 years

Portfolio

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

Designed and developed Data Warehouses and OLAP Cubes for Ecommerce and Merchandising for a major North American Retailer with over 1000 stores. This included an extensive reporting infrastructure that was widely distributed throughout the organization with C-Level visibility. The entire SQL Server BI suite was used for the implementation: SQL, SSIS, SSAS, and SSRS.

Data Engineer - Internal system upgrade
Data Engineer - Internal system upgrade

Advised and provided technical assistance to a high-end North American retailer in a major internal system upgrade. This included changes and updates that spanned throughout their entire business intelligence infrastructure including coordination with global data sources and parent company. The entire SQL Server BI suite was used for the implementation: SQL, SSIS, SSAS, and SSRS including other industry-specific BI and planning software.

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

Acted as a senior developer and team lead in the development of a state-of-the-art Energy Management and Conservation System that is used by individual and industrial consumers in the province of Ontario including all the energy distribution companies of the province. The system consists of three main components: an ASP.NET application, a .NET Middleware, and an xRM application using Dynamics CRM.

Work history

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

  • Delivers data warehouse and ETL solutions as part of an agile team using advanced machine learning techniques to improve performance and processes.

  • Helps build and improve infrastructure, application and performance development and ensures tight security including data encryption, security groups, and environment scanning.

  • Ensures high-quality deliverables and implements DevOps and security best practices in fast-paced environments.

SQLT-SQLMDXMSSQL ServerSSASMS SSISETLPowerBIBusiness IntelligenceData EngineeringAWSTableauData Warehouse
T4G Limited
T4G Limited
Data Analytics Engineer/Senior Business Intelligence
2012 - 2020 (8 years)
Canada

  • Acted as Data Analytics Engineer and Senior Business Intelligence for a full-service Applied Data Company, helping help organizations collect,organize, and apply data to drive growth, operate efficiently, and engage with stakeholders.

  • Assisted clients in creating Business Intelligence and Analytics solutions including designing and creating Relational Data Warehouses, ETL, SSIS, MultidimensionalOLAP Cubes, automated reporting, and complex SQL and MDX queries.

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

Data EngineeringBusiness IntelligenceETLData WarehouseMS SSISOLAPSQLT-SQLMDXSSASSSRSPythonPowerBITableauOOPAWS
T4G Limited
T4G Limited
Senior Software Engineer
2007 - 2012 (5 years)
Canada

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

  • Acted as a senior developer and team lead in the development of a state-of-the-art Energy Management and Conservation System that is used by individual and industrial consumers in the province of Ontario .

  • Led multiple projects and provided mentorship to junior developers.

Web DevelopmentJavaScriptC#.NETASP.NETAgile software developmentKentico CMSSQLT-SQLDatabase AdministrationDatabase Architecture
The Catholic Principals’ Council of Ontario
The Catholic Principals’ Council of Ontario
Software Developer / IT Manager
2004 - 2007 (3 years)
Canada

  • Acted as Software developer and IT Manager for the leading provider of professional development to Ontario’s Catholic principals and vice-principals.

  • Designed and developed custom web-based learning management systems. Managed the IT infrastructure including database server and web servers.

  • Managed and coordinated IT projects with government partners.

SQLT-SQLMSSQLC#JavaScriptASP.NET.NETDatabase AdministrationDatabase Architecture

Education

B.Sc., Computer Science/Software Engineering
B.Sc., Computer Science/Software Engineering
University of Victoria
1999 - 2002 (3 years)
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
Courses