PROFESSIONAL SUMMARY

• A Technology driven IT professional with over 7 years of experience in designing and developing Complex applications, developing Reports for Internet/Intranet based applications using Oracle..
• Experience using SQL in a large-scale relational database environment.
• Expertise in writing SQL Queries, PL/SQL Stored Procedures, Functions, Packages, Database Triggers, Materialized Views, SQL Trace on Oracle 10g/11g databases.
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases.
• Extensive experience in database programming using SQL and PL/SQL.
• Managed many database tables using Views and Sequences.
• Scheduled complex cron jobs on UNIX platform using crontab format.
• Involved in handling large volumes of data.
• Experience in Dynamic SQL, PL/SQL Collections and Exception handling.
• 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 Table Partitioning, creation of indexes for faster database access and better query performance.
• 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.
• Worked on Performance Tuning and SQL optimization.
• Expertise in using Excel spreadsheets.
• Expertise in writing Pipeline functions.
• Extensive experience in using Compound triggers.
• Planned, Designed and Implemented Table Partitioning for improving performance.
• 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.
• Experience of building and maintaining Microsoft Excel Spreadsheets, Pivot tables and Macros.
• 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.

TECHNICAL SKILLS

Scripting: PL/SQL, SQL, C, C , UNIX

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 , Oracle forms and reports 9i.

PROFESSIONAL EXPERIENCE

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 creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL loader from text and excel files.
• Worked with the Data mart team and involved in the development process.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Extensively used Ref cursors.
• Used external hints during the SQL optimization to fast up the SQL process.
• 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 .
• Involved in development of Oracle Forms/Reports, New Screen designs, Modifications.
• 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.
• 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.
• 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, SQL, PL/SQL, SQL Loader, MS Access, UNIX Shell script, TOAD, Oracle Forms 10g,Reports10g,UNIX, Windows XP/2000.owb 10g.

Confidential

Oracle PL/SQL developer

Responsibilities:

• Analyzed the business requirements for the enhancements needed in the contract Administration application and related policy modules.
• 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.
• 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.
• Worked on Performance tuning using Explain plan, TK PROF.
• Performed SQL Query Optimization for better performance.
• Developed various forms and reports using Oracle Forms and Reports builder 10g.
• Extensive use of Global Temporary Tables GTT .
• 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.
• Used pipelined functions for better performance.
• 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.
• Implemented various customized Oracle reports using different techniques in Oracle SQL/PLSQL like SQL Plus reports.
• 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.
• Database security by authenticating users, using logon triggers. Created materialized view on remote database and automated scheduler of refreshing of materialized view.

Environment:

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

Confidential

Oracle PL/SQL Developer

Responsibilities

• Hands on experience for performance tuning on existing SQL to improve application performance.
• Involved in all phases of SDLC as active participant.
• Has a very good exposure on technical documentation.
• Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
• Expertise in creating functional/technical specifications, testing scenarios, preparing test cases.
• Strong drive and determination to meet targets and deadlines.
• Works quite well under pressure, has a can do attitude.
• Involved in project plan and Risk plan.
• Created Materialized views for summary reports and extracts for better query performance.
• Used various Indexing and partition techniques to improve the query performance.
• Strong experience to analyze the existing and proposed systems.
• Based on requirements estimations provided for new development and enhancements.
• 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.
• Exposed on UNIX scripts and environment.
• Hands on experience to create views, stored procedure, Packages.
• Interacted with business analyst and software developers for bug reviews and participated in QA meetings.
• Used Explain Plan and AWR reports to tune the complex queries and debug the queries to provide exact solution.
• Conducted brainstorm meetings and suggested performance improvement techniques and proposed designs.
• Review the test cases and code developed by team members.

Environment:

Oracle 10g, UNIX, PL/SQL, Shell Script, Windows XP, Clear Case, Clear Quest, Unix Shell scripts, SQL navigator, SQL Loader, Microsoft Visual web developer 2009

Confidential

Jr. Oracle developer

Responsibilities:

• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in developing CRONTAB to schedule the information of cron entries.
• 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.
• Worked with the Data mart team and involved in the development process.
• 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 .
• Involved in development of Oracle Forms/Reports, New Screen designs, Modifications.
• 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.
• Upgraded to Forms 10g, Reports 10g, maintained and troubleshoot Oracle Forms and Reports.

Environment: Oracle 11g/10g, Forms 10g, Reports10g, Designer 10g, SQL Plus, XML, SQL Developer, PL/SQL, HP-UX, Windows NT/2000