SUMMARY

• Over Seven (7) years of IT experience asOracle Developer in all phases of SDLC involving Analysis, Design, Development, Migration, Implementation, Testing and Deployment of Business applications using Oracle RDBMS on various platforms
• Extensively Used Cursors, REF Cursors, Exceptions and Hints. Worked heavily with Table Partitioning
• Proficient in RDBMS concepts, with hands on exposure in the development of relational database environment using Oracle 11g/10g/9i/8i, SQL, PL/SQL, SQL*Loader, MS SQL Server, T - SQL, SQL*PLUS, TOAD and SQL Navigator in many development projects
• ExcellentSQL skills, experience writing complex queries and working with database objectslike Tables, Sequences, Synonyms and Views
• Technology used was Oracle 10g, Pro*C and shell scripts
• Proficient inOracle SQL, advanced PL/SQL,SQL*PLUS includes creating Packages, Functions, Procedures, and Triggers and materialized views with emphasis on maintaining standards and handling errors in a consistent and robust manner
• Worked extensively on Pro* C, forms and Reports
• Excellent experience with normalization and partitioning of data and indexing of partitioned tables
• Experience in Bulk Data Loading using Oracle utilities namely SQL*Loader and External Tables
• Expertise inQuery Performance TuningbyAnalyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk CollectFeature,Materialized Views, Dynamic SQL, Oracle Hintsand TroubleshootingOracle database issues for better performance
• Experienced in DB Design, Oracle Forms and Reports, PL/SQL Development
• Expertise with Data Migration, Data Mapping or Table Mapping, Data Loading and exporting by using SQL*Loader and UTL File Utilities
• Good knowledge of Data Modeling using Erwin tools, Data Warehouse concepts
• Proficient in developing front-end interface using OracleForms and Reports
• Extensive knowledge ofSQL*Loaderand Oracle supplied standard packages
• Experience in UNIX, loading data using SQL*Loader and input parameter validation
• Proven ability to plan, coordinate and implement Full Life Cycle software development and maintenance projects
• Excellent communication, teamwork and client interfacing skills
• Expert in understanding of business procedures and ability to work as an individual and as a part of a team.

TECHNICAL SKILLS

Programming Skills: Oracle PL/SQL, T-SQL, SQL, HTML, UNIX Shell (Korn), XML, C, TOAD

Tools: Oracle SQL Developer, Forms 6i,9i,10g,11g Reports 6i,9i,10g,11g, Toad, SQL Navigator, SQL*Loader, Data Modeling Erwin

Databases: Oracle 11g/10g/9i/ 8i/8/7.x, MYSQL, Access, MS-SQL Server

Operating Systems: Sun Solaris, Unix, Ubuntu, Windows 9x/2000/NT/XP, DOS

PROFESSIONAL EXPERIENCE

Confidential - Des Moines, Iowa

Oracle PL/SQL Developer

Responsibilities:

• Active team member in periodic providing analysis and development of the client Reporting requirements
• Involved in preparing the functional specification, technical documentation, schema documents, flow charts and user support documents
• Ensured the client SDLC processes using requirement traceability matrix
• Load the data into tables from flat file via temporary tables using SQL * Loader and PL/SQL
• Extensively used Oracle stored procedures, Complex SQL queries, Functions, Packages, PL/SQL objects and Oracle utilities for data retrieval from various database objects including tables and views
• Usage of PLSQL tables, records, cursors, materialized views and collections for implementing the processing logic for report generation
• Tuned and optimized Oracle Queries for better performance
• Development on a ORACLE 11g database using ORACLE FORMS, REPORT to create integration software.
• Designed and developed user interfaces using Oracle Reports and Forms
• Involved in Creation of New Logical /Physical Data Model using Erwin
• Modified various existing Pro*C reports and Pl/Sql code.
• Worked with Oracle packages like UTL FILE to open, read and write files to OS directories
• Developed database triggers to maintain audit tables
• Involved in database design, partitioning of tables and indexing tables
• Error handling using implicit and user defined exceptions
• Performance tuning of the queries using explain plan, hints and SQL trace
• Used DB LINKS for accessing data across different databases
• Maintained the data integrity and security using integrity constraints and database triggers
• Used UNIX Shell scripts for sequencing the flow and provoking all procedures for automated output
• I have developed forms and reports using embedded SQL procedures
• Developed flowchart of various client business processes and participated in various knowledge transfer sessions with team members
• Mentored junior programmers in Oracle database design and development

Environment: Oracle 11g, SQL Developer, PL/SQL, ERwin, HTML, Forms 10g, Reports 10g, UNIX and WIN XP OS

Confidential - San Diego, CA

Oracle Developer

Responsibilities:

• Written complex SQL queries using joins, sub queries and correlated sub queries
• Developed PL/SQL procedures, functions, packages and triggers
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases
• Handled errors using system defined exceptions and user defined exceptions
• Developed code in Pro*C on UNIX, to retrieve data from the stored procedures.
• Wrote custom support modules for upgrade implementation using Pl/Sql, Unix Shell Scripts and Pro*C.
• Loaded the data into database tables using SQL*loader from text and excel files
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database
• Worked on Oracle Hints. Partition tables in Oracle Database, Dynamic SQL
• Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views and functionsas per the business requirements
• Involved in data Migration of MYSQL and SQL Server databases to Oracle 10g databases
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plan and Trace sessions for Cost based optimization
• Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning
• Tuned SQL queries for new reports for faster response time
• Developed application using Oracle Forms & Reports
• Involved in Designed physical and logical data models using ERwin
• Involved in creating INDEXES to avoid the need for large-table, full-table scans and disk sorts, and for fast retrieval of data from database objects
• Tuned the SQL Queries and Stored procedures for better Performance
• Optimized the performance of queries by Data Manipulations which includes modifications in SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins and created clustered/non-clustered indexes wherever necessary
• Modified existing packages, procedures, functions, views and triggers to handle new database design
• Wrote Unix for clean-up, logging, file manipulation and transferring the files
• Collaborated with other project teams for performance tuning of queries.

Environment: Oracle 11g, PL/SQL, XML, Forms and Reports, UNIX, TOAD, Windows XP

Confidential, Owings Mills, MD

Oracle PL/SQL Developer

Responsibilities:

• Gathered the Requirement from the business use and prepared the program specification and design document for the development of the Timesheet Application
• Created the PL/SQL packages, procedures, functions applying the business logic to update the database with employees’ timesheet and to calculate payroll
• Created custom triggers to automatically populate different tables and also to restrict the data being inserted to the timesheet tables
• Developed various programs using Native Dynamic SQL and REF CURSORS
• Worked with Oracle packages like UTL FILE to open, read and write files to OS directories
• Trouble shooting performance issues using Explain Plan and TKPROF
• Optimized and tuned PL/SQL subprograms to reduce the loading process
• Writing database triggers & views in maintaining business rules of the firm
• Declaring, raising and handling user defined exceptions in handling unexpected situations during compilation and execution
• Wrote packages by grouping procedures and functions that are similar in functionality and thereby enhancing application performance by overloading procedures and functions
• Coordinated with the offshore support team in resolving critical issues. Maintained the data integrity and security using integrity constraints and database triggers
• Created triggers on tables and views and associating appropriate trigger timing and trigger events
• Customized forms and reports as per user requirements using Oracle Developer Forms & Reports.
• Made use of DB LINKS for accessing data across different databases
• Writing Requirement analysis and specifications during design phase of SDLC and interacting with the client
• Created the custom tables to import the employee data and insert into the timesheet database
• Developed the SQL*Loader scripts to load data into the staging tables from the flat files
• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries
• Created the Shell Scripts to automate the execution of the PL/SQL subprograms and to move the data to store in historical folders

Environment: Oracle 10g, Forms, Reports, PL/SQL, TOAD, Erwin, Putty, Windows

Confidential, Knoxville, TN

Oracle PL/SQL Developer

Responsibilities:

• Worked with business analysts to understand the business requirements and created technical requirements document
• Responsible for development activities at the back-end side as well as actively participated in analysis and designing part
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements
• Used PL/SQL features such as stored procedures, functions, packages and database triggers for maintaining complex integrity constraints and implementing the complex business rules
• Optimization of SQL queries, and performance tuning by using Explain plan and Analysis
• Fixing the problems in PL/SQL code and any problems with DDL scripts for tables and indexes and escalating the issues in severe cases to the development and other support teams about possible impact on the application functionality
• Designed reports using Reports as per user requirements. Created Reference and Master/Detail tables to store information. Tested forms and reports using test data
• Tuning Database and SQL for Optimal Performance, Redesign and build the Schemas to meet optimal Performance measures

Environment: Oracle 10g, PL/SQL, SQL*Plus, SQL*Loader, Erwin, Forms, Reports

Confidential - Atlanta, GA

Oracle Developer

Responsibilities:

• Involved into updating procedures, functions, triggers, and packages based on the change request
• Involved in moving the data from flat files to staging area tables using SQL * Loader
• Implemented Complex business Logic as per the client requirement
• Prepared daily reports from the invoice data received for different department like sales, marketing
• Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables
• Creation of database objects like tables, views, synonyms, materialized views, procedures, packages using oracle tools like SQL* plus
• Extensively used for all and bulk collect to fetch large volumes of data from table
• Developed Reports to extract the monthly sales information
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL
• Performed performance tuning using the DBMS PROFILER package, this checks the run time behavior
• Worked closely with Production Support team to Troubleshoot and fix any production issues
• Responsible for code migration of existing application from SQL Database to Oracle Database
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL) program asynchronously
• Wrote SQL Loader control file for flat file data load and scheduled them in UNIX to load every night in Production Environment
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE
• Developed Master Detail, Detail reports using tabular and Group above reports
• Wrote many simple and complex ad-hoc reports using SQL * Plus and TOAD for the business users Transformed complex business rules to Oracle PL/SQL

Environment: Oracle 9i, PL/SQL, SQL*Plus, SQL*Loader, Reports, TOAD

Confidential

PL/SQL Developer

Responsibilities:

• Performed review of the business process, involved in Requirements Analysis, System Design Documents, Flows, Test Plan preparations and Development of Business Process / Work Flow charts
• Developed PL/SQL procedures, customizing existing programs according to the needs of the client testing
• Wrote PL/SQL packages consisting of procedures and functions
• Created Materialized Views, Triggers, Sequences, collections
• Involved in development and testing of oracle back-end objects like database triggers, stored procedures, Sequences and Synonyms
• Worked with tuning the complex Stored Procedures for faster execution using bulk collections and Dbms Profiler
• Involved in design, development and Modification of PL/SQL stored procedures, Functions, packages and triggers to implement business rules into the application
• Extensively used cursors for fetching the rows
• Loading data through SQL Loader and UTL FILE
• Involved in tuning the SQL queries create database objects and optimally set storage parameters for tables and indexes
• Designed reports using Reports as per user requirements. Created Reference and Master/Detail tables to store information. Tested forms and reports using test data
• Developed complex triggers in reports before/after for validation of user input
• Designed and developed user interfaces using Oracle Forms
• Wrote Shell scripts to insert data to database tables. Wrote PL/SQL code to retrieve data for master and detail blocks
• Customized forms and reports as per user requirements using Oracle Developer Forms & Reports

Environment: Oracle 9i, PL/SQL, SQL*Plus, Forms, Reports, Windows