Talk to sales Try for Free
Oliver Qian

Oliver Qian

Financial Product Specialist

Followers of Oliver Qian129 followers
location of Oliver QianHomebush, New South Wales, Australia

Connect with Oliver Qian to Send Message

Connect

Connect with Oliver Qian to Send Message

Connect

  • Timeline

  • About me

    Data Specialist | PowerBI Associate | Azure Administrator | Azure Databricks | Scrum Master

  • Education

    • 上海理工大学

      2016 - 2020
      Bachelor's degree Management Information Systems and Services GPA: 3.6/4

      Excellent scientific literacy: Obtained knowledge of advanced mathematics, economics, management, operations research, and computer applications during the school period, and has a solid basic theory and basic knowledge of management discipline.Solid Technical Skills: Gained advanced management ideas, methods, organization and technology, as well as mathematics and computer models, analyse, make decisions, and organize implementation of problems in operation management, organization… Show more Excellent scientific literacy: Obtained knowledge of advanced mathematics, economics, management, operations research, and computer applications during the school period, and has a solid basic theory and basic knowledge of management discipline.Solid Technical Skills: Gained advanced management ideas, methods, organization and technology, as well as mathematics and computer models, analyse, make decisions, and organize implementation of problems in operation management, organization management, and technology management. Show less

    • 澳大利亚悉尼大学

      2020 - 2022
      Master's degree Information Technology and Information Technology Management(Data Analytics) Graduate in Distinction; WAM: 78.2/100

      Activities and Societies: O-Week participant, Fair Work Court Participant Advanced Technical Proficiency: A two-year dual master’s degree program that combined the technical expertise of IT and IT Management. Undertaken advanced coursework in data analysis, database design, and data mining. Strong technical skills involved for efficient data cleansing, extraction, transformation, and interpretation. Competent coding skills and sound experiences of Python, R, SQL, Cypher.Data Visualization Expertise: Honed skills in data visualization whilst in coursework. Obtain… Show more Advanced Technical Proficiency: A two-year dual master’s degree program that combined the technical expertise of IT and IT Management. Undertaken advanced coursework in data analysis, database design, and data mining. Strong technical skills involved for efficient data cleansing, extraction, transformation, and interpretation. Competent coding skills and sound experiences of Python, R, SQL, Cypher.Data Visualization Expertise: Honed skills in data visualization whilst in coursework. Obtain skills in BI tools including Tableau and Power BI to create compelling visual representations of data trends and patterns and being able to effectively communicate complex insights to non-technical stakeholders in Slack. Show less

  • Experience

    • Tianhong Asset Management Co., Ltd.

      Jun 2019 - Sept 2019
      Financial Product Specialist

      Role description: Achieved relevant financial knowledge and market operation methods and analyse data through data analysis software.Daily work: Gained and deeply understood financial management and investment. Participated daily morning lectures, integrated into reports on special topics; Assisted researchers in tracking emerging data and composing weekly reports.Achievements: Participated in the analysis of consumer purchasing power trends of financial products in the past five years. Nearly 8,000 customer data were converted into analysis report graphs through Excel and SPSS. Show less

    • InterCare Staffing and Employment

      Jan 2023 - Jun 2023
      Data Reporting Analyst

      - Initiated SEO keyword data research and web crawling, providing visualisation insights to the marketing team.- Implemented data validation protocols that ensured the maintenance of data quality.- Analysed and integrated datasets from separate sources alongside proceeding over 68,000 customer data into pre-processing algorithm, converted into analysis report graphs through Power BI.

    • Star Loop Pty Ltd

      Jul 2023 - Sept 2024
      Data and Business Intelligence (BI) Analyst

      - Optimised and implemented data extraction algorithms, increased SQL queries extraction efficiency by 20%. - Leveraged SQL and Python labs to manage multiple datasets, reducing correlative redundancy by 15%.- Applied ETL processes using MS Power Automate on cross-functional department datasets loaded on SQL Server, integrating with Power BI to transform over 117,000 data points into reports and visualisations for internal and external clients with accessible and data-driven strategic insights. Show less

    • AI Consulting Group

      Oct 2024 - now
      Associate Consultant - Data Engineer

      - Recruitment X.AI: Implemented DevOps on client project IP, ensuring branch and version control (Git) for consistent and clean operations data.- Implemented a PDF-to-text extraction pipeline using LibreOffice and Azure Queue, ensuring continuous batch conversion of CVs for preview and processing.

  • Licenses & Certifications

  • Honors & Awards

    • Awarded to Oliver Qian
      National Advanced Mathematics Competition Zhejiang University Oct 2017