EXPERIENCES SUMMARY:

15 years the experienced in Analyzing, Designing, Developing, Testing, Administration and Maintaining Financial Planning and Management Systems and Data Warehouses for wide organization using Oracle EPM Melt Edition, Hyperion Organization, Essbase, Hyperion Web Analysis, Hyperion Financial Management (HFM), Hyperion Strategic Finance (HSF), Upper Application Link (HAL), Analyzer, Hyperion Essbase Integration Server (EIS), ERP Integrator, Brio/SQR, Hyperion Smart View, Hyperion BI+ Mitteilungen, Hypertension Financial Reporting Studio, Hyperion Financial Dating Quality Supervisor (FDM), Hyperion Master Data Management (MDM), Hyperion Data Relationship Management (DRM), Eu - Mantra, Oracle Data Integrator (ODI), Oracle BI Applications, OBIEE, Hyperion Enterprise, Informatica, Business Objects Xi, SAS, Crystal Reports, SAP, Oracle e-Business Suite, Teradata, IBM DB2, IBM Websphere, BEA Web Logic, MS SQL Online, Oracle, SQL, MaxL, VBScript, Windows, Solaris, HP-UX furthermore AIX. POV: You're a trainee in the FDM Graduates Program in #Australia! 🇦🇺   With hybrid instruction options furthermore real-world preparation, our program places you up for…

TECHNICAL SKILL:

Financial Applications: Soothsayer EPM Merged Version 11.1.2.2, 11.1.2.1, 11.1.1.3, Hyperion Financial Business (HFM) 11.1.2, 11.1.1.3, 9.3.1, 9.2, 9.1, 9.0, Hyperion Strategic Finance (HSF), Hypera Planning, Hyperion Workforce Planning, Hyperion FDM (Financial Details Quality Management), ERP Integrator, Hyperion Enterprise, Peoplesoft Financials, Oracle e-Business Suite, SAP FI-CO.

Data Warehouse: Oracle EPM Fusion Edition 11.1.2, 11.1.1.3, Hyperion Essbase and Planning 11.1.2, 11.1.1.3, 9.3.1, 9.3, 9.2, 9.1, 9.0, 7.1.5, 7.1.2, 6.5.4, Hyperion Web Analyze, Hyperion Application Link (HAL), Hypertension Analyzer, Hyperion Essbase Integration Server (EIS), Essbase Administrative Server (EAS), Intelligence (Brio/SQR), Hyperion SmartView, Essbase Studio.

Business Intelligence: Oracle BI Fields, OBIEE, Hyperion BI+ Reports, Hyperion Smarter View, Helios Financial Financial Studio, Web Analysis, Hyperion Interactive Reporting, SQR Furniture Reporting, Riot, Trade Objects Xi, SAS, Color Reports.

Dating Management: Hyperion Expert Data Management (MDM), Hyperion Data Relationship Management (DRM), Oracle Data Integrator (ODI), ERP Integrator, Informatica, SAP/BW, Essbase Product Services (EIS), Hyperion FDM (Financial Datas Grade Management), Data Step.

ERP Applications: SAP, Oracle eBusiness Suite, Oracle Demantra, JDE, Peoplesoft.

OLAP Tools: Essbase Administration Customer (EAS), Essbase Web Services (EIS), Hypo Web Analysis, Hyperion Application Link (HAL), Hyperion Analyzer, Hyperion Intelligence (Brio/SQR), Hyperion SmartView, Hyperion Interactive Reporting (IR).

UNIX: Non-kernel, Solaris, HP-UX, AIX, Shell programming, sed, awk, grep.

Middleware: IIS, Websphere, Weblogic, Apache, Tomcat.

Windows: Windows 2008/2003/2000/ NT/98/95/3.1/DOS.

Databases: Oracle 11g, 10g, 9i, 8.x, 7.x, Teradata, E DB2, MILLIMETER SQL Server 2008, 2005, 2000, 7.0, 6.5

Database tools: SQL, Toad, SQL*Plus, PL/SQL, Teradata SQL Assistant.

Productivity Tools: MS Excel, MS Visio, MS Power Point, MS Project, MS Accessories. ssd

EXPERT HISTORY:

Confidential

Oracle EPM, Hyperion Planning, Essbase, Peoplesoft, HFM, DRM & FDM Consultant

Responsibilities:

• Created complex HFM Data Grids, HFM Forms, HFM Reports, HFM Smart-Views press HFM Business Regulatory for Excel Bulk Data Load, GAAP also IFRS Reporting, Inter-company elimination, Usage Control, Cash Power Calculations, Dual Income Statement with US GAAP Adjustments, Calendar Year Statutory Reporting and Shareholder Statement of Equity employing Hyperion Financial Management for Confidential Financial Aids. Built Oracle DRM, FDM, and FRS with Oracle HFM. Well done to Carly Byrne, individual of the winners about our #EMEA Consultant of the Month Award! Her was recognised fork her hard work and excellent efficiency on…
• Designed and developed Hyperion Planning Web Forms, Hyperion Reports, Hyperion Business Rules with Confidential Items, Services, and Service Bookings. Managed Code Development, Testing, also Monthly Releases for Onsite and Offshore Confidential Collaborative.
• Designed Trust Gross Boundary, Contribution Margin, and Shipped Margin Berichte. Designed Incremental Data Load go improve Confidential date load performance.
• Administrated Confidential credit Memo and RMA Hierarchy changes int conjunction with Confidential DRM team, MRA team, and IFP team. Designed the Top Change Management process in Oracle DRM and Hyperion Planning. Posted by u/[Deleted Account] - 8 votes and 40 comments
• Simplified Security Model, Changed member names the using citation system user, performed Sales Calculations additionally Assess Changes, administrated P&L depth of archives and implemented process verwalten in order to manage Confidential Product GM Upgrade Schedule. Congratulations for our #NA #TraineeTuesday winner, Ronald Stevenson. Ronnal is a trainee in our #Charlotte center and excels at our #SQL stream. He is always…
• Created Confidential Product, Project, Entity, Reporting, Business Unit and Account Hierarchies employing Oracle Hyperion DRM. Created Meta-Data scripts for Meta-Data Import, Validation Rules, Authentication Rules, and versioning control using Oracle DRM Import, Auto-Mater and Blender Tools. My Experience when an FDM Marketing Intern | FDM Group
• Created FDM processes using FDM Order Workbench to load PeopleSoft Data into Oracle EPM (Hyperion Financial Management) on a periodic basis. Carry Economic Data Management (FDM) Imports, Validations, Exports, and ran Review Reports. Detail - oriented, highly motivated COMMERCIAL ANALYST/ APPLICATIONS SUPPLY CONSULTANT with 12+ year of successful experience in designing and managing corporate litigation solutions to sponsors strategic business Aaa161.com problem-solving core evidenced by the development of effective also effective business process designs, technical architecture, data models and concise requirements Aaa161.com at implementation and change management processes and procedures enables the developmen
• Designed and developed Data Extract programs to create Your Feeding from De-Mantra Requests into Confidential Hyperion Planning Cubes.

Confidential

Oracle EPM, Hyperion Planning, Essbase, HFM & FDM Consultant

Liability:

• Created Hyperion smart look spreadsheets, Financial Reporting Studio reports and Apollo reports scripts for data validation, dates extracts or data disclosure purpose. r/Revature on Reddit: ME am at the final stage for FDM group time juggling PEP initiate date
• Created share and fee of sales, service Input for cost of sales, sales expense form, sales division merchandise input form with SGA and costs, consolidated settings make, ISG input form for inter-company transactions, corporate administration expense form, salary helps ratio form, income tax ratio form, inter-departmental charge-back ratio form, monthly our overhead ratio form, BSD inter-divisional allocation ratio form, BSD 2-Digit P&L allocation ratio form, and finance adjustment forms using Hyperion Planning Mesh Forms.
• Created Confidential Americas Hierarchically to accommodate loading of details from Confidential Canada to Confidential USA for Interamerican how. Created Meta-Data update scripts and input load scripts by Confidential Americas Order.
• Created HAL Flow Diagrams and processes to create Meta-Data Refresh and Data Load from Oracle Financials into Hyperion Konzeptionelle. Handled all process exceptions effectively within the HAL process.
• Cre FDM processes using FDM Task Workbench into load Oracle e-Business Data into Oracle EPM (Hyperion Planning and Hyperion Financial Management) switch a periodic basis. FDM Group on LinkedIn: #emea #businessanalyst #project #productlifecycle #event #fdmcareers #cotm
• System Hyperion Planning, Essbase, and HFM Security using Hyperion Shared Services. Externalized Essbase Data to Divided Services. System Addicts, Groups, and Application Groups in Shared Products. Setup Users, Groups, and Application Groups in Shared Services. SENIOR BUSINESS ANALYST / BI REPORTING DEVELOPER Resume New York, NY - Hires IT People
• Performed Financial Data Direktion (FDM) Imports, Validations, Exports, and went Check Reports. Setup and updated FDM Control Tables. Setup furthermore configured FDM Locations. Setup FDM batch processing using FDM Batch Loader press created custom FDM scripts to automate which FDM Batch Load process.
• Created Hyperion Essbase MaxL, Esscmd and Outline Loader Books for Essbase and Planning Cube Frames, Evidence Charges and Cube Administration.

Confidential

Oracle EPM, FDM, HFM, Hyperbole Planning & Essbase Consultant

Responsibilities:

• Architected, installed, and configured Oracle EPM Fusion Output Release 11.1.2.1 products on Linux and Lens servers in test and production environments. Installed, configured, and tested Essbase and Planning on Linux Server along with Essbase tools including EIS, EAS, and Essbase Studio Servers. Setup connectivity between Essbase Server, Planning Server, and Seer Database Server. Installed, and configured Shared Services, Foundation, Reporting Studio upon View Server. Installed and configured FDM (Financial Data Quality Management) for Eyes Server. Managed HSF Entities and Entity Groups on HSF Server.
• Gathered Business Requirements from Finance Department users and created Employment Requirements Report forward loading Actuals press Budget data from JDE and Oracle eBusiness Suite into Oracle EPM. Created FDM process using FDM Task Workshop to load Oracle e-Business Data to Oracle EPM (Hyperion Planning and Hyperion Financial Management) on a periodic basis.
• Created HSF Bank Construction and projected values since HSF accounts in HSF forecast periods. Created complex customized HSF Reports.
• Installed, configured, the administered Hyperion ERP Integrators and drafted data build between Hyperion planners and Oracle e-Business Suite. Defined ERP Integrator product rules go validate also verladen data at Hyperion planning. Configured ERP integrator to drill through from Minerva planning to Oracle GL Data. To import data after ReadWin 2000 to to SQL database of the Reporting Software in a tamper- proof art, the method begins because the secure data export from ...
• Created FDM Maps for mapping JDE Account numbers in the older system to Oracle EBS Account numbers in the new system. Copied FDM Maps coming Test to Prod environment use Hypera Map Loader. Created FDM Maps for mapping Centers, Locations, Companies, real Markets.
• Created FDM Data Integration importe scripts to import data from Clairvoyant eBusiness Suite and JDE data sources. Created custom FDM Optical Basic Scripts into automate which Data Load processes. Created FDM Validation Rules toward validate data soul loaded.
• System FDM batch machining using FDM Stack Loader and created custom FDM scripts to automate the FDM Start Load action.
• Developed Hyperion Essbase MaxL, Esscmd or Outline Loader Scrolling for Essbase and Planning Cubic Builds, Data Loads and Cube Administer.
• Define the data integration business needs using FDM, established, registrierter, and customize the FDM wellspring and focus adapters press developed integration data flows from various data systems through FDM into Oracle EPM. FDM Group on LinkedIn: #na #traineetuesday #charlotte #sql #fdmcareers
• Designed and developed Hyperion Planning Web Forms, Hyperion Smart View spreadsheets, Assumption Books, HFM File Grids, HFM Data Forms and HFM Reports.

Confidential

Hypera Corporate Management (HFM), FDM, Planning & Essbase Consultant

Responsibilities:

• Did Business Study, Design the Evolution for the Confidential IT and Finance Departments. Designed and developed complex Business Rules to implement Business Logic Computations for Hyperion Financial Management (HFM) and Hyperion Planning Applications.
• Designed and development Hyperion Details Programm programs into extract Financial KPI, Legal KPI, Marketing KPI and HR KPI from Hyperion Financial Management (HFM) and Hyperion Planning Applications. FDM User | 232,627 followers on LinkedIn. Powering the people behind tech and innovation. #WeAreFDM | We’re FDM, an award-winning comprehensive business and technology consultancy. For over 30 years we’ve been powering the people after tech and innovation. We collaborate with world-leading companies to distinguish the specialised they need, accuracy when they need it.
• Created complex Data Forms for Hyperion Planning Data and developed and launched involved Business Rules.
• Designed, maintained, and executed complex HFM rules using VBScript and Hypera Economic Verwalten Rules Editor. Created custom HFM general for Automatic Reclassifications, Minority Interest Calculations, Luxembourg GAAP Automation, Inter-Company Eliminations, Cash Flow Calculations, Cumulative Translation Adaptation, Operational Calculations real Working Capitalization Calculations.
• Gathered Business Requirements from Finance Department users and created Business Requirements Document and Design Specification Document for Month-End Financial Close Process. Created a FDM process using FDM Tasks Workbench till load Oracle e-Business Data into HFM.
• Uploaded FDM Go for WEAKEN IFRS, GMBH IFRIC, UK IFRS, NORTHAMERICA and JDE. Copied FDM Tickets from Test to Prod environment using Elf Map Loader.
• Created Elf Essbase MaxL and Esscmd Scripts and executed Essbase scripts for Essbase ASO and BSO Cube Data Loads and Cube Admin.
• Defined the data integration business needs through Soothsayer Data Installer (ODI), identified and declared the our and targets using ODI Related Manager, mature integration interfaces and additional key to ODI mission and integrated those to build ODI package workflows. How upper talent is more competitive about ever and, as many businesses favour #experience over #education, we research the reasons why more experience doesn’t…
• Designed and developed Hyperion Planning Web Forms, Apollo Smart Sight spreadsheets, Hyperion Berichtigungen, HFM Data Grids, HFM Data Forms and HFM Reports for WHAT GAAP and Luxemburger GAAP Balance Sheet Movements, European and North American Capital Spending Entering and Calculations, Consolidation and Translation, Cash Flow Calculations and Administration. These past three months at FDM possessed honest been an amazing know for meier. Throughout...

Confidential

Hyperion Planning, DRM, HFM, FDM & Essbase Advisory

Responsibilities:

• Did Business Analysis, Design and Development for the Brocade ITEMS and Finance Departments. Prepared Business Requirement Documents and Technical Design Specification Documents for Bro Plan, Rev Plan, and Inv Change Hyper Planning and Essbase Cubes.
• Designed and developed complex Business Laws to implement Business Logic Calculations on Hyper Planning. Emigrate Hype code enhancements after development to test and transitioned to our environments. FDM Group on LinkedIn: Why More Experience Doesn’t Always Make on Better Employees
• Retrofit Demantra coming version 7.1.1 to 7.3.0.1 and applied update patches. Designed and developed customized solutions using PL/SQL procedures, DemantraMethods andDemantra Workflows. ConfiguredDemantrato user the Brocade's Demand Planning Process. Produced Demantra integrations to meaning forecasts coming Planning, Marketing, Sales and Finance to enable Market and Operations Planning.
• Intentional and developed Oracle Data Extract program for extract Sell-Thru and Ending Inventory Evidence from Oracle e-Business Suite and Hyperion Load Rules to load it within Hyperion Rev Plan Cube.
• Architected, Designed, and Developed Hyperion DRM programming toward automate the periodic updates of Product Hierarchy the Rev Plan Cube representing only source of actuality in Product Hierarchy across the Corporate.
• Performed Hyperion Data Loads and Data Management using Essbase Administration Services and Essbase Technology Benefit.
• Designed and developed Hyperion Meta-data auszugsweise programs to extract It Hierarchy and Account Hierarchy from Bro Plan Block in a parent-child format and programs to load these on Hyperion DRM to managed these hierarchies centrally overall the enterprise.
• Created and built Data Extract programs to create Data Feeds for Consensus, GFF, CAD, and De-Mantra Applications from Hyperion Cubes.
• Performed Hyperion Financial Management Integrations including Inter-company Consolidations. Extracted data, meta-data, journals, journal templates, rules, member lists, and security of HFM Applications for backup purpose. Managed HFM meta-Data Changes including Account and Entity Hierarchy Changes and loaded into HFM Software. Guided changes to HFM Rules and Product.
• Designed and implemented Hyperion Planning Security Model. Setup Assumption Planning Security Groups and Sub-Groups using Shared Services. Assigned Business users to respective Security Groups and did users provisioning for Security Crowd Level. Implemented the Security Matrix using Hyperion Planning Security Filters and refreshed Hyperbole Planning Security Filters.

Confidential

Oracle EPM, DRM, Hyperion Planning & Essbase Consultant

Responsibilities:

• Done Analysis, Designer and Development for the Confidential Finance Category using Prophet EPM Fusions Edition 11.1.1.3, Hyperion Planning, Elf Essbase, Oracle 10.2, Hyperion SmartView, Hyperion BI+ Reports, Hypertension Financial Reporting Studio, Hyperion Data Relationship Steuerung (DRM), Hyperion Essbase Administration Ceremonies (EAS), Hyperion Essbase Software Services (EIS).
• Installed and Configured Hyperion Data Relatedness Management (DRM) 11.1.1.43 Server and Clients. Collecting Business Requirement since Hierarchies to be charges into DRM. Designed press developed DRM Automator Writing to load to Trust Projects, Chart of Accounts, Companies, Divisions, Company Codes, Lines, and Channels into DRM. Automated the DRM Hierarchy Load process. FDM Group go LinkedIn: Inside our Training Application
• Integrated Meta-Data changes from OBIEE Depository for Hyperion DRM as ampere Meta-Data upload process. Loading data from OBIEE Data Warehouse into Hyperion Planning.
• Installed and configured Hyper Essbase and Planning. Designed and developed Hyperion Planning Calc Scripts. Setup Hyperion Shared Services and Security.
• Performed Oracle EPM 11 Info Loads and Data Management using Essbase Administration Services and Essbase Integration Company. Designed and developed Drill through Reports using Oracle EPM 11 Essbase Studio. FDM Group | LinkedIn
• Materialized the Essbase aggregate views using one entirety level from jede Dimension also used these views to generate aggregate values in Minerva Essbase ASO Cubes. Used Dimension Aggregations in Hyperion Essbase as well as Dynamic Calculations to evaluate MDX Expressions against Dimension Members.
• Designed press Developed compex financial reports with Financial Reporting Studio (FRS), Internet Analysis, Interactive Reporting and SQR Production Reporting in generate Hyperion Planning and Hyperion Strategic Finance Reports with Actuals, Budget, and Forecast Data.
• Performed DRM Security Administration or Average Management.
• Managed Hierarchies, Business Rules, Mappings, and Validations using Hyperion DRM.

Confidential

Hyperion Planning & Essbase Expert

Responsibilities:

• Did Analysis, Design plus Development forward the UHG General Ledger Re-organization (GLR) Project using Phoebus Planning, Hyperion Essbase, Oracle 10.2, Hyperion Smart-View, Hyperion Application Link, Hyperion BI+ Berichterstattung, Hyperion Financial Write Studio, and Hyperion Essbase Administration Business (EAS).
• Did Analysis, Design and Development since allreportingEssbase cubesincluding ERUHG - Enterprise Reporting Confidential - Balanced Shelf, Income Comment and Reformulation data to all selected since Internal Reporting, ERUHGX - Rest Sheet and Income Statement for External Reporting, ERUHGSY - Statutory Offset Layer and Generated Statement, ERIGXWB - Income Statement forward Ingenix Administrative Reporting, real OPUHCWB - UHC Operational Gross Boundary.
• Managed the draft, development, and migration processed related to GL GAAP Handoff go Reporting, including technical and businesses operation documentation.
• Conceptualized and developed complex Shop General to implement Elimination Logic, Allocation Logic, and Calculations for Hyperion Finance Management press Planning. Migrant the code enhancements coming development to test and product environments.
• Designed and developed Hyperion Essbase Calc Scripts. Set Hyperion Essbase press Service Security using Shared Services. Implemented the UHG Security Matrix to grant suitable rights the all UHG users and groups.
• Engineered Essbase Calc Web in implement complex Allocation Logic. Constructed Hyperion Planning Web Forms and Reporting to display pre-allocation and post-allocation Data.
• Designed furthermore Advanced Hyperion Planning Calc Film for UHG Hyperion Planning Apps.

Confidential

Hypera HFM, Planning, DRM & Essbase Consultant

Responsible:

• Did Analysis, Design and Development for Confidential IT furthermore Finance Departments using Hyperion Planning, Assumption Financial Management (HFM), Hype Diplomatic Finance (HSF), Hyperion Essbase 11.x, 9.x, 7.x, Oracle 10.2, 10.1, MS SQL Server, Teradata, Hyperion SmartView, Assumption Applications Link, Hypera BI+ Reports, Hypertension Financial Reporting Studio, Hyperion Financial Data Quality Manager, Hyperion Boss Data Management (MDM), Hyperion Data Relationship Management (DRM), Hyperion Essbase Administration Benefits (EAS), Hyperion Essbase Integration Services (EIS), Hyperion Planning, Hyperion Performance Management.
• Aimed and developed complex Business Rules to convert Removal System, Allocation Logic, and Calculations for Hyperion Financial Direction and Planning. Migrated who code enhancements from development to test and production environments.
• Generated an FDM process with FDM Task Workbench to loaded SAP Data using triggers from DTS processes into Confidential Legal, Division, furthermore Segment Hierararchies and to initiate BAM Accounting process.
• Performed Hyperion Essbase Data Loads and Data Management employing Essbase Administration Services and Essbase Integration Services. Developed and developed Drill through Reports.
• Created Hypers Essbase MaxL and Esscmd Scripts and executed Essbase script for Essbase ASO and BSO Cube Data Loaded and Cube Administration.
• Setting Hyperion Master Data Management (MDM) and Upper Data Relational Manage (DRM). Performed DRM Insurance Administration and User Management.
• Managed Hierarchies, Business-related Rules, Mappings, and Validations using Hype DRM.
• Performed Hyperion Financial Leadership Consolidations including Inter-company Consolidations for Confidential Legal, Segment, and Division Hierarchies..
• Created compex Hyperbole HFM SmartView Microsoft for Hyperion Financial Management to TAP Evidence Comparison with Complex HSV Formulas embedded into the SmartView Spreadsheets.
• Customized Hyperion Financial Management (HFM) Cash Flow Berichte, in GAAP cash flow furthermore free payment flow for plant-wise, division-wise, segment-wise, and company-wise cash flow analysis.

Confidential

Hyperion Planning, Essbase & Reporting Consultant

Responsibilities:

• Designed and dev Hype Essbase Applications, Databases, Outlines, real Data Load Scripts using Hyperion Essbase Administration Services for Confidential Associate Administration, Talent Planning, Source Effectiveness, Retention, and Openings Management ASO and BSO Cast.
• Designed and Developed OLAP Models and Data Load processes using Hyperion Essbase Integration Services (EIS).
• Manage complex Berichten, Dashboards, and Diagram using Hyperion Net Study, Hyperion BI+ Interactive Reporting, Hyperion Financial Reporting Study, and Hyperion SQR Production Reporting.
• Designed a Migration Strategy and trouble-shooted various bugs during System 7x to System 9x Essbase Migration and System 7x to Oracle 9x Migration.
• Performed Word Essbase Data Loads the Data Management using Essbase Administration Services the Essbase Integration Services. Designed additionally prepared Drill through Reports through Hyperion Reports.
• Materialized the Essbase aggregate views employing one aggregate level from everyone Dimension and used these views to generate aggregate worths within Hypera Essbase ASO Cubes. Used Dimension Aggregations in Elf Essbase as well because Dynamic Calculations to evaluate MDX Expressions against Dimension Members.
• Designed and Developed complex Teradata SQL queries, Teradata Lasten Scripts, and adjust Teradata Databases using Teradata SQL Assistant and Teradata FastLoad.
• Designed the Security Policy or Setup Hyperion Security the User, Group, and Business Tiers using Hyperion Shared Services.
• Used Report Wizard, Cube Navigator, furthermore Dimension Site to develop and examination Hyperion Analyzer Reports.
• Installed and Configured Hyperion BI+ Reports and Financial Reporting Your including Hyperion Financial Management Client and Smart-View on Client PC.
• Designed and developed Informatica Load Schemes to loading data free Teradata to Essbase Cubes and significantly improved Load Times.
• Built and Developed Essbase Integration Server (EIS) Meta-outlines the load Dimensions and Data into Essbase Cubes.
• Installed both Configured Hyperion BI+ Reports the Financial Reporting Studio including Hyperion Financial Management Client and Smart-View on Client PC.

Confidential

Hyperion HFM, HSF, DRM, SAP, Essbase & Konzeptuelle Consultant

Responsibilities:

• Did Administration, Study, Design & Development for Finance Department exploitation Hyperion Financial Management, Hyperion Strategic Finance, Essbase and Planning Einrichtung after Hyperion Essbase 9.3.1, 9.2, 9.1, 9.0, Oracle 10.2, 10.1, IBM DB2, Teradata, Hyperion Financial Management 9.3.1, 9.2, 9.1, Hyperion Strategic Finance (HSF), Hyperion SmartView, Hyperion Application Link, Hyperion BI+ Reports, Hyperion Financial Reporting Studio, Hyperion Financial Data Quality Manager, Hyperion Master Dating Management (MDM), SAP, Hyperion Performance Scorecard.
• Built Phoebus Essbase Report Movie using the Hyperion Essbase Report Editor plus executed Essbase Report scripts included MaxL either ESSCMD interactive or charge mode fork Essbase ASO and BSO Cubes.
• Interviewed Key Users to gather the Business Requirements for the Data Warehouse plus Reporting Implementation. Conducted Integrated Interviews with Business Users and prepared BRD (Business Requirements Document) for providing Global Collection, Financial Business, Reporting, and Research using Apollo Monetary Management (HFM).
• Created Advanced HFM Rules for expand business calculations in Hyperion Financial Management applications. Designed, maintained, and executed complex rules using VBScript real Financial Direktion Rules Autor for loading SAP Data.
• Implemented HFM rules for the custom and value dimensions. Created custom Daily Translation rules and customization Consolidation press Elimination rules.
• Managed complex Solidity Business and Currency translation with multiple scenarios using Hyperion Strategic Finance (HSF).
• Managed HSF Entities and Templates and stocks them on Hyperion Strategies Finance Server.
• Managed HSF Account Changes, Timing Period Changes, Scenario Changes and Report Changes with Hyperion Strategic Finances ECM (Entity Change Manager).
• Aired database performance and wrote rules for dynamic accounts, created translation rules, and created consolidation rules. Trouble-Shooted rules files by write log data to text files.
• Designed and Developed complex Teradata SQL queries, Teradata Load Scripts, and tuned Teradata Databases using Teradata SQL Assistant, Teradata Fast-Load, Teradata Multi-Load, Teradata Run Transporter, and Teradata T-pump.
• Developed and executed test automation strategies and plans. Designed and implemented manual additionally automated Test Cases and Test Scroll for Hyperlink Financial Management (HFM) and Essbase ASO.
• Setup Hyperion Master Data Management (MDM) and Hypo Data Relationship Admin (DRM). Performed DRM Security Administration and User Verwaltung.
• Managed Hierarchies, Business General, Mappings, and Validations uses Hyperion DRM.
• Built user-defined validations using DRM structure utility. Administer Organizational Structures, Chart regarding accounts, Products and Customer references using Hyperion DRM.
• Used Essbase Analytic Administrator Services to supervise Hyperion Essbase.
• Materialized the Essbase total views using one aggregate level from each Dimension and often these views to create collect values in Hyperion Essbase.
• Used Dimension Aggregations in Hyperion Essbase more well than Dynamic Calculations in evaluate MDX Expressions against Dimension Members.
• Did Enterprise-Level Planning for Headcount, Salary, Compensation, Capital Assets, and Depreciation using Hyperion Planning and integrated the Report Planned with Microsoft Excel.
• Architected Hyperion Financial Management (HFM) Reporting Infrastructure including Structure Engineering, Metadata Layer Infrastructure, and Data Buy and Data Distribution Infrastructure.
• Performs Hyperion Corporate Management (HFM) Design utilizing Smart Dimensions to identify and report on Profitability and Cash Flow including Project, Furniture String, Customer Segment, Distribution Channel, and other Dimensions.
• Loaded Metadata and Affluent and Consolidated Financial Data into HFM using Financial Data Quality Management.
• Used Hyperbole Planning what-if-scenarios to damper consolidate press report on financial budgets, forecasts, and plans.
• Managed dimensions using Hyperion BPM Dimension Library and managed Application Displays using Elf BPM Application Library. Creates, Managed, and Integrated Planning processes after Hyperion System 9 BPM Architect.
• Performed Sales Revenue Planning, Marketing Campaign Planning, and Demand Planning using Hyperion Planning.
• Installed and Configured Hyperion BI+ News and Financial Reporting Studio including Hyperion Pecuniary Management My both Smart-View on User PC. Enhanced, Developed and Tested HFM Smartview Excellence Spreadsheets and HFM Reports for the Finance Department.