SUMMARY

• Over 6+ years of programming experience as an Oracle SQL and PL/SQLDeveloper in Analysis, Design and Implementation of Applications using the Oracle Relational Database Management System (RDBMS).
• Developed complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Created Tables, Views, Constraints, Index(B Tree, Bitmap and Function Based).
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Worked extensively onRef Cursor, External Tables and Collections.
• Expertise in Client - Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD, SQL Developer and SQL*LOADER.
• TEMPEffectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write.
• Experience wifData flow diagrams, Database normalization, Entity relation modelinganddesign techniques.
• Good knowledge on logical and physicalData Modelingusingnormalizing Techniques.
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance wif timely delivery against aggressive deadlines.
• Good knowledge on Data warehouse concepts, ETL.
• Developedmaterialized viewsfor data replication in distributed environments.
• Loaded Data into Oracle Tables usingSQL Loader.
• Experience wif Oracle Supplied Packages such asDBMS SQL, DBMS JOB.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Expertise in Dynamic SQL, CollectionsandException handling.
• Experience in SQLperformance tuningusing Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such asQuery Optimizer, Execution PlansandIndexes.
• Experience wifPerformance Tuningfor Oracle RDBMS usingExplain PlanandHINTS.
• Expertise in designing and developing Oracle Forms and Reports.
• Good knowledge on Java, HTML, XML and XSL.
• Created Shell Scriptsfor invoking SQL scripts and scheduled them using cron tab.
• Experience in Agile Development using Scrum.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

RDBMS/Application Sever: Oracle 11g/10g/9i/8i/, Developer 11g/10g/9i/6i suite (Forms 10g/9i/6i, Reports 10g/9i/6i), Oracle Designer 2000/6i, Discoverer 9i SQL*PLUS, Server Manager/SQL*DBA, Export/Import, SQL*Loader, Erwin, Toad, Oracle Enterprise Manager

Languages: SQL, PL/SQL, Unix shell scripting (Bourne shells)

Operating System: Oracle Enterprise Linux, Red hat Linux, Sun Solaris for SPARC 8.0/2.6, HP UNIX 10.2, IBM AIX 4.1, Windows-2000/NT/98/95, MS-DOS

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK

Languages and Web Technologies: SQL, PL/SQL, Java, J2EE, Shell Scripting, XML, HTML/XHTML.

Hardware: SUN SPARC E5500, HP9000, IBM RS/6000, Dell Power Edge 6400, Intel x86, P-II/P-III/P-IV

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Oracle PL/SQL Developer

Responsibilities:

• Coordinated wif the front end Service Now application team to provide them wif the necessary stored procedures and packages and the necessary insight into the data.
• Creation of database objects liketables, views, materialized views, procedures and packages using oracle tools likeToad and PL/SQL Developer for customer data.
• 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 for Service Now Customer data.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to production.
• Created scripts to createnew tables, views, queriesfor new enhancement in application using TOAD for client’s data.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools like SQL*TRACEandAUTOTRACE.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesand Dynamic SQL for Order module.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.

Environment: Java, Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows.

Confidential, Ann Arbor, MI

Oracle PL/SQL Developer

Responsibilities:

• Involved in gathering requirements and created design documents and mapping documents.
• Involved in design and development complex ETL mappings and stored procedures in an optimized manner.
• Migrating data from legacy systems (SQL Server, Sybase, Amisys, etc.) into Facets database (Oracle) and into Data warehouse.
• Writing PL/SQL code to integrate data from multiple source systems into Data Warehouse and Facets.
• Writing PL/SQL code. (Stored procedures, functions, triggers, packages, batch jobs, etc.).
• Developed complex mappings and SCD type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations. Created complex Mapplets for reusable purposes.
• Performing SQL and PL/SQL tuning using Explain Plan, Execution plan, SQL Trace utility, TKProf & DBMS PROFILER.
• Writing Korn shell scripts.
• Carrying out code review of other developers.
• Maintaining different versions of codes using SVN.
• Using SQL*Loader, BCP (bulk loader), Informatica Power center to load data from external files.
• Using DBMS JOBS, DBMS SCHEDULER to automate jobs.
• Writing Batch jobs, daily jobs, one time jobs and queues.
• Using Oracle Reports for reporting.

Environment: Oracle 9i, SQL*PLUS, PL/SQL, SQL navigator, SQL*LOADER, Forms 9i, Reports 9i, UNIX

Confidential, Columbus, OH

Oracle PL/SQL Developer

Responsibilities:

• Developed AdvancePL/SQL packages, procedures, triggers, functions, Indexesand Collectionsto implement business logic usingTOAD for CIS data.
• Generated server side PL/SQL scriptsfordata manipulationand validation and materialized views for remote instances.
• Created management analysis reporting usingParallel Queries, Java stored procedure API.
• Participated in change and code reviews to understand the testing needs of the change components.
• Worked on troubleshooting defects in timely manner.
• Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
• Involved in table redesigning wif 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 existingformas per change request and maintained it.
• UsedCrystal Reportsto track logins, mouse overs, click-through, session durations and demographical comparisons wif SQL database of customer information.
• 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 usedBULKBinding 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.
• Involved in data replication and high availability design scenarios wifOracle Streams.
• DevelopedUNIX Shell scriptsto automate repetitivedatabase processes.

Environment: Oracle 10g/11g, PL/SQL, SQL*LOADER, Oracle Streams 10g (Replication), SQL PLUS, HTML,, TOAD, XML, UNIX shell scripting.

Confidential, Warren, NJ

Oracle Developer

Responsibilities:

• Wrote complex queries using SQL and wrote stored procedures using PL/SQL in Various API’s like Java, .Net and Hierarchical databases like Oracle and Access.
• Developed and modified a number ofFormsand for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
• Wrote Shell Scripts forData loadingandDDL Scripts.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Wrote conversion scripts usingSQL, PL/SQL, stored procedures, functionsandpackagesto migrate data from SQL server database to Oracle database.
• Performed Database Administration of all database objects includingtables, clusters, indexes, views, sequences packagesandprocedures.
• Implemented 11g and upgraded the existing database from Oracle 9i to Oracle 11g.
• Involved inLogical & Physical Database Layout Design.
• Performance tuning of Oracle Databases and User applications.
• UsedDTS Packagesas ETL tool for migrating Data from SQL Server 2000 to Oracle 10g.
• Provided user training and production support.
• Improved the performance of the application by rewriting theSQL queries.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.

Environment: Oracle 9i/10g/11g SQL, PL/SQL, Forms 9i, Reports 9i, SQL*Loader, SQL Navigator, Crystal Reports, TOAD.

Confidential, Chicago, IL

Oracle Developer/Analyst

Responsibilities:

• Involved in full development cycle ofPlanning, Analysis, Design, Development, Testingand Implementation.
• Designed logical and physical data models.
• UpgradedOracle 9i to 10gsoftware in different environments for latest features and also tested databases.
• 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 wif 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.
• Created some Custom reports and Forms for the end users to check the details and errors.

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