SUMMARY

• About 7 years of IT experience in design, development, enhancements, customizations, up-gradations, interfaces and conversions using Oracle Applications 11i, SQL, PL/SQL, Oracle 10g/9i/8i, Developer 6i/2000, Discoverer 10g/4i, Oracle JDeveloper
• Expertise in Developing, Customizing and Implementation of various Oracle Application Modules (Order Management (OM), Shipping (WSH), Learning Management (OTA), General Ledger (GL), Account Payables (AP), Account Receivables (AR), Purchase Order (PO), Inventory (INV), Bill of Materials (BOM), Work In Process (WIP), Project Accounting (PA), Human Resources (HR))
• Extensive experience in Order-to-Cash, Procure-2-Pay Business flows of Oracle Applications 11i
• Expertise in Reports, Interfaces, Conversions, and Extensions and ability to work in most of the Oracle Application modules
• Expertise in Oracle Databases (9i/8i), SQL, PL/SQL, SQL* Loader and Toad
• Expertise in developing stored procedures, packages, and triggers for oracle
• Extensive Programming experience in Shell scripting, Perl Scripting, Forms 10g/6i, Reports 10g/6i and Discoverer 10g/4i
• Experienced in Conversion/Migration of data from Legacy to Oracle System
• Used Trading Community Architecture (TCA) API’s to create or update parties and relationships
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency using EXPLAIN PLAN and TKPROF
• Customized ORACLE workflow process according to the business requirement
• Experience in customizing reports in PDF, EXCEL and RTF formats using XML Publisher
• Experience in System Administration such as creating users, menus, assigning responsibilities, and adding forms and functions to menus
• Familiar with version control tool (PVCS, ITG and RCS)
• Strong analytical, diagnostic and troubleshooting skills and ability to work in a fast-paced and team-oriented environment
• Proven ability to work with a wide range of departments and levels of management
• Excellent communication and interpersonal skills

ERP Modules: Oracle 11i E-Business Suite (Modules: OM, WSH, OTA, GL, AP, AR, PO, INV, PA, HR and AOL)
Databases: Oracle 10g/9i/8i
GUI: Oracle Forms 10g/6i, Reports 10g/6i, Oracle Discoverer 10g/4i, Oracle Workflow Builder 2.6, XML Publisher, and Oracle JDeveloper
Tools: Toad, SQL* PLUS, SQL* Loader
Languages: C, C++, SQL, PL/SQL, Perl and Shell scripting
Operating Systems: UNIX, Linux, Windows XP/NT, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Feb 2009 – Till Date
Oracle Apps Technical Consultant

Reynolds Packaging Group (formerly Alcoa Inc.) is one complete resource for products, services and solutions. Reynolds offers innovative packaging products in virtually every size and shape, made from one of the widest selections of materials in the industry. This project is a clone-and-clean-process, which involves in checking each and every object to make sure it works without any error.
Environment: Oracle Apps 11.5.10.2 Modules: (OM, SFM, WSH, BOM, WIP, GL, AP, AR, INV, QP, FA, PA, HR), Oracle 9i, Oracle JDeveloper10g, Reports 6i, Forms 6i, Discoverer 10g, XML Publisher, Workflow Builder and Custom Oracle Database for Data warehousing

Responsibilities:

• Involved in validating the objects (Reports, Forms, Interfaces and workflow background process) with variety of input parameters
• Involved in designing GAS using Oracle JDeveloper
• Designed SOD Tool using OAF
• Made several changes to the workflow mailer and created custom watchdog process for monitoring concurrent programs
• Re-designed Certified Inspection Report and Intercompany Invoice Report in BI Publisher (formerly the reports were using JETFORMS)
• Added new COPY_FROM functionality to Market code Form
• Worked on Mass price change Interface on weekly basis using Oracle Loader
• Involved in solving the issues with Oracle Alerts, created an SR and worked with Oracle support team to resolve the issue
• Designed various discoverer reports using Discoverer Administrator and Discoverer Plus
• Resolved issues with various reports: shipment recovery report, Inactive Items Report and Purchase Order Print Report
• Worked with several other team mates to design a custom oracle database for data warehousing (SPARK), created tables, views, PL SQL packages and individual functions.
• Created custom PL SQL packages in Oracle Applications to load the data into custom tables in Data warehousing.

Confidential, Dec 2007 – Jan 2008
Oracle Apps Technical Consultant

SAPA Industrial Extrusions (formerly Alcoa Inc.) is implementing Oracle Applications. This project is involved in migration of custom solutions from Alcoa to SAPA. These objects include reports, forms, interfaces, Discoverer Reports and workflows.

Environment: Oracle Apps 11.5.10.2 Modules: (OM, SFM, WSH, BOM, WIP, GL, AP, AR, INV, QP, FA, PA, HR), Oracle 9i, Reports 6i, Forms 6i, Discoverer 10g, XML Publisher, Workflow Builder, Toad, UNIX, PL/SQL, Shell and Perl Scripting

Responsibilities:

• Lead a team of 3 people for solving Discoverer Issues.
• Involved in analyzing the existing objects in Alcoa, finding the dependencies involved such as PL SQL packages, custom tables and views.
• Followed AIM methodology to document the analysis work done: MD 65.5 or MD 70.
• Made necessary changes to the object, migrate it to SAPA instance and unit test.
• FNDLOAD is extensively used for migrating definitions of concurrent programs, request sets, forms, functions, menus and form personalizations.
• Migrated various Oracle 6i Reports such as Yearly Summary Data Report, Management Order Status Report, Custom Agreement Report, Custom Open Sales Order Report, Change Order Acknowledgement Custom Report, Payment Register Report, Invoice on Hold Report and Mass Price Update Reports.
• Designed Custom Purchase Order Report, Change Order Purchase Report, Requisition Approval Report and Custom Check Printing Report using XML Publisher.
• Implemented Trading Partner Layers and Callouts for specific customers
• Migrated various forms such as Job Status by Trip, Trip planning, GL Error Correction, Log Completion and price update forms.
• Created End User Layer for Discoverer Reports, migrated seeded and custom business areas to the new EUL, Analyzed and migrated workbooks needed for SAPA.
• Involved in migration of GL to PA Interface Receiver, AR Accounting Correction, Journal Import Submitter, FA Reconciliation, Sales Tax Legal Identification
• Involved in migration of various interfaces such as Mexican Mass Payments, Lock-box Interface, On-guard Interface, and Account Payables Invoice Interface.
• Implemented Bank Branches and Bank Accounts Conversion, Supplier Conversion, Employees Conversion and PO Receipt Conversion.
• Migrated Custom workflows: PO Approval Workflow, PO Error Workflow and PO Document Workflow.
• Used RCS repository for version control and SMT tool to migrate the objects between the instances.

Confidential,IL March 2007- Nov 2007
Oracle Apps Technical Consultant.

Kaplan Professional provides organizations and individuals with training solutions, such as exam prep and continuing education. This project involved in addition of various feature sets and development of custom reports using Report Builder and Discoverer Tool.

Environment: Oracle Apps 11.5.10 Modules: (OM, WSH, OTA, GL, AR, INV), Oracle 9i, Reports 9i, Forms 9i, Discoverer 4i, XML Publisher, Workflow Builder, Toad, UNIX, PL/SQL

Responsibilities:

• Involved in analyzing the user requirements, helping the Business Analysts in preparing the requirement document, designed various feature sets according to the requirements and unit tested.
• Developed feature set: Reminder Letter Report to send an email to customer those who didn’t pay the amount in time and developed associated Collection Letter Report to provide the list of customers.
• Involved in integration of Oracle to Microsoft SQL server (Customers, Students, Session Attendance and Classes).
• Designed a custom report: Deferred Revenue Report to provide the sales amount which is deferred every month.
• Developed a feature set: Custom Receipt Register to store the payment information in AR table and designed corresponding Custom Receipt Register Report.
• Developed various reports using Discoverer tools: Classroom Profitability Report, Contact Center Commissions Report, Sales Rep Commission Report, Fixed Lease Report, Special Class ID report, Payroll Verification Report, Class Roster Report, Shared Revenue Report, Daily Sales Report, Oracle to Vega Integration Error Report and Vega to Oracle Integration Error Report.
• Designed various Sign-In sheet Reports using Reports 6i and provided output in PDF format using XML Publisher.
• Involved in developing Descriptive Flex Fields, Value sets (Item Classes in Discoverer).
• Customized the existing quick order organizer search form to include Sales Group name using Forms builder 6i.
• Prepared documentation of feature sets: SADD, Test Plan and MD-120 (Deployment Document)

Confidential. June 2006-February 2007
Oracle Apps Technical Consultant.

Camelbak is the originator and world leader in hands-free hydration systems. The first Camelbak products proved to be very popular among mountain bikers and motocross riders. Camelbak believes in the performance advantage that proper hydration delivers for just about any activity. This project involved in implementation and customization of Oracle Financials and Manufacturing modules.

Environment: Oracle Apps 11.5.10 Modules: (OM, WSH, GL, AP, AR, PO, INV), Oracle 9i, Reports 10g, Forms 10g, Discoverer 10g, XML Publisher, Workflow Builder, SQL*Loader, Toad, UNIX, PL/SQL
Responsibilities:

• Developed Custom Reports in Inventory and Order Management modules as per the user requirements
• Developed Move Order Actual Receipts error report to provide error details of move orders in Inbound staging table
• Customized reports like company income statement, company balance sheet and trial balance reports for GL module
• Customized many reports such as Recurring Invoice Report, Payment Schedule Report in AP, provided the users with detailed vendor reports on existing vendors
• Developed summary report to provide details of receipt confirmations in PO and Inter-Org Transfer with XML Publisher
• Involved in developing new DFF’s, Value Sets and Values for supporting the reports developed
• Registration of customized reports through creation of concurrent executables, concurrent programs, and assigning to the request group.
• Involved in development of custom objects for third party integration with Oracle Applications
• Worked on prevention of Back Order of deliveries based on business rules for an Inbound Interface
• Worked on Cycle Count Outbound Interface for providing data file for third party application
• Developed trigger to pull delivery data required to be sent to third party application as ship request
• Developed an Interface program for Inventory Adjustments
• Imported data from Legacy systems into temporary tables in account payables and successfully designed and implemented Payables Interface
• Experience with SQL*Loader, UTL_FILE, Oracle Export and Import utilities.
• Involved in customization of the Purchase Order workflow, which include addition of events, notifications, and functions
• Workflow customization for Order Management. Reporting for shipping distribution and order statuses which were used for month-end closing
• Worked in the support role, performed the responsibility of system administration tasks like creating users, setting up the user profile etc.