SUMMARY

• Over 11 years of experience in Oracle Applications as Oracle Techno - Functional consultant/Developer.
• Expertise with technical and functional understanding of Oracle Payables (AP), Receivables (AR), General Ledger (GL), Fixed Asset (FA), Cash Management (CM), HRMS, Purchasing (PO), Order Management (OM), Inventory (INV), Advanced Pricing, Oracle Loan, e-Commerce Gateway, XML Gateway
• Experience with technical and functional understanding of, Warehouse Management (WMS), CRM, Install Base (IB), Project Contract, Service Contracts (SC), Project Accounting (PA), Grants, Billing, Costing, ADI, AME, iProcurement, iExpense, iPayables, iReceivables & iSuppliers
• Expertise in Analysis, Implementation, Design, Development, Customization, Upgrade, Integration, Testing and Support of Oracle applications
• Expertise with the Multi-org and Multi Currency and Trade Community (TCA) Architecture
• Expertise in Design and Development of Data Interfaces & Conversions from legacy systems. Developed over 10 Master/8 Transactional Conversion & 25 Interfaces
• Expertise in designing and creating Oracle Forms and Reports. Developed/Customized over 70 Reports, 30 Forms & 11 Workflows
• Experience in extending self-service applications using OA Framework (OAF), Expertise in XML, BI publisher and Oracle Report builder, Experienced in Oracle Application Express (APEX) (HTML-DB)
• Experience also includes 5 full life cycle implementation project which includes Procure2Pay, Order2Cash and Manufacturing Cycle
• Experienced with Service Oriented Architecture SOA/BPEL, Application Development Framework (ADF), ETL and Oracle Data Integrator 10.1.3.5.0
• Creative and quick in learning new technologies. Conversant with OBIEE, EDI, DBI, scheduling tool UC4/Automic Automation Engine and Data warehousing (Informatica) concepts
• Excellent understanding of AIM methodology. Designed and developed CV010, CV050, CV060, CV070, MD-50, MD-70, PT050, PM010, BR100 documents
• Extensively involved in writing procedures, triggers, functions, packages (PL/SQL), UNIX Shell Scripting
• Extensive experience with best practices for configuration options, optimizing application user friendliness, performance and expediting month-end close and minimizing maintenance cost

TECHNICAL SKILLS

Core Knowledge Areas: Oracle Applications RICE Components, AOL, API (Financial/ Supply Chain/MFG) and System administration, OA Framework(OAF)

E-Business suite Modules: GL, AP, AR, CM, FA, OM, INV, PO, Pricing, PA, AME, Adv Pricing, iProc, iExpense, iReceivables, iSupplier, HRMS, e-Commerce and XML Gateway

Tools: Oracle Application Server (OAS), Oracle Developer10g (including Forms6i/9i/10g and Reports6i/9i/10g), XML Publisher, Oracle Application Express (HTML-DB) APEX, SQL*Plus, SQL*Loader, SQL*Net, ERWIN, Query Builder, Oracle Discoverer 10g, 4i, Designer/2000. Oracle Workflow 2.6, Oracle Alerts, Kintana, TOAD, Clear Case, Clear Quest, AppWorx, BI Publisher, Oracle Jdeveloper 10g, Oracle Data Integrator 10.1.3.5.0 , ETL, UC4/Automic Automation Engine, Data Loader, PVCS, WinCVS, Putty, WinSCP, SOA, BPEL

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

Programming Languages: SQL, PL/SQL, Java (J2EE), Javascript, XML, CSS, HTML,AJAX, COBOL

Office Applications: PowerPoint, Excel, Word, Visio, MS Office, MS Project

Platforms: HP-UNIX, IBM AIX-UNIX, Windows NT/2000/XP/7, Solaris

Oracle ERP: 12.1.3, 12.1.1, 12.0.4, 11.5.10.2, 11.5.9, 11.0.3, 10.7

PROFESSIONAL EXPERIENCE

Confidential, Mahwah - NJ

Techno-Functional consultant/Oracle OAF Developer

Responsibilities:

• Involved in full life cycle Implementation of Procure2pay, Order2Cash & MFG Cycle.
• Developed conversion program for AP supplier, supplier sites and contacts
• Developed conversion programs to load the Customer data into oracle receivables by using Customer Interface and created packages for General ledger (GL) journal interface load
• Open Sales Order data conversion using the interface program ‘Import Order’
• Developed conversion program to load Inventory Item Master data
• Designed Conversion program of Item Usage and Inventory On hand Quantity from the legacy system
• HR employee data conversion programs to load employee data from the legacy system
• Developed conversion program to Import Open Purchase Orders from Legacy System Interfaces
• Developed interfaces for Bank Reconciliation and Positive Pay transactions through Oracle Cash Management (CM)
• Designed interface program for General ledger (Journal) information to Hyperion for Reporting & GL Upload from iExpense interface
• Implemented Auto Lock Box for receipts processing by importing data into staging table by writing control file according to bank transmission format
• Worked on Ship Confirm interface, Material transactions interface & Receiving Transactions interface
• Developed inbound interface program on StoreNext (EDI) - Sales Order using XML Gateway
• Developed outbound interface program StoreNext (EDI) - ASN using XML Gateway
• HR employee Interface to load data from Global HRMS data sub systems
• Designed interface program to Serial Number Extract from Oracle to Reporting DW
• Worked on EDI interfaces for CAP Process (850, 855, 856, 944), Replenishment Process (850,855,856), Usage Process (750,855,944), Overstock Process (940,944)
• Loaded mapped data through Oracle e-Commerce Gateway in PO HEADERS INTERFACE, PO LINES INTERFACE, RCV HEADERS INTERFACE, RCV TRANSACTIONS INTERFACE OAF/SOA/BPEL
• Customized the iExpense page in Oracle iExpense. This involved OA Framework (OAF) changes to a couple of pages
• Personalized many OAF pages in iExpense, iProcurement, iSupplier & iReceivable modules. Worked with DBA/Security team on setups for iReceivable module over DMZ
• Designed and coded a new self-service HRMS page to show vacation accrual details for a given date. This was done using OA Framework (OAF)
• Developed a bridge between third-party software called ValSpeQ and Order Management. This included building an OA Framework screen to import an XML file and PL/SQL logic to validate and create sales orders using the OM public APIs
• Created PO Approval hierarchy as per user requirements. Configured the workflow for requisition and PO approval including configuring the workflow process, mailing notifications and setting the profile options for iProcurement and auto creation of purchase orders during requisition import
• Customized iProcurement Requisition OA pages such as Requisition Home page, Requisition Search page (ExpSearchPG.xml). Customized different regions in Home page and Search page
• Implemented ADI and Oracle Financial Analyzer (OFA) with the web interface and set up the OFA GL Link as the client used OFA for financial statements, management reports and budgeting
• Design and Develop complex error reporting interface with systematic notification across Enterprise and legacy applications using pl/sql, BPEL process and BAM.
• Define WSDL for SOA/ BPEL process, partner links, BPEL process templates and developed process logic definition.
• Built SOA composites using BPEL components that exposed some EBS sales order processing functions as web services accessible by all technology platforms in the enterprise through SOAP/WSDL interface
• Worked on the custom approval process for the custom application Order Entry Transaction application using SOA, the BPEL Process Manager 10.1.3, BPEL Designer, XQuery, XSQL Reporting
• Customized existing Oracle reports to provide customized versions of Check Payment Files, Check Remittance Files and EFT Payment Files
• Developed many Complex Ad-Hoc reports (Standard & Matrix report) using Report 9i and CFD (Customer Facing Documents) using XML Publisher including the Check Print
• Developed Tabular Form, Control Form Layout, Parameterized Report, Drill Down Report and Mater detail PDF report using APEX
• Created various complex Matrix report and Label report using Oracle report builder
• Other Customization & Troubleshooting:
• Worked on iExpense production fixes such as duplicate lines for AMEX transactions, incorrect mileage adjustment for second expense report for the same user in the same period
• Handled customer issues pertaining to Auto Invoice Interface, Auto LockBox, imported Standard invoices, Credit memos and Debit memos to Oracle Receivables (AR) etc
• Customizations of iProcurement Workflows like PO Requisition Approval, PO Document Creation, Account Generator, PO Send Notifications, Confirm Receipt workflows.
• Worked on approval rules based on invoice amount for the following transaction type Payables Invoice Approval using Approval Management (AME) and configured action types and actions
• Carried out EDI Gateway implementation for catalogue import and defined the code conversion values between the external suppliers system and Oracle Applications
• Carried out initial catalog import and defined the mappings between catalog service providers and Oracle Purchasing. Setup various Account Regions, Procurement cards, attachments, catalog types, internal and external source catalogs. Performed application set up for AP and PO
• Created template expense reports, enabled descriptive flexfields in the Excel spread sheets, customized documentation and messages by modifying the standard help files for the self-service expense module. Customized the Workflow process of expense reports by modifying existing procedures and developing new procedures in the Web Expense PL/SQL packages
• Customization in Standard PO Blanket Purchase Agreements, Planned and Contract PO, Auto creation of PO program
• Optimized performance measures for Auto Invoice process using System Options setups
• Form Personalization, workflow customization and Custom.pll changes in GL, AP, AR, PO, INV & OM forms in the new R11 instance
• Wrote many Oracle Alerts to help manage data files and to notify users of automated tasks that have taken place. Customized several AR and GL reports according to the user specification specifications
• Development custom application with EBS authentication & authorization using various APEX APIs like APEX ITEM, APEX UTIL, APEX MAIL, APEX APPLICATIONS, APEX PLSQL JOBS, APEX CUSTOM AUTH
• Developed UNIX shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application. Developed automated FTPs using PLSQL.
• Worked on consolidating the legacy data using the Oracle Data Integrator 10.1.3.5.0
• Developed data fix scripts for GL, AP, AR, PO, OM, INV identifying the issues related to Invoices that are stuck in the interface table
• Designed and developed the CV010, CV050, CV060, MD-10, MD-70 documents for the Conversion/interface programs
• Involved in the implementation of job scheduling tool UC4/Automic Automation Engine
• Migrated various Oracle forms and reports from legacy system using the oracle Applications express form converter
• Performance tuning of the application programs using EXPLAIN PLAN, TKPROF and SQL TRACE

Confidential, Richardson, TX

Techno-Functional consultant/Oracle Developer

Responsibilities:

• Developed conversion program to load Inventory Item Master data
• Developed conversion program for AP supplier, supplier sites and contacts
• Data import through Standard Auto Invoice Program, testing and troubleshooting
• Work on the ACH payment processing program, NACHA format was used with JPMC
• Inventory On hand Quantity data conversion
• Advanced pricing price list data conversion from the legacy system using the standard QP Bulk Import interface program
• Open Purchase Order data conversion from legacy system
• Open Sales Order data conversion using the interface program ‘Import Order’
• Developed a bridge from the Legacy system to the Oracle FA Mass Additions open interface.
• HR employee data conversion programs to load employee data from the legacy system BAAN and D1 using the HR APIs
• Configured the set ups and validated the set ups in core purchasing and iProcurement modules and carried out end to end integration between iProcurement and GL modules
• Supervised the customization of Oracle iSupplier Portal using Oracle Applications Framework (OAF)
• Implemented an integrated iProcurement module AP, PO for providing web enabled inquiries for merchant purchase orders, inventory availability and vendor purchase orders.
• Involved in review of functional requirements and wrote technical design for Integration with Oracle Iprocurement
• Worked on customizing approvals using Oracle Approval Management (AME)
• Developed customized Oracle Sales Online Application OAF pages by customizing different fields in Basic Information Region, Financial Information Region, and Profile Information Region in Customer Overview Page (OrgViewPG.xml) of Sales Online module.
• Designing and implementing the data conversion methodology to bring Installed Base (IB) instances and Service Contract (SC) from a legacy system into the Oracle application. Designing an interface to send entitlement information from SC/IB Oracle to Legacy so those can be used by the support organization to verify a customer’s right to support
• Worked on synchronization related issues of PA/Grants and GL
• Resolved Grant Management/Projects conversion errors.
• Designed and developed the master and transactional conversion technical document CV050, packages, control files, LDT files
• Developed Tabular Form, Control Form Layout, Parameterized Report, Drill Down Report and Mater detail PDF report
• Worked on Javascript APIs, CSS and AJAX to provide the client side functionality
• Created stacked bar chart and Worked with check boxes, button and list of values
• Involved in development and Unit testing for Puchout cart Return Outbound Interface. Involved in doing setup for Punch-out cart return
• Developed on the People Soft to Oracle HRMS interface to load the employee information on regular basis
• Worked on EDI interfaces for CAP Process (850, 855, 856, 944) & Replenishment Process (850,855,856)
• Integration, Packing and Shipping changes - Workflow Extension, Upload Prices and discounts for Purchasing - Custom PLL Extension, Automatic E-mail - PL/SQL program to e-mail reports
• Created complex Matrix report using report 9i, Developed many Complex Ad-Hoc reports (Standard & Matrix report) using Report 9i and CFD (Customer Facing Documents) using XML Publisher including the AP Check Print

Confidential, Edgewater - NJ

Techno-Functional consultant/Oracle Developer

Responsibilities:

• Data fix of issues related to Open interface Variable rent gateway using the standard APIs
• Developed the 3-Way Invoice Match Interface Program (Including Testing/Trouble Shooting)
• Developed the Custom Supplier Merge program which merge the supplier from 8 schemas to one
• Worked on testing and matching the AP Trail balance and GL posting after consolidation
• Worked on creating the interface to integrate Oracle Projects with Oracle Loans for the parent company Bain Capital in MA. Oracle Projects is used to first record every loan request as a project. Once the project is appraised and approved, the loan is sanctioned and Oracle Loans module was used to monitor the disbursement activities and repayment process
• Design and developed middle ware solution for interfaces using SOA/BPEL Process Manager and JDeveloper
• Customized the Login page using the Oracle Jdeveloper and Java Pluggable Component (JPC)
• Designed the high level and low level Oracle Account payables consolidation approach documents
• Developed the Account payables consolidation programs which consolidations the AP data from 8 schemas in 10.7 to one schema in 12.0.4 (Multi-Org)
• Created an interface from Oracle GL to SBT/GL transferring all posted SBT journal entries produced by the FA Mass Additions upload. A chart of accounts mapping was developed to support this process.
• HR employee data conversion programs to load employee data from the legacy system BAAN and D1 using the HR APIs
• Form personalization in the Recovery, Payment and Billing forms
• Developed a package that validates invoice information and load the invoices into AR by running Auto Invoice daily
• Worked on Project Costing and Billing setups and implementation
• Designed & Developed the Markdown Allowances Interface Program
• Designed & Developed the Vendors Compliance Interface - Invoice/Vendors
• Two Year data extraction script from 8 Account Payables schemas
• Form Personalization, Workflow Customization and Custom.pll changes in AP, AR, FA, PA, OM, INV & Loan module forms
• Optimized performance measures for Auto Invoice process using System Options setups
• Worked on customer issues pertaining to Auto Invoice Interface, AutoLockBox, imported Standard invoices, Credit memos and Debit memos to Oracle Receivables (AR)
• Worked on the PRG Interface - Payment/Vendors
• Created complex Matrix report and Label report using report 9i
• Developed the Export/Import Scripts to load data from legacy system 10.7 to 12.0.4

Confidential, Atlanta, GA

Techno-Functional consultant/Oracle Developer

Responsibilities:

• Responsible for the Vendor conversions from legacy data to Oracle AP
• Developed conversion programs to load the Customer data into oracle receivables by using Customer Interface
• Customized “PO Doc creation workflow”, “PO Approval & Requisition Approval Workflow” for iProcurement
• Developed many web based forms and interactive reports using oracle application express (APEX) for the custom Global Order Entry Tool (GOET) application
• Customized the Login page using oracle Developer in OA framework. With modification of the servlets
• Designed Conversion program of Item Usage from Legacy System
• Handled customer issues pertaining to Auto Invoice Interface, AutoLockBox, imported Standard invoices, Credit memos and Debit memos to Oracle Receivables (AR) etc
• Developed conversion program to Import Open Purchase Orders from Legacy System
• Developed conversion program to Import Sales Orders from Legacy System in 11i
• Designed Conversion program of BOM and Routings from Legacy System
• Interface program for shipment of serialized items
• Designing and coordinating all data conversion development/testing tasks (for Install Base IB instances with Counters, Warranties, Service Agreements, and Service Contract (SC) with Charges) and custom development items (e.g., Field Service Debrief customizations to facilitate data flow to order management (OM) and cost tracking)
• Customized existing Oracle reports to provide customized versions of Check Payment Files, Check Remittance Files and EFT Payment Files
• Involved in the Creation/customization of forms, reports and form personalization in AP, AR, MFG, OM, PO, INV. GL modules
• Developed Pl/SQL procedures & functions to support the reports by retrieving the data from the data warehousing application (Informatica)
• Developed data fix scripts for identifying the issues related to Invoices that are stuck in the interface table
• Developed custom programs, utilizes the standard Oracle order API to create and book orders, a program to process a flat file containing inventory (INV) and bill of material (BOM) data into the open interface tables to load these items utilized the standard Oracle API for Importing Inventory Items, Inventory Categories, and BOM
• Responsible for defining validation rules for ship confirm Interface. Also responsible for scheduling Ship confirms and Interface Trip stop concurrent programs in OM
• Designed and Developed Ad-hoc customer reports. Worked on XML Reports/ XML publisher
• Developed data fix scripts for identifying the issues related to employee, resource, and buyers
• Involved in the Period closing activities with functional and technical teams

Confidential

Oracle Technical Consultant

Responsibilities:

• Developed many forms and report for the custom application
• Conducted several Conference Room Pilot (CRP) and User Acceptance (UAT) Tests
• Developed import program to Import data from Legacy System (FoxBase) in 11i
• Preparing Detail Design Documents and Unit Test Cases
• Design and Development of Forms (Masters & Billing Screen) and Reports
• Creating backend Packages, Procedure and Functions in PL/SQL
• Integrating the Pluggable Java Component (PJC) with Forms
• Development and Deployment of Forms and Reports 9i on Application Server
• Unit, Integration and Performance Testing
• Registered PL/SQL packages and custom Forms, Menus and reports as concurrent programs
• Used SQL Navigator to reverse engineer the model of the legacy applications