SUMMARY

• Around 7 years of programming experience as anOracle PL/SQLDeveloper in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques.
• Expertise in Client - Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADandSQL*LOADER.
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-WriteandTransportable table spaces.
• Strong experience inData warehouse concepts, ETL.
• Good knowledge on logical and physicalData Modelingusingnormalizing Techniques.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developedmaterialized viewsfor data replication in distributed environments.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTPand dimension modeling forOLAP.
• Experience inOracle supplied packages, Dynamic SQL, RecordsandPL/SQL Tables.
• Experience in data loading usingSQL Loader.
• Experience with Oracle Supplied Packages such asDBMS SQL, DBMS JOBandUTL FILE.
• Expertise inDynamic 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 withPerformance Tuningfor Oracle RDBMS usingExplain PlanandHINTS.
• Experience inETLtechniques and Analysis and Reporting including hands on experience with the Reporting tools.
• Experience in developing Shell Scriptsfor invoking SQL scripts and scheduled them using crontab.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

ETL/Reporting Tools: Informatica Power Center 8.1/8.0

Databases: Oracle 11g/10g/9i/8i/8.0/7.x, MySQL, Microsoft SQL Server 2000/2005, MS Access

Tools: /Utilities: TOAD, PL/SQL Developer, SQL Developer, SQL Navigator, SQL*Plus, SQL*Loader, SQL Navigator MS Visio

Scheduling Tools: Control M, Autosys, Tidal, Tivoli Alerts

Operating System: Windows 95/98/2003/XP/NT/Vista/7, UNIX, Linux

Programming /Scripting Languages: SQL, PL/SQL, Proc*C, C/C++, Java, Cobol, CICS, HTML, XML, UNIX Shell Scripting, Korn Shell Scripting (Kshell), Perl

Data Modeling Tools: Erwin 3.x/4.x, E/R Studio

Version Control: Starteam, PVCS, Rational Clearcase, Tortoise SVN

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

Sr. Oracle PLSQL Developer

Responsibilities:

• Involved in full development cycle ofPlanning, Analysis, Design, Development, Testingand Implementation.
• Developed and modifiedtriggers, packages, functionsandstored proceduresfor data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote sequences for automatic generation of unique keys to supportprimary and foreign key constraints in data conversions.
• Created and modifiedSQL, PL/SQLandSQL*Loader scriptsfor data conversions.
• Worked on Cursors, Ref cursors, collections and bulk collection.
• Wrote various programs required to retrieve data using cursors and exception handling.
• Createdindexeson 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.
• Used various tools like JIRA and SVN to keep track of the working modules.
• Responsible for unit testing and project documentation.
• Tuned Report performance by exploiting the Oracle’s new built-in functions and rewriting SQL statements
• Extensively used Erwin for data modeling and Dimensional Data Modeling by ERWIN.
• Developed various UNIX Shell Scripts to automate the routine tasks
• Provided support for testing and production environments.

Environment: Windows 2000/XP/Win7, Oracle 11g/10g, TOAD, PLSQL Developer, SQL Plus, Tortoise SVN, JIRA bug Tracker, UNIX, Putty, ERWIN

Confidential, Durham, NC

Oracle PLSQL 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 shell scriptsaccording 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.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Creation of database objects liketables, views, materialized views, procedures and packages using oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• Extensively usedbulk collectionin PL/SQL objects for improving the performing.
• 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.
• 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

Confidential, Atlanta, GA

Oracle PLSQL Developer

Responsibilities:

• Involved in full development cycle ofPlanning, Analysis, Design, Development, Testingand Implementation.
• Developed various modules using Oracle PLSQL. 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 inPerformance tuning of Oracle Databases and User applications.
• UsedSQL*Loaderas an ETL tool to load data into the staging tables.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.

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

Confidential

Oracle PLSQL Developer

Responsibilities:

• Worked closely with managers and external clients - gathered business requirements, provided advice, guidance and operational services for the project.
• Involved in the Analysis, Design, Coding and Testing of the application.
• Tune SQL statements using hints for maximum efficiency and performance, create and maintain/modify PL/SQL packages, mentor others with the creation of complex SQL statements, perform data modeling and create/maintain and modify complex database triggers and data migration scripts.
• Performed unit testing and supported integration testing and end user testing.
• Proactively tuned SQL queries and performed refinement of the database design to leading significant improvement of system response time and efficiency.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN, etc.
• Developed UNIX shell scripts in VI Editor with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
• Created indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
• Design and development of conversions, interfaces, customizations, Custom Forms, Reports and all Technical design and solutions.
• Ensured that the project was aptly managed and delivered accordingly, maintaining excellent balance among the team and client requirements.

Environment: Windows 2000/XP, Oracle 9i, SQL, PLSQL, SQL*Loader, KORN Shell script, TOAD, UNIX