John C. Email & Phone Number

Auckland, Nz

Sydney, New South Wales, Au

- Data modelling- Data warehousing- Data management- Data governance & data quality- Data-driven framework- Data security- DataOps & CI/CD- ELT solution- Cloud solution & engineering- Automation- Visualization- Administration on Enterprise Applications- Prioritising and planning

Auckland, Nz

- Migrate data from on-prem database to the cloud- Use Extract-Load-Transform (ELT), EL or traditional ETL method for the data pipeline- Build data or dimensional model for the different reservations systems- Design and develop enterprise data warehouse- Migrate the reports from SAP Business Objects to Tableau- Utilise Amazon Relational Database Service (RDS) and also take care of database administration- Turn data into insightful knowledge and assist senior management to make better decisions

- Deal with big data (huge, complex and live datasets)- Create and modify executive and management dashboards- Work with developers and DBAs on Microsoft SQL Server, Oracle, DB2, MySQL and NoSQL Databases- Data science and data mining projects- Migrate SAP Business Objects dashboards onto Tableau- Reconcile the data flow in Oracle and Exasol (Data quality assurance)

Auckland, Nz

- A variety of reporting and analysis (weekly ROI report, customer demographic report, agent report, claims & workshop report, online / offline bookings & revenue report, call centre operator performance report, desktop / mobile analytics report, accessory report, target market report, and other business related reports)- Create and maintain KPI dashboards for all departments including Claims, Customer experience design & innovation, Finance, HR, Operations, Marketing, Fleet, Call centre- Data mining, web optimisation and present insightful information to senior management- Initiate and progress several big projects which aims to help the business to generate more profit or reduce cost, such as cost risk analysis, incremental analysis, accessory upsell plan, friends referral plan, etc- Collect and analyse data by using data warehousing techniques and business intelligence tools- Evaluate internal and external customers' needs and abilities in order to provide appropriate solutions

Bonn, North Rhine-Westphalia, De

- Master data management and analysis in SAP/CRM system- Prepare ad-hoc reports and dashboards- Update and maintain the freight quotations on DHL’s customer portal

Truganina, Victoria, Au

- Generate daily payment schedule- Liaise with factories, suppliers and freight forwarders to ensure all customers’ shipments are promptly delivered- Purchase of supplies, goods and materials with overseas factories in accordance with international customers’ instructions- Liaise with the Artwork & Design Department to compile shipping mark, artwork instruction labels and rating labels

Auckland, Nz, Nz

- Data management- Data cleansing and sorting with advanced Excel skills and formula.- Turn unstructured customer detail files into the correct data types which can be loaded into the CRM/SAP system

Graduate Diploma In Computing, Business Intelligence & Data Engineering

Bachelor Of Commerce (B.Com.), Logistics, Materials, And Supply Chain Management

Diploma, Business Management And Marketing