OBJECTIVE

• To work in fast paced dynamic environment to align my professional Oracle PLSQL skills with a progressive company wherein the application of my technical education and work ethics that would provide a significant contribution to the company’s continued success and thereby adding value to the organization.

SUMMARY

• Having 9 years of experience as Oracle PL/SQL developer and implementation of applications using Oracle Applications.
• Strong experience in Oracle RDBMS, PLSQL Development, Oracle 9i,10g,11g, SQL, PL/SQL, Developer 2000/Forms and Report 10g/6i, Java, HTML, UNIX and Workflow.
• Experience in Design, Development, Implementation and support as Oracle Developer in Production, Development and Test Environments using Oracle Tools.
• Experience in using Oracle tools like SQL * Loader, Toad, SQL Navigator, SQL Developer and Data Loader.
• Developed SQL Loader control programs, interfaces and PL/SQL validation scripts to transfer flat file data into oracle database and Oracle Applications base tables.
• Experienced in RDBMS design, data modeling, data normalization and SQL tuning using Indexes.
• Good conceptual knowledge in Data warehouse and STAR Schema.
• Good knowledge in Creating and Maintaining Database objects like Tables, Indexes, Views, Synonyms, Stored Procedures and Packages.
• Proficient in writing Stored Procedures, Functions, Packages and Database Triggers using PL/SQL.
• Experience in Creating and Maintaining Database objects like Tables, Indexes, Views, Synonyms, Stored Procedures and Packages.
• Experience in Creating Unix Shell script to automate the FTP processes for receiving and sending the files
• Experience in writing and tuning of complex SQL statements, complex joins and sub - queries.
• Used SQL Trace, Explain Plan and TK Prof for Better performance.
• Experience in working with UTL Files and Dynamic SQL.
• Developed SQL Loader control programs, interfaces and PL/SQL validation scripts to transfer flat file data into oracle database and Oracle Applications base tables.
• Proficient in Designing and Developing of Forms and Reports using Oracle Forms 10g/9i/6i and Reports 10g/9i/6i.
• Experience in Design, Development, Implementation and support as Oracle Developer in Production, Development and Test Environments using Oracle Tools like JDeveloper and reporting services using Oracle BI tools.
• Proficient in designing, modeling, creating and maintaining Oracle database.
• Excellent experience in L2 production support dealing with User queries and requirements.
• An excellent team player & technically strong person who has capability to work with business users, project managers, team leads, architects and peers, thus maintaining healthy environment in the project.

TECHNICAL SKILLS

Operating Systems: DOS, Windows XP/NT,Vista,7 Sun, AIX, Linux, UNIX

Languages: SQL, PLSQL, C, C++, COBOL, Java, VB .Net

Scripting Languages: JavaScript, Perl, HTML and XML

GUI’s Technologies: Oracle Forms and Reports 10g/9i/6i, Oracle Designer 2000, Crystal Reports 9/10, Discoverer10g, Erwin, ODI, J2EE (Servlets, JSP, JDBC), Oracle APEX

Databases: Oracle 9i/10g/11g, SQL server 2000, Oracle XML DB, Oracle AIX, Oracle AQ, MS Access

SCM Tools: Subversion, CVS, ClearQuest, JIRA

Utilities: SQL* Plus, SQL* Loader, SQL Navigator, Toad, UTL File, ETL tools Informatica Power Center, OEM

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Oracle Developer & Production Support

Responsibilities:

• Participated in all phases of development System Analysis, Design, Coding, Development and Implementation and provide support to existing client databases.
• Requirement Gathering through BRD (Business Requirement Document) Discussion with end users and clients for Analysis.
• Participated in High Level Design Document, Project Cost Estimation and Project Delivery Schedule for getting Project Approvals from Business Team.
• Developed Code Units, testing, debugging and implemented business rules using SQL, PLSQ (functions, procedures, packages, triggers), SQL*Loader, Unix Korn shell scripts
• Involved in creation of tables, partitioning tables, correlated sub queries, nested queries, views, and sequences, synonyms for the business application development and as per the business rules from client.
• Managing migration code base using CVS.
• Extensively used the advanced features of PL/SQL like Varrays, Records, Nested Tables, Bulk collect and Dynamic SQL for high performance of stored procedures.
• Used Oracle provided packages DBMS OUTPUT, DBMS JOBS, DBMS SCHEDULER, DBMS SQL and UTL FILE in different requirements.
• Optimized daily database jobs running by generating statistics, creating indexes, SQL, PL-SQL code tuning using hints, Explain Plan,, SQL Trace, TKPROF
• Handled exception in PL/SQL using Pragma Exception init, Raise Application Error and error trapping functions
• Set up dbms scheduler jobs to auto run procedures Confidential specific interval.
• Providing support to production, development, QA and staging databases.
• Working on daily script reviews, ad hoc requests, testing migrations.
• Extracted data from the Customer Interaction Center and creating separate flat file (text file) to load data into database table.
• Maintained the data integrity and security using integrity constraints and database triggers. Also used instead of triggers and Pragma Autonomous transaction trigger.
• Extensively used SQL*Loader, export/import and data pump, dblink
• Created Batch Job Interfaces for Data Cleaning, processing and loading using shell scripts and SQL Loader.
• Created Batch Job Interfaces using Unix Shell Scripts and pl-sql for daily file transfers using FTP, SFTP, and ConnectDirect.

Environment: Oracle 11g, Toad 10.6, SQL Loader, UNIX (AIX 6.1), Putty 0.62, CVS, Windows 2010

Confidential, Deerfield, IL

Oracle PL/SQL Developer

Responsibilities:

• Written PL/SQL Stored Procedures, Functions and Packages and Triggers.
• Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle utilities like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions
• Developed many packages using PL/SQL to do the validations as per requirements.
• Generate SQL Scripts and created views for reports.
• Used Toad to Extract and test the data in the database.
• Developed Database Triggers to enforce security.
• Involved in Data Extraction using UTL FILES in PL/SQL.
• Developed Forms using Forms10g and Reports using Reports10g based on client requirement.
• Prepared technical documents for all the programs developed & generated.
• Responsible in coding, trouble shooting and debugging.
• Modified the existing database objects to meet the expanding business requirements.
• Loading of the data from flat files into staging tables using SQL Loader.
• Written Stored Procedures to perform Validations on data and to move data from staging tables into the Base tables.
• Loading of data from flat files into the user interface forms using Data Loader.
• Responsible for creating the technical design document.
• Involved in Development, Testing and Maintenance of the System.
• Written Procedures and Functions using Dynamic SQL and written complex SQL queries using joins, sub queries and correlated sub queries.
• Developed various Forms for the application involving modules to segregate the data.
• Written UNIX shell scripts and scheduled cron jobs.
• Involved in design, development and Modification of PL/SQL stored procedures, functions, packages and triggers to implement business rules into the application
• Involved in performance tuning of SQL queries and Created indexes on tables and optimizing Stored procedure queries
• Analysed the business requirements of the project by studying the Business Requirement Specification document.
• 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.

Environment: SQL, PL/SQL, Oracle 9i/11g, Toad 8.5, SQL*Plus, Oracle APEX, SQL*LOADER, XML, Pro*C, UNIX shell scripting, Reports 10g, Forms 10g, Discoverer 10g.

Confidential, Chicago, IL

PL / SQL Developer

Responsibilities:

• Identified tables, Indexes, Stored Procedures, triggers, Constraints and Data types of the existing SQL Server database.
• Came up with the low level detailed design to re-create the objects to Oracle database.
• Implemented and fine tuned the detailed design to fit into the migration process.
• Created and managed primary data base objects such as Tables, Views, Indexes, Sequences, and Synonyms according to corresponding Data types
• Developed PL/SQL code to implement business rules through cursors, ref cursors, procedures, functions, and packages
• Migrated data from flat files to Oracle database using SQL*Loader
• Developed control files for SQL * Loader and PL/SQL scripts for Data Extraction/Transformation/Loading and Mapping, loading data into interface tables from different Legacy systems and validating the data.
• Efficiently developed Conceptual, Logical Data models and transformed them to Physical Data model and Creating Schemas using ERWIN.
• Designed and developed Informatica Mappings to load data from Source systems.
• Created PL/SQL stored procedures for database and application validations
• Modified and developed database triggers, cursors, procedures, functions and packages to meet business requirements
• Involved in performance tuning of SQL queries to decrease the execution time
• Created test cases PL/SQL procedures for migrated SQL and PL/SQL procedures
• Used cursor variables to pass query result sets between PL/SQL programs and client application
• Migrated the reports according to the requirement using Oracle Reports 10g
• Responsible for writing the technical documents and maintaining the documentation

Environment: Oracle 10g, SQL and PL/SQL, SQL * Loader, TOAD, SQL * Plus, Reports 10g, Erwin, ERD, Informatica Power Center

Confidential, Pittsburgh, PA

PL/SQL Developer

Responsibilities:

• Involved in analysis, design, coding, and implementation
• As a part of Data Mining team provided the data from the database to the Testing teams
• Written the SQL Queries to Data Retrieval Tool
• Upon the Requirement updated and modified the queries in the query tool
• Need to develop the reports everyday from the database to check the accounts migration
• Extensively used inbuilt Oracle PL/SQL packages like UTL FILE, DBMS PIPE, DBMS SQL, DBMS STATS in application development
• Developed PL/SQL packages, procedures, functions, materialized views, SQL Scripts and triggers to populate the historic data in the tables applying business logic
• Extensively involved in writing SQL sub-queries with join conditions and PL/SQL scripts
• Involved in performance tuning of SQL queries and Created indexes on tables and optimizing
• Stored procedure queries
• Developed triggers for automatic updating of the tables and views
• Created group, tabular, and form reports
• Used UNIX scripting to automate the process by using CRONTAB.

Environment: Oracle 10g, SQL*PLUS, TOAD, SQL*LOADER, Forms 10g, Reports 10g, PL/SQL

Confidential, New York

PL/SQL Developer

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 10g, XML publisher, SQL * Plus, Unix, Java

Confidential, Philadelphia, Pennsylvania

PL/SQL Developer

Responsibilities:

• Gathered and analyzed requirement from business users
• Created database objects like Tables, Synonyms, Sequences and Views
• Edited procedures and functions for improved business requirements
• Wrote complex PL/SQL packages for Customer Interface and Payment Interface and for Oracle Applications
• Used Materialized Views, Hints, SQL Trace/TkProf, Indexes for query tuning and optimizations
• Collaborated with data Warehouse Architect in writing SQL scripts, Shell Programs, Data Flows and more
• Supported development, test and production database
• Used SQL Developer and TOAD to develop code.
• Worked with Oracle Forms 10g and Reports 10g.
• Created Test cases, Technical Design Document, and Install Plans and worked with Release Engineering teams

Environment: Oracle 10g, PL/SQL, SQL, ERWIN, Forms 10g, Oracle report 10g, Shell Scripts