PROFESSIONAL SUMMARY

• A Technology driven IT professional with over 6 years of experience in designing and developing Complex applications, developing Reports for Internet/Intranet based applications.
• Expertise in writing SQL Queries, PL/SQL Stored Procedures, Functions, Packages, Database Triggers, Materialized Views, SQL Trace on Oracle 10g/11g databases.
• Experience in Table Partitioning, creation of indexes for faster database access and better query performance.
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases.
• Designed and developed Oracle Reports and Forms for Oracle Applications using Oracle 10g.
• Expertise in development of Oracle Forms/Reports, New Screen designs, Modifications
• Worked on different level triggers like form level, block level and item level.
• Extensive experience on developing different types of Canvases.
• Developed Master Detail, Detail reports using tabular and Group above reports
• Extensive experience in database programming using SQL and PL/SQL.
• Extensive experience in developing UNIX Shell scripts, SQL and PL/SQL coding.
• Managed many database tables using Views and Sequences.
• Scheduled complex cron jobs on UNIX platform using crontab format
• Experience in Dynamic SQL, PL/SQL Collections and Exception handling.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and different file formats utilizing oracle Utility tools SQL Loader, Import and Export.
• Expertise in writing Pipeline functions.
• Extensive experience in using Compound triggers.
• Expertise in utilizing oracle Utility tools SQL Loader, Import and Export.
• Experience with Oracle SQL and PL/SQL programming and used Database utility tools like SQL Navigator, SQL Plus, TOAD, SQL Developer.
• Expertise in working with Oracle built-in packages such as DBMS SCHEDULER, UTL FILE, UTL MAIL, DBMS SQL, DBMS JOBS.
• Excellent Analytical, Programming and Reporting skills.
• Experience in Understanding complex performance issues and worked with DBA's to suggest valuable ways to fix the problem.
• Coordinated with DBAs, QA, Release Management and external team for technical needs and to ensure the timely release of project.
• Good communication skills, inter personal skills and proven ability to perform both as an individual and as a team player.

TECHNICAL SKILLS

Scripting : PL/SQL, SQL, C, C , UNIX, Oracle Forms and Reports.

Web Technologies : HTML, HTML5, XML

Database : Oracle 9i/10g/11g, SQL Server, Ms Access 2000.

Operating Systems : Windows 95/98/NT/XP/Vista, Windows 2007, UNIX, Linux

Tools/Utilities/IDE : SQL Developer, Putty, SQL Navigator, SQL Plus, SQL Loader, TOAD,

AQT Advanced Query Tool .

Work Summary

Confidential

Oracle PL developer

Responsibilities:

• Analyzed the business requirements for the new and enhancements needed in the reports.
• Performed several DDL and DML operations.
• Created database packages with related functions and procedures.
• Developed views by joining multiple cash flow tables to show output as a report to the user.
• Extensive PL/SQL programming including Development of new backend packages, procedures and functions to incorporate advanced modules.
• Developed Master Detail, Detail reports using tabular and Group above reports
• Worked on BULK COLLECT for bulk loading the data into various transaction tables.
• Implemented various UNIX scripts to generate the data in delimited format.
• Used UTL FILE to load the data into oracle tables from FLAT, CSV and Text files.
• Added database triggers to some history tables of the database for keeping track of updates to values in a history table.
• Extensive use of Global Temporary Tables GTT in staging areas.
• Refreshed the development and test databases using export/import utilities.
• Used external hints during the SQL optimization to fast up the SQL process.
• Worked on Ref cursors.
• Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, stored procedures, functions and packages.
• Worked on inline and correlated Sub queries based on business context.
• Extensive and in depth analysis of the problem tickets to dig out the root cause for the problems.
• Involved in Impact analysis of the defects to the associated functionalities and modules in the Production environment.

Environment:

Oracle 11g/10g, PL SQL, SQL Developer, SQL Plus, Export Import Data, Forms 10g, Reports10g, UNIX, Toad 9.6/9.7

Confidential

Position: Sr Oracle Developer

Responsibilities:

• Understanding the existing business applications functionality, technology and requirements by referring through documentation, WebEx meeting records, database table and reviewing the source code.
• Understanding of data extraction, transfer and loading in existing applications
• Analysis of source code for existing applications, delegation and assignment of work with offshore team.
• Developing the PL/SQL script to extract data from database
• Developing ER diagram for existing database
• Data mapping for ETL.
• Performance tuning the existing procedures in the packages.
• Guiding the team to contribute to the success of Knowledge transfers. Co-ordinate with them to resolve the production issues in SQL scripts.

Environment: Oracle 11g/10g/9i, SQL PLUS, TOAD, UNIX, ERWIN, CVS, XML, WebEx, Workflow Manager, Mapping Designer, MS VISIO, Performance Tuning.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Collaborated with the Business analysts and the DBA for requirements gathering, business analysis, testing and project coordination
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in developing CRONTAB to schedule the information of cron entries.
• Involved in development of Oracle Forms/Reports, New Screen designs, Modifications.
• Created, Modified, maintained and debugged Forms and Reports using Oracle Forms and Reports 10g.
• 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.
• Developed Master Detail, Detail reports using tabular and Group above reports
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL loader from text and excel files.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Extensively used Ref cursors.
• worked with bulk collect to Implement the performance of multi row queries
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems using PL/SQL and SQL Loader.
• Remediate Oracle application Custom object components like Forms, report and Concurrent Program PLSQL code .
• Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader and External tables.
• Implemented SQL and PL/SQL stored procedures.
• Worked on admin and user editions of discoverer 10g and used AIM application implementation methodology in documenting the development tasks.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• 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.
• Generated various analytical reports using Microsoft Access.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Used Toad for creating PL/SQL trigger, sequence, stored procedure .
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.

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

Confidential

Position: Sr Oracle Developer

Responsibilities:

• Prepared technical documentation about the implementation of business logic, Workflow diagrams and Activity diagrams
• Understanding the business requirement Of the Business Application. Creation or Alteration of Schema Objects to accomplish them.
• Involved in creating logical and physical data model for the application
• To synchronize schema objects from different databases.
• Work with data modeling using ERwin data modeler
• Deploy scripts to different environments like Development, Testing QA , staging ITG and Production.
• To create package, procedure and function for generation of scripts for metadata of schema objects using in-built API's like dbms metadata, dbms lobs..,
• Data integration into fact or lookup tables.
• To resolve the data integrity issue among the upstream and Downstream applications.

Environment: ERwin, SQL developer, SQL PLUS, source tree, windows power shell, ALM.