Peter Smart Email & Phone Number

Milton, Qld

Milton, Qld

Working with MS BI stack to provide whole of business intelligence, analysis, and system automation.Integrating Dynamics 365 CRM, Sage ERP, AWS, and other data source to populate a datamart to provide a holistic business intelligence view.Developed SSAS cubes to allow rapid analysis for managment.Developed a full SSRS suite to provide users simplified analytical and exception reporting.

Brisbane, Australia

Providing BI Solutions for some fantastic clients.Data Integration with AccPac, SAGE CRM, MS DynamicsData Warehousing OLAP, SSRS, and MS Office integration

Browns Plains

Key responsibilities: • Expand existing and develop new Business Intelligence solutions.• Responsible for the management of the BI SQL servers. • Develop and maintain solutions using SQL SSIS, SSAS and SSRS. Extend the SQL tools using MDX and .NET programming where necessary.• Responsible for the maintenance of the OLAP cubes and the development of new cubes in response to new BI initiatives.• Promote and develop business reporting methods using various BI tools – including… Show more Key responsibilities: • Expand existing and develop new Business Intelligence solutions.• Responsible for the management of the BI SQL servers. • Develop and maintain solutions using SQL SSIS, SSAS and SSRS. Extend the SQL tools using MDX and .NET programming where necessary.• Responsible for the maintenance of the OLAP cubes and the development of new cubes in response to new BI initiatives.• Promote and develop business reporting methods using various BI tools – including SharePoint, Performance Point and automated Excel reporting.• Work with Businesses to develop new business simplification methods and tools. Utilise InfoPath, SharePoint, BizTalk and interfacing with SQL server where necessary to provide detailed reporting or upload facilities into the Pronto Oracle ERP system.• Develop K2 Workflow solutions to provide automated forms and request process flow solutions.• Provide support and maintenance oversight for the FPOS Freight Management/Despatch software for the L&D and Scott Safety businesses.Key achievements: • Developed the Wormald KPI suite delivering ahead of schedule. This is a real-time dashboard now utilised by the service business to accurately monitor their activities.• Successfully redeveloped the staff leave process and workflow program. This change in process has provided savings of over $300k p.a. in reduced leave leakage.• Successfully completed Tyco Six Sigma Green Belt certification. The certification projects involved use of many of the Six Sigma tools, creating and managing project teams, and creating automated reporting programs to measure and control the process improvements.• Successfully developed an ASP .net web program to provide accurate freight vendor selection and costing of freight despatches for all RDCs.• Liaised with the National Distribution Manager and Finance teams to successfully produce a suite of financial management reports using SSRS. Show less

Cannon Hill

Key responsibilities:• Work with the businesses to develop reporting solutions using the newly purchased Microsoft SQL • Business Intelligence suite.• Responsible for the management of the BI SQL servers.• Work with the Finance Team to develop efficient, accurate, and comprehensive reporting.• Liaise with the business teams – Logistics and Distribution, Tyco Traffic, Scott Safety, Fire Detection – to develop reporting processes using a combination of OLAP and SQL data… Show more Key responsibilities:• Work with the businesses to develop reporting solutions using the newly purchased Microsoft SQL • Business Intelligence suite.• Responsible for the management of the BI SQL servers.• Work with the Finance Team to develop efficient, accurate, and comprehensive reporting.• Liaise with the business teams – Logistics and Distribution, Tyco Traffic, Scott Safety, Fire Detection – to develop reporting processes using a combination of OLAP and SQL data sources.• Install and maintain the Freight Management/Despatch software for the L&D and Scott Safety businesses.Key achievements: • Developed a Freight Management Costing Suite to automatically load supplier invoices from email, calculate the allocation of costs to the appropriate business unit and reporting to the L&D and Business Unit Managers in web based, subscription or excel formats.• Developed a PPV report to provide real-time information on the status and profitability of indent shipments for the Scott Safety and L&D businesses.• Successfully completed the implementation of the FPOS freight management solution into the Brisbane, Perth and Auckland (NZ) Regional Distribution Centres. • Liaised with the National Distribution Manager providing analysis of historical freight movements against tendered rates to facilitate selection of the most cost effective freight companies for national use by Tyco. Worked with the National Distribution Manager to achieve a saving, for the company, of over $250k pa.• Worked with the Tyco Traffic business to successfully develop the data collection and reporting system which tracked current and historical location of bus OBUs and associated hardware. These reports are available online to the NSW Roads and Traffic Authority via an external web portal. Show less

Cannon Hill

Key responsibilities: • Manage distribution facilities in Brisbane and Mackay to provide a safe workplace and efficient, timely supply of product to the Wormald and ADT businesses in Queensland.• Liaise with the other Tyco Regional Distribution Centres throughout Australia to ensure appropriate stock holding to meet product demand.• Forecast, plan and order product to ensure on time supply for our customers.• Liaise with local and overseas suppliers to maintain on time supply of… Show more Key responsibilities: • Manage distribution facilities in Brisbane and Mackay to provide a safe workplace and efficient, timely supply of product to the Wormald and ADT businesses in Queensland.• Liaise with the other Tyco Regional Distribution Centres throughout Australia to ensure appropriate stock holding to meet product demand.• Forecast, plan and order product to ensure on time supply for our customers.• Liaise with local and overseas suppliers to maintain on time supply of product. Produce long term production forecasts for our manufacturing partners.• Ensure accurate inventory record keeping to legal and corporate requirements. Key achievements: • Designed and implemented a national forecasting system resulting in a saving of 12 work days per month for State Planners. Automated this using ODBC connections to the Pronto ERP system. • Successfully implemented cycle counting and reporting programs to maintain an absolute stock accuracy of over 99.7% eliminating the labour intensive requirement for quarterly wall to wall stocktakes.• Successfully managed the relocation and consolidation of the Wormald and NFS warehouses from Archerfield and Newstead into the Cannon Hill facility.• Managed existing slow moving and obsolete stock which increased the inventory stock turns from 2.5 to 6.2 by implementing a rigorous stock movement analysis program coupled with strong accountability measures for new product ranges. Show less

Key responsibilities:• Develop systems to forecast and plan indent purchasing for the newly sourced products from our manufacturing plant in USA.• Manage distribution facilities in Archerfield to provide a safe workplace and efficient, timely supply of product to the Wormald businesses. • Maintain records and processes to ensure continued ISO9002 accreditation.Key achievements:• Designed and implemented a semi-automated forecasting system to import data from an existing… Show more Key responsibilities:• Develop systems to forecast and plan indent purchasing for the newly sourced products from our manufacturing plant in USA.• Manage distribution facilities in Archerfield to provide a safe workplace and efficient, timely supply of product to the Wormald businesses. • Maintain records and processes to ensure continued ISO9002 accreditation.Key achievements:• Designed and implemented a semi-automated forecasting system to import data from an existing MRP system text based reports. This eliminated days of repetitive data input into the forecasting systems each month.• Worked alongside the IT project team on implementation of the Pronto ERP system within Wormald Fire Systems warehouse, including the extraction and migration of warehouse inventory data from the existing MRP system.• Successfully simplified the distribution process documentation as part of ongoing ISO9002 accreditation. Replaced a complex and cumbersome Process Instruction manual (in excess of 150 pages) with a 10 page manual consisting of easily comprehensible flowcharts.• Produced CAD manufacturing and product overview drawings for locally manufactured products, which facilitated consistent supply to ISO9002 standards. Show less

Newstead

Key responsibilities:• Manage the Fire Protection production facility to ensure a safe and efficient workplace that meets the production targets.• Maintain ISO9002 certification for the production of Australian Standards certified products.• Manage the gas cylinder test station and its ongoing NATA accreditation.• Manage the warehouse to ensure accurate inventory records, and distribution of stock to the regional branches.Key achievements: • Successfully established… Show more Key responsibilities:• Manage the Fire Protection production facility to ensure a safe and efficient workplace that meets the production targets.• Maintain ISO9002 certification for the production of Australian Standards certified products.• Manage the gas cylinder test station and its ongoing NATA accreditation.• Manage the warehouse to ensure accurate inventory records, and distribution of stock to the regional branches.Key achievements: • Successfully established the Newstead, Brisbane production facilities to manufacture fire hosereels and extinguishers to Australian Standards, under ISO9002 certification.• Undertook recruitment of suitably competent staff to work in a team environment to achieve productivity goals within project time lines.• Developed induction and training of new staff to ensure company policy and procedures were engaged in work practices.• Successfully implemented appropriate stock controls throughout the production facilities.• Reduced an annual stock loss from over $100K per annum to less than $1K per annum by instituting proper physical security as well as strict operating procedures for the issuing of stock. Show less

Auckland, New Zealand

• Managed the engineering design and drafting team• Performed Cost Analysis on existing products and redesigned where possible to facilitate more efficient production methods and using lower cost materials.• Led the Design team in developing new products under ISO9001 standards.

Auckland, New Zealand

Key responsibilities: • Manage the sheetmetal production facility to ensure a safe and profitable workplace that met the demanding delivery requirements of the elevator industry.• Produce detailed working drawings from architectural plans to allow production of the elevator hardware (lift body and interiors, doors and architraves).• Schedule staff labour, subcontractor and material supply to meet the required delivery program.• Liaise with the customers (including Otis, ECC… Show more Key responsibilities: • Manage the sheetmetal production facility to ensure a safe and profitable workplace that met the demanding delivery requirements of the elevator industry.• Produce detailed working drawings from architectural plans to allow production of the elevator hardware (lift body and interiors, doors and architraves).• Schedule staff labour, subcontractor and material supply to meet the required delivery program.• Liaise with the customers (including Otis, ECC, EPL, Schindler) to schedule production and deliveries according to the specific site requirements.• Liaise with subcontractors to maintain on time deliveries according to the production schedule.Key achievements: • Supervised up to 25 production staff both in the factory and on building sites.• Became SME for the manufacturing module during the implementation the TIMS ERP system.• Developed key reports for the business using the TIMS ERP system.• Developed the site installations team to take advantage of the increasing elevator refurbishment market.• Initiated more efficient manufacturing processes and equipment, including CNC presses and punches, job specialisation, and production line assembly. Show less

Masters Of Information Technology

Bachelor Of Engineering, Mechanical Engineering, First Class Honours

K2 Workflow Development

Microsoft Business Intelligence

Installing, Developing and Maintaining SQL Server - Integration Services, Analysis Services and Reporting Services (SSIS, SSAS and SSRS)

New Zealand Certificate Of Engineering, Production Engineering