PROFESSIONAL SUMMARY:

• An ambitious, an ardent, and a results-driven professional having 6.5 years of work experience in Information Technology domain that can quickly adapt, learn and deliver.
• Expert in Oracle 8i/9i/10g Database Development using SQL & PL/SQL programming, Oracle SQL*Loader, Views, Synonyms, temporary tables, Indexes, Parsing table data in XML format, Materialized Views, Stored Procedures, Functions, Packages and Database Triggers.
• Led a team of five consultants and assigned them worked accordingly to meet the SLAs
• Written, used Unix Shell Scripts. Extensively used TOAD, SQL*PLUS, SQL Navigator and used SQL * Loader to load the huge data into source tables.
• Experience in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases.
• Sound Experience and knowledge of General Ledger, Account Payables, Account Receivables, Cash Management, Order Management, Purchasing
• Experience in Table design and Extraction and population of data using oracle batch routine process.
• Expert in coding complex and advanced PL/SQL programs using Oracle’s Object-Oriented programming, collections, records, index-by tables, object types and methods.
• Well-acquainted in working with complex SQL queries with joins, date functions, inline functions, sub-queries to generate reports, Functions, Procedures, Exception handling, Views, Packages, Triggers and Ref Cursors.
• Extensive experience in using PLSQL Object Types, Oracle Parallel Queries, Materialized Views, Bulk Collects, Bulk Load, Regular Expressions, FORALL, Merge etc.
• Excellent proficiency in Data Transformations and loading using Export/Import and SQL*Loader and worked on External tables and Transportable table spaces.
• Good understanding of Software Development Life Cycle (SDLC) and RDBMS principles.
• Good understanding of
• Involved in Designing and developing efficient Error Handling methods and implementing them throughout all the mappings.
• Experience in developing user interface for database applications using the Oracle Apex.
• Strong experience in developing SQL/PLSQL Scripts/Programs for Data Analysis, Extraction, Transformation and Loading (ETL) mechanism
• Possess strong ability to quickly adapt to new applications, platforms and languages
• Recognized Team player with the ability to perform well in a group or individually with the ability to cope well in a high intensity work environment.

TECHNICAL SKILLS:

Databases: Oracle, MySQL, SQL Server

Design concepts: Object-oriented design

Frameworks: Oracle Application Framework, Spring

Programming languages: C, C++, Java, SQL, PL/SQL, T-SQL, Hive SQL

Web services: REST, SOAP

Tools: TOAD, SQL Developer, SQL*Plus, WinSCP, putty, XML Publisher, BI Publisher, Oracle Form Builder, Oracle Workflow builder, Oracle J Developer, Oracle Report Builder, Eclipse, NetBeans, Informatica, Pentaho

Operating systems: UNIX, Microsoft Windows, OSX

Cloud computing: Hadoop, Google App Engine, Amazon Web Services

ETL tools: Informatica, Pentaho

Content management system: Drupal

PROFESSIONAL EXPERIENCE:

Lead Oracle Database Developer

Responsibilities:

• Analyzed Database of Source 9i and target 11g database before and after migration
• Used DBMS SQLTUNE.REPORT SQL MONITOR package to generate sql monitoring report and tune the queries
• Improved the performance of Materialized View Refresh from 4 hrs. to 25 min using WITH clause/MATERIALIZE HINT, Indexes and Bulk Processing.
• Performance Tuning of complex SQL queries using Explain Plan to improve the performance of the application.
• Oracle Apps Modules worked on - Account Receivables (AR), Account Payables (AP), General Ledger (GL), Fixed Assets (FA), Cash Management (CM), Inventory (INV), Order Management (OM)
• Solved production issues in Oracle E-Business Suite application which occurred in the technical side based on SLA agreements
• Extensively worked on BULK COLLECTS, BULK INSERTS, and BULK UPDATES & BULK DELETES for loading, updating and deleting huge data.
• Used Oracle Analytical functions such as RANK, DENSE RANK, LEAD, LAG, LISTAGG& ROW NUMBER Functions for sorting data.
• Modified PL/SQL code backend to improve the performance concurrent jobs
• Developed PLSQL Trigger and Procedures, Functions, Packages to provide backend security and data consistency.
• Performed ETL processes using the tool Informatica
• Extensively worked on Table Partitions, Materialized Views for speeding up the response of SQL queries
• Extensively worked on SQL and PL/SQL performance tuning to improved performance of many application queries and batch processing jobs.
• Responsible for development and testing of conversion programs for importing data into Oracle database utilizing PL/SQL, SQL*Loader and shell scripts, to load data from flat files to Oracle database.
• Maintained a high-quality standard in a complex and constantly evolving software environment.
• Extensive query optimization and performance tuning. Created the integrity constraints and Database Triggers for the data validations. Used PL/SQL Tables and Records in payment generation process. Written Test Plans and Involved in unit testing.
• Involved in implementing table partitions using Range, Hash, Composite techniques.

Senior Oracle Database Developer

Responsibilities:

• Created new packages, procedures and functions for those objects which could not be migrated due version incompatibility.
• Customized the standard Java-based Customer page in Oracle Apps using Oracle's proprietary framework - Oracle Application Framework
• Created Records, Tables, Objects, Collections, Views, Materialized views and Global temporary tables (Nested Tables and Varrays), and performed Error Handling.
• Extensively used Cursors, Ref Cursors, Dynamic SQL and Functions.
• Participated in Performance Tuning using Explain Plan.
• Tested, Installed, Documented and provided On Call Support for the Applications.
• Developed scripts and changed few existing scripts to solve the issues
• Actively involved in gathering, designing of code and developing system requirements
• Created Functional Requirement Specification (MD50) documents by analyzing the Business Requirement documents
• Tuned existing PL/SQL routines and redesign the application to improve overall system performance
• Analyzed the data using SAS to create a predictive model for categories of insurance policies, that customers could probably choose
• Created and modified existed complex queries, sub queries and joins to check the validity of loaded and imported data
• Tuned existing PL/SQL routines and redesign the application to improve overall system performance by using Auto trace, SQL Trace, Explain Plan, and TKPROF utilities
• Solved priority one issues relating financial period closing, in production environment, during year closing.
• Developed PL/SQL stored procedures, functions, triggers and packages to access the database
• Strengthened developmental methodologies by introducing a code quality document
• Maintained a high-quality standard in a complex and constantly evolving software environment.

Senior Oracle Developer.

Responsibilities:

• Involved in writing PL/SQL procedures to generate DDL scripts that created database objects dynamically based on user inputs
• Developed Packages, procedures, functions, views and triggers using PL / SQL, SQL*PLUS and TOAD
• Written (Back-end) PL/SQL code in Oracle 10g to implement business rules through Triggers, Cursors, Procedures, functions, and Packages using SQL*Plus or TOAD
• Generated table data in XML format and sent them for import/export using payload concept
• Created PL/SQL Packages for easier application design and improved Performance. Created PL/SQL Procedures using Native Dynamic SQL and Cursor Variables
• Created Table design and Data models for various reports purpose. Developed Table Functions to populate and extract the data in schema based data Model tables
• Created database objects like tables, indexes, synonyms, views etc. using SQL* Plus, used SQL*Loader control files to load data from external data sources into Oracle database
• Used built in functions of PL/SQL such as SQLCODE, SQLERRM for error reporting
• Developed PL/SQL stored procedures, functions, triggers and packages to access the database
• Written PL/SQL scripts to test and validate the information from the source to target systems
• Developed staging Tables, Control files based on Flat File and used SQL*Loader to load the data into Oracle Source Tables
• Extensively used temporary tables, REF CURSORS for dynamic allocation of SQL statements to cursor variables within procedures and packages
• Extensively used UTL FILE package to dump the oracle base table’s data into XML format per the client’s requirement.
• Tuning SQL queries of the application for better performance by using Auto trace, SQL Trace, Explain Plan, and TKPROF utilities
• Prepared technical documents for all the programs developed & generated
• Involved in production support to load the data using the UNIX shell scripts to schedule Jobs. Involved in Regression and User Acceptance Testing (UAT)

Junior Oracle Database Developer

Responsibilities:

• Oracle Apps Modules worked on - Order Management (OM), Purchasing (PO), Inventory (INV), Customer Relationship Management (CRM)
• Actively involved in gathering, designing of code and developing system requirements
• Modified existing 11i Packages, procedures, functions, views and triggers using PL / SQL, SQL*PLUS and TOAD to make them compatible in R12.1.3 Environment
• Created custom Packages, procedures, functions, views and triggers using PL / SQL, SQL*PLUS and TOAD in R12.1.3 Environment for the objects which couldn’t be modified and had incompatibility.
• Created Custom reports to view the data using XML publisher
• Customized ORACLE seeded reports based on the client requirements
• Debugged the production priority one issues. Developed scripts and changed few existing scripts to solve the issues
• Created and modified existed complex queries, sub queries and joins to check the validity of loaded and imported data
• Tuned existing PL/SQL routines and redesign the application to improve overall system performance by using Auto trace, SQL Trace, Explain Plan, and TKPROF utilities
• Worked with PL/SQL advanced features like Collections and Record Types
• 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.
• Involved in Regression, System Acceptance Testing (SAT) and User Acceptance Testing (UAT)
• Extensively worked on creating partition indexes for large tables.
• Optimized code for the better functionality of several procedures, packages, functions and Triggers.
• Extensively involved in performance tuning using Explain Plan, DBMS PROFILER, Optimized SQL queries and created Materialized views for better performance
• Created new packages, procedures and functions for those objects which could not be migrated due version incompatibility.
• Customized the standard Java-based Customer page in Oracle Apps using Oracle's proprietary framework - Oracle Application Framework
• Developed scripts and changed few existing scripts to solve the issues
• Actively involved in gathering, designing of code and developing system requirements
• Created Functional Requirement Specification (MD50) documents by analyzing the Business Requirement documents
• Tuned existing PL/SQL routines and redesign the application to improve overall system performance