Matt Ockerman Email & Phone Number

Vancouver, Washington, United States

Data AnalystSafeguard customer and company data with utmost integrity. Maintain proficiency in Microsoft Excel, SQL Server Management Studio, and Power BI.Communicate with stake holders on reporting needs.Clarify report requests, identify key performance indicators, develop, and design requested reports.Work with data base engineer to ensure all required data is available and updated.Maintain an understanding of relations between databases and tables.Write SQL queries to extract relevant data.Normalize data and create table views as needed.Relate data from multiple sources into meaningful reports.Build, maintain, and distribute reports in Power BI, Excel, DMS, CRM, and other software tools.Develop and maintain relationships with personnel, management, and owners. I pride myself on the level of trust our stores’ personnel have in me. They know I’m here to help them, our customers, to the best of my ability.

Vancouver, Washington, United States

Duties as of 04.2018 include previous duties as well as:Data AnalystMaintain proficiency in Microsoft Excel, SQL Server Management Studio, and Power BI.Communicate with stake holders on reporting needs.Clarify report requests, identify key performance indicators, develop, and design requested reports.Work with data base engineer to ensure all required data is available and updated.Maintain an understanding of relations between databases and tables.Write SQL queries to extract relevant data.Normalize data and create table views as needed.Relate data from multiple sources into meaningful reports.Build, maintain, and distribute reports in Power BI, Excel, DMS, CRM, and other software tools.VisionMenu (Add on product menu/enrollment software).Assist finance managers with troubleshooting issues.Communicate with support.Set up/remove users as needed.The Guy that gets it done.Whatever needs doing I’ll learn it, plan it, implement it, and maintain it. Including training, developing and defining processes, troubleshooting, and taking ownership of the said product. Develop and maintain relationships with personnel, management, and owners. I pride myself on the level of trust our stores’ personnel have in me. They know I’m here to help them, our customers, to the best of my ability.Excellent at translating between IT and non-IT personnel.

Vancouver, Washington, United States

CRM/Desking (Customer Relations Management)Develop and maintain a thorough understanding of the CRM.Work with the stores to develop processes and workflows that meet the needs of the store and maintain the owner’s expectations.Support and train users from floor sales to general managers on any all aspects of the CRM software.Communicate with support.Maintain software settings including but not limited to; follow up processes, text and email templates, security Settings, add/remove users, and third party integrations.Desking settings; templates, proposals, fees/taxes, and products offered.Meet regularly with key personnel at the store level to discuss ongoing issues, share information, refine processes, and build relationships with the aim of further understanding store level needs.DMS (Dealer Management System)Maintain system settings for the sales and vehicle management portions of the DMS software.Work with the stores on creating and refining processes.Communicate with comptroller and IT to ensure continuity.Support finance managers, sales managers, and used car managers with issues or questions regarding deal issues. Including but not limited to; calculation errors, form changes, new forms, and inventory issues.Communicate with support as needed regarding sales/FI/VMS issues.Assist users with setting up and modifying reports.Work with other IT members to diagnose and resolve systemic issues with the DMS.OthervAuto (Inventory Syndication)Work with stores to ensure that proper inventory is listed in vAuto and third-party sites.Develop and maintain processes around inventory to ensure vehicles are categorized correctly.Assist in setting up/removing inventory feeds from third party vendors.Utilize vAuto data for reporting Set up/remove users as neededWindows Office ProductsAssist when needed with Excel and other office questions

Newberg, Or

Responsible for covering the Dealer's assets by ensuring proper legal disclosure of documents, verify all information gathered is complete and correct.Improve Dealership cash flow through the timely funding of contracts, keeping current on lender rates and programs, and developing relationships with lenders.Increase the profitability of dealership through selling products such as extended service contracts, and various insurances.Manage and educate sales staff in regards to available products and selling techniques.

Portland, Oregon Area

Responsible for scheduling and training customers on Windows-based software for multiple applications and processes within auto dealerships.Position requires an understanding of auto dealership business processes and the integration and applications of the processes within the software systems.Develop and implement processes to facilitate dealership functionality and profitability.Initiate and perform follow-up courses to ensure customer satisfaction.Facilitate weekly status and transition meetings with customers and management team.Develop and maintain relationships with dealership personnel and management.Listen effectively to understand customer's issues, concerns, and needs, so as to suggest and provide appropriate training and business solutions.

Irvine, Ca

Responsible for troubleshooting computer-based technical issues via telephone.Diagnosed and resolved problems relating to printer functionality, modem and communications issues, software configuration, and customer error.Followed-up with customers to assure solution of problem.