Anup Kumar Somavarapu
Masters in Science
abiboj@r.postjobfree.com
Bachelor's in Technology
OBJECTIVE
To utilize my software design and development skills in a leading
organization that will provide continuous opportunities for growth and
advancement.
SUMMARY
. Over eight and half years of diverse experience in OLAP design, BI,
Data Ware House, analysis, architecture, development, implementation,
reporting, administration, Oracle General Ledger and migration of
various applications in client/server environment using Hyperion
Essbase, Hyperion Planning(Workforce, Capex) Hyperion Financial
Management, Shared Services, Essbase Integration Services, Hyperion
Interactive reporting, BRIO, DRM, Enterprise Performance Management,
Hyperion Performance Suite, Hyperion Reports, Hyperion Analyzer, ODI,
Essbase Spread Sheet Add-in, Hyperion Intelligence(Web Client) under
Windows and UNIX environments.
. Experienced Hyperion System 11.1/9.3 modules (Hyperion System 11.1/9
BI+ Analytic Services, Hyperion System 11.1/9 Planning, Interactive
Reporting, Financial Reporting, Production Reporting and Dashboards).
. Highly proficient in loading, reconciling, consolidating key Financial
Data with Hyperion using Financial Data Quality Management (FDM - DRM
related tool).
. Proficiency in Oracle Hyperion Data Relationship Management (DRM)
solutions. Expertise in using DRM for managing users, properties,
verifications and validations, managing system categories, node types,
migrating DRM metadata, working with formulas and transaction
requests.
. Extensive knowledge in Hyperion Business Rules (HBR), Hyperion
Application Link (HAL), DIM, Essbase Calculation scripts, Essbase
Commands and Essbase functions.
. Strong Multidimensional Database design skills, development and
business intelligence modeling capabilities.
. Experienced in interacting with business users at various levels and
converting their requirements into technical specifications.
. Experience working with intercompany eliminations with consolidations
in Hyperion and oracle and with foreign subsidiaries.
. Performed Dense/Sparse settings, Optimization of Data load and
Optimization of Calculation scripts and Business Rules.
. Expert level knowledge and understanding of ESSCMD and MAXL scripts
used for automation and partitioning.
. Experienced in working with Aggregate Storage Outline (ASO) and Block
Storage Outline (BSO).
TECHNICAL SKILLS
Hyperion System 11.1/9 BI+ Analytic
OLAP TOOLS Services 11.1/9.3, Hyperion Financial
Management 11.1/9x, Hyperion Essbase
11.1./9.3/7.x/6.5, Hyperion Planning
System( WorkForce and Capex)
11.1/9.3/9.2, Hyperion Planning
11.1/9.3/3.0/4.0, Hyperion Workspace
11.1/9.3
REPORTING TOOLS Hyperion Financial Reporting release
11.1/9.3, Sales Reporting, Hyperion
Interactive Reporting release11.1/ 9.3,
Hyperion Production Reporting release
11.1/9.3, DRM, Hyperion SmartView
11.1/9.3, Dash Boards, Hyperion Reports
11.1/9.3/7.2, Hyperion Excel
Spreadsheet Add- in, Hyperion
Analyzer7.2.x, Budgeting, Forecasting,
Planning
DATABASES Oracle 12.1 & 11.5.10,
10g/9.x/8.x/7.x/6.x, DB2, MS SQL Server
2000, Microsoft analysis server 2005,
Microsoft Reporting Server 2006, SSAS,
Teradata 6.5, MS Access
Metropolitan Washington Airport Authority (MWAA), Washington DC, Apr10 to
Present
Position: Hyperion Consultant
RESPONSIBILITIES:
. Involved in installation of Hyperion on a new environment and applied
all patches.
. Worked on lot of trouble issues like fishbone issues of HFM during
installation.
. Involved in modifying and maintaining business rules for HFM
applications.
. Custom Business Rules and custom dimensions formulated.
. Worked with Hyperion workspace 9x to schedule the certain task flow in
HFM applications.
. Modified the hierarchy of flow of data from sources by rules file in
HFM applications.
. Created HFM applications through Workforce and windows desktop
interface.
. Created Application profiles and Metadata for HFM applications.
. Scanning of Metadata and correcting the errors before extracting in to
HFM applications.
. Migrated applications across environments.
. Created applications in Essbase by gathering requirements from the
users.
. Gave a demo to users about the application and its final demo look.
. Developed the application, batch scripts to do automation i.e.,
dimension build and data load.
. Built report scripts.
. Created users and groups in Development.
. Created security files and provisioned users based on access levels to
different applications
. Assisted DBA in setting security in system testing.
. Created lots of calculations scripts, batch scripts for loading data
and extracting data.
. Involved in the automation process for data load, tuning, backups and
adhoc reports too.
. Created the user training documentation.
. Trained the end users.
. Created lots of financial reports. Both traditional and non
traditional reports.
. Involved in tuning of the applications.
. Created partitions Using MAXL scripting.
. Worked on workforce planning.
. Built web forms on workforce planning.
. Solved several issues involved in Hyperion Planning(WorkForce, Capex)
and Essbase interaction at architecture and end-user level based on
business, budgeting, financial and accounting department requirements.
. Hyperion Planning budgeting architect based responsibilities involved
performing prerequisites to creation of Planning application -
starting the RDBMS database, creation of data sources, creation of
Shared Services Planning project, and eventually the creation of
Planning application using Classic Administrator.
. Create Post-production ad-hoc reports using Hyperion with metatopic
features.
. Migrated and took backups of different Hyperion applications across
Development.
. Creating reports on Planning, Work Force Applications.
. Created reports using Interactive Reporting/BRIO for the users so that
they can interact among each other without any IT support.
. Fixed customized dashboards in the charts and associated with the
slider control using Interactive reporting/BRIO.
. Created web forms for users to enter the data.
. Created and involved in creating business rules.
. Created reports in FR includes, profit & loss, balance ledger, income
statement reports,.
. Fixed dashboards in IR for building reports on top of that.
. Trained the end users to make them understand the system of budgeting
and planning.
. Prepared the training material.
. Created lots of books in FR.
. Trained end users.
. Worked on OBIEE.
. Modified OBIEE configuration files for the better application
functionality.
. Created reports for adhoc purpose by OBIEE.
. Created user defined customized reports by OBIEE.
. Involved in dynamic dimension building and modifying outlines.
. Using Enterprise Performance Management worked on extended migrations.
. Installed the score card on machine and configured it.
. Created Business objects and applications in Performance scorecard.
. Assigned groups and individuals to tasks in performance scorecard
business map.
. Worked Extensively on HP quality center.
. Fixing defects and entering them.
. Type of defects and the range of defects fixed were reported in HP
Quality center.
ENVIRONMENT: Hyperion System 11.1.3/ BI+Analytic Services 11, Hyperion
Financial Management 11.1/, Essbase Administration Services7.2.1,
Management systems, Hyperion System 11.1/9 BI+ 9.2.0.2, Hyperion System
11.1.1.3, Hyperion Planning, Hyperion Financial Reportin 11.1., Hyperion
performance score card 11.1, HP Quality center.
LexisNexis, Alpharetta,GA Aug 08 to Apr 10
Position : Hyperion Consultant
RESPONSIBILITIES:
. Implemented Essbase 9.3.1/11.1.3 on a new application server.
. Created applications and migrated from previous environment too.
. Created calculations scripts, batch scripts.
. Involved in the automation process for data load, tuning, backups and
adhoc reports too.
. Created ASO and BSO cubes.
. Created ASO from BSO.
. Build and maintained two new Essbase cubes, one for international
markets and the other one for its domestic markets..
. Involved in installation of HAL.
. Configured HAL.
. Created applications using HAL and also configured the cubes for the
better performance.
. Used EPMA to manage essbase specific applications.
. Created applications in planning through EPMA.
. Deployed Planning Applications in Hyperion EPMA.
. Created, designed and validated business rules in planning, Essbase,
HFM through EPMA.
. Implemented Planning(Workforce, Capex) over Essbase to leverage the
Cube design activities .
. Created reports using financial reporting and involved in decision
making for future fiscal years by forecasting and budgeting.
. Was responsible for performance tuning of Hyperion Planning and HFM
applications.
. Developed Calc Scripts, Rule files and Report Scripts for data loads
and dimension builds.
. Involved in Setting up the required project infrastructure by co-
coordinating with users and with technical team.
. Was responsible for assigning work for the DBAs related to Hyperion
suite products, and conduct meetings with the business units to gather
user requirements, build road-map and the plan targets/deadlines.
. Implemented HFM 9.3.1/11.1.3 and configured on windows environment.
. Worked on lot of trouble issues like fishbone issues of HFM during
installation.
. Involved in modifying and maintaining business rules for HFM
applications.
. Custom Business Rules and custom dimensions formulated.
. Worked with Hyperion workspace 9x to schedule the certain task flow in
HFM applications.
. Modified the hierarchy of flow of data from sources by rules file in
HFM applications.
. Created HFM applications through Workforce and windows desktop
interface.
. Created Application profiles and Metadata for HFM applications.
. Scanning of Metadata and correcting the errors before extracting in to
HFM applications.
. Developed Hyperion Planning application (full cycle implementation)
for budgeting requirements. Worked with business analysts for
requirements gathering creation of design documentation.
. Worked on FDM, customized the configuration of FDM installation on the
server.
. Involved in setting security for FDM.
. Created customized reports for FDM applications.
. Solved several issues involved in Hyperion Planning(WorkForce, Capex)
and Essbase interaction at architecture and end-user level based on
business, budgeting, financial and accounting department requirements.
. Hyperion Planning budgeting architect based responsibilities involved
performing prerequisites to creation of Planning application -
starting the RDBMS database, creation of data sources, creation of
Shared Services Planning project, and eventually the creation of
Planning application using Classic Administrator.
. Automated the data load process by using ESSCMD and Maxl Scripts.
. Used FDM to load data in to both ASO and BSO cubes.
. Used, worked on HAL for dimensionality.
. Worked with Hyperion Financial Data Quality Management (FDM) to
integrate Oracle GL with planning applications.
. Involved in installation of Hyperion Planning on Windows environment.
. Involved in database and security refreshes in Hyperion Planning.
. Creating reports on Planning, Work Force Applications.
. Created reports using Interactive Reporting/BRIO for the users so that
they can interact among each other without any IT support.
. Fixed customized dashboards in the charts and associated with the
slider control using Interactive reporting/BRIO.
. Customized the properties for the users in the embedded options based
on the privileges using Interactive reporting/BRIO.
. Used advanced properties in the Interactive reporting/BRIO for the
ease access of data in the reports by users.
. Created new Dash Boards in Interactive Reporting/BRIO for the
efficient use in Workspace templates.
. Wrote complex SQL queries for pulling data from databases to fix
dashboards in IR.
. Installed the 11.1.3 on a new windows environment.
. Involved in migration of 9.3.1 applications to 11.1.3.
. Validated, tested all the 9x applications from production before
migrating to 11x development environment.
. Tested all the scripts, rules, Meta datas in 9.3 production before
migrating to 11x development.
. Migrated essbase cubes, web forms, reporting scripts, calculation
scripts, business rules, Meta datas from 9.3.1 to 11.1.3.
ENVIRONMENT: Hyperion System 11.1.3/9 BI+Analytic Services 11/9.2.0.2,
Hyperion Financial Management 11.1/9x, Essbase Administration
Services7.2.1, Management systems, Hyperion System 11.1/9 BI+ 9.2.0.2,
Hyperion System 11.1.1/9 Planning 9.2.0.2, ESSCMD, Maxl, MDX, FDM,
Enterprise Performance Management Architect (EPMA), DIM, Work Force
Planning, Hyperion Financial Reporting 9.2, Hyperion Interactive
Reporting/BRIO, Financial Reporting, Microsoft Reporting Server 2006.
JP Morgan Chase, OH Oct 2007 to Aug 2008
JP Morgan Chase is a leading global financial services firm with assets of
$2 trillion and operations in more than 60 countries. I was to mainly work
on design and development of different cubes used for creating reports
about various business strategies, decision-making.
Position: Hyperion Sr. Developer/Lead
RESPONSIBILITIES:
. Involved in installation of Hyperion Planning on Windows
environment.
. Optimized dense and sparse database settings for improving
retrieval times.
. Was responsible for designing Hyperion Planning applications for
Planning, budgeting and Forecasting (PBF), Hyperion FDM, Hyperion
Financial Reports, and web forms for planning users in the role of
Hyperion Architect for financial system.
. Created reports using financial reporting and involved in decision
making for future fiscal years by forecasting and budgeting.
. Implemented Planning(WorkForce, Capex) over Essbase to leverage the
Cube design activities .
. Involved in Mapping FDM data for creating Adhoc reports.
. Worked on the issues of data drill back from essbase to FDM.
. Worked on configurating ERPI adapter.
. Used ERPI adapter and mapped the dimensionality.
. Created applications using HAL and also configured the cubes for
the better performance.
. Loaded the data in to Essbase through HAL.
. Used FDM to load data in to both ASO and BSO cubes.
. Created applications in planning through EPMA.
. Deployed Planning Applications in Hyperion EPMA.
. Created business rules in planning and HFM through EPMA and
validated them too.
. Involved in gathering requirements and developing a project plan.
. Involved in design and development of two cubes, one for budgeting
and planning and the other for customer analysis.
. Designed several custom reports using Hyperion System 9 Interactive
Reporting for Corporate reporting processes (Monthly, Quarterly and
annual) as well as for each business units for HFM applications.
. Worked Involved in requirement gathering and created reports using
Financial Reports from HFM applications.
. Involved in modifying and maintaining business rules for HFM
applications.
. Created Project, Application in Hyperion Shared Services and
provision users and groups for (HFM) Hyperion Financial Management.
. Worked with Hyperion workspace 9x to schedule the certain task flow
in HFM applications.
. Created Application profiles and Metadata for HFM applications.
. Scanning of Metadata and correcting the errors before extracting in
to HFM applications.
. Created security for HFM applications in shared services.
. Involved in dynamic dimension building and modifying outlines.
. Automated the data load process by using ESSCMD and Maxl Scripts.
. Developed batch scripts for automating the dynamic dimension builds
and data loads.
. Assured optimal match between cube design and report
specifications.
. Involved in performance issues of FDM mapping.
. Created enterprise view of Financial, DRM, and Analytical Master
Data Management.
. Customized the connection adapters by DRM.
. Create Post-production ad-hoc reports using Hyperion with metatopic
features.
. Migrated and took backups of different Hyperion applications across
Development, Test and Production environments.
. Maintained cubes and took regular backups.
. Involved in performance tuning, backup and recovery of cubes.
. Involved in system upgrades and client installations based on users
requirements.
. Involved in setting the database properties, and creating filters
on Dimensions.
. Maintenance of Batch Scripts, Scheduling runs through AutoSys.
. Worked as a team member in Hyperion Essbase & Planning
Implementation.
. Created numerous business rules in Planning, Work Force, to
calculate data inputs from Hyperion Planning.
. Created Applications in Work Force Planning.
. Created more security enhancements for users using Enterprise
performance Management.
. Created reports using Interactive Reporting/BRIO for the users so
that they can interact among each other without any IT support.
. Fixed customized dashboards in the charts and associated with the
slider control using Interactive reporting/BRIO.
. Customized the properties for the users in the embedded options
based on the privileges using Interactive reporting/BRIO.
. Involved in validating and testing the application in production
of 8.3 before migrating them in to 9x development environment.
. Using Enterprise Performance Management worked on extended
migrations
Environment: Hyperion Essbase 9.3.1/8.3, Hyperion System 9/8 Planning
9.2+ (Work Force),
Hyperion Financial Management HFM 9x, Financial Interactive reporting 9+,
Web Analysis, Enterprise Performance Management Architect
(EPMA), DIM, Hyperion Reports 7.0, FDM, DRM, ESSCMD, Maxl,
MDX, Hyperion Analyzer 6.2, Hyperion Intelligence (Web Client), OLAP,
Windows 2000 NT, Hyperion
Shared Services, BI, Hyperion Interactive Reporting, Teradata, Microsoft
Analysis server 2005, SSAS.
Reddy's Pharmaceuticals, Hyderabad-India Feb 05- Aug07
Position: Hyperion Developer
PROJECT: Budget Application
The purpose of this project is to replace the current Excel based system
with a more robust and technologically advanced application that would
offer standardized solutions to the current budgeting, forecasting, and
reporting challenges now and in the future.
RESPONSIBILITIES:
. Primarily responsible for upgrading, administering and monitoring the
Essbase Database and Hyperion environments for Financial Reporting,
Planning the forecasting and budgeting system.
. Involved in the load test of Business rules emulating the realistic
production workload using Load Runner test scripts
. Worked closely with business stakeholders to correctly identify their
requirements and ensured the design satisfies the requirements.
. Created projects and interfaces to load metadata and data into the
Hyperion Planning applications using both Planning and Essbase
Knowledge Modules (KMs) in Oracle Data Integrator (ODI).
. Used Hyperion System 9 Planning to maintain and administer Planning
Applications.
. Created Business Rules to assign them to Planning Web forms and also
to launch them on demand.
. Created reports using financial reporting and involved in decision
making for future fiscal years by forecasting and budgeting.
. Retrieved data using Hyperion Essbase Excel Add-in for analysis of
data.
. Created and maintained interfaces to move data into and out of
Hyperion cubes.
. Built complex Business Rules, fine tuned them and attached to web
forms.
. Optimized dense and sparse database settings for improving retrieval
times.
. Migrated Block Storage (BSO) databases to Aggregate Storage (ASO)
using migration wizard.
. Involved in performance tuning, backup and recovery of cubes.
. Used Essbase administrative activities such as creating filters,
assigning users and groups to the filters and maintaining Essbase
Servers.
. Tuned and optimized Essbase outlines and cubes by setting the correct
order of dimensions, dense sparse settings and compression method.
. Involved in installation and up-gradation of Hyperion Essbase from 7.0
to System 9.0.
. Involved in installation and up-gradation of Hyperion Essbase and
Essbase Integration
. Designed and supported the complete architecture, installation and
configuration of the entire Hyperion system.
. Held accountability for system maintenance, supporting and monitoring,
capacity planning, resource management, evaluating and implementing
upgrades and patches, performance tuning as well as security
maintenance.
. Led the complete implementation of Hyperion Planning System right from
scratch to the production move.
. Migrated and took backups of different Hyperion applications across
Development, Test and Production environments.
. Maintained the configuration settings, startup scripts, and various
log files.
. Automated the data load process by using ESSCMD and Maxl Scripts
. Created lot of Batch Files using Maxl scripting.
. Involved in performance tuning, backup and recovery of cubes.
. Involved in system upgrades and client installations based on users
requirements.
. Modified Essbase configuration files and developed customized MaxL
scripts to work with all related application objects, aggregations,
partitions, MDX formulas, caches, disk volume allocations, and table
spaces.
. Provided all the required Hyperion Administration and DBA support of
all Hyperion components of the Essbase, Planning and Reporting systems
- database servers, application servers, batch job servers, and file
servers for the development, test and production environments.
. Created the existing Budget Book reports using Web Analysis.
. Prepared training material and well designed documents covering both
the functional and technical aspects of the project.
. End user training and support.
Environment: Hyperion Essbase 9x/6.5, Hyperion Planning 4.0/3.5, Hyperion
Reports 7.2/2.0, Essbase Administration Services 7.1.2/6.2,Hyperion
Interactive reporting, Hyperion Reports 7.0, EPMA, DIM, Financial
reporting, OLAP, BI, Hyperion Analyzer 7.0, Oracle, ESSCMD, Maxl, MDX,
Hyperion Application Link 7.0, Windows NT 4.0, Unix.
Toshiba, Chennai, India Jan 04 to Feb 05
Position: Essbase Developer/Analyst
Toshiba is always is in need of numerous web-based financial reports as
well as their in-house financial reports for its widespread international
markets as well as domestic businesses. Hyperion Essbase, Hyperion Analyzer
had been extensively used to generate these reports. With the help of these
Hyperion products, financials are deployed online and managers can see the
numbers on a daily basis.
RESPONSIBILITIES:
. Designed, developed, and implemented Expense Planning and Reporting
System for the Financial Department at Target Corporation using
Essbase for better decision-making by Top Management.
. Involved in the requirements and design documents with business
users.
. Build and maintained two new Essbase cubes, one for toshiba's
international markets and the other one for its domestic markets.
. Involved in dynamic dimension building and modifying outlines.
. Implemented Planning over Essbase to leverage the Cube design
activities.
. Developed batch scripts for automating the dynamic dim builds and
data loads.
. Analyzed user requirements and involved in the process of
finalizing dimensions for cubes.
. Optimized dense and sparse database settings for improving
retrieval times.
. Migrated Block Storage (BSO) databases to Aggregate Storage (ASO)
using migration wizard.
. Involved in performance tuning, backup and recovery of cubes.
. Used Essbase administrative activities such as creating filters,
assigning users and groups to the filters and maintaining Essbase
Servers.
. Involved in database and security refreshed in Hyperion Planning.
. Documented and standardized the entire development of cube.
. Involved in performance tuning and developed the required alternate
rollups for reports.
. Involved in system installation, configuration and software
upgrades from Essbase version 6.5 to 7.0.
. Modified Essbase configuration files and developed customized MaxL
scripts to work with all related application objects, aggregations,
partitions, MDX formulas, caches, disk volume allocations, and
table spaces.
. Involved in defining requirements, functional specifications,
designing documentations and testing strategies.
. Designed and developed numerous complex Essbase applications with
excellent balance of Dense and sparse dimensions, arranged in an
hourglass fashion, starting with Accounts, Time and then largest
dense to the largest sparse at the bottom of outline.
. Optimized the applications to bring down the runtime and database
size considerably.
. Developed OLAP Models and Meta outlines using Essbase Integration
Services.
. Developed Report Scripts for extensive reporting using Report
Extractor.
. Created new Dash Boards in the Studio for the ease use of BRIO
reports in the workspace.
. Customized the Dash Boards for users based on privileges without
the need of IT support using BRIO.
. Created charts, Pies and other graphical reporting interfaces for
lot of results using BRIO.
. Developed the documentation required to transfer knowledge for the
users and for the administration and support.
ENVIRONMENT: Hyperion Essbase 6.5/7x, Essbase Administration Services 6.2,
Hyperion Analyzer 6.2/7.0, Hyperion Reports 7.2, Hyperion Brio, Essbase
Integration Services 6.2, Microsoft, Oracle, Windows NT 4.0, Unix, Excel
Add-in, MS SQL Server, Oracle, DB2, UNIX
Andhra Paper Mills, Hyderabad, India Mar 02 to Dec03
Position: Essbase Analyst
RESPONSIBILITIES:
. Interacted with finance managers and other users in gathering the
requirements for the new cubes.
. Designed 3 cubes for reporting along with a currency cube.
. Developed Calc Scripts to generate various measures like Net
Revenue, USD Net Revenue and Functional Net Revenue to facilitate
the reporting in multiple currencies.
. Developed MOR (Monthly Operational Report) for sales data on
monthly basis.
. Developed ESSCMD Scripts for the automation and scheduling of data
loads and reports.
. Developed multiple Analyzer views (Reports) and demonstrated the
flexibility of switching connections, writing data to Essbase and
running calcs from Analyzer.
. Optimized outlines to have the optimum load, calculation and
retrieval times and fine tuned the Calc Scripts.
. Implemented Hyperion Planning, created test Applications for
existing Essbase cubes.
. Developed Web forms and Business Rules for the Planning
Applications.
. Supported work for production in taking the backups and migrating
the cubes from development to production.
Environment: Hyperion Essbase 6.5, Essbase Administration Services 6.2,
Hyperion License
Server, Hyperion Application Link 7.0, Excel Add-In, ESSCMD, TOAD, Windows
2000/NT,
Sun Solaris 5.8.