Power BI Developer For One of The World's Largest Brewers
2019 - PRESENTToptal 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, SQLSenior Data Warehouse Architect/BI Specialist
2015 - PRESENTBluB0x- 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, SQLPower BI Developer for An International Consulting Firm
2020 - 2020Toptal 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 ArchitectureSenior ETL Architect/Developer for Kirkland & Ellis (legal firm)
2019 - 2019Request Technology- Converted SSIS packages under SQL 2008 R2 to SQL 2016. Added new functionality when needed.
Technologies: SQL Server Integration Services (SSIS), SQLSenior BI Specialist for Plante Moran, Southfield, MI
2019 - 2019Strive 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), SQLSenior BI Specialist for Komatsu, Rolling Meadows, IL
2019 - 2019Randstad 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), SQLSenior ETL Developer for Reyes Holdings (Great Lakes Coca Cola Bottling)
2019 - 2019Addison 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 ServerSenior BI Specialist for CDW, Vernon Hills IL
2018 - 2019Insight 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, SQLSenior BI Specialist for Ventas, Chicago, IL; Merchant's Fleet Management, Rosemont, IL
2017 - 2018Addison 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), SQLSenior BI Specialist
2012 - 2017AON 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), SQLSenior BI Architect/Developer
2012 - 2012SIMS 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), SQLSenior BI Architect/Developer
2010 - 2011Redbox (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), SQLSenior ETL Architect/Developer for W. K. Kellogg Foundation, Battle Creek, MI
2010 - 2010Information 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)
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 ProjectMicrosoft Power BI, SQL
- BluB0xMicrosoft Power BI, SSRS, SSAS, SQL Server Integration Services (SSIS), Azure...
- Toptal ProjectMicrosoft Power BI, SQL Architecture
Experience
- Data Warehousing 20 years
- SQL 20 years
- Dimensional Modeling 20 years
- SQL Server Reporting Services (SSRS) 19 years
- SQL Server Analysis Services (SSAS) 19 years
- SQL Server Integration Services (SSIS) 14 years
- Microsoft Power BI 3 years
- SQL Server 2016 3 years
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
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, MDXTools
Microsoft Power BI, Visual Studio, SSAS, SSRSParadigms
Dimensional ModelingStorage
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 ArchitectureOther
Data Visualization, Multidimensional Expressions (MDX), Data Warehousing, Data Warehouse Design, Data Reporting, DAX, Windows 10, Cisco MDSPlatforms
Azure
Education
- Bachelor's Degree in Computer Science1984 - 1988Siena College - Loudonville, NY
