Development Data
Resume:
VISHNU KUMAR CHILLAM CHERLA
Email: **************@*****.***
Mobile: 412-***-****
Professional Summary:
. 7 plus years of IT experience on large global projects in health care,
services, banking, retail and process industries
. 3 years of experience with Hyperion technologies Essbase, Planning,
Financial Reports, SmartView, ODI with latest versions
11.1.2.1,11.1.1.3,9.3.1
. 4 years of hands on experience in Hyperion DRM design, development and
integration with Oracle EBS on source side and Hyperion Suite of
products on target side
. Strong Experience in implementation of Hyperion Planning & Essbase ASO
solutions for finance and analytical operations
. Strong experience in integration and ETL tools ODI for integrations
between Hyperion products and relational data sources for moving data
and metadata
. Strong experience in automation using Maxl and other scripting
languages
. Strong experience in development of reports using Financial Reporting
Studio
. Experience in new Hyperion Life Cycle Management(LCM) tool to migrate
code and security from one environment to another environment
. Experience in Hyperion Application administration, production support,
installation and configuration activities
. Experience in all phases of System Development Life Cycle (SDLC) from
investigation of initial requirements through analysis, design,
programming, testing documentation and implementation.
. Experience in relational databases Oracle and Microsoft SQL Server
database modeling, SQL, PL/SQL DB Tables, Stored Procedures, and
Functions etc.
. Excellent communication and interpersonal skills with large global
teams
Technical Skills:
. Hyperion Tools : Hyperion DRM, Hyperion Planning, Essbase,
Financial
Reporting Studio, LCM, EPMA, SmartView
. Databases : Oracle 11g, SQL Server 2000/2005.
. Software Packages : MS-Office 2000/03/07
. Other tools : Toad
. Programming Languages : MaxL, SQL, PL/SQL
Professional Experience:
ING (VOYA), GA
Hyperion DRM consultant
JAN 2014 - Till date
Description:
ING (VOYA), headquartered in Atlanta, GA., is large global Insurance and
Retirement plan chain.
My role in this project consists of developing, managing, optimizing
Hyperion DRM hierarchies.
Responsibilities:
. Gathered functional requirement and based on that Developed of
hierarchies, attributes and properties to feed target analytical systems
. Creation of validations and verifications as per the Business needs for
validation of data through DRM.
. Development of mappings through DRM.
. Managing and auditing the master data using DRM.
. Development of hierarchies using Action Script, import and blend methods
in DRM
. Development of mappings in DRM to map the data between source systems to
target systems
. Automation of the hierarchy build and update through DRM Batch Client and
Batch files
. Development of automation process
. Development of validations and reports in DRM
. Development of exports
. 24x7 support for syndication schedule to generate and transmit the data
Environment: Oracle DRM 11.1.2.2, Windows 2008 servers
Bank of America, NC
Hyperion DRM consultant
Oct 2012 - Dec 2013
Description:
Bank of America, headquartered in Charlotte, NC., is large global bank
chain.
My role in this project consists of developing, managing, optimizing
Hyperion DRM hierarchies.
Responsibilities:
. Requirements gathering for the implementation of Hyperion DRM
. Design Document preparation for DRM solution
. Development of hierarchies, attributes and properties to feed target
analytical systems
. Creation of validations and verifications as per the Business needs for
validation of data through DRM.
. Development of mappings through DRM.
. Installation and configuration DRM on server and client machines
. Managing and auditing the master data using DRM.
. Development of hierarchies using Automator, import and blend methods in
DRM
. Development of mappings in DRM to map the data between source systems to
target systems
. Automation of the hierarchy build and update through DRM Batch Client
(MDM Connect)
. Workflow and Security setup on hierarchies at different levels to allow
the approval process
. Was responsible for managing and auditing the master data using DRM.
. Development of Planning and Essbase components and troubleshooting of
meta data builds
. Development of Business Rules and calc scripts for various functions
. Administration and enhancements to existing Hyperion Planning and Essbase
applications
. Development of automation process using Maxl, DOS and shell scripting
. Development of reports using Financial Reports, Web Analysis, OBIEE
. Development of integration of reports into corporate web portals
Environment: Oracle EPM 11.1.2.1 Suite Planning, Essbase, DRM, ODI,
Financial Reports, EPMA, LCM, Windows 2003 Servers
Environment: Oracle DRM 11.1.2.2, Windows 2008 servers
Marriott, Bethesda, MD Apr 2012 -
Sep 2012
Hyperion DRM Consultant
Description:
Marriott, headquartered in Bethesda, MD., is large global hotel chain.
My role in this project consists of developing, managing, optimizing and
integrating Hyperion DRM hierarchies with target Hyperion Planning and
Essbase applications
Responsibilities:
. Development of hierarchies, attributes and properties to feed target
analytical systems
. Creation of validations and verifications as per the Business needs for
validation of data through DRM.
. Development of mappings through DRM.
. Managing and auditing the master data using DRM.
. Development of hierarchies using Action Script, import and blend methods
in DRM
. Development of mappings in DRM to map the data between source systems to
target systems
. Automation of the hierarchy build and update through DRM Batch Client and
Batch files
. Development of automation process using Maxl, DOS and shell scripting
. Development of validations and reports in DRM
. Development of exports and audit reports
. Preparation of metadata using macros from excel files and other sources
to load into DRM
Environment: Oracle EPM 11.1.2.1 Suite Planning, Essbase, DRM, Peoplesoft
GL, Windows 2008 Servers
US Steel, Pittsburgh, PA Nov 2011 -
Mar 2012
Hyperion DRM Consultant
Description:
United States Steel Corporation, headquartered in Pittsburgh, PA., is an
integrated steel producer with major production operations in the United
States, Canada and Central Europe and an annual raw steelmaking capability
of 31.7 million net tons. The company manufactures a wide range of value-
added steel sheet and tubular products for the automotive, appliance,
container, industrial machinery, construction, and oil and gas industries.
My role in this project consists of developing, managing, optimizing and
integrating Hyperion DRM hierarchies with target Hyperion Planning and
Essbase applications. Also work on production support of Hyperion planning
and Essbase applications.
Responsibilities:
. Requirements gathering for the implementation of Hyperion DRM
. Design Document preparation for DRM solution
. Development of hierarchies, attributes and properties to feed target
analytical systems
. Creation of validations and verifications as per the Business needs for
validation of data through DRM.
. Development of mappings through DRM.
. Installation and configuration DRM on server and client machines
. Managing and auditing the master data using DRM.
. Development of hierarchies using Automator, import and blend methods in
DRM
. Development of mappings in DRM to map the data between source systems to
target systems
. Automation of the hierarchy build and update through DRM Batch Client
(MDM Connect)
. Workflow and Security setup on hierarchies at different levels to allow
the approval process
. Was responsible for managing and auditing the master data using DRM.
. Development of Planning and Essbase components and troubleshooting of
meta data builds
. Development of Business Rules and calc scripts for various functions
. Administration and enhancements to existing Hyperion Planning and Essbase
applications
. Development of automation process using Maxl, DOS and shell scripting
. Development of reports using Financial Reports, Web Analysis, OBIEE
. Development of integration of reports into corporate web portals
Environment: Oracle EPM 11.1.2.1 Suite Planning, Essbase, DRM, ODI,
Financial Reports, EPMA, LCM, Windows 2003 Servers
Cardinal Health, Dublin, OH Jun' 10 to Oct 2011
Hyperion DRM Consultant
Cardinal is a leading Pharmaceutical & Healthcare Consulting Services
Company. This project is to implement, enhance, upgrade and support the
Hyperion suite of products and applications using Hyperion DRM, Hyperion
Planning, Essbase, HFM, ODI, Financial Reports and Web Analysis.
Responsibilities:
. Design of metadata, hierarchies, attributes and properties to build
HFM and hyperion Planning applications in DRM
. Development of hierarchies for all HFM and Planning dimensions
. Development of properties and attributes in DRM
. Development of DRM Automator, blenders and other components to
build the hierarchies
. Development of DRM reports/exports to generate flat files for
loading into HFM
. Development of DRM reports/exports to generate flat files for
loading Planning using ODI
. Administering the security and other maintenance operations
. Automation of the process using MDM Connect.
. Maintenance and support of the Hyperion Planning applications
. Created Aggregate Storage (ASO) application from the Block Storage (BSO)
applications for executive level reporting
. Created financial reports using Prompts, User POV, Grid POV, Conditional
Suppression and Conditional Formatting
. Developed Reports to compare against different months & years, entities
and scenarios using SmartView
. Provided user Documentation, Training and Production support as part of
the Implementation
Environment: Hyperion Essbase 11.1.1.3, Hyperion Planning 11.1.1.3, EPMA
11.1.1.3,Oracle Data Integrator (ODI) 10.1.3.4, Hyperion Shared Services
11.1.1.3,Workspace, Hyperion SmartView, Hyperion Financial Reports
11.1.1.3, MS SQL Server 2005, Windows XP
Marsh, New York, NY Jan' 09 to
May '10
Hyperion Developer/Administrator
Marsh is a Risk Management & Insurance Service Company. This project is to
implement the Hyperion Planning and Essbase solutions for General Ledger
Analysis, forecasting and budgeting requirement across the whole
enterprise.
Responsibilities:
. Development of hierarchies, attributes and properties to feed
target analytical systems
. Development of mappings through DRM.
. Maintaining and administering security permissions for users and
groups.
. Defining and creating batch scripts for automation in import and
export using DRM.
. Worked in coordination with the OBIEE team for the Integration of
DRM and OBIEE.
. Installation and configuration of SOA for deploying the DRM request
client application.
. Responsible for setting up the properties, properties categories,
system preferences and queries in DRM.
. Developed Rules file for Dimension Building and performed Metadata and
Data loading
. Developed business rules and calc scripts to derive complex calculations
such as cash cost per user, YTD commitment, variance, capital expenditure
forecast and budgeted cash flow statements
. Developed web forms using Hyperion Planning web client for the users to
input Forecast, Budget, Actual, Accounting changes and other variance
explanations data
. Created financial reports using Prompts, User POV, Grid POV, Conditional
Suppression and Conditional Formatting
. Developed Reports to compare against different months & years, entities
and scenarios using SmartView
. Created and maintained ASO/BSO cubes as per user requirements and
performed optimization by using appropriate dense/sparse configuration,
outline structure strategies such as dynamic calculations, attribute
dimensions, partitioning etc. and optimization of calc scripts and tuning
of calc cache
. Designed Task lists and workflow process for all the Planning
applications
. Created Hyperion Security by creating Users, Groups and Filters for
Analytic Services and Hyperion Reports in Shared Services
. Created Data Integration interfaces, procedures and projects for loading
SQL and File System data into Planning and Essbase using ODI
. Use of Operator GUI within ODI in-order to debug data loading issues and
also schedule procedures
. Integrate Shared Services Security with ODI Security for centralized
management of security
. Created documentation for the users and provided required training for
data entry and reports
Environment: Hyperion Planning 9.3.1, Hyperion DRM(MDM), EPMA, Essbase
Administration Services (EAS), Oracle Data Integrator (ODI) 10.1.3.4,
Hyperion Shared Services, Hyperion Web Analysis, Hyperion SmartView, Oracle
Database 10g, Windows Server 2003, MS Excel 2003
Pitney Bowes, Stamford, CT Apr'
07 to Dec '08
Hyperion Administrator
Pitney Bowes is leading provider of Office Technologies & Business
Solutions. This project is providing Maintenance & Support and carrying out
Enhancements of the Hyperion Planning and Essbase applications. Also the
project is to support all the corporate FP&A reporting requirements.
Responsibilities:
. Created Budgeting and Forecasting applications using Hyperion Planning
for the Finance department
. Identified planning metadata requirements and loaded metadata
. Developed Load Rules to automatically validate the data and feed into
Essbase
. Extensively involved in creating web forms and business rules
. Designed reporting and input templates and developed numerous Financial
Reports like Profit & Loss Reports, Income statement Reports, Expense
Reports & Revenue Reports using Hyperion Financial Reporting
. Created financial reports using Prompts, User POV, Grid POV, Conditional
Suppression and Conditional Formatting
. Developed Reports to compare against different months & years, entities
and scenarios using SmartView
. Interacted with end users on a regular basis to capture business
requirements
. Supported existing cubes, problem identification, resolution and
documentation
. Provided user training on data entry and report generation steps
Environment: Hyperion System 9, Hyperion Planning 9.2.0.2, Hyperion
Financial Reporting 9.2, Hyperion Shared Services 9.2, Hyperion Smart View,
Workspace, Windows NT, Oracle 10g
BellSouth, Atlanta, GA Oct' 06 to Mar '07
Hyperion Developer/Administrator
BellSouth implemented Hyperion Essbase, Planning and Reporting tools for
their corporate and departmental forecasting, budgeting and actual
analysis requirements.
Responsibilities:
. Designed, developed and supported financial and management cubes and
reports
. Develop Rules file and perform Monthly loading of metadata and data
. Developed and implemented Dimensions and member Attributes
. Involved in budgeting application using Hyperion Planning
. Used Hyperion planning to create Planning Applications with Business
rules and data forms
. Uploading metadata to Hyperion planning and data to Essbase
. Developed web forms using Hyperion Planning web client for the users to
input Forecast, Budget, Actual, Accounting changes and other variance
explanations data
. Created financial reports using Prompts, User POV, Grid POV, Conditional
Suppression and Conditional Formatting
. Developed Reports to compare against different months & years, entities
and scenarios using SmartView
Environment: Hyperion Essbase 7.0.1, Hyperion Reports 7.0.1, Hyperion
Planning 3.5.1, ESSCMD, Windows NT 4.0/2000
Contact this candidate