Mahalaxmi Ch

Around 10+ years of IT experience in Oracle Hyperion EPM systems and Hyperion Planning implementations. Involved in Requirement Gathering, Testing and Database Administration of OLAP and Client/Server projects. Involved in successful implementation of 1 full life cycle, starting from require gathering to end user trainings.

Worked in varied environments of Development, Production-Support, and Maintenance projects. Supported and maintained PBCS and EPBCS applications. Worked on Strategic model (Scenario Modeling) for what If scenarios and long-range planning.

Extensively used IPM( EPM Integrated AI) and Predictive Planning for auto forecasting and bugeting. Developed forms, business rules, TaskList, Menus, Navigation flow, validation rules, datamaps, epmautomate in EPBCS application. Developed data interion between Source to EPBCS/PBCS application using data management.

Worked on Essbase ASO, BSO applications. Written\modified Calcscript and Business rules as per business requirement. Developed\Modified data load rules using flatfiles and Oracle database. Written\edited Maxl’s for automation, data retrieval, Properties settings, cube building and etc .

Key strength in Automation, Optimization and Performance Tuning of Essbase application. Created templates and ad-hoc reports using Excel Add-in, Smart view for budget and forecast analysis. Developed simple to complex Hyperion Reports for higher managements and for internal and external audit purpose.

Strong experience in interacting effectively with business stakeholders and technical teams at all levels of the organization. Proven success in delivering the projects on time with high customer satisfaction. Excellent written and oral communication skills and a team-player with a results-oriented attitude.

Skilled in managing enterprise-wide Oracle EPM environments, supporting large user communities, and ensuring application stability, scalability, and compliance with governance standards. Expertise in identifying performance bottlenecks and implementing optimization strategies that improve calculation performance, reporting efficiency, and user experience. Strong experience supporting cloud transformation initiatives, application migrations, release management activities, and continuous improvement programs within Oracle EPM ecosystems.

Recognized for delivering high-quality solutions in fast-paced environments while maintaining strong stakeholder relationships and consistently achieving project milestones. Effective team player with excellent analytical, problem-solving, and communication skills, capable of collaborating across cross-functional teams to deliver business-critical financial planning solutions.

EPM Developer - Watlow - St. Louis, MO

(2023-03)

• Gathered and analyzed business requirements and translated them into Oracle EPBCS technical solutions.
• Configured and customized Oracle EPBCS applications to support budgeting, forecasting, and financial planning processes.
• Developed and maintained Forms, Dashboards, Business Rules, Task Lists, Smart Lists, and Navigation Flows. Created and enhanced calculation scripts and business rules to automate planning and forecasting activities.
• Managed metadata updates, hierarchy maintenance, and application enhancements. Designed and maintained Data Management integrations for loading data from multiple source systems.
• Performed monthly maintenance activities, including metadata changes, mappings, and security updates. Supported month-end and year-end financial close processes.
• Worked with Oracle Intelligent Performance Management (IPM) Predictive Planning to generate statistical forecasts based on historical data trends.
• Configured and utilized Predictive Planning features within Oracle EPBCS to improve forecast accuracy and reduce manual planning efforts.
• Analyzed prediction results, confidence intervals, and forecast variances to support business planning and decision-making processes.
• Developed and optimized Financial Reports and Smart View reports for executive and business users. Automated routine administrative and business processes using EPM Automate.
• Monitored and resolved application performance issues, job failures, and user access issues. Provided L2/L3 production support and performed root cause analysis for critical incidents.
• Optimized calculation scripts, reports, and data retrieval processes to improve system performance. Prepared technical design documents and solution specifications.
• Collaborated with Finance, Accounting, and Business stakeholders to deliver new enhancements and process improvements. Participated in application migrations, testing, and deployment activities across environments.
• Configured Financial applications for business needs in EPBCS. Customized EPBCS applications to meet business requirement. Provide L2/L3 support for performance issues, login failures, or failed job runs.
• Written\Modified business rules, Smartlist, forms, dashboards as per business requirement using PBCS and EPBCS.
• Developed Forms, Dashboards, Business Rules, TaskList.
• Managed the day-to-day technical administration of the Oracle PBCS Platform for the Global Corporation.
• Monthly maintenance, including metadata and mapping changes, and any related testing, and managing all utilities and tools, including security for users.
• Involved in monthly and Year end closes. Optimized calc scripts and Reports for faster retrieval and output. Streamlined the monthly and year closes.
• Understand functional spec and convert it to technical design doc. Involved in Requirement gathering for new enhancements.
• Environments: PBCS, EPBCS, Data management, OAC, Reports, EDMCS, EPM automate, Smart View, SQL.

Oracle EPM Developer - Chubb Insurance - New Jersey

(2020-09 - 2023-02)

• Participated in requirement gathering sessions and designed Oracle PBCS solutions based on business requirements. Developed and implemented new PBCS applications for budgeting, forecasting, and planning processes.
• Created and maintained Forms, Business Rules, Task Lists, Menus, Navigation Flows, Validation Rules, and Data Maps.
• Designed and developed Financial Reports and Narrative Reports for management reporting. Configured Data Management processes for data integration from source systems into PBCS.
• Developed automated data export and reporting solutions. Implemented EPM Automate scripts to automate metadata loads, data loads, backups, and maintenance activities.
• Performed application migrations between Development, Test, and Production environments. Managed metadata updates and dimensional hierarchy changes.
• Supported monthly forecasting and annual budgeting cycles. Assisted users with Smart View reporting and ad-hoc analysis requirements.
• Performed application validation, testing, and defect resolution activities. Supported Hyperion Planning and Essbase applications in production environments.
• Collaborated with cross-functional teams to implement system enhancements and business process improvements.
• Provided ongoing application support, troubleshooting, and performance tuning. Involved in Gathered requirements and design of PBCS application. Involved in created new PBCS application as per business requir