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