Ran Dumpit

***** ************ ******* **, ************, NC 28078

adhw9a@r.postjobfree.com

770-***-****

PROFESSIONAL SUMMARY

Performance driven and result oriented BI/Datawarehouse professional with over 20 years of total IT experience of which 10 years of experience in design, analysis, development, implementation and administration in Hyperion applications.

Strong background implementing various applications in Client/Server environment using Oracle Essbase 11.1.2, 9.2,7.x & 6.x, Hyperion Essbase Studio, Hyperion Planning, Oracle Smart View, ODI, DODECA Spreadsheet Management System, Hyperion EPMA and HFM

Designed and developed efficient outline Aggregate and Block storage databases with excellent balance of Dense and Sparse dimensions.

Have extensive experience in Calculation Scripts, MDX, Excel VBA, Report scripts, and MaxL

Involved in Hyperion Applications Development and Production Support.

Experience in architecting complete data models combining multiple transaction systems ETL tools and relational and multi-dimensional data stores for star schema methodology and reporting tools using MS SQL Server, Oracle and DB2 relational databases

Possess ability and willingness for learning new applications as needed.

Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.

TECHNICAL SKILLS

OLAP: Oracle Essbase 6.1\6.5.4\ 7.1\9.3\11.2.2

Reporting Tools: Oracle Smart View, Excel VBA, Applied Olap/Dodeca

ETL Tools: SQL Server Integration Services, IBM DB2 Warehouse Builder,

Oracle SQL Developer, Oracle Data Integrator

Databases: IBM DB2, Oracle, SQL Server 2005/2000

PROFESSIONAL EXPERIENCE

DS Waters of America

HYPERION Financial Systems Manager Apr 2017 to Present

Development and Support of Hyperion Essbase GL/Sales and Expenses applications.

Report development using Applied OLAP DODECA spreadsheet management system and VBA in SmartView/ Essbase Excel Add-in.

Automate Essbase load, build and calculation using MaxL scripts

Compass USA

Hyperion Administrator May 2016 to Apr 2017

Performs Essbase/HFM administration including support of monthly periodic close process.

EPMA application deployments. Dimension loads and other HFM operational tasks

Troubleshooting/Enhancement/Modification of VBA automation scripts for HFM data load tasks, Consolidations, Extended Analytics and Essbase loads

Automate Essbase data load, build and calculation using MaxL scripts.

PGI Global/Avintiv/Berry Plastics

Hyperion Administrator Jan 2015 to May 2016

Performs Daily extract from various ERP using ODI, data load and to Customer profitability and GL application.

Created Essbase Excel report templates using SmartView VBA.

Automation of data extracts and loads using ODI and MAXL scripts.

DS Waters of America

Essbase Developer

Jul 2012 to Dec 2015

Development of Sales and Expenses cubes to load actuals, budget and forecast.

Development of VBA Smart View for reporting and uploading.

Automate Essbase load, build and calculation using MaxL scripts

ABBOTT LABORATORIES

Essbase Developer Mar 2011 to Jul 2012

Development of Budgeting, Sales and Expenses applications for the Global Pharmaceutical operations division.

Built data and dimension build rules, Data extraction process using SPSS warehouse builder.

Created Excel VBA templates for report extractions and planning applications

AMERICOLD LOGISTICS Jun 2005 to Mar 2011

Manager, Financial Systems

Development of Sales and Expenses cubes to load actuals, profit plan and expected actuals.

Built Calc scripts and Report scripts to import/export Essbase data. Essbase load, build and calculation using MaxL scripts

Created RPGLE and Embedded SQL programs to for ETL processes. Built Fact and Dimension tables using Star Schema.

MANHEIM AUCTIONS Jul 2004 to Jun 2005

Essbase Developer

Developed and maintained existing cubes. Modified ETL process that populates data sources for Essbase data and dimension loads using SHOWCase SPSS Essbase

Production support and maintenance of existing cubes.

YAMAHA MOTOR MANUFACTURING CORPORATION Apr 2001 to Jul 2004

Essbase Developer/ETL Developer/AS400 RPG Programmer/Analyst

Created Essbase applications, load and build rules, Calc script, report scripts

Created FTP scripts to transfer data from client to server and vice versa

Created ETL processes using IBM DB2 Warehouse Builder

Build, Create new ILE RPG applications, MACPAC ERP package modifications and maintenance programming

Contact this candidate