Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

Dillion Liu

Adelaide,SA

Summary

Logical data analyst skilled in requirement analysis, software development and database management. Self-directed and proactive professional with several years of vast experience collecting, cleaning and interpreting data sets. Natural problem-solver possessing strong cross-functional understanding of information technology and business processes.

Overview

5
5
years of professional experience

Work History

Data Analyst

Qipu Technology
Jilin, China
10.2023 - 02.2024
  • Conducted Exploratory Data Analysis (EDA) using Python with Pandas, Matplotlib, and Seaborn to analyze vehicle production and sales data. Key insights helped improve the accuracy of production forecasting by 20%, leading to better alignment between inventory levels and market demand, which reduced overstocking costs and boosted overall efficiency by 15%.
  • Designed interactive Power BI dashboards that transformed complex manufacturing data into clear visual insights. These dashboards allowed stakeholders to monitor production timelines, identify bottlenecks, and track key performance metrics, leading to a 25% improvement in operational decision-making and a 10% increase in production line efficiency.

Database Analyst

Everbright bank
Jilin, China
08.2019 - 10.2021
  • Managing Databases: Maintain and optimize SQL Server and Oracle databases to ensure fast, reliable performance for banking applications. This includes tuning queries, managing indexes, and performing regular backups.
  • Ensuring Data Security: Protect sensitive customer information by setting up access controls, encryption, and following regulatory guidelines. This helps keep data safe and compliant with rules.
  • Data Analysis and Reporting: Write SQL queries to pull data for reports, helping teams understand trends like customer behavior and transaction patterns. Use tools like Power BI to create easy-to-understand dashboards.
  • Data Integration: Set up processes to move and sync data between different banking systems using tools like SSIS, making sure data stays consistent.
  • Disaster Recovery: Plan and maintain backup strategies and recovery plans to keep data safe and ensure quick recovery if something goes wrong.
  • Troubleshooting: Solve database issues like slow queries or connection problems to keep everything running smoothly for the bank.

Front-End Developer

Chongqing software
Chongqing, China
11.2018 - 05.2019
  • Developing Responsive Web Applications: Build dynamic and user-friendly web applications using HTML5, CSS3, JavaScript, and frameworks like Bootstrap, ensuring the best possible user experience across devices.
  • Front-End and Back-End Integration: Work closely with PHP-based back-end services to ensure smooth data interaction between the server and front-end components, creating a seamless experience for users.
  • Collaborating with Designers: Translate wireframes and prototypes from the design team into fully functional web pages and applications, ensuring that the final product aligns with design specifications and user needs.
  • Optimizing Performance: Focus on optimizing applications for speed and scalability, ensuring that they perform well across different devices and browsers.
  • Troubleshooting and Debugging: Identify and resolve cross-browser compatibility issues and front-end performance problems to maintain a consistent user experience.
  • Collaboration and Continuous Improvement: Work alongside back-end developers to implement APIs and dynamic content, and stay up-to-date with new front-end trends and technologies to continuously improve the development process.

Education

Master of Science - Data science

University of Adelaide
Adelaide, SA
10-2023

Bachelor of Science - Computer Science and Technology

Guizhou University
Guizhou, China
07.2018

Skills

  • Process Improvement
  • Report Writing
  • Visual data representation
  • Business Needs Analysis
  • A/B Testing
  • Data Modeling
  • Technical Analysis
  • Microsoft tools
  • SQL
  • Python Programming

Languages

English
Professional
Chinese (Mandarin)
Professional

Timeline

Data Analyst

Qipu Technology
10.2023 - 02.2024

Database Analyst

Everbright bank
08.2019 - 10.2021

Front-End Developer

Chongqing software
11.2018 - 05.2019

Master of Science - Data science

University of Adelaide

Bachelor of Science - Computer Science and Technology

Guizhou University

Similar Profiles

  • Henk Volschenk

    Henk VolschenkHenk Volschenk

    Training Supervisor at Cape Peninsula University of Technology (CPUT), South African Renewable Energy Technology Centre (SARETEC)Training Supervisor at Cape Peninsula University of Technology (CPUT), South African Renewable Energy Technology Centre (SARETEC)

  • Alison Hawkins

    Alison HawkinsAlison Hawkins

    Vice President of Client Services at Orion Advisor Technology (Redtail Technology)Vice President of Client Services at Orion Advisor Technology (Redtail Technology)

  • Krishnaraja Ganapathy

    Krishnaraja GanapathyKrishnaraja Ganapathy

    Application Development Manager at BNY Mellon Technology India Pvt Ltd – Pershing TechnologyApplication Development Manager at BNY Mellon Technology India Pvt Ltd – Pershing Technology

  • SANDEEP SAHNI

    SANDEEP SAHNISANDEEP SAHNI

    Truck Driver at ADELAIDE TRUCK & VANSTruck Driver at ADELAIDE TRUCK & VANS

  • Lauren Hortin

    Lauren HortinLauren Hortin

    Shift Manager at McDonald'sShift Manager at McDonald's

CREATE PROFILE
Dillion Liu