We provide IT Staff Augmentation Services!

Sr Oracle Consultant Resume

SUMMARY

  • Over 15 yrs of professional experience with Oracle database and development, with 8 yrs of Sr. Level developer experience with SQL, PL/SQL, SQL TUNING, UNIX shell scripting experience.
  • Experienced in working with Health Insurance (Diamond and Amisys knowledge), Paramedical, Banking and Finance and Telecom domain, with extensive involvement in design, development, implementation and post implementation support of Database applications.
  • Have extensive worked experience in UNIX shell scripting and scheduling tools like CRONTAB, CTRL-M, Autosys and Appworx.
  • Experience in using Oracle SQL*Loader and IDE tools such as PL/SQL Developer, Toad and SQL Navigator with extensive Unit testing, test cases and DEBUGGING knowledge.
  • Expertise in Midlevel- DBA activities creating Indexes and Performance Tuning. Involved in data migration, creating various DB objects and on-call support activities for production systems.
  • Extensive experience in performance tuning and optimization of PL/SQL scripts and SQL queries using Explain Plan, TKPROF and Auto-trace.
  • Used ERWIN to design Normalized and De-Normalized Data Models.
  • Good Knowledge of complete Software Development Life Cycle, Data Acquisition, Data Integration and Data Loading. Familiar with Source control management tools like Clear case, VSS, PVCS and CVS.

TECHNICAL SKILLS

Operating System: UNIX (IBM AIX, Sun Solaris, HP UX), Windows 2000/NT

Languages: SQL, PL/SQL, Korn Shell, Python

Java Skills: Java, JSP, JDBC, Java Mail

DB/Utilities: Oracle 8i/9i/10g/11g/12c, SQL Server 2000, MS-Access

Oracle Tools: EXPLAIN PLAN, SQL* Loader, SQL*PLUS

ETL Tools: Informatica 9.1/9.5

Oracle GUI Tools: Toad, ERWIN, SQL Developer, PL/SQL Navigator, OEM

Internet Technologies: HTML, PHP, Java Script, XML

Documentation Tools: MS Word, MS Excel

PROFESSIONAL EXPERIENCE

Confidential

Sr Oracle Consultant

Responsibilities:

  • Developed new PL/SQL Package for Enrollment and Billing for Med Advantage and Meds Supplement members.
  • Intensively worked on the Annual Enrollment and new changes as per the government policies.
  • Developed Shell Scripts to call the newly build PL/SQL programs through shell scripts for automating batch programs with CTRL-M.
  • Tuned SQL Query for optimization in Oracle stored packages using Explain plan and Auto trace.
  • Used TKPROF (SQL * Trace) tool to analyze and fix multiple time-consuming SQL statements that were available in stored packages.
  • Involved in importing the production data to work environment through TOAD.
  • Extensively worked on OEM (Oracle Enterprise Manager) for development database issues.
  • Involved in DBA Activities like creation of DDL scripts along with Indexes and done SQL Query Optimization to enhance performance using Explain plan and Auto trace.

Environment: HP-Unix, J2EE, Oracle 12c, SQL, PL/SQL, TOAD, JIRA, OEM, ERWIN

Confidential

Oracle Consultant

Responsibilities:

  • Developed PL/SQL Package for migration of data from legacy systems to SAP systems.
  • Creation of LSMW files for the SAP load process.
  • Extensive use of SQL Loader to bring to data from Legacy systems to the staging environment.
  • Automating the data load using UNIX shell scripts and creating batch programs using Autosys tool.
  • Involved in DBA Activities like creation of DDL scripts along with Indexes and done SQL Query Optimization to enhance performance using Explain plan and Auto trace.
  • Involved in Unit testing and migrate the objects to the QA and UAT TEST environment.
  • Attending and Solving both QA and Production tickets for different projects at any given point of time.

Environment: HP-Unix, Autosys, Python, Oracle 11g/12c, SQL, PL/SQL, TOAD, SAP

Confidential

Oracle Consultant

Responsibilities:

  • Developed new PL/SQL Package for processing the fulfillment request for the corresponding templates and sending it to print vendor.
  • Worked very closely with functional team to understand their Development related requirements and created TDD (Technical Design Document) for the design provided in SDS (System Design Specification).
  • Created test scenarios for created code and distribute across to the QA along with Knowledge transfer.
  • Attending and Solving both QA and Production tickets simultaneously for different programs across different schemas at any given point of time.

Environment: HP-Unix, J2EE, WebSphere 7.0, Oracle 11g, SQL, PL/SQL, TOAD, DIAMOND, IBM Clearcase

Hire Now