Experience

  • Data Specialist / Communications Co Ordinator

    at Customer Care Solutions

    January 2012 - October 2018

    Province of the Western Cape

    Data importing, extracting, formatting, capturing, prepping, deduping, data manipulating and segmenting from internal and external data sources in various file formats. Pre- and post-campaign analysis on data set/s to establish campaign feasibility. Data Analysis of customer data. Daily, weekly and monthly reporting. SQL querying experience. Pivot table and charts utilized to turn raw data into information. Performing Vlookups in MS Excel to cross-reference data and identifying duplicate record/s. Performing data quality checks on internal and external data before uploading utilizing business rules and my own techniques. Email and SMS campaign distribution to the requested customer target list. Set up, edit and troubleshoot pre-coded HTML email templates utilizing Adobe Dreamweaver. CRM system exposure (Examine leads and customer details for accuracy and data completeness). Test in-house systems, 3rd party tools and data related applications designed by the IT department.

  • SQL Support / Administrator

    at Anthony Richards and Associates

    December 2007 - October 2011

    Province of the Western Cape

    Data capturing, uploading, downloading, extracting, formatting, prepping, deduping, data manipulating and segmenting from internal and external data sources in various file formats. Performing data quality checks on internal and external data. SQL querying experience. Reporting provided on request from in-house tools or ad-hoc. Extracting and processing financial transactions, generating invoices from an in-house application and liaising with the financial department and clients. Distribution of promotional SMS as per schedule, daily, weekly and monthly. PC Troubleshooting and basic Windows server troubleshooting as well as PABX phone systems assistance where necessary. Basic network setup as per request.

Education

  • Diploma in Information Technology

    at Oval International Computer Education

    2002 - 2005 (3 years) Province of the Western Cape

  • Matric Certificate

    at Modderdam Senior Secondary School

    1996 - 2000 (4 years) Province of the Western Cape

Knowledge and keywords

Languages

  • English Negotiation

  • Afrikaans Negotiation

Hives