SUMMARY

• Over 13+ years of experience as EBS technical, techno functional, Data Analyst and team lead in oracle EBS 11i, R12 and Oracle Fusion Cloud implementation and AMS projects.
• Experience in large scale implementation, support and upgrade projects in SCM, Finance and Manufacturing modules.
• Experience in studying the existing legacy systems, analyzing and design mappings to Oracle Applications and to Oracle Cloud Systems. Experience in working integrations with other 3rd party/custom applications.
• Experience in AIM Documentation - MD050, MD070, TE040, CV040, CV060 and BR100.
• Hands on experience in using SQL, PL/SQL, OCI, OIC, HTTP/REST Services, BI Publisher, Workflows, Forms, Reports, Shell Scripting, SQL * Loader, etc.
• Hands on experience in using Oracle Integration Cloud - OIC Instance Setup, FTP, SOAP, REST, BIP Reports, PaaS applications.
• Experience in Oracle Integration Cloud using FTP, SOAP, REST, FBDI, BIP Reports, SaaS, PaaS including experience with working on-premises integration and 3rd part applications to oracle cloud.
• Extensive experience in data conversions from legacy to oracle cloud - includes identifying business rules/requirements, data extraction, cleansing, pre-validation and loading/transform to oracle cloud environment.
• Experience in working with end clients/customers, business process leads to understand /analysis business requirements. Travelling and experience working with users at plant location (for requirement gathering, support and super user trainings).
• Experience in leading on-site and offshore teams working in different time zones and experience in resource annual appraisal process.
• Experience in designing, development, and integration of MDM projects like Global Product Management, Supplier Management, Customer Management systems.

PROFESSIONAL EXPERIENCE

Confidential

OIC Specialist

Responsibilities:

• Worked on various oracle cloud projects in Finance and SCM areas utilizing OIC and SaaS.
• Experience in analysis of legacy system data, creating mapping, designing, testing and deployment.
• Worked on Oracle Cloud Tenancy setup and OIC instance setup - creating FTP and REST adapters for integration with SaaS environment.
• Developed suppliers and Customers inbound and outbound integrations using OIC. This integration is between Oracle Cloud and 3rd party systems.
• Worked on AP Invoices conversion using oracle cloud integration using FBDI.
• Worked on bank integrations for invoice payments using ACH, wire, Check Printing, Bank Statement formats in oracle cloud payables.
• Worked on AR transactions and receipts data migration to oracle cloud using FBDI.
• Built a scheduled integration to transfer AR Invoices and receipt data from 3rd party system to oracle cloud.
• Development of FBDI integration to convert Blanket Agreements, Purchase Orders from legacy system to oracle fusion.
• Worked on integration to convert suppliers, addresses, sites (and associations), contacts, supplier banks using FBDI process.
• Experience in monitoring and analyzing load failures and preparing strategy to reprocess the data.
• Development of FBDI integration to convert Blanket Agreements, Purchase Orders from legacy system to oracle fusion.
• Worked on design, develop, testing and deployment of AP Invoice data conversion using FBDI process from legacy to oracle SaaS system. Involved in analysis of data, mapping, defining business rules and documenting.
• Experience in working with on premise application (oracle EBS R12) to oracle cloud using OIC.
• Development of new custom BI Publisher Reports and registering them as ESS jobs. Has exposure with customizing standard reports in SaaS environment.
• Hands on experience in oracle fusion.

Confidential

Sr Programmer/Systems Analyst

Responsibilities:

• Worked on for personalization using GRC module to check item UOM conversions to align with business and prevent updating/creating if values are not aligned.
• Designed new form to create item, categories, UOM conversion etc., from the single form.
• Customized AR Aging report to include additional information and converted to excel output using XML publisher templates.
• Developed interface to manage customers and sites from 3rd party systems and designed an interface in advanced pricing to load/update pricelists, qualifiers, and modifiers.
• Worked on customizing PO workflow to meet with certain business requirements.
• Designed and developed many of the data conversion programs in multiple modules using oracle standard APIs and interfaces - in AP, PO, AR, OM, INV, OPM, Costing.
• Worked on MSCA pages for batch consumption.
• Worked with integration team and coordinating with customers to design complex solutions to integrate other systems to EBS using interfaces. Monitoring incoming and outgoing data from/to EBS system to other systems which includes development, testing and implementation in production.
• Worked on with data conversion implementation for new Confidential plants into oracle EBS. Responsible and critical role of converting data from Confidential ’s legacy system to EBS, which includes creating detailed mapping between old data elements to EBS data elements, creating business rules, clarifying data analysis, identifying issues and provide recommendations, perform data verifications between legacy applications and EBS.
• Developing RICEW objects in AP, AR, INV, OPM modules - XML Reports, BI, Forms (includes form development and personalization).
• Responsible to review/define setups and validating process flows.
• Providing support with business process, design, and development of complex objects across various EBS modules like INV, PO, AR, AP and OPM.
• Team Lead at Confidential: Managing onsite and offshore data conversion team.
• Responsible for providing information, reporting status to client.
• Involving Technical Design and Development discussions.
• Responsible for huge installation scripts for RICEW objects.