Profilbild von Conrad Coetzee Data Warehouse Specialist, Data Engineer, Modeler, MSQL, ETL, Migration, Business Intelligence, aus Hillcrest

Conrad Coetzee

verfügbar

Letztes Update: 06.09.2022

Data Warehouse Specialist, Data Engineer, Modeler, MSQL, ETL, Migration, Business Intelligence,

Abschluss: MCSD
Stunden-/Tagessatz: anzeigen
Sprachkenntnisse: englisch (verhandlungssicher)

Dateianlagen

CONRAD COETZEE CV4.pdf

Skills

Data Warehouse Architecture, ,Data Warehouse Design, Architecture, & Development Analytics, MS SQL analyst programmer,  Business Intelligence, Data Warehouse specialist, ETL, Data Analysis, ETL,  SSIS development, Data Profiling,

An accomplished and dynamic professional with over 20 years’ experience, I have been specializing in Business Intelligence, Data Warehousing, Information Management, Data Migration, IT Management, Business Analytics, Business Process Architecture Design and IM Project Management. Well known for my ability to meet, achieve and exceed company and project objectives.

It takes years of experience to understand the true workings of a Business Intelligence strategy. It is easy to learn the technical aspects and one can become a good programmer in a short period of time, however, only experience will produce a good analytical designer – it is a way of thinking.

Throughout my career, I have successfully led and managed the structure and implementation of new departments and projects. Excellent ability to manage, coach and motivate staff members.
 
  • Qualified Microsoft Certified Systems Developer (MCP ID 1760894) since January 2000.
  • Technical design, programming and implementation of several new Data Warehouses and BI platforms, one audited by Britehouse (a division of Dimension data), their opinion that it is a benchmark of system design.
  • Building data profiling platforms.
  • Re-engineering and automation of business processes (daily registers, sales processes, sales to QA, dialer, data profiling, HR, collections, cash-flow, client services).
  • Successful implementation of new migration projects.
  • Implemented automated Debit order processes (Naedo) .
  • Successfully implemented a Dialer load strategy for sales campaigns.
  • Designed a Government Performance Management Business Intelligence system, accepted by Dimension Data and Bytes Technologies.

Projekthistorie

01/2016 - 12/2020
Business Intelligence Executive
Leadership Management; Talksure; X X


03/2013 - 03/2016
Data Warehouse and Analytics Executive
Blake & Associates

Responsibility
* Project Management
* Successfully implemented new data migration process
* Data architecture/systems analysis, data warehouse design and BI analysis,
* Successful implementation of new Data Warehouse
* SSRS development
* Audit and risk
* Developed new QA processes.
* Developed new leadership and coaching courses based on John Maxwell's work.
* Coach more than 150 employees.

06/2010 - 02/2013
Data Warehouse Consultant
Ethekwini

Responsibility
* Project Management
* Successfully implemented new data migration process for Revenue Management System.
* Data architecture/systems analysis, data warehouse design and BI analysis,
* Successful implementation of new Data Warehouse
* Data Migration projects
* SDLC: (Waterfall, Agile)
* Training (team members)
* Design and implementation of new Meta Data Repositories
* Design and implementation of Audit Trail/log process
* Design and implementation of new Report architecture process.

Reason for Leaving End of contract

01/2009 - 01/2010
Project manager IT/BI X X
MiCentre


05/2007 - 12/2008
Head of Department: Business Intelligence
TUW

Company TUW (Financial and contact centre)
Position Head of Department: Business Intelligence
Responsibilities
Setting up of new BI department (all interviews done by me)
* Responsible for overall design, development and successful implementation of new BI processes
Companies New Data Warehouse and BI processes.
* Responsible for company's new data strategies, data management.
* Distribution and designing of data processes for supplying and feedback of data to the company's
dialers (handling of 2 million records a month).
* All negotiations with external companies regarding data procurement.
* SDLC (Agile)
* Design and implementation of Fraud prevention processes
Responsibilities:
1. Management of BI team
2. Designing, Architecture
3. Extraction, loading and Transformation (ETL)
4. Administration and Maintenance of the Data Warehouse and BI Landscape
5. Data analysis
6. SLA management

Achievements
1. Exco (Premier Growth Group)
2. Growth Award Premier Growth Group)
3. Leadership Nomination (Premier Growth Group)
4. Successful negotiations with service providers which saved the company +/- 8 million pa

Reason for leaving Resigned

11/2005 - 04/2007
BI Specialist consultant
B.I.D Solutions

Responsibilities Work as a BI consultant. Designed a Government performance management Business Intelligence system.
Implemented a Printer Data Mart at Albert Luthuli Hospital for reporting purposes.

07/2002 - 10/2005
Business Intelligence Manager/Senior Analyst Programmer
Credit Indemnity (PTY) LTD A Division Of African Bank (Financial)

Responsibilities
1. Designing
2. Architecture
3. Extraction, loading and Transformation (ETL)
4. Administration and Maintenance of the Data Warehouse and BI Landscape
5. Data analysis
6. SDLC (Agile)
7. Design and implementation of Fraud prevention processes

Achievements
Responsible for overall design, development and successful implementation of new BI processes
Companies New Data Warehouse and BI processes.
* Was responsible for building a complete warehouse and was part of the initial planning. I was
responsible for 98% of the design and Architecture.
* The Data Warehouse was designed with SQL server 2000, DTS, OLAP, Visual Basic and Proclarity
* The warehouse was designed on Ralph Kimball's methodology.

Reason for Leaving Company relocated to Johannesburg

07/2001 - 07/2002
BOE Treasury Data Manager: (Data warehouse manager)
BOE Bank

Responsibilities
1. Managing and maintaining the BOE Treasury's data warehouse.
2. Creating and designing new projects (Jobs) making use of Datastage, DTS, Sybase and Microsoft
SQL.
3. Data manipulation and transformation making use of Datastage, Microsoft DTS (Data Transformation
Services), Microsoft OLAP.
4. Data analysis and extraction for excising and new Reports.
5. Designing jobs for ALCO, Money Market, Credit Risk, Group exposure.
6. Software development:
6.1 Credit Risk application & reports
6.2 Money Market application & reports
The Credit Risk application was designed with VB6, SQL Server, Datastage and Crystal Reports. It is
a data capturing system that produces reports for Management.
Money Market report application. The application was designed in Sybase, SQL server 7, Datastage,
Visual Basic 6 and crystal reports.

Reason for resigning: Nedcor was in the process of taking over BOE Bank and head office was relocating to Johannesburg

02/2000 - 06/2001
MCSD Lecturer
Megamasters Computer centre (Internet und Informationstechnologie)

Responsibilities
MCSD and MCDBA track. I was responsible for 5 subjects.
Microsoft Visual Basic Desktop Applications 6 (1 full course)
Microsoft Visual Basic Distributed Applications 6 (1 full course)
Microsoft SQL Server 2000 Design & Implementation (3 full courses)
Microsoft SQL Server 2000 Administration (3 full courses)
Microsoft Analyzing requirements and defining solution architecture (1 full course)

The students work and studied under my supervision for a further 6 months at my house and they all
passed their MCSD exams by the end of that year.

03/1995 - 12/2000
Senior IT and Communication Manager (Consultant)
Viva Africa Pry Ltd

Responsibilities
Senior IT and Communication Manager for the Independent Electoral Commission covering the area of
the iNdlovu Regional Council.
Information Technology: Had to set up an office from scratch, operational planning between the
business section and IT Department. Designing of a Data Base in Access for capturing +/- 300 000
potential voters for registration process (for office use.)
Planned and implemented an office network for implementing a Data Capturing system.
Managing all Information systems.
Writing small office programs in VB and Access.
Communications:
Dealing with Telkom Management, Iridium Global Satellite Network in Washington D.C., Vodacom and
M.T.N.
Technical management. Planned and implemented a new communications network model designed for the
I.E.C. by me for 368 voting stations, and 150 field personnel for the national elections. (+/- R1
500 000 total cost of operation).

Reisebereitschaft

Verfügbar in den Ländern Südafrika
Profilbild von Conrad Coetzee Data Warehouse Specialist, Data Engineer, Modeler, MSQL, ETL, Migration, Business Intelligence, aus Hillcrest Data Warehouse Specialist, Data Engineer, Modeler, MSQL, ETL, Migration, Business Intelligence,
Registrieren