Nandeep Bommanna
314-665-0037
nandeep.bc@gmail.com
SUMMARY
• Over 8 years IT experience in Oracle E-Business Suite (EBS) a...
Nandeep Bommanna
314-665-0037
nandeep.bc@gmail.com
EXPERIENCE SUMMARY
Customer: Laclede Gas,St Louis,MO Oct2014 to till da...
Nandeep Bommanna
314-665-0037
nandeep.bc@gmail.com
 Customizationof ProjectSupplierInvoice,ProjectExpense Report, PO Requ...
Nandeep Bommanna
314-665-0037
nandeep.bc@gmail.com
staging table so that users can correct input data and upload it simult...
Nandeep Bommanna
314-665-0037
nandeep.bc@gmail.com
Responsibilities:
 Workedon Customizationof Purchase OrderApproval, Pu...
of 5

Nandeep Bommanna Oracle EBS

Published on: Mar 3, 2016
Source: www.slideshare.net


Transcripts - Nandeep Bommanna Oracle EBS

  • 1. Nandeep Bommanna 314-665-0037 nandeep.bc@gmail.com SUMMARY • Over 8 years IT experience in Oracle E-Business Suite (EBS) as Techno-functional consultant (Business System Analyst), with experience in Oracle Account Payables (AP).  Extensive experience withanalysis,design,development, customizations and implementation of software applications including ERP applications  Implemented/Partof severalend-to-endimplementationsinmulti-program, multi-project, multi- vendor environment  Expertise inimplementation,customizationandsupportof Oracle Applicationmoduleslike Oracle Payables, Oracle Receivables, Oracle Purchasing and Oracle Order Management  Exposure tovarious Oracle modules related to Finance, SCMand has good understanding on the data flow/integration within the modules  Proficientintechnical aspectsof Oracle ApplicationsCustomizations,Interfaces,data Conversions and Extensions.  Experience inimportingdatafromlegacysystemstoOracle Applications through SQL*Loader and Fusion Middleware.  Extensive experience in registering and configuring various AOL concepts like concurrent programs, request groups, request sets, Key Flex fields, Descriptive Flex fields etc.  Expertise in developing and customizing Oracle Forms using Oracle OAF.  Experience in Oracle SOA 11g.  Certified in Oracle SOA 11g.  Possess working knowledge in Developer tools like Oracle Reports  Proficient in Programming Using PL/SQL  Participated in code review of custom scripts for easy maintenance of custom components  Excellentworkingknowledge incomponentsrelated to Order to Cash cycle, Procure to Pay Cycle.  Experience in Reports, Interfaces, Conversions and Extensions (RICE).  Knowledge in Oracle ADF  Able toworkeffectivelyatall organizational levels and have an ability to manage rapid changes.  Good communication skills and a genuine team player with good organizational and self- management skill. TECHNICAL SUMMARY Oracle Applications:Oracle Applications11i / R12. AccountsReceivables(AR),General Ledger(GL), AccountsPayables(AP),OrderManagement(OM),Inventory(INV),Purchasing(PO), FixedAssets(FA),ApplicationObjectLibrary (AOL) Oracle FMW:Oracle SOA 11g, BPEL Languages/Frameworks: SQL,PL/SQL, C,UNIX Shell Scripting Oracle Tools: JDeveloper11.1.1.7, DeveloperForms6i / 10g, Report6i/10g, Work Flow Builder. Databases: Oracle 11g/10g/9i/8i, MS Access. Tools: Toad, SQL PLUS, SQL* Plus, SQL Loader, UTL_FILE, SQL Developer
  • 2. Nandeep Bommanna 314-665-0037 nandeep.bc@gmail.com EXPERIENCE SUMMARY Customer: Laclede Gas,St Louis,MO Oct2014 to till date Role: Oracle Applications Developer Responsibilities:  Responsibilities involved attending design sessions with client, preparation of functional documents, technical documents and test case documents.  Design and development of various subject areas for converting data from legacy systems into Laclede system. Conversion involved AR invoice interface, Purchase Order interface (PO), AP Invoice interface, Fixed Assets interface (Asset Mass Addition), Inventory Items Interface and Project and tasks interface (Open Projects - API).  Integrationof varioussystemsintoLacledesystem throughconversion.Redesignanddevelopment of variousSOA interfacesbetweenOracle EBSandlegacysystems.Itinvolved changes to the WSDL file(Changes to one of the Operation input Parameter type, XSD file), changes to looping logic within BPEL, changes to XSL mapping file, redesigning web service calls to DB calls(Web Service adaptor to DB adaptor), fixed few performance issues and redesigned error logging web service.  Redesignanddevelopmentof anOAFpage inOTL module usingJdeveloper 10.1.3.1. This involved few fixes to VO and AMmethods.  Developmentof variousscriptsusedfor comparing data and reporting between source and target systems.Performancetuningof variouscodesusedindataconversion.Designanddevelopment of scripts used for comparing data and reporting across various subject areas between various systems in production so that data integrity is maintained. Customer: MemphisLightGas and Water(MLGW), Memphis, TN Jan 2014 to Sep2014 Role: Oracle ApplicationsDeveloper Responsibilities:  Participated in all the phases of the development life cycle involving analysis, design, development, testing and deployment of the project.  Activelyparticipatedinthe planning project backlogs, 2 week sprints and daily stand up meetings to analyze the time frame and report the status of the project.  Used AOL to define the concurrent programs, value sets needed for the process.  Writing stored procedures based on the requirements.  Designanddevelopmentof constructionestimate,construction standard and manufacturing units Oracle applicationframeworkpages.Thisinvolveddevelopmentof new searchpage,creationpage, update page and details page using Jdeveloper.  Alerts for various requirements across modules. Alerts were used for checking asset expiry and send mail to a group of users. It was used for calling concurrent program after insert into an work order table.  Customized Sourcing RFQ process which involved customization of OAF page using Jdeveloper 10.1.3.1, developmentof newworkflow componentusingworkflow builder and creation of event.  Account generator workflows for PO, Requisition and Invoice to change one of the accounting segments.
  • 3. Nandeep Bommanna 314-665-0037 nandeep.bc@gmail.com  Customizationof ProjectSupplierInvoice,ProjectExpense Report, PO Requisition and PO Account generator workflows.  AME implementedfor Payables Invoice Approval, Requisition Approval and iExpense workflows. Approval hierarchy was used as part of this implementation. Customer: Laclede Gas,St Louis,MO Jan2013 to Dec2013 Role: Oracle Applications Developerandon-shore coordinator Responsibilities:  Oracle R12 implementation and support across various modules.  Primarycontributionswere for requirementsgathering,designs,developmentandoff-shore co- ordination.  Involved in design and developing all the PL/SQL packages, reports needed for the process.  Used AOL to define the concurrent programs, value sets, lookups and DFF needed for the process.  Writing stored procedures based on the requirements.  Fixed all OTL related issues. OTL issues involved timecard load, various rules for Union employees for payroll.  Fixed various issues with Project and Task creation interfaces. Issues fixed with Move Order creation interface.  Involved in maintenance work of SOA components which is used to integrate with various systems like Maximo, Hyperion, CCB, G4 and EBS. AP and GL PIP Process maintenance – Integration between CCB and EBS systems.  Co-ordination of all off-shore resources.  DuringthisprojectI workedonvariousinterfaces, enhancement and customizations related to various modules AP, AR, GL, Projects and Tasks, PO, iProcurement, iExpense, Invoice, Fixed assets, Work Orders and Inventory items. Customer : Blackstone,New York,NY May 2012 to Jan 2013 Role : Oracle Applications Developer and off-shore coordinator Responsibilities:  Analyze the requirements provided by Business Analyst and prepare Impact analysis and estimates.  Have Prepared the Use cases and Functional Specification documents.  Have Prepared the High Level Design Documents.  Writingfunctional and technical design specifications, Test documents and Unit test cases and develop modules.  Developed new PL/SQL packages and interfaces for the requirements  This involved Web ADI user interface through which users input invoice data. Also worked on development of this requirement which involves Web ADI based User Interface integrated in Oracle Application. Web ADI involves validation of data entered before data is inserted into
  • 4. Nandeep Bommanna 314-665-0037 nandeep.bc@gmail.com staging table so that users can correct input data and upload it simultaneously.  For one of the custom requirement of client, designed and developed few OAF pages. This involveddesignof database tablesstructure usedinOAFpage anddevelopmentof fourcomplex OAF pages which are related. Search page, Creation page, Update page and Details page were created as part of this requirement.  Actively involved in off-shore coordination of all designs, development and testing. Customer : LiquorControl Board of Ontario(LCBO),Toronto,Canada Jan2012 to Apr 2012 Role : Oracle Applications Developer Responsibilities:  Working on migration from 11.5.10 to R12 version. Analysis of custom reports in R11 and its migration to R12 with required modification.  Analysis of existing OAF customizations and personalization in R11 and its migration to R12 instance.  Analysis of custom packages in R11 and its migration to R12 instance with required changes.  Analysis of custom views, alerts and triggers and its migration to R12 instance.  Used AOL to define the concurrent programs, value sets, lookups and DFF needed for the process. Customer : DLL Wayne, Wayne, PA Mar2010 to Dec 2011 Role : Oracle Applications Developer Responsibilities:  Workedon customizationof standardOAFpage.Thisincludedadditionof few fieldsandcustom validationforthese fields.Thisincluded modification of VO, AMand OAF page. Validations are handled in a package.  Worked on customization of standard and custom JSP pages. This included addition of new fields, attachment of LOV to fields, validations for newly added fields and update of database tablesbasedon input. This included changes to View Object, Data Object, Page Controller and JSP page.  Development of XML Reports in various modules.  Modification of custom workflow and seeded workflows like Order header and Order lines approval workflow and Purchase order approval workflow.  Modification of custom form. Development of materialized views.  Involved in design and developing all the PL/SQL packages  Used AOL to define the concurrent programs, value sets, and lookups needed for the process. Customer : Koninklijke PTTNederland(KPN) (Capgemini,Bangalore,India) Oct2008 to Mar 2010 Role : Oracle Applications Developer
  • 5. Nandeep Bommanna 314-665-0037 nandeep.bc@gmail.com Responsibilities:  Workedon Customizationof Purchase OrderApproval, Purchase Requisition Approval, Invoice Approval and many other standard workflows.  Worked on development of many complex XML Publisher Reports in Projects, Project management and Project Accounting modules.  Worked on customization of standard oracle forms, which involved Custom.pll changes.  Worked on application migration from 11i to R12.This involved moving existing inbound and outbound interfaces with necessary changes, customization of standard oracle forms, customizationof standardworkflowsandconversionof XMLpublisher reports into BI Publisher reports.  As part of customizationof standardworkflows,customizationof workflow notificationsis done whichare OAFpages.Thisinvolved extension of View Object (VO) and Controller Object (CO).  Involved in design and developing all the PL/SQL packages  Used AOL to define the concurrent programs, value sets, and lookups needed for the process. Customer : CJIB, Nederland (Capgemini,Bangalore,India) Mar2007 to Sep2008 Role : Oracle Applications Developer Responsibilities:  Analysis of requirement based on functional document. Preparation of technical document. Involved in coding, development and testing. Preparation of release and quality documents. Worked on XML publisher reports related to PO, AP and AR modules.  Involved in design and developing all the PL/SQL packages  Used AOL to define the concurrent programs, value sets, and lookups needed for the process.

Related Documents