Experience

• 

  Hcl technologies

  Aug 2007 - Nov 2013

  Oracle developer

  • Techno-Functional Oracle Applications Finance and Manufacturing Support for modules Inventory, Bills Of Material, MRP, WIP,Order Management, Accounts Receivables, General Ledger, Purchasing, Account Payable, Fixed Assets• Gathering business requirements, identifying gaps, design solutions to resolve gaps in the standard Oracle system Configuration in the application.• Developed Oracle Alerts in various Modules and worked on SQL, PL/SQL, Functions , Procedures and Triggers. • Customizing Oracle Applications according to business needs that includes Forms Personalization.• Development or Enhancements of Oracle Forms, Reports and Interfaces across modules and applications.• Worked in creating XML Reports.• Involved in developing the automated test cases by using QTP and Attest for Oracle Regression Testing• GL Upload WebADI and Oracle Report Manager implementation in Oracle 11i• Involved in development of the Migration of data from 11i to R12 and Build Import programs to upload the data to R12. And build some sync program for 11i and R12 for HRMS Modules• Developed Automation Script for updating the Supervisor in set up Business Group.• Thorough Understanding and usage of APIs, Code development using PLSQL Tables (Collections).• Provided Techno Functional Support for Custom Application Roll forward built on Forms 10g which provides solution on Tax exemption for the purchased materials that flows across Legal Entities• Provided support during Period and Year End closure of Subsystems Inventory,AP,AR,FA and General Ledger.• Assisting in other Project related activities Including Auditing, Knowledge repository Maintenance, Change Management review for EBS team• Handled PWC and SOX Audits for more than 3 years. Show less

• 

  Cognizant

  Nov 2013 - Dec 2016

  Project: L3 Support – Oracle R12 ERP Applications Responsibilities:• Worked as Offshore Lead and responsible for on-time Deliverables• Worked with functional team members to finalize md.050 / md.070 and architecture design for RICEW elements • Review of code standards and Performance tuning of Technical components• Worked in customizing the Personal and Credit Card Notifications in iexpense modules through OAF and Workflow Changes• Developed new OAF Pages for Customer page and had done Extension to AM, EO and modified the CO based on the requirements.• Have worked on Oracle Forms Modifications on Payables Invoice Form.• Have done Customizations in custom.pll through Oracle Forms.• Worked on the Remittance Email notifications to Vendors for Oracle Payables• Worked in Multiple customized XML reports for Purchasing, Project Accounting and Fixed Assets• Worked on bug fixes for AP Interfaces and Cash Management Interfaces• Worked on AP Workflow Customizations per the Business Requirements.• Creation of expenditure types for interface supplier costs and miscellaneous transactions.• Creation of projects and project status. Created various projects, tasks and sublevel tasks with in those projects.• Did all the setups in PA like Project Class, project types and project templates etc• Designed functional specs for auto-accounting rules.• Configuration of Oracle Project Costing Auto Accounting to standardize and streamline the account generation for material, labor and miscellaneous transactions.• Resolved month end related issues involving and data fixes or configuration changes• Worked Customized Notifications for employee and Manager in iexpense process.• Have done Many OAF Personalization in iexense and iprocurements.• Customize/ Maintain Oracle Application Framework (OAF) Application.• Write custom components in OAF and OAF extension using Forms Personalization and extending controller. Show less Project: Comcast R12 Implementation Modules: AP, PO, FA, GL, AR, IexpenseThis Project involved end to end implementation of Oracle E- Business Solutions taking into the consideration the changes in Organizational and Financial Restructuring for both inherent and Live Data. The inherent system was completely redesigned to take the leverage of the new features available in R12. New Touch points were also part of the consideration during the implementation of the project. Responsibilities:• Worked on AP Interfaceso CABI Interfaceo EDI810 Interfaceo ComcastEDI Interface• Worked on FA Mass Transfer and Retirements Web ADI and Involved in GL WebADI Customizations and Created new PO Requisition Creation Web ADI.• Worked on the below AR Interfaces o Processoro AMEXo VISAMCo Discoverer• Worked on the Retrofit Items for ACH Payment File Creations.• Worked on the OUTBOUND interfaces in AP • Worked on Multi-sheet XML Publisher Reports• Worked on common Smart Coding which convert the GL 6 segments from 11i to 8segments for R12.This Smart coding is used across all modules for Interfaces.• Worked on the following conversionso Itemso Item Catalogueo Item Categorieso Suppliero Supplier siteso Supplier Contacts• Prepared MD50, MD70 and MD120 documents• Worked on R12 Upgrade of iExpense Module setting up JDeveloper environment to reapply extensions in R12 instances. Show less

  • Senior Oracle Developer

    Jul 2015 - Dec 2016

  • Senior Oracle Developer

    Nov 2013 - Jun 2015
• 

  Yankee candle

  Jan 2017 - Jan 2017

  Oracle ebs technical solution lead

  Project: Decoupling Order Management and Ship Confirm ProcessThis project involved in redesign of generation of EDI856 ASN to Customers from Oracle EBSResponsibilities:• Understanding the Current customization of Oracle Order Management process to PKMS warehouse System.• Worked with Functional team and end users for the new Redesign of EDI 856 ASN file generation process.• Worked with Technical team for any gaps in the new re-design process.• Interacted with client team to understand the existing business practices and prepared the business requirement definition documents and designed business requirement definition• Provided the functional requirements for the redesign of EDI ASN process.• Prepared Technical redesign document for EDI 856 ASN Redesign• Gathering the open issues and worked accordingly for the solution.• Observed the Dependency among the Application Modules and resolved the issues Show less

• 

  Granite telecommunications

  Nov 2017 - now

  Oracle developer