We provide IT Staff Augmentation Services!

Sr. Oracle Ebs Fusion Technical Consultant Resume

Minneapolis, MN

PROFESSIONAL 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.
  • 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, Minneapolis, MN

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:

  • Worked on developing custom code, maintenance and support for multiple modules like Order Management, Purchasing and OPM and HCM
  • End-user page level customizations for adding client flavor to standard product.
  • •Developed the several BIP Report for integration.
  • •Design and developed the HCM extract for integration.
  • Interfaces of creation of employee, update of employee, address API to load data from the legacy system to oracle.
  • •Design the OTBI Report as per the client/business requirement.
  • •Worked on the data security as and when required.
  • •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.
  • Worked on Payables Open interface to import standard Invoices from third Party in AP.
  • 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.
  • 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.
  • Experience developing and customizing Oracle EBS using OA Framework, ADF and PL/SQL.

Confidential, BOSTION

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.
  • Post production support.
  • 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, Minneapolis, MN

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, Monroeville, PA

Oracle Apps Techno-Functional Analyst

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

Hire Now