Leo Tran - Senior Data Engineer

Leo Tran

4.8

Select me!

Leo is available for hire

Hire Now

Leo Tran

4.8

Gender

Male

Main expertise

Data Database Database Administrators ETL Azure SQL Data Migration Data Warehouse Big Data Architects Data Analysts Data Visualization Data Scientists

Introduction

Leo Tran is an experienced Senior Data Engineer and Database Developer with over 10 years of expertise in Software Development.

Project list

Sombo Insurance Data Integration Project - Thailand

Developed a new Business Intelligence (BI) system for Sombo Insurance Company in Thailand by transforming the legacy system and implementing new business rules. Provided advanced data visualizations for end users, including technical staff and management.

Discussed business rules with the onsite team. Composed data model design. Built ETL processes to transform data from the legacy system into the new data center. Authored technical documents and supported the QA team in data verification. Built the visualization layer. Developed the environment and managed deployment. Managed the team and supported members with technical issues. Proposed technical documentation, such as database models, data flows, and SAP BO-related documents.

Technologies: DB2, MSSQL, SAP Business Objects, Visio

MetLife Bangladesh Insurance Data Migration - Bangladesh

Developed a data movement strategy to transition client data to the new Integral Life Insurance system using T-SQL and Bash. Engaged directly with the client to create mapping documents, design approaches, and construct scripting templates.

Discussed business rules with the onsite team and client. Composed mapping documents based on business rules between legacy and new systems. Deeply involved in data cleansing, reconciliation, transformation, and extract-translate processes. Managed a data migration team of approximately 10 members. Optimized performance and troubleshot technical issues.

Technologies: DB2, MSSQL, T-SQL, Batchshell, Visio

NCR Data Integration

Migrated and integrated the ERP reporting system into a cloud-based solution.

Build ETL processes using Informatica Cloud. Build ETL processes using Apache NIFI. Develop data pipelines on Azure Cloud utilizing Azure Data Factory and Azure Databricks. Write SQL scripts for data transformation and testing.

Technologies: Apache NIFI, Informatica Cloud, Azure Data Factory, SQL Server

Swiss ERP Reporting Enhancement - Switzerland

Enhanced and customized the existing ERP reporting system to support additional features such as financial and sales reports.

Manage the database system Write complex SQL queries to retrieve data for the reporting system Support team members with technical issues Discuss with clients to clarify business requirements Build SSIS pipelines to transform data from legacy systems into the new data core

Technologies: SSIS, SSRS, SSAS

Sales Hub

Developing a new platform tailored for the FMCG industry to offer innovative retail methods.

Meeting with the business analyst team to compose the technical document. Planning the development schedule, breaking down tasks, and managing team members. Managing the database system. Writing complex SQL queries and tuning performance to meet business requirements. Setting up the development environment and deploying. Supporting the QA/QC team in bug fixing.

Technologies: MSSQL, Azure Datafactory, Databrick

ERP System Migration

Responsible for the development and maintenance of legacy systems, ensuring that new user functionalities are seamlessly integrated.

Manage database system, backup, and recovery of data files. Write complex SQL queries for data manipulation and retrieval. Optimize database performance for speed and efficiency. Compose technical documentation including database structure and user guides.

Technologies: SQL

Licensee Reporting System

Developed and maintained a legacy system to provide reporting services for the betting industry. With over 200 detailed reports, this is a very large database system that often faces heavy traffic. The licensee system processes over 10 million transactions per day and categorizes them based on business rules for different types of logic such as live transactions, scheduled transactions, and follow bets. The reporting system provides detailed views for managers and dealers, allowing them to take appropriate actions to manage the business effectively.

Create and implement database designs and data models. Coding SQL stored procedures and functions. Build database and table structures. Review code and establish standardized coding conventions. Collaborate with the QA/QC team to fix bugs. Meet and discuss with the BA team to clarify business requirements.

Technologies: MSSQL, Git, TFS, Visio, T-SQL

Accounting and Reporting System

Development and maintenance of an existing system that serves as the centralized data repository, encompassing both credit and deposit transactions spanning over 10 years. The database model is structured as a Data Warehouse utilizing a star schema.

Create and implement database design and data models. Build cubes and dimensions in alignment with the star schema. Develop ETL processes using SSIS. Write queries for handling large volumes of data to construct stored procedures. Perform performance tuning. Engage in meetings and discussions with the BA team to clarify business requirements.

Technologies: SSIS, SSAS, Git, SVN, T-SQL

Human Resource EzManage 2.0

Enhanced the EZManage system from version 1.0 to 2.0 using the VB.net framework. Customizations were made to accommodate new business rules, and a new reporting system was developed.

Create and implement database design and data models Build new web forms aligned with business requirements Set up the environment and deploy the application to customers Write technical documents and user guides Train end-users

Technologies: SQL server 2008, VB.net framework, SVN

Internal Reporting System

Developed an internal reporting system to assist financial and marketing managers in obtaining both overview and detailed figures. This system supports in making informed decisions through the provision of various reports, such as accounting, finance, and marketing reports.

Manage and operate on core banking (TCBS). Build accounting reports. Query data from core banking to provide finance reports. Train end-users on core banking systems.

Technologies: Oracle 10g, PL/SQL, Visual FoxPro, VB6

Project list

Education

Expertise