Data Architect / BI & EPM Specialist
Resume:
ROBERT MARCUS HENDERSON
Atlanta, GA 770-***-**** ac0os9@r.postjobfree.com
Professional Summary
Mr. Henderson is a Director level IT/IS professional with over 17 years of experience in the Information Technology field. His positions have ranged from Director of EPM/BI Systems, Consultant/Architect, Project Manager, Data Analyst to Controller and IT Director. These positions have been in a variety of industries including Financial Services, Retail, Manufacturing, Telecommunications, Professional Services, and Entertainment.
Professional Experience
Recent assignments and roles include an emphasis on Strategic Architecture and Delivery of EPM and BI Solutions for Enterprise Wide Budgeting/Forecasting, Data Consolidation, Business Intelligence, and Data Analytics solutions. Performed significant roles in over 30 Full Life Cycle implementations.
Carter’s Corporation, Atlanta, GA
January 2015 – Present (consultant 1st year)
IT Director - Financial Systems//BI Practice Director Responsible for technology for multiple Domestic and International Planning and Consolidation Applications utilizing EPM and BI solutions. Rebuild initiatives for Hyperion Systems for Chart of Accounts rewrite coordinating with SAP G/L. Unified Master Data across enterprise systems. Started Center of Excellence framework with ERP/EPM/Reporting level. Created strategies and integrations with all levels of IT organization. Lead multiple IT initiatives including DR, Change Control, and efficiency/audit. Initial integration, design, and pre-build of Oracle PBCS including FCCS. Worked with Retail Assortment Planning project utilizing Anaplan.
Enhance Net Solutions Corporation, Owner
Client: Vanguard Financial Services, Valley Forge, PA Sep 2012 – 2014
Major system rebuild project of multiple Planning applications. Provided analysis and designed procedures for a Hyperion Planning 11.1.2 to 11.1.2.3. Upgraded Planning tools include Planning Forms, rules, and PeopleSoft integration using ODI for ETL. Modified and migrated over 25 business rules/calc scripts to Calc Manager. Built ASO cubes using existing BSO cubes to enhance usability and consolidations. Resolved multiple SmartView, business rule, and system settings to increase efficiencies of overnight and on-demand calculations. Enhanced existing International Planning including currency calculations utilizing 8 international locations. Roles
Director Finc.Planning System
EPM / Hyperion Architect
EPM Practice Director
Project Manager
Consultant Company Owner
Hyperion Developer
Software Tech. Sales Lead
Business Intelligence Lead
Data Analyst
IT Manager / Director
Controller
Technology
Oracle EPM 11.1.2.x
Oracle PBCS
Essbase
Hyperion Planning
Workforce Planning
CAPEX
Hyperion Financial Mgmt
Hyperion Finc. Reporting
Strategic Finance
Hyperion FDM/FDMEE
Anaplan
OBIEE
SQL
Oracle MDM
Informatica/Control-M
Neteeza/MicroStrategy
Application Packages
Oracle EPM
Oracle EBS
PeopleSoft Financials
JD Edwards (JDE)
SAP
Programming Languages
Programming languages:
SQL
Jython
Maxl
Hyperion BR
R. Marcus Henderson
Threshold Consulting
November 2007 - 2012
EPM Practice Director / Hyperion Architect / Developer / Managing Consultant Responsible for leading multiple Hyperion Essbase, Planning, Financial Management (HFM), Financial Reporting, and OBI/BI Dashboard initiatives. Designed, built, tested, and implemented Long Range Planning and Forecasting Applications using Hyperion Planning System 9 and v11. Responsible for designing and building ETL solutions including Hyperion Financial Data Management (FDM), Oracle Data Integrator (ODI), and Informatica.
Client: Mercedes-Benz US, Inc., Tuscaloosa, AL
June 2012 – August 2012
Led internal Mercedes - Functional and Technical Project Teams. Performed architect, manager, and developer roles for a full Essbase v7 upgrade to System 11_2_1 Planning and Financial Reporting. Designed and implemented multiple Business Rule and Load Rules for consolidation and loading of Headcount and Hours from underlying Peoplesoft data files. Designed versioning procedures and custom calculations for backups of Essbase cubes. Installed, designed, and built automated/robust ETL solution extracting data from SAP financial source system using FDM/FDQM. Lead formal and informal training for all system users
(including Controllers) for both Planning Web Forms and Financial Reports. Performed design and implementation for the entire EPM infrastructure solution including Web/Application server cluster and all supported Hyperion Planning Plus suite of applications including Planning/Essbase/Foundation Services. Client Outback Steakhouse, Inc, Tampa, FL
Oct 2011 – May 2012
• Led 2 person consultant team. Performed role as Architect and Project Manager OBIEE project application upgrade from version 4.2 to 11.1.2. Built requirements for entire OBIEE reporting solution. Provided detailed ETL designs and interfaced with Business Users, DBA’s and Data Warehouse team. Designed and built OBIEE repository. Designed and built Answers dashboards and Publisher reporting solutions. Enhanced existing Essbase applications to streamline processes and calculations. Designed and developed new reporting Essbase cube used to report Outback Consolidated Management P&L results. Client: PHH Mortgage Services, New Jersey
Sep 2009 – Oct 2011
• Architect and Project Manager for HFM full application upgrade from version 4.2 to 11.1.2. Responsible for implementing solution with fully rewritten consolidation application with new COA including IS, BS, Cash Flow, and Metrics. Produced 50+ management and SEC filed reports. Integrated HFM data with OBIEE dashboards. Supported over 75 users for Hyperion and OBIEE access. Performed multiple training sessions for reporting tools including SmartView and Financial Reporting. Managed and developed ETL solution using ODI as enterprise wide to bring AS/400 data into HFM.
R. Marcus Henderson
• Led 3 person team. Gathered requirements and designed OBIEE solution for one of the largest Mortgage underwriters in US. Built Reporting solutions using integrated Essbase applications and OBIEE dashboards. Client: Allscripts, Atlanta, GA (formerly Eclipsys) 2008-2009
• Managed year long full life cycle implementation of Hyperion Planning/Essbase system 11. Designed and implemented 40+ Forecasting and Variance Reports for major $700 million plus Medical Software Company. Ultimate solutions deployed enterprise-wide using ODI as ETL solution. Independent Hyperion Consultant
Owner, Enhance Net Solutions
November 2007 – October 2008
Experience Overview
• Built and deployed Essbase Solution for Property Rental Corporation. Developed automated data integration solutions using Maxl/SQL.
• Configured and Deployed Planning Applications and Rules via EPMA v11 tool.
• Built and deployed IR Dashboard solutions using the Planning Web Analysis Tool for various clients
• Conducted pre-sales technical sessions including demo’s of Hyperion Planning, Essbase, and Financial Reporting. Created client services proposals for distribution to prospective clients.
• Led Full Project Implementations including leading multiple Requirements and Design Sessions with client and teams. Led 1-5 FTE teams during implementations.
• Analyzed intercompany and consolidation calculations for HFM and increased calculation performance by over 20%.
• Assessed changes needed to current state Financial Reports and implemented updates post upgrade of HFM and Planning/Essbase
• Worked with Infrastructure team to upgrade multiple HFM and Planning/Essbase applications and underlying Database infrastructure Client: US-Analytics May 2007 – October 2007
Senior Hyperion Consultant
Sub-Clients: Match.com Dallas, TX; Dell Corp; Noble Drilling Responsible for Business Intelligence initiatives. Designed, built, tested, and implemented Long Range Planning and Forecasting Applications using Hyperion Planning. Created International Applications with multiple delivery methods and currency designs.
R. Marcus Henderson
Client: North Highland Company January 2006 – May 2007 Business Process Management – Budgeting & Financial Reporting Hyperion Solutions Expert
Sub-Clients: EarthLink; BellSouth; SunTrust; Turner Broadcasting; Cox Enterprises Hyperion Lead Developer roles, including delivery of Hyperion projects, managing resources, ETL, and Reporting. Leveraged Multiple data sources including PeopleSoft, SAP, and JD Edwards.
Client: IBM Consulting April 2004 – November 2004
Hyperion Financial Management Consultant
• Responsible for oversight, management, and review of design and implementation of Hyperion Financial Management (HFM) application and I.T. integration.
• Determined system logic and structure needed to create a balanced/valid Balance Sheet, Income Statement, and Cash Flow Statement for the Corporate Consolidation Group.
• Created consolidation logic via HFM rules to consolidate multiple business units to corporate level
• Adjusted rules based on updated requirements from client. Reconciled data errors.
• Designed and built HFM application structure, logic, and Excel Add-in reporting. Assisted in conforming client accounting and financial systems to Sarbanes- Oxley Act requirements.
• Utilized and configured Hyperion FDM (Upstream) data translation software for actual data integration data.
• Utilized SiteMinder software to build security logic to work with Microsoft LDAP.
• Created System disaster recovery plan and Windows security plan. New Era Investments December 2003 – April 2004
Controller / IT Manager
• Monthly closing of all accounting data and posting to banks.
• Created parent company roll-up and asset allocation reports for use during litigation.
• Designed backup schedule for all accounting and business information. Managed firm’s IT network and all resources. Created system to share financial data between G/L system and reporting system.
• Responsible for day-to-day all accounting, human resources, and IT activities for Real Estate/ Development Company.
• Designed financial reports used by outside Tax and Accounting Firms. Performed financial analysis of all company assets and liabilities. Provided schedules used in legal proceedings.
• Assisted company partners in dissolving all Long-term assets. Provided pro- forma analysis of potential asset sales.
• Managed all day-to-day activities (financial and logistical) of 200+ room
“Extended Stay” Hotel.
R. Marcus Henderson
Mirant Corporation / Southern Company / GA Power October 1992 - Oct 2003 Financial Systems Developer/ Senior Financial Analyst Hyperion Financial Management / Hyperion Planning/ Hyperion Essbase
• Lead developer/designer for corporate-wide relational financial consolidation tool
(Hyperion Financial Manager – HFM 3.x) implementation at billion $ energy trading company. Part of all phases of implementation starting with design meetings (POC) through Live Application. Migrated existing consolidated accounting system data to HFM tool.
• Designed, built, and implemented HFM calculation logic modules using HFM rules. Created reports to and adjusted rules to reconcile data errors.
• Designed, created, and supported over 100 Hyperion Planning Web Forms. Completed business structure and financial logic used to produce SEC financial statements for over 40 North America business units totaling over $1 Billion in revenues.
• Managed team of employees in order to create several accounting data interface programs. Supported over 40 users as system administrator for Hyperion Planning, Reports, Hyperion Financial Management, and Hyperion Enterprise applications.
• Headed financial and accounting analysis of major long-term power agreements with outside corporations.
• Elected member of 1999 Southern Company Leadership Program, inclusive of only 30 employees labeled potential leaders by executive management. Monthly and ad-hoc presentations made to various executive groups including Marketing and Finance Vice Presidents.
Education
Master of Science (2000)
Management of Information Systems/Finance
Georgia State University - Atlanta, Georgia
Bachelor of Science (1991)
Economics
Berry College - Rome, Georgia
Contact this candidate