We provide IT Staff Augmentation Services!

Sr Application Developer Resume

2.00/5 (Submit Your Rating)

OBJECTIVE:

As an Oracle Developer, quest to work in the professional atmosphere where i can use my knowledge and experiences and also which enables me to cope - up with the emerging as well as new technologies which in turn, I can use them for the success of the organisation

PROFESSIONAL SUMMARY:

  • Having around 8+yrs of experience in Oracle PL/SQL and Oracle Applications ( Confidential )
  • Sound knowledge of Confidential R12 Upgrade. Good knowledge in Fincial Accounting Modules Accounts Payables (AP), General Ledger (GL), Fixed Assets (FA).
  • Very Good Understanding on Subledger Accounting (SLA) module, the new generalized concept of Oracle Applications Rlease 12 and on Global Accounting Engine (AX), a specialized (dealing with limited sub ledgers like AP, AR and Costing) Oracle Applications 11i module similar to Subledger Accounting in R12.
  • Good experience in tuning techniques to optimize the performance of SQL queries and PL/SQL Blocks Using optimization tools like TKPROF, Explain Plan, Dbms Profiler, SQL Trace and AWR report
  • Extensive experience in Oracle 11g/10g/9i,Oracle 10g reports, SQL*Loader, RICE Components and Oracle SQL Developer.
  • Knowledge and work experience in Virtual Private Database and oracle packages DBMS LOB, DBMS PROFILER, DBMS SCHEDULER, UTL FILE and many more
  • Extensive experience in writing PL/SQL Packages, Functions, Procedures, External tables, Types, Views, Indexes &Triggers to implement business logic.
  • Knowledge and exposure to Unix and Shell Scripting
  • Extensively used ETL methodology for supporting Data Extraction, transformation and loading processing, in a corporate-wide-ETL Solution using Informatica and OWB (Oracle Warehouse Builder)

TECHNICAL SKILLS:

Application Development Tools: XML Publisher, Oracle Application Framework

Application Package: Oracle Applications E-Business Suite R12

Oracle Tools: Oracle Developer, PL/SQL Developer, TOAD, Export & Import, SQL Loader

Databases: Oracle 9i/10g/11g

Languages: SQL, PL/SQL, HTML, Javascript, Java

Operating Systems: Windows XP

ETL Tools: Informatica 8.1, OWB

PROFESSIONAL EXPERIENCE:

Confidential

Sr Application Developer

Responsibilities:

  • Handled many performance bugs. Dealt with SQL Trace, TKProf, Hints and Statistics.
  • Maintained the internal forums for techno functional questions.
  • Modified the existing Stored Procedures and packages for various modules in the application.
  • Worked on various Codefixes and Enhancement Requests.

Environment: Oracle 11g, Oracle Applications 11i/R12, Confidential, Oracle SQL developer, UNIX, Shell Scripting

Confidential

Database Engineer

Responsibilities:

  • Involved in Exporting and Importing tables.
  • Involved in data loading across different schemas
  • Involved in comparing the schemas to compare both the structural and data differences
  • Involved in writing the SQL queries to the application team members
  • Involved in tuning the performance of the queries
  • Written Stored Procedures and cursors for various modules in the application.

Environment: Oracle 11g, SQL, PL/SQL, SQL Developer, TOAD, Webworks, UNIX, Shell Scripting

Confidential

Module Lead (Sr. Support Engineer)

Responsibilities:

  • Involved in identifying the problems in the issues reported in production
  • Involved in making the fixes to the bridge cases(issues raised in production)
  • Involved in various calls between different teams from different companied with in the BT-UII
  • Conducting interviews to take the new members into the team
  • Involved in code reviews for the code written by other team members.

Environment: Oracle 9i, SQL, PL/SQL, SQL Developer, Weblogic 8.1, Tortoise SVN

Confidential

Module Lead (Sr. Database Developer)

Responsibilities:

  • Conducting interviews to take the new members into the team
  • Involved in code reviews for the code written by other team members.
  • Involved in writing PL/SQL blocks which implement business logic.
  • Involved in Exporting and Importing tables.
  • Working on Performance Tuning in order to increase the performance of the application in exporting report (CLOB Data).
  • Working on all the query changes in the entire application which involve in Virtual Private Database (VPD) context.
  • Responsible for creating/ monitoring the user scheduled jobs.
  • Responsible for creating the installation guide (contains the steps to apply the release/patch on the production/Test environment) to the client.
  • Involved in writing PL/SQL blocks which implement business logic.
  • Involved in Exporting and Importing tables.

Environment: Oracle 10g, PL/SQL, SQL Developer, PL/SQL Developer, Putty, WinSCP, OC4J, Eclipse, Tortoise SVN, UNIX

Confidential

Database Engineer

Responsibilities:

  • Conducted sessions for Version Control System and knowledge transfer of the project to the new team members
  • Involved in writing the SQL queries to the application team members
  • Unit testing, Build and Deployment related activities
  • Responsible for creating/updating the Use case and TSD documents. Involved in creating UML diagrams

Environment: SQL, PL/SQL, Core Java, HTML, Eclipse, Aqua Data Studio 6.5, Jude 5.0, Tortoise SVN, UNIX

We'd love your feedback!