SUMMARY

• Expertise in Oracle E - Business Suite has a techno functional analyst from 9 years.
• Expertise in P2P (PO, I-Procurement, AP, Payments), O2C (OM, INV, AR), Q2C, Sales (Quoting, Trade Management, Channel Revenue Management (CHRM), Advance Pricing, I-Store), GL, Project Accounting PA.
• Four full life cycles.
• Worked with Offshore Teams.
• Expertise in RICE-W Components (Reports, Interface, Conversion, Extensions, Workflows).
• OAF (Oracle Application Framework).
• SQL, PLSQL, Unix Shell Scripting, packages, procedures, functions.
• Functional Setups for Advance Pricing, OCRM, OM, AR, QOT, AP.
• Oracle Forms (Personalization & Customization), BI (XML) Publisher, Discoverer Reports.
• Worked with Salesforce integration with Oracle EBS, SOA BPEL Process.

TECHNICAL SKILLS

• Oracle EBS 11i - R12
• Salesforce
• OAF
• JSP
• HTML
• CSS
• Oracle Forms 6i
• 10g
• Oracle Reports 6i
• 10g
• BI Publisher
• Discoverer
• Workflows
• WebADI
• SQL
• PLSQL
• Unix Shell Scripting
• Concurrent Programs
• System Administrator
• Application Developer
• AIM Methodology Documentation.
• Remedy
• JIRA
• Service Now
• Microsoft VSS
• SVN
• Kintana
• Data Loader

PROFESSIONAL EXPERIENCE

Confidential, Mountain View, CA

Oracle Techno Functional Analyst/Developer

Responsibilities:

• Oracle Channel Revenue Management (CHRM) (Trade Management), Advance Pricing, Order Management (OM), AP, AR, P2P and O2C.
• Confidential and VERITAS, R12 Implementation Project.
• Developed Outbound Interface from CHRM to Custom Portal Application.
• Involved in Inbound Interface between CHRM and Custom Portal.
• Worked on Budgets, Offers and Claims Customization.
• Worked on Custom Upload interface for Budgets and Offers.
• CHRM integration with OM, Advance Pricing, AP and AR.
• Worked on custom qualifiers in Pricing/CHRM.
• Claim Automation for a custom process.
• Worked on PLSQL and AOL Objects.
• Worked on Offers, Claims and Budget APIs.
• Customized Workflows.

Confidential, Newark, CA

Oracle Techno Functional Analyst/Developer

Responsibilities:

• Oracle Channel Revenue Management (CHRM) (Trade Management), Advance Pricing, Order Management (OM), PO, AP, AR, I-Store, P2P and O2C.
• Development, Functional setups and RICE components.
• Performed Advance Pricing Setups (Pricelist, Modifiers, Qualifiers, Formulas) and also Pricing attribute setups and mapping.
• OCRM Setups, Approvals setups.
• OCRM budgets, offers and claims creations.
• WebADI Upload Customization for budgets, offers and claims.
• Offer,claims,budgets Conversion from legacy systems. (Conversion Lead).
• Oracle Pricing Conversion.
• Developed custom process to load Pricelist, modifiers and qualifiers using Pricing API’s (QP).
• Worked on Oracle I-Store and Pricing Integration.
• Performed Multi-Org (MOAC) setups.
• Created Custom responsibilities and performed security setups.
• CVS upload to process offers and pricelists.
• Worked on Multi-Currency Pricelists and Restricted Pricelist’s to responsibilities.
• Worked on various offer types (On-Invoice, Accruals, Lumpsum).
• Customized reports and Built SQL for Ad-Hoc reports.
• Worked on PLSQL, packages, procedures, and functions, UTL FILE, SQL Loader and OAF.
• OCRM Claims Interface to AP and AR.

Confidential, Bellevue WA

Oracle Techno Functional Analyst/Developer

Responsibilities:

• Provided techno-functional leadership in development, conversion, enhancements and bug fixes.
• Worked on P2P Cycle.
• Worked on AP, PO, I-Expense, I-Procurement, Suppliers and payments.
• Gathered business requirements and provided solutions of conversion project between Confidential and sprint.
• Worked on customizing Accrual reconciliation report.
• Extracted all attachments of AP, PO, I-Expense, Suppliers and payments to a service location.
• Extensively used UTL FILE to extract attachments from database (LOB files).
• Created new and registered new custom concurrent programs, packages, procedures and functions.
• Used FND LOAD to migrate from one instance to other.
• Worked on grants and user roles to provide business users access to tables to run their SQL.
• Worked Discover reports.
• Worked with OAF for I-Expense and I-Procurement (Personalization and Extension).
• Worked on Offers and discounts.
• Collaborated and interacted with offshore teams.
• Created technical and functional documents (MD50, MD70).
• Worked on issue tracking systems JIRA and ServiceNow and used code repository SVN.
• Worked on Approval workflows.
• Created SQL scripts for data fixes.
• Worked on Custom AP Invoice Upload Program, custom supplier record attachment program and custom
• Developed custom reports for conversion to match supplier, invoice, po etc with extracted attachments.
• Worked on custom shipment reconciliation report.

Confidential, Norristown PA

Oracle Techno Functional Analyst/Developer

Responsibilities:

• Provided techno-functional leadership has a production support analyst on Sales and SCM side.
• Worked on Q2C (Quote to Cash), O2C and P2C Cycles.
• My role involved interaction with Client, End users, and Technical team, scheduled meetings on regular basis and followed up the progress of work with offshore team members.
• Mainly overseen a Custom Quoting Application fully developed with OAF technology.
• Worked on Salesforce.com and Oracle Integration.
• Customized objects, profiles, security, Tabs (applications) and maintained users in salesforce.com
• Worked on data syncing between salesforce.com and oracle EBS.
• Expertise in administrating Accounts, Leads, Opportunities, Quotes in salesforce.com
• Worked on customizing applications using OAF technology.
• I worked on all OAF components like VO, EO, AM and CO for developing OAF pages.
• Created pages, regions, and updated records, developed navigation in OAF.
• Worked on user personalization, half page rendering in OAF.
• Worked on creating and calling XML/ BI publisher PDF's from OAF pages.
• Used Pricing API’s to get pricing calculations for quotes and to create new pricelists.
• Worked on BRMS (Business Rules Management System) on SOA to provide promotions (Discounts) to quotes.
• Custom program to upload pricelist’s (Adv. Pricing) via csv upload and created customized forms for this process.
• Worked on I-Store.
• Worked on custom workflows and OM workflows, Approval workflow and AME.
• Worked on XML Publisher and Adobe Acrobat Professional for developing custom PDF forms.
• Worked on CRM, a custom program to create Sales Rep’s (JTF tables) and also updating sales-rep information from HR tables based on hierarchy.
• Used Oracle Configurator to configure items in custom applications.
• Used Web ADI to upload custom requirements like approval rules, approvers, etc.

Confidential, Dallas, TX

Oracle Techno Functional Analyst/Developer

Responsibilities:

• Worked for Development and Production support of modules PA, AP, AR, GL, OM, INV, modules and P2P, O2C Cycles.
• Involved in the day-to-day issue resolving and Month end closing process for various modules.
• Worked on critical GL Close and accounting reconciliation issues.
• Developed, implemented and tested Payables interface to import invoice information from a Third Party system into Oracle Application tables.
• Customized Auto Invoice process for AR and Invoice Printing.
• Worked on implementation and integration between PA, Order Management and AR.
• Involved in R12 upgrade for various modules like Payables and Receivables.
• Created projects using AMG API's
• Was a key developer in the re-writing the third party order system Interface to accommodate new changes with oracle OM.
• Designed and Customized Journal Import interface to import journals from Sub ledgers and other system.
• Customized AP Trial Balance Report, RFQ report, PO document and various reports in GL, AP, AR, PO, OM and INV using XML publisher and also worked on check printing process.
• Worked on Bank Statement Interface in Cash Management
• Used Form Personalization to zoom out PA Projects Form from AP Invoice screen, to run Concurrent program from RFQ screen and to Display various Messages for different forms based on user requirement.
• Customized, personalized and extended I-Procurement (OAF).
• Worked on AP interface to import Expense Reports into AP.
• Worked on TCA API’s (Customer Conversion).
• Extensively utilized the Application Object Library to register SQL*Loader programs, PL/SQL packages and procedures, forms and reports.

Confidential, Dayton, OH

Oracle Techno Functional Analyst/Developer

Responsibilities:

• Working on TCA API’s for complex AR Customer conversion.
• Designed and developed Journal Import interface to import journals from legacy system. And run a Journal import to populate data into base tables.
• Imported data from legacy system into Oracle Receivables using Lockbox and also involved in the daily Interface process of splitting the bank file to feed Auto lockbox and cash management.
• Developed an Interface program to load the invoices data from flat files into oracle payables which Validates the data using PL/SQL program and populated the Payables interface table through a Concurrent program, which in turn submits a standard Payables Interface program.
• Worked extensively on creating templates using XML publisher (BI Publisher) for Checks printing using various templates (RTF).
• Designed and developed Purchase Order requisition interface to load PO requisitions from a homegrown System in to purchasing interface tables.
• Worked on Purchasing Documents Open Interface to import Standard PO, Blanket PO into the PO Module using SQL*Loader and PL/SQL.
• Developed an Interface to Import Sales Orders to Oracle Order Management using Interface tables. Involved in creation of MD70 and technical data mapping.
• Worked on Purchase Order Workflow.
• Worked on I-Procurement.
• Worked on Item conversion as Items and Option classes.
• Documented all the work using AIM methodology. Created and updated MD50, MD70 and BR120 documents for all the Development work done.

Confidential, Jersey City, NJ

Oracle Techno Functional Analyst/Developer

Responsibilities:

• Developed and maintained AP invoices interface, spreadsheet upload for AP invoices.
• AR functional setups, customer conversion and Invoice interface (Auto Invoices).
• Worked extensively on Employee interface from a HR repository to oracle.
• Done historical invoice and payment conversion for all the Mergers.
• Worked on AR Invoice approval, High dollar Amount WF and INV custom report.
• Done the Supplier Conversions and Mergers using MS access database, PL/SQL packages and Vendor API’s.
• Worked on employee to Vendor conversion.
• Functional Testing for PATCHES, Health Checks.
• Worked on custom forms and reports.
• Worked on generating 1099 report using API’s.
• Developed many programs using UTL FILE, FTP scripts and DB links.
• Created new responsibility to be used only by the Invoice Gateway users.

Confidential, Houston, TX

Oracle Techno Functional Analyst/Developer

Responsibilities:

• Worked on Project Security Extension customization for oracle projects.
• Know in detail the data flow from AR/AP to GL.
• Developed various discoverer reports for Project Accounting, HR, AP and PO modules including crosstab, matrix style reports.
• Developed custom form for Packing slip.
• Developed GL Detail report and AP multi-currency Tax report.
• Worked extensively on Procure-to-Pay and Order-to-Cash cycles.
• Worked closely with the Clients from various countries for all the above developments.
• Worked on discoverer admin/desktop/plus and viewer including setups of EUL, Business Area and sharing, registering functions and user grants.
• Created new reports and Customized the standard reports in AP like
• Suppliers report, Payment status report, Invoice validation report, Payment batch control report, Invoice aging report, Aging 7-buckets report and Invoice On-hold report.
• Customized the standard forms in AR using custom.pll to make some fields required or to disable fields as per the business requirement.
• Implemented business group level security rules on the discoverer reports for Projects and HR invoking custom Security Profiles.
• Worked on MD50, MD70 and BR120 documents for all the Development work done.

Confidential

Oracle Developer

Responsibilities:

• Written PL/SQL Stored Procedures, Functions and Packages and Triggers to implement business rules into the application.
• Generated SQL Scripts and created views for reports.
• Written PL/SQL code for packages, procedures, functions, triggers and views.
• Widely Used Decode Statements to Implement if-then-else Functionality in SQL
• Involved in Data Extraction using UTL FILE using PL/SQL.
• Involved in data loading. Used SQL*Loader to load data into the database using pl/sql.
• Developing system Triggers and stored Procedures to implement business rules.
• Created indexes to improve the system performance.
• Developed Forms using Forms 6i based on Business Requirements.
• Prepare technical documents for all the programs developed & generated.
• Responsible in coding, trouble shooting and debugging.