Frontline Analytics is a business intelligence consulting firm specialized in the Microsoft data platform. We offer core advisory consulting as well as solution design and development services to help organizations obtain greater value from their data and investments in Microsoft BI technologies including Power BI, Analysis Services, and SQL Server. I primarily focus on Frontline's relationships and engagements with customers and the ongoing development of staff and services. In addition to consulting engagements, I've written two books on Power BI and maintain the popular Insights Quest technical blog.

Technical and project leader of a business intelligence initiative for the supply chain of a major retail organization. Responsible for logical and physical data modeling, SSAS Tabular and DAX development, testing and documentation of all components of solutions (data warehouse, ETL, security, cubes, reports and dashboards). Also responsible for driving effective business user adoption of Microsoft Power BI tools and SSAS Tabular design standards and optimizations.https://powerbi.microsoft.com/

Technical lead on a multi-project scoping initiative for a Fortune 500 retail organization to design and plan a migration to the Microsoft information platform including Parallel Data Warehouse (PDW) and SQL Server Analysis Services (SSAS) Tabular. Developed SSAS Tabular and DAX query standards and best practices documentation to support development teams and future projects.. Developed complex SSRS reports to support system migration of supply chain organization.

Lead consultant and developer on an Agile BI solution for the supply chain organization of a national retail brand. Designed and developed staging layers and physical data mart, ETL/ELT logic, multidimensional data model, custom analytical metrics, interactive dashboards and reports, and solution roadmap and maintenance documentation. Technologies Used: SQL Server 2012, Power View, Power Pivot, T-SQL, DAX, SSAS Tabular Lead consultant on an Agile BI project for the finance division of a large manufacturing organization focused on profitability. Delivered a multidimensional data model, dashboards, exception reports, nightly refresh process, and documentation. Provided guidance on utilizing, supporting and enhancing the solution.Technologies Used: T-SQL, DAX, Power Pivot, Power View, SQL Server 2012, SharePoint 2013

Designed and developed ETL and BI Semantic Layers in support of Enterprise Data Warehouse. Developed and deployed multidimensional data model (OLAP cube), custom security requirements, advanced reports and dashboards, and provided training and support to end users. Technologies Used: SQL Server 2012, SSIS, SSAS Tabular, SSRS (SharePoint Integrated), Visual Studio, Team Foundation Server, T-SQL and DAX

Develops the eCommerce Operational Plans, Models and Dashboards for eCommerce Operations, Merchandise Planning and Site Management. Works closely and collaboratively with the eCommerce organization and shared services supporting eCommerce to understand business needs to identify and develop operational and financial solutions to improve profitability and service levels and to support future growth. Spearheads eCommerce analytics including Alerts and Exception Management Reporting, Key Performance Indicators (KPIs), dashboards, complex data modeling across functional disciplines and ensures that all work product is actionable, streamlined and can be employed in improving the overall performance of the supply chain. Works closely with technology professionals to create new processes and participates on various IT committees related to data management, governance and tools in order to bridge the gap between business and technology.

*Works closely with the Supply Chain organization to understand business needs and develop business intelligence solutions to improve profitability, service levels, and leverage network assets*Leads the evolution of the Business Anaytics organization, collaborating with Information Architecture*Develops the Transportation & Logistics Annual Plan models and all related financial reporting models. *Works closely with technology professionals to create new processes and participates on various IT committees related to data management, governance and tools in order to bridge the gap between business and technology*Drive business intelligence projects with IT

*Developed a new financial modeling and analysis tool to evaluate alternative operational scenarios and strategies*Implemented VBA programming and integration solutions to drive greater productivity and data integrity*Supported the financial plan, close, and forecasting process*Led database design, migration and upsizing projects

*Developed a financial model for the Sales organization to use in evaluating the profitability of contract scenarios*Supported annual budget process and monthly reporting*Spearheaded ad hoc analyses regarding customer behavior, merchandise mix, profitability/margin, and revenue growth