Dipl.-Ing. Carlos Heller

Lead migration to a cost-effective ELT approach using Hevo, replacing Matillion, and assist in data migrations; manage Snowflake DWH with cross-region replication and ELT processes. Migrate code base from SQL to dbt core using VSCode and GitLab; collaborate to deploy Data Mesh architecture in Snowflake. Design and maintain Snowflake RBAC structure and perform DBA tasks; integrate AI tools like GitHub Copilot and ChatGPT to enhance productivity.

Redesign and implement new Snowflake DWH following industry best practices, including GitLab project structure; maintain legacy DWH and Matillion ETL on AWS. Support BI Analysts with complex queries, data exploration, view materializations, and data integrations. Define and document team coding processes, naming conventions, data type conversions, and coding styles. Integrate data sources such as Salesforce, MariaDB, Elasticsearch, Zendesk, HubSpot, ChargeBee, Jira, REST API, PostgreSQL, MySQL, and others.

Expand data integrations to enhance internal analytical capabilities with Tableau; maintain high data quality and optimize data warehouse and ELT performance using PostgreSQL scripting and Pentaho PDI jobs.

Managed sensitive financial data migrations using SSIS and SQL, ensuring compliance with business models and FCA regulatory standards. Prepared databases—including schemas, tables, views, stored procedures—for various migration stages in development and production environments. Applied business-specific logic to migrated data to align with client business models and legal, financial regulations. Designed and executed unit and smoke tests to validate the integrity of data models and business logic.

Design, develop and deploy business intelligence platform architecture using Microsoft BI Tools: SQL Server 2012, Visual Studio 2013 (SSIS, SSAS and SSRS), Office 2013 (Excel, PowerPivot and Power View), Report Builder 3.0 and SharePoint 2013 (Excel Services, PerformancePoint Services and Visio Services). Integration services programing using C# sentences and Analysis Services programing with T-SQL for View level querying and MDX for KPIs and conditional formatting for OLAP cubes.

Managed IT department and team, ensured meeting project deadlines, led development projects for production line and information exchange with ERP platform using .Net and SQL Server technologies, negotiated with ICT service providers, handled server and user terminal configurations, trained users in MS Office and proprietary tools.

- Coordinated commercial relations and maintained business operations between Chile, Colombia, California (HQ) and Asia (WH), created business reports for HQ in Taiwan, presented company products to corporate clients, trained their sales teams in Santiago, Bogota, Cali and Medellin. - Inspected and nominated technical service centres in Chile and Colombia to become authorized ASUS service centres, provided commercial and technical support to Latin America customers.

- Researched environmental reading probes and successfully combined them with remote diagnostics control software. - Participated in the design of networking, access/attendance control, CCTV and IT security projects.

Intensive Czech Language course for foreigners at Mendel University.

Integrated Management Systems diploma in ISO 9001:2008, ISO 14001:2004 and OHSAS 18001:2007 with international auditor certification by Applus.

Industrial Electronics, Automated Control (PLC), Telecommunications, Computer Technologies, Network Technologies