SUMMARY

• Software Engineer with 7years of total IT experience in the areas of analysis, design, development, implementation and management of full life cycle commercial applications.
• Proven technical skills with 5 years of experience in Oracle SQL, PL/SQL and oracle 9i/10g/11g.
• Experienced in developing Stored Procedures, Functions and Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Synonyms, Database Links, User Defined Data Types, Nested Tables and Collections.
• Extensive experience in developing UNIX Shell scripts, SQL and PL/SQL (Coding Procedures, Functions, Database Packages and Triggers).
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans and Table partitioning.
• Writing scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.
• Experience in advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML operations for better performance.
• Experience in Dynamic SQL, Records, Arrays and Exception Handling
• Experience in Understanding complex performance issues and worked with DBA’s to suggest valuable ways to fix the problem.
• Have extensive experience in developing, implementing and maintaining application systems under Windows/Unix operating systems using SQL, PL/SQL, Oracle Database and many other facilities, such as Import/Export, SQL*Loader and SQL*Plus.
• Hands on experience in lowering the query by more than 200% using hints like PARALLEL, PARALLEL INDEX,APPEND
• OLTP environment experience.
• Experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications.
• Significant experience working with clients, technical teams for executing concurrent multi-technology projects.
• Extensive ability to back trace the bottle necks of a query using LONGOPS.
• Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operational costs.
• Highly motivated & conceptually strong individual with outstanding oral and excellent communication, analytical and interpersonal skills.

TECHNICAL SKILLS

Languages and Technologies: PL SQL, C, C++, SQL plus

Operating System: MS Windows 2000/NT/XP/NT & VISTA, MS DOS and UNIX.

Databases: Oracle 8i, 9i, 10g, Access, MS SQL Server

GUI(S): Visual basic 6.0, ASP, HTML, Cold Fusion

CASE TOOLS: VANTIVE, TOAD 8.5

Reports: Crystal Reports 7 / 8, Oracle Report Builder, MS visual studio 2005

Version Control: Visual SourceSafe, CVS

PROFESSIONAL EXPERIENCE

PL/SQL Developer

Confidential, Dunnhumby, OH

Responsibilities:

• Involved in interacting with the end-user (client) to gather business requirements.
• Participated in analyzing and modeling the requirements for the logical and physical design of the database using star schema and normalization techniques.
• Population of the data warehouse tables using SQL*Loader.
• Analyzing and writing Oracle PL/SQL code.
• Developed procedures to run the SQL * Loader to load data from flat files into the target database tables.
• Developed complex mappings to load data from Source System (Oracle) and flat files
• Define and represent Entities, Attributes and Joins between the entities.
• Written UNIX shell scripts to automate loading files into database using crontab.
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.
• Extensively developed PL/SQL Procedures, Functions, Triggers and Packages.
• Identified SQL and PL/SQL bottlenecks using PL/SQL Profiler (package DBMS PROFILER), Explain plan, Auto trace, TKPROF and tuned them for better performance.
• Increased performance by creating Indexes and Hints.
• Responsible for troubleshooting various aspects of the client/server architecture in both UNIX and Oracle setting.
• Analyzing and upgrading Oracle Forms 11g.
• Aided developers in writing efficient code and making efficient use of the resources leading to better performance and optimization.
• Developed Front end Designs using .Net Framework using WinForms, WebForms, HTML/DHTML, JavaScript, Crystal Reports 9.0, used Control Objects, Package and Deployment.
• Developed interface program in VB.Net and used ADO.Net Oracle Database as Data Access Layer.
• Coordinated the deployment of applications on a CITRIX server/NetScaler.
• Support for the development, pre-production and the production databases.

Environment: Oracle 10g (SQL, PL/SQL), SQL*Loader, Forms 6i, TOAD 7.4, HTML/DHTML, PRO*C, JavaScript, Windows NT/2000, Crystal Report 8.0/9.0, Erwin 4.0, UNIX, CITRIX.

Confidential, Louisville KY

PL/SQL Developer

Responsibilities:

• Coordinate with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
• Created and used Table Partitions to further improve the performance while using tables containing large number of columns and rows.
• Designed reports that had complex SQL, PL/SQL code and stored the procedures. The filter conditions for the Queries were dynamic in nature and included lexical parameters.
• Responsible for coding and modifications to enforce business rules and to improve performance of the system.
• Fined tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans.

Environment: Oracle 10g/9i, PL/SQL, SQL PLUS, TOAD, Windows XP Professional.

Confidential, NJ

Oracle PL/SQL Developer

Responsibilities:

• Involved in SDLC gathering requirements from end users.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Involved in GUI designing using Oracle Developer 10g (Forms 10g and Report 10g).
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Developed Database Triggers for audit and validation purpose.
• Used pipelined functions for faster data accessibility.
• Writing validation packages using PL/SQL package.
• Used PL/SQL to validate data and to populate billing tables.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Developed Installation scripts for all the deliverables.
• Performed functionaltesting for different Oracle Forms application functionalities.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Involved in migrating database from oracle 9i to 10g database.
• Involved in developing screens and generating reports.
• Developed Style Sheets using XSL and the data in XML format to present the Standard Reports to the Client.
• Developed Forms and Reports.

Environment: Oracle 9i, 10g SQL, PL/SQL, XML, Forms 9i, Reports 9i, SQL*Loader, SQL Navigator, Crystal Reports, Toad

Confidential, Atlanta GA

PL/SQL Developer

Responsibilities:

• As a programmer I was involved in the data transfer creating tables from various tables, coding using PL/SQL, stored procedures and triggers.
• Worked with DBA in making enhancements to physical DB schema. Also coordinated with DBA in creating and managing table, indexes, table spaces, db links and privileges.
• Developed back end interfaces using PL/SQL stored packages, procedures, functions, Collections, Object types, Triggers.
• Developed screens and reports using Oracle Forms/Reports 6i. Also developed reports using PL/SQL.
• Utilized SQL*Loader to load flat files database tables.
• Utilized PL/SQL developer tool in developing all back end database interfaces.
• Responsible for performing code reviews.
• Developed user documentation for all the application modules.
• Responsible for writing test plan documents and unit testing for the application modules.

Environment: Oracle 9i/10g, PL/SQL, SQL*Loader, TOAD, Java, HTML, MS Office, HP-UX 11i

Confidential, OH

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading static data into database tables.
• Batch processing was done to load huge amounts of data effectively.
• Developed Interfaces in ODI to load data from one table to other.
• Developed packages and Scenarios in ODI to automate the data load.
• Developed Unit test harness to test the loaded data.
• Generated the XML documents from the database and stored the external XML files from the DME server in the database.
• Worked on fixing knowledge modules.
• Working knowledge on LKM,IKM,CKM.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Preparation of the Test Cases and involvement in Unit Testing and Integration Testing.
• Wrote SQL*Loader scripts to load data into temporary staging tables.
• Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.
• Involved in tuning of SQL queries manually by Explain plan.
• Partitioned tables and indexes for better performance of application.
• Involved in handling the changes in compiling scripts according to the database changes.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Provided the creation of Tables using storage parameters and clusters.
• Coded many generic routines (as functions), which could be called from other procedures.
• Developed user interface screens, Master detail relations and Report screens.
• Developed various Reports for the end users as per their requirements and created many reports to suit preprinted format of the company.
• Created user defined Exceptions while handling exceptions.
• Wrote stored procedures, Functions and Database triggers using PL/SQL.
• Conducted training sessions for the end-users.

Environment: Oracle 8i, SQL*Plus, Windows 2000.