SUMMARY

• 8 years of programming experience as an Oracle Developer(SQL,PL/SQL, Forms and Reports) in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System(RDBMS)
• Expert in Client - Server application development using Oracle 10g/9i/8i/8.x/7.x, PL/SQL, SQL *PLUS, Designer 2000, Developer 2000
• Extensive experience in Oracle RDBMS design and developing Stored Procedures, Packages, Triggers, Cursors using SQL and PL/SQL
• Proficient in Oracle Tools and Utilities such as SQL*Loader, Import/Export, TKPROF and SQL*Navigator v.4.5
• Proficient in utilizing weak and strong cursor variables for dynamic SQL
• Expertise in data modeling, Normalization, database design, data loading, data retrieval, modification, and archival techniques
• Extensively worked in developing Oracle Forms 6i, Menus, Oracle Reports 6i,9i
• Experience in Oracle reports 6i developer (Oracle developer suite 10g)
• Experienced in creating Tables, Views, Indexes and other SQL joins and query writing
• Proficient in Oracle database creation, table space management, creating database links, schemas, profiles and roles, managing control, redo log and data files
• Design modular applications using packages
• Manage data retrieval for front-end applications
• Invoke native dynamic SQL to develop high-level abstract code
• Hands-On experience in encapsulating data manipulation statements in stored procedures
• Performed complex data manipulation with cursors
• 24/7 Production Database Support & Maintenance
• Expertise in leveraging EXCEPTIONs to handle runtime errors
• Experience in creating triggers to handle data integrity and derivation
• Expertise in planning and implementing Application Server Security and database permissions, creating roles and managing user permissions
• Ability to work autonomously and also as part of a team under tight deadlines so as to meet any project expectations.
• Excellent analytical and problem solving skills and can work independently.

TECHNICAL SKILLS

Operating Systems: Windows XP/NT/2000,98/95, DOS, Solaris 10, AIX, Unix, Linux

Programming languages: ANSI C, C++, VC++, JavaScript, C#, VB, Java, PL/SQL programming, Pro*C, Unix scripting

Web Technologies: HTML, DHTML, Cold Fusion, AJAX, XML, JSP

Script Languages: JavaScript, Shell, Perl scripting

Database: PostgreSQL, Oracle 11g/10g/9i/8i, MySQL, MS SQL Server, MS Access 2000, Oracle Application Server 9i/10g

Tools: Toad, PLSQL Developer, SQL*Loader, TOAD, Talend, OEM, SQL NavigatorSQL Tools, Powerbuilder 10

GUI Tools: Oracle Forms 6i, Oracle Reports 6i

Others: Object Oriented Designing Methodology, UML, RDBMS Concepts

PROFESSIONAL EXPERIENCE

Confidential, Dallas,TX

Sr.Oracle PL/SQL Developer

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day
• Created and modified severalUNIX shellScriptsaccording to the changing needs of the project and client requirements
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables
• Involved in the continuous enhancements and fixing of production problems
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD
• Involved in System Study, preparation of Detailed Design (DD), Development (Coding), Unit testing, System testing and Integration testing
• Developed PHP and MySQL based products for Jhoomla CMS
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance
• Involved in creating items, item templates, assigning item attributes, item categories, sourcing rules, transacting move orders, creating flex fields for sales orders headers and lines, creating order types, line types and invoice types, creating customers, customer accounts, customer sites and addresses
• Developed maintenance screens using Oracle forms 6i to process sales orders and shipments and also created several Email Alerts in Oracle to schedule emails going out to users
• Partitionedthe fact tables andmaterialized viewsto enhance the performance
• Extensively usedbulk collectionin PL/SQL objects for improving the performing
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesand Dynamic SQL
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP Oracle Forms 6i/9i, Reports 6i, Test Tracker, BI Publisher, eWeb Reports, MS Visio.

Confidential, Marlton, NJ

Database Developer

Responsibilities:

• Created new Tables, Indexes, and Sequences where needed.
• Created database triggers for data security & Consistency.
• Wrote complex functions to calculate performance returns of stocks, bonds, and mutual funds.
• Wrote procedures to calculate calendar year returns & trailing year returns both Annualized & Compounded
• Developed SQL*loader scripts to load data in the custom tables
• Created Unix Shell scripts for automating the execution process
• Created Materialized views & normal views where business requirements needed
• Tune the SQL queries and complex procedures to improve performance
• Data migration and conversion done utilizing Oracle utilities: Export/Import
• Communicated issues and progress to project manager
• Involved in solving day-to-day problems, giving support to the users
• Developed scripts for checking oracle errors in alert log and trace files for every 30 minutes
• Involved in providing 24/7 Database Production Support
• Coordinated with the team of java developers to accomplish complex financial calculations.

Environment: Oracle 10g, SQL, PL/SQL, SQL*Plus, SQL*Loader, Exp/Imp, Toad, Java, UNIX.

Confidential, Iowa City, IA

Database Developer

Responsibilities:

• Involved in analyzing the system and business
• Tuned the SQL Queries to improve the system performance
• Developed complex SQL queries for generating reports of various modules
• Involved in analyzing and validating data migrations from the old system to highly relational database system
• Involved in writing complex queries for the project as required using Toad and Oracle SQL Developer
• Used Advanced PLSQL concepts like Bulk collect, plsql tables and Dynamic SQL for DML operations for better performance
• Used SQL*LOADER for loading full and delta files of candidate details.
• Used oracle XML Functions in SQL Queries to generate data in hierarchal structure.
• Modified and Debug the Functions, Procedures and Triggers as per the requirement
• Involved in Bug Fixing and Unit and Integration Testing.
• Involved in the restructuring and fine tuning of the existing SQL Queries according to the new requirement
• Used SQL HINTS whenever required for better performance of queries.

Environment: Oracle 11g/10g, Toad, Oracle SQL Developer, SQL*LOADER, UNIX, Windows XP, Quality Centre, Sybase PDM power designer, CVS version control, Java

Confidential, CA

Database Developer

Responsibilities:

• Involved in requirement gathering, High level and Detail level design documentation
• Developed shell scripts for validating and processing day-to-day data files and applying them to application tables.
• Developed, modified, and optimized complex queries for data retrieval and modification.
• Optimized and Tuned SQL Queries by running Explain plans
• Used advanced PLSQL concepts like Bulk collect, plsql tables and Dynamic SQL for DML operations for better performance
• Extensively used UTL FILE, DBMS XMLGen for creating flat files and XML files
• Created tables with complex constraints applicable to the business rules.
• Created tables, Tablespaces, schemas, views, packages, stored procedures, triggers, functions etc using TOAD
• Wrote control files for data loading using SQL*Loader
• Wrote Unix shell scripts for automating regular data loading jobs
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges
• Involved in developing scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
• Benchmarked data loads on different environments
• Monitoring data staging, processing and loading jobs
• Involved in Production support and Maintenance

Environment: Oracle9i/10g, SQL, PL/SQL, SQL*Plus, SQL*Loader, Java, SQL Navigator, Sub Version, Mercury Quality Control, Solaris-Linux

Confidential

Software Engineer

Responsibilities:

• Incorporating all the build rules, writing the code using SQL*PLUS, PL/SQL
• Used SQL* Loader to load data into different tables
• Mapping Operational Repository to Business Repository elements and incorporating the build rules
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers
• Extensively used PL/SQL to extract data from different tables with 20 Million records in some of the tables
• Based on the user selection and finally storing the output as a flat file for further processing for the next module
• Extensively used SQL & PL/SQL in reports. Cardinalities and Joins were used
• Incorporated validation rules for promotion history table and updating tables
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes
• Generated PL/SQL reporting and Unix Scripts to notify process failure/success.
• Also my role includes testing the data in addition to re-designing the database. Front end using Forms 4.5 and Reports 2.5

Environment: Oracle 7.3.4, Forms 4.5, Reports 2.5, PL/SQL, SQL*Plus, Exp, Imp and Windows NT.

Confidential

PL/SQL Developer

Responsibilities:

• Incorporating all the build rules, writing the code using SQL*PLUS, PL/SQL
• Used SQL* Loader to load data into different tables
• Mapping Operational Repository to Business Repository elements and incorporating the build rules
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers
• Extensively used PL/SQL to extract data from different tables with 20 Million records in some of the tables
• Based on the user selection and finally storing the output as a flat file for further processing for the next module
• Extensively used SQL & PL/SQL in reports.
• Cardinalities and Joins were used
• Incorporated validation rules for promotion history table and updating tables
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes
• Generated PL/SQL reporting and Unix Scripts to notify process failure/success.
• Also my role includes testing the data in addition to re-designing the database. Front end using Forms 4.5 and Reports 2.5

Environment: Oracle 7.3.4, Forms 4.5, Reports 2.5, PL/SQL, SQL*Plus, Exp, Imp and Windows NT.