Jacksonville University

University of North Florida

Sr. MSBI with Azure + Synapse, Snowflake, Matillion ELT, SSAS, ADF, Azure ML, ADLS, Databricks, SAP, AWS Redshift  -        ** PowerBI Premium Expert **

Washington, District Of Columbia, United States

- Lead EY cloud migration effort at EY for the Assurance databases located across 35 datacenters all over the world and many other accessory data sources; - Provisioned, configured and C/I deployed Azure ADF and Azure Gateways, storage and other necessary Azure components for the seamless ingestion of on-prem data-sources into the Azure cloud; administered one of the EY Azure subscription;  -Provisioned, configured deployed and administered Azure Synapse Pool with all accessory components such as Azure Key Vault, ADLS Storage and other Azure components as part of the rollout of the EY Cloud Data Retention area in the Cloud;-Designed, coded and delivered a custom Azure Synapse Accelerator utility for the automated migration of on-prem database objects to the Azure Synapse database; this included automatic production of valid code by way of a driver table in combination with sys tables that produced valid Synapse T-SQL code for native table (with appropriate distributions) and External tables;-wrote a custom Python solution for the Automated generation of Parquet files from on-prem SQL Server data sources using a driver table and auto-uploading of these files thereof to the ADLS;-Provided both strategic as well as detailed roadmaps to EY for all of the cloud data migration efforts and challenges;

Azure Data Architect

Architecting and directing cloud Azure migration strategy for this Global Client; with details related to data-centric client components such as Azure Data Factory for advanced data movement  Azure SQL Database for the main data storage ; Azure Blob Storage for PBI Reports Azure Data Lake Storage for archival and long-term comprehensive storage plus enablement Azure Lake Analytics; hands on coding skills with Azure data factory packages and Azure machine learning (fraud) ETL and enabling Azure Search;

Stryker

Sr. Azure and PowerBI Architect

- Designed, Architected and Implemented a Revenue Recognition data load Engine for satisfying SEC regulatory compliance requirements 605 and 606 for CoStar group; complex technical requirements;➢ Provided source code for balance data migration from the accounting system of record (Navision) to Oracle ERP Cloud; modules covered were: GL, Fixed Assets payables, receivables using SQL for ETL;➢ Architected a comprehensive ‘Product SKUing’ data-engine that defined complex sets of product mixes (15k variations) sold over time and calculated Fair Value(FV) for those mixes over time for Revenue Recognition and reporting purposes; this was the crucial and pivotal part of the entire $3 million project;created and kept master tables for those mixes to perform lookups and assign new Mix ID’s each day; ➢ Designed an ETL framework for efficient and automatic data-loading into the RevPro Revenue system;resolved very complex hierarchy issues for facilitating these loads; coded complex straight-line rev-rec;➢ Designed and provided a Finance cube with Power-BI reports all uploaded to the cloud which merged together two very complex source systems; uploaded source data to AWS S3 storage in cloud, used SQL;➢ Used MongoDB to store and access JSON documents and templates for AWS; wrote JSON templates; used mongo-export utility; MongoDB functions; using mongoose for modifying documents;

CoStar Group

Senior Data Architect - Finance

- Architected, developed and deployed a SSRS framework reporting against SAP ECC source system ofNRUCFC; involved in modeling and prototyping a total SSAS cube solution (Analytics engine);➢ Delivered 25+ Financial reports as part of a Major Data Migration Effort to SAP ECC 6.0 for areas spanning GL ledger accounting, financial facility, long-term loan and other financial products; facilitated front and back office report integration into one cohesive solution using Microsoft Power-BI components; involved with dashboard prototyping with SAP ECC 6.0 as the source system of record; used SQL➢ Owned the BRD (business requirements document along with a BDG (business data glossary) reflecting business and technical definitions of all of the required element from the old and new systems as part of the data Migration effort and in part of the requirements for the entire ETL processes; used SQL;➢ Use cloud-based Hadoop solution for batch processing, and developed machine-learning solutions by integrating code from several systems; backend data tables were modeled and kept in AWS RedShift; ➢ Prototyped an incremental Data warehouse ETL architecture flow for backend nightly data pulls from source system and integrated a Power-BI executive dashboard solution; used PIG ETL with Python UDF functions to enable the load into the data-warehouse backend that ran this dashboard; also used SQL;➢ Developed an Azure Machine Learning algorithm for ‘Most likely Financial Product Cross-Sell’ prediction model and accessorized it with Azure Data-Factory movement package for uploading data to the cloud;➢ Setup a MongoDB repository for storage and access of JSON documents; setup of JSON templates; used MongoDB functions to modify (update and delete and insert) documents;

NRUCFC (National Rural Utilities Cooperative Finance Corporation)

Sr. Financial MSBI Consultant

- Singlehandedly produced a Full-Functionality POC (proof-of-concept) solution on Budgeting Solution for Fairfax County; this involved producing a complex financial/budgeting SSAS cube to demonstrate effective  replacement of a portion of existing  SAP ECC reporting for a large Government Organization; presented POC was for one module only – FM (funds management); Client was thrilled with proposed POC solution as presented and decided to expand to all of the other ECC modules (FM, GM  etc.);	Took Client  from Blank slate to Full Production Stability with the FM  module  and portions of the GM module (Cube +  ETL + tables + reporting ) ; provided nightly cube processing and incremental nightly ETL’s that ran smoothly for months with no human involvement; achieved production  DW system that was self-regulating with multiple safety-net features that detected anomalies in the underlying stage data and responded with differing processing routes depending on data anomalies; 	Served as Chief ETL Architect and Developer and technical lead for the SQL side of the ETL processing that populated the data warehouse and the SSAS Cube; authored all of the stored procedures that populated the cube as well as authored the framework for the whole ETL data processing; packages; notifications; established standards; naming conventions; optimization guidelines; process flows; and etc.	Served as Chief Cube Designer and worked with the Budget Reporting Group users to enhance and advance the usability of the SSAS cube from POC stage phase to  full Production phase which involved directly collecting requirements in real-time, coming up with solutions/ways of implementing these features within the context of cube drill-through, actions, mdx calculation items or reporting features residing on the SSRS reports; or figuring other ways of satisfying the client reporting need and presenting it to the client;

Fairfax County Government

Sr. Budget Solutions Consultant

- Helping IBC move their existing physical data warehouses into the cloud space (Azure);-Authoring the SSAS cube and backend (table) design for a comprehensive Member Analytical Engine to be used for advanced member/prospect segmentation and full ad-hoc analytics capability to include: utilization analysis, prospect lift analysis, treatment effectiveness analysis, provider rankings etc;-Working with key business users and stakeholders of the project (C360) in order to aquire in-depth business knowledge necessary to deliver on the complete end-to-end turn-key product; ROI of the project estimated to be in the 10-15 million US dollar area;

Independence Blue Cross

Sr. MSBI Consultant - healthcare costing

Private Cloud Sales and Leasing

Lead Datawarehouse Architect - Cloud Migration

Architected, designed, piloted, directed implementation and put into Production an FHCP Pharmacy Data-warehouse solution; involved in all aspects of the implementation from requirements gathering, to table, key construction, cube development, query performance tuning etc. and finally - CEO presentation; the management at FHCP ( this is both a payer and provider) was totally mesmerized by the efficiencies of the BI solution in terms of  impact on supply chain, cost improvements gained from timely pharmaceutical  information and speed of information retrieval;• Involved in ETL architecture, mapping , metric design, some technical resource management as well as participation in standard setting and recommendations to the upper management Steering Committee as to the major direction of BI efforts at FHCP; leveraged as a key company technical resource for all Microsoft Business Intelligence technologies;

Florida Health Care Plans

Data Warehouse Architect - healthcare costing

- Architected, designed, developed and spearheaded implementation of a unique file loading system for the marketing data-warehouse at Bloomberg with information from several hundred sources which involved auto code-generating capabilities as well as a mechanism to for data-type checks without interruptions of the overall load; this ETL was put into production and reduced overall ETL maintenance by well over 75%; •	Designed and modeled several proof-of-concept customer segmentation data-mining models for advanced customer analytics and for the cross-selling of financial products to Bloomberg customers;•	Participated in the maintenance of the click-stream data analysis and loading for the main Bloomberg website; wrote MDX for metrics inside the SSAS cube that held aggregations of this data;•	Personal wealth of Michael Bloomberg increased by 4B during 2012 in no small part due to better analytical tools and advanced data capabilities provided by the R&D department of which I was a part;

Bloomberg LP

MSBI Financial Solutions Expert

Providing detailed hands-on technical guidance to the entire GAF BI team in regards to all aspects of Microsoft BI encompassing the entire suite of Microsoft BI products. Instrumental in the successful first production release of ‘Sales Center’ Data-warehouse at GAF by improving performance of Reporting Services reports and architecture; overall performance of the reports improved by over 65% through correctly identifying and eliminating bottlenecks by  methodical stress-testing and improving both front-end (RS), back-end design (Cube) as well as correct configuration and hardware; sourcing from data from Peoplesoft 8.8 into SQL Server data-warehouse tables; query cost analysis; production and post production issues; managing lifecycle, translation of complex business requirements into a detailed and valid and scalable data-warehouse model and SSAS cubes. Currently working on multiple projects involving improvement the efficiency and load windows of ETL processes feeding the cube and as well as sourcing additional complex Metrics and KPI’s by  means of MDX; Currently hold the title of the Chief Microsoft BI Consultant for GAF and in that serve to advise GAF on Microsoft Best Practices in BI.   Hands-on technical and strategic direction guidance on migration from a mature Cognos TM1 9.1 financial reporting environment to an SSAS based reporting environment;  analysis and detailed technical migration strategies and technical direction and advice involving finer aspects of TM1 and SSAS both from an object structure (architecture)  and data-movement standpoints (TI’s and SSIS pkgs).

Sr. BI Consultant - SupplyChain

- Advising JP Morgan Chase on Best Practices in regards to data-warehouse design and development in the Microsoft BI space. Providing senior technical guidance in the BI space to this organization. •	Strategy, architecture and process improvements; risk assessment, technical know-how on Global BI deployments and efficiency improvements in existing BI applications.•	Providing technical guidance to both onshore and offshore resources (several teams that include ETL developers and QA testers).

JPMorgan Chase & Co.

Sr. BI Consultant -  Finance

- Advised CitiGroup EMCT Division (Emerging Markets Credit Trading) on industry Best Practices in regards to data-warehouse design and development overall and in regards to the Microsoft BI implementation •	Design and modeling of complex Credit Derivative trading instruments in the multi-dimensional cube space and using the Microsoft BI toolset; recommended solutions on improvement of daily cube loads.•	Performance improvement of the EMCT cube and analysis of current schema design in regards to optimal efficiency and performance; recommended schema improvements; recommended and designed attribute relationships for the trade dimension;  Worked directly under MCS for this client

Citi

Chief BI Architect - Financial Pricing

- Advised Merill Lynch (Research) on industry Best Practices in regards to data-warehouse design and development in the Microsoft BI space.•Designed, architected and technically spearheaded a radically new way of modeling very complex business requirements using the SSAS platform. Requirements were pertaining to equities research and reporting analysis at Merill Lynch.  The approach received top honors from three adjacent business units and was adopted as a de-facto standard for modeling complex relationship research reporting designs at ML.

Merrill Lynch

Chief BI Consultant (Equities Research)

- Enterprise Architectural Guidance; common dimensional BUS architecture; environment gap analysis ; project analysis, tracking, risk management, change management, course correction & process improvement •	Came up with several pivotal architectural solutions that provided on average a 50% improvement in Cube query performance for the sales funnel and other cubes for the Pro-Curve division of HP. •	Designed the backend architecture and provided cube architecture and guidance for the Supply-Chain project and provided heavy analytics for specialty metrics calculation for the HP supply chain area with use of BSM (business scorecard manager and Microsoft Performance Point), integration with Microsoft SharePoint •	Delivered on several key performance improvement recommendations in the BPM (business performance management and the Finance PNL )

Hewlett Packard Enterprise

Chief Business Intelligence Architect - Supplychain

- Advising Lehman Brothers on industry Best Practices in regards to data-warehouse design and development;•	Development of the architecture of the SSAS cube to model P&L data for credit swap derivatives, fixed income products and other investment products; calculation of complex real-time exposures rates; P&L rollup of accounts using ragged hierarchies and advanced cube design structures; modeling complex investment vehicles in multi-dimensional environment using the Microsoft BI toolset in SSAS 2005; revenue/loss participation ratios; percent contribution and other advanced calculations;•	Authored Functional and Technical Specification documents for PALS project (subpart of Alpine), heavy trading desk analytics and resolution of complex performance issues with current reporting logic through stored procedures in Sybase; authored pilot cube simulating exposure rates of credit risk derivatives

Lehman Brothers

Senior BI Architect - Finance

- Advising Home Depot on industry Best Practices in regards to data-warehouse design and development;•	Production Engineering, Partitioning VL (11 terabyte backend tables) Microsoft Analysis Services Cubes with DSO and later AMO, creating and authoring automated data-driven top-tier production engineering mechanisms; design of custom aggregations for increase of performance of MSAS cubes; •	Authored and coded an Advanced MSAS/SSAS CUBE Aggregation scripting utility which creates XML aggregation stores from production cubes and then reverse-processes those original aggregations back into the cubes (performing a name/vs. ordinal match-up) on demand even  after structural changes to the original cubes have been made; •	Designed and developed cubes and data-marts for the supply chain area (SPM, RTV, REC); complex metrics; currency conversion paradigms with MDX; customer basket analysis with MDX; ratios with MDX; solving complex supply-chain reporting OLAP modeling issues;

The Home Depot

Sr. BI Architect - Supplychain

- Responsible for hands-on design, modeling, development and VB coding as part of an inside development team delivering OLAP data-mart solutions for various Business Units within Publix; •	Involved in  requirements gathering; identifying implementation strategies; design of cubes, dimensions, elements, sets; dimensional modeling of highly complex business models with OLAP MS Analysis Services cubes;  •	Partitioning of large tables; auto partitioning of cubes with DSO; index fine-tuning;  dupe removal; handling nulls/unknowns; coding complex business logic rules using MDX functions  and calculated sets within the CUBE Editor;  •	Loading data into pre-staging and staging areas, complex cleansing and then loading into  corporate  cubes for detailed analysis for  improvement of Inventory product flow Preparing and implementing complex, multi-conditional type1 and type2 corporate  dimensional data  updates for the Loss-Prevention Pharmacy Drug Data-mart system; Improving dimensional updates and ETL for PIMS system(SQL Server 2000 and DTS with XML):•	Tuning High-volume data movement Production systems for efficiency and performance; dynamic index and covering index creation; identification of performance bottlenecks and customizing effective solutions for attaining desired performance levels; scripting backups and restores;  •	DTS scripts & package tuning to narrow processing time windows; streamlining existing SQL Server Stored Procedures for speed and efficiency in performing ETL processes; coding complex and highly successful ActiveX ETL scripts in VBScript within the DTS designer environment; •	Designed input configuration XML files for DTS packages and defining standards; coding new Stored Procedures for data extracts for new data-marts in development; modeling highly complex “Flex-Pricing” data engines that use cubes  for multi-condition price setting with MDX;

Publix Super Markets

Sr BI Architect - Supplychain

Financial OLAP : Developed and put into production a cube-enabled CBS Studio Center Balance-Sheet and Income Statement on the OLAP TM1 server; administered the TM1 OLAP server; routinely transferred GL figures from the accounting application into the TM1 OLAP server through import logs; maintained and developed those logs;  helped the Financial Planning Department put together the yearly Corporate Budget.ASP & <a href="http://ASP.NET">ASP.NET</a>:  Developed and launched a company store web site in ASP; maintained the company web site at  in ASP; Developed and deployed into production an online  Employee Directory; developed and deployed into production an online Project Scheduler for keeping track of the details of activities going towards specific projects (coded in <a href="http://VB.NET">VB.NET</a>); developed an online PO system (in ASP); SQL Server 7 and DTS:  Deployed the SQL 7.0 on a test server and tested systems data conversion to the new DBMS; wrote stored procedures & triggers; fine-tuned queries; setup indexes; configured access rights and permissions; converted and imported tables with DTS; setup full search capability; improved query performance; developed tables and set up relationships and keys

Nick Kletnoi,MCP

Nick Kletnoi,MCP