Summary
Overview
Work History
Education
Skills
Certification
Declaration
Timeline
Generic
John Celestina J

John Celestina J

Oracle Technical Consultant
Chennai

Summary

  • Having 6.4 years in the field of Oracle Fusion Cloud Applications& Oracle Applications Release R12 Enterprise Business Suite.
  • Extensive experience in Oracle Application Implementation Methodology (AIM), applying best practices across the project lifecycle to ensure successful Oracle EBS implementations.
  • Highly experienced on BI Publisher, OTBI, FRS & FWS Reports.
  • Good experience on creating RTF Templates, Excel Templates & XSLT.
  • Hands on Knowledge on Business Process Management (BPM) & Descriptive Flex Field (DFF), OTBI Dashboard, Analysis.
  • Extensively worked on Oracle Cloud Applications modules like AP, PO, PPM & GL Modules.
  • Hands on Experience on Manual testing in AP, AR, PPM& GL modules.
  • Gained basic knowledge of using File-Based Data Import (FBDI) for customer and supplier data uploads into Oracle Fusion applications.
  • Configured FTP server to integrate Oracle Fusion Cloud Application with other ERP.
  • Possess foundational knowledge of SOAP and REST API web services, understanding their architecture and protocols for data exchange.
  • Familiar with the standard documents like MD70 documents based on the functional design document MD50 by following the AIM methodology.
  • Highly experienced in developing & customizing Oracle forms and Reports.
  • Experience with Oracle and Other Utilities: TOAD, SQL*Loader, SQL Developer.
  • Good team player with strong interpersonal, analytical and Communication skills.
  • Self-motivated, excellent team player with proven leadership skills.

Overview

8
8
years of professional experience
6
6
Certifications

Work History

Senior Analyst

Thryve Digital Health LLP
11.2022 - Current
  • Collaborated with cross-functional teams and with Stakeholders to identify areas of improvement, leading to increased effectiveness of business needs.
  • Developing customizing & Enhancing BIP & OTBI reports, summarizing and presenting data in visually appealing format.
  • Maintaining strong working relationships with clients, ensuring their needs were met while exceeding expectations on deliverables.
  • Analyzed data to identify root causes of problems and recommend corrective actions.
  • Optimized BIP report performance by troubleshooting and streamlining report generation processes, resulting in faster load times and better system resource utilization.
  • Prepared MD 70 Technical Specification Documents for newly developed reports ensuring detailed documentation for the development and implementation of technical processes.
  • Exploring FAW/FDI (Feature/Application/Software): Actively learning and familiarizing with the features of FAW to enhance technical proficiency in data analysis and reporting.

Associate Consultant

Quadrobay Technologies Pvt Ltd
06.2021 - 10.2022
  • Involved in Requirement Gathering for the Custom Object Development.
  • Build Inbound & Outbound Integrations using BIP, Webservices
  • Integrated LMS (Loan Management System) with Oracle Fusion using REST and SOAP APIs to automate the transfer of General Ledger (GL) transactions, ensuring seamless data flow between systems.
  • Involved in the development and customization of Financial Statement Reports in Financial Reporting Studio (FRS) & Financial Web studio (FWS), including Balance Sheet and Profit & Loss reports, to meet organizational financial reporting requirements.
  • Basic Knowledge in Business Process Management (BPM), configuring and automating business processes to improve efficiency and streamline workflows across various business units.
  • Gained basic knowledge of using File-Based Data Import (FBDI) for customer and supplier data uploads into Oracle Fusion applications.
  • Configured FTP connections to Adaptive Server (Client System), enabling seamless and secure file transfers between Oracle Fusion to other Client system using BIP (Trail Balance Report) using Bursting.

Associate Technical Consultant

TransformEdge Pvt. Ltd.
08.2020 - 05.2021
  • Designed custom solutions, leading to increased productivity for clients.
  • Delivered an informative demo sessions to clients on the E-way Bill and E-Invoice generation flow within Oracle E-Business Suite, demonstrating key features and benefits of the solution.
  • Explained the step-by-step process for generating E-way Bills and E-Invoices, highlighting system configuration, compliance requirements, and integration within Oracle EBS.
  • Customized Oracle Reports to generate dynamic Barcode and QR Code images in XML format, ensuring compatibility with business workflows.
  • Developed user-friendly documentation for seamless knowledge transfer and training purposes.

Technical Consultant

Chainsys India Pvt Ltd
01.2017 - 02.2019
  • Collaborated with clients to gather and analyze requirements, converting them into efficient and accurate data templates.
  • Registered and configured Executable programs, Concurrent Programs, and Request Sets within Oracle Applications using Applications Object Library (AOL).
  • Used Oracle EBS (E-Business Suite) tools for development of Oracle reports & Forms related to concurrent requests and executable registration.
  • Developed and implemented key reports such as Purchase Order Report, Repair Transaction Report, and Stock Transfer Report, improving visibility and decision-making for business operations.
  • Managed and Collaborated with business stakeholders and tax authorities to gather requirements and ensure successful alignment with VAT Implementation using Oracle E-Business Tax of Oracle EBS R12.1.1VAT.
  • Involved in End to End Implementation Project of Oracle Fusion Cloud by Implementing HCM & GL Module and Analysis of the entire business process of the organization.
  • Developed and customized Business Intelligence (BI) and Oracle Transactional Business Intelligence (OTBI) reports (GL Trial Balance Report,Project Exit Status Report,New Hire Report,Assignment Costing Report.) in alignment with the MD 50 document specifications, ensuring business requirements were met.
  • Explored and integrated Oracle IoT Cloud Services with Raspberry Pi to streamline data collection and real-time monitoring, enhancing operational efficiency for HR planning automation.

Education

MBA - Technology Management

Anna University
04.2001 -

Bachelor of Engineering - Electronics And Communications Engineering

Vaigai College of Engineering
04.2001 -

HSC -

St.Joseph’s Matriculation Higher Secondary School
04.2001 -

SSLC -

St.Joseph’s Matriculation Higher Secondary School
04.2001 -

Skills

Oracle Fusion Application

Certification

Oracle Cloud Fusion Analytics Warehouse 2023 Certified Implementation Professional

Declaration


I hereby declare that the above-furnished details are true to the best of my knowledge.

DATE 

PLACE 

Timeline

Oracle Cloud Infrastructure 2024 certified Foundation Associate

10-2024

Oracle Cloud Infrastructure 2024 AI Foundation Associate

10-2024

Oracle Cloud Data Management Foundation Associate 2023

10-2023

Oracle Cloud Fusion Analytics Warehouse 2023 Certified Implementation Professional

09-2023

Oracle Cloud Infrastructure 2023 AI Foundation Associate

09-2023

Oracle Cloud Infrastructure 2023 certified Foundation Associate

08-2023

Senior Analyst

Thryve Digital Health LLP
11.2022 - Current

Associate Consultant

Quadrobay Technologies Pvt Ltd
06.2021 - 10.2022

Associate Technical Consultant

TransformEdge Pvt. Ltd.
08.2020 - 05.2021

Technical Consultant

Chainsys India Pvt Ltd
01.2017 - 02.2019

MBA - Technology Management

Anna University
04.2001 -

Bachelor of Engineering - Electronics And Communications Engineering

Vaigai College of Engineering
04.2001 -

HSC -

St.Joseph’s Matriculation Higher Secondary School
04.2001 -

SSLC -

St.Joseph’s Matriculation Higher Secondary School
04.2001 -
John Celestina JOracle Technical Consultant