SUMMARY

• Certified Professional wif 8+ years of experience in functional and technical aspects of Oracle Applications.
• Implementation and technical expertise in Oracle Applications 12i/11i which includes General Ledger (GL), Accounts Receivables (AR), Accounts Payables (AP), Inventory (INV), Purchasing (PO), Shipping, Order Management (OM), Service Contracts, Fixed Assets (FA), Customer Data Hub (CDH), Warehouse Management Systems (WMS), Enterprise Asset Management (EAM), Installed Base, Advanced Pricing, iSupplier, iProcurement and iExpense modules.
• Good Knowledge on order to cash, procure to pay, cash management (CE) and quote to cash process.
• Good Knowledge on Trading Community Architecture (TCA).
• Strong technical development skills on RICEW components ( Reports, Interfaces, Customizations, Extensions and Workflow )
• Experience in Application System Administration like managing concurrent managers, application user setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports, concurrent programs, printers and providing support to business users for any technical and functional issues.
• Upgrading oracle systems to R12.
• Strong experience on Oracle Applications Frame Work (OAF).
• Strong programming knowledge in creating SQL, PL/SQL, Stored Procedures, Packages, Functions, Triggers and API.
• Exposure to UNIX shells scripting.
• Experienced in Data Mapping, Data Conversions and Interfacing.
• Experience working on Approval Management Engine (AME)
• Very good knowledge on interface programs to import data and convert data from legacy systems.
• Experience in designing and developing project plans for complete SDLC from gap analysis to post production support.
• Experience in preparing Test Plan, Unit Testing, System Integration Testing and Documentation.
• Extensively worked on Oracle Workflow 2.5, Discoverer 4i/ 10g, Reports 4.5/6i/9i/10g, XML Publisher and Forms.
• Customizing Oracle applications wif Custom.pll library to create new functionality to teh application.
• Experience in using teh tools like TOAD and SQL Navigator for Ad - Hoc Query development and database objects creation.
• Provided support for SIT (System Integration Testing), UAT (User Acceptance Testing) and Production Support.
• Experience in creating, managing and resolving TAR/SR (Technical Assistant Request/ Service Request) wif oracle support, managed and monitored TAR’s for several P1 issues.
• Good expertise using oracle software for applications design, development in a single and Multi-Org, Multi-Currency environments.
• Extensively worked on AIM (Application Implementation Methodology) documents like MD50, MD70 and MD120.
• Excellent verbal and written communication skills, exhibited a consistent performance and ability to work as a team member or as an individual.
• Knowledge on Oracle SOA BPEL Monitoring and Services.
• Demonstrated good leadership skills wif inspirational attitude wif result oriented approach.

TECHNICAL SKILLS

ERP: Oracle Financials and Manufacturing Applications (Purchasing, Inventory, Work in Progress, Bills of materials, General Ledger, Accounts Payables, Accounts Receivables, Order Management).

Languages: PL/SQL, SQL, C, Java

Database: Oracle 8i/9i/10g, MS Access

Oracle Tools: Forms 6i/9i/10g, Reports 6i/9i/10g, SQL*Loader, TOAD, SQL Navigator, SQL*Plus, Optio7.8, Discoverer-4i and XML Reports-5.6.3, Web ADI.

Operating Systems: Windows 98/NT/2000/XP/2007/VISTA, UNIX, LINUX, MS-DOS.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Oracle Technical/Functional Consultant

Responsibilities:

• Oracle R12 Procure to Pay (PTP) Techno Functional Consultant responsible in Coordinating Offshore team of 5 Team members, scheduling daily/weekly status call and tracking teh PTP RICEW (Reports, Interfaces, Conversion, Extensions and Workflow) Components.
• Responsible in Coordinating wif Project Manager, Business Leads and Functional Owners to gather requirement for all RICE Components.
• Designing Technical Specification, Build, Unit Testing, Customization and SQL/PLSQL Tuning of Oracle Applications 11i and R12 Procure to Pay Modules (AP,PO, Cash Management (CE), iprocurement and iexpenses).
• Involved in teh design of AIM (Application Implementation Methodology) documents (MD50, MD70) for all teh RICEW (Reports, Interfaces, Conversions, Extension and Workflow) Objects.
• Implemented teh Payables Open Interface. Activities involved creation of Loader File, importing Invoices into teh interface tables using SQL*Loader and tan using Payables Open Interface to import teh data into teh Base tables.
• Developed a Supplier Conversion to load Suppliers data into Oracle Supplier base Tables by loading teh data and validating teh data using PL/SQL and tan loading into teh vendor information tables.
• Involved in teh design of AIM (Application Implementation Methodology) documents (MD50, MD70) for all teh RICEW (Reports, Interfaces, Conversions, Extension and Workflow) Objects.
• Responsible for creating New Forms, Form Personalization, Reports Customization, RTF/XSL-FO template creation.
• Designed MD70 Technical Design Document, Development for PO Requisition Work Flow Approval Management Engine (AME).
• Developed Vendor Conversion Reconciliation Report for teh Conversion Process
• Involved in teh development of Purchase Order interfaces/ Conversions to import teh data from legacy system into oracle application base tables.
• Designed and developed a custom PO Output for Communication Report for teh Standard, Blanket, Blanket Release and Contract Purchase Orders according to teh business requirements by customizing Standard XSL-FO style sheets.
• Customized teh Oracle Standard Check Template according to teh business requirements and made required setups for Check Printing. Changed and fine-tuned teh template to generate checks by placing MICR font, Digital Signature on teh preprinted watermark paper.
• Designed and developed custom packages, triggers and procedures.
• Worked to improve teh performance of teh system by tuning and restructuring PL/SQL units for optimum performance.
• Designed and developed PL/SQL concurrent programs, Oracle Forms, Oracle reports.
• Customized and modified teh existing forms using Form builder according to teh requirement of teh Business user.
• Personalized standard Oracle forms using forms Personalization according to teh business requirement.
• Assisted wif user testing of reports, developing and maintaining quality Procedures, and ensuring dat appropriate documentation is in place.

Environment: Oracle Applications 11i and R12 FIN and SCM Modules (GL, AP, AR, INV, PO, WIP, BOM, CE,CST, Shipping, iprocurement, iexpenses), Warehouse Management Systems (WMS), OAF (Oracle Application Frame Work), Customer Data Hub (CDH), Service Contracts, Installed Base, PL/SQL, TOAD, SQL Plus, SQL Loader, Oracle Reports 10g, RTF Reports, UNIX Shell scripting.

Confidential, Jasper, IN

Oracle Technical/Functional Consultant

Responsibilities:

• Oracle R12 Techno Functional Consultant responsible to work on PTP and OTC RICEW (Reports, Interfaces, Conversion, Extensions and Workflow) Components, New Enhancements and Handling P1-P4 JIRA Tickets for Bugs.
• Designing Technical Specification, Build, Unit Testing, Customization and SQL/PLSQL Tuning of Oracle Applications R12 Procure to Pay Modules (Account Payables (AP),Purchasing (PO), Account Receivables (AR), Service Contracts (SC), Cash Management (CE), Fixed Assets (FA), General Ledger (GL), Inventory (INV), Order Management (OM), iprocurement and iexpenses).
• Involved in teh design of AIM (Application Implementation Methodology) documents (MD50, MD70) for all teh RICEW (Reports, Interfaces, Conversions, Extension and Workflow) Objects.
• Designed MD70 Technical Design Document, Development for MOPUB AP Supplier, Supplier Sites and Banks Conversion to R12.
• Designed MD70 Technical Design Document, Development for MOPUB AP Invoices Conversion to R12.
• Developed Conversion Programs to import Customers into Oracle Order Management using Trading Community Architecture (TCA) API’S.
• Supported wif Service Contract Conversion which handles Sales Order Creation wif Service Lines and teh integrating order wif service contract.
• Developed Account Receivables (AR) Invoice Integration including Adjustments and Receipt Integration from legacy applications to R12.
• Developed Account Receivables (AR) Customer Integration (Party, Party Sites, Party Contacts, Accounts, Account Sites and Site Uses) between Sales Force and Oracle R12.
• Involved in designing MD50, MD70 Functional and Technical Design Document, Development for Purchase Requisition Work Flow Approval Management Engine (AME) Process.
• Modified existing logic and customized receiving notification for PO Confirm Receipts Work Flow.
• Modified existing PO Account Generator Work Flow to derive charge account based on expense account rule.
• Developed Custom Self Service Page for iexpenses using Oracle Applications Framework (OAF).
• Involved in Planning and implementing data conversion methodology and programs using PL/SQL to bring Installed Base (IB) instances (software licenses) and Service Contracts (SCs) (service agreements and maintenance) from a legacy system into teh Oracle 12i application.
• Developed Interface to Import On hand Quantity for Inventory (INV) Items in Oracle EBS.
• Developed Interface to Move On hand Quantity from one Sub Inventory and Locator to another.
• Designed and developed a custom PO Output for Communication Report for teh Standard Purchase Orders according to teh business requirements by customizing Standard XSL-FO style sheets.
• Worked on Unix Shell Scripting for Code Deployment of Packages, Procedures, SQL Files, Reports and LDT files.
• Designed and developed custom packages, triggers and procedures.
• Responsible for creating New Forms, Form Personalization, Reports Customization, RTF/XSL-FO template creation.
• Worked to improve teh performance of teh system by tuning and restructuring PL/SQL units for optimum performance.
• Designed and developed PL/SQL concurrent programs, Oracle Forms, Oracle reports.
• Customized and modified teh existing forms using Form builder according to teh requirement of teh Business user.
• Personalized standard Oracle forms using forms Personalization according to teh business requirement.
• Assisted wif user testing of reports, developing and maintaining quality Procedures, and ensuring dat appropriate documentation is in place.
• Tested and fixed teh bugs in exiting forms and reports.

Environment: Oracle Applications 11i and R12 FIN and SCM Modules (GL, SLA, AP, AR, INV, PO, WIP, GCS, AGCS, BOM, CE,CST, Shipping, iprocurement, iexpenses), Install Base, Service Contracts (SC), Oracle Depot Repair (ODR), Oracle Field Services (OFS), OAF (Oracle Application Frame Work), Customer Data Hub (CDH), Approval Management Engine (AME), PL/SQL, TOAD, SQL Plus, SQL Loader, Oracle Reports 10g, RTF Reports, UNIX Shell scripting.

Confidential, Durham,NC

Oracle Applications Technical Developer

Responsibilities:

• Worked in Oracle 11i and R12 Supply Chain Modules (SCM) and Finance (FIN) SDP (Subscription Delivery Platform).
• Understanding business requirement and functional design document, Designing Technical Specification, Build, Unit Testing, Customization and SQL/PLSQL Tuning of Oracle Applications 11i and R12 Finance (AP,AR,PO,GL,CE, SLA, Shipping) and SCM Modules (OM, Inventory).
• Once sales order was booked, need to work wif other Middle Ware Integration teams (Aria and VCHS) to make sure order was processed and service instance ID’s were created.
• Worked on Order and Provisioning Confirmation Email Notification changes as per business requirement.
• Involved in designing MD70 and developed SFDC to Customer Data Hub (CDH) Phone Number Conversion.
• Worked intensely on customer import from third party system (NBCS) and updating them in CFS to interface them into another third part system using TCA API’s in AR.
• Developed User Portal SFDC to Customer Data Hub (CDH) Conversion which includes Parties, Party Sites, Locations, Party Classifications, Accounts, Contacts, Contact Roles and Contact Points.
• Involved in designing MD70 Technical Design Document, Developed and did Unit Testing for PO Requisition Work Flow Approval Management Engine (AME).
• Involved in designing MD70 Technical Design Document, Developed and did Unit Testing for iexpenses Approval wif Work Flow Approval Management Engine (AME).
• Worked on XML Publisher Report in generating Monthly Sales Order Information for business.
• Worked on XML Bursting to send emails and FTP teh PDF files.
• Worked on EDI Sales Orders to load into Oracle Applications Sales Order Page which comes from external source systems via raw xml files.
• Developed package for EDI Transactions to validate teh orders before coming to sales order page. In case of any validation issues, we use to check in teh Error Corrections Form (ECS) and fix accordingly.
• Develop database clean-up strategies using Oracle standard archiving and purging processes. Responsible for creating clean-up scripts to remove lease and service contract data which includes teh contract, asset information, customer invoices, install base lines etc.
• Worked on Fixed Assets module by managing assets which includes depreciation periods, summary of depreciation periods, FA Books etc.
• Working experience on WMS - Inbound, Outbound and Reverse Logistics.
• Worked on WMS Stocking and Internal Inventory Movements.
• Developed Price Book Report, Price Book History RDF Reports in Report Builder 10g.
• Development of SID Transfer, to change teh distributor, reseller and end customers from one instance to other for teh orders dat are already booked in production as per teh Project requirements.
• Developed Self Service Pages for Sales Order Creation using Oracle Application Frame Work (OAF).
• Worked on OAF Personalization on adding links and custom pages.
• Development on Workflow Customizations for sending teh sales order to VCHS before provisioning teh Sales Order.
• Used Workflow builder 2.6 to customize existing processes by adding new notifications.
• Coordination and Worked on daily QA Bugs and blockers after developed and fixing it.
• Working Experience on 10 releases wif Business Analyst and Integration Team during CRP Testing.
• UAT and Production Support during each phase go-live.
• Developed Load statements (control files) for SQL*Loader to load legacy data from flat files in to oracle tables.
• Implemented Pl/SQL Stored Procedures to load data from staging tables to interface tables.
• Loaded traffic data logs into staging tables using SQL loader and shell scripts
• PL/SQL coding for Exception Handling and duplicate data maintenance.
• Developed UNIX Shell Scripts and PL/SQL procedures to extract and load data for month-end batch processing.
• Developed interface for loading supplier invoices from various sources.
• Developed Auto invoice program for loading customer invoices.
• Responsible for Month Close, Quarter close process for General Ledger.
• Working wif oracle support to resolve TAR and performance issues.
• Provided support for Data conversion from legacy system into oracle.

Environment: Oracle Applications 11i and R12 Finance (AP,AR,PO,GL,CE, Shipping), iprocurement, iexpenses, Fixed Assets (FA), Enterprise Asset Management (EAM), WMS, Installed Base, Service Contracts, Customer Data Hub (CDH), Bill of Material (BOM), Cost Management (CST), Global Consolidation System (GCS), Advanced Global Intercompany System (AGCS), Sub Ledger Accounting (SLA) and SCM (OM, INV), PL/SQL, EDI, OAF (Oracle Application Frame Work), TOAD, XML/BI Publisher, SQL Plus, SQL Loader, Discoverer Reports, Form Personalization, Oracle Reports 10g, Work Flow Mailer, UNIX Shell scripting.

Confidential, Minneapolis,MN

Oracle Applications Technical Consultant

Responsibilities:

• Oracle R12 Procure to Pay (PTP) Track Lead responsible for mentoring 6 team members, scheduling daily status call and tracking teh PTP RICEW (Reports, Interfaces, Conversion, Extensions and Workflow) Components.
• Highly responsible in Coordinating wif Project Manager, Business Leads and Functional Owners to gather requirement for all RICEW Components.
• Designing Technical Specification, Build, Unit Testing, Customization and SQL/PLSQL Tuning of Oracle Applications 11i and R12 Procure to Pay Modules (AP,PO, Cash Management (CE), iprocurement and iexpenses).
• Responsible for creating New Forms, Form Personalization, Reports Customization, RTF/XSL-FO template creation.
• Responsible for Encryption, Decryption and Transmission of Secure File Transfer from Oracle Applications to Trading Partners and vice versa.
• Involved in teh design of AIM (Application Implementation Methodology) documents (MD50, MD70) for all teh RICEW (Reports, Interfaces, Conversions, Extension and Workflow) Objects.
• Designed MD70 Technical Design Document, Development for PO Requisition Work Flow Approval Management Engine (AME).
• Designed MD70 Technical Design Document, Development for Credit Memo Approval wif Approval Management Engine (AME).
• Developed Custom Self Service Page for iexpenses using Oracle Applications Framework (OAF).
• Involved in teh development of Vendor interfaces/ Conversions to import teh data from legacy system into oracle application base tables.
• Developed Vendor Conversion Reconciliation Report for teh Conversion Process
• Involved in teh development of Purchase Order interfaces/ Conversions to import teh data from legacy system into oracle application base tables.
• Designed and developed a custom PO Output for Communication Report for teh Standard Purchase Orders according to teh business requirements by customizing Standard XSL-FO style sheets.
• Customized teh Oracle Standard Check Template according to teh business requirements and made required setups for Check Printing. Changed and fine-tuned teh template to generate checks by placing MICR font, Digital Signature on teh preprinted watermark paper.
• Developed Purchase Order Conversion Reconciliation Report for teh Conversion Process
• Worked on Enterprise Asset Management - EAM Work Order Scheduler Report, EAM Weekly Schedule Report.
• Involved in Planning and implementing data conversion methodology and programs using PL/SQL to bring Installed Base (IB) instances (software licenses) and Service Contracts (SCs) (service agreements and maintenance) from a legacy system into teh Oracle 12i application.
• Developed and implemented Service Contracts conversion from Eclipsys to Oracle

Environment: Oracle Applications 11i and R12 FIN and SCM Modules (GL, AP, AR, INV, PO, WIP, BOM, CE,CST, Shipping, iprocurement, iexpenses), Warehouse Management Systems (WMS), OAF (Oracle Application Frame Work), Customer Data Hub (CDH), Service Contracts, Installed Base, Enterprise Asset Management (EAM), PL/SQL, TOAD, SQL Plus, SQL Loader, Oracle Reports 10g, RTF Reports, UNIX Shell scripting.

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.
• Freight cost incurred on shipping teh goods from manufacturing Units to sub-inventories is known as Primary Freight. Custom Form was developed to capture teh transaction and Concurrent program creates a provision in GL for teh freight amount
• Forms and Concurrent Programs were developed to capture teh Freight cost incurred on shipping teh goods from sub-inventories to Customers. Reports were developed for reporting Secondary Freight transaction details and Exception details.

Environment: Oracle EBS Applications Release 11.5.10.2 (CRM), Oracle Database 9i, SQL *Loader, Reports 6i, Forms 6i.