Data Engineer and Data Warehouse Manager with over 15 years of successful experience in

databases and data warehousing. Recognized consistently for performance excellence and contributions to success in financial industry. Strengths in data warehouse query optimization and Cloud solutions backed by training in Google Cloud Platform (GCP). Skills

Excellent

SQL (BigQuery and TSQL) proficiency

Excellent

Data Warehousing

Excellent

Data Analysis

Very Good

Python

Excellent

Data Analysis

Very Good

SQL Extraction Transformation and Loading (ETL)

Very Good

Big Data

Work History

Mar 2020

- Current

Data Warehouse Manager

Outsurance, PRETORIA, Gauteng

Created and implemented migration strategy to move on-prem data bases to BigQuery, using an use case-based incremental approach. Selected methods and criteria for warehouse data evaluation procedures. Coordinated troubleshooting support for warehouse personnel. Performed systems and data analysis using variety of computer languages and Gerhard Van Deventer

Data Warehouse Manager And Data Engineer

Address 26 Rockwood Crescent, Pretoria,

Gauteng, South Africa, 0044

Phone 278-***-*****

E-mail adcfd0@r.postjobfree.com

LinkedIn https://bit.ly/2xZkdAB

procedures.

Dec 2018

- Mar

2020

Technical Team Lead

OUTsurance, Pretoria, Gauteng

Designed and developed BigQuery and analytical data structures. Planned and implemented security measures to safeguard vital business data. Led, engineered and architectect cloud-based solutions for digital reporting platforms

Guided and trained co-workers on emerging technologies in order for them to optimally perform their duties

Designed and implemented cloud security best practices so as to establish a safe and secure working environment

Piloted the migration of our on-premise data warehouse to the cloud Developed cloud-based solutions for integration of heterogeneous data sources into a unified data lake

Jan 2014

- Dec

2018

Business Intelligence Developer

OUTsurance, Pretoria, Gauteng

Developed intelligence-sharing dashboards, providing company-wide access to collected data.

Maintained proficiency with latest database technologies, including MSSQL and Power BI.

Planned, designed and implemented diverse business intelligence solutions. Generated reports, updated spreadsheets and presented results. Monitored and optimized SQL Server performance.

Wrote MSSQL scripts for daily maintenance activities, including indexes and tables analyses.

Oct 2008

- Dec

2018

Senior Database Administrator

OUTsurance, Centurion, Gauteng

Created scripts and processes for data integration and maintenance. Created and implemented database designs and data models. Set up and controlled user profiles and access levels for each database segment to protect important data.

Wrote and maintained technical and functional specifications to document database intentions and requirements.

Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process.

Planned and implemented security measures to safeguard vital business data. Authored and coded logical and physical database descriptions. Recommended architectural improvements, design solutions and integration solutions.

Designed and implemented new server standards for core business services. Jan 2003 Database Administrator

- Oct

2008

EOH, Johnnesburg, Gauteng

Supported multiple concurrent projects enabling delivery efficiencies and technical resolution.

Designed and implemented TSQL queries for reporting and complex solution development.

Maintained complex T-SQL queries, views and stored procedures in multi- database environment with little supervision.

Created optimal technical solutions to user needs through research and in-depth system analysis.

Documented and analyzed business reports for prompt communication, follow-up and ongoing support.

Education

Jan 2004

- Jan

2015

Bachelor of Science: Computer Science And Programming University Of South Africa - South Africa

Graduated cum laude

Software

Excellent

BigQuery

Excellent

Google Cloud Platform (GCP)

Very Good

Apache Airflow

Very Good

Python

Excellent

TSQL

Excellent

SQL Server

Very Good

Certifications

Oct 2019 Google Cloud Certified Professional Cloud Architect Mar 2019 Google Cloud Professional Data Engineer

Dec 2018 Google Cloud Associate Cloud Engineer

C#

Contact this candidate