Contact

adqk7l@r.postjobfree.com

www.linkedin.com/in/chaim-

katz-468a101b (LinkedIn)

Top Skills

ETL

Data Warehousing

Data Visualization

Snowflake

PL/SQL

Certifications

Data Wrangling, Analysis and AB

Testing with SQL

Distributed Computing with Spark

SQL

Hands On Essentials - Data

Warehouse

SQL for Data Science

Oracle Database 10g Administrator

Certified Professional - Version

Retired

Publications

Mastering Oracle PL/SQL: Practical

Solutions

Chaim Katz

Business Intelligence Specialist

Jerusalem

Summary

Database professional with experience analyzing, modelling, scripting, implementing, tuning, reporting, visualizing and maintaining production applications.

Over 10 years in a data warehouse environment

Over 10 years as a production and development database administrator

Excellent rapport with users and managers

I have taught database courses at the college level, and worked as a volunteer elementary school teacher (Logo/Lego Robotics ). I have written for trade journals and for Apress.

Experience

TouchTunes

Data Warehouse Business Intelligence Developer

October 2010 - January 2021

Designing star schemas, writing ETL frameworks (MySQL, PL/SQL), Creating dashboards and data visualizations, end-user reports as needed. OBIEE 11g/12c

Relational databases, JSON, XML, text files

Oracle Database Developer

November 2003 - September 2010 (6 years 11 months) Mirabel, Quebec Canada

Supporting Perl DBI engineering applications. Working with database administrators in performance tuning and solving database related problems. Responsible for creating and maintaining CF-18 Data Warehouse. Creating database driven web applications.

Bombardier Completion Center

Oracle Production DBA

October 1999 - October 2003 (4 years 1 month)

Responsible for performance, security, upgrading, backup and recovery of a number of Oracle production databases. Automated/scripted data transfer routines between heterogeneous data sources and Oracle databases.

Education

McGill University

B. Sc., Molecular Biology

McGill University

Accounting and computer science studies

Contact this candidate