Skip to content

Latest commit

 

History

History
124 lines (79 loc) · 4.79 KB

index.MD

File metadata and controls

124 lines (79 loc) · 4.79 KB
Raw

QUEENIE LI

Summary

Highly skilled and motivated Data Analyst with 5 years experience and in-depth knowledge in various database technologies, reporting tools, data visualization and big data looking for new career challenges.

Core Technical Skills

Skills Rating
Oracle 11 / MySQL 6 / Presto 0.19 Advanced
Stored Procedures / Funtions / Query Performance Tuning Advanced
Tabuleau 10 / Jasper 6 Reporting Server / Power BI Advanced
Big Data with Splunk Intermediate
Microsoft Excel 2007 & above / Formulae / Power Pivot / Macro Expert
Rest of the Microsoft Office stack Advanced

Core non-Technical Skills

  • Business requirements gathering
  • Scrum
  • Communication and Teamworking
  • Working against deadline

Professional Experiences

NBNCo, Melbourne

Contract Data Analyst, (Feb 2017 - Current)

Oracle / Presto / Tabuleau / Excel

  • Working closely with the Engineering Department or other stakeholders, to understand, analyze and quantify the Network Performance Indicators against coporate objectives

Responsibilities

  • Forecasting future network capacity growth rate using various algorithms and reflecting on Dashboards

  • Data governing to ensure data consistency and integrity

  • Data Visualization and Dashboard Building

  • Extract Key Business Insights using historical network capacity data for executive stakeholders

  • Data Integrity Validation and Cleansing

  • Reporting automation

Achievements

  • Individually set reporting baselines from scratch which are actively adapted by various departments within NBNco

  • My work has been widely acknowledged and recognized by executives and were "Sparked" on NBNco intranet

Ultrafast Fibre Ltd, Auckland

Reporting Analyst (Oct 2013 - Jan 2017)

MySQL / Splunk / PowerBI / Jasper Server / Excel

  • Solely responsible for the reporting function of Ultrafast Fibre including designing, producing and maintaining the Network and Service Level Agreement / Key Performance Indicator Reports

  • Solely responsible for producing marketing/RSP reports for the commercial managers，and to clear any ambiguity and to balance both needs.

  • Solely responsible to produce Exceptional Reports to highlight miss-aligned business order / network data

  • Highlight areas to improve in Business Processes

  • Supporting the finance department with Billing reconciliation and financial reports

  • Significant contributor of the Revenue Assurance Project

  • Data Cleansing

  • Reporting Automation

Achievements

  • Designed and developed the entire Ultrafast Fibre reporting suites from ground up

  • Technical provisioning to the Revenue Assurance Project saved Ultrafast Fibre over half a Million dollars over a year

  • Supporting the Billing team to reconcile their invoice batches every billing cycle, to highlight discrepancies which could cost the company thousands every month

  • Best employee of the month in 2014

Nokia Siemens Networks, Shanghai

Technical Support Engineer (2007 - 2012)

  • Delivering solution and technical support to ensure all services operate normally

  • Resolving incidents within tight deadline

  • Performing integration tests of products / services / improvements / bugs

  • Highlighting known issues

  • Participating new Product Development Lifecycle, which includes but not limited to risks management, defects identification and tracking, software / hardware integration, project coordination and tests

  • Prioritising tickets by coordinating urgencies between R&D teams, Product Line teams and Sales and Marketing teams

  • Documenting and reviewing User Manual, Upgrade Procedures, Acceptance Test Manual and other customer documentation with the Documentation team

Nokia Siemens Networks, Shanghai

System Testing Engineer (2005 - 2007)

  • Accountable for functional and integration testing across various products and networking infrastructures

  • Providing analysis reports and documents on test results in a timely and well-organised fashion

  • Managing defect fixes and maintenance throughout the Product Lifecycle

  • Requirement analysis, use-case specifications and interpretations

  • Test planning, test reporting, defect analysis

  • Owning and maintaining test environments, execute test plans, evaluate and record results in an effective and meaningful way

Academic Histories

Donghua University, Shanghai

  • Bachelor of Science in Computer Science and Technologies (Sep 2001 - July 2005)

Professional Membership

Cisco

  • Cisco Certified Network Associates (Obtained in 2006)

Other Characteristics

  • Outgoing, optimistic personality and positive energy
  • Passion in technologies
  • Non-smoker
  • Australian Permanent Resident
  • Australian full Driver License