Scott Carmody, Data Warehousing Developer in Naperville, IL, United States
Scott Carmody

Data Warehousing Developer in Naperville, IL, United States

Member since June 18, 2020
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

  • Toptal Project
    Microsoft Power BI, SQL
  • BluB0x
    Microsoft Power BI, SSRS, SSAS, SQL Server Integration Services (SSIS), Azure...
  • Toptal Project
    Microsoft Power BI, SQL Architecture

Location

Naperville, IL, United States

Availability

Full-time

Preferred Environment

MDX, Visual Studio, SQL Server Management Studio, Windows 10

The most amazing...

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

Employment

  • Power BI Developer For One of The World's Largest Brewers

    2019 - PRESENT
    Toptal Project
    • Managed the architectural design of the underlying SQL database for various initiatives within the company.
    • Designed and developed Power BI models to support the internal initiatives. This included relating the tables, creating DAX measures and incorporating appropriate visualizations.
    Technologies: Microsoft Power BI, SQL
  • 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: Microsoft Power BI, SSRS, SSAS, SQL Server Integration Services (SSIS), Azure, SQL
  • Power BI Developer for An International Consulting Firm

    2020 - 2020
    Toptal Project
    • Served as a Power BI consultant for a large analytics and data science consulting company in South America.
    • Created a Power BI report for their client. This was an iterative approach where the client was rapid prototyping design and functionality. Involved complex modeling, visualizations, and complex DAX coding.
    Technologies: Microsoft Power BI, SQL Architecture
  • Senior ETL Architect/Developer for Kirkland & Ellis (legal firm)

    2019 - 2019
    Request Technology
    • Converted SSIS packages under SQL 2008 R2 to SQL 2016. Added new functionality when needed.
    Technologies: SQL Server Integration Services (SSIS), SQL
  • 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 Server Integration Services (SSIS), SQL
  • 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: Microsoft Power BI, SQL Server Integration Services (SSIS), SQL
  • Senior ETL Developer for Reyes Holdings (Great Lakes Coca Cola Bottling)

    2019 - 2019
    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: SSAS, SQL Server Integration Services (SSIS), Microsoft SQL Server
  • 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: SSAS, SQL Server Integration Services (SSIS), Cisco MDS, SQL
  • 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: SSAS, SQL Server Integration Services (SSIS), SQL
  • 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: SSRS, SSAS, SQL Server Integration Services (SSIS), SQL
  • 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: SSRS, SSAS, SQL Server Integration Services (SSIS), SQL
  • 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: SSRS, SSAS, SQL Server Integration Services (SSIS), SQL
  • 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: SSRS, SSAS, SQL Server Integration Services (SSIS)

Experience

  • Dashboard Creation

    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

    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, MDX
  • Tools

    Microsoft Power BI, Visual Studio, SSAS, SSRS
  • Paradigms

    Dimensional Modeling
  • Storage

    SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server 2016, SQL Server Management Studio, Microsoft SQL Server, SQL Architecture
  • Other

    Data Visualization, Multidimensional Expressions (MDX), Data Warehousing, Data Warehouse Design, Data Reporting, DAX, Windows 10, Cisco MDS
  • Platforms

    Azure

Education

  • Bachelor's Degree in Computer Science
    1984 - 1988
    Siena College - Loudonville, NY

To view more profiles

Join Toptal
Share it with others