SUMMARY

• Over 7+ years of extensive working experience as an Oracle PL/SQL developer with proven ability in the area of Client/Server and Distributed Multi - tier Application Development, Data modeling, Design, Development, Data processing, System Analysis, Testing, Deployment and support with Oracle technology on different platforms.
• Experience in developing External Tables, Stored Procedures, Functions, Packages, Views, Materialized Views, Joins, indexes, Cursors, Database Triggers, Dynamic SQL, Records, ETL Process, shell scripts, Arrays and Exception Handling.
• Experience in using Database skills such as export, import, data pump and SQL* Loader.
• Expertise in Production Support.
• Worked in extensively on Query Level Performance tuning using Explain Plan, SQL Trace and TKPROF utilities to pin point time consuming SQL’s and tuned them by creating indexes and forcing specific plans.
• Experience in SQL* Loader, Toad, PL/SQL Developer, Oracle SQL Developer, Erwin tools.
• Strong experience with Oracle Data Warehouse, ETL Process.
• Worked on large databases up to 8 terabytes.
• Proficient using UNIX command and Shell Scripting.
• Expert in Query Optimization, Debugging and Tuning for improving performance of the applications.
• Have experience in Relational and Dimensional Data modeling, Normalization, Demoralization, Data Architecture.
• Excellent communication skills, problem solving and logical methodology. Work well in the team environment, Self-motivated, quick learner, able to work well under tight deadlines and rapidly changing priorities.

TECHNICAL SKILLS

Databases: Oracle 8,8i, 9i, 10g, 11g, SQL Server 2000/2005, Microsoft Access

Oracle Software: TOAD, SQL *PLUS, ERWIN, Oracle 6i/9i/10g, Teradata SQL AssistantReports & Forms developer suite, TKPROF, EXPLAIN PLAN SQL*Loader, Export, Import, SQL Developer, OWB

Scripting: HTML, XML, Korn & Bash Shell ScriptingOperating System Windows 9x/NT/2000/2003/XP/VISTA, Linux(RedHat Linux), UNIX. Aix

Programming Languages: SQL, PL/SQL, Shell.

Tools: Oracle Forms & Reports, Oracle Enterprise Manager(OEM), oracleware house builder (OWB), Toad, PL/SQL Developer, Erwin

PROFESSIONAL EXPERIENCE

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Gathered Business Requirements from the client and translated the business detail in to technical design and specification.
• Extracted the data from the various legacy systems.
• Analyzed the data, extracted from the different source systems based on the business rules.
• Creation of Database, table spaces, schema objects and stored procedures.
• Developed various backend application programs such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL.
• Responsible for creating functions to be used for calculations. Written database triggers for monitoring the data migration.
• Developed algorithm and PL/SQL code for efficient retrieval and manipulation of complex data sets using PL/SQL packages.
• Written PL/SQL procedures and functions while migrating the data from the source legacy systems to the Target system (Oracle database).
• Extracted and transformed source data from different database like Oracle, SQL Server and DB2 and flat file into oracle.
• Loaded the flat file data into database table by creating multiple SQL*Loader control scripts.
• Created and modified database objects like tables, views, and constraints.
• Implemented business logic using stored procedures to increase performance.
• Used Explain plan and TKPROF for Tuning the SQL statements by creating indexes. Generated session level trace and used the TKPROF utility to get the report for the trace file.
• Monitor and publish database response times, uptime of different applications in supporting different database applications.
• Created some executable programs running in UNIX shell script operation system.
• Wrote Unix Shell scripts for automating the process
• Enhanced the existing UNIX scripts to run batch processes, oracle background processes using JOBS & achieve better performance and throughput.
• Manage work sheets and workbooks. Using discover to complexity of underlying database structures like OLAP, cubes, tables, column, joins etc
• Created stored procedure and function in PL/SQL to increase the performance of Forms on web server.
• Used TOAD, Erwin tools for database designing and business process flow.

Environment: Oracle 9.2.0.2/10.2.0.1/11 , SQL Server 2000, PL/SQL developer, SQL*Loader, TOAD, HTML, Windows, 2000/2003/XP, FTP, Developer 2000, Export, Import, ETL, Erwin, Unix sun Solaris(5.10), Unix shell scripts.

Confidential, Clearwater, FL

Oracle PL/SQL & ETL Developer

Responsibilities:

• Deployed business rules into PL/SQL code for data analyzing, transforming and cleansing.
• Created Custom Packages, Stored Procedures, Function and SQL Scripts to load data into Data warehouse from different sources clean and transform data to provide quality information, and manage metadata.
• Created/updated Oracle procedures to transfer data from legacy source to staging area and from staging area to data warehouse and to data marts with Business Intelligence reporting layers.
• Prepared/updated shell scripts for ETL to run in batch.
• Tested and took measures for maximum performance utilizing optimization hints, processors, storages and query optimization.
• Wrote Oracle procedures for Data transform and cleansing.
• Created Complex SQL script, Dynamic SQL, Analytical function, Bulk Collect.
• Done Heavy SQL tuning for performance improvement.
• Prepared/updated shell scripts for ETL to run in batch.
• Design Data Conversion/Interface with the use of SQL*Loader and convert data.
• Writing Unix Shell Scripts to load the data as per the Business functionalities.
• Support the implementation of the project and address any post implementation defects.

Environment: Oracle Database 10g R2, Erwin, Oracle 10g Application Server, TOAD, Oracle Reports, Sun Solaris/UNIX.

Confidential, Chicago, IL

Oracle PL/SQL Developer

Responsibilities:

• Analyzed the Business requirements of the project by studying the Business Requirement Specification document.
• Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
• Creation of database objects like Tables, Views, Materialized views, Procedures, Packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader
• Converting/Migrating data from Mainframe, XML and Flat files into Oracle database tables for Data warehousing and BI purpose.
• Create PL/SQL procedures to transfer data from legacy sources to staging area and from staging area to data warehouse.
• Create data warehouse objects - table partitions, sub-partitions, normal and bitmap indexes, summary tables, materialized views, stored packages, functions and procedures with parallel queries, and rebuild indexes for partition exchange loading.
• Writing PL/SQL code for Oracle Job Scheduling and Maintain Batch jobs.
• Data Load from Various sources like Flat File, Excel file using SQL*LOADER and External Table.
• Writing Complex SQL script, Analytical Function.
• Improved query performance by query optimization - tracing the query execution plan (explain plan).
• Used Collections, Bulk Binds to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
• Writing Unix Shell Scripts to automate data loading and other activities as per the Business functionalities.

Environment: Oracle Database 11g, 10g R2, SQL, PL/SQL, TOAD, Oracle Reports, Sun Solaris/UNIX.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Deployed business rules into PL/SQL code for data analyzing, transforming and cleansing.
• Created database objects and developed and modified PL/SQL packages, functions,procedures, triggers using index, hints, global temporary table, Cursors, Ref-cursors etc.· Created PL/SQL & SQL scripts for the ETL Converting/Migrating data from Mainframe, Oracle XML, Flat files into Oracle database tables for Data warehousing and BI purpose.· Used EXTERNAL Tables, Utl file and SQL LOADER for the purpose of loading flat file And XML data.
• · Implemented Join conditions, group by functions, correlated sub queries, nested queries.
• Used aggregate routines for views, summary tables, materialized views, reports etc.
• Created partitioned tables, partitioned indexes for manageability and scalability ofapplication.
• Used Collections, Bulk Binds to improve performance by minimizing the number of contextswitches between the PL/SQL and SQL engines.
• Monitoring and optimizing the Database Performances through Database Tuning and
• Application tuning using DBMS STATS, Explain Plan, SQL*Trace, TKPROF.
• Improved query performance by query optimization - tracing the query execution plan.
• Created composite SQL script using Dynamic SQL, Analytical function.
• Wrote PL/SQL code for Oracle Job Scheduling and Maintain Batch jobs.
• Deployed, troubleshoot, supported database after implementation.
• · Created/modified logical and physical models using Erwin with normalization of relations.
• Prepared/updated shell scripts for ETL to run in batch.
• Writing Unix Shell Scripts to load the data as per the Business functionalities.

Environment: Oracle Database 11g, 10g R2, SQL, PL/SQL, Oracle Application Server 10gOracle 10g Developer Suite, TOAD, ERWIN, Statistical Analytical Software, Mainframe, Windows XP Professional clients, UNIX.

Confidential, FL

Oracle Developer

Responsibilities:

• Involved in Creation of tables, Join conditions, correlated sub queries, and nested queries, views, sequences, synonyms for the business application development.
• Writing new PL/SQL packages, modified existing code perform Certain Specialized functions / enhancement on oracle Application.
• Create Complex SQL script, Dynamic SQL, Analytical function, Bulk Collect.
• Created Packages, Stored Procedures, Function and SQL Scripts to load data into warehouse from different sources.
• Developed store procedures to return ref cursors, PL/SQL Table/Record for Application.
• Created partitioned tables, partitioned indexes for manageability and scalability of theapplication.
• Used Collections, Bulk Binds to improve performance by minimizing the number of contextswitches between the PL/SQL and SQL engines.
• Expertise in tuning SQL queries on large partition databases for optimal performance.
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
• Created PL/SQL packages, stored procedures and functions that extensively used PL/SQL cursors, user defined object types, exception handling to implement automation process.
• Involved in Performance tuning which included creating indexes and modifying tables using explain plan utility.

Environment: Oracle Database 10g, SQL, PL/SQL, UNIX, Windows XP Professional clients, Toad, SQL, PL/SQL Developer, SQL*Plus