Warehouse Architect Business Intelligence
Resume:
Robert Christopher McKenzie
**********@*****.***
QUICK SUMMARY
I just finished a project with the Los Angeles Unified School District leveraging my experience developing solutions with Microsoft PowerAutomate, Powerapps, MS Flow, Dynamics 365 and the Azure platform, including Azure Data Factory. I engaged in an intensive knowledge transfer platform with the original developers at Microsoft and supported and performed enhancements for the new managed services partner Kokomo247. I have 20+ years of Microsoft Application and Sql Server Solution Architecture and Development experience including a heavy focus on architecting and developing business intelligence solutions for the past 12 years including data marts and enterprise data warehouse solutions, etl processes to integrate data from source systems into ods and warehouse stores and reporting and extract solutions to serve stakeholders.
RECENT SKILLS
Programming Languages: Visual Basic, VB.NET, C#.NET, ASP Classic, ASP.NET, HTML, DHTML, Java, JavaScript, NodeJs, Angular, XML, XSL, COM/DCOM/COM+/.NET, C Net Core
Software/Databases: SAP NW 7.0, SAP BW, AccPac SageCRM, Dynamics CRM 3-2013, ActiveX, MS Access, MS SQL Server 4.5-2012, T/SQL, Oracle 7/8i/10g, PL/SQL, DB2, Winapi32, TCP/IP, ISAPI, Index Server, MTS (Transaction Server), MSMQ, ODBC, OLEDB, LDAP, OLAP, Team Foundation Server, Visual SourceSafe, Visual InterDev, SAP, Sybase, MS Office, MS Exchange, MS Outlook, MS IIS, CSS (Cascading Style Sheets), ASPMail, SAFileUP, Samba, SSL, PowerAutomate, PowerApps, Dataverse
Operating Systems: Windows, Unix, Linux
Methodologies: Project Management, Software Engineering Methodology, SDLC, Agile, Scrum, Kanban, CICD
Business Intelligence/Data Warehousing: SAP Business Warehouse, SQL Server (2005,2008R2, 2012), SSIS, SSRS, SSAS, PowerBI, Kimball Method Certification, Dell Boomi, Informatica, Talend, Erwin, Cognos, Pentaho, Tableau, DecisionFirst Modeler, DAX, MDX
Cloud: Azure, AWS, Google
HRIS: Dynamics HR, Kronos, Jobvite, PeopleSoft, Workday, ADP, Ultipro, Sage
ERP: Dynamics 365, Netsuite, Salesforce, SAP, Dynamics AX, Saleslogix, Dynamics CRM, Dynamics 365
PROFESSIONAL EXPERIENCE
INTROBI (TATTOO TECHNOLOGIES INC) 4/2004 – PRESENT (CLIENT ENGAGEMENTS LISTED BELOW)
LOS ANGELES UNIFIED SCHOOL DISTRICT(KOKOMO247), - CHICAGO, JUNE 2022 – SEPT 2022 – SR. MICROSOFT SOLUTION ARCHITECT
●Worked with the 2nd largest school district in the US to transition knowledge and support of their Covid-19 response district management Return To School application platform built on MS Azure, MS PowerApps, MS Dataverse, MS Dynamics 365 and MS PowerBI from the original developer/integration partner to new managed services partner Kokomo247.
●Worked with stakeholders from Microsoft, LAUSD, and Kokomo to understand, document, enhance and support the RTS platform. Leveraging my knowledge and experience working with Azure, PowerAutomate, PowerApps, Flow, Dataverse, Data Factory, and PowerBI to complete issue ticket requests, resolve known bugs, and add enhancements as requested by the LAUSD team.
WHEELS DONLEN, - CHICAGO, JUNE 2020 – JUNE 2022 – SR. DATA WAREHOUSE DEVELOPER
●Worked with Fleet Management Solution Provider to develop SQL Server Data Scripts, Stored Procedures, Talend, PowerBI and SSRS Reporting Solutions for enterprise operations and management users.
●Worked with members of the business to architect automated SSRS reporting subscriptions, deprecated legacy database servers by converting legacy code into new entities on newer database servers, and migrated over a thousand (1,000+) crystal reports into ssrs reports..
WILEY AND SONS, - NY/LONDON, APRIL 2021 – MARCH 2021 – DATA/POWER BI and POWER AUTOMATE ARCHITECT
●Worked with Global Publisher to architect and develop an advertising campaign performance reporting solution and custom subscription application as well as an automated data quality framework.
●Worked with members of the business and marketing analytics team to architect an automated powerbi reporting solution that extended custom subscription functionality to the businesses marketing management using kapost, snowflake, power automate, ms flow, and of course power bi.
ALDI, - BATAVIA,IL OCTOBER 2020 – MARCH 2021 – BI REPORTING, DATA WAREHOUSE ARCHITECT AND DEVELOPER
●Working with Global Grocer to develop enterprise, division, and store level reporting solutions. Consulted an internal BI and Reporting team to handle overflow requirements and assist with the onboarding of a permanent resource.
●Worked with members of the business to architect data feeds, authoring SSIS packages, VBA applications, SQL Server Stored Procedures, and SSRS reports and subscription for distribution on the various reporting servers.
MEDIACOM, - NYC/LONDON, UK - FEB 2020 – APRIL 2020 – POWERBI ARCHITECT
●Working with Global Media client to consult and provide hands-on architecture and development of a marketing management reporting system for the end-client (multi-national energy).
●Provided analysis of existing project teams structure, recommending best practices and organizational modification for delivery.
●Provided mentoring to less experienced data architects and PowerBI developers, including providing hands-on architecture and development.
●TOOLS USED INCLUDED MS SQL SERVER AND POWER BI.
TEMPUR SEALY, - TRINITY, NC -JUNE 2019 – FEB 2020 – BUSINESS INTELLIGENCE, DATA WAREHOUSE, AND AZURE INTEGRATION/MIGRATION CONSULTANT
●Working with the Director of Business Intelligence to provide data architecture services, create business matrices, and develop reporting for the global mattress manufacturer.
●Designed and developed data migrations from on-prem data warehouse into the Azure cloud.
●Tools used included Erwin, the Microsoft BI Stack, Dynamics AX 2012, and Power BI.
MEDSPEED LLC, - CHICAGO, IL -AUG 2018 – MAY 2019 – BUSINESS INTELLIGENCE, DATA WAREHOUSE, AND AZURE INTEGRATION/MIGRATION CONSULTANT
●Working with the Vice President of IT and the Director of BI, Data Architecture, and Integration to build data and application integrations for the company’s proprietary and highly critical Next Gen Project based upon a new Salesforce based custom ERP solution and Azure Data Warehouse.
●Provided SSIS Packages, Azure Data Factory, and Dell Boomi Processes to integrate disparate enterprise solution components with the Azure Data Warehouse and Azure Data Lake. Migrated On-Prem EDW to Azure Cloud.
●Developed Data Warehouse Reporting using Microsoft Power BI, SSAS(Tabular), SSRS, and the Azure Advanced Analytics Architecture.
●Developed integration solutions using such tools as Microsoft BI Stack SQL Server, SQL Server Management Studio, Integration Services, Azure Data Factory, Azure Data Lake, Dell Boomi, DBAmp, and Power BI.
●Third party integration sources and targets included sftp sourced flat files, Jobvite, Kronos, and Salesforce.
FAMILY ENTERTAINMENT GROUP - CHICAGO,IL, FEB 2018 – AUGUST 2018 – LOYALTY AND ANALYTICS PROGRAM ARCHITECT
●Working with the Director of Marketing Analytics and other senior leaders to deliver both a loyalty program and a business intelligence/data analytics program to one of the industry leaders in family entertainment, game rooms, and amusement.
●Providing project management, architecture, development and support for both programs
●Providing talent acquisition for supporting roles
●Toolsets include Microsoft Azure, Microsoft SQL Server, SQL Server Integration Services, Power BI, MS SQL Server Reporting Services, PHP and C#.
ORTHOCAROLINA, APRIL 2018 – SEPT 2018 – SR. BUSINESS INTELLIGENCE CONSULTANT
●Working with HRIS Management to design and develop an HRIS Reporting solution to support the employment law group for a leading healthcare provider in North Carolina
●Performing the analysis on Ultipro data to create custom reporting in a custom HRBI environment.
●Technologies used include Microsoft SQL Server, SQL Server Reporting Services, and Ultipro
BRADFORD GROUP EXCHANGE LTD., NOV 2017 – MAY 2018 – SR. BUSINESS INTELLIGENCE CONSULTANT
●Working with architects and engineers to design and develop ETL solutions that included a C# application to automate package delivery rate shopping for the company’s logistics operations.
●Technologies include SSIS, Visual Studio, C#, Agile Methodology.
CHANGE HEALTHCARE, MAY 2017 – OCT 2017 – SR. BUSINESS INTELLIGENCE CONSULTANT
●Working with architects to provide ETL solutions for a leading healthcare services provider.
●Technologies include Microsoft SQL Server, SSIS.
UILABS, FEB 2017 – MAY 2017 – SR. BUSINESS INTELLIGENCE CONSULTANT
●Designed and developed a custom ERP solution for the maturing tech innovation laboratory.
●Worked with senior executives and department heads to do analysis and architect the solution eliminating reliance on management by spreadsheet.
●Technologies include MS Azure, SQL Server, Salesforce, Access.
NICOR GAS, JAN 2017 – FEB 2017 – SR BI DEVELOPER (ETL)
●Short project providing backfill ETL development services for Data Warehouse project team
●Designed and developed SSIS packages to prepare project data for reporting.
CLIENT: HOLLAND CO., SEPT 2016 – DEC 2017 – SR. BUSINESS INTELLIGENCE CONSULTANT
●Working with engineers to and sales to design and develop operational reporting for their Aries Railroad testing platform.
●Technologies include MySQL, SQL Server, Tableau, and Crystal Reports.
CLIENT: MILWAUKEE POLICE DEPT, MAY 2014 – JULY 2016 – Business Intelligence/Data Warehouse Architect
●Worked with the department’s Director of IT and key stakeholders to provide contract Oracle and Microsoft SQL Server DBA/BI Data Architect services to the city of Milwaukee’s police Department.
●Help the stakeholders to identify requirements, design, and lead development of custom data warehouse solution serving the analysis, decision support and reporting needs for the Chief of police and the command staff and senior management.
●Lead the department stakeholders through a rigorous interview process to define the Kimball Method Business Matrix to assist in DW architecture.
●Delivered such tactical services as SQL, ETL packages, in an environment with Oracle 10 and Microsoft SQL Server 2008R2/2012 SSIS and SSRS).
CLIENT: COMSCORE INC., JUNE 2014 TO FEB 2015 – Business Intelligence/Data Warehouse Architect
●Worked with C-level executives, senior finance leaders for a publicly traded Marketing/Technology services company to identify requirements, design, and lead development of custom data warehouse solution serving the firm’s financial analysis, decision support and reporting needs.
●Lead the company stakeholders through a rigorous interview process to define the Kimball Method Business Matrix to assist in DW architecture.
●Technologies used include Softrax 6, MS SQL208, PowerPivot, PowerBI, and Dynamics AX 2012, Salesforce, and Informatica.
CLIENT: WORTH LTD (NEW YORK, NY), DEC 2013 TO APRIL 2014 – Business Intelligence/Data Warehouse Architect
●Worked with C-level executives, internal business leaders such as the Director of IT, VP of Customer Services of a $100M women’s apparel business to identify requirements, design, and lead development of custom data warehouse solutions serving the analysis, decision support and reporting needs of over 1,000 stakeholders.
●Lead the company stakeholders through a rigorous interview process to define the Kimball Method Business Matrix to assist in DW architecture.
●Assisted the client with talent acquisition efforts in the hiring of SQL, ETL, and DW developers
●Worked strategically with the Director of IT to help IT partner more effectively with the business and to prep organization for migration to current versions of SQL2012, Dynamics AX 2012, and Dynamics CRM 2013.
●Delivered such tactical services as SQL, ETL, and .NET development to build the various parts of the solution, from portal-based requirements gathering tools and testing tools, to SQL databases, scripts and queries for ETL and reporting, all using Microsoft SQL Server 2008R2 (SSIS and SSRS).
CLIENT: TCF INVENTORY FINANCE INC., NOV 2013 TO JAN 2014– Business Intelligence/Data Warehouse/Reports
●Perform Analysis, Architected, and Developed a new Microsoft BI Stack Solutions for TCF Banks Inventory Finance subsidiary.
●Worked closely with internal stakeholders to identify and implement business requirements.
●Toolset used included Microsoft SQL Server 2008 R2, Visual Studio 2012, architected ETL packages with SSIS, developed reporting using SSRS and Tableau. Also provided cubs for reporting using SSAS.
CLIENT: VITAL DECISIONS LLC (EDISON, NJ), FEB 13 TO DEC 2014 – Business Intelligence/Data Warehouse/ Dynamics CRM/ Call Center Solution Consultant
●Worked with Client business leaders, CoCentrix Dynamics CRM Solution providers, and telephony and server compliance vendors to architect a mission critical comprehensive case management data warehouse and reporting solution to run the clients growing business.
●Perform Analysis, Architected, and Developed a new Microsoft BI Stack Solution using MSSQL, SSIS and CozyRoc ETL processes, Data warehouses, and Developed reports in SSRS to support a proprietary case management system.
●Worked closely with internal stakeholders (C-Level Executives and Directors) to identify and implement business requirements.
●Toolset used included MS Dynamics CRM/Cocentrix CCP, Microsoft SQL Server 2008 R2, Visual Studio 2008/2010, SSIS, SSRS, and SSAS.
CLIENT: PAYNET (SKOKIE, IL), OCT 12 TO NOV 12 – ETL/SSIS Training Consultant
●Delivered Microsoft SQL Server 2008 R2 SSIS training to a team of 5 Integration Analysts.
●Developed Microsoft SQL Server 2008 R2 SSIS Packages assisting the trainees in completing their various project requirements.
●Performed analysis with proofs of concept with internal stakeholders using Pentaho Data Integration platform in addition to SSIS
CLIENT: HU-FRIEDY (CHICAGO, IL), MAY 12 TO SEPT 12 – SAP/Business Intelligence/Data Warehouse Consultant
●Worked SAP Architect to Analyze and extract SAP Master and Sales data in the existing SAP BW Business Intelligence Solution.
●Perform Analysis, Architected, and Developed from scratch a new first phase Microsoft BI Stack/SharePoint Solution including SAP to MSSQL ETL processes, Data warehouses, Analysis Services Cubes, developed reports in SSRS, Models, and SSIS Packages to support and leverage customer data warehouses
●Worked closely with SAP Business Analysts and internal stakeholders to identify and implement business requirements.
●Toolset used included SAP New Weaver 7/ BW, Microsoft SQL Server 2008 R2, SharePoint 2010, Visual Studio 2008/2010, SSIS, SSRS, and SSAS.
CLIENT: ACQUITY GROUP (CHICAGO, IL), APR 12 TO MAY 12 – Business Intelligence/Data Warehouse Consultant
●Worked with Internal Reporting Analyst to jumpstart a new Business Intelligence Dynamics AX Initiative.
●Developed New Data Warehouses, developed reports in SSRS Reports, Data Models, Security, and SSIS Packages to support existing customer reporting requirements.
●Worked closely with Business Analysts to identify and implement business requirements.
●Toolset used included Microsoft SQL Server 2008 RS, Visual Studio 2008/2010, SSIS, SSRS.
CLIENT: MADDEN COMMUNICATIONS (WOOD DALE, IL), AUG 10 TO JAN 12 – Business Intelligence/Data Warehouse Consultant
●Worked with architects to develop and support a new proprietary Business Intelligence Initiative.
●Developed Reports with SSRS, Models, and SSIS Packages to support and leverage customer data warehouses
●Worked closely with Business Analysts to identify and implement business requirements.
●Toolset used included Microsoft SQL Server 2008 RS, Visual Studio 2008/2010, SSIS, SSRS, and SSAS, Cognos Framework Manager, Pentaho Data Integration.
CLIENT: INSURESOFT (UNIVERSITY PARK, IL), MAY 10 to AUG 10 –Application Development Consultant
●Supported, designed, and developed insurance industry software solutions for the INSURESOFT proprietary Diamond system using vb.net, WinForms, SQL Server 2005, ASP.NET 2.0, T-SQL.
●Provided development for all the clients various lines of business; Home, Dwelling Fire, Personal Articles (Inland Marine), Watercraft, Umbrella, and Auto policy rating and policy management processes.
●Worked closely with external client testers and quality assurance staff to ensure business requirements compliance.
CLIENT: NATIONAL BLACK MBA ASSOCIATION (CHICAGO, IL), Feb 09 to MAY 10–Application Development Consultant
●Designed, developed and supported new development and enhancements to the association’s CRM and web portal systems using Microsoft CRM, SQL Server 2005, ASP.NET 2.0, T-SQL, and JavaScript.
●Designed, developed, and delivered business processes and systems to manage membership dues transactions and refunds, internal dashboard applications for IT, Membership, and Corporate Development.
●Designed and developed customizations for Microsoft Dynamics CRM application modules.
●High visibility/P & L results include reduction of Technical Support calls and increase in customer satisfaction by membership and internal users by 90%; Increase in monthly revenues processed through the re-engineered e-commerce technology systems by 105-115%.
CLIENT: NORTH AMERICAN CORPORATION (GLENVIEW, IL), April 08 to Feb 09 – Consultant
●Designed, developed and supported enhancements to client’s proprietary SMART E-Business platform using SQL Server 2000 & 2008, ASP.NET/Classic ASP, T-SQL, and JavaScript.
●Executed high-profile, P&L impacting projects which provided significant value to external clients and internal customer support including quantity allocation management, automated catalog management, and quick order technologies.
●Performed Analysis for and proposed future Smart Mobile E-Business systems including mobile web and text messaging services.
●Worked on design for classic asp to ASP.net conversion.
CLIENT: NATIONAL PTA (CHICAGO, IL /WASHINGTON, DC), Dec 07 to Feb 08 – Consultant
●Designed, developed and supported enhancements to their proprietary OMDR (ERP) system using SQL Server 7, ASP, T-SQL, PL/SQL, and JavaScript.
●Lead analysis, requirements gathering, planning, and documentation for the OMDR system enhancements which included heavy contact with internal stakeholders throughout the organization.
●Performed Analysis, Design, Data Conversion and Data Re-architecture for the PI Certification System.
●Worked on designed and re-architecture for the next generation OMDR system.
CLIENT: AT&T (HOFFMAN ESTATES, IL), Mar 07 to Dec 07 – Consultant
●Designed and developed web-based .Net application components for the AT&T Business Continuity Planning System which provides an interface for over three thousand internal AT&T business units (AT&T, SBC, Bell South, and Cingular) to create, populate and maintain their continuity plans.
●The primary development environment consists of ASP.NET and VB.NET (version 2.0), SQLServer2005, JavaScript and IIS.
●Lead technical analysis, requirements gathering, planning, and documentation for the CAP (Create-A-Plan System).
●Designed and developed Import Interfaces with Sungard’s Paragon Availability System.
CLIENT: COAMS (CHICAGO, IL), Jan 07 to Mar 07 - Consultant
●Designed, developed and supported enhancements and bug fixes for COAMS campaign production fulfillment system.
●The primary development environment consisted of Classic ASP, SQL Server 2000, JavaScript and VB/VBScript 6.
●Worked with Business Analysts to identify campaign and bug resolution related requirements. This position was primarily emergency support for legacy campaign applications.
CLIENT: NATIONAL PTA (CHICAGO, IL), June 06 to Jan 07 - Consultant
●Designed, developed and supported enhancements to their proprietary OMDR (ERP) system using Oracle 8i and 10g, SQL Server 7, ASP, T-SQL, PL/SQL, JavaScript and VB/VBScript 6.
●Lead analysis, requirements gathering, planning, and documentation for the OMDR system enhancements which included heavy contact with internal stakeholders throughout the organization.
●Performed Analysis, Design, Data Conversion and Data Re-architecture for the PI Certification System.
EDUCATION
B.G.S., Math, Communications, and Social Science, 1996 (University of Michigan, Ann Arbor, MI)
University of Michigan – Ann Arbor (BGS. Mathematics - 1996)
Contact this candidate