Jonathan Chong Email & Phone Number

Sydney, New South Wales, Australia

Sydney, Australia

Providing my clients with MicroStrategy expertise, mobile solutions, business intelligence delivery and managed services.

• Designed and delivered the Zurich Underwriting Dashboard, which allows underwriting managers to view how many life insurance cases have been submitted to Zurich, and the underwriting decision outcomes of policies.
• Implemented the Zurich Sales Metric Dashboard, which combines multiple sales streams of the Life Insurance business and effectively displays the information in a portable dashboard. This dashboard depicts KPIs of.

• Deployed the Retail Sales App and Transactional Analysis App on the iPad which informs every level of the company how they are performing, from the individual store, segment and up to the total company network. The.
• Designed the Sales Business Review pack, which is an automatically generated document depicting key performance indicators for any PANDORA store selected. A wide range of internal and external source systems are used.
• Developed a real-time operational dashboard accentuating to warehouse managers, operational personnel and senior management the progress of Pandora's e-Commerce business. This dashboard highlights key performance.
• Automated many labour and data intensive Excel spreadsheets for the merchandising team, such as their buying processes and product reporting. The greatest improvement resulted in a reduction of approximately 7 working.

North Sydney

• Delivery of BI projects such as streamlining the budgets process and analysis into Life Insurance Sales and Exits.
• Developed an operational dashboard revealing how efficient an Auto-Population system is at matching clients and life insurance policies.

North Sydney

• Project TIES innovates and maintains Zurich’s fast flow underwriting system Z.streamXpress (ZSX). My responsibilities are to ensure that all transactional data such as quotes and written business from ZSX are captured.
• Developed a key GWP (gross written premiums) report and dashboard for executives and senior management. This report is emailed daily to over 100 managers across the country, depicting actual GWP to target GWP for each.
• Successfully grew Zurich’s analytical capability in data-mining ZSX data, by providing multiple channels to access this data to the business and the actuaries. For example, the actuaries use SAP to query database views.

Sydney, NSW

• Implemented a greenfield business intelligence environment on-time and under budget. This solution allows the business to effectively analyse key retail and wholesale metrics such as stock on hand, stock movements and.

Sydney, NSW

• Delivery of the Microstrategy reporting solution for the Corporate Data Program (CDP), which ensures that Macquarie is in line with Basel III requirements.
• Responsible and accountable for the Microstrategy schema design and modelling of the semantic data layer.
• Ensuring that the Microstrategy project stream is delivered while supporting the BAU tasks in parallel.

North Ryde

• Provided analysis and results to the executive team and retail sales/marketing to support decision making, such as supplier profitability analysis.
• Management and administration of the production BI environment, across the data-warehouse and Microstrategy.
• Ensuring that the data provided by third parties to our industry suppliers is accurate and timely.
• Technical lead on systems implementation, such as Salesforce CRM and Microstrategy BI.

North Sydney

• Ensuring that the integrity and information arising from the data-warehouse is of high standard and accurate.
• Ad-hoc data analysis to provide business insight, such as identifying customers in our targeted marketing campaigns for life insurance products.
• Developing Microstrategy reports for the informational needs across the different lines of business, from sales/underwriting, claims and operations. Most of this information is distributed automatically on a daily and.

Sydney

• Developed monthly sales and marketing dashboards for senior executives, and reduced the number of working days that this information is available at the start of every month.
• Providing data support in a market-leading approach to segment our customer base. This also included tailoring the strategies applied to each customer segment, based on insights from the data.
• Intensive data analysis to develop opportunities within our customers’ growth and providing informational support to the marketing team for identifying key customers for cross-selling campaigns. Additionally, provided.
• Completed a ‘share of wallet’ data model for the telecommunications industry as a whole, allowing us to identify opportunities with our customers better.
• Created the data model for the reporting data cube used for strategic customer data, for effective and efficient customer relationship management.

B Commerce, Information Systems, Finance

Granted a UNSW Co-op scholarship in 2008-2010 due to my involvement in high school activities, strong technical abilities and business.

Education record