Oracle Epm Financial Planning
Resume:
Objective
Looking for position Oracle EPM FCCS/EPBCS Consultant, where I can utilize both my skills and experience towards the development of your business
Qualification
10+ years hand-on EPM/BI/Data Warehouse Project Delivery experience
Functional Role on Consolidation, Financial Planning & Analysis, Process Reengineering, Financial Transformation, Business Process Transformation.
EPM Skills:
Hyperion Planning/HFM/PBCS/EPBCS, HFM/FCM/FCCS, Account Reconciliation/ARCS,
DRM/DRG/EDMCS, Tax Reporting Cloud Service, Hyperion Profitability and Cost Management/PCMCS, Essbase/Oracle Analytic Cloud Service,
Oracle Public Sector Planning, Hyperion Tax Provision, Tax Reporting, Hyperion Strategic Finance, SAP BPC 10/10.1/11, Cognos TM1/Planning/Controller
Good understanding of GAAP, IFRS
BI Skills: OBIEE(11g/12c)/BICS, Data Visualization, OBIA, DAC/BIACM, OBIEE using Answers, Dashboards, Administrations Tool, BI Publisher, SAP BOBJ, Cognos
ERP Knowledge: Oracle EBS/Financial, SAP FI/CO, SAP BW, ABAP, S4 Finance/HANA
Database: DB2, Oracle, MS SQL Server, Teradata, PL/SQL
Cloud Computing: AWS, Azure, Good Cloud Platform
Big Data: Hadoop, MapReduce,Pig, Hive, HBase, ZooKeeper, Sqoop
ETL tools: ODI 11g/12c, Informatica 9.5/9.6/10.1, IBM Inforsphere DataStage
Programming: Java/C#/.NET, R, Ruby, Shell Script, Python, Jython, Java Scripting, PHP
Industry experience including Auto Manufacture, Public Sector, Finance, Banking, Retail, Distribution and Telecommunication
5+ years Project Management experience
Self-starter and Fast-learner
A good team-player with excellent communicational skills
Professional Experiences
Oracle FCCS Consultant 2024 Apr – Current
WALMART, Bentonville, Arkansas
Project Description: Support Walmart Global Financial Close and Consolidation System. End to End Implement Oracle Financial Close and Consolidation System (FCCS), Support both HFM and Oracle FCCS parallel running
Environment: Oracle EPM FCCS, Oracle Narrative Reporting, HFM, FDMEE
Review current Financial Close process and Consolidation
Implement Oracle EPM FCCS system
Migrate HFM functions to Oracle EPM FCCS
Build Data Integration and EPM Automate script with EPM Integration Agent
Build Jobs scheduler with Control-M
Create Financial Report by using Narrative Reporting
Review FCCS application Setting profile and enable necessary features
Rebuild Account and Entity dimension for FCCS
Enable and Customize features: Traditional Balance Sheet, CTA, Retained Earnings
Define Web forms, grids and supplemental data
Create Task in Task Manager
Data Migration and Validation between HFM and FCCS
Make SIT/UAT test
Production Support for HFM/FCCS Parallel running
Oracle EPM Cloud/ODI/OBIEE/OAC Consultant 2023 Dec – Mar 2024
Client: Ministry of Public and Business Service Delivery (MPBSD) – BI & Analytics
Project Description: Migrating Budget/Forecast System from Oracle EPM On-Premise to EPM Cloud. Support Budget/Forecast/Planning process for Cost Center Salary & FTE, Cash Planning.
Environment: Oracle PBCS, OAC, OBIEE 12c, ODI 12c, OICS,OCI, APEX, EPM Integation Agent
Migrating Oracle EPM On-Premise application to Oracle EPM Cloud PBCS
Convert MaxL scripts to EPM Automate scripts for Nightly/Monthly Data load process
Redesign Navigation flow to accommodate new card for Enhanced Reports
Create Test Scripts for Form, Reports and ETL for testing
Meet Ministry user to review all of CCSB reports in OBIEE
Create Enhanced Report with Form/Grid in PBCS to replace CCSB Report in OBIEE
Create LoadPlan and Scenario in ODI 12c to import Metadata and load GL Data to CCSB
Update and improve APEX web application on Procurement & Contract Analysis and Enhanced Vendor reports
Migrate part of OBIEE Report to Oracle Analytic Cloud to compare with EPM Reports
Create users and add user into group from Weblogic admin console, and assign group to application role from Oracle Enterprise Manager Fusion Middleware control
Redesign Data Model with RPD file from Oracle Administration Tool
Design Row level security at Cost Centre level from APEX application
Create design document and deployment document for CCSB reports migration
Make SIT/UAT test
Production Support for Quarterly Forecast and year end Budget
Oracle EPM Solution Architect 2022 Jan – Dec 2023
WalMart Canada
Project Description: Provide Production Support for WalMart Merchandise Financial Planning Application
Environment: Oracle PBCS Freeform Merchandise Financial Planning
Meet with Business to collect KPI, Store EOP, Receipt cost, FC Inventory, Reserve $
Work with Deloitte consultant to make enhancement on MFP functionality
Develop new e-Commerce channel form and business rule, groovy script
Make UAT Test and Production Deployment for new change and enhancement
Review and Update Batch script for Daily/Weekly/Monthly/Ad hoc processing
Provide on-call support for Daily/Weekly/Month End processing
Oracle EPM Solution Architect /FCCS and ARCS/TRCS Consultant Apr 2021 – Jan 2022
Client: ATCO, Edmonton, Alberta
Project Description: Full End to End Implementation of Financial Consolidation Application for ATCO Corporation Accounting by using Oracle EPM FCCS.
Environment: Oracle Fusion Cloud Financial, Oracle EPM FCCS, ARCS, TRCS
Collect business requirement
Convert functional requirement into technical objects
Analyze user stories and discuss with business to close the gaps
Design Oracle EPM FCCS system based on the client requirement
Build Metadata and load into FCCS consol and report cube.
Create Data form and Data Grid for data input and validation
Customize business rules based on business requirement
Customize Data source dimension to add Journal reverse
Format Journal template and design Journal load and posting process
Implement Ownership management module to cater to proportional consolidation demand
Configure consolidation for Intercompany Elimination
Configure Currency Translation calculation and CTA
Create custom validation rules using member formulae in FCCS
Build and configure Cash flow
Build Data Integration starting from GL to load trial balance into FCCS
Build Statutory Report by using Oracle TRCS
Provide KT to business user
Oracle FCCS/EPBCS/FDMEE Consultant Mar 2020 – Mar 2021
Client: McDermott, Houston TX
Project Description: Implement Fresh Start Project for Corporation Accounting and Finance Department
Environment: Oracle FCCS/EPBCS/ARCS/EDMCS Financials Consolidation and Planning and Project Financial Planning, FDMEE
End to End Oracle FCCS full implementation
Collect business requirement
Provide business design and technical design document
Analyze Financial Consolidation Requirement
Design and configure Ownership management
Design Intercompany Elimination, Translation and CTA, Roll Forward Calculation
Design Legal Entity Structure
UAT Test and go live support
Phase II - EPBCS End to End Full Implementation
Review Tasks and Dashboard and Data form
Restructure organization hierarchy, build alternative hierarchy for Entity, update Account hierarchy
Create business rule to calculate Project Revenue and Expense/Working Capital, consolidate Balance Sheet
Use Oracle Access Manager (OAM) to manage the coarse-grained seurity
Customize data integration between FS, PFP and Reporting Cube with DataMap
Build project metadata load through EPM Automation Script
Integrate ERP JDE /GEAC with EPBCS by using FDMEE
Build new batch, Update FDMEE automation script and batch script
Load JDE and GEAC data through FDMEE to EPBCS reporting cube, PFP, FS cube
Test, Debug and troubleshooting the error during the data load from FDMEE to PFP/FS cube
Implement Oracle EDMCS and make production support and enhancement
Client: Novelis, Atlanta GA
Project Description: Implement and support Financial Reporting System for Corporation Wide including East Asia, NA, europe with Hyperion EPM on Premise
Environment: Hyperion Planning Essbase, FDMEE, Narrative Reporting
Collect business requirement
Provide business design and technical design document
Create Input Template and Web Form in Hyperion Planning
Create business rule to calculate B/S, Metal, Opex, SGA Sales, Head Count, CapEx, IC other account.
Implement Forecast/Strat_Plan Automation Load Process by using Calc Manager Command Line Launch utility
Create Planning RTP file, change Business Rule Batch Script
Test, Debug and troubleshooting the error during the data load from FDMEE
Review FDMEE Planning call Script
Rewrite Business rule for command line running again BSO and then push data to ASO FinRpt cube.
Work on both Forecast and Strategic Planning Scenario for forecast cycle.
Create report by using Oracle Narrative Reporting
Oracle PBCS/Hyperion PCM/Hyperion Essbase Consultant May 2019 – Dec 2019
Company: Pepsico Food Canada
Location: Mississauga, Ontario
Project Description: Support FP&A Reporting System for Pepsico Food Canada
Environment: Oracle PBCS,PCMCS, Hyperion Essbase
Provide Product support on Essbase Cubes for Frito Lay and Quaker including main cube and supply chain cube.
Enhance calculation Script and Data load
Use Control M to Trigger and Monitor jobs to load into essbase from EDW and extract essbase data back to EDM
Support and enhance ETL processes by programming Oracle PL/SQL to extract data from PeopleSoft, Tereadata, other data sources
Troubleshooting any issue related to Financial Budgeting/Forecasting
Design and Implement Hyperion PCM(Profitability and Cost management) Application
Enhance,Support Hyperion PCM Production
Production Support of Oracle PBCS/EPBCS/Oracle EPM for Pepsico Food Canada and US
Oracle PBCS Consultant Feb 2019 – May 2019
Client: GE Aviation ( www.GE.com )
Company: GENPACT
Location: Cincinnati, Ohio, 45202
Project Description: Build and Support FP&A Reporting System for GE
Environment: Oracle PBCS, FDMEE/DM
Work for GE Aviation BGAIS project using Oracle PBCS.
Define Project scope and Plan
Collect and translate business requirement from various business units like Power/Unison
Create Instance on Oracle EPM Cloud
Create PBCS Services (Test and production)
Design metadata dimensions from scratch on Smart view
Load dimension into PBCS and write business rule to implement consolidation and amortization.
Build Stage Table to handle Financial Actual Input and Adjustment.
Create Data load rule in PBCS Data management to load data into PBCS
Automate metadata load and data load using EPM Automate scripts
Create EPM Automate Script to automate data load
Design Rolling Forecast work flow
Assign Security user/group and provision associated roles
Make Test strategy,Test plan and create Test Scripts
Migrate PBCS Test application to Production
Post Production support
Hyperion Planning/ DRM/OBIEE Developer Aug 2017 – Aug 2018
Company: Scotia Bank
Location: Toronto
Project Description: Build Budgeting application for Scotia bank Mexico FP&A System
Environment: Hyperion Planning 11.1.2.4, FDMEE, DRM, PeopleSoft Financials 9.2
Define Project Scope and Plan
Review and finalize business requirement
Convert Business requirement to Technical Design Documentation
Create Scotia Mexico Planning Application
Design Transit/Cost Center/Product dimensions from scratch on Excel and load it into Planning by using FDMEE to create mapping, load rule to load data
Create Maxl Script to automate data load
Create MaxL Script to import custom dimensions including Entity/Transit /CustomSeg/Product
Create Data Mapping between main MGL BSO to reporting MGL ASO Cube
Design G&A expense allocation business rules that are based on Revenue and head count
Build Balance Sheet by invested products, calculate Net Exposure
Design Rolling Forecast work flow
Assign Security user/group and provision associated roles
Make Test strategy,Test plan and create Test Scripts
Post Production support
Project Description: Build Scotia bank AGL, EGL, MGL Metadata applications in Oracle DRM/DRG for Scotia bank Asia GL, Toronto GL, Mexico GL
Review and Assess the Global Finance master data management solution.
Analyze PeopleSoft Financial and FP&A system and process in Scotia bank.
Identifying what should be the master data and how it can be handled using DRM.
Designed solution for centralized repository of Finance Master Data.
Designing solution/architecture for the system integration
Build Work flow Process by using DRG
Build action script-based IDCC solution to meet larger Change Management request
The development involves following tasks:
- Creating functional and technical design document for Asia GL implementation.
- Creating properties, Property Category as per the requirement.
- Developed workflow process for the users to add new Account/BU/Transit/product etc.
- Creating validation rules to verify metadata in DRM.
- Develop SQL to query PeopleSoft to get GL hierarchy node/leaf
- Creating custom exports as per the requirements by different target systems.
- Automating the whole end-to-end process by using batch scripts.
- Created staging version to capture delta data (daily Incremental).
- Creating standard exports and use batch to automate the export and sftp to landing zone
a. Full Tree export/Delta export
b. Control file export to validate the export.
- Implementing security using tool internal ability and external authentication.
- Generate migration package for production migration by using migration utility.
Project Description: Build Scotia bank AGL BI application including Data Mart Build, ETL process from PeopleSoft and Core Banking, Create OBIEE Interactive Dashboard and Reports
Adopt dimensions exported from DRM and Build Star Schema in Data Warehouse for Asia GL BI Application.
Use Oracle SQL/PL SQL to build multiple ETL processes by utilizing Informatica Power Center. Extract and transform data from Core banking and People soft to Data warehouse
Create RPDs based on AGL Requirement in OBIEE, build OBIEE Answer/interactive Dashboard to present Asia GL to Management Team.
Build P&L, Balance Sheet and Cash Flow Reports in BI Publish on Month/Quarterly Closing for Hongkong, China, Singapore and India, Korea based entities.
Go live support
Oracle Hyperion Planning/PBCS/EDMCS Consultant Feb 2015 – July 2017
Company: Vanguard Group
Location: Valley Forge, Pennsylvania
Project Description: Build Fund Expense Planning Application with Hyperion Planning, build Essbase BSO cube to implement Fund Expense Allocation function and Data Integration
Project I –Fund expense Application
Define Project scope and Plan
Review business requirement
Build Fund Expense Application with Hyperion Planning
Create Business Rule/Calculation scripts to build Fund Expense allocation
Build Daily Expense Accural and Asset calculation
Create Web form for driver input and data visualization
Use Oracle Data Integrator to interface and package to make data integrate from PeopleSoft G/L, Legal Entity planning and Management Planning, Legal Entity Reporting and Management Planning Reporting cube.
Make Test plan and build Test Script
Deploy Fund Expense Planning application
Enhance and Daily support
Upgrade from Hyperion planning from Hyperion 11.1.2.1 to 11.1.2.4
Project II – Oracle EDMCS Implementation
- Creating functional and technical design document for GL and Hyperion .
- Creating properties, Property Category as per the requirement.
- Developed workflow process for the users to add new Account/Fund Product.
- Creating validation rules to verify metadata.
- Develop SQL to query PeopleSoft to get GL hierarchy node/leaf
- Creating custom exports as per the requirements by different target systems.
- Automating the whole end-to-end process by using batch scripts.
- Created staging version to capture delta data (daily Incremental).
- Creating standard exports and use batch to automate the export and sftp to landing zone
a. Full Tree export/Delta export
b. Control file export to validate the export.
Hyperion Essbase/Hyperion Enterprise Developer July 2014 – Jan 2015
Company: Bank of Montreal Financial Group, T&O Corporate
Location: Toronto, Canada
Project Description: Develop and Support Corporate Finance Reporting including Essbase ASO/BSO cube build and deployment, support Hyperion Enterprise 6.5 for CODA G/L system
Collect and review business requirement
Define Project scope and Plan
Build Essbase ASO/BSO cube and deploy Partition to support Finance Reporting
Modify partition script by utilizing MS SQL 2008 to store user password
Develop Calculation scripts to implement cost allocation on BSO cube
Design Korn shell script to automate cube rebuild by using MaxL script
Support CODA G/L system and support Hyperion Enterprise Reporting system
Migrate exist report template from Essbase Add-in to SmartView version
Build report script and Shell scripts to extract balance sheet and marginal data for GMO Division
Make Test plan and build Test Script
Support on-going projects
Run Cron job on Unix environment to support Windows based Planning Essbase Application and Support daily maintenance activities to schechule and changes to CRON jobs.
HFM/FDM Consultant Aug 2013 – May 2014
Company: Canadian Tire Corporation
Location: Toronto, Canada
Project Description: Implement HFM Consolidation System External Financials Reports and CFO and Direct Accountability Reports, Migration of Hyperion Planning System
Implement HFM system with Ernst & Young Consultants
Collect and review business requirement
Define Project scope and Plan
Implement function including consolidation and intercompany Elimination
Define Data Inbound/Outbound Interfaces Among PeopleSoft, JD Edward, HFM, Planning
Provide Data integration solution within Hyperion Planning, FDMEE, HFM
Build and Extract dimension from DRM
Define and Build HFM Metadata
Act as Architect to make a solution to meet business requirement
Program HFM Business Rule to function consolidation, Account Roll Forward, Currency Translation, Intercompany Elimination
Maximum consolidation process automatically
Make Test plan and build Test Script
Validate Consolidation Data
Create External Reports, CFO Reports and Direct Accountability reports by using Financial Report Studio and Smart View
Post Support HFM System Go Live
Support Migration Hyperion Planning system to 11.1.2.2
Integrate Hyperion Workforce Planning with HFM
Design inbound and outbound data interface between Planning and HFM
PM/Hyperion Planning Consultant Feb 2013 – July 2013
Coompany: HuaWei Technologies Co, Ltd
Location: ShenZhen, P.R.C
Project Description: Implement IFS PB&F E-Planning 5(Integrate Financial System Planning Budgeting and Forecasting) Project for corporate wide Budgeting Financial System
Create Project plan and Define project scope and requirement
Collect the business requirement and define target
Analyze Gap/Fit on Profit, Revenue, expense and Cost by Brand, Region
Propose IT solution
Design Corporation Meta Data by using DRM to extract dimension for Planning App
Streamline forecast model that is based on Pipeline baseline Forecasting
Design IT solution for Pipeline Baseline Forecast Model
Using IBM Infosphere DataStage to Design ETL Script/Process to make data transformation among various transaction system and R&A Data Warehouse to meet Forecast requirement
Developed and maintained PL/SQL packages, stored procedures and SQL scripts to create database multidimensional object
Write PL/SQL packages and procedures from scratch for the application to improve data integrity and increase the system efficiency.
Build forecast data model in OBIEE RPD and Demonstrate Signing and Backlog Sales Performance Index
Design Budget Input template for Plan Year
Design Hyperion Planning 11.1.2.2 Application by Hyperion EPMA
Create Business rules for allocation and consolidate by using Calculation manager
Design Essbase Transparent partition by Business Group or Geography view
Design User Financial Report Studio to create Financial Reports for different level BG.
Rewrite load rule for new data load format
Review MaxL script to automate data load
Hyperion Planning Consultant Jan 2012 – Jan 2013
Company: Sears Canada
Location: Toronto, Ontario
Project Description: Implement Commodity Budget Project for Sears Canada Financial Budget System by using Hyperion EPM 11.1.2
Collect the business requirement and define business target
Analyze Gap/Fit of Gross profit, Inventory and COGS of Sears Canada
Propose the improvement direction and feasible solution
Design retail business model to align retail industry KPI
Build bottom up model for Commodity Budget Forecast System
Design Division or Shop level P&L Excel input template for Plan Year
Design Planning Application by Hyperion EPMA
Create webform as input template for Subshop level input
Create Business rules for allocation and other calculations by using Calculation manager
Create Excel SmartView template and Code VBA to retrieve data from essbase cube
User Financial Report Studio to create Financial Reports for different level user for Commodity Budget System
Create Web base report by Web Analysis
Revise load rule for new data load format
Create MaxL script to automate data load
Design scheduled ETL Process by using IBM Infosphere DataStage to extract data from various transaction system and make data massage and transformation, export loadable data into Essbase
Design new OBIEE RPD and build data model based on Price Change Key Driver
Create Interactive Dashboard Report in OBIEE 11g to demonstrate Sales, Inventory by category, line and shop rollup level
Hyperion Planning/FDM Consultant Aug 2011 – Jan 2012
IBM GBS
Client: General Motor
Location: Detroit, Michigan
Project Description: Implement LEPA SA(Legal Entity Profitability Analysis South America) Hyperion Planning Project for General Motor Financial Budget System
Design Web forms for Forecast and Budget Exchange Rate manual load
Design Currency Translation Process
Create allocation Business Rules for expense accounts by Country of Sales and Volumes
Create Business Rule to make Currency Translation
Design Budget /Forecast Process based on GM south America Business flow
Create MaxL script to clear and load data into Essbase
Utilize SQL/PLSQL in Oracle Data Integrator 11g to build interface/package to make data load automatically
Use Oracle Data Integrator 11g to load metadata for Hyperion planning application
Make Data conversion/data loading and build System Data integration in ODI environment: created business rules for data interfaces (mapping), and technical implementation (flows), set operators, temporary table as sub-select. Created packages and worked on different load scenarios, defined mappings between sources and targets using ELT approach. Built load plans and execute scenarios
Create Smart View template to validate the data and upload exchange rate
Coding Excel VB scripting and make transformation template
Define import file format and setup Mappings for Brazil SAP and Andean SAP location
Design Automate process in FDM on Import Validate and Export and load to Essbase
Define Business rule in BRControl table for Budget, forecast and Actual
Design Account and Production Hierarchy from Hyperion DRM system and export Dimensions from DRM and import into Planning Application
Create Financial Reports by using Financial Report Studio and Web Analysis
Create Interactive Dashboard Report in OBIEE to combine Cube information with other relational transaction database
Integration test between SIT, UAT
Support LEPA SA system Go Live
FDM/HFM/Planning Consultant May 2011 – July 2011
Deloitte Canada
Client: MAGNA
Project Description: Implement Interface module between HFM and Planning/Essbase by using FDM
Collection both HFM and Planning interface format and understand existing data
Design Input and output interface definition for MAGNA HFM and Planning System
Design FDM script to run calculation script to extract Budget/Forecast data from Essbase
Programming Import script and Batch script to run the batch load to load data into HFM
Validate data on HFM
Hyperion Planning/Essbase Consultant Oct 2010 – May 2011
Client: TD Bank Financial Group – BI & Data Warehouse Team
Project Description: Enterprise Management Reporting System
Meet with Business Departments and collect requirement
Create ASO cubes for TD Wealth, TD Security, TD Canada Trust, TD Insurance, TD US applications
Design outline, dimensions, business rules, load rules, report scripts.
Create MaxL, VBScript, Java code to automate cube refresh and data load
Create CA7 jobs to schedule all of cubes fresh
Create Python Scripting for batch processing
Develop Financial Report and Web Analysis Reports
Act as Essbase DBA to support Hyperion System 11.1.1.3 system
Support ASO and BSO Cube migration
Optimize ASO Cube and BSO Cube
Deploy Essbase applications within BAT/PAT/Prod into Production
Developer Java code Essbase Java API to extract security filter.
Migrate Hyperion Planning System between various system
Modify Business Rule and Webform, SmartView to meet business requirement
Make Migration and DRP plan for TD Hyperion full system
Upgrade to Hyperion 11.1.2 from 11.1.1.3
Hyperion Financial Management Consultant Aug 2010 – Sep 2010
Client: Dana Corporation
Project Description: Hyperion Financial Management Project to support and transition
Act as HFM Admin to support both Financial Closing and Forecasting
Metadata Change update on HFM
Update Data Grid and Data Form, Smart View input template.
Utilize Process Management to activate or deactivate Entity
Manage period to support journal loading and posting
Change or update Business Rule to support system on-going
Run translation/calculation/consolidation for closing and forecasting
Document Run-Book and System-Appreciation-document to interpret system
EPM Financial System Analyst May 2010 – July 2010
Company: Trican Well Service. ( http://www.trican.ca )
Project Description: Hyperion Financial Management Project to go live and Support Hyperion Budgeting/Planning System
Act as HFM Administrator and SME to support HFM System go live
Configure and maintain Metadata HFM/Planning, FDM
Create Data Grid and Data Form, Smart View input template.
Build member list and maintain business rule
Design ETL script to make data conversion and load data into HFM from G/L system
Streamline Process Management
Extract Data with Extended Analytics from Hyperion Finance Management
Load journal and manage period to make adjustment
Maintain Business Rule
Run translation/calculation/consolidation
Make Change Management including acquisition and merger and peel entity
Organize support document of Hyperion System
Design and Modify Financial Reports by Hyperion Financial Reporting Studio
Create RPD and design answer query and dashboard in OBIEE
Hyperion Consultant Feb 2010 – April 2010
Client: Environment Canada. ( http://www.ec.gc.ca )
Project Description: Implement Oracle ERP Financial Project including Financial Consolidation and Budgeting System to support Statutory Reporting and Budget Management
Act as Hyperion EPM 11.1.1.3 DBA role
Install and Support Hyperion System 11 Planning/Essbase, FR/WA, FDM, ODI
Collect Business Requirement and design input template
Create Hyperion Workforce Planning Application and Financial Budget Planning application
Setup Security for Hyperion EPM System
Utilize SQL/PLSQL in Oracle Data Integrator to build interface/package to make data load automatically
Use Oracle Data Integrator to load metadata for Hyperion planning application
Make Data conversion/data loading and build System Data integration in ODI environment: created business rules for data interfaces (mapping), and technical implementation (flows), set operators, temporary table as sub-select. Created packages and worked on different load scenarios, defined mappings between sources and targets using ELT approach. Built load plans and execute scenarios
Use Oracle Data Integrator (ODI) to extract data from Oracle Financial system(Merlin) and Salary Management System(SMS) and setup load metadata and data into Planning/ Essbase
Design Multi-Dimension Cube and build dimension
Design Web Form and SmartView
Design Financial Reports by using Web Analysis and Hyperion Financial Reporting
Senior Consultant Oct 2007 – Jan 2010
Company: IBM Global Business Services, Financial Management Services (FMS)
Client: GuangDong YuDean Group Co., Ltd. (http://www.gdyd.com)
Project Description: Implement Oracle ERP Financial Project including Financial Consolidation and Budgeting System to support Statutory Reporting and Budget Management
Manage delivery team including internal user and external partner
Create Project plan, timeline budget and resource
Define project scope and requirement
Collect Business requirement
Streamline Budget process and point out the direction of improvement
Design YuDean Group Financial System Architect
Install Hyperion EPM System 11 including Hyperion Planning and HFM
Create Metadata and Business Rule
Create HFM Data Grid and Data Form, Smart view
Streamline process management
Create User/Role/Security
Load Data and Journal
Run translation/calculation/consolidation
Validate Data
Create Planning application
Create script/business rule, web form and smart view input template
Design load rule/report script
Designed and implemented ETL routines, loading data from heterogeneous sources in Hyperion Essbase
Utilize SQL/PLSQL in Oracle Data Integrator (ODI) to make data conversion and load metadata/data into Hyperion Planning/Essbase
Design budgeting and rolling forecast process
Generate Financial Reports by using Hyperion Financial Reporting and Web Analysis
Client:
Contact this candidate