Oracle Application Developer Resume
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