PROFILE:

Information Technology driven Project Manager with over 15 years of a mix in accounting and finance. Installation, training, administration, and analysis of ERP packges. Financial Report creation, advanced excel, MS Projects, SharePoint, Visio. Liaison between finance, IT and outside Vendors/CPA’s. System design and security with segregation of responsibilities for compliance and audit controls.

TECHNOLOGY:

Oracle Hyperion, HFM, FDM, Hyperion Planning, Hyperion Essbase, JDEdwards, Microsoft Business Intelligence Great Plains, PeopleSoft, SAP, Cognos, SharePoint, Visio, MS Projects, Microsoft Suite including Advanced excel

EXPERIENCE:

Project Manager

Confidential, Langhorne, PA

Responsibilities:

• Create project plan using PMBOK methologies to install new vending software and inventory program system wide with QuickBooks, HR and PR. SQL serve, network 4 desktop computers,create COA, financial reports, monthly reporting, trend analysis, forecasting and budgets, dashboards, metrics, cost transparency.
• Work with NJ and PA tax offices, review and negotiate contracts.

Project Manager

Confidential, Philadelphia, PA

Responsibilities:

• Maintain Project plan for conversion to JD Edwards 9.1.
• Use MS Projects to design milestones and goals.
• Interface with outside IT consultants and internal SME’s to identify project backlog, reorganize plan, align budget, create new milestones and enforce plan.
• Weekly meetings presenting Scorecard and adjusting plan where necessary.
• Correct mapping, document business requirements, reconcile legacy to Financials, accounting close processes, training, and other hands - on duties to complete project plan.
• Upload all documents to SharePoint and work with outside auditors.
• Creating financial package for Management report to Corporate.

Hyperion Analyst

Confidential, Radnor, PA

Responsibilities:

• Provide expert knowledge of HFM, FDM and GL during migration to Hyperion 11.2.
• BS, IS, mapping verification, providing feedback and suggested fix to Business Rules and GL conversion.

Sr. Financial Systems Analyst

Confidential, Philadelphia, PA

Responsibilities:

• Financial Systems lead/Project Manager for BI platform managing metadata for various entities, Confidential ’s, and accounts.
• Manage 3rd Party Consultants and developers in the US and India for system improvements
• Manage multiple projects, preparing weekly status reports and working directly with SME’s to deliver finalized product to stakeholders by working off hours when necessary.
• Managed BI systems ETL from HFM (Oracle workspace 11.1), Essbase, Great Plains and multiple Sales modules for Financial Reporting creating pivot tables in the cube

Sr. Consultant

Confidential, Philadelphia, PA

Responsibilities:

• Assisted in the project management to include implementing, forecasting, budgeting and operational reporting solutions utilizing a variety of current Hyperion/Oracle products to add value to client
• Liaison with IT, accounting and project teams
• Train client’s end users in Oracle’s Hyperion HFM, FDM and Consolidations
• Provided expertise in HFM, FDQM for consolidation efforts and planning.

Testing/Project Manager

Confidential, Pittsburgh, PA

Responsibilities:

• Assisted in the replacement of SAP ECC 6.0 with the implementation of a utilities-based ERP system Microsoft Dynamics GP creating test plans, UAT, scripts, business processes, SharePoint, Visio, uPerform.
• Led training on WEB Procurement, creating financial reports; BS, IS, Cash Flows, Analytics in Reporting Manager, SmartList, SmartList Builder.
• Created employee roles and security access to modules and field Level Security, implementing a scanning software solution for three way matching.

Lead Business Systems Analyst/Project Management

Confidential, Herndon, VA

Responsibilities:

• Assisted in the migration from Oracle Hyperion (Essbase) to Great Plains with SQL Server 2008; created new custom dimensions, system changes to include chart of accounts and logic.
• Created custom financial reports utilizing built-in GP reporting and 3rd party BI360 reporting tool, smart connect, SmartList Builder, SharePoint, Visio, utilizing SQL, and VB.net. Conducted UAT in group environment and over the WEB

Financial/Hyperion Analyst

Confidential, Plainsboro, NJ

Responsibilities:

• HFM, FDM, Metadata; correct mapping issues between Cognos and Hyperion for 60 entities
• Created new entities in FDM, utilized WorkSpace, SharePoint, reconciliations of Income Statement & Balance Sheet and Intercompany, SmartView ad-hoc reporting and analysis.
• Developed reports in Financial Reporting Studio, FX rates, review/test rules and calc scripts for Budget and Forecast.

Project Manager

Confidential, Exton, PA

Responsibilities:

• Charged with all program management and integration activities.
• Managing the UAT for multiple offices in the US. MS Projects, SharePoint, Visio
• Actively managed the work efforts of multiple functional resources through the project plan.
• Initiated and maintained reporting relationships with project stakeholders including team members, peers, managers, customers, vendors, and other affected departments to coordinate efforts across multiple business units and ensure continuous efficient management of projects; gather input and feedback and developed SOP and screen shot documentation
• Analyzed and reported project status and research information; monitor project performance to maintain the quality of services, deliverables, and content.
• Effectively assisted in directing both internal and external resources to achieve business solutions within project guidelines.
• Responded to operational issues and RFI’s within defined areas of responsibility while progressing on project

Manager of Assets and Overheads

Confidential, Willow Grove, PA

Responsibilities:

• Responsibilities included review and disbursement of P&L between regions and calculation of overheads for bidding purposes.
• Assist in choosing an ERP provider, financial reporting, gathering audit information and providing timely sales and cost reports to 100+ regions.
• Built Excel based financial models to evaluate cash flow feasibility and profitability, new bid proposals and support business plans for acquiring new businesses
• Built Excel and Access based db to file Business Personal Property Taxes returns in conjunction with Lawson system

Hyperion Administrator

Confidential, Philadelphia, PA

Responsibilities:

• Responsible for global consolidations and maintained Hyperion 9.3.1 Financial Reporting package including security changes and user support/training
• Set up automated task flows for global consolidations in HFM and Hyperion Planning 3-5-7-10yr plans, support calculation on stock issuance
• HAL load, data warehousing, add new entities in Workspace, maintain Intranet via SharePoint, create tax structures, and accounts
• Designed dynamic reports in Financial Reporting Studio, FLUX analysis, Flash, PII
• Customized Hyperion P&L’s for divisions, install and train Smart View ad-hoc reporting, HFM entries to P&L and BS, and Planning progression