Deidre Diedricks

CURRICULUM VITAE – DEIDRE ANNE DIEDRICKS Residential Address:31 Boston Road Austerville Durban 4052 Postal Address:31 Boston Road Austerville Durban 4052 Telephone:(Cell- After hours031 - Office hours-Email: - PERSONAL DATA Surname:Diedricks First Name(s):Deidre Anne Identity Number:- Date of Birth:22 October 1974 Marital Status:Married No. of Dependants:2 Driver’s Licence:Code 08 Health:Excellent Race:South African Citizen (Coloured) Criminal Record:None EDUCATIONAL DATA Last School Attended:Fairvale Secondary (1988 – 1992) Highest Standard Passed:Matric (Exemption) Subjects Passed:English Afrikaans Mathematics Physical Science Biology History Technikon Attended Name of Technikon:ML Sultan Diploma obtained:ND: Information Technology Subjects Passed:Information Systems I Information Systems II Information Systems III Development Software I Development Software II Development Software III Systems Software II Technical Programming (Pascal) Commercial Programming Management Accounting Information Technology Skills I COURSES AND CERTIFICATES Business Analysis FundamentalsApril 2015 Faculty Training Institute (In House at Insight Consulting, Durban) QlikView Designer and Developer CourseFebruary 2012 Insight Consulting, Durban Implenting and maintinaing Microsoft SQLAugust 2011 Server 2008 Reporting Services Bytes Technology, Westville (Certificate Obtained) Cognos 8 Report Authoring Part 1October 2008 Synergy Computing, Westville (Certificate Obtained) Quick Books Pro 2006August 2007 (Certificate Obtained) Pastel Payroll Training Academy Villa Avant Garde 96 Armstrong Avenue La Lucia Service ManagementJanuary 2005 Foster-Melliar Cognos Metrics Manager Administration Synergy Computing, Westville (Certificate obtained)February 2004 HUMMINGBIRD DOCUMENT MANAGEMENTDecember 2004 SERVER MSSQL enterprise Server AdministrationMay 2003 IT Intellect (Certificate obtained) Administering an MSSQL ServerMay 2003 Powerplay OLAP TransformerSeptember 2001 Synergy Computing, Westville (Certificate obtained) Cognos Impromptu User ReportsSeptember 2001 Synergy Computing, Westville (Certificate obtained) Cognos Impromptu AdministrationSeptember 2001 Synergy Computing, Westville (Certificate obtained) Powerplay User ReportsAugust 2001 Synergy Computing, Westville (Certificate obtained) Introduction to Crystal ReportsFebruary 2001 (Certificate obtained) In-house Visual BasicApril 2001 SKILLS : QlikView COGNOS MSSQL Reporting Services MSSQL Database Development MSAccess Database development EMPLOYMENT HISTORY Name of firm :Central Applications Office (CAO) Position held:SQL Data Analyst (May 2017 – Current) Industry : Main Duties:Gathering of business requirements and data analysis for development of QlikView Business Intelligence models. Assisting with user reports and data extractions from SQL Database. Providing daily support to users across the organization. Name of firm :Insight Consulting Position held:BI Consultant (February 2012 – Current) Industry :Business Intelligence Consulting Main Duties:Gathering of business requirements and data analysis for development of QlikView Business Intelligence models. Assisting with user reports and data extractions from various databases and systems. Providing daily support to users across the organization. Assisting with QlikView server problems and connectivity issues Reason for leaving:Employed at Central Applications Office Name of Firm :Metrorail Durban Position Held:Programmer (Business Intelligence) (February 2008 – January 2012 ) Industry:Government Parastatal Main duties:My main job funcions include analyzing extracts and presenting information to the business based on business requirements using various methods i.e extracts from enterprise systems. Duties also include creating and maintaining Powerplay cubes, Impromptu Catalogs and reports, and to provide Management with the information that they require using MSSql Extracts, MSAccess Queries, Impromptu, Crystal Reports. I am responsible for maintaining the databases that I work with. These are primarily MSSQL Databases. This includes creating new databases, exporting and importing data, extracting data using SQL code. Other smaller databases are created using MSACCESS. I am also responsible for ad-hoc reports, daily, weekly and monthly reports which are distributed to a variety of users ranging from operational clerks to general management. I am currently implementing our current reports to be executed from the MSSQL Reporting Services. In addition to this, I have also been involved in extensive systems testing of in-house developed systems. Part of my duties here was to assist the development team in defining business rules, assisting with user training as well as testing the integrity of the data exported from the developed system. Reason for leaving:Employed at Insight Consulting Name of firm :Spring Forest Trading 61cc Position held:Office Administrator (September 2005 – January 2008) Main duties:Managing the company. I was responsible for the day-to-day operation of the office. This includes invoicing clients using Quickbooks accounting software, tracing payments, and ensuring that the general office duties are tended to efficiently and timeously. In addition to this, I have maintained the data on an MSAccess database. Reason for Leaving:Relocated to Durban Name of firm :Metrorail Durban Position held:Programmer (Business Intelligence) (August 2002 – March 2005) Industry:Government Parastatal Main duties:Included analyzing extracts and presenting information to the business based on business requirements using various methods i.e extracts from enterprise systems. My duties also include creating and maintaining Powerplay cubes, Impromptu Catalogs and reports, and to provide Management with the information that they require. I am responsible for maintaining the databases that I work with. These are primarily MSSQL Databases. This includes creating new databases, exporting and importing data, extracting data using SQL code. Other smaller databases are created using MSACCESS. I am also responsible for ad-hoc reports, daily, weekly and monthly reports which are distributed to a variety of users ranging from operational clerks to general management. Reason for leaving:Family relocated to Eastern Cape. Name of firm :NBS (A Division of BOE Bank Limited) Position held:Programmer / Data Warehouse Analyst (August 1999 – July 2002) Industry:Financial Institute Main duties:Included analyzing extracts and presenting information to the business based on business requirements using various methods e.g. Coding in mapper, cobol, Louis, SQL, visual basic, Crystal reports. Develop and maintain management information applications for ongoing operational, sales and performance purposes e.g. Intranet Reporting systems, Powerplay cubes, Visual Basic applications. Design, develop and maintain database tables, datawarehouses. Extract and forward data for marketing campaigns. Provide ongoing support to clients ranging from operational clerks to general manager Reason for leaving :Retrenched due to the sale of the NBS Homeloans Book to First National Bank Name of firm:Durban Metro Council Position held:Programmer (July 1998-July 1999) Main duties :From July 7 – July 14, I attended an in-house IDEAL/DATACOM training course. My duties included providing software support to two of the systems developed for Durban Metro namely the Rates and Housing systems. I am well aquatinted with the IDEAL/DATACOM programming environment since my duties included writing programs and maintaining existing programs in the above environment. I have written a few programs for the following : SystemContact Person Rates Kenny Kanni Housing Donald Hodges Building Environment Kenny Kanni Durban City Police Rabbie Dwarika Corporate Job Costing Logan Govender Qpac, Pay & Leave Hilda van Rooyen I am also familiar with Flow Diagrams. Reason for leaving:Employed by NBS Name of firm:Microvision Software Position held:Trainee programmer – programmer (February 1996 – June 1998) Main job functions :My main duties were to provide software and technical support to the Master-C School Administration System which was developed by MicroVision Software. This system was developed in Clipper and ran from MS-Dos. I also developed two systems, Creditors and Timesheets in Powerbuilder 5.0. The Creditors System was developed to capture all incoming and outgoing invoices for VAT purposes. The Timesheets system was developed for employees to keep track of their job schedules. Reason for leaving:Employed by Durban Metro Council REFERENCES 1. Peter Smorfit IT Manager Illovo Sugar Tel :- Cell :- 2. Linga Naidoo HR Metrorail Durban Tel : 072 - 3. Reshma Pillay Management Accountant Metrorail Durban Tel : 083 - 4. Colin Fourie (Managing Director) Microvision Software cc Tel :- CV-Deidre.docWednesday, March 15, 2017