|
|
|
|
Controller SAP Finance Analyst Accounting Accountant Hyperion SQL Resume
|
| Desired Industry: Multiple Job Offering |
SpiderID: 23384 |
| Desired Job Location: Philadelphia, Pennsylvania |
Date Posted: 11/14/2008 |
| Type of Position: Full-Time Permanent |
Availability Date: 11/15/2008 |
| Desired Wage: |
|
|
U.S. Work Authorization: Yes |
| Job Level: Management (Manager, Director) |
Willing to Travel: Yes, Less Than 25% |
| Highest Degree Attained: Bachelors |
Willing to Relocate: No |
Objective:
Areas of Expertise
- FINANCIAL ANALYSIS
- SAP / HYPERION / SQL
- PROJECT MANAGEMENT
- PROCESS IMPROVEMENT
- FINANCIAL SYSTEMS MANAGEMENT
- COST & GENERAL ACCOUNTING
- APPLICATION DEVELOPMENT AND ADMINISTRATION
Experience:
Work Experience
Draeger Medical - Telford, PA
Manufacturer of incubators, monitors, and provider of equipment services to the healthcare industry
($400M in sales; Parent: $1B in sales). Position was eliminated due to downsizing.
Sr Controller - January 2007 to October 2008
ACCOMPLISHMENTS:
- Developed a month-end reporting package for upper management that provided financial statement
comments and company-wide project updates.
- Developed reports and trend analysis utilizing SAP and SQL that focused on cash flow, working
capital management, business unit profitability, and cost center spending. The result of which
improved root cause analysis and financial statement transparency.
- Aided in establishing the company’s first CO (financial analysis, cost, and SAP support) department
(9 headcount at the start of my employment). Reduced headcount by 2 FTEs through automation
and streamlining of procedures.
- Project Manager for the following:
- Implementation of an SQL data warehouse that significantly improved business unit analysis by
incorporating SAP Business Warehouse and key SAP tables.
- Resurrected the scrap and cycle count program and established a root cause analysis process.
- Established the company’s first comprehensive physical inventory program in over 15 years.
- Overhauled the deferred revenue determination process, the result of which allowed our external
auditors to remove an audit finding that had been part of the management letter since 2006.
RESPONSIBILITIES:
- Financial Modeling and Analysis
- Shared services and operations budget preparation and presentation to the US Executive team.
- CO and COPA (financial analysis) reporting on 350+ cost centers to cost center managers and four
profit center management teams.
- Developed the quarterly forecast analysis for two legal entities.
- Managerial responsibility for the CO month and year-end close process.
- Shared managerial responsibility for fiscal year-end audit support.
- Inventory analysis and reporting on a $60M inventory for two legal entities.
- Provided procedural instructions, business guidance, and SAP support to the US organization for the
PP, MM, SD, and FI-CO modules.
- Management of a Sr Financial Analyst, Financial Analyst, Financial Database Analyst, Tax
Accountant, Cost Accountant, and two Sr Cost Accountant positions.
- IFRS principles interpretation and application.
Hunt Power Inc. - Langhorne, PA
Manufacturer of high-end electronic meters ($100M in sales; Parent: $2.3B in sales).
Hunt Power is a division of Hunt Oil Inc. Manufacturing division sold to an investment firm.
Controller \ Business Process Manager - 2005 to 2007
ACCOMPLISHMENTS:
- Implemented the company’s first inventory control processes and standard costing system.
- Negotiated agreements with three new subcontractors to reduce sub-assembly unit costs, reduce
internal capacity constraints, improve sub-assembly quality, and delivery reliability.
- Successfully managed a plant consolidation in order to minimize sales interruptions, equipment loss,
and inventory obsolescence.
- Project Manager for the following:
- Implemented the company’s first Material Resource Planning (MRP) system within SAP,
which aided in a 15% reduction in inventory.
- Implemented numerous aspects of SAP’s PP, MM, SD, and FI-CO modules.
RESPONSIBILITIES:
- Provided capital expenditure, lease vs. buy, major financial measures analysis and reporting.
- Responsible for the financial representation, financial analysis, and working capital management.
- Managerial oversight for the subcontracting process that provided work-in-progress sub-assemblies.
- Managed accounting, purchasing, operations, and SAP positions.
Worthington Armstrong Venture (WAVE) - Malvern, PA
Manufacturer of ceiling grid suspension systems ($200M in sales).
WAVE is a joint venture between Armstrong (3.5 B in sales) and Worthington (3.0B in sales)
Assistant Corporate Controller - 2000 to 2005
Plant Controller - 2000
Financial Analyst - 1999 to 2000
ACCOMPLISHMENTS:
- Initiated focus on shortening inventory turns, inventory reduction, controlling period costs, and
improving average selling price over fiscal quarters.
- Team member that developed the company’s first standardized performance measurements reporting
and goals settings process.
- Provided analysis and reporting for Material Usage and Mix, Labor, and Direct Cost Variances.
- Project Manager for the following:
- Developed a comprehensive and automated cash flow analysis and reporting system.
- Successful BPCS maintenance system implementation.
- Automated product pricing reports for upper management, world-wide sales force, and internal
customers. The benefit of the tool for the company was to maximize the average sales price on
an order by order basis.
- Automated the Debt Covenant reporting process utilizing Hyperion Retrieve. This reporting was
used to satisfy the 50 Million dollar loan requirements and aspects of the year-end audit process.
- Automated all or major aspects of the following tasks: year-end tax package, sales tax reporting
and reconciliation, inter-company trading prices, inter-company clearing account reconciliation.
- Designed, developed, and automated pro-forma P&Ls, sales reporting, and sales analysis process
for major product lines, profit centers, sub-contractors, and geographic regions for upper
management and the world-wide sales force.
- Improved the month-end payroll postings which saved 4 full workdays each month.
RESPONSIBILITIES:
- Responsible for the worldwide Hyperion financial statement consolidation and reporting process.
- Provided capital expenditure, lease versus buy, and major financial measures analysis and reporting.
- Global reporting team leader that lead team by instructing the U.S., Europe, and Asia controllers on
U.S. GAAP, Sarbanes Oxley compliance, performance measures, month-end close, master data
management, year-end budgeting process, logistics, cost accounting, and systems and procedures
compliance.
- Six Sigma training and project participation that utilized the principles.
- Primary accounting representative for the interim and year-end audits for our external, internal, and
tax auditors.
- Improved upon and further developed the following systems and components in order to improve
upon the accuracy and timeliness of world-wide reporting . . .
SAP (FI/CO, MM, & SD), SAP’s Business Warehouse, BPCS, J.D. Edwards, Hyperion, Hyperion
Retrieve, Best Fixed Asset System, and WebEx.
Other Related Experience
Positions held from 1994 to 1999:
Staff Accountant, Cost Accountant, Sr. Cost Accountant, Financial Analyst
Education:
Education
Bloomsburg University, Bloomsburg, PA
Bachelor of Science Degree - Major: Accounting & Business Management
Penn State University, Great Valley Campus, PA
Certification: Programming and Database Development.
Key areas of study: Oracle, SQL, PL\SQL, Visual Basic, Active Server, Perl, Java Scripting, HTML
Skills:
Computer Experience
Enterprise Level Software:
SAP, BPCS, JD Edwards
Software:
Hyperion Enterprise, Reporting, and Retrieve
Microsoft Access, Excel, PowerPoint, Word, and Project
Cognos Powerplay, Crystal Reports
DB2
Additional Information:
Areas of Expertise
- FINANCIAL ANALYSIS
- SAP / HYPERION / SQL
- PROJECT MANAGEMENT
- PROCESS IMPROVEMENT
- FINANCIAL SYSTEMS MANAGEMENT
- COST & GENERAL ACCOUNTING
- APPLICATION DEVELOPMENT AND ADMINISTRATION
Reference:
Available upon request.
Candidate Contact Information:
TheJobSpider.com has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response. |
|
|
|
|
|