SUMMARY

• Over 12+ years of extensive experience in Oracle EBS & Cloud Application as Techno Functional consultant in implementation, Support, upgrade and customizations.
• dis includes system study, design, development, post implementation maintenance and support of Oracle EBS, Conversions &Integrations in Oracle Cloud.
• Strong requirements gathering, scope development and inventory coordination abilities.
• Skilled at overseeing complex, high - value technical projects wif excellent planning competencies.
• Good experience in Oracle Application Modules, which include Order Management (OM), Purchasing (PO), Inventory (INV), General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Service Contracts(SC), Integrated SOA Gateway (ISG), OracleApprovals Management (AME),Project Portfolio Management(PPM), Grants Management(GMS).
• Worked on Oracle Integration Cloud (OIC), SOAP, Rest API and Web services to build the integrations between the applications.
• Experience designing and implementing web services for real-time data integrations wif SaaS solutions.
• Experience on FSM, BPM, IDM, FBDI, HDL Loader in Fusion Financials Applications.
• Designed and Build Approvals for Requisition, Purchase Orders, AP Invoices, Journals using AME in Oracle EBS and BPM in Oracle Financial Cloud.
• Worked on building the report in BI Publisher, OTBI (Oracle Transactional Business Intelligence) XML Publisher and customize documents and Payment Templates as per requirement.
• Experience in Oracle ERP Cloud data conversions using FBDI and Web services.
• Solid understanding of the configuration, integration, data migration and extensibility tools dat are available to Oracle ERP Cloud Service implementations, and how to leverage them to expedite the implementation process.
• Good in database design and in performance tuning skills.
• Create SR's wif Oracle Technical Support, coordinated and followed on multiple issues based on priority including identifying bugs and follow-up wif Oracle Development as well as conducting Oracle Web Conference (OWC) wif Oracle Support Team.
• Multiple project life cycles experience wif Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering including facilitate Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing.
• Expertise in writing Packages, Procedures, Functions, Triggers using SQL & PLSQL.
• Good working experience in development of Inbound and Outbound Interfaces between Applications.
• Good knowledge on Project Cycle and AIM Methodology.
• Good Knowledge on TOAD, SQL Developer and SQL*Loader.
• Having Good Knowledge on Work flows.
• Worked on Oracle Application Alerts.
• Developed the reports using XML Publisher (Pictorial diagrams, xml Bursting, OA Media, Pre Printed Templates).

TECHNICAL SKILLS

Languages: C, C++, SQL, PL/SQL, MySQL, Shell Scripting, Unix.

Databases: Oracle 10g/11g/12c.

ERP: Oracle Fusion Cloud Financials, Oracle Fusion Cloud PPM, Oracle E-business suite R12/11i version Modules worked on: Purchasing (PO), Order Management (OM), Shipping and Oracle Inventory (INV), Account Receivables (AR), Account Payables (AP), General Ledger (GL), Project Portfolio Management(PPM), Grants(GMS).

Reporting Tools: Xml Publisher, BI Publisher, Report Builder(D2K),Oracle Transactional Business Intelligence (OTBI), Discover.

Integration Tools: Oracle Integration Cloud (OIC), FBDI (File Based Data Import), HDL (HCM Data Loader), Spreadsheet Data Loaders (ADFDi),ISG (Integrated SOA Gateway).

Web Services: WSDL (Web Service Descriptive Language), SOAP (Simple Object Access Protocol) and REST (Representative State Transfer).

PROFESSIONAL EXPERIENCE

Confidential

Technical Consultant

Responsibilities:

• Prepared mapping documents between source and target fields wif transformations logics.
• Developed the scheduled integration in OIC which run on the pre-defined frequency which takes Salary data of employees from ODS data base and load as project cost in Oracle cloud.
• Built Integration between MAXIMO and Oracle Cloud to create requisition using OIC.
• Built Integration between JMS tool and Oracle PPM Module to create and update the Capital Projects and project Budgets using OIC.
• Built Integration to create Awards Demographic Information and Budgets from PATS (Pre Award System) to Oracle PPM Grants.
• Importing bulk data through File Based Data Integration (FBDI) into ERP Cloud.
• Developed File based Integrations to read excel files and Process records in Oracle cloud using ICS.
• Proxy the Oracle Get Web services (AR Invoice Details, Payments, Project Budgets, Payable Invoices etc.) to the source systems to lookup the data in Oracle Fusion Cloud.
• Configured SOAP and REST adapters for Publish and Subscribe to OIC.
• Developed OTBI and BI Reports as per user requirements.
• Customized the Check, Payment Files and Purchase Documents Reports in BI Publisher.
• Worked on ERP Cloud Bulk Extracts (BI Publisher) where files are delivered to UCM or SFTP server in comma separated value (CSV) format.
• Installed OIC agent in On premise applications to connect from OIC instance.
• Create BI reports and integrating wif web services using SOAP API’s.
• Worked on the Requisition Approval process in BPM.
• Worked on the setting up Purchase Order Approval process in BPM.
• Loaded Employees into Oracle Fusion cloud from People soft using HDL Loader.
• Converted Suppliers using File Based Data Import (FBDI) Process.
• Converted open AP Invoices and AR Invoices using File Based Data Import (FBDI) Process.
• Converted Legacy Capital Projects, Projects Costs, Project Budgets, Awards demographic data, Award Project, Award Project Budgets and costs in to Oracle Cloud PPM Module.

Confidential

Technical Conversions Lead

Responsibilities:

• Prepared data mapping/Field mapping documents between EBS to Fusion.
• Prepared design and developed Reports, Extracts and Integrations/Interfaces.
• Worked on End to End Conversion process from EBS to Fusion, related to Open AP Invoice, Open AR Invoice, Open Sales Orders, Supplier, Customers, Chart of Account, Purchase Orders, Assets, GL Open Balances.
• Written SQL scripts to pull the data from the oracle EBS into FBDI formats to load the historical data.
• Conducted sessions wif user to explain the process in Oracle Fusion Cloud.

Confidential

Project Lead

Responsibilities:

• Prepare Month end activities sheet and update up on the task completed.
• Worked on Month end period closing issues.
• Worked closely wif user on bug fixes testing.
• Schedule Weekly Status meetings wif respective business unit users.
• Worked on fixing Interface stuck records.
• Host weekly project meetings.
• Take Lead’s on P1 issues and complete wif in SLA’s.
• Worked on the Functional Issues related to Distributions Module like Account Receivables, Account Payables, General Ledger, Inventory, Purchasing Issues, Order Entry, Shipping Execution and RMA.
• Worked wif Oracle Product Support team in SR tracking raised wif Oracle.
• Worked on the issues related to the Custom Process.
• Prepared MD120 for Code Migration.
• Written scripts to check Data Quality.
• Worked on Custom Alert’s in Alert Module.
• Customized the Custom Process Related Programs.
• Customized Purchasing Approval Status Report.
• Monitoring the Stuck transactions for period close.
• Involved in Regression testing of the mentioned Objects and consolidating all the test results, prepared issue logs and error logs for the failed test cases.
• Tested the Migration activity in different test instances.
• Customized the Oracle Out bound extract Integration Programs to Oracle RMCS for Revenue Recognition Process.

Confidential

Technical Lead

Responsibilities:

• Single point of contact from technical side to support existing Oracle ERP system, finding RCA and bug fixes for all issues across all locations, Accountable for implementations design, stability, scalability and expandability of the architecture.
• Involved in interacting wif users regularly and handling multiple projects.
• Involved in ticket solving related wif RICE components.
• Worked on the Functional Issues related to Distributions Module like Inventory issues, Purchasing Issues, Order Entry, Shipping Execution and RMA.
• Worked wif Oracle Product Support team in SR tracking raised wif Oracle.
• Interacted wif Users for Better Solutions.
• Worked on the issues related to the Custom Process.
• Prepared Test Scripts as per User Requirements.
• Prepared MD120 for Code Migration.
• Performing the Data Quality Check.
• Handled Alerts Event Alerts and Periodic Alerts Related to the Oracle.
• Worked on Alert Module.
• Customized Purchasing Approval Status Report.

Confidential

Technical Lead

Responsibilities:

• Customized the Purchase requisition workflow to send Approval Email to purchasing Department.
• Customized the Purchase Order Work Flow to send Approval Email Notification to buyer.
• Form personalization not to display 2-way match PO in Purchase Order Receipt OAF Screen.
• Developed BI Publisher template for change Order Report.
• Developed API to Integrate the Legacy System Journals to Oracle General Ledger.
• Form Personalization on Requisition form in procurement to default the Category wif 1%.
• Developed a Purchase Order, Requisition Report Template.

Confidential

Technical Developer

Responsibilities:

• Setting up the Instance to use Out of box ISG Module.
• Developed a custom API to read the Xml Data from the Legacy system and inserting data in to EBS Custom Tables.
• Developed API to create and update the order using Interface table.
• Developed API to create receipts using Interface approach.
• Developed the WSDL in ISG to integrate EBS to ELEMICA (Legacy System).
• Migration of WSDL and EBS Components.