We provide IT Staff Augmentation Services!

Oracle Apps Technical Consultant Resume

Webster, NY

SUMMARY:

  • Over 5 years of IT experience in Analysis, Design and Implementation as a Techno Functional Consultant in Oracle database and E - Business Suite. Highly motivated, enthusiastic professional with high level of commitment to succeed.
  • Worked on more than 3 end to end large scale Oracle EBS implementation projects.
  • Received appreciations from management on various occasions for dedication and commitment towards work in various projects.
  • Have Extensive experience in different phases of the software development life cycle such as requirements gathering, analysis, design, development, administration, testing, implementation and Documentation.
  • Ability to work independently, key team player and effectively promote teamwork.
  • Have experience in Implementation, Development, Customization, Testing and, Production Support of Oracle Applications, mainly in CRM, SCM and Financials Domains.
  • Good working knowledge in Data Model of Order Management (OM), TCA Architecture, Service Contracts (OKC/OKS), Install Base (IB), Account Receivables and Fixed Assets (FA) Modules.
  • Have thorough hands on Experience Senior Developer in SQL, PL/SQL, Oracle Forms, Reports, Oracle Workflow, BI/XML Publisher to generate reports in PDF, HTML, and Excel Formats.
  • Possesses sound knowledge of System Administration part of Oracle applications, Concurrent Program Registration, Responsibilities, Menus, and Functions etc.
  • Expertise in developing RICE components using SQL, PL/SQL, as per Oracle Applications coding/ Customization/ User Interface standards and Coding techniques in Oracle Applications.
  • Extensive experience in creating Stored Procedures, Functions, Packages, Triggers and other database objects using SQL and PL/SQL.
  • Experience using Oracle Streams, Advanced Queuing (AQ), Java Store Procedures, DBMS Jobs, Generating/Parsing XML data, building and invoking Web Services from database.
  • Worked on Database Performance Tuning for custom programs in EBS
  • Ability to learn new modules and Technologies quickly and efficiently.
  • Excellent communication skills and team player, very good working knowledge in Technical Documentation
  • Excellent problem solving and Analytical skills with an ability to identify problems and implement connective solutions.

TECHNICAL SKILLS:

Operating System: Windows XP, UNIX

Languages: SQL

PL/SQL: Unix Shell Scripting

Core Java: Oracle ERP Modules

CRM Modules: Oracle Service contracts

Oracle Install Base: Field Service

Oracle Receivables: Account Payables

Fixed Assets: General Ledger

TCA: Order Management

Front end Tools: Oracle Reports Builder(XML Publisher)

Oracle Form Builder(6i,10g): Oracle Work Flow Builder

PL/SQL Developer: JDeveloper 12.2.1.2.0 for ADF(Just 6months experience)

Tools: & Technology: MKS Integrity and ALM

PROFESSIONAL EXPERIENCE:

Confidential, Webster, NY

Oracle Apps Technical Consultant

Operating System: Windows XP

Languages: SQL, PL/SQL, UNIX

Modules: Service Contracts, Install Base, Accounts Receivables, General Ledger and TCA

Version: Oracle Applications R12.1.3

Tools: Forms 10g, PL/SQL Developer, Oracle 11g and Oracle E-Business Suite.

Responsibilities:

  • Understanding business process and gathering requirements from clients
  • Analyzing the existing business flow and proposing new business flow
  • Preparation of customer requirements, development requirement documents and Functional Test Case Design Documentation and presenting them to business and IT users for getting approvals.
  • Implementing the functional and technical setups in order to develop the desired functionality
  • Understanding and implementing any new functionality which comes in addition to the existing functionality
  • Providing estimations, code version control and code development
  • Responsible for database tuning and optimization of the SQL queries and PL/SQL objects
  • Optimizing the database performance of Trading Applications using Object Types, Collections, Records, etc.
  • Knowledge sharing and onsite - offshore coordination.

Confidential

Oracle Apps Technical Consultant

Operating System: Windows XP

Languages: SQL, PL/SQL,UNIX

Version: Oracle Applications R12.1.3

Tools: Forms 10g, PL/SQL Developer, Oracle 11g and Oracle E-Business Suite.

Modules: Service Contracts, Install Base, Field Service, Accounts Receivables, Account Payables, General Ledger and Fixed Assets

Responsibilities:

  • Carried out the following activities:
  • Involved in the Preparation of AS-IS documents for CRM modules.
  • Prepared Customer Requirements and Development Requirement documents.
  • Involved in Design, Coding and Unit Testing.
  • Manually executed the test cases on the build for functional validation.
  • Analysing the data reports and defect logging & tracking till closure.
  • Sharing the Test Results with Client.

Confidential

Oracle Apps Technical Consultant

Hardware:

Operating System: Windows XP

Languages: SQL,PL/SQL,UNIX

Version: Oracle Applications R12.1.3

Tools: Forms 10g, PL/SQL Developer, Oracle 11g and Oracle E-Business Suite.

Modules: Service Contracts, Install Base, Accounts Receivables, Field Service, TCA and Order management

Responsibilities:

  • Involved in discussions with Customers for gathering the requirements.
  • Prepared customer requirements, development requirement documents and Functional Test Case Design Documentation and presented to business and IT users for getting approvals.
  • Developed PL/SQL objects such as Packages, Functions, Procedures, triggers, tables etc.
  • Used UTL FILE package to generate various feeds for the external and internal systems.
  • Analyzed the complex Backend Procedures/Packages/Queries and implemented the changes to improve the processing time by using Hints and Materialized Views.
  • Implemented the functional and technical setups in order to develop the desired functionality
  • Implemented new functionality which comes in addition to the existing functionality
  • Provided Post Production support and resolved issues arisen during that duration.
  • Involved in Knowledge sharing and onsite - offshore coordination.

Confidential

Oracle Apps Technical Consultant

Operating System: Windows XP

Languages: SQL,PL/SQL,UNIX, Core JAVA

Special Software: Oracle Applications R12.1.3 Forms 10g, PL/SQL Developer, Oracle 11g and Oracle E-Business Suite.

Tools: Forms 10g, PL/SQL Developer, Oracle 11g and Oracle E-Business Suite.

Modules: General Ledger, Fixed Assets, Account Receivables

Responsibilities:

  • Understand the functional requirements and prepare detail technical design Documents
  • Implemented the necessary changes to enable the Oracle ERP General Ledger and Fixed Assets module
  • Consolidated the multiple General Ledger and Fixed Assets applications that are currently supporting US and Canada .
  • Prepared High level Design, Detail level design and test cases
  • Involved in Development and testing of outbound interfaces and conversions.
  • Post-production support.
  • Involved in Knowledge Sharing Sessions with Support Teams.

Hire Now