SUMMARY

• Over 5+ years of Experience in the field of Software Design, Development and Implementation with Proficiency in Oracle, SQL, PL/SQL.
• Strong knowledge in creating Oracle Stored Packages, Procedures, and Functions.
• Writing code for enhancing existing programs or developing new programs
• Experience programming PL/SQL batch environment utilizing large tables and high transaction throughout requirements. and demonstrated experience in Oracle Database tuning.
• Proficient in debugging PL/SQL packages Emphasis to troubleshoot issues.
• Ability to design, develop, and conduct unit test plans to ensure application code is functioning correctly.
• Can Collaborate with the Product Management to understand and deliver the right solutions for business needs
• Providing innovative solutions to complex and critically sensitive issues affecting multiple work groups
• Good programming skills in SQL 2000, PL/SQL, SQL* Plus with stored procedures/triggers, Oracle Forms 9i and Reports, Developer 2000 (Forms 6i and Reports 6i), Toad, SQL Scripts, SQL* Loader.
• Experience in Back end Testing of the applications by executing complex SQL commands.
• Experienced in data retrieval from multiple tables using joins, writing stored procedures, cursors.
• Worked extensively on PARTITIONS to enhance performance and archiving of a DW.
• Very good experience with Oracle Hints. Experience with TKPROF and EXPLAIN PLAN.
• Experienced in working with many complex SQL queries with joins, date functions, inline functions, cursors, ref cursors, collections, partition tables, external tables, materialized views, sub - queries and analytical queries to generate reports.
• Expertise in all the phases of System development life Cycle (SDLC)
• Work Experience in UNIX environment.
• Comfortable in working with a fast-paced, professional development team environment.
• Excellent verbal and written communication skills and the ability to interact professionally with a diverse group, including executives, managers, and subject matter experts.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g, MS-SQL Server, MS Access, MySQL

Scripting: SQL, PL/SQL, UNIX DB2, T-SQL

Languages: C, C++, HTML, XML, PHP

Reporting Tool: Business Objects, Crystal Reports

ETL Tool: Informatica

Query Tools: TOAD, SQL Navigator, SQL* PLUS

Operating Systems: Windows 2000/XP, LINUX 9.2/9.3

GUI: Oracle Forms 9i and Reports 9iOther Tools: Toad 10.1/ 9.7, SQL * Plus 10.1, SQL-Navigator 6.2, SQL*Loader

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Oracle PL/SQL Developer

Responsibilities:

• Monitoring existing SQL code and performance tuning if necessary.
• Created indexes for retrieving data quickly.
• For better performance used EXPLAIN PLAN, HINTS to tune queries.
• Created Temporary Tables in procedure to achieve performance issues.
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• Involved in report generation using Crystal reports.
• Based on the requirement developed necessary forms and reports.
• Developed Unix Shell scripts.
• Worked with workflow team to support existing PL/SQL code and provided solutions to assigned tasks for various enhancements and defects.
• Wrote complex database modification scripts for hot fix solutions.
• Wrote packages for unit testing using PL/SQL and debugged using DBMS debug packages and other PL/SQL developer tools.
• Created views to apply security policies and also created materialized views to achieve performance gain.
• Worked with DBA for performance tuning and space management.
• Documented technical specifications and did knowledge transfer with other departments and team members.
• Developed numerous programs using PL/SQL and many packages to do the validations as per requirements.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries.
• Dealt with heavy weight tables which are appended with millions of records daily.
• Moved / manipulated data from one environment to another for development, testing and debugging of application.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Created and maintained all database objects such as Tables, views, indexes, sequences, constraints, procedures, functions.
• Used SQL*Loader to load data from flat files and Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.

Environment: Oracle 11g, PL/SQL Developer, SQL*Plus, SQL Loader, Toad, FTP Client.

Confidential, Knoxville, TN

Oracle PL/SQL Developer

Responsibilities:

• Extensively worked on Performance tuning by using Explain plans and various hints.
• Worked on table partitioning (Range and List) and deploying local indexing on partioned tables.
• Involved in Extraction, Transformation and Loading (ETL) of the data in the data warehouse for Oracle 10g database.
• Used stored procedures in Oracle for retrieving the data from the database for solving complex queries.
• Created Stored Procedures, functions and Packages in Oracle 10g using SQL and PL/SQL for the Audit Trail using Oracle 10g as backend.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Worked on Partitioning and indexing concepts (Local and Global) indexes on partition tables.
• Worked on Data warehouse design, created star schema, dimension and fact tables.
• Interacted with end users and functional architects for mapping the legacy data to the Oracle tables.
• Involved in testing all forms, PL/SQL code for logic correction.
• Studied the existing OLTP system(s) and interacted with Data Architect regarding facts, dimensions and star schema representation for the data mart.

Environment: Oracle 10g, Forms 10g & Reports10g, ASP, SQL PLUS, PL/ SQL, SQL*LoaderUnix Shell Scripts, Data Stage, Business Objects, SQL Navigator, TOAD.

Confidential, San Diego, CA

Oracle PL/SQL Developer

Responsibilities:

• Modifying and developing database triggers, cursors, procedures, functions and packages to meet business requirements.
• Writing (Back-end) PL/SQL code to implement business rules through triggers, cursors, procedures, functions, and packages using SQL*Plus Editor or TOAD.
• Created PL/SQL Packages for easier application design and improved Performance.
• Created PL/SQL Procedures using Native Dynamic SQL and Cursor Variables.
• Developed Unix Shell Script as required.
• Migrated data from Flat Files to Oracle database using SQL*Loader.
• Wrote Oracle PL/SQL programs for backend processing.
• Encapsulated PL/SQL procedures and functions in packages to organize application.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Performed complex data manipulation using foreign functions written in C and PL/SQL language.
• Created and managed primary data base objects such as Tables, Views, Indexes, Sequences, and Synonyms.
• Performed tuning by using the Dense/Sparse settings and developed the required alternate rollups for reports.
• Involved in trouble-shooting production database problems and report problems.
• Developed user documentation for all the application modules. Also responsible for writing test plan documents and unit testing for the application modules.

Environment: PL/SQL, C, Pro*C, SQL, SQL*Plus, SQL*Loader, Oracle 9i, UNIX, Windows.