Johnnie Tran - Senior Database Administrator

Experienced as Senior Data Engineer,Database Administrator, Database Developer with 17+ years' experience in Software Development. Senior Database Developer with 10+ years of experience in building data intensive application, extensive with modifying databases, solving issues and ensuring standards are properly met. Senior BI Developer with 3+ years of experience in building complex dashboards using SSRS/SAP BO/Sisense in the insurance industry and betting.5+ years of experience in database design included on-premise and Microsoft Azure Cloud service. Experience working with Git/ Github in delivery system.

Project list

KSA DataOps - Vietnam

Logistic data for the government system.

- Defining users and enabling data distribution to right user, in appropriate format and in a timely manner - Monitor database performance, implement changes and apply new patches and versions when required - Configuring server and databases

Technologies: Jenkins, Git, Docker, CloudFormation, Microsoft SQL Server

NCR Data Integrated

Integrated & Converted ERP reporting system into cloud.

- Build ETL on Informatica Cloud - Build ETL on Apache NIFI - Build Data pipeline on Azure Cloud: Azure data factory, Azure Databrick - Write SQL script for transformation and testing

Technologies: Microsoft SQL Server

Sombo Insurance - Thailand

Build a new Bl system for Thailand Sombo Insurance company by converting legacy system and customizing with new business rules. Provide new data visualization for end users (technical user/management).

- Discussing with onsite team about business rule - Compose data model design - Build ETL to transform data from legacy system into new data center - Build visualization layer - Compose technical document and support QA team to verify data - Setup Develop Environment and Deployment - Manage team and support member in technical issue - Propose technical document such as database model, data flow, SAP BO related documents

Technologies: Microsoft SQL Server, Oracle

ERP Reporting - Switzerland

Customize the existing ERP reporting system to support more features, e.g., financial reports, sale reports.

- Manage database system - Write complex SQL queries to retrieve data for building report system - Support team member in technical issue - Discussing with client to clarify business requirements - Build SSIS pipeline to transform data from legacy system into new data core

Technologies: Microsoft SQL Server

Sales Hub - Switzerland

Build new product (owner) to provide retailed method for FMCG industry.

- Meeting with business analyst team to compose the technical document - Planning the develop schedule, break task and manage team member - Manage database system - Write complex SQL queries, tuning performance to adapt with business requirement - Setup develop environment and deploy - Support QA/QC team to fix bug

Technologies: Microsoft SQL Server, Azure

ERP Migration

Development and maintenance legacy system for new user functional

- Development and maintenance legacy system for new user functional - Manage database system, backup & recover data file - Write SQL queries - Tuning performance - Compose technical document such as database structure, user guide

Technologies: SQL

Licensee Reporting System - Vietnam

Development and maintained legacy system to provide reporting service for betting industry. With over 200 detailed reports, this is a very huge database system and always facing heavy traffic. Licensee system get over 10 million transactions per day need to separate based on business rules for some kind of logic: live transaction, scheduler transaction, follow bet... The reporting system provides the detailed view for manager and dealer then they will have suitable action for managing business.

- Create and implement database design and data models - Coding SQL stored procedure / functions - Build database and table structures - Review code and provide standing coding conventions - Co-op with QA/QC team for fixing bug - Meeting and discussion with BA team to clarify business required

Technologies: Microsoft SQL Server, Git

Accounting Reporting System

Development and maintained existing system. This is the centralize data system, include both credit and deposit transactions over 10 years. The database model need to be a Data warehouse following with star schema.

- Create and implemented database design and data models - Build cube / dimension align with star schema - Build ETL by using SSIS - Coding queries for huge data volume to build stored procedure - Tuning performance - Meeting and discussion with BA team to clarify business required

Technologies: Microsoft SQL Server, Git

Human Resource EzManage v2.0 - Japan

Upgrade EZManage v1.0 to v2.0 by using VB.net framework. Customize to adapt with new business rules and create new reporting system.

- Create and implemented database design and data models - Build new web-form align with business requirement - Set up environment and public application to customer - Write technical document and user guide - Training end user

Technologies: Microsoft SQL Server

Reporting system - Vietnam

Build internal reporting system to support financial / marketing manager to take overview /detailed figures and give the suitable action such as: accounting reports, finance reports, marketing reports.

- Manage and Operate on core banking (TCBS) - Build accounting reports - Queries data from core banking to provide finance reports - Training end-user about core banking

Technologies: Oracle

Project list

Education

Techstacks