Development Lead Resume Profile, NJ - Hire IT People

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 provide IT Staff Augmentation Services!

Development Lead Resume Profile

NJ

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship