We provide IT Staff Augmentation Services!

Oracle Techno-functional Consultant Resume

Burlington, MA

SUMMARY

  • Having 16+ Years of Experience in Oracle Finance/SCM/Manufacturing Techno - Functional Consultant in Oracle Applications e-Business Suite (11i & R12), Oracle Cloud Finance Fusion Application (R13) Suit & Oracle Integration Cloud (OIC) Pass Premier Product
  • Exposure in the areas of Oracle Applications Modules in General Ledger (GL), Account Payables (AP), Accounts Receivable (AR), Cash Management (CM), Fixed Assets (FA), Purchasing (PO), Order Management (OM), Inventory (INV), Bill of Material (BOM), Work in Progress (WIP), Oracle Transport Management (OTM) and Oracle Learning management (OLM), Oracle Lease management (OLM) & Oracle Clinical Management (OCM)
  • Experience in Oracle Application Implementation, Enhancement, Rollout, Upgrade, Integration, Data migration, Customization, Production Support in Oracle Application (11i & R12)
  • Exposure in Oracle SaaS Cloud implementation experience with Oracle Fusion Modules of Financial implementation/Support Project(R13)
  • Experience in Oracle Integration Cloud (OIC) using agent group Integration components Integration Cloud Service (ICS), Process Cloud Service (PCS) and Visual Builder Cloud Service (VBCS).
  • Having Experience working on complex integration in OIC/EBS using REST APIs (End Point)/SOAP Services
  • Expertise in building complex integration processes, integrating cloud-based and On-Premise Enterprise Applications.
  • Hands-on design, development, deployment, and maintenance of integration processes between on premise\cloud systems and other 3rd party applications
  • Experience Oracle Integration Cloud (OIC) adapters, usage of REST Adapter, SOAP Adapter, ERP Adapter, Salesforce Adapter, FTP Adapter, File Adapter, usage of orchestration integration patters
  • Experience in REST APIs/End Point, SOAP Web Services and FBDI Templates in Oracle Cloud.
  • Have good hands-on experience on developing process and calling sub process in Process Builder Cloud Service (PBCS).
  • Having Good exposure working on VBCS developing web application, Consuming REST, SOAP Services and Business events.
  • Experience in Oracle Cloud reporting tools (Financial Reporting Studio (FRS), Oracle Transactional Business Intelligence (OTBI), and Business Intelligence Publisher (BIP)) to develop new reports and enhance standard ERP Cloud reports in Cloud Finance Module.
  • Experience in B2B Integration in Oracle Integration Cloud
  • Experience in Procure to pay life cycle (P2P) & Ordered to Cash (O2C).
  • Expertise in requirement analysis, System design, Data Flow Designs, supports, development, testing, Documentation and design reviews
  • Requirement mapping and translating the requirements into functional specifications
  • Experience in Business process study, requirement gathering set up configuration and documentation.
  • Experience in using Oracle AIM of project implementation methodology and preparation of RD050, MC050, BP040, BR100, MD050, TE040, MD070, TE020, MD120 and Conversion Templates, User Manuals, Training Material Preparation
  • Technically proficient in RICEW components (Report, Interface, Conversion, Extension and Workflow)
  • Having experience in Oracle Apps Upgrade Project from R12.1.3 to R12.2.9
  • Having Good Exposure in Data Migration and worked as a Technical Team Lead with data transformation, data cleansing & data validation team
  • Having Good Experience to Managed the Oracle critical SR’s and Spin SR
  • Having Good Team Handling, Project Management and Client Management skills.
  • Expertise in On-shore and Off-shore delivery Model Team Handling.
  • Good communication and presentation skills
  • Good Analytical skills and Planning and Co-ordination skills

TECHNICAL SKILLS

ERP Modules: Expertise Oracle E-biz Suite Financials (GL, AP, AR, FA & CM), SCM (INV, PO) Manufacturing (INV, WIP, BOM), Oracle Transport Management (OTM)Oracle Learning Management (OLM), Oracle Clinical Management (OCM)Oracle Learning management (OLM) in 11i, R12& R13.

Tools: & Utilities: SQL Developer 19.2.1.247 , Oracle Data Base 9i, 11g, 12C, 19C, Data loaderMSVisio, MSOffice 2003, 07, 08, PUTTY, WinSCP, SQL*Loader, XML 12.0.0, Oracle Report/Form 6i, 10g, Oracle Workflow Builder 2.5, SoapUI 5.6.0, Postman v7.32.0, Oracle ADF 11g Desktop Integration

Operating Systems: Windows 2007 NT/XP, UNIX, MS-Dos.

PROFESSIONAL EXPERIENCE

Confidential, Burlington, MA

Oracle Techno-Functional Consultant

Responsibilities:

  • Involved in understanding the business process requirements & design the new ICS objects
  • Involved in System Integration testing with Functional Team after develop the ICS objects
  • Worked on Localization in VBCS for French (Canada) and Spanish
  • Worked on AMSGetBrewerList Integration using App Driven Orchestrion
  • Worked on AMSGetUserifo using App Driven Orchestrion
  • Worked AMSGetUserInfoWithAccounts using App Driven Orchestrion
  • Worked on AMSGetBusinessAccountContact using App Driven Orchestrion
  • Worked on to Developed new VBCS page using R13 Template.

Confidential

Techno-Functional

Responsibilities:

  • Working as a Techno-Functional/Technical Lead and Developer for this Oracle Apps R12.2.9 Upgrade Project
  • Involved in understanding the business process requirement& upgrade changed Cemli Objects from R12.1.3 to R12.2.9
  • Coordinate with all project Stake holders& Team at Onsite & Offshore.
  • Resolved the all the third-party system integrations issues after upgrade from R12.1.3 to R12.2.9. Vita mix Having Critical Business Integration objects AddressDr, PaymenTech, PayPal, ODI Sync Programs and other Integrations.
  • Involved in System Integration testing after upgrade the Oracle Apps system in R12.2.9.
  • Responsible to Run the ConfigSnapshot tool to find the Customization impact analysis report of Oracle EBS R12.2.9 after upgraded.
  • Responsible to identify all the impacted Object after Upgrade the system and provide the solution to customer.
  • Responsible for code review, document review, Document/Code versioning and file management control in GitHub Vitamix Common Share point.
  • Worked with FNDLOAD utility to migrate objects from one instance to another instance till Production.
  • Run the GSS Program to Improve the performance after upgrade the system performance issue
  • Worked on Oracle Business Event/Alert/Form Personalization/Custom Hook &Custom Pll, XML Reports
  • Worked on to Modify the Vitamix Auto Receipt custom concurrent program after upgrade due to Oracle system Bug in R12.2.9.
  • Worked on to modify the AddressDr Validation Custom Program after Upgraded data base from 11g to 19C.
  • Worked on PL/SQL procedures, packages, Data base triggers and Functions, tables, sequence synonyms, views and indexes for modification and retro fitment in upgraded 19C Oracle Data base.
  • Developed BR100, TE040, MD070, TE020 and MD120 Documents
  • Technical Support, Guidance and Planning for Code migration from Development through Production
  • Managed Oracle Critical SR and Spinning SR with Oracle during Oracle Upgrade Time
  • Managing the Tickets, resolving the issues on day-to-day basis on priority after Go-Live.
  • Interacting with Users for required information about the issues arise.
  • Resolving user’s day to day functional issues by understanding and analysing them.
  • Raising Service Request with Oracle for resolution of Critical and Transactional issues.
  • Responsible for post go live support resolution delivery
  • Delivered objects on time for CRP, SIT, UAT, MOCKPRD & PROD in Oracle Application Upgraded Instance R12.2.9

Confidential

Oracle Fusion Techno- Functional

Responsibilities:

  • Responsible for Configuration of Financial Modules (GL, AP, AR & CM)
  • Finalized Data Migration Strategy for Financial Objects
  • Worked on Data Migration for General Ledger, Payables, Receivables and Fixed Asset
  • Design System Configuration Documents for Financial Modules.
  • Worked on VBCS developing web application, Consuming REST, SOAP Services and Business events.
  • Worked on to Manage Daily Rate using FBDI Templates, Load using Import and Calculate Daily Rates Programs.
  • Worked on an integration to import GL Journals into ERP Cloud using Oracle Standard Web Service WSDL in ICS.
  • Worked on inbound integration for Customer Creation/Update in ERP cloud to Integrate Sales force in Oracle ERP Cloud using Salesforce Adapter
  • Worked on in Data Migration using FBDI in Financial Modules for Suppliers.
  • Worked on to develop new reports and enhance standard ERP Cloud reports using reporting tools (Financial Reporting Studio (FRS), Oracle Transactional Business Intelligence (OTBI), and Business Intelligence Publisher (BIP))
  • Worked on Oracle Integration Cloud (OIC) adapters, usage of REST Adapter, SOAP Adapter, ERP Adapter, Salesforce Adapter, FTP Adapter, File Adapter, usage of orchestration integration patters
  • Developed ICS Inbound interface to Create Invoices in Oracle Fusion cloud using ERP Cloud Service
  • Worked on VBCS to Build the Custom Form for approval process.
  • Worked on VBCS developing web application, Consuming REST API, SOAP services and Business events.
  • Task and responsibilities performed include Work around, Development, application setup, documentation, training, testing, and preparation of end user manuals
  • Worked on VBCS to Build a Web application to manage ERP Banks Information using REST APIs provided by Oracle
  • Involved in understanding the business process Requirement and design requirement/setup documents.
  • Responsible for document review and Unit Test case Preparation.
  • Conduct CRP1, CRP2 & UAT and System Testing
  • Handling the Service Now Tickets, resolving the issues on day-to-day basis on priority.
  • Interacting with Users for required information about the issues arise.
  • Post Production Support

Confidential

Techno-Functional

Responsibilities:

  • Worked as a Techno-Functional, Technical Lead and developer for this project.
  • Interacted with end users to understand the business requirements from offshore.
  • Coordinate with all projects Stake holders (SAP, Oracle EBS & Webvan Team) at Offshore and Onshore.
  • Managed Senior Management Review (SMR) Meeting and Customer with weekly.
  • Worked on to prepare the mapping documents for inbound/Outbound interface Programs
  • Worked on to prepare the High-Level Design document for Outbound/Inbound interface parallel processing Programs from Oracle Apps to SAP Integration
  • Developed a common PL/SQL Package Code Block Engine to generate the SAP code block string, this value is held in a DFF on the Accounting segment, the engine translation mapping values/data between Oracle & SAP and used in AP, AR & GL Interface programs
  • Worked on to developed the web service all the parallel processing program using SOAP (WDAL to WSDL) format
  • Involved in technical design and development of the Interfaces “ Confidential - FI001 AP Invoice Parallel Program”
  • Involved in technical design and development of the Interfaces “ Confidential - FI095 AR Invoice Parallel Program”
  • Involved in technical design and development of the XML Report “ Confidential - FI001 AP Invoice Interface Error Report”
  • Involved in technical design and development of the XML Report “ Confidential - FI095 AR Invoice Interface Error Report”
  • Involved in technical design and development of the XML Report “ Confidential - Code Block Engine Error Report”
  • Responsible for code review, document review, Document versioning and file management in SVN.
  • Worked with FNDLOAD utility to migrate objects from one instance to another instance
  • Writing PL/SQL Packages, Procedures, Functions, tables, sequence synonyms, views and indexes
  • Technical Support, Guidance and Planning for Code migration from Development through Production
  • Responsible for post go live support resolution delivery
  • Development of packages & procedures as per client coding standards.
  • Worked with FNDLOAD utility to migrate objects from one instance to another instance.
  • Registrations of AOL objects
  • Based on Confidential process design MD50, TE040, MD070, TE020, MD0120 Documents
  • Involved in Development Integration testing for all the Integration objects with BA’s.
  • Maintain common package to create common objects Preparation of SQL loader scripts.
  • Delivered objects on time and successfully completed this integration Implementation project

Confidential

Techno-Functional

Responsibilities:

  • Contributed as a Technical Lead for this project and also worked as a developer in times of need basis.
  • Involved in understanding the business process Requirement and provided solution for this integration
  • Coordinate with all Project Stake holders at Onsite & Offshore
  • Involved in Functional, Technical design doc and development of the Interfaces for the Integrations Objects from TMS (Oracle Application) to OTM Call via DB Link.
  • Involved in Functional, Technical design doc and development of the Interfaces for the Integration from ECOM to TMS (Oracle Application) & OTM Call via Dell Boomi.
  • Involved in Functional, Technical design doc and development of the XML Report “Terex Fixed Freight Order Comparison Report”
  • Involved in Functional, Technical design doc and development of the Interfaces “Terex AWP-ECOM Sales Order Update Freight Charge Program”
  • Responsible for code review, document review, Document versioning and file management in PVCS.
  • Worked with FNDLOAD utility to migrate objects from one instance to another instance
  • Writing PL/SQL Packages, Procedures, Functions, tables, sequence synonyms, views and indexes
  • Developed MD050, TE040, MD070, TE020 and MD120, Documents for all components.
  • Technical Support, Guidance and Planning for Code migration from Development through Production
  • Post Go Live Hyper Care Support

Confidential

Techno-Functional

Responsibilities:

  • Worked on with customer to understanding the business process Requirement
  • Coordinate with all project Stake holders at Onsite & Offshore
  • Involved in technical design and development of the Interfaces for the Integration
  • Developed Confidential PROS Product Dimension Interface Program.
  • Developed Confidential PROS Customer Dimension Interface Program
  • Developed Confidential PROS Sales Org Dimension Interface Program
  • Developed Confidential PROS Currency Dimension Interface Program
  • Developed Confidential PROS Date Dimension Interface Program
  • Developed Confidential PROS List Price Lookup Interface Program
  • Developed Confidential PROS Sales Cube Interface Program
  • Developed Confidential PROS Ready to Process Interface Program
  • XML File generation Process and FTP Process Quality checks
  • Worked on APEX to Developed Custom Forms for all the above interfaces
  • Responsible for code review, document review, Document versioning and file management in SVN
  • Worked on SQL Loader Programs Development
  • Worked with FNDLOAD utility to migrate objects from one instance to another instance
  • Writing PL/SQL Packages, Procedures, Functions, Tables, Sequence Synonyms, Views and Indexes
  • Developed MD70, TE20 and MD120, Documents for all components.
  • Technical Support, Guidance and Planning for Code migration from Development through Production

Confidential

Data Migration Technical Lead/Developer

Responsibilities:

  • Coordinate with stakeholders to understand the requirements.
  • Worked on to Support data transformation team
  • Worked on to Support data validation team
  • Worked on to design and development of Item, Locator, Stock Level, Routings and Bill of Material, Purchase Order, Skip Lot & Sourcing Rule, Payable Invoices, GL Interface Data Migration Programs.
  • Worked on the bug fixes during the testing and support phase. (UAT & PROD).
  • Worked on development of new XML reports, Form customization & personalization, XML BI Publisher Reports.
  • Developed Receiving Process Auto Delivery Transaction interface e program in Oracle Purchasing
  • Developed GL Daily Rates Conversion program by using Interface
  • Responsible for code review, document review, code versioning and maintaining the same in SVN.
  • Worked with FNDLOAD utility to migrate objects from one instance to another instance
  • Writing PL/SQL Packages, Procedures,Data base triggers and Functions, Tables, Sequence Synonyms, Views and Indexes
  • Developed MD50, MD70, CV60, TE20, and MD120 Documents.
  • Worked on Support post go live activities

Confidential, Cleveland, Ohio

Techno-Functional

Responsibilities:

  • Developed Eaton Tax Credit Extract to Payroll Concurrent Program.
  • Developed Eaton Transfer (FTP) Tax Credit files to Payroll.
  • Eaton Payroll to Tax Credit tables -FTP and Upload.
  • Eaton Payroll to Tax Credit tables - FTP
  • Developed Eaton Tax Credit Extract to Payroll Concurrent Program.
  • Developed Eaton Transfer (FTP) Tax Credit files to Payroll.
  • Eaton Payroll to Tax Credit tables -FTP and Upload.
  • Eaton Payroll to Tax Credit tables - FTP
  • Developed 7 XML Publisher Reports for Eaton Ohio Tax Credit Reporting in Oracle HRMS and Payroll.
  • Developed Active and Retired Asset XML Reports in Oracle Fixed Assets.
  • Developed Eaton Mexico Tax Book Asset Number Initial Load Interface Program.
  • Developed Oracle Standard 23 database PL/SQL custom procedures (for flex-builder to use) for the new book (MEXICO TAX BOOK) to run depreciation program successfully through flex-builder to generate accounts in Oracle Fixed Assets
  • Done enhancement of custom workflow PL/SQL Package “EFACLOSE” for the new tax book “MEXICO TAX BOOK” which earlier had the” MXN TAX BOOK” to close the “Mexico Tax Book” by running the program “FA Close” successfully
  • Responsible for post go live support resolution delivery

Hire Now