Oracle Fusion Techno-Functional Consultant (SCM/PDH)
Resume:
JOB OBJECTIVE
Targeting challenging assignments in Oracle Fusion
focusing on Domains like Product-based applications, data modules, Oracle-integrated systems, and
technical/functional consulting
CONTACT
***************.********@*****.***
IT SKILLS
Category Skills & Competencies
ERP
Ecosystems
Oracle Fusion Cloud (PDH, SCM),
Oracle EBS R12 (SCM)
Data
Engineering
FBDI (File Based Data Import),
Data Migrations, Item/Supplier
Conversions, Data Reconciliation
Development
Tools
TOAD, SQL Developer, PL/SQL
Developer, WinSCP
Business
Intelligence
BI Publisher (BIP), OTBI, XML
Publisher, RTF Template Design,
Bursting Logic
Programming SQL, PL/SQL (Packages,
Procedures, Functions, Triggers)
Project
Governance
BR100 Documentation,
Requirement Gathering, UAT &
Production Deployment
Automation
& UI
ESS Job Scheduling, Forms
Personalization, Custom Oracle
Forms Development
Functional
Process
NIR (New Item Request), Change
Orders, Item Lifecycle
Management, UOM Management
CORE COMPETENCIES
Enterprise Resource Planning
Integration
Financial Accounting Processes
Supply Chain Management
Workflows
Database Object Optimization
Report Automation Techniques
Business Process Customization
Data Migration Strategies
User Interface Personalization
Project Cost Management
System Performance Tuning
CAREER TIMELINE
Nimit Srivastava
O r a c l e F u s i o n T e c h n o F u n c t i o n a l C o n s u l t a n t PROFILE SUMMARY
Oracle Fusion Techno Functional Consultant with over 6 years of experience specializing in SCM and Product Data Hub (PDH) modules.
Expert in architecting end-to-end data migrations and lifecycle management strategies using FBDI and SQL, ensuring 100% data integrity and adherence to BR100 documentation for global clients like EXL, Deloitte and Genpact.
Proficient in the Oracle BI stack, including BI Publisher (BIP), OTBI, XML Publisher, to deliver automated reporting frameworks & custom RTF templates.
Skilled in streamlining complex business processes through Forms Personalization, ESS Job automation, and high-performance SQL/PL/SQL development across UAT and Production environments.
Led end-to-end implementations, including requirement gathering, full-suite configuration, and the design of complex Product Rules, NIR workflows, and Change Order processes.
Orchestrated large-scale data migrations using FBDI for Items and Supplier Invoices, while maintaining rigorous BR100 documentation and providing cross-functional support through ServiceNow to ensure seamless business alignment. WORK EXPERIENCE
NCR Voyix (Product-based Organization), Gurugram, India as Application Developer January 2025 – Present
Key Result Areas (KRAs):
Managing functional setup and configuration related to product data modules within the core product ecosystem.
Supporting the transformation from legacy in-house data tools (GSDB/ PMDM) to new Oracle-based systems.
Acting as a functional and technical bridge between internal product teams and external cloud/implementation partners.
Understanding and mapping data storage structures across legacy systems and Oracle platforms to ensure accurate data migration and integration.
Supporting implementation activities, ensuring continuity between existing concepts and new application models.
Handling indirect reporting responsibilities for 2–3 team members and supporting coordination efforts.
Communicating with different downstreams to get the data in FBDI Format. AWC (Client-based / Consulting Engagement)
2019 – 28 December 2024
Application Developer / Technical Consultant
Key Result Areas (KRAs):
Worked across multiple client engagements, providing application development and technical consulting support.
Supported application and data-related functionalities across different client environments.
Gained hands-on experience in understanding enterprise data models and application workflows.
Contributed to system reviews, enhancements, and maintenance activities based on client requirements.
Built foundational experience during early career phase, including initial 1–1.5 years in application-focused roles, before transitioning into product and data- centric responsibilities.
PROJECTS
ERP Ecosystem: Oracle Fusion Cloud (Project Portfolio Management & Data Hub)
Data Engineering: PL/SQL, SQL, FBDI (File Based Data Import), Data Migration & Conversions
Business Intelligence: Oracle BI Publisher (BIP), OTBI, XML Publisher, RTF Template Design
Development Tools: Toad, PL/SQL Developer, SQL Developer, WinSCP, ESS Job Scheduling
2019-24 Since 2025
EDUCATION
2019
Bachelor of Technology (B.Tech)
GL Bajaj Institute of Technology and
Management, Greater Noida
PERSONAL DETAILS
Date of Birth : 01 June 1998
Languages Known : Hindi, English
Oracle Fusion Technical Consultant Encalm Hospitality Jan 2023 – Jul 2024
Enterprise Data Migration & Lifecycle Management: Orchestrated large-scale data conversions for Items and Suppliers using FBDI; architected the Oracle PDH (Product Data Hub) environment by defining Item Classes, custom attributes, and lifecycle statuses to ensure data integrity.
Automated Reporting & Intelligence: Developed complex BI Publisher (BIP) and OTBI reports with advanced bursting logic to automate delivery via SMTP/Email. Engineered custom RTF templates for high-priority financial documents, including AR Invoices and Purchase Orders.
Process Automation & Integration: Streamlined operational efficiency by creating and scheduling ESS Jobs, managing Unit of Measure (UOM) configurations, and implementing New Item Requests (NIR) and Change Order workflows for controlled product governance.
Business Requirement Engineering: Collaborated directly with stakeholders for requirement gathering and BR100 documentation; translated business needs into technical specifications, including custom Product Rules and Item Class templates.
System Reconciliation & Deployment: Integrated OTBI analysis for real-time data reconciliation between modules and managed the end-to-end deployment lifecycle across UAT and Production environments.
Project Experience
Oracle Fusion Technical Consultant EXL Aug 2021 – Jan 2023 Environment: Oracle Fusion (PDH & SCM)
Product Data Governance: Orchestrated the end-to-end setup of Oracle Product Data Hub (PDH), including the design of Item Classes, custom Attribute Groups, and Item Lifecycle statuses to ensure enterprise data consistency.
Data Migration & Conversion: Executed complex item data conversions and bulk uploads of Catalogues, Categories, and TPINs using FBDI, while maintaining strict adherence to BR100 documentation.
Business Logic Implementation: Designed and deployed sophisticated Product Rules and custom item templates to automate data validation and streamline the New Item Request (NIR) and Change Order workflows.
Operational Inventory Management: Managed foundational SCM configurations, including Units of Measure (UOM) and inventory parameters, utilizing OTBI reporting for real-time data reconciliation and audit accuracy. Oracle Technical Consultant (EBS R12) Genpact Nov 2019 – Jul 2021 Environment: Oracle EBS R12 (SCM)
Custom Technical Development: Engineered robust PL/SQL packages, procedures, and functions tailored to SCM business requirements; developed high-impact reports including Project-wise Pending Orders and Custom Sales Invoices.
Production Support & Code Optimization: Served as the technical focal point for SCM modules, specializing in complex code fixing, error handling, and performance tuning to resolve critical system bottlenecks.
UI Customization & Personalization: Enhanced user experience and business process compliance through Forms Personalization and the development of custom forms for FA Asset Acceptance, Bank Guarantees, and Store Division management.
Functional Alignment: Bridged the gap between technical delivery and functional needs by assisting in the configuration of PDH and engaging in regular client consultations to translate business pain points into technical solutions.
Contact this candidate