PROFESSIONAL SUMMARY:

• A dynamic professionalwith9 yearsof experience inSoftware Development Life cycle as an Oracle Developer/PL/SQL Developer, which includes Analysis, Development, Implementation and testing& Team Management.
• Expertise in Database Design and Development usingOracle 11g/10g/9i/8i, Web deployment using Oracle 9iAS, PL/SQL, Oracle SQL Loader.
• Excellent skills in writingPL/SQL Stored Procedures, Triggers, Packages, Constraints and Fine - Tuningthem.
• Creating workflows, Mapping andscheduling jobs inINFORMATICA
• Well versed in UNIX Commands & Scripting (Shell and Perl).
• Experience in writing SQL queries for relational databaseslike Oracle 10g/9i.
• Hands on experience on writing Queries, Stored procedures, Functions and Triggers by usingPL/SQL.
• Interaction with clients forbusiness gathering, conducting system analysisand finalizingtechnical / functional specificationsand high level design documents for the project.
• Demonstrated excellence in understanding of all phases in the software life cycle entailingrequirement study, analysis, design, development, testing, implementation and support.
• Expert in Banking & Financial Domain including banking products likeFinnOne.
• Thorough understanding of the life cycle ofLoan Management System (LMS) with proficiency in mapping business requirements, application design, development, integration, testing and troubleshooting for Information Systems Management.
• An effective communicator with exceptional relationship management skills with the ability to relate to people at any level of business and management.
• Experienced in creating various project artifacts like use-case documents, class diagrams, design document, architecture document, etc.
• Expert in translating the Technical understanding of products/projects in technical/understanding documents that serve as base of understanding to new members and repository of knowledge to Team.
• Experience to communicate with End client to understand the business requirement and prepare business document.
• As a lead engineer involved in code review of all the team members.
• UsedClear caseas control management tool.
• Highly organized with the ability to manage multiple projects and meet deadlines.
• Have the motivation to take independent responsibility as well as ability to contribute and be a productive team member.
• Managing the end-to-end implementation of the project including designing, development, testing, implementation and support of software applications.
• Providing post-implementation, application maintenance and enhancement support to the client with regard to the product / software application and extending post go-live support to the user department.

TECHNICAL SKILLS:

Operating Systems: HP-UNIX 10.2, Windows 95/98/NT/XP.

Programming Languages: PL/SQL,SQL*Plus, HTML, UNIX shell scripts,C, C++, XML

Databases: ORACLE 11g/10g/9.x/8.x/7.xTools / Utilities: Oracle Forms 6i/9i/10g, Reports 6i/9i/10g, SQL LoaderTOAD, SQL*Plus, VB 6.0, D2K,, VSS, Autosys,ETL tools.

System Networks: Oracle Net, HTML, Windows Servers, OLAP/MSMQ series, ODBC, DHTML

PROFESSIONAL EXPERIENCE:

Confidential, Brea, CA

Sr. Consultant

Responsibilities:

• Enhancement of Hypo Response report.
• Developing Views in Netezza database for esourcing project
• Development for Fluid management project.
• Performance tuned the Monthly Augmented report. TAT 20 minutes from 24 hrs.
• Responsible for code development using PL/SQL
• Responsible for Data migration using SQL loader and PL/SQL code.
• Responsible in code review and design doc preparation
• Preparation of Test Plans. working on Database like Mysql, Netezza and Oracle.

Confidential, Houston, Texas

Sr. PL/SQL Developer

Responsibilities:

• Applying business logic and creating data forecast models for business users.
• Customer Value score development for Green Mountain (NRG subsidiary).
• Responsible for production support.
• Developed various procedures, functions and packages to implement the new business using Oracle PL SQL.
• Responsible for code development using PL/SQL
• Developedmapping’s,workflowsand scheduling Job inINFORMATICA
• Responsible for Data migration using SQL loader and PL/SQL code.
• Responsible in code review and design doc preparation
• Preparation of Test Plans.

Environment: Oracle 11.1.0.7.0 , PL/SQL Developer 7.1.4.1390 , UNIX

Confidential, Houston, Texas

Sr. PL/SQL Developer

Responsibilities:

• Gathering business requirements from end users.
• Modifying existing reports to cater the new business requirements.
• Request reports from frond end report module and then Running modified reports using UNIX shell scripts.
• Developed complex scripts for the data analysis to check the quality of data using regular expressions at database level.
• Developed various procedures, functions and packages to implement thenew business using Oracle PL SQL.
• Statement level, row level database triggers were developed for auto updating the data.
• Responsible for code development usingPL/SQL in UNIX environment.
• Responsible for scheduling jobs fromCRON using PERL and SHELL scripting
• ResponsibleforData migrationusingSQL loaderandPL/SQL code.
• Responsible in code review and design doc preparation.
• Was responsible to communicate with End client to support the application and analyze the issue and fixed the issue.
• Preparation of Test Plans.
• Responsible for the yearlyROLLOVERprocess.
• Responsible for migration theSQL serverdatabase for “LOCATION” schema to ORACLE platform
• Responsible for making technical document for the TAX portal and Data migration process.

Environment: Oracle 11.1.0.7.0 , PL/SQL Developer 7.1.4.1390 , UNIX

Confidential, NJ

Sr. PL/SQL Developer

Responsibilities:

• Production support at onsite (USR New Jersey ) from as Project Lead and responsible for handling onshore and off shore team of 4 members.
• Responsible for code development usingPL/SQL in UNIX environment.
• Responsible for scheduling jobs fromCRON using PERL and SHELL scripting
• Holds the distinction of helping the business user with business.
• Monitored the daily scheduled jobs on CRON
• Resolved the daily issues faced by business users.
• Oversaw the tuning of query & processes, index creation, analyze table for performance.
• .More than 1000 production tickets resolved as part of onsite support to the customer
• Hold the distinction of conceptualizing and implementing a customized user interface as a value add, to the client for vendor that help them to save a cost of approx. 50K$ annually.
• Responsible for providing on call support to the client on requirement basis.

Environment: Oracle10g (SQL/PL/SQL), Toad 10.5.1.3, SQL*Plus, SQL Developer 1.5.5, UNIX,Scripting (Shell and Perl),PERL, InformaticaPower center 9, Quality Center 10.0.

Confidential

PL/SQL Developer (Senior Software Engineer)

Responsibilities:

• Involved in process mapping document creation and GAP analysis.
• Responsible for offsite development and system testing.
• Responsible for implementation of new enhancements.
• Responsible for Monitored the daily job sheet.
• Production Support for All the clients mentioned above.
• Oversaw the tuning of query & processes, index creation, analyze Explain plan.

Environment: Forms and reports, Oracle9i, 10g (SQL/PL/SQL), SQL Loader, Solaris

Confidential

PL/SQL Developer (Senior Software Engineer)

Responsibilities:

• Responsible for making and finalizing UD between Confidential & Nucleus.
• Designed and tuned the INTERFACE between Nucleus Software’s Finnone and Infosys Finacle for Confidential Nigeria.
• Involved in the designing of the system and development of the code using PL/SQL & test cases.
• Responsible for the performance tuning of the system
• Hold the distinction of imparting FinnOne suit in India to business users of Confidential of Nigeria.

Environment: Oracle9i/10g (SQL, PL/SQL), SQL Loader, Scripting, Solaris, UNIX, Windows 2000/2003 Server

Confidential

PL/SQL Developer (Senior Software Engineer)

Responsibilities:

• Involved in gathering the requirements of the customer for the enhancements.
• Took care of the development of code using PL/SQL.
• Managed the test planning & scheduling.
• Provided functional/technical support to the clients.
• Oversaw the tuning of query & processes, index creation, analyze Explain plan.
• Wrote stored procedures & functions using PL/SQL.
• Designed the Entity-Relationship model and normalized database.
• Conducted re-sizing of data files, managed table spaces and data files.

Environment: Oracle 9i (SQL, PL/SQL), MS Windows 2000 Server

Confidential

PL/SQL Developer ( Software Engineer)

Responsibilities:

• Evaluated, developed & implemented theEOD modules.
• PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.
• Various features of PL/SQL such as Dynamic SQL and parameter passing of PL/SQL tables were evaluated
• Developed SQL Applications for extracting the data from the Oracle tables.
• Extensive testing was done on the programs for achieving accuracy, timely processing of data.
• Involved in the development of backend procedures by using PL/SQL for ledger posting and for reversing the journal ledgers.
• Used Oracle Forms 6i was used to design and develop the interface for the system.
• Oracle Reports 6i was used to create reports.
• Created Reports like Ledger, Profit and Loss statement, Balance Sheet and Trial Balance.
• Used Forms 6i to create Group, Ledgers, Vouchers and Bank Reconciliation statements
• Created front-end procedures and functions with Forms 6i to calculate reorder level and reorder quantity.

Environment: Oracle 9i (SQL/PLSQL), VS 6, MS Windows 2000 Server

Confidential

PL/SQL Developer ( Software Engineer)

Responsibilities:

• Acted as the Team Player for analysis, development & implementation.
• Developed code using PL/SQL.
• Design of system
• Wrote UNIX Shell scripts using Korn shell to performing routine activities such as Database Backup.
• Created Tables, Stored Procedures, Triggers, Packages, and Views
• Developed Forms and Reports using Forms 4.5 and Reports 2.5
• Testing and Debugging

Environment: PL/SQL Oracle 9i,NT, Forms 4.5, Reports 2.5, UNIX