Mayur Mhetre
Pune
Summary
Oracle Applications Developer with 15 years of experience in enterprise application architecture and implementation. Skilled in Oracle E-Business Suite (interfaces, conversions, form personalization, SQL, and PL/SQL), Oracle Fusion Cloud, and Oracle Integration Cloud with strong focus on integrations and data migrations. Proficient in REST/SOAP APIs, FBDI/HDL, and BI Publisher. Experienced in designing and delivering scalable solutions across cloud and on-premise platforms. Adept at supporting full project lifecycle from development to post-production support. Committed to building efficient, reliable, and business-focused technology solutions.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Oracle Fusion and OIC Consultant
TCS
Pune
05.2025 - Current
- Developed integration architecture strategies focusing on data flow, security, scalability, and performance.
- Defined integration and customization strategies aligned with business needs.
- Architected solutions using Fusion extensibility tools like Application Composer and Page Composer.
- Established integration architecture with Oracle Integration Cloud, B2B, REST/SOAP APIs, and middleware technologies.
- Designed integrations between Oracle Fusion Cloud, EBS, and third-party applications via OIC.
- Created solution blueprints incorporating Oracle SaaS (Fusion Apps) and PaaS (OIC, VBCS, PCS).
- Defined data migration approach utilizing FBDI, ADFdi, HDL, and OIC bulk APIs for efficient implementation.
- Executed testing phases including unit testing, system integration testing, and user acceptance testing for integrations.
OIC Technical Consultant
TCS
Pune
06.2023 - 05.2025
- Defined integration architecture using Oracle Integration Cloud and middleware technologies.
- Designed and deployed integrations between Oracle Fusion Cloud, Oracle EBS, and third-party applications.
- Configured REST and SOAP-based integrations to automate business processes across Finance, SCM, and HCM modules.
- Developed and managed data migration solutions utilizing FBDI, HDL, and BI Publisher reports.
- Implemented error handling, logging, and notification mechanisms within OIC integrations.
- Collaborated with functional teams to gather requirements and design best-practice technical solutions.
- Conducted unit testing, system integration testing and supported user acceptance testing for integrations.
- Documented integration designs and user guides to ensure maintenance and knowledge transfer.
Oracle R12 Upgrade Consultant – Techno-Functional
TCS
07.2022 - 05.2023
- Analyzed existing business processes and customizations in R12 and earlier environments.
- Retrofitted custom objects for compatibility with R12, including reports and workflows.
- Conducted Fit-Gap analysis to identify discrepancies between current system and target R12 version.
- Evaluated customization versus configuration options for new requirements.
- Performed impact analysis on customizations based on schema and API changes.
- Collaborated with business users to capture new requirements related to R12 features.
- Migrated and validated custom objects in upgraded environment, ensuring functionality.
- Supported data migration activities and reconciled data between old and new systems.
Oracle R12 Upgrade Consultant – Data Conversion
TCS
Pune
08.2021 - 06.2022
- Analyzed legacy systems to identify data for migration.
- Collaborated with functional consultants and business users to establish mapping rules and transformation logic.
- Created mapping documents linking legacy data structures with Oracle ERP tables.
- Outlined transformation rules and data cleansing requirements for accuracy.
- Developed extraction scripts to retrieve data from legacy systems.
- Implemented transformation logic using PL/SQL, SQL Loader, and external tables.
- Designed load programs for seamless data insertion into Oracle APIs.
- Validated data quality and compliance with established business rules.
Oracle EBS R12 Support Consultant
TCS
Pune
12.2017 - 06.2022
- Provided daily technical support for Oracle EBS modules, including Financials, SCM, and EAM.
- Troubleshot and resolved issues with Oracle Forms, Reports, Interfaces, Workflows, and Concurrent Programs.
- Monitored scheduled jobs and data interfaces for failures, resolving incidents within established SLAs.
- Conducted root cause analysis of recurring issues and implemented permanent fixes.
- Guided team in analyzing critical incidents and identifying patterns in recurring issues.
- Supported month-end and year-end processes by ensuring smooth operation of technical components.
- Applied Oracle patches and assisted in testing for custom objects to maintain system integrity.
- Designed and developed custom Oracle Forms, OAF pages, and PL/SQL packages as per business requirements.
Oracle R12 Financials Support Consultant
TCS
Pune
02.2013 - 08.2017
- Resolved daily technical issues in Oracle GL, including SLA, FA, AP, and AR modules.
- Supported month-end and year-end closing activities for seamless GL operations.
- Addressed escalated tickets promptly while updating customers on progress.
- Monitored data interface issues between sub-ledgers and GL, including Journal Import.
- Collaborated with functional teams to convert business requirements into technical solutions.
- Conducted code reviews and performed patch impact analysis during upgrades.
- Designed interfaces for importing journals, budgets, and balances into GL.
Software Professional
Forbes Marshall Pvt ltd
Pune
08.2010 - 01.2013
- Designed and developed RICEW components, customizing solutions for diverse business needs.
- Created new reports utilizing Oracle Reports, BI Publisher, and APEX technologies.
- Executed data conversions and migrations with SQL Loader, PL/SQL, APIs, and open interfaces.
- Monitored and resolved production issues related to Oracle ERP modules including GL, AP, AR, and PO.
- Provided technical support for custom objects such as Reports, Interfaces, Conversions, Extensions, and Workflows.
- Debugged and corrected issues in PL/SQL packages, forms, reports, and integrations.
- Developed low-code applications, dashboards, and self-service portals through Oracle APEX.
- Coordinated with external teams to establish data formats (XML, CSV, JSON) and communication protocols.
Education
Bachelor of Engineering - Electronics & Telecommunication
Pune University
05.2008
Skills
- App-driven and scheduled integrations
- REST/SOAP APIs
- XML, JSON, XSLT
- Application composer and page design
- BI Publisher
- SQL and PL/SQL
- RICE components
- Data migration
Certification
- Oracle Cloud Infrastructure 2023 Application Integration Professional (1Z0-1042-23), Oracle Integration Cloud, 2023
- Oracle E-Business Suite 12 Financial Management Certified Implementation specialist: Oracle general ledger, Implementation and configuration of Oracle GL Module, 2014
- Oracle Certified Associate, Oracle Database Fundamentals, covering architecture, SQL, and PL/SQL basics, 2009
General Technological Expertise
Windows/Linux-based environments, Oracle Integration Cloud, REST/SOAP Web Services, BIP publisher, XML and XSLT, JSON, Inbound Interface, Outbound Interface, Extensions, SQL, PLSQL, Oracle Fusion Applications, Oracle Database, Oracle E-Business Suite (EBS), OIC Gen3, Postman, SOAP, SQL developer, WinSCP, Putty, Toad, Oracle Forms and Reports
Career Awards
- TCS On the Spot Award (2014, 2020)
- TCS Star Team Award (2017, 2018, 2019)
- TCS Contextual Master Award, Awards for Excellence (2022)
Career Profile - Experience
- TCS, January 2013 to present
- Forbes Marshall Pvt. Ltd., August 2010 to January 2013
Personal Information
- Passport Number: U2828837
- Passport Date Of Issue: 11/01/21
- Date of Birth: 05/18/87
- Nationality: Indian
- Marital Status: Married
Timeline
Oracle Fusion and OIC Consultant
TCS
05.2025 - Current
OIC Technical Consultant
TCS
06.2023 - 05.2025
Oracle R12 Upgrade Consultant – Techno-Functional
TCS
07.2022 - 05.2023
Oracle R12 Upgrade Consultant – Data Conversion
TCS
08.2021 - 06.2022
Oracle EBS R12 Support Consultant
TCS
12.2017 - 06.2022
Oracle R12 Financials Support Consultant
TCS
02.2013 - 08.2017
Software Professional
Forbes Marshall Pvt ltd
08.2010 - 01.2013
Bachelor of Engineering - Electronics & Telecommunication
Pune University
Similar Profiles
FAIYAZ KHANFAIYAZ KHAN
ACCOCIATE VP at TCSACCOCIATE VP at TCS
Prathyusha ChivukulaPrathyusha Chivukula
IT Analyst - QA Lead at TCSIT Analyst - QA Lead at TCS
Pratik WanvePratik Wanve
Business Analyst at TCSBusiness Analyst at TCS
Shubham NayarShubham Nayar
Senior Associate 2 at Acko General InsuranceSenior Associate 2 at Acko General Insurance
Niraj NandaneNiraj Nandane
SDE3 - Staff - Principal Engineer at FortinetSDE3 - Staff - Principal Engineer at Fortinet