Business Analyst Data Management

Name: GOWTHAMI DOMA

Email: *****************@*****.*** Phone: 341-***-****

LinkedIn: https://www.linkedin.com/in/gowthami-doma-7a918b88/

Professional summary:

Overall 9 years of Techno functional expertise in Oracle EPM Cloud, PBCS implementing out-of-the-box (OOB) modules within Oracle Hyperion Planning, including Financials (Financial planning Module), Workforce and Capex, modules. Hyperion Essbase, Hyperion Planning, Data Management/FDMEE, Financial Reporting, and flow of data across different systems/platforms.

Implemented and configured Oracle TRCS for global tax reporting, ensuring compliance with country-specific regulations and automation of tax provisioning processes.

Have good experience in ASO and BSO applications. Much experience in creating Security, Outline, Web forms, Task Lists, Smart Lists, Menus, Business Rules, member formula’s and EPM Automate Scripts in PBCS applications. Develop and maintain Business Rules, Calc Manager scripts, and Groovy scripting to support customized business processes.

Designed and developed tax data models, data forms, and calculation scripts within Oracle TRCS to streamline tax provisioning and reporting cycles.

Performed performance testing of Oracle Cloud Order Management and Finance modules using OpenText LoadRunner Enterprise, ensuring scalability and responsiveness under peak load.

Hands-on expertise in ERP Integration, integrating Oracle R12 ERP with Hyperion/EPM solutions for seamless financial data flow and reporting.

Experience in Agile methodology, working in an onshore/offshore model, coordinating with cross-functional teams to deliver high-impact EPM solutions.

Worked with IBM Cognos Center.

4 years of my experience into healthcare domain and insurance projects.

Worked as Oracle EPM Admin and Business Analyst as well. There is no separate BA and admin roles we used to maintain the applications as an admin and gathering requirements as Business analyst.

Have good experience in the migration of the EPM applications from On-Premises to EPM cloud.

Oversee Data Management and ensure accurate data integration across EPM modules.

Support with HFM (Hyperion Financial Management) on an intermediate level, providing insights and assistance as needed.

Expertise in troubleshooting & performance tuning, resolving key data and technical issues in Hyperion applications to improve system efficiency and reliability.

Successfully implemented a streamlined EPM solution, reducing forecasting cycle time by 40% and enhancing real-time scenario modeling capabilities.

Provides OOTB templates for financial analysis and business modeling.

Worked with PCMCS, ARCS and FCCS.

Utilize EPM Automate and Linux SH scripting to automate processes, ensuring efficiency and accuracy in system operations.

Migrating Models and other artifacts across environments.

Attend daily Scrum and sprint meetings, including sprint planning and backlog grooming sessions.

Performing regular system checks, data validations, and reconciliations to ensure data integrity and accuracy.

Create high-level project plans based on business needs, prioritize tasks, and provide timely project updates to stakeholders.

Identify technical risks and plan contingency/mitigation actions to address potential roadblocks.

Developed Data Actions to calculate complex values in OPEX, CAPEX and WORKFORCE Models.

Defined and created necessary unit test case documents as part of Testing.

Business Rules development in Data Movements.

Developed Smart View, Financial Reporting and web analysis reports based on requirement.

Good experience in Reports scripts development to export data for downstream systems and data movements.

TECHNICAL SKILLS:

Oracle Cloud and EPM Tools : Essbase, Oracle PBCS and EPBCS, EDMCS, ARCS, FDMEE/Data Management, SmartView

Integration Tools : REST API, Data Management, SSIS, SSRS

Custom Application Development : Python, Groovy, Power Shell, REST API, VBA

Scripting & Programming : Groovy Scripting, SQL basics, REST API

Automation & Integration : EPM Automation, REST API

Reporting : Narrative Reporting, TRCS

Oracle Database : PL/SQL, Essbase

PROFESSIONAL EXPERIENCE:

Client: Altice, Bethpage, NY Mar 2024 to till Date

Role: EPM Consultant/Business Analyst

Responsibilities:

Doing some analysis on Revenue Predictive forecasting based on historical data, external market variables, and internal financial metrics to create more accurate and dynamic forecasting.

To create automated, dynamic models that integrate with AI/ML to provide more accurate revenue predictions.

Using machine learning to predict revenue based on multiple variables, integrating AI-driven insights into the forecasting models.

Integrated Oracle TRCS with upstream systems including Oracle ERP Cloud and external data sources to enable seamless data flow for tax calculations.

Implementing Intelligent Performance Management (IPM) to leverage Machine Learning (ML) and Artificial Intelligence (AI) for revenue forecasting and predictions.

Working with Hyperion Essbase and Planning Application support

Working in Hyperion FDMEE Application support.

Provided end-user training and support for Oracle TRCS modules, improving user adoption and ensuring smooth month-end and quarter-end closes.

Designed and executed end-to-end test scenarios and load test scripts targeting key business workflows across Oracle Cloud applications.

Managing Security in Hyperion Shared Services as per the IDM (Identity Management) requests.

Installed Hyperion clients on new user’s machines.

Migrated Hyperion Applications from DEV to QA and QA to PROD and vice versa.

Created Import formats, Locations, dimension level mappings, period level mappings in FDMEE.

Hands on experience in cloning Hyperion Applications using LCM.

Working as admin to provide security to our oracle EPM applications.

Manage and maintain the Oracle Fusion applications environment, including ERP, EPM, HCM, CX, and SCM Cloud.

Supporting Oracle Financial planning modules and ARCS.

Trouble shooting of Smart View, Hyperion Services issues.

Monitor performance and troubleshoot issues.

Created alternative hierarchies as per the reporting requirements.

Defined and created application backups using LCM and other necessary Hyperion utilities based on Hyperion App types.

Supports installations and configuring Hyperion components.

Created automation scripts for dimension building, data loads and business rules.

Implement performance tuning measures for optimal system operation.

Taking care of the month end, planning cycles and year end close activities.

Data Issues & Modification of business Rules and Calculation Scripts.

Provided training to end users on Hyperion planning, Essbase, Smart View, FR and Web analysis.

Experience in managing user/group security in access control and creating users in Oracle identity domain.

Client: Dish Network, Littleton, CO Oct 2022 to Dec 2023

Role: Package Consultant/EPBCS Admin

Responsibilities:

Worked in creating build rules and load rules as part of Essbase cube development.

Worked in integrating with multiple sources in FDMEE development.

Worked as admin to maintain groups level, resource level, department and grade level access control.

Utilized Toad and SQL Developer for data validation, test data management, and backend verification to ensure accuracy of performance test results.

Collaborated with finance and tax teams to align Oracle TRCS configurations with global tax compliance requirements and reporting standards.

Hands on experience in Calculation Script, Business rules.

Monitor service notifications and maintain KPIs, metrics, and dashboards.

Good experience in Reports scripts development to export data for downstream systems and data movements.

Schedule, monitor and troubleshoot of jobs in Hyperion System for error logs and production outages.

Wrote complex SQL queries to extract, manipulate, and validate large datasets supporting performance analysis and test scenario preparation.

Participated in upgrades, patch testing, and system optimization efforts to ensure high performance and stability of Oracle TRCS environments.

Created Classic & EPMA Planning Applications Dimensions loading into Planning using Outline Load Utility Web form development and migration using Form DefUtil.

Implement role-based access control and user security management.

Involved in Security of Planning application and migration using Security Utility.

Defined and created necessary unit test case documents as part of Testing.

Business Rules development in Data Movements.

Developed Smart View, Financial Reporting and web analysis reports based on requirement.

Managed and updated metadata using DRM as part of monthly close activities, ensuring data accuracy and compliance with financial reporting standards.

Experience in managing user/group security in access control and creating users in Oracle identity domain.

Automated key processes using EPM Automate, reducing manual tasks and increasing overall operational efficiency.

Client: IBM, IND Nov 2021 to Apr 2022

Role: EPBCS Consultant

Responsibilities:

Worked on Workforce, Financials and Capex Models configuring and enabling the out of box models.

Automated the data loads using EPM Automate – Data Loads, Dimension Building, Execution of BR’s.

Developed an interface to load Oracle HCM data into Workforce model.

Proficiency in SQL and PL/SQL for troubleshooting and data analysis.

Automated key processes using EPM Automate, reducing manual tasks and increasing overall operational efficiency.

Developed an interface to load GL Actuals into Finance Model.

Work with security, network, development, and product teams to resolve issues.

Ensure data protection and compliance with security standards.

Worked on Valid Intersections and Cell level Security.

Worked on performance tuning of Calc Scripts.

Ensure deliverables align with business processes and design standards.

Worked on Creating the Data Maps or Smart Push between the models.

Build and maintain Oracle EPBCS applications, including financial planning, budgeting, forecasting, and scenario modeling.

Develop strategies for business continuity, disaster recovery, and data integrity.

Worked with cost allocations in profitability cost management PCMCS.

Client: Schneider Electric Private Limited, IND Oct 2019 to Nov 2021

Role: Oracle EPM Analyst

Responsibilities:

Successfully implemented PBCS solutions to the client.

Successfully implemented the data integration from Oracle HCM to PBCS for the Actual Head count data along with Salaries.

Successfully delivered the financial reporting model using the PBCS which involved financial, workforce and Capex cubes.

Collaborated with cross-functional teams to gather and integrate financial data into PBCS, ensuring data accuracy and consistency.

Coordinated with the Business Client for various stages of the project

Created Adhoc Smart View templates for User requirements.

Automated the data loads using EPM Automate.

Worked on Creating the Data Maps or Smart Push between the models.

Worked with reporting and financial consolidation and close FCCS.

Managed data and metadata DRM loading with FDMEE, optimizing data integration workflows using advanced mapping techniques.

Optimized data pipelines within Oracle EPM to facilitate seamless data integration and transformations.

Client: Optum, IND Jan 2017 to Oct 2019

Role: Oracle EPM Developer

Responsibilities:

Involved in requirements gathering, design, development, implementation, SIT & UAT. Development.

Worked Closely with FP&A Teams for Forecast and Budget Closures.

Created Dimensions, Data forms, Calculation Rules for Workforce and Financials.

Created Task List for the Forecast and Plan Cycles.

Worked on Enhancements like updating Calc.

Automated the Variables (Substitution) Maintenance using Maxl in Essbase which was earlier a manual process every month.

Handled Security – Creating Groups and assigning users to the groups and updating dimension level security.

Created and optimized business rules to enable seamless data transfers between different planning applications.

Managed and updated metadata as part of monthly close activities, ensuring data accuracy and compliance with financial reporting standards.

Converted existing Excel-based reports into Financial Reporting Studio, aligning them with user specifications to improve accuracy and reporting capabilities.

Utilized Excel with Smart View to perform ad-hoc analysis and generate real-time reports from Oracle EPM, significantly improving decision-making capabilities.

Client: Sutherland HealthCare IT Solutions, IND Aug 2015 to Nov 2016

Role: Oracle EPBCS Business System analyst

Responsibilities:

As a Hyperion Planning Developer, Responsible for developing the Planning application and data load process to the application.

Manually and using flat files maintained the dimensions.

Created Report Scripts that are used to export data from the backend Essbase application to HFM.

Developed Batch Scripts to automate the data load and data Export process.

Developing rules files to load data into applications and building calculation scripts to calculate the data in the cube as per the business requirements.

Migration of the objects between the environments using LCM.

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.

Automated key processes using EPM Automate, reducing manual tasks and increasing overall operational efficiency.

Supported Hyperion Applications for Health Care Group.

Contact this candidate