Oracle Consultant Resume Samples

HIGH QUALITY

The best examples from thousands of real-world resumes

EXPERT APPROVED

Handpicked by resume experts based on rigorous standards

DIVERSE EXAMPLES

Tailored for various backgrounds and experience levels

Oracle Consultants play a vital role in Oracle projects as they liaise with customers and development teams to make sure the best solutions are delivered. Typical duties mentioned on an Oracle Consultant resume example include determining potential risks, analyzing functional issues, solving technical problems, designing workflows, communicating with clients regularly, and updating Oracle applications. The ideal candidate demonstrates Oracle technologies expertise, problem solving orientation, attention to details, customer service skills and time management. Employers select resumes displaying a degree in a relevant field, like software engineering.

1

Oracle Consultant

Successfully completed an Oracle DBA engagement for a large manufacturing company upgrading to Documentum 6.

  • Completed an Oracle 9i to 10g upgrade of Test and Production database environments.
  • Integrated HP Data Protector with Oracle 10g RMAN incremental backups to tape.
  • Performed RMAN backup and recovery tasks as required, including configuration, monitoring, and troubleshooting.
  • Documented Install, Upgrade, and Database Best Practice for the customer.
Candidate Info
19
years in
workforce
2
months
at this job
BS
Computer Science
2

Associate Oracle Consultant

Deployment team member for Oracle EBS implementation for client ([company name])

  • Conducted various trainings for Sonoco manufacturing plant employees in the usage of Oracle EBS R12 (Manufacturing Suite) to improve inventory management
  • Reconciled Sonoco plant inventory prior to Oracle implementation with previous obsolete system
  • Assisted in the upload and transfer of primary data from previous system Baan to Oracle
  • Conducted personalized trainings for Sonoco workers based on their day to day activity
  • Trained and analyzed various inventory metrics with the use of Oracle reporting
Candidate Info
4
years in
workforce
2
years
at this job
BS
Business Administration
3

Technical Oracle Consultant

Designed, developed and implemented ETL process to convert vehicle history data from various agencies.

  • Designed, developed and implemented various Business reports using OBI
  • Developed Certified Pre Owner (CPO) program for Auto dealers writing Oracle Packages. Stored procedures and function.
  • Designed, Developed and Implemented various customized interfaces using PL/SQL on Oracle 10g
  • Tuned nightly batch processes to complete during nightly off time.
  • Provided level 2 supports to business user and modified existing reports Oracle Business Intelligence.
  • Wrote shell scripts to execute daily, weekly and monthly process through Control M.
Candidate Info
12
years in
workforce
11
months
at this job
MS
Electrical Engineering
MS
Information Systems
4

Independent Oracle Consultant

Implemented an email notification program to notify users of pending and completed tasks.

  • Developed multiple custom reports in the areas of Accounts Payable, Accounts Receivable, Purchasing and Human Resources
  • Researched and resolved Oracle software related issues resulting in patch application and/or setup changes.
  • Developed a custom program to generate a nightly Citibank Positive Pay file.
  • Provided end user support and training.
Candidate Info
3
years in
workforce
3
years
at this job
BA
Management Information Systems
5

Sr. Oracle Consultant

Performed infrastructure review across the Oracle platforms throughout the IT organization.

  • Performed Applications and Database tuning for Multiple databases
  • Significantly improved performance and maintainability of major application (Solumina) through DB tuning and working with application support resources
  • Led the upgrade and configuration of Oracle Enterprise Manger 12c which led to improved proactive DB monitoring for over 200 Oracle Database instances
  • Helped to define processes and standards - specifically significant in the SAP DB landscape
  • Tuned Database for 4 Diverse Applications - Product Life Cycle Management, Design and Engineering, Project Management and Manufacturing Design
  • Implemented Oracle Enterprise Management and Cloud Control for over 200 Oracle Database instances
  • Documented and created Oracle Performance tuning best practices for their business processes and mentored staff to continue the database performance initiative in place
  • Designed and trained permanent staff on implementing Oracle Automatic Storage Management (ASM) to support all new environments and for future upgrades of existing database instances
Candidate Info
9
years in
workforce
1
year
at this job
6

Oracle Consultant

Consultant responsible to work on a large database conversion project for [company name].

  • Worked on data models for telecomm equipments inventory and management
  • Implemented data conversion from legacy databases into Oracle 7.x
  • Designed and developed complex SQL scripts for data migration, error handling and reporting
  • Designed and developed SQL scripts for data cleanup
  • Created various forms and reports for the overall conversion process
  • Managed the go live project
Candidate Info
26
years in
workforce
1
year
at this job
BS
Computer Science
MS
Master of Science
7

Oracle Consultant

Developed/Migrated Merchant ETL Credit Card Application Data Module with Scheduling.

  • Developed Dynamic Scheduling report Engine process for customer transactions reporting.
  • Developed Java FTP package for periodical transfer of generated merchant reports.
  • Developed Thin Client J2EE JSF applications for Encrypted DSS Data Retrieval Testing.
  • Used Oracle Warehouse Builder for creating dimensions, fact tables, materialized views, mapping, deployment and scheduled periodical merging of object dimensions from source schema.
  • Implemented Streams/Change Data Capture (CDC) from server to server DSS data replication.
  • Ensured Data Security by oracle Transparent Data Encryption (TDE) and VPD policy.
Candidate Info
16
years in
workforce
3
years
at this job
AS
Banking
BS
Bachelor of Science
MA
Software Engineering
8

Oracle Consultant (home Lending)

Responsible for analyzing performance, recommending improvements and teaching improved techniques to the application development team for the Home Lending Operational Data Store.

  • Analyzed the longest running queries and determined how to make them more efficient. Combined multiple sequential queries on a single table into a single query.
  • Through direct system observation and analysis of AWR reports, determined that the system was dependent on outstanding SAN performance. When SAN response time was more pedestrian, application performance suffered badly. Analyzed bottleneck queries and determined that 4 index changes would eliminate table reads completely, reducing total required I/O. This change reduced the average sequential read rate per unit of work by 50% and improved the buffer cache hit rate from 79% to 95%. Application performance went from lagging several hours to current.
  • Analyzed issues raised by business users, tied them to root cause and designed solutions.
  • Designed and led implementation of a separation of the application into four parts to be run in parallel. This allowed it to scale as the volume increased.
  • Led team through sessions on how to read AWR reports, how to use Toad Session Browser and how to spot performance bottlenecks
  • Guided team members on process improvements and improved techniques for Oracle queries.
  • Assisted the team in improving technical design document writing
Candidate Info
31
years in
workforce
9
months
at this job
BS
Materials Engineering
9

Oracle Consultant

Worked on changes to custom Java and JSP interfaces to Oracle AR.

  • Created Oracle PL/SQL reconciliation reports for financial compliance.
  • Gathered requirements, designed, developed, tested and trained users on new functionality to ready to inject (RTI) drugs.
  • Created technical documentation.
  • Created interface for electronic claims submission. Designed new mappings between the HCFA 1500 paper claims and the electronic 837 XML standard.
Candidate Info
10
years in
workforce
9
months
at this job
BS
Computer Science
10

Oracle Consultant

  • Developed business areas, work books, implemented ad-hoc reports (oracle discoverer 9iAs Rel2) and uploaded to Microsoft xl spread required by concerned business users.
  • Integrated oracle reports (9iDS) to oracle portal (9iAs Rel2).
  • Designed and coded general database provider & portlets, which are used for portal integration.
  • Environment: Oracle 9i database, Oracle Applications 11.5.8, Oracle 9I discoverer release2, Developer 6i (Forms & Reports), Discoverer 9i , PL/SQL Web tool kit, Unix, Windows XP and SQL Navigator.
Candidate Info
11
years in
workforce
2
months
at this job

Your Resume, Made Easy.

You are looking for your dream job and need a resume? My Perfect Resume is your solution and takes the hassle out of resume writing. Create the perfect job-worthy resume effortlessly in just a few clicks!