DAVID J. RENKEN
************@*******.***
**** **** **** *****, ******, MO 63025
www.linkedin.com/in/davidrenken
CAREER OBJECTIVE
Financial professional looking to leverage specific experience in
forecasting, budgeting and strategic planning in a senior level position
within financial planning, business unit or plant leadership.
PERSONAL COMPETENCIES
- P&L Responsibility - Planning/Organizing -
Forecasting
- Change Management - Financial Modeling - Financial
Analysis
- Product Profitability - Team Building -
Problem Solving
- Variance Analysis - People Development
- System Integrations/Enhancements (JDEdwards, BPCS, Hyperion-Essbase)
PROFESSIONAL EXPERIENCE
Manager Financial Analysis/Planning
2005 - 2009
Tyco Healthcare - Mallinckrodt/Covidien
. Forecasted expenses by production and overhead departments for spending
summary used by management - overhead spending was approximately $150
million in FY2009
. Budget & Strategic Plan development including standard costs by product -
Cost of Production for the site of $250 million
. Utilized an Excel add in (Essbase) to aid in data accumulation, analysis
and reporting reducing analysis preparation shifting it to greater time
for analysis
. Responsible for the maintenance of systems in Essbase for rapid analysis
reducing the accumulation of data to minutes
. Worked with Plant Controller and Cost Accounting personnel in standard
product cost development in a chemical manufacturing environment
. Developed overhead allocation methodologies and calculated departmental
overhead rates
. Worked with Logistics to forecast monthly production by manufactured item
(Plant manufactured hundreds of thousands of pounds per month)
. Led forecast meetings to develop consensus among Finance, Logistics,
Manufacturing and Management on forecast submission
. Consolidated reports, analyzed trends and coordinated submission of
monthly forecast to Plant management and division executives
. Assisted in the monthly financial close
. Participated in the annual Sarbaines-Oxley review/audit
Controller - Pharmaceuticals Business
1995 - 2005
Mallinckrodt/Tyco Healthcare - Mallinckrodt
. Approved Rebate transactions for payment to customers of approximately
$75 million
. Determined one of the major Wholesalers was receiving too much credit for
charge backs and recovered $3 million
. Forecasted sales ($400 million annually) and margins ($200 million
annually) by product to update monthly forecast
. Provided Marketing with support (historical trends, prior forecast data)
in order to forecast future sales and expenses
. Generated and reviewed daily sales for comparison to forecast and
estimate its accuracy
. Calculated bonuses in accordance with approved plans and approved
payments of $3-4 million for division sales force
. Evaluated and adjusted reserves for obsolete inventory and doubtful
receivables
. Worked with the credit department to evaluate customers credit terms,
placing customers on credit hold or write-off accounts as uncollectible
. Formed a satellite A/R team to process debit memos and collect on
delinquent accounts reducing DSO by 3 days
. Performed due diligence for company acquisition ($75 million) including
physical inventory and A/R analysis
. Integrated acquired plant into company by establishing ledger accounts
and consolidation
. Forecasted profitability and sales for product line acquisitions - 2
generic products, 1 brand product yielding millions of profit annually
. Prepared presentations for VP/General Manager (actual results vs.
forecast and budget)
. Supervision of staff including a Plant Controller of a small packaging
operation (approximately 10 billion doses of pharmaceutical
tablets/capsules)
. Consolidated plant forecast into the business plan for senior management
Senior Financial Analyst / Financial Analyst
1986 - 1995
Mallinckrodt/MSCC/Mallinckrodt Chemical, Inc
. Assisted manager in P&L forecasting for four businesses by consolidating
data from sales and marketing
. Completed balance sheet forecasting
. Analyzed controllable working capital (DSO, DPO, DSI)
. Reviewed capital projects to determine compliance to company policies
. Reviewed capital project financials and compared to hurdle rates
. Consolidated and reported budget and strategic plan to senior management
. Reviewed and provided summarization of major projects (projects greater
than $1 million) for President and Board of Directors
Accountant - Financial Reporting
1984 - 1986
Mallinckrodt (wholly-owned subsidiary of Avon) sold to IMC in 1986
. Collaborated with business representatives to maintain accounts,
consolidation relationships and reporting
. Established new entities within the company reporting consolidation
. Maintained accounts of divested company on the general ledger
. Tracked journal entries and submitted to ledger system
EDUCATION & CERTIFIATION
Bachelor of Science - Accountancy, University of Missouri - Columbia
CPA
TECHNICAL SKILLS
. Microsoft Excel
. Microsoft Word
. Microsoft Power Point
. Multiple System Integrations
. Hyperion-Essbase
. JDEdwards