We provide IT Staff Augmentation Services!

Sr. Oracle Ebs Fusion Technical Consultant Resume

SUMMARY

  • Over 11 years of Techno - Functional experience in Oracle E-business suite Release 11i and 12 - Performing Techno-Functional work in Finance, HCM, and Order management modules of Oracle Applications (Oracle E-Business Suite (EBS) for Enterprise Resource Planning (ERP)).
  • Experienced Technical Development skills in the domain of Oracle Applications E- Business Suite using SQL, PL/SQL, Forms, Reports, Workflow I Publisher, BIP Report for integration, OTBI Report and discoverer reports.
  • Expertise in developing RICE components (Reports, Interfaces, Conversions, Extensions) in the domain of Oracle Application E-Business suite.
  • OAF web pages application development (Jdeveloper 10g, EBS R12.1.x, R12.2.x).
  • Extensive SQL and PL/SQL development including implementations of Index and Hints management,Query optimization and various others on top of regular PL/SQL and SQL programming.
  • Extensive Experience in writing Stored Procedures, Functions, Triggers and packages using PL/SQL.
  • Experienced in loading data from flat files into database tables using SQL*Loader,
  • Excellent communication skills, with strong troubleshooting, and problem solving ability
  • Experience in customizing Oracle workflows such as the PO Approval process, Order/Line.
  • Good understanding of Order to Cash (O2C) and Procure to Pay cycle (P2P),HRMS,Time and Labor module.
  • Excellent perspective on converting the functional specifications into technical design and development.
  • Able to clearly articulate and effectively communicate ideas, problems, and solutions with individuals at all levels
  • Having Very good exposure of implementation and support for Oracle E-business suite Release 11i and 12.
  • Well versed with Onsite Offshore model and effectively handled onsite assignment.
  • Followed quality and coding standards with all the deliverables delivered to client

PROFESSIONAL EXPERIENCE

Confidential, Minnepolis

Sr. Oracle EBS Fusion Technical Consultant

Environment: Oracle E-Business Suit R12, Oracle SQL, PL/SQL, Oracle Forms 10g, Oracle Reports 10g, XML Publisher, Workflow, Unix, SQL Loader, WEB ADI,OAF

Responsibilities:

  • Responsibilities included development and debug of Pl/sql packages and procedure for integration of HCM module
  • Developed custom XML Publisher, Oracle Reports (RDF) as per business requirements.
  • Worked on multiple projects, which include developing SQL Loader code for loading data into staging tables, PLSQL code for validation and insert/update of data and emailing the output to the user.
  • Development and Debugged Oracle Forms and Form Personalization.
  • Developed custom Web ADI and modified GL ledger WEBADI.
  • Debugged Reports, PL/SQL codes and UNIX scripts and provided various code fixes.
  • Post production support.
  • Developed custom reports like Transaction register, Receipt register
  • Worked on Order import interface program.
  • Worked on drop ship order and back to back orders
  • Prepared various documents like MD70 (Technical Design Doc), MD120 (Deployment Doc)
  • Involved in technical testing of various bug fixes.
  • Testing of the technical components end-to-end t.
  • Executed and implemented testing procedures and analyzed results.
  • Ensured deliverables conformed to customer requirements.
  • Used bug tracking tools to track and test defects.
  • Modifying existing functions based on Problem Report/Change Request (PRCR) and maintaining Product compatibility.
  • Provided End users training on customizations and outbound and inbound interfaces flows.
  • Frequent Client Interaction to discuss future enhancement and optimization solution.
  • Worked on various custom developments, maintenance and support.
  • Worked on Migrating/Creating customers, accounts, sites from third party system to Oracle.
  • Worked on various performance issues to during production support.
  • Assisted functional/business with various analysis and prod issues.
  • Developed custom XML Publisher, Oracle Reports (RDF) as per business requirements.
  • Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances.
  • Strong Knowledge in Development and Customization of Forms/Reports with sound understanding of Application Object Library (AOL).
  • Experience with Oracle Supplied Packages such UTL FILE.
  • Expertise in System Administrator responsibility to create users, responsibilities, Values Sets and Request sets.
  • Used FND-LOAD to migrate Concurrent programs, Request sets, forms menus and Personalization, by downloading the LDT files.
  • Submitted Service Request with Oracle Support in different Scenarios, for providing Solutions to the Bugs identified during Production support resolved various bugs, working in collaboration with Oracle Support.
  • Developed PL/SQL procedures, functions, packages, triggers to validate the data and insert the validate data into Oracle Standard interface tables.
  • Used of GIT for maintaining code version, logging of bug, Work tracking.
  • Proactively tuned SQL queries, Views using Explain Plan, Hints, indexes, and SQL trace.
  • Experience developing and customizing Oracle EBS using OA Framework, ADF and PL/SQL.

Confidential, BOSTON

Sr. Oracle EBS Technical Consultant

Environment: Oracle E-Business Suit R12, Oracle SQL, PL/SQL, Oracle Forms 10g, Oracle Reports 10g, XML Publisher, Workflow, Unix, SQL Loader.

Responsibilities:

  • Worked on developing custom code, maintenance and support for multiple modules like Order Management, Purchasing and OPM.
  • Developed custom XML Publisher, Oracle Reports (RDF) as per business requirements.
  • Worked on multiple projects, which include developing SQL Loader code for loading data into staging tables, PLSQL code for validation and insert/update of data and emailing the output to the user.
  • Worked on custom.pll to perform the zoom functionality.
  • Debugged Reports, PL/SQL codes and UNIX scripts and provided various code fixes.
  • Postproduction support.
  • Worked on AR Invoice Print Report, AR Credit Note/debit Note Print Report.
  • Worked on AR Invoice, Customer Interfaces.
  • Worked on order workflow.
  • Worked on PO import interface program.
  • Prepared various documents like MD70 (Technical Design Doc), MD120 (Deployment Doc)
  • Involved in technical testing of various bug fixes.
  • Provided End users training on customizations and outbound and inbound interfaces flows.
  • Frequent Client Interaction to discuss future enhancement and optimization solution.
  • Worked on various custom developments, maintenance and support.
  • Worked on Migrating orders from third party system to Oracle.
  • Worked on various performance issues to during production support.
  • Assisted functional/business with various analysis and prod issues.
  • Developed custom XML Publisher, Oracle Reports (RDF) as per business requirements.
  • Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances.
  • Strong Knowledge in Development and Customization of Forms/Reports with sound understanding of Application Object Library (AOL).
  • Expertise in System Administrator responsibility to create users, responsibilities, Values Sets and Request sets.
  • Used FND-LOAD to migrate Concurrent programs, Request sets, forms menus and Personalization, by downloading the LDT files.
  • Developed PL/SQL procedures, functions, packages, triggers to validate the data and insert the validate data into Oracle Standard interface tables.
  • Used Version Control (PVCS, Clear Case) to maintain code changes.
  • Proactively tuned SQL queries, Views using Explain Plan, Hints, indexes, and SQL trace.

Confidential

Sr. Oracle EBS Technical Consultant

Environment: Oracle E-Business Suit R12, Oracle SQL, PL/SQL, Oracle Forms 10g, Oracle Reports 10g, XML Publisher, Workflow, Unix, SQL Loader.

Responsibilities:

  • Worked on developing custom code, maintenance and support for multiple modules like Order Management, Purchasing and OPM.
  • Developed custom XML Publisher, Oracle Reports (RDF) as per business requirements.
  • Worked on multiple projects, which include developing SQL Loader code for loading data into staging tables, PLSQL code for validation and insert/update of data and emailing the output to the user.
  • Development and Debugged Oracle Forms and Form Personalization.
  • Debugged Reports, PL/SQL codes and UNIX scripts and provided various code fixes.
  • Post production support.
  • Worked on Payables Open interface to import standard Invoices from third Party in AP.
  • Worked on PO import interface program.
  • Workflow/Business Events
  • Prepared various documents like MD70 (Technical Design Doc), MD120 (Deployment Doc)
  • Involved in technical testing of various bug fixes.
  • Modifying existing functions based on Problem Report/Change Request (PRCR) and maintaining Product compatibility.
  • Provided End users training on customizations and outbound and inbound interfaces flows.
  • Frequent Client Interaction to discuss future enhancement and optimization solution.
  • Worked on various custom developments, maintenance and support.
  • Worked on Migrating/Creating customers, accounts, sites from third party system to Oracle.
  • Worked on various performance issues to during production support.
  • Assisted functional/business with various analysis and prod issues.
  • Developed custom XML Publisher, Oracle Reports (RDF) as per business requirements.
  • Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances.
  • Strong Knowledge in Development and Customization of Forms/Reports with sound understanding of Application Object Library (AOL).
  • Experience with Oracle Supplied Packages such UTL FILE.
  • Expertise in System Administrator responsibility to create users, responsibilities, Values Sets and Request sets.
  • Used FND-LOAD to migrate Concurrent programs, Request sets, forms menus and Personalization, by downloading the LDT files.
  • Submitted Service Request with Oracle Support in different Scenarios, for providing Solutions to the Bugs identified during Production support resolved various bugs, working in collaboration with Oracle Support.
  • Developed PL/SQL procedures, functions, packages, triggers to validate the data and insert the validate data into Oracle Standard interface tables.
  • Used Version Control (PVCS, Clear Case) to maintain code changes.
  • Proactively tuned SQL queries, Views using Explain Plan, Hints, indexes, and SQL trace.

Confidential

Oracle Apps Techno-Functional Analyst

Environment: Oracle E-Business Suite R12, Oracle SQL, PL/SQL, Oracle Forms, Oracle Reports, XML Publisher, Workflow, OAF.

Responsibilities:

  • Worked Primarily on Forms, Reports and Pl/Sql Packages, Function etc.
  • Manages the team to deliver the objects within the deadline.
  • Part of the complete implementation cycle.
  • Managing the team and ensuring the quality delivery of the objects by them.
  • Working as Technical lead which involves gathering requirement from client and assigning the work to other technical consultants and working on the objects.

Confidential

Sr. Oracle EBS Technical Consultant

Environment: Oracle E-Business Suite R12, Oracle SQL, PL/SQL, Oracle Forms, Oracle Reports, XML Publisher, Workflow.

Responsibilities:

  • Involved in Requirement gathering and technical design documentation.
  • Written PL/SQL stored Procedures, Functions and Packages for implementing the business logic.
  • Developed the custom Form that call location specific Report.
  • Developed customer RDF reports using Oracle 10g.
  • Developed a new customer forms in OM.
  • Unit testing and code reviews for modified objects.
  • Prepared various documents like MD70 (Technical Design Doc), MD120.
  • Worked on multiple projects, which include developing SQL Loader code for loading data into staging tables, PLSQL code for validation and insert/update of data and emailing the output to the user.
  • Used FND-LOAD to migrate Concurrent programs, Request sets, forms menus and Personalization, by downloading the LDT files
  • Submitted Service Request with Oracle Support in different Scenarios, for providing Solutions to the Bugs identified during Production support resolved various bugs, working in collaboration with Oracle Support.

Hire Now