SUMMARY

• Over 8 years of IT experience in various Hyperion and oracle cloud technologies like - Essbase, Planning, OAC, PBCS, EPBCS, Business Analysis, Requirements, Development, Testing and Database Administration of Data Warehousing and Client/Server projects using industry accepted methodologies and procedures.
• 5 Years of experience in Oracle EPM and Oracle Cloud Technologies.
• Worked in Essbase to Oracle Analytical cloud (OAC) Migration projects.
• Worked in Oracle Planning Budgeting Cloud service (PBCS/EPBCS) Development and Enhancement project.
• Expertise in Analysis, design, development, enhancement, and production support for Oracle EPM Tools.
• Designed and developed Block storage databases with excellent balance of Dense and Sparse dimensions, developing various OLAP Models.
• Worked extensively on System 11.1.2.X/11.1.X, versions on Planning (Budget/Forecasting), ESSBASE 11.1.2.X/11.1.X and reporting tools.
• Strong experience in Hyperion Planning v11.1.2.X Hyperion ESSBASE v11.1.2.X Workforce Planning, Shared services, Hyperion Workspace, EPMA 11 (Enterprise Performance management Architect windows and UNIX systems.
• Created the Meta Data using EPMA (Data synchronization, ADS files), Essbase Studio, Planning (Outline Loader) and in Essbase (EIS, Text files).
• Extensive experience in creating reports using Essbase Excel Add-In and Smart view.
• Experience in Creating Business Rules, Calc scripts, Load Rules, Architecture, Design, Business Logic, Performance tuning, Report development and all the areas related to whole life cycle of Essbase application implementation.
• Well experienced in Planning Application implementation from end to end includes architecting, designing the metadata, building, loading data. Worked with Business unit, Process unit, Review process, Rules.
• Loaded data using Essbase Integration Services (EIS)
• Developed MAXL Scripts, Calc scripts, ESSCMD.
• Used TOAD to connect with database and convert the files to FLAT FILES
• Expert in developing application security process, creating users/groups, security profiles and application access to different groups using filter
• Experienced with Disaster Recovery planning including Import/Export and Backup/Restore process.
• Commendable knowledge and experience in Automation using Batch scripts
• Essbase cube designing and partitioning and optimization of report queries in Microsoft Excel.
• Excellent communication skills, strong analytical and architectural skills, hardworking and a very good team player. Extremely well organized, meticulous, and highly self-motivated.
• Ability to quickly grasp any new technology in a short period of time and apply that knowledge towards the successful completion of the project.

TECHNICAL SKILLS

OLAP: Hyperion Planning 11.1.2.X, EPMA 11.1.X, Essbase, EAS, Hyperion Integration Services.

Oracle Cloud: Oracle Analytical cloud (OAC 12/19/21), Oracle Enterprise Performance Management enterprise cloud (EPMC 21).

Operating Systems: UNIX, Windows 2000/2003/2008 , LINUX

Scripting/Language: MAXL, ESSCMD, CALC scripts, VB script, Batch scripts

Databases: Oracle, MS Access, MS SQL Server 2000/2005, DB2

Server: UNIX, Windows, HP, Solaris.

Reporting Tools: Essbase Add-in, Smart view, Hyperion Financial Reporting.

PROFESSIONAL EXPERIENCE

Hyperion Consultant

Confidential, Plano, TX

Responsibilities:

• Worked in Hyperion Essbase 11.1.2.4 to Cloud Migration project (OAC 12/19 and 21).
• Worked in Essbase CLI Client and Life cycle Management tool to migrate Essbase application to OAC Cloud.
• Worked in Essbase Maxl and Automated Batch script to integrate TFS source data into cloud application.
• Worked in Oracle planning cloud Enhancement project (EPMC 21) to modify business rules.
• Worked in Cloud EPMC Planning Extensions to update metadata.
• Worked as Hyperion Essbase developer, workforce Planning Developer and Cloud migration and enhancement projects.
• Involved in gathering requirements and developing project plan & system level requirement definition (SLRD).
• Analyzing the raw data and converting it into valuable business information by design & development of appropriate cubes & reports provided seamless integration of historical, projected & derived data.
• Migrated applications from development environment to production environment.
• Automated the entire build, load and calculations using ESSCMD scripts
• Worked on the monthly reports in development phase to introduce them into the production phase after testing and verifications.
• Deployed dashboards for easier end user interaction and report generation.
• Developed complex Formulas, Calc scripts and rule files for reporting application.
• Developed automation scripts for back up and Refresh of all Production Cubes during recovery.
• Extensively used calculation commands and functions to improve the performance of applications. Developed Calc Scripts for complex calculations and optimized them.

Environment: Hyperion Essbase 11.1.2.4, Hyperion Planning 11.1.2.4, Oracle11g, Windows 2008.

Hyperion Developer

Confidential, Irvine, CA

Responsibilities:

• Analyzing the raw data and converting it into valuable business information by design & Development of appropriate cubes & reports.
• Headcount
• 1) Change counting of headcount currently done as body count and not FTE. Interns and P/T need to flow through the budget system as less than 1 headcount.
• 2) Create new form to enter contractors and consultants individually by month or itemization of consulting firms or project budgets by month.
• 3) Include titles in HP system to ease actual vs. budget comparisons once year begins (New Hires and Open Requisitions). Ensure using same code from HP new hires and open requisitions in Open Hires and monthly headcount report from HR.
• Commission
• 1)Written different calculation script to distribute commission percentage different region.
• Other Form Changes
• 1) Ability to link or embed assumptions directly in forms (example: T&E)
• 2) IT cost allocation process in HP requires realignment with AX. HP business rule allocates IT global cost pool to each entity each department using global headcount but AX allocates IT cost locally to each department using global headcount. This creates discrepancies by entity even though total function allocation remains intact. Need new IT form to be able to enter data entity specific or derive by entity via modified business rules. (HP budget process uses global expenses/global HC * entity HC in respective department and AX process uses entity expenses* (global department HC/total global HC))
• Designed/Modified Outlines, Business Rules, Calc scripts, Rules files, MAXL Scripts as per requirement.
• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data.
• Used Essbase administration activities such as filter creation, creation of users, and creation of groups and maintenance of Essbase Servers.
• Extensively worked on Database optimization and performance tuning of Essbase cubes for fast retrieval and calculation performance.
• Created excel add-in reports from the workforce planning module of Hyperion planning.

Environment: Hyperion Essbase 11.1.2.3, Hyperion Planning 11.1.2.3, Smart view, Windows 2003 server.

Hyperion Developer

Confidential, Oakland, NJ

Responsibilities:

• Configured with Application Server and Database. Involved in the designing the dimensions.
• Experience in the installation of Hyperion products on several different environments like Windows, and UNIX environment.
• Automated the Essbase Cubes using Esscmds and Batch Scripts.
• Optimization and performance tuning for Data Load/Calculations.
• Essbase Development and Maintenance of Essbase Cubes.
• Hyperion Planning is used to build the Planning and budget application from the scratch to meet the business functional requirement and to map the data from the external sources applications.
• Perform migrations of Essbase, Planning and other products from source systems to new systems.
• Designed and developed web-based data entry forms with in Hyperion planning.
• Maintain Outline, Metadata, Member formulas as business requirement changes.
• Meta data is developed in Hyperion Planning for the actual or Budget data and loading the data.
• Developed web forms using Hyperion Planning web client for the users to input
• Forecast, Budget, Actual, Accounting changes and other variance explanations data.
• Designed Reports as per user requirement using Hyperion Reports.
• Scheduling the reports based on the user requirement.
• Doing Process Management and locking various Entities on client request.

Environment: Hyperion Planning 11.1.1.3, EPMA, Shared services, Workspace, Hyperion Essbase 11.1.1.3, Oracle 10g, Smart view, Financial Reporting, Windows Server 2003.

Informatica Developer

Confidential

Responsibilities:

• Analyzing the Source and Target Data.
• Developing the different types of mappings using Designer Tool.
• Extensively using Transformations for homogeneous and heterogeneous data joins like Joiner, and created various Transformations like Joiner, Aggregate, Expression, Filter, Update Strategy and Lookup, stored procedures.
• Used Informatica server Manager to create different types of batches, command, session, email, scheduling and running the session.
• Monitoring the sessions, batches, and logs server manager.
• We are fixing the bugs using debugger tool in designer.

Environment: Oracle 8i, Informatica, Windows NT

SQL Developer

Confidential

Responsibilities:

• Involved in maintenance, documentation, coding, and testing of the system
• Setup of Standby database for faster disaster recovery and data guard setup for high availability.
• Installation and configuration of SQL Backtrack for backup and disaster recovery.
• Load balancing, databases/schema/table re-organization for faster performance.
• Upgraded Database from .
• Created &, managed different kind of table space, space issues, extent, and storage parameters.
• Using export and Import utilities.
• Adding new user accounts create profiles, roles & assigned them to different users.
• Checking the alert logs regularly.
• Supporting and learning both production and development activities
• The size of the databases between 30 GB and 80 GB
• Data refresh from one database to another
• Did research on different configuration to expertise my skills.
• Implemented and tested standby database configuration.
• Learnt user management, project management and trouble shooting skills

Environment: WINDOWS 2000 SERVER, VC++ 6.0, MS SQL Server 2000 and 2005.