Professional Summary:

• Over 7 years of experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling Logical and Physical , and Implementation of Business Applications using the Oracle Relational Database Management System RDBMS .
• Strong experience in analysis, design, development, testing, implementation of database application in Client/ Server application using Oracle 11g/10g/9i/8i,SQL, SQL Loader and open Interface.
• Extensive experience in application data modeling and building data warehouse architecture Star Snowflake schemas and ER Diagrams using Microsoft Visio, Erwin and IBM Rational Rose data modeler tool.
• Extensive knowledge in Client/Server Technology, GUI Design, Relational Database Management Systems RDBMS , and Rapid Application Development Methodology.
• Extensively worked in PL/SQL for creating stored procedures, clusters, packages, database triggers, exception handlers, cursors, cursor variables.
• Extensively Worked on Oracle Database creation, Tablespace management, Export Import Backup, Performance tuning, Tuning Init.ora file.
• Working knowledge of SQL Trace, TK-Prof, Explain Plan, SQL Loader for performance tuning and database optimization.
• 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.
• Understanding of the functionality and data model of Oracle PO, AP, AR, FV and GL modules
• Extensively worked in writing PL/SQL stored procedures, database triggers, exception handlers and cursors and ref-cursors and utPL/SQL test cases.
• Good experience working on Data Extraction, Data Transformations, Data Loading, Data Conversions and Data Analysis.
• Good knowledge of Data warehousing and ETL Process for Extraction, Transformation and Loading of data from multiple source Database Systems to Data Warehouses using Oracle Warehouse Builder OWB and Informatica.
• Strong knowledge of Extraction Transformation and Loading ETL processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Experienced in working with many complex SQL queries with joins, date functions, inline functions, cursors, ref cursors, collections, partition tables, external tables, materialized views, sub-queries and analytical queries to generate reports.Expert in maintaining data integrity using various constraints and database triggers.
• Expertise in data migration with both target source same database as well as with heterogeneous databases.
• Strong analytical skills coupled with technical skills. Strives hard, drives the work and handles the team to completion such that deadlines are met.
• Proficient in interpersonal relations, team lead skills, project management, communication, outsourcing partner teamwork and organization with excellent communication and presentation skills.

Technical Skills:

Professional Experience:

Confidential

Role: Oracle Pl/SQL developer

Responsibilities:

• Worked on data export and import wizard to transfer data between different schemas in oracle using TOAD.
• Worked with various complex queries, sub queries and joins to check the validity of loaded and imported data.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Normalized and De-normalized entities for the Data Warehouse.
• Worked on data transformation and retrieval from mainframes to oracle, using SQL loader and control files.
• Worked and developed many procedures and functions according the requirement, and developed brand new packages with cursors.
• Sound Knowledge in understanding already existed packages, and worked with them to create updated versions to solve the issues.
• Involved in creating stored procedures, functions, triggers and developed monthly and weekly reports.
• Good knowledge in database links, Worked on tables, various types of views like inline and materialized views in different databases by linking the databases.
• Worked with advanced PL/SQL concepts like collections, PL/SQL objects and records used them in building procedures and functions.
• Developed, enhanced, maintained and supported the Web for Student, the Web for Faculty and Internet Native Banner Forms using Oracle, PL/SQL Web Toolkit, SQL, PL/SQL, Oracle Forms and a third party product called SunGard SCT Banner.
• Extensive knowledge in performance tuning the queries and development, built indexes as part of tuning and optimization.

Environment: Oracle Database 11g, Oracle Http Server 11g, Windows 2007 Enterprise, TOAD, HTML, XML, JAVASCRIPT, CSS, , ETL, SDLC, Waterfall, Agile methodologies, SOX Compliance.

Confidential

Role: Oracle Pl/SQL developer

Responsibilities:

• Involved in Identifying requirements and developing models according to the customer's specifications and drafting detailed documentation.
• Worked extensively in PL/SQL to develop packages, stored procedures, functions and database triggers.
• Involved in Tuning SQL queries using Explain Plan and Tkprof utility to improve performance of the queries.
• Involved in designing Technical specification document, identified various data mappings and the design of Data warehouse.
• Loaded data using ETL tools like SQL loader and external tables to load data from data warehouse and various other database like SQL Server and DB2.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc in different schema.
• Created scripts to load the data into staging tables from other database using DBlinks.
• Worked with various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Worked with UNIX shell scripts to load different optimize instruments data in to analysis tables.
• Worked with SQL loader and control files to load the data in different schema tables.
• Involved in the database administration and creating objects such as database, users, and schema and table spaces.
• Researched and updated problem data and code to resolve hundreds of help desk tickets Experienced in Agile Methodology of Project Management.
• Involved in production support by efficiently debugging the production issues.

Environment: Oracle Database 11g, Oracle Http Server 11g, Windows 2007 Enterprise, TOAD, HTML, XML, JAVASCRIPT, CSS, , ETL, SDLC, Waterfall, Agile methodologies, SOX Compliance.

Confidential

Role: Oracle Pl/SQL developer

Responsibilities:

• Worked on data export and import wizard to transfer data between different schemas in oracle using TOAD.
• Worked with various complex queries, sub queries and joins to check the validity of loaded and imported data.
• Worked on data transformation and retrieval from mainframes to oracle, using SQL loader and control files.
• Worked and developed many procedures and functions according the requirement, and developed brand new packages with cursors.
• Sound Knowledge in understanding already existed packages, and worked with them to create updated versions to solve the issues.
• Involved in creating stored procedures, functions, triggers and developed monthly and weekly reports.
• Good knowledge in database links, Worked on tables, various types of views like inline and materialized views in different databases by linking the databases.
• Worked with advanced PL/SQL concepts like collections, PL/SQL objects and records used them in building procedures and functions.
• Developed, enhanced, maintained and supported the Web for Student, the Web for Faculty and Internet Native Banner Forms using Oracle, PL/SQL Web Toolkit, SQL, PL/SQL, Oracle Forms and a third party product called Sungard SCT Banner.
• Extensive knowledge in performance tuning the queries and development, built indexes as part of tuning and optimization.
• Worked with Export and Text IO packages and wrote many Stored Procedures in many Forms and Reports. Worked with UNIX shell scripts and PERL scripts to generate daily reports.
• Worked with dynamic SQL, developed many procedures and function with dynamic SQL.
• Worked in resolving the production issues. Developed lot of new scripts and changed few existing scripts to solve the issues.

Environment: SQL Server, J2EE, UNIX, MS Project, Oracle, Web Logic, SOX Compliance, JavaScript, HTML, Microsoft Office Suite 2010, Excel, Oracle Database 11g, Windows 2007 Enterprise, TOAD, HTML, XML, JAVASCRIPT, CSS, , ETL, SDLC, Waterfall, Agile methodologies.

Confidential

Role: Database Analyst

Responsibilities:

• Build the new universes in Business Objects as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Used Business Objects to create reports based on SQL-queries. Generated executive dashboard reports with latest company financial data by business unit and by product.
• Performed the data analysis and mapping database normalization, performance tuning, query optimization data extraction, transfer, and loading ETL and clean up.
• Implemented Teradata RDBMS analysis with Business Objects to develop reports, interactive drill charts, balanced scorecards and dynamic Dashboards.
• Responsible for requirements gathering, status reporting, creating various metrics, projects deliverables.
• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
• Involved in analyzing and adding new features of Oracle 10g like DBMS SHEDULER create directory, data pump, CONNECT BY ROOT in existing Oracle 9i application.
• Tuned Report performance by exploiting the Oracle's new built-in functions and rewriting SQL statements.
• Extensively used Erwin for data modeling and Dimensional Data Modeling by ERWIN.
• Used EXPLAIN PLAN, TKPROF to tune SQL queries.
• Developed BO full client Reports, Web intelligence report in 6.5 and XI R2 and universes with context and loops.
• Migrated Reports from 6.5 thick clients desktop Intelligence report to XI r2 Thin Client Web Intelligence Report through Report Conversion Tool RPT and Import wizard.

Environment: SQL Server, J2EE, UNIX, MS Project, Oracle, Web Logic, JavaScript, HTML, Microsoft Office Suite 2010, Excel, Oracle Database 11g, Windows 2007 Enterprise, TOAD, HTML, XML, JAVASCRIPT, CSS, , ETL, SDLC, Waterfall, Agile methodologies, SOX Compliance.

Confidential

Role: Database Developer/Tester

Responsibilities:

• Build the new universes in Business Objects as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Used Business Objects to create reports based on SQL-queries. Generated executive dashboard reports with latest company financial data by business unit and by product.
• Performed the data analysis and mapping database normalization, performance tuning, query optimization data extraction, transfer, and loading ETL and clean up.
• Implemented Teradata RDBMS analysis with Business Objects to develop reports, interactive drill charts, balanced scorecards and dynamic Dashboards.
• Responsible for requirements gathering, status reporting, creating various metrics, projects deliverables.
• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
• Designed and developed Informatics Mappings to load data from Source systems. Worked on Informatics Power Center tool - Source Analyzer, Data warehousing designer, Mapping Mapplet Designer and Transformation Designer.
• Involved in migrating warehouse database from Oracle 9i to 10g database.
• Involved in analyzing and adding new features of Oracle 10g like DBMS SHEDULER create directory, data pump, CONNECT BY ROOT in existing Oracle 9i application.
• Tuned Report performance by exploiting the Oracle's new built-in functions and rewriting SQL statements.
• Extensively used Erwin for data modeling and Dimensional Data Modeling by ERWIN.
• Used EXPLAIN PLAN, TKPROF to tune SQL queries.
• Developed BO full client Reports, Web intelligence report in 6.5 and XI R2 and universes with context and loops.
• Migrated Reports from 6.5 thick clients desktop Intelligence report to XI r2 Thin Client Web Intelligence Report through Report Conversion Tool RPT and Import wizard.

Environment: Quality center, Quick Test Professional 8.2, SQL Server, J2EE, UNIX, .Net, MS Project, Oracle, Web Logic, Shell script, JavaScript, HTML, Microsoft Office Suite 2010, Excel