Requests
0
Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
AM2SystemsConsultant
Jun. 2025Pretoria, Gauteng, South AfricaAzure
KQL
Grafana
FSP SolutionsSSRS and SQL Developer
Jan. 2023 - Apr. 2024Pretoria, Gauteng, South AfricaMicrosoft SQL Server Reporting Services developer and T-SQL developer. I created and maintained existing SQL Server databases. I created and Altered Stored Procedures for use in SSRS. In SSRS I obtained most data from Stored Procedures and custom SQL query code. The SSRS reports were then published to DEV, Staging and Live Reporting Servers. All reports were accessed through the production front-end. I was active as a SSRS (SQL Reporting Services) developer. I created new SSRS reports and maintained existing reports. I touched on and worked with most functionality in SSRS. All data necessary for the development and maintenance of reports was obtained from Stored procedures, either developed by me or maintained by me. In addition to the SSRS part of the business I rolled out new applications and BI functionality like SSAS Tabular format Cubes for use inside Excel or outside Excel via Excel functionality build by me. (please have a look at the Excel BI Ribbon project that I build and maintained.) I did SQL Server Database design and implementation for the SSRS reports used by business and Power-Users inside and outside the company.
Symplexity SQL Developer
Mar. 2022 - Dec. 2022Pretoria, Gauteng, South AfricaI did SQL changes on a SQL Server database and that was then verified by a team leader along with Word documentation in a specific format and that was then taken live the next day.
SymplexitySQL Developer
Mar. 2022 - Dec. 2022Pretoria, Gauteng, South AfricaI did SQL changes on a SQL Server database and that was then verified by a team leader along with Word documentation in a specific format and that was then taken live the next day.
CrowdCollectBusiness Intelligence Consultant
Jan. 2019 - Feb. 2022Pretoria, Gauteng, South AfricaMy responsibilities included the below: 1. SSRS
2. SSAS - SSAS OLAP Cubes. - SSAS Tabular Cubes. - Some Cubes was used for monthly Reports while some was used for hourly turnaround measurement. The Turnaround Cubes was processed hourly on the hour or on an agreed time. 3. SQL Server - Import and Extract of data in Excel, .csv and normal text data. - Create and Alter of Stored Procedures. - Create and Alter views. 4. SSRS 5. Excel - All the above was mainly viewed and used by the end user in Excel. All Cubes in Excel was connected to Analysis Services Server via the Data Tab and then Analysis Services option / Driver. This included the Tabular Cubes.
CrowdCollectBusiness Intelligence Consultant
Jan. 2019 - Feb. 2022Pretoria, Gauteng, South AfricaMy responsibilities included the below: 1. SSRS 2. SSAS - SSAS OLAP Cubes. - SSAS Tabular Cubes. - Some Cubes was used for monthly Reports while some was used for hourly turnaround measurement. The Turnaround Cubes was processed hourly on the hour or on an agreed time. 3. SQL Server - Import and Extract of data in Excel, .csv and normal text data. - Create and Alter of Stored Procedures. - Create and Alter views. 4. SSRS 5. Excel - All the above was mainly viewed and used by the end user in Excel. All Cubes in Excel was connected to Analysis Services Server via the Data Tab and then Analysis Services option / Driver. This included the Tabular Cubes.
Owner of HeMacc ITConsulting
May. 2013 - Dec. 2018South AfricaCurrent consulting work: Microsoft SQL Server 2014 and 2016: Creating Databases in SQL Server for reporting.
Using Stored procedures.
Extracting data from user databases (Stored Procedures).
Dropping Tables.
Creating tables.
Building Indexes for performance purposes.
Building Clustered Indexes and some unique Indexes.
Making use of Linked Servers within SQL Server "server objects".
Scheduling "Jobs" via SQL Server Agent.
Job steps include:
Stored Procedures
Analysis Services Commands (OLAP Cubes).
Using SQL queries to monitor Jobs within Reporting Services (Executing Hourly). Reporting Services: Building and maintaining reports for business use.
Using Microsoft Visual Studio 2017 to build SSRS reports.
Creating new Reports
Creating Data Sets and using Report items in .rdl reports.
Uploading reports to the Reporting Services browser site.
Setting and managing rights on reports and folders. Analysis Services: Using two different Server installations. Multidimensional OLAP Cubes. Creating new projects for OLAP Cubes with Visual Studio 2017.
Creating Datasources and datasource views.
Creating Dimensions from tables and columns inside DataSource Views.
Creating Cube after all Dimensions was created.
Creating Roles.
Setting Role permissions and rights on the Cube for certain or all users on the LAN. Tabular Model Cubes. Using Tabular Model Explorer to create.
Data Sources.
Tables.
Using table properties to select columns and de-select columns.
Processing Models and maintaining Cubes on the Tabular Server.
Measures.
Roles. Integration Services: Creating .dtsx Packages
Using Control Flow and Data Flow options.
Using SSIS Toolbox items.
Importing data and Exporting data from and to: SQL Server source / destination.
OLE DB source / destination.
ADO NET source / destination.
.xlsx source / destination.
.csv source / destination. Processing OLAP Cubes.
Send mail tasks.
File System tasks.
File watcher tasks.
Executing SQL tasks.
Script task.
Business Intelligence Developer OneLawBusiness Intelligence Developer
Jun. 2008 - Apr. 2013Microsoft SQL server database 2012:
SQL Server Integration Services 2012:
SQL Server Analysis Services 2012:
SQL Server Reporting Services 2012: Microsoft SQL server database 2008:
SQL Server Integration Services 2008:
SQL Server Analysis Services 2008:
SQL Server Reporting Services 2008:
Performance Point Services Responsibilities: I was a Business Intelligence Developer, working in a small team of 4 people. We design, develop and maintain small Data Warehouses and databases for various departments within our company. We do all development and reporting in Microsoft products like SQL Server, SSAS, SSIS, SSRS. With SSAS I develop Cubes by using SQL server tables and views for the business in order to analyze current financial situations and to view trends in order to make predictions. With SSRS I build basic reports for power users in order to analyze low level data and business processes. I also build Dashboards by using gauges and graphs for internal call centers. With SSIS we build packages in order to execute stored procedures which in turn help us to update our SSAS Cubes. I make use of controls like ''Execute SQL task'', ''Analysis Services Processing Task'', ''Send Mail Task'' as well as other controls. I also assume responsibility for interaction with the client\user in order to draw up the necessary specifications for the development process by using a basic in-house BI SDLC.
UTIETL Developer
Nov. 2007 - May. 2008At UTi we worked with PL/SQL on large Oracle Databases as well as inhouse SQL Data warehouses. We followed an ETL process with Microsoft DTS (Data Transformation Services) in order to extract data from Oracle into SQL Databases. Other ETL processes was done within PL/SQL on the Oracle Databases.
Momentum LifeBusiness Intelligence Developer
Apr. 1999 - Oct. 2007At Momentum I worked with various data sources in order to do reporting via old Cognos applications like Impromptu. Mostly because of licensing costs and a lack of functionality we moved over to Microsoft SDQL Server in order to do reporting for the business along with DTS (Data Transformation Services) as an ETL tool. The mainframe from which we got most of our data was IBM AS/400 iSeries servers and other smaller SQL Servers. We later used SharePoint as a storage platform for data until we developed a small HTML front-end with HTML in order to make Excel and SSRS data available to the business.
BCOMPT - NOT CompletedUniversity of South Africa
Jan. 1997 - Dec. 1999Pretoria, Gauteng, South AfricaStudies at University of South Africa BCOMPt (Not completed)
SANDFWeerman
Jan. 1992 - Dec. 1992Pretoria, Gauteng, South AfricaNational Service.
EdconEdcon Internal Auditor
Mar. 1989 - Dec. 1997Pretoria, Gauteng, South AfricaFinance and Audit.
Intch is a Professional Networking App for the Future of WorkSee more people like Werner on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
499616 people
16
PR - Writer - Marketing
23
Educator/Coach/Entrepeneur, Leader, Motivator, Problem Solver @ ArchED Learning and Development
38
Entrepreneur / 3x Tech Startup / Marketing and Growth @ Morlean Trading Group
134004 people
38
Entrepreneur / 3x Tech Startup / Marketing and Growth @ Morlean Trading Group
20
Project Leader /Project Manager @ Thomas Matern Developments
25
Resource Manager @ Stellenberg High School