We provide IT Staff Augmentation Services!

Senior Oracle Applications Techno-functional Consultant Resume

4.00 Rating

SUMMARY:

  • Over 8 years of experience in Oracle Applications E - Business Suite as a Techno- Functional Consultant in design, development, data conversion, implementation and upgrading of Oracle Applications. Experienced in version upgrade from 11i to R12.
  • Extensive Knowledge in Implementing and supporting Financial Modules like Purchasing (PO), Payables (AP),Receivables (AR), General Ledger (GL), EBTAX and process manufacturing modules including Order Management (OM), Inventory (INV) and Cash Management (CM).
  • Hands on experience in implementing RICEW (Oracle Reports, Forms, Interfaces, Conversions, Extensions and Workflow) components.
  • Commendable implementation of Procure to Pay (P2P) and Order to Cash Management (O2C) business process flows.
  • Well versed in Concurrent Programs, Custom Forms development and registration, Reports and Flex Field Customizations for various clients.
  • Extensively worked on Forms personalization and customization using CUSTOM.PLL
  • Developed various BI reports, check printing reports, payment templates and remittance advises using XML Publisher Administrator.
  • Proficient in Multi-Org and Multi-Currency implementation solution
  • Had hands on experience working on various oracle modules on Finance and Supply Chain Management.
  • Experienced in UNIX Shell Scripting and command line utility. Developed scripts for automation of various concurrent processes, mail generation, file handling, encrypting, archiving, etc., and registered them as host concurrent programs.
  • Experience in various development tools like SQL Developer, SQL*Loader, TOAD, WINSCP, PUTTY.
  • Effectively made use of Materialized Views, Query Re-Write and Transportable table spaces, Ref Cursor, External Tables and Collections and Exception handling.
  • Experienced in developing and customizing various workflows and well versed using components like Workflow Builder and Workflow administrator.
  • Expertise on forms personalization and OAF personalization as per the business requirements.
  • Proficient in creating Discoverer Business Areas and folders using Discoverer Administrator component. Created various complex workbooks and shared them to various users and responsibilities using Discoverer plus Component.
  • Experienced in design and development of Interface/Conversion programs to import data from legacy systems and integrate into Oracle Applications using open interfaces and APIs, and worked on Interface/Conversions like GL Interface, Supplier Invoice Interface and Customer Invoice Interface.
  • Expertise in using Oracle 9i, 10g and 11g databases and Proficient in PL/SQL programming using Procedures/Packages, Database Triggers, Cursor variables, Ref. Cursors, PL/SQL Collections, Records, Custom Exceptions, Exception Handling, Conditional Control Statements, Loop Statements and Dynamic SQL.
  • Extensive Knowledge Implementing and supporting various process manufacturing Modules, specifically Procurement, Order Management, Advanced Pricing, Inventory, Cost management and Shipping.
  • Well versed and extensive working knowledge in designing and developing Trading Community Architecture (TCA), for various entities including Suppliers, Customers, Banks and Employees.
  • Experienced in customization by extension and modification of the standard application suite using Application Object Library (AOL).
  • Strong problem solving, Analytical skills & ability to work in a time-constrained and team-oriented environment.

TECHNICAL SKILLS

Platforms: Unix, Linux, Solaris, Windows NT/2000/XP

ERP: Oracle Applications 11i(11.5.9,11.5.10,11.5.10.2), R12(12.0.4,12.0.6,12.1.3,12.2.4)

Data Bases: Oracle 10g, 11g, 9i

Oracle Applications: General Ledger, Payables, Purchasing, Receivables, Inventory, Order Management, Application Object Library, I-Expenses, I-Procurement, iSupplier, SLA, EB-Tax, Shipping, Advanced Pricing, Service Contracts, Cash Management, Fixed Assets and others

Oracle Tools: Forms Oracle Forms 10g/6i

Reports: Oracle Reports 10g/6i, XML Publisher

Discoverer: Discoverer Administrator 4i/10g, Discoverer Desktop and Plus 4i/10g

Work Flow: Work Flow Builder 2.5

Other Tools: FND Load, Data Loader, Putty, Kintana, HP Quality Center

Documentation: Application Implementation Methodology (AIM), MD70, MD50, CV40

Languages: C, C++, Core Java, Unix Shell Scripting, SQL, PL/SQL,XML,HTML

Development Tools: TOAD, SQL Developer, SQL*Plus, Enterprise Manager (Import/Export)

PROFESSIONAL EXPERIENCE:

Confidential, West Des Moines, IA

Senior Oracle Applications Techno-Functional Consultant

Responsibilities:

  • As part of the implementation team involved in requirement gathering sessions, designing and authored Functional Specification documents (MD050) and Technical Specifications (MD070) for various customizations.
  • Worked on various financial modules (AP-Accounts Payables, PO-Purchase order, GL-General Ledger and AR-Accounts Receivables), developing interfaces, designing and developing reports, customizing workflows and forms personalization.
  • Interfaced legacy system GL data using Journal Import. Created PLSQL Procedure that calls Journal Import program from the backend to load data into GL JE BATCHES, GL JE HEADERS and GL JE LINES tables.
  • Developed interface programs for validating and loading Customer Transactions (Invoices) from external systems to Oracle using Auto Invoice Concurrent Program.
  • Worked on the Customization of PO Account Generator workflow depending on the auto accounting rules set by the client for charge, accrual and variance accounts for standard purchase orders in PO and IProcurement.
  • Worked on the Customization of PO Requisition Account Generator Workflow to derive accounts, depending on the auto accounting rules set by the client for charge, accrual and variance accounts for standard purchase orders in PO and iProcurement.
  • Have performed conversion of Credit Card holder’s master data from legacy into Oracle AP for IExpense.
  • Created Alerts in Oracle iExpense module.
  • Worked on Oracle Application Framework (OAF) to develop custom solutions for iExpense and iProcurement module. Development involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
  • Customized PO Approval workflow process to ensure the notification is send to next in hierarchy if the first approver doesn't respond using workflow builder and also to stop sending emails upon update of PO for second time onwards.
  • Worked on iExpense related Oracle Service Request (SR) on incorrect Mileage rate after adjustment and mileage rounding to threshold value bugs.
  • Used the System Administrator and Application Developer responsibilities to register various objects including custom application, menus, forms, responsibilities, profiles, request groups, request sets, lookups, Descriptive Flex-fields and Value sets.
  • Worked extensively on form personalization for controlling access and providing secured privileges in AP, AR and Purchasing Modules.
  • Generated various Payment Templates as per client requirement for ACH and wire transfers using XML Publisher.
  • Generated various custom BI reports that generated XL output using BI/XML Publisher and registered them in Oracle Applications.
  • Extensively used FND LOAD for migrating various AOL objects including Menus, responsibilities, forms personalization, Concurrent programs, Lookups and values etc., from one instance to another.
  • Defined request sets with concurrent programs to run in stages depending on the output generated by each request.
  • Assisted the team in setting up EB-Tax and developed required custom extensions for Vertex integration and required report generation.
  • Generated Unit test plan uploading the scripts into HP Quality Center for XML Reports, Conversions and few Extensions.

Environment: Oracle Applications R12.2.4 (GL, AR, AP, PO, OM, WIP, INV, BOM), Oracle 10g, SQL,PL/SQL, Forms10g, Reports 10g, Workflow Builder 2.6.5, JDeveloper 10g, Discoverer 10g, TOAD and UNIX.

Confidential, Rochester, NY

Senior Oracle Applications EBS Consultant

Responsibilities:

  • Involved in trouble shooting issues and helped development team in bug fixing.
  • Followed a strict change management process involving, user tickets assignment, problem analysis, development and bug fixes, unit testing, User acceptance testing support and deployment.
  • Performed application support in single and multi-Org environment for Oracle Financials (Purchasing (PO), Accounts Payables (AP), iExpense and iProcurement modules).
  • Documented the required trouble shooting issues maintained at all stages.
  • Raising Service Requests (SRs) and working with oracle support for identifying issues, escalating Service Requests and finding resolutions.
  • Designed and customized workflows in PO and OM and debugged errors like duplicate rows in modules schema.
  • Extensively worked on Multi Organization structure, MRC (Multiple Reporting Currencies), MOAC (Multi Org Access Control), TCA (Trading Community Architecture) and RBAC (Role Based Access Control).
  • Imported Legacy Journals data into GL using Journal import interface.
  • Wrote PL/SQL packages for different validations, for processing data in order to create Valid POs and Receipts and for populating the PO interface tables and called the Seeded import programs to populate the base tables.
  • Customized standard reports such as AR Customer Invoice Report, Pack Slip Report, Open Order Report, Purchase Order Listing Report, Payment Register, Supplier Register, etc.,
  • Created various AOL object including and not limited to Concurrent Programs, Executables, Request sets, Custom Menus, Forms, Functions, Responsibilities, Value sets, Lookups, Flex fields, Request Groups, etc.,
  • Created UNIX shell scripts to automate interface programs on daily basis. Designed and developed multiple file handling system in UNIX.
  • Day-to-Day interaction with Functional Users on design requirement for data mapping from external systems. Documented Application Technical design for each component developed as per oracle AIM methodology
  • Resolved Prod warranty issues by providing Maintenance support on different RICE components
  • Involved in development and customization of Forms in AP, AR and GL modules as per the user requirements using Forms 10g
  • Worked on developing RMA which updates the return orders in the OM Module
  • Experience in Building data conversion/migration strategy, mapping legacy system fields to Oracle Applications data fields
  • Worked on developing a custom interface for Pick Release, to pick release the orders
  • Developed custom Purchase order and Account Payables Invoice Report to display the PO and corresponding Invoice details.
  • Developed various integrations into oracle P2P for invoice interface and requisition import.
  • Worked on building a new custom API to check the on-hand availability for a given sub-inventory and warehouse.
  • Worked on BI Publisher (XML Publisher) for Various Purchasing reports. Generated new reports as well as converted existing oracle reports to XML, by creating RTF templates using Template Builder.
  • Developed interface program for conversion of sales orders using the Order Import Open Interface program.
  • Imported Items from legacy system intoOracle Inventoryusing theStandard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.
  • Managed Oracle Apps Testing and test planning. Regulated risk approach for testing. Established and executed test cases.
  • Implemented and managed an EDI solution, interfacing Trading Partners with legacy systems and Oracle Applications, and managing data to support Order Entry, Purchasing, Accounts Payable, Shipping, and Accounts Receivables.
  • Handled automated and manual testing requirements and drafted results.
  • Customized the Order Header workflow to place custom holds as per client requirement before the order is booked.
  • Worked on oracle alerts and developed alerts to send mail notification to employees for settlement of advances in Oracle Payables.

Environment: Apps R12.1.3 (GL, AP, AR, OM, INV, PO, Advanced Pricing, Payments), Oracle Database 10g, Reports 10g, Forms 10g, EDI, Windows XP Professional, PL/SQL, TOAD, HP Quality Center, XML Publisher, Workflow Builder.

Confidential, Maumee, OH

Senior Oracle Techno-Functional Consultant

Responsibilities:

  • Involved in Requirement gathering and Analysis, Data Mapping and Client interaction. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
  • Provide system support for the Oracle E-Business Suite; primarily the financial modules and all peripheral software in support of the organizations monthly financial business processes.
  • Used FND LOAD extensively for downloading LDTs for form personalization migration to TEST, UAT and production environments.
  • Worked with Account Receivables team to develop Auto Invoice Interface to upload invoices coming from legacy systems. Developed Several PL/SQL and SQL Scripts to perform validations on the legacy data.
  • Customized GL Journal entry form using forms personalization embedding Trigger events with Custom APIs as per client specification. For a manual Journal Entry added validations using API and enabled various fields of Line DFF as custom display enabled mandatory fields for user usage.
  • By using SQL loader imported data into temporary tables and validated this data by creating custom PL/SQL procedures. Worked extensively on PO and AP conversions.
  • Created interface to load requisitions data from flat file to oracle purchasing using PL/SQL Packages and Procedures.
  • Worked on data fixes for invoice holds in Accounts Payables (AP).
  • Worked on iExpense related Oracle Service Request (SR) on incorrect Mileage rate after adjustment and mileage rounding to threshold value bugs.
  • Worked on iExpense production fixes such as duplicate lines for AMEX transactions, incorrect mileage adjustment for second expense report for the same user in the same period.
  • Also developed Validation Programs for Purchase orders and Conversion Programs for Purchase Orders, Receipts, and Invoices for both Received & Invoiced as well as for only Received Purchase Orders.
  • Worked on various conversions for different operating units and their individual business rules.
  • Several PL/SQL and SQL Scripts were developed to perform back end jobs. Developed Data Conversions and Interface Programs. Designed and Developed Stored procedures, Functions and Triggers in PL/SQL to implement complex business rules.
  • Developed PL/SQL procedures to load Price list Data (Qualifiers, Modifiers and Price Lists).
  • Extensively worked in testing conversion programs and involved in Unit Testing and Performance Testing of all conversion programs.
  • As per client requirements, customized iProcurement, iSupplier module.
  • Worked on various forms and reports customizations and extensively on complicated Discoverer reports.
  • Experienced in System administrator responsibility, which contains customizing the menus, adding new concurrent requests, registering the custom applications etc.
  • Worked on various objects which include forms, form personalization, Responsibilities, Menus, Concurrent programs, lookups, value sets, and XML publisher templates.
  • Involved in Requirement gathering for AP Invoice, Check Request and Purchasing.

Environment: Oracle Application 11.5.10.2/12.1.3 GL, PO, AP, AR, PA, INV, IExpenses, Iprocurement, Oracle 9i/10g, Discoverer 10g, PL/SQL, SQL *PLUS, SQL*Loader, Reports 6i/10g, Forms 6i/10g, XML Publisher 5.6.3, Linux x86.

Confidential, Durham, NC

Senior Oracle Applications Consultant

Responsibilities:

  • Working on business processes of the company. Prepared Gap analysis and AIM documents, mapping the business requirement to Oracle Applications.
  • Designed, documented and implemented Interface programs to import ITEMS from a legacy system into Oracle Inventory.
  • Designed, documented and tested Item Master sync out-bound interface to maintain synchronization between item and its attributes in oracle and the third party WCS system.
  • Worked on Designing and testing conversion program to load on hand quantities, lots and locators into inventory using oracle on-hand and Lots interface.
  • Defined Currencies, Calendars and Chart of Accounts, managed journals and account inquiries and performed document sequencing setups for accounts and Journals.
  • Worked on resolving the technical issues related to OTC and P2P cycle.
  • Imported Sales order data into Oracle Application base tables. Wrote PL/SQL procedure to validate data and load into interface tables and using order import inserted orders into base tables.
  • Designed and developed various custom Discoverer reports on discoverer desktop and granted reports as per responsibility to users.
  • Involved in Importing BOM data from Legacy system to Oracle through Open BOM Interface.
  • Customized forms appearance and incorporated new functionalities by using forms personalization.
  • Designed custom extension of PO seeded workflow as per the business rules.
  • Designed and developed multiple FSG reports on Budget and Actual balances, crossing over fiscal periods as per Business requirement.
  • Acted as primary point of contact for business, during UAT, regression and Performance testing during the implementation of various inbound and outbound interfaces.

Environment: Oracle Applications (11.5.9/11.5.10.2 ) Manufacturing and financials (INV, BOM, OM, GL, AR, AP, PO, AOL), TOAD, Discoverer 4i, Workflow, HP Quality Center.

Confidential

Oracle Applications EBS Consultant

Responsibilities:

  • Worked on the upgrade process of Oracle 11i (11.5.8) to R12 (12.0.4)
  • Worked on loading and importing credit card transactions and exporting the expense report into Oracle Payables in Oracle Financials.
  • Worked on archive and purge process that will save the AR invoices in a file until a given date and then deletes the records from tables.
  • Extensively tested oracle upgrade instance, identifying issues, supporting business functionality & resolving issues working closely with business users and Oracle Support.
  • Implemented PL/SQL scripts in accordance with the necessary business rules and requirements.
  • In the GL module, designed and developed packages for Journal Import Interface to import journals information into the system. Developed PL/SQL package to validate and insert the validated data into interface tables.
  • Extensively registered various AOL objects such as Value Sets, Value Set values, Custom Responsibilities, Lookup Values, Request Sets, and Request Set Links.
  • Developed various Business Areas using Oracle Discoverer Administrator mainly on financials GL, AP, AR and PO. Developed various reports with complex business conditions by creating various workbooks in Discoverer plus and sharing them to users.
  • Created an interface to add bank account of an employee supplier in Payables from their payroll data.
  • Created a custom interface to load Procurement card transaction to Oracle payables.
  • Analyzed the requirements, performing risk analysis for mapping the business processes. Understanding the gaps, recommended the necessary customizations.
  • Configured payment system to record wire payments in payables and to avoid direct journal entry in General Ledger.
  • Customized the remittance advice as per the client's requirements.
  • Assisted in the month end and year end close process of financial modules.
  • Resolved number of production issues in GL, AP, AR, PO and FA.
  • During the Support phase, Applied various Recommended patch Collections (RPCs), for AP
  • Suppliers, Workflows and Cash management. Analyzed and applied various GDFs in payables and applied RCA patches to fix the issues permanently.
  • Created FSG (Financial Statement generator) Reports, defined row sets, column sets and reports.
  • Performed forms personalization to ensure the security of the system and data access to only specific orgs for which user belongs to.
  • Worked on Forms Personalization and customization for incorporating business logic.

Environment: Oracle Apps (11.5.8/12.0.4 ) (AP, PO, GL, FA, AR, iExpense, System Administrator) Oracle10g, SQL, PL/SQL, SQL*Plus, SQL*Loader, Data Loader, Reports 10g, Forms 10g, BI Publisher, Discoverer 10g, Workflow, Windows 7, UNIX.

Confidential

Oracle Applications Consultant

Responsibilities:

  • Worked as an Oracle Application developer at Natco Pharma Limited.
  • Worked on AR, AP, GL, PO to maintain consistency between legacy system and Oracle Apps.
  • Developed interface to load Receivables invoices from external system, contract base to Oracle using Auto Invoice Concurrent Programs.
  • The interface components include 'Journal Import', 'Payables Invoice Import', 'AR Invoice Import', 'PO Outbound interface for EDI Vendors', 'Outbound interface for EFL Customers' etc.
  • Maintained the GL INTERFACE table data from different Journal Sources on a daily basis for the Journal Import.
  • Developed a custom Interface to update the customer account numbers that are no longer active, Create a relationship with the newly added customer account numbers.
  • Workflow Notification for Sales Order will be triggered at the launch of Sales Order "Book" event and an email notification is sent to the concerned.
  • Developed interface to load Receivables invoices from external system, contract base to Oracle using Auto Invoice Concurrent Programs.
  • 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.
  • Delete the existing outdated customer account number relationship and Update the shipping details of the existing customer account numbers.
  • Developed the below Custom reports using Reports 10g as per the client requirements in OM
  • Involved in design of AIM (Application Implementation Methodology) documents (MD-70) for all conversion and reports.

Environment: Oracle EBS 11.5.10.2, Procure-2-Pay, Oracle Database 10g, Oracle RICEW, Oracle A.I.M, Oracle SQL, Oracle PL/SQL, AP, GL, PO, AR, OM, INV, TCA, TOAD, Discoverer, XML Publisher, SQL*Developer, Forms Builder 6i, UNIX, Shell Scripting, WINDOWS XP.

Confidential

Oracle Applications Consultant

Responsibilities:

  • Involved in developing conversion programs, interfaces, Custom OAF pages, building custom reports and writing UNIX shell scripts based on the functional specifications provided.
  • Developed various RICEW components in modules like AP, AR, GL and PO.
  • Worked on application system administration activities such as user setup, defining responsibilities, value sets, flex fields, data groups and request groups, registering applications, menus, forms, reports, concurrent programs, providing support to apps users for any technical and functional issues.
  • Involved in Development and Implementation of AP, AR, PO and INV and also involved in developing interfaces for AP, AR and INV.
  • Created new concurrent request sets and scheduled the Order Import interface program to run periodically.
  • Developed custom reports using Report 6i and also customized seeded reports.
  • Developed Operational Dashboards for business to view current health of the organizations.
  • Developed various custom reports Pick Slip Report, Bill Of Lading (BOL) using Report builder.
  • Involved in Preparing Design Documents for all Customizations with detailed solutions, development and implementation of all interfaces and conversions.
  • Customizations include adding menus, Hiding fields and changing prompts.
  • Wrote SQL scripts to create temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables.
  • Involved in some activities for Oracle System Administration module such as, creating new responsibilities and defining the required system profile options. Extensively utilized the Application Object Library to register SQL*Loader programs, Shell Scripts, PL/SQL procedures, Forms and reports.
  • Designed and developed Custom Trial Balance reports to help Business cross validate converted Journals and Balances before and after data conversion.
  • Provided post go-live support and involved in user sessions.
  • Experience in Building data conversion/migration strategy, mapping legacy system fields to Oracle Applications data fields.
  • Supported on Month end closing. Assisted users in completing the transactions.
  • Documented all the work done for future . Also created various manuals for functionaltesters and users.

Environment: Oracle Applications R11.5.10 (GL, AR, AP, PO, OM, WIP, INV, BOM), Oracle 10g, SQL,PL/SQL, Forms Builder 6i, Reports Builder 6i, Discoverer 4i, TOAD and UNIX.

We'd love your feedback!