Experience

PBT Group

• South Africa
• IT Services and IT Consulting
• 200 - 300 Employee

• Data Analyst

  • Feb 2021 - Present



InfoBluePrint

• South Africa
• Information Technology & Services
• 1 - 100 Employee

• Data Analyst/Developer

  • Apr 2013 - Jan 2021

  Ab Initio skills and exposure: - Reading from database tables, flat files or queues - Transforming input data using fixed, variable length and delimited DML definitions. - Using lookup files efficiently to simplify graph operations and avoiding the JOIN component where performance degradation may occur. - Building and managing ICFF lookup files, for storage of big volume data and being able to lookup data from within the files based on a select key and loading these files dynamically. - Exposure to using dynamic lookup templates, which help create a lookup template at runtime - Using PDL and KSH to create variables within graphs and projects to simplify project and graph settings. - Able to construct graphs that can be switched conditionally on and off for easy reuse of common functionality across graphs. Show less



SAP/Sybase

• Cape Town Area, South Africa

• BI Consultant

  • Sep 2009 - Mar 2013

  - Setting up database models using Power¬-Designer. - Creating and maintaining scripts for running reconciliation processes. - Wrote SQL Script/Stored Procedures to run reconciliations based on documentation received from client. - Involved in writing Stored Procedures to replicate real time data to backup/standby server. - Adhoc queries and data investigations. - Involved with creating tables and views for incoming telecoms data streams. - Dynamic SQL programming for reusability. - Basic HANA training. - Procedural Documentation: Functional Specification, Technical Flow Diagram, Factory Acceptance Testing. Show less



Sybase

• BI Consultant

  • 2009 - 2013



Ovation Global Investment

• Cape Town

• Database Administrator

  • May 2000 - Aug 2009

   Setting up Adaptive Server Enterprise 11.5.1.2 on NT Server/Windows 2003.  Maintenance of Sybase Infrastructure: creation of database devices, database,  Logins, setting up cache and pool configuration  Responsible for maintaining the database and model using Power¬-Designer.  Creating and maintaining of scripts for populating database with default values.  Wrote SQL Script to populate new database with production information.  Involved in writing Stored Procedures to print statements and do recon process.  Responsible for backup procedures and reindexing of databases.  Enrich V3 Release  Database capacity forward planning  Security lockdown for FICA purposes  Inhouse Access Applications Show less



Ovation Global Investments

• Sybase DBA

  • 2000 - 2009



Metropolitan Health Group

• South Africa
• Health, Wellness & Fitness
• 700 & Above Employee

• Sybase DBA

  • 2002 - 2003



Snyman & Partners

• Sybase DBA

  • 1997 - 1999



Van Vuuren & Associates

• Developer

  • 1994 - 1996