EXPERIENCE SUMMARY:.

• 7 years of experience in Software design, development and implementation of Oracle, SQL, PL/SQL applications.
• Excellent knowledge in Oracle 8i/9i/10g/11g SQL and PL/SQL.
• Experience in Relational Data Base Management Systems RDBMS .
• Extensively worked in Client-Server application development using Oracle 11g/10g/9i/8i Forms 9i/6i, Reports 10g/6i/6.0, SQL, PL/SQL.
• Proficient in designing, modeling, creating and maintaining oracle database.
• Experience in writing SQL queries, functions, packages, cursors and stored procedures, database triggers using PL/SQL in Oracle.
• Experience in application development using various advanced features of Oracle like Collections, Table Functions, Dynamic SQL, Object types and Records.
• Involved in query performance of slow SQL statements by implementing Index, using FORALL and BULK COLLECT.
• Expertise in distributed query performance tuning by using EXPLAIN PLAN, SQL Trace and TKPROF Utilities provided by oracle.
• Experienced in working with utilities like SQL loader, External tables, import, export to extract large volume of data.
• Expert in Oracle database and GUI design and development of high performance technical solutions to meet the challenging business demands to the clients.
• Expert in Creating PL/SQL procedures, packages, functions, database triggers and other database objects like to generate back-end and front-end reports.
• Experience in Application Development using Forms, Reports and Discoverer.
• Strong experience in Oracle Workflows.
• Extensive experience in data migration techniques using Oracle External Tables, SQL Loader, Import/Export, bulk and batch processing.
• Experienced in data analysis, data modeling, development, testing and documentation of projects.
• Had good experience with Object-Oriented Design, application design and development using SQL SQL Reports, complex queries, views, group queries, tree queries, nested query, sub queries , PL/SQL Functions, Procedures, Triggers, Packages and Oracle inbuilt packages .
• Experience with DBA activities like creating users, granting and revoking privileges on database objects and taking backups.
• Excellent working and conceptual knowledge of PL/SQL, HTML and XML Technologies.
• Knowledge of Database design, E-R diagrams.
• Experience in Software Development Life Cycle SDLC including analysis, logical design, Resource Planning, code development, testing, implanting and maintenance
• Worked on ETL- extraction, transformation and load.
• Possess good communication skills.

TECHNICAL SKILLS:

Databases : Oracle 11g/10g/9i, SQL server 2000/2005, MS Access 2000, XP

Languages : SQL, PL/SQL DB Utilities : Oracle APEX 4.2, Toad, PL/SQL Developer, SQL Developer,

SQL Loader, SQL Navigator.

GUI Tools : Developer 2000 Forms 6i/9i/10g, Reports 6i/9i/10g, Graphics , BI

Publisher, XML, MS Excel, Visual studio.

Operating Systems : Windows, UNIX, and Mac.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. PL/SQL Developer

Responsibilities:

• Involved in the business requirements gathering and analysis, understanding client's Data Warehousing requirements and system analysis.
• Creation of database objects like Tables, Indexes, Views, Materialized Views, Packages, Triggers, Sequences and Synonyms.
• Written Procedures and Functions using Dynamic SQL and written complex SQL queries using joins, sub queries and correlated sub queries.
• Used Oracle SQL Developer for creating PL/SQL trigger, sequence, stored procedure .
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Used Explain plan and Tkprof to tune the long running and queries and modified scripts.
• Written procedures for jobs that runs daily.
• Jobs include inserting new records into the existing table if not present or update the values in table for the records that are already present.
• Developed procedures for tree views.
• Tree views contains the hierarchical view of information which can be expanded to reveal the sub-items if exists and collapsed to hide sub-items.
• Used cast, regular expression regex functions frequently.
• Created transaction tables from the existing tables by writing procedures.
• Transaction tables are derived from the original tables in which different rows of transaction table are populated from a single row of the original table.
• Worked with ArcGIS developers and have a very good understanding of Geographic Information Systems GIS concepts.
• GIS lets us visualize, question, analyze, and interpret data to understand relationships, patterns, trends and it can relate unrelated information by using location as the key index variable.
• Developed Stored Procedures in PL/SQL for cleaning up data and providing underlying structure for reporting using SQL.
• Involved in review, testing and logging defects of the code designed.

Environment: Oracle 11g, PL/SQL, TOAD, SQL Developer, UNIX and Windows.

Confidential

Sr. PL/SQL Developer

Responsibilities:

• Involved in complete SDLC system development life cycle including system analysis, high level design, detailed design, coding and testing.
• Ensure conformance to code standards and documentation requirements.
• Creation of database objects like Tables, Indexes, Views, Stored Procedures, Functions, Packages, Triggers, and Synonyms.
• Used advanced Bulk techniques FOR ALL, BULK COLLECT to improve performance.
• Developed Installation scripts for all the deliverables.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Used Dynamic SQL programming technique to build and process SQL statements.
• Used TOAD, PL/SQL developer tools for faster application development.
• Performed exception handling.
• Writing validation packages using PL/SQL package using Data Structures.
• Developed various complex stored procedures, packages, interfaces and triggers in PL/SQL.
• Apart from developing, other day-to-day responsibilities involved supporting production with issues related to day-to-day data fixes and debugging aborted processes.
• Documenting procedures and scripting, and eventually be drafting up them into Unit test plans.
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Performed functional testing for the procedures and packages.

Environment: Oracle 11g, PL/SQL, TOAD, SQL Loader, UNIX and Windows.

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in designing ER diagram using Oracle designer, to set the logical and physical relationships of database.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing and project coordination.
• Making changes to the existing apex applications in the production.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Loaded the data into database tables using SQL loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Created SQL plus reports as per client's various needs, and developed business objects.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in PL/SQL blocks and even have experience with exception handling.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Data loaded from legacy systems ETL Operations using PL/SQL and SQL Loader.
• Archived many applications in the existing system and retrieval of necessary data from them.
• Used Oracle SQL Developer for creating PL/SQL trigger, sequence, stored procedure .
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE.
• Developed UNIX Shell scripts to automate table creation, execute procedures.

Environment: Oracle 11g, PL/SQL, TOAD, SQL Developer, SQL Loader, SQL Plus, UNIX and Windows.

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in Requirement Analysis, System Design, Preparing Functional Specifications, and Preparing Design.
• Developed database objects including Tables, Clusters, Indexes, Views, Sequences, Packages, Triggers and Procedures to troubleshoot any database problems.
• Created SQL Loader scripts to load data into the temporary staging tables.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Used Oracle forms builder 6i for developing oracle forms.
• Involved in uploading of the data from flat files into Databases and Validated the Data with PL/SQL procedures.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements.
• Experience working with implicit, explicit, reference cursors, triggers, collections, exceptions, etc.
• Developed various complex stored procedures, packages, interfaces and triggers in PL/SQL.
• Usage of XML db for applications with data processing.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Responsible for the system user interface creation.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Worked on various Back End Procedures and Functions using PL/SQL.
• Involved in Requirement gathering and creating Dataflow Diagrams, ER diagrams and database diagrams using Oracle Designer.
• Wrote shell scripts for calling functions to automate the loading and extraction process from legacy system.
• Performances tuning using Explain Plan and TKPROF.
• Based on usage or retention requirements migrated the legacy data to other databases or storing data in proprietary files.
• Check the functionality of data in the front-end whether it is displaying properly or not.

Environment: Oracle 11g,SQL, PL/SQL Developer, Unix, SQL Loader, SQL Plus, Oracle Reports 11g, 10g , TOAD.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Gathered the requirements and documented high-level documentation for the project.
• Involved in the business requirements gathering and analysis, understanding client's Data Warehousing requirements and system analysis.
• Designed Logical data model and Physical conceptual data model using Erwin.
• Developed user entry screens and master-detail forms using Oracle Forms.
• Created and designed reports based on complex queries using Oracle Reports according to the requirements.
• Responsible for overseeing all aspects of the databases. This includes installation, management, performance tuning, backup/restore, stored procedures.
• Performed database design, tuning using Oracle Job Scheduler, Oracle Advanced Queuing.
• Applying constraints and writing triggers to apply the business rules.
• Involved in handling Errors and Transaction Processing in the Procedures.
• Created Records, Tables, Objects, Collections Nested Tables and Arrays , and Error Handling.
• Performed Data Migration using SQL Loader from flat files in to data base tables.
• Extensively involved in Writing PL/SQL Stored Procedures, Triggers, Functions, and Packages to meet the business requirements.
• Created custom partition tables for reporting.
• Responsible for SQL tuning using explain plan and optimizer hints.
• Used Ref-cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Moved data from the old tables into the new tables using SQL Loader.
• Handled exceptions for the ease of debugging and displaying the error messages in the application.
• Performed code reviews and acceptance testing of the application.

Environment: Oracle 10g/11g, Oracle Forms 10g, Oracle Reports 10g, PL/SQL, UNIX, SQL Loader, Oracle SQL Navigator, TOAD.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in development of process using SQL LOADER, PL/SQL Package, TOAD
• Involved in Oracle development Data Base by creating Oracle PL/SQL Functions, Store Procedures, Triggers, Packages, Records and Collections.
• Involved in Oracle SQL, PL/SQL, SQL Plus, SQL Loader, Query performance tuning.
• Extensively used Cursors, Ref Cursors, Dynamic SQL and Functions.
• Created Records, Tables, Objects, Collections, Views, Materialized views and Global temporary tables Nested Tables and V arrays , and performed Error Handling.
• Designed CUSTOM forms and reports in order to meet the Business requirements.
• Run batch jobs for loading database tables from Flat Files using SQL Loader.
• Fixed Bugs during development/testing and Production phases.
• Performed SQL performance tuning.
• Created business area, new custom folders, complex folders, summary folder, hierarchies, and item classes and list of values using Discoverer 10g.
• Involved in Technical Documentation, Unit test, Integration Test and writing the Test plan.
• Used Forms Compare tool to compare the difference between forms.

Environment: SQL Plus, PL/SQL, TOAD, SQL LOADER, SQL Discoverer, Oracle 9i, Oracle Forms/Reports 6i,Windows, UNIX.