Experience

Yum! Brands

• United States
• Restaurants
• 700 & Above Employee

• Senior Oracle Applicaton Developer

  • Aug 2013 - Present

  Developed Order Import Interface for business applications to load header and line details by creating Staging Tables and performing validations by writing PL-SQL package into the Order Import (OE) headers and line interface tables and then to OE base tables. Imported Items from legacy system into Oracle Inventory using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories. Developed Discoverer Reports to get the employees information Period wise, monthly and yearly. Developed workbooks using Discoverer to develop custom reports for business analysis. Developed UNIX Shell Scripts. Customized and developed Oracle Forms and Oracle Reports using Oracle Forms 9i/10g and Reports 9i/10g. Customized standard reports such as AR Customer Invoice Report, Pack Slip Report, Open Order Report, Purchase Order Report. Developed new reports using Report Builder 9i and also customized seeded reports in purchasing (PO) module. As per the company requirements, created and implemented XML/BI Publisher reports for different products like PO, AP and GL. Creation of new custom reports using Oracle XML/BI Publisher. Developed AR Credit memo and AR Customers forms. Built custom forms using Oracle Forms 9i/10g Builder to fulfill the business requirements of the client. Customized existing forms to define system Profile Options, Descriptive and Key Flex fields. Show less



Omnicare, a CVS Health company

• United States
• Pharmaceutical Manufacturing
• 700 & Above Employee

• Senior Oracle Application Developer

  • May 2011 - Jul 2013

  Configuration of General Ledger for multiple sets of books and integration with AP & AR. Hands on experience on Oracle EBS R12 P2P (iProcurement, AP, PO, iSupplier) modules. Hands on experience on Oracle EBS R12 SCM, BOM and WIP modules. Performed data conversion from legacy system to oracle modules using SQL*Loader. HRMS integration with other Oracle Applications, including Shared and Full installation considerations. Implemented Oracle Demantra applications like demand management, sales & operations planning, and trade promotions management solutions. Worked on integration interface, workflow, methods, series and system parameters of Demantra. Customize/ Maintain Oracle Application Framework (OAF) Application. Write custom components in OAF and OAF extension using Forms Personalization and extending controller. Provided Technical support activities resolving internal TARs and RFCs. Responsible for TAR creations & escalation process and resolving functional & technical issues by coordinating with oracle corp. support staff working remotely. Provide data fixes to GE Energy wherever required. Worked on hosted CRM using Oracle CCA (Contact Center Anywhere) product. Worked on Oracle CRM modules (Oracle foundation, Contracts, Installed base) Worked on code modifications and project enhancements based on client requests. Worked in the support system, performed the responsibility of system administration which involved creating users, setting up the user profile, registering and managing the concurrent programs. Customized standard reports like open Sales order report and AR Customer Invoice Report. Show less



Ashland

• United States
• Chemical Manufacturing
• 700 & Above Employee

• Oracle Application Developer

  • Sep 2009 - Apr 2011

  Create standard purchase order, BPA and blanket releases. Developed PL/SQL scripts to load order data from external system to OM Developed Order Management, Inventory,Receivables queries to compare summary information of the standard and custom reports. Have done mapping 11.5.10 reports to R12XML/BI templates, writing Extent and Validation rules, plugging Validation and extends to Payment Process. Customized Standard AR Receipt Register Report using Reports6i/10g. Designed and developed data storage procedures, functions and underlying views used for discoverer reports and developed discoverer Reports as per the requirement. Designed and developed ad-hoc Oracle Discoverer workbooks and reports and also trained the End Users. As per the company requirements, created and implemented XML/BI Publisher reports for different products like PO, AP, FA and GL. Registered the Templates and Data Definitions using XML/BI Publisher Administrator responsibility. Developed various reports as of the user specifications using XML/BI Publisher. Proficient in generating Forms using Oracle Forms meeting variety of Business needs including custom Reports. Modifying Forms to accommodate new functionality like adding Buttons and Texts. Conversant with both offshore and onsite development models. Involved in post-production support. Show less



Infosys

• India
• IT Services and IT Consulting
• 700 & Above Employee

• Oracle Application Developer

  • Oct 2007 - Aug 2009

  Designed and developed two custom data entry forms to maintain data in custom tables. Modified existing reports. Migrated GL and AP custom interfaces and reports, during oracle financials upgrade project. Imported Invoices using Auto-invoice program and applied receipts using Auto-Lock Box Developed test cases and templates to test the custom report migration process. Customizing Accounting Flex Fields, Cross Validation Rules and Security Rules Setting of profile options at various levels. Evaluation of organization structure, reporting needs, business needs to plan the chart of accounts as well as defining them Frequently worked with defining accounting and descriptive flex fields, writing validations to custom forms. Developing Adhoc reports using Discoverer to analyze data and compare with General Ledger. Helping financial service people to understand and reconcile data between custom module and Oracle financials. Also designing and developing custom procedures and Reports (Pl/SQL, Reports 6.0). Writing scripts to automate reports to run in batch for given time period. Show less