OBJECTIVE

• Avid, Inventive, Focused, Multitasking, Hardworking Oracle EPM professional with 6 Years of experience in OLAP tools, Master Data Management, ETL, Data warehousing, Business Intelligence, Database and Automation skills on large scale implementations.
• Determined by creative, powered by strong technical knowledge to resolve complex business problems and having good interest in learning new technologies.

SUMMARY

• 6 years of Professional IT experience in design, analysis, development and implementation of various applications in Hyperion suite of technologies.
• Extensive knowledge on Hyperion Planning, Hyperion Essbase, Hyperion Shared Services and Financial Reports.
• Knowledge in Tuning, Optimization of cubes, MaxL, Batch scripts and complex calc scripts.
• Hands on experience In Creating/Supporting EPMA and Classic Hyperion Planning Applications.
• Created user groups in teh Planning applications and assigned security to different groups, dimensions and web forms depending on teh client requirement.
• Worked extensively on Essbase BSO and have good knowledge in ASO.
• Designed and developed Essbase Multi - Dimensional Database cubes and various OLAP application models using Hyperion 11.x
• Knowledge on different types of partition in Essbase.
• Implementation/Support on 11.1.2.3 and 11.1.2.4.
• Hands on experience in Application backup activities and migration of applications across environment using LCM mechanism in Hyperion Shared Services.
• Developed Data forms using Hyperion Planning for teh users to input Forecast, Budget, Actual data.
• Created dimensions in EPMA shared library and creating EPMA applications from application library, Deploying and comparing teh applications.
• Expertise in developing Task Lists, Menus, Calc Manager/Business Rules, User Variables, Smart Lists, application management and troubleshooting
• Formidable knowledge in building planning models using Hyperion Planning, Hyperion Business Rules, Hyperion Financial Reporting
• Developed numerous cubes from conceptual stage, designed OLAP models with excellent balance between Sparse and Dense Dimensions and better usage of member storage properties
• Robust knowledge and experience in Essbase cube designing and Partitioning, Data Load Rules, developed numerous complex calc scripts, involved in application tuning and optimization, MaxL Scripting, Report Scripts, Automation using Batch scripts

TECHNICAL SKILLS

Operating Systems: WINDOWS, Linux

Languages: SQL

Database: ORACLE, MS SQL OLAP

Tools: ESSBASE 11x, PLANNING 11x

Reporting Tools: Hyperion Financial Reports, Smart View

Planning Tools: Hyperion Planning

Hyperion Tools: Hyperion Shared Services, Calc Manager Rules, Oracle Data, Integration, DRM

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Supporting both Confidential Power and Lighting business DRM's.
• Follow federation model and sync Business DRM's with Enterprise Standard governed segments.
• Design and maintain business specific segments.
• As per business requirement design DRM objects like Properties, Exports, Books, Validations, Node types, External connections, etc..., using both DRM formulas and Java script.
• Managing Oracle DRM Administration, Infrastructure and operational activities.
• Prepared templates/forms for achieving quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with teh business managers.
• Designed and developed load rules for both metadata and data.
• Created Business rules, Calc scripts, global variables as per teh requirement.
• Created report scripts to extract teh data as per teh requirement.
• Support teh system for Quarter End reporting and worked parallel on Planning/Essbase applications.
• Worked on Planning Dimensional level security and User access in Shared Services.
• User Security administration and design in Hyperion Shared Services console.
• Trained End users in accessing teh Smart views and Web forms.
• Trouble shooting critical issues in timely manner to- ensure teh SLAs (Service level agreement) are met.

Confidential

Onsite, Technical Lead

Responsibilities:

• Managing a team of 8 members on an onsite/offshore model
• Organizing individual meetings with different stake holders as part of requirements gathering on teh enhancements to teh existing system in term of functionality, features & other technical aspects and documented them to a BRD.
• Tuning system design with respect to teh new requirement of integrating several applications.
• Conducting POCs to determine teh right design and provide initial assessment to teh business.
• Redesigning entire Hierarchy structure by cleaning up unwanted hierarchies and organizing teh structure based on User classification.
• Integrating Cash flow application and designing optimized process which enables much granular level visibility to teh businesses for FED reporting
• Integrate Multiple historical cubes with different dimensionality into one single database
• Re-designing data forms to reduce quarterly maintenance and providing more flexibility to users.
• Tuning performance on calc scripts and reduce teh WTW time by 40%
• Build auto validations between source system to Hyperion at parent level of all Business units
• Build new Financial Reports for Balance sheet pack for Central team and Tax Report for Tax teams.
• Managed UAT - Co-ordination with users, project team and support team, tool training, training pitches and guiding users in converting existing excel reports to suite new system.
• Working with multiple downstream system owners to ensure data flows from Hyperion into their respective systems without any issues
• Meeting IT customers on a regular basis and providing them with dashboards and risk analysis throughout teh project

Confidential, Plano, TX

Hyperion Technical Lead

Responsibilities:

• Managing a team of 6 members on an onsite/offshore model working out of Houston, TX
• Designing Hyperion ASO application in 11.1.2.3 sourcing data out of HFM application
• Designing hierarchies, design aggregations, data load process to minimize teh WTW time
• Designing teh EA process to convert data from HFM to ASO loadable format
• Designing and building HFM EA template to refresh data from HFM into EA
• Conducting POCs to determine teh right design and provide initial assessment to teh business.
• Design platform hierarchy not available in HFM to be built looking at mappings on Accounts, Entities
• Meeting key users and IT managers to understand teh closing process and replicate teh same in Hyperion application
• Leverage teh resources of offshore team in development of Essbase objects and Informatica Mappings, Sessions and Workflows
• Design entire automation process using Windows batch scripts and Unix shell scripts
• Validate data between HFM and ASO application and find out root causes if their is any variance
• Managed UAT - Co-ordination with users, project team and support team, tool training, training pitches
• Meeting IT customers on a regular basis and providing them with dashboards and risk analysis throughout teh project

Confidential

Hyperion Developer

Responsibilities:

• Created ASO and BSO applications, databases and designed outline in an hourglass model.
• Created Rules files for building dimensions and loading Data into Essbase applications.
• Optimized structure, loading and calculations through appropriate dense and sparse settings of dimensions.
• Created Essbase outline formulas and Calc scripts.
• Involved with Hyperion Planning budgeting application to add dimensions, assign member properties, variance reporting procedures, time balancing properties, overall metadata building and refreshing teh data.
• Designed and developed web forms for data inputs as per teh business requirements. Developed Smart lists and Task Lists for end users.
• Created Business Rules with run time prompts for planning web forms (consolidation, and currency conversion).
• Set up users and groups according to teh departments and maintained security to users and groups from Hyperion shared services and assigned security to data forms.
• Provided teh support to teh Essbase and Planning applications post development phase and performed teh required enhancements for metadata and forms based on business requirement.
• Monitoring teh daily backup process and weekly service restart and Responsible for Hierarchy Maintenance Process as part of monthly operational activities.
• Creating teh users, Groups and assigning Security Provisions through Shared Services based on new requirements.
• Performing daily Health Checks and Ensuring that teh environment is up and running and restoring teh environment with minimal downtime.
• Ensuring that teh Hyperion environment is available for Month end activities like Actuals load, Headcount load.