Manager Sales

**** ******** ****, *** *****, CA *****

Karl Komenda abk5yn@r.postjobfree.com

619-***-****

Education:

MA, Public Administration -- Monterey Institute of International Studies -- Monterey, California (May

1993)

BA, Latin American Studies -- University of California at Berkeley -- Berkeley, California (Dec. 1990)

Specific Skills:

Accounting: Passed all four sections of the May 1998 CPA exam.

Computer: SQL, MS Access, Visual Basic for Applications, Excel macros, Monarch, and MS Office

automation.

Experience:

Sr. Financial Analyst/Programmer -- US Foodservice San Diego -- Vista, CA (Jul.

2008 -- Jul. 2010)

• Developed a SQL server-based data warehouse that automatically imported data from

mainframe reports and SMART mainframe queries using enterprise server data transformation

packages;

• Created a fully automatic process to silently review and optimize the cost of thousands of

products each day, resulting in 2.5% increase to internal sales margin over six months;

• Built a vacation accrual and liability tracking database, based solely upon Kronos and

PeopleSoft queries, eliminating all possibility of input errors;

• Provided critical analysis of inventory problems, including early identification of

slow/dead/oversupplied inventory, improper pallet rotation, and pending short code date

products;

• Constructed a front-end database to facilitate shorts and fill-rate analysis by the Military

Department; and

• Used MS Access, VBA, and XML programming in Host-On-Demand to automate hundreds of

daily checks and corrections to item, customer, and vendor-level mainframe data.

Manager, Special Projects -- US Foodservice San Diego -- Vista, CA (Jan. 2006 -- Jul.

2008)

• Designed a local data warehouse in MS Access that auto-updated each morning with invoice-

level sales data;

• Developed automated procedures for distributing reports to Sales, Finance, and Operations

personnel;

• Created ad hoc databases, reports, and queries to resolve problems not easily addressed with

existing tools;

• Automated data import into the Margin Manager and Credit Manager toolsets, saving hours of

work;

• Programmed mainframe macros to put delinquent customers on credit hold in minutes instead

of hours;

• Built and managed sales commission database; and

• Provided training and leadership to two Financial Analysts.

Margin Manager -- US Foodservice San Diego -- Vista, CA (Dec. 2002 -- Jan. 2006)

• Developed an automated process for emailing pricing guides to account executives and

contract customers;

• Generated and distributed daily pricing exception reports to over fifty territory and district

managers;

• Analyzed multi-unit customer profitability, using activity-based costing methods, providing

breakeven analysis;

• Provided visibility to all components of gross profit, with reporting by customer, chain, and

business segment;

• Responsible for both AOP and CapEx budgets, developing models that allowed on-the-fly

changes during conference calls and presentations, using sales, cases, deliveries, and fixed cost

as cost drivers;

• Mapped entire local AS400-based G/L to Corporate mainframe G/L, providing weekly variance

analysis;

• Trained management team to use AFS Sales Discovery, automating weekly data upload and

download;

• Integrated sales, routing, and MS MapPoint software to provide geographical analysis of all

deliveries, enabling sales management to optimize account distribution between territory

managers; and

• Providing training and leadership to one Financial Analyst.

Financial Analyst -- US Foodservice San Diego -- Vista, CA (Jun. 1999 -- Dec. 2002)

• Performed general ledger variance analysis;

• Responsible for CapEx budget; and

• Generated weekly P&L Flash and period-end analysis reporting.

Accounting Manager -- AMS Plastics -- San Diego, CA (Maquiladoras in Baja, CA)

(Aug. 1998 -- Jun. 1999)

• Supervised Accounts Payable, Accounts Receivable, and Cash Receipts;

• Developed new procedures for cost-of-material reconciliation and month-end closings; and

• Built custom EDI transaction sets to meet specific customer and vendor requirements.

Staff Accountant -- DeNardi Truck Equipment -- El Cajon, CA (Sep. 1997 -- Aug. 1998)

Contact this candidate