Patrick L. Trammell
******@*******.***
SUMMARY OF QUALIFICATIONS
* Competency in financial and business-metric modeling, forecasting,
reporting,
cost analysis, budgeting, capital investment evaluation and decision
support.
* Proven ability in developing and implementing financial and
operational plans.
* Advanced people skills; superior verbal and written communication
skills.
* Proficiency with standard business software and business analysis
tools.
* Produces timely results with limited direction, as part of a team or
as an individual contributor.
WORK EXPERIENCE
QVD US (national seafood importer/distributor)
Financial Analyst/Contractor 3 months
Developed financial models for sales forecasting, long-term planning and
supply chain integration.
T-Mobile (national wireless telecom company)
Financial Analyst/Contractor 5 months
Responsibilities: marketing metric analysis and executive dashboard
reporting by program, product, rate plan, channel and market.
Nordstrom's (national department store retailer)
Financial Analyst/Contractor 2 months
Responsibilities: construct integrated forecasting model for sales, margin,
purchases, markdowns and inventory.
Vertafore, Inc. (software developer/supplier of management
systems to insurance agency industry)
Financial Analyst/Contractor 22 months
Responsibilities: income statement forecasting; revenue recognition and
operating expense variance analysis; operating budget preparation and
product pricing analysis.
Cascade Natural Gas (distributor to 237,000 residential, commercial and
industrial customers)
Financial Analyst/Contractor 7 months
Responsibilities: income statement forecasting; margin and operating
expense variance analysis; cash flow modeling; operating budget preparation
and consolidation; capital investment analysis; banking fee analysis,
lockbox RFQ preparation and vendor selection.
Aventail, Inc. (supplier of network access/security devices)
Financial Analyst/Contractor 3 months
Responsibilities: reporting key operating metrics such as sales by product,
customer and channel; receivables and collections; cash receipts and
disbursements; personnel headcount and evaluation units. Forecasting cash
flow; explaining income statement and balance sheet variance to budget.
Microvision, Inc. (supplier of laser/lens display systems)
Financial Analyst/Contractor 3 months
Responsibilities: building financial models for application of engineering
and manufacturing overhead to cost-of-sales and inventory; for government
program bid rates and factors; for cash-flow forecasting; for expense
allocations.
Nokia, Inc. (supplier/integrator of wireless telecom
networks)
Financial Analyst/Contractor 3 months
Responsibilities: building financial models to reconstruct and reconcile
billing on a $1 billion contract for the several thousand sites of AT&T
Wireless' nation-wide network, using internal information systems (MLS,
NOLS, NMS) to capture and inter-relate financial and engineering data.
Patrick Trammell resume (continued)
Atomfilms Corp. (short-film distributor/syndicator)
Planning Manager/Contractor 9 months
Responsibilities: developing comprehensive business plans and content
acquisition models; evaluating sales performance by product and channel;
assessing product profitability/ROI for investment and programming
decisions; evaluating filmmaker royalty structures.
Fortune, Inc (business planning consultancy)
Business Planner/Consultant 8 years
Responsibilities: developing strategic, financial and operational plans
for medical, hotel, public relations, communications, engineering, retail
and non-profit organizations.
Winebow, Inc. (fine-wine importer/distributor)
Director of Operations 2 years
Responsibilities: expansion plan that doubled sales in two years; hiring,
training and supervising five department managers; installing/managing an
integrated distribution-accounting system; implementing inventory location
and tracking system; establishing next-day fleet delivery service for 2,500
customers.
Rockwell International ($6 billion annual sales, diversified engineering
and manufacturing company)
Finance Manager, reporting to VP of Sales and Operations ($80M
communications division) 4 years
Directed 2 managers and 10 analysts performing financial planning and
control for 400 sales, tech support and project engineering personnel with
an annual budget of $20 million. Managed admin functions including orders
and sales forecasts, delivery scheduling, quotas and commissions, staffing
additions.
Finance Manager, reporting to VP of Finance ($80M telecommunication
systems division) 4 years
Directed 3 managers and 12 analysts performing pricing, costing, capital
investment analysis, financial planning and project accounting functions.
Designed and implemented standard cost database, project accounting margin
system and catalog margin analysis system.
Led reviews of $10-30M business ventures/contracts, including competitive
analysis, project scope and schedule, staffing and capital requirements,
cash flow and return on investment.
Financial Analyst, reporting to VP of Finance ($6 billion corporation,
headquarters staff) 2 years
Consolidated monthly forecasts, performed variance analysis, prepared
monthly Board meetings, evaluated profit center operating plans as well
as acquisitions, divestitures, capital investments, finance policies and
corporate staff budgets.
EDUCATION
MBA, Finance and Accounting; University of Chicago
BS, Math major, Statistics and English minors; St. Louis University