PROFILE:

• MBA Graduate - Finance
• Hyperion Essbase Certified Professional
• IT, FPA, Management and Consulting experience

AREAS OF EXPERTISE:

Hyperion Essbase, Planning, Shared Services, Workspace, Smart View: Strong experience with the design, build, implementation, optimization, automated processing, administration & training of all products. Calculation, report scripts, partitions, load rules, web forms, business rules, Esscmd, MaxL. Unix & Windows environments. ETL processes, backup/recovery. Versions 6 - 11.2. Over one year with Confidential consulting experience

End User Support and Training: Daily interaction with customers helping resolve issues with Hyperion, Excel, VBA and other systems. Lead in person training sessions monthly and also created training documents and videos that were updated with each new version of Hyperion.

Financial Analysis: Trend and KPI identification and efficiency analysis. Operational, statistical and fiscal reporting with variance explanation. Report design,packaging and presentation to management.

Project Management: Technical and business experience in full life cycle projects. Interaction and presentation to all levels of management. Identifying key objectives, scope, risks, drivers, and fostering cooperation between departments to enable success.

Technical Experience: Hyperion Business Intelligence Product Suite, Data Management, OBIEE, HSF, DRM, Business Objects, SQL, MS Office, SQL Server, VBA

EXPERIENCE:

Confidential

Solutions Consultant

Responsibilities:

• Responsible for building and managing demo environments used for NetSuite and Confidential environments.
• Working with Data Management to integrate NetSuite and other source systems with Confidential .
• Roles include writing/designing Business Rules, Web Forms, Cards, Infolets, Dashboards, etc.
• Additionally, maintaining LCM (Life Cycle Management) for several environments, End User Training and other cloud based technology.

Confidential

Hyperion Group Manager

Responsibilities:

• Responsible for managing the Hyperion Group, 2-3 direct and 2 dotted line employees.
• Day to day activities, creating and executing the environment’s long-term vision and aligning Hyperion with Confidential ’s IT and FPA road map that supported Budgeting, Planning and Forecasting at a Corporate and BU level.
• Managing and participating in all day to day Hyperion administration activities.
• This includes developing technical solutions/guidance, troubleshooting issues, process management, detailing future vision and customer support including creating organizational reporting. Lead role in all new design or optimization of the Hyperion environment and projects that encompass several system environments.
• Additional lead roles include environment long range planning, future product testing, training, product upgrades, license requirements and communication to management.
• Corporate Planning/Actuals, BU operational & KPI DB’s and other data sets. Environment: 11.1.2, Planning, Essbase, ODI, DRM, HSF, Workspace, WA & FR web reports.

Lead Hyperion Administrator

Confidential

Responsibilities:

• involved in managing, optimizing and troubleshooting day to day activities, end user support, primary focus on new design and optimization of the current environment.
• Acted as liaison between the Hyperion and IT groups to translate and identify issues for processes where both areas are connected.
• Responsible for long range planning for the Hyperion environment and its potential impact to help better leverage the available tool sets across the Confidential Hyperion user community.

IT- Independent Consultant

Confidential

Responsibilities:

• Lead position in Hyperion Essbase database implementation. Full Life Cycle engagement.
• Fact finding/requirements gathering to the design, build and rollout of the database with end user training.
• Lead meetings with primary business groups to gathering data requirements and present technical specifications to Confidential for sign off. Helped create automated ETL processes, designed and built database and objects, lead UAT, follow-up optimization, rollout, report creation and end user training.

Confidential

Hyperion Systems Analyst

Responsibilities:

• Developed and maintained FPA’s databases, web pages, web based & custom reports, budgeting and forecasting applications.
• Primary role was to provide systems development, administration and end user support to the Finance and Marketing departments principally through Essbase databases.
• This encompassed developing/updating/tuning Essbase databases, automated batch scripting, database administration, security, ensuring data integrity and creating/updating VBA reporting applications.
• Position included project management, translating business users requirements into technical specifications, accessing numerous data sources (e.g. Teradata, DB2) to write SQL queries for data extraction.
• Also, conducted training sessions and created end user documents.

Application Associate

Confidential

Responsibilities:

• Position focused on enhancing or optimizing existing databases, ad hoc interdepartmental projects and automating processes.
• Position also included the rotating 24 hour support of existing databases and servers.
• Numerous ad hoc projects include server optimization, Essbase server installation/version upgrade, batch automation scripts using Perl/MaxL and leading application design lifecycles or projects as assigned by management.
• Other areas include Crystal Reports, Teradata and MicroStrategy assignments.

Confidential

Strategic Planning - External Consultant

Responsibilities:

• Member of an executive team that analyzed areas of the company as directed by the Chief Finance Officer of WFB Retail.
• Analysis included working with internal departments to identify metrics and measures to properly evaluate performance.
• Each analysis usually resulted in a project to be implemented, sometimes by our team.
• Example projects include designing and creating databases to house financial or customer data, share presentations and recommendations to executives.
• Confidential Retail Consistency Project Team that planned, developed, tested and implemented a companywide reporting system that consolidated WFB’s many sourced Retail data into one Essbase server application.
• Created and presented special project top-level BS, IS, FTE and modeling analysis reports to upper management and committees.
• Translated business requirements into technical specifications. Involved in several other special projects involving both systems and financial expertise.
• For example, asset and deposit yield validation, statistical analysis of performance metrics, and performance measures that were adopted company wide.

Confidential

Sr. Staff Consultant

Responsibilities:

• Developed, designed, and implemented Hyperion Essbase and its related products (Analyzer, Reports) at client sites.
• Involved with high level planning and design of client’s IT structure.
• Prepared testing and procedural plans, documentation and mapping.
• Configured and extracted data for existing and future configurations.
• Involved in the creation of all Essbase components; outlines, calculation scripts, Esscmd scripts, data load rules, server & client installation, data & index cache and other optimization tasks.
• Created custom reports, input templates and data transfer applications.
• Tested applications to ensure the built application, data conversions and interfaces supported the business processes as designed.
• Transferred knowledge about the built application to end-users during and after implementation.
• Communicated effectively with client and Hyperion engagement manager. Numerous upgrade, migration and optimization assignments.