SUMMARY

• More than 5 years experience with proven ability in the 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 4 years proven experience in PL/SQL that includes Cursors, Ref-cursors, Bulking techniques, Procedures, Functionsand Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Materialized Views, Table Indexing, Index Organized Tables (IOT), SQL*Loader, ETL Tools etc.
• Over 5 years experience in Oracle data warehousing and Business Intelligence: 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 the applications using Explain Plan, SQL Trace and TKprof.
• 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 with people at all levels. Good communication and presentation skills.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, SQLPLUSRDBMS 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, iSQLPVCS, FTP

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

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Data PL/SQL Developer

Responsibilities:

• Expertise in full suite of Oracle Tools including SQL*Loader, TOAD, SQL*Plus, SQL Developer Oracle 10g database.
• Extract data into Oracle table using SQL*LOADER and EXTERNAL Table.
• Experience in Data modeling and Dynamic SQL.
• 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 with 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.
• Applied Query Optimization, Debugging and Tuning for improving performance of the applications using Explain Plan, SQL Trace and TKprof.
• Experience in Oracle Database, Developing Packages, Procedures, Functions, Packages Database Triggers by using PL/ SQL.
• Experience in performance tuning using hints, troubleshooting and problem resolution Complex environment.
• Used Toad to import and export.
• Working on order Management conversions.
• Writing Unix Shell Scripts to load the data as per the Business functionalities.
• Experience inKorn Shell, BashShell and Shell Scripting.
• Interacted with the user group on a regular basis to discuss requirements and updates.

Environment: Oracle Applications SQL, PL/SQL, SQL*Loader, Oracle, Win SCP, Putty, UNIX, TOAD, Windows XP, Oracle alerts, AIM methodology.

Confidential, Overland park, KS

Data PL/SQL Developer

Responsibilities:

• Designed and created complex PL/SQL code for the 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.
• Experience in financial domain.
• Extensively Works with merging three large Data integration and Business Intelligence Project for Home Finance.
• Working on Oracle Database Integration
• 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 with performance tuning issues for multi terabyte Database.
• Used Normalization andDenormalization in Database.
• Used Collections, Bulk Binds to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
• Experience inKorn Shell, BashShell and Shell Scripting.

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

Confidential, Kansas City, KS

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 with 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 the 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 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.

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 with 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 the pharmacy data warehouse scheduled jobs and support.
• 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.
• Provide adequate documentation on unit testing.
• Support the implementation of the project and address any post implementation defects.

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