Senior BI Consultant & ETL Architect
Resume:
IZAK JOUBERT
Occupation
Senior BI Consultant & ETL Architect
Years Experience
(10 years BI intelligence and Data Warehousing )
Age
41
Objective
A position as a Senior BI Consultant in a dynamic environment that offers continuous challenges in new technologies \ ideas \ methods and scope to remain on the cutting edge of Technology; with a company that is intimate in structure and leadership and values professional growth and development as an asset.
Availability
30 days
Cell phone
Tel
+27-12-329-**** (H)
+27-12-311-**** (W)
Fax
+27-12-329-**** (H)
acqia8@r.postjobfree.com (H)
acqia8@r.postjobfree.com (W)
Address
310 Malherbe Straat, Capital Park, Pretoria, 0084
Personal Details
Gender
Male
Nationality
South African
ID No
Marital Status
Married (2 kids)
Language
Afrikaans, English
Profile
Proactive, adaptable and conscientious Business intelligence Consultant and ETL Architect with fifteen years’ experience in the IT industry. Overcomes challenges through a tenacious and questioning approach. An out of the box thinker; enjoys a challenging environment. Great team worker; adaptable and flexible. An articulate and diplomatic communicator and effective team player with strong coaching skills.
Education
1998
Technikon of South Africa
N-DIP, Information Technology
(Not Completed)
Subjects completed: Programming Concepts (Distinction), Information Systems I (Distinction), Language and Life skills: IT, Computer Literacy: Theory (Distinction), Computer Literacy: Practical (Distinction), Introduction to C, Information Systems II, System Software I, Applied Programming I (Visual Basic), Development Software II, Technical Programming (Turbo C), New Technology I: Internet Fundamentals (HTML)(Distinction), New Technology I: Java.
1992–1996
Potchefstroom University
B.A: Psychology and Labour Relations
1991
Volkskool Potchefstroom High school
Matric
Professional Certifications
A+
Comptia
2000
Certified MCP:
Designing and Implementing SQL server 2000
Damelin
2004
Installing and Administrating SQL server 2000
Torque-IT
2004
Certified IBM Solutions Developer:
Datastage 7.5, 8.1 and Information Analyzer 8.1.1
Bytes
2009
Professional Courses
Forte Developer
IOCORE (In-house)
2000
Advanced Forte Development
IOCORE (In-house)
2001
Forte System Management
IOCORE (In-house)
2000
Advanced Forte Systems management
IOCORE (In-house)
2002
Web focus Development
IOCORE (In-house)
2001
Oracle Basic development and DBA course
Technikon SA
2002
SQL 2000 Analysis Server
LGIT
2003
SQL 2000 Reporting Services
LGIT
2004
DataStage 7 server Fundamental course
Sybase
2007
DataStage 7 server Advanced
Sybase
2007
Datastage 8 Enterprise Fundamentals
Sybase
2007
Datastage 8 Enterprise Advanced
Sybase
2009
Sybase IQ Administration
Sybase
2008
Introduction to Linux Redhat server
Sybase
2008
IBM Information Analyser Fundamentals
Sybase
2008
Experience Summary
Senior BI Consultant & ETL Architect
6.75 years
ETL Development 40%, Database Design 25% ETL Architecture 25%, Training/Mentorship 10%
Data Warehouse Developer
2.25 years
SQL Development 50%, Database Design 25%, Database Maintenance 25%
SQL Developer
1.5 years
SQL Development 65%, System Design & Maintenance 20% Month-End Consolidations 15%
Programmer & Systems Analyst
3 years
Development (Programming) 50%, Back-end Maintenance 40%, Deployments 10%
Junior Help desk Consultant
1.5 years
1st Line Support 25%, 2nd Line Support 75%
Areas of Expertise
Data Warehouse Designs
Database optimization
ETL Designs
BI System Analysis
Technical Architecture (BI Systems)
Datastage 9.1
Datastage 8.1
Datastage 8.1 training
Datastage 8.5
Datastage 8.5 training
T-SQL Programming and ETL integration
Career History
1
MAR 2014 – CURRENT (CONTRACT)
Telkom
http://telkom.co.za
Senior ETL Developer
Responsibilities
Designing an optimized ETL solution for the migration of Customer, Product and Financial data from the current Legacy systems into a staging area, where it is to be processed into the new Telkom system
Developing the migration design within the guidelines of the project
Maintenance on the current MDM solution that was built by my team
Datastage and IIS Support
Consulting on ETL issues and solutions as well as consulting on ETE solutions
Consulting on other Telkom projects that require bulk loading of data
Datastage training, formal and on-site
Technologies
Datastage 9.1 Enterprise
Information Analyzer 8.7
Oracle 11G
Linux Redhat 5.5 Enterprise
SQL Developer
2
NOV 2011 – FEB 2014 (CONTRACT)
Kwezi Software Solutions
http://kwezisoftware.co.za/index.html
ETL Line Manager
Responsibilities
Team lead for the Kwezi ETL resource working on various Telkom projects
Designing optimum solutions based on input from the customer, as to what is expected, and what is available
Resource planning based on Kwezi requirements towards ETL requirements at other customers
ETL architecture representative
Consulting on ETL issues and solutions as well as consulting on ETE solutions
Assisting and liaising with Telkom ETL resources on the MDM project
Datastage training, formal and on-site
Technologies
Datastage 8.7 Enterprise
Information Analyzer 8.7
Oracle 11G
Linux Redhat 5.5 Enterprise
Power Designer
SQL Developer
3
JAN 2011 – OCT 2011 (CONTRACT)
Vodacom
www.vodacom.co.za
DATA INTEGRATION EXPERT
Responsibilities
Maintaining the current Huawei 2G and 3G production environments
Optimizing and re-writing of Legacy Datastage jobs
Developing new projects using Datastage 7.5
Designing new Network information system ETL projects
Liaising with the Datawarehouse DBAs
Technologies
SQL Server 2008
Oracle 10G
Datastage 7.5 Server
Solaris Unix
JCL
4
APR 2007 – JAN 2011 (CONTRACT)
Sybase
www.bipractice.co.za
SENIOR BI CONSULTANT & ETL ARCHITECT
Responsibilities
Provide knowledgeable and accurate advice in Data warehouse design using the Kimball methodology.
Design Data Warehouses based on the Kimball.
Create tables and indexes on Databases.
Optimize tables via normalization of tables and designs or adding of the correct indexes.
Build Data Warehouses based on a design.
Build ETL stage using IBM Information server (DataStage)/ Microsoft DTS (SSIS).
Database administration (triggers, backup, stored procedures, security) on SQL server.
Code stored procedures creating staging tables and generate reporting information to populate the staging tables for Tsogo Sun's reporting environment (Cognos).
Create a replicated SQL Server environment at Tsogo Sun, with their 3 regional servers publishing successfully every 30 minutes.
Create Triggers on all the tables on the Replicated servers, to populate staging tables with indicators for new/updated or deleted records.
Develop a number of stored procedures that pulls audit information from the database for troubleshooting and change audits.
Consolidate data from an out of scope SQL Server using only views and stored procedures whilst maintaining 100% uptime with information readily available to the users.
Finish a complete Data Warehouse solution (The first in SA using Datastage 8 and Cognos 8) at Tsogo Sun Gaming. A case study was done in the South African BI magazine called ITWeb.
Fulfill role as Lead ETL Developer on Teba Bank SA project; build an ODS and a Data Warehouse.
Implement procedures and troubleshoot guides for the Data warehouse.
Continually optimize the Data warehouse and the coding behind it.
Data massaging.
Create tables and indexes on Sybase IQ (using T-SQL).
Create stored procedures on Sybase IQ (using T-SQL) to manage the “Upsert” of records from the ETL tools.
Create a number of views in SQL Server (T-SQL), Oracle (PL/SQL) and Sybase IQ (T-SQL) to optimize the queries running on the Database.
Facilitate training in Datastage essentials, Datastage advanced and Infosphere Administration courses.
Setting up and stabilising development environment (specifucally IBM IS environments)
Managing the Datastage Development environment at Standard Bank AIMS
Setting in motion the datastage development at Medihelp (analyzing the environment and developing template jobs to be used by the company)
Certifications
IBM Solutions Developer and Datastage trainer.
Certification in Datastage 7.5 and 8.1.
Certification in Information Analyser 8.1
Technologies
QL Server 2000
SQL Server 2000 DTS packets
SQL Server 2005
SQL Server 2005 SSIS
Sybase Power Designer
IBM Information Sphere (DataStage 8)
IBM DB2
Oracle 9
Sybase IQ
T-SQL
PL/SQL
Achievements
Involved in first Datastage 8 deployment project in South Africa. ITWeb compiled a case study on the work completed at Tsogo Sun.
Successfully completed Teba bank project as Technical lead. Project completed on time and supplied client with not only an ODS, but also a Data Warehouse reading from the ODS (The ODS was fed from 20+ source systems).
Was elected as part of “techie club” (Top 10 technical consultants) at Sybase South Africa for 2007/2008.
5.
JAN 2005 – MAR 2007 (CONTRACT)
Nampak Wadeville
www.nampak.co.za
BI CONSULTANT/BI DEVELOPER/BACK-END SUPPORT
Responsibilities
Manage Nampak Corrugator’s Data warehouse.
Develop and implement new Database designs.
Code stored procedures and triggers.
Schedule various Stored Procedures via SQL server job monitor.
Create SQL Server backups via query analyzer and restore the databases dynamically via query analyzer.
Create Triggers on the Data Warehouse to limit the IO required for change captures.
Create the entire load script of the Data Warehouse in stored procedures (Business Rules dictated that DTS could not be used for the load of data from the Corrugated Databases).
Create DTS packets to successfully extract and load data from various sources (incl. Excel, CSV files and SQL Databases) around the country.
Create a number of views on SQL Server to optimize reporting from the Data Warehouse.
Create a number of Stored Procedures to dynamically import data (using dynamic SQL).
Manage change control on the Data warehouse.
Implement procedures and troubleshoot guides for the Data warehouse.
Continually optimize the Data warehouse and the coding behind it.
Create and maintain the Data Analytical models in QLIKView.
Maintain and develop the QLIKView web front-end and environment.
Technical expert and consultant.
Database administration (backups, triggers, security, stored procedures).
Change control administrator.
ERP software administrator.
ERP software support.
ERP software deployments and upgrades.
Designer / Developer to Crown Mines Data centre on all regional servers (Cape Town, Durban, PE, Wadeville and Rosslyn).
ETL and data massaging.
Technologies
SQL Server 2000
SQL Server 2000 DTS packets
Transact SQL (T-SQL)
Microsoft Projects
Visio
QLIKview
Excel 2003
Achievements
Single handedly in charge of Nampak Corrugated's Data Warehouse as well as the development and maintenance of their reporting environment using Qlikview.
6.
MAY 2003 – DEC 2004 (CONTRACT)
Nedcor Sandton
www.nedbank.co.za
SQL Developer
Responsibilities
SQL developer (at manager level) in a team automating the entire month-end volume extractions for the financial department of Nedcor.
Accumulate loose ending systems and personal spreadsheet culture into one giant financial system running on a 3 tier architecture, featuring various interfaces and reporting environments and all running on a tight schedule.
Re-design the database based on rules of normalization and optimization of activities.
Interpret business rules and the design and code scripts to extract financial volumes (on average about 2 million rows per product volume), and produce outputs in Microsoft excel format.
Design work in SQL 2000 server DTS packages.
Create DTS packets to pull in data from various sources (Excel Files, DB2 dat files and CSV files).
Create a number of stored procedures to manipulate and maintain data.
Create an archive strategy using stored procedures to archive data based on relevancy.
Create Dynamic SQL scripts as part of the Automated Month End processes.
Database Administration (triggers, security, stored procedures).
Technical specialist on the Jade server (The main server in the Financial MIS environment).
Projects
Re-design and re-development of Nedcor’s Product volumes database:
Entails the collection of raw data on account level from the Data Warehouse (DB2). Importing it into the Volumes DB. Assign raw data to specific customers through various scripts.
Re-design of the month end Bill split process:
Entails the collection of data from the volumes DB and data captured from different analysts. Splitting the data percentage wise to the different business customers and sorting the values into Billable and Non Billable Volumes.
I streamlined the process from 2-4 days to 4 hours.
Creation of a C#. NET application enabling someone without SQL knowledge to run the splits.
Usage of SQL Server 2000, C#. NET, Analysis Server, Cognos and DB2 Connect in completing all tasks.
Migrating and consolidating all Databases on the SAN.
Design and development of a Property model used for calculating variance and capacity as also forecasting budgets.
Redevelopment of a project accounting model that fully automates a project accounting month-end.
Creation of a Recovery Application and model, to be used by all the top Executives at Nedcor to view the cost and benefits of their recovery initiatives.
Technologies
SQL Server 2000
SQL Server 2000 Analysis Server
SQL Server 2000 Reporting Services
Visual C# .NET 2002/2003
ADO.NET 2002/2003
Cognos Impromptu
Excel 2000
SQL Server 2000 DTS packets
Achievements
One of the top 3 teams for the 2nd Quarter (Nedcor, SQL Developer, 2003).
7.
OCT 2000 – APR 2003
Potchefstroom University
www.nwu.ac.za
SYSTEMS ANALYST PROGRAMMER
Responsibilities
Systems Analyst Programmer in a team re-writing the administration systems of the university.
DBA work and Database design for certain projects.
Back-end maintenance; act as backup for the Systems Architect.
Administrator on Select enterprise software (For modelling purposes). (I am currently one of only a handful of people that can successfully install/Maintain Select Component Factory in South Africa)
Projects
Re-writing and re-design of the university’s Administrative systems. (The previous system was a green screen system written in Natural/Adabas which was not user friendly, and was lacking some critical components).
Consolidating of all the University’s SQL databases into one Database.
Creating DTS packets to import data from various sources.
Creating stored procedures to consolidate the data from staging tables.
Migration from Forte 4gl to UDS 5.
Migration of Forte 4 GL from Windows Server to Unix AIX server.
Integration of Forte with the Web focus reporting environment.
Deployment of the newest software through Install shield (Was in charge of Deployments).
Giving technical support to the people in the department.
Backup for the Systems Architect (Duties included: Design, System implementation, System Design on a high level, Systems Analysis, Network Analysis, Database optimization, network optimization.
Technologies
Forte 4gl
SQL Server 7/2000
Oracle 8.1.5
Web focus
C++ (In conjunction with Forte for compiling exe packages from an interpreted language)
Remedy
Select software modelling tools
ER-WIN
AIX UNIX (In conjunction with keeping the development environment (Forte) up and running)
Terminal Services
Install shield
Windows XP Professional
Windows 2000 Advanced Server
Achievements
Junior Colleague of the year (PU for CHE, Systems Analyst / Programmer, 2001).
One of the top 10 employees (PU for CHE, Systems Analyst / Programmer, 2002).
8.
MAR 1999 – OCT 2000
Potchefstroom University
www.nwu.ac.za
JUNIOR HELPDESK CONSULTANT
Responsibilities
Manage 300+ workstations and keep them up and running.
Work in team to check all the workstations (over 1500) for Y2K capability.
Provide support to various workstations: Software and hardware support. Delivery of new pc’s and installation of the OS and required software.
Troubleshoot network problems in various departments.
Technologies
Windows 3.1 / 95 / 98 / 98 2nd Edition / ME
Novell
TCP/IP
IPX
MacAfee
Office 97
Remedy
Compaq
HP
Dell
Other Projects
Database and front-end for Krappies Nursery School
Access and VB-Script
2 months (2002)
Create an Application/Database to receive a list of Students (First name, Surname, Address etc.) and store the data.
Every Quarter, the students are evaluated and the rating is entered into the System which produces a report for each Student.
Created on Access 2000 with VBA; modified to only run on Access 2000 runtime library to save costs.
Ratings for students are easily maintained and updated by importing ordinary text files with the required values and descriptions.
Personal Strengths
Strong planning, organising and monitoring abilities and an efficient time-manager.
Strong analytical skills - able to analyze complex data, draw meaningful conclusions and make business recommendations.
Excellent listener and communicator, effectively conveys information verbally and in writing.
Creative, pro-active and innovative.
Willing to learn and adapt to changing environments.
Accountable and responsible.
Focused, self motivated and target driven; determined to succeed.
Good interpersonal skills - works well with others, motivates and encourages.
Able to solve complex problems through strong planning and strong implementation skills, and help others deal with ambiguities.
Strong prioritisation and time management skills with particular focus on meeting deadlines.
Versatile and able to learn new tasks/skills quickly.
Interests
Technology, mobile and PC orientated; Music; Reading
References
Available on request.
Contact this candidate