We provide IT Staff Augmentation Services!

Development Lead Resume Profile

2.00/5 (Submit Your Rating)

NJ

EXPERIENCE SUMMARY

  • Over 7 years of experience in Oracle PL SQL Developer.
  • 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 experience in loading large number of data using SQL LOADER.
  • Prepare design of Critical components Develop prototype to present client to get sign off on requirement.
  • Supported development effort by providing SQL statement tuning and optimizing procedures and removing load and query performance bottlenecks by using tools Explain Plan, TOAD.
  • Develop a customize process with PLSQL to provide the prepaid cards to the employees by the bank.
  • 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 package to authorize the banking transactions and to do the money transfers.
  • Extensive database development skills using SQL, Stored Procedures, Functions, and Packages in PL/SQL for Relation Databases Oracle.
  • 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 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:

Environments

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

Title : Development 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.

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

Confidential

Title : 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

Title : Developer

Responsibilities:

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

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

Confidential

Title : 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.

We'd love your feedback!