09/06/2022 updated

**** ******** ****
100 % available

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

Hillcrest, South Africa
South Africa
MCSD
Hillcrest, South Africa
South Africa
MCSD

Profile attachments

SENIOR CONSULTANT – SPECIALIST IN BUSINESS INTELLIGENCE, DATA WAREHOUSING, DATA MIGRATION, DATA ENGINEER, DATA MODELING, BUSINESS

Analytical ThinkingData AnalysisArchitectureArchitectural DesignAutomationBusiness IntelligenceBusiness AnalysisBusiness ProcessesCash ManagementServicio al ClienteInformation EngineeringExtract Transform Load (ETL)Data MigrationData ProfilingData WarehousingEngineering Design ProcessPerformance ManagementSalesInformation ManagementIT ManagementProject ManagementMicrosoft Certified Systems EngineerMicrosoft SQL ServersQuality ManagementReengineeringSales ProcessSQL DatabasesSQL Server Integration ServicesSystems DesignCoaching and MentoringSales Campaigns
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.

Experience

Professional experience10+ years

Languages

EnglishFluent

Project history

Business Intelligence Executive

Leadership Management; Talksure; X X

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.

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

Project manager IT/BI X X

MiCentre

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

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.

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

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

MCSD Lecturer

Megamasters Computer centre

Internet & IT

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.

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).

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in