We provide IT Staff Augmentation Services!

Oracle Ebs Developer Resume

DenveR

SUMMARY:

  • Total 9+ Years of Experience as Oracle EBS Consultant Providing Solutions of Upgrade, Maintenance, Testing and Production Support in 11i and R12.
  • Experience in Financial Modules such as Account Payables (AP), General Ledger (GL), Account Receivables (AR), Fixed Assets (FA), Purchasing (PO), Project Accounting (PA), Oracle Project Management (OPM), Oracle Internet Expenses (iExp), Oracle Time and Labor (OTL), Sub - Ledger Accounting (SLA), Trading Community Architecture (TCA), Cash Management (CM), iSupplier.
  • Functional Responsibilities: Requirement Gatherings, Functional Gap Analysis, Configuration, Training End Users, Writing Training Guides.
  • Technical Responsibilities: Designing Custom Technical Solutions, Code Fix and Data Fixes
  • Experience working on end-to-end Procure to Pay (P2P) and knowledge of Order to Cash (OTC).
  • Proficient in SQL and PL/SQL.
  • Experience working on RICE Components.
  • Knowledge of Setups. E.g. COA, Calendars, Currency Rates, Cross Validation Rules. And Ledgers
  • Experience of developing conversion programs and Interfaces (Inbound & Outbound).
  • Experience in using tools like SQL *Loader, Data Loader, FND LOAD.
  • Knowledge of Writing/Modifying UNIX Shell Scripts.
  • Creating WEB ADI’s to load data in to oracle upon business requirement.
  • Proficient in Performance Tuning SQL statements using SQLTRACE and TKPROF.
  • Involved in QA Testing process and coordinated with end users for UAT.
  • Experience of writing Technical/functional specification documents using AIM Methodologies.
  • Performed Fundamental administrative tasks Including registering Concurrent Programs, Flex Fields, Value Sets, responsibilities and Menus.
  • Coordinated with Oracle support to resolve application issues, bugs and TAR/SR management.
  • Production support, bug fixing and enhancement.
  • Working Experience at Different Locations (United Kingdom, Poland, USA, India).
  • Coordinated and Planned with Various Teams for Release Roll Out plans and Maintenance Plans in Support Projects.
  • Exceptionally well organized with Strong Communication, Inter-personnel, Analyzing Skills and a desire to learn new technologies and tools.
  • Absolutely capable of working in a fast paced, dynamic, team-oriented environment with 24x7 support.

TECHNICAL SKILLS:

ERP: Oracle Applications Release 11i & R12

Databases: Oracle 9i, 11g.

Programming Languages: SQL, PL/SQL, UNIX & OAF

Development Tools: Forms & Reports 6i/10g, Xml Publisher, Workflow builder

ERP Modules: AP, AR, GL, SLA, PA, TCA, FA, iExpenses, OTL, CM, PO

Version Control: Clear case

Migration Control: Kintana, Serena

DB Tools: Toad, SQL Developer

Additional Tools: BMC Remedy, Service Now, Master Craft and Hyperion Brio, OBIEE, HP QC

PROFESSIONAL EXPERIENCE:

Confidential, Denver

Oracle EBS Developer

Responsibilities:

  • Requirement Gathering and Analysis for the Upcoming Reynosa Implementation.
  • Preparing MD-50 & MD-70 Documents.
  • Working on PRODUCTION Issues for already Implemented SPARTA.
  • Developing New BI Publisher Reports as per Client Requirements.
  • Working with Oracle through Service Request for Seeded Issues and bugs.
  • Preparing User Manuals and assist users in UAT Enhancement Testing
  • Preparing Standard Operating Procedures(SOP) for Production Issues.
  • Providing Status on Open Items during Daily Status Meetings.

Environment: - Oracle E-Business Suite R12.1.3 (AP, GL, AR, PO, INV, OM) Window 7, Oracle 11g, Toad, GitHub, Forms & Reports 10g, Xml Publisher, Workflow builder

Confidential, Chicago

Oracle EBS Consultant

Responsibilities:

  • Created New Rollup Groups, Summary Templates and tested the Funds Checking Functionality as part of Budget Organization changes requested by the Business.
  • Knowledge of defining Accounting flexfield Structure, Cross-Validation rules and Ledgers.
  • Preparing MD-50(Functional Design Document) for Various Reports and Interfaces to understand functional Requirements.
  • Performing Functional testing for AP, GL, FA and PO Modules to understand and document the existing Business process.
  • Responsible for handling daily Production issues related Financial Modules.
  • Implementation of Withholding Invoices Functionality for Foreign Supplier.
  • Creation of Shell Script to FTP Files to Third party vendors.
  • Supporting Business for UAT (Finance Modules) after every Patching Activity to verify the Functionality.
  • Knowledge of Defining Fixed Asset setups like Category/Asset key/Location key flex fields.
  • Knowledge of Defining Fiscal Year, Calendar and Depreciation methods locations and book Controls in Fixed Assets.
  • Resolving Issues in FA related to differences in Corporate and Tax books.
  • Web ADI Creation for Fixed Assets Module.
  • Migrating WEB ADI templates from one Instance to another using FND LOAD.
  • Developing Custom BI Publisher Reports as per Requirements.
  • Writing/Executing Scripts to perform various extracts from database.
  • Implemented Positional Hierarchy Workflow in Purchasing as per business requirements.
  • Modification of Existing OBIEE reports for CAFR as required by business.
  • Preparing User Manuals and assist users in UAT Enhancement Testing
  • Monitoring critical issue progress in order to avoid SLA violations and customer escalations.
  • Tracking recurring issues and provide Permanent fixes.
  • Documenting Issue Resolutions.
  • Coordinating with DBA for the Maintenance Activities.
  • Working along with Oracle Support through metalink for escalated issue analysis and resolution.
  • Provide Month/Year end Closing Support

Environment: - Oracle E-Business Suite R12.1.3 (AP, FA, PO, CM and GL, HR, PAYROLL) Window 7, Oracle 11g, Toad, Serena, BMC Remedy Software, Unix, Forms & Reports 10g, Xml Publisher, Workflow builder, OBIEE

Confidential, Schaumburg

Oracle EBS IT Analyst

Responsibilities:

  • Involved in requirement gathering with Motorola Solutions Business.
  • Presenting Technical/Functional Documents to business users and Approvals from Business.
  • Converted required Motorola Solutions Projects to Zebra Operating Units using Microsoft Projects Integrator.
  • Created New Project Templates for Zebra Operating Units.
  • Created New Projects Under Zebra Operating Units.
  • Created Resource Assignment for New Zebra resources for Zebra Projects.
  • Coordinated and supporting business user during CAT (Customer Acceptance Testing).
  • Provide Post Production Support and Extended care support.
  • Prepared User Manuals as per Business requirement.
  • Worked on Production Issues related to other Financial Modules (AP, GL, FA, AR, iExp) when required.
  • Developing Reports as Per Business Requirements.
  • Preparation of GL Extract for the Legal Audit Purpose.

Environment: - Oracle E-Business Suite R12.1.3 (Oracle Project Management (OPM) Window 7, Oracle 11g, Toad, BMC Remedy Software, Service Now

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

  • Working on Daily Production Issues across Finance Modules (AP, GL, IEXP, PA, AR, OTL, and OPM).
  • Analyzing the system and raise RFC for Enhancements and Performance.
  • Implemented Setups and Profile Options related to iExpense.
  • Done Setup for Assigning Signing Limits and supervisors for iExpense Approvals using AME.
  • Performing Data Fixes and Code Fixes.
  • Preparing/Modifying Reports as per user Requirements.
  • Knowledge of Setting Up Suppliers and Setting Up of Invoice tolerances
  • Tracking recurring issues and provides Permanent fixes.
  • Preparing Status Tracking Report on the Current issues and Permanent Fixes.
  • Provide Month/Quarter/Year end closing support.
  • Documenting Issue resolutions.
  • Personalized iExpense attachment upload page to include “Note” to the users at the organization level.
  • Coordinating with DBA for the Maintenance Activities.
  • Coordinating with Oracle through Service Request for standard bugs and working towards Resolution.
  • Supporting the Month end/Quarter End/Year End Closure Activities.
  • Supporting Motorola Custom Applications.
  • Primary Escalation Contact for the EMEA region.

Environment: - Oracle E-Business Suite R12.1.3 (PA, AP, GL, OTL, OPM, IEXP, FA) Window 7, Oracle 11g, Toad, BMC Remedy Software, Kintana, Unix, Forms & Reports 10g, OAF

Confidential

Oracle Apps Consultant

Responsibilities:

  • Responsible for analysis of functionality integrating other system with the Project Accounting Modules.
  • Coordinating with Business users during CAT (Customer Acceptance Testing) for Motorola R12.1.3 upgrade.
  • Implementing Code/Data fix and testing the Functionality after Implementation.
  • Preparation of Technical Design Documents for the newly/modified component in the existing system.
  • Worked on Production Issues and Alerts to meet customer needs.
  • Worked on Form Personalization Issues.
  • Preparation of as-Is document and To-Be documents.
  • Worked on 11.5.10 minimum baseline patch upgrade to the Internet Expense for Oracle Support.
  • Handling Client Meetings and providing status to Motorola Management.
  • Providing data extracts as per user requirements.
  • Converting Existing RDF reports in to XML Publisher Reports.

Environment: - Oracle E-Business Suite 11.5.10(PA, OPM, OTL, AP, AR) Window 7, Oracle 9i, Toad, BMC Remedy Software, Kintana, HP QC

Confidential

Oracle Apps Support Analyst

Responsibilities:

  • Responsible for handling Production issues related to Financial Modules and Custom Applications.
  • Extensively participated in Month/Year End Closing Activities.
  • Providing adhoc reporting data from business users during critical year-end, Month end process.
  • Clearing the Error Interface transactions.
  • Responsible for handling Customized interfaces issues
  • Monitoring critical issue progress in order to avoid SLA violations and customer escalations
  • Working along with Oracle Support for escalated issue analysis and resolution.
  • Communicating to all the stakeholders, getting the approval for the down time. Presenting the weekly status, SLA reports to Motorola team.
  • Working on Data fixes and Code Fixes.
  • Co-ordinate with business users to complete the User Acceptance Testing and log the defects in the PPM client Tool.
  • To identify and to implement best practices to ensure continuance of business operations and to reduce the risk and impact of potential disaster scenarios. Extensive Disaster Recovery tests are conducted every year.
  • Documenting Issue Resolutions.
  • Problem Management: To assist the Incident Management team to drive downs the number of incidents by identifying the root cause. Perform Post Incident Review on major incidents.
  • Supporting Motorola Custom Applications (FIRE, e-BAM, e-Check, e-Sar).
  • Preparing the Release Rollout plan and make sure that proper code is migrated across various instances via Kintana and Clear-Case tools.
  • Tracking the various stages in the life cycle of the project using the Client Specific tool COMPASS.
  • Following Change management, release management processes to ensure quality during production migration.
  • Gaining knowledge on the Inbound and outbound applications and resolving cross application tickets.

Environment: - Oracle E-Business Suite R11.5.10 (AP, AR, OM, GL, PA, iEXP, FA, Motorola Custom Applications) BMC Remedy, Kintana, Clear-Case, Oracle 9i, Toad, SQL* Plus, UNIX, PL/SQL, Forms & Reports 6i/10g, Hyperion Brio

Confidential

System Engineer

Responsibilities:

  • Underwent rigorous training in Oracle PL/SQL, SQL, and Unix Shell Scripting.
  • Trained to analyze customer business systems and requirements.
  • Trained to Document Functional/Technical Design Documents as per AIM .
  • Testing the Existing Business Process and Documenting Test Results .
  • Trained on Communication Skills and User etiquette.
  • Understanding Project SDLC and implemented the same for in-house projects.

Environment: -Oracle 8i/9i, Toad, SQL* Plus, UNIX, PL/SQL, SDLC concepts, Master Craft

Hire Now