John Mcmahon Email & Phone Number

Perth, Western Australia, Australia

Canberra, Australian Capital Territory, Australia

• Create, maintain and enhance interconnected Tableau dashboards with multiple data sources.
• Create, maintain and enhance supporting Tableau mobile dashboards with multiple data sources
• Assist in the creation of curated datasets from raw data using SQL in Hue.
• Investigate data anomalies using SQL in Hue.
• Train and provide support to my former team to maintain the functionality of the Verint data export SAS EG programs.
• Create and modify dashboard UI elements using Adobe XD. Technologies used:TableauApache Hue – SQL Assistant for Data WarehouseVerint – Speech AnalyticsSAS Visual Analytics (SAS VA) SAS Enterprise Guide (SAS EG)Teradata.

Australia

• Finalise modified replica of a bespoke SAS EG Verint Data export program for a second speech project.
• Generate, maintain and enhance daily SAS EG email program on unusual changes in speech categories using control chart theory.
• Create, maintain and enhance multiple SAS VA dashboards using Verint Speech data and replicate control chart graphs within SAS VA.
• Regularly update, maintain and troubleshoot any issues with SAS EG Verint Data export programs and datasets, including interrogating relevant Teradata (EDW) datasets.
• Create and maintain intraday speech category Tableau dashboard.Technologies used:Verint – Speech AnalyticsSAS Visual Analytics (SAS VA) SAS Enterprise Guide (SAS EG)Teradata SQL - Enterprise Data Warehouse.

Australia

• Built, tested, maintained over 50 Speech Transcription categories using Verint – Speech Analytics across multiple speech projects.
• Supported improvements to the Verint Speech Category creation, testing and documentation standards within the Agency.
• Assisted in the provision of expert advice for Speech Transcription requirements in a tender process.
• Created a fully customisable data entry spreadsheet in Excel using data validation dropdown menus/Tables and Pivot Tables, while also quickly reconfigured by beginner Excel users.The spreadsheet is in active use by.
• Regularly supported the export of metadata from Verint into SAS EG to enable more thorough analysis and visualisation of data within SAS VA through a bespoke SAS EG data export program.Technologies used: Verint –.

Wellington, New Zealand

Seven weeks assisting the New Zealand Initiative research team as an intern.- Assisted Chief Economist with scoping his report on water management.- Cleaned, organised and interpreted datasets for Senior Researcher.- Weekly blogs published on Mannkal's website- Wrote article published in New Zealand Initiative's weekly Insights newsletter- Wrote article.

Booragoon

Current position: Customer service representativeServices provided:- Cashier- Sales returns- Photo processing- Lay-by sales- Mobile phone sales- Provide information on product locations and cross-store availability- Stock decant/fillingSkills Required:- Communicating effectively with customers and staff- Processing, labelling and disposal of faulty items.

Bachelor’S Degree, Commerce (Economics), Credit

Commerce Degree Contents - Macro-economic concepts - Micro-economic concepts - Australian Business Law concepts - rights.

Bachelor’S Degree (Incomplete), Mechanical Engineering, Pass

Activities and Societies: Amnesty international - Donor Mechanical Engineering - Calculus - CAD software - Fluid Mechanics - Fluid.

Education record