Scott Carmody

Sr Consultant for Kirkland & Ellis law firm (Chicago, IL) Migrating SSIS packages from SQL 2008 to SQL 2016

Sr Consultant for Komatsu, Rolling Meadows IL Co-developed over 180 Power BI dashboards supporting Komatsu’s New Parts System initiative. Helped architect data models to feed SSAS tabular mo...

Solely responsible for architecting and developing a Kimball DW in Azure along with a SSIS ETL process using Azure Data Factory to service reports built into and rendered from the company’s...

Sr Consultant for Plante Moran, Southfield MI Responsible for assessing and triaging issues related to data movement and ETL among business processes within the firm. Requires extensive us...

Technical Lead/Consultant for CDW, Vernon Hills IL Responsible for all MDS (Master Data Services) and ETL development (SSIS) from the AS400 source system to the corporate DW in order to crea...

Consultant for Ventas, Chicago IL Responsible for all ETL development (SSIS) from the source financial system (Yardi) to the corporate DW. Also responsible for optimizing and developing MDX ...

Solely developed a BI solution centered around Sims' inventory, invoicing, and CRM products using the Microsoft BI stack.

Responsible for providing real-time strategic data and information to the Loss Prevention and Games teams using a combination of T-SQL and OLAP cube queries. Responsible for providing strate...

Consultant for W. K. Kellogg Foundation, Battle Creek, MI Responsible for ETL architecture using a combination of T-SQL stored procedures and SSIS, SSAS, and SSRS Reports with Dundas to crea...

Consultant for Eli Lilly, Indianapolis, IN Solely responsible for creating a BI solution for the Health, Safety, and Environmental group at Lilly. Tasks included modeling the data for an ope...

Consultant for Ashley Furniture, Arcadia, WI Review current relational database and SSAS architecture and recommend best practices in cube design and processing Create MDX queries for dashbo...

Modeled, designed and developed a Data Warehouse/BI solution for an international distributor of natural and herbal health care products. Tasks included modeling a Sales and Marketing soluti...

Responsible for operational database activities and theoretical database design/modeling using SQL Server 2005. Extensive report writing using SSRS as well as requirements gathering with sen...

Designed and developed a SQL Server 2005 Data Warehouse with data from many disperate medical sources. Extensive modeling following the Kimball approach was implemented. This warehouse will ...

Develop data marts and OLAP cubes using Microsoft Analysis Services 2005 and SQL Server 2005 for Cohen’s business processes. This included retrieving Producer (sales), Lender, Property, Quot...

Consultant for General Board of Pensions and Health Benefits for the United Methodist Church, Evanston, IL Developed a reporting solution for a major Pension and Retirement Benefits Admini...

Developed Crystal Reports used to display survey data for various health studies. Required use of SQL Server stored procedures and views. ;

Created an OLAP solution to stage and analyze data related to JLL’s financial and property management business. Integrated JD Edwards financial data as well as lease data held in proprietary...

Responsible for developing PL-SQL and Transact SQL stored procedures and views against an Oracle Data Warehouse and SQL Server databases. Solely responsible for all Crystal Reports and Cryst...

Responsible for automating cube creation of MS Analysis Services (OLAP) cubes. Knowledge of MS Analysis Services (OLAP), MS SQL Server 2000, and Visual Basic 6.0 were required. General cus...

Responsible for content and database changes relating to the Apropos product. Also created procedures, triggers, and scripts to fully automate the creation of the database, users, roles, and...

Consultant at Superior Coffee, Bensenville, IL Solely developed an application to track national account information. Application was created in Visual Basic 6.0 and SQL Server 7.0. Involved...

Consultant at Allstate Insurance Co., Northbrook, IL Primary Crystal Reports developer for the Equity and Fixed Income Investment Group. Created reports in Crystal Reports using both Oracle ...

Consultant for Navistar International, Oak Brook, IL Developed an application to assist the sales force in taking orders and processing orders into requests using Visual Basic 4.0, third par...

Responsible for developing a full life cycle EIS (Enterprise Information System) application using Visual Basic and MS Access. Responsible for installing and customizing Scopus, a client-s...

Consultant for General Electric Power Generation, Schenectady, NY Responsible for developing software for Steam Turbine engineers using C, UNIX and Sybase

Consultant for General Electric Corporate R&D, Schenectady, NY Responsible for developing a hypertext application which imitated the daily tasks of an engineer. Development was done using C ...