SUMMARY

• 10+ years of diversified technical and Functional expertise in Oracle E - Business Suite (EBS) Applications11i& R12, with extensive exposure in development of Custom interfaces, APIs, building control files, dealing with Application Object Library, customizing forms, reports, OAF and workflows.
• Expertise in Technical and Functional aspects of Oracle E-Business Suite (EBS)applications Federal Admin, Accounts Payables (AP), Accounts Receivables (AR), Purchasing (PO), Finance, Supply Chain, P2P (procure to Pay) and Order to cash Modules which include Trading Community Architecture (TCA), AOL, General Ledger (GL), Inventory (INV) Cash Management (CM), Bills of Materials (BOM, Fixed Assets (FA), Project Accounting(PA), Manufacturing & HRMS, well versed with Procure to Pay (P2P) and Order to Cash (O2C).
• Well experienced in Reports, Interfaces, Conversions, Extensions, Workflow, Discoverer, UNIX (RICEW), Implementation and Support of various Oracle Apps modules. Involved in implementing versions/upgrades of Oracle Applications 11i, and involved in implementing/upgrading Oracle E-Business SuiteApplicationsR12.
• Extensive experience in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, and Packages using PL/SQL.
• Good experience in developing reports using Forms, Reports6i/9i/10g, Discoverer 9i/10g and XML Publisher.
• Expertise in developing forms using Forms 6i/9i/10g.
• Expertise in developing/customizing teh workflows and having teh strong knowledge in OAF.
• Experience in developing Install scripts, copy scripts and FND load scripts using Shell programming.
• Experience in Import and Export utility, SQL* Loader.
• Extensively experienced in Oracle PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers.
• Having good experience in Support projects and SLA (Service level agreement).
• Expertise in data fixes and troubleshooting teh issues.
• Strong familiarity with AIM standards &OUM Methodologies and worked on MD50, MD70, MD120, CV60 and CV80.
• Experience in registering of Custom Applications/Table/Schemas in Oracle Applications.
• Capable of Performance Tuning, Optimizing SQL and PL/SQL scripts.
• Experience in Log, view, access, monitor, follow up and close Service Requests (SRs) online -Oracle Metalink.
• Good experience in creation of concurrent programs to execute requests viz.; reports, stored procedure, shell script.
• Strong knowledge of order to cash (O2C) and procure to pay (P2P) business flows.
• Highly motivated self-starter with excellent communication, presentation and interpersonal skills, can perform well both independently and with a team, always willing to work in challenging and cross-platform environments.

TECHNICAL SKILLS

ERP: Oracle EBS applications 11i/R12 (AP, AR, GL, OM, PO, IB, SC, FA and CE).

Languages: Java, SQL, PL/SQL, C, C++.COBOL

Databases: Oracle 8i/9i/10g/11g, MS Access, SQL Server 2000, MYSQL.

Web Tools: HTML, Java Script, JSP, MS Front page.

Office Applications: MS-Office.

Tools: Oracle Reports 6i/9i/10g, Oracle Forms 6i/9i/10g, Oracle Developer, OAF, Oracle Discoverer 4i/9i/10g, Oracle Workflow, TOAD, SQL Navigator, and Workflow Builder. Tableau, WINSCP3, Filezilla, PUTTY

Operating Systems: UNIX, & Linux, Windows98/XP, Windows NT.

PROFESSIONAL EXPERIENCE

Confidential, CA

Oracle Applications Techno Functional Consultant

Responsibilities:

• Prepared BR100 documents regarding setup changes and performing teh configuration changes in several development, test and production instances.
• Experience in R12 Remediation for 11i Custom components using Panaya tool.
• Participated in Impact analysis of all Custom components to make use of R12 features such as SLA and MOAC.
• Hands-on Experience in implementing XLA for existing Accounting processes.
• Developed Aging Bucket, AP/AR Netting Reports (AR) in XML Publisher.
• Designed and developed TCA Interfaces, for updating and adding new Suppliers and Customers from shared systems.
• Used Auto Invoice Interface to import Standard invoices from a legacy system into Oracle Receivables using a control file, PL/SQL packages/procedures and Auto Invoice Import program.
• Developed AP and PO interfaces to integrated data from different systems.
• Worked on Performance issues for huge volume Interfaces.
• Developed Custom form to create Facts and Treasury details in Federal Admin.
• Updated As-Is Process Flows andFunctionalSpecification Design documents.
• Analyzed custom objects for treasury mandates impact and recommended solutions for them.
• Conducted/Participated in Solution Reviews for PMR's (Problem Management Records) and Working Group Sessions special projects in R12.
• Customized Controller objects in IProcurement in OAF Page.
• Involved in creating Payment Batch Extension to create Payments from different Invoices Sources.
• Customized Printed Purchase Order Report, Transaction Register and Aging Reports according to teh business requirements.
• Developed detail Depreciation reports in Fixed Assets (FA).
• Good exposure in reporting tools Tableau, crystal reports, Data reports.
• Customized XLA Pages in OAF to restrict data for orgs by using Data- access sets.
• Modified several Customized Reports using XML/BI Publisher like Credit/Debit Memo Report, Invoice History, Invoice Aging, Prepayment Status, and Invoice on Hold Reports as per changing business needs.
• Responsible for supporting multiple instances, activities include maintenance and upgrade of Oracle E-business Suite.
• Functional & Technical Analysis and Troubleshooting of post-production issues on various Business processes.

Environment: Oracle EBS Apps R12, ORACLE 11g, PL/SQL, Toad 10, SQL*PLUS, UNIX.

Confidential, Columbus, OH

Oracle Applications Techno Functional Consultant

Responsibilities:

• Designed Technical documents (CV60) and developed AR Conversions like Invoices, Receipts, and Resources to bring data from different Legacy systems.
• Designed Technical documents (MD 70) and developed Cash Management Bank statement Interface to load BAI2 files from different banks for reconciliations.
• Developed Custom form to maintain Voucher details, Cost Allocations and mapping to GL Accounts.
• Designed Technical documents and developed Conversions and Interfaces for GL to import Journals from different systems.
• Developed OAF page to view and updated Customer credit rules for Customer holds and generate teh reports.
• Created JSP pages to upload files manually to run interface on demand.
• Created Dunning plans for sending custom letters via manual dunning process to 3rd party systems
• Customized OAF Controller class to change teh labels by creating messages from Application Developer and assigning default values.
• Publish dashboard reports on current projects and issues. Review escalated Issues and work with teh team to ensure a resolution plan.
• Modified several Customized Reports using XML/BI Publisher in GL like Account Analysis 180 char and Drill down reports.
• Developed Financial Statement Generator reports in GL.
• Worked on extensions on OAF pages as per client requirement
• Provided Change Management on-call support for Emergency Changes. Processing CAB exceptions efficiently.
• Involved in post Implementation support and providing training to end users.

Environment: Oracle EBS Apps R12, ORACLE 10g/11g, PL/SQL, Toad 9, SQL*PLUS, UNIX.

Confidential, Houston, TX

Oracle Applications Techno Functional Consultant

Responsibilities:

• Developed Custom Interface programs using API’s to update Service entitlements and products in Service Contracts.
• Developed Keystone - TCA-Detailed Customer Master Architecture.
• Developed forms to maintain Customer Volume Purchase Program (VPP), pricing benefits they can get for future orders based on teh points earned on existing orders.
• Developed Order import program to create different orders like ELA Order, Redemption, NFR, and Downgrade.
• Developed Zoom form in Order manger to get license details for teh Customer.
• Issue resolution, incident management, coordinating with Business Analysts and end-users, attending weekly review calls with business, developing hot fixes through e-CAB and taking part in teh CAB Review/Approval meeting.
• Customizing Order management workflows as per Business requirement.
• Created outbound Interface to inform consignment suppliers about teh item demands.
• Handling quality metric management for tickets by ensuring SLA is met and teh key words are in place for tickets.
• Developed Interfaces and reports to accommodate generated flat files to be transferred to external systems using custom UTIL package.
• Customized several reports in OM, INVand Telesales as per Business requirement.
• Developed Custom Interface programs using API’s to update Install Base Parties and Licenses.
• Customized Oracle standard report “Payables Account Analysis Report” to meet teh business needs.
• Created PDF/EXCEL output’s for reports based on requirements.
• Created Data fixes in OM, SC, BOM and IB for issues.
• Developed deployment documents for data fixes.
• Developed Workbooks based on teh Custom Folders and calculations using Discoverer Desktop.

Environment: Oracle EBS Apps 11i, ORACLE 10g/11g, PL/SQL, Reports 6i/10g, Toad 9,SQL*PLUS, UNIX.

Confidential

Oracle Applications Techno Functional Consultant

Responsibilities:

• Coordination of a 7-member development team, evaluate and implement changes to all customizations and extensions.
• Prepared Functional and Technical design Document for Reconciliation Summary and detail report.
• As a technical lead in support analyst I handle escalated issues.
• Handled quality metric management for tickets by ensuring they meet SLA and teh key words are in place for tickets
• Managed all development aspects of an Oracle Applications 11.5.10.2 to R12.1.2 upgrade.
• Analysis COA changes (Client Requirement) impact after upgrading.
• Place all new alternate accounts in both setups and open transactions.
• Preparing unit test plan with COA changes and R12 futures.
• Worked on Period closure reconciliation Issues.
• Validating open transactions in all finance modules & matching teh same with teh GL balances, as part of upgrade activity.
• Customized OAF pages by using personalization in iExpenses.
• Developed new pages in OAF to maintain Customer Attributes for Dunning Letters.
• Responsible for modifying & creating Business Areas using Oracle Discoverer Admin for changed & new reports.
• Created Workbooks based on teh Custom Folders with multiple parameters and calculations using Discoverer Plus and Discoverer Desktop.
• Responsible for developing new reports in Oracle XML/BI publisher.
• Created output format in XML/BI, new templates for XML/BI Publisher to display teh reports in client requirement format.
• Created PDF/EXCEL output’s for reports based on requirements.
• Used teh Totals/Subtotals/group/sort features of XML/BI Publisher to make data intense operations happen at teh template level.
• Customizing teh application forms to meet teh specific business needs using built in features available with (Template.fmb) form, built-in stored procedures and attached libraries.
• Involved in teh design & development of user interface in Forms and table design using Oracle.
• Developed various Business and ad-hoc Reports.
• Extensively worked in tuning teh SQL queries using Explain Plan, Tkprof, SQL*Trace.
• Involved in Interface designing and Documentation and implementation of these as per AIM.

Environment: Oracle EBS Apps R12, ORACLE 9i/10g, PL/SQL, Oracle Workflow, Discoverer, XML/BI Publisher, UNIX.

Confidential

Oracle Applications Techno Functional Consultant

Responsibilities:

• Creating Flex fields for Location, Defining Systems Option parameters
• Creating Customers, Profile Classes & Bank information
• Creating Distribution Sets, Receipt Sources, Receipt Classes & Payment Terms
• Defining Application Rule Sets, Auto Accounting Rules & Auto cash Rule Sets
• Creation of Transactions & Source and Customization of check printing report
• Importing Legacy Journals in General Ledger using SQL Loader and Journal Import
• Created BOM Interface using API.
• Created Item and Invoice Interfaces
• Developed interface programs to integrate Legacy System with teh AR module to import customer information using teh Customer Interface. Defined descriptive flex fields
• Testing and Code review.
• Implementing control points in business processes by developing Form Personalization.
• Created output format in XML/BI, new templates for XML/BI Publisher to display teh reports in client requirement format.

Environment: Oracle EBS Apps R12, ORACLE 9i/10g, PL/SQL, Oracle Workflow, Discoverer, XML/BI Publisher, UNIX.

Confidential

Oracle Applications Techno Functional Consultant

Responsibilities:

• Developed Interface by using API for creating Notes corresponding.
• Developing components for teh Middle Tier to implementing various business rules.
• Developed Interface by using API for creating Notes corresponding Customers and Leads.
• Developed Interface by using API for Converting Quotes to Booked Orders.
• Coordinate with Oracle Support determining teh bugs incurred in R12 with EVENTS and counters and fix them applying appropriate patches. Resolved issue in Service pricing with oracle support.
• Documentation and maintenance of Technical work done.
• Resolving teh issues on Telesales Module, iprocurement and iexpense.
• Resolving teh issues on PO components like Requisitions, Purchase Orders and Receiving.
• Resolving teh issues on AP components like Invoices, Payments, and Banks & Suppliers.
• Experienced in using teh performance tuning methods like TKPROF, Explain plan, Trace and creating indexes.
• Worked on creating application mode End User Layer, building business areas, and building discoverer workbooks.
• Developed reports in AP, GL and AR modules using Reports9i.
• Built custom forms using TEMPLATE.FMB to fulfill teh business requirements like implementing teh calendar feature, WHO columns, defining DFFs etc.
• Developed teh Request sets dat are scheduled to submit concurrent programs in a desired sequence as per teh functional document.
• Customizing teh application forms to meet teh specific business needs using built in features available with (Template.fmb) form, built-in stored procedures and attached libraries.
• Involved in teh design & development of user interface in Forms and table design using Oracle.
• Experience in customization of XML Publisher reports.
• Created output format in XML, new templates for XML Publisher to display teh reports in client requirement format.

Environment: Oracle EBS Apps 11i, ORACLE 9i/10g, PL/SQL, Forms Reports 6i/10g, Toad 8, Discoverer, XML/BI Publisher.

Confidential

Oracle Applications Techno Functional Consultant

Responsibilities:

• Defining teh Approval Group by utilizing teh Position Hierarchy.
• Customizing Accounting Flex Fields, Cross Validation Rules and Security Rules.
• Designing and development of customized object/programs in Oracle Database/Applications as per teh business requirements and Apps Schema standards.
• Setup transaction types, document numbers, and processing constraints.
• Implementing control points in business processes by developing Form Personalization.
• Created alerts, for sending mails to users and receiving response mails from users.
• Resolving teh issues on OM components like Sales Orders and Sale Returns.
• Resolving teh issues on AP components like Invoices, Payments, and Banks & Suppliers.