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.

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.

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:

Confidential

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 Confidential 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 Confidential 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

Confidential

ETL Line Manager

Responsibilities:

• Team lead for the Confidential ETL resource working on various Confidential projects
• Designing optimum solutions based on input from the customer, as to what is expected, and what is available
• Resource planning based on Confidential 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 Confidential 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

Confidential

DATA INTEGRATION EXPERT

Responsibilities:

• Maintaining the current Confidential 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

Confidential

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.
• 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 Confidential IQ (using T-SQL).
• Create stored procedures on Confidential 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 Confidential 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)

Technologies:

• QL Server 2000
• SQL Server 2000 DTS packets
• SQL Server 2005
• SQL Server 2005 SSIS
• Confidential Power Designer
• IBM Information Sphere (DataStage 8)
• IBM DB2
• Oracle 9
• Confidential IQ
• T-SQL
• PL/SQL

Confidential

BI CONSULTANT/BI DEVELOPER/BACK-END SUPPORT

Responsibilities:

• Manage Confidential 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

Confidential

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

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

Confidential

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

Confidential

JUNIOR HELPDESK CONSULTANT

Responsibilities:

• Manage 300+ workstations and keep them up and running.
• Work in team to check all the workstations (over 1500) for Confidential 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 2 nd Edition / ME
• Novell
• TCP/IP
• IPX
• MacAfee
• Office 97
• Remedy
• Compaq
• HP
• Dell