John  Gouws

John Gouws

$40/hr
I love working with data, doing Data Analysis, Data Transformation, Data Cleansing and discovery.
Reply rate:
-
Availability:
Full-time (40 hrs/wk)
Age:
68 years old
Location:
Paulshof, Gauteng, South Africa
Experience:
11 years
Resumé - John Gouws PERSONAL DETAILS • • • • • Full name: Address: Identity number: Date of birth: Contact number: John Gouws. 12 April 1957. EDUCATION & TRAINING QlikView Training • QlikView Developer and Analyzer – August 2009 • QlikView Requirements for certification – 26 June 2015 Pastel / Alchemex Certification • Certified Alchemex Consultant – May 2009 • Pastel Partner Module One • Pastel Partner Installation Technician • Pastel BIC Courses • Alchemex Administrator • Alchemex Report Manager • Excel on Steroids – Workshop 1, 2 and 3 - Excel 2007 SQL Training • Querying and Processing SQL Server Data with SQL Statements – February 2009 Project Management Diploma (1997) • Completed at Damelin College Project Management Tools and Methodology • Project Scheduler • MS Projects • PMBOK Novell CNE Course • Novell CNE Sequential Course Technical High School Middleburg • NTC - 1 -1- Resumé - John Gouws CURENT POSITION COMPANY Inside Analytics. POSITION MD - Qlik Consultant PERIOD May 2017 to Present RESPONSIBILITIES Since consulting again, I have had the opportunity to work on various solutions. These include: • • • • Being involved with a project which entails moving from QlikView to Qlik Sense. Monitor and maintain a 600-user QlikView environment, whilst working on a QlikView optimization model and improvements to Production models. A solution to consolidate Gaming data, Gaming and Financial data, from various smaller operations. I am currently busy with a Qlik Sense Asset Management project. PREVIOUS EMPLOYMENT COMPANY Keyrus South Africa. POSITION Principle Consultant PERIOD November 2017 to April 2018 RESPONSIBILITIES Keyrus opened a branch in Johannesburg. • The idea was to assist the Durban people with Qlik related work currently being handled from Durban and eventually handling all these projects locally. • Assist the Sales people with the Sales process. • Learn a new product – BI360 budgeting and forecasting – to increase the product scope. The most meaningful workpiece completed here was an NPrinting project. Unfortunately we had a personal crises at home and those responsibilities needed more time. I resigned from Keyrus. After taking time out I returned to Keyrus and I have been given a Master Services Agreement. I assist on Qlik projects as well as the sales process of BI360. The understanding is that when the projects materialize, I will be handling these. -2- Resumé - John Gouws PREVIOUS EMPLOYMENT COMPANY Bayport International Group Support. POSITION BI Analyst PERIOD June 2014 to April 2017 RESPONSIBILITIES Bayport could not offer me a contract, they could only make me an employee. I decided to accept this because it was long term and it was in an environment, micro lending, where I had no BI experience. My primary function was to monitor and maintain existing QlikView environments and production applications in RSA and Colombia. As it is a growing QlikView environment in BIGS, advice Business and Infrastructure regarding what will be required for each country when their “in house” application is rolled out into each country, as well as the consolidated QlikView environment in SA. Obtain requirements from countries of additional BI requirements, design and develop new QlikView applications to be used in each country as well as consolidated versions thereof. The idea is not to end up with country specific apps. For consolidated versions, the PoPI act must be kept in mind. Applications developed: ETL processes that could be used for the ODS; Loan Application Process Workflow; Sales Model; Debtors Model; Contributed heavily in all the Migration processes for the new application; -3- Resumé - John Gouws Inside Analytics Independent QlikView Consultant COMPANY Formally T/A BiWorx – Now Inside Analytics Pty Ltd. POSITION Independent QlikView Consultant QlikView Implementation Partner PERIOD July 2009 to Present While doing Alchemex reports I came across QlikView. QlikView had a lot more functionality and after some training I managed to land my first project. What was clear to me was that QlikView would be much more ‘rewarding’ and the project would be of a longer term nature. As I did more and more QlikView projects the Alchemex work fell by the wayside. With QlikView I do the design, development and implementation of the solutions. I have implemented versions 8.5, 9, 10 and 11. As a QlikView Implementation Partner, I generate my own implementations and have an arrangement with QlikView Partners to handle projects on their behalf when they do not have resources available. Applications implemented thus far: Sales, Logistics, Production, Gaming, Financial and Service / Maintenance. PREVIOUS EMPLOYMENT Independent Alchemex Consultant COMPANY Self Employed – T/A BiWorx POSITION Independent Alchemex Consultant PERIOD February 2007 to about July 2010 FUNCTION After Multi-door I did not know exactly what to do, but I wanted to get back into the IT arena. By chance, a friend of ours needed some Excel help. During this help it came out that the software her company was implementing and supporting had just released a reporting module which was able to get data from your Pastel accounting package into Excel. From here you could create some nifty reports. I investigated this further and decided I really enjoyed the reporting side. I went for training and registered as a consultant with Alchemex. Alchemex would then forward support leads to consultants. I implemented and supported Pastel Clients who had the BIC module. The standard reports used by BIC would be sufficient for the Clients using the standard field. Most companies however made use of used defined fields and it was then necessary to either customize or create new reports via the BIC module. -4- Resumé - John Gouws VENTURE Multi-Door During the time at Namitech I had gotten involved as a ‘silent’ partner in a venture where we were manufacturing security barriers for doors and windows. A factory was set up for the purpose on manufacturing retractable security doors. The venture had taken off better than what we expected and I decided to join the business full time. All processes were taken care of in one factory. Apart from handling the daily issues of running your own business my main functions were: Stock control was critical Financial control Quality control – on the manufactured product Quality control – installations – I tried to “sign-off” as many installations as possible After about two years of operating I decided to sell my share in the business. The venture was established in 2003 and I sold out in the beginning of 2006. PREVIOUS EMPLOYMENT COMPANY Namitech Ltd 39 Galaxy Avenue, Linbro Park POSITION Projects Manager REPORTING TO William Wilsnagh PERIOD November 2001 to November 2002 William was also an employee at MGM Grand SA at the time I was there. William had joined Namitech and they were developing tracking hardware and software for slot machines. I was asked if I would like to join Namitech as a project manager and it seemed like a good opportunity. Scope • Project tracking and control • Maintaining the project budgets • Assist with the installation of the hardware and software -5- Resumé - John Gouws PREVIOUS EMPLOYMENT COMPANY MGM Grand SA (Tsogosun) 3rd Floor Twin Towers East, Sandton City POSITION Project Manager PERIOD December 1998 – August 2000 CASINO’S OPENED Emnotweni – Permanent Casino(Nelspruit) Montecasino Scope This position was in essence the same as the Tsogo position, only under the MGM banner. • • • • • • • Establish hardware and software standards. Establish network security standards. Network design and establishing the Head Office infrastructure. Establish maintenance agreements for WAN, VPN. Preparing detailed operational and development budgets for IT and Surveillance departments. Design IT infrastructure for new casinos and ensure infrastructure is implemented correctly. Staff recruitment. PREVIOUS EMPLOYMENT COMPANY Tsogosun POSITION Opening Team Member 3rd Floor Twin Towers East, Sandton City PERIOD July 1997 – November 1998 CASINO’S OPENED Emnotweni – Temporary Casino (Nelspruit) Sundome - Temporary Casino (JHB) Champions - Temporary Casino (Witbank) Scope As Tsogo Sun was a new company I had to establish the IT Department with all related infrastructure. • • • • • • • • Establish hardware and software standards. Establish network security standards. Network design and establishing the Head Office infrastructure. Establish maintenance agreements for WAN, VPN. Preparing detailed operational and development budgets and presenting to MGM Grand South Africa. Design IT infrastructure for new casinos and ensure infrastructure is implemented correctly. Staff recruitment. Prior to the Montecasino opening I was part of the Tsogo Management team who went to Acres in Las Vegas to evaluate the Acres Gaming System. This was to compare the IGT IGS and Acres Systems. -6- Resumé - John Gouws PREVIOUS EMPLOYMENT COMPANY Sun International Sun International Head Office: (1993 to 1997) Information Systems Project Manager Responsible for Interface between IT department and Sun International Development department Responsible for ensuring all IT infrastructure requirements are met during refurbishing phases of Casinos Project budget control and reporting Responsible for scheduling all hardware and software upgrades at Resorts Wild Coast Sun: (1986 to 1993) Data Processing Technician Assistant Data Processing Manager Regional Information Systems Manager (Transun) Wild Coast Sun: (1985 to 1986) I joined Wild Coast Sun as a air-conditioning technician. During this time I was offered the opportunity to join a newly formed data processing department. Although I had never touched a keyboard, I was given training and I seemed to take to it. If not for this opportunity, I am sure I would not be in the position I am in today. PREVIOUS EMPLOYMENT COMPANY Marshalls Refrigeration POSITION Refrigeration & Air-conditioning apprentice / technician PERIOD 1978 – 1984 After school I had no idea what I wanted to do as a career. I was offered an apprenticeship through a friends Dad and I thought it was a good idea. As it turns out, having technical skills comes in very handy in one’s life. Marshalls Refrigeration handles commercial refrigeration and air-condition, I was on the refrigeration side. We installed and maintained refrigeration plants for large chain stores like Pick and Pay, butcheries and even fishing trawlers. -7- Resumé - John Gouws CAREER ACHIEVEMENTS Inside Analytics – (QlikView) Being in a unique position where I have had the benefit of working with different Qlik Partners, I have had the opportunity of seeing how people ‘do things’. Being in this position has also given me the benefit of working in a variety fields. The biggest achievement, and most satisfying, in the QlikView space was the time at BIGS. I had the opportunity of developing QlikView Apps from start to finish, covering all aspects of the Projects. Interfacing with Business to deploying the apps. What I enjoy about BI, is that it is, and probably always will be, a constant learning curve. Tsogosun At Tsogosun I was on the Start-up Team. We had to set up the company from scratch. This included establishing our own internal infrastructure. Developing the infrastructure requirements for our first Casino. Staff recruitment, maintenance agreements, daily meetings with the Professional Team, (architects, electrical consultants, interior designers, air-conditioning consultants) networking companies and computer supply companies. The Casinos we started up were in the following order and also listed is the function filled: Sundome Casino – IT Management / Project Management Emnotweni Temporary Casino – IT Management / Project Management Champions Temporary Casino – IT Management / Project Management Emnotweni Permanent Casino – Project Management Montecasino – Project Management Suncoast Casino – Contract Project Manager. Prepared all operational equipment budget and built the installation project plan prior to leaving their employ. The most stressful of these was the Sundome because it was the first. The most rewarding and biggest in terms of grandeur and budget was Montecasino. The total budget I was responsible for was just under R220M. I see the Tsogosun phase as an achievement because as the gaming licenses are awarded by the Gaming Board, you had to start developing to avoid penalties. No penalties were incurred. Namitech Limited Namitech Limited, Gaming Division, was tasked to design a complete Gaming System, both software and hardware. William Wilsnagh headed the division up. I joined Namitech about 8 months into the Project on a contract basis. An agreement had be entered into between Namitech and Tusk Resorts to develop the System on their behalf and use one of their Casinos as a test site. During the contract I managed the following Projects: Namitech Gaming Management System – software and hardware Smart Cashier – ATM like unit found in most casinos Tusk Mmabatho - Pilot site installations – all versions were tested here Tusk Umfolozi installation – first regulated Namitech system installed Tusk Mmabatho - Roll out to the main floor – moved from test environment to live environment Tusk Venda - Initial Project planning – project to convert entire floor to the Namitech system The system was and still is the only “local” system to be developed for the Gaming industry. When many said the project would fail, it is running in various regulated casinos. -8-
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.