VICTOR KHABAS

Vaughan, Ontario

(***) *** - ****

E-mail: adoq0g@r.postjobfree.com

Career Objective: BI/ETL Data Warehouse Designer and Developer, Data Analyst

Business Intelligence Visualization Tools: Power BI, DAX Studio, Excel with PowerPivot

Development: SSAS (Tabular/ Multidimensional data models)

Modeling and visualizing data with DAX and MDX

SSIS, SSRS

Power BI, DAX Studio, Excel with PowerPivot, DevExpress

SQL Server v.2008/R2 – 2017, Transact SQL

C#, VB.net, ASP.net, JavaScript, VBScript

Visual Studio 2010-2015, TFS Version Control

Informix, MS Visual Source Safe, Access

OLAP/OLTP specialization:

Design and Development of Relational Databases, Data Warehouses, Multidimensional, and Tabular Cubes.

Creating Data Marts with Star/SnowFlake/Many-to-Many schemas.

Slow Changing Dimensions with SCD2.

SSIS packages with incremental extractions for Data Warehouses.

Automation of SSAS cube processing.

Using SQL/MDX/DAX queries for data analysis and reports.

Transact SQL stored procedures, triggers, CTEs, user-defined/ranking functions.

Database optimization, performance tuning.

ETL development:

ETL Mapping /Profiling /Cleansing /Auditing data.

Import/Export data in different formats using SSIS packages.

Deploying and configuring SSIS packages.

Creating scheduled jobs with SSIS.

Loading full and incremental data into Enterprise Data Warehouses.

Database Design Tools: MS Database Designer, Analysis Services Designer (VS),

ERwin, S–Designer.

Platform: MS Windows

EMPLOYMENT HISTORY

BI Developer

Dynacare, Brampton September/2020 – September/2021

Contract

- Integration and conversion logistics data for CRM Dynamics 365. Clarifying business rules.

Creating Data Dictionaries and mapping fields from different sources based on business

requirements. Creating SSIS packages, stored procedures, views, functions, and scripts for data

loading. Problem investigation.

- SSIS packages for automation of order entering medical data from different sources (SFTP, excel,

csv, json, SQL Server.

- PowerBI reporting for specimen tracking (reports, Power Query, dashboards, DAX).

Senior BI Developer

Brookfield Global Integrated Solutions, Markham July/2019 – April/2020

Contract

- Design and structural optimization of Tabular Models with DAX calculations (Visual Studio).

- Power BI reporting with Import/Direct/Live data source connections.

- Row-Level Security (RLS) in Power BI.

- Power BI Service with Dashboards.

- Power Query for shaping, transformation, and cleansing imported data.

- Conversion MDX expressions to DAX in SSIS packages.

- SSIS packages for loading data in EDW from different sources

(Oracle, SQL Server, Excel, text files).

- Automation of incremental extraction, loading EDW, and processing Tabular Models.

- Using SSIS Task Factory components to accelerate data load into data warehouses.

- TFS Version Control for SSIS and SSAS projects.

Senior BI Developer

Information Technology Solution Providers Inc, March/2019 – June/2019

Toronto Contract

- Creating Power BI reports with DAX calculations.

- Receiving and consolidation data from different sources: MS SQL Server, Oracle, DB2,

MySQL, Excel, text files.

Senior ETL/BI Developer June/2018 – December/2018

Kinross Gold Corporation, Toronto Contract

Project: Transfer Pricing Integration

- Data migration ETL packages to transfer employee data to the Head Office database.

Project: Analysis of Stock Items Purchased on Contract.

- Design and creation of Data Warehouse.

- ETL packages to load daily snapshots into DW.

- Visualization data with Power BI and MicroStrategy.

Senior Data Warehouse/BI Developer Oct/13 – May/18

Bond Brand Loyalty, Mississauga Full Time

(former Maritz Canada)

Projects:

Design and creation of Data Warehouses and Cubes for the following companies:

Scene Cineplex, CIBC, Scotia, HSBC, Johnson&Johnson, London Drugs (SSIS, SSAS)

- Data Warehouse design, mapping data, dimensional modeling, and referential integrity.

- Conceptual, logical, physical data models.

- EDW design data marts with Many-to-Many relations between dimensions.

- Slow Changing Dimensions (SCD2) with Many-to-Many relations between them.

- Implementation of incremental data load for EDW with SSIS packages.

- Queering OLAP cubes with MDX/DAX. Creating calculated sets and measures.

- Analyzing fluctuation of customers in segments with MDX.

- Load, processing, and optimization of Multidimensional/Tabular Analysis Services databases.

- Synchronization of OLAP databases with XMLA.

- Automation of Cube processing on the ETL level with Analysis Management Objects (AMO).

- Dynamic creation of partitions for measure groups of cube.

- Ad-hoc SQL/MDX/DAX queries.

- Daily monitoring and fixing problems in case of failure of SSIS packages when loading data into

Data Warehouse and processing SSAS cubes.

- Tuning and performance optimization in ETL data flows.

- Reporting and visualization data with SSRS, Power BI, Tableau, Excel, DevExpress.

- Agile project development environment.

Senior Database Developer Mar/03 – Sept/13

The Marketing Store (Toronto) Full Time

Project: Triggered Email System for Transitions Optical USA/Canada

- Enterprise Data Warehouse/Cube design and implementation (VS 2008, SSAS);

- Loading dimension and fact tables in DW by SSIS.

- MDX querying data from cubes;

- Incremental extraction data.

- Creating Mapping Documentation (Word, Excel, Visio, PowerPoint);

- Database design (logical/physical models) with MS Database Designer;

- Import data from different sources (SQL Server, Excel, Access, Flat files);

- SSIS Profiling source data to meet quality standards;

- Cleansing and Validation of imported data;

- Scheduling emails according to their priorities and resolving conflicts (Transact SQL)

- Deployment SSIS packages to database server with configuration files;

- Reports of data dynamic trends (Transact SQL, SSRS);

- Backup and restoring of the Transitions Optical database (relational db);

- Creating scheduled jobs for developed SSIS packages;

- Migration from DTS to SSIS;

- Using Excel Power View for Data Visualization;

- Agile project development environment.

Project: Customer Data Mining (CDM) Tool for Nissan/Infiniti USA/Canada.

- Dynamic generation of SSRS reports. (Visual Studio, C#, VB.net, SSRS).

- Synchronization between CRM and CDM databases (triggers, Change Data Capture (CDT)).

- Generating SQLs with dynamic sets of filters and selectable fields (Transact SQL).

- Performance tuning of canned queries (Profiler, indexing, partitioning).

- Creating technical documentation (Word, Visio, PowerPoint).

Project: Tire Reminder Notice (Nissan/Infiniti USA/Canada)

- Design and development of Data Warehouse (DW) (VS 2008, SSAS).

- Creation stored procedures and SSIS package to populate DW.

- Building cube and querying data with MDX.

- Modification of front/back ends and middle tier to add new options to the existing

Implementation;

- Using Geographic Information System (GIS) objects with geographic data type for Nissan

Dealerships Reporting;

Project: Data Load for CRM Nissan/Infiniti USA/Canada databases

- Import of daily and history Sales/Service/Appointment files (bulk insert, SSIS).

- Design and development of Data Load Validation Framework (DLVFW) to validate data of imported

files (SSIS, Transact SQL).

- Filling DLVFW with validation rules (Transact SQL).

- Reports about results of validation with localization of data issues (SSRS, Transact SQL).

- SQL Parsing of loaded data (recursive CTE).

- Transformation of cursor logic to batch logic (Transact SQL, Profiler).

- Performance tuning of stored procedures. Query optimization (Profiler, indexing, denormalization,

Activity Monitor).

- Creating technical documentation (Word, Visio, PowerPoint)

Senior Database Developer/WEB Developer Oct/02 – Mar/03

The Marketing Store (Toronto) Contract

Project: Dealer Management Systems “Your Service” for Nissan and “Inner Circle” for Infiniti

North America (COM+, VB.NET, C# and ADO.NET).

- Database design and stored procedure development for SQL Server 2000.

- Stored procedures for receiving file feeds from 3rd party providers.

Project : Web Query Tool for bilingual dealers (Nissan/Infiniti USA/Canada)

- ASP, JavaScript, Transact SQL

Senior Programmer Analyst/Database Developer March/02 – Sept/02

InfoNet Toronto Inc (Toronto) Part time contract

Project: WebMarket

- Research and Development (ASP.NET, VB.NET, SQL Server 2000)

- Reporting with CRYSTAL REPORTS 8.5

- Data presentation with ASP.net.

- ASP.net Server Controls.

- Data manipulation with ADO.net.

- Database design with Erwin.

Senior Programmer Analyst/Database Developer Nov/01 – Feb/02

SuperGravity Inc (Markham) Contract

Project: Time Billing Database

- Design and Development (ERwin, VB, MS SQL Server 2000, Stored Procedures, Full-Text/Indexing

Services for Text fields)

Project: ActiveX Control for WEB Editing

- VB, MS WebBrowser Control, DHTML, DOM

Administration of MS SQL Server

Reports with CRYSTAL REPORTS 8.5

Creation of Installation Packages (MS Deployment Package, InstallShield)

Senior Programmer Analyst/Database Developer Nov/98 – Oct/01

Advanced Computers Ltd (Toronto) Contract

Project: Point of Sale (POS) Software Development (PC-based systems)

- Front End: Visual Basic 6.0, GUI, ADO 2.5, OCX, COM, DCOM, COM+

- Back End: MS SQL Server 7/2000 with the local database engine (MSDE)

- Disconnected Recordsets, Development and optimization of Stored Procedures.

Connecting to multiple Servers and Databases

Project: POS Internet project

- ASP, COM+, MS SQL Server 2000.

- VBScript, HTML, Visual InterDev, VSFlexGrid Pro 7 for data visualization

- Load of text, dbf, MS Access files to MS SQL Server

- DTS of MS SQL Server

- Crystal Reports 8.5/Crystal Enterprise

- Creation of installation packages

Senior Programmer Analyst/Database Developer Aug/98 – Apr/01

CHUBB Security North America, Toronto permanent position

Project: Client/Server Development and Administration for Security Monitoring Database

- Client: Visual Basic 5.0/6.0, GUI, ADO Connection; MS Access, Crystal Reports 8.5

- Server: MS SQL Server 7/2000, Transact– SQL;

- Development and optimization of Stored Procedures; ORACLE 8i.

Project: Database design and Intranet development for TELCO Billing Component and Pricing module of the MAS Security system ( ASP, JavaScript, MS SQL Server 7)

- Database design (logical/physical models): ERwin

- Database migration. Data Transformation packages. Visual Basic and MS SQL Server applications

for the data transformation process.

- Installation and support of the local version of MS SQL Server (Access 2000/MSDE)

Senior Programmer Analyst/Database Developer July/97 – July/98

KITIMAT Systems Inc., (Mississauga) permanent position

Project: Shipping Management System

- Client: VB 5.0/6.0, GUI, ODBC, DAO/RDO/ADO Connections; MS Access, Crystal Reports

- Server: MS SQL 6.5, Informix, ORACLE. Development and optimization of stored procedures and

Triggers.

- Database design (logical/physical models): ERwin, S-Designer

- Conversion of text, *.dbf, MS Access files and Informix DB’s to MS SQL Server

Programmer Analyst/Database Developer Apr/97 – June/97

TORONTOTEL, Scarborough contract

Project: Phone bill comparison and finding of inconsistencies.

- Creation of Visual Basic/Access application.

- Creating GUI, menus, bound lists, Forms for displaying “master - detail” information, validation of

entered data.

- Designing Forms for entering, searching, filtering and editing data (SQL, Visual Basic).

- Creating and maintaining MS Access database (Phone Bill System).

- Conceptual and physical database modeling (Erwin, S - Designer).

- Printing Reports (Crystal Reports).

Senior Programmer Analyst/Database Developer June/95 – Oct/96

Bank Mishkan (Central Branch of Bank Hapoalim), Tel Aviv, Israel

Visual Basic/Access/Paradox financial applications for the Bank Loan System (Project HALVAA)

SQL querying and filtering data

MS Access database design, creating Queries, Forms, Crystal Reports

Maintaining and modifying of the database HALVAA

Conversion data from text files to MS Access and Paradox database

Senior Programmer Analyst June/93-June/95

Yagev Computer Ltd., Israel

Visual Basic and Paradox database applications for aviation Warehouse

Optimization algorithms for bus transitions

Programs for control of the local network (MS; VAX).

Training

Course of Managing and Optimizing INFORMIX OnLine Dynamic

Server Databases. Certificate of INFORMIX Software, Inc., Toronto

Course "Simulation and Analytical Models of Computer Structures",

Computer Center, Russian Academy of Science. Computer Science Degree

Certificate of Soviet Academy of Sciences, Moscow

Education

Post graduate course at the Computer Center (Russian Acad. of Sciences, Novosibirsk)

Master of Science. Specialty in Applied Mathematics. Specialization in

Programming languages and algorithms.

Novosibirsk State Technical University, Russia.

References available upon request.

Contact this candidate