Management Professional Experience
Resume:
JAMES HILL
act1i9@r.postjobfree.com
My goal is to work for innovative companies in the areas of business intelligence (BI) and enterprise performance management (EPM).
SOFTWARE EXPERIENCE
HYPERION ESSBASE - DATABASE ENGINE
Calculation scripts
Data load rules
Data report scripts
Outline metadata dimension builds
Security filters
Partitions
HYPERION PLANNING - WEB BASED APPS
End User & group security management
Data source name configuration
Interactive business rules
Workflow management
HYPERION SHARED SERVICES
End User security management
Application & server provisioning
HYPERION WORKFORCE PLANNING
Employee level calculations
Implementation of menus
Implementation of smart lists
Design of workforce business rules
Utilization of run-time prompts
Customization of workforce planning outline for client
HYPERION ESSBASE EXCEL ADD-IN QUERIES
Ad hoc analysis of multidimensional data
Slice & dice pivoting of dimensional intersections
Production support data validation
VIGNETTE BUSINESS INTEGRATION STUDIO
ETL tool for converting data file formats
Integration used to manage data loads and metadata
Batch integration deployments to end users
PROFESSIONAL EXPERIENCE
NORDSTROM, Seattle, WA July 2010 – January 2015
Senior Software Engineer, Enterprise IT - Analytics
This position uses my technical expertise to improve Nordstrom’s use of Hyperion Essbase. It supports and enhances existing cubes and creates new cubes as needed. It also leads the technical design, build, testing, and implementation of Essbase projects. The role requires partnering with internal business teams to identify, develop, and analyze complex business requirements.
Created Canada Essbase cubes for expansion reporting initiative
Developed complex dimension building load rules and partitions for large ASO & BSO cubes
Participated in migration of version 7 cubes to 64-bit Essbase version 11 environment
AMAZON, Seattle, WA September 2007 – December 2009
Programmer Analyst, Global Financial Applications
This position with Amazon’s Global Financial Applications team contributed to the strategic, tactical, and operational aspects of Amazon’s financial planning, reporting processes, and tools. It was primarily responsible for structuring multi-dimensional business intelligence data by analysis, design, engineering, and requirements gathering.
Installed and configured Hyperion versions 9 and 11 in a Linux environment
Implemented Essbase Integration Services to build a prototype Inventory reporting cube
Converted the primary reporting application from block storage to ASO, reducing it from 20 partitions and 500 GB to a single database of300MB
ACUITY ANALYTICS, Seattle, WA October 2006 – September 2007
Lead consultant, Hyperion Planning & Essbase Reporting Solutions
This lead software consultant position developed centralized Hyperion Planning and Essbase reporting databases at the division and enterprise levels. These solutions vastly improved the budget, forecast, and planning processes for finance departments as well as the monthly close process for accounting departments. Project management and documentation skills were required as engagement lead.
Created web based Planning entry forms for Project, Balance Sheet, and Income Statement
Tuned outlines and business rules for granular planning data detail
Optimized business rules, database caches and Essbase.cfg files for fast calculation speeds
HYPERION SOLUTIONS, Seattle, WA September 2005 –October 2006
Senior Consultant, Hyperion Planning & Essbase Reporting Solutions
This senior consulting position with the global leader in EPM software focused on the development and implementation of Hyperion Planning and Essbase reporting solutions. Overall system reviews were performed to improve database configuration and design for existing client as well.
Revamped current managerial reporting databases and processes
Employed ASO database technology geared for large multi-dimensional outlines
Worked with management and analysts to design customized Planning solutions
Designed custom Workforce Planning solution providing granular employee level calculations
WASHINGTON MUTUAL BANK, Seattle, WA July 2002 –August 2005
Technical Specialist, Finance Business Partners of the Technology Solutions Division
This position directly supported the Commercial Division Finance team, the Commercial Division CFO and the division’s Corporate Chief Administrative Officer. Responsibilities centered upon the administration and development of the division’s production applications and associated enhancements. This role was the primary Hyperion Planning and Essbase subject matter team expert and lead developer. It also coordinated software upgrades with the technology engineering group.
Administered the primary financial planning and reporting databases and processes
Developed Commercial’s Loan Officer Sales Contest database
Redesigned Commercial’s FPA Planning database for the Commercial Finance department
Supported the monthly accounting close process as well as budgets, forecasts, and plans
EDUCATION
University of Washington, Seattle, WA August 2001
BA Business Administration - Management Information Systems & Marketing
Contact this candidate