Justin Pillay

Primary Activity : Data Strategy · Business Intelligence · Digital Transformation · Enablement and Data-driven Decision Making · Commercial Mindset · Innovation through AI

Key Duties:

• Accountable for BI Value Delivery across the Business
• To own and orchestrate the delivery of the Business Intelligence Strategic Vision across Currys.
• Thought leadership - Identify and Explore new innovations
• Create the future Commercial Strategy for BI including AI for BI
• Democratisation of Data and Self-Serve through Change Management
• Interface with C-level and Executive Leadership
• Deliver a high quality and fast paced agile service to our Business Leaders
• Lead a large onshore/offshore function
• Foster strong relationships with external vendors ensuring effective collaboration on key projects.
• Secure stakeholder buy-in for major organisational changes using effective communication strategies.

Responsible for setting the strategy and vision for Group wide Data & Business Intelligence initiatives reporting to the Group CTO

Areas of Remit to include:

• Strategic Roadmaps
• Building an Enterprise Data Warehouse
• C-Level Proposals
• Executive Level communications and presentations
• Manage Multiple teams
• Budgeting
• Supplier Management
• Data Governance and best practice
• GDPR Compliance
• ROI Delivery
• External Market understanding
• Analyse core KPI's
• Optimise Business units

BI Areas Include: BI Reporting/Data Insight; Google Analytics; Display Advertising; Data Science/Research; Data Warehouse and Marketing Technologies

Additional Responsibilities: Part of Haymarket Automotive Division Leadership team; Global Technology Leadership; IT Procurement technology adoption committee; DPIA approval committee with DPO and Mental Health Champion.

Lastly, to oversee/audit and advise on all Data architecture and environments across the organisation; Implement governance and processes; and focus on the efficient delivery of strategic projects.

The Head of Business Intelligence has the primary responsibility for setting the strategic vision and for managing the day-to-day tactical operations of the BI Department.

He is responsible for all tactical, operational, financial, human, and technical resource managerial responsibilities associated with BI directly to the CTO.

The main focus of this role was to deliver a brand new Business Intelligence team; BI Architecture and technology stack; and Governance/Best Practice.

Highlights include:

• Perform BI Industry research on leading BI technologies and select optimal technologies
• Architect Cloud Based Enterprise BI system
• GDPR
• Architect Data Warehouse
• Develop Data Warehouse with Talend
• Implementation of Tableau Reporting
• Gain Project approval
• Work closely with Senior Executives
• Manage numerous teams

This project was to define a BI strategy, Architect and Implement a Global

Business Intelligence Solution encompassing over 50 territories

Project Budget Scope: £ Millions

Subject Areas of the Project Include: Many CRM Systems, Global E-Commerce system and Many Social Provider Networks

Technical Management Duties Include:

• Perform BI Industry research on leading BI technologies and select optimal technologies
• Architect with Cloud specialists a completely secure Cloud Based Enterprise BI system and other areas of infrastructure
• Understand Security and Compliance around International Privacy policy regulations and Distribution of Data
• Architect with Lead ETL Developer the strategy for building the core Data Mart's in the Data Warehouse
• Develop Data Warehouse with DataStage, QualityStage, SSIS, DB2, MS SQL Server and Scripting
• Implementation of integrated reporting tool-sets: Cognos, Tableau, SSRS, SSAS
• Implementation of Data Mining/Analytics tools SPSS, Cubes
• Gain Project approval from Internal IT Project review
• Work closely with Senior Management of Director's, VP's
• Present early POC to Senior Management, CIO
• Work in the scope of both structured data and Big Data

Strategic/Business Management Duties Include:

• Manage multiple stakeholders including Multiple Heads of Marketing, VP's in E-Commerce, other Senior Stakeholders
• Perform Business workshops in order to ascertain high level Business requirements and scope
• Sign-off documented Business requirements and manage any changes/expectations
• Perform numerous Strategic Presentations, including business road-maps, feasibility reviews, progression updates and other project areas
• Perform Data Quality Exercises
• Manage Progress of Project from start to finish
• Manage ongoing support and new requirements
• Deliver Global Reporting System and Analytics engine
• Maintain high level of confidence and responsibility though efficient management of Risks and Assumptions.

This role was to Project Manage the Global CRM Marketing Technologies team and to architect a new Group Cloud BI solution on top of this CRM system ( With additional systems).

Highlights:

• IT Project Manager for international CRM system using Neolane (Adobe Campaign)
• Project manage data migrations for over 30 countries to Neolane
• Liaise with Directors of Marketing/IT to architect all platform improvements in accordance with current and future marketing strategy
• Architect Tier 1 territories migration strategy within a multi lingual capacity
• Project Manage BI Warehouse strategy for CRM( To include future implementation BI Warehouse)
• Implementation of IT policies to manage and support all marketing territories.

Misys is a leading multinational software company providing software solutions and services to the financial services and healthcare sectors.

This contract is specifically with ING Belgium and ING Holland. The aim of the project is to implement trading software ‘Summit' and ‘Cognos' for both reporting and analysis on all trading activity.

Client: Investment Arm of ING Belgium and ING Holland

Main Duties Included:

• Establish new Cognos environment
• Conduct Business analysis and develop Proof of Concept for the client
• Project Management of other Cognos resources and partner software firms
• Building of various trading reports
• Conduct Reporting Requirement/Design Workshops (up to 30 stakeholders)
• Coordinate/Liaise with international project team.(Warehouse team in NY, Analysts in Paris, Client in Belgium and Amsterdam)
• Use Cognos 8.4 Reporting tools
• New Framework model developed in both relational and dimensional layers
• Building of SWAP reports, Adjustment tools, Audit reports, Complex book structures etc)
• Coordinate and submit official benchmarking for all Cognos areas
• Working with a large volumes of financial data
• Large international Project with collaboration from many countries.

This Role was primarily to perform Data Analysis:

• Business requirements and design
• Data analysis and design of multiple systems
• Data mapping
• Strong involvement in different types of e-commerce platforms
• Project Management
• Testing and Implementation of large systems

Focus is a BI consultancy firm that has been Cognos's partner of the year four years running in Australia. It specialises in offering Cognos consulting services to all mid to large size organisations

Sample of client work included:

• Virgin Broadband - Consulting on Cubes and Security
• Department of Education - Building of Board Reporting Transformer Cube and Board reports via Report Studio
• Sanofi-Aventis (Pharmaceutical) - Made major changes to their Data Warehouse using Cognos Decision Stream. The data warehouse was a snowflake warehouse on Kimball standards
• MTU Detroit Diesel (on Behalf of IBM) - Build a Data Warehouse from Oracle ERP Financials; as well as implementation of procedures and maintenance.
• Australian Investment and Securities Commission (ASIC) – Government body that regulates all companies in Australia. Delivered Cognos 8.4 training in each of the Studios. Acted as Lead Consultant on reporting and warehousing. This solution incorporated TM1.
• WorkCover Australia (Government body that covers all workers injury compensation)– Acted as Reporting and Data Warehouse Lead Consultant. Included High level Project Management; requirements gathering and design for both the Data Warehouse/Reporting.

IAG is Australia's Largest and Premium Insurance Company.

Working as part of the Management Information Department. This Department governs the business Intelligence reporting for the entire company.

Main duties of the role include: for the creation; automation and maintenance of all financial reporting. IAG is one of the largest Cognos sites in Australia.

Main duties of the role include:

• Project Management
• Business Analysis: Execution of an array of different project designs. These have a high degree of standard due to the accuracy/sensitivity of the data we work within
• Documentation: Very familiar with standard project documentation and protocol. E.g. UML
• Data Analysis: Skills in identifying data issues and manipulating data (SQL)
• ETL: Have become proficient in working with Cognos Decision Stream.Types of DS work included: Jobs to populate the warehouse; validate contributor; complex dimensional lookups; or connect to other systems e.g. SAP; Contributor; Analyst; TM1.
• Data Modelling: Have used dimensional reporting tools like Cognos Transformer as well as Cognos Impromptu to write and model reports
• Data warehousing: Familiarity with working in very large star schema environments. These warehouses contain international data and are in accordance with Kimball standards
• Databases: Working in many different database platforms. Oracle, MS SQL Server
• Working Flexible hours: During forecasting and budgeting cycles I have been on call overnight; and have worked throughout the night if any issue had arisen
• Working on large international projects
• LDAP Security: Working in very secure environments from web portals to Individual report security. For example: Cubes having security at a dimensional level
• COGNOS 7 Installations: Have set up whole environments over multiple servers
• Cognos 8.1: Completed training in COGNOS 8.1
• Worked on a large upgrade project from Cognos version 7 to 8.1. This included upgrading multiple reports and redesigning the data warehouse.

APS is an international accounting software firm in which over 70 of the top companies in Australia use. It ranges from management software to high level cube based reporting

Role Includes:

• Assisting in generating Month end/Year end reports for clients
• Reconciliations of WIP and Debtor ledgers as part of month end procedures
• Knowledge of WIP and Debtor Audits
• Tax knowledge of all types of returns and forms
• Budgets and productivity reports
• Minor customisation of cubes
• Writing SQL Scripts for consultants, helpdesk to implement on large MS SQL Servers
• High Knowledge of Operating Systems and MS Office
• High Understanding of Databases and ODBC Connections
• High Knowledge of MS SQL Server and MS Access: Including the writing of views, triggers, queries, and user rights
• Working with new technologies: APS products are .NET applications
• Various on-site consulting activities at medium sized accounting firms. Such as conducting training sessions on reporting and processes.
• Liaising with Senior Managers/Clients from the top 70 firms in Australia: Including liaising with senior managers and partners from firms like KPMG.
• Very close contact with the ATO, and integration of our software and “Elite tax software”
• Conduct internal training sessions for the IT helpdesk
• Responsible for the confidentiality of very important data
• Responsible to reconcile/fix reports and taxation returns of very large sums. Into the Hundreds of millions of dollars
• High level of customer service and communication skills
• Ability to work within a tight knit team environment
• Writer of documentation for Taxation processes and Visual Basic Customisations.

Accountant for family Business.