Patrick Ng

Patrick Ng Email and Phone Number

Data Analyst | BI analytics, reporting, visualisation, projects | Business and technical capable with broad industry exp. @ Transport for NSW
australia
Patrick Ng's Location
Greater Sydney Area, Australia
Patrick Ng's Contact Details

Patrick Ng work email

Patrick Ng personal email

n/a
About Patrick Ng

Ask the right questions, use the right data, examine insights critically, develop practical solutions and iterate for incremental value add.Broad experience and MBA-qualified, engaging in business and technical functions.I care about:• Being considerate to those downstream and around me and minimising technical debt.• Strong foundation leads to operational efficiency and quality.• Good analysis should be an iterative process, as each step can expose further questions for exploration or an obstacle/dependency.Tools I use:While not all of my work are technical, I do have a toolkit that evolves around job requirements. Most recently working with SQL Server, Excel/CSV, Power BI and Tableau (with Server), Qualtrics and ServiceNow.Things I know something about:I have past experience or familiarity with Agile/Kanban/Lean, cloud computing, Cognos, data cleaning/feature engineering/machine learning, HTML/CSS, leading/coaching small teams, process/workflow, MS Office/Excel/Access, PowerBI, price/quote automation (JDA), production scheduling (Manugistics/SAP), project management, R/Tidyverse, Sharepoint, software testing, Theory of Constraints (TOC), user story/UI/UX/CX.

Patrick Ng's Current Company Details
Transport for NSW

Transport For Nsw

View
Data Analyst | BI analytics, reporting, visualisation, projects | Business and technical capable with broad industry exp.
australia
Employees:
6125
Patrick Ng Work Experience Details
  • Transport For Nsw
    Customer Experience Analyst - People, Communication & Workplaces
    Transport For Nsw 2023 - Present
  • Transport For Nsw
    Business Insights Analyst - Corporate Services
    Transport For Nsw 2021 - 2023
    Sydney
  • Transport For Nsw
    Reporting & Analytics Consultant - Corporate Services
    Transport For Nsw 2020 - 2021
    Sydney, Australia
    • Contributed to the Voice of Customer program, developing and managing customer surveys in Qualtrics with insight analysis.• Service improvement project support with benefits modelling.• Developed dashboards and reports for monitoring shared services consumption and performance.• Supported new data collection initiative, exploring new datasets in SQL Server and established interim process for reporting continuity.• Supported client engagement team with project analysis and consultation.Context:Transport for NSW is the government agency responsible for managing multi-mode services and building the state's future infrastructure. I am an analytics specialist in Corporate Services, supporting demand tracking and performance analysis, in both operational and project capacities.
  • Optus Business
    Lead Reporting Analyst
    Optus Business 2011 - 2019
    Sydney, Australia
    • Developed and maintained master datasets and related mapping tables, enabling 'single source' data governance and efficient data pipes, supporting sales/management reporting, dashboards and analysis. Primary sources were in SQL Server (to GB size, relational and dimensional), including sales CRM and revenue.• Converted high usage datasets to user-friendly Tableau Data Sources for self-serve consumption by analysts and superuser managers.• Systematically explored previously unused data in datamart and exposed them for analyst use, after any appropriate cleaning, transforming and validation, enabling new insights.• Pioneered the use of slow changing dimension (SCD) sales data, enabling a true measure of pipeline-to-sales conversion for forecasting use.• Built Tableau automated reports, interactive dashboards and publishing to Tableau Server, including stakeholder management and data sourcing.• Trained others on various Tableau use cases. Participated in initial tool assessment, setup and adoption phase, including working with IT Lead on resolving challenges like role definition, data governance, version control and community collaboration.• Supported machine learning consultants (Deloitte) on 2 project iterations, with domain knowledge, feature engineering and testing, for cross-sell/up-sell propensity modelling. Part of OB's initial effort to explore and build predictive analytics capability.• Hands-on training and coaching of junior analysts/graduates on sales operations, analysis, data use and other domain/technical knowledge.Context:Optus Business (OB) is the B2B sales division of Optus. I was a senior analyst in sales operations, supporting reporting and analytical demands, with joint projects across IT, product mgt, marketing and service delivery teams. Worked as individual contributor and as a team lead, guiding and supporting 1-2 direct reports.
  • Telstra
    Sales Analyst - Telstra Business
    Telstra 2010 - 2011
    Sydney, Australia
    • Improved legacy reporting by standardising data sources and streamlining report build with Excel VBA macros, which cleared 2-3 days per week for additional project and support work.Context:Telstra Business is the medium corporate sales division of Telstra. I was a reporting and project specialist, supporting the technical product pre-sales team.
  • Smt Consulting
    Consultant
    Smt Consulting 2004 - 2009
    Australia And Asia
    • Analysed inventory and assembly processes at a B&D Doors garage opener factory, identified 88% under-utilisation. Proposed reduction in planned capex and overtime, demonstrated constraint was at procurement, not production. [solo project]• Modelled material transport routing options at Boral and identified $3.8M/yr in potential savings. [solo project]• Supply chain review and implementation of production scheduling software at B&D Doors. [with SMT]• Implementation of price optimisation and quote automation software at Telstra. [with JDA]• Implementation of aircraft maintenance scheduling module at Qantas. [with MXI Technologies]• Review of ordnance sustainment processes at the Australian Department of Defence DMO. [with other contractors]Context:SMT Consulting is a niche consultancy of 15-30 people, specialising in supply chain, logistics and software. Operating as part of a complete team, on solo projects or outsourced to partners, I was a consultant with assignments in Australia and SE Asia.
  • Telstra
    Account Executive - Telstra Business & Government
    Telstra 2002 - 2004
    Australia
    • Closed a 2 year managed mobile/wireless fleet agreement with Leighton Holdings (now CIMIC), worth $3M.• Helped customers use wireless technology to improve their business, while achieving all sales targets allocated to me. Solutions include Blackberry email for collaboration, real time job allocation for efficiency and vehicle tracking for optimisation.Context:Telstra Business & Government was the large corporate sales division of Telstra. I was a key account manager, specialising in mobile telephony and wireless data solution sales.

Patrick Ng Skills

Performance Dashboards Solution Selling Information Technology Pandas Consulting R Sharepoint Salesforce.com Account Management Microsoft Powerpoint Data Analysis Forecasting Sales Operations Microsoft Sql Server Telecommunications Business Analysis Jira Agile Methodologies Data Analytics Team Leadership Business Insights Tableau Strategy Decision Support Data Cleaning Data Visualization Microsoft Office Data Modeling Microsoft Excel Business Analytics Feature Engineering Business Intelligence Sql Python Project Management Problem Solving Analytics Continuous Improvement Crm Microsoft Power Bi

Patrick Ng Education Details

Frequently Asked Questions about Patrick Ng

What company does Patrick Ng work for?

Patrick Ng works for Transport For Nsw

What is Patrick Ng's role at the current company?

Patrick Ng's current role is Data Analyst | BI analytics, reporting, visualisation, projects | Business and technical capable with broad industry exp..

What is Patrick Ng's email address?

Patrick Ng's email address is pa****@****.com.au

What schools did Patrick Ng attend?

Patrick Ng attended Macquarie Graduate School Of Management, University Of Sydney, Marist College North Shore.

What skills is Patrick Ng known for?

Patrick Ng has skills like Performance Dashboards, Solution Selling, Information Technology, Pandas, Consulting, R, Sharepoint, Salesforce.com, Account Management, Microsoft Powerpoint, Data Analysis, Forecasting.

Not the Patrick Ng you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.