Stephan Neethling Email & Phone Number

Cape Town Area, South Africa

SQL ETLs supporting the BI team

Ensures efficient access to data, working with data analysis and database design functions where appropriate.1. Merging data from subsystems with HP Asset Manager.2. Setting up online reports using SQL Reporting Services.Development:3. C#.Net Data Web Application: Tracking Assets in process flow.4. C#.Net Data Web Application: Asset Register.5. C#.Net Data Web Application: Employment Register.6. C#.Net Data Web Application: Network Access Register.7. C#.Net Data Web Application: "My Services" Tracking movement of employee services.8. C#.Net Integration Services: Push SAP-Employee reporting structure to Active Directory.9. C#.Net Integration Services: Push SAP-Employee position title to Active Directory.Other DBA Duties:10. Undertakes regular exercises to optimise database performance.

MS SQL 2000, 2005, 2008.Database Design, Replication and Adminstration1. Upgrade 30 SQL Replicated servers from SQL 2000 to SQL 2005 and there after to SQL 2008Troubleshoot replication issues while upgrading SQL servers.2. Backup & maintain all SQL servers3. Deployment of new replication environmentDeployment of new replication environment with SQL generated scripts.4. Developed C#.Net Web Application to deploy SQL scripts to multi servers targeting selected DB’s. 5. Developed SQL procedure to create and maintain missing indexes.

SQL 2000 Projects : 1. Upgrade SQL 2000 32bit cluster to SQL 2005 64bit cluster.Written all SQL scripts for the upgrade procedure. 2. Develop and Program SOX Procedures LogC# Web Application to log Timesheets to a MS SQL 2000 DB.3. Develop and Program Timesheet Website.C# Web Application to log Daily Tasks to a MS SQL 2000 DB.4. Develop and Program Budget WebsiteC# Web Application to log Budget Request and Transactions to a MS SQL 2000 DB with approval machanism inclueded. 5. Developed and Program SQL mechanismTo monitor SQL Server 2000 events and replicated events to one central server from where events is e-mailed to relevant business units.6. Backup & maintain all SQL servers (+- 70 SQL Servers.)7. Developed and program monthly summarized history reports for the call centre. (SQL 2000 Reporting Service & Visual Studio 2003 .NET)

Database design & Program DB Scripts.Writing Stored Procedures & Triggers.Implementing final database scripts.Quality Assurance for systems running on the DB system.Windows NT 4 Administrator (Small Business Server 4.5)E-mail – Administrator (MS Exchange 5.5)SQL 6.5 & 7.0 Database AdministratorFruit delivery system for Elgen Fruit JuicesFruit Reception based on multiple offloads per multiple producers for one truck deliveryMember Management System – Analysis, DB Design & ImplementationDeveloped an Error log system. (Access Application & SQL 6.5 Database)Developed a Time sheet system. (Access Application & SQL 6.5 Database)Developed a Contact Information system. (Access DB & Application)

Bachelor'S Degree, B.Comm, Financial Accounting, Statistics, Computer Science

High School, Matric