Oracle Technical Consultant Resume Samples

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.

Experience

2-5 Years

Level

Executive

Education

Bachelor Of Science

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.

Experience

2-5 Years

Level

Executive

Education

Diploma

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.

Experience

2-5 Years

Level

Executive

Education

Bachelor Of Science

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.

Experience

10+ Years

Level

Senior

Education

Bachelors Of Engineering

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.

Experience

2-5 Years

Level

Junior

Education

Bachelor Of Science

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.

Experience

2-5 Years

Level

Junior

Education

Bachelors In Computer Science

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.

Experience

2-5 Years

Level

Junior

Education

Bachelor's In Computer Science

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.

Experience

2-5 Years

Level

Entry Level

Education

Bachelor's In Technology

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.

Experience

5-7 Years

Level

Management

Education

Bachelor's In Electronics

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.

Experience

0-2 Years

Level

Entry Level

Education

Bachelors