Patrick Ng Email & Phone Number

Sydney

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.

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.

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.

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.

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.

Master Of Business Administration - Mba

Bachelor Of Engineering - Be Mech Honours

Higher School Certificate - Hsc Nsw