| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
Street Address
cell PHONE NUMBER AVAILABLEhome PHONE NUMBER AVAILABLE EMAIL AVAILABLESUMMARY: 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, DataStageUX: Power BI, Excel, SSRS/Mobile Reports Publisher, Telerik KendoUI/DataViz, Tableau, D3.js, VMLLANGUAGES: SQL, PowerShell, Power BI/DAX/M, R, JavaScript/JQuery, XML, JSON, .Net (C#/ASP/VB), HTML/CSSANALYTICS: SSAS, DAX, MDX, Power BI Services and for SSRS, Excel, SSRS, R, Crystal ReportsTOOLS: 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, JiraEXPERIENCE:SMBC, Jersey City, NJ HYBRID/CONTRACT Jun 2024 - currentPower BI Consultant Develop and enhance reports for Governance/Risk/Compliance and Fraud Detection Define and manage data storage in SQL database, files in Azure Blob or SharePoint Perform data preparation and cleansing for consumption in reports Excel, CSV, JSON, XMLMitsubishi 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 appPower 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 reportingPower 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 reportsPower 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 themePower 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 ExcelAsset 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 2022Sr. 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, DAXCRM 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, DAXCylinder 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, DAXBulk 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, PowerShellPowerShell 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 changesDevOps 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 2019Sr. BI EngineerPower 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 datasetsDevOps 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 guidePredictive 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 2018Sr. Database DeveloperCombined 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 dashboardsMS Dynamics GP SmartLists deployment as Excel dashboards/reports on SharePoint.
Created and modified custom SSRS reports from GP dataCoreMotive 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 hoursCompassion-First Pet Hospitals, Tinton Falls, NJ Jun 2016 May 2017Database 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 APIXIMA 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 ServicesUS 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 contributionMy 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 2007Information Systems Analyst Project LeadInteraction with business users, full stack development; Database/Web server AdministrationEmployee 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 departmentsEDUCATION AND ACCOMPLISHMENTS: Client/Server Applications Development. CHUBB Institute, Jersey City MS/BS in Mechanical (HVAC) Engineering. Refrigeration University, Odessa Ukraine |
