CONSULTANT NAME
(Oracle Apps Developer)
SUMMARY
| About 6 years of experience in Analysis, Design, Development, Testing and Implementation of Software Applications using Oracle Applications 11.5.x/11.0.3 spread across Implementations, Version upgrades, Data conversions and Customizations. |
| Experience in three full lifecycle implementations. Strong knowledge of Order to Cash and Procure to Pay Cycles.
|
| Extensive experience in Oracle Application Modules which include General Ledger(GL), Accounts Payable (AP), Accounts Receivable (AR), Purchasing(PO), iReceivables, iProcurement, iStore, Fixed Assets(FA), Inventory (INV), Bills of Material (BOM) & Order Management (OM) modules.
|
| Extensive Programming experience in Oracle 10g/9i/8i, SQL, PL/SQL and XML.
|
| Expertise in Forms 9i/6i and Reports 9i/6i. |
| Experience in Application Object Library (AOL) Framework for forms based applications as well as Oracle Applications Framework (OAF) for Self Service Frame Work 5.6E.
|
| Expertise in Data Conversion and Interface development |
| Experience in Oracle Discoverer and XML Publisher
|
| Experience in Workflow Customization according to business needs. |
| Strong analytical, diagnostic and troubleshooting skills and ability to work in a fast-paced and team-oriented environment. |
| Experience in environments requiring direct customer interaction during specifications, documentation, design and development and implementation phases. |
| TECHNICAL SKILLS |
| Oracle Applications: | Oracle Applications 11.5.x/11.0.3/10.7. (Accounts Receivables (AR), General Ledger (GL), Accounts Payables (AP), Fixed Assets (FA), Order Management (OM), Inventory (INV), Purchasing (PO) Bills of Material (BOM), iProcurement, iReceivables, iStore and Application Object Library (AOL)). |
| Languages: | Java, SQL, PL/SQL, HTML, PHP, C, C++ UNIX Shell Scripting |
| RDBMS: | Oracle 10g/9i/8i, MS SQL Server 6.5/7.0, MySQL 4.1, MS Access |
| Oracle Tools: | Forms 6i/9i, Reports 6i/9i, Oracle 8i/9i, Discoverer 4i/9i, JDeveloper, Work Flow Builder and XML Publisher. |
| Database Tools and Utilities: | SQL*Plus, SQL* Loader, Toad |
| Operating Systems: | UNIX, LINUX, Windows 98/NT/2000, MS DOS, Solaris 8.0 |
PROFESSIONAL EXPERIENCE
| Client Name |
From Date - To Date |
| Oracle Applications Techno-Functional Consultant | |
This Project involved implementing of Oracle Applications 11i. Responsibilities included writing conversions and interfaces, customization and development of reports using Reports 6i, Discoverer 4i and XML Publisher and customizing forms using Forms 6i in GL, AP, AR, OM, PO, INV.
Responsibilities:
| Responsible for gathering Business Requirements, creation of Technical Design Documents and user Documents.
|
| Worked extensively on Customer Conversion using interface tables to import customer data from Legacy AS/400 system. Was involved in data mapping, and interaction with functional consultant and business users.
|
| Developed a custom item interface program for loading legacy items information into Inventory Item Interface tables, by validating items according to their predefined item categories and category sets.
|
| Designed and developed Order Import Interface for daily and weekly feeds of orders.
|
| Developed Vendor conversion program to import vendors from the legacy system into Oracle with required validations.
|
| Customized AR account status Report, and AP Trial Balance report using Report 6i tool.
|
| Designed and developed reports using combination of Report 6i and XML publisher for modules like Purchasing and Order management.
|
| Developed reports in Discoverer 4i and created various business areas, user views, custom folders and joins for reporting. Created Workbooks based on the Custom Folders with multiple parameters and calculations using Discoverer Plus and Discoverer Desktop.
|
| Involved in Workflow customization for approval hierarchy level in Purchasing.
|
| Developed interfaces integrating Vertex O-series with Oracle Modules OM and AR.
|
| Created several Requests and Request Set to attach the PL/SQL procedures, SQL*Loader routine and Reports with Application.
|
Environment: Oracle Applications 11.5.10.2 (AR, AP, GL, PO, OM, INV), Solaris, Oracle 9i, Forms6i, Reports 6i, Discoverer 4i, Workflow 2.6, PL/SQL, SQL*Loader, Toad 8.5
| Client Name |
From Date - To Date |
| Oracle Applications Techno-Functional Consultant | |
Assigned as Oracle Applications Technical consultant to design, customize, implement and support Oracle Application. Involved in full implementation life cycle of GL, AP, AR, PO and FA. Responsible for implementation of 11.5.10.2.
Responsibilities:
| Interacted with business owners, functional consultants and subject matter experts effectively to understand business requirements, functional designs, process flow and data flow.
|
| Worked on Purchase Orders conversion. Responsibilities involved configurations, data mapping using SQL*Loader to import legacy Suppliers into Oracle.
|
| Developed PL/SQL Packages, Procedures and Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated the base tables.
|
| Used Auto Invoice Interface to import Standard Invoices into Oracle Receivables using a control file, PL/SQL Packages/Procedures and Auto Invoice Import program.
|
| Customized the AR Invoice, Sales Tax Reports in Receivables using Reports 6i and XML Publisher.
|
| Converted Fixed Assets Data from Legacy System to Mass Additions Table using SQL Loader and developed programs for Conversion of Tax Data from flat Files to Tax Interface Tables.
|
| Extensively utilized the Application Object Library (AOL) to Register PL/SQL Procedures, forms and reports.
|
| Customized the Print Purchase Order Report based upon user requirements and added bitmap image of company logo to the report.
|
| Customized the following workflows:
o PO Approval Workflow: Implemented notification reminder and Timeout needs for the PO Approval workflow
o PO Account Generator Workflow
|
| Worked closely with the team responsible for Setups and Customization of self service modules like iProcurements, iExpenses, iPayment, iReceivables, Modified XSL, JSP, XML files for additional functionality and GUI enhancement.
|
| Created and modified PL/SQL API for creation of assets retirement and Mass additions in interface table in FA module.
|
| Involved in the process of splitting the bank file to feed Auto lockbox.
|
Environment: Oracle Applications R11.5.10.2 (AR, AP, GL, PO, FA, iProcurement), Solaris, Oracle 9i, Forms6i, Reports 6i, Discoverer 4i, PL/SQL, SQL*Loader, Toad 8.5, Workflow, Jdeveloper.
| Client Name |
From Date - To Date |
| Oracle Applications Techno-Functional Consultant | |
Provided technical support in terms of design, analysis, development and testing of customization and extensions for Oracle Applications 11i (GL, AP, AR, PO, iProcurement).
Responsibilities:
| Developed an interface to upload the legacy GL Journal data into the Oracle Application System, developed a PL/SQL procedure, which transfers data to interface tables after performing necessary business validations
|
| Developed various custom reports and customized standard Oracle reports like Account Status Report and Bank Account Listing as per the business requirements.
|
| Used Payables Open Interface to import payables information from legacy system to Oracle Applications.
|
| Designed and Developed AR Auto-invoice interface from different front-end systems
|
| Customized Invoice printing Report for selected invoices and new invoices as per user requirements.
|
| Modified PO Requisition workflow as per user requirements.
|
| Customized iProcurements pages as per client requirements added additional functionality in it by customizing .jsp, .jspx files using JDeveloper.
|
| Developed new reports for Oracle Payables as per Business requirement.
|
| Customized PO Account Generator Workflow and Requisition Account Generator Workflow for Generating Project Charge Account.
|
| Prepared categorized iProcurements catalog for different kind of items used in the company.
|
| Provided support to create iStore hierarchy and associate item to iStore hierarchy.
|
Environment: Oracle Applications 11i (11.5.10) (AR, AP, PO, GL, iProcurement, iStore), Oracle 9i, PL/SQL, TOAD, SQL*PLUS, Reports 6i, UNIX, Workflow 2.6.
| Client Name |
From Date - To Date |
| Oracle Apps Technical Consultant | |
It was an upgrade project where the client upgraded from Oracle Applications 11.0.3 to 11i. Responsibilities included customization of components, review of functional and technical design documents and coding.
Responsibilities:
| Customized Reports in OM and inventory.
|
| Upgraded shell scripts, which calls reports, control files and sql files which are in the production.
|
| Worked on forms personalization, which is a new feature in 11.5.10
|
| Developed custom Reports in INV and BOM modules using Reports 6i
|
| Customized workflows in PO according to the requirements.
|
| Customized BOM reports like Bill of Material Listing, Bill of Material Loop Report, Department Report and Item Report.
|
| Developed custom Requisitions and Purchasing Documents Interface to import requisitions information from legacy system. Used SQL* Loader, PL/SQL packages to validate the data before inserting into base tables.
|
| Customized the COGS Account Generator workflow in OM.
|
| Developed some adhoc reports using discoverer according to the client requirement.
|
| Implemented Oracle Workflow for activating Quality Sample Notifications, Testing Notifications, and Sample Disposition Notifications etc.
|
Environment: Oracle applications 11.0.3/11i (AR, BOM, INV, PO, OM), TOAD, Discoverer 10g, forms 6i, Reports 6i, windows 2000, Unix (Solaris 5.9), shell scripting, Workflow.
| Client Name |
From Date - To Date |
| Oracle Applications Techno-Functional Consultant | |
This project involved implementation of Oracle financial modules (Oracle General Ledger, Account Payables, Account receivables and Oracle purchasing).
Responsibilities:
| Assisted in design of various conversions/customizations from legacy system to Oracle Accounts Payable and Oracle Purchasing and General Ledger.
|
| Gathered requirements for various RICE elements from the Business Users and created technical design documents.
|
| Imported data from legacy system to Oracle Payables tables using SQL*Loader and validate them using PL/SQL procedures.
|
| Generated weekly/monthly/yearly Reports using Discoverer 4i for Department wise Payments to vendors.
|
| Developed SQL*Loader Program to migrate the Customer information captured from the text files to staging tables.
|
| Worked on Purchasing Documents Open Interface to import Standard PO, Blanket PO into the PO Module using SQL*Loader and PL/SQL.
|
| Developed an interface to upload the journal data into the Oracle Application’s General Ledger, developed a PL/SQL procedure, which transfers data to interface tables after performing necessary business validations
|
| Performed some administrative work such as, creating users, menus, adding forms and functions to menus, assigning responsibilities etc.
|
| Developed Custom Reports for Billing History by Client, Invoices and Projects.
|
| Worked with workflow builder on order management and account receivables to backup the notifications
|
Environment: Oracle Application 11.5.9, SQL*Loader, TOAD, Windows XP, UNIX. Discoverer 4i. Modules: (GL, AP, AR, PO, OM), Forms 6i and Reports 6i.
| Client Name |
From Date - To Date |
| Oracle Applications Techno-Functional Consultant | |
Worked as a Technical Consultant for new Oracle Applications Implementation at Spectrum Chemicals. Responsibilities included Oracle reports, Discoverer reports, packages, procedures, functions and custom tables
Responsibilities:
| Interacted with the functional team to understand the business and user requirements
|
| Interface Designing and Applications development.
|
| Designed the Product Transaction Listing by Customer report in AR
|
| Designed and developed migration scripts for all activities and GL migration.
|
| Used SQL *Loader control file to import the customer information provided in the form of flat files into staging tables
|
| Developed PL/SQL program to perform validations and to relate customers with addresses, contacts, banks and profiles and move the data from staging table to interface tables
|
| Loaded existing Purchase Orders of the legacy system through SQL* Loader, validated (in AP) whether those PO’s are paid and finally valid entries are recorded in GL. Also, an exception report was created
|
| Developed custom reports for Billing history by client and Invoices by client report using Discoverer 4i.
|
| Designed and customized the following reports using Oracle Reports Builder 6i in OM and Service Contracts:
o Sales Order Report with Contract Details
o Holds Release Report
o Product Transaction Listing by Product
|
Environment: Oracle Applications 11.0.3 (GL, AP, OM, PO, AR), Oracle 9i, UNIX, Reports 6i, PL/SQL, SQL*Loader and Toad
EDUCATION/CERTIFICATIONS/AWARDS
Bachelor of Engineering in Computer Science & Engineering, Bharathi Dasan University, India - 2002
OCP Oracle Functional Certification, PMI Project Management Certification
PLEASE LEAVE YOUR COMMENTS BELOW
|