SUMMARY:

• An Oracle Hyperion EPM architect and project manager with over 20 years of experience having led or participated in over fifteen Oracle Hyperion related projects such as Planning, Reporting, or Profitability (HPCM). Possess a strong track record of project success and a proven record of unwavering project support
• Core competencies for enterprise performance management technology include core soft and technical skills. I bring a project vision for overall design and architecture of Planning and other information management solutions; a vision for business transformation using cutting - edge technologies; a sound understanding of project evolution from requirements to post go-live management; an understanding of the dynamics of client/consultant relationship, as well as the importance of effective client knowledge transfer. I bring effective mentoring and team-building skills to ensure the health and vitality of projects. Possess technical/functional knowledge and implementation skills to ensure solutions consistently solve client business challenges with an emphasis on business efficiency and transformation.
• Considerable experience with information management competencies such as data architecture, data integrations, business intelligence, KPI dashboards, and general software engineering. Versed in Kimball methodology for data warehouse design, instrumental in providing a consistent methodology to all EPM implementations. Extensive experience in program budget management providing coordination and support for budget formulation/execution processes in biomedical and clinical environments. International working experience in Germany and Southeast Asia.

TECHNICAL SKILLS:

SKILLS: Hyperion Financial Reporting, Interactive Reporting Microsoft SQL Server Analytic Services (SSAS), Pilot Analysis Server Data warehouse architecture, data analysis, data modeling, OLAP modeling, Erwin Dashboards, KPI development, decision support systems, rules - based expert systems, inference engine development Business Analysis, Program Analysis, PMO Program budget management, budget formulation and execution processes Financial analysis, requirements analysis, business process flow analysis Activity Based Cost modeling and cost allocations SDLC requirements, RTM, WBS, schedule, resources, UAT, risk, status updates, documentation, user support EPM Infrastructure Hyperion Planning, Essbase, and HPCM installation, configuration, and administration Oracle and SQL Server database administration Weblogic Server and Oracle Application Server administration Apache and IIS Web Server administration Backend, Data Integrations and ETL FDMEE, Oracle Data Integrator (ODI), Essbase Load Rules and Outline Load Utility Microsoft Integration Services (SSIS) Essbase Calc Scripts, Business Rules, Calculation Manager ASP, ASP.NET, C#, Java, JavaScript, HTML, PL/SQL, T-SQL

PROFESSIONAL EXPERIENCE:

Confidential

Solutions Architect Manager

Responsibilities:

• Overall solutions architect for a comprehensive budget, planning, workforce, grants, document management, and reporting solution at the US Food and Drug Administration (FDA) primarily using Hyperion Planning 11.1.2.4. Modules included employee-level salary projections, budget formulation (OMB Justifications), budget execution, financial reporting, cost allocations, appropriations, and continuing resolutions. Led efforts in requirements and design with weekly client touchpoints per functional module. RTM, design document, process flow diagrams, and client presentations. Responsible for solution implementation, UAT, documentation, . Supported PMO activities.
• Hyperion Planning financial systems senior manager overseeing systems and processes for budgeting, planning, forecasting, staffing, allocations, reporting, analytics, and central corporate financial data management.

Confidential

CONSULTING Manager, Specialist Master, Information Management

Responsibilities:

• United States European Command (EUCOM) - Stuttgart, Germany - architecture, requirements, design, and implementation of a EUCOM-wide decision support solution to assess theater and operational military strategy, partner events and activities that supported strategy, as well as financial, military lessons-learned, theater and operational assessments, and geospatial visuals. Defined and built an analytic framework to support a broad spectrum of business processes and data sources. Framework encompassed dashboards, data warehouse repositories, integrations, OLAP reporting constructs, scorecards, and analysis capabilities utilizing the Microsoft Business Intelligence stack. Utilizing the foundation laid by the Joint Forces Command, the resulting framework enabled senior leadership and staff action officers to monitor progress, and adjust activities, to ensure mission objectives are met.
• United States Mint - planning, requirements, design, implementation, and testing of Hyperion OPEX, Workforce Planning, and Scorecard modules. Designed and built virtualized hardware and software infrastructure, to include installations and configurations. Responsible for the development and delivery of comprehensive SDLC documentation and supporting artifacts: project management plans, kick-off presentations, systems design, security plans, risk management plans, change management plans, configuration management plans, quality assurance management plans, gap analysis, functional requirements, RTM, to-be and as-is business process models, instance strategies, test plans, user manuals, operations manuals, and materials. Provided system testing, user, user documentation, and full systems documentation for Hyperion projects. Performed classroom activities in Denver, West Point, and Washington, DC.
• United States Census - Manager of operations and maintenance activities of a Hyperion Planning enterprise budgeting and reporting solution. Led three-person team for daily operational support of processes and ongoing system enhancements, change requests, bug-fixes, and operations documentation.
• Cigna Healthcare - designed and implemented activity based costing and allocation profitability models using Hyperion Profitability and Cost Management (HPCM). Design for activity based costing and cost center allocations. Integrated process and data flows to and from Hyperion Planning applications. Managed all Hyperion infrastructure processes such as data loads, web service deployments, lifecycle management, security, and migrations.

Confidential

Principal Consultant

Responsibilities:

• Architecture, design, requirements, development of Hyperion Planning, Essbase, and Financial Reporting.
• Documented client business processes, user interfaces, and business rule requirements. Designed and developed Hyperion Planning applications, forms, business rules, reports, and dashboards.
• Supported system testing, user, user documentation, and system documentation.
• Performed migration activities such as security and provisioning; reports, forms, business rules, calc scripts, and load rules migrations. Systems analysis for documentation. Participated with infrastructure team in technical issues surrounding migrations and deployment performance.

Confidential

Associate

Responsibilities:

• Designed and implemented a multidimensional quality performance management system to integrate strategic and operational goals against performance, resulting in business intelligence dashboards using Hyperion tools.
• Designed and implemented a central data repository, ETL interfaces, reports, and supporting design and requirements artifacts to support the DHS state investment justification system. Essbase, Informatica, and .NET.
• Lead data architect of an enterprise case management re-engineering effort, responsible for logical universal data models and data migration strategies. Participated in facilitated requirements workshops with stakeholders.
• Designed logical master data model (MDM) referencing as-is systems and to-be business process and data requirements, as well as a data migration strategy outlining source and target systems and data topologies.
• Analyzed reporting and data requirements to enable product transportation segment to better manage budgets and expenditures. Designed and developed interactive dashboards to help assess KPI metrics.

Confidential

Lead Programmer Analyst

Responsibilities:

• Project lead and knowledge engineer for the architecture, design, and implementation of the next generation of expert system applications, a rules-based expert system generator to support employment laws assistance available to the public. C#, .NET. Analyzed and researched requirements to assess inference engine technologies with client needs, resulting in UML and use-case artifacts. Designed architectural iterations to meet changing client requirements. System and data architect roles providing technical and project leadership in the areas of expert systems, rules-based development, and web-based application development.

Confidential

Chief Programmer Analyst

Responsibilities:

• Project lead in the reengineering of ad-hoc reporting modules for a financial performance and monitoring system. Managed on-going maintenance and new requirements, to include project planning, testing, documentation, and status. Analyzed requirements to determine feasibility. Documented data schemas and process flows.

Confidential

Project Lead, Programmer Analyst

Responsibilities:

• Expert systems and custom application development for federal clients (DOL, SBA, EOP). Confidential was acquired by Confidential .

Confidential

Systems Engineer, Financial Systems Analyst

Responsibilities:

• Designed/developed financial, statistical, and HR budgeting decision support and reporting systems to support management analysis of Confidential t and protocol activity, budgets, and financial transactions.

Confidential

Program Budget Coordinator

Responsibilities:

• Program budget management for federally-funded non-profit organization. Applix TM1 (TM/1) power user. Coordinated allocation of HIV program budget funding: audited financial reports, prepared journal vouchers, re-budgets, encumbrance adjustments, cost allocations, budget variance analyses, budget reconciliations, discretionary fund usage, and indirect cost analysis. Analyzed personnel, program, and indirect costs to formulate/modify budgets. Prepared presentations of program obligations, funding, and protocol status. Developed technical infrastructure and applications to support budget formulation and execution.