Independent Consultant
Information Technology/IT
Australia
India
New Zealand
Singapore
United Kingdom
United States
English
Hindi
Summary:
• 4 years of experience in Oracle E-Business Suite Applications (R12) and Oracle Fusion as an Oracle Apps/Fusion technical Consultant and worked on Implementation, AD and Support projects.
• Client Interaction, communication and managing client expectations in accordance with scope, time and effort, executing Onsite-Offshore support models
• Extensive experience in implementation, Migration, Customization and support of various modules in Oracle Applications with major focus in Order Management (OM), Inventory (INV), Purchasing (PO), Accounts Receivable (AR), Accounts Payables (AP) General Ledger (GL).
• Exposure in PPM to AR integration reports.
• Expertise in developing and customizing Reports and Forms in Oracle E-Business Suite R12, Oracle 10g, Oracle Reports/Forms 10g, XML Publisher 5.6.3. • Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs.
• Substantial development experience in creating stored procedures, Packages, Triggers, Functions, Indexes and Views.
• Developed several customized oracle BI publisher reports on Fusion and report bursting.
• Customized standard reports such PO-PDF, Sales invoice etc. in oracle fusion based on the client requirement.
• Developed basic Oracle Transactional Business Intelligence (OTBI) reports.
• Conversions:- Received data from various source system like IPM (Intellectual Property Management), TEP(The Enabling Program) in MDM (Master Data Management), It’s a comprehensive platform given by Oracle that delivers consolidated, consistent and authoritative master data across the enterprise and distributes this master information to all operational and analytical applications. Data will come in JSON Format in a queue we need to De-queue the Data first then parse it and finally store in the staging tables.
• Extensively worked on OAF Development & Personalization.
• Enabled AME for payables at invoice line level based on the cost center.
• Involved in the analysis of the assigned support tickets including replicating the issue, analyzing the custom processes/API’s/reports/forms/OAF/PLSQL Codes/SQL Queries and updating the ticket with the appropriate information.
• Work on the development activities as part of issue resolution. Perform Unit Testing, migrate to next environments, assist user testing and closing the tickets.
• Closely worked with users to understand business needs and objectives.
• Code and Data fix migration using SBM, a code migration too.
• Performance tuning using TKProf and explain plan.
• Oracle EBS Developer :- Creating concurrent program, registering it, Creating Value sets and lookups • Developed OAF Pages: - An OAF Page with multiple functionalities like Partial Page rendering (PPR), message choice List of Values (LOV), Dependent LOVs, fetching WEBADI through Submit Button with some validations. • Developed XML/BI Publisher Reports: - Developed BI Publisher reports with multiple layout and then using the same in XML Bursting in order to send the report to multiple People/Vendors. • XML Bursting:- Sending a single report to multiple people as per the requirement • SQL Queries:- Complex SQL queries using REPLACE, REGEXP_SUBSTR, INSTR functions and joining multiple tables. • Worked on custom package for AP invoice interface with validation and derivation logics:- Worked on standalone PL/SQL procedures, function and Packages for validating the particular field from base tables and check whether the format of data is as per the business requirement or not.
• Worked on the development of Oracle Fusion BI publisher report, customization of a standard sales invoice page. • Worked on PPM to AR integration bi publisher reports.
• Oracle APPS Technical Consultant:- Creating concurrent program, registering it, Creating Value sets and lookups • Enabled AME at invoice line level: - Enabled AME at invoice line level based on the cost center and payment limit. Once a invoice gets created it should be sent for approval before the payment is done parallelly at each invoice line level to the defined person as per the range of amount.
• Developed the custom BI publisher purchasing reports. • Worked on the customization of standard PO PDF seeded page as per the client requirement. • Designed and developed the BARCODE report of shipment number and enabled the functionality of getting scanned through a scanner as per the business requirement. • Designed a RTF with check box functionality.
• Involved in the day to day activities of production support of Oracle applications environment in AP, PO, INV modules. • Involved in the analysis of the assigned support tickets including replicating the issue, analyzing the custom processes/API’s/reports/forms/OAF/PLSQL Codes/SQL Queries and updating the ticket with the appropriate information. • Work on the development activities as part of issue resolution. Perform Unit Testing, migrate to next environments, assist user testing and closing the tickets. • Closely worked with users to understand business needs and objectives. • Code and Data fix migration using SBM, a code migration too. • Personalized Oracle Application Framework pages. • Worked on the development of BI Publisher/XML Publisher reports
• Conversions:- Received data from various source system like IPM (Intellectual Property Management), TEP(The Enabling Program) in MDM (Master Data Management), It’s a comprehensive platform given by Oracle that delivers consolidated, consistent and authoritative master data across the enterprise and distributes this master information to all operational and analytical applications. Data will come in JSON Format in a queue we need to De-queue the Data first then parse it and finally store in the staging tables. • Interfaces: - Sending and receiving data from MDM to other sources like IPM In .DAT Files for Items, User defined attributes and Value sets and vice-versa. • Performance tuning using TKProf and explain plan. • Oracle Apps Technical Consultant for upgrade and support project.
Year of Passing Qualification Institute Board/University Percentage 2011-2015 Bachelor of Technology Krishna Engineering College, Ghaziabad. Dr. A.P.J. Abdul Kalam Technical University 73.02%
Login / Register
