Home

Sai Nallamothu - Oracle Hyperion

[email protected]

Location: Elliston, Virginia, USA

Relocation: Open

Visa: H1B

Name: Sai nallamothu Contact: +1 703-745-8917 SAI NALLAMOTHU [email protected] | 703-745-8917 | Profile Summary: Accomplished Oracle Hyperion Planning consultant having 4+ years of experience in PBCS, EPBCS, Hyperion, Essbase, FCCS, FDMEE, ARCS and migrations from on premise to Oracle Cloud. Acquired experience in gathering Business Requirements, Analysis, Design, Develop, test, implement and documenting end to end Oracle Enterprise Performance Management. Developed and implemented performance tuning strategies and managed migrations as part of the successful deployment of Hyperion On-Premises platforms. Having strong knowledge on designing and tuning Essbase applications and automating jobs using batch scripts and shell scripts. Developed and troubleshooted the data load rules, calculation scripts, business rules, web forms. Utilized Groovy scripting to create dynamic business rules, enabling more flexible and efficient financial planning models in Hyperion EPM. Extensive experience in development, production support, and administration tasks within Hyperion EPM products. Developed and implemented seamless integrations using Oracle Integration Cloud (OIC) to automate data flows between Oracle EPM and various external financial systems. In-depth knowledge of cloud-based SaaS solutions and strong understanding of FP&A processes, including bottom-up planning, scenario modeling, allocations, account reconciliations, intercompany eliminations, currency translation, and top-side adjustments. Managed application migrations from Test to UAT and Production environments. Proficient in using EPM automate and utilized SmartView to create and modify ad-hoc reports to enable real-time data analysis. Integrated EPM systems with ERP solutions (Oracle Fusion and SAP) for seamless data flow and reporting. Developed profitability models to identify cost-saving opportunities, leading to reduction in operational costs. Conducted user training sessions and created comprehensive documentation for end-users, improving system adoption. Automated complex financial reports using Smart View and Narrative Reporting, reducing manual effort. Strong analytical skills complemented by a deep understanding of financial management principles and best practices. Skills: EPM Tools: PBCS, FCCS, EPBCS, On Premise Hyperion Planning 11.2.10, PCMCS, FDMEE. Automation Tools: EPM Automate, Rest APIs. Reporting Tools: Reporting Web Studio (PBCS/EPBCS), Smart View. Languages: Groovy, Batch Scripting, SQL, MAXL. MS Office Tools: MS Word, PowerPoint, Excel. Other Skills: Business Requirements Gathering, Design Documents, Process Flow &, Data Flow Diagrams. Professional Experience: Flag Star Bank Troy, MI, USA Oracle Financial Analyst Jan 2024 Present Analyzed banking business processes and user requirements for financial planning, budgeting, and reporting, ensuring alignment with the needs of banking institutions. Built and managed ASO (Aggregate Storage) and BSO (Block Storage) applications in Oracle PBCS, customized to support banking specific use cases such as risk management and financial forecasting. Designed and implemented Cubes and forms to enhance planning and budgeting activities for banking clients, improving operational efficiency Developed and managed integrations using APIs (Oracle Integration Cloud - OIC), streamlining system connectivity for secure and efficient data flows across core banking systems. Streamlined delivery of Oracle EPM solutions by leveraging EPCM practices, enabling optimized resource allocation, cost control, and profitability analysis for banking clients. Developed custom Groovy solutions to address banking-specific business requirements and improve the functionality of Oracle Cloud EPM applications. Configured and loaded financial data, including actuals and budgets, ensuring data accuracy and compliance with banking regulations through robust data management practices. Automated key financial processes using EPM Automate, reducing manual intervention and increasing operational efficiency in banking operations. Created complex business rules, web forms, dimensions, menus, and member functions tailored for banking needs, and developed REST APIs to integrate financial systems seamlessly. Additionally, generated multiple Adhoc based HSGet reports using Excel SmartView for banking data insights. Managed user/group security in access control, creating and maintaining secure user accounts within Oracle Identity Domain for banking compliance. Developed financial models and scenario planning frameworks in Oracle PBCS, enabling precise top-down and bottom-up planning for credit risk analysis and liquidity management. Designed and implemented web forms with validation rules, enhancing data entry accuracy and user experience in financial systems. Managed data and metadata loading with FDMEE, optimizing data integration workflows with advanced mapping techniques specific to banking systems. Optimized data pipelines within Oracle EPM, facilitating seamless integration and transformation of large-scale financial data. Documented comprehensive procedures and processes, enabling efficient knowledge transfer and smooth collaboration among banking teams and stakeholders. Environment: Oracle EPM to include EPBCS, SmartView, FCCS, Excel, Financial Reporting studio, FDMEE, SQL, Groovy. PennyMac Charlotte, NC, USA Oracle Hyperion Consultant May 2023 Dec 2023 Worked on a comprehensive Hyperion Planning application for the Cost Area to optimize the existing application. Developed multi-currency translation solutions for EUR, USD, and other reporting currencies to ensure accurate financial reporting and compliance with global standards. Worked on integration and migration of Data Management processes and created various mappings using SQL. Implemented both bottom-up and top-down data entry functionality, offering flexible data input options to users for more dynamic planning processes. Designed and deployed Oracle Integration Cloud (OIC) solutions for connecting Oracle EPM modules (Hyperion Planning, Financial Consolidation) with on-premises and cloud applications. Converted existing Excel-based reports into Financial Reporting Studio, aligning them with user specifications to improve accuracy and reporting capabilities. Developed and optimized MDX member formulas for ASO cubes to enhance data performance and improve reporting outcomes. Utilized Excel with Smart View to perform ad-hoc analysis and generate real-time reports from Oracle EPM, significantly improving decision-making capabilities. Configured mappings, locations, import formats, and scripts in Data Management for seamless monthly data loads into Oracle Planning applications. Developed business rules using MAXL scripts to efficiently transfer data from BSO to ASO cubes. Created and optimized business rules to enable seamless data transfers between different planning applications. Trained users on the effective use of applications, data management processes, and financial reporting tools to enhance user adoption and system utilization. Managed application backups using LCM and MAXL, and created and modified reports in Financial Reporting Studio to ensure consistent and reliable reporting. Environment: On Premise Hyperion Planning, Smart View, Data Management, Reporting Web Studio. HCL Tech Hyderabad, India EPM Consultant May 2023 Dec 2023 Provided ongoing application support and implemented enhancements by troubleshooting and resolving issues in a timely manner to maintain system reliability. Designed and developed data forms with validation rules to meet client specifications, improving data accuracy and user experience. Created key application artifacts such as task lists, reports, data maps, and valid intersections to enhance system functionality and usability. Developed and implemented business rules for allocations to meet specific business requirements, optimizing resource planning. Created data maps to facilitate the transfer of data from BSO to ASO cubes, enhancing system performance and improving reporting capabilities. Managed and updated metadata as part of monthly close activities, ensuring data accuracy and compliance with financial reporting standards. Configured user roles and managed security provisions to ensure appropriate system access and maintain data integrity. Participated in month-end activities including loading actual data and creating/updating data mappings to support financial close processes. Developed data load rules and mappings in Data Management to streamline and automate data import processes from PCMCS to PBCS applications. Worked across Production and Test environments, handling projects, maintenance requests, bug fixes, enhancements, and data updates to ensure smooth operations. Created batch scripts to export data from PBCS applications to external files, automating key processes and reducing manual effort. Environment: PBCS, PCMCS, EDMCS, EPM Automate, Batch Scripting, Windows Servers. Education: Master of Science in Computer Information Systems Jan 2022- May 2023 New England College MA, USA Keywords: active directory microsoft Massachusetts Michigan North Carolina