SUMMARY

• Around 4 years of experience in Analysis, Design, Development, Testing, Implementation and upgrading Oracle Applications ERP (11i, R12) of Software Applications using Oracle Applications Financial and Manufacturing modules
• Development of Technical Objects Packages, Functions, Procedures, Reports and Interfaces related to Modules like Accounts Payables (AP), Accounts Receivables (AR), General Ledger (GL).
• Development of Technical Objects Packages, Functions, Procedures, Reports and Interfaces related to SCM Modules like Order Management (OM), Purchasing (PO), Inventory (INV).
• Knowledge of complete Software Development Lifecycle including requirement analysis, design, development, implementation and testing.
• Very Good Understanding on Setups related to Procure to Pay (P2P) and Order to Cash Management (O2C) Cycles.
• Good Knowledge in RICE (Reports, Interfaces, Conversions and Extensions) components.
• Relevant Experience in Multi - orgs (Business Group, Ledgers (Set of Books), Legal Entity, Operating unit and Inventory Organizations).
• Extensively worked in Oracle back-end programming and Front-end development using tools like TOAD, PL/SQL, SQL*Plus, SQL*Loader, Oracle*Forms10g/6.0, Oracle*Reports 10g/6.0, XML Publisher.
• Development and customization of Reports and Interfaces in Oracle Apps modules.
• Has strong technical noledge in SQL & PL/SQL Programming and developing Reports by using SQL and Oracle Applications 11i/R12 tables.
• Translate business needs into technical deliverable solutions.
• Experienced in working with reporting tools like D2k Reports, XML Publisher Reports.
• Good Knowledge in debugging, testing and deploying the applications designed and developed interactive GUI screens and reports using oracle forms/reports.
• Strong programming experience in creating Procedures, API, Packages, Functions, Triggers and other database objects using SQL, PL/SQL, UTL File, UNIX and Shell scripts etc.
• Used FTP Tools to transfer objects from desktop to server for Testing purpose.
• Experience in interacting with the off-shore development team.

TECHNICAL SKILLS

Oracle Applications: Oracle Applications ERP R12, 11i.

Operating Systems: HP UNIX, Windows 7/XP/2000/NT, MS-DOS

Languages: C, C++,Unix Shell Scripting, PL/SQL

RDBMS: Oracle 10g, 9i.

Tools: Toad, SQL*PLUS, SQL*Loader, WSFTP

Development Tools: Developer 2000, XML Publisher, Oracle Forms 10g/9i/6i, Reports 10g/9i/6i, OA Framework.

Methodology: Oracle Application Implementation (AIM) Methodologies

Oracle Financial: Account Receivables (AR), Accounts Payables (AP), General Ledger (GL), HRMS.

Modules: Oracle-Supply Chain/Distribution Modules Order Management (OM), Inventory (INV), Purchasing (PO).

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

Oracle EBS Techno-Functional Consultant

Responsibilities:

• Designed & developed Database components specific to Services & Product like Tables, Materialized Views, Procedures, Indexes, Grants and PL/SQL Packages.
• Worked on MLS (Multi Language Support) Reports.
• Developed PL/SQL scripts to load order data from external system to OM interface tables (OE HEADERS IFACE ALL and OE LINES IFACE ALL) and OE base tables (OE ORDER HEADERS ALL and OE ORDER LINES ALL).
• Worked for Procure to Pay Process and Order to Cash Processes and module integrations with AR, GL, AP, OM and INV with in EBS System.
• Personalized the standard and custom forms.
• Worked on Procure to Pay (P2P) and Order to Cash (O2C) life cycle implementation and integrating modules.
• Involved in development of inbound interface custom package to validate and import invoices data into Oracle applications AP Payables open interface tables from external system.
• Used SQL * Loader and UTL FILE packages for data interfaces.
• Knowledge on me-Expense setups which need access to Oracle Workflow Builder to customize the Expenses workflow and Project Expense Reports Account Generator.
• Created Request Groups and Value sets for reports.
• Built custom forms using Oracle Forms 10g Builder to fulfill the business requirements of the client.
• Customized the existing forms with descriptive flex fields.
• Registered the Concurrent Programs, Forms, Reports and Request Sets in AOL and System Administration.
• Responsible for Preparing and Reviewing Technical Documents.
• Responsible to test the required reports in multiple instances.

Environment: Oracle EBS R12(12.1.3), Oracle Apps 11.5.10, Oracle Reports 9i,10g,Forms 9i, 10g, PL/SQL Developer, Oracle R.me.C.E, Oracle A.me.M, Oracle SQL, Oracle PL/SQL, TOAD, SQL*Developer, UNIX, WSFTP Tool.

Confidential

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Involved in Requirement gathering and Analysis, Data Mapping and Client interaction. dis involves analyzing MD50 (Functional Spec) and tan 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.
• Customized GL Journal entry form using forms personalization embedding Trigger events with Custom APIs as per client specification.
• Worked on Procure to Pay (P2P) and Order to Cash (O2C) life cycle implementation and integrating modules.
• 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.
• Created interface to load requisitions data from flat file to oracle purchasing using PL/SQL Packages and Procedures.
• 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.
• Experienced in System administrator responsibility, which contains customizing the menus, adding new concurrent requests, registering the custom applications etc.
• Registered customized Oracle reports and XML Publisher reports using System Administrator and Application Developer.
• Worked on various objects which include forms, Responsibilities, Menus, Concurrent programs, value sets.
• Involved in Requirement gathering for AP Invoice, Check Request and Purchasing.
• Used FND LOAD extensively for downloading LDTs for form personalization migration to TEST, UAT and production environments.

Environment: - Oracle Applications 11.5.10, Release 12.1.3 (AP/AR/GL/Order Management, Inventory, Reports 10g/9i/6i, SQL, SQL*Loader, TOAD, XML Publisher, UNIX), WSFTP Tool.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Involved in analyzing the legacy data for conversion into Oracle, Data mapping was done with the inputs from functional users and Business Analysts. Gaps for the same were identified and rules created.
• Conversion of Customer billing, Customers account sites, customer account contacts was also implemented as a part of business requirement.
• Defined Pricing Attributes process to attach pricing attributes to agreements.
• Created Reports for Seeded Order Management reports execution based on requirement.
• Released holds using OE ORDER PUB API and adjusted line adjustments.
• Legacy data was loaded into pre staging tables and tan the PL/SQL programming logic with different procedure and function calls was used to analyze and validate the data and load into the staging tables. Generated errors were handled with proper error logging.
• Developed Pl/SQL Programs for Customer Conversion.
• Developed reports in Oracle inventory for comparison of available and on-hand quantities in various lots.
• Created technical design for item conversion, Used standard Inventory Application Program Interfaces supplied by Oracle.
• Transferred GL Account Balances from legacy system.
• Created various business areas, user views, custom folders and joins for reporting in user edition.

Environment: Oracle Applications 11.5.9 Manufacturing, Order Management, INV, GL, AP, AR,QM, Windows 2000, Forms 6i, Reports 6i, WSFTP Tool.

Confidential

Oracle Applications Developer

Responsibilities:

• Responsible for the design, development and import of invoice information into Oracle Receivables.
• Developed custom PL/SQL conversion program for loading PO Vendors using Oracle Standard Vendor API
• Performed SQL tuning using Explain plan and tuning database with appropriate indexes.
• Maintaining concurrent manager and assigning priorities.
• Creating users & modifying the privileges for users. Creating appropriate roles and assigning it to users.
• Loaded data into oracle tables using SQL*Loader.
• Used Order Import to import data into Order Entry/Shipping for processing.

Environment: Oracle Applications 11.0.3, SQL*Loader, Toad, Shell Scripts, Developer 2000, SQL, PL/SQL.