Open to opportunities

Hilzon Lanin

@hilzonlanin

Message

Results-driven Data Engineer with over 9 years of experience.

Indonesia

Message

What I'm looking for

I am looking for a role that challenges my skills and offers opportunities for growth in data engineering.

I am a results-driven Data Engineer with over 9 years of experience in data integration and database management. My expertise lies in designing, developing, and maintaining ETL processes using the latest technologies to ensure efficient data extraction, transformation, and loading. I possess strong SQL skills and a solid understanding of data modeling principles, which enable me to tackle complex technical challenges effectively.

Throughout my career, I have successfully developed Azure pipelines for seamless data ingestion, optimized dynamic stored procedures for enhanced data processing, and implemented automated reporting systems that streamline decision-making. My experience spans various industries, where I have collaborated with stakeholders to define strategic KPIs and build analytical models that support data-driven initiatives.

I am passionate about problem-solving and excel at communicating complex technical concepts to diverse audiences. I continuously seek opportunities to leverage my skills in data engineering to drive impactful results and contribute to organizational success.

Experience

Work history, roles, and key accomplishments

Current

Data Engineer

Current

Business for Good, LLC

Jan 2023 - Aug 2023 (7 months)

Developed Azure pipelines for data integration from API endpoints into Azure SQL, enhancing automated data ingestion. Optimized stored procedures for JSON data parsing and integrated Azure Storage with Event Grid for streamlined workflows.

Azure SQL Azure Data Factory JSON ETL SQL Data Modeling Next.js

Reporting System Developer

Retriver D.O.O.

Jan 2022 - Jan 2023 (1 year)

Implemented ETL processes to transform raw data and generate dashboards for reporting. Automated reporting systems using Python and Google Big Query, enhancing data visualization and decision-making.

ETL Python Big Query)VBA Dashboard Development Data Visualization Report Automation

Data Engineer

PT. Easypay Payment System

Jan 2018 - Jan 2019 (11 months)

Designed server-side components for data applications and developed ETL pipelines using SQL Server and PostgreSQL. Collaborated with stakeholders to define KPIs and implemented analytical models.

SQL Server PostgreSQL ETL SSIS Data Warehousing API Development KPIs

Data Analyst

The Hongkong & Shanghai Banking Corporation Ltd.

Jan 2016 - Jan 2017 (1 year)

Developed a SQL-based data warehouse to centralize analytics and automated reporting processes for compliance and financial analysis, enhancing efficiency and accuracy.

SQL Data Warehousing VBA Compliance Customer Segmentation Financial Analysis

Data Engineer

PT. Bank Mega, Tbk

Jan 2013 - Jan 2014 (1 year)

Designed a KPI tracking system and integrated AS400/DB2 with MS SQL Server. Developed automated notifications for executive updates on transactions.

KPI Tracking AS 400 MS SQL Server Data Integration Data Pipelines

Education

Degrees, certifications, and relevant coursework

Business for Good, LLC

Data Engineering

2023 - 2023

Developed Azure pipelines to integrate data from API endpoints into Azure SQL, enabling seamless and automated data ingestion. Designed and optimized dynamic stored procedures for parsing JSON data into SQL tables, enhancing data transformation and processing efficiency. Integrated Azure Storage Blob Container with Azure Event Grid to automate data detection and processing and streamline workflows

Retriver D.O.O.

Reporting System Development

2022 - 2022

Developed and implemented ETL processes to transform raw data, aggregate information, and generate insightful dashboards for reporting and analysis. Designed and automated reporting systems using Python, Google Big Query and Google Looker to streamline data visualization and decision-making. Created dynamic dashboards and automated report generation in PDF format using VBA for seamless distributio

PT. Easypay Payment System

Data Engineering

2018 - 2018

Designed and maintained server-side components for data-intensive applications, ensuring seamless API communication with front-end systems. Developed and optimized database schemas, improving query performance and data integrity. Developed ETL pipelines using SQL Server, PostgreSQL, MySQL, and SSIS to integrate business systems and external data sources into a centralized data warehouse. Built aut

The Hongkong & Shanghai Banking Corporation Ltd.

Data Analysis

2016 - 2016

Developed a SQL-based data warehouse to centralize analytics, reducing reporting time and improving data accuracy. Designed and implemented an online data monitoring tool to track sales performance and goal attainment using VBA. Automated reporting processes for compliance, customer segmentation, and financial analysis, enhancing efficiency and accuracy. Optimized database queries and indexing str

PT. Bank Mega, Tbk

Data Engineering

2013 - 2013

Designed a KPI tracking system to measure sales team performance, branch efficiency, and portfolio growth. Integrated AS400/DB2 and Oracle databases into MS SQL Server, streamlining operational reporting. Developed an automated daily notification system using SMS gateway for executive updates on high-value transactions. Built data pipelines and reporting solutions using Pentaho Data Integration to