SUMMARY

• Around 6 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, and Implementation of Business Applications, using the Oracle Relational Database Management System (RDBMS).
• Experience in all phases of the SDLC (Software Development Life Cycle) - analysis, design, development, testing, implementation and maintenance; wif CMMI level procedures and processes.
• Experience wif Data flow diagrams, Data dictionary and Database normalization theory techniques, ER modeling and design techniques.
• Experience in Client-Server application development using Oracle 11g/10g/9i, PL/SQL, SQL*PLUS, TOAD and SQL*LOADER.
• Experience in creating PL/SQL Functions, Procedures, Packages, Triggers and Materialized Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Experience using Table Functions, Table Partitioning, Collections and Analytical functions.
• Experience in creating Tables, Views, Sequences, Constraints and Indexes (B Tree, Bitmap and Function Based).
• Excellent technical and analytical skills wif ER modeling for OLTP and dimension modeling for OLAP.
• Experience wif Dynamic SQL, Records, PL/SQL Tables and Exception Handling.
• Experience wif Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Worked extensively on Ref Cursor, External Tables, Collections and Bulk Collections.
• Experience in Performance tuning and Query Optimization using Explain Plan, TKPROF, HINTS and SQL Trace utilities.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features, such as Query Optimizer, Execution Plans and Indexes for faster execution.
• Good knowledge of Data Modeling using ETL tools, OLAP tools, Star and Snowflake Schemas, and Entity-Relationship diagrams.
• Knowledge in UNIX shell scripting.
• Experience in writing Technical design documents and developing unit test documents.
• Supported integration and end user testing wif efficient defect management process.
• Good Communication and Interpersonal Skills; halp me bridge the gap between technical and end user objectives.
• Excellent Time Management skills; halp deliver solutions wifin a deadline.
• Strong interpersonal and leadership abilities; opens unlimited avenues for growth.
• Strong creative, analytical and problem solving skills.
• Hard working, aggressive in acquiring new skills, innovative and self-motivated.
• Ability to excel under pressure.
• Capable of maintaining excellent rapport wif employees and executive management.

TECHNICAL SKILLS

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

Programming Languages: C, C++, HTML, SQL, PL/SQL

Tools: and Utilities: SQL*PLUS, SQL*LOADER, PL/SQL Developer, ToadErwin Data Modeler

Operating Systems: UNIX, LINUX, Windows (98/2000/XP/VISTA), DOS

PROFESSIONAL EXPERIENCE

Confidential, Eau Claire, WI

Oracle Developer

Responsibilities:

• Analyzed and overviewed the database design for better understanding the relations, associations and dependencies wifin the database.
• Discussed and analyzed business functionality wif the client and the developers.
• Generated SQL and PL/SQL scripts to install create and drop database objects including Tables, Views, Primary Keys, Indexes, Constraints, Sequences and Synonyms.
• Developed and modified PL/SQL packages, procedures and functions as per customer requirement to make new enhancements or resolve problems.
• Wrote complex SQL queries to retrieve information from the databases depending on user requirement.
• Created PL/SQL program units to implement DML and DDL statements using Dynamic SQL.
• Used Mergestatements to select rows from one or more sources for updating and inserting into one or more tables.
• Extensively used for all and bulk collect to fetch large volumes of data from tables.
• Created triggers to automatically populate different tables and also to restrict the data being inserted to the tables.
• Created Bitmap Indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
• Wrote control files and loaded data into the Oracle database wif SQL*Loader.
• Wrote complex Oracle SQL queries using joins, sub queries and correlated sub queries.
• Implemented Materialized Views for extracting data from remote databases.
• Handled various Exceptions to troubleshoot PL/SQL code.
• Used PL/SQL Collections (Nested Tables and Varrys) in complex backend packages.
• Coded Unix Shell Scripts to call SQL scripts and to manipulate the returned data.
• Developed Test Plan documents for all back end database modules.
• Extensively worked on Explain Plans and various hints for Performance tuning.
• Developed Data Model, SQL Query tuning processes and Schemas.

Environment: Oracle 11g, Windows XP, SQL, PL/SQL, SQL*Loader, PL/SQL Developer, UNIX, TOAD

Confidential, Atlanta, GA

Oracle Consultant

Responsibilities:

• Gatheird Business Requirements from the client and translated the business detail into technical design and specification.
• Coordinated wif the front end design team to provide them wif the necessary stored procedures and packages and the necessary insight into the data.
• Involved in logical and physical modeling of application.
• Wrote packages, triggers, stored procedures and functions for the following modules - products, catalogue, billing, shipping, rejected material, purchase orders and material receipts.
• Worked on Performance tuning, Optimization of queries and standardization of the code.
• Used Database triggers for making history of insertion, updating, deletion and all kind of audit routines.
• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Developed data model, SQL Queries, SQL Query tuning processes and Schemas.
• Used PL/SQL tables, pragma autonomous transaction to avoid mutating problems in database triggers.
• Suggested and Implemented indexes for faster retrieval of data in Weekly and Monthly Metrics reports.
• Created records, tables, collections (nested tables and Varrays) for improving performance by reducing context switching.
• Worked on data conversion, loaded data from different Sources into the Temp data backup environment using SQL*Loader and validated the data before loading it into oracle tables.
• Optimized PL/SQL code and SQL queries using Explain Plan, Indexes and Hints.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data wif master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Provided database support to testing team in writing complex SQL queries.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used UTL FILE PACKAGES for writing output messages to file.
• Extensively used for all and bulk collect to fetch large volumes of data from tables.
• Designed required end user forms and reports using Oracle Forms 10g and Reports 10g.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Customized existing forms and developed new forms using different form built - ins, created LOVs and record groups.
• Worked wif different triggers in forms like Block processing triggers, Interface event triggers, navigation triggers, validation triggers etc.

Environment: Oracle 10g, UNIX, SQL, PL/SQL, SQL Loader, UNIX shell script, Erwin, XML, Forms & Reports 10g, and Toad.

Confidential, Minneapolis, MN

Oracle PL/SQL Developer

Responsibilities:

• Created the Object Relational Database Tables wif all the necessary Constraints.
• Developed back end interfaces using PL/SQL Packages, Stored Procedures, Collections and Triggers.
• Used Control Structures like IF, CASE, FOR, and WHILE Loops for standard PL/SQL programming.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Created and managed primary data base objects such as Tables, Views, Sequences, and Synonyms.
• Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc.
• Implemented multiple-table links requiring Complex Join statements, including outer-joins and self-joins.
• Used advanced Explicit Cursor concepts like FOR UPDATE, WHERE CURRENT OF Clauses.
• Loaded data from flat files to temporary tables in Oracle database using SQL*Loader, Collections for better performance.
• Worked in Maintenance of the system and debugging of the code whenever necessary.
• Used Exception Handling for validation of input and displaying the error messages in the application.
• Used Explain Plan, TKPROF to gather the statistics along wif analyze command for performance tuning.
• Tested, installed, documented and provided On Call Support for the Applications.

Environment: PL/SQL, SQL, SQL*Plus, SQL DEVELOPER, SQL*Loader, Oracle 9i/10g, Windows XP/2000.

Confidential, East Hanover, NJ

Oracle Developer and Analyst

Responsibilities:

• Interacted wif the end users for gathering and analyzing the requirements
• Worked wif the development team to design, develop, test and implement the system.
• Developed ER Diagrams, Data flow diagrams based on the requirement
• Created prototype reporting models, specifications, diagrams and charts to provide direction to system programmers.
• Developed Model Diagrams and Input/Output structures for the data entry screens.
• Used efficient Joins, Indexes and Correlated queries for Query optimization.
• Developed Control files, SQL*Loader scripts, Oracle import and export scripts for data loading, migration and backup of Oracle data.
• Extensively used PL/SQL to implement cursors, triggers and packages and to develop stored procedures, functions.
• Implemented Record Insert, Record update and also used Insert All to load the data into multiple tables.
• Created Shell scripts to automate the execution of the PL/SQL subprograms and to move the data to store in historical folders.
• Extensively used Collections like Varrays and nested tables.
• Involved in programming, debugging, and unit and system integration testing of modules.
• Used SQL trace facility and TKPROF along wif Explain Plan to accurately assess the efficiency of the SQL statements when the application runs.

Environment: Oracle9i/10g, Windows XP/2000, PL/SQL, SQL*PLUS, UNIX, SQL*Loader, UML.

Confidential, Louisville, KY

Oracle Developer

Responsibilities:

• Gatheird requirements from the business users, prepared functional specification and design documents.
• Prepared program specification and development of PL/SQL packages, procedures and functions as required by the business users.
• Developed server side PL/SQL scripts for data manipulation and validation.
• Analyzed the existing method for data repository refresh and tan developed a new package wif tuned queries to improve the performance and reduce the time taken for the refresh.
• Loaded data into oracle database from flat files using SQL*Loader.
• Created Materialized View for extracting the data from the remote databases.
• Wrote PL/SQL procedures to generate DDL scripts that created database objects dynamically based on user inputs.
• Developed and maintained Keys, Constraints and Relationships between tables for OLTP database.
• Maintained a series of UNIX shell scripts to manage batch order processing.
• Optimized critical queries to eliminate Full Table Scans, reduce Disk I/O and Sorts.
• Fine Tuned SQL statements for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and Trace sessions for Cost based and Rule based Optimizations.

Environment: Oracle 8i/ 9i, Windows NT/2000/XP, UNIX, HTML, SQL*Plus, PL/SQL, SQL*Loader, Toad.

Confidential

Oracle Developer

Responsibilities:

• Developed database objects like Tables, Views, Indexes, Synonyms and Sequences.
• Wrote stored procedures, functions, packages and triggers for modules like -products, catalogue, billing, shipping, rejected material, purchase orders and material receipts.
• Loaded traffic data logs into staging tables using SQL*Loader and shell scripts.
• Developed PL/SQL codes for Exception Handling and duplicate data maintenance.
• Used Triggers in Customizing Error conditions.
• Developed/modified PL/SQL code like stored procedures, packages, collections, bulk collections, etc for interfaces.
• Developed UNIX Shell Scripts and PL/SQL procedures to extract and load data for month-end batch processing.
• Developed PL/SQL code for updating payment terms.
• Created Forms, Pop-up Menus and maintained Master Detail relationship.
• Used various LOVs (List of Values) and record groups at various points in runtime.
• Designed and developed User Interfaces using Forms 6i, Reports 6i and coding modules in PL/SQL.
• Developed client side program units and shared them among multiple applications for processing business logic in the database.
• Tested all forms and PL/SQL code for logic correction.
• Performed code reviews.

Environment: Oracle 9i (SQL, PL/SQL), SQL *loader, Toad 9.0.1, Forms/Reports 6i, UNIX