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.

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:

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:

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:
• Liaise with local and overseas suppliers to maintain on time supply of product. Produce long term production forecasts for our manufacturing partners.

• 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:
• 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.

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:

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:
• Liaise with the customers (including Otis, ECC, EPL, Schindler) to schedule production and deliveries according to the specific site requirements.

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