Summary

• Used bulk binding techniques like BULK COLLECT and FOR ALL to improve performance.
• Experience in writing and tuning of complex SQL statements, complex joins and sub-queries.
• Experience in Creating and Maintaining Database objects like Tables, Indexes, Views, Synonyms, Stored Procedures and Packages.
• Experience in creating Cursors, composite data types, Collections and Exceptionhandling.
• Good knowledge in Creating and Maintaining Database objects like Tables, Indexes, Views, Synonyms, Stored Procedures and Packages.
• Expertise in creating Range, List Partitions, Sub Partitions and used CASE, DECODE functions and Analytical functions like Rank, Dense Rank, Row Number for data transformations.
• Proficient in writing Stored procedures, Functions, RefCursors, Views, Partitions Packages and Database Triggers using PL/SQL.
• Experience in Design, Development, Implementation and support of Oracle custom applications in Production, Development and Test Environments using Oracle Tools.
• Over 7 years of experience as Oracle PL/SQL developer with strong expertise in Oracle RDBMS, PLSQL Development, Oracle 9i,10g,11g SQL, PL/SQL, Developer Suite 10g: Forms and Report, Java, HTML and UNIX.
• Experience in working with Forms and Reports for development and customizations as per client specifications.

• Experience in using tools like SQL Plus, SQL developer, PL/SQL developer, TOAD.
• Excellent communication, interpersonal and versatile team player with problem solving skills.

Technical Skills:

Professional Experience:

Projects Summary:

Confidential

Oracle PL/SQL Developer

Responsibilities:

Requirement/Data Gathering and Analysis.

• Creation of Technical and Detailed Level Design Documents.
• Creation of Oracle Packages, Views, Triggers, PLSQL Collections.
• Extensively worked in Oracle SQL, PL/SQL, SQLPLUS, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms, Sequences, stored procedures etc., and involved Data Import/Export, Closely worked with DBAs to improve performance.
• Worked on Oracle SQL Developer.
• Performance tuning of SQL queries and PLSQL Code.
• Defined the executable, concurrent program and schedule the process to run automatically using AOL.
• Involved in writing complex queries to generate ad-hoc reports as well as ad-hoc DBA activities like data migration, ETL, replication per client request as a part of production
• Tuning the performance of SQL statements using HINTS and using TKPROF utility Explain Plan Table
• Used Materialized view to create a Monthly Snapshot from the Filed Reporting.
• Involved in writing complex procedures using Oracle 9i features like Bulk collect, FORALL loop, Collection Type , Object Type Autonomous transactions
• Involved in the creation of Database Objects to Oracle database, by using Erwin, Wrote UNIX SHELL scripts to automate Oracle ETL jobs.

• Used reports triggers before parameter form and after parameter form
• Debugging and testing of procedures and packages developed for the customized forms and reports
• Experience in using Oracle Workflow and supporting applications using Workflow and e-business applications as well.
• Involved in the creation of Database Objects to Oracle database, by using Erwin, TOAD Procedure Builder applications.
• Developed Reports to extract the monthly sales information

• Involved in helping and providing training to the users for creating Business Objects different types of reports like List report, Cross tab/matrix reports, Chart, Drill down, Drill up, Master/Details Reports etc.
• Used import/ export utility to backup daily development jobs.
• Used SQL Loader in Oracle for bulk Data Loading using direct path Conventional Path.
• Creating Unix Shell script to automate the FTP process for receiving and sending the files from many data vendors like IMS, WKH NDC , VA, Milliman, Pharmarica etc.
• Creating Auto-sys UNIX/TDP job to schedule the jobs to be run the given time and completion of the dependent jobs..Creating Operation support documentation.
• Provided quality assurance for all the modules developed.
• Developed Reports, Menus, Object Libraries and PL/SQL Library using Oracle Reports Developer 6i
• Created group, tabular, and form reports.
• Provided technical support to the user with regard to operational aspects

Environment: Oracle 10g, Reports 6i, Oracle 10g, UNIX, XML, ETL, PL/SQL, TOAD 8.6.1, SQL Loader, SQL Server, PL/SQL, AWR, SQL, SQL PLUS, SQL Loader.

Confidential

Responsibilities:

• Actively participated in gathering Business Requirements and System Specification from system users.
• Based on partially filled reports which comes from CRM department Retrieved the customer data from database
• Referencing the CUSIP id retrieved the customer policy id, premium amount, policy start date, end date, policy interest rate
• Written the pl/sql procedures to retrieve the customer information by giving policy id, cusip id as parameters
• According to given reports, changed the insurance policy by calculating the interest.
• Updated the policy interest rates by calculating the insurance rate then calculated the interest for next month
• Developed and updated the reports on different type of bonds like municipal bond, public financial bonds and insurance bonds
• Customized the reports with the new interest rates as per the business needs
• Developed and enhanced existing PL/SQL code extensively to suit changing needs
• Developed new reports using XML publisher in PDF format
• Used UTL FILE package in PL/SQL to read and write data in text files
• Wrote scripts to create tables, functions, procedures, ref cursors, triggers and packages
• Wrote shell scripts for automating the process of data loading
• and daily process
• Worked with DBA's to help them in data loading process, batch jobs and various administration tasks

Environment: Oracle 10g, SQL, PL/SQL, TOAD, SQL Loader, Reports 6i, XML publisher, SQL Plus, Unix, Java

Confidential

Oracle Developer

Responsibilities:

• Wrote SQL Loader scripts and PL/SQL programs for data loading
• Used Export/Import utility for backup and transferring data from one database to another
• Experienced of UTL FILE packages to load the data from external files that is exported from Server
• Extensively Used Cursor, Exception Handling, Throwing Exceptions, and Nested Loops, and also used the PragmaException Init in order to associate our own created error message with the error codes
• Managed and resolved design issues during development
• Wrote complex PL/SQL packages for Customer and Payment Interface from oracle Applications.
• Optimized and enhanced the existing procedures and SQL statements for the better performance EXPLAIN PLAN,SQL TRACE,HINTS and TKPROF to tune SQL queries
• Involved in application tuning of database by defining the indexes tuning SQL queries.
• Performed data partitioning
• Wrote UNIX shell scripting to call data load programs and email load status/errors.
• Extensively used SQL to create insert programs for loading data
• Designed and created Database object
• Performed Data Conversions and Data Cleansing
• Created indexes as a part of tuning.
• Used ETL software to extract, transform and load needed data into data warehouse.
• Cleansing data in data warehouse.

Tools Technologies: Oracle 11g, PL/SQL, SQL Plus, SQL Loader, UNIX shell Scripting.

Confidential

PL/SQL Developer

Responsibilities:

• Worked to translate business information requirements into technical data definitions. Worked closely with business analysts to understand and document business needs for decision support data.
• Working with Data migration team, providing the mapping between the source and target systems.
• Involved in gathering requirements from Business users.
• Developed PL/SQL packages, procedures, functions to migrate the data from source to stage and stage to the target systems.
• Designed intermediate database tables as per technical specifications.
• Involved in coding of data extraction scripts as per technical specifications
• Wrote complex queries to retrieve hierarchical data.
• Coordinated with DBA in creating and managing tables, indexes, db links and privileges.
• Developed cross reference tables needed for the data migration from the source to target systems.
• Developed various Packages to load and process the data.
• Involved in Data Extraction using UTL FILES in PL/SQL.
• Prepare program specification for PL/SQL procedures to do the conversion.
• Developed UNIX scripts and generated .csv files to load the files to the target system.
• Written Procedures and Functions using Dynamic SQL and written complex SQL queries using joins, sub queries and correlated sub queries.
• Created Unix Shell script to automate the FTP processes for receiving and sending the files.
• Used external tables to manipulate data obtained daily before loading them into the tables.
• Responsible for performing code reviews.
• Involved in Technical Documentation, Unit test, Integration test and writing the Test plan.

Environment: Oracle 10g/11g, SQL Plus, PL/SQL, SQL, UNIX Shell scripting, Oracle JDeveloper, Forms 6i/10g, SQL Loader, Discoverer, TOAD.