EMILIO
MARTIN
SENIOR DATA ENGINEER AND ANALYST. KIMBALL METHODOLOGY ENTHUSIAST
CONTACT--LinkedIn
Remote or hybrid (Cape Town)
PROFILE
A well seasoned Data Professional with over 20 years experience. My passion is
deriving business insight from multiple data sources into information that drives
meaningful knowledge to make informed and actionable operational and strategic
decisions.
Recently was privileged to be involved in Project Horizon at Coca-Cola Beverages
Africa. A complete ERP change to Microsoft Dynamix 365 Finance and Operations as
well as D365 Customer Engagement.
I was involved in processing data across all functions using Kimball Methodology.
Here are some some of the Automated Solutions Developed as Initiatives that I am
particularly proud of. Kimball Methodolgy is not just Datawarehouse Fact and
Dimension Design, its making sure that all the subsystems are in place and are easy
to use:
•
•
•
•
•
•
•
SQL Data Lineage from Sources to Target Facts and Dimensions
o Kimball - Subsystem 29: Lineage and Dependency Analyzer
Metadata Driven Incremental Process of staging data from Serverless SQL
Pool to Dedicated Pool
o Subsystem 2: Change Data Capture System
o Subsystem 30: Problem Escalation System
Late- Arriving Dimension Identification and rectification
o Subsystem 16: Late Arriving Data Handler
Data Duplication Detection
o Subsystem 7: Deduplication System
Data-Profiling of Tables
o Subsystem 1: Data Profiling
Incremental Fact Load Pattern Design
o Subsystem 13: Fact Table Builders
Detailed SQL Stored Procedure Performance Monitoring without extra
overhead tapping into sql performance system data
o Subsystem 27: Workflow Monitor
I particularly enjoy generating Cost Savings through query optimisation
SKILLS
EXPERIENCE
◦
SQL / T-SQL / PL-SQL
Altron Karabina / Altron Digital Business
◦
AZURE DATA FACTORY
Coca Cola Beverages Africa – Project Horizon
◦
AZURE SYNAPSE
Senior Specialist Data Engineer-
◦
ETL AND PIPELINES
Microsoft Azure
◦
C#
•
Kimball Data Warehouse Design
•
Synapse
CURRENT
UPSKILLING
◦
PYTHON
◦
PANDAS
◦
DATABRICKS
Gillian De Klerk
“Emilio is one of those Data Engineers that
solves problems creatively, efficiently and
accurately. He has an extremely high level
of technical ability always staying abreast
of the latest trends by researching and
applying practically. He mentors and
supports team members, communicates
effectively with clients and always succeed
at projects.
I can highly recommend Emilio as a Senior
Data Engineer.”
Christo Oertel
“What a joy to have worked with this
individual over the past two years. Emilio
always handles every opportunity or
challenge with utter professionalism, an
inquisitive mind and an eagerness that I
have seen in very little people I have
worked with over the years. He is an asset
to any company or project and I would
highly recommend him.”
Jean-Pierre Voogt
“Emilio is one of the most upbeat mentors
I had in my life, always in problem solving
mode. His professionalism towards clients
is something everyone should aspire
towards.
Emilio pushed me harder that what I
thought I could do and contributed to me
being a well rounded consultant. His
passion for his work and helping others
really inspired me to be better.”
Spark Notebooks
o
Pipelines
o
Dataflows
•
Serverless SQL Pool
•
Dedicated SQL Pool
•
Data Factory
Some Automated Solutions Developed as Initiative:
•
RECOMMENDATIONS
o
SQL Data Lineage from Sources to Target Facts and Dimensions
•
Metadata Driven Incremental Process of staging data from Serverless SQL
Pool to Dedicated
•
Late- Arriving Dimension Identification and rectification.
•
Data Duplication Detection
•
Data-Profiling of tables
Mine Tech Services (MTS)
Data and Software Engineer-
Equipment Health, Fleet Maintenance, Productivity and Geospatial data analysis,
extraction and reporting
SAP Business Objects (4.1, 4.2)
•
BI Platform Administration
•
Information Design Tool (Universes)
•
Web Intelligence
•
Explorer
•
Dashboards
Microsoft
•
Data warehousing
•
SQL Server Integration Services
•
Windows Communication Foundation
•
ASP.net
I have been involved in the world of extracting, analyzing and conforming data from
some the world’s top Open-Pit Mining Fleet and Health systems. These include
MineStar by Caterpillar, Jigsaw by Hexagon and Modular by Komatsu.
Having visited multiple mining operations around the world including
•
•
•
•
•
Australia (Newmont Boddington - Gold),
USA (Newmont, Barrick, Nevada Goldmines Carlin, Long Canyon - Gold)
Mexico (Newmont Peñasquito - Gold)
Zambia (FQM Kansanshi - Copper)
Russia (Phosagro Apatit – Phosphate)
PBT Group
Ncedo Geza
BI Consultant
“It was a great privilege to work with a
highly skilled and meticulous problem
solver such as Emilio. During the time we
worked together I noted, in particular, his
interest for people development, excellent
client-facing capabilities and in-depth
knowledge of various tools. He is eager to
impart this knowledge to anyone who pays
enough attention and is a leader at heart.
-
First Quantum Mineral Ltd
SAP Business Objects
•
•
•
•
•
Data Services
Information Design Tool (Universes)
Web Intelligence
Explorer
Dashboards
Any organisation or team would benefit
immensely from having Emilio. His skill set
is flawless.”
EDUCATION
Santam
SAP Business Objects
•
•
•
•
•
Information Design Tool (Universes)
Web Intelligence
Sybase IQ
Data warehouse design
ETL
PepkorIT
MCSA: SQL 2016 Database
Development
MICROSOFT
2016
SAP Business Intelligence Platform
4.1
•
•
•
•
•
•
SAP Business Objects Administrator
SAP Business Objects SDK
Information Design Tool (Universes)
Web Intelligence
Explorer
Oracle PL/SQL development of ETL procedures
SAP
2016
Asyst Intelligence
Microsoft Certified Technology
Specialist (MCTS): Business
Intelligence
Development and Maintenance
-
Business Intelligence Team Leader / Principal Consultant
Department of Public Enterprises
•
MICROSOFT
2010
•
BSC: Information Systems (IT
Management Stream)
UNISA-
This stream was unfortunately
discontinued. 29 out of 30 modules
completed. Transcript available.
Microsoft Certified Technology
Specialist (MCTS): SQL Server
2008, Database Development
Monitoring and Evaluation Dashboard and data capture web application
development using Visual Studio 2005/2008/2010, C#, SQL Server,
Xcelsius and Business Objects for reporting to National Treasury and The
Presidency
Business Areas:
o Corporate Governance – Board Performance
o Risk
o Financials
o CAPEX projects – Monitor the infrastructure build programme
o Skills Development
o BBBEE
o Government Guarantees
o Corporate Plan
o Strategic and Operation KPIs
Anglo American
•
Developed a supply chain intranet application using Visual Studio 2005,
C#, SQL Server and Reporting Services
MICROSOFT
2009
Business Objects and Crystal Reports Trainer
Microsoft Certified Solution
Developer
Growthpoint Properties
Hatfield Business College /
MICROSOFT
2001
Diploma in Business Management
and Administration
Varsity College
SharePoint 2007 (MOSS) intranet implementation
This included the customisation of the Master Pages and stylesheets, integrated
business intelligence using KPI’s , SQL Server Reporting Services Reports, SSIS live
share price imports.
Data Warehouse Design and ETL Development
Designed and developed the ETL processes to load financial and other data from
the source business system into a dimensional data warehouse (Kimball
methodology) using SQL Server 2005 and SSIS
1992
Fugro Airborne Surveys
•
Development of a data warehouse using SQL Server 2005, SQL Server
Integration Services and SQL Server Analysis Services. Performance
Dashboards were provided using Microsoft Office Business Scorecard
Manager SQL Server Reporting Services. The dashboards were hosted in
Sharepoint Portal Server 2007
•
•
Document libraries were set-up with Approval routing, auditing and
version control to conform to ISO requirements using Sharepoint Portal
Server 2007.
Data management functionality was provided by embedding forms into
Sharepoint using Sharepoint Designer 2007.
Pieman’s Pantry
•
Development of a data warehouse using SQL Server 2005, SQL Server
Integration Services and SQL Server Analysis Services.
Rand Merchant Bank
•
•
Private Bank Portfolio Reports using Crystal Reports
JSE regulator STRATE export reports using SQL Server DTS