Oracle Apps Technical Consultant Resume
TX
SUMMARY
- Over 7 years of experience as an Oracle Applications Technical consultant with expertise in Order Management OM, Purchasing Order PO, Inventory INV, Oracle Financial modules (General Ledger GL, Account Payables AP, Account Receivables AR, Fixed Assets FA and Cash Management CM) Project Accounting PA, Bills Of Materials BOM and Work In Progress WIP.
- Extensive experience in developing Reports, Interfaces, Conversions and Extensions (RICE) Components.
- Implementation in Order to Cash (O2C) and Procure to Pay (P2P) business Cycles both R 11i/12.
- Involved in performance tuning in oracle using Explain plan, Auto Trace and Tkprof.
- Experience with AOL in creation of Flex fields, Value sets, Concurrent programs,, Request group, Menu, Forms, Forms Functions and Responsibilities.
- Worked on Oracle Discoverer (Desktop, Administrator, Plus, Viewer), which includes report developments, discoverer administration, configuring discoverer and End User Layer (EUL).
- Extensive experience in developing Interface/Conversion Programs to import data from various Legacy Systems into Oracle Applications using PL/SQL packages, SQL*Loader, Oracle Standard Api’s, Interface Tables and Unix Shell Script’s.
- Extensively worked on Out Bound Interface using UTL File to import data into various file formats.
- Worked on OA Framework in Customization and Personalization of JSP pages.
- Experience on FORM PERSONALIZATION, CUSTOM.PLL and Customizing Oracle Forms.
- Creation Of forms using TEMPLATE.fmb and APPS STANDARD.fmb.
- Creation and customization of Oracle reports as per business requirement using tools like Oracle Report Builder, XML Publisher and BI Publisher.
- Creation of XML reports using PL/SQL Packages.
- Well versed with AIM (Application Implementation Methodology) Documents.
- Participated in written Functional (MD050, CV040), Technical (MD070, CV060) design documents and Testing documents TE020.
- Good Knowledge In Multi - org In both R12 and 11i.
- Substantial development experience in creating Stored Procedures, Packages, Triggers, Functions, Indexes, Views, Sequences and Staging tables.
- Expertise on migration of developed components from development instance to production instance using FNDLOAD.
- Experience in developing of SOD Matrix and assigned responsibilities to different business users.
- Demonstrated highly effective communication skills through presentations at the end of implementations with each project.
- Strong analytical and problem solving skills and a proven ability to be an effective team player with excellent time management skills.
- On time deliverables and on time supporting to the client.
TECHNICAL SKILLS
Oracle Applications: R12, 11i, 11.5.3,11.0.3,11.7
Oracle EBS Modules: GL, AP, AR, OM, PO, CM, INV, AOL,FA, PA,BOM and WIP
Oracle Tools: Reports6i/10g, Forms 6i/10g, Discoverer 4i/10g, Developer2000/6i/9i/10g, Workflow Builder, XML/BI publisher, WINSCP and Putty
IDE: TOAD, SQL Developer and SQL Developer
Languages: SQL and PL/SQL
Database: Oracle 11i/10g/9i/8i
Database Tools: TKPROF, SQL*PLUS, SQL*LOADER
Scripting Languages: UNIX shell scripting
Operating Systems: UNIX, Linux, Windows NT/2000/ MS-DOS
PROFESSIONAL EXPERIENCE
Confidential, TX
Oracle Apps Technical Consultant
Responsibilities:
- Worked on Oracle Projects Accounting (Billing, Costing)
- Reviewed the existing system and Prepared Document to Change the Projects Task structure for the user Interface.
- Studied the existing API’s and made changes in order to make effect for the new structure.
- Developed Journal Voucher Report.
- Developed GL Daily Rate conversion program as per client requirement.
- Customized Invoice Payments History Report.
- Modified packages, procedures and functions for designing user interface.
- Created Different template structures for different Organizational setups in order to create new projects.
- Involved in the development of Interfaces/ Conversions to import the data from legacy system into oracle application base tables with Validations.
- Created different Billing Cycles, Billing Frequencies with the existing API’s as per the user requirement.
- Worked on projects invoicing (Auto Invoicing) made a Customized procedure for the auto invoice generation for every customer by running concurrent program requests.
- Worked on Alert manager in order to make alerts to the project mangers regarding the status of project and billing.
- Worked on Time Cards in order to enter the Employee billed hours, Un billed hours and invoiced hours.
- Worked on different PA tables in order to change the Projects new task structure for the user end.
- Assisted in compiling the required functional setup changes for the Task Restructure.
Environment: Apps 11i, XML Publisher, Oracle 6i, Reports 10g, Windows XP, Project Accounting (PA), General Ledger (GL) and Account Payables (AP), PL/SQL, TOAD, Winscp and Putty
Confidential, CA
Oracle Apps Technical Consultant
Responsibilities:
- Developed Reconciliation Reports for GL & CM module.
- Developed API for Converting the Invoice Payments (AP) from legacy system to Oracle.
- Written an interface for invoices Upload, which creates invoices from a CSV file.
- Developed conversion program for Purchasing Order import from legacy system into oracle applications using Oracle interface tables and Import standard purchase order program.
- Developed Customers interface in Accounts Receivables (AR) using Oracle Standard API.
- Written PL/SQL packages with cursors, functions and procedures for inserting the data into vendors, invoices and purchase orders interface tables from various staging tables while validating the data.
- Prepared Technical Specification MD.070, TE.020 and CV.060 documents.
- Import Open AR Invoices using Oracle standard interface tables and Auto invoice import program
- Developed Supplier ledger report as per client requirement.
- Created control file to load data into staging using SQL* LOADER conventional path.
- Created test scripts for every level of testing from unit testing stage to integration testing.
Environment: Oracle Applications - 11i/12 AP, AR, GL, CM, PO, Forms 6i, Reports 6i, SQL*Loader, BI/XML Publisher, PL/SQL, TOAD, Winscp and Putty
Confidential, Lancaster, OH
Oracle Apps Technical Consultant
Responsibilities:
- Performed business requirement gathering and high-level solution design for implementing Purchasing Order, Accounts Payables, Order management and General ledger.
- Designed and developed an Outbound Interface between Internal Systems (Supply-Chain Management tool) and Oracle Applications for Customers, Items, On hand Quantity, etc.
- Conducted multiple workshops for demonstrating the prototype of the system to illustrate preliminary business process flows, discuss high-level fit-gap analysis, gather detailed business requirements and identify detailed gaps.
- Developed PL/SQL Inbound interface programs in Oracle Accounts Payable module (worked on Invoice formats of FedEx Air and ground, Enterprise Partner)
- Customized GL ‘Journal Batch Summary and Detailed Report’.
- Worked on Pending Invoice for Payments and Pending approval status report.
- Customized Shipping Exception Report.
- Performed migration of Purchase Requisition and Purchase Order using SQL* Loader, Oracle Interface and Oracle Standard Programs in P2P cycle
- Developed Pl/SQL program to import Items into Oracle Inventory using Item Import Program and Item Interface Tables
- Open AP Invoices Migrations to 11i using Payables Open Interface.
- Worked with Process Order API to create new orders in O2C
- Developed Purchase order and invoice print reports to the business requirements.
- Developed Discoverer End User Layers to develop Month End Parts ordered report.
Environment: Oracle Applications 11i, Discoverer 6i, Forms 6i, procurement, Reports 6i,AP,OM,PO, P2P cycle, O2C cycle, TOAD, SQL* Loader, XML Publisher, Winscp & Putty.
Confidential, Louisville, KY
Oracle Apps Techno Functional consultant
Responsibilities:
- Designed customizations, interface/conversion mapping in Development instance and Production instance.
- Interacted with end users for business requirement gathering and provided solution at on time.
- Invoked standard API’s within custom packages for creating and updating Customer Sites and Contacts.
- Gathering Open Purchase orders from legacy system and migrated into Oracle applications using interface tables and Import purchase orders.
- Wrote Functional (MD050) and Technical Specification (MD070), Conversion Mapping (CV040, CV060) documents for converting Vendors, Vendor Sites and Vendor Contacts.
- Experience in developing of SOD Matrix and assigned responsibilities to different business users.
- Designed, developed and documented an Inbound/Outbound interfaces.
- Designed and developed Asset Conversion by running Mass Additions Concurrent Program to transfer the data from interface to base tables in Fixed Assets (FA).
- Responsible for providing production support for Account Receivables (AR) and Account payables (AP).
- Migrated the components among the instances using FNDLOAD and LDT files.
- Developed Concurrent Programs, Value Sets, Request Sets & Request groups based on the business requirements.
- Developed Supplier Details Report at Operating levels.
- Developed Customer ledger report.
- AR Invoice Print Report for multiple invoices, each invoice should print on individual page.
- AR Cash Receipt Print Report.
- Designed and developed complex Discoverer reports by communicating and interpreting end-user business requirements.
- Registered customized Oracle reports and XML Publisher reports using System Administrator and XML Administration.
Environment: Oracle Applications 11i 11.5.10 and R12 12.1.3, AP, AR, PO, FA, GL, INV Reports 10g, Discoverer, XML publisher, SQL, SQL*Loader, PL/SQL developer UNIX, TOAD, Winscp and Putty.
Confidential
Oracle Apps Technical Consultant
Responsibilities:
- Overseeing project implementation and process changes.
- Coding for the Interface programs to extract data into flat file and uploading of data files to the media application using UTL File
- Created the necessary Packages, triggers for the implementation.
- Fine tuning the SQL Queries to improve the speed of program execution using us Explain plan, Auto Trace and Tkprof.
- Coordinated with users to ensure that the User Acceptance Testing is done successfully.
- Extensively worked on PL/SQL and wrote necessary scripts.
- Ensured that the programs, scripts, procedures fully tested to ensure bug free performance.
- Demonstrate domain expertise in business area related to the assigned project including keeping up with latest industry trends.
- Preparing Test Case Documents (TE020).
- Creation of views and reports.
- Developed Bar code Reports for manufacturing modules.
- Ensured that the programs, scripts, procedures fully tested to ensure bug free performance
- Complete responsibility of deliverables as well as the production support
Environment: Oracle Applications 11i, PL/SQL, Forms 6i & Reports 6i, INV, BOM & WIP.
Confidential
Oracle Apps Technical Consultant
Responsibilities:
- Tuning the PL/SQL code for performance enhancement.
- Developed Custom forms and added the zoom functionality in the e-business form. And also developed PL/SQL scripts.
- Registered concurrent programs, request groups for reports.
- Created Customized Invoice report for client by modifying standard Invoice Report provided by Oracle.
- Enabled the descriptive flex fields on Sales orders and Invoices to facilitate additional information.
- Developed Daily rate conversion program for currency conversion.
- Developed Oracle alert which shows every day currency exchange rates.
- When day starts this alert goes to the management including all the conversion rates.
- Involved in System Administration Created Users, Menus, Responsibilities, functions, User Authentication security system profiles, etc.
- Involved in preparation of Technical Documentation (MD070) using AIM Methodology.