Summary:

• More than 7 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 7 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 the 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:

Professional Experience:

Confidential

Role: Oracle Developer

• Involved in Requirement Analysis and Client Interaction. This involves analyzing MD50 Functional Spec and then writing MD70 Technical Spec
• Working on STAT tool for Change management process.
• Involved in fixed assets interface creation from JDE system to oracle e business suites. Fixing the interface issues.
• Writing Unix Shell l Scripts to load the data as per the Business functionalities.
• Experience in Data modeling and Dynamic SQL.
• Experience in Table partition exchange loading PEL .
• Expertise in full suite of Oracle Tools including SQL Loader, TOAD, SQL Plus, SQL Developer Oracle 10g database.
• Experience in performance tuning using hints , Query optimization and troubleshooting and problem resolution Complex environment.
• Experience in Oracle Database, Developing Packages, Procedures, Functions, Packages Database Triggers by using PL/ SQL.
• Working on order Management conversions.
• Interacted with the 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, Win SCP, Putty, UNIX, TOAD, Windows XP, Oracle alerts, AIM methodology..

Confidential

Role: Oracle PL/SQL Developer

• Used Normalization and De normalization in Database.
• Works with performance tuning issues for multi terabyte Database.
• Created Complex SQL script, Dynamic SQL, Analytical function.
• Prepare Proper Documentation and Decode Mapping for further upgrade of code.
• Extract data into Oracle table using SQL LOADER and EXTERNAL Table.
• Oracle Job Scheduling and Advanced Queuing by Scheduled and Maintain Batch jobs.
• Creating database objects And Developing and modifying PL/SQL packages, functions, procedures, triggers.
• Extensively Works with merging three large Data integration and Business Intelligence Project for Home Finance.
• Utilized business rules for data profiling, data analyzing and cleansing.
• Experience in performance tuning , Query optimization and troubleshooting and problem resolution Complex environment.
• 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.
• Used Collections, Bulk Binds to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.

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

Confidential

Role: Oracle PL/SQL Developer

• 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 , Cobol ,Oracle Discoverer 10g, Oracle Reports, HP-UX.

Confidential

Role: Oracle PL/SQL Developer

• 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, COBOL TOAD, Oracle Reports, Sun Solaris/UNIX.

Confidential

Role: Oracle PL/SQL Developer

• Created staging area for accumulating periodical data from various data sources include Data mart creation, Extracting data from different source, Transformation data in the Staging area and load data into the Fact table.
• Actively participated in the team for the 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 the 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 , COBOL Visio, TOAD, Business Intelligence BI , Linux.

Confidential

Role: Oracle PL/SQL Developer

• Designing and modifying of Database tables, keys, indexes, grants, triggers, packages, functions and procedures etc.
• Used Collections, Bulk Binds to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
• Created partitioned tables, partitioned indexes for manageability and scalability of the 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 the integrity and security purpose.
• Oracle Job Scheduling and Advanced Queuing by Scheduled and Maintain Batch jobs.
• Improved query performance by query optimization - tracing the query execution plan explain plan and Used TKPROF SQL scripts to monitor the performance.
• Involved in handling Database Security Related issues as suggested by the guidelines set by the company.

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