Peningo Systems, Inc.
Resume of Candidate: PEN-171
Rate: email us at info@peningo.com for rate information
Hyperion Planning Consultant
PROFESSIONAL SUMMARY
Oracle Certified Hyperion Planning 11 Implementation Specialist
PROFILE SUMMARY:
• Oracle Certified Hyperion Essbase Developer.
• Oracle Certified Hyperion Planning 11 Implementation specialists.
• 7 years of expertise in the area of Data Warehouse and OLAP software systems design and implementation.
• Strong Technical and Functional experience in Application Architecture, design, analysis, development and administration of various financial
applications in Client/Server environment using Oracle EPM 11, Hyperion Essbase, Hyperion Planning, Hyperion Financial Reporting, Web
Analysis/Hyperion Analyzer, Esscmd, MaxL, and Essbase Spreadsheet Add-In.
• Strong expertise in Batch Scripting, Calc Scripting, Software Installations, system upgrades, server maintenance, data back-ups and security.
• Demonstrated ability to work as part of a team to analyze complex business requirements and translate them into business intelligence solutions.
• Skilled in Architecture design and maintenance of numerous applications of Essbase Cubes using Block storage (BSO) and Aggregate storage
(ASO) Essbase Cubes.
• Experience in implementing full lifecycle projects starting from requirement analysis, design, development, unit testing, integration testing, user
acceptance testing etc.
• Extensive experience in maintaining, updating and migrating Essbase and Planning applications.
• Expertise in configuring Shared Services as centralized framework to create and maintain users for managing user security across all Oracle
Hyperion modules including external authentication using Lightweight Directory Access Protocol (LDAP), NTLM (NT LAN Manager) and Microsoft Active
Directory (MSAD).
• Performed several Optimizations and Performance tunings of Essbase/Planning applications.
• Experience in creating reports using Essbase Excel Add-In, Web Analysis, Hyperion Reports, Hyperion Financial Reporting Studio and Smart view.
• Provided recommendations to the client for backup and recovery procedures.
• Expertise in Creation and Maintenance of Hyperion Planning applications, Calculation Scripts, Business Rules, Web forms and Task lists
• Trained end users and managers on Workspace, Planning and Smart View features.
• Experience in creating interfaces, packages in ODI for meta-data automation and data loads.
• Experience in analysis of system and data issues, including data reconciliation, to identify root cause and required corrective actions.
TECHNICAL SKILLS:
OLAP Oracle EPM System 11, Hyperion Essbase 9.3.1/7.X/6.x, Hyperion Planning 3.0/3.3/3.5/4.x/9.x/11.x, Oracle Data Integrator(10.1.3.5/10.1.3.4),
Hyperion Shared Services System 9 BI+, Hyperion System 9 Smart View, HAL 7.3/7.1,
Databases Oracle 11g/10g / 9i / 8i / 7x, MS SQL Server 2000/2005, MS Access, SQL plus
Reporting Tools Hyperion Financial Reporting, Hyperion Analyzer/Web Analysis, Excel Add-in, Smart View.
Programming languages Java, PL/SQL
Operating Systems Windows 95/98/2000/2003/NT/XP, UNIX
Web Technologies HTML, XML, Java Script, Servlets, JSP
Application Servers Tomcat Apache 6.x/5.x, Weblogic 10.x/9.x/8.1, Websphere 7/6.x/5.x
Office tools: MS Office 2000/XP/2003/2007 - Word, Excel, Power Point, Quick Books, MS Visio
Aug ’12 – Present
Sr. Oracle Hyperion Essbase / Planning Developer Lead
Responsibilities:
• Gather business requirements by conducting regular meetings with the end users.
• Create Business Requirement Documentation (BRD).
• Export meta data from existing Essbase application, format the load files and load the meta data into Planning application.
• Created Data forms to enable business users and managers to input data from Planning web client and Smart view.
• Created Dynamic variables and enabled them in the data forms to filter down the list of members.
• Designed Composite forms to group data forms based on similar Chart of Accounts and enable tabbed browsing.
• Developed Business Rule for Aggregating data on the forms for selected Entity, Scenario and Version
• Developed Business Rule for Currency conversion from local currency to USD based on Location UDA (User defined Attributes).
• Created run time prompts in Business rules to copy data from one version to other.
• Create User Acceptance Test (UAT) script and provided training to business users on Planning web client and Smart view.
• Set up security based on Departments, created different groups and provisioned them to have Planner access.
• Created Batch script to clear the prior month’s Forecast and load Actuals.
• Created Batch script to export data from Planning Essbase cube to Reporting Essbase cube.
• Migrate the Planning Application from Dev to Test and Production for Go-Live.
• Create the Admin script for onsite Admins to follow during month end close.
Feb ’12 – Aug ’12
Oracle Hyperion Essbase / Planning Developer
Responsibilities:
• Gather business requirements by conducting regular meetings with the end users.
• Create Business Requirement Documentation (BRD).
• Export Meta data from existing Essbase application, format the load files and load the Meta data into Planning application.
• Created Data forms to enable business users and managers to input data from Planning web client and Smart view.
• Created Dynamic variables and enabled them in the data forms to filter down the list of members.
• Designed Composite forms to group data forms based on similar Chart of Accounts and enable tabbed browsing.
• Developed Business Rule for aggregating data on the forms, copying data between different versions
• Developed Business Rule for Currency conversion from local currency to USD based on Location UDA (User defined Attributes).
• Optimized the Planning application by rearranging the dimensions in the outline for faster calculation and query response.
• Optimized the Essbase cube by changing member properties and setting up caches.
• Create User Acceptance Test (UAT) script and provided training to business users on Planning web client and Smart view.
• Set up security based on Location and Departments, created different groups and provisioned.
• Created Batch script to clear the prior month’s Forecast and load Actuals.
• Used ODI to automate dimension building and data load.
• Created Batch and MaxL script and to export data from Planning Essbase cube to Reporting Essbase cube.
• Migrate the Planning Application from Development to Production for Go-Live.
• Create the Admin script for onsite Admins to follow during month end close.
• Create Application documentation for End-users.
Environment: Oracle Hyperion System 11.1.2.1, Oracle Hyperion Essbase, Hyperion Planning, Financial Reporting, Shared Services, Workspace, Oracle
Data Integrator(10.1.3.6) Smart View, Essbase Excel Add-In, Esscmd, MaxL, Weblogic 11g and Oracle 11g.
May’11 – Feb 12
Oracle Hyperion Essbase / Planning consultant
Responsibilities:
• Plan, Install, Configure, and Administer Hyperion, Hyperion Essbase and Hyperion Planning Windows environment with both physical and virtual
servers.
• Create/Maintain automation scripts, and maintain responsibility for creating and updating system documentation.
• Identify, implement and test patches and upgrades and maintain up-to-date documentation of Hyperion-related configuration.
• Trouble-shoot and resolve process, functional and technical issues.
• Create, modify and maintain BSO Essbase cubes in Essbase version 11.
• Modify, and maintain and trouble shoot Hyperion Planning Applications.
• Investigate issues in reports or cubes and provide root cause analysis.
• Train end-users on how to use the Workspace to complete their budgeting and forecasting tasks.
• Set up, Manage and maintain user security through Shared Services.
• Migrate Planning and Essbase applications from one environment to other.
• Develop Interfaces and Packages in ODI to load data into Essbase and Planning applications.
• Recommend corrective actions for technical systems issues, taking into account user needs and IT resources.
• Import and manipulate data from multiple disparate systems Flat files, Essbase, Oracle and Excel sheets.
• Monitor application performance, availability, and utilization.
• Maintain Accounting structure and outline metadata for online reporting.
• Provide user support, security and other ad hoc requests.
Environment: Oracle Hyperion System 11.1.2, Oracle Hyperion Essbase, Hyperion Planning, Financial Reporting, Shared Services, Workspace, Oracle Data
Integrator 10.1.3.5, Smart View, Essbase Excel Add-In, Esscmd, MaxL, Weblogic 10 and Oracle 11g.
Aug’09 – May’11
Oracle Hyperion Essbase/Planning Consultant
Bristol-Myers Squibb is a global BioPharma company discovers, develops and delivers innovative medicines that help patients prevail over serious
diseases. BMS uses the Hyperion suite of products to present the financial information to the end users to make better business decisions, and uses
Hyperion suite of products for financial analysis, budgeting, forecasting and reporting. This project is to create a planning and budgeting application for
their marketing expenses and sales budgeting.
Responsibilities:
• Install Hyperion Foundation Services, Essbase, Reporting and Analysis and Planning.
• Patch and configure all five environments with latest Hyperion 9.3.3 release update to support Windows 7 and IE8.
• Integrated client data into Hyperion Cubes and was involved in development as well as administration of Hyperion Planning application, Financial
Reporting and Essbase applications.
• Full life cycle development with Hyperion Planning in creating applications, managing the application security and system users.
• Developed Business rules and attached to the input forms to calculate data on save Option
• Removed Fragmentation from Essbase cubes, recommended settings in Essbase.cfg file on Production server for optimal usage of resources.
• Administered user groups and privileges in Shared Services.
• Created Backup Scripts to backup data files and logs files, created and performed Daily, Weekly and Monthly backup.
• Used CSSImport/Export and OpenLDAP backup utility to backup and restore Shared Services provisioning information and OpenLDAP.
• Implemented Weblogic cluster to perform load balance between planning servers.
• Developed MaxL scripts and rules files to work with all database objects including outlines, formulas, caches, and security profiles; also designed
calculation scripts, and batch files to automate data load and other maintenance procedures like outline modifications.
• Involved in database and security refreshes in Hyperion Planning.
• Created and scheduled batch jobs for complete automation processes for nights and weekends application backup.
Environment: Oracle Hyperion System 9.3.1, Oracle Hyperion Essbase, Hyperion Planning, Financial Reporting, Shared Services, Oracle Data Integrator
10.1.3.5, SmartView, Essbase Excel Add-In, Esscmd, MaxL, Weblogic 9.1 and Oracle 10.2.
Constellation Brand Inc. (CBI), Victor NY Apr’08 – Aug’ 09
Sr. Oracle Hyperion Planning/ODI Consultant
Constellation Brands, Inc. is the leading producer of premium wines in the world. Constellation is the largest premium wine company in the U.S.; the
largest wine company in the U.K., Australia and Canada; the second largest wine company in New Zealand; and the largest beer importer and marketer in
the U.S. Constellation needed to upgrade the current System 11 Financial Planning Application and Reporting (FPAR) upgrade. Constellation uses Oracle
Hyperion Financial Management and Hyperion Planning for financial consolidation, budgeting and forecasting.
Responsibilities:
• Full life cycle development with Hyperion Planning, in creating applications, managing the application security and system users.
• Loaded the metadata into the Planning Applications using the Interfaces, Procedures, and Packages and ran preload Business Rules using Oracle
Data Integrator.
• Developed MaxL scripts and rules files to work with all database objects including outlines, formulas, caches, and security profiles; also designed
calculation scripts, and batch files to automate data load and other maintenance procedures like outline modifications.
• Involved in database and security refreshes in Hyperion Planning.
• Participate in developing and implementing process improvements involving the corporate financial reporting process
• Created load rules, windows batch, EssCmd and MaxL scripts.
• Application development using Hyperion Planning and creating Web Forms and Business Rules.
• Optimized the applications to bring down the runtime considerably.
• Automated the execution of Packages for loading data into the Essbase cubes according to the version, period and Fiscal Year.
Environment: Oracle EPM System 11, Oracle Hyperion Essbase, Hyperion Planning , Shared Services, Oracle Data Integrator 10.1.3.5, Essbase Excel Add-
In, MaxL and SQL Server 2005.
United Refining Company, Warren PA Jul’05- Jan’07
Hyperion Developer
URC has over 375 retail outlets in Pennsylvania, Ohio and New York, which include service station/convenience stores, truck stops, restaurants, and
garages. The locations are branded Kwik Fill, Red Apple Food Marts, and Country Fair. URC conducts business through various operating subsidiaries.
The requirement was to build an Enterprise Dashboard with manufacturing metrics. Metrics of various functional areas were identified and dimensional
model was designed which would incorporate all the attributes/Dimensions that would be required.
Responsibilities:
• Involved in writing ESSCMD, MaxL, API for total automation of the process
• Actively involved in writing calc scripts and reduced the calc times.
• Involved in optimizing and fine-tuning the Essbase applications for build times. Responsible for creating and maintaining users, groups using
shared services.
• Responsible for creating filters using Essbase.
• Define the load rules (Hierarchies), functions and dynamic calculations for the Essbase cube build.
• Involved in tuning the applications for better performance by modifying the server side, application, and database settings.
• Communicated with all Levels of Management for ongoing report development & support.
• Worked on Essbase deployment plan (moving cubes and data from Development to Production environment).
• Involved in full life cycle development with Hyperion Planning, in creating applications, managing the application security and system users.
• Implemented and maintained Hyperion Planning Suite 3.0 and assisted the integration of financial reporting along with streamlining of
process/method improvement for data collection and the administration consolidation of monthly financial information.
• Involved in generating various reports in Hyperion Planning.
• Extensively involved in Excel-Add in for developing the upload template for the Essbase applications
• Delivered a presentation on outline optimization to the Essbase core team and identified possible anomalies in the cube outlines.
• Design and develop Web Analysis for the purpose of accessing the on line reports by the users.
• Train and help the users to access the online Web Analysis.
Environments: Hyperion Essbase 7.0, Hyperion Planning 3.0, Hyperion Analyzer 7.0, Hyperion Reports 2.5, Essbase Integration Services 7.0, WebSphere
5.0, Oracle 8i, Windows NT 4.0, Unix.
EDUCATION
• M.S. in Computer Science, Governors State University – 2008.
• Bachelors of Computer Science, JNTU, India – 2005.
CERTIFICATIONS/ AWARDS
• Oracle Certified Hyperion Essbase Developer -2009.
• Oracle Certified Hyperion Planning 11 Implementation specialist -2013
 | |  | |  | |  | |  | |  | |  |