TECHNICAL SKILLS

• HFM
• SAP
• FDQM
• OBIEE
• ARGOS
• MerlinXL
• Maestro
• Web Symphony
• MDM
• DRM
• Shared Services
• Hyperion Planning
• HAL
• Hyperion Ledger Link
• SAP
• Oracle Financials applications
• GEAC
• ADP Payroll
• Peachtree
• QuicksBooks Pro
• Lawson
• Mapics
• Movex
• Legacy
• PeopleSoft
• JD Edwards
• Great Plains
• MAS200
• Crystal Reports CorpTax
• Excel
• Lotus
• RealWorld
• Kronos and Platinum

PROFESSIONAL EXPERIENCE

Confidential, NH

Project Manager/Lead Applications Developer Consultant

Responsibilities:

• Serves as Project Manager/Sr Developer for implementation of HFM/FDM 11.1.2.4 with integration to Hyperion Planning and Essbase
• Leads the development, design, and implementation of information applications, upgrades, interfaces, and other enhancements from a functional/technical perspective to meet business requirements.
• Reviews and approves requirements, gap - fit analysis, and design documents
• Develops Quality management plans (acceptance criteria), Risk management plan (risk register), Issue management plan (issue tracker)
• Develops, tests, and runs export routines for data transfer to other systems
• Writes and optimizes HFM business rules, Essbase calc scripts, and develops metadata for both HFM and Planning apps
• Develops FDM/FDMEE and creates FDM batch processing, import format scripts, interface design, and data conversion
• Defines Security Groups, set up end user security in Shared Services for HFM and Planning applications
• Designs FRS analytical reports and support Smart View users through troubleshooting
• Creates and maintains consistent and thorough documentation of all processes and procedures for supported applications
• Monitors implementation deliverables both functional and technical. Provided feedback to key stakeholders, and system implementers
• Reviews and coordination of any service change orders, statements of work, service level agreements, etc. with business
• Develops user training materials and conduct user training sessions, as needed
• Conducts weekly project status meetings with budget updates
• Implemented SAS70 and SOX controls also developed system reports
• Utilizes Scrum Methodologies, HFM, HP, HEssbase, FDM/EE, FRS, OBIEE, Masterpac, HEnterprise, MSProject, MSVisio

Confidential, Grove, IL

Project Manager/Sr. Applications Consultant

Responsibilities:

• Provided technical administrative support to client SaraLee
• Performed Hyperion Financial Management (HFM), and FDQM Administrator duties including maintenance of metadata and rules
• Created, configured, designed, and implemented new Hyperion applications (ie. FDQM, HFM, MerlinXL)
• Kept development and conversion, environment in sinc with production environment
• Implemented HFM at the business unit level, including required data integrations, as needed
• Developed and updated Business rules and metadata
• Applied HFM and FDM software applications patches and enhancements
• Created and maintained consistent and thorough documentation of all processes and procedures for supported applications
• Leveraged skills, experience, and HFM functional knowledge to various business segments to effectively execute change orders
• Served as primary communicator of all functional HFM and FDM changes to key stakeholders and end users
• Provisioned and maintained security in Shared Services
• Designed financial and analytical reports via Financial Reporting Studio
• Supported SmartView users through troubleshooting
• Maintained Sox compliant controls for changes initiated in the application
• Assisted in defining standards, managing risks, and support process governance around financial business intelligence issues and enhancements opportunities
• Monitored system performance, availability and utilization
• Worked with SaraLee internal audit team to execute risk mitigation and compliance activities
• Created and maintained webforms, tasklists, templates, data grids etc.
• Troubleshooted database issues
• Interfaced with domain architects, project team, vendor and development team to scope technical requirements
• Utilized HFM, FRS, FDQM, SmartView, Maestro, MerlinXL, MS VISIO, and MicroSoft Office

Confidential, IL

Financial Systems Manager

Responsibilities:

• Supported financial staff in performing monthly close processes, including extraction and validation of data transfer from/to the SAP, Navision, and Infinium general ledger systems for actuals, forecast and budget reporting thru FDQM or HAL
• Loaded monthly actual and supplemental data via Hyperion Smart View for foreign entities
• Mapped the core general ledger data from source system into the respective accounts in HFM, FDQM, as new entities are formed
• Created new FDM reporting scripts for new acquisitions
• Maintained Hyperion Metadata and business rules and Hyperion Essbase Outlines.
• Developed user training materials and conduct new user training sessions, as needed
• Perform detailed analysis as needed, including gap analysis to develop both high-level and detail business requirements/specification documentation for all application upgrades, enhancements, and add-ons.
• Coordinated with Finance and IT to guarantee accuracy of data feeds and inclusion of all relevant information in population of Hyperion Financial, Hyperion Planning and Reporting modules.
• Created and maintained documentation on processes and procedures related to Hyperion applications and Reporting in conjunction with organizational policies, guidelines, and standards.
• Developed and sustained planning, forecasting, and reporting tools necessary for users to analyze and present relevant financial data to senior management as necessary.
• Set-up and maintained Hyperion Data Entry Forms and related security/calculation settings.
• Wrote, modified, and maintained Essbase Calculation scripts, Essbase Outline member formulas, Essbase Data load rules, Essbase Dimension build rules, and Essbase reporting scripts.
• Wrote, modified, and maintained Hyperion Financial Reports, Hyperion Web Analysis Views, Dashboards, SmartView Reports, and Hyperion Planning smart lists.
• Supported company-wide consolidation and financial reporting application from problem diagnosis and analysis through problem resolution and will analyze and design solutions to ensure that Hyperion system functionality aligns with business processes.
• Organized and leads requirement meetings with business sponsors/users.
• Executed testing of developed solution, ensuring business requirements are implemented accurately.
• Utilized HFM, Hyperion Planning, Essbase, FDM, Navision, SAP, Lawson, Maestro

Confidential, Lincolnshire, IL

District Financial Manager

Responsibilities:

• Managed implementation of Hyperion Enterprise, Analyser, Essbase, and ADP Payroll at Confidential
• Hired, supervised, & trained staff of thirty-three controllers
• Consolidated, reviewed, reconciled and analyzed 33 entities financial statements monthly
• Maintain a documented system of accounting policies and procedures
• Oversight of the accounting office personnel along with all aspects of the general ledger and financial statements
• Partner with the General Manager to manage the financial results of the dealership
• Responsible for adherence to dealership policies and internal control structure
• Proactively manage and safeguard company assets
• Actively manage expense structure and vendors
• Prepare the daily, weekly, and monthly reports.
• Work with the management staff of the dealership to review the data and prepare reports/analysis as necessary
• Designed divisional Hyperion reports for budgeting, forecasting, consolidations, Process Improvements, Cash flow analysis, costs, sales and metrics
• Maintained the consolidated organization, accounts, and reporting structure in Hyperion to ensure proper recording and reporting of financial data
• Led the development, design, and implementation of information applications, upgrades, interfaces, and other enhancements from a functional/technical perspective to meet business requirements.
• Provided support and training to district end-users as required ensuring productive and efficient utilization of the Hyperion application
• Supervised annual audit reviews, audits records and evaluates internal controls
• Supervised audits for Internal controls and to determine accuracy
• Ensure compliance monitoring is in place, including implementing, documenting, and maintaining processes for regulatory reporting, in accordance with Company and regulatory standards
• Developed and implemented audit programs for compliance based on audit findings
• Created budget/forecast for 33 entities & presented findings to management for budget variance analysis
• 3-year financial forecast and explanation of budget variances
• Established policies and procedures to ensure internal controls for all financial transactions
• Utilized Best FAS, CorpTax, Hyperion Enterprise, Hyperion Retrieve, Hyperion Application Link (HAL), ADP Payroll, Automatic Dealer Services, Essbase, Citrix, Reynolds & Reynolds, and Microsoft Office Suite

Confidential, GA

Plant Controller

Responsibilities:

• Hired/Supervised staff of nine professionals
• Prepared perpetual, obsolete, and slow moving inventory reports and supervised physical inventory counts
• Ensured accurate valuation of inventory costs and balance sheet inventory values
• Calculated manufacture ABC cost accounting, job costing & analysis
• Reviewed, reconciled, and correct bills of material including work standards
• Performed monthly financial close variance analysis, cost roll-up and reconciliation’s
• Created and closed job orders on a monthly basis
• Analyzed and reconciled overhead absorption and work order variance
• Monitored budgets, communicated significant variances to department heads for investigated causes
• Maintained the integrity and accuracy of all cost related functions
• Utilized ADP Payroll, Peachtree, CorpTax, PointMan, implementation of SAP, Excel, and Access