SUMMARY

• Around 8+ years of IT experience in developing cost - effective solutions as Technical Consultant using Oracle Applications.
• Having experience in Analysis, Design, Development, Data Conversion, Upgrades, Customization, Interfacing & Implementation of business applications using Oracle Applications R12, 11i
• Extensive experience in Oracle Application Modules which include General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), Purchasing (PO), Order Management (OM), Inventory (INV), Application Object Library (AOL), System Administrator.
• Experience in other modules like Fixed Assets (FA), Project Accounting (PA).
• Exposure in modules like Bills of Material (BOM), Work in Progress (WIP), Oracle Shipping (WSH), Oracle Alerts (ALR).
• Extensive experience in Procure to Pay (P2P) and Order to Cash (O2C) life cycles with related Open Interfaces and API’s.
• Worked as Techno Functional Consultant in AP Setups for Payments Using Payment Administrator.
• Exposure in Trading Community Architecture (TCA), Sub-Ledger Accounting (SLA).
• Experienced in RICE (Reports, Interfaces, Conversions and Extensions) components.
• Experience with Workflow execution, workflow modification, PL/SQL event support, debugging and testing.
• Extensive experience in Personalization of Oracle Forms 6i/10g.
• Extensive experience in Customizing and Developing Oracle Reports 6i/10g.
• Extensive experience in developing Interface and Conversion Programs to import data from various Legacy source files into Oracle Applications using PL/SQL, SQL*Loader, UTL File, Unix Shell script’s, and API’s.
• Expertise in XML Publisher Reports, Creating Data Templates and complex XML Publisher Templates.
• Experience in OA Framework and customization and Personalization of JSP pages.
• Extensive experience in using SQL, PL/SQL, SQL*Loader, UNIX, and Shell Scripts.
• Extensive experience with AOL to develop Flex fields, Lookups, Validation sets, Concurrent programs, Profile Values, Request Sets registration, and Responsibilities.
• Proficient in writing Stored Procedures, Packages, Functions, Triggers using PL/SQL.
• Well versed with client server environment and tools like Developer/2000, SQL* Loader, SQL Developer, JDeveloper, and TOAD.
• Involved in performance tuning in oracle using Explain plan, Auto Trace, and Tkprof.
• Involved in QA and UAT testing and fixing the issues.
• Extensive experience identifying product gaps coordinated with development team by creating Technical Assistance Request (TAR)/SR and obtained one-off fixes.
• Well versed with AIM (Application Implementation Methodology) Documents.
• Participated in written Functional Document’s (MD .050), Technical Document’s (MD.070) and Migration Documents (MD.120) according to the business requirements.
• Ability to interact effectively with clients, Understanding their requirements and providing optimum solution and support.
• Excellent Analytical, interpersonal and communication skills. And ability to learn quickly to new technologies and methods in a short period of time.

TECHNICAL SKILLS

ERP: Oracle E-Business Suite R12, 11i

ERP Modules: GL (General Ledger), AP (Account Payables), AR (Account Receivables), PO (Purchasing), OM (Order Management), INV (Inventory), Project Accounting (PA), AOL (Application Object Library), P2P, O2C, and System Administration.

RDBMS: Oracle 8i/9i/10g, SQL Server 7/2000.

Development Tools: XML/ Reports & Forms 6i/10g

Database Tools: SQL*PLUS, SQL*Loader, TOAD, SQL*Navigator, SQL Developer.

Document Methodologies: MD.050, MD.070, MD.120, TE.020, CV.040.

Languages: SQL, PL/SQL, C, Java, HTML, UNIX Scripting, XML

Reporting Tools: Reports 6i/10g, XML/BI Publisher.

Operating Systems: Windows XP/NT/ 2000/98/95/2007, UNIX.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Design and development of the Project Accounting customization form from the standard Project Accounting form.
• Development of form customizations using forms builder for Oracle Project Accounting applications, Purchase Order Form,
• Worked on Auto Invoice Interface to import Customer Invoices, Credit & Debit Memos in Receivables. Materialized views, Collections for Forms.
• Development of PL/SQL scripts to load data from the database to customized form.
• Developing Oracle Alerts to send the notifications to the users based on the business requirements.
• Develop and debug SQL, PL/SQL scripts including Packages, Procedures, and Functions & Triggers in Oracle 10g database to perform various form tasks.
• Debugging, testing and deploying the Oracle Project Accounting applications using oracle forms.
• Reviewing unit test cases, unit test results and validating as per the business requirements.
• Preparing Technical specifications (MD070) from the Functional Specifications (MD050).
• Writing the functional design and technical design for all customizations (forms, concurrent programs), so that business users and technical developers had a common understanding of the solution.
• Developed Billing events and revenue events creation program by using APIs in Oracle PA module
• Developed form customizations for Purchase Order Form, Import Journals form and Sales Order Form using forms builder for Oracle Financial applications.
• Involved in performance tuning of various packages and reports. Also, have done code fixes to improve the performance using Explain Plan, TKPROF & Trace.
• Using the standard Oracle OM (Order Management) API OE ORDER PUB created a custom PL/SQL package. This custom DB object used to create a new sales order, update/cancel an existing sales order.
• Worked on custom program to perform Address Validation of the Address to be Imported to TCA tables against the Vertex provided seeded data.
• Developed Custom Program to interface Customer locations provided by AT&T to TCA Base Tables. This includes loading of Addresses, Sites, Business purpose (Bill-to, Ship-to) etc from the AT&T file which provided on a weekly basis
• Customized standard AP Invoice aging report, Check printing report in Account Payables.
• Developed AP Invoice Interface to upload items into the Oracle Payables.
• Designed and developed custom forms and reports in AR, AP as per business requirements.
• Provided analysis, design, installation, and rollout of Accounts Payable.
• Developed PL/SQL Procedures for Customer interface in Accounts Receivables (AR).
• Worked on the Credit Memo issues in the Project Billing (PB) Module. For this developed a script to store the TAID provided by Vertex for the original project Invoice in a Custom Descriptive Flex Field (DFF) in Receivables (AR) lines table.
• Developed an UNIX Shell Script to send the Output & Log file of the custom interface as an attachment notification to the end users.
• Developed a custom program to perform data cleansing on the Description Column of PA TASKS table in Project Accounting (PA). This program is used to cleanse control characters which may cause problems for certain EDI transactions.
• Worked on Vertex, eB-Tax base tables to retrieve the Vertex O Series TAID for a corresponding Original Project Invoice.
• Developed control Files to load the data from legacy System to Oracle Staging Tables using SQL Loader, from which data is transferred to the base tables using the conversion programs.
• Developed Oracle Alerts to send the notifications to the users based on the business requirements.

Environment: Application Modules:- GL, AR, AP, PO, FA, OM, PA. & Languages:- SQL, PL/SQL, Forms, Oracle Reports 10g, BI/XML Publisher, UNIX, TOAD,, SQL*Developer.

Confidential, Boston, MA

Sr. Oracle Apps Technical Consultant

Responsibilities:

• Designed customizations, interface/conversion mapping, pre production testing and related documentation.
• Developed and customized Financial Modules (GL, AR, AP, PO), Interacted with End users to gather requirements and Draft specifications for development Phase.
• Invoked standard API’s within custom packages for creating and updating Customer Sites and Contacts.
• Strong Oracle RICE development experience in all AP, AR, GL, PO and OM Modules.
• Responsible for converting the Purchase Orders (PO) in P2P cycle using Import standard Purchase Orders.
• Wrote Technical Specification (MD070), Conversion Mapping (CV040) documents for converting Vendors, Vendor Sites and Vendor Contacts.
• 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).
• Creating staging tables required for loading the legacy data and loading the staging tables with the legacy data using SQL Loader.
• Downloading & Upload commands using FNDLOAD for migration from instance to another instance.
• Developed Concurrent Programs, Value Sets & Request Sets based on the business requirements.
• Created a Report for End Users to get the vendor and its site information.
• Designed and developed complex Discoverer reports by communicating and interpreting end-user business requirements.
• Customization and Personalization of Oracle Forms as per Client Business requirements.
• Registered customized Oracle reports and XML Publisher reports using System Administrator and Application Developer.
• Created custom templates with Data Definitions for XML Publisher and Developed reports using reports 9i and registered as XML reports in applications.

Environment: Oracle Applications 11. i)/R12 (12.1.3) - PA, AP, AR, GL, CM, OM, PO, TCA, Workflow Builder 2.6, Oracle 9i, Oracle Forms& Reports 6i, XML publisher, SQL*Loader, PL/SQL Developer, TOAD, OAF.

Confidential, Hartford, CT

Sr. Oracle Apps Technical Consultant

Responsibilities:

• Designed and developed GL, AR, AP, OM, PA and WIP related Interface programs to synchronize the data between existing Legacy system and Oracle Database
• Developed GL Account Balances Conversion Programs
• Developed Item conversion program for assigning Items to Item category set and Categories
• Developed PO interface to import PO orders from legacy systems. Used API’s to update quantities and to cancel Orders
• Developed PL/SQL scripts to load order data from external system to OM interface tables
• Used SQL * Loader and UTL FILE packages for data conversion and interfaces
• Converted pricing information from legacy systems into Oracle applications using SQL*Loader and pricing API
• Designed and developed Data Audit System scripts to capture the data from "before" system (10.7) and after system (11i) based on the business requirements
• Developed database triggers on few tables to keep track of changes
• Registered the automation scripts as concurrent programs and created a scheduling process that invokes the script periodically
• Coordinating with the offshore team with daily status calls
• Proficient with the System administrator responsibility, which included customizing the menus, adding new concurrent requests, request sets, registering the custom applications etc
• Developed Pick slip template using XML Publisher
• Developed XML template for invoice report using XML Publisher
• Created EUL and BA’s using Discoverer Admin 9i
• Handled security and privilege issues using Discoverer Admin 9i
• Handled performance issues for several reports, which involved code optimizations using auto summary management (ASM) using Discoverer Admin 9i
• Created and scheduled workbooks as per the user requirement using Discoverer
• Developed custom AR Adjustments Aging Report with fixed aging buckets. Designed the technical and user documents
• Customized Inactive Item Report and Cancelled Sales Order Report
• Developed reports to compare the captured data and report the discrepancies in the migrated data
• Built custom reports using Oracle Report builder 6i and integrated them with the application (based on the descriptive flex fields) to solve the client’s reporting needs
• Built custom forms using Oracle Forms 6i Builder to fulfill the business requirements of the client
• Worked with end users to facilitate issue resolution, troubleshooting functional application issues
• Customized existing forms to add search criteria on descriptive flex fields
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context. Modified CUSTOM.PLL to activate zoom
• Developed Application Extension CV70s using AIM methodology by reviewing CV40s

Environment: Oracle Apps R12(12.1.2), OM, INV, BOM, WIP, PO, AP, AR, GL, AOL, ORACLE 8i, 9i, PL/SQL, Forms 6i, XML Publisher, Reports 6i, Discoverer 9i, Toad 2.5

Confidential, Salt Lake City, Utah

Oracle Apps Technical Consultant.

Responsibilities:

• Imported Sales Order data from legacy system into Oracle Order Management by using the standard OE ORDER PUB API.
• Developed the Purchase order and PO Receipt interface programs to load the Purchase orders and receipts from the legacy system.
• Customized FSG reports in Oracle General Ledger.
• Worked on performance tuning to increase the performance of reports and stored procedures.
• Developed Custom Overdue Sales Order report in XML Publisher report.
• Interacted with end users and functional architects for mapping the legacy data to the Oracle tables.
• Developed Replenishment Interface in Oracle Inventory (INV) based on data sent from warehouse in flat file. Used Loader program to load the data into the staging table, and then performed PL/SQL validations to load the data into the interface tables.
• Wrote the Program to insert data into Receiving Interface tables based on the different Transactions and Receiving Transaction Processor process data from the interface tables and the quality updates are done.
• Defined payment terms, Locations, Invoice Approvals and setting up Bank Account information in Accounts Payables.
• Created Sets of Books in GL by defining Key Flex Fields, segments, value sets, accounting calendars, currencies.
• Modified existing reports by creating additional joins and designed and developed many reports by using lexical parameters in before, after parameters and before report triggers.
• Customized several oracle standard forms using CUSTOM .PLL.
• Develop Custom Alerts to send mails to related users to notify process of PO and error codes.
• Involved in customization of various reports as per the user requirements, which includes customized mailing label report, sales order acknowledgement report, Order Status Summary report, printed purchase order and packing slip report, Vendor Performance report.
• Developed a customized weekly inventory report that gives details of pending orders and available quantity of the items in inventory.
• Designed and developed custom reports in AR, AP as per business requirements.
• Part of performance tuning team, tuned PL/SQL code and SQL queries using Execution plan and TOAD.

Environment: Application Modules:- INV, OM, PO, AP, AR and GL. & Languages:- PL/SQL, Forms 6i, Reports 6i, Work Flow 2.6, Oracle BI Publisher, Oracle Report Builder, UNIX, TOAD.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Developing new Reports as per client requirement.
• Developed PL/SQL programs for validations.
• Developed Procedures, Packages, Triggers and Functions.
• Development of Customer and Reports.
• Created packaged procedures, triggers validation procedures.
• Created and tested reports, packages, and triggers for the system.
• Developed validation scripts for the complex business rules using PL/SQL.
• Unit and acceptance testing for all the developed forms and reports according to the client requirement.
• Designed the Test Case documents for the product.
• Tested product Performance and Functionality.
• Created test cases at all phases of unit and acceptance testing for all the developed forms and reports according to the client requirement.

Environment: Oracle Applications R12 (12.0.3), Oracle 10g, PL/SQL, SQL*PLUS, Oracle Reports, SQL* Loader, WINSCP, Core FTP, Putty, TOAD, Windows 2000/XP, UNIX.

Confidential

Oracle Developer.

Responsibilities:

• Worked on Database Schema design and User Interface screens. Designed ER diagram of database using Microsoft Visio.
• Developing GUI using Oracle Form Builder - Object Library, Object Groups, PL/SQL Library, Menus and Data Entry screens
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes and Sequences.
• Used partitioning and sub partitioning of tables to improve performance.
• Developed Shell scripts and SQL control files to load data through SQL*Loader.
• Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out the projects.
• Used Bulk Collect feature to improve performance.

Environment: Languages: - Oracle 8i, SQL, PL/SQL, Developer 2000, Forms 4.5, Reports 2.5, SQL*Loader, HP UNIX, SQL*PLUS Windows 2000/NT.