SUMMARY

• More TEMPthan 6 years experience with 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 TEMPthan 6 years proven experience in PL/SQL that 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.
• 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 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 with people at all levels. Good communication and presentation skills.

TECHNICAL PROFICIENCY:

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, Kansas City, KS

Oracle PL/SQL Developer

Responsibilities:

• Experience in Data modeling and Dynamic SQL.
• Writing Unix Shell l Scripts to load teh data as per teh Business functionalities.
• Involved in fixed assets interface creation from JDE system to oracle e business suites. Fixing teh interface issues.
• Applied Query Optimization, Debugging and Tuning for improving performance of teh applications using Explain Plan, SQL Trace and TKprof.
• Working on order Management conversions.
• Interacted with teh 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, Plano, TX

Oracle 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 with 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 with 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.
• Experience in Oracle Report.

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

Confidential, NJ

Oracle 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 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.

NRECA, 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 teh pharmacy data warehouse scheduled jobs and support.
• Design Data Conversion/Interface with 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 Data Modeler

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 with Business Object Developer.

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