EXPERIENCE SUMMARY:

• Over 7 years of experience in Oracle PL SQL Developer.
• Comprehensive Experience in Analysis, Design and Development (Coding, Testing & Maintenance) of various types of oracle technology based projects in multi - tier environment for Banking sector.
• Extensive database development skills using SQL, Stored Procedures, Functions, and Packages in PL/SQL for Relation Databases Oracle .
• Develop a package to authorize the banking transactions and to do the money transfers.
• Involved in database design by following DDL standards - naming conventions, column order, indexing, table spaces, referential integrity constraints, default values, column check constraints, primary keys, and permissions.
• Develop a customize process with PLSQL to provide the prepaid cards to the employees by the bank.
• Supported development effort by providing SQL statement tuning and optimizing procedures and removing load and query performance bottlenecks by using tools Explain Plan, TOAD.
• Prepare design of Critical components & Develop prototype to present client to get sign off on requirement.
• Extensive experience in loading large number of data using SQL LOADER.
• Prepared Technical design document, Use cases, Test cases and User manuals for various projects and good at Bug fixing, Code reviews, and Unit & System testing.
• Extensive knowledge in working with Oracle 9i/10g/11g, PL/SQL, TOAD, SQL*Loader.
• Performing responsibility as mentor for the new comers in the project by conducting knowledge sharing sessions on Oracle PLSQL and SQL.

TECHNICAL SKILLS:

Environment: Windows XP, Windows 7

Oracle: 9i/10g/11g

Methodologies & Tools: PLSQL Developer, Toad, Visual source Safe(MSVSS), Team Foundation Server(TFS)

Domain Knowledge: Banking

PROFESSIONAL EXPERIENCE:

Confidential

Development Lead/Tech Lead

Responsibilities:

• Develop Authorizer code in PLSQL Package.
• Use features of Oracle for PL/SQL programming like Cursors, Dynamic SQL, Nested Loops, PLSQL Tables, Nested Tables, and Varrays to perform transaction activities.
• Worked with Onsite for requirement gathering and analysis.
• Worked with the team members that the initiatives being delivered by are of a high standard in terms of application design and code quality.
• Involved in development/testing activity of different subject area of the Banking.
• Doing the code walkthrough, system testing and regression testing of critical functionality in the Banking.
• Worked in deployment of the solution and release management.
• Involved in performance tuning of the application from database.
• Conducted team meetings, lead the team, provided advice on how process and procedures may be improved to promote good coding practice amongst the team.
• Develop Oracle PLSQL Procedures to carry out the prepaid card activities of the Bank.
• Used packages like UTL FILE for writing the statement files, debug files etc.
• Tuned SQL queries, developed for prepaid card using Explain plan.

Environment: s: Windows XP, Oracle 10g, Pl/Sql Developer, Toad

Confidential

Senior Developer

Responsibilities:

• Design & Developed Database Stored Procedures and Views using oracle 10g.
• Developed Packages, Cursors using Oracle 10g.
• Prepare test case and script to perform Home loans development in dev environment
• Document development phase and prepare component level design documents for each component moved to production.
• Prepare weekly status reports to report ongoing activity to higher management.
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Used Analyze, Indexes for fine-tuning the SQL and PL/SQL.
• Supported development effort by providing SQL statement tuning and optimizing procedures and removing load and query performance bottlenecks by using tools Explain Plan, TOAD.
• Created the indexes to optimize the performance of the data retrieval process.
• Analysis of the Defect/Enhancement raised by different customers, design of the system and finding the total impact of the module.
• Coding, Deploying and Testing for various business functionalities using Oracle PLSQL Procedure, Functions & Packages.

Environment: Windows XP, Oracle 9i, Oracle Pl Sql, Pl/Sql Developer

Confidential

Developer

Responsibilities:

• Analyzed the existing system functionality, screens, and database structure of existing application.
• Writing complex PL/SQL code and SQL queries.
• Develop backend procedures by using PL/SQL
• Wrote triggers and packages by using PL/SQL for giving security privileges
• Prepared the Test conditions and test scripts using standard templates.

Environment: Windows XP, Oracle 9i, Oracle Pl SQL, Pl/Sql Developer, Toad

Confidential

Developer

Responsibilities:

• Understanding the functionality of the products and responsible for Product Customizations as per customer requirements
• Analyzing the support tickets raised by various customers and providing the fix for the same.
• Adhering to SLA (Service Level Agreement).
• Involved in Weekly status meeting
• Involved in Document preparations.
• Involved in maintaining the Error Reports.