SUMMARY

• Around 8 years experience wif proven ability in teh area of Client/Server and Distributed Multi - tier Application Development, Data modeling, Database Design, Data processing, Data Warehouse and Support mainly using Oracle technology on different platforms.
• More than 8 years proven experience in PL/SQL dat includes Cursors, Ref-cursors, Bulking techniques, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Materialized Views, Table Indexing, Index Organized Tables (IOT), SQL*Loader, ETL Tools etc.
• Data modeling in dimensional structures - Star/Snowflake schema, ETL, OLAP, OLTP, VLDB (very large application).
• Expertise in Data Conversions/Migration from Legacy System of various sources (flat files, Oracle, Non Oracle Database) to Oracle system Using SQL LOADER, External table and Calling Appropriate Interface tables and API’s.
• Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, Oracle Object etc.
• Expert in Query Optimization, Debugging and Tuning for improving performance of teh applications using Explain Plan, SQL Trace and TKprof.
• Use Obiee for different Business Intelligence OLAP report purpose.
• Proficient in using UNIX and Shell Scripting.
• Experience in Advance Queue
• Experience in Data flow Diagram, ER Diagrams using Oracle designer.
• Exclusively followed all phases of System Development Life Cycle (SDLC) and Best Practices.
• Strong interpersonal skills, ability to interact wif people at all levels. Good communication and presentation skills.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, SQLPLUS

RDBMS: Oracle 11g/10g/9i/ 8i, MS SQL Server, Ms-Access

Business Intelligence Tool: OBIEE 10.1.3.4.1

Modeling: Visio, Oracle designer

ETL: SQL, PL/SQL

Other Tools: TOAD 8.0/8.5/9.0, SQL Developer, SQL Navigator, XML, iSQL PVCS, FTP

Operating Systems: Sun Solaris, HP-UX, AIX, Unix, Linux, Windows

PROFESSIONAL EXPERIENCE

Confidential, KS

Data PL/SQL Developer

Responsibilities:

• Experience in Oracle Database, Developing Packages, Procedures, Functions, Packages Database Triggers by using PL/ SQL.
• Experience in Development and customization of Oracle Reports (10g/9i/6i) and Oracle Forms (10g/9i/6i)
• Expertise in full suite of Oracle Tools including SQL*Loader, TOAD, SQL*Plus, SQL Developer and Developer 2000/6i/9i/10g and experience wif Oracle 10g database
• Experience in Sys Admin and Application Object Library (AOL) for registration of Forms, Reports, Concurrent Programs and Menus
• Involved in fixed assets interface creation from JDE system to oracle e business suites. Fixing teh interface issues.
• Working on STAT tool for Change management process.
• Involved in Requirement Analysis and Client Interaction. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec)
• Working on order Management conversions.
• Interacted wif teh user group on a regular basis to discuss requirements and updates.
• Involved in Account Payable interface for integration of JDE systems.

Environment: Oracle Applications 11i, FA, AP, GL, AR, SQL, PL/SQL, SQL*Loader, Oracle, Reports, Win SCP, Putty, UNIX, TOAD, Windows XP, Oracle alerts, AIM methodology..

Confidential, Plano, TX

Data PL/SQL Developer

Responsibilities:

• Designed and created complex PL/SQL code for teh ETL Converting/Migrating data from Mainframe, DB2 and Flat files into Oracle database tables for Data warehousing and BI purpose.
• Utilized business rules for data profiling, data analyzing and cleansing.
• Extensively Works wif merging three large Data integration and Business Intelligence Project for Home Finance.
• Creating database objects And Developing and modifying PL/SQL packages, functions, procedures, triggers.
• Oracle Job Scheduling and Advanced Queuing by Scheduled and Maintain Batch jobs.
• Extract data into Oracle table using SQL*LOADER and EXTERNAL Table.
• Prepare Proper Documentation and Decode Mapping for further upgrade of code.
• Created Complex SQL script, Dynamic SQL, Analytical function.
• Works wif performance tuning issues for multi terabyte Database.
• Used Normalization and Denormalization in Database.
• Used Collections, Bulk Binds to improve performance by minimizing teh number of context switches between teh PL/SQL and SQL engines.

Environment: Oracle Database 11g, 10g, DB2, VISIO, TOAD 9.7, Business Intelligence (BI), Mainframe, UNIX, Oracle RAC, PVCS

Confidential, NJ

PL/SQL Developer

Responsibilities:

• Created data warehouse objects - Fact tables, dimension tables, table partitions, sub-partitions, normal and bitmap indexes, summary tables, materialized views, stored packages, functions and procedures wif parallel queries, making indexes unusable and rebuilding local indexes for partition exchange loading (PEL).
• Converting/Migrating data from SQL Server, XML and Flat files into Oracle database tables for Data warehousing and BI purpose, designing and creating OWB mappings, process flows for teh ETL.
• Utilized business rules for data profiling, data analyzing and cleansing.
• Created PL/SQL procedures to transfer data from legacy sources to staging area and from staging area to data warehouse.
• Prepared shell scripts for ETL to run in batch.
• Creating database objects And Developing and modifying PL/SQL packages, functions, procedures, triggers.
• Oracle Job Scheduling and Advanced Queuing by Scheduled and Maintain Batch jobs.
• Extract data into Oracle table using SQL*LOADER and EXTERNAL Table.
• Writing Complex SQL script, Analytical Function.
• Improved query performance by query optimization - tracing teh query execution plan (explain plan).
• Used Collections, Bulk Binds to improve performance by minimizing teh number of context switches between teh PL/SQL and SQL engines.

Environment: Oracle Database 10g, Oracle Warehouse Builder 10g R2 OWB),Erwin, Oracle 10g Developer Suite, Oracle Application Server 10g, TOAD, Business Intelligence (BI), Oracle Discoverer 10g, Oracle Reports, HP-UX.

Confidential, Arlington, VA

Oracle PL/SQL Developer

Responsibilities:

• 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 corporate metadata.
• Created/updated ETL procedures to transfer data from legacy source to staging area and from staging area to data warehouse and to data marts wif Business Intelligence reporting layers using Oracle Warehouse Builder.
• 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.
• Utilized business rules for data profiling, data analyzing and cleansing.
• Created Complex SQL script, Dynamic SQL, Analytical function, Bulk Collect.
• Heavy SQL tuning for performance improvement.
• Load Data monitoring of teh pharmacy data warehouse scheduled jobs and support.
• Design Data Conversion/Interface wif teh use of SQL*Loader and convert data.
• Writing Unix Shell Scripts to load teh data as per teh Business functionalities.
• Provide adequate documentation on unit testing.
• Support teh implementation of teh project and address any post implementation defects.

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

Confidential, Dearborn, MI

Oracle PL/SQL Developer

Responsibilities:

• Created staging area for accumulating periodical data from various data sources include Data mart creation, Extracting data from different source, Transformation data in teh Staging area and load data into teh Fact table.
• Actively participated in teh team for teh purpose of defining project scope, sizing & technical design to establish technical direction regarding technology, platforms & development tools, development standard and guide lines.
• Writing Complex SQL script, Analytical Function using packages, procedures, functions and database triggers.
• Utilized business rules for data profiling, data analyzing and cleansing.
• Used aggregate routines for views, summary tables, materialized views, reports etc.
• Applied Query Optimization, Debugging and Tuning for improving performance of teh applications using Explain Plan, SQL Trace and TKprof.
• Code for Fact and Dimension table population using SQL, PL/SQL.
• Data Modeling using ERWIN.
• Use SQL Loader and External Table for data Load.
• Work wif Business Object Developer.

Environment: Oracle Database 10g, Oracle Warehouse Builder 10g (OWB), Visio, TOAD, Business Intelligence (BI), Linux.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Designing and modifying of Database tables, keys, indexes, grants, triggers, packages, functions and procedures etc.
• Used Collections, Bulk Binds to improve performance by minimizing teh number of context switches between teh PL/SQL and SQL engines.
• Created partitioned tables, partitioned indexes for manageability and scalability of teh application.
• Did data profiling, data cleansing
• Created Pl/SQL based ETL processes transfer data from legacy sources to staging area and from staging area to data warehouse.
• Support Data warehouse, ETL Process.
• Developed Database Triggers for teh integrity and security purpose.
• Oracle Job Scheduling and Advanced Queuing by Scheduled and Maintain Batch jobs.
• Improved query performance by query optimization - tracing teh query execution plan (explain plan) and Used TKPROF SQL scripts to monitor teh performance.
• Involved in handling Database Security Related issues as suggested by teh guidelines set by teh company.

Environment: Oracle Database 9i, Visio, TOAD, Solaris.