Summary:

• More than 7 year's 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 year's 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 7 year's 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.
• Developed different Business Intelligence OLAP report using OBIEE.
• 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:

• Worked with Help Desk people to solve problem and create batch job.
• Created monthly campaign manifesto work for business improvement.
• Worked with Middle Tire and Guie for Design and Development for project.
• Wrote complex PL/SQL package, functions, procedures, batch processes using bulk processing, ref cursors and Pl/Sql Tables.
• Did Design Document and create ER Diagram for project development.
• Designed Data Flow, Entity Relation and others Diagrams with Erwin,
• Visio, SDPRO, Oracle Data Modeler tools.
• Coordinated with DBA in creating and managing Indexes, Db Links and Privileges.
• Exclusively followed all phases of System Development Life Cycle SDLC
• Created complex program unit using PL/SQL Records, Collection types
• Nested Tables and Varrays in complex backend packages.

Environment: Oracle 11g, 10g, PL/SQL, SQL Plus, Toad, SQL Loader, SQL Developer, Shell Scripting, AIX, Erwin, Windows XP Professional clients.PL/SQL

Developer.

Responsibilities:

• Did Extracting data from Teradata.
• Handled complex Exceptions.
• Packages using Oracle utilities like PL/SQL, SQL Plus, SQL Loader and
• Created database objects like Tables, Views, Materialized views, Procedures
• Designed the process flows to record the dependencies between the mapping runs.
• Did technical design document for future development process.
• Nested Tables and Varrays in complex backend packages.
• Created complex program unit using PL/SQL Records, Collection types
• Designed Data Flow, Entity Relation and others Diagrams with Erwin, Visio and SDPRO.
• Worked on production support team for EOM process issue.
• Coordinated with DBA in creating and managing Tables, Indexes, db links and Privileges.
• Testing and taking measures for maximum performance utilizing optimization hints,
• Indexes, partitions, parallelism, storages and query optimization.
• Experience in Advance Queue.
• Worked on performance tuning of SQL, PL/SQL and analyzed Tables.
• Detailed user requirement Analysis and Design of systems.
• Created UNIX Shell Scripts for automated execution of batch process.
• Developed Application Interfaces using PL/SQL stored Packages,

Procedures, Functions, Collections, Object types and Triggers.

Environment: Oracle 11g, 10g, PL/SQL, SQL Plus, Toad, SQL Loader, SQL Developer, Shell Scripting, AIX, Erwin, Windows XP Professional clients.

Responsibilities:

• Identified resources for information and source systems data flows.
• Did basic script using PERL.
• Created and optimized source-to-target mappings by using aggregator, filter, joiner, expression, lookups.
• Designed the process flows to record the dependencies between the mapping runs.
• Code for Fact and Dimension table population using SQL, PL/SQL.
• Worked as a Data Warehouse Developer using OWB.
• Created metadata, ETL mappings using Oracle DB 9i later started building enterprise Data Warehouse using Oracle DB 10g and upgrading from 9i to 10g.
• Developed packages, procedures, functions and database triggers using SQL and PL/SQL.
• Use SQL Loader and External Table for data Load.
• Testing and taking measures for maximum performance utilizing optimization hints, indexes, partitions, parallelism, storages and query optimization.
• Used UNIX shell scripts to clean and re-organize tables from time to time.
• Data modeling using ERWIN tools.
• Created OLAP reports using Oracle Discoverer/OBIEE.
• Customizing Reports in Oracle Report Developer 6i.

Environment: Oracle Application 11.5.10 GL, AR, AP, PA, OM , Oracle Workflow,

Oracle Database 9i/10g R2, SQL, PL/SQL, Discoverer 10g and Developer Forms Reports 6i, SQL Loader Oracle Application Server 10g, UNIX, Red Hat Linux, Windows XP Professional clients, Toad.

Responsibilities:

• Wrote Stored Procedures for effective insertion and updating of the data in to the tables.
• Complex Sub-queries and joins were extensively used in select statements
• Involved in extensive coding in Oracle forms/reports using PL/SQL.
• Used SQL Loader to automate the load of data from Text files to Oracle Tables.
• SQL Loader was used to load the data from the file in CSV format to oracle tables.
• Worked on Oracle Forms and Reports 6i.
• Created matrix reports using Oracle Reports 6i.
• Used Collections like variable arrays, nested tables extensively.
• PL/SQL was extensively utilized for coding and writing complex stored procedures and packages.
• worked on performance tuning of SQL, PL/SQL and analyzed Tables.
• Database Objects Recreation on Development after Refresh from Production
• Worked on Table partition.
• Worked as a Data Warehouse Developer using OWB.

Environment: Oracle 9i/10g R2,Oracle Developer 6i, SQL, PL/SQL,UNIX, Windows 2000/XP, TOAD, Toad, SQL Developer, SQL Loader, Erwin.

Responsibilities:

• Created Dimensions, measures and hierarchies for providing drill down options in the reporting environment.
• Extracted data from Oracle database 9i and flat file, perform mappings and load it into target Oracle tables using PL/SQL.
• Designed and developed data cleansing, data validation, load processes ETL using Oracle SQL and PL/SQL and UNIX.
• Created report using Oracle Discoverer, Any report can further pivot, sort, stoplight, graph the data presented.
• Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.
• Modified Korn shell scripts as per technical specifications in HP-UX/SUN OS environment.
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
• Involved in Performance tuning which included creating indexes and modifying tables using explain plan utility.
• Developed forms and reports using Oracle Forms 6i and Reports 6i for Financial System.

Environment: Oracle Warehouse Builder 9i, Oracle Database 9i, Discoverer 9i, Oracle Developer6i, HP-UX, SUN OS, Windows 2000/XP, TOAD, Toad , SQL ,PL/SQL Developer, SQL Loader, Erwin.

Responsibilities:

• Integrated software system for Apparel Manufacturer.
• Maintained liaison with the client executives and technical teams.
• Functional requirements gathering, high-level and detail design.
• Designed Data Flow, Entity Relation and others Diagrams with Erwin, Visio and SDPRO.
• Designed and Created forms and reports with Oracle Developer6/6i/ Crystal Report, PL/SQL, Procedures, Functions, Triggers.
• User Interface elements and reports design.
• Coding, unit, integration and load test.
• Commissioning and system support.
• Installed and configured oracle 9i.
• Created instances, schemas, users, profiles and roles.

Environment: SQL, PL/SQL of Oracle 8i/9i and UNIX Shell scripting, Visio, Erwin and SDPRO.

Developer 6 forms Report and Discoverer EUL.UNIX, Windows 2000/NT Environment, Toad, SQL Loader.