Rob Micklewright Email & Phone Number

London, England, Gb

London, ., Gb

Extended scope to include data architecture and data governance functions including recruitment and stand up of team to support these pillars.

London, ., Gb

Leading the Data & Analytics function globally for the Dr Martens brand with a team of data engineers and reporting analysts to support the design, development and business department implementation of the Analytics solution.Primary responsibility to manage the data sourcing, staging and quality through to analytics solution delivery, governance, documentation and compliance.Responsible for defining the strategy, road map and architecture of the Data & Analytics function, with achievements to date including:Implementation and enhancement of Azure hosted SQL data warehouse and analytics solution in line with global deployment of Microsoft D365 Finance & Operations. Successful project go-lives in EMEA, Americas and HK regions in parallel with other business transformation projects.Coordination of all D&A team activities and development backlog planning.Management of data and analytics engineering and analyst resources to :Implement Azure Data Factory pipelines for ETL, data ingestion and integration. Logic Apps and tabular data model processing.Analysis Services tabular data model development and deployment to provide analysis capability across retail, eCom and wholesale sales channels, inventory, procurement, distribution and finance.Google Analytics and Supermetrics integration to support digital and eCom teams.Deployment of Power BI as presentation layer tool with associated requirements gathering, development and support of report and dashboard packs.Engagement of business super users across departments to help foster an active community with Power BI skills working closely with the Analytics team.Use of Azure DevOps and git source control to manage source code repository, sprint planning and release.

London, England, Gb

Brand evangelist for BI, providing a vision and driving adoption throughout the department user base. Management of the BI team: facilitating requirements elicitation, management of development priorities and activities through to handover and end user support.Working closely with Richemont teams to design and enhance BI capability.Ensure seamless brand reporting capability during challenge of split of ERP/BI system use in markets until SAP rollout complete.Responsibility for the broader overall business framework of business processes, ensuring alignment between brand functions.Working closely with the SAP process manager to ensure clarity from organisation structure level down to transaction entry and BI reporting capability.Identifying opportunities for further improvement and optimisation of business processes.

London, England, Gb

dunhill BI Solution Architect and assigned BI key user for brand project that started in September 2015 integrating dunhill into the Richemont SAP template.Responsibilities include:Definition of the BI requirements for fashion and accessories brands to ensure template reports fit business need.Training of all brand central back-office and retail boutique users in SAP BEx Web and Excel add-in tools.Assigned as brand key user for BI in Richemont project that started in Sept 2015 integrating dunhill into the group SAP template.Responsible for confirming BI requirements for fashion and accessories brands to ensure SAP template enhanced to fit business need throughout assessment, implementation phases through to testing and post go-live support.Development of Power BI report dashboards using Power Pivot and Power Query to provide visualisation capability, complimenting and addressing gaps in the group standard SAP BEx Web reports.Member of the brand change management and business process review core team during the SAP project responsible for reviewing, documentation and assessment of gaps and open issues in the merchandising, allocation, supply chain, e-commerce, finance and sales processes.Brand key user for Yoox e-commerce integration into SAP template.

London, England, Gb

Business Intelligence Solution Architect for the dunhill brand managing a team of BI developers, with responsibility for the support and development of the centralised BI environment supporting users in all dunhill global markets.Deployment of Cognos presentation tools with standardised report content to UK head-office and Japan, China, APAC and EMEA markets in-line with M3 ERP rollout project.Provided a brand single version of truth for reporting by replacing end user manual file based reporting leading to increased efficiency within department teams, notably merchandising.BI requirements gathering and agreement activities at all levels from operational user to director level. Design and development of reporting content for head office and regional merchandising, finance, logistics, marketing, e-commerce, retail, wholesale and supply chain departments.Design, development and deployment of reporting and analysis using Cognos 10 with dimensionally modelled packages and powercubes. Professional standard reports using Report Studio.Development of SSIS packages and procedures to manage the ETL of data from multiple brand data sources including ERP, Excel and e-commerce platform.Development of fashion brand reporting and KPI's including: brand sales by market/channel versus budget, weekly/monthly sales performance by category, retail footfall/ASP/UPT/cross-sell KPI’s, stock valuation and provision and margin analysis. Development of merchandising reporting and analysis including: sell through analysis, sales and stock analysis by market and site, product best/worst sellers, open orders, model stock and seasonal buy analysis.Development of production and supply chain reporting including: product delivery to market, supplier performance and lead time analysis.Design and development of CRM reporting solution to support customer status, segmentation, level of engagement, lifecycle and spend history analysis.

New York, Ny, Us

Business Intelligence consultant working with extensive travel to clients across Europe and the US in Service and Rental, Maintenance, Fashion and Food & Beverage verticals implementing data warehouse and reporting BI solutions. Work in this role included requirements gathering, data warehouse design, datamart/cube/report development, project management and training of customer business users.Classroom course instructor in the Lawson Business Intelligence (LBI), Business Performance Warehouse (BPW) and ProcessFlow Integrator (PFI) applications with onsite project work with clients across Europe and the US.Subject matter expert in the Lawson business process automation application ProcessFlow Integrator requiring a close working relationship with product development for the escalation of issues and support of enhancements.

New York, Ny, Us

Business Intelligence consultant, primarily onsite at clients across the UK and Europe focussed on the development of data warehouse solutions using Lawson Business Performance Warehouse (BPW) and SQL Server. OLAP cube development using Analysis Services and report development in Crystal Reports.Issue investigation and resolution for clients in across the BI application stack.

Graduate position with core role responsibilities including :- Onsite customer facing development activities and trainer of courses covering business document development applications.- Data migration consultancy, managing the planning, migration and testing of data from client legacy systems to Movex M3 using API, web services and SQL.- Technical developer using Java and Javascript.