Emilio Martin

Emilio Martin

$60/hr
Microsoft Data Engineer and Kimball Methodology Architect
Reply rate:
-
Availability:
Hourly ($/hour)
Age:
51 years old
Location:
Cape Town, Western Cape, South Africa
Experience:
24 years
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
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.