We provide IT Staff Augmentation Services!

Development Lead/tech Lead Resume

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: s: Windows XP, Windows 7

RDBMS/ DB: 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

Hire Now