Allen Roan
Bryan, OH *****
Office: 419-***-**** Cell: 419-***-****
********@***********.***
SUMMARY
Financial Professional with expertise in financial reporting, planning and
analysis, cash flow, reengineering, systems and process implementation and
acquisitions. Strong analytical skills including Business Intelligence and
OLAP applications. Exceptional organizational skills, ability to work with
all levels of management and functional teams. Seeking a financial
management and/or Business Intelligence opportunity that will enable me to
make a meaningful contribution quickly to an organization.
PROFESSIONAL EXPERIENCE
INTERLYNX SYSTEMS, LLC Bryan, Ohio 2009 - Present
Financial Analyst
Analyze client financial/business/market data identifying trends and
opportunities by utilizing and developing business intelligence and data
mining techniques.
INGERSOLL RAND COMPANY Bryan, Ohio 1989-2008
Financial Analyst, Productivity Solutions, North America (2001-2008)
Financial Analyst to Director of North American Distribution
Developed, implemented and managed financial reporting and control
functions for a $400 million division that achieved record sales and
earnings during a time of significant organization and industry change.
. Designed sales management compensation system that held managers
accountable to measurable performance standards.
-Analyzed reporting requirements. Established Daily & Weekly
reporting/tracking of bookings & revenues (North America) for Sales,
Management.
-Run rate to forecast comparisons, prior year performance
-Revenue performance vs. rolling quarter
-Product Code breakdown vs. forecast prior year
. Created monthly summary reports
-Provides ability to review history, trend data, establish metrics-by
customer product, code; Strategic Business Unit and regional team
. Prepared critical analytical data in support of Monthly Business Review
-Tracking of new product development
-Performance by Strategic Business Unit
. Compiled end-user data from major customers
. Responsible for organizing Productivity Solutions "President's Club"
sales rankings information
. OLAP - Business Intelligence responsibility including report writing and
verification between Executive Information Systems (EIS - Pilot
Software/SAP), Oracle Discoverer and MFG/PRO.
Senior Financial Analyst, Worldwide Fluid Products (1994-2001)
Performed Financial Analyst duties for the Worldwide Fluid Products
Strategic Business Unit in a matrix management system. ($250 million annual
sales)
. Compiled monthly operating results package (line items for profit & loss
for Domestic; Latin America; Asia; Europe & Canada.
. Supervised staff of 3 data analyst in addition to relying on 3
individuals with dotted line responsibility.
. Headed Profit Growth Plan (budget), establishing time lines, instructions
and spreadsheets. Summarized preliminary, interim and final budget
results and conducted budget review meetings with department
leaders/plant managers. Supported Strategic Planning. Provided data for
projections and "what if" scenarios and created presentations.
. Provided historical data for standard cost review including manufacturing
overhead, absorption and variance. Created plant P & L statements on
MFG/PRO including analysis of material, labor and burden vs. forecast,
plan and prior year. Participated in annual physical inventory and cost
analysis at all facilities. Plant capacity calculations based on standard
labor content projections. Participation in new plant equipment
justification process.
. Played key role in acquisition of Johnstone Pump. Aligned Johnstone
general ledger accounts with Ingersoll Rand accounts.
Internal Auditor, Domestic Fluid Products (1989-1994)
Financial responsibility prior to re-organization into a matrix management
system. ($200 million annual sales)
. Prepared monthly and interim analysis of three manufacturing facilities
-Bryan, Ohio, Angola, Indiana, and Waterloo, Indiana
. Provided complete variance from forecast and prior year summaries for
closing meetings. Helped solidify results prior to accounting staff
submitting monthly Standard Trial Balance (STB) results to Annandale.
. Partnered with Sales, Marketing and Engineering departments to create
MFG/PRO reports for each facility including full P & L, departmental
spending, and variance analysis.
Design Institute of America Montpelier, Ohio 1980-1989
Accounting Manager/Controller
Lead accounting position ($20 million annual sales)
Privately held contemporary furniture manufacturer
. Supervised staff of 8 accounting/finance positions in various
manufacturing locations. Owners chose to take the company public and was
involved in due diligence and SEC compliance for DIA.
EDUCATION
Defiance College, Defiance OH
Bachelor of Science in Finance and Business
COMMUNITY ACTIVITIES
Bryan School Board, Bryan, OH
Served on Bryan School Board for 12 years
(Elected Position)
Northwest State Community College, Archbold, Ohio
Taught Microsoft Applications