VICTOR KARLOVICH

** **** *****, *******, ** *****

cell 201-***-****

home 201-***-****

ad4x66@r.postjobfree.com

SUMMARY: Looking for opportunity to concentrate on Business Intelligence Reporting, Data Modeling and Integration relying on diverse technical background and experience in business applications design and development; Proficient in full project life cycle; Own the project and work with minimal supervision; Maintain open communication with management, business owners and end users.

US Citizen. Local to NJ and NYC area. No relocation.

DBMS: SQL Server, Oracle, Sybase, OrientDB, PostgreSQL, Hive, HBase, Access

ETL: Azure Synapse/DataFactory, SQL/Jobs/SSIS, PowerShell, Power BI/M, MS Automate/Flow, SSIS, REST API, Scribe, DataStage

UX: Power BI, Excel, SSRS/Mobile Reports Publisher, Telerik KendoUI/DataViz, Tableau, D3.js, VML

LANGUAGES: SQL, PowerShell, Power BI/DAX/M, R, JavaScript/JQuery, XML, JSON, .Net (C#/ASP/VB), HTML/CSS

ANALYTICS: SSAS, DAX, MDX, Power BI Services and for SSRS, Excel, SSRS, R, Crystal Reports

TOOLS: MS Visual Studio, SQL Server Management Studio, Power BI Desktop, DAX Studio, Bravo for Power BI,

Power BI Helper, Power BI Report Builder, R-Studio, Toad for Sybase, Oracle SQL Developer, MS Office 2016/365, Visio, TFS, GIT, Jira

EXPERIENCE:

Mitsubishi HC Capital America, Norwalk, CT – REMOTE Nov 2022 – Mar 2024

Sr. Data Engineer

Discuss requirements with end users

Identify data sources in vendor DBs

Configure pipelines to bring data into DW

Create SQL objects

Consume data with Power BI desktop

Define data models

Design UI with Power BI desktop/services

Create and incorporate paginated Power BI reports with parameters

Publish and distributed Power BI reports with app

Power BI Modeling – defined dimension and fact objects; created SQL server objects to partition/transform data; mapped SQL objects to Power BI functions; used transformations using M/DAX; optimized performance; utilized various joins/direction; created measures to support business logic and/or UI navigation; deployed/maintained semantic models used as base for end users self-serve reporting

Power BI Optimization – analyzed data utilization and reports performance with internal/external tools. Compared/tested different DB objects and data consumption modes to streamline development/deployment, reuse DB objects and semantic models, reduce storage footprint

Power BI Services Reporting – set of PowerShell scripts collects information on daily usage/activity, refreshes, backups, users/roles per workspace via API calls and/or PowerBIMgmt module, data saved into SQL database and used as source for Power BI reports

Power BI Template – M function to map SQL to Power BI objects; Company branding and standardized layout; Toolbar (icons/buttons) navigation; Centralized “show on demand” slicers; Reset functionality; Help page; Custom theme

Power BI Services Training – prepared training materials for end users transforming simple table into set of pie and bar charts, illustrating filters vs. slicers, cross-filter vs. cross-highlight, star modeling concept, Power BI vs. Excel, Matrix vs. Analyze in Excel

Asset Insurance and Relocation Power BI with embedded paginated reports - provides search-preview-export (Excel) functionality; Excel files sent to internal/external users for update tax codes/rates per location and upload it back to DB.

Power BI Services Management – user access/role management (individual, groups, row level security); reports distribution (subscription, apps); downloading backups (PowerShell); refreshing reports (scheduled or pushed via PowerShell)

Migration onsite ETL and DW onto Azure – collaborated with vendor on SSIS packages conversion into DataFactory pipelines; tested and debugged pipelines; created operational Power BI reports to compare pipelines vs. SSIS performance and row count; configured underlying database to import new objects from the various sources into DW

Matheson, Basking Ridge, NJ Apr 2019 – Nov 2022

Sr. BI Engineer

•Interacted with users, analyze reporting requirements, prepare proposals and demos

•Identified data sources and their location, define appropriate means of collection

•Scripted, configure and orchestrate ETL processes to populate data repository

•Designed conceptual, logical, and physical data models, define and script data objects

•Defined and structure relational and tabular databases, utilize OLAP databases

•Created reports and dashboards, identify appropriate visuals and layouts

•Authored/enhanced and maintain around 50 Power BI report of various complexity

•Deployed and administer reports in SSRS for Power BI on-premises environment

•Managed SSRS and SQL servers on dedicated VM for testing Power BI versions prior to deployment

•Provided technical mentoring and support to Help Desk, power end users and junior developers

Metrics Time Series Forecast – mileage, volume and stops predictions based on historical patterns from ~40 locations. Data resides in SQL server database. Predictions are made by calling R libraries from SPs. Three base models used – ETS, SNAIVE and PROPHET. COMBINED model averages base models. Models are trained on the past parallel period data and the “best fit” coefficients calculated. Historical and forecasted data presented in Power BI report for analysis per location, product, and day of the week. The report helps Logistics Team in planning trucks/tankers allocation and operations. T-SQL, R, DAX

CRM Reporting – complimentary Power BI report to MS CRM for Regional Managers and Sales Reps.

Significantly simplified access and aggregated data analysis comparing to native CRM reports by eliminating manual export/manipulation in Excel. Deep analysis of dynamics and trends from Professional Sales Calls to Opportunities to Won/Lost deals by Line of Business, Geo location, Sales Rep, Product, Account, Pipeline, etc.

Pays special attention to Cross Sell activity to increase and diversify company market penetration.

Dedicated SQL DB with linked server to CRM DB; SQL functions for dimensions and facts; data import into Power BI; data model and custom measures; 3d party visuals, toolbar navigation among 10 bookmarks, custom/page tooltips; T-SQL, M, DAX

Cylinder Management Reporting – Power BI report replaced Crystal report.

Eliminated manual export and manipulation in Excel to track cylinders re-fills and movement, identify cylinders for cleansing and valve retrofit.

Dedicated SQL DB with linked server to Oracle DB; SQL functions for dimensions and facts; data import into Power BI; data model and custom measures; 3d party visuals; T-SQL, PL/SQL, M, DAX

Bulk Gases Management Reporting – number of Power BI reports atop of custom order management system.

Provides time analysis of trips cost, actual and forecasted tanks fills, outages, sales, etc.

Dedicated SQL DB; Excel/CSV files on SharePoint; imported data to Power BI; T-SQL, M, PowerShell

PowerShell ETL functions – custom modules to automate ETL and reports administration.

Download files from SharePoint; Upload files into DB; Convert XSL to XSLX and CSV; Upload and download reports to/from server; Set reports data sources and security; Compare old and new SSRS reports outcome after DB structure changes

DevOps reporting – number of Power BI reports on atop of ChangeGear and SSRS servers. Simplifies DBA activity by providing access and analysis of Help Desk tickets and load, reports usage, reports migration and deployment

Amano McGann, Roseland, NJ Apr 2018 – Apr 2019

Sr. BI Engineer

Power Analytics for occupancy, revenue, net flow and other historical business metrics.

Took over self-contained Power PI report prototype utilizing DAX for data generation and visualization. Converted it into production grade service for external clients hosted on Microsoft Power BI Services (cloud):

Analyzed data gap and migrate data model onto SQL/SSAS

Converted Power BI internal data model into SSAS MDX cube structures

Traced data flow and map objects from DW into SSAS MDX cube structures

Developed views, SPs, SSIS packages to populate DW objects

Created SSAS Measures and Calculations to support Power BI visuals in Live mode

Developed 20+ pages Power BI report with toolbar navigation

Created Power BI services dashboards

Explored embedding options into company web portals

Administered Power BI Services users/groups, dashboards, reports, and datasets

DevOps Deployment in QA (daily) and Production (2-4wks) environment. Took over manual deployment in Azure multi VM/DB/DW environment driven by spreadsheet updated by developers and converted it into semi-automated process. Significantly decreased services downtime, number of manual entries and related human errors. Developed PowerShell script (remote session, XML, VSTS API, Jira API/JQL, SSRS API, XMLA, CSV, .Net):

Extracted Jira items marked for deployment

Extracted VSTS source code changesets corresponding to Jira items

Segregated source code by type and order of deployment (DDL, FN, SP, VW, other SQL, SSRS datasets and

reports, SSIS packages, SSAS cube)

Obtained deployment details from XML based variables mapping VSTS folders/projects to appropriate

server/DB/VM/DW

Copied existing objects into “rollback” folder

Copied new objects into “package” folder

Generated deployment XMLA from cube project file, modify it per deployment environment

Deployed each object onto target environment and generated deployment report as rollback guide

Predictive Analytics for future occupancy, revenue, net flow and other business metrics derived from historical data. Data Scientist consultant created R script prototype containing 4 modules (6K lines of code) and running approx. 1h per one lot of one-year data. The goal was to improve performance and enhance report to make it understandable for different audience:

Analyzed R script flow, data extract and transformation

Migrated R code as in-database service separating ETL and ML tasks between SQL and R

Re-designed output tables into star model suitable for SSAS (MDX or DAX cube)

Developed ETL/SSIS packages to load predictive analysis into existing DW

Developed SPs to support Power BI data model in Imported mode

Infragistics, Cranbury, NJ Jul 2017 – Apr 2018

Sr. Database Developer

Combined Marketing/Sales DW/Cube to track effectiveness of marketing campaigns on resulting sales. Eliminated manual data re-entry and made reports available from monthly to daily schedule.

Developed ETL process to extract data from Google Analytics, AdWords, AppFigures, Apple Search Ads,

Marketo, Twitter, Facebook, MDM cubes, Dynamics GP and CRM to replace manual data re-entering into

Excel workbook

Evaluated SSIS, REST API, Scribe, CData drivers; Created custom Google Analytics, AdWords and Marketo reports delivered as email attachments

Promoted and executed Email/MS Flow/SharePoint/PowerShell approach. Configured MS Flow tasks to

save email attachments onto SharePoint, OneDrive, etc.

Developed PowerShell functions to download/extract Excel/CSV files, execute MDX queries on existing

dedicated Sales and Marketing cubes and load staging tables in combined Marketing/Sales DW

Developed SQL SP/FN to transform/load fact tables

Designed SSIS package to orchestrate PowerShell and SQL script execution

Modeled and structured staging and fact tables and corresponding SSAS cubes measures

Generated Tabular and MDM cubes from combined Marketing/Sales DW

Created reports/dashboards from combined/dedicated cubes in Excel, ReportPlus, SSRS and Power BI

Compared automated data with previous manual dashboards

MS Dynamics GP SmartLists deployment as Excel dashboards/reports on SharePoint.

Created and modified custom SSRS reports from GP data

CoreMotive Solution removal from MS CRM replaced by Marketo.

Identified solution objects, archived historical data, executed vendor and custom script

Decreased DB size 20-30%; Modified ETL for existing Marketing DW/cubes after CoreMotives solution

removal that cut MDM cube processing time from 8 to 1.5 hours

Compassion-First Pet Hospitals, Tinton Falls, NJ Jun 2016 – May 2017

Database Analyst/Developer/Administrator

Analyzed internal business reporting needs and vendors’ software capabilities

Communicated with software vendors on technical requests, issues and remedies

Identified source of data in vendor specific databases (SQL Server, Sybase, OrientDB)

Modeled, designed and configured logical/physical DW/DM databases

Developed ETL/ELT modules to combine data from various sources into single repository

Developed dashboards and reports on combined and refined data

Provided feedback, recommendations and training to IT managers, staff and business owners

Administered SQL Server and Sybase databases

Revenue vs. Expenses Reporting and Analysis – identified patterns of data collection directly from Cornerstone (Sybase), ImproMed (SQL Server), MS Dynamics (SQL Server) databases or indirectly from Ceridian Dayforce and DVMax (cloud) as PDF or CSV files via FTP, email; Modeled data, designed and configured staging database on Azure (star model); developed SPs, SSIS packages, PowerShell and Outlook script to automate data collection and cleansing from network and remote servers; compared results of direct data collection with native reports and historical manual Excel spreadsheets; created interactive Power BI dashboard ported to database model (T-SQL, .Net DB and Azure libraries within PowerShell)

Hadoop and NoSQL Evaluation – installed Hortonworks and Cloudera implementation on VM; installed Syncfusion Windows OS implementation; deployed star model DW on Hive; Modeled data and loaded Hive tables

from CSV files, installed independent PostgreSQL instance; deployed DW star model and loaded data; ported DW from different repositories to Power BI and Tableau for visualization; evaluated UNIFi implementation on Azure/HDInsight to ingest Cornerstone (Sybase) data, create data sources, jobs and reports, and administer users/groups/schedule via Web UI and REST API

XIMA Chronicall Reporting for Cisco Phone system – evaluated native tools, created custom reports and scheduled delivery, installed local OrientDB instance; deployed XIMA schema; explored direct load and access to data via REST API and porting it to Power BI for advanced interactive analysis

SQL Server, Power BI and R analytics – deployed SQL Server 2016 instance with R; created set of generic SPs and FNs to wrap R functions and execute them on SQL datasets from host database; utilized R visuals within Power BI on data model queries; examined historical pattern of visits and reasons by months, weeks and days for insight on appropriate staffing

ChangeGear IT Incidents Reporting - evaluated native, created custom and scheduled reports delivery; installed and configured SSRS for advanced reporting; developed stored procedures to retrieve data and created Power BI and Mobile Dashboards for IT and executive’s needs; customized Notification Templates, Help Desk/End User Entry Forms, User Views and Work Flow; administered changes, synch Lookup lists and user roles/accounts with AD and other sources (T-SQL, PowerShell, SQL Server 2016/2012)

MS Dynamics Reporting – developed SPs and customized Smart Views and SSRS reports for end users (AP, Inventory modules); created Power BI dashboard for MS Dynamics modules/tables catalog and memory utilization for IT users; debugged/deployed vendor’s update script (T-SQL, SQL Server 2012)

Dayforce Reporting – created customized Payroll reports; communicated with vendor reports delivery on dedicated FTP server; automated files retrieval and uploading data into DW (Azure SQL Server, PowerShell); created Excel reports of scheduled/worked hours for personnel (tables, pivot tables, slicers, lookups)

BARD Inc., Murray Hill, NJ Jul 2007 – Jun 2016 (mass layoff)

Sr. Business Technology Analyst, Internet

•Interacted with users and analyzed requirements, prepared proposals, and demos

•Architected, planed, and developed functionality layers - client, server, and back end

•Modeled, transferred, transformed, and migrated data from multiple sources

•Deployed, administered, and supported 8-12 databases (1-4GB) and 8-10 apps (3 SQL and 3 IIS Servers)

BI Portal - “universal” utility for Excel files upload, validation, and verification as part of ETL for DW/DM.

XML validation based on dynamic XSD generated from table schema. Portable against Oracle and SQL Server.

Kendo UI grid with “Excel like” AJAX CRUD; Integrated with SharePoint.

Sales Dashboard - monthly and annual (current/previous year) sales data per role and account.

Developed 20 steps ETL, designed 19 dimensions OLAP cube deployed on SSAS, Server CRL SP data conversion into XML; Telerik KendoUI/DataViz/JQuery with drill down capability embedded in Web Viewer on FileMaker layout; Distribution onto iOS devices via FileMaker Go, web server hosting with caching or export into .cub files.

Spirit of Excellence Award for “can-do” spirit and support of BARD Corporate Health Services

US Product Catalog - search and browsing BARD products as part of corporate website; avg. 1000 hits per day (Catalog only); Supports major desktop browsers (IE, Chrome, Safari, Firefox) and mobile devices (iPhone, iPad, Android, Blackberry). Developed internal/external IIS/DB servers 10 steps ETL SSIS process, 100 SP/FN; utilized Telerik server-side controls, Reporting Services WS, Google Analytics, SQL injection proof. Migrated from SQL2005

to SQL2012 and IIS6 to IIS8.5. Awarded BARD Certificate of Recognition for Corporate Website and Product Catalog contribution

My Contracts - detailed products multi-tier pricing per account/contract, contracts’ expiration and membership; Implemented for DAVOL and BASD, 300+ users, avg. 200+ hits per month; UAT for BPV (Vascular, Peripheral, Bio). The only common source of contracts data for all level of management and sales force.

Redesigned app to replace 40+ pages with 10 -12 templates reusing ASP.Net data driven Custom Server controls, vendor (DbNetLink, Telerik) controls and vendor/custom JS snippets stored in database that drastically simplified divisional branding and deployment. Developed 80 steps ETL DTS/SSIS, 400 SP/FN, optimized DB (indexing,

partitioning), strong user role-based security, SQL, and IIS server caching; Migrated from SQL2K to SQL2008R2; Awarded bonus in company stocks for developing and deploying in “non-standard” situation.

Insite – custom web portal providing single access point for Sales data, Contracts Pricing, divisional/corporate documents and training, external sources, and apps; 1300 users avg. 2500 hits per month. Integrated Classic ASP and ASP.Net pages, DbNetLink, Telerik.Net/KendoUI controls and JS/JQuery; ASP.Net MVC Admin Console

The Valley Hospital, Paramus, NJ May 2003 – Jul 2007

Information Systems Analyst – Project Lead

Interaction with business users, full stack development; Database/Web server Administration

Employee Evaluation – tools to conduct employees’ annual performance review (200 users).

Financial Reporting – Led Cizer Net Reporting and Microsoft Reporting Services implementation; Developed reports for Finance, Cost and Budget, Human Resources and Home Care departments

EDUCATION AND ACCOMPLISHMENTS:

•Client/Server Applications Development. CHUBB Institute, Jersey City

•MS/BS in Mechanical (HVAC) Engineering. Refrigeration University, Odessa Ukraine

Contact this candidate