SUMMARY

• Around 12 years of experience as Techno - Functional consultant in Oracle E-business suite 11i/R12 with extensive knowledge and experience in implementation, customization, interfaces, conversion, integration, upgrade/migration, designing/developing extensions to Oracle Applications and hands on experience with Production Support .
• Extensively used Oracle Apps Financial and Distribution, supply chain modules like Purchasing, Accounts Payables, and Receivables, General Ledger, Inventory, Order Management, Fixed Assets, i-Expenses, i-Procurement, Project Costing and Oracle Credit Management, Service Contracts. AME
• Experience with PTP (Procure-to-pay) and OTC (Order-to-cash) business process scenarios with full cycle implementations, upgrade and support projects
• Extensive experience in working with PL/SQL Stored procedures, triggers, packages using Oracle 8i/9i database, Query tuning .
• Experience in EBS integration with GXS EDI Applications.
• Experience in Development and Customization of Reports/XML Publisher/Forms/Alerts/Form Personalization.
• Experience in Development and Customization of Oracle workflows.
• Experience in development of Inbound interfaces in modules such as AP,AR,FA,PO,PA to import data from legacy systems and integrate it into Oracle Applications using open interfaces, APIs and util file Packages .
• Experience in writing shell Scripts for Automation, Inbound and Outbound Processes.
• Experience in Development and Customization of OAF Pages (OAF/Core Java) and having knowledge of ADF.
• Experienced in all stages of documentation in the implementation life cycle using Oracle’s AIM.
• Wide exposure on developing Technical design specifications and Setups for Conversions, Interfaces, User Interface Customizations and various other business requirements.
• Having good communication and presentation skills.
• Involved in end to end life cycle starting from initiating the kick-off meetings, Business requirements documents, Preparation of effort estimates, Solution design development & testing to ensure quality deliverables. Preparing test plans, Coordinating UAT with the client.
• Excellent overall project life cycle experience, Conceptual and Logical Thinking, Teamwork, Goal oriented.

TECHNICAL SKILLS

Oracle Applications: Oracle E-business suite 11i/R12.X.X

Oracle Apps Modules: Purchasing (PO), Account Payables(AP), General Ledger (GL), i-Expenses, i-Procurement, Fixed Assets (FA), Project Accounting (PA), Inventory (INV), Order Management (OM), Oracle Credit Management (OCM), Account Receivables (AR), Application Object Library(AOL), Oracle Credit Management (OCM), Service Contracts(SC),AME

Programming Languages: SQL, PL/SQL, Shell Script, C, C++, Java

Development Tools: Forms, Reports, JDeveloper, XML Publisher, Workflow Builder, SQL Loader, TOAD

Other Applications: GXS,Vertex, Sabrix, Control M

SAAS Applications: Concur,Coupa,Aria billing system, Black line

Databases: Oracle 8/8i/9i/10g/11g

Configuration Mgmt Tools: Microsoft Visual Source Safe, Clear Case, SharePoint, Perforce

PROFESSIONAL EXPERIENCE

VMWare-Lead Consultant

Confidential CA

Environment: Oracle E-business suite AP, AR, FA, GL, I Expenses, I Procurement, PA.

Responsibilities:

• Worked as Onsite Technical Lead for gathering requirements, preparing functional specification, co-ordinate with offshore team for development and support for UAT
• Interaction with the functional consultants and client for finalizations of the requirements and test strategies
• Developed Supplier, payment, purchase order, employee, GL Data extract to interface to Legacy systems
• Worked on day to day support tickets and meets the SLA timings
• Provide MONTH End/QTR End support to the users for closing the periods for PO,INV,AR,AP,PA Periods and reconciliation, reporting
• Involved in Concur and Coupa SAAS applications integrations requirement analysis, design review phases and in implementation and infant case support
• Designed and developed and tested integrations developed for data flow between Concur,Coupa to Oracle EBS
• Provided business analyst support for various business processes in EBS and SAAS applications
• Worked on the issue related to AP Payment Batches confirmation errors
• Worked on the issue related to Expense report creation
• Worked on the AR, AP, GL Interface error corrections
• Worked on Interfaces in GL AP AR and finance and SCM module interfaces and conversions

Confidential

Lead Consultant

Responsibilities:

• Doing Analysis of Impact due to Minimum Base Line Patching.
• Doing Retrofit of broken customizations
• Coordinating Testing and Break fixes and Post go live support.
• Worked on Oracle Credit Management Implementation.
• Worked as Onsite lead for Finance Module Enhancements.
• Worked on Finance Custom processes designs, development, in the area of AP,FA,AR,OCM
• To develop the RICE components.
• Worked as lead for projects and enhancement teams.
• Designing and developing custom process in OCM modules.
• Design and development of custom reports and
• To Develop the RICE Components
• Claim Statements report, an xml extract of former claim statements
• Worked on customization of Custom workflows to cater the new business process
• Worked as CBT, AT, AIT Fix Resource

Confidential

Environment:Oracle Applications, Oracle 10g, PL/SQL, Reports6i, Toad 7.6, SQL*Loader, UNIX, Core FTP, VSS, XML Publisher.

Technical Team Member

Responsibilities:

• Understanding the client requirements and Preparation of Solution Design Documents
• Development of some RICE components.
• Review the all deliveries from team members to onsite.
• Developed Customer Conversion program
• Developed Price list conversion.
• Employee Assignments conversion.
• Developed Item Cost Conversion.
• Transfer Chillan report for inter org material transfer
• Developed Receipt Voucher report
• Customized Customer statement report
• Developed Net stock turns report.

Confidential

Environment:Oracle Applications 11.5.10/R12, Oracle 10g, PL/SQL, Reports6i, Toad 7.6, SQL*Loader, UNIX, Core FTP, VSS, Remedy action request system 04.05.01

Technical Consultant.

Responsibilities:

• Understanding the client requirements and Preparation of Solution Design Documents
• Development of some RICE components
• Review the all deliveries from team members to onsite.
• Project Plan preparation, SCM Plan preparation.
• Coordinating and assigning the work to team members
• Involving in Project audits.
• Accounts payables Trial balance report in custom format
• FSG Reports For GL Trial balances
• Outbound, reports of gl balances based on summary templates.
• Payables realized gain/loss account report
• Developed a Feeder Program to load AR transactions/Invoices from flat file (IMS) to CORE
• Created Custom (Auto Invoice) pre-processor programs based on the Customer Additional Information.

Confidential

Environment:Oracle Applications 11.5.10, Oracle 10g, PL/SQL, Reports6i, Toad 7.6, SQL*Loader, UNIX, Core FTP, VSS, Remedy action request system 04.05.01

Technical Consultant.

Responsibilities:

• Studying, understanding and analyzing the given SDD
• Preparation/Reviewing of Impact analysis documents
• Development and customization of the assigned RICE Components
• Building packages, procedures, functions using Oracle
• Responsible for code review, testing of developed code.
• Customized Account Analysis by sub ledger report
• Developed Supplier spent reports XML Report
• Developed never validated invoices report.
• Journal entry form customization to disable posting for certain responsibilities during the month end time.
• Form personalization s to warn the user about the negative amount entered in entered Debit/Credit field of the form
• Developed OCR Invoices interface.
• Journal interface Feeder program to load the journals from entity to CORE,
• Customer profiles interface programs.
• Payments format files using UTL FILE package
• Developed Extract program for gl balances extract
• Worked on AS Retirement reports(Custom GL Trial Balance Report)Production support: Involved in on site (Stockton on tees UK) production support activities like
• Interface monitoring, Data movement monitoring.
• Resolving the day to day production support issues.
• Providing technical support during month end activities
• Doing the Break fixes of various programs running from different entities
• Providing AUDIT EXTRACTS for various details.

Confidential

Technical Consultant

Environment: Oracle Applications 11.5.9, Oracle 9i, PL/SQL, Reports6i, Toad 7.6, SQL*Loader, UNIX, Core FTP, VSS

Responsibilities:

• Studying, understanding and analyzing the given AIM Documents (MD50).
• Development and customization of the assigned RICE Components
• Building packages, procedures, functions using Oracle
• Responsible for code reviewing, testing of developed code.
• Developed GL Interface Feeder program to upload the journals data from legacy to Oracle
• General Ledger base tables(Using Journal interface program)
• Accounts receivable Transaction Load Interface
• Developed Invoice Outbound Interface to extract all the AP Invoices information from the
• Account Payables base tables into the flat file using UTL FILE package.
• Customized Sales order form to capture the additional information when sales order status is booked, and then item DFF capture a additional information required status yes using custom.pll

Confidential

Technical Consultant

Responsibilities:

• Studying, understanding and analyzing the given AIM Documents (MD50).
• Development and customization of the assigned RICE Components
• Building packages, procedures, functions using Oracle
• Responsible for code reviewing, testing of developed code
• Worked for Extension of invoices interface package to transfer rejected records from interface table to discard table
• Developed CMR(Current month revenue)Report in Accounts receivables
• Developed FPR(Future period revenue)Report in Accounts receivables
• Worked for the modification of invoice error correction screen

Environment: Oracle Applications 11.5.9, Oracle 9i, PL/SQL, Reports6i, Toad 7.6, SQL*Loader, UNIX, Core FTP,VSS

Confidential

Technical consultant

Responsibilities:

• Studying, understanding and analyzing the given AIM Documents (MD50).
• Development and customization of the assigned RICE Components
• Building packages, procedures, functions using Oracle
• Responsible for code reviewing, testing of developed code
• Developed a feeder program to transfer all the Purchase Order Details from legacy into Oracle
• Purchasing base tables using Import Standard Purchase Orders concurrent program.
• AP Invoices Conversion to transfer the standard and credit memo invoice details into payables base tables.

Environment Oracle Applications 11.5.9, Oracle 9i, PL/SQL, Reports6i, Toad 7.6, SQL*Loader, UNIX, Core FTP, VSS