SUMMARY

• 14 Plus years of rich IT experience including proven track record in Hyperion Administration, Hyperion Planning/Essbase,
• ODI, FDM, HFR, Oracle and Java/J2ee related Software Development Life Cycle including development, analysis, design, development, testing, integration, deployment & implementation.

TECHNICAL SKILLS

OLAP, ETL, ELT and OLTP tools: Oracle Hyperion Planning 11.x/9.x/7.x/6.x, Essbase Administration Services (EAS), Analytic Integration Services (AIS/EIS), Smart view for Office, Excel Add - in, Oracle Data Integrator(ODI), EPMA, DRM, Oracle Financial Data Quality Management (FDQM), Financial Reporting FHR, Smart View and Essbase Add in.

Modeling Tools: Star, Snowflake schemas and Dimension - Fact tables.

Programming & Scripting: SQL, PL/SQL, Shell Script, Java, XML, VBA Scripting, C, C++, JavaScript, VBScript, ANT Scripts, Maxl, Windows Batch and Unix Shell scripts and JIL.

Servers side & DB: Servlets, JSP, EJB, JDBC, Struts, Web logic, IBM RAD, Jboss, Oracle, DB2, MS SQL server and PostGre SQL.

IDE’s & Utilities: ODI Integrator console, Oracle Toad, Blat, Eclipse, Intellij Idea, Builder, Junit

Operating Systems: Unix / Linux, WINDOWS 2003/2008R2/NT/XP

Design/ Version control: Rational Clear Quest, FogBugz

PROFESSIONAL EXPERIENCE

Confidential - Dallas TX

Hyperion Administration

Responsibilities:

• Migration of Essbase models from 6.5 to 11.1.2.4 and translate all XLS based auto actual loads to a UNIX approached flat file CSV loads.
• Functioning as a single point of contact for the business / Production support / Strategy towards Hyperion applications maintenance and enhancements.
• Maintenance of user security and troubleshooting user access issues as they arise.
• Backup and Recovery of Hyperion applications. Scheduling backups and backup strategy.
• Smart View related troubleshooting. Architecting the solutions and needs of analytics environment..
• EBS Data Integration in to Essbase and help consolidate data.

Confidential - Richmond VA

Hyperion Administration, Integration, Planning and Essbase Technology SME

Responsibilities:

• ASO cube compression and optimization and Migration of ASO and BSO apps from 11.1.2.1 to 11.1.2.3
• Establishing metadata governance and process cycle for Metadata integration between JDE and Essbase.
• Automation of Actual load process from JDE and different source systems and making a unified Actual load.
• Built 30 plus financial reports using financial reporting studio tool, security setup, setting batch processing, setting email distribution list templates, reports migrations between environments.
• Designing Metadata extract automation from Oracle ERP system and performing ETL before building Metadata on GL BSO/ASO and Planning application.
• Maintenance of Essbase 11.1.2.1 services in UNIX Solaris machines and upgrade estimation to 11.1.2.3 in Red Hat Enterprise Linux 6.4.

Confidential Waukegan, IL

Sr Hyperion Administration, Integration, Planning and Essbase Technology SME

Responsibilities:

• Administration and Infrastructure activities like installing and restarting services 11.1.2.1 on Windows Server 2008 with load balancing with server patching.
• Seamless data visibility and movement to users by designing solution which uses Transparent and Replicated Partitions on BSO-BSO and BSO-ASO cubes.
• Automated scripts to perform DB restructures, partitions refresh and every day calculations on various Sales, GL, Head count cubes using MAXL and Windows batch scripts. LCM related daily batch scripts.
• Development & setup of Version, Hierarchies, properties, property query, Automatons, import, Blend, exports, system & property categories in DRM.
• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget cycles and Actual loading cycles and other variance calculations.
• Replacing the Legacy system (Hyperion Application Link) using Oracle Data integrator and automated the process for periodic dynamic dimension building and data loading.
• Migrating application from Essbase 7.x, 9.x version to Essbase 11.x version ( Oracle EPMA)
• Automation of the Dimension building process on Enterprise PMA shared library, Validation, Deploy activity from Planning to Essbase using EPMABatch client and Interface tables.
• Integrated ODI mappings and translations with Oracle Data Relationship Management (DRM) to support meta-data management approach to maintaining account and entity hierarchies.
• Using Oracle Financial Data Quality management tool, Designing and implementation of the ETL process (Extraction from source, Transfer using the mappings and Load i.e. Export to Essbase environment), thus providing Auditing capabilities through FDQM tool of the data flow to the Oracle Hyperion Essbase.

Confidential Lincolnshire, IL

Hyperion Administration and Hyperion Developer

Responsibilities:

• Installation, Configuration and maintenance of System 9 and System 11 EPM Products like Shared Services, BI+ Products (Workspace, Financial Reporting and Web Analysis).
• Lead the System 11 (Fusion) Upgrade project on technical front.
• Maintain outline, Metadata, member formulas and data load as per business cycle requirements.
• Created Calc Scripts using the Calc Script editor for performing calculation. Automation using MAXL Scripts and scheduling batch scripts for automation. HAL utility to build Metadata.
• Worked on the performance tuning (Cube Optimization) of the Applications for the fast data loads, better calculation times of the cubes and fast retrieval of the reports using the Dense/Sparse settings, Cache settings, Outline formulas and Calc scripts.
• Designed & developed new reports using Hyperion Financial reports as required.

Confidential, Cincinnati, OH

Hyperion Developer

Responsibilities:

• Created application, database and build dimensions dynamically using rules files as per business needs.
• Created new batch jobs and scheduled these batch files for complete automation process for nights and weekend’s calculations and backups.
• Prepared Profitability Reports, Unit Cost, Price/Volume Trends, and Expense Variances over prior periods.