Contact
***********@*****.***
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