Anthony Apollis

• Working with large-scale agriculture data to develop insights for improved crop management and logistics.

• Developing data pipelines, cleaning and analyzing data from IoT and remote sensing systems.

• Leveraging Python, SQL, PowerBI and SSIS.

• Engage and own the key relationships with stakeholders across the regions within the specific function/s within their portfolio as the BIRE SME in the function.
• Translate complex business requirements into actionable user-friendly business intelligence products to support the IMETA, BIRA, regional and functional strategies and decision making.
• Translate complex data from multiple data sources into information and insights to drive decision making at several levels i.e. data driven decision making.
• Design, develop and deploy advanced ETL solutions to extract data from several data sources, transform and load into the warehouse (Amazon (AWS) RDS).
• Leverage best practice in deployment of business intelligence solutions.
• Design, develop and deploy reports/dashboards and data products as per business needs in IMETA (ensuring data accuracy and stability). Also accountable for what products are deployed into the functional BI Product Suite and ensuring they align with the functional strategy and regional strategy.
• Drive best practice implementation to improve the product offering to business stakeholders.
• Lead strategy initiatives uncovering opportunities based on data trends.
• Complete required documentation for reports/dashboards/data products created to ensure knowledge management best practice are met.
• Tools: SSIS, PowerBI, Bracs, SAP BW, Postgres & T-SQL(Microsoft SQL Server)

• Anthony’s serving as a Senior Digital Analyst and Cloud Data Engineer using Google Bigquery as our cloud database and Google Campaign Manager, Display & Video 360 as data sources.
• His roles include Modelling data for marketing and cloud applications.
• Design and implement data modelling solutions and design bespoke databases to enable data as an asset; translating business intent into concrete blueprints for the data environment.
• Using ETL/ELT tools like Talend, Data Fusion and Five Tran to build data pipelines and Google Cloud - Bigquery as destinations.
• Work with management to define Objectives, Goals and Key Performance Indicators for digital properties and specific campaigns.
• Interpret data, analyse results using statistical techniques and provide ongoing reports.
• Monitor user behaviour and marketing campaign performance over time, making recommendations to optimise.
• Identify, analyse and interpret trends or patterns in complex data sets.
• Work closely with the digital marketing team to understand our digital customers.
• Produce accurate daily, weekly, and monthly reports and explain movements and trend.
• Track and review performance of all areas to ensure targets are met.
• Leverage the data to find new ways of looking at customer behaviour and solutions to business challenges.
• Run ad-hoc in-depth analysis across different data sources.
• Understand the business process to create new analyses highlighting improvement areas.
• Develop analytics to review resource planning and discover opportunities to increase efficiency.
• Work with BI and Product owners to find automated solutions to streamline operational processes.
• Work closely with management to prioritise business information and data.
• Locate and define new opportunities for process improvement.
• Reporting is done with Tableau.

• ETL (Extract, Transform & Load) data files in various formats from the client’s server etc. with SSIS.
• Attending meetings and workshops at clients to gather requirements for data transformation, data visualization, etc.
• Populating Meal Ordering & Survey App with data (training and assisting users with technical issues.
• Edit, Verify, and view data in SQL Server and Tableau Dashboards.
• Servicing clients in health, pharmaceutical, logistics and retail.
• View links below:
• Https://drive.google.com/open?id=1Z9Nl3F-UF9C9xfAy46WFUmZHpNk7Umdg
• Https://drive.google.com/open?id=1M-vDkmpDuEm9VGyZSlhS7G9UYNBv-CK1
• Https://drive.google.com/open?id=1x2P3c15j9w3D2I5nzT5F2RQw2QYkHABq
• Tools Used: Tableau, Microsoft SQL Server, SSIS

• Establish GIS Data Governance Standard which includes:
• Master Data, Cleansing Data, Data Migration and Data Quality Control.
• Create documentation for users on new PlanetGIS System.
• Creating Digital Maps with PlanetGIS.
• Digital Maps includes:
• Solar Energy Maps, Local Municipality Maps, (LUMS)Land Use Management System Maps
• Farming Maps etc.
• Work of Geo-Intelligence (Better decision for Agriculture, Solar Farms, Ecology etc.) can be viewed here:
• 1. https://drive.google.com/open?id=16ZCmogdj8WyQGHnGZ05Q4FKh4_IoKHk6
• 2. https://drive.google.com/open?id=1Y0bDdrhjKXzzgH4KM7-rj4gKQGkDz0V
• 3. https://drive.google.com/open?id=1PgAQKpR6oNLkc-gTquGnz41h3Ompg5Vk
• 4. https://drive.google.com/open?id=1FyZMQ5WjinBaPg5qrFgxDntlCJ9HPd7v2
• 5. https://drive.google.com/open?id=1MmcFkBbC143e0d5cG-BV6rfqnaGZ_aZp

• Populating Child Friendly South Africa App with data (Available on Google Play and Apple store)
• Capturing Data according to best suited categories and mobile design principles.
• Cleansing Data and finding discrepancies
• Testing Mobile App for display, data and image quality and UX.
• Capturing and Testing Geo coding for easy and correct location display.
• Brainstorming ideas for best SEO/SEM, Digital Marketing and Data Design principles.

• Analysing large amounts of master data, interpreting the results and arriving at actionable conclusions.
• Understand GS1 master data standards and are able to apply it to article data as required.
• Assuring the integrity of master data while performing duties including data extraction, manipulation (cleaning/transforming), validating, processing and analysis.
• Collecting and collating appropriate master data for usage in spreadsheet documentation and related analytical requirements.
• Present findings and translate data into understandable document formats.
• Identify gaps/issues in operational master data Identify proactive mechanisms to detect errors in master data and quality assurance processes recommend opportunities for data cleansing and improvement of data quality.
• Work with data transformation teams to assist in the coordination of data models, dictionaries and other master data management systems.
• Completed SAP Buyers Training Course:
• Article Creation, Article Maintenance, Listing, Local Pricing, Export Pricing Promotions, Bonus Buys, Price Surveys and Tallies.
• He has been part of Shoprite’s COR 3 Project. Been practically involved with SAP Business One/ERP and been exposed to Microsoft’s SSIS.
• Tools Used: SAP Data Services, SSIS

• Working with BIG DATA in the Telecommunications Environment.
• Been working with Vodacom’s Big Data in Teradata Database. Doing Post Implementations Checks (PIC) in production.
• Updating changes to records on SharePoint.
• Using Oracle Data Integrator (ODI - ETL) to move data from Source to Target (From Staging to Integration Layer etc.)
• Programming Teradata SQL using SQL Assistant to collect results sets.
• Tools Used: SharePoint, IntelliSphere, SQL, Python, Power BI, Qlik Sense, QlikView

• Working in different departments, ranging from the data department (sources and collecting data to populate the Kalahari.com website).
• Also involved in the Marketing department (doing competitive research on social media and report findings and looking at marketing strategies (Digital and Campaigns-PPC).
• Attending seminars like (Content 2013, to the point, Music Exchange & Net Prophet etc.) on a regular basis to keep up on what is happening in the Digital arena and Content Marketing.
• Liaise with an external digital agency to ensure delivery of all performance media assets on time and in line with the approved digital media plan.
• Brief all digital content requirements into the design studio in accordance with agreed lead times.
• Work closely with community managers to actively seek out and act on engagement opportunities within our online communities.
• Leverage & incentivize user-generated content on channels through the ideation and execution of competitions, giveaways, or potential brand partnerships.
• Assist in creating an annual marketing plan, incorporating seasonal factors and key sales periods plan.
• From an SEO perspective, doing keyword research (category research from competitor’s websites) and try to optimise the Kalahari.com and Price check website.
• Using Google Analytics and Google AdWords as primary analytics Tools.
• Uploading product/price/ stock data via XML or CSV feeds.
• Day-to-day review of Product error reports # Assisting with product data queries
• Managing the support system (being in contact with merchants about their products and data feeds). Assigning products to relevant categories and making sure it adheres to SEO and SEM Friendliness.
• From an SEO perspective, doing keyword research (category research from competitor’s websites) and try to optimise the Kalahari.com and Price Check website.
• Using Google Analytics and Google AdWords as primary analytics Tools.
• Tools Used: Google Analytics, XML, Microsoft SQL Server

• Project Administrator in the marketing department at Stellenbosch University.
• Tasks varied from admin to marketing.