SUMMARY:

• Over 15 years of Oracle Techno - functional Consulting experience in Oracle Fusion Cloud HCM, Oracle Apps eBS R12/11i developing RICEW components, requirements gathering, analysis, setting up Oracle EBS R12/11i with multiple full life cycle implementations, R12 Upgrades, 11i upgrades and supporting Multilingual, Multi Org projects.
• Extensive experience in developing and debugging RICEW (Reports, Interfaces, conversions, extensions and workflows) components in various financials modules(GL, AP, AR,CE, PA) Financial Accounting Hub (FAH), Supply chain modules( OM, Shipping, INV, PO), Order to Cash, Procure to Pay, CRM modules( Install base and Service Contracts) using Oracle SQL, PL/SQL, Forms, Reports and workflow builder
• Expert Developer in RICEW Components across O2C (OM to Receivables), P2P (Purchasing to Payables), Manufacturing, Financials, AOL and System Administration.
• Extensive experience in development and customization of forms, reports and PL/SQL using OAF (OA Framework) according to Oracle AIM methodology in Oracle eBS environment
• Wrote technical design documents like MD050 for extensions and data fixes.
• Extensive experience in implementation, migration, data conversion, upgrade and Oracle Postproduction Support in Oracle eBS R12/11i projects
• Strong experience in developing inbound and outbound interfaces
• Worked on multiple projects at a time
• Familiar with Web ADI
• Handled offshore team
• Extensive experience in developing reports using BI/XML publisher
• Experience in forms creation and customization using Custom.pll and Forms personalization
• Disable tab pages of PN form using forms personalization
• Used custom.pll to implement query find
• Troubleshoot apps problems using tools like TOAD, heat. Experience in writing unit test plans
• Strong SQL performance tuning experience
• Integrated Oracle Applications with third party tools
• Wrote Technical Design documents (MD070) according to AIM standard
• Coordinated production releases by creating Kintana packages to migrate code from DEV to TEST environment and helped DBAs to have it migrated from TEST to PROD environment.
• Worked on change management as migration coordinator.
• Excellent interpersonal, communication, presentation and customer relational skills
• Experience in requirements gathering from users, clients, understanding their requirements
• Experience in Agile project management methodology and story monitoring tool like Jira. Participated in daily stand-up meetings
• Conducted CRP/UAT/SIT sessions
• Experience in unit, system testing and writing test plans documents according to Oracle AIM standard
• Strong Conceptual, Business and Analytical skills
• Excellent communication skills
• Strong experience in writing code for stored procedures, functions, packages and database triggers using PL/SQL

TECHNICAL SKILLS:

Operating Systems: Windows XP/2000/NT/98, Unix/Linux

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

SKILL:

• Oracle Fusion Cloud HCM
• Oracle Applications R12/11i
• BI/XML Publisher
• Noetix (Qlick view)
• Oracle Reports 10g/6i
• Oracle Forms 10g/6i
• Oracle Discoverer
• Oracle Workflow Builder 2.6
• Custom.pll
• Forms Personalization
• API, Interfaces,
• Conversions, Migration
• Data Loader, SQL*Loader, Shell Scripting, Smart FTP, WinScp, Kintana (Version Control/code migration Systems)
• AIM methodology
• PL/SQL, C
• TOAD, SQL Developer
• Unix/Linux shell scripts
• Toad, VSS, Kintana, PVCS, UTL FILE, Oracle Developer 2000 including Forms 6i, and Reports 6i
• BI/XML Publisher, Oracle Workflow, Clarify, PUTTY, Remedy, Heat
• Oracle General Ledger (GL),
• Oracle Receivables (AR),
• Oracle Payables (AP),
• Financial Accounting Hub (FAH)
• Oracle Purchasing (PO), iExpense iProcurement
• Fixed Assets (FA)
• Cash Management (CE)
• HRMS
• Oracle Shipping (WSH),
• Advanced Pricing (QP),
• Order Management (OM)
• Oracle Inventory (INV),
• Work in Process (WIP)
• Project Accounting (PA)

PROFESSIONAL EXPERIENCE:

Confidential, Portland, OR

Oracle Apps eBS R12 Techno-Functional Lead

Tools: Forms 6i, Reports 6i, PL/SQL, Workflow, UNIX, SQL Loader, SQL Developer, TOAD, RICEW

Environment: Implementation/Production Support for of eBS R12.2.5/R12.2.8

Responsibilities:

• Designed and developed Credit exposure program for Customers
• Designed Material attribution tool using APEX
• Developed many reports using Oracle Reports/BI Pubisher
• Upgraded Oracle EBS from R12.2.5 to R12.2.8

Confidential, Denver, CO

Oracle Apps eBS R12 Techno-Functional Lead

Tools: Forms 6i, Reports 6i, PL/SQL, Workflow, UNIX, SQL Loader, SQL Developer, TOAD, RICEW

Environment: Implementation/Production Support for of Oracle Fusion Cloud HCM, eBS R12.2.4

Responsibilities:

• Created and updated Jobs in HRMS using HR JOB API.
• Developed AP Invoice upload program using SQL and PL/SQL
• Developed AP Credit cards outstanding items XML Publisher Report
• Gathered requirement for AR and AP module
• Set up AP and AR
• Developed item mass update program
• Created a notification for PA unbudgeted expenditures using user hook
• Created accounting rules and validation using Financials Accounting Hub (FAH) and integrated legacy or sub systems accounting rules with Oracle General Ledger.

Confidential, Bowling Green, KY

Oracle Apps eBS R12 Techno-Functional Lead

Tools: Forms 6i, Reports 6i, PL/SQL, Workflow, UNIX, SQL Loader, SQL Developer, TOAD, RICEW

Environment: Implementation/Production Support for of eBS R12.2.4

Responsibilities:

• Developed a custom tax adjustment program to adjust AR tax
• Developed Payment History and Active Vendors extract reports
• Modified a program to show up warranty SKU for firearm items
• Modified a cycle count program to enable cycle counting at subinventory level
• Modified a form to restrict users from updating shipping address for the orders they are not supposed to have access
• Modified the Statement Generation Program in AR to send e-mail from TST to internal distribution list.
• Converted existing XLS template report to RTF to include more data for SKU ranking for INV
• Created a program to show historical pricing as of a specified date
• Validate Available to Reserve quantity at sub-inventory level as well instead of DC level only
• Did setups like Transaction Types, Transaction Sources, Remittance Banks, Receipt Classes, Payment Methods, Customer Profile Classes, Accounting Periods, Transmission Format
• Customized aging 7 buckets report
• Involved in Customer Conversion to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them into base tables using TCA APIs.
• Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated into the Base Tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices
• Did forms personalization
• Wrote MD.070 document according to AIM standard
• Validated OM Setup for migration to TEST environment
• Created employee conversion program in HR

Confidential, Dallas, TX

Oracle Apps eBS R12 Techno-Functional Lead

Tools: Forms 6i, Reports 6i, PL/SQL, Workflow, UNIX, SQL Loader, SQL Developer, TOAD, RICEW

Environment: Implementation/Production Support for of eBS R12.2.4

Responsibilities:

• Developed a party relationship between VAR (Value Added Reseller) and their customers using API hz relationship v2pub
• Imported the VAR and Customers Relation Data in Oracle using SQL Loader
• Worked on a project in Receivables which e-mails and prints customers invoices using xml publisher bursting utility
• Did setups like Transaction Types, Transaction Sources, Remittance Banks, Receipt Classes, Payment Methods, Customer Profile Classes, Accounting Periods, Transmission Format
• Customized aging 7 buckets report
• Involved in Customer Conversion to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them into base tables using TCA APIs.
• Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated into the Base Tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices
• Did forms personalization
• Involved in month end closing activities
• Led offshore team in India
• Wrote MD.070 document according to AIM standard

Confidential, Phoenix, AZ

Oracle Apps eBS R12 Techno-Functional Lead

Tools: Forms 6i, Reports 6i, PL/SQL, Workflow, UNIX, SQL Loader, SQL Developer, TOAD, RICEW

Environment: Implementation/Production Support for of eBS R12.2.3

Responsibilities:

• Set up Fairchild Semiconductor (Shanghai, China) for Payment File Generation.
• Created Payment Format, Payment Template, Payment Method and Payment Process Profiles
• Modified Korean, Israel, Germany iExpense Template
• Performed the setups for Project Accounting, GL and AR
• Involved in month end closing activities
• Implemented Auto Lock Box by importing data into staging table by writing control file according to bank transmission format.
• Developed Interfaces to load the accrual data from Purchasing into PA and GL
• Used CUSTOM.PLL extensively to modify the functionality and implemented query find
• Uploaded BAI Transaction Codes in Cash Management tables
• Developed a Generic program in PL/SQL to read and load multiple bank files. Developed an import program from PL/SQL and scheduled it to run periodically
• Loaded a data file and imported bank statements in Oracle Cash Management for (US)
• Created and successfully tested the XML Payment file for UK and China. Created a MD070 Document for all the setups like Payment Format, Payment Template, Payment Method and Payment Process Profile

Confidential, Manhattan, NY

Role: Oracle Apps eBS R12 Techno-Functional Lead

Tools: Forms 6i, Reports 6i, PL/SQL, Workflow, UNIX, SQL Loader, SQL Developer, TOAD, DiscovererXML Publisher, BarTender Label printing, RICEW

Environment: Production Support for of eBS R12.0.6

Responsibilities:

• Created a new direct debit payment method for AP bank.
• Resolved an issue to correct the historical accounting entries from fixed assets which were failing to create accounting.
• Enabled AP invoice batch processing
• Did setups for AP
• Enabled bank screen to update Canadian bank affiliate code
• Resolved the issue of ACH Payment Batch which was on hold
• Generated blackline files for Journals attestation
• Resolved GL Consolidation Program duplicate batch posting issue.
• Resolved issue with discrepancies in GL55 detail journal listing report with the summarized US19B report
• Worked on FITS payables invoices interface to modify the interface program

Confidential, Buffalo, NY

Oracle Apps eBS R12 Techno-Functional Lead

Tools: Forms 6i, Reports 6i, PL/SQL, Workflow, UNIX, SQL Loader, SQL Developer, TOAD, DiscovererXML Publisher, BarTender Label printing, RICEW

Environment: Production Support for of eBS R12.1.3

Responsibilities:

• Worked on a project in Receivables which e-mails and prints customers invoices using xml publisher bursting utility
• Worked on month end closing issues
• Developed customer contact point interface/API to upload and update customer e-mail addresses
• Resolved Inventory value and GL discrepancy issue for Japan Ledger
• Created Blanket PA using PO interface
• Modified Oracle Discoverer report to show correct data
• Modified XML publisher report to show drop ship address and tracking number for an order. Bursted XML publisher report to generate a file at a server location to be picked up for processing to show order status
• Configured BarTender Label printing and resolved issues related to labels
• Worked on RICEW components. Developed a report Confidential bookings backlog
• Worked on many incident tickets for PO and AR
• Wrote MD070s technical design documents
• Fixed Payables interface errors
• Involved in Noetix reporting training. Created some Qlick view reports
• Created/Resolved many BarTender Labels

Confidential, San Francisco, CA

Oracle Apps eBS R12 Techno-Functional Lead

Tools: Forms 6i, Reports 6i, PL/SQL, Workflow, UNIX, SQL Loader, SQL Developer, TOAD, DiscovererXML Publisher

Environment: Implementation of eBS R12.1.3

Responsibilities:

• Worked for Luxembourg Office Closure project. Translated the functional document to Technical Design Document
• Designed Project plan, did unit, integration and system testing for this project.
• Setup GL and AR for this. Wrote MD050 and MD070 documents
• Developed GL and AR interfaces
• Created AR Invoices and Journals for this project
• Designed Project Plan and wrote MD070 according to AIM standard
• Set up new rules for AME in iExpense
• Created a package to define new rules for US and other countries for iExpense
• Modified an AP invoice import program to recalculate accounting date
• Developed an alert to notify stuck invoices in interface for AP
• Wrote documents using Oracle AIM methodology
• Worked on a project to calculate, invoice and account ad revenue using different processors for US and Ireland
• Supported DataMart activities
• Developed a new report for supplier bank accounts using Oracle Discoverer
• Wrote MD.0120(installation/migration document) and helped DBA in migration activities
• Wrote shell Unix scripts to populate staging tables using SQL*LOADER

Confidential, San Francisco, CA

Oracle Apps eBS R12 Techno-Functional Lead

Tools: Forms 6i, Reports 6i, PL/SQL, Workflow, UNIX, SQL Loader, SQL Developer, TOAD, DiscovererXML Publisher

Environment: Implementation of eBS R12.1.3

Responsibilities:

• Developed API in AR to create customers and customer contacts
• Did setups for system options, customers, customer sites, accounting rule, invoicing rule, lockbox etc.
• Designed and developed Payment Process request in AP
• Involved in month end closing activities
• Developed PO requisitions interface and PO receiving interface
• Generated a payment file for Australia and Ireland operating unit and FTPed to the bank server for validation
• Customized and created menus and assigned to responsibilities
• Created operating units for Australia and setup profile options (like security profile and hr: user type)
• Created XML publisher reports for AP
• Handled offshore team in India
• Converted invoices and suppliers from legacy system to oracle apps
• Developed bank statement interface in cash management
• Wrote documents using Oracle AIM methodology

Confidential, Sarasota, FL

Oracle Apps eBS R12 Techno-Functional Developer/Lead

Tools: Forms 6i, Reports 6i, PL/SQL, Workflow, XML/BI Publisher, EDI, UNIX, SQL Loader, SQL DeveloperTOAD

Environment: Implementation of eBS R12.1.1

Responsibilities:

• Designed and Developed Customer Items and Customer Items cross reference interface to assign a new unrestricted part/IPN to all active customers/distributors and to assign a new active customer/distributor to all unrestricted parts in INV
• Converted items, invoices and sales order from legacy system to oracle apps
• Designed project rollout plan
• Designed and developed Sales Order Notification to send a pdf report when an order is created, or its ship date is changed according to the technical design document MD070
• Customized order line workflow in order management to put a hold on an order line for specific product when the order is booked using PL/SQL
• Created pages using OA framework
• Sent PO to the supplier using EDI 850
• Conducted CRP/UAT/SIT sessions
• Customizes a mass change form in OM to change the values entered in DFF to Quick sales order form.
• Customized Cash receipts form to prevent duplicate receipts.
• Wrote a pl/sql package to send an email when price of an item changes or price across IPNs (Internal part Numbers) is different.
• The legacy system Ross was unable to receive items. Fixed an outbound PO interface for this.
• Customized and created many forms using forms personalization and custom.pll

Confidential, San Francisco, CA

Oracle Apps eBS R12 AR Lead Developer

Tools: Forms 6i, Reports 6i, PL/SQL, Workflow, UNIX, SQL Loader, SQL Developer, Kintana, TOAD, Agile Project Management Methodology, Story Monitoring tool (Jira), Oracle Discoverer

Environment: Implementation of eBS R12.1.3

Responsibilities:

• Worked with the client team in understanding their business process and prepared various requirement gathering and functional design documents Created new operating unit and set up AR in it
• Did setups like system options, customers, customer sites, accounting rule, invoicing rule, lockbox, remit to address, banks in AR for the regional inventory project for Confidential Franchisees
• Created two new operating units for UK. Wrote BR.100 and BR.110 documents for AR
• Wrote Quote Upload API to import quote from legacy system.
• Created Kintana packages to migrate from DEV to TEST environment and TEST to PROD environment and wrote the test cases documents
• Coordinated production releases creating Kintana packages
• Attended daily stand-up meetings and monitored stories using Jira
• Created Quarterly and Daily Quantity On-hand Extract for Reserve reports using BI Publisher in inventory module
• Designed and Developed Auto invoice inbound interface and using PL/SQL according to Oracle AIM design documents
• Wrote one-time PL-SQL programs to convert Recruitment data from various Legacy systems in HRMS
• Involved in IQN-Oracle Financials Integration Project to bring in timecards from IQN system into oracle PO and approve them and create payables invoices for those POs in Oracle Payables.
• Developed PO requisitions interface and PO receiving interface and customized PO approval workflow for this.
• Involved in Unit and system testing
• Customized and created many forms using forms personalization and custom.pll
• Designed a project plan showing phase (e.g. Development or testing), task, start date and end date for that task and percent complete on that date to deliver the tasks on time

Confidential, Oakland, CA

Oracle Apps eBS R12 Techno-Functional Lead Developer

Tools: Forms 6i, Reports 6i, PL/SQL, Workflow, OA Framework, UNIX, SQL Loader, SQL Developer, KintanaTOAD, Heat

Environment: Implementation/Upgrade of R12.0.3

Responsibilities:

• Wrote MD070 technical design document according to AIM standard and wrote code for the above form
• Involved in Unit and system testing
• Updated customers sites in AR.
• Imported vendors and vendor sites using suppliers’ interface
• Developed a PL/SQL package to calculate the commission for the pizza business sales representatives
• Customized Aging 7 buckets report in AR
• Did customization for Gross Margin split in GL
• Added a new column to a List of Values (LOV) in OA Framework
• Created Invoices in AR using Auto Invoice Program. Transferred this to GL using GL transfer program. Created a request set for this
• Created an outbound interface for GL coordinated with DBAs and team members to help migrate changes to production environment
• Fixed many issues in AR using ticket monitoring tool Heat
• Involved in month end closing activities
• Customized and created many forms using forms personalization and custom.pll
• Developed many reports using XML/BI Publisher. Created new reports and converted from rdf to XML/BI Publisher reports in BOM, INV