We provide IT Staff Augmentation Services!

Oracle Application Developer Resume

2.00/5 (Submit Your Rating)

NJ

SUMMARY

  • Senior Oracle PLSQL Developer with proven technical expertise in IT career spanning > 10 years.
  • Master degree holder in Computer Software Applications
  • Experienced in all phases of SDLC including requirements gathering, analysis, customer interaction, design, development, testing, deployment, support & maintenance.
  • Possess excellent analytical skills, strong problem - solving skills & multi-tasking skills, good organizational skills, detail-oriented approach and outstanding oral & communication skills.

TECHNICAL SKILLS

SOFTWARE: Oracle 11g, 10g, 9i/8i, TOAD 9.7.2, PL/SQL, Oracle BI Reports and Analytics, Dashboard, PowerBuilder 10/8.0/6.5, Visual Basic 6.0, Crystal Reports 11/8.5/7, Oracle Applications 11i (11.5.9), Oracle Forms 6i/Reports 6i, Developer/2000, SQL Server 2000/7.0/6.5, SQL*Plus 10.2/3.3, UltraEdit-32, MS Excel/Word, PowerPoint, C, C++, VBScript, OOP, HTML.

RDBMS: Oracle 11g, 10g, 9i/8i, MS SQL Server 2000/7.0/6.5, Sybase, MS Access 2000

OPERATING: Windows XP, Windows NT 4.0, Windows 98, Sun Solaris 5.8, Linux, UNIX

PROFESSIONAL EXPERIENCE

Confidential, NJ

Oracle Application Developer

Responsibilities:

  • Using Dynamic Cursors and SQL to fetch data based on parametric inputs, thereby making individual processes more generic, functional, stable and easy to use & maintain.
  • Performance tuning with Explain Plan at every level to achieve greater performance and increasing throughput.
  • More than 1000 edits by creating triggers and procedures at right levels, to help ensure the accuracy of data entered.
  • Views & stored procedures to increase productivity and performance.
  • ETL scripts to load and massage complex client data from input files into our database to maintain integrity and constraints.
  • Developed processes and controls to ascertain the Medical data files use the standard NCCI-compliant format with regard to file formats, codes, identification numbers, etc. for eligibility information, premium payments, claims submissions,
  • Providing estimates on project time-lines | Requirement gathering | Analysis & Data mapping | Design & development | Testing from pre-edits to extensive test scenario | production deployment, post-production support and maintenance.
  • iTAKE Application - Worked on the automation of IAIABC EDI FROI & SROI form submission & reports to the Labor Dept. of Worker’s Compensation for all Jurisdictions (52 states) using Oracle, BI reporting tool.
  • iCLMS Application (Tristar’s Disability Claims & Payment Processing Application) - Worked on the automation of W2 & 1099 processes and maintenance of other key functionalities.
  • EDI - Developed processes for electronic reporting of transmission of Claims, Proof of Coverage, and Medical Bill Payment information to the Department of Labor for all 52 Jurisdictions.

ENVIRONMENT:Oracle 11g/10g, PL/SQL, TOAD 9.7.2.5, SQL*Plus 10.2, Oracle BI Publisher, Crystal Reports 11, RMX R7, Ultraedit 32, Intersolv PVCS v6, Merant Tracker v 8.0.3.

Confidential, PA

Programmer Analyst & Technical Support

Responsibilities:

  • Planning, designing and developing a Tracking Monitor to identify processes that were causing backlogs resulting in backlog reduction & cutting lead time significantly.
  • Developed Email-Notification and Barcode printing into the system, to provide a secured channel to communicate with the brokers and submit the deliverables in a proper, timely manner.
  • Making sure processes are adhering to HIPPA rules and guidelines for compliance purposes.
  • Single handedly migrated from PowerBuilder 6.5 to 8.0 to v10 | Oracle 8i to 9i & provided Post-Migration Support.
  • Assisted in converting Claim Entry System from PowerBuilder to Java 1.2 using IBM Visual Age v3.0.

ENVIRONMENT:PowerBuilder 6.5/8.0/10,Java 1.2, IBM VisualAge 3.0, Oracle 8i/9i, PL/SQL

We'd love your feedback!