jeff he

Business/Technical System Manager, Corporate Planning Set strategic direction for Corporate Planning Business Intelligence needs. Mapped out future changes, developed new initiatives, and worked to ensure system compliance with JSOX. Led project to upgrade from Hyperion Essbase 7.1.3 to Hyperion Essbase System 9.3.1. As part of the upgrade process, converted Hyperion Essbase cubes and migrated EIS models. Planned and built an HR compensation planning system collaborating with HR. Built a traveling expense reporting system, analyzed the data, and presented travel insights to senior executives. Redesigned and streamlined complex financial allocation processes. Experience sourcing data from General Leger and Human Resources modules of Oracle Financials.

Business/Technical System Owner, Corporate Planning Built Hyperion Essbase Business Intelligence solutions to meet Corporate Planning business needs to help analyze actuals and budget. Created Portfolio Management plan for pharmaceutical projects and assisted in forecast data analysis. Created new systems using Hyperion EIS, Oracle, Hyperion Essbase, Oracle Financials, and Clarity systems. Automated tasks, reduced time to execute tasks, and streamlined processes in the financial planning system. Worked with end users to improve system and solve issues. Performed Profitability Analysis of an upcoming drug based on a variety of factors including competitive marketplace, primary, and secondary data sources. Created Dashboards for Finance analysis comparing past, Actuals, and Budget project performance.

Worked as a developer on Business Intelligence solutions. Gathered business requirements, wrote business project plans, performed validation, created reports, and built Hyperion Essbase solutions. Optimized SQL ETL, created load rules, wrote MDX scripts, built outlines, wrote report scripts and helped build an ASO cube. Helped setup, administrate, test, and configure development and production servers.