Ash T.

Power Bi Developer @SMT GB

Provide information on new machine pipeline and order status through CRM & ERP; combine with market data to support market share intelligence.Analysis of existing aftermarket portfolio (Profit analysis, CSAs performance, Extended warranty performance, Parts and Labour sales) to highlight key trends and opportunities.Proactive parts pricing monitoring using lost sales analysis and other market intelligence to support the negotiation of optimum supplier agreements with OEM.Study of existing machine population to identify aftermarket parts and service sales opportunities and help formulate aftermarket sales strategy with the Commercial development team.Creation of appropriate KPIs and dashboards to help drive and reinforce functional objectives both on Commercial growth and operational efficiency as per Company Data Strategy.Customer analysis and ranking to provide clarity on total customer loyalty and overall customer portfolio profitability.Production of financial reports to drive Company performance.Development of competitor market intelligence.Support the development of CareTrack machine usage with internal and external customers to maximise the downstream parts and service potential. Building relationships with key business stakeholders to support requests and maintain existing reports. Extracting data from multiple datasets, transforming and loading (performing ETL process within Power BI).Create Role Level Security to support limit relevant information to Regional Management Structure.Migration specialist - Migrate Power BI to Group domain