We provide IT Staff Augmentation Services!

Senior Oracle Consultant Resume

4.00/5 (Submit Your Rating)

SUMMARY

  • Over 12 years of experience in the Information Technology with good knowledge and experience in Oracle Database Client Server Architecture.
  • Technically proficient in Implementation, Data Migration and Production Support.
  • Extensive experience on Oracle Database 8i/9i/10g/11g on Windows and Unix/Linux environment.
  • Extensive Experience on Procedures, Functions, Packages, Triggers, Materialized views, SQL* Loader, Data Loader, UTL FILE, Forms6i, Reports6i, Interfaces, Conversions Unix Shell Scripting, CRON scheduling.
  • Extensive Experience with Data Extraction and Data loading through multiple applications/ Databases.
  • Extensive Knowledge on DBA Activities like Backup/Recovery, load Balancing, Tuning the applications, Space management, Table Partition, Schema/Table level gather stats.
  • Experience in tuning of complex SQL statements using Oracle Hints(Hash & Nested Loops), Explain plans, Bulk collects, bulk binds, Parallel Process, TKPROF, SQL Trace, SQL Profiler and Indexing, Verifying AWR reports, SQL PLAN and histories, Gather Stats.
  • Extensive experience on Oracle Advance Technologies Oracle Advance Queuing, OLTP, OLAP, External Tables and Table Functions.
  • Extensive Knowledge on Dataware house and ETL tools.
  • Extensive experience with front end applications (Java,.Net, VB,D2K).
  • Extensive experience with AIM Documentation.(Technical and Functional Specifications, Unit Test Case and Installation documents).
  • Involved in User Acceptance Testing,data validation, data integrity, functional testing, and system testing.
  • Worked on large databases over ~1TB of data. Actively involved in creating database objects and deploying them through forms applications.
  • Experienced in full life cycle of project development especially with SDLC (System Development Life Cycle) methodology.
  • Participation in the analysis, development, debugging, modification and enhancement of forms and reports.
  • Experience with reporting tools XML Publisher, Discoverer and Business Objects.
  • Used SQL*Navigator, SQL Developer, TOAD and PL/SQL Editor.
  • Used Wincvs, PVCS, Clear case and STAT, Celar Quest, Migration/version Control tools.

TECHNICAL SKILLS

ORACLE TOOLS: Oracle 7.x/8.1.7/9i/10g,Oracle Forms 4.5/6i, Oracle Reports 2.5/6i, PL/SQL, SQL*PLUS, SQL*loader, Toad 7.2/8.0.2

RDBMS: Oracle 7.x/ 8.x/8i, MS Access

Front End Tools: Developer 2000, Visual Basic,.NET, Java

LANGUAGES: SQL, PL/SQL, C++, HTML

TOOLS: Toad, SQL Navigator, PVCS, Clear case, SQL Navigator, Wincvs, Winscp, WS FTP

OPERATING SYSTEMS: Windows 9x/NT 4.0/2005, Unix

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Consultant

Responsibilities:

  • Designed and developed the interface of Groupings (BO/SF/F/A), Instruments, Positions, and stress data, regulatory/house calc output data .
  • Developed the database objects like Tables, Sequences, Synonyms, Indexes, Procedures, Functions, Packages, collection types, Materialized views etc.
  • Data loaded using SQL* Loader, External Tables and extraction done using UTL FILE (.txt, .csv).
  • Created new schemas using schema refreshes for testing and development purposes.
  • Used the Advance technologies like Table functions, Bulk Bind, Bulk collect, Collections (Varrays and Nested tables), Partition Tables and Materialized View.
  • Prepared common utility package for total project it includes (messaging, partition creation and table/partition level gathering statistics).
  • Supported the Quality Assurance, User Acceptance test and live phases.
  • Guided technically to other team members of my team.
  • Performed performance tuning the oracle objects using partition tables, global temporary tables, bulk binding, Indexes etc.
  • Responsible for deployment process like code management, check in and deploying into different environments.

Environment: Oracle 11g, Java, PL/SQL Developer, SQL* Loader, Triggers, Unix, Clear Case.

Confidential

Senior Oracle Consultant

Responsibilities:

  • Designed and developed the Pricing list conversion.
  • Designed and developed the data base object like procedures, functions, packages, staging tables, Synonyms, Sequences, Indexes, Temporary Tables.
  • Used the Advance technologies like Table functions, Bulk Bind, Bulk collect, Collections (Varrys and Nested tables), Partition Tables and Materialized View.
  • Designed and developed Initial Order Shipment Confirmation email notification.
  • Performed scheduling jobs in Unix and implemented complex shell scripts.
  • Performed performance tuning (Partition Tables, Materialized view, Parallel Process, TKProf, SQL Trace, Oracle HINTS( HASH and Nested Loops) and Explain Plan).
  • Developed Synonyms, constraints and indexes.
  • Prepared Technical Design and Installation Documents.
  • Working on multi - tasking for different branches and different customers.
  • Prepared and ran script for creating tables, indexes etc.

Environment: Oracle 11g, Java, PL/SQL Developer, SQL* Loader, Triggers, Unix, Clear Case.

Confidential

Senior Oracle Consultant

Responsibilities:

  • Developed the database objects like Tables, Sequences, Synonyms, Indexes, Procedures, Functions, Packages, collection types, Materialized views etc.
  • Data loaded using SQL* Loader, External Tables and extraction done using UTL FILE (.txt, .csv).
  • Created new schemas using schema refreshes for testing and development purposes.
  • Used the Advance technologies like Table functions, Bulk Bind, Bulk collect, Collections (Varrays and Nested tables), Partition Tables and Materialized View.
  • Prepared common utility package for total project it includes (messaging, partition creation and table/partition level gathering statistics).
  • Supported the Quality Assurance, User Acceptance test and live phases.
  • Guided technically to other team members of my team.
  • Performed performance tuning the oracle objects using partition tables, global temporary tables, bulk binding, Indexes etc.
  • Responsible for deployment process like code management, check in and deploying into different environments.

Environment: Oracle EBusiness sutie R12, Oracle 10g, Java, PL/SQL Developer, SQL* Loader, Triggers, Unix, ClearCase and Clear Quest.

Confidential

Senior Oracle Consultant

Responsibilities:

  • Involved in the FDERS Account Data Conversion.
  • Designed and developed Packages for Amortization, Merchant, Mass and batch letters, and Recovery.
  • Designed and developed tables and triggers for Amortization, Mass and batch letters.
  • Developed database objects Procedures, Functions, Packages, Synonyms, Constraints, Indexes, and External Tables.
  • Performed performance tuning (TKProf, SQL Trace and Explain Plan).
  • Prepared Complex Unix Shell Scripts.
  • Prepared Technical Design and Installation Documents.
  • Working on multitasking for different branches and different customers.
  • Data loaded from flat file to tables using SQL* Loader from legacy applications.
  • Data Extracted to flat file using UTL FILE.
  • Involved in day-to-day database maintenance, Partition tables, Unix Job Scheduling.
  • Prepared and ran script for creating tables, indexes etc.

Environment: Oracle 10g, Java, PL/SQL Developer, SQL* Loader, Triggers, Unix.

Confidential

Senior Oracle Consultant

Responsibilities:

  • Performed performance tuning (TKProf, SQL Trace, Oracle HINTS(HASH and Nested Loops) and Explain Plan).
  • Used the Table functions in Packages to improve the performance.
  • Data loaded from flat file to tables using SQL* Loader.
  • Designed and developed Un Invoiced Late Procedure.
  • Designed and developed Sales Tax PL/SQL Report.
  • Designed and developed Stamp Duty PL/SQL Report.
  • Designed and developed Partial Payments Late Interest Package
  • Designed and developed Sales Orders Conversion Package.
  • Designed and Developed AR Invoices Conversion Package.
  • Used for materialized view for the customer data.
  • Designed back end tables structures.
  • Prepared unix shell scripting programs.
  • Working on multitasking for different branches and different customers.

Environment: Oracle EBusiness sutie R12, Dataware house/ ETL tools, Oracle 10g, PL/SQL, SQL*Plus, SQL* Loader, Triggers, Unix, TOAD, SQL Developer, STAT (Migration TOOL), SVN(Version Control Tool)

Confidential

Senior Oracle Consultant

Responsibilities:

  • Performed database design (Views, Database triggers, Materialized views, packages, functions, and procedures).
  • Performed performance tuning(TKProf, Explain plan).
  • Data extraction using UTL FILE.
  • Involved OLTP database design.
  • Scheduled the nightly jobs using DBMS Scheduler.
  • Implemented Advance Queing for message transmission between different programs.
  • Developed control scripts for SQL*Loader for loading data from flat file to Oracle.
  • Involved in taking the backups from day to day and make sure of the servers maintenance.
  • Prepared unix shell scripting programs.
  • Running script for creating table spaces, tables, indexes etc.
  • Developed Packages to extract data and populate tables in CSV format for reporting.
  • Involved in developing packages to convert data from legacy to Oracle.

Environment: Oracle EBusiness sutie 11.5.10, Oracle 10g, PL/SQL, SQL*Plus, OLTP, SQL*Loader, Unix, TOAD

Confidential, TX

Team Lead

Responsibilities:

  • Interacting with business user to gather requirements and object wise clarifications.
  • Arrange meetings with team members.
  • Reviewing the objects of team members.
  • Performed performance tuning(TKProf, Explain plan).
  • Attending conference calls with business users and team members for clarifications.
  • Objects estimation.
  • Daily/weekly status reports.
  • Involved in developing Views, Database triggers, packages, functions, and procedures
  • Working on multitasking for different branches and different customers.
  • Prepared Technical Design Document and Installation Document for the project.

Environment: Oracle EBusiness sutie R12, Oracle 10g, PL/SQL, SQL*Plus, SQL*Loader, Unix, TOAD.

Confidential

Offshore Technical Lead

Responsibilities:

  • Receive the objects from on-site and review the objects.
  • Estimation of the objects.
  • Allocation of the objects to team members.
  • Attending conference call with business users for objects clarifications.
  • Daily/weekly status reports.
  • Creation of users, managing privileges.
  • Resolving user’s day-to-day issues.
  • Supported several developers with Oracle related support for database access and Performance tune applications.
  • Performed SQL tuning, analyzing and optimization.
  • Used Wincvs version control to check in and check out files

Environment: Oracle EBusiness sutie 11.5.3, Oracle 9i, PL/SQL, SQL*Plus, SQL*Loader, Unix, TOAD, Wincvs.

We'd love your feedback!