PROFESSIONAL SUMMARY:

• Oracle Developer with 7+ years of experience in various phases of Software Development Life Cycle involving Analysis, Design, Development and Maintenance of Business Applications using Oracle Relational Database Management System.
• Experience in Design and Implementation of PL/SQL Stored Procedures, Functions, Packages, and Database Triggers for Oracle Relational Databases.
• Proficient in the Data Manipulation using SQL for the retrieval of data from the Relational Database (inner joins, outer join, group by, order by, cursors etc).
• Proficient in Oracle Tools and Utilities such as SQL*Loader, TOAD, SQL Developer, and PL/SQL Developer
• Experience in Design and Implementation of PL/SQL Stored Procedures, Functions, Packages, Ref Cursors, Constraints, Database Links, UTL file and Triggers for Oracle Relational Databases.
• Strong experience in developing SQL/PLSQL Scripts/Programs for Data Analysis, Extraction, Transformation and Loading (ETL) mechanism
• Proficient in the Data Manipulation using SQL for the retrieval of data from the Relational Database (inner joins, outer join, group by, order by, cursors etc.).
• Extensive development experience in data designing, mapping, Loading data, Testing and Tuning databases.
• Hands on experience in working with advanced PL/SQL concepts such as Collections, Objects, records, Native dynamic SQL.
• Extensive experience in Performance Tuning of SQL queries & Views using Explain Plan.
• Extensive experience in working with standard Microsoft software applications like Word, Excel, Microsoft Project, PowerPoint and Visio.
• Good Knowledge in data extraction, transmission and loading.
• Strong analytical skills with ability to quickly understand clients’ business needs and identify available data sources and the relationships that exist within them.
• Experience in Production Support and the ability to provide time - bound and quality driven solutions have cultivated decision-making and analytical ability
• Ability to learn and adapt quickly in a dynamic environment and Ability to work on multiple projects against aggressive deadlines.
• Good Communication, Writing, Presentation, Workforce Management, Interpersonal and Analytical skills, along with the ability to work on multiple projects and prioritize workload
• Self-starter can work independently as well as a good team player.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i, SQL Server 2008

DB Utilities: SQL*Plus, SQL*Loader

Operating Systems: Windows7/Vista/XP/, UNIX (Sun Solaris, HP-UX)

Developer Tools: TOAD 10.6, 10.1, 9.6.1, 8.5, 8.1, Sql developer, Pl/Sql developer

Web Technologies:HTML, XML Publisher

PROFESSIONAL EXPERIENCE:

Confidential, MI

Oracle Developer

Responsibilities:

• Generated DDL scripts and Created and modified database objects such as tables, views, sequences, functions, synonyms, indexes, packages, stored procedures, Records and Collections using TOAD tool.
• Used Bulk Collect, PL/SQL tables, arrays and other collection for huge data manipulations and improve the performance of the system. Involved in the detailed data mapping from the source legacy systems (WWCOM, CSPORTAL) extract files to the Oracle Payables tables.
• Provide quality operations support for production environment. Worked with QA and provided support timely technical resolutions for defects.
• Gathered the business requirement from clients and translated the business details into technical requirements.
• Used Bind Variables while writing Dynamic SQL to improve performance.
• Created relevant staging tables to load data, identified the business validation rules.
• Build several Unix Shell scripts for PLSQL programs to schedule them on Control M.
• Involved in the LOGICAL & PHYSICAL MODELING of the CSPORTAL application.
• Involved in performance tuning using HINTS, EXPLAIN PLAN.
• Involved in writing complex SQL Queries to implement the business requirements.
• Used SQL* Loader and UTL FILE Packages for data conversions and interfaces.
• Expertise in handling System Analysis and Business Analysis related issues when the application is in earlier stages.
• Coordinated with the business analysts for requirements analysis.
• Used techniques like direct path load, external tables for loading the data faster.
• Developed technical design documents by reviewing functional requirement documents.
• Involved in preparing the test scenarios and performed unit tests on PL/SQL programs.
• Involved in creating various utility scripts to generate log files in UNIX using shell scripts.

Environment: Oracle 10g/11g, TOAD 10.6, SQL*Loader, Windows Server 2008/Windows 7, UNIX.

Confidential, MD

Oracle Developer

Responsibilities:

• Designed and developed several complex database procedures, packages. Extensively used features like Cursors, autonomous transactions, distributed transactions, exception handling, Dynamic, pl/sql tables, bulk load methods, optimizer Hints, Cursor variables and returning of multi record set from procedures and functions
• Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
• Used Bulk collect stored procedures to improve the performance and make the application to run faster.
• Wrote custom support modules for implementation using PL/SQL, Unix Shell Scripts
• Worked on logical and physical data modeling and created Materialized views.
• Implemented various UNIX scripts to generate the data in CSV and txt format.
• Develop SQL* Loader scripts for data extraction and transformation.
• Developed various Mappings to load data from various sources using different Transformations.
• Extracted data from different sources like Oracle, Flat files, External files and transformed the data based on Business requirements and loading into Oracle target database.
• Extensively involved in performance tuning using Explain Plan, DBMS PROFILER and Optimized SQL queries, created Materialized views for better performance
• Extensive use of Collections like Varray’s and nested tables.

Environment: Oracle 10g/11gTOAD 10.1, SQL*Loader, Windows Server 2008/Windows 7, HP-UX.

Confidential, PA

Oracle Developer

Responsibilities:

• Used PLSQL to Extract Transform and Load (ETL) the data into Data Warehouse and Developed PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Created and modified database objects such as Tables, Views, Materialized views, Indexes, Sequences and constraints, SQL queries.
• Created and used TablePartitions to further improve the performance while using tables containing large number of columns and rows.
• Extensive use of Oracle External Tableswhich is used to load the flat files into Oracle Database.
• Develop the codes in Pl/Sql packages, procedures, functions, Forms, Reports.
• Keeping flexibility in the code so that it can in corporate any change that the Business might ask for.
• Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, Stored Procedures/Functions/Packages.
• Involved in creating various utility scripts to generate log files in UNIX using shell scripts.
• Documented the PL/SQL packages, log files, locations and descriptions, log tables and possible error codes and message descriptions.
• Documenting the technical changes that would help any person in understanding the technical design end to end
• Detected and corrected bugs during system integration and user acceptance testing.

Environment: Oracle 9i/10g, SQL*Plus, TOAD 10.1, SQL*Loader, Windows Server 2003, HP-UX

Confidential

Oracle Developer

Responsibilities:

• Used SQL*Loader and PL/SQL programs to Convert data from many legacy systems to Oracle 10g and to store data in the Oracle database from different types of flat files.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Designed, developed and enhanced custom Oracle Reports 9i according to the functional specification.
• Wrote SQL, PLSQL, SQL*Plus programs required to retrieve data from the Data repository using cursors and exception handling.
• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, Records and Collections using TOAD tool.
• Extensive use of Collections like Varray’s, nested tables and Sub-queries and joins in stored procedures.
• Developed new reports as per Oracle Applications development standards and customized existing reports in the PO module according to the client’s requirements.
• Analysis, Development and documentation of Importing Vendor Information from external systems.
• Support and modify existing PL/SQL code (Flow Through’s) in various legacy systems.
• Performed SQL and PL/SQL tuning to improve the performance with the help of SQL Trace, Explain Plan, Tkprof, Indexing and Hints.
• Used Bulk Collect, PL/SQL tables, arrays and other collection to improve the performance of the system.

Environment: Oracle 9i, PL/SQL Developer, SQL*Plus, TOAD 9.6, SQL*Loader, Windows Server 2003, Sun Solaris, UNIX, Oracle Forms/Reports.

Confidential

Database Developer

Responsibilities:

• Used Oracle Developer to support JA Built complex queries using SQL and wrote stored procedures using PL/SQL in Various API’s like Java, .Net and Hierarchical databases like Oracle and Access.
• Developed and modified a number of Forms and for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
• Wrote Shell Scripts for Data loading and DDL Scripts.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Used Oracle Developer to support JAVA, JSP and HTML codes used in modules.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Strong analytical and problem solving skills.
• Creating database objects like tables, indexes, views, packages and procedures using PL/SQL Developer.
• Sequences packages and procedures.
• Involved in Logical & Physical Database Layout Design.
• Set-up and Design of Backup and Recovery Strategy for various databases.
• Worked on XML along with PL/SQL to modify/create interface between system Performed Database Administration of all database objects including tables, clusters, indexes, views, Performance tuning of Oracle Databases and User applications.
• Used SQL*Loader as an ETL tool to load data into the staging tables.
• Provided user and production support.
• Improved the performance of the application by rewriting the SQL queries.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
• Environment: Environment: ORACLE 7.x, Reports 6i, PL/SQL, SQL Loader And SQL.