SUMMARY

• More than eleven (11) years of experience in design, coding, testing, customization, conversions, and interface of Oracle EBS 11i and 12i applications
• Experience developing business solutions in Oracle applications financials and supply chain related modules including AR, GL, AP, PO, AGIS, OM, INV, SLA, AME and other system admin related activities
• Strong technical skills in developing solutions via Oracle Forms 6i/10g/11g, XML Publisher, Oracle Reports 6i/10g, SQLPLUS, PL/SQL, SQL* Loader, Oracle Workflow Builder and D2K Translation builder, UNIX shell scripting, OA framework development and extension
• Strong programming experience with procedures, APIs, packages, functions, triggers views, collections, records, sequences, materialized views, constraints and other database objects using SQL and PL/SQL
• Proficient with user set up, defined responsibility value sets, flex fields, profile options, request sets, and registered forms, tables, menus, reports and concurrent programs
• Experience in teh entire Software Development Life Cycle (SDLC) including analysis and requirement gathering, design, development, testing, deployment and implementation of solutions in EBS applications
• Provided out of box solutions to match and exceed user expectations in implementing teh business rules
• Experience providing technical and functional support for daily/month end tasks of an Oracle EBS application
• Worked with Oracle support in TAR/SR management and coordinated patch (both GDF and regular) implementation by working with DBA/infrastructure teams
• Experience resolving time bound critical issues during month end
• Created Oracle EBS development related documents like MD50, MD70 and T120 documents using AIM methodology

TECHNICAL SKILLS

Programming: SQL, PLSQL, UNIX Shell Scripting, XML, XSLT

EBS: Versions11.5.9, 12.1.3, 12.2.4

EBS Modules: AR, AP, GL, PO, OM, AGIS, INV, XLA, AME, i - Supplier, Collections

Oracle Databases: 9i, 10g, 11g, 12c

Tools: Oracle Forms 6i/10g/11g, Oracle Reports 6i/10g, BI Publisher, SQL Toad/Navigator, JDeveloper

PROFESSIONAL EXPERIENCE

Oracle EBS Developer

Confidential, Jacksonville, FL

Responsibilities:

• Developed GL funds inquiry forms which displayed teh available funds for teh selected account combinations
• Developed Oracle GL account inquiry forms such as teh Oracle standard GL account inquiry form
• Teh development is done with an historical database where teh inactive data is present and is unable to move to new instance
• Forms and Reports developed retrieved teh data from historical database using Oracle DBLink
• Designed and developed new tables and views in teh new custom instances to retrieve teh information from historical database
• Developed custom packages derived following values from teh historical database using dblink
• Provided GL code combination description
• Re-implemented SRW FND FLEXIDVAL user exits to retrieve key flex fields values and used teh same in reports developer
• Retrieved lookup meanings from AR and FND Lookups
• Designed KFF segment blocks in Form 10g development for displaying KFF values for querying purposes in GL FUNDS and GL account inquiry replica form
• Developed custom views to retrieve data from historical database using dblink for teh AR collections form replica in new instance
• Developed custom AP invoice forms along with payment information using custom views to retrieve data from historical database

Environment: Oracle 11g, Oracle EBS R12.1.3, Oracle Forms 10g, Oracle Reports 10g

Lead Oracle EBS Techno Functional Consultant

Confidential, Columbus, IN

Responsibilities:

• Served as a technical team lead for a team size of six and delivery contacts for teh Oracle applications
• Directly coordinated with central business users and business IT users on a day to day basis
• Primarily involved from teh phase of requirement analysis and design until teh implementation phase of release management into production
• Prepared teh technical design document and unit test case plans as per teh functional specifications stated for individual book of work/change requests
• Provided Infant care production support for rolled out releases and ensured smooth month end closures
• Developed PLSQL programs to import Purchase Orders from plants to central financial systems on a regular basis
• Developed PLSQL program to import PO pre-approved receipts from plants to central financial systems on a regular basis
• Developed PLSQL programs to import AP customer invoices from teh suppliers
• Developed reconciliation reports between plants and central financial systems using Oracle reports 10g/BI Publisher
• Designed and developed custom auto match programs for matching teh supplier invoices against teh PO and receipts already imported to systems
• Designed and developed custom PLSQL programs to create automatic receipts for inter-company AGIS AR invoices based on payments of AGIS AP invoices
• Developed inbound interfaces for AGIS batch creation and customization of transfer programs of AGIS batch to AR and AP
• Imported items from teh legacy systems like developed interface programs to import items from teh legacy system to Oracle inventory by creating staging tables
• Developed suppliers interface import program
• Provided production support for implementing PO, AP, AR, AGIS and GL modules
• Developed UNIX shell program using SFTP command for teh transfer of payment files from teh financial server to another EDI server for processing teh supplier payments
• Provided support in reconciliation during period end closing
• Handled service requests (TAR) logged against Oracle corporation
• Developed teh custom OAF pages for teh business users to manually match programmatically unmatched supplier invoices against PO/receipts
• Coordinated with teh offshore teams throughout teh delivery phase
• Optimized code for performance tuning

Environment: Oracle 11g/12c, Oracle EBS R12.2.4, Oracle Forms 10g/11g, Oracle Reports 10g, BI Publisher, Unix shell scripting

Oracle Techno Functional consultant

Confidential

Environment:

• Developed inbound interface program for teh creation of blanket releases instead of standard Purchase Orders (PO)
• Created or enhanced INV, OM, PO modules setups according to teh business requirements
• Performed troubleshooting Oracle production issues reported by business users through tickets or other requests through Remedy ticketing tool
• Customized teh PO approval workflow
• Worked with AP teams to reconcile AP with general ledger by running accounts payable trail balance report, posted invoice register reports, posted payment register reports and unaccounted transaction reports
• Developed interface program to import sales orders from teh external system to Oracle apps OM
• Developed Oracle AR customer import interface to import party (customers, addresses, sites, payments, bank accounts) data into teh system in accordance with Trading Community Architecture (TCA)
• Developed BI publisher reports related to customer/supplier payments
• Provided technical design, development and support for "Order to Cash (OTC)" and "Procure to Pay (PTP)" business processes
• Used teh totals/subtotals/groups/sort features of BI publisher to make data intense operations happen at teh template level
• Responsible for providing techno-functional support for teh Oracle applications for AR, INV, AP, PA and OM modules
• Customized AP supplier OAF pages in accordance with teh business requirements
• Developed teh custom auto-match process as per business rules to match supplier invoices against PO and/or receipts based on source of teh invoices
• Developed teh new OAF pages for custom business applications
• Used OM API's to import teh orders from teh legacy system to process teh orders
• Developed a program which provides UDK and credit card authorization files in pre-defined format to adhere to SEPA payment format with teh European Unions
• Developed teh complex UNIX shell programs to transfer generated payment files from teh user server to respective bank servers using SFTP while adhering to PCI DSS standards
• Resolved a high number of production support tickets/work orders with a very quick turn-around time
• Modified several customized reports using XML/BI Publisher like credit/debit memo report, invoice history, invoice aging, pre-payment status, and invoice on hold reports as per changing teh business needs
• Developed reconciliation reports using BI (XML) Publisher with AP, AR, GL, OM, PO modules to facilitate teh users validating teh interfaced data
• Prepared functional and technical design documents for teh new database staging area applications
• Designed and developed teh custom programs to import invoice data and scheduled teh programs, provided statistics to users on teh completed programs in teh Oracle 11g database without any application server
• Designed and developed custom invoicing forms to records, hold, approve, account and transfer teh invoices via custom responsibility to Oracle EBS financials
• Developed teh custom reports as per teh business rules for custom business applications
• Developed interface to transfer data from custom responsibility to financial modules AR/AP
• Replicated cashbook applications to perform cash transactions recording, cash maintenance, and monthly reporting for teh same

Environment: Oracle 10g/11g, EBS R12.1.2, Oracle Workflow Builder, UNIX Shell Scripting, JDeveloper, Remedy