Freelancer profile picture

Werner M.

SQL Developer

  • Hourly rate: R300 /hr
  • Experience: 20 Years

About Werner

Phone verified

I have been applying my skills as a Business Intelligence Developer since April 1999, specializing in Databases, Database development, Office and Windows automation, Reporting, etc. Over the years I have had the opportunity to work with many different IT systems and processes and most of these were used by me to build, maintain, upgrade, or implement BI tools for the end-user or management. My IT career started with Momentum where I worked with large IBM AS/400 iSeries servers. On these servers I made use of CL (Command Language) and AS/400 SQL functionality. Much of the BI data preparation was done on the AS/400 thereafter the rest of the ETL processes was done on SQL Server, Data Transformation Services (DTS) and Cognos. After almost 9 years at Momentum, I left and in November 2007 started working at UTi where I was exposed to Oracle databases, SQL Server, and SQL Server DTS, and a slightly newer version of Cognos. After this, I started working at OneLaw as a BI Developer, where I worked with SQL Server 2008 and 2012. Almost all tools used during my time at OneLaw were Microsoft from back-end to front-end. Reporting data was prepared from a SQL Server production database via an ETL process which consisted of a combination of SQL Stored Procedures and SSIS (Integration Services Packages). I also built SSAS (Analysis Services OLAP Cubes) and SSRS (Reporting Services Reports). I did some User Interface work in “Visual Studio Tools for Office” for management. When I left OneLaw in April 2013, I started my own company (HeMacc Information Technology) with the idea to get involved with IOT development and implementation for 2 of his own clients – he has done work with many IOT devices as well as break-out board modules like Arduino and Sparkfun. Today I still re-sells electronic components and IOT devices, whilst doing Business Intelligence and SQL Server Development. I have limited exposure to Azure Cloud (recent), with knowledge of BigQuery. Major Achievements: - Development of custom UI in Excel for Business Intelligence management team with Microsoft Tools for Office - Development of production URL’s inside SSAS for fast navigation - Developing and implementing access control systems with IOT devices and breakout boards

5 Profile Views
Report Werner

Testimonials

No testimonials to display.

People Also Viewed

Photo of Joe goldlifetime Freelancer

Joe F.

HR Generalist

Cape Town

R 650 /hr

Photo of Amanda goldlifetime Freelancer

Amanda D.

Finance Consultant

City Of Tshwane Metro

R 90 /hr

Photo of John goldlifetime Freelancer

John S.

Software Developer

Pinetown

R 450 /hr

Photo of Jacqueline goldlifetime Freelancer

Jacqueline H.

Service Advisor

Pinetown

R 150 /hr