Shane Hartzenberg

Experience

• 

  DotActiv

  Jul 2009 - Aug 2012

  Key Accounts Manager

  1. Took responsibility of a team of senior, junior space planners and a scanner which I lead, guided and assisted in developing their skills.2. Went from a scanner taking, cleaning and renaming images including dimensions of products where after I was then promoted to a junior space planner assisting on general projects, based at L’Oréal where after I was promoted to a senior space planner servicing the likes of Amka, Aspen, Permoseal, Johnson & Johnson, BIC & Sea Harvest and finally being appointed as a Key Account Manager for Cambridge Food where my responsibilities included:• Ensured deliverance of contractual requirements for retailer-based, tactical category management processes.• I had to show excellent knowledge of space planning and the general workings of the category management industry in general as I was expected to interact with all relevant representatives at a senior level.• My team was directly responsible for the coordination, production and implementation of floor and space plans, floor and space plan analytical reviews, ranging reports and analytical reviews for all 100+ categories.• In some instances, I was required to process sales data and forward the same day to the client• Our primary aim was to maximize our client and all categories’ performance.• Optimal use of shelf and floor space was achieved by taking category strategies and plans, product financial performance, shopper psychology and aesthetic appeal into consideration. Show less

• 

  Nativa

  Sept 2012 - Jun 2015

  Category Manager

  1. Managed category management processes across all retailers developing appropriate ranges, product flows and planograms ensuring the maximum return on investment.2. Worked directly with FMCG team, third party sales agents and retailers:• Developed channel and category strategies for optimal returns.• Managed the development, presentation and negotiation of category reviews ensuring shelf space and distribution opportunities aligned with the retailer and company’s aspirations.• Drove the planning process and ensured deadlines were met and quality was assured.• Evaluated competitors and their activities in order to formulate proactive responses by performing rigorous category and channel analyses to understand existing and potential growth.• Reviewed final ranging and planograms after which I disseminated them to sales managers and agents for implementation where after I monitored launch to date performance and identified focus areas.• Managed the image, retail sales database and maintained listings for all channels.• Also generated internal sales and stock reports according to the national sales manager’s request for the improvement of sales and distribution across all channels.• After my first year, I started assisting in the trade, doing trade visits with the third-party sales agent generating better sales, identifying merchandising opportunities and ensuring general shelf health.• After assisting in the general FMCG trade and four months prior to leaving I was given the opportunity to operationally manage the entire Gauteng Forecourt division.I assisted in filtering out unnecessary agents and only retaining the essential ones.Managed successful promotions on seven impulse products in the energy tonics and sweets segments.This division made budget consecutively for those four months as well as the trimester. Show less

• 

  Ascendis Health Ltd

  Jul 2015 - Mar 2016

  Business Intelligence Manager

  1. Managed relational fields across entire database, working with a third-party trading as Gondwana Soft hosting, loading and automating the back end Qlikview interface.2. Developed look, feel and data expressions according to the business’ needs: Daily reports consisted of:• Overview: Displayed comparative year on year performance and current sales tracking versus budgets with graphics for each of the six acquired companies and combined.• EXCO: Identifying top performing products, customers & sales representatives by company and combined.• Company tracker: Identifying Company and division performance for the financial month and year to date by sales division, channel and company.• Daily sales: Tracking sales daily by rep, customer and sales division indicating sales prior, current and projected for the sales period, including sales units and values by date by company.• Daily stock: Enabled a view of products in stock as well as out of stock, specifying on hand quantities, average product rate of sale as well of average months cover with a view of months before the product and batch’s expiry.• Range & Distribution: Viewed by division, customer and product enabling a view of how many products were sold down to customer level for the specified period and the sales value. This analysis was running versus a national customer master that Ascendis could potentially sell into and identified opportunity gaps by the click of a button.• 80/20 Pareto analysis: Specifying 20% of customer’s contribution turning 80% of sales based on any criteria.• Performance Tracker: Tracked and graphically displayed regional, divisional and product performance drilling down to any specific view.• Managed pricing and authorized claims in instances where incorrect pricing was invoiced with our third-party logistics distributor.• Managed free stock with our third-party logistics distributor on request to ensure dealing parameters were adhered to. Show less

• 

  DSV - Global Transport and Logistics

  Apr 2016 - Oct 2020

  IT Specialist

  1. IBM Cognos Administrator.2. Business Intelligence Developer.3. Business Intelligence monitoring and support 24/7.4. Key liaison between internal and external BI stakeholders.• SSIS, SSAS development.• SSRS, Power BI report development.• Responsible for deployments within the SSIS, SSRS and Power BI environments.• Conducted QC testing on SSIS, SSAS, SSRS and PowerBI development.• Conducted Annual Disaster Recovery on front and back end BI Applications.• Managed Annual PwC audits for Application and Database Servers.• Monitored, repaired and coordinated daily ETL’s and IBM Cognos Schedules.• Coordinated SSRS Subscriptions.• Administrated reporting mailbox for bulk report dissemination.• Managed Active Directory / LDAP/S groups and supplied access where required internally and externally.• Managed infrastructure documentation, architecture and records for BI by making use of the MS Office suite.• Worked on documentation, preparing for data center and domain migrations.• Administrator for multiple IBM Cognos systems locally and globally.• Maintained IBM Cognos resources, content and services.• Managed server security, storage and software installations.• Coordinated availability of software, configuration data, known error databases, shares, drivers, certificates and so on for healthy and stable systems.• Monitoring and administrating of middleware related to Business Intelligence Applications.• Assisted with domain security migration, as well as LDAP/S configuration and tests.• Assisted with Application migrations between Data Centers.• Managed Cherwell service management tool for action of level 1 to 3 support.• Liaised with support teams for resolution of internal and external Application related issues.• Assisted with rebranding of All BI related Applications after the merger between UTi and DSV. Show less

• 

  Nativa

  Nov 2020 - now

  Data Operations Services Specialist

  1. IT and BI Department Manager.2. Business Intelligence Analyst.3. Business Intelligence Developer.4. Liaison between sales personnel and data administrator, technical advisor.• SSAS, Qlik Sense, Power BI modeling.• SSRS, NPrinting, Power BI report development.• Responsible for deployments within the SSAS, SSRS, Qlik Sense, NPrinting and Power BI environments.• Coordinated QC testing on SSAS, SSRS, Qlik Sense, NPrinting and Power BI development.• Collaborated with third party integration specialist on multiple projects.• Managed Annual audits on Asset related queries.• Monitored, repaired, and coordinated daily ETL’s, Power BI and NPrinting tasks.• Built a custom data mart, replicating production, ensuring optimal ERP uptime.• Compiled, streamlined, and automated monthly trade commission structures.• Coordinated the building of an initial ticketing system, enabling real time tracking.• Saved labor hours through automation, utilizing SSAS, Power BI and SSRS, creating for example order efficiency (OTIF), sale vs return ROI analysis, Debtors ageing vs sales ultimately calculating AVG debtor’s day’s cubes, and automated agent commission reports using SSRS and Power BI.• Documented known error databases and coordinated the implementation of an asset-tracking system.• Organized VISA integration and assisted with the automation of a credit card expense system.• Took responsibility for automated FMCG replenishment system uptime.• Compiled and disseminated weekly, monthly, and ad-hoc trade reporting.• Assisted with the financial budgeting and operational forecasting procedures by building simple and easily modifiable structures to have realistic comparisons vs. actual occurrences, not altering historical actual.• Prepared monthly and year-to-date budget-tracked reports for presentation to C-level management.• Created additional out of scope projects to track and enable current and potential new business ventures. Show less