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 Analytics Engineer/Senior Business Intelligence
2012 - 2020 (8 years)
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.
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.
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.
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.
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.
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