Gary Odendaal, SQL Report Writer

Gary Odendaal

SQL Report Writer

VAT I.T

Location
United Arab Emirates
Education
High school or equivalent, Matric
Experience
7 years, 1 Months

Share My Profile

Block User


Work Experience

Total years of experience :7 years, 1 Months

SQL Report Writer at VAT I.T
  • South Africa
  • April 2015 to November 2015

Reporting services creation
Reporting services trouble shooting
Systems troubleshooting
Corrections of data
Utilization and Moving of Cash in SQL
System Support
User support - Dragon (In-house System)
Adhoc Reports
Monthly reporting

Completed a companywide report using Salesforce and SQL to measure the services and sales of products not yet supported by the companies systems allowing for financial tracking of the viability of launching the products.

Data Integrity Analyst at IMS Health
  • South Africa
  • November 2013 to April 2015

Quality Control
Corrections Analysis
Customer Bridging QC
Product Bridging QC
Production QC
Ad Hoc Queries and Reports
Process improvement (Kaizen facilitator)
Process Automation
Report Building

Facilitated a Lean Kaizen to improve and change the business quality control process improving from an error rate of 20% to an error rate of 1% restating the entire medical market in South Africa.

Senior Data Analyst at Real People
  • South Africa
  • November 2008 to November 2013

Developing Business Intelligence Solutions
Daily reporting on trends and production
Campaign creation and administration
Process analysis
Monthly operations reporting
Entry level project management

Migrated the entire sales team to a mobile CRM system using Microsoft Dynamics. Was responsible for the entire project including planning, development, deployment, staff supervision and training.

Education

High school or equivalent, Matric
  • at Beaconhurst School
  • November 2006

Specialties & Skills

Data Analysis
Data Quality
ANALYSIS
AUTOMATION
BUSINESS INTELLIGENCE
PROCESS ENGINEERING
PROJECT MANAGEMENT
REPORTS
STAFF SUPERVISION

Languages

English
Native Speaker
Afrikaans
Native Speaker

Training and Certifications

Course 6235 - SSIS SQL Server 2008 (Certificate)
Date Attended:
January 2012
Excel Foundation Level (Training)
Training Institute:
Real People
Date Attended:
June 2009
Excel 2007 Basic / Intermediate (Certificate)
Date Attended:
April 2011
Word Foundation Level (Training)
Training Institute:
Real People
Date Attended:
July 2009
Course 6234 - SSA-SQL Server 2008 (Certificate)
Date Attended:
November 2011
Excel Advanced Level (Training)
Training Institute:
Real People
Date Attended:
June 2009
Access 2007 Basic / Intermediate (Certificate)
Date Attended:
March 2011
Excel 2007 Advanced (Certificate)
Date Attended:
June 2011
Maximising Pivot Tables 2007 (Certificate)
Date Attended:
June 2011
Course 6236 - SSRS SQL Server 2008 (Certificate)
Date Attended:
February 2012
Excel Intermediate Level (Training)
Training Institute:
Real People
Date Attended:
June 2009

Hobbies

  • Reading, Writing, GIS Mapping, Data Analysis, Research
    Published ebook 10Step Guide to Management Skills