Lead Hyperion Consultant Resume

SUMMARY:

Oracle Hyperion architect proficient in the development of Oracle solutions including Planning, Essbase, and Financial Reporting Studio
Seasoned IT development professional with eleven years of professional experience and an MBA
Experienced lead consultant proficient in all phases of system analysis and design, development, business requirements gathering, programming, information technology transfer structures, financial reporting, project management, financial statement analysis, accounting procedures, and budgeting and forecasting

TECHNICAL SKILLS:

Hyperion Essbase (versions 7.1.2 - 11.1.1.3 )

Hyperion Planning (versions 9.2.1 - 11.1.1.3)

Hyperion Financial Reporting Studio

Workforce Planning

Hyperion Pillar

VBA, SQL, XML

Microsoft Project and Project Server

ASP, HTML, Java

Hyperion Smart View

Hyperion Application Link (HAL)

Essbase Integration Services

MaxL, Esscmd

Microsoft SQL Server

Microsoft Access

Microsoft Office

Microsoft Windows

PROFESSIONAL EXPERIENCE:

Confidential

Lead Hyperion Consultant

Responsibilities:

Lead Oracle Hyperion Consultant - Developed all aspects of Oracle Planning and Essbase budgeting, forecasting and reporting solutions
Utilized Financial Reporting Studio, Smart View, and the Essbase Excel Add in to develop custom reporting solutions
Worked closely with customers to understand requirements and translate them into Oracle solutions
Developed Oracle Planning and Workforce Planning applications, web forms, Oracle Reports, utilized HAL and Informatica for data transformations, Essbase databases, calculation scripts, business rules, report scripts, MaxL and EssCmd logic
Conducted extensive data integrity and performance testing to support rollout of new implementations
Created Oracle Planning security models and provisioned users. Monitored production environments to determine performance optimization opportunities

Confidential, Tampa, FL

Project Manager - Hyperion Developer - Administrator

Responsibilities:

Team lead member for all aspects of a Oracle Planning implementation, including requirements gathering, development, testing and troubleshooting
Developed and maintained the firms Oracle Essbase budgeting and forecasting system acting as its lead developer and administrator
Supported, maintained, and monitored the Essbase environment, including multiple monthly updates for reporting
Developed multiple cubes using complex hierarchies for budgeting and reporting needs. Conducted extensive data integrity, stress testing, and performance optimization of the application
Created load rules, dimensions, calculation scripts, and conducted extensive analysis of the ETL process
Created and conducted multiple training sessions for Oracle Essbase
Managed multiple development projects simultaneously that required input from multiple departments with conflicting needs

Confidential, Tampa, FL

Senior Analyst - Programmer

Responsibilities:

Effectively translated business requirements into financial reporting solutions utilizing SQL, Hyperion Reports, Oracle Database Structures, PeopleSoft, Actuate, E Spreadsheet, Toad, Visual Basic, MS Access, Java, and various other tools
Managed development projects for new reporting solutions including Hyperion Financial Management, Hyperion Reports, Hyperion Retrieve and a PeopleSoft upgrade by acting as both the lead developer and a liaison between business users and IT
Added value to new applications and solutions through extensive testing and knowledge of accounting processes. Conducted training sessions for the MS Office suite of products

Confidential, Tampa, FL

Senior Analyst - Programmer

Responsibilities:

Utilized ASP, Java, SQL, Visual Basic, and HTML, to create an Intranet based financial reporting structure for a new Shared Services accounting center
Coordinated development, testing, and delivery of several new corporate reporting packages including a quarterly financial statement analysis tool
Acted as a liaison between the business and IT to ensure that the conversion to SAP from a legacy system would be successful through data and functionality testing
Extensively reviewed processes and procedures in order to determine where improvements could be made
Conducted comprehensive analysis of financial information for senior management

Confidential, Tampa, FL

Senior Analyst

Responsibilities:

Developed and maintained financial reporting packages and tools for leadership utilizing Visual Basic, SQL, and MS Access which took into account a myriad of factors from varying departments and systems
Coordinated development projects that required input from multiple departments with conflicting needs. Maintained firm wide reporting packages for multiple business lines
Managed multiple projects from start to finish simultaneously