Scott Mohan Email & Phone Number

• Managed and implemented the resale pricing strategy for a large segment of the company’s product portfolio, representing $150 million in sales in the North American region. Monitored, analyzed, and reported on internal.
• Performed statistical, price, and financial analysis from various back office systems for strategic review, tactical price decisions, reporting, and trends.
• Analyzed quantitative and qualitative feedback from sales, executive management, supplier development, product management, finance, and marketing to improve pricing department functions.
• Designed and carried out department wide process improvements using SQL Management Studio, R statistical modeling software, and Microsoft Excel.
• Developed and maintained business intelligence dashboards in Qlikview BI software and SQL BI Studio designed for end-user data accessibility and flexibility. This design was subsequently rolled out to the entire.
• Quantified results of tactical pricing decisions, including price changes set up as controlled randomized trials, for reporting to management and various functional groups.

• Managed daily project accounting, monthly reporting, quarterly and year-end close for a portfolio of six clients, including billing, budget vs. actuals, staff utilization, project completion, and internal and client ad.
• Developed Excel VBA programs to extract customized, detailed, user-friendly internal and client reports from the legacy ERP system that provided better controls and near real-time information.
• Organized training to implement Excel VBA programs across the entire finance department. Report creation process changed from a three-hour manual process to a 30 minute largely automated process.
• Trained and supervised employees on the billing and vendor process, project management software, and day-to-day operations.
• Ensured accounting practices conformed to client contracts, corporate policy, and Sarbanes-Oxley.
• Successfully facilitated budgets, client reporting needs, and collections directly with clients’ finance contacts and internal project managers.

• Evaluated the relative risk of commercial loans with regard to customers' bank needs, performance, cash flow, and collateral. Reviewed customers' financial statements, accounts receivable and payable, and inventory..
• Participated in customer calls with the purpose of discovering company background, quality of operations, current threats and opportunities, business strategy, and the character of the business owners.
• Reviewed independent field audits and recommended commercial loan decisions based on their conclusions.
• Prepared internal loan proposals and submitted for approval based on the above analysis.
• Determined customer compliance with financial covenants such as minimum debt service ratio and tangible net worth.

Master'S Degree, Applied Statistics, 3.83/4.0

Mba, Business Administration, 3.75/4.0

Activities and Societies: Sigma Iota Epsilon National Honorary

Bs, Electrical Engineering