SUMMARY:

• Oracle PL/SQL Developer with almost 5 years of extensive experience in analysis, designing, developing, implementing and maintaining database applications and solutions, primarily using Oracle database technologies.
• Expert in writing efficient SQL and PL/SQL code (Stored Procedure, Functions, Triggers, Autonomous Transactions and Packages) on TOAD to analyze very large data sets.
• Expert data integration. Import export from raw data file to database and database to dat/txt/csv file.
• Hands - on experience using Oracle tools like SQL *PLUS, SQL Developer, PL/SQL Developer and TOAD in many development projects.
• Good knowledge on Pro*C coding.
• Complete understanding of Oracle architecture including SGA(Database Buffers, Redo Log Buffers, Shared Pool) Log writer, Achiever, PMON, SMON, PGA, Listener services, Data dictionary Views
• Expertise in system integrations and client interactions in preparing functional designs.
• Experience on Oracle Collections and Oracle Partitioning.
• Expertise with Oracle Analytic functions.
• Good knowledge on performance tuning activities.
• Expertise with concepts of referential integrity and constraints.
• Experience in working on Regular Expressions.
• Excellent Analytical skills to understand the business process and Functionality, Requirements and to translate them to system requirement specifications.
• Experience in working on SQL Loader.
• Extensive experience in Performance Tuning (both SQL Tuning and PL/SQL Tuning) using TKPROF, SQL TRACE, TIMED STATISTICS & Explain Plans, DBMS PROFILER.
• Good knowledge with Unix Shell Scripting.
• Good knowledge of Data Modeling and creation of Entity Relationships Diagrams.
• Knowledge of Data warehouse and ETL.
• Expertise in requirements gathering, software requirements specifications, systems development, testing (unit, performance), reporting, application maintenance, application / production support.
• Good domain knowledge of Banking, Retail and Financial institutions.
• Excellent documentation and presentation skills, great verbal and written communication skills
• Analytical thinker, quick learner and proficient problem-solver who envisions business and technical perspectives to develop workable solutions.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i

Languages: SQL, PL/SQL, HTML, PRO*C, UNIX Shell Scripts

Tools: SQL Loader, Import/Export, Oracle Developer Suite. SQL * Plus, Toad,WinSCP,Putty

Repositories: VSS,Clear case(Version Controlling tools)

Reporting Tools: Business Objects (Crystal Reports)

Operating Systems: UNIX, Linux, Windows 2000/XP/NT

Productivity Applications: MS Office, Edit plus, Visio, Visual Studio, .NET

PROFESSIONAL EXPERIENCE:

Confidential

Oracle PL/SQL Application Developer

Responsibilities:

• Creating complete end-to-end software solutions by developing, testing, rolling out and supporting systems, reports and services
• Worked on design/ development of Customer Integration system.
• Developing program specs based on Functional specifications.
• Wrote procedures to import raw data into oracle database instead of using SQL*Loader.
• Wrote procedures to extract data into excel/csv/dat/txt format for interfacing.
• Wrote procedures to identify possible duplicate to staging table.
• Wrote procedures to load data from different tables for mapping table.
• Created the role level security for database and tables.
• Modified existing forms and reports, designed new forms and reports as per business requirement.
• Extensively used of PL/SQL Stored Procedures, Functions, Triggers, Cursors and Packages
• Creating SQL, PL/SQL database objects.
• Wrote Views, PL/SQL packages, procedures and function for processing business logic in the database.
• Developed and modified a number of SQL, PL/SQL, stored procedures, functions, packages and reports.
• Responsible for following up bugs reported by various users and suggesting possible patches to be applied.
• Enhanced the performance of legacy PL/SQL packages by using Oracle 10g new features like FORALL and BULK COLLECT.
• Written the Interface Stored Procedures for Data Transformation
• Used PL/SQL developer tools for faster application design and developments
• Developed procedures using Dynamic SQL, UTL FILE.
• Involved in Testing (Both Unit and Integration Level) and Implementation.
• Tested the entire application in testing environment and exported to Production.
• Wrote PL/SQL packages, procedures, triggers and function for processing business logic in the database.
• Developed and modified a number of SQL, PL/SQL, stored procedures, functions, packages and reports.
• Involved in Designing of Data Modeling the, Design Specifications and to analyze Dependencies.
• Responsible for creating and maintaining the packages, stored procedures, triggers functions and cursors.
• Involved in Unit level testing, Module level testing and System testing.
• Involved in preparing functional specifications, release notes, & documentation using MS-Office.

Technologies: Oracle10g/11g(SQL*PLUS,PL/SQL),MS-Office,SQL*Loader,TOAD,Windows,ClearCase, WinSCP,Putty, Development, Testing and Production environment, Windows, UNIX, Visio

Confidential

Oracle PL/SQL Application Developer

Responsibilities:

• Creating SQL, PL/SQL database objects.
• Involved in data maintenance for static tables.
• Involved in preparing test datas for testing.
• Worked on checking log files on UNIX while working on support for production environment.
• Worked in SQL Loader for loading data from various sources like flat file, excel etc. into tables.
• Involved in developing PRO*C batch programs.
• Attending client meeting to discuss functional design for conversion programs.
• Worked Extensively on Oracle Analytical functions like partition over by, rank, dense rank, lead, lag.
• Created database tables, indexes and partitioned existing tables.
• Worked on Bulk loader utilities like Sql loader for moving data from external files into the Oracle database.
• Extensively used of PL/SQL Stored Procedures, Functions, Triggers, Cursors and Packages
• Worked Extensively on Collections (Varrays, Associative arrays and Nested tables).
• Created database tables, indexes and partitioned existing tables.
• Performed unit, system and Integration testing.
• Developed FTP process to extract data from Flat files received from various systems.
• Used PL/SQL developer tools for faster application design and developments
• Developed procedures using Dynamic SQL, UTL FILE.
• Involved in Testing (Both Unit and Integration Level) and Implementation.
• Tested the entire application in testing environment and exported to Production.
• Done the documentation and provided on-site production support.

Technologies: Oracle 9i, PL/SQL, Pro *C, SQL Plus,Visual Source Safe,Pl/Sql developer,Toad,Putty, Windows 2000 and UNIX