Matthew Braun Email & Phone Number

Port Jefferson Station, Ny, Us

Annapolis, Maryland, Us

San Diego, California, Us

Irvine, California, Us

New York, New York, Us

Bellport, New York, Us

Englewood Cliffs, New Jersey, Us

-Develop a SKU Optimization/Decommission process to analyze poor performing product and develop dashboards & reports in Tableau to view the brand, category, collections, category type against strategic initiatives.-Analyze syndicated IRI data to understand dollar and unit momentum to see what the growth trends within a brand or segment-Developed a ranking report in Tableau to see what items were selling the best (Unit and dollars) against our competitors.-Created a quarterly Quartile Analysis in Tableau to analyze each of Sundial’s collections.-Created a Cohort Analysis in Tableau to look at the products by launch year and their contribution to the overall business.

Bellport, New York, Us

-Extensively worked on SSRS and delivered complex reports from different data sources such as SQL Database and Cubes.-Engineered a productivity report (SSRS) to measure our employee effectiveness in selling our products (Key metrics: Average Dollar Sales, units per transaction) against all other store associates.-Built a tax jurisdiction report for our finance team so that could pay each state/county the sales tax each location was collecting on a monthly basis.-Implemented a system to post an Excel/PDF version all of our Regional, District and Store level reporting to Google drive.Assist the development of the firm's internal reporting platform and data warehousing Capability. Build data integration with other applications such as: POS, Financial, Marketing and ERP systems and support all downstream data warehousing and reporting. Work across departments to build common strategic frameworks that support the overall business analysis capability of the firm. Develop and support creation and management of KPI analytical reporting using Epicor systems. Function as the business team Subject Matter Expert for enterprise reporting tools - including user support and standard report development. Gather and document business requirements for new sources of data and data warehouse enhancements. Seek out and define new reporting and analysis capabilities to drive improved visibility to past performance and enable future decision-making.

New York, Ny, Us

Developed and implemented a curriculum for beginner, intermediate and advanced level Excel classes to teach entry level and advanced skills, key formulas and pivot table knowledge.Create an application to standardize the merchant order sheets using historical sales data by size/location to optimize orders.Created and deployed a “Top 50 Brands” report for the executive team to analyze sales growth shifts and changes in vendor margin.Create multiple SQL Server DTS packages to extract Bloomingdale’s data from MST’s Teradata EDW into local SQL Server.Convert and migrated all of Bloomingdales DTS packges to SSIS (SQL Server Integration Services)Converted screen scrapping Microsoft Excel based reports to use local SQL Server database.

Mba, Management

Ba, Resource Management/Dietetics

Dietetics/Nutrition