Business Analyst with a Difference
Sydney Area, Australia
- Current
-
- Available for a new challenge at A Great Company!
- Past
-
- Operations Analyst, Asia Pacific at Lenovo
- Commercial Manager at Telstra
- Senior Business Analyst at Qala Singapore Pte Ltd
- Education
-
- University of Technology, Sydney
- Macquarie University
- Macquarie University
- Recommended
-
9 people have recommended Colleen - Connections
-
210
connections
- Industry
- Information Services
- Websites
Colleen Chan’s Summary
I have a unique career DNA, statistician meets business analyst. This means I am the go-to person for C-level executives who need data turned into insightful advice right across your business.
- a logical thinker and has a heightened awareness.
- about details and is results driven.
- smart, confident, nice and personable.
My style maybe a bit left of centre but I'm great to be around and you'll really enjoy working with me!
I can take complex problems and make them simple. I can understand and measure the ambiguous!
I am a visual person so I can take all kinds of complex data and make it understandable not only to financial people but to everyone in the business. That makes me a critical part of every decision making process.
In fact, no organisation should do business until they...Check with Chan!
Colleen Chan’s Specialties:
Specialist in building models that extract massive amounts of diverse data from multiple sources and present it in a very clear, user friendly and graphical format. These models have been very successfully used by non-financial business stakeholders to make well informed commercial decisions with regards to pricing, sales, product offerings, project viability and financial management.
Excel Master, Experience Business Intelligence systems.
Colleen Chan’s Experience
-
Operations Analyst, Asia Pacific
Lenovo
(Public Company; Computer Hardware industry)
August 2005 — August 2008 (3 years 1 month)
1. Redesigned all management reports used in the operations area. Newly designed reports provide more data, and taking less than a quarter of the time to produce with greater accuracy.
2. Achieved greater inter-departmental efficiencies by analysing current conditions, pointing out areas for improvement, and suggesting action plans.
3. Improved data interlocking processes, between AP Ops, Global Supply Chain, and the regions.
4. Increased efficiencies with Sales, Distribution, Supply & Investments processes.
5. Created processes and models to measure Forecasts vs. Actuals vs. Targets. -
Commercial Manager
Telstra
(Public Company; TLS; Telecommunications industry)
August 2004 — June 2005 (11 months)
•Provided financial support for key initiatives undertaken for Telstra Shops.
•Redesigned financial models depicting retail presence .This redesign was commended by the Business Development Managers as making decisions much quicker and easier.
These models included: (All financial modelling for new business initiatives)
a) Company owned stores and kiosks
b) Licensed stores in Metropolitan and Regional areas
c) Sensitivity analysis on KPi’s against NPV, ROI and breakeven over 5 years.
d) Cost benefit analysis for company owned and licensed stores.
e) Identification of key business drivers for all costs and revenues including forecasting revenue, Direct Variable Costs and Direct Incremental Expenses, opex, and capex for all initiatives.
Models were created using Business Intelligence system TM1 and Excel -
Senior Business Analyst
Qala Singapore Pte Ltd
(Privately Held; Information Technology and Services industry)
December 2000 — August 2001 (9 months)
• Greenfield opportunity reporting to the Sales Director.
• Designed and developed from scratch, a number of business models used in the local and regional markets for the simultaneous openings of a start up ISP in Singapore, Hong Kong and Sydney.
• These models included:
• Forward looking model using NPV and ROI analysis and using forecasting revenue, operating expenditure and capacity forecasting for the cost recovery of capital expenditure.
• Sensitivity analysis using different customer KPI scenarios to achieve best operational practice for product profitability and pricing analysis as well as business case or “what if” scenario analysis.
• Ongoing communication including:
• Engineers to translate the technical infrastructure into a numeric model.
• Marketing and product managers to understand their particular revenues and costs.
• Sales force to understand different sales channel methodologies.
• Finance for management accounting and reconciliations. -
Senior Business Analyst
Optus
(Public Company; SGT; Telecommunications industry)
October 1996 — September 2000 (4 years )
• Responsible for developing the models to produce a complete monthly product profit & loss reports for all business units and sales channels to EBITDA. These models were used for business case analysis, new pricing proposals and to review performance of business cases and understanding of variances in KPI’s and between actuals and budgets.
• Expanded existing model which took the above from contribution GM to EBITDA.
• Moved model to TM1 platform reducing delivery day from day 10 to day 3.
• Models were created using Business Intelligence system TM1 and Excel -
Business Analyst
AAPT
(Public Company; TEL; Telecommunications industry)
May 1993 — October 1996 (3 years 6 months)
• Reporting to the Director of Business Development role was responsible for developing the models for customer revenue analysis. These models were used for month end financial process including accruals and deferments, billing analysis, revenue forecasting, revenue variances and revenue Kpi’s, financial reports for senior management, customer analysis for product and pricing, fulfilment of contracts to our resellers, commission agents, association groups including commission payments and any fraudulent claims.
• Understanding and maintaining the billing system to revenue to ensure product economic analysis is complete.
• Models were created using Business Intelligence system Oracle and Excel. -
Computer Manager
Rheumatology Department, Royal North Shore Hospital
(Hospital & Health Care industry)
May 1989 — January 1993 (3 years 9 months)
Responsible for all computer related issues - IT support, system development, database administrator, training and any external party arrangements.
Achievements : Moved from two floppy disk drive systems to networking laboratory, adminstration and completed patient database, including billing and diagnostic analysis, automated queries for doctors & student doctors and automated all laboratory reporting analysis. -
Statistics Officer
AMP
(Public Company; AMP; Financial Services industry)
May 1988 — May 1989 (1 year 1 month)
Colleen Chan’s Contact Settings
Interested In:
- career opportunities
- job inquiries
- expertise requests
- reference requests
- getting back in touch
