We provide IT Staff Augmentation Services!

Oracle Developer Resume

5.00/5 (Submit Your Rating)

CA

Hire Now

SUMMARY:

  • Dynamic IT professional with 2+ years of experience in Software Analysis, Design, Data Modeling, Development, Testing, Implementation, Support and Documentation of Multitier Business Applications.
  • Expertise in PL/SQL Procedures, Functions, Packages, Triggers, Materialized views, Collections, SQL*Loader and External Tables.
  • Experience with Data Extraction and Data loading through multiple applications/Databases.
  • Intermediate knowledge of DBA Activities like Backup/Recovery, load Balancing, Tuning the applications, Space management, Table Partition.
  • Working knowledge of Documentation(Technical and Functional Specifications, Unit Test Case and Installation documents)
  • Experience in tuning of complex SQL statements using Oracle Hints, Explain plans, Bulk collects, bulk binds, TKPROF, SQL Trace, SQL Profiler and Indexing.
  • Experience in SDLC (System Development Life Cycle) methodology.
  • Worked on large databases over ~4TB of data/ over billions of rows. Actively involved in creating database objects and deploying them through forms applications.
  • Strong interpersonal skills and ability to interact with people at all levels.

PROFESSIONAL EXPERIENCE:

End client: MMC20/20, Regence and Kaiser Jan 2010 to Present Client: Confidential, CA Project: Dtraq Active management (PDE, RDS and COB)

Project Description: The Confidential produce front-end and back-end application solutions to MMC20/20 which in turn provides the strategic, operational and financial consulting services required to deal effectively with CMS challenges. This is Medicare Application development, modification, enhancement and support project. As an Oracle Developer for PDE modules, my responsibilities are analysis, developing and tuning the complex scripts for Application development and enhancement and pulling ad-hoc reports for business requirements. Responsibilities:

  • Hands on experience on new features of Oracle 10g and 11g.
  • Expert in doing the data analysis and digging to find out the dependent fields for the transformations and manipulations of data.
  • Designed, developed, debugged Packages, triggers, views, tables, indexes, pipe functions, types and optimized using AWR, Sql Tuning Advisor, Explain plan, SQL trace and parallel techniques for Prescription drug event loading, calculating pde event cost in different phases for the member and Plan by considering various business constraints.
  • Created automated imports to load partial PDE claims, Rx claims, Error claims and cms return claims and scheduled automated jobs for admin packages.
  • Gathers business requirements (Business flow charts), issues and converted them into back-end code.
  • Worked on client production databases to resolve and debug high priority issues and to do undo DML transaction in case of abnormal transaction calculation because of the code bug's and user errors.
  • Loaded and unloaded data sets from or to Oracle Databases using several kinds of tools such as SQL*Loader, sql*Plus scripts, UTL, Toad and Oracle Import/Export Facility.
  • Used version control tools like Microsoft visual studio WinCvs to store back end code versions and front end code deployment.
  • Created some executable programs running in UNIX operation system for Loading files to oracle DB tables and Creating ZIP files from oracle DB tables.
  • In depth knowledge on oracle memory structures, storage structure and oracle background processors.
  • Created metadata backup for master tables ,PL/SQL subprograms, monitored DB space usage and execution of scripts to avoid lopping of automated jobs.

Environment: Oracle 10.2.0.4.0 and 11g, Windows, UNIX and DB SIZE 3 terabyte

Database Tools/Utilities: SQL* Loader, Expdp/IMPdp, TOAD 9.5.

SOFTWARE SKILLS:

  • Languages: C , Java, SQL, PL/SQL, XML, XPath, XQuery, XSLT, UML, HTML
  • Operating Systems:
  • Databases: Oracle 10g/11g, MySQL
  • Query Tools: TOAD, SQL*PLUS
  • Packages: Microsoft Office Suite- MS-Word, MS-Excel, MS-Power point

PROFESSIONAL QUALIFICATION:

  • Master of Engineering - Communication Systems
  • Bachelor of Engineering - Electronics and Communication

TRAINING & CERTIFICATION:

  • Attended training on technologies like SQL, PLSQL, XML, UML, Relational Design Theory.
  • Attended training in Embedded Systems Programming and Artificial Intelligence.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship