Ying Pin (Louis) LAN

Junior Data Engineer (Secondment) at Cin7
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
NZ
Languages
  • Chinese Native or bilingual proficiency
  • English Professional working proficiency
  • Japanese Professional working proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • AZ-104: Azure Administrator Associate
    Microsoft
    Apr, 2023
    - Nov, 2024
  • DP-203: Azure Data Engineer Associate
    Microsoft
    Mar, 2023
    - Nov, 2024
  • DP-300: Azure Database Administrator Associate
    Microsoft
    Feb, 2023
    - Nov, 2024
  • SC-900: Security, Compliance, and Identity Fundamentals
    Microsoft
    Feb, 2023
    - Nov, 2024
  • DP-500: Azure Enterprise Data Analyst Associate
    Microsoft
    Jan, 2023
    - Nov, 2024
  • PL-300: Power BI Data Analyst Associate
    Microsoft
    Dec, 2022
    - Nov, 2024
  • AI-900: Azure AI Fundamentals
    Microsoft
    Nov, 2022
    - Nov, 2024
  • AZ-900: Microsoft Azure Fundamentals
    Microsoft
    Nov, 2022
    - Nov, 2024
  • DP-900: Microsoft Azure Data Fundamentals
    Microsoft
    Nov, 2022
    - Nov, 2024
  • Google Data Analytics
    Coursera
    Aug, 2022
    - Nov, 2024
  • Introduction to EDI X12
    Udemy
    Jul, 2022
    - Nov, 2024
  • API and Postman
    LinkedIn Learning
    Sep, 2021
    - Nov, 2024
  • Google Analytics Training
    Lynda.com
    Apr, 2020
    - Nov, 2024

Experience

  • Cin7
    • New Zealand
    • Software Development
    • 200 - 300 Employee
    • Junior Data Engineer (Secondment)
      • Jan 2023 - Present

      • Developing and managing data pipelines hosted in Azure • Assisting in developing data visualisation and presenting data in a meaningful way using Power BI/Tableau and third-party software• Designing, building and maintaining data architectures, data processing systems, data catalogues and monitoring using Data Factory and Azure Synapse Studio• Manipulating, exploring and extracting value from datasets

    • EDI/3PL Integration Analyst
      • Feb 2021 - Present

      EDI:• Set up the EDI connections as AS2, VAN, or SFTP with Opentext (GXS)• Build the EDI integrations under X12 or EDIFACT• Work with 3rd parties to build the EDI connections, including IBM, SPS Commerce, CommerceHub, True Commerce, etc.• Develop new features and functions for the EDI messages based on the MIG with Integration Engineers (.NET)• Provide a certain level of customisations by configuring the settings3PL:• Create the import/export mappings which are based on the documentation/ specification from the trading partners• Communicate the messages with the partners in different formats, including XML, XSLT, JSON, RC, and CSV • Connect to the endpoints by FTP, SFTP or API (REST API/SOAP API)• Use software to conduct the testing and debugging, including Postman API, Raygun, FileZilla etc.• Identify bugs while conducting the tests and resolve the issue with Integration Engineers (.NET)• Provide customisations upon request by using the SQL query to change the payload• Offer Go-Live training session once the integration is completed and Post Go-Live support when the customers need help Show less

    • Data Analyst (Secondment)
      • Aug 2022 - Dec 2022

      • Analysed results of data queries deriving actionable insights• Performed data cleansing and ETL process• Tested and sampled data to verify the credibility of the insights• Reported the results, observations, suggestions and recommendations using multiple presentation techniques including Pivot Tables, Google Sheets, Salesforce and Power BI

  • Wealth Architects
    • New Zealand
    • Investment Management
    • Marketing & Data Analyst
      • Jan 2020 - Feb 2021

      Duties & Responsibilities • Created the company's online presence and marketing campaigns including company website (Crazy Domain), social media (Linkedin / FB), email marketing (Mailchimp), and customer relationship management (Hubspot) • Improved graphic designs, photography and website design elements to attract traffic (Google Analytics/Tableau) • Launched strategic proposals and implement marketing, branding, and advertising plans to different customer segmentation to attract leads and prospects • Analysed the property market in Christchurch and produce specific marketing messages to support sales activities • Systematised existing clients and prospects' database, and import/export/integrate between different platforms Show less

  • Pyper Vision
    • New Zealand
    • Airlines and Aviation
    • 1 - 100 Employee
    • Intern: System Developer
      • Sep 2020 - Nov 2020

      Goal: As a startup company, they wanted to build a marketing dashboard to promote their fog dispersion solution Actions: My primary task was to use Python (Selenium, Beautifulsoup, Requests, and Pandas) to perform web scraping, extract data from the flight schedule website, and load information into the data warehouse. I also developed an Optical Character Recognition (OCR) program to read PDF files about the aeronautical charges and convert it to Excel Result: At the end of the internship, I successfully built a data pipeline, integrated to AWS, and generated visualisation charts with Power BI to show the results. This program helped Pyper Vision to pull the data effectively and efficiently to build the marketing dashboard with a prediction model Show less

  • YKK Vietnam Co. Ltd
    • Retail Apparel and Fashion
    • 1 - 100 Employee
    • Sales Analyst | International Key Account Manager
      • Sep 2012 - Jun 2019

      Duties & Responsibilities Sales and Marketing: • Communicated with the marketing team in Ho Chi Min and Hong Kong regularly to obtain the latest product information, brand holders’ strategy and market-related news. • Collected the market information of the textile industry in Cambodia and discuss with the regional manager/marketing team about the strategic plan. • Organised marketing strategies with the marketing team and put plans into practice and evaluate the outcome regularly. • Executed strategies to increase sales, including visiting customers, approaching potential customers, providing a competitive price quotation and fulfilling customer’s requests. • Implemented sales operations base on each month’s sales target and result. • Explored and obtain new market shares in the ASEAN region. • Familiarised brand holders the new products which are based on individual needs including anti-nickel, recycled tape, quick-release lock and air/watertight zipper. • Introduced customers to the latest products and provide a catalogue for details to fit the purposes. Compliance: • Participated in annually Tax Audit / ISO9001 & ISO14001 Audit / Office Internal Audit. • Designed workflows and procedures to improve efficiency and productivity. • Monitored and evaluated the current policies and suggested regional managers to revise if outdated. • Reviewed office expenses, salary payment, and tax declaration documents. • Negotiated the price and evaluate the performance of service providers and stationery suppliers. Team Management: • Recruited new staff and provided training programs including products types, operating system, and orders arrangement process. • Assigned jobs to assistants and managed to balance the workload between each team member. • Evaluated the performance of each team member monthly, quarterly and yearly then report to the regional manager for personnel appraisal. Show less

Education

  • University of Canterbury
    Master, Business Information System
    2019 - 2020
  • The University of Queensland
    Master, International Business
    2011 - 2012
  • National Chiayi University
    Bachelor, Applied Foreign Language: English & Japanese
    2004 - 2009
  • University of Oregon
    Exchange Student, International Business
    2007 - 2008

Community

You need to have a working account to view this content. Click here to join now