Data Developer
Resume:
Harry
Hyperion Administrator/Developer
Summary:
• Over 8 plus years of diversified experience in software development, design,
implementations and testing using Hyperion Essbase (System 9,V11), and
Hyperion Planning(System 9) including Workforce, CapEx and DRM (System
9 and 11.1.2)
• Used various ERP tools to manage monthly financial consolidation process.
• Extensive experience with automation and batch scripting using Hyperion
scripting languages such as MaxL, Esscmd and Visual Basic API
• Extensive experience in Excel based custom reporting solutions over diversified
data sources.
• Extensive experience on the installation, configuration, server settings, backups,
client installations of Hyperion products on both Windows and UNIX
environments.
• Extensive experience in Business Rules, Web Forms, Calculation Scripts, Load
Rules and Report scripts.
• Experience and expertise in managing and administering numerous Essbase
applications and cubes (Block Storage and Aggregate Storage), forms, reports,
and books.
• Applied in-depth understanding of STAR and SNOWFLAKE SCHEMA modeling
techniques to develop optimized OLAP models and meta-outlines using
relational and other database sources.
Expert technical/developer knowledge of Hyperion Planning
• Substantial experience in creating, maintaining, and supporting all application
objects including outlines, calculation scripts, rules files for dimension building
and data loading, creation and optimization of transparent partitions, and security
objects through Essbase Administrative Services (EAS), MaxL, MDX queries,
and ESSCMDs.
• Thorough understanding of multidimensional and relational database architecture
and their applications for effective planning, budgeting, strategizing and
forecasting procedures.
• Experience in creation and maintenance of finance, ledger, planning, and
reporting cubes across BSO and ASO Essbase kernels along with strong database
development and business intelligence modeling capabilities.
• Extensive experience with migrations of Essbase version 6.x, 7.x and 9.x.
• Excellent communication skills and better understanding of business requirements
and software development cycle in the Hyperion Essbase environment.
• Highly dedicated towards work goals and creative in new development as well as
solutions to critical issues.
• Experience developing and implementing Hyperion Planning applications
Education: Bachelor of Engineering In Electronics and Communication
Technical skills
Database Oracle 7.x/8.x/9.x/10g, IBM DB2, SQL Server
BI Tool Hyperion Essbase system 11 and 9, EPM 11, Hyperion Planning, Workforce
Planning, Hyperion Shared Services, Hyperion Work Space, Hyperion Financial
reporting,Life Cycle Management Smart view, Excel AddIn
DW/ETL Hyperion Data integration Management(DIM), Informatica 8.2,ODI 11.x
Server side Calc script, ESSCMD,MaxL script, Batch scripts, JDBC
ERP Oracle apps 11i (MM, AP and AR)
Internet HTML, XML, Java script, VB script
scripts
Language SQL, PL/SQL
Other Quality Center, Test Director, MS Visio, MS Access, Citrix, Toad, Rapid
Software / SQL.,WINSCP, PUTTY, DAC
tools
Operating Windows NT4.0/2000/XP/2003,
System
Professional Experience
APS Healthcare,NY
July 2012-Present
Hyperion Essbase DRM /Developer/Support
Support Hyperion Planning, Essbase, Hyperion Report, for FP&A and Accounting
Groups,
Perform Hyperion system maintenance and upgrades, coordinate user security
Essbase\Planning\and Hyperion Report, create/ monitor/execute batch jobs .
Complete Metadata changes and maintain companywide metadata chart
Manage DRM batch client jobs scheduled in Control-M
Work with Business Analyst to collect requirement and design changes to DRM
Update Hyperion with Workforce information from ADP systems and distribute
organization
Workforce report to corporate executives(CEO,CFO,CIO etc)
Validation and cleansing techniques of data to be imported in DRM.
In building automator scripts to upload different hierarchies in DRM
User provisioning and security access rights in DRM
Monitor GL data load process into Essbase and evaluate data Integrity on a daily
bases
Work closely with CFO and Controller to complete External and Internal Hyperion
Reports
Complete Adhoc Hyperion Excel Report for VP of Finance, CFO, Tax Manager,
Controller etc
Manage Month-end Close Process
Changing/Updating Subvars each month
Performed DRM Import/Export processes to various applications for Hyperion
Planning and Essbase applications.
Total experience with in building automator scripts to upload different hierarchies in
DRM.
Discussion with Users on Functional requirement and created ODI interfaces to load
data into
OMM each time, changes done in Planning
Update and run various Macros, Automatic Essbase Batch Process, and Calc Scripts
to
Initialize Hyperion for Month-end Close Process.
Discuss related variances with Planning group
Create users and manage security in DRM
Transfer Employees between cost centers in Planning
Environment :Hyperion Essbase,Planning, EIS-Integration services,
Hyperion Financial reporting 9.3.0.1,, Hyperion Interactive
Reporting.,Hyperion), Hyperion Web analyzer 9.3.0.1, HAL Hyperion
Application Link, Hyperion Planning desktop, Oracle 9i/10g,
Hilton,Mclean VA
Feb 2012-Jul 2012
Hyperion DRM/ Developer/Analyst
•Performed DRM Import/Export processes to various applications for
Hyperion Planning and Essbase applications
•Total experience with in building automator scripts to upload different
hierarchies in DRM.
•Discussion with Users on Functional requirement and created ODI interfaces
to load data into Hyperion planning systems and configured ODI agent.
•Build Hyperion DRM application components per track lead guidance and
specifications
•Defining properties into the system. Worked with blender.
•Installed and Configured Oracle EPM system 11.
•Developed Business rules and assigned it to data forms to run on save.
•Designed and developed various web forms for the business users to input
budget and forecast data in planning.
•Data load rules from SQL View
•Extensively involved in clubbing dimensions to avoid excess dimensions in
key design issues
•Provided exports of hierarchies/attributes to client in time to time based on
their requirements
•Manage DRM batch client jobs scheduled in Control-M
•User provisioning and security access rights
•Maxl and batch scripting.
•Used Life Cycle Management (LCM)
•Performed Validation and cleansing techniques of data to be imported in
DRM.
•Experience with System Administration setup and activities.
•Configure and Create Hyperion DRM application components (Hierarchies,
Properties, Node types, Validations etc) within DRM.
•Prepared design document for Interfacing DRM with transactional and
analytics system through inbound and outbound web services API
•Understanding of source data files and configure meta data and master data
in DRM.
•Prepare key deliverables such as requirement documents, design documents,
development inventory, test documentation, training materials and
administration/procedural guides
•Defining batch scripts to automate the imports and export processes.
Environment: Hyperion Essbase 11,ODI 11.x, DRM 11, EIS-Integration services,
Hyperion Financial reporting 9.3.0.1,, Hyperion Interactive Reporting 8.x/6.x+
(BRIO).,Hyperion data integration management(DIM), Hyperion Web analyzer
9.3.0.1, HAL Hyperion Application Link, Hyperion Planning desktop, Oracle
9i/10g, SQL Plus, SQL, SAP, People Soft, PL/SQL
Navistar, IL April 2011 – Feb
2012
DRM/Planning/ Onsite Support and Admin/Developer
Responsibilities:
Create SQL’s to query the DRM database, to create reports
Create automator to make changes to DRM data
Loaded the Metadata using Hyperion Application Link tool into Hyperion Planning.
Designed and developed various web forms.
Managed planning applications in Hyperion Workspace.
Extensively used EPMA to maintain metadata for various planning applications.
Validate calculated data with the help of Excel add in.
Developed ad-hoc reports in smart view.
Developed Maxl scripts write back Process to Automate the Whole Hyperion Essbase
tasks.
Responsible to migrate reports into latest version.
Developed the Corporate financial reports using Hyperion Analyzer, Reports and
Excel-Add in.
Developed reports for the regulatory purpose in Essbase ExcelVAdd in and Standard
Reports in Hyperion Financial Reporting.
Worked on consolidated reports where I was involved in clubbing a group of reports
into one consolidated view using Hyperion Web Analysis.
Build Node types and data validations in DRM to support data integrity
Create users and manage security in DRM
Involved with the full life cycle implementation of the project.
Discussed with business users in requirement gathering meetings.
Installed and configured Oracle EPM system 11.
Responsible for migration of Essbase cubes from 9.3.1 to System 11.
Applied update patches for the applications.
Experience with Oracle Data Integrator
Substantial ETL architecture design experience within data warehousing
environments governed by applying appropriate methodologies and ETL
standards
Ability to design ETL technical/functional specifications.
Discussed with users to incorporate new dimension requirements into the existing
cubes.
Created scripts for automating the dimension build process.
Involved in stream-lining the data load process to Essbase from other data sources.
Created Batch scripts and MaxL scripts required to automate the data load process.
Designed and developed the metadata and data validation process.
Create backup versions to store historical data
Manage DRM batch client jobs scheduled in Control-M
Create and provide optimal DRM solutions to support the downstream EPM systems
Work with Business Analyst to collect requirement and design changes to DRM
Created DRM solution to support the approval process of Navistar using Oracle
Business Process Management
Create DRM imports and blenders
Migrate DRM metadata object using the DRM migration utility
Environment: Hyperion DRM, Essbase, 11.1.1.2.00, Hyperion DRM 11.1.2.1, Excel
AddIn, MS- Excel, MS Access.
Pfizer, Groton, CT July
2009March 2011
Essbase/ DRM /Developer
Pfizer Inc is dedicated to better health and greater access to healthcare for people and
their valued animals. I was one of the Essbase developers for Pharmaceutical Company to
maintain Essbase system on different platforms.
Responsibilities
Involved in creating new Essbase cubes and restructure and redesigning of existing
cubes.
Extensively used MaxL, ESSCMDS for creating automation scripts and batch files.
Scheduled these batch files for complete automation process for nights and
weekends cube refresh and backups.
Developed various load rules for dimension build and data load to the cubes.
Involved in the performance tuning and optimization of data files, dimensions and
calc scripts for ASO and BSO cubes.
Validation and cleansing techniques of data to be imported in DRM.
In building automator scripts to upload different hierarchies in DRM
Build Node types and data validations in DRM to support data integrity
Create users and manage security in DRM
Involved with the full life cycle implementation of the project.
Created HAL integrations to build and load metadata for planning applications.
Prepared quarterly forecasts, annual budget, ad-hoc reporting and management
reporting using Hyperion Reports and Hyperion Analyzer.
Involved in maintaining the security for Hyperion Analyzer by assigning the
users/groups, creating user profiles and granting the report access to these users
and groups. Involved in Performance Tuning to minimize data load time.
As the Hyperion Planning Systems Analyst responsibilities include partnering with
Finance and various operating groups in the organization to support the
budgeting, forecasting and reporting process.
Responsible for Performance Monitoring, Backup and Recovery of the cube.
Implemented various troubleshooting procedures to recover databases.
Develop calculations scripts and business rules
Investigated and resolved consolidation and metadata design issues.
Environment: Environment: Hyperion Essbase 9.3,EPMA,Hyperion planning
9, Hyperion Reporting, Shared Services, Work Space, Hyperion Smart
View,Excel Add-In Oracle 10g, Windows 2003, Hyperion DRM 9X
Bank of America, Pennigton, NJ
Hyperion DRM Essbase /Planning Developer
Aug 2008July 2009
Responsibilities
Created Users and Groups in Hyperion Essbase, Hyperion Reports and Hyperion
Analyzer and assigned privileges to them. Applied security on different
applications by creating Filters on its dimension members.
Working with blender in DRM.
Defining batch scripts to automate the imports and export processes in DRM
Defining properties into the DRM system.
System Administration setup and activities
Created Meta outlines to build Essbase cubes.
Developed automation scripts for back up and Refresh of all Production Cubes
during recovery.
Involved in reviewing the cube design, Performance Monitoring and Tuning of
the Essbase server.
Developed EIS Meta-outline for the cube and created various filters as per user
requirement.
Designed Transparent Partitioning on databases using MaxL scripts.
Developed and made changes to the existing MaxL Scripts and scheduled the
batch script to automate the running of the new Calc Scripts with development
of outlines and load rules. Created easy-to-share customized views that
represent sales performance using Hyperion Analyzer as well as performance
analysis charts
Designed, developed and tested cubes and deployed them in to production.
Responsible to understand key business processes and then communicated and
translated those needs into technical solutions.
Reduced calc time by optimizing the cube and using other appropriate
Performance tuning methods.
Required to apply understanding of advanced application programming principles
throughout the project.
Environment: Hyperion System 9, Essbase 9.x, SQL Server 7.0 MS-Access,
Load rules, MS-Excel VBA, and Windows NT. Hyperion DRM
T-Mobile, NY Feb
2007Aug 2008
Hyperion Developer
Responsibilities:
Responsible for creating Dimensional security for hyperion Planning and loading
metadata using Outline load utility.
Designed and developed web forms for data inputs as per the business requirements
using Hyperion Planning. Developed numerous simple to complex Business Rules
and attached them to the web forms.
Created various data load rule files, including SQL load.
Created and maintained Essbase application objects including database outline, Calc
scripts, and data load scripts security objects, etc.
Provided Database Optimization with Dimension Building, Data Loading,
Calculations and Partition Management.
Developed MaxL scripts to automate the daily GL transaction data to upload into the
cube
Created new batch jobs and scheduled these batch files for complete automation
process for refresh, calculations and backups.
Developed & Scheduled batch scripts to automate dimension build, data load and
backup.
Worked on various forms,Menus,Smart list using Hyperion Planning. Created and
maintained Essbase databases using planning application.
Used Business rules for allocation and budgeting in Hyperion Planning
Involved in designing and implementing new application in Hyperion Essbase.
Worked with existing cubes for budget allocation.Executed performance tuning
and optimization in both the data retrieval and data loading scenarios.
Developed a comprehensive reporting system using Hyperion Reports and Hyperion
Analyzer using the approach of Financial Dashboard.
Administered users and user groups
Prepare and present project briefings
Lead for the QA and Performance enhancement to ensure delivery of high quality and
high soln Enhanced outline, forms, rules and reports to ensure quick response
times for all concurrent users
Environment: Hyperion Essbase 6.5.4, Hyperion Analyzer 6.5, Essbase Integration
Services 6.5.4, Microsoft Excel 2000, Oracle 9i, WindowsNT4.0, ESSCMD, Maxl, Excel
Add-In.
Biogen IDEC, Boston Sep
2006 Feb2007
Essbase/Planning Developer
Analyzed user requirements and performed the process of finalizing dimensions
for Cubes.
Extensively involved in designing and modifying the outlines for Essbase Cubes.
Developed outlines, calc scripts, report scripts and dimension build and data load
rules for the cube.
Automated the weekly calculation process using batch script file.
Supported users with excel add-in, essbase databases and data issues.
Involved in performing Administrative tasks like user authentication, creating new
users for the Essbase cube using EAS options.
Used Hyperion Analyzer to generate reports for the users.
Translated end user requirements into application design specifications.
Involved in the Development of four cubes – one for Industrial Sales, one for
Production Planning and Budgeting, one for Market Research and one for
Customer Analysis.
Automated the data loads using ESSCMD in both interactive and batch modes
Implemented Dos, MaxL, Esscmd, Report and Calc Scripts.
Managed system upgrades and client installations based on users’ requirements
Prepared Profitability Reports, which detail Unit Cost, Price and Volume Trends,
and Expense Variances over prior periods using Hyperion Reports/Analyzer.
Prepared quarterly forecasts, annual budget, ad-hoc reporting and management
reporting by working with the business managers.
Handled performance tuning, weekly back-ups and monthly consolidations of
data and automated monthly/quarterly/annual report generation
Developed Analyzer OLAP views and sophisticated what-if scenarios for the end
users
Hyperion Planning 9.3.1 Create and Manage Applications
Environment: Hyperion essbase 9.3.1, Hyperion planning 9, Hyperion
Financial Report, Shared Services, Work Space, Hyperion Smart View, excel
Addin, oracle 10g, Unix, DAC, Informatica 8.1.1, OBIEE
State Bank, India
Oct 2005 Sep 2006
Essbase Developer
As a member of Hyperion Essbase & Planning Implementation team, responsibilities
included the design, development and testing of different cubes to create reports used for
various business strategies, decision-making and future planning. I was required to
participate in all phases of the development lifecycle, and played an active role in the
development, maintenance and optimization of new planning databases based on revenue
and expense analysis.
Responsibilities:
Played an active role in all phases of the development lifecycle including
requirements gathering and analysis, application design and development, testing
- user acceptance and quality assurance, Implementation, and maintenance
Designed and developed new aggregate storage and block storage cubes;
Implemented partitions to link databases and enable limited calculations
Modified Essbase configuration files and developed customized ESSCMD scripts to
work with all related application objects, aggregations, partitions, caches, and disk
volume allocations
Participated in the creation and migration of numerous planning applications to newer
versions of Essbase.
Gained valuable experience in using Essbase Integration Services to connect to
Oracle, use source relational data to tie into multidimensional databases, and
develop OLAP models and meta-outlines.
Performed client/server installations, setup, configuration, and upgrades of Hyperion
Essbase as well as other Hyperion products including Excel spreadsheet add-in
and Reports.
Regularly monitored performance and carried out optimization and fine-tuning tasks,
provided troubleshooting services and assistance to end-users in resolving errors.
Environment: MS Windows NT 4.0, Hyperion Essbase 6.1 / 6.5, Essbase Integration
Services 6.5, Excel Spreadsheet Add-In, Hyperion Reports 2.3, Hyperion Analyzer
6.1, Oracle 9i
Sebiz Infotech
Jul 2003Oct 2005
Oracle Developer/Software Engineer
Responsibilities:
Designed and developed Graphical User Interface using Forms.
Developed the PL/SQL stored procedures for implementing the business logic.
Developed the on-line context-sensitive user help.
Development of reports (stores ledger, invoice preparation) using reports 3.0
Developed test plans for invoice, order entries, billing, shipping, and Stock
maintenance.
Conducting Functional testing, System testing and GUI testing.
Tested the functionality by creating dummy transactions.
Manually tested different reports generation.
Created Packages, Procedures and Functions.
Configure Oracle Clients on Win NT Workstations.
Creating Complex Stored Procedures, Functions and Packages.
Developing Oracle Schema Design and Table Structures.
Constructing Oracle Database Triggers and Indexes.
Code Reviews, PL/SQL Code Tuning and Plan SQL
User Management; Create, Modify and Delete user accounts.
Grant Roles and Privileges to Users.
Environment: Developer 2000, Windows NT, UNIX, HTML, SQL*Plus, PL/SQL,
ORACLE Forms 6.i, ORACLE Reports 6.i.
Contact this candidate