SUMMARY

• 8+ Years of Experience in Database Development, Application Development using Oracle 11g/10g/9i/8i/8.x and Developer 2000(Forms and Reports).
• Over 8 years of diverse experience in various capacities in IT Industry which includes Oracle Forms 10g/9i/6i/5.0/4.5, Reports 10g/9i/6i/5.0/4.5, Graphics Builder 6i, Discoverer 9i, SQL, PL/SQL Developer, TOAD, SQL Loader, Designer 10g/9i/6i.
• Extensive working experience and Expert in developing Forms 10g/9i/6i, Reports 10g/9i/6i, PL/SQL, SQL, Discoverer, XML/BI publisher.
• Strong experience in developing and maintaining Oracle 10g &11g application using Oracle 10g & 11g Forms and Reports.
• Good knowledge in STAR Schema, Snow Flake Schema, FACT Tables and Dimension Tables.
• Experienced in different Modeling Types (Conceptual Data Modeling, Logical Data Modeling, Physical Data Modeling, Relational Data Modeling and Dimensional Data Modeling).
• Extensive experience in writing Tables, Views, Constraints, Indexes, Sequences, Database Triggers, Synonyms, Stored Procedures, Packages, Functions, Collections, Records.
• Expertise in areas of Application software development and maintenance in Oracle environment using Client/Server.
• Experienced in SQL*Loader, Data pumps, Import, Export, UTL FILE, SQL Query Tuning using Explain Plan, Auto Trace, TKPROF, PVCS, and DBMS PROFILER for maximum efficiency and performance.
• Good knowledge on version control tools like PVCS which helps multiple users to access the source code of the PL/SQL programs.
• Worked in various levels of SDLC (System Development Life Cycle) which involves Analysis, Design, Development, Testing, Implementation and support with extensive exposure in database.
• Extensive experience in using Cursors, Ref - cursors, collections and nested tables for processing of data.
• Experience in evaluating and performance testing of database applications. Implemented indexes on tables for better performances on data retrieval from oracle.
• Implemented DBMS JOB, UTL FILES, DBMS LOB and UTL SMTP Built-in Packages.
• Used UTL MAIL packages to automate the reportdelivery through Emails.
• Comprehensive knowledge in different types of optimizer hints, indexes, table partitions and sub-partitions, materialized views, global temporary tables, autonomous transactions and bulk binds.
• Established and maintained productive working relationship with Management, Clients and Team Members.
• Self-starter, entrepreneurial, highly motivated team- player with excellent communication / problem-solving skills.
• Flexibility and Adaptability in regards with new technologies and new environments.

TECHNICAL SKILLS

Operating Systems: Windows 9.x / NT / 2000,XP,2003,2008, UNIX,LINUX, AIX Systems

Languages: SQL, PL/SQL, C, C++, Pro*C, Java

Databases: Oracle 8i/9i/10g,11g, DB2/UDB, MS Access

Scripting Languages: HTML, DHTML, JavaScript, PERL, XML

Utilities: SQL Loader, SQL Navigator, TOAD, PL/SQL Developer, XML/BI Publisher, SQL*Plus

Case Tools: Rational Rose, Smart Draw

Data Modeling: ER-Win 3.5/4.0

ETL Tools: Informatica 8.6, Oracle Change Data Capture (CDC)

GUI Tools: Oracle Forms 6i/9i/10g, Oracle Reports 6i/9i/10g, Oracle Discoverer 9i

Other Tools: Auto Sys, PVCS, Win CVS, T Pump, Fast Load, BTEQ

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

Sr Oracle Developer

Responsibilities:

• Extensively used SQL Query, Joining tables, SQL functions in Queries.
• Creation of objects in PL/SQL with the use of Cursors, REF Cursors and loops. Also the PL/SQL table and record, PL/SQL Wrappers, Function Overloading etc.
• Developed lot of PL/SQL programs, stored procedures and triggers for data loading and data validations.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes, Analytic functions, Hints, Partitions, Cursors etc., and Views in Development and Production environment in PL/SQL.
• Performed Application Migration from Oracle Forms 10g, Reports 10g to Forms 11g, and Reports 11g.
• Involved in Production Support to allow effective capture, reporting, tracking and resolution of issues, performed periodic tuning as a part of application maintenance.
• Developed Oracle PL/SQL stored procedures used for migrating data for initial load and daily load.
• Used VI editor for PL/SQL scripts and UNIX Shell Scripting.
• Creation, maintenance and debugging of PL/SQL packages and procedures including the use of Cursors, REF Cursors, Loops, Collections, Records, Error Handling, DBMS OUTPUT, BULK COLLECT and Dynamic SQL.
• Applications tuning using Explain Plan, SQL trace, TKPROF and hints.
• Performed Performance Tuning using the DBMS PROFILER package, this checks the run time behavior.
• Identified if any programs or any updates in the table or any deletion by setting up the DBMS JOB package.
• Working with DBA’s in moving code between instances using UNIX shell scripts and Move request templates for testing and quality purposes.
• Written shell scripts to automate loading files into database using crontab, error handling and notification.
• Developed UNIX Shell Scripts with embedded SQL*Loader, Expdp/Impdp calls and PL/SQL statements to extract data in the form of flat files for data loading and data migration.
• Involved in collecting specifications, Analyzing and mapping of FRLs with Procedures and also involved in testing applications using the PL/SQL anonymous blocks, Procedures and Functions.
• Involved in loading the data loads coming from flat files into staging tables in the Oracle Database using SQL* Loader.
• Executed PL/SQL scripts on server using Shell and Perl scripts.
• Assisted the team of Developers in SQL statement tuning and use of ANALYZE command, Events trace to track the execution plan of statements.
• Involved in Writing Backend Packages extensively in PL/SQL.
• Involved in Code Reviews and preparing unit test cases.
• Created several materialized views for reporting purpose and better performance.
• Designed API’s for integrating data from external XML files into Oracle database.
• Developed and modified a number of Forms 10g and Reports 10g for various modules.
• Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
• Generated web pages directly from an Oracle 10g database by using PL/SQL Web Toolkit.
• Extensive Use of External tables and Creating Sequences to generate numbers on the fly.
• Involved in requirement analysis, design, implementation, testing of the new system.

Environment: Oracle 11g, Reports 10g, Forms 10g, Discoverer 10g, XML Publisher, PL/SQL Developer, SQL*Loader, Oracle Performance Tuning, TOAD, UNIX, Win SCP.

Confidential, Bloomington, IL

Sr. Oracle Developer

Responsibilities:

• Creating or modifying Packages, Procedures and functions using SQL Navigator application tool and then launching the applications from a report console or at the URL line.
• Developed primary database objects such as tables, Indexes and views to implement required functionality.
• Developed Customized Forms in Vendor Management, Service Initiation, Install Base, Notes, Tasks, Log, Customer, Contact, INV, AP, PO, AR and GL etc.
• Developed Forms and Reports in Windows environment using Oracle Forms10g for Quote Management Systems.
• Involved in requirement analysis, design, implementation, testing and deployment of the system.
• Support, Enhancement and Bug fixing for SCM (Service Contract Management) Product.
• Developed packages, procedures, triggers and views to bridge the gaps between the old and new application.
• Developed back-end PL/SQL packages, building UNIX shell scripts for data migration & Batch Processing.
• Using Oracle built-in packages to manipulate BLOBS, and Materialized Views to generate aggregate reports.
• Handling the conversion of existing SQL Batch reports with Oracle 10g Reports; Release and Configuration Management of the application.
• Developed various complex queries to generate various reports to predict business trend.
• Performed Performance Tuning using the DBMS PROFILER package, this checks the run time behavior.
• Developed reports using Reports and invoked Triggers, etc.
• Configured and deployed Forms and Reports to the Forms & Reports 10g Server.
• Involved in design, development and testing of Forms and Reports.
• Migrated data between stage and application schemas. Developed SQL*LOADER control CTL files for data loading.
• Worked on SQLPLUS and SQLLDR calls from shell scripts.
• Executed PL/SQL scripts on server using Shell and Perl scripts.
• Developed Forms, Menus, PL/SQL Libraries and Object Libraries extensively for code reusability and standardization.

Environment: Oracle 11g/10g, PL/SQL, Unix Shell Scripting SQL Navigator, SQL*PLUS, Forms 10g/9i, Reports 10g/9i, BI (XML) Publisher, Vi Editor, SQL*Loader, PL/SQL Developer, TOAD, PUTTY.

Confidential, Boston, MA

Oracle Developer

Responsibilities:

• Developed PL/SQL procedures, packages and triggers as required.
• Tuned SQL queries by using quest central tools and manual by EXPLAIN PLAN.
• Testing on PL/SQL code and make Documentation of Root cause of Error message occurs and Fix it.
• Reduced processing times of SQL queries, night batch jobs by reviewing PL/SQL code, modifying database parameters.
• Wide experience in applying Business Logic using SQL Scripts, PL/SQL, Database Packages, Stored Procedures, Functions and Triggers.
• Designed the mappings between sources (external files and databases) to operational staging targets.
• Developed Packages, Procedures, Triggers, Tables, Creating Primary and Foreign Constraints, Unique constraints, Check constraints, Views, Creating indexes to bridge the gaps between the old and new application.
• Created database objects like Sequences Procedures Functions Packages Triggers Indexes Cursors and Views in Development and Production environment in PL/SQL
• Troubleshooted performance issues and bugs within packages, forms, and reports using dbms output, Forms debugger, explain plan and TKPROF.
• Use SQL*Loader, SQL, shell scripts (awk, sed), and Perl to load Oracle Data Warehouse.
• Programmed batch routines that perform multiple tasks for a single processing.
• System analysis, design, management, development, testing and deployment.
• Involved in requirement analysis, design, implementation, testing of the system
• Worked in production (LIVE) environment in Oracle Databases
• Performance tuning of Oracle Databases and User applications.
• Created oracle objects like Views, Materialized Views, Inline views, hints.
• Developed Complex Business Logic using procedures, packages, triggers, function for programming.
• Utilized ORACLE Import, Export Utilities.

Environment: Oracle 10g/9i, Unix, SQL+, PL/ SQL, Forms 9i/6i, Reports 9i/6i, Oracle Performance Tuning, PL/SQL Developer, TOAD, SQL Navigator, Vi Editor, TKPROF, Query Analyzer.

Confidential, San Jose, CA

Oracle Developer

Responsibilities:

• Created many Generic Stored Procedures, Functions, Database Triggers, Packages, tables, indexes, views, synonyms, sequences using SQL and PL/SQL.
• Extensively used PL/SQL programming in backend and front end Functions, Procedures, and Packages to implement business logics/rules.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms and Sequences.
• Analyzed the system requirements and performed logical and physical design of the database.
• Experience in performance Tuning using Explain plan and hints. Experience with Query Optimization procedures using SQL Advisors.
• Used SQL*Loader for data uploading from flat files. PL/SQL Coding and SQL tuning throughout the development wherever needed.
• Experience in developing Dynamic SQL and Ref cursors and Hands-on experience in writing Packages, Stored procedures, Functions, and Database.
• Created application schema as tables, view and indexes and customized the stored procedures and database triggers in PL/SQL.
• Exception handling and cursor management in PL/SQL.
• Involved in developing packages to transfer data from different Oracle forms to Oracle database, every time whenever processor do the transactions.
• Involved in form level coding for Approval, Data Entry, Data Query and Response Modules as per the requirements.
• Designed Conversion and Interface Programs using PL/SQL procedures and packages.
• Analysis, Development, Testing and Implementation using Oracle 10g/9i/8i.

Environment: Oracle(9i / 8i), PL/SQL, Oracle Performance Tuning, Forms & Reports 9i/6i, PL/SQL Developer, TOAD, SQL Navigator, Vi Editor, TKPROF, Query Analyzer

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Creating E-R Diagram, Function Hierarchy diagrams, Process diagrams and Data flow diagrams for designing database using Designer 2000.
• Extensive use of Toad, PL/SQL Developer for development of Oracle database objects.
• Generation of the flat files using UTL FILE package for the mainframe users.
• Extensive tuning of application SQL Statements.
• Consulting with internal and external customers to gather requirements for various forms and reports.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
• Create complex procedures and functions to identify the customers eligible for combining loan rates with the account history.
• Planned version control of production source code using Concurrent Version System (CVS).
• Optimize database queries to improve processing speed using index and hints.
• Developed oracle reports to represent complex queries to classify customers based on the location and allocate a biller.

Environment: Oracle 7.3, PL/SQL, Forms & Reports 6i, Oracle Performance Tuning, TOAD, SQL Navigator, Designer 2000, Query Analyzer.