Support Specialist Oracle Hyperion

ARYA PALLEMPATI Cell Phone: 774-***-****

ORACLE ESSBASE CERTIFIED IMPLEMENTATION ***************@*****.*** SPECIALIST www.linkedin.com/in/arya-p

Citizenship: U.S. Citizen

Security Clearance: Public Trust

Desired Location: Washington DC Metro Area.

Certifications: Oracle Essbase 11 Certified Implementation Specialist Professional Summary:

• Highly skilled and experienced IT professional with over 8 years of experience in analyzing, designing, developing, implementing, tuning, and supporting the Oracle Hyperion Suite of tools including Hyperion Essbase, Hyperion Financial Reporting, and Hyperion Planning.

• Hands-on experience with EPBCS applications and expertise in EPMA on loading and maintaining metadata in Master Library, creating and deploying EPMA Application for Essbase and Planning. Strong experience in dynamic dimension building and data loading using Essbase Rules files, ODI, and EPMA.

• Expert in Hyperion Essbase Rules File, Calculation Script, Report Script, and have extensive experience in automation process by developing MAXL Scripts, ODI Scenarios, Task Flows, FR batches, and DB backup.

• Expertise in developing Task list, Business Rules, Data Grids, and Data forms and strong experience in implementing Hyperion Essbase security, dimension level security in planning, and Reports level Access.

• Proficient in Hyperion System 9/11.xBI+, Hyperion Essbase 11.x/9.x, Hyperion Planning 11.x/9.x, Hyperion Reports, ESSCMD, MAXL, Essbase Excel Add-In, and have expertise in Partitioning, Calc scripting, and dimension build, Data Load Rules, Tuning, and Optimization.

• Experience in the creation and maintenance of Hyperion planning applications, business rules, webforms, security groups, and users. Strong overall systems, business analysis, design skills, and full lifecycle implementation experience.

• Overall, Arya is a highly skilled results-oriented IT professional with a proven track record of delivering innovative and effective solutions to complex business challenges in fast-paced, team environments.

ARYA PALLEMPATI Cell Phone: 774-***-****

ORACLE ESSBASE CERTIFIED IMPLEMENTATION ***************@*****.*** SPECIALIST www.linkedin.com/in/arya-p

Technical Proficiency:

OLAP Oracle EPBCS, Essbase, Planning (Classic & EPMA), 11.1.2/11.1/9.3/9.3.0/9.3.1, ESSCMD, MAXL

Reporting Tools Hyperion Financial Reports, Smart View, Hyperion spreadsheet Add In, Web Analysis, Dashboards

Database Oracle 11,8.x & 8.1.5, 8.1.6, 8.1.7, 9i, SQL Server 2000/2005/2008, MS Access 2003

Operating System Microsoft Windows 2000/2003/2008

ETL Oracle Data Integrator

Professional Experience:

Employer: Deloitte August 2021 - Present

Role: IT Consultant/DC Solution Specialist

Responsibilities

● Worked on Oracle Hyperion Planning application EPBCS (EMPCOMP, FORMLTN, EXECTN, BUDCIO) to assist in the budgeting and planning process.

● Collaborated with stakeholders, process specialists, and users to elicit and document business requirements; evaluated alternate solutions and designed processes and systems.

● Developed and maintained technical documentation for core system processes, including break fix manuals and maintenance playbooks.

● Provided end user support for application and reporting training, and created/modifed calculation scripts, business rules or forms to meet enterprise requirements.

● Engaged in 2+ full implementation lifecycles, with relevant experience in financial accounting and planning.

ARYA PALLEMPATI Cell Phone: 774-***-****

ORACLE ESSBASE CERTIFIED IMPLEMENTATION ***************@*****.*** SPECIALIST www.linkedin.com/in/arya-p

● Monitored and refined Hyperion solutions, and contributed to the development of overall architecture and strategy for the deployment of Hyperion technology.

● Demonstrated technical development exposure to Oracle Hyperion Planning using Essbase, and knowledge of Oracle’s EPM competitors.

● Estimated task levels and provided input on project schedules, with strong analytic, problem-solving, and debugging skills.

● Maintained end user security, including creating and provisioning user groups, filters, and security profiles aligned with business needs.

● Provided timely and effective technical support to troubleshoot issues and minimize downtime during month-end close and forecasting process.

● Assisted with internal control documentation, and performed quarterly metadata and user access reviews.

Client: Toronto Dominion Bank (TD bank) April 2016 – July 2021 Role: IT Support Specialist / Design Specialist

Responsibilities:

● Reduced the nightly package run time from 7 hours to 90 minutes by cube optimization and fine-tuning settings.

● Optimized the performance of applications by tuning cubes, tweaking Dense/Sparse settings, Cache settings, Outline formulas, and Calc scripts to ensure fast data loads, quick calculation times, and fast retrieval of reports.

● Balanced the calculation and retrieval performance needs by optimizing Essbase application.

● Executed test plans, scenarios, scripts, and procedures, and identified best practices in sprint testing.

● Participated in requirements gathering for testing and collaborated with Business and Risk Stakeholders to perform testing and resolve issues.

● Conducted regression testing every time code changes were made to fix defects.

● Managed end-to-end project planning, scheduling, execution, risk management, client communication, status meetings, and reporting.

● Provided functional support for developers by clarifying questions on business processes and domain information.

● Developed and maintained Rule Files, MaxL Scripts, Esscmd, and Calc Scripts& Reports.

ARYA PALLEMPATI Cell Phone: 774-***-****

ORACLE ESSBASE CERTIFIED IMPLEMENTATION ***************@*****.*** SPECIALIST www.linkedin.com/in/arya-p

● Collaborated proactively with project leadership to identify and resolve key risks in the Hyperion upgrade project.

● Updated business rules to replicate the functionality of complex formulas existing in excel.

● Created new and updated existing Web forms for various users with POVs and Pages.

● Maintained and supported Hyperion Planning application (TDPLAN01), implemented the application security process, created users/groups, security profiles, and application access to different groups using filters.

● Conducted training and workshops for users on new features in Smart View and Web analysis 11.1.2.1.

● Created a VISIO diagrams and worked on updating the current manual process to automate using SSIS packages.

● Provided support for existing cubes, identified problems, resolved them, and documented the resolutions.

● Provided Hyperion Planning support, user training, documentation, and deployment.

● Designed and developed web-based reports using Web Analysis.

● Developed Report Scripts to export a subset of the database.

● Monitored scheduled reports and batch scheduler failures. Client: Food and Drug Administration May 2014 – March 2016 Hyperion Planning/Essbase Developer

Responsibilities:

● Engaged in requirement analysis and documentation, leading to an effective Hyperion solution that incorporated user needs by converting Excel-based Budgeting and Forecasting processes to Hyperion Planning to increase efficiency.

● Created business rules that replicated the functionality of complex formulas existing in Excel.

● Developed dynamic web forms for various users with POVs and Pages.

● Improved Hyperion Smart View retrieval performance from 10 minutes to about 5 seconds.

● Designed the overall workflow of the budgeting and forecasting process with kick-off, reviews, and approval states.

ARYA PALLEMPATI Cell Phone: 774-***-****

ORACLE ESSBASE CERTIFIED IMPLEMENTATION ***************@*****.*** SPECIALIST www.linkedin.com/in/arya-p

● Maintained and supported Hyperion Planning applications (FDAEXE, FDAFRM, and FDASAL), also implemented an application security process by creating users/groups, security profiles, and application access to different groups using filters.

● Responsible for scripting and automating Essbase Commands using Maxl, EPMA using EPMA batch Client.

● Created Aggregate Storage (ASO) applications from Block Storage (BSO) applications for executive-level reporting.

● Worked on design documentation for various applications.

● Created both source and target model folders, models, and data stores.

● Created interfaces, defined optimization context and staging areas, performed source and target data store mapping, and defined properties.

● Defined filters and constraints as required to run execution and worked with the Operator if an error occurred.

● Created several interfaces/packages to extract metadata/data from Source systems and load them into EPMA interface tables for metadata and load data into Essbase.

● Created end-to-end automation packages to load metadata and data.

● Created groups and users for different business segments and then assigned security and filters to define Essbase privileges on them.

● Provided support to users on access-related issues, and for some users, installed Essbase add-ins and Smart View. Mentored and guided FDA business users on all Hyperion products on Hyperion Planning & Essbase.

● Responsible for providing functional support to testers by providing guidance on the business processes and scenarios and answering queries on test coverage.

● Created Change Requests (PCR) in QuickBase and prepared change management artifacts by working closely with business stakeholders to prioritize and address critical problems. Procured resources and secured funds required for change implementation. Presented changes to the change control board to ensure smooth approvals. Education:

• Bachelor of Engineering in Information Technology - Nagarjuna University, India

• Master of Science in Information Technology - Leeds Beckett University, UK

Contact this candidate