SUMMARY:

• Around seven years of extensive experience in Analysis, Design, Development, Testing, Implementation and upgrading Oracle Applications 11i, R12 of Software Applications using Oracle Applications Financial and Manufacturing modules
• Extensive experience in Oracle E - business suite Accounts Payables (AP), Accounts Receivables (AR), General Ledger (GL), Purchasing, Cash Management (CM), Shipping, Inventory, Work-in-process (WIP), Bill of materials (BOM), Application Objects Library (AOL), System Administration, Functional Administrator modules.
• Technical knowledge of Discrete Manufacturing, Process Manufacturing and Supply Planning Modules, Production Planning, Formula Mgmt, OPM Inventory.
• Demonstrated delivery in Procure to Pay and Order to Cash business flows.
• Extensive experience in RICE (Reports, Interfaces, Conversions and Extensions) components.
• Extensively worked in Oracle back-end programming and Front-end development using tools like TOAD, PL/SQL*Plus, SQL*Loader, Oracle*Forms 10g/6.0, Oracle*Reports 10g/6.0, XML Publisher, Discoverer, Workflow
• Extensive experience in Implementations, version upgrades, Personalization, data conversions, customization of Reports and Forms in Oracle Applications.
• Hands on experience on Oracle EBS 11i/R12 P2P (iProcurement, AP, PO, iSupplier) modules
• Experienced in debugging, testing and deploying the applications designed and developed interactive GUI screens and reports using oracle forms/reports.
• Expert in troubleshooting and fixing the bugs, creation of SR with Oracle Support, obtaining patches from oracle support and applying patches with coordination of Apps DBA.
• Experienced in preparing Technical specifications (MD070), Functional Specification (MD050), Conversion Mapping Documents (CV050), User Documents, test procedures document preparation and CRP.
• 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.
• Also experienced in fine-tuning code for better performance using EXPLAIN PLAN and SQL TRACE.
• Knowledge of complete Software Development Lifecycle including requirement analysis, design, development, implementation and testing.
• Experience in interacting with the off-shore development team.
• Strong analytical, Inter-personal and communication skills. Good working experience with oracle applications end users.

TECHNICAL SKILLS:

Oracle Applications: Oracle Applications R12, 11i, 11.0.3, HP UNIX, Windows 7/XP/2000/NT, MS-DOS

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

RDBMS: Oracle 10g, 9i, 7.x/8.x

Tools: Toad, SQL*PLUS, SQL*Loader

Development Tools: Developer 2000, XML Publisher, Oracle Forms 10g/9i/6i, Reports 10g/9i/6i jDeveloper 9i/10g, OA Framework, Oracle Work Flow, Reports from OBIEE, Oracle Workflow Builder 2.5

Oracle Financial Modules: Account Receivables, Accounts Payables, Purchasing, General Ledger

Oracle Manufacturing Modules: Order Management/Order Entry, Inventory, BOM, WIP

PROFESSIONAL WORK EXPERIENCE:

Confidential, Cincinnati, Ohio

Oracle Applications Senior Consultant

Environment: Oracle Applications 12.1.0, RDBMS: 11.2.0.3.0 (Oracle Financials: Accounts Payables(AP), Account Receivables (AR), General Ledger (GL), iSupplier,iProcurement, Application Object Library(AOL) ), SQL, SQL*Loader, TOAD, XML Publisher, Unix, Shell Scripting, Code Check-In’s (SVN), Oracle Bi Publisher,XML Publisher.

Responsibilities:

• Developed various custom XML, PLSQL, Unix programs reports as per the requirements.
• Worked for STAT ledger process custom object as per the client’s requirement
• Worked for Custom XML Transfer Pricing Report for Russia Ledger Purpose which has multi sheet Excel output.
• Designed complex XML Publisher reports (with XLS and RTF) like FA Asset Assignments Report, Custom AR Transaction Report Etc.
• Worked on Custom FORMS .fmb files for various enhancements.
• Worked and Developed various reports in General Ledger, Account Receivables, Fixed Assets.
• Designed complex PLSQL, Unix Shell Scripts, Fusion BIP coding.
• Worked in Oracle Fusion BI Analytics and Reports

Confidential, San Jose, California

Oracle Applications Techno-Functional Consultant

Environment: Oracle Applications 11.5.10.2, RDBMS: 11.2.0.3.0 (Oracle Financials: Accounts Payables(AP), Account Receivables (AR), General Ledger (GL), Cash Management, iSupplier, Application Object Library(AOL) ) Forms 10g/9i/6i, Reports 10g/9i/6i, SQL, SQL*Loader, TOAD, XML Publisher, Unix, Shell Scripting, Code Check-In’s (SVN), Migration Tools Kintana.

Responsibilities:

• Prepared MD070’s as per the client’s requirements for the above activities
• Prepared test cases and executed unit testing and coordinated with end-user on Custom Interfaces Developed.
• Defined Request Sets for the Custom Interfaces and assigning them Incompatibilities according to the requirement
• GL Sets-ups like Auto Post Criteria and Document Sequence assignments for Journal Import interface.
• Involved in Customizations of Auto Lock box related Setup based with Bank of America on client requirement.
• Worked and Co-ordinated with offshore team on daily- basis for the progress of the project.
• Involved in the Custom AP Positive Pay Interface with offshore team.
• Participated in the definition of Oracle lookups for SWIFT Auto-client Server
• Defined the custom distribution alerts in General Ledger, Receivables, Cash Management and other applications to send emails via Concurrent program Unix files to IT Support Team and business users.
• Developed SQL Reports for LOV’s for Brocade Business Requirement.
• Responsible for the Migration of code for other instances using version control software SVN and Kintana

Confidential, San Jose

Oracle Applications Techno-Functional Consultant

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

Responsibilities:

• Designed, Developed and Documented Supplier Conversion from Legacy system to destination system i.e., R12.
• Designed, Developed and Documented Employee as Supplier conversion from legacy system (11i and other systems) to R12.
• Designed, Developed and Documented Supplier Bank Conversion from Legacy Systems (11i and other systems) to R12.
• Designed, Developed and Documented a conversion program to convert Fixed Assets from legacy system to oracle Fixed Assets (FA).
• Designed, Developed and Documented Purchase Order inbound interface to upload the Purchase Orders details from the legacy to Oracle Applications base tables
• Extensively worked on conversions into Oracle AR, GL Balances import, PO by mapping the data, writing oracle stored procedures, packages and oracle seeded packages. Has developed interfaces for transferring data from legacy to Oracle Apps.
• Worked on GL interfaces for balances Conversion, SQL, PL/SQL, stored procedures and packages.
• Worked on invoice conversions by designing, developing style sheets and generating XML files using Oracle PL/SQL, Oracle AR, and BI Publisher.
• Developed SQL*Loader control programs and PL/SQL validation procedures to load legacy GL Code Combinations into Oracle General Ledger GL.
• Developed PL/SQL scripts to load data from external system to Fixed Assets FA MASS ADDITIONS interface tables and developed asset interface
• Designed and Documented FA Account Generator Workflow Extension based on the client’s requirement.
• Designed and Documented AP Invoice Workflow changes based upon client's requirement.
• Designed and Documented COGS Account Workflow changes based upon client's requirement.
• Developed and modified custom report involving trigger to initiate workflow for Invoice holding reason.
• 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.
• Developed New Reports and Customizations in XML Based reports using XML Publisher.

Confidential, Kansas City, Kansas

Oracle Applications Techno-Functional Consultant

Environment: - Oracle Applications 11.5.9 11.5.10.2 (AP/AR/GL/Order Management /Fixed Assets, Inventory/iSupplier/iProcurement, Workflow, Web Application Modules) Forms 10g/9i/6i, Reports 10g/9i/6i, SQL, SQL*Loader, TOAD, XML Publisher, STAT, UNIX

Responsibilities:

• Written an API for Converting the Orders Status in Order Management from third-party application to Oracle EBS
• Worked on Material Transaction Conversion and Interface programs to merge the lot numbers with Item in Oracle Inventory (INV)
• Designed and developed purchase order import interface program to import standard purchase order.
• Worked on Requisitions Import Interface program to upload purchase requisitions data to Oracle Purchasing.
• Moving the Objects from Applications Object Library to CVR’s Custom Application.
• Developed a new conversion script for Item on-hand quantities to import on-hand from OCE Legacy System.
• Designed, developed and documented an inbound interface for AP Vendors from Java based application.
• Developed a new inbound interface for proof of deliveries for supplies orders.
• Migrating the objects from one Instance to another Using Quest STAT
• Designed Technical documents AIM (MD70 and CV60) from the functional requirement specifications
• Developed a custom PLSQL program for Bank Reconciliation interface to Oracle Cash management Interface.
• Process for Supplier submitting Invoices matched to PO, invoices without PO and Online Payment updates
• Developed the Shell Scripts as per the clients requirement to import vendors, invoices from legacy systems using SQL Loader files and SQL scripts
• Responsible for collecting business requirements for new conversion and Interfaces converted them into Functional and technical design documents.
• Resolved issues in custom packages.
• Developed a custom report as per the business users requirement for getting the data of vendors from Account Payables
• Modified AP Vendors form to add an attribute from the legacy system to the existing form
• Developed a On - hand Daily Inbound Bump Report
• Designed and developed Back Order Process to identify, release and cancel Sales Order by using Oracle Forms
• Developed Extract Program to provide flat file Oracle Order details to third party system (WCS)

Confidential

Programmer/Developer

Environment: Oracle Applications 11i- PA, AR, iReceivables, AP, Oracle 9i, Forms 6i, Reports 6i, SQL*Loader, XML Publisher, BPEL, PL/SQL developer, TOAD

Responsibilities:

• Performed Development and provided support for the Oracle and SAP E-Business Suite Applications.
• Interacted with the business users and collected the requirements. Analyzed business requirements, designed and recommended solutions.
• Procure to Pay, Order to Cash, Logistics and Warehouse Engineer with Business Objects Developer with SAP and Oracle EBS Applications User
• Gained expertise on the following EBS Application modules: Accounts Receivables (AR), Accounts Payables (AP), General Ledger (GL), Project Accounting (PA), Purchasing (PO), Inventory (INV), Order Management (OM) etc.
• Responsible for installing, configuring, administering, tuning, and troubleshooting Database products and features for various application suite in Unix and Windows environments.
• Reviewed the process of Material Management with Procure to pay of Materials from Ordering with vendors, follow-up with suppliers to Procuring and placing them in Organization with proper Warehouse Management Tools in Oracle and SAP
• Worked with Oracle development tools such as Workflow, Reports, Forms& J-Developer.
• Developed custom reports to reflect the Daily Work orders and Future Work Orders.
• Developed a Programmable Language Script reports to list the mileages, work orders, preventative maintenances, warranty claims for all the items.
• Proficient with development of Oracle SQL scripts, SQL Plus, PL/SQL packages, procedure & functions, Forms 10g, and Reports10g to extend Oracle EBS functionality based on user requirements.
• Work with cross functional teams to help identify and deliver improvements to streamline processes and gain efficiencies.
• Hands on experience create diagrams such as Process Flow Diagrams, Use Case diagrams and Activity Diagrams.
• Assist business users to understand business rules/process and then create detailed, specific, and comprehensive documentation.