Chaim Katz

Chaim Katz Business Intelligence Specialist -Jerusalem, Israel 20 years experience in taking complex ideas and communicating them simply. Consistent data modeling and table design skills. Superb SQL and data warehouse skills. Analytical and detailoriented. Experienced in ad-hoc and incremental reporting. Familiar with data visualization tools. Work Experience Business Intelligence Team Lead TouchTunes Music Corp. (Octave group), Montreal, Quebec October 2010 to January 2021 (10 years) o Translated business requirements into efficient presentation objects. o Wrote complex SQL queries against large data sets. o Ensured accuracy and reliability of data o Fixed issues in a fast-paced environment. o Owned the design, development, maintenance, and distribution of key business metrics and reports. Data Warehouse Analyst CAE Inc, Mirabel, Quebec. November 2003 to October 2010 (7 years) o Developed scalable res-usable data models to meet business needs. o Wrote ETL procedures. o Produced technical and user documentation o Worked closely with stakeholders to define metrics, reports, and dashboards. Production Database Administrator Bombardier Completion Center, Dorval, Quebec. October 1999 to October 2003 (4 years) o Responsible for Oracle databases that supported enterprise-critical applications. o Developed and tested database backup and recovery routines. o Wrote scripts to automate data transfer between heterogeneous data sources. Teacher o o Taught Introduction to Database Systems for Concordia University Montreal, Graduate Diploma Program in Computer Science Taught Logo programming language, and Logo/Lego Robotics on a volunteer basis to elementary school children Technical Reviewer and Author o Reviewed chapters of the following trade books for Wrox Press and Apress: • Expert One-on-One Oracle, Thomas Kyte, Wrox Press (2001) • Beginning Oracle Programming, Sean Dillon, Wrox Press (2002) • The Art and Science of Oracle Performance Tuning, Christopher Lawson, Apress (2004) o o Wrote two chapters in Mastering Oracle PL/SQL, published in 2004 (OakTable Press Series) Contributed articles to a number of trade newsletters between 1999 – 2004: Example subjects: Statistical line charts with Oracle Discoverer, Dynamic web pages with XSQL, Coding style in SQL/PSM, PL/SQL Server Pages, Extending Oracle’s Enterprise Manager with OraTcl, Application Migration from MS SQL Server to Oracle. Education Bachelor of Science (Molecular Biology), McGill University Accounting and computer science studies McGill University Introduction to Java Programming, McGill University continuing education (2002) Certificates Jackson Structured Programming Oracle 7 certified professional Database Administrator Oracle 10g certified professional Database Administrator