Scroll To View More
Scott Carmody, Data Warehousing Developer in Naperville, IL, United States
Scott Carmody

Data Warehousing Developer in Naperville, IL, United States

Member since August 21, 2019
Scott is a data warehouse architect and BI developer with 30 years of industry experience. He specializes in the Microsoft BI stack. He utilizes all aspects including building data marts and data warehouses in SQL Server, ETL with SSIS, SSAS cubes, and creating reports and advanced analytics with SSRS and Power BI. He also has considerable cloud experience with Azure and has worked with Azure SQL Database and Azure Data Factory.
Scott is now available for hire

Portfolio

Experience

  • Data Warehousing, 20 years
  • Dimensional Modeling, 20 years
  • SQL, 20 years
  • SQL Server Analysis Services (SSAS), 19 years
  • SQL Server Reporting Services (SSRS), 19 years
  • SQL Server Integration Services (SSIS), 14 years
  • Microsoft Power BI, 3 years
  • SQL Server 2016, 3 years
Naperville, IL, United States

Availability

Full-time

Preferred Environment

Windows 10, SSMS, Visual Studio, MDX Studio

The most amazing...

...project I have worked on was an end-to-end BI solution for a multi-national financial services company.

Employment

  • Senior ETL Developer for Reyes Holdings (Great Lakes Coca Cola Bottling)

    2019 - PRESENT
    Addison Group (contract)
    • Supported new and existing SSIS development for the Coca Cola business unit of the beverage distribution company.
    • Assisted with SSAS cube development.
    Technologies: SQL Server, SSIS, SSAS
  • Senior Data Warehouse Architect/BI Specialist

    2015 - PRESENT
    BluB0x
    • Solely created a data warehouse in Azure SQL Database reading from a transactional system (also in Azure) using Kimball methodologies and best practices. Developed SSIS ETL processes and successfully ported them to Azure Data Factory to service reports built into and rendered from the company’s ASP.NET MVC website. BluB0x is a manufacturer and service provider offering physical security as a service (card readers, elevators, video, alarms, visitor management, biometrics, mobile, etc) using Microsoft Azure as its hosted cloud solution.
    • Implemented Power BI as an analytics platform sourced from the company’s data warehouse as well as all reporting needs. This involved porting the model, managing relationships and creating visualizations for reports and dashboards that will be embedded within the BluSKY web application.
    Technologies: SQL Architect, Azure, SSIS, SSAS, SSRS, Power BI
  • Senior BI Specialist for Plante Moran, Southfield, MI

    2019 - 2019
    Strive Consulting (contract)
    • Assessed and triaged issues related to data movement and ETL among business processes within the firm. Required extensive use of SQL scripting and SSIS.
    • Planned for data warehouse build-out.
    Technologies: SQL Architect, SSIS
  • Senior BI Specialist for Komatsu, Rolling Meadows, IL

    2019 - 2019
    Randstad Technologies (contract)
    • Helped create over 180 Power BI reports and dashboards against SSAS tabular models as part of Komatsu’s New Parts System initiative program.
    Technologies: SQL Architect, SSIS, Power BI
  • Senior BI Specialist for CDW, Vernon Hills IL

    2018 - 2019
    Insight Global (contract)
    • Oversaw all MDS (Master Data Services) and ETL development (SSIS) from the AS400 source system to the corporate DW in order to create a new categorization for products. Required extensive use of MDS and the MS BI stack of tools including SSIS.
    Technologies: SQL Architect, MDS, SSIS, SSAS
  • Senior BI Specialist for Ventas, Chicago, IL; Merchant's Fleet Management, Rosemont, IL

    2017 - 2018
    Addison Group (contract)
    • Managed all ETL development (SSIS) from the source financial system (Yardi) to the corporate DW. Also responsible for optimizing and developing MDX queries from several cubes used in reporting. Required extensive use of the MS BI stack of tools including SSIS, SSAS, and the MDX query language.
    • Headed DW architecture and ETL development (SSIS). Created Data Dictionary for DW. Optimized several source queries. Responsible for production deployment procedures.
    Technologies: SQL Architect, SSIS, SSAS
  • Senior BI Specialist

    2012 - 2017
    AON Corporation
    • Created, developed, and modified an entire BI solution to handle ad-hoc requests and MDX report queries regarding comparative analysis among clients (brokerage firms) for McLagan Retail. Architected a data warehouse according to Kimball best practices; created robust ETL using SSIS including email notification, auditing, and logging; designed and developed a cube in SSAS; and created complex calculated member logic and report queries using MDX. Mentored and assisted the offshore team with MDX query creation. Required extensive use of the entire MS BI stack of tools including SSIS, SSAS, SSRS, and the MDX query language.
    • Assisted in redesigning a more optimal solution for the existing survey data warehouse. Helped to evaluate in-memory solutions including Qlik. Developed a robust ETL solution for large data loads using SSIS 2014. Also assisted with DBA tasks in an effort to host an acquired company in MS Azure. This included writing SQL stored procedures and administering SQL Agent jobs in Prod and LLCs with Availability Groups.
    Technologies: SQL Architect, SSIS, SSAS, SSRS
  • Senior BI Architect/Developer

    2012 - 2012
    SIMS Recycling (contract)
    • Created a complete data warehouse and BI solution for inventory analysis. Required extensive use of the entire MS BI stack of tools including SSIS, SSAS, SSRS, and the MDX query language.
    Technologies: SQL, SSIS, SSAS, SSRS
  • Senior BI Architect/Developer

    2010 - 2011
    Redbox (contract)
    • Provided real-time strategic data and information to the loss prevention and games teams using a combination of T-SQL and OLAP cube queries. Created real-time alerts and reports which contributed to a reduction of fraud in game rentals from 17% to 2% and allowed for a nationwide rollout of games with an estimated $40 million increase in revenue.
    • Assisted the marketing department with numerous initiatives including providing RFM (recency, frequency, and monetary) data to assist in strategic decision-making initiatives.
    Technologies: SQL, SSIS, SSAS, SSRS
  • Senior ETL Architect/Developer for W. K. Kellogg Foundation, Battle Creek, MI

    2010 - 2010
    Information Technology Partners (contract)
    • Managed ETL architecture using a combination of T-SQL stored procedures and SSIS, SSAS, and SSRS Reports with Dundas to create a corporate dashboard displaying trends of corporate contract, request, and grant information for a non-profit charitable foundation. Dramatically reduced the existing ETL time from a run time of around one hour to between 5-10 minutes.
    Technologies: SSIS, SSAS, SSRS

Experience

  • Dashboard Creation (Other amazing things)

    Created over 100 Power BI dashboards in three months for a new parts system project. This included multiple visualizations, DAX coding, etc.

  • Redbox Game Rentals (Other amazing things)

    Redbox was considering not rolling out games to their kiosks because of a high rate of fraud in test markets. I created real-time alerts and reports which contributed to a reduction of fraud in game rentals from 17% to 2% and allowed for a nationwide roll-out of games with an estimated $40 million increase in revenue.

Skills

  • Languages

    SQL, C#.NET, VBScript
  • Tools

    Microsoft Power BI
  • Paradigms

    Dimensional Modeling
  • Storage

    SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server 2016
  • Other

    Multidimensional Expressions (MDX), Data Warehousing, Data Warehouse Design, DAX

Education

  • Bachelor's degree in Computer Science
    1984 - 1988
    Siena College - Loudonville, NY
I really like this profile
Share it with others