Oracle Technical Consultant Resume Samples

An Oracle Technical Consultant is hired to implement Oracle business solutions for a variety of client’s needs. A well-drafted Oracle Technical Consultant Resume mentions the following core roles and responsibilities – assigning functional design documents; preparing technical design documents; developing and customizing forms, and reports; working on XML publisher reports using RDP and data template; defining Concurrent programs and executables; preparing SQL loader scripts and PL/SQL programs, and developing an outbound interface for transferring the data from base tables.

Those seeking to work as a consultant in this area of expertise should denote on the resume the following skills – experience in Oracle Applications; expertise in Oracle, Reports, 6i, SQL and PL/SQL; good knowledge in utilities such as TOAD, SQL Loader, and SQL * Plus; solid understanding of XML publisher reports; and deep knowledge of SQL queries, procedures, and packages. A degree in IT or Computer related field is mandatory.

 

Oracle Technical Consultant Resume example

Oracle Technical Consultant Resume

Objective : 9+ years of IT experience as a Technical Developer, experienced in Designing, Development, Enhancement, Customization, Implementation of Oracle Applications R12/11i Oracle Financials (AP, GL, AR) and (Oracle Manufacturing (PO, INV, BOM, WIP, OM, Advanced Pricing and Shipping), System administrator, iSupplier, iProcurement and Application Object Library (AOL).

Skills : Technical Developer, experienced in Designing.

Description :

    1. Wrote PL/SQL script to automate the process of creation of Responsibility level associated Profile option and values.
    2. Customized the Standard Purchase Order(PO) Interface Program to add 5 additional attributes as per the business requirement as a part of P2P Process.
    3. Designed and developed PO (Purchase Order) Requisition Interface to load PO requisitions from the legacy System in to purchasing interface tables.
    4. Solid experience in PLSQL Interfaces, PLSQL APIs, Conversions, Customization and Development of Reports.
    5. Developed the interface program for Accounts Payables given in the flat file and loading the data from flat file to the staging table using SQL Loader and did all the necessary validations.
    6. Developed the Back end process for Auto Lock Box Interface to read and write the multiple files coming from Bank.
    7. Developed an interface for monthly import of journal entries from payroll running on a legacy system by using the Journal Import Interface provided by Oracle General Ledger.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelor Of Science


Sr. Oracle Technical Consultant Resume

Objective : 12 years of IT experience in Leading IT Projects, full life cycle implementations and continuous improvement of ERP and bolt on systems. Delivered in different roles like Solutions Architect, Business Analyst and leading Development Teams. Experience in design, development and specializing in GL/AP/AR, i-Expenses, i-Payments, Cash Management, Fixed Assets, EB-Tax, Time & Labor and Project Costing/Billing.

Skills : GL/AP/AR, i-Expenses, i-Payments, Cash Management, Fixed Assets.

Description :

    1. Developed custom activities and notifications to build complex workflow processes as per the business scenarios.
    2. Extensively worked on Formula Columns, Summary Columns, Placeholder Columns and Ref Cursor Query for developing the reports, prepared complex Data Model and Data Layout in Oracle Reports.
    3. Worked on Advanced pricing API based on the requirement to change the item price by end dated the existing price list line item.
    4. Imported these invoices using standard AP invoice import.
    5. Customized Open Interface invoices form to handle exceptions during the invoice validation and import.
    6. Customized i-expense attachments page to view attachments (receipts of expenses) in a new window rather than opening up in same window Developed program to attach receipts from IPM system to the specific expense report.
    7. Developed AMG API to load a new classification for all the projects which has new expenditure type.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Diploma


Jr. Oracle Technical Consultant Resume

Objective : 9+ years of IT experience as a Technical Developer, experienced in Designing, Development, Enhancement, Customization, Implementation of Oracle Applications R12/11i Oracle Financials (AP, GL, AR) and (Oracle Manufacturing (PO, INV, BOM, WIP, OM, Advanced Pricing and Shipping), System administrator, iSupplier, iProcurement and Application Object Library (AOL).

Skills : Oracle Applications R12/11i Oracle Financials.

Description :

    1. Developed an Ordering Trend Report for the past 13 months using XML publisher.
    2. Developed new XML reports and also converted old reports6i to XML publisher reports.
    3. Developed an interface for monthly import of journal entries from payroll running on a legacy system by using the Journal Import Interface provided by Oracle General Ledger.
    4. Worked on Advanced pricing API based on the requirement to change the item price by end dated the existing price list line item.
    5. Used SQLLoader for importing, PL/SQL block validation of data and inserting into base tables.
    6. Customized using Form personalization making Vendor name as mandatory for all suppliers in purchase order.
    7. Customized the form personalization, warning when user exceeds the quantity in requisition form for Purchasing Module.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelor Of Science

Asst. Oracle Technical Consultant Resume

Summary : Over 8+ years of experience as Oracle Apps and PL/SQL developer in Analysis, Design, Data Modeling (Logical and Physical), Implementation of Business Applications using the Oracle Relational Database Management System. Experience with the Software Development Life Cycle (SDLC) process.

Skills : PL/SQL developer in Analysis, Design, Data Modeling.

Description :

    1. Designed the Item conversion program using PL/SQL to import items information from the legacy system to the Inventory Base tables.
    2. Designed and developed complete Vendor Interface for import of vendor information into the Oracle Account payables system.
    3. Used the SQL Loader viewed the errors in the log file and involved in rectifying the errors and then loaded the data into the interface tables.
    4. Developed custom activities and notifications to build complex workflow processes as per the business scenarios.
    5. Extensively worked on Formula Columns, Summary Columns, Placeholder Columns and Ref Cursor Query for developing the reports, prepared complex Data Model and Data Layout in Oracle Reports.
    6. Connected to Oracle and job included monitoring transactions between Oracle and WMS and other third party systems.
    7. Responsible for day to day monitoring of interfaces and working on issues reported by business users.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Bachelors Of Engineering

Associate Oracle Technical Consultant Resume

Objective : Working as Technical Lead. Familiar Oracle Quoting and Order Management Modules. Having Good Knowledge in SQL, PL/SQL, and AOL setups and basic knowledge on Oracle Forms, Oracle Reports, Xml Publisher, OAF Flexible to work with Environment and Tools. Excellent communication and interpersonal skills.

Skills : SQL, PL/SQL, and AOL setups and basic knowledge on Oracle Forms.

Description :

    1. Designed and developed/enhanced at many as 5 conversions, 2 interfaces and 1 extension.
    2. Supported Team lead in understanding and analyzing requirements.
    3. Captured requirements, collated and documented requirements.
    4. Worked with the Business user / leads / SME to get it approved.
    5. Collected & analyzed technical data to identify any trends and issues or areas of improvement for the delivery model or capability.
    6. Found out various plans and alternatives to identify the source of the problem.
    7. Performed a root cause analysis and suggested the best possible solution or work around.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelor Of Science

Oracle Technical Consultant III Resume

Objective : Over 8 years of experience in Oracle Applications (E-Business Suite) R12/11i on Analysis, Design, Development, Testing, Implementation, Version upgrades, Data conversions and Customizations. Strong knowledge of development tools such as Oracle Developer (Forms 6i/10g and Reports 6i/10g), PL/SQL, Workflow Builder and BI/XML Publisher.

Skills : Analysis, Design, Development, Testing, Implementation.

Description :

    1. Assisted in the preparation and review of the technical/functional documentation and maintains an effective library.
    2. Followed the standards/guidelines laid down while making designs/Specifications/development documentation.
    3. Developed interfaces required as per specifications to update inventory data using the data file from MRO database.
    4. Involved in writing PL/SQL Triggers, Procedures, Functions and Packages.
    5. Performed and owned the tasks to completion and help out other team members.
    6. Developed Oracle E-Business Suite using PL/SQL, SQLPlus, Workflow Builder, Application Object Library, Forms and Reports.
    7. Used the features of BI Publisher such as Sort, Group, Total, Subtotals to make data intense operations happen at the template level.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors In Computer Science And Technology

Oracle Technical Consultant II Resume

Objective : Enthusiastic and highly skilled individual with 7+ years of experience in the field of data warehousing, specialized in Oracle BIEE, Siebel Analytics, BI publisher, BI Concepts and Reporting tool. Over 9+ years of extensive experience in R&D and implementation of several applications related to both Client/Server and Internet Technologies involving Object Oriented Analysis, Design and Development.

Skills : Data warehousing, Specialized in Oracle BIEE.

Description :

    1. Developed various Interfaces, both inbound and outbound and implemented various Data.
    2. Developed new forms using Template.fmb (AU_TOP/forms/US).
    3. Customized Seeded Reports(Financial) in Oracle Applications.
    4. Developed a program to load external data from legacy system.
    5. Involved in Customer Conversion to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs.
    6. Created custom built forms with Oracle applications using t customized forms using Custom.pll.
    7. Designed and created custom form using Forms 10g tool to hold lookup cross reference values between legacy system and oracle apps.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelor's In Computer Science

Oracle Technical Consultant I Resume

Objective : Around 8 years of Professional experience on Oracle Applications as a Techno-Functional consultant, focused on Implementation, Upgrade and Customization of Oracle e- business suite Applications. This includes system study, design, development, post implementation maintenance and support of Oracle EBS.

Skills : Techno-Functional consultant, focused on Implementation, Upgrade and Customization.

Description :

    1. Worked on custom API to generate error, data files and import data from legacy system to ERP system.
    2. Developed to aid and assist the management committee in making various decisions regarding a customer.
    3. Maintained in Oracle, Star schema was used in the design process and Erwin was the data-modeling tool utilized to present the facts.
    4. Extensively used OBIEE Administration Tool for creating physical, business and presentation layers of repository.
    5. Merged two different Repositories using administration tool and Web Catalogs using Catalog Manager.
    6. Used job manager to manage and monitor iBots.
    7. Involved in Repository Configuration, Troubleshooting, Migration and Server Administration.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Entry Level
Education
Education
Bachelor's In Technology

Lead Oracle Technical Consultant Resume

Headline : Oracle SOA Middleware Consultant with 10+ years of experience in Oracle Technologies, including five end to end implementations with Oracle ERP. Have extensive experience in Oracle ERP implementation projects. 6 yrs. extensive experience with Oracle SOA 11g Fusion Middleware technologies including BPEL, OSB, WSDL, XSLT Design, Development and system implementation Hands on experience on various Oracle EBS modules: Order Management, BOM, Purchasing, Inventory, AR, and AP.

Skills : SOA, Middleware, OSB, WSDL, XSLT, Mediator, PL/SQL, Oracle EBS.

Description :

    1. Developed customized reports using XML Publisher & Discoverer Reports.
    2. Installed and Configured OBIEE Environment in the Organization.
    3. Involved in the Installation and Configuration of Oracle BI Suite.
    4. Worked on the entire life cycle of the project starting from Requirements Gathering, Analysis, Design, Development, System Testing and Production support.
    5. Involved in the complete Orderto Cash, Procure to pay cycle, Oracle Grants and Projects implementation.
    6. Worked on Project Costing to monitor Project Performance, Capitalize on Global Opportunities and Evaluate expenditures.
    7. Studied the Required business processes and suggested alternate ways to accomplish the same through Non-Customizations of Oracle Application in 11i.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Management
Education
Education
Bachelor's In Electronics And Communications Engineering

Oracle Technical Consultant Resume

Objective : Document MD70, Unit Test Plan TE020 and installation instruction document MD120. Developed interfaces required as per specifications to update inventory data using the data file from MRO database.

Skills : Document MD70, Unit Test Plan TE020 and installation instruction document MD120.

Description :

    1. Interacted with Oracle support for any escalated SR.
    2. Interacted with global business users for any issues and quick fix.
    3. Performed testing for the bug fixes and shared the output to Development Team.
    4. Developed interface program for conversion of sales orders using the Order Import Open Interface program.
    5. Developed interface program to import Purchase Order receipts from the legacy system to Oracle Applications.
    6. Supported Rollouts and Post Go Live Operations Daily interaction with client to understand existing business process and help client in understanding Oracle ERP features and processes.
    7. Reviewed team's work; coordinate with onsite team to resolve issues.
Years of Experience
Experience
0-2 Years
Experience Level
Level
Entry Level
Education
Education
Bachelors