We provide IT Staff Augmentation Services!

Oracle Applications Technical Consultant Resume

Washington, DC

SUMMARY:

  • Over twenty years of experience in developing business and financial applications in the ERP, Client/server, Object Oriented technology
  • Leadership qualities in managing teams, in facilitating key management decisions, presentation skills at any level.
  • Well conversant with Oracle’s AIM methodology. Green - Belt Certified
  • Proven track-record of working with leading companies like Confidential and Cisco
  • Extensive techno-functional experience working on Oracle Financials and Supply Chain modules as a lead person. Extensive experience in the Functional and Technical areas of iProcurement, BOM, Routing, PO, AP, iSupplier Portal, OM, Inventory and AME
  • Worked in Oracle Applications R12, 11.5.10, 11.5.9, 11.5.8, 11.5.3, 11.03, 10.7
  • Good experience working on interfaces, conversions, Unix Korne Shell programming and UTF8 conversions.
  • Very strong in Oracle database programming, creating fuction, procedures,packages and triggers.
  • Extensively worked in Upgrading of workflows/customizing in Family Pack G, Family Pack H, Family pack I and Family Pack J using Workflow Builder.
  • Extensively worked on Forms 6i and Reports 6i.
  • Good Analysis, Design and Programming skills
  • Extensive experience developing reports in Oracle APEX
  • Comprehensive experience customizing Workflows Strong exposure to System Administration and Application Object Libraries

SKILL:

Application: Oracle iProcurement, Oracle Purchasing, BOM, Routing, WIP, Sourcing, iSupplier Portal, Inventory, Order Management, Account Payables, Work Flow and AOL

Languages & Tools: Oracle Workflow 2.6, Developer 2000, Forms 6i/Reports 6i, Oracle APEX

Databases: ORACLE-7.3, ORACLE-8, ORACLE-8i, ORACLE-9i

Operating System: UNIX, Windows 2000

Hardware: IBM-PC Compatibles

PROJECT EXPERIENCE:

Confidential, Washington, DC

Oracle Applications Technical Consultant

Responsibilities:

  • Upgrading the system to R12.
  • Creating document on mapping 11i tables with R12 tables.
  • Debugging issues
  • Modify all Procedures/packages/triggers based on the new TCA architecture.
  • Performance Tuning of long running query.
  • Working on SR with Oracle
  • Customization of Workflow
  • Creation of reports in Discoverer
  • Upgraded FMS system to R12 in 8 months.
  • Created a generic script to create a flat file for any sql passed and in any format or separator.

Confidential, Raleigh, North Carolina

Oracle Applications Technical Consultant

Responsibilities:

  • Developed a custom BOM Conversion using APIs
  • Developed Customer Item Conversion Program .
  • Developed Customer Item cross Conversion Program.
  • Development of Routing Conversion Program
  • Development of Sourcing Rule Conversion
  • Creating interface for deleting inactive items .
  • Creating Item load Interface.
  • Setup of Forecast Sets and Forecast Designators
  • Customization of Workflow
  • Designing and testing customizations and enhancements
  • Developing OM conversion specifications and programmatic conversion processes
  • Working tars, testing patches
  • Developed Informatica mappings by using Slowly Changing Dimensions.
  • Extensively worked on the Performance Tuning of mappings and sessions.
  • Creating Oracle PL/SQL Procedures/functions/tables/Indexes
  • Creating scripts for ftp of files.
  • Performance tuning of queries

Confidential, Charlotte, North Carolina

Oracle Applications Technical Consultant

Responsibilities:

  • Define Purchasing cycle.
  • Define suppliers & Approved supplier list.
  • Customization of Workflow.
  • Define Items, item attributes.
  • Creating interface for deleting inactive items.
  • Creating Item load Interface.

Confidential, New York

Oracle Applications Techno-Functional Consultant

Responsibilities:

  • Gathering Business requirements.
  • Creating Functional and Technical documents.
  • Present the solution to the Business users.
  • Setup for PO/Requisition workflow in Purchasing. Of HR Interface
  • Troubleshooting Production HR Issues
  • Customizing T&L HR Workflow.
  • Working on development
  • Developing document viewer in Oracle APEX team members on Oracle APEX
  • Perform SYSADMIN setup, Profile setup.
  • Setting up timeouts for notification escalation in iExpense.
  • Integration of AMEX with iExpense
  • Involved in Project design and development of purchasing functionality
  • Customizing and Upgrading PO, autocreate, requisition initiated change order and requisition workflows .
  • Writing Procedures, functions, Packages and triggers.
  • Development of Forms for custom setup tables.
  • Customization of Invoice Approval workflow using AME.
  • Working on Production issues.
  • Performance tuning of High cost queries.
  • Generating Trace file for debugging issues.
  • Working on TAR with Oracle
  • Testing
  • Development of Forms for custom setup tables.

Confidential, NC

Oracle Applications Technical Consultant

Responsibilities:

  • Gathering Business requirements.
  • Working as IT Analyst for HRMS.
  • Data mapping of required fields in HRMS.
  • Working on upgrade from 11. for iProcurement, Purchasing and HR.
  • Analysis on the new functionality in R12.
  • Creation of Table Space.
  • Customization of iExpense workflow.
  • Calculation of backup space requirement for financial tables in Archive schema.
  • Creating FSD
  • Developing HR Interface
  • Customizing Workflows.
  • Modification of Form and Report as per business requirement.
  • Customization of Invoice Approval workflow.
  • Working on Production issues.
  • Testing
  • Group the requisition based on requestor, supplier and description
  • Escalation process
  • Stop autocreate for the requisition, which are not touchless, and these requisition should not be visible in autocreate pool.
  • Sends Email to the concerned person with relevant error message making the Requisition incomplete
  • One time script to create Contracts.
  • Script to create autobuyer employees and users

Confidential, CO

Oracle Applications Technical Consultant

Responsibilities:

  • Upgrading PO and requisition and OM workflow .
  • Gathering requirements for iSupplier customization
  • Giving Demo of iSupplier to users.
  • Testing of customization.
  • Documentation and knowledge transfer to Confidential technical team.

Confidential, FL

Oracle Applications Techno-Functional Consultant

Responsibilities:

  • Conduct meeting with Cincom team members and understanding the requirement.
  • Enhancement of GL Interface
  • Setup and Implementation of OFA.
  • Involved in the development of Reports, Interfaces, Conversions, customization of Workflow
  • Developed a custom BOM conversion using oracle APIs to load BOM from custom application
  • Created triggers on order lines to perform custom validations.
  • Designed and developed custom workflow Item types to send notifications from Concurrent Programs/PL-SQL procedures.
  • Prepare mapping between oracle and cincom field.
  • Preparing extract file layout required for each conversion
  • Identifying Translation/Derivation required for mapping.
  • Preparing Technical design document in CV60 format for Conversion
  • Preparing Technical design document in MD70 format for Interface
  • Coordinating with offshore in development of code
  • Development at Onsite
  • Preparing UTC document.
  • Testing of conversion.
  • Preparing MD120 document
  • Conducting knowledge transfer sessions with GEUnison team members .

Confidential, PA

Oracle Applications Techno-Functional Consultant

Responsibilities:

  • Setups for Application
  • Testing existing functionality
  • Verifying setups after upgrade.
  • Requirement Gathering
  • Preparing test scripts and Setup document.
  • Functional Specifications and Gap analysis.
  • Functional design document
  • Gathering Technical requirement for workflow customization.
  • Resolving critical workflow issues in production quickly.
  • Setup of AME rules for Invoice approval workflow.

Confidential, California

Oracle Applications Techno/Functional Consultant

Responsibilities:

  • Techno/Functional consultant for iSP implementation.
  • Facilitating Supplier Adoption Process
  • Testing existing functionality
  • Setups of Application.
  • Ensure smooth functioning of iProcurement module.
  • Organizing weekly status and review meetings with various users to review the modules and to discuss the wish lists.
  • Tracking all the enhancement requests from the users and planning the development.
  • Coordinating with offshore team for the deliveries of the production fixes and enhancements.
  • Involved in analyzing the business requirement, preparation of GAP analysis documents, functional and technical specification documents.
  • Conducting Conference Room Pilots and Super Users Coordinating the QA and UAT

Confidential, New York

Oracle Applications Techno-Functional Consultant

Responsibilities:

  • Testing existing functionality
  • Ensure smooth functioning of iProcurement module.
  • Organizing weekly status and review meetings with various users to review the modules and to discuss the wish lists.
  • Tracking all the enhancement requests from the users and planning the development.
  • Coordinating with offshore team for the deliveries of the production fixes and enhancements.
  • Involved in analyzing the business requirement, preparation of GAP analysis documents, functional and technical specification documents.
  • Leading the workflow upgrade team in upgrading workflow.
  • Gathering Technical requirement for workflow customization.
  • Resolving critical workflow issues in production quickly.
  • Setup of AME rules for Invoice approval workflow.

Confidential, Cincinnati

Group Leader

Responsibilities:

  • Requirement Analysis
  • Coded
  • Tested of the Maintenance Change Requests (MCR's)
  • Co-ordination with the client during conference calls
  • Knowledge Transfer to new team members

Hire Now