PROFESSIONAL SUMMARY:

• 7+ Years of experience in Software design, development and implementation of Oracle, SQL, PL/SQL applications.
• Excellent knowledge in Oracle SQL and PL/SQL.
• Experience in Relational Data Base Management Systems (RDBMS).
• Extensively worked in Client - Server application development using Oracle Forms 9i/6i, Reports SQL, PL/SQL.
• Experience in writing SQL queries, functions, packages, cursors and stored procedures, database triggers using PL/SQL in Oracle.
• Expertise in distributed query performance tuning by using EXPLAIN PLAN, SQL Trace and TKPROF Utilities, hints provided by oracle.
• Proficient in designing, modeling, creating and maintaining oracle database.
• Involved in query performance of slow SQL statements by implementing Index, using FORALL and BULK COLLECT.
• Experience with DBA activities like creating users, granting and revoking privileges on database objects and taking backups.
• Experienced in working with utilities like SQL * loader, External tables, import, export to extract large volume of data.
• Expert in Oracle database and GUI design and development of high performance technical solutions to meet the challenging business demands to the clients.
• Expert in Creating PL/SQL procedures, packages, functions, database triggers and other database objects like to generate back-end and front-end reports.
• Experience in Application Development using Forms, Reports and Discoverer.
• Strong experience in Oracle Workflows.
• Creating custom reports using BI tools such as OBIEE Reports, Oracle Reports Builder.
• Experience in application development using various advanced features of Oracle like Collections, Table Functions, Dynamic SQL, Object types and Records.
• Installation, maintenance of databases. Query to data dictionary.
• Extensive experience in data migration techniques using Core Oracle External Tables, SQL* Loader, Import/Export, bulk and batch processing.
• Excellent Java development skills using HTML, CSS, Java Script, Core Java,J2EE, Groovy, Grails framework.
• Experienced in data analysis, data modeling, development, testing and documentation of projects
• Has good experience with Object-Oriented Design, application design and development using SQL (SQL*Reports, complex queries, views, group queries, tree queries, nested query, sub queries), PL/SQL (Functions, Procedures, Triggers, Packages and Oracle inbuilt packages.
• Excellent working and conceptual knowledge of PL/SQL, VB. NET, JAVA, HTML and XML Technologies.
• Knowledge of Database design, E-R diagrams.
• Experience in Software Development Life Cycle (SDLC) including analysis, logical design, Resource Planning, code development, testing, implanting and maintenance
• Experience in UNIX shell scripting.
• Worked on ETL- extraction, transformation and load.
• Possess good communication skills.

TECHNICAL SKILLS:

Databases: Oracle 12c/ 11g/10g/9i, MS ACCESS

Oracle Tools: SQL * Plus, SQL developer, PL/SQL Developer, TOAD, SQL Tool, SQL * Loader, Developer 2000 (REPORTS 6i/9i /10g, FORMS 6i/9i/10g), SQL Navigator

SSIS: SQL Server Integration services,SSRS,Tableau.

Languages: C, SQL, PL/SQL, JAVA, VB.NET, Perl Scripting, UNIX Shell Scripting, Linux, COBOL.

Operating System: Windows NT/XP, UNIX

Data Analysis: Requirement Analysis, Business Analysis, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehouse, System Integration, Hibernate.

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Oracle SQL, PL/SQL Developer

Responsibilities:

• Involved in interacting with End users, Business Analysts, Data modeler and QA.
• Developed PL/SQL stored procedures to pull the data for reporting to be used on front end application by TELERIK.
• Responsible for gathering the business requirements by analyzing legacy application source code which is in COBOL.
• Responsible for writing reusable procedures, function, views and materialized views.
• Responsible for Unit testing and Integration testing and user acceptance testing.
• Identify Data migration bugs and assign to the data migration teams and following up with them.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Worked on requirement analysis, PL/SQL coding and testing various modules in a software development life cycle.
• Responsible for analyzing the legacy Main frame report and converting into PL/SQL.
• Did performance tuning to improve the report run time by using Hints, with clauses, dynamic queries, and indexes.
• Used Ref cursors to return data to the front end application TELERIK.
• Responsible for Bug fixes and Release Notes.

Environment: Oracle 12c PL/SQL, ETL, SQL*Plus, SQL*Loader, SQL Developer, TOAD, SharePoint, TFS, TELERIK, UNIX, UNIX Shell Scripts, COBOL

Confidential, Boston, MA

Oracle SQL, PL/SQL Developer

Responsibilities:

• Actively involved in interacting with front end users and gathered User Requirements and Online System Specification.
• Writing Procedures, Functions, Triggers and Packages.
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities using Oracle 11g/12c.
• Views creation for underlying reports on Tableau.
• Programming experience in UNIX Shell Script, PLSQL, Core Oracle PL/SQL,SQL PLUS.
• Created number of database objects like tables, views, indexes, synonyms and materialized views.
• Involved in creating procedures, functions, packages and triggers to facilitate functionality in different modules.
• Created data mapping files for the data coming from different Web Services.
• Created audit tables and implemented complex business logic using triggers(Statement level trigger and multiple row triggers).
• Worked on XML along with PL/SQL to develop and modify web forms.
• Created OBIEE Reports with multiple drilldown and sub-reports.
• Loaded the data into the tables using TOAD and SQL loader.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Modified in Scripts due to database changes using SQL and Oracle PL/SQL
• Developed ETL sessions for initial full loading and incremental loading.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Worked on requirement analysis, PL/SQL coding and testing various modules in a software development life cycle.
• Developed Unix Shell Scripts to Schedule jobs to automate tasks of loading data into Tables.

Environment: . Oracle 11g, 12c PL/SQL, SQL*Plus, SQL*Loader, SQL Developer, TOAD, Agile, UNIX, OBIEE, UNIX Shell Scripts

Confidential, Danbury, CT

Sr. PL/SQL Developer

Responsibilities:

• Gather Business rules from the end users
• Created new databases from scratch, refreshed databases for DEV/UAT environments.
• Implemented Database security via User Profiles, Roles and Grants.
• Developed and optimized database design for new applications.
• Data residing in the source tables have been migrated into staging and then final tables.
• Wrote PL/SQL Procedures, Functions, and Packages for Insert, Update and Delete transactions and optimized for maximum performance.
• Created TRIGGERS to Audit the changes to data in main Tables.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data and present it to the Front-End Team.
• Worked on Database Links to Access data from remote Database.
• Extensively worked on BULK COLLECTS, BULK INSERTS, BULK UPDATES and BULK DELETES for loading, updating and deleting huge data.
• Work Closely with DBA team during Database and Performance issues.
• Scheduled the Jobs for loading data using DBMS SCHEDULER.
• Utilized tools like SQL Navigator during development of the application.
• Utilized the DEBUGGING Tool of SQL Navigator to monitor the execution Process of the procedures, functions and packages.
• 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
• Performed SQL and PL/SQL tuning to improve the performance with the help of SQL Trace, Explain Plan, Indexing and Hints.
• Involve with Business Analysts and Front-End (JAVA) users to develop the Application and fix the bugs.
• Created PROCEDURES & FUNCTIONS by making use of UTL FILE to read and write data to the Database.
• Created VIEWS for generating reports and restricting data access to different users.
• Worked on MATERIALIZED VIEWS with COMPLETE, FORCE refreshes to improve the Performance of the application by making local copies of remote Tables.
• Performance Tuning of complex SQL queries using Explain Plan to improve the performance of the application.
• Extracted data from Flat files using SQL*LOADER.
• Developed Unix Shell Scripts for loading data into the database using SQL* Loader.

Environment: Oracle 11g, SQL Navigator 6.5, SQL Tuning, SQL*Loader, UNIX Shell Scripting, Oracle forms, MS Excel, MS Word.

Confidential, Atlanta, GA

Oracle 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 views as per the business requirements.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, Tk-prof and Auto trace.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Part of a development team for creation and maintenance of custom apps/reports.
• Experienced with bulk collections and for all 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 UNIX Shell scripts to automate table creation, execute procedures using dynamic SQL statements.
• Worked on Data schema modeling and designed Database Schema using ERWIN tools and implemented Normalization on relational modeling.
• 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.
• Extensively used Database Query tuning and performance tuning of reports.

Environment: Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, MS Access, UNIX Shell script, TOAD, Oracle Forms 10g, Reports10g, Perl, UNIX, Windows XP/2000.owb 10g

Confidential

PL/SQL Developer

Responsibilities:

• Interacting with the business users to understand the functionality and their requirements.
• Designed and developed custom packages, procedures, Triggers using PL/SQL.
• Loaded data into Oracle using PL/SQL, Dynamic SQL UTL FILE, SQL* Loader and extensive use of External Tables
• Designed the packages and procedures for getting the data from Source systems to ESA (Enterprise Staging Area) and from ESA to EDW(Enterprise Data Warehouse)
• Extensively worked on Oracle Packages, procedures and functions using PL/SQL, SQL, SQL Navigator and PL/SQL Developer.
• Performed unit testing on the developed code to ensure that its bug free and handled Production issues and manage the same in issue log.
• Interacted with Business Analysts and Users in requirement gathering, built complex queries using SQL and wrote stored procedures using PL/SQL.
• Involved in the database design for better understanding the relations, associations and dependencies within the database.
• Designed Technical design document based on the business requirements.
• Worked on SQL*Loader to perform bulk data loads into database tables from external data files.
• Designed and developed Oracle PL/SQL Procedures, Functions, and Database Triggers and involved in creating and updating Packages to meet business requirements.
• Created UNIX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources.

Environment: Oracle 10g, PL/SQL, Report Builder 10.1.2.0.2 , Jasper Server 3.1.1/1.3.0 , Jasper ETL, IReport 3.1.1/1.3.0 , Toad 7.5.2.0, UNIX