SUMMARY

• Around 9 years of programming experience as in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Extensive experience in Data Transformations, Data Loading, Database Modeling and Performance Tuning.
• Strong knowledge in front end development using oracle forms/reports6i/9i/10g/11g.
• Experience in different phases of Oracle Application implementation life cycle including Technical Design, Data Conversion, OracleForms development, and Oraclereport development, Unit Testing, Integration Testing, End User Training, and Production Support.
• Strong Knowledge on oracle architecture and database design.
• Excellent knowledge on data warehousing concepts and implementation using oracle ware housing.
• Strong knowledge on Star schema, snowflake schema
• Expert in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Hands on experience in design, development of end user screens and reports using Oracle Developer/2000 (Forms, Reports), Forms and Reports, Oracle Developer Suite 10g.
• Experience in Database design using Normalization and E/R Diagrams.
• Extensive experience in developing UNIX Shell scripts, scheduled complex cron jobs on UNIX platform using crontab format
• Expertise in Database Performance Tuning and Optimization of SQL statements using Oracle Hints, Explain plan, Tkprof, SQL*Trace and Table partitioning.
• Experience in troubleshooting various aspects of the client/server architecture in both UNIX and Oracle setting.
• Proficient in Oracle Tools and Utilities such as SQL*Loader, Import/Export, TKPROF and SQL*Navigator v.4.5.
• Experience in developing Reports in MS Excel, MS Access and Creating different analytical reports.
• Experience in using Business Intelligence/Enterprise Reporting delivery tools like Crystal Reports, Crystal Enterprise, Business Objects, and Client/server and web application.
• Excellent planning, analytical, written Communication, ability to work under pressure and Interpersonal skills.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/ 8i,DB2, Teradata v2r5.

GUI’s: Developer/2000(Forms10g/9i/6i/5.0/4.5&Reports 10g/9i/6i/3.0/2.5), OWB.

Languages: SQL, PL/SQL, C, HTML, XML, java script.

TOOLS: SQL*Loader, Export, Import, TOAD,SQL*PLUS, SQL*NAVIGATOR, SQL DEVELOPER, Putty, VI Editor, forms Builder, Reports Builder, Procedure Builder, Graphics Builder, Import & Export utility, Erwin.

OPERATING SYSTEM: Windows7/ NT/2000/98/95, DOS 6.0/3.0, UNIX,SUN SOLARIS

PROFESSIONAL EXPERIENCE

Confidential, Foster City, CA

Oracle Developer

Responsibilities:

• Responsible for requirements gathering from Clients and implement the back end changes in existing product and in designing the database.
• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
• Created Platform independent schema structure so that the product data can be implemented in any database.
• Used Internationalization and Localization techniques in designing data structure so that it can be adapted to various languages and regions without engineering changes.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Loader, Query performance tuning, created DDL scripts, created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Developed Shell scripts and SQL control files to load data through SQL Loader.
• Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out the projects.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Performance Tuning: Used partitioning and sub partitioning of tables to improve performance
• Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF.
• Used Bulk Collect feature to improve performance.
• Analyzed and computed statistics to improve response time for queries.
• Involved in Performance tuning of complex queries.
• Test case/data preparation, execution and verification of the test results.

Environment: Oracle 11g/10g, Clear case, Clear quest, Toad 9.5, PLSQL Developer 7, Sun OS 5.8, Windows XP 5.1.2, AB Initio, Business Objects, DOORS.

Confidential, Gaithersburg, MD

Oracle Pl/SQL Developer/ Data Analyst

Responsibilities:

• Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.
• Developed AdvancePL/SQL packages, procedures, triggers, functions, Indexesand Collectionsto implement business logic usingSQL Navigator.
• Generated server side PL/SQL scriptsfordata manipulationand validation and materialized views for remote instances.
• Involved in creatingUNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
• Involved in table redesigning with implementation of Partitions Table and Partition Indexes to makeDatabaseFaster and easier to maintain.
• Experience inDatabase Application Development, Query Optimization, Performance Tuning andDBAsolutions and implementation experience incomplete System Development Life Cycle.
• Extracted data from the XMLfile and loaded it into thedatabase.
• Designed and developedOracle forms & reportsgenerating up to 60 reports.
• Performed modifications on existingforms as per change request and maintained it.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day. Used standard packages likeUTL FILE, DMBS SQL, and PL/SQLCollections and usedBULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Used principles of Normalization to improve the performance.
• Involved in the continuous enhancements and fixing of production problems.
• Designed, implementedandtunedinterfaces and batch jobs usingPL/SQL.
• DevelopedUNIX Shell scriptsto automate repetitivedatabase processes.

Environment: Oracle 10g, PL/SQL, SQL*LOADER, HTML, TOAD, XML, HP - UNIX shell scripting.

Confidential, Columbus, IN

Oracle PL/SQL Developer/ Data Analyst

Responsibilities:

• Involved in full development cycle ofPlanning, Analysis, Design, Development, Testingand Implementation.
• Involved in migrating warehouse database from Oracle 9i to 10g database.
• Involved in analyzing and adding new features of Oracle 10g like DBMS SHEDULER, Create Directory, Data pump, CONNECT BY ROOT in existing Oracle 9i application.
• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
• Tuned Report performance by exploiting the Oracle’s new built-in functions and rewriting SQL statements.
• Designed logical and physical data models for star and snowflake schemas usingErwin.
• Used EXPLAIN PLAN, TKPROF to tune SQL queries.
• Used BULK COLLECT and External Tables for improving performance on the Enterprise DataWarehouse.
• Wrote sequences for automatic generation of unique keys to supportprimary and foreign key constraints in data conversions.
• Created and modifiedSQL*Plus, PL/SQLandSQL*Loader scriptsfor data conversions.
• Developed and modifiedtriggers, packages, functionsandstored proceduresfor data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Worked onXMLalong with PL/SQL to develop and modify web forms.
• Designed Data Modeling, Design Specifications and to analyzeDependencies.
• Creatingindexeson tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases usingOracle Hints, for Rule based optimization.

Environment: Oracle 9i, 10g, SQL*Plus, PL/SQL, Erwin 4.1, Oracle Designer 2000,Windows 2000, Toad

Confidential

Oracle Pl/SQL Developer

Responsibilities:

• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Knowledge of Normalization, and data transfer, documentation, preventive maintenance, code review, automation, store procedures and triggers etc.
• Performed exception handling for data that did not conform to the required format.
• Responsible for making the merged data in turn available to other clients.
• Wrote UNIX scripts to automate loading files into database using error handling and notification.
• Involved in implementing the data integrity validation checks through constraints and triggers.
• Involved in developing packages for implementing business logic through procedures and functions.
• Developed and modified procedures, functions, triggers, forms, and reports and deployed the changes in the system.
• Developed user interfaces using Oracle Forms.
• Extensively involved in application tuning, SQL tuning, memory tuning and I/O tuning using Explain Plan and SQL trace facilities.
• Performance of the queries is enhanced by executing optimization techniques such as index creation, table partition and coding stored procedures.
• Responsible for creation of new users and setting up privileges and policies for protection of data.
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.

Environment: Oracle 9i, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Oracle Forms 9i, Reports9i.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Analyzed requirements, designed, developed, deployed and documented software components.
• Designed ER diagram using Erwin, to set the logical and physical relationships of database.
• Developed the shell script, SQL*Loader script, and most of PL/SQL stored procedures, triggers and views to handle the Online and Batch process
• Created database Triggers for the security purposes.
• Developed Forms as per the requirements using Forms 6i.
• Involved in Control File Format in SQL*LOADER.
• Creating SQL, Object Views, and PL/SQL database objects.
• Written the interface stored procedures for data transformation.
• Performed Performance Tuning using the DBMS PROFILER package, this checks the run time behavior.
• Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.
• Involved in Troubleshooting performance issues and bugs within packages and stored procedures using dbms output and explain plan.
• Developed test plan documents for all back end database modules.
• Responsible for documentation of the interfaces.
• Developed User Interfaces (forms 6i ), Stored Procedures ( PL/ SQL), Reports (sql )
• Writing Unix Shell Scripts to run batch jobs, automated processes, and to automate routine systems administration tasks.
• Developed complex procedures to handle errors and exceptions at database level using PL/SQL.
• Tuned the SQL Queries with the output of Oracle Tools like Explain Plan, TKPROF.

Environment: Oracle database 9i, Forms 6i, PL/SQL, SQL Plus, SQL*LOADER, TKPROF, TOAD, and UNIX.