Murray Energy
Mining, Exploration, and Energy Client
Ohio, USA, Coal and Natural Gas
SAP BPC/ Business Objects Corporate Lead Architect
Sept 2009- March 2010
Budget Planning and Consolidation SAP BPC 7.0 SP04
* Lead Architect, Blueprinting, Assessment, training, and deployment for 60 business units in the
mining, exploration, and coal extraction.
* Focused on Financial Reporting, Consolidation and Financial Planning.
* Sales and Operational Planning (SOP) and using SAP CRM extractors using trade promotion
management (TPM) , Bdocs, and SAP BW Adapter.
* Complete migration of financial reporting using Business Objects and SAP BPC from legacy
environment with reports such as: Shareholder's Equity, Cash Flows, Income Statements, Balance
Sheet, Intercompany, Budgets, Statistical Key Figure reporting, Statement of Operations with
monthly, variance, and YTD values, Sales and Cost Planning by G/L Account, Profit and Cost
Centers, and others.
* Transformation, Conversion and Loading files, and G/L Account conversion and migration.
* Financial and Operational Planning, which includes CAPEX, OPEX, Revenue Planning, and Cost Center
Planning.
* Development of input schedules, templates, DTS packages, upload and download programs, scripts,
EVDRE Reports and Dynamic templates, Application Sets, property and member maintenance.
* IFRS/US GAAP dual reporting formats and migration of chart of accounts, and reports. Working on
US GAAP Joint Venture reporting and IFRS modifications for revenue recognition, capitalization of
intangible assets, inventory valuation, and service contracts based on percentage of completion
basis.
* Transition from a multiGAAP to a IFRS as secondary reporting applying adjustments to the base
data automatically to allow the dual reporting and changes stored in the same application set.
* Development of SAP BI Cubes, Transformation, Loading, Financial and Operational transactional
data extraction.
* Development of Business Objects Universes, Xcelsius Dashboards, and Web Intelligence Reports.
Queries and architecture design from SAP BI Cubes and BEx reports, Slice and Dice, Cross-Tab and
Tabular Views, Tree Control, Data Provider Viewer, Hierarchies, Attributes, Universe Designer,
Web Intelligence Reports with Time Dependencies, Single Sign On, reports and subreports in
Crystal.
* Security, teams, roles, user ids, SAP BPC Web, BPC Excel, Word and PowerPoint interfaces.
* Design and Accessing BOBJ Universes from BI, Xcelsius, Query as a Web Service, Crystal Reports,
Web Intelligence.