Ranojoy Paul

Oracle EPM/Hyperion Consultant with around 5 years of experience delivering enterprise-scale Oracle Hyperion solutions across production support and application administration. Expertise in Oracle Essbase, Hyperion Planning, Smart View, and Hyperion Financial Reporting (HFR), with hands-on experience in metadata management, data validation, reconciliation, defect analysis, and financial close support. Proven track record of ensuring application stability, optimizing business processes, and providing timely resolution of complex production issues while maintaining adherence to SLAs.

Experienced in collaborating with finance stakeholders, business users, and cross-functional technical teams to support critical planning, budgeting, forecasting, and financial reporting processes. Demonstrates strong analytical, problem-solving, and communication skills, with a commitment to delivering high-quality solutions and driving continuous process improvements in fast-paced enterprise environments.

Analyst at Tata Consultancy Services (2021-09 – Present)

Oracle Hyperion Planning & Essbase (On-Premises) | Financial Reporting Studio (HFR) | Planning Data Forms | Smart View | Lifecycle Management (LCM) | Business Rules & Calc Scripts | MaxL | Batch Scripting | SQL | Python | Process Automation.

• Administered Oracle Hyperion Planning and Essbase production environments.
• Collaborated with finance team during budgeting, forecasting, month-end, and year-end financial cycles.
• Managed metadata, security provisioning, data loads, LCM migrations, and application performance tuning.
• Led end-to-end Oracle Hyperion EPM environment upgrade from version 11.1.2.4 to 11.2.8, including Planning, Essbase, HFR, Calculation Manager, Shared Services, Batch and Python scripts and QA/SIT validation.
• Led Oracle quarterly CPU patch implementation with minimal downtime.
• Developed Python and Windows Batch automation to reduce manual effort and improve operational efficiency.
• Performed root cause analysis and resolved production incidents within SLA.

Subject Matter Expert (SME) – Mathematics & Computer Science at Sansaptak (2017-10 – 2021-03)

Teaching & Mentoring | Foundation & Higher Secondary Mathematics | Computer Science | Analytical Thinking | Problem Solving | Communication | Presentation Skills | Student Assessment | Curriculum Planning.

Bachelor of Technology in Computer Science & Engineering – MCKV Institute of Engineering, Liluah, Howrah (2017-07 – 2021-09)

Higher Secondary in General Science – Uttarpara Amarendra Vidyapith, Uttarpara (2015-05 – 2017-05)

Secondary in General Study – Uttarpara Amarendra Vidyapith, Uttarpara (2014-05 – 2015-05)