SUMMARY:

Senior IT professional with more than 14 years experience in technology filed and 13 years in Hyperion Essbase and Planning reporting applications, including but not limited to Sales Analysis, Financial Reporting, Budgeting and Forecasting, Inventory and Logistics. Extensive experience in applying various Oracle/Hyperion technologies in broad business applications.

EXPERTISE AREA:

• System Development
• Acceptance Testing
• System Launch
• Solution Design
• User Acceptance
• Project Planning
• Functional Design
• Systems Analysis
• Consultation

TECHNICAL SKILLS:

• Hyperion Essbase (11, 9, 7 and 5), Essbase Calc Script, Rules File, Report Script, Hyperion EAS, Hyperion EIS, MAXL, ESSCMD, Hyperion HFM, Hyperion Planning, Hyperion FDM, Hyperion Financial Reporting, Hyperion Web Analysis and Hyperion Essbase Excel VBA, Cubus Outperform
• SQL Server 2005 and 2008 Business Intelligence Suite, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)
• Oracle (PL/SQL), SQL Server 2000, 2005 and 2008 (TSQL) and Informix (4GL)
• Unix (Solaris, SCO Certified) Ksh shell scripting and Awk, Windows (95, 98, NT, 2000), DOS and Macintosh and Windows Batch scripting
• Clarity System, Salesforce, HTML, ASP (VB script) and MS Office

PROFESSIONAL EXPERIENCE:

Confidential, Bay Area CA

Hyperion Consultant

Responsibilities:

• Work closely with finance planning and analysis team to build PNL, Workforce and Capex planning models
• Design and develop Functional System Design Document
• Support daily system process in dev, staging and production environment
• Gather business requirement from management and end - users
• Interact with business clients and discuss upcoming changes and existing issues
• Create, modify and support financial reports
• Hyperion Planning (11 fusion) Design and Development
• Hyperion Planning Web Forms
• Hyperion Planning Business Rules
• Hyperion Planning Metadata Update
• LCM migration
• Hyperion Shared Services
• FDM support
• SmartView
• Essbase BSO cube maintenance, performance analysis and performance tuning
• Unix Ksh and AWK scripting on Linux Server

Confidential, New York, NY

Hyperion Applications Administrator/Developer

Responsibilities:

• Work closely with finance planning and analysis team to build annual financial and operational forecasting, budgeting and operating process
• Support monthly systems close, budgets and consolidations
• Gather business requirement from management and end-users
• Interact with business clients and discuss upcoming changes and existing issues
• Create, modify and support financial reports
• Design and develop all aspects of the Essbase cube
• Essbase BSO Database Outline
• Dimension and Data loading Rule files
• Essbase BSO Calc scripts
• Essbase BSO Report scripts
• MAXL scripts
• Essbase BSO cube maintenance, performance analysis and performance tuning
• Automate Essbase process using both Unix Ksh and AWK scripting and Windows batch scripting
• Develop Excel interface with Essbase for customize and ad-hoc reporting using VBA and Essbase API.
• Support all aspects of Cubus Outperform (Hyperion Planning Competitive Tool)
• Outperform Template and Spreadsheet design
• Outperform Server and Client Administration
• Hyperion Shared Services
• Essbase Calc scripts
• IBM/Cognos Executive Viewer

Confidential, PA

IT/Essbase Analyst

Responsibilities:

• Work closely with management and end-users to gather business requirement
• Interact with business clients and discuss upcoming changes and existing issues
• Support monthly systems close, budgets and consolidations
• Provide support for user support, security and other ad hoc requests.
• Create, modify and support financial reports
• Design and develop all aspects of the Essbase cube
• Essbase ASO Database Outline
• Dimension and Data loading Rule files
• Essbase BSO Calc scripts
• Essbase Report scripts
• MAXL and ESSCMD scripts
• Essbase cube maintenance, performance analysis and performance tuning
• Develop Hyperion Essbase Integration Services (EIS) models and metaoutlines
• Develop SQL Server PL/SQL procedures and database management
• Develop reports using SQL Server Business Intelligence Suite - SSIS, SSAS and SSRS
• Automate Essbase process using both Unix Ksh and AWK scripting and Windows batch scripting
• Support Hyperion HFM, Planning and FDM daily and monthly process
• Develop and support reports using Hyperion Financial Reporting
• Develop Excel interface with Essbase for customize and ad-hoc reporting using VBA and Essbase API.
• Support Clarity System and Salesforce system

Confidential, Atlanta, GA

IT/Essbase Analyst

Responsibilities:

• Hyperion Essbase BSO development and production support
• Hyperion EIS development and production support
• Hyperion Excel Essbase add-in
• Shell scripting on Solaris environment
• Oracle query, procedure, SQL and PL/SQL
• Tivoli TWS job scheduler
• OLAP process (Aphablox)
• Hyperion Essbase Training
• TeraData Training

Confidential, Atlanta, GA

Database Programmer

Responsibilities:

• Informix database manipulation (SQL, 4ge, shell) on Unix and Linux
• Use Informix i4gl and isql to process data
• Write data loading, deduping and report program in 4gl language
• Write data loading, databack program in Shell scripts
• Set up automatic cron jobs to send emails with attachment of daily databack files and write 4ge and shell program to generate those files
• Database system backup and check
• 4GL training and certified by Informix Atlanta
• SCO Unix System Administration training and certified