PERSONAL DETAILS:

SURNAME : Gerber

FULL NAME : Hendrik Mathys

NAME KNOWN BY : Henk

HOME ADDRESS : ** ****** ****, *** **** Lane, Faerie Glen, Pretoria Gauteng, 0043

TELEPHONE : +27-76-270-****

LINKEDIN PUBLIC PROFILE URL : www.linkedin.com/in/henk-gerber-a924ba40

DATE OF BIRTH : 3rd of November 1971

ID NUMBER : 711**********

NATIONALITY : RSA

DRIVERS LICENCE : Code 8

SEX : Male

LANGUAGE : English

Afrikaans

HEALTH : Excellent

CRIMINAL OFFENCES : None

DISABILITIES : None

HOBBIES : Badminton, Cricket, Golf,

Travel (did freelance work in London UK)

CAREER DETAIL

Company Name: M Stores (Pty) Ltd

(Retail)

Employment Period: Jan 2015 – to date (5 Years)

ERP System: Select MS Dynamics

Position: BI Analyst & Developer and Product Support Administrator

SQL 2008/12/16

Perform database administration, maintenance, performance tuning, security, and troubleshooting.

Develop, maintain, perform, and test database backup and recovery strategies and procedures.

Provide proactive performance monitoring, and capacity planning for future database and server growth.

Design, evaluate and recommend best practices for database models and architecture.

Collaborate with business users to understand their analytic objectives and business needs to develop requirements and plans for data warehouse projects.

Facilitate and encourage wide-spread adoption of and innovation in the use of the data warehouse.

Lead and perform technical work activities, including logical data modelling, physical data modelling, data flows, software installation and configuration, code development, stored procedures, decision support, batch job scheduling, database backup and recovery process, connectivity and security, performance monitoring and tuning, testing (unit, integration, and performance), disk space management, software patches and upgrades, automation of manual tasks, problem support, and technical troubleshooting.

Business Intelligence Analyst

Produce accurate, reliable and timely reports for all levels of the company, keeping a strong focus on quality, completeness and accuracy of reporting data.

Analyse data, interpret the results and provide written summaries of the analysis.

Assist other business units (through coaching and sharing of knowledge) in the development and production of departmental reports.

Gather reporting requirements from business users and create/enhance reports to meet these requirements in cross functional projects and strategic developments.

Create and update documentation in relating to the reports and business logic.

Train end users in the use of reports.

Assure the integrity of data, including data extraction, storage, and manipulation and processing.

Reporting Duties (SSRS)/Qlik

Responsible for two broadly categorised types of reports described as being operational and analytical in nature. Operational reports are based on OLTP sources and are static in nature while Analytical reports are based on OLAP sources and generally facilitate drill-down and drill-through for analysis.

A large number of the reports are flexible to manipulation by users and accept parameters from users to fetch and report data conditional to the input made. Some reports using OLTP sources are static in output and some using OLAP sources facilitate drill-down and drill-through for analysis. Most of the reports are based on multiple datasets and require input parameters to populate the body of the report. Customisation codes by the user are sometimes and essential requirement to delivery. All Reports are Chart based reports using graphical representation. Reports are published on the VPN website

Key Performance Areas

1.Providing decision-making data that enable the business to intrust with confidence of the available information at all times

Ensure that our data are kept safe, reliable and are hosted with utmost integrity

Analyse business and functional requirements throughout the business from a data and BIS Point of view

Design and develop BI reporting as per business unit requirements

Design and develop in-house development software required to effectively support the business requirements

Investigate into leading market data tools such as Qliksense

Stress test all data and ensure that data are always accurate and balances

2.Safeguarding of MIS and ITC Infrastructure to ensure that there is reliable back-ups in case of relapses in the system.

Ensure that all data and software are sitting behind a secure firewall and protected from Malware and unwanted traffic/visitors

Ensure that all servers are equipped with Anti-Virus software and safe from attack

Ensure that data are kept safe and accessible at all times

3.Providing product support the business units making use of BI and In-house developed software.

Ensure that effective and immediate support is given on all in-house developed software and BI reporting

Ensure that data, reports and software are always readily available and online

Motivation for change: Company is Restructuring.

Company Name: Spacefinder Properties

(Industry Property Specialists)

Employment Period: Jan 2014 to Dec 2014 (6 Months)

ERP System: Select MS Dynamics

Position: Commercial/Industrial Broker (Part-time)

Lease and sale negotiations

Investment sales

Site selection and analysis

Landlord and tenant representation

Corporate solutions

Development solutions

Province, district and suburb analysis

Supply and demand trends

Unit size and grade segmentation vendor

Relations management

Motivation for change: I realized that the opportunity to grow wasn’t available to me and that in order to continue to improve myself professionally, it was time to move on.

Company Name: Nashua

Employment Period: Jan 2007 – Mar 2014 (6 Years and 3 Months)

ERP System: Select MS Dynamics

Position: Solutions Consultant/Manager Software & Office Automation / Sales Executive for PABX & ECN – Winelands (01 Apr 2013 – Mar 2014)

Responsible for software solution sales.

Product marketing & training.

Services including but not limited to training of sales staff.

Sales documentation: product templates, ROI, Vertical focused solutions, case studies etc.

Provide consulting services and pre-sales support.

Solutions sales for Business process optimization, content management, legal cost recovery, specialization in managed print services and managed document solutions.

Scope and design solutions.

Identify opportunities.

Scope of work.

Project management.

Sales support.

Product development.

Vendor relations.

Total cost of ownership.

Motivation for change: I had to leave due to family or personal reasons.

Position: Key Accounts Manager Office Automation / Sales Executive for PABX & ECN – Cape Town

(Jan 2012 – 31 Mar 2013)

Administer all day-to-day activities, at a more senior level.

Establish and maintain a productive communication with the clients.

Assist in the delivery of services to the clients.

Ensure a smooth and timeous workflow of activities directed at the clients.

Write contact reports and forward these to the client within 48 hours after every meeting.

Write status reports for each account.

Forward recommendations and analyses to the client.

When required - assist that client's accounts are correct and that payment is effected timeously.

Ensure a smooth and timeous internal workflow.

Work with other departments to ascertain timetable through actual production and final presentation.

Must be able to work across multiple accounts.

Assume day to day running of the accounts.

Build strong relationships with clien.t

Manage client expectations and be able to push back where necessary.

Demonstrate good time management.

Ensure key contacts are aware of the status of work in progress at all time.

Achievements

Feb 2012 - Special Accounts Salesman of the month.

August 2012 - Software Salesman of the month quota.

2012 Hunting trip.

Motivation for change: I was offered a promotion with in Nashua

Position: Key Accounts Manager – Tshwane (Jan 2009 – Dec 2011)

Responsibilities same as listed above.

Achievements

Salesperson of the Quarter Jan – Mar.

Salesperson of the Quarter Jul – Sep Quota Namibia.

Quota Rio de Janeiro.

Motivation for change I was offered a promotion with in Nashua moved to Cape Town

Position: Senior Sales Executive – Account Development / Technical Support (Technician) / Sales – Durban

(Jan 2007 – Dec 2008)

Senior Sales Executive – Accounts Development

Maintain contact with customers throughout their contract periods and to continually explore ways of developing their business with Nashua.

Technical Support (Technician)

Perform maintenance and repairs to Ricoh machines.

Direct Sales of office solutions

Represent Nashua in a positive and professional manner in and outside of Nashua.

Work with all personnel and outside contacts to satisfy clients and achieve company goals.

Identify areas of improvement in the company and assist in creating and implementing solutions.

Keep up to date on market trends and new products.

Identify and investigate growth opportunities for the company with our customers.

Provide constructive feedback to department employees.

Sell Nashua services and reach revenue quotas for existing customers.

Motivation for change: I was offered a promotion with in Nashua moved to Pretoria

Company Name: Claims Check National

(Web-based Database System of Insurance Claims History)

Employment Period: Jan 2004 – Dec 2006 (3 Years and 0 Months)

ERP System: Select MS Dynamics

Position: Data Manager/ Company Director

Collect data from client systems flat and Excel file formats (.csv).

Design database system to filter and manage data.

Process, filter and export data into flat files ready for upload onto web system.

Motivation for change: Data Management Services, Claims Check National and Dx3 was under one umbrella. One of the shareholder died and the company closed down.

Company Name: Data Management Services

(Data Management)

Employment Period: Jan 2004 – Dec 2006 (Years and Months)

ERP System: Select MS Dynamics

Position: Company Director

Host and capture client data on Broker Free using Server 2003.

Setup ADSL, Iburst and Terminal Server 2003.

Setup and manage DHCP, network load balancing, performance, remote desktops, routing and remote access, configuration and services.

Client and network securities, data sharing and management.

Oversee data capture as well as Marketing teams.

Motivation for change: Data Management Services, Claims Check National and Dx3 was under one umbrella. One of the shareholder died and the company closed down.

Company Name: DX3

(Data Management)

Employment Period: Jan 2004 – Dec 2006 (Years and Months)

ERP System: Select MS Dynamics

Position: Software Engineer / Director / Programmer / Marketer

I integrated the following system benefits for sort term brokers:

Total integration into the database for voice recording, email, faxes and all other communications. Built in statistics for the end user. Automated debit order collection with automated client notification of debit order activities as well as automated financial entries on debit order activities up to trial balance, integrated with Netcash. Complete claims administration and file management. Built in security. Comprehensive reports. A complete log system for security. Paperless office. Quoting system. Product builder with an integrated rate structure. Clauses, extensions & excess information visibility. More than 130 pre drafted confirmation of covers to client, insurers & finance house at the press of a button. ODBC Integration with Web and Microsoft.

Motivation for change: Data Management Services, Claims Check National and Dx3 was under one umbrella. One of the shareholder died and the company closed down.

Company Name: ATS School Admin/ PAG Admin

Employment Period: Jan 1992 – Dec 2003 (Years and Months)

ERP System: SchoolEase

Position: Software Engineer / Director / Programmer / Marketer

I Started in Marketing worked my way up to Database Developer with 280 schools on service contracts using our database system and IT Support contract. Marketing and Sales.

IT Solutions.

Development of SchoolEase.

Development and maintenance of the in-house support log system.

Monitoring, analysing and maintaining SchoolEase, using the support log.

Interacting with the end users to make SchoolEase user friendly.

Responsible for program updates and patches. Training, insulations, presentations and conferences.

Motivation for change: Opportunity to start my own business.

EDUCATION and QUALIFICATIONS

1989

(Obtained)

Grade 12

Hoërskool Gerrit Maritz

COURSES and TRAINING

2020

SQL Server Administration Part1

SQL Server Administration Part2

The Complete QlikView Boot Camp

Introduction to machine learning in the cloud with Azure Machine Learning

2019

Introduction to Data with Power BI

Querying Microsoft SQL Server 2012

SQL Server Integration Services (SSIS)

2018

2017

2016

Sage 300 and Sage 300 Retail (installation and support)

Qlik Sense/ Qlik View

Introduction to Programming

Programming HTML with JavaScript & CSS3

Querying Microsoft SQL Server

Administrating Microsoft SQL Server Databases

Microsoft

2015

SQL 2008/2012

2014

Broker Procedure Manual

2013

Software Sales & Presales Training

Equitract, PaperCut, Softlog

2012

Reading People – Your Poker Face

The Art of Negotiation – The Game of Tells

Branding – Your Table Image

Decision Making – Game Theory

Selling Your Hand – The Business of the Game

Dealing – The Management Schedule

The Poker Room

2011

Managed Print Services

Billy Bell

2011

CDIA+

2010

2008

Nashua Linc Exams

Nashua (Technician) Basic Digital

Nashua

1998

DataEase for Windows - Introduction, Intermediate & Advanced

TECHNICAL SKILLS

MS SQL SERVER 2008/2012/2016 (SSIS, Reporting Services)

Visual Studio 2010 (C#, ASP.NET, Web & Desktop Applications)

MS SQL (Databases, Tables, Queries) software development (DataEase Frontend with relational tables and full reporting)

Networking General A+, N+)

PC Hardware support (DataEase)

Jada Tools

DIW (guild updates)

Incwease

Increase

Data Model Manager

Data Export & Import

ODBC Integration in Office

Demo Builder DOS

Windows 9x, NT, 2000, ME, XP, Server 2000 (Terminal Server)

QuickBooks

Adobe PDF Printing

Bullzip Printing

Nero

Skype

Convert video to VOB to AVI

Di

PhotoShop

AS400

Microsoft Office (Word, Excel, Access)

Sage 300/ Sage 300 Retail

Power BI

Crystal Reports

Qlik Sense/View

REFERENCES:

Leon Goosen 072*******

M Stores

IT & Special Projects Manager

Robert Klaasen 072*******

M Stores

BI Analyst & Developer Manager

Francois Joubert 083-******* Nashua

Sales Manger

Vincent du Preez 071-***-**** Canon Milnerton

Sales Manger

CHARACTER:

I am able to communicate effectively with a wide range of people, by showing interest and carefully listening to their needs. I have a strong presentation and demonstrating skills; Confident, articulate and professional speaking abilities.

I enjoy working with others; I’m outgoing, I enjoy the team spirit and I’m understanding of the needs of others. I’m good at helping the team to see the bigger picture – to see the wood from the trees – helping them to focus on what really matters rather than getting bogged down in irrelevant detail. I’m also good at helping the team to spot flaws in our approach – and potential problems and pitfalls. I believe I have strong communication skills and, while I don’t yet have experience in a leadership role, I do have a talent for liaising between different team members and resolving any disputes which may arise. Conflict between different team members is rarely very productive and is normally best avoided

I am a visionary, I can lead others and myself and take responsibility whenever things go wrong. I do not need someone to spoon-feed me or hold my hand on a daily basis in order for me to do my job!

I am a person who is enthusiastic about what I do; completing tasks with excellence and always looking forward to the next one.

I think outside of the box; I come up with things rather than sit and wait until things come to me. I am a starter. Not a follower.

I do proper management of my time, resources and focus.

Ability to handle pressure and meet deadlines: I stay calm and carry out my tasks efficiently under pressure and always meet my deadlines

I am willing to learn and develop my skills and qualities further.

I handle new situations with ease and I adapt to whatever circumstances I am presented with. I can complete a task in more than just one way.

Contact this candidate