Caroline Barnard Email & Phone Number

Cape Town

Seconded to The DOT Group in London, technical data lead on Electrolux account, responsible for data integration and enrichment environment supplying master data to spares and accessories webshops.

Cape Town And Johannesburg, South Africa

Take over and complete Cashbuild (customer) data migration for SAP conversion.Article and Vendor replenishment analysis and development, convert existing Sales History migration (on MySQL) to efficient SQL Server process. Redesign Redundant Stock process to resolve significant timing issues. Data Migration Analysis for JD Group SAP CRM implementation (includes a deduplication and consolidation of customer master data on the way into CRM). Reference/master data analysis and mapping documentationData Quality analysis and recommendations for JD

Cape Town, South Africa

(Global Vision - client)Product architecture for in-house product MDM capabilityDesign and development of error-tolerant index for fuzzy lookup, using q-gram inverse index to determine candidate set followed by JaroWinkler string metric for more accurate matching.(Vodacom) Design of summary data quality metrics and reporting processes, repository architecture, Datanomic dn:Director integration, Strategic Data Quality and Master Data Management Discussion Document for Vodacom

Cape Town, South Africa

Masthead Broker Services: analyse, specify and build a data takeon for Sanlam broker commission data to integrate into Masthead BI data warehouseAllan Gray: General support and consulting on SQL Server 2005Old Mutual Broker Distribution: take over architecture of broker management BI system, migrate existing warehouse to new platformCity Capital: Define data migration approachSelestia/Skandia BI Integration (international project) – redesign and tune ETL, redesign transaction warehouse and processes, migrate existing reports to new platform – technical lead and project managerAirborne Data Competency co-leader

Cape Town, South Africa

Product Architect and development lead designer: in-house data quality product with profiling, cleansing, standardization, probabilistic matching, data decay models and trust-based consolidation capabilities; client implementations and consultancy on data quality, eg Afrox, Standard Bank, Sanlam (WIS); data architecture for clients, data migration strategies and project management for clientsSuccessful migration of very complex Amarta and LD data onto SDT Life for Old Mutual African Operations (Kenya and Malawi)Initial architecture for Vodacom call centre bonus BI system

Mcgregor, South Africa

Spent an idyllic few years in the country, taught myself web design and development and managed to make ends meet (just!), especially with the help of a few performance contracts.

Bellville, Cape Town

Short term tune-up on some critical data warehouse programsPerformance consultancy on data warehouseSMF costs on one program reduced from R140 000.00 pm to R39 000.00 pmMonitor Sanlam Life online/batch systemsMake tuning recommendations and monitor implementation

London, United Kingdom

Short-term performance tuning contractTune high-volume retail MIS systemsDesign & manage implementation of programmed solutions for severe performance problems including severely skewed data Install performance and productivity toolsProject definition and Terms of Reference for tool evaluation project

Bellville, Cape Town

Short-term contract to overcome severe performance problems on the FinPro projectSet up DBA procedures to provide service and support to FinProOptimisation of current production releasePerformance and design consultancy (v4.1, v5)Project management and planning Some elapsed time reductions obtained:- 7 hours reduced to 3.1 minutes (batch)- 150 hours reduced to 3.5 hours (batch)- 2.5 minutes reduced to 1.5 seconds (online)Note that the batch improvements were achieved only after extensive redesign of the programs.

Cape Town

Responsible for management of DB2 subsystem (v3.1)Performance specialistApplication support Team Leader from November 1996Includes developing DBA team into a self-managing team between May 1997 and Feb 1998

Cape Town

SAP/DB2 Implementation Project at Engen (v2.3)Recovery/Restart Procedures and Recommendations at CaltexPresented advanced Recovery/Restart educationHPS Pilot Project Technical Support at SANLAM

Bellville, Cape Town

Installation and customisation of DB2 sub-system (v2.2, 2.3)System management proceduresPerformance management including application design recommendations, resolution of performance issues encountered during conversion of Walker accounting system from DataCom to DB2. Application supportSQL training for programmersAssembler utilities

Certification In Companion Animal Behaviour, Animal Behaviour And Ethology, Distinction

Non-Degree Purposes, Psychology I And Ii

Ba (Hons), Pure Mathematics

Bachelor'S Degree, English, Mathematics

Activities and Societies: YMCA