Christine M. Wu

Bay Area, CA, Cell: 914-***-****, adg7y2@r.postjobfree.com

Oracle Hyperion EPM On-Prem 6.5 to 11.2. EPM Cloud applications. Modules integration, conversion, build, migration, upgrade, and tuning. Financial principles, scripting, and enhancements.

Competency and Expertise:

FCCS, PBCS, Oracle EPM Cloud products.

Oracle Hyperion On-Premise EPM: HFM, Essbase, Planning, DRM, FDMEE, ODI, Weblogic/EM.

Windows, Linux, and Solaris Servers. Shell, batch, maxl, MDX, Jython, action scriptings, VI.

Financial accounting principles for building financial logic into system applications and specifications.

Application migration, LCM, rebuild, install and configuration tools. RCU configuration, Middleware config.

Project Management Methodologies concepts in timeline, plan, resource, and implementation.

GL/HRIS Systems, SQL/Oracle DB Servers, sqlplus, Transactional concepts.

Certification:

Oracle Hyperion Planning, Oracle Hyperion Essbase, Oracle Hyperion HFM

eBook:

2019, ‘Some Things Do Come Easy – Oracle Hyperion EPM FCCS & PBCS’, e-booklet.

CONSULTING EXPERIENCE

Hexaware Inc. at Northern Trust. Technical Architect, IL 2/20 -5/20

•Technical SME for HFM Upgrade from 11.1.2.3 to 11.2 On-Prem,

•Provided infrastructure install support. Track tasks, security, and defects to resolutions.

•Set up HFM Taskflow with hub functionality, smtp mail notifications, query db fact table.

•Translated EPMA processes to DRM metadata procedures, Create health-check and tuning docs.

•Converted and migrated custom .bat, FDMEE Jython scripts, and open batch loads to 11.2.

•Created DRM custom security, groups, custom property definition, action scripts.

•Worked through drillthrough FDMEE integration to Peoplesoft.

•Prepared test scripts for UAT testing. Perform environment validations on release.

Integrated IT at UBM Plc, EPM Business Partner, NY 4/18-11/19

•Created FDMEE integration of EBS to Main Planning application, including ODI set up.

•Rebuilt Planning and HFM applications from metadata extracts to upgraded version.

•Updated Workforce Planning and Oracle HR for FTE changes, maintained leavers and transfer info.

•Worked through Close, Budget/Planning cycles, updated tasklists and the phase submission changes.

•Troubleshooted user error messages, Essbase server tuning, updated business rules.

•Some trainings and discussions in PBCS.

Resources Global Professional, Management Consultant - Oracle EPM, NC 4/16 – 4/18

•Installed EPM prototype environment in 11.1.2.4 for testing with Third Party tool Tableau.

•Rebuilt custom Japanese HFM application in AWS onto upgraded US on-premise with translation.

•Provided recommendation on new HFM application, I/C configurations, custom rules.

•Transferred ownership information and consolidation methods to new application.

•Updated custom scripting rules to map unconsolidated historical data.

Integrated IT at Fujitsu America, EPM Consultant, TX 10/15 – 1/16

•Provided post upgrade support and transition of EPMA HFM, Planning, FDMEE applications to production.

•Reviewed legacy Enterprise application for metadata and data completion.

•Produced reports and close cycle procedural documentation for new applications.

Techstar Consulting Inc. at Verizon, Oracle EPM/Infrastructure Consultant, CO 1/15 – 8/15

•Performed patching and upgrades to 11.1.2.3.5 on Linux Exalytics and Solaris Exalytics for EPM system.

•Optimized Essbase server in upgraded 11.1.2.4 version via cache tuning, Essbase config file tuning.

•Migrated multiple Essbase applications and components to new EPM Linux servers.

•Worked with team to install EPM environment on Exalytics with Oracle SQL DB.

•Prepared and conducted presentation for EPM Planning.

• Scripted diagnostic shell scripts for simulation testing. Reviewed Maxl and Planning rules.

•Reduced Essbase application aggregation time by 50% from optimization.

•Related products and artifacts included SQL, OBIEE, LDAP, Java, SOA, DRM, ESPx.

Integrated IT at Dun and Bradstreet, HFM Project Consultant, NJ 9/14 - 11/14

•Created project plan for HFM upgrade from 9.2 to 11.1.2.3, including timelines.

•Defined WBS such as upgrade paths, tasklists, deliverables, resource, and procurement requirements.

•Interacted with related IT groups in communicating deployment requirements.

•Reviewed application and FDM, evaluated new features for upgrade, and formulated technical plans.

Tata Consulting Services at Covance/Cisco, Planning Project Lead, NJ 9/13 - 8/14

•Created Essbase ASO archive cubes for Planning, Project, CAPEX, qnd Workforce applications.

• Led design meetings, offshore developers on daily project tasks, technical guidance and schedules.

• Converted Essbase outlines to ASO. Translated member formulas to MDX. Developed data load rules.

•Worked with Planning close process in Unix environments.

•Developed technical documents and other project related matrix.

Abeam Consulting at Huntington Ingalls Industries, HFM Technical Manager, VA 10/12 – 2/13

•Worked on EPM infrastructure upgrade from 11.1.2.1 to 11.1.2.2.

•Merged separate HFM and Planning instances into a single Foundation platform with team.

•Built new HFM application subsequent to organization spin-off.

•Incorporated new features in HFM upon upgrade, expanded HFM custom dimensions to six.

•Revised rule file for new metadata and removed non-functioning rules.

Hyperion System Support and Administration 3/07 – 10/12

Cognizant Technology Services at Wal-Mart, HFM/Planning Support Project Manager, AR

•Managed Hyperion HFM, Planning, Essbase support projects in v.9.3 for WM’s technology division.

•Identified HFM clustering issues causing environment crossing for stabilization of application.

•L3 technical support in HFM, Planning, Workforce, FDM for WM ISD, for Prod, Test, QA environments.

•Worked with Change Management process and ticketing system within WM ISD.

• Gave presentation of new software to WM’s software review committee, and client.

•Conducted Cognizant internal training. Observed ISO standards. Tracked disaster recovery procedures.

SeaCube Container Leasing, Sr. Systems Administrator, NJ

•Financial systems administration on Essbase, Planning, HFM, FDM, Sql DBs, Lawson, Salesforce.com, HRIS Databasics, FRS, report tools, Add-Ins, and Office suites.

•Maintained batch, MaxL, calc. scripts, and 100+ MSSQL DTSs for scheduled data refreshes.

•Worked with data feeds from in-house proprietary software to Essbase cubes v.9 with 26 dimensions.

•Developed ad hoc queries for data pull via cross joint SQL queries, Access, and ODBC connections.

•Filed government data reports with XBRL formats. Converted XML to XBRL via Perl.

•Provided business user support, troubleshooting, and issue resolutions on finance systems.

Accountants International at Handy Harman, Technical Project Manager, NY

Expanded existing HFM/FDM applications to include acquired company subsequent to M&A in v.9.

•Developed new Entity and Account hierarchies with integrated COA.

•Set up intercompany eliminations, override, currency, ownership in metadata, updated rules as pertinent.

•Set up FDM data feed locations, monitored data feeds at close.

•Troubleshooted and corrected server installation errors. Provided end user training.

Continental Grain Company, Financial Systems Administrator, NY

•Ensured Financial consolidation, G/L, budget/forecast systems are available, addressed any error.

•Performed system rollover at month-end, and for budget/forecast cycles.

•Worked on system upgrade in Hyperion, JDEdwards, from v.6 to v. 7.

•Maintained user securities. Coordinated backups, recycling, automated scheduled tasks.

• Business user support, troubleshooting, and training. Developed documents.

BI Functional Consultant, Commodities and Consumer Goods 7/04 – 12/06

UBS Securities LLC, Pepsico International, Scholastic Inc., Dover Corp., NY/IL

•Worked with Hyperion Enterprise and other BI products such as Khalix, and Bloomberg.

•Designed Hyperion test scripts/templates for system conversion UAT Test Cases.

•Worked with consolidation, budgeting, and forecasting processes and cycles.

•Ensured data accuracy in close cycles with source system and across related systems.

•Designed templates with embedded allocations for budget/forecast data collection.

•Compiled and filed market data report to commodity exchanges CBOT, CME.

•Provided systems conversion analysis and support.

Systems Conversion Merger Consultant, Banking and Finance 10/99 – 6/04

Bank of Nova Scotia, JPMorganChase, Citi-Capital, Deutsche Bank, GE-Capital, NY/NJ/IL

•Supported systems conversion and migration to ACBS Loan Accounting system.

•Supported systems conversion in Hyperion Enterprise subsequent to M&A on $20 billion ledger.

•Supported systems conversion and data migration to Oracle GL 11i.

•Parsed data on large supplemental accounts post Acquisition activities with 500 pages in one account.

•Provided gap analysis on conversion data, made recommendations on variance.

•Ensured accuracy of data migration from source to target systems, at 99.95% accuracy.

•Maintained age and breaks records for security trading.

•Cleared $25MM post conversion backlog items in one project.

Training:

Oracle University Training FCCS, PBCS, ARCS

ITSM Foundation Certification Training

Agile Scrum Certification Training

Education:

University of California Berkeley, BA, Economics, 1995.

Tufts University, MA, Economics, 1998.

Contact this candidate