We provide IT Staff Augmentation Services!

Oracle Applications Techno Functional Consultant Resume

Atlanta, GA

SUMMARY:

  • Having 8 plus years of IT experience in Oracle Applications R12 and 11i E - Business Suite and complete SDLC (gathering Business Requirements, Analysis, Design, Implementation and testing).
  • Good Technical Developer with expertise in Oracle Manufacturing modules (OM,INV,PO,BOM,WIP), Financials modules (GL,AP,AR,FA,CM),supply chain modules(INV,PO,OM,CST,QP,WSH) i-Procurement, i-Store, AOL and Install Base Service Contracts.
  • Strong knowledge on Order to Cash (O2C), Procure to Pay (P2P) and DROPSHIP business flows.
  • Very good understanding of Trading Community Architecture (TCA).
  • Good working knowledge of RICEW (Reports, Interfaces, Conversions, Extensions and Workflows) components which involves working on Reports, SQL, PL/SQL Cursors, Composite data types, Procedures, Functions, Packages and Data dependencies.
  • Expertise in developing Functional Specification (MD-50), Technical Specification (MD-70), Migration (MD-120), Testing (TE-20), BR-100, CV-60 documents using AIM methodology.
  • Expertise on designing and implementing Oracle Alerts and Lookups.
  • Strong hands on experience in Oracle Applications 11i, Release 12, Oracle 10g/9i/8i, SQL, PL/SQL and Developer 2000(Forms 6i/10g, and Reports 6i/10g), SQL* Loader, Discoverer, Workflows and XML/BI Publisher and UNIX Shell Scripting.
  • Expertise in Design and Development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL * Loader scripts. Designing, developing, customizing and supporting the Inbound and Outbound Interfaces in Oracle Applications which includes AP, PO, AR, OM, INV, GL modules.
  • Experience using project management tools such as AIM Methodology, Microsoft Project and Visio.
  • Experience working on Application Developer and System Administration Responsibilities such as registration of concurrent programs, creations of Users, Responsibilities, Forms, Functions, Menus, Value Sets and Flex fields in Oracle Applications.
  • Knowledge on Oracle Application Framework (OAF), BPEL and SOA concepts.
  • Knowledge on Human Resource, payroll and Self Service applications in Oracle HRMS and good working experience with VSS (Virtual SourceSafe), WINSCP.
  • Good Debugging skills and good at using Exceptions and Error Handling.
  • Commendable experience in data conversions, interfaces, migrations using SQL*Loader and import and export using tools like Discoverer.
  • Excellent verbal and written communication skills with leadership qualities, analytical and problem solving skills and open to innovative ideas to develop a creative solution for challenging client needs.
  • Highly efficient in working under pressure with focus on meeting deadlines on top priority. Comfortable working in a team or as an individual when required.

TECHNICAL SKILLS:

Oracle Applications: Oracle E-Business suite R12/11i, OM, INV, GL, AP, AR, PO, FA,CM, WIP, BOM and AOL.

Application Tools: Reports 6i/10g, Discoverer 4i/9i/10g, BI/XML Publisher 5.6.3/5.6.2, Oracle Forms 6i/10g, TOAD, SQL*PLUS, Export, Import, SQL*Loader, Oracle JDeveloper, OA Framework.

Operating Systems: Windows NT/XP/2000/98, UNIX, Linux, MS-DOS, Microsoft Visio, MAC OSX.

Languages: SQL, PL/SQL, Web PL/SQL, C, C++, Java Script, PHP, C#, Java, HTML, XML.

Scripting Languages: Unix Shell scripts, Python, Perl.

RDBMS: Oracle 8i/9i/10g/11g, Access, SQL Server 2000, MySQL.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Oracle Applications Techno Functional Consultant

Responsibilities:

  • Working as a Sr. Techno Functional Consultant as well as onsite lead.
  • Leading the technical team for pre designing phase of upgrade to R12.1.3 from 11.5.10 including the design approach, end to end impact analysis of all the customization (CEMLI Preparation).
  • Interacting with the business users as well as third party system owners to understand the impact and preparing the documentation for smooth running of all the interfaces which involves third party software system.
  • Estimation preparation for the efforts including development, testing, CRP1, UAT and code deployment.
  • Document preparation for user training on the major modified area in the R12 in the financial domain.
  • Involved on implementation of iProcurement module with designing of solution approach to meet business requirements.
  • Worked on customization on PO Requisition Approval workflow to enable automatic creation of PO as soon as Requisition got generated.
  • Worked on customization of PO Requisition Account generator workflow to fetch correct accounting segment from user preferences set.
  • Actively involved during iProcurement setup and provided design approach to meet business requirements with minimum customization involved.
  • Involved on Forms Personalization, XML Publisher Reports Development, Workflow customizations, Complex Interfaces Design and day to day production support.
  • Develop technical specifications, process flow diagrams. Translate functional design into technical deliverables. Develop test strategy and author test plans as required for enhancements and patches.
  • Directly or indirectly, in conjunction with Business Analysts, work with business users to resolve customer support issues within Oracle EBS within agreed-to service level agreements (SLAs).
  • Involved in Development / Bug fixes/ Root cause Analysis of Custom Interfaces / Workflow and Customizations of Oracle Supply Chain System using PL/SQL, Forms & Oracle Reports.

Environment: Oracle EBS 11.5.10, R12, PO, REQUISITION, OM, INV,SHIPPING, SOURCING, AP, AR, iProcurement, iExpenses, Oracle Forms 10g, Oracle Reports 10g, XML Publisher, Oracle 10g, PL/SQL, TOAD, SQL Loader, Web center.

Confidential, Torrance, CA

Oracle Applications Techno Functional Consultant

Responsibilities:

  • Worked on Order Import interface, to load all the legacy orders in booked status into Oracle.
  • Worked extensively on Auto Lock Box to bring data from external sources into Receivables AR base tables.
  • Customized the Credit Analysis Report, Trucking Manifest and Pick Slip reports in Order Management OM.
  • Developed Conversion program to import Vendor/Supplier Information into Purchasing PO by loading data into staging tables from legacy system, validating data using PL/SQL API and then loading the data into Vendor information Base tables.
  • Created Custom responsibilities in GL, AR, OM, and INV and moved all orders booked and status not closed to the new responsibilities for further process.
  • Developed SQL*Loader control programs and PL/SQL validation procedures to load legacy GL Code Combinations into Oracle General Ledger GL.
  • The PO Approval Workflow is used to approve new documents as well as approve revisions to the Purchase Orders using workflow builder.
  • Adding and Capitalizing a CIP asset in Fixed Assets FA module.
  • Designed, developed and loaded data using FA MASS ADDITIONS Interface from Legacy systems.
  • Developed PL/SQL Packages, Procedures, Functions for validating the journals (for accrual and payment information) in the staging table and importing them into Oracle Application using the GL Open Interface and populated the base tables, which involved in creation of multiple journal entries for each type (accrual and payment) and journal import.
  • Worked on the development of Interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports in Order to Cash Cycle touching various modules such as GL, AR, INV, OM, BOM & SHIPPING.
  • Developed UNIX Shell scripts to FTP the Flat file from External Server to Oracle UNIX Server location.
  • Developed Interface for the Standard Items in INVENTORY generating the SQL Loader scripts and PL/SQL procedures for validating and loading data into oracle tables
  • Developed interfaces to import payable invoices and iExpenses related invoices.
  • Responsible for design, development of reports across various modules using XML/BI Publisher and Discoverer. Customized the Master/Detail budget report in GL and the Discounts Available
  • Customized existing Oracle Reports in Inventory Module (INV), pricing using Reports 10g.
  • Invoices are imported from the Excel sheets to the Oracle Database using SQL *Loader.
  • Worked on performance tuning like Explain Plan to improve the performance of various custom PL/SQL Packages developed.
  • Responsible for Migration of code and data fixes through Tortoise SVN.

Environment: Oracle Applications 12.1.2, Oracle 10g, PL/SQL, SQL, Forms, Reports, Workflow Builder 2.6.3.5, CVS, SQL*Loader, DB2,, Putty, Winscp 3, FTP, Optio 7.8, Windows XP and UNIX

Confidential, Reno, NV

Oracle Functional Analyst

Responsibilities:

  • Involved in requirement gathering, design and development of functional specifications for General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Purchase Order (PO) and Fixed Assets (FA) modules
  • Conducted Business Process Review (BPR) and GAP analysis to determine business requirements and prepared documentation accordingly
  • Implemented General Ledger (GL) by defining chart of accounts, calendars (Accounting & Transaction), currency types, conversion periods, conversion rates, flex fields and values sets to deal with multi-currencies
  • Involved in set up for consolidations and customizing FSGs and generating reports using RXi Reports tool along with month end close processes for GL and sub-ledgers
  • Implemented Purchasing (PO) module by setting up organizations, inventory organizations, locations and customers, buyers, payables options and purchasing options
  • Performed buyer set up to facilitate PO creation and approval process by defining various approval groups and approval limits with default approval routing hierarchies
  • Acted as a liaison between the client and technical team to enable product development with a close fit to client requirements.
  • Analyzing the requirements.
  • Prepare MD 70 for the SRS
  • Understanding of EBS architecture and underlying tables / columns in Oracle EBS R12.1.3.
  • Working on P2P module and worked in one complex PO conversion.
  • Identify the gaps in 11i and make changes to R12.
  • Working on RICE components.
  • Developed complex shell script program calling PL SQL from shell scripts
  • Helped the team in solving critical issues.
  • Worked towards Future business flows, Identification of Gaps, Workarounds in order to provide an Integrated Procure to Pay (P2P) business flow.
  • Developed Custom Programs to load Data item into Interfaces in Account Receivables (AR).
  • Worked on implementing Oracle Inventory to Cash business flow as part of Procure to Pay (P2P).
  • Performed Setup steps, defined various Key Flex fields and Descriptive Flex fields for Financial Modules AP, AR, GL.
  • Responsible for changing existing forms and reports of Customized Account Receivables (AR).
  • Creating and Approving AR Invoices.

Environment: Oracle Applications 11.5.10 RUP2, 11.5.10 RUP6, R2R, O2C, GL, AP, AR, INV, PO, iStore, PL/SQL, Reports 6i, Forms 6i, SQL*Plus, Oracle RDBMS 9i/10g, UNIX.

Confidential, Phoenix, AZ

Oracle Apps Techno - Functional Consultant

Responsibilities:

  • Worked on Open Item Interface to convert Purchased Item Information from Custom Purchasing System to Oracle INV module.
  • Developed custom conversion program to convert Locators and On Hand Quantities in WIP module
  • Involved in General Ledger conversion of legacy data into Oracle Applications using PL/SQL packages and Shell Scripts. SQL * Loader was used to load data into custom tables.
  • Developed validation packages to Load data to interface tables (OE HEADERS IFACE ALL, OE LINES IFACE ALL, OE CUSTOMER INFO IFACE ALL)
  • Developed XML reports to Provide Customer Master Data details and its transactions details like orders, invoices, service requests, service contracts and install base for Customer Data Cleansing process
  • Designed and Developed packages for the SOA adapters to interact with the Point of Sales Application
  • Designed and Developed wrapper API to load the Extensible attributes in TCA
  • Designed and Developed Wrapper API to make web service calls to SOA and Raise Business Event in Oracle Applications for the order import process
  • Worked on customization of Order Import Interface in Oracle Order Management.
  • Worked on Form Personalization in Order Management
  • Customized Auto lockbox interface such that the receipt file from the bank is automatically imported into Accounts Receivable.
  • Involved in the Query Optimization using Explain Plan to bring the existing Queries to optimize to the maximum.
  • Customized Un-invoiced Receipts Report and Supplieron Hold Report in Purchasing
  • Customized AP Approval, Requisition Approval and PO Approval workflow for Procurement.
  • Developed Alerts in Inventory Modules.
  • Worked on auto create deliveries across sales orders and launch pick release using APIs
  • Developed Interface for the Standard Items of Sales Orders Import in OM.
  • Worked on Item Conversion in the INV Module.
  • Customized the Sales Order Invoice Detail Report in Order Management.
  • Customized Pack Slip report, Shipping, Back Order Report and Freight Carrier Listing Report in OM.
  • Modified Material Account Distribution Summary Report to run for all organizations in INVENTORY.
  • Developed Order Capture Exception Report to display errors, exceptions and modifications generated during Order Import Interface.
  • Developed Order Status Summary Report to provide the status of orders in the system for given time period.
  • Developed new reports like Daily Demand report; forecast Accuracy report, Open Vs Active PO, Return Reject Inventory Report.
  • Worked with SQL Loader and PL/SQL Built in packages to import legacy data into Oracle Applications using different APIs at different levels as and when necessary.
  • Created workflows using workflow Manager for loading the converted data into the target tables.
  • Worked on creating various Oracle XML reports as per client requirement.
  • Developed technical documentations of work done complying with AIM Methodologies.

Environment: Oracle Applications R12 (12.0.5) (GL, AR, OM, INV, WSH), Forms 10g, Reports 10g, SQL*Loader, BI Publisher.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

  • Prepared User Requirements document (URD) for Data Migration from legacy to Oracle Apps.
  • Developed a Custom form for the Line flow Schedule data in WIP Module.
  • Developed SQL scripts to create temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables.
  • Worked on configuration and customization various oracle modules (OM, INV, AP, AR, OM, GL) for a multi-site, multi-phase implementation
  • Documented all the conversions according to the AIM documentation standards.
  • Prepared MD70, MD120 using AIM Methodology
  • Worked on Open Item Interface to convert Purchased Item Information from Custom Purchasing System to Oracle INV module.
  • Developed Order interface for daily and weekly feeds of orders
  • Conversion and reconciliation of Legacy AP Invoices and Payments into Oracle Applications.
  • Designed and developed Payables interface import program and interface tables to load invoices from the legacy systems into the oracle payables base tables.
  • Designed and developed Conversion scripts to convert data from 11.0.3 to 11.5.9 systems for AR Module. For the Customer related data, Scripts were developed to use the standard Customer Interface program and includes converting Customers, Addresses, Sites, Contacts, Phones, Profiles, Profile Amounts etc
  • Customized seeded reports such as Invoice print report, Commercial Invoice, Customer Invoice report, Print Selected Invoice, transaction detail report, Account Status report in AR.
  • Validated the data and populated the Payables interface table through a Concurrent program which in turn submits a standard Payables Interface program.
  • Customized Invoice Register Report by appending additional columns like invoice terms, supplier site promotions cost and descriptive flex field information.
  • Created a custom AP Trial Balance report.
  • Developed Reconciliation Report using XML Publisher (BI Reports) Reporting Tool.
  • Developed a new report to get users who have Purchase order and requisition open and are out of the company.
  • Developed database triggers on insert or update on MTL ITEM CATEGORIES table to track the changes in the table.

Environment: Oracle Applications EBS 11i(AP, AR, PO, OM, INV, GL FA, CM, BOM and WIP), Oracle 9i, Workflow Builder 2.6, Developer 2000/6i, Reports 4.5, BI Publisher 5.6.2, PL/SQL, SQL*Loader, SQL*Plus, TOAD, Windows XP.

Hire Now