Experience

Mr. Bult's, Inc.

• United States
• Truck Transportation
• 100 - 200 Employee

• SQL Developer/ Data Engineering

  • Dec 2021 - Present

  • Designs and develops ETL pipelines to integrate various sources of data, including Excel, Flat Files, MySQL, and REST API sources into MSSQL Server using SQL Server Integration Services (SSIS). • Utilizes critical thinking and creativity in coordination with stakeholders in the development of T-SQL Database Solutions to meet various business requirements. • Creates and maintains reports using SQL Server Reporting Services (SSRS) and PowerBI. • Monitors SQL Server Agent jobs, diagnosing problems and implementing resolutions as needed. • Provides operational support, investigating problems that arise in database solutions and business applications Show less



FPT Americas

• United States
• Information Technology & Services
• 300 - 400 Employee

• Data Engineer/Data Analyst

  • Jun 2021 - Dec 2021

  • Conducted data from customers to build data pipelines per customers’ requirements, designed and implemented dimensional modeling, created database diagrams and data dictionary to provide concise guides for various businesses in accounting, sales, healthcare, and education industries, helping them understand and utilize the data, and increase work efficiency by 80%. • Operated SSIS to set up parameters and variables for dynamic packages to ETL data, wrote script tasks to set up alerts and retry when loading fails, performed SCD to track the history of dimension records, created View/Index/Stored Procedure/Trigger/Data Mask using MS SQL Server and Snowflake to improve the performance of queries, security, privacy, and grant access for proper users, decreasing compute costs by 30% on average for businesses. • Deployed packages on SSIS catalog, created environments, jobs, and schedules to refresh data in Snowflake and automate dashboard updates on PowerBi Service, saving operating costs by 50%. • Utilized Power BI to design data models, performed aggregation with DAX and Python (Pandas, NumPy, Matplotlib, SK learn) to analyze data and answer business problems, creating dashboards to provide meaningful insights for an education institution, improving class quality by 25% by analyzing feedbacks, and helped a healthcare organization enhance diagnostic accuracy based on patients' symptom declaration and demographic characteristics by 30%. Show less



CMC Global Company Limited.

• Vietnam
• IT Services and IT Consulting
• 700 & Above Employee

• Data Analyst and Computer Science

  • Jun 2017 - Sep 2017

  • Conducted survey to gather data of 5000+ customers, imported, cleaned, and analyzed data using SQL to provide analysis of target audience’s behaviors and preferences to help business to tailor new product to meet customers’ demands. • Implemented sentimental analysis using Python to convert unstructured text of customers’ reviews to meaningful business insights and created Tableau dashboards to help Marketing team measure and leverage current products, contributing to a 15% increase in customer retention. • Ran weekly reports in SAS to monitor starts and stops of subscriptions, built churn model in Python to predict stops and actionable insights to help business retain customers, raising the save rate by 25%. • Actively contributed to software development using Android Studio (Java), maintained code quality across multiple mobile software development environments, helped Post Production support and bug fixes and worked closely with designers, artists and other developers to expand and tune our product offering for the mobile arena. Show less



Public Bank

• Malaysia
• Banking
• 700 & Above Employee

• Corporate Investment Banking

  • Jun 2016 - Sep 2016

  • Populated corporate customers satisfaction data in Excel and visualized data in Tableau to understand trends in average satisfaction, the changes among satisfaction levels over time, and the satisfaction rate among different banking services. • Created Tableau dashboards to communicate ideas to assist Marketing department in improving customer satisfaction and optimize product portfolio, contributing to an 8.2% increase in gross profits. • Ran survival model using SAS to predict survivals among various groups of different marketing offers, and calculated revenues generated to help business in decision-making, saving costs and increasing profits by 5%. Show less