Danhio Pietersen Email & Phone Number

Cape Town Area, South Africa

• Responsible for Monitoring, Operational Support and Management of a complex Data Warehouse on Sybase IQ 15.4 Multiplex• Part of team migrating ODS (Operational Data Store) from Sybase IQ 15.4 to Oracle 11g• Continue Monitoring, Operational Support and Management of one of the largest Data Warehouses on Oracle 12c• Planning, Implementation and Testing of DR Management• Change Management of the Application• Maintaining of ETL processes• Solving operational/data problems in consultation with other staff and management• Responsible for the data collection and collation processes• Maintain external data source service providers• Solving operational/data problems in consultation with other teams• Train and Mentor junior staff in team• Maintain Service Levels• Planning and Implementation of User Access• Role includes the Development and Design of database strategies, Monitoring and Improving database performance and capacity• Planning for future expansion requirements• Plan, co-ordinate and implement security measures to safeguard the database• Involved in AGILE planning, scrums and reviews• Customer Relationship Management• Manage Operational Service Levels

Cape Town Area, South Africa

– Support, Monitoring and Operational management of one of the largest Data Warehouse in Cape Town– Responsible for DR Management– Responsible for Index optimization– Required to control User Access– Responsible for the Design, Implementation, Maintenance and Repair of the database– Role includes the Development and Design of database strategies, Monitoring and Improving database performance and capacity.– Development to enhance ETL processes– Planning for future expansion requirements.– Plan, co-ordinate and implement security measures to safeguard the database– Customer Relationship Management including contract negotiations

Cape Town Area, South Africa

• Maintaining the accuracy, integrity and security of a complex information management system• Estimating development work• To maintain a constant standard of quality of data, data warehouse and databases• Maintaining of ETL processes• Analysis of daily market data feeds• Identifying and Resolution of data issues and keeping track of progress through Issue Tracking software• Responsible for ensuring the integrity of all data• All data cleaning / validation and verification protocols • Documenting of database design and structures• Solving operational changes through AGILE practices• Report on the quality of the data to management• Responsible for the data collection and collation processes• Responsible for Database Support and Maintenance• Assessment of current Information Architecture, and compiling of architectural development processes• Design, Implement and Test of DR plan• Ensure database security is enforced• Design, Plan and Implement Assist with database migrations• Design, Plan and Implement Sharepoint migration• Assist users with data extractions from datawarehouse/database• Responsible and managing of processes, procedures and infrastructure relating to data management• Maintain external service providers relationships• Solving operational/data problems in consultation with other staff and management• Assist ICT Manager with HelpDesk and any other IT related queries• Assist with Upgrading of Internal Business Application Systems• Analysis of daily market data feeds• Responsible for DBA activities

Cape Town Area, South Africa

• Maintaining the accuracy, integrity and security of a complex information management system• Estimating development work• Applying knowledge of regulations, policies, protocols and/or procedures to control and maintain accurate records• To maintain a constant standard of quality of data and databases (MySQl and SQL Server)• Bulk imports and updating data into databases, using DTS• Identify pockets of inaccurate or poor data• Responsible for ensuring the integrity of all data• All data cleaning / validation and verification protocols • Documenting of database design and structures• Solving operational/data problems in consultation with other staff • Report on the quality of the data to management• Responsible for the data collection process• Responsible for Database Support and Maintenance• Checking Database size and growth• Assessment of current Information Architecture, and compiling of architectural development processes• Create, schedule, test and restore database backups• Ensure database security is enforced

Cape Town Area, South Africa

• Maintaining the accuracy, integrity and security of a complex information management system• Estimating development work• Applying knowledge of regulations, policies, protocols and/or procedures to control and maintain accurate records• To maintain a constant standard of quality of data and databases (MS Access / SQL Server)• Bulk imports and updating data into databases• Identify pockets of inaccurate or poor data• Responsible for ensuring the integrity of all data• All data cleaning / validation and verification protocols • Documenting of database design and structures• Solving operational/data problems in consultation with other staff • Report on the quality of the data to management• Responsible for the data collection process and data capturing• Development and Implementing of Quality Control and Quality Assurance Procedures and streamlining thereof• Continuous review of QA / QC, Data collection, Reporting Processes• Responsible for IT Support and Maintenance• Checking Database size and growth• The execution, scheduling and compilation of various selected internal and external reports• Assessment of current Information Architecture, and compiling of architectural development processes• Planning, Designing and Implementing Systems Architecture – Data Warehouse• Perform Data Analysis and creation of Reports

• Maintaining the accuracy, integrity and security of a complex information management system• Estimating development work• Applying knowledge of regulations, policies, protocols and/or procedures to control and maintain accurate records• To maintain a constant standard of quality of data and databases (MS Access / SQL Server)• Bulk imports and updating data into databases• Identify pockets of inaccurate or poor data• Responsible for ensuring the integrity of all data• All data cleaning / validation and verification protocols • Documenting of database design and structures• Solving operational/data problems in consultation with other staff • Report on the quality of the data to management• Responsible for the data collection process and data capturing• Development and Implementing of Quality Control and Quality Assurance Procedures and streamlining thereof• Continuous review of QA / QC, Data collection, Reporting Processes• Responsible for hardware/software maintenance and trouble-shooting• Checking Database size and growth• The execution, scheduling and compilation of various selected internal and external reports• Compile client quarterly reports• Assessment of current Information Architecture, and compiling of architectural development processes• Planning, Designing and Implementing Systems Architecture – Data Warehouse• Perform Data Analysis

• Maintaining the accuracy, integrity and security of a complex information management system• Estimating development work• Project Management• Supervision/Coordination of Data Capturers• Documentation/Communication• Applying knowledge of regulations, policies, protocols and/or procedures to control and maintain accurate records• Assisting Nurses/Doctors with completing data sheets (CRF’s)• Maintenance and enhancement of skill levels to perform the functions of the position• To maintain a constant standard of quality of data and databases (SQL Server)• Bulk imports and updating data into warehouse using DTS• Assist the senior data warehouse developer with warehouse design and updates• Identify pockets of inaccurate or poor data• Responsible for ensuring the integrity of all clinical data• All data cleaning / validation and verification protocols • Documenting of SQL Server database design and structures• Solving operational/data problems in consultation with other staff • Report on the quality of the data to management• Responsible for the data collection process and data capturing• Development and Implementing of Quality Control and Quality Assurance Procedures and streamlining thereof• Continuous review of QA and QC Processes• Responsible for hardware/software maintenance and trouble-shooting• Checking Database size and growth• The execution, scheduling and compilation of various selected internal and external reports using Cognos ReportNet• Assisting with project quarterly reports (Cognos ReportNet) • Adhering General Clinical Practise Standards• Implement Systems Architecture – Data Warehouse• Assist with the Evaluation and Monitoring of the project

• Maintaining the accuracy and integrity of all data• Estimating development work• Project Management• Documentation/Communication• Applying knowledge of regulations, policies, protocols and/or procedures to control and maintain accurate records• Assisting Nurses/Doctors with completing data sheets (CRF’s)• Maintenance and enhancement of skill levels to perform the functions of the position• To maintain a constant standard of quality of data and databases (MS Access)• Identify pockets of inaccurate or poor data• Responsible for ensuring the integrity of all clinical data• All data cleaning / validation and verification protocols • Solving operational/data problems in consultation with other staff • Report on the quality of the data to management• Responsible for the data collection process and data capturing• Development and Implementing of Quality Control and Quality Assurance Procedures and streamlining thereof• Continuous review of QA and QC Processes• Responsible for hardware/software maintenance and trouble-shooting• The execution, scheduling and compilation of various selected internal and external reports• Adhering General Clinical Practise Standards• Managing data capturing staff• Maintenance and enhancement of skill levels to perform the functions of the position• To maintain a constant standard of quality of data and databases• Oversee the accurate collection and timely submission of study data• Solving operational/data problems in consultation with other employees and/or supervisors; • Responsible for the data collection process and data capturing• Responsible for hardware/software maintenance and trouble-shooting.• Adhering to International Data Management• Plan, Design and Implementation of Systems Architecture• Assist with organising and planning of regional and local training• Assist with coordination of research projects

• Assisting Research Consultant with Adhoc Database related issues• Quality Assurance control of data• Assisting Data Warehouse Developer with queries and extractions• Data manipulation• Standardisation of data• Assisting consultant with formulating reports• Troubleshooting

• Keeping up with new developments and trends• Understanding, communicating, developing, fixing, documenting, testing and running the GAP DB model (Sybase)• Doing DB development and DB Support (Sybase)• Estimating development work• Tracking work against estimates• Assist developers in modeling application database tables• DB Modeling• Sybase DB definition• Stored Proc Development (Sybase, isql)• Project Management• Being involved in drafting URS (User Requirement Specifications)• Assisting the DBA with Adhoc DB administration, ie. User access, backups, bringing DB’s online, etc• Database Design & Architecture • Documentation/Communication

• Data manipulation of behalf of clients through efficient use of available IT tools • Data extraction and correction using tools such as SQL, MS Access and Sybase.• Checking quality of data• Data analysis• Segmentation and Profiling of data• Ensuring correct processes are applied• Training of junior staff members• Creating, updating and modifying of database tables for production• Testing of software applications• Creating test cases and scenarios for data applications testing• Creating error log files of data manipulated by applications• All data extracts to be in accordance with client requirements• Maintenance and enhancement of skill levels to perform the functions of the position• Ensuring client’s need are met through quality of the products• Setting priority of certain jobs according to the evaluation of processes involved• Supplying correct data to clients for Marketing and CRM solutions• To maintain a constant standard of quality of databases throughout production• Ensuring that sales get the best support on key-risk factors pertaining to quality of databases and client briefings• Ensuring of production backups