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, Deployment and support with Oracle technology on different platforms.
• Expert working experience in Oracle PL/SQL Development using various Oracle key components such as Stored Procedures, Functions, Packages, DB Triggers, Views, Materialized Views, DBlinks, Exception handling, Oracle Supplied Packages, Collections, PL/SQL Types, External Tables, Merge Statements, Global Temporary Tables (GTT), Bulk Load, Cursor, Ref Cursors, Partitioned Tables, Dynamic SQL, SQL*Loader, Data Pump, Export/Import, UTL FILE.
• Expertise in Creating and Maintaining Database objects like Tables, Views, Indexes, Constraints, Materialized Views, Synonyms, and Sequences.
• Proficient in writing and tuning Complex SQL statements, complex joins co-related sub-queries and SQL statements with Analytical functions (Rank, Lead, Lag, Connect by level etc).
• Experience in writing dynamic SQL Statements using EXECUTE IMMEDIATE and DBMS SQL.
• 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.
• Working knowledge on using new partitioning techniques like Interval, reference and extended composite (List-List, List-Range) partitioning.
• Expertise in loading data from flat files to the Database Tables using SQL*LOADER and EXTERNAL TABLE etc.
• Expertise in Oracle datapump commands like IMPDP and EXPDP for data migration.
• Extensive experience in writing ANSI SQL functions, Stored Procedures within Composite Data type.
• Extensive experience in developing multi-threaded database processes using Oracle packages like DBMS SCHEDULER, DBMS STATS.
• Strong experience with Oracle Data Warehouse, ETL Process, Data analysis for ODS, online transactional processing (OLTP) and Data Warehouse logical/physical, relational and multi-dimensional modeling (Star Schema, Snowflake Schema), optimization, partitioning, archiving and capacity planning.
• Expertise in Software Development Life Cycle (SDLC).
• Good understanding of RDBMS, Oracle Database architecture, designs and having performed DBA duties, such as Table Partitioning, Import/Export and data pump.
• Experience in using Oracle concepts Like Table Partitioning, Optimizer hints and Materialized Views (Snapshots).
• Assisted DBA in performing various DDL (Create, Drop, Rename, and Alter) works like Creation of Schemas, tables, Indexes, Materialized Views, and Partitioning tables.
• Good understanding in the areas of Users, Roles, Privileges, Schema and Object management & Session monitoring.
• Expertise in Data Mapping, Transformation and Loading data in a complex and high-volume environment.
• Expertise in Transaction Management like Commit, Rollback in Oracle Database.
• Extensive Experience in using Oracle 11g/10g/9i/8i and tools like Toad, SQL *PLUS, Advanced SQL Optimizer.
• Expert working Knowledge of UNIX Shell Scripting and Scheduling Cron jobs and tools like WINSCP, PUTTY, FTP/SFTP and CONNECT DIRECT.
• Expert in Query Optimization, troubleshooting, debugging, problem solving and Tuning for improving performance of the applications.
• Have experience in Relational and Dimensional Data modeling, Normalization, Demoralization, Data Architecture, Planning, Testing, Data Migration and Data Conversion.
• Experienced in Database Administrative duties like Grants, Loads, and Backup/Recovery & Performance.
• Experience in supporting the production system and handling day-to-day issues.
• 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

Database Technology: Database 11g, 10g, 9i, MS SQL Server 2000/2005, Ms Access.

Database Management System: Database design, Development and maintenance.

Database Tools: Oracle Forms & Reports, Toad, SQL*Loader, PL/SQL Developer, Oracle SQL Developer, SQL *PLUS, VI Editor, Putty, ERWIN, Oracle 9i/10g/11g, FoxPro, Teradata SQL Assistant, TKPROF, EXPLAIN PLAN, Export, Import, Oracle Warehouse builder (OWB), Oracle Data Integrator (ODI), Oracle Enterprise Manager (OEM).

Modeling: ERwin4.1/3.5.2, ER/Studio, Dimensional Data Modeling, Star Schema Modeling, Snowflake modeling, Toad, Physical and logical data modeling.

Scripting: Shell (Bash Shell), HTML, XML, SQLOperating Systems LINUX (Red Hat Linux), UNIX, AIX, MS DOS and Windows 9x/NT/2000/2003/XP/VISTA.

PROFESSIONAL EXPERIENCE

Confidential, Wayne, NJ

Oracle Database Developer

Responsibilities:

• Gathered Business Requirements from the client and translated the business detail into technical design and specification.
• 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 Table, 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 ANSI SQL, PL/SQL procedures and functions while migrating 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.
• Responsible for troubleshooting, debugging, problem solving and tuning for improving performance of the backend application programs.
• Loaded the flat file data into database table by creating multiple SQL*Loader control scripts.
• Created and modified database objects like tables, views, Indexes, Synonyms, Sequences and Constraints.
• Implemented business logic using stored procedures to increase performance.
• Used Plan table, 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 many executable programs running on UNIX operating system and wrote Unix Shell Scripts for automating the process.
• Implemented business logic using ANSI SQL functions, stored procedures within Composite Data type.
• Used exception handling methods along with RAISE APPLICATION ERROR in order to associate our own created exception names.
• Enhanced the existing UNIX scripts to run batch processes, oracle background processes using JOBS & achieve better performance and through out put.
• Manage work sheets and workbooks. Using discover to complexity of underlying database structures like OLAP, cubes, tables, column, joins etc.
• Responsible for Data Migration using Oracle tools Expdp, Impdp and RMAN.
• Involved in creating target database users and modules using Oracle Warehouse Builder (OWB)
• 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 9i/10g/11g, PL/SQL, SQL*Plus, SQL developer, SQL*Loader, TOAD, OWB, HTML, ANSI SQL, XML, Windows 2000/2003/XP, FTP, Developer 2000, Export, Import, ETL, Erwin, RMAN, 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.
• Written Bash Shell scripts that were used for staging, transformation and loading of the data into base tables.
• Prepared/updated shell scripts for ETL to run in batch.
• Wrote Oracle procedures for Data transform and cleansing.
• Worked in creating target database users and modules using Oracle Warehouse Builder (OWB)
• Created Complex SQL script, Dynamic SQL, Analytical function, Forall, Bulk Collect.
• Developed ETL scripts using SQL Loader for transferring flat files into data base tables.
• Done Heavy SQL tuning, troubleshooting, debugging, for performance improvement.
• Load Data monitoring of the County data warehouse scheduled jobs and support.
• Was responsible for development and testing of conversion programs for importing data from text files into Oracle database utilizing SQL *Loader.
• Involved in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links.
• Wrote SQL*Loader scripts to migrate the data from the text files, CSV files etc. and populated the intermediate tables.
• Supplied packages were used to extend the functionality of PL/SQL programs such as DBMS JOB for scheduling, UTL FILE to read and write from database, DBMS SQL to write Dynamic SQL.
• Support the implementation of the project and address any post implementation defects.
• Writing Unix Shell Scripts to load the data as per the Business functionalities.

Environment: Oracle 9i/10g/11g, PL/SQL, SQL* Plus, TOAD, OWB, SQL Developer, ETL, Shell Scripting, SQL*Loader, SQL developer, DBMS JOB, UTL FILE, 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.
• Implemented business logic using ANSI SQL functions, stored procedures within Composite Data type.
• 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.
• Used Oracle Utility SQL*Loader and External Table Concept in order to facilitate the Bulk Upload Mechanism, which involved loads from Excel Sheets using GUI and Flat Files from Various source systems.
• 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.
• Using the Crontab in UNIX and scheduler in Windows for automatic Tasks (Analyzing tables, loading tables, Import/Export).
• Used parametric Cursors and Ref cursors for performing DML operations involving multiple records.
• Responsible for troubleshooting, debugging, problem solving and tuning for improving performance.
• Involved in the maintenance and support of existing applications with the users.

Environment: Oracle Database 11g, 10g R2, SQL, PL/SQL, TOAD, SQL Developer, SQL*Loader, HTML, ANSI SQL, XML, Sun Solaris/UNIX.

Confidential, Portland, ME

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, and 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.
• Responsible for Data Migration using Oracle Data Pump (Export & Import utilities).
• Used aggregate routines for views, summary tables, materialized views, reports etc.
• Created partitioned tables, partitioned indexes for manageability and scalability of application.
• Used Collections, Bulk Binds to improve performance by minimizing the number of context switches 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.
• Wrote complex SQL queries using Join Conditions, Group by functions, Sub queries, Correlated Sub queries, Nested queries and Inline Views to retrieve data from the database.
• Implemented various Error/Exception handling methods using system defined exceptions and user defined exceptions.
• Working with Oracle databases to manage data for development, training and production environments.
• Deployed, troubleshoot, debug 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.
• Worked on Data Backup and Data Recovery using RMAN.
• Writing Unix Shell Scripts to load the data as per the Business functionalities.

Environment: Oracle 9i, SQL, SQL*Plus, PL/SQL, Oracle Application Server 10g, Oracle 10g Developer Suite, TOAD, ERWIN, SFTP, Mainframe, XML, Expdp, Impdp, RMAN, MS Access, Windows XP Professional clients, SQL*Loader, UNIX.

Confidential

Oracle Developer

Responsibilities:

• Participated in analysis, design, development, and testing of the application.
• Involved in Creation of tables, Join conditions, correlated sub queries, nested queries, views, sequences, and synonyms for the business application development.
• Writing new PL/SQL Packages, modified existing code perform Certain Specialized functions for enhancement on oracle Application.
• Created 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.
• Worked extensively on tuning of mappings/sessions using session partitioning and lookup strategies to address bottlenecks.
• Developed stored procedures to return Ref cursors, PL/SQL Table/Record for Application.
• Created partitioned tables, partitioned indexes for manageability and scalability of the application.
• Used Collections, Bulk Binds to improve performance by minimizing the number of context switches 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 for various oracle-based application using various methods like SQL Trace, EXPLAIN PLAN, TKPROF etc.
• Experienced in using Oracle Utility programs like SQL*Loader, SQL Developer and External Tables.
• Strong knowledge in using views, Materialized views, Export and Import Utilities provided in Oracle TOAD.

Environment: Oracle 8i, 9i, SQL, PL/SQL, Reports, UNIX, MS Access, Windows XP Professional clients, Reports, Toad, SQL Developer, SQL*Plus, Statistical Package for the Social Sciences (SPSS).