PROFESSIONAL SUMMARY:

• Over 12 years of experience asOracle Applications Techno - FunctionalConsultantin implementation, upgrade and customization ofOracle e-Business Suite Applications. This includes system study, design, development, post implementation maintenance and support ofOracle EBS.
• Broad technical experience in Implementation, Migration, Customization, Production Support of various modules including Order Management (OM), Inventory (INV), Purchasing (PO), General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), WIP and BoM, HRMS in Multi Org environment.
• Extensive experience as Oracle Applications e-Business Suite Consultant and Technical Developer in Design, Development and Implementation of Oracle Applications R12/11i.
• Excellent technical experience Reports, Interface, Conversion and Extension (RICE) with documentation using Oracle’s AIM methodology.
• Extensively experienced in Oracle PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers.
• Extensively worked in SQL*Loader, SQL* Plus, FNDLOAD, Oracle Import/Export utilities, Toad and SQL* Navigator, Oracle Configuration Management.
• Experience in designing, developing, testing, performance tuning and supporting data base applications using Developer Tools (Reports 6i/9i/10g, Discoverer4i/9i/10g, XML/BI Publisher), PL/SQL on UNIX and Shell Scripts).
• Very Good understanding of Trading Community Architecture (TCA).
• Functional experience in Application Object Library (AOL) implementation standards and System Administration module (setting up new responsibility, user, registering menu’s and concurrent programs, request groups and request sets.)
• Worked on Performance Tuning to increase the performance of Custom concurrent programs.
• Excellent communication skills and a smooth client handling and interaction experience. Strong proficiency in problem solving, Initiative taking, Time management. Excellant understanging with team members and supervisors in all projects.

TECHNICAL SKILLS:

ERP: Oracle E-business suite R 12.1.3/11.5.10.2/11.5.9/11 i/11.0.3/ (Financials/ Manufacturing /HRMS)

Oracle Apps Modules: Order Management (OM), Inventory (INV), Oracle Purchasing (PO), Oracle Receivables (AR), Account Payables (AP), General Ledger (GL),Bill of Material (BOM), Work in Progress (WIP), Application Object Library (AOL) and HRMS

Databases: Oracle 8i, 9i / 10g, MS Access

Tools: SQL Navigator, Toad, Oracle SQL Developer, Workflow Builder 2.6, BI Publisher, Discoverer 10g, Edit Plus, Putty, Clear Case, Clear Quest, Remedy, Autosys

Utilities: FNDLOAD, SQL*Loader, Export, Import, Shell Scripting, OA Framework

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Applications Consultant

Environment: Oracle Applications 12.1.2 (AP, AR, SLA, GL and AOL)

Responsibilities:

• R12 upgrade from 11. .1.2. Involved in requirements analysis, identifying database modification, coding changes, implementing the interface programs and reports across financial modules.
• Remediate R12 changes in 271 Beneficiary Interface (Customer/Supplier) Includes processing data file from Contractor, load into staging table, validate and move into oracle seeded tables. Supported during the testing of end to end process in Alpha, Beta and UAT testing phases.
• Provider/Beneficiary: Involved in the Transition of Providers/Beneficiaries as Customers and Suppliers from External System like FISS and MCS and also from One HIGLAS Organization to another organization.
• Remediate R12 changes in 811 Case Interface and supported during the testing of end to end process in Alpha, Beta and UAT phases.
• Involved in the R12 changes Custom Web ADI Manual AP Invoice Import Program.
• Also worked on Autosys tool upgrade, validated end to end process of multiple threads including
• Excellent understanding of 271, 274, 837, 810 inbound interfaces, AR/AP Netting, 835 Payment Batch interfaces.
• Involved in ACE Audit entry framework process across application. An audit entry created in custom audit tables at file level validation in oracle as well as WebSphere operations. Involved in the testing of end to end process in Alpha, Beta and UAT testing phases.
• Developed custom CMS Transaction Register report based on COTS report.

Confidential, Columbus, GA

Oracle Application Techno-Functional Consultant

Environment: Oracle Applications 12.1.3 (OM, PO, INV, AR, AP,GL,WIP and BOM)

Responsibilities:

• Involved R12 upgrade from 11.5.9 to R12.1.3
• Identified the processes and database objects that will be impacted by R12 Upgrade
• Identified obsolete database objects/seeded functions and all custom programs that needs upgrade(cascading PO receipt does not work for Blanket PO(R12 bug, OM Price list no longer org specific, RMA receipts do not work ) etc.
• Involved in requirement study to Handover of the project which includes analysis, user requirements, database modification, coding, Support and testing in various environments (CRP1, CRP2 and UAT)
• Worked closely with the Oracle Support team regarding setup and data corruption issues through Oracle web Conference, Bugs and SRs etc.
• Created a custom process to identify and mark as printed invoices. This is needed to where no printed invoices need to be sent EDI customers.
• Created an Autoinvoice request set includes custom revenue account/autoinvoice./no print invoice. Scheduled to run every day with increment date parameters.
• Setup some supplier are BROKERs and created custom application to calculate commission for brokers ( po vendors, ra customers etc. obsolete in R12 )
• Created a custom interface to identify all expected PO receipts based on promised date and drop as message to third party receiving tool.
• Created a custom interface to process receipt confirmation in oracle against POs based on the warehouse receipt feed . Implemented cascading in receiving process.
• Develop API that returns refcursor output to various web application and window applications specific to the client ( SFS, PSI, Intranet Reports, Broker Commision, Daily Sales by Customer Intranet report, etc.)
• Recently developed an interface process to load cost data into oracle (with Pending cost type) followed by Cost rollup job.
• Recently worked with user on Customer PO number is different between sales order and Invoice.
• Open a DFF in customer master RISK CODE, in Quickcodes setup screen for no. of days allowed past due (FND LOOKUP).
• Setup/schedule an Alert/email notification to user for all invoices printed previous working day.
• Setup of custom credit hold process for all customer orders if it exceeds the credit limit with certain type of credit risk in customer master. Also provided a custom hold release screen to release holds.
• Automate the inventory reconcile process, warehouse FTP inventory file end of every business day, compare the inventory in oracle vs. warehouse inventory and email mismatch report to users.
• Automated order drop process based on scheduled ship date. Creates delivery and available for warehouse shipping team to ship to customer. Parameter by sub inventory/customer
• Production Support: Working on the post production support phase which involves enhancement of existing and new features. Monitor all the scheduled jobs and closely working with customer service users. Involved in Month End and year end activities.

Confidential, Columbus, GA

Oracle Application Technical Consultant.

Environment: Oracle Applications 11.5.9 (GL, AR, AP, INV, PO and OM)

Responsibilities:

• As a Senior Oracle Consultant involved in the full life cycle of the project from Requirement study to Handover of the project which includes analysis, user requirements, database modification, coding, Support and testing in various environments (CRP1, CRP2 and UAT) and Responsibilities include gathering functional and technical requirements, design, development and resolution of problem tickets raised by users.
• AR: Involved in Design and development of Customer conversion, which include Customer, Addresses and Profile Information. Setup all the Lookups / Quick codes for customer conversion which includes payment terms, customer class, customer category, Freight terms etc. Involved in AR Invoice conversion. Developed Custom AR Invoice program to print invoice on pre-printed stationary.
• INV: Involved in the Design and development Inventory Items Conversion using Item Import Interface, Inventory Adjustment using Material Transaction Interface. Developed Item Cross Interface, Item Categories and UOM conversion using custom API’s. Designed Item Template for Item conversion.
• PO: Developed Standard Purchase Order and Receipt Conversion using oracle standard interfaces. Worked on the design and development of DELTA interface for domestic purchase order interacting with external systems and GPM for international purchase orders. Receive ASN (Advance Shipment Notice) information/ IR Information from GPM.
• OM: Setup Freight Carriers, Various order Headers and order line types. Created a ship confirmation program in oracle using the warehouse MQ message. Created multiple reports including open orders report, Deliveries dropped to warehouse and not shipped in oracle, Customer Service Rep efficiency report etc. Worked on Drop ship container orders. Approve supplier list and Sourcing Rule setup.
• Oracle General Ledger (GL): GL Journal Conversion using Journal Import Program.
• Reports: Involved in developing various new reports (Inventory Reconciliation Report) and customization of existing report. Created packages which return refcursor data. These packages were called from .NET application for many web based reports. (Daily sales by salesperson, Region, Slow moving inventory). Developed Sales by state Report using XML publisher.
• Forms: CUSTOM.pll is modified to make PO Promised date as non-mandatory and Need by date should be mandatory. Added customer name in Supply/Demand screen which does not exists in oracle standard form.

Oracle Application Technical Consultant

Confidential, Marlborough, MA

Environment: Oracle Applications 11i (V 11.5.10) (AP, AR, FA)

Responsibilities:

• Involved in the development of AP Invoice Interface (Accounts Payable).
• Load data from the legacy system to Oracle Applications. This involved the usage of SQL*Loader, PL/SQL scripts. After all the records populated from flat file into oracle Interface table via Interim tables, a Standard Oracle Payables Import program is used to validate and populate records into oracle standard tables.
• Migrated vendor information from legacy systems using AP Vendor conversion.
• Involved in the customization of Separate Remittance Advice Report in AP.
• Registered as a Concurrent Program in different Environments. Prepared Technical Design (MD070) /Unit Test Plan / Implementation plan.
• Changes inside the report vary from addition of fields, removal of unwanted lines that makes the report unreadable to users.
• Involved in the customization of AP - Travel by Department Report for Accounts Payables By management Information System
• Registered as a Concurrent Program in different Environments and prepared Technical Design (MD070) / Unit Test Plan and implementation plan.
• Involved in the customization of AP - Check Details Report.
• Involved in preparing Technical Design (MD070)/Test Plans/Implementation Notes.
• Discoverer Reports; Developed many Reports using Oracle Discoverer 3.1/4i. Involved in creation of custom views for Discoverer Reports and Creation of End User Layer (EUL);
• Involved in production support for Application, data and Scheduled jobs. Involved in solving production issues. Bugs are figured out from the client side and will be reported to our onsite team. The bugs will be created as a ticket and assigned to our team thro KINTANA (Kintana is a reporting tool).
• Need to find out the root cause of the problem. Need to provide the resolution. Involved in fixing the bugs in the reports / Involved in enhancement of the reports.
• Developed Custom Reports for Oracle HR and Payroll. Some of the reports are Over Time Report per Payroll, New Hire Report, Head Count Report, and Terminations Report.
• If it is a development request then Development ticket will be created and need to work accordingly. Involved in monitoring scheduled jobs (CONTRO-M).

Oracle Application Technical Consultant

Confidential

Environment: Oracle Applications 11i (V 11.5.7) - AR, AP, FA & HRMS

Responsibilities:

• Oracle Receivables (AR) Customer Interface: Involved in design and development of Customer Interface program. Developed a Custom Sql*Loader Program to load legacy data into Custom staging table. Developed Custom PL/SQL API to validate the data, which loads into Customer interface tables and through Oracle Standard 'Customer Interface' the valid data gets loaded into Oracle base tables.
• Worked on Trading Community Architecture (TCA).
• Developed the customer data import program for data loading from different systems to oracle TCA tables.
• Involved in the Design and development of RICE (Reports, Interface, Customization and Enhancements).Oracle Reports; Developed of many reports to support users in various modules AR, AP, OM and FA using Oracle Reports 6i.
• Discoverer Reports; Developed many Reports using Oracle Discoverer 3.1/4i. Involved in creation of custom views for Discoverer Reports and Creation of End User Layer (EUL).