Experience

MOFCO

• Canada
• IT Services and IT Consulting
• 1 - 100 Employee

• Business Intelligence Consultant

  • Apr 2020 - Present

  Development Power Bi, Sql, Reports Stimulsoft, SSRS, SSIS Development Power Bi, Sql, Reports Stimulsoft, SSRS, SSIS



Zoetis Inc.

• United States
• Legal Services
• 1 - 100 Employee

• Business Intelligence Consultant

  • Sep 2019 - Apr 2020

  Project: Automatized data import and data validation, developed dashboards and reports for finance and inventory teams. Tasks:  Developed Power BI reports and dashboards for different finance and supply chain departments. Power BI reports included row/data level security (RLS). Created SSRS reports based on data warehouse tables and cubes. Programmed complex stored procedures using T-SQL, functions, views. Verified, modified, checked with end-users and organized existing reports.  Developed and supported SSIS to import information from different sources. Worked with global support group to deploy changes on production.  Produced ad-hoc queries to support various departments. Show less



WestGroupe

• Canada
• Wholesale
• 100 - 200 Employee

• BI/SQL programmer-analyst (contract)

  • Aug 2018 - Sep 2019

  Project: Analyzed and developed new star schema datawarehouse, participated in development of Power BI dashboard for sales managers. Created and supported various reports for intern customers from different divisions and departments based on ERP and datawarehouse. Tasks: Analyzed and developed datawarehouse importing information from multiple dababases with different business logic. Created SSIS to import data to datamarts. Supported and validated Power BI sales dashboard. Created SSRS reports based on data warehouse and ERP using tablix, matrix, charts, sub and drill reports. Programmed complex stored procedures using T-SQL, functions, views. Processes query optimization for existing reports. Verified, modified, checked with end-users and organized existing reports Produced ad-hoc queries to support various departments. Show less



Jam Industries Ltd

• Business Intelligence

  • Jun 2015 - Aug 2018

  Project: Participated in development and support of BI application used by intern customers from various divisions and departments: warehouses, inventory, sales, purchasing, finance. Analyzed customer requests as well as processed final tests. Tasks:  Created SSRS reports based on data warehouse and JDE tables using tablix, matrix, charts, sub and drill reports. Programmed complex stored procedures using T-SQL, functions, views. Processes query optimization for existing reports. Supported SharePoint’s users groups security and schedules.  Produced ad-hoc queries for various departments. Designed report prototypes and tested with end-users using Excel Pivot tables and different formulas.  Processed backup and restore databases, SQL job schedules, developed database update scripts.  Developed SSIS that received information from txt, Excel files and SQL tables using code in scripts and different formulas, foreach loop container, windows variables and XML dynamic configuration.  Used TFS (distributed revision control) for SSRS and SSIS versions. Show less



Benchmark Inc.

• United States
• Construction
• 100 - 200 Employee

• BI Programmer

  • Sep 2014 - Jun 2015

  Project: Participated in development of new BI application that received multiple txt input files and transformed it to data warehouse tables that are used in cube and multiple reports. Tasks: • Developed SSIS that received information from txt files and SQL tables using C# code in scripts and different formulas, foreach loop container, windows variables and XML dynamic configuration. • Created SQL jobs, stored procedures and SQL code, index, security, database backups. Created sftp transfer scripts. Supported PROD, QA and DEV servers. Validated imported information, exceptions. • Used Git (distributed revision control) for SSIS and SQL server databases versions. • Developed Access database to manage data exceptions using ODBC connection, linked tables, VBA, macros. Show less



Groupe Yellow Inc.

• Advertising Services
• 1 - 100 Employee

• BI programmer

  • Aug 2013 - Aug 2014

  Project: Participated in implementation of new ERP retail system - Epicor. Validated, prepared data files to import to WMS system and RH department. Tasks: • Developed SSIS and stored procedures for data migration to new ERP system from different data type’s files like Oracle, SQL, .TXT, .XLS, XML. Delivered multiple ad-hoc and stored procedures. Used different SQL options like temporary table, T-SQL, sub and pivot/unpivot queries. • Created, verified and delivered complex SSRS reports including table, tablix, graph, sub-report with cascade filters and different formulas. Build reports based of large volume of data. • Developed different smart-look reports for management. Show less



Raymark

• Software Development
• 1 - 100 Employee

• SQL programmer

  • Nov 2011 - Aug 2013

  • Developed SSIS for data import and export between txt files and SQL database. Used variables for SSIS data source and data destination connection strings, variable SQL command as well as error treatment process. Used foreach loop container, scripts and different formulas. • Created and modified complex SQL stored procedures and triggers that transferred information from staging to application’s tables. Designed SQL queries that modified table’s structure, created and dropped index, created and scheduled jobs. Processed troubleshooting of production’s application errors and modified existing scripts. • Designed and modified SSRS reports including tables, graphs, and matrix. Used sub reports and different formulas. • Created technical documentation. Used Excel including different formulas, pivot tables. Show less