EXPERIENCE SUMMARY:

• Over twenty - five (25) years of experience concentrating in the financial and information technology fields
• Have worked on and supported multiple Hyperion products and applications including a financial consolidation system using Hyperion Enterprise and Hyperion Financial Management, and a forecast and budgeting application using Hyperion Planning.
• Have performed as a project manager using systems life cycle tools, MS Project and Visio on the corporate financial consolidation system and general ledger systems. Responsibilities included documenting current processes, developing and documenting system design documentation, test cases, and implementation plans
• Facilitated user requirement meetings with vendor and training of users
• Have performed as an analyst, a systems liaison, business analyst and system administrator including root cause analysis and troubleshooting
• Have performed in the technical environments of Hyperion Planning, Hyperion Financial Management, Hyperion Data Management, Hyperion Enterprise and MS Office
• Demonstrated excellent written and non-verbal communication skills

TECHNICAL SKILLS:

Operating Systems: Windows

Databases: MS Access, Oracle, Hyperion Financial Management, Hyperion Data Management, Hyperion Planning, Hyperion Enterprise

Methodologies: Object Oriented (UML), System Development Life Cycle, Iterative Incremental (Agile)

Business Intelligence Tools: Confidential, MicroStrategy, Tableau

Ancillary Software: Microsoft Project, MS Excel, MS Office

SOFT SKILLS:

Industries: Automotive

Functions: Hyperion Systems Administrator, Financial Analyst, Budget and Forecast Analyst, Financial Team Lead/Manager

Applications: Hyperion Planning, Hyperion Financial Management

PROFESSIONAL EXPERIENCE:

Confidential, Auburn Hills, MI

Internal Financial Consolidations Manager

Responsibilities:

• Manage the month end processes for internal financial reporting that includes actuals, forecast and budgeting reports using Confidential
• Help with financial analysis for month end close and reporting processes
• Manage the change control process for Confidential metadata
• Work with the user community to establish reporting requirements for changes
• Provide training on how to use Confidential and the system related internal financial reports
• Managed a financial analyst aiding in the support of the Confidential system

Environment: Hyperion Financial Management, MS Access, MS Excel

Confidential, Detroit, MI

System Administrator

Responsibilities:

• Performed the management and support the Hyperion Planning application of Global Engineering Finance ( Confidential ) which is used to consolidate and report the Global Engineering Budget and Forecast
• Performed the maintenance of Confidential security
• Managed the month end maintenance and processes to the Confidential application
• Worked with the user community to establish reporting requirements for changes to Confidential
• Provided training on how to use the application and on any changes made to the operations of the application

Environment: Hyperion Planning, MS Access, MS Excel

Assistant Manager

Confidential

Responsibilities:

• Managed and supported the Global Sales Reporting Analysis ( Confidential ) and Vehicle Sales Tracking Analysis and Reporting ( Confidential ) teams
• Provided update to training materials for users with system enhancements
• Facilitated and managed projects and enhancements related to these applications including such things as user meetings and training when needed
• Provided ad hoc reporting to executive management as needed using Confidential and MicroStrategy reporting tools

Environment: Confidential, ORACLE, Tableau, MS Excel

Senior Financial Analyst

Confidential

Responsibilities:

• Administered the financial planning consolidation system including managing security and database changes for Confidential, a Hyperion Planning application
• Had responsibility for loading data in the financial planning consolidation system of Confidential
• Provided update to the training materials for users with system enhancements
• Facilitated user meetings and training when needed
• Performed second level help desk support for Confidential
• Performed as a Business Analyst and project team member in the creation of Confidential system by collecting and documenting requirements, creating test cases and training materials

Environment: Hyperion Planning, Oracle, MS Excel, MS Access

General Supervisor

Confidential

Responsibilities:

• Managed a group of four analysts in supporting corporate financial consolidation systems
• Administered of security and database changes for corporate financial consolidation systems that included Hyperion Enterprise, Hyperion Financial Management, and Financial Data Management.
• Performed change control management of corporate financial consolidation systems
• Followed and use SDP-21 (systems life cycle) tools for project management
• Assisted in Sarbanes-Oxley 404 and Deloitte system audits
• Managed a $3m IT budget for Controller’s Staff
• Managed the project as well as the development team for the budget and forecast system. Responsibilities included defining the scope, goals, and objectives, gathering requirements, and controlling the budget of this project.
• Managed the project as well as the development team for the ledger and financial consolidation system, which migrated mainframe legacy systems to web based applications. Responsibilities included developing project requirement documents for use by an outside vendor, developing and documenting test cases, developing and documenting implementation plans and then implementing the new system.
• Developed system documentation and training programs for users for these systems.
• Coordinated changes to corporate policies
• Implemented internal control processes for the Controller’s Staff
• Maintained Controller’s Staff website
• Re-engineered the collection of audit expense data by using web-based applications

Environment: Hyperion Enterprise, Hyperion Financial Management, Hyperion Financial Data Management, Confidential, MS Excel, MS Access

Financial Analyst

Confidential

Responsibilities:

• Re-engineered the database for the corporate overhead and divisional overhead rate process
• Developed a process for forward pricing information
• Analyzed impact of Corporate and Government accounting changes to Government contracts
• Analyzed and allocated corporate paid and accrued costs to the divisions
• Managed internal control for the Government Business Reporting Section
• Prepared invoices on various Government programs
• Developed price proposals for various Government activities, as required
• Assisted Vehicle Development & Technical Operations with contract pricing requirements
• Supported negotiations with Government, as required
• Interfaced with Confidential and assist in resolving audit issues

Environment: MS Excel, MS Access