We provide IT Staff Augmentation Services!

Apps Technical Consultant Resume

MiamI

SUMMARY:

  • Total 8 years of experience in Oracle Technologies and E - Business Suite of Applications.
  • Implementation and technical expertise in Oracle Applications R12/11x, across Modules such as Accounts Payable(AP), Purchasing(PO), Accounts Receivables(AR), General Ledger(GL), Fixed Assets(FA), Cash management(CE), Internet Expenses(OIE), iProcurement (iProc), Alerts and XML Publisher
  • Experienced in designing, coding, testing custom applications with an integration to Oracle Applications
  • Experienced in Oracle Application System Administration, AOL System Admin Activities such as Creating KFFs, DFFs, Profile Options, Value Sets, Users, Responsibilities, Managing Concurrent Programs and Requests.
  • Extensive experience in creating Stored Procedures, Functions, Packages and other database objects using SQL and PL/SQL. Experienced in UNIX/LINUX shell scripting.
  • Experienced in developing custom Oracle Forms using Oracle Forms 10g/6i. Used CUSTOM.pll to customize the standard Oracle Forms and Forms personalization to personalize the forms.
  • Experienced in Customizing standard Oracle Reports using Reports 10g/6i in GL, AP, FA, AR and PO modules as per business user requirements.
  • Experienced in Oracle Application Framework (OAF) applications, customization of OAF pages, extension and creation of new OAF pages in JDeveloper.
  • Experienced in requirement gathering, design and development of custom applications in Oracle Applications Framework (OAF) environment.
  • Experienced in implementation and upgrade from Oracle 11i to R12
  • Experience with Oracle SLA(Sub Ledger Accounting), MOAC and TCA
  • Experienced in implementing, scripting, testing and supporting heavily customized Oracle Applications environment.
  • Experienced in implementing WebADI and Oracle Report Manager Utility for Oracle reporting.
  • Experienced in implementing in Oracle XML Publisher Bursting functionality.
  • Experienced in integrating SOA with Oracle EBS using BPEL processes
  • Experienced in Patch analysis process and Performance tuning for Oracle custom processes
  • Completed Oracle s in Oracle EBS R12 and 11i
  • Experience includes exposure to all the phases of Software Development Life Cycle including Analysis, Design, Development, Testing, Implementation, Production Support and Maintenance.
  • Great exposure to Client Interaction, Requirement Gathering, Designing, Development, Testing, Team Leading, Release Management and Follow ups.
  • Experienced working in onsite-offshore support model.
  • Possesses excellent communication and inter-personal skills.

SKILL:

Applications: Oracle Applications 11.5.10 and R12 Applications, Markview

Modules: PO, AP, AR, GL, CE, FA & AOL, Oracle Workflow

Languages: SQL, PL/SQL, Linux Shell Scripting

Software/Tools: Oracle Forms 10g and 6i, Reports 10g and 6i, SQL * PLUSSQL * Loader, PL/SQL Developer, TOAD, Putty, WinSCP, Oracle Jdeveloper 10gBI Publisher, Workflow Builder 2.6, Microsoft Office, MS-Visio

RDBMS: Oracle 9i/10g/11g

Operating System: HP-UX, Linux, Windows XP, Windows 7

PROFESSIONAL EXPERIENCE:

Confidential, Miami

Apps Technical Consultant

Responsibilities:

  • Remediating 11i custom components to R12 including interfaces, custom Forms and custom Reports
  • Experience in developing inbound and outbound Interfaces for AP, AR, PO, CE and GL interfaces to load data from legacy systems into Oracle.
  • Developed custom interface to load GL daily rates from external system.
  • Developed custom treasury application for Confidential financial reporting.
  • Developed GL Budget interface to load Oracle budget data from external system.
  • Developed Custom reports based on RDF and BI Publisher Templates for all financial modules
  • Worked on Form personalization on PO Entry form, Daily Rates Form and OAF personalization on Supplier entry page.
  • Experienced in using FNDLOAD and XDOLOADER functionalities in migrating various components from one instance to another instance.
  • Customized PO Approval workflow to default the From Email address of the notification based on the OU of the PO and Expense Approval workflow to modify the default approval durations
  • Gathering the requirements from various parties and working with multiple groups to carry out the development.
  • Customized Supplier entry OAF page to force the supplier name Upper case by extending the controller
  • Developed and migrated OAF personalization on various OAF pages to hide/show fields/buttons and enabling DFF values.
  • Preparing and reviewing MD050, MD070, MD120 and UTC documents.
  • Function as the primary liaison between the business line, operations, and the technical areas.
  • Organizing daily calls with onsite/offshore to report the status of current development and understand the issues.
  • Creating and reviewing the technical design documents and test case documents for all the components
  • Coordinating with users for SIT/UAT testing.

Solution Environment: Oracle Apps R12.1, Oracle 11G, Oracle Reports 10g, Oracle Forms 10g, Oracle SOA

Tools: PL/SQL, Toad 8.6.1.0, Jdeveloper, Workflow Developer, SQLPlus, BI Publisher

Modules: PO, AP, AR, GL, FA, OIE and AOL

Oracle EBS Production Support

Confidential, Miami

Responsibilities:

  • Working as a Techno-Functional Consultant for this project to support issues in Oracle applications functional and technical areas including custom interfaces, forms, and reports.
  • Monitoring Oracle Applications and Markview systems.
  • Worked on creating scripts for data fix and breakfix changes.
  • Worked on resolving issues with workflow approval for POs and Internet Expenses.
  • Creating and using WEBADI templates to for GL Daily Rates, FA Mass Additions, GL Budgets and GL Journals.
  • Configuring and supporting FSG reports
  • Developing adhoc SQL queries to help users pulling setup and transactional data for auditing and monitoring purposes.
  • Created multiple monitoring scripts based on Linux shell scripting and PLSQL queries.
  • Configuring and using SVN Tool to version control of different objects.
  • Working with Oracle support through Service Requests in resolving issues with standard processes
  • Analyzing the issues and preparing Root Cause Analysis (RCA) documents for Problem Management.
  • Resolved Production Support tickets with a quick turnover time
  • Function as the primary liaison between the business line, operations, and the technical areas.
  • Organized daily/weekly calls with Business users to report the status of current issues and understand the issues.
  • Organizing daily calls with offshore team
  • Provide Knowledge Transfer and groom personnel in the team to support the system

Solution Environment: Oracle Apps 11.5.10, Oracle 11G, Oracle Reports 61, Oracle Forms 61, Oracle SOA

Tools: PL/SQL, Toad 8.6.1.0, Jdeveloper, SQLPlus, BI Publisher

Modules: PO, AP, AR, GL, FA, CE, OIE and AOL

Confidential

Technical Consultant

Responsibilities:

  • Code Remediation - Make changes to custom objects (Forms, Reports and Interfaces) to make them compatible to 11g database.
  • Testing Support - Assist users and team members during various phases of testing including Unit Testing, SIT and UAT.
  • Performance testing support - Assist in performance testing team by providing Oracle set up details and data gathering.
  • Participating in customer calls to clarify on the requirements and to discuss weekly status.
  • Development of design document for the changes made during DB upgrade.

Solution Environment: Oracle Apps 11.5.10, Oracle 10G

Tools: PL/SQL, Forms 6i, Reports 6i, UNIX Shell scripting and HP LoadRunner

Modules: PO, AP, GL, AR, FA, CE, OIE and AOL

Confidential, Miami

Oracle Developer

Responsibilities:

  • Developed multiple inbound and outbound interfaces in different modules including AP, PO, GL and AR.
  • Worked on modifications to the existing custom objects including custom interfaces, custom reports and custom forms
  • Developed custom interface to load Purchase Orders and Receipts to Oracle from external systems (Crunchtime, AMOS and Stockwatch)
  • Developed Custom interface to load AP invoices from external system IMS.
  • Created form personalization to default the Payment terms from vendor site for Quickmatch Invoices in Invoice workbench.
  • Created Form personalization to automatically copy the PO header DFF values to PO Distribution upon PO approval
  • Performing Unit test results for the developments and creating unit test results documents
  • Creating and updating Technical and Functional understanding documents for the developments.
  • Coordinating with users for UAT testing
  • Coordinating with DBA for promotion of changes from one environment to other environment.

Solution Environment: Oracle Apps 11.5.10, Oracle 10g, Oracle Reports, Oracle Forms, Linux Shell Scripting

Tools: PL/SQL, Toad 8.6.1.0

Modules: PO, AP, AR, GL, FA and AOL

Hire Now