Kyle Hoac Email & Phone Number

Vevey, Ch

* In charge of the entire Nestle Professional sales reporting system of $1.5B in annual sales. Providing daily critical sales information to all levels of users from the President, VP of Sales, CFO, managers and external brokers. Guaranteed daily information availability by 8:00 am.* Managed a centralized system that supports over 95 critical downstream systems, reports and data files impacting Sales, Finance, Supply Chain, Marketing, and brokers on a daily basis.* Responsible for master data, project requirement gathering, system and reports development, training, maintenance and sustainability. * Architected, managed, maintained, and made necessary enhancements to the main sales system from data inceptions, scheduled jobs, and to the final output on the extranet, Excel, texted email, and Power BI.* Developed a solid daily validation procedure for completeness and accuracy. Documenting the QA work, archiving and signing off for accountability and future research.* Trained new and current employees on our extranet, web applications and reports. Training on Business Object, Power BI, Access, Excel Pivot table, etc. Understanding of our broker and customer hierarchies, sales credit, and how we calculates sales.* Completed the certification for Power BI, developed and implemented the first mobile app dashboard for Nestle Professional, successfully trained and achieved adoption by the President and all mission critical users. In the process of migrating other web and Excel reports over to the Power BI platform.

Vevey, Ch

* Worked closely with other divisions to develop incentive programs to calculate performance and payouts such as Cocoa & broker bonuses programs.* Managed the EDI system to ensuring DOT and Sysco daily data are cleansed and incorporated into the Nestle reporting system.* Developed the Group Purchasing Organization (GPO) systems which includes 26 accounts databases and one consolidated master system for reporting for cleansing data and standardizing the customers and products for reporting.* Developed the Nestle Professional Divisional and Customer Profit and Loss models for Finance. Enabled them to run what-if scenarios to predict profitability on new accounts in 2 minutes.* Daily productions of critical sales information to support Sales, Finance, Supply Chain, Marketing, and brokers. * Redesigned current processes for automation and efficiency using batch scheduler and Access VBA.* Performed daily validations to ensuring the reconciliation of all sales information in our system.

El Segundo, Ca, Us

* Provided sales reporting to upper management.* Analyzed sales with information from Oracle.* Developed and managed the COOP and retention programs.* Calculated charge back payments for our dealers (Circuit City, Radio Shack, etc.)* Calculated monthly commissions and update Oracle for payments.* Developed and trained users in using many of the in house database programs.

* Responsible for the full accounting cycle of 5 credit unions totaling $780M in assets.* Accounts receivable - Generated invoices, collected payments, and made daily deposits.* Accounts payable - Matched invoices with POs, updated the system, and printed checks for payment.* Used FAS 2000 to track fixed assets, ran monthly depreciation process and imported entries into the system.* Month end closing - Performed recurring entries, bank reconciliations, account analysis, and generated all financial reports.* Managed the migration of the legacy accounting system to the new MAPICS system.

* Audited data coming from the Retail Management System, Sales, and Treasury.* Working with different departments to resolve tax and other issues.* Worked on a project to resolve system errors. Finding of $1.45 million of unrecorded sales over the course of 2 years.* Changed, deleted, and created new cost centers in the system.

Associate Of Science (A.S.), Computer Systems Networking And Telecommunications

Bachelor Of Science (B.S.), Accounting