Hyperion Administrator

KENNETH L. DAZEY

***.*****@*****.*** www.linkedin.com/in/ken-dazey-mibs 336-***-**** Winston-Salem NC Area

IT SYSTEMS MANAGEMENT

Accomplished System Administrator for Oracle Hyperion Middleware including Planning, Essbase and Reporting. Proficient Administrator for SAP Business Objects and Crystal Reporting. Skillful Administrator of Informatica Platform. Emphasis on process improvement, automation and scheduling. Proven capacity to drive projects to completion, coordinating with several departments to achieve goals and specifications. Fluent in Spanish and speak conversational Japanese.

SOFTWARE APPLICATION

Oracle Hyperion Essbase

MS Office

DB2/AS400

Oracle Hyperion Planning

SAP Business Objects

IBM Client Access

Oracle Hyperion Reporting

Crystal Reporting

Brio Query

Essbase Studio

SQL

ShowCase Strategy

Oracle Data Integrator

VBA

Visio

Informatica

PROFESSIONAL EXPERIENCE

LINCOLN FINANCIAL GROUP, Greensboro, NC 2008 – Present

Analyst, Application Development

Lead Administrator instrumental in automating the building, loading and back-up operations for the Hyperion applications at Lincoln Financial. Lead who administers the complete Hyperion environment for DEV, UAT and Production, including maintenance, patching and system upgrades. Sub – Administrator in charge of report migration, troubleshooting and maintaining Business Objects Enterprise environments including WEBI and Crystal Reports. Sub - Administrator accountable for Informatica Operational and Administrative functions.

Upgraded Hyperion 9.3.1 to 11.1.2.3 and then to 11.1.2.4 assuring that systems remained current and that hardware was in compliance resulting in reduction of outside consulting fees - saved $50,000 to $100,000. Consolidated systems into an integrated system and upgraded to a new process that was a more direct LCN process leading to more direct SDLC management, better process control and improved program development tracking.

Upgraded existing Hyperion 7 systems and applications to Hyperion 9.3.1 for 3 environments. Facilitated automation of data loads and builds and back-ups for Hyperion applications which automated the process, simplifying scheduling without monitoring, creating failure notifications and restorations through back-ups.

As part of a team, maintain Corporate Reporting Systems and deployments for Business Objects, and Actuate spreading out coverage through the addition of team members creating additional time that staff could assist users.

Maintain Informatica Systems and deployments, as a team member, through on call rotation and the creation of an administrative process.

SEALY, Trinity, NC 2007 – 2008

Sr. Analyst Applications

In a Lead role, planned and implemented the upgrade of the Hyperion environment from System 7 to System 9.3.1 on three environments. In charge of coordinating operations between several other groups within the organization to set up the resources needed for storage, server usage and databases for the initial upgrade. Coordinated testing among many Business and IT groups for migrated applications. Lead Developer in charge of automating build, load and backup operations for all existing and new applications.

Upgraded existing Hyperion 7 systems and applications to Hyperion 9.3.1 for 3 environments.

Trained personnel in utilizing new client tools (Essbase, Smart View, Excel, Microsoft Office Tools) for accessing the new features of the Hyperion applications.

Automated load and build process for Hyperion applications scheduling notifications and back-ups for restorations.

PREVIOUS RELEVANT EXPERIENCE

HANES BRANDS INC., Winston-Salem, NC 1997-2007

Sr. Analyst Applications

Lead Developer for the Intimates Department for the Hyperion Applications. As Lead, gathered requirements for new applications and changes to existing applications. Coordinated training for multiple user groups including Sales, Marketing, Finance and IT groups, training them in the use, maintenance and enhancement of Hyperion applications and reporting. In charge of automating build, load and back-up process and code for all Hyperion applications for the Intimate Department.

9 years leading, developing, implementing and supporting BI Solutions using Hyperion Essbase.

Designed and implemented database outline builds and data loads using MSDOS batch, Esscmd, Maxl and VB Scripting.

Supported 15 POS (Point of Sale), 3 Flash (Daily Sales and Orders), 2 Weekly Shipment, 4 Financial Sales, 1 MAPS (Marketing and Promotional Spending), 1 Inventory cube on 3 different platforms.

Managed the Hyperion Software upgrades for 25 Windows Servers, including five 64bit Itanium servers.

Implemented and supported Hyperion System 9.3.0.1 on 3 Environments.

Developed and implemented Informatica ETL extracts from AS400 to text files for loading into Essbase.

Evaluated, documented, designed, and implemented interfaces and reports using Analyzer, Analyzer for the Web, ShowCase Query & Report Writer, and Excel with VBA.

Designed training materials and instructed users on the use of ShowCase Strategy Tools including Analyzer.

Lead Knowledge Expert for Data Warehouse on AS400/DB2 platform.

HANES BRANDS INC. (FORMALLY BALI CO.), Merida, MX 1993-1997

Administrative Manager/Controller

Oversaw the Financial Operations of a Sewing Facility for Intimate Apparel. Directed Accounting, Purchasing, Payroll, Import/Export, Local, State and Federal Taxes. Coordinated Production Planning, Material Inventory Control, IT Operations and Logistics. Processed weekly payroll cash payments to over 1000 employees which entailed payment accuracy and security during payment distribution. Manager assigned to work with Local, State and Federal Government agencies to settle disputes and regulatory changes.

Performed Budgeting and Financial Control functions for a sewing plant with over 1000 employees.

Managed a staff of 11 in areas including, Payroll, Accounting, Production Planning, Reception, and Import/ Export.

Liaison for Plant Management and all Government Entities, Local/State and Federal for Taxes, Social Security, Import/Export Duties and Environmental issues.

EDUCATION

University Of South Carolina - Columbia, SC

MIBS (Masters International Business Studies)

University Of North Carolina, Chapel Hill, NC

Bachelor Of Arts – Interdisciplinary Studies (Spanish, Japanese and Computer Programming)

PROFESSIONAL TRAINING

Hyperion System 9.x Installation

Essbase Database Administrators

Essbase Bootcamp

Essbase Calc Scripts

Essbase Analyzer

ODI 11g Integration and Administration

SAP Business Objects Business Intelligence Platform: Administering Servers (Windows)

Informatica Administration Training

ShowCase Administrator (Warehouse Manager and Builder)

ShowCase Query and Reports

RPG Programming for AS400

.

Contact this candidate