Project Manager Data

Kurt Reece-Peeplez

**** * **** **** *****, Unit *2, Mesa, AZ 85205

480-***-**** ******@*****.***

www.linkedin.com/in/hyperionguys

SUMMARY Over 20 plus years as a Hyperion Architect, IT Project Manager,

Business and Systems Analyst, Applications Developer and

Software Administrator in a variety of environments, working

with small and multinational firms. Responsible for system

design, maintenance, project management, data conversions,

custom report writing and database development.

PROFESSIONAL EXPERIENCE

Nov 2011 to Present Velocity Technical Solutions

Hyperion Architect and Project Manager

. Successfully managed these projects as Technical PM:

o Implement SSL for EPM 11.1.2.1,

o Upgrade Essbase and Planning from 11.1.1.3 to 11.1.2.2

o Upgrade HFM from 9.3.3 to 11.1.2.2,

o Upgrade EPM from 11.1.2.1 to 11.1.2.2.

o 3 Full Lifecycle implementations of 11.1.2.2

. Manage the participation of offshore teams, third-party consultants

and internal teams in bringing these projects in on time and within

budget.

. Responsible for designing system architecture, configuration,

upgrades and patches.

. Troubleshoot technical problems and provide RCA and solution

. Partner with the client in process improvement, optimization,

design and automation.

. Excellent troubleshooting skills across all disciplines, heavy DR

experience

Apr 2008 to Nov 2011 Freeport McMoRan and Accenture

Hyperion Application Architect

. Successfully managed these projects as Technical PM:

o Created automated ETL interface between SAP and Hyperion

Enterprise

o Upgrade Hyperion Enterprise from 6.4 to 6.5.1

o Upgrade Planning from 3.5 to 4.0

o Created Data Transformations in SQL to automate loads to and

from Essbase, People Soft and Ellipse ERP system

. Responsible for maintenance, configuration and support of HAL

programs and the Hyperion Enterprise application servers.

. Successfully developed and tested Disaster Recovery Plans for

Hyperion Enterprise, FAMS and CorpTax software.

. Maintained parallel development and user testing environments,

security and monitored/tested the servers during an enterprise-wide

domain migration.

Dec 2007 to Mar 2008 BearingPoint Inc. Corporate Office (Contract Position)

Hyperion System Analyst / Hyperion 5.5 / Help Desk

. Successfully managed this projects as Technical PM:

o Rebuild of Hyperion Enterprise application incorporating new

entity, department and COA structure.

. Hyperion administrator responsible for maintenance and support.

. Developed a spreadsheet that automated the creation of new entities

with complete hierarchy structure ready for import into the

application.

. Maintained the Chart of Accounts, modified Reports and Logic.

. As a daily task, loaded data feeds through the Database Module and

posted journal entries through the Journal Module.

June 2006 to Dec 2007 Tower Automotive

Hyperion Systems Analyst /PM / Hyperion 6.1.1 HAL 7.0 Administrator /

Hyperion Administrator responsible for maintenance, support and

enhancements for current Hyperion Enterprise 6.4 System.

. Successfully managed this projects as Technical PM:

o Successfully completed a server migration/application upgrade

from Hyperion 6.1.1 to 6.4.1

o Implemented several enhancements to the current system,

including reprogramming the HAL scripts, that reduced user

and system errors by more than 400%

. Used HAL 7.0 as an ETL tool to automate extractions and loads of

data into our application.

. Collected user requirements and consulted with the Finance group on

the feasibility and design of reporting projects.

. Provide training and coaching to end users.

. Used VB extensively to automate the exporting of data from Excel

templates to CSV format for loading into Hyperion.

October 2005 to June 2006 JFShea Co, Inc

Application analyst / Hyperion 6.4 Administrator / Help Desk

. Hyperion Administrator responsible for maintenance, support and

enhancements for current Hyperion Enterprise 6.4 System.

. Successfully completed an upgrade from Hyperion 5.5 to 6.4. using a

Citrix farm and a new dedicated Hyperion Application Server.

. Performed all month end collection and loading of data, as well as,

maintain the organizational rollups and chart of account

structure.

. Collected user requirements and consulted with the Finance group on

the feasibility and design of reporting projects.

. Provide training and coaching to end users.

2002 - 2005 Net Journeys, Inc., Victorville, CA

Business / Computer Consulting Training, President

February 2005 to August 2005 GE Plastics

I worked as an Administrator for Hyperion Enterprise version 4.3. I

was the Hyperion Administrator and Help Desk for worldwide Plastic

Operations. I modified the entity structure as needed to accommodate

new cost center additions and performed monthly and quarterly data

loads and verifications. I also maintained security and added/deleted

users per management requests. I performed monthly backups and created

ad hoc reports as requested.

September 2004 to January 2005 -- Mattson Technology

I worked in the Accounting Department as Temporary Administrator for

Hyperion Enterprise version 5.5.4. I meet with and gathered

requirements from users and used Crystal Reports to develop Ad Hoc

report requests. I also built a mapping interface with MS Access and

Excel to move data between Hyperion Enterprise and SAP. I created

reports using Retrieve worksheets and Hyperion Report Writer for

Bluebook Reporting, to present budget information, and to validate and

reconcile account balances. Developed and maintained mapping, Chart of

Accounts and Organization Structures between SAP and Hyperion.

March 2005 to September 2005 -- Universal Studios

I was Involved in the Hyperion Bridge Project to help facilitate

financial reporting between NBC and Universal during their merger. I

created an Interface to move data between Hyperion Enterprise 6.2 to

SAP and PeopleSoft. I also used Crystal Reports to create special

reports to verify and track variances. Retrieve worksheets were used

to capture and translate data through 3 different accounting systems

(including SAP and Hyperion). I gathered requirements and created

reports to track variances, present budget information, validate and

reconcile account balances and show data views of dollar amounts in

all three Charts of Accounts to validate mapping. I developed a system

to report and convert Budget and Actual data that was to be loaded

from Hyperion Enterprise to SAP. I also created Categories and Roll-

ups in Hyperion Enterprise for different budget periods and modified

system logic to carry forward period balances and to subtotal account

groupings.

June 2002 to December 2003 -- Reliance Steel & Aluminum, Co

I was involved in Software Implementation for Aluminum Stainless in

New Orleans, LA and Central Plains Steel in Wichita, KS. I conducted

Software Training Classes in Sales, Production, Purchasing and

Shipping / Receiving, and Inventory Corrections. I developed Data

Conversion programs using advanced formulas and macros in Excel and

Access to convert, validate, then move legacy data into Stelplan. I

was also used to troubleshoot and devise workarounds to solve problems

completing transactions and to maintain consistent following of

business processes.

November 2002 to June 2003 Warner Bros

I converted financial data for SAP implementation from Hyperion

Enterprise 4.3 using Excel and Access and Retrieve. I used pivot

tables and financial calculations in Excel using Retrieve and Crystal

Reports to validate and reconcile data before and after data

conversions to Hyperion Enterprise 4.3 and 6.0. Excel was used to view

data in Hyperion Enterprise to track status of data loads to and from

SAP. I used cell-linking to clean and pre-consolidate data in Excel

before moving to Access database for final conversion processes. I

developed specially formatted spreadsheets to accept data loads from

SAP prior to converting and loading into Hyperion Enterprise. I

created user forms to display reported data via Hyperion Retrieve into

a more meaningful and presentable format. I was the Helpdesk Support

for Hyperion Administrators in all WB divisions (27 apps). I gathered

requirements from FRB and other divisions to help determine whether to

upgrade Hyperion or rebuild the older Hyperion Enterprise

applications. I also helped solve problems in Hyperion Enterprise by

correcting formulas in Logic, creating Retrieve spreadsheets and

correcting elements in Reports, modifying Account Lists, and adjusting

the properties of Names in Organizational Structures for all WB

Divisions

June 2002 to Present -- Various Small to Medium Size Business

I have acted in a Financial Analyst roll in using Crystal reports to

create ad hoc reports. I have created Payroll reports from ADP data on

Oracle using Crystal Reports and Access. When needed I have imported

data using ODBC and FTP processes to Access databases and Excel

Spreadsheets. Using ODBC I have connected to SQL Server, Informix,

Oracle, and other relational and flat database file systems with Excel

using MS Query, Access and Crystal Reports to extract data for

cleansing and for display as formatted reports. I have used VBA code

to open Excel from within Access to perform preliminary updating tasks

and data extraction for database tables, which had too many indexes

for Access to open on its own.

In automating systems I have used VBA code and batch files with MS

Scheduler to automatically run Access applications and have reported

data sent directly to coded email recipients as Excel spreadsheets

attachments. I have developed and fine-tuned Access databases, used in

Inventory Control, Sales Analysis and Financial Reporting. I used

macros and VB script to perform advanced operations on data in Excel

spreadsheets for data cleansing and validation. I have used Pivot

tables and Pivot Charts to consolidate linked data between various

company divisions. I have also used linked charts in Excel for

executive staff to view from data managed in Excel spreadsheets

maintained by other support staff. I am experienced in Web Design

using HTML, Flash, Front Page, HomeSite, ASP

EDUCATION

CAL STATE FULLERTON Computer Science (not

completed) 1980 to 1982

SKADRON COLLEGE OF BUSINESS Accounting 1982 to

1984

Contact this candidate