We provide IT Staff Augmentation Services!

Senior Oracle Ebs Techno-functional Consultant Resume

Bethesda, MD

SUMMARY:

  • Over 8 years of Experience in Information Technology, have experience in Implementation, Up - gradation and Customization of various versions of Oracle Applications (versions R12, 11i).
  • Proficient working in Order to Cash(O2C), Procure to Pay Cycles(P2P) touching various modules Purchasing, iProcurement, iSupplier, Account Payables, General Ledger, Account Receivables, Budget Execution, OM, Oracle CRM, iStore, Quoting, Inventory, Advanced Pricing, Trading Community Architecture (TCA), System Administration and Application Object Library (AOL).
  • Expert in Oracle Application Framework (OAF), R-I-C-E components (Reports, Interfaces, Conversions, Extensions), CRM Technology Foundation (JTF), Workflow, ADF, Oracle Forms, XML Publisher.
  • Very good understanding and exposure of working with the Oracle Trading Community Architecture (TCA) entities and public APIs.
  • Involved in Full Life cycle Implementations of Oracle CRM, Federal Financials with major clients.
  • Strong understanding of business flows, underlying technical architecture and table structure of Oracle E-Business Finance Suite.
  • Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
  • Experience working on Oracle Application Implementation Methodology (AIM) documents like MD050, MD070, MD120 and TE.020 and also worked on BR100 document.
  • Experience in customization by extension and modification of the standard application suite using Application Object Library (AOL) and setting up Oracle Alerts in Application.
  • Extensively worked on SQL *Loader, Developing PL/SQL Packages, Stored Procedures, Functions and Triggers.
  • Expertise in Developing and Supporting both Production and Development Systems.
  • Expertise in using migration and version control software KINTANA and Clear Case.
  • Experience in working with Oracle Support- TAR management, resolving the issues.
  • Knowledge of Web Services, XML, XPath, XSLT, SOAP and WSDL based development.
  • Followed best Coding Standard Practices while developing deliverables.
  • Excel at managing complex real time projects with tight schedules.
  • Interaction with Functional community (Customers) and End Users to Analyze and Map the Business and Functional requirements with Oracle Applications.
  • Highly motivated, energetic individual as well as a team player with excellent analytical, problem solving, communication and interpersonal skills.

TECHNICAL SKILLS:

ERP Oracle Applications: (R12, 11.5.10).

Modules: General Ledger, iProcurement, iSupplier, Account Payables, Budget Execution, FedAdmin, PurchasingiStore, Quoting, Order Management, InventoryiExpenses, Advanced Pricing, Sales Online and AOL.

Database: ORACLE 9i, 10g, 11g, MS SQL Server and MS Access.

Languages: SQL, PL/SQL, JAVA, C, C++, JSP, HTML, JavaScript, AJAXUNIX/Linux Scripting. Tools: JDeveloper, Workflow builder, XML Publisher, ToadOracle Data Integrator (ODI), SQL Plus, SQL*LoaderEclipse, NetBeans, Kintana, SVN, Panaya, WinScp.

Application Servers: Oracle 9i AS, JBoss, Web Logic.

GUI Oracle Application: Framework, JSP, Struts.

Operating System: UNIX, Windows-NT/2000, DOS.

PROFESSIONAL EXPERIENCE:

Confidential - Bethesda, MD

Senior Oracle EBS Techno-Functional Consultant

Responsibilities:

  • Responsible for upgrade of iProcurement, iSupplier and Custom applications from 11i to R12.2.3.
  • Worked extensively in remediating and testing Non Catalog Requisitions, PCARD Requisitions, NBS External and Internal Requisitions and NBS Vendor Training Requisitions.
  • Remediated Requisition Account generator and Requisition Approval Workflows customizations.
  • Remediated Custom PL/SQL Packages, Views, triggers and API’s for Inventory, Order Management and Purchase Order Modules.
  • Developed new OAF customizations in Supplier forms to meet the client requirements.
  • Involved in configuration and development work for iProcurement, iSupplier, EVIP and Account Payables.
  • Extensively worked with iSupplier external vendors and supported them as needed in helping them create invoices and login issues. Acted as primary POC for iSupplier.
  • Worked with Oracle support on multiple Service Requests including R12.2 various performance related issues.
  • Remediated OAF components and BI Publisher Reports for NBS Fellow Ship Payment Process. This system allows the NIH Institutes and Centers (ICs) to create and maintain fellows and awards (Purchase Orders), disburse Fellowship and Health Insurance Payments, as well as associated tax documents.
  • Used Oracle performance tools like Explain Plan and TKPROF to tune the application.
  • Troubleshot and tested Funds Check Process for FPS system.
  • Remediated Inventory Supply Oracle reports.
  • Supported client and users for post go live support.
  • Developed Shell scripts to automate migration of OAF personalizations and extensions through HP PPM.

Environment: Oracle Applications 12.2.3, iProcurement, Purchasing, iSupplier, Payables, OAF, JDeveloper 10.1.3, Panaya, HP Quality Center, Workflow Builder, BI Publisher, SQL, PL/SQL, UNIX/Linux, TOAD 11.6, SVN, HP PPM, Win SCP, Putty.

Confidential - Rockville, MD

Senior Oracle EBS Techno-Functional Consultant

Responsibilities:

  • Involved in Enhancements and customizations of Oracle E-Business Suite Budget Execution, iProcurement, Purchasing, Account Payables.
  • Responsible for design, coding and development of custom applications using OAF, Workflow Builder, SQL, PL/SQL and XML Publisher.
  • Developed iReclass Tool interface to classify journal entries and automate the process of creating GL journal entries in UFMS General Ledger. This tool validates all the data, has online iReclass request workflow approval with monitoring and notifications, ability to create and query iReclass transactions, store iReclass data and approvals history, upload backup documentation and funds check while creating entries, easy export iReclass data to Excel and iReclass Reporting.
  • Developed Automated Clearing Record System (ACRS) custom interface that automates the process of creating AP invoices in UFMS Accounts Payable System from generic csv files for clearing transactions. This interface allows users to upload files from various clearing sources, correct the data, split the transactions and submit it.
  • Developed custom interface and OAF pages for UFMS Budget Execution process. This interface is developed to load the budgets for FDA every year and transfer the budget to appropriate centers and provide reporting to track the budget by funds and year.
  • Developed complex OAF Pages that include csv file upload through OAF page to server, dynamic LOV’s, Dependent LOV’s, Copy Functionality, Excel Feature, Amount Formatting, dynamic locking and hiding of fields and buttons, advanced tables and responsibility security.
  • Developed PL/SQL Packages, Procedures, and Functions for validating the invoices and payment information.
  • Worked on Payables Open Interface Import program to validate and create Invoices.
  • Created PL/SQL package for validating PO’s, Vendors and CAN’s, to populate and load data into interface tables, check balances and funds available, create journal lines and archive data.
  • Worked on support of Custom Applications, General Ledger, Budget Execution, Account Payables, iProcurement, Purchasing.
  • Used Application Object Library (AOL) to register generated Reports and Concurrent Programs.
  • Created new Lookups, Profiles, Concurrent Programs, FND Messages, functions, menus, and responsibilities.
  • Implemented Auto Lock Box by importing data into interface tables by writing control file according to bank transmission format.
  • Developed UNIX scripts to download and upload FND Messages, Profiles, Concurrent Programs, Lookups and migration scripts for java class files and pages.
  • Created HP-PPM packages, provided Deployment documents and Test Results for deployment/migration of code from Development Instance to Production System.
  • Involved in resolving issues related to Federal year end closing of UFMS Oracle EBS system.
  • Developed Oracle BI Publisher Templates and Reports using BI Publisher Desktop Edition.
  • Worked closely with client in requirement gathering, providing and testing solutions.
  • Provided alternative workaround solutions when there are technology challenges.
  • Involved in creating the business flow for the application using Microsoft VISIO.
  • Documented the MD070 and MD120 documents.
  • Developed Test case document for user testing.
  • Ability & highly keen on to learn, grasp and deliver both individually & also as a proactive team member.

Environment: Oracle Applications 11.5.10, Federal Financials, General Ledger, Account Payables, Budget Execution, iProcurement, Purchasing, OAF, JDeveloper 9.0.3, Workflow 2.6, BI Publisher, XML, UNIX, SQL, PL/SQL, TOAD, SVN, OBIEE 11g, Win SCP, Putty, SQL Plus.

Confidential - Waukegan, IL

Oracle Applications Technical Consultant

Responsibilities:

  • Involved in design, coding and development of the Oracle Applications Framework Extensions as part of 11.5.10.2 Enhancement, R12 Upgrade Projects with WMS Gaming.
  • Worked on Analysis, Design and Implementation of Soft Billing which reduced Work Order lead time.
  • Created the test plans and coordinated the UAT with the business users.
  • Involved in the design and Development of Customer Quoting Module using Oracle Applications Framework.
  • Worked on Application Module, Entity Object and View Object substitutions for various customizations.
  • Created Entity Expert classes, Property View Objects to validate and display fields based on business rules.
  • Extensively worked on creating Entity Associations and View Links for loading data from custom tables which were dependent on data from seeded tables.
  • Developed PL/SQL packages, procedures, and functions.
  • Defined value sets, flex fields, Lookups, Responsibilities using Application Object Library (AOL).
  • Designed a complex Configurator solution for quote copy along with copy configuration.
  • Created an advanced pricing solution in conjunction with configurator using pricing attributes for ‘Parts’ models.
  • Worked on Upgrade and retrofit of Quote Approval Workflow, Workflow for Task Manager, Order Headers, and Order Lines Workflow.
  • Developed OA Framework pages with custom security based on user security permission roles.
  • Conducted a number of workshops with Revisions team to gather requirements.
  • Developed program to identify and propose required correct parts for configuration to reduce downstream issues for Planning and E-Prom Room to ensure the correct size flash card is processed.
  • Involved in design and analysis of iProcurement Customizations and Approval Management Engine.
  • Developed UNIX scripts to download and upload FND Messages, Profiles, Concurrent Programs, Lookups and migration scripts for jsps, java class files and images.
  • Worked on supporting production issues.
  • Used Sub Version for version control of Custom code objects.

Environment: Oracle Applications 11.5.10, R12, SOA Suite, Oracle Quoting, Order Management, Inventory, Bills Of Material, Work In Process, Advanced Pricing, AR, iProcurement, TCA, OAF, BPEL, PL/SQL, UNIX, TOAD, Workflow 2.6, JDeveloper 9.0.3, SOA Suite.

Confidential - King of Prussia, PA

Oracle Applications Technical Consultant

Responsibilities:

  • Involved in design, coding and development of the Oracle Applications Framework Extensions as part of R12.0.6 Upgrade Project with Confidential .
  • Worked on customizations, personalizations of Oracle application Framework.
  • Developed Custom Quote Lines Region using Hgrid to support custom pricing and payment schedules of Configurator Models.
  • Extended Opportunity summary region to include additional attributes in the Personalize search page.
  • Created and extended various AMs, VOs and EOs as per the requirement.
  • Created new Pages to add rows and update rows for Custom tables.
  • Created new Lookups for the lookup values for the static choice dropdowns.
  • Worked on user and admin personalized views.
  • Developed custom validations for navigation from Opportunity, Quote Workflow Notifications.
  • Worked on Customizations on Calendar View, Task Update pages.
  • Worked on Upgrade and retrofit of Quote Approval Workflow, Workflow for Task Manager, Order Headers, and Order Lines Workflow.
  • Customized iExpense workflow to add approval hierarchy for related expenses.
  • Customized iExpenses Notification body to include fields from Expense Report Details.
  • Developed OA Framework pages with custom security based on user security permission roles.
  • Handled various Exceptions in the pages for various functions involved in transactions.
  • Created UNIX/Linux scripts to deploy Personalizations and Customizations in Various Instances.
  • Documented the BR100, MD070, TE.020 and MD120 documents.
  • Used Clear Case for version control of Custom code objects.

Environment: Oracle Applications R12, Oracle Sales, Order Management, Inventory, Advanced Pricing, AP, GL, iExpenses, TCA, OAF, UNIX, TOAD, Workflow 2.6, JDeveloper 10.1.3.

Confidential - Fort Wayne, IN

Oracle Apps Developer

Responsibilities:

  • Involved in design and customizations of various Oracle iStore.
  • Conducted Rapid Requirements gathering summits with the Business users to gather Requirements.
  • Involved in setup and implementation of iStore.
  • Created custom API’S to get Global Availability to Promise (ATP) Information without using the Cart Information in iStore.
  • Created Custom APIS to Get Pricing Information Using Advanced Pricing Api’s in iStore.
  • Customized iStore Direct Item Entry Page to Check Item Availability & Pricing Using Java and PLSQL Wrapper’s.
  • Created Custom Pages for Open orders, Track orders, Invoices in Oracle Portal using JAVA & JSP’s.
  • Extensively Customized User Registration Process using Diff Custom Enrollments. User types for B2B and B2c Customers in iStore Based on Roles & Permissions.
  • Customized iStore Alert and JTF Approval Workflow’s
  • Prepared Documentation involving from MD050, MD070 & BR100 following AIM methodology
  • Customized JSP’s for Look and Feel as per business requirement.
  • Helped in Integration of iStore with Oracle Portal.

Environment: Oracle Applications 11.5.10, iStore, Order Management, Inventory, UNIX, TOAD, JDeveloper 9i.

Hire Now