SUMMARY:

• 8 years of experience in Database development using Oracle, Sql, Pl/Sql SQL*Loader, SQL*Plus, C, UNIX Shell Scripting.
• Extensively worked with database tools like Sql Developer, Toad & Pl/Sql Developer.
• Involved in Requirement Analysis, System Design, Preparing Technical design documents, Unit Testing and Implementation.
• Good experience in writing SQL Queries, Joins, Indexes, Sequences, Views, Materialized Views, PL/SQL Procedures, Functions, Packages, Triggers, Cursors, Collections, Ref Cursor, Cursor variables, Dynamic SQL.
• Experience in Designing and creating SSIS packages to ETL data from databases.
• Created Packages to automate transactions from the Oracle Forms.
• Strong knowledge of Data Extraction, Data Mapping, Data Conversion and Data Loading process using UNIX Shell scripting, SQL, PL/SQL and SQL Loader.
• Experience in preparing source to target mappings and design documents using Data Warehouse Dimensional modeling.
• Used Oracle JDeveloper to support JAVA,JSP and HTML codes used in module
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Experience in Oracle R12 Financials implementation
• Designed and Developed Type 2 Slowly Changing Dimension (SCD) model using star schemas.
• Good experience in developing ETL procedures and Data Conversion Scripts using Pre - Stage, Stage, Pre-Target and Target tables.
• Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Tkprof, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect and Creation of global temporary tables and table partitioning.
• Experience in writing Technical Design Documents and Developing Unit Test Documents.
• A Self-starter with a positive attitude, willingness to learn new concepts and accept challenges.
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i/8i, DB2, Sybase, MS Access 2000

Languages & Tools: SQL, PL/SQL, SQL*Loader, SQL*Plus, UNIX Shell Scripting, Perl

Operating Systems: UNIX, MS Windows XP/2003/2000/NT, MS DOS

UNIX Platforms: Sun Salaries 9, IBM AIX 4.3.3, HP-UX 11.22

Data Analysis Tools: TOAD, Pl/Sql Developer, Sql Developer

Data Modeling Tools: Power Designer, Erwin

Version Control Tools: MS Visual Source Safe, Rational Clear Case, Harvest

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Senior PL/SQL Developer

Responsibilities:

• Designed, Developed and Modified tables, views, materialized views, stored procedures, packages and functions.
• Loaded the data into database tables using SQL*loader from flat files.
• Worked in developing ETL procedures and Data Conversion Scripts using Pre-Stage, Stage, Pre-Target and Target tables.
• .Designing and creating SSIS packages to extract, transform and load data from mainframe files and ORACLE database.
• Used Oracle JDeveloper to support JAVA,JSP and HTML codes used in module
• Tuned and Optimized the SQL statements using Explain Plan and SQL trace utilities.
• Used bulk collections for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
• Designed and Developed Type 2 slowly changing dimension when loading data into Taret tables.
• Troubleshot production problems and worked effectively with other team members to identify and address problems.

Environment: Oracle 11g, TOAD, PL/SQL, HTML, UNIX, SQL Plus, SQL Loader.

Confidential, Belmar, New Jersey

Oracle PL/SQL Developer

Responsibilities:

• Involved in Requirement Analysis, System Design, And Preparing Technical design documents.
• Creates scripts for validating extracted data from Legacy systems before loading into target system.
• Developed database objects including Tables, Clusters, Indexes, Views, Sequences, Packages, Triggers and Procedures to troubleshoot any database problems.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Involved in uploading of the data from flat files into Databases and Validated the Data with PL/SQL procedures.
• Strong in Oracle R12 Financials implementation in the areas of GL, AP, AR, PO, OM, and FA with Full Life Cycle implementation experience.
• Designed and Developed Type 2 Slowly Changing Dimension (SCD) model using star schemas.
• Good experience in developing ETL procedures and Data Conversion Scripts using Pre-Stage, Stage, Pre-Target and Target tables.
• Designing and creating SSIS packages to ETL data from databases.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements.
• Develop the perl and shell scripts to automate the finance billing file.
• Developed perl and shell scripts for upload of data feed into data base.
• Developed report in perl for our end users.
• Developed various complex stored procedures, packages, interfaces and triggers in PL/SQL.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Worked on various Back End Procedures and Functions using PL/SQL.
• Wrote shell scripts for calling functions to automate the loading and extraction process from legacy system.
• Check the functionality of data in the front-end whether it is displaying properly or not.
• Managing Version Control Tool like MS Visual Source Safe.

Environment: Oracle 11g, PL/SQL, TOAD, Query Direct, Oracle Applications R12, SQL plus, UNIX Scripting

Confidential

PL/SQL Developer

Responsibilities:

• Worked with the Business analysts and the DBA for gathering, business analysis, testing, and implementation.
• Involved in logical modeling and physical modeling of database application and Developed Stored Procedures, Functions, Packages using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL*loader from flat files.
• Developed SQL scripts, cursors, tables, views, materialized viewsas per the business requirements.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Experienced with bulk collections and forall operations on tables to improve the performance of manipulation language statements.
• Coordinated with DBA in creating and managing tables, indexes, table spaces, auditing and data quality checks.
• Developed data conversion procedures in PL/SQL. Involved in maintaining batch processing PL/SQL procedures for data extraction for feed creation.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, Tkprof and Auto trace.
• Developed UNIX Shell scripts to automate table creation, execute procedures using dynamic sql statements.
• Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing and Load Testing.

Environment: Oracle 11g/10g, SQL*Plus, TOAD, SQL*Loader, UNIX.

Confidential, Pittsburgh, PA

PL/SQL Developer

Responsibilities:

• Interacting with Business users, gathering and analyzing requirements.
• Analyzed Financial Markets Data and mapped Source Systems Data to Finance Data warehouse.
• Created system design document with high-level design and requirement document. Conducted walk through for requirement and system design.
• Created and modified SQL, PLSQL and SQL*Loader scripts for data conversions to load data from flat files into oracle interface tables.
• Developed SQL Queries to fetch complex data from different tables from different databases using database links and inserted the results into the newly developed tables.
• Created views, materialized views and synonyms for developers to hide the complexity and secure the direct access of DB Tables.
• Developed various Oracle sub functions like Stored Procedures, Functions, and Packages using PL/SQL as per the Design Documents.
• Involved in uploading and downloading of the flat files from UNIX server using FTP.
• Undertook Code Optimization and Performance Tuning of the application using Explain Plan, Hints, Indexing and Partitioning of tables.
• Worked on Data Modeling tool which includes both Logical and Physical Models.
• Generated UNIX Shell scripts to automate Batch Jobs and Loading Process.

Environment: Oracle10g/9i, Sql, Pl/Sql, Toad, SQL*Loader, Win XP, UNIX.

Confidential, Pittsburgh, PA

PL/SQL Developer

Responsibilities:

• Developed PL/SQL stored procedures, packages, and triggers for data load and transformation, and data extraction.
• Extensively used sub queries and joins while writing stored procedures.
• Involved in extensive coding using Oracle PL/SQL.
• Used Oracle Forms 10g to design and develop the interface for the system.
• Created Packages to automate transactions from the Oracle Forms.
• Tuned and Optimized the SQL statements using Explain Plan and SQL trace utilities.
• Created Shell scripts to automate the loading of data from Text files to Oracle tables.
• Used bulk collections for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
• SQL*Loader was used to load the data from the flat files to database tables.
• Developed batch jobs, shell scripts to automate file transfers, data cleansing, loading and final data processing.
• Scheduled batch jobs, shell scripts in AutoSys to run at a specified times as per the requirements for each application.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Used UTL File Packages to Load data from Excel Sheet to Oracle tables.
• Created matrix reports using Oracle Reports 10g.
• Performed the unit testing for procedures, functions and packages.

Environment: Oracle 10g, UNIX, PL/SQL, SQL*PLUS, SQL*Loader.

Confidential, Memphis, TN

PL/SQL Developer

Responsibilities:

• Involved in design and development of the database design.
• Involved in Bulk loading of data from non-Oracle data sources using SQL * Loader.
• Participated in system analysis, data modeling and database designing which included creating tables, views, indexes, synonyms, triggers, procedures and packages.
• Developed Shell and PL/SQL scripting for regular maintenance and production support to load the data in regular intervals.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
• Involved in the design, development, testing and maintenance.
• Troubleshot production problems and worked effectively with other team members to identify and address problems.
• Provided input into project plans for database projects providing timelines and resources required. Involved in SQL tuning using SQL-Trace, Explain plan utilities.
• Responsible writing UNIX Shell scripts.

Environment: Oracle 9i, Sql*Loader, Pl/Sql, Toad, UNIX Shell Scripting.

Confidential, Union, NJ

Oracle Developer

Responsibilities:

• Development of user interface windows for sales order processing, invoicing, customer billing & inventory.
• Validation rules were implemented by writing procedures during data input.
• Created stored procedures, Packages, Functions and triggers using SQL & PL/SQL.
• Developed database triggers where ever necessary.
• Involved in analyzing user/business requirements and mapping into technical specifications.
• Performed in depth of data analysis and prepared weekly, biweekly, monthly reports by using reports 2.5.
• Implemented a whole new security for the reports in the oracle database to prevent confidential data from being displayed to all users. The security is based on the standard concept of roles and privileges.
• All the security roles and privileges are stored in the database tables and the logic is implemented using functions and views. Promoted the security feature to the existing reports with a very minor code change in the actual reports.

Environment: Oracle 9i/8i, Pl/Sql, Sql*Loader, Unix