Eric Matz Email & Phone Number

Washington Dc-Baltimore Area

Washington Dc-Baltimore Area

Washington D.C. Metro Area

• Identify and lead IT integrations on new product/vendor opportunities for all locations to enhance operational efficiencies and profitability by 8%• Balance budgets and create Excel macros to facilitate proper cost analytics on all product lines and across three locations• Collect and analyze data from our point of sale system in Excel to evaluate menu sales in order to establish ideal margin and higher selling efficiencies which reduced waste by 20% and decreased cost of goods by 10%• Managed sales and marketing efforts across all locations and franchise company; increased social media engagement by 90% and increased the number of signed franchised locations by 33%• Address customer complaints and coordinate with store management to ensure optimal customer service

Washington D.C. Metro Area

• Worked jointly with United States Navy program offices to gather and analyze program financial data and program requirements in Excel to create and validate project life cycle cost estimates• Collaborated with clients to identify roadblocks and potential solutions for the project• Developed cost analysis to facilitate organizational decisions that directly impact fiscal and operational outcomes and presented to them to Navy program office project leads• Mentored junior analysts, assisting in onboarding and training

Arlington, Va

• Collaborated with United States Marine Corp to assist in collecting program requirements and financial data in Excel and ACEIT• Gathered historical data to determine key cost drivers and prepared reports to project life cycle costs • Performed data and cost analytics to assist program office leaders in their efforts to request additional funding from the US Congress• Worked with subject matter experts to identify and resolve data gaps in the program financial estimates

Washington D.C. Metro Area

• Analyzed large data sets and developed custom analysis for congressional districts dependent on the demographics using SQL, Excel, Microsoft Power BI and Tableau• Collected, normalized, versioned and cleaned large volumes of data sets detailing voter demographics and preferences for US Congressional member campaigns to better target voters in the election• Created and modified macro Excel templates to improve time and data efficiencies, increasing user’s productivity by 200%• Generated SQL Server Reporting Services Reports (SSRS) in Microsoft Visual to generate demographic reports for congressional member campaigns, which directly resulted in an increase of congressional seats in 2016• Lead a series of workshops teaching Excel skills to NRCC staff across departments

Fairfax, Va

• Formulated and defined system scopes and objectives based on both user requirements and a strong understanding of government-funded financial programs and industry knowledge • Performed research to assist in the development of project scope, define requirements, and propose areas for optimization • Implemented user acceptance testing on the EPA website redesign, involving regression testing and validating accepted functionality and criteria• Managed testing strategies to verify system validity and functionality