Oracle PBCS Consultant
Resume:
Hari Krishna Enikepalli Email: *******@*****.***
PBCS Consultant Mobile: +91-855*******
Professional Summary
I am having 4.6 years of professional experience on Oracle Hyperion Business Intelligence Application Development, Installation, Deployment and Support with strong analytical, reasoning and good interpersonal skills.
Expertise in Oracle PBCS, Oracle EPBCS, Hyperion Planning, Hyperion Essbase, Essbase Administration Services(EAS), Hyperion Financial Close Management, Hyperion financial data quality management Enterprise Edition(FDMEE), Oracle Data Integrator(ODI), Hyperion Financial Reporting, Smart View, ASO/BSO Applications, Maxl, MDX, Calc scripts, Hyperion business rules, Dimension build rules, Data load rules, Groovy Rules and FR reports, SQL Server databases, and Oracle databases.
Extensive hands-on Administrative tasks such as installation and configuration of several Hyperion Products, server settings, backups& disaster recovery & client installations of Smart view.
Experience in Troubleshoot Hyperion database, server, and issues.
Perform Patch Updates on several products to fix the ongoing bugs/issues.
Managed Essbase/Planning security to create users and groups for application access.
Experience in performing Migration of applications and its artifacts between different Environments using Lifecycle Management Utility (LCM) utility.
Extensive work experience on Business Intelligence solutions through the complete project lifecycle from requirements analysis, design, development solutions to implementation and delivery of the overall project using ODI and Essbase technology.
Strong experience in development, production support and administration oriented tasks of Hyperion EPM products and ODI.
Worked on Migration project related to Hyperion Planning Classic Applications to Enterprise Performance Management Architect (EPMA).
Extensive hands-on Administration tasks in Hyperion Financial Close Management such as Data load in ARM, Opening Periods/Schedules etc.
Supporting during the moth-end of Hyperion Planning/FCM/ARM Period closer and planning, budgeting submissions.
Experience in Import formats, Data Load Mapping, Data load Rules and integration between ARM and PeopleSoft in FDMEE.
Developed ESSBASE cubes using Block storage and Aggregate storage technologies as per the requirement.
Experience in building Dimensions and Loading Fact data using rule files in an ESSBASE Application cubes by means of several build methods such as generation, level and parent-child references.
Created multiple reports by using Hyperion Financial reporting studio Tool.
Expertise in Hyperion Planning classic and EPMA, ASO/BSO applications, Hyperion Financial Close Management and Account Reconciliations Management, ODI and Hyperion financial reporting studio.
Very good experience in preparation of the metadata for Hyperion Planning EPMA applications.
Automated process of loading source data into Hyperion Planning applications using ODI technology.
Worked on automation of loading source data into Account Reconciliation management (ARM) and hands-on experience on creation of Profiles and Tasks.
Automated production jobs using Windows Scheduler by creating batch, VB scripts and EPM Automate
Created data forms, business rules, Groovy rules, menus, task lists as part of application development.
Excellent communication, organizational and interpersonal skills.
EDUCATION
B.Tech. from JNTU College of Engineering, Kakinada, Andhra Pradesh.
EXPERIENCE SUMMARY
Currently working as a Hyperion Developer with Tata Consultancy Services, Bangalore from July-2013 to till date.
TECHNICAL SKILLS
BI Tools
Hyperion Planning V11.1.2.1, Hyperion financial data quality management Enterprise Edition(FDMEE) V11.1.2.3, Hyperion Essbase,Hyperion Financial Close Management(FCM) V11.1.2.3,Hyperion Financial Reporting, Oracle Data Integrator(ODI) V11.1.1.7 and smart view.
Databases
Oracle 11g,Sql server 2008/2012
Programming languages
VB script, SQL, Batch Scripting
Operating Systems
Windows XP/7, Windows server 2008 R2
WORK EXPERIENCE:
Organization: Ernst & Young
Role : Oracle PBCS/EPBCS Consultant
Client : Unilever
Duration : Aug 2016 to Till Date
Synopsis:
Unilever is a transnational consumer goods company. Present in over 190 countries it owns over 400 brands. The objective of the project is to standardize operations across countries and bring uniformity in planning and forecasting process.
Roles and Responsibilities:
Understanding the client’s requirement and preparation of the requirement and design document accordingly.
Create metadata for the planning application.
Create planning applications and data forms to allow the end users to enter data as per budgeting process.
Create Menus for Data Forms
Responsible for writing Business Rules and Groovy Rules for the Application.
Responsible for Workflow of the Application and Basic security for the users.
Create EPM automate scripts to automate the interfaces
Create interfaces using Data Management
Create datamaps by mapping Smartlist to a dimension in ASO
Responsible for optimizing the business rules and also application performance
Responsible for Backup and Restore of Application and Migration of Application.
Conduct training for the end users for Smart View as well as for the application.
Post Implementation Support.
Environment: Oracle PBCS, Oracle EPBCS, Data Management, EPM Automate, Smartview.
Organization: Tata Consultancy Services
Role : Hyperion Developer
Client : Covance, USA
Duration : Sep 2015 to Till Date
Synopsis:
Covance Inc. with headquarters in Princeton, New Jersey, is a contract research organization providing drug development and animal testing services. It is using Oracle Hyperion Tool for their Reporting, Planning and Budgeting process. Existing Hyperion system is having 6 EPMA applications. Business is looking for 2 more applications creation so that they can perform in-detail forecasting and finally pushing the forecasted data into main cube.
Roles and Responsibilities:
Experience in metadata management as per business requirement.
Created and modified existing data forms as per reporting and planning submission requirement.
Created ads templates for loading dimensions in to EPMA dimension library.
Experience in writing complex Business rules and creation of business rule sets as per requirement.
Migration of applications and components in different environments by using utilities like LCM.
Experience in managing user/group security in shared services.
Experience in creation of ASO/BSO applications.
Experience in pushing data from one application to other using Essbase replicated partition.
Experience in archiving BSO data into ASO application.
Experience in troubleshooting data related issues.
Creation of calculation scripts for currency translation, allocations and for complex calculations using calculation script editor.
Designed and modified Essbase database outlines for better performance and for dynamic calculations.
Created load rules for dimension building and data loading.
Comprehensive experience in developing scripts using MaxL.
Experience in application backup using LCM and MAXL.
Experience in creation and modification of reports using FR studio.
Strong experience in scripting languages like VBScript and Batch script to automate the process.
Prepared Technical and User training documents.
Environment: PeopleSoft, Hyperion Planning, Hyperion Essbase, Hyperion FR Studio, Smartview, Oracle 11g.
Organization: Tata Consultancy Services
Role : ODI Developer
Client : Covance, USA
Duration : Sep 2015 to Till Date
Synopsis:
Covance Inc. with headquarters in Princeton, New Jersey, is a contract research organization providing drug development and animal testing services. It is using Oracle Hyperion Tool for their Reporting, Planning and Budgeting process. Existing Hyperion system is having 8 EPMA applications. They are interested to load actuals data from source system to 2 Hyperion applications simultaneously.
Roles and Responsibilities:
Experience in set up of topology including Physical architecture, logical architecture and contexts.
Created new models for data sources – flat files, Hyperion Essbase, Oracle.
Good experience in reverse engineering for data source and targets.
Strong experience in developing interfaces to load data from multiple sources like flat files, Oracle and Hyperion Essbase.
Experience in importing required knowledge modules based on source and target databases.
Experience in developing temporary interfaces popularly known as Yellow interfaces.
Experience in developing complex procedures and interfaces including variables.
Created ODI packages and scenarios using procedures, interfaces and variables.
Experience in scheduling scenarios as per requirement.
Experience in using ODI utilities like OdiSendMail, OdiOsCommand, and OdiFileAppend etc.
Implemented parallel execution of interfaces and packages.
Experience in customization of knowledge modules as per requirement.
Experience in migration of artifacts between different environments.
Participated in all phases of project development, testing, deployment and support.
Performed unit and integration testing.
Having experience in troubleshooting the problems by using logs in sessions.
Environment: Hyperion Essbase, PeopleSoft, ODI, Oracle.
Organization: Tata Consultancy Services
Role : Hyperion FCM Developer/ Administrator
Client : Covance, USA
Duration : Apr 2015 to Till Date
Synopsis:
Covance Inc. with headquarters in Princeton, New Jersey, is a contract research organization providing drug development and animal testing services. It is using Oracle Hyperion Tool for their Reporting, Planning and Budgeting process. Currently they are following manual process to do reconciliations & Task Management. They are looking for a centralized dashboard where they can easily do reconciliations & drilldown to the Source systems if required and to know the work flow status.
Roles and Responsibilities:
Experience in creation of profiles in ARM and tasks in FCM as per requirement
Having Strong experience in creation of periods and Schedules.
Experience in integration of ARM application and source systems like PeopleSoft in FDMEE
Experience in creation of locations, data load rules, import format and data load mappings in FDMEE.
Experience in loading data from Source system to ARM using FDMEE.
Having experience in adding custom attributes as per requirement.
Experience in copying profiles to the periods in ARM and tasks to schedules in FCM.
Experience in migrating artifacts from one environment to other using LCM.
Experience in database migration between two environments.
Having experience in automation of data load from source to ARM using ARM Scheduler.
Experience in opening/closing/locking the periods and schedules.
Experience in managing dataload definitions, System attributes and system settings
Having strong knowledge on the preparation of reconciliations.
Experience in providing user/group access and creation of teams from workspace for both FCM and ARM
Experience in creation of task types, templates and export/import of tasks to template in FCM.
Experience in applying patch updates to fix ongoing bugs/issues.
Experience in troubleshooting the issues.
Environment: PeopleSoft, FDMEE, Hyperion FCM
Organization: Tata Consultancy Services
Role : Hyperion Developer
Client : Covance, USA
Duration : Nov 2014 to Mar 2015
Synopsis:
Covance Inc. with headquarters in Princeton, New Jersey, is a contract research organization providing drug development and animal testing services. It is using Oracle Hyperion Tool for their Reporting, Planning and Budgeting process. Existing Hyperion system is having 6 classic planning applications. Metadata maintenance for these applications is getting difficult as similar kind of hierarchy structure existed. So they are interested in shared library from where we can manage metadata across multiple applications.
Roles and Responsibilities:
Strong experience in managing metadata in EPMA dimension library.
Having experience in identifying shared members among multiple planning applications.
Experience in conversion of classic application into EPMA applications using Transform Classic to EPM architect.
Experience in adding dimension and members as shared dimensions/members as per requirement.
Having experience in loading dimension members into dimension library using ads by creating profiles.
Experience in preparing ads templates for loading dimension members
Experience in deployment of EPMA applications including Business rules.
Experience in setting performance and evaluation order for EPMA application dimensions.
Experience in migrating applications from one environment to another using LCM.
Experience in creation of EPMA BSO/ASO applications.
Experience in automation of loading dimension members using EPMA bath client.
Strong experience in extraction of metadata using EPMA file generator.
Having experience in managing user/group security access.
Experience in creation of validation templates.
Having experience in applying patches to ongoing bugs/issues.
Experience in data synchronization to push the data between two applications.
Having experience in creation of technical documentation.
Environment: PeopleSoft, Hyperion Planning, Hyperion Essbase.
Organization: Tata Consultancy Services
Role : Hyperion ODI developer
Client : Covance, USA
Duration : Jul 2014 to Oct 2014
Synopsis:
Covance Inc. with headquarters in Princeton, New Jersey, is a contract research organization providing drug development and animal testing services. It is using Oracle Hyperion Tool for their Reporting, Planning and Budgeting process. Currently for Hyperion planning applications, actual data is coming from PeopleSoft through control-m process. Flat files will be shared by PeopleSoft and we will be loading them into Essbase. They are looking for options to bring PeopleSoft data into Hyperion environment directly whenever they required.
Roles and Responsibilities:
Architected and implemented ETL using ODI
Experience in Installation and configuration of Oracle ODI 11.1.1.7(Master and Work Repositories, ODI agents)
Maintained DEV, UAT and Prod environments with different context definitions.
Maintained topology connections in all 3 environments.
Developed interfaces with filter and joins to bring the data from source system(PeopleSoft) to target(Essbase)
Having experience in creation of procedure and variables.
Experience in customizing the knowledge modules.
Implemented logic to archive session log files to file system.
Designed interfaces for loading beg balance flat file from source system to Hyperion Essbase.
Experience in migration of artifacts like packages, scenarios from one repository to another.
Having experience in scheduling scenarios using ODI agent.
Created documentation on installation and configuration process, Design and technical documentation for the developed ETL process
Environment: PeopleSoft, Hyperion Essbase, ODI, Oracle
Organization: Tata Consultancy Services
Role : Hyperion Essbase Developer
Client : Covance, USA
Duration : Mar 2014 to Jun 2014
Synopsis:
Covance Inc. with headquarters in Princeton, New Jersey, is a contract research organization providing drug development and animal testing services. It is using Oracle Hyperion Tool for their Reporting, Planning and Budgeting process. Existing Hyperion system is having only planning applications and volume of data is keep on increasing as they are doing copy of data into multiple versions and it’s required to maintain it for reference purpose. Due to this retrieval performance is greatly affected. So they are looking for archiving BSO data and can do version cleanup in BSO cubes.
Roles and Responsibilities:
Having experience in creation of ASO/BSO applications.
Experience in conversion of block storage outline into Aggregate storage outline using wizard.
Experience in handling errors/warnings during conversion of BSO outline to ASO outline.
Experience in writing MDX member formulas.
Experience in creation of load rules for data loading.
Having strong experience in achieving BSO cube data into ASO cube.
Experience in creation of data validation templates for ASO cubes.
Experience in handling metadata changes for ASO cubes.
Experience in creation of security filters in Essbase and user/group access through shared services.
Experience in assigning security filters to users/groups as per requirement.
Experience in setting cache buffer in the Applications, for optimum retrieval performances.
Experience in migration of applications from one environment to another using LCM.
Experience in conversion of BSO member formulas to MDX.
Experience in creation of technical documentation.
Environment: Hyperion Essbase, Smartview.
Organization: Tata Consultancy Services
Role : Hyperion Planning/Essbase Support
Client : Covance Inc., USA
Duration : Sep 2013 to Feb 2014
Synopsis:
Covance Inc. with headquarters in Princeton, New Jersey, is a contract research organization providing drug development and animal testing services. It is using Oracle Hyperion Tool for their Reporting, Planning and Budgeting process. Existing Hyperion system is having 6 planning applications (Classic) and provided support for application maintenance and worked on enhancements
Roles and Responsibilities:
Experience in taking Level0 and planning artifacts backup on daily basis.
Maintained and supported the Hyperion planning classic applications.
Involved in financial reporting as a report designer.
Experience in preparation of documentation for supporting end users for trouble shooting issues.
Experience in resolving Hyperion Smart View Add Ins issues in Microsoft Excel.
Having experience in analyzing issues in order to determine root causes analysis.
Strong experience in performing data validation after migration of the application from test environment to production.
Experience in creation of automated batch scripts for Level0 backup and artifacts backup using Maxl & LCM utility respectively.
Experience in Hyperion planning classic application migration from one environment to another.
Experience in troubleshooting service related issues.
Involved in performance tuning of the applications by arranging outline in hour-glass model and by setting index and data cache values in Essbase.
Experience in maintenance of FR reports using FR studio.
Experience in defragmenting Essbase cubes by performing restructure on weekly basis.
Having Experience in creation of VBScripts to automate the process of monitoring page file count on daily basis.
Environment: Hyperion Planning, Hyperion Essbase, Hyperion FR Studio, Smartview and Batch Scripting.
Contact this candidate