CHIRANJEEVI R

Title : ******

Environment : ******.

Client : ******

Roles & Responsibilities:

• Change and creation of new PL/SQL packages and procedure as per business requirement
• Developed interface for item data conversion to load items from flat file to Oracle Inventory using SQL Loader, PL/SQL and import items program
• Involved in development of shell scripts to send invoices to customer through mailing
• Developed various reports ‘Customer Statement of Account’, ‘Core Debit memo’ and AR Invoice Report
• Extensive Use of Pragma Autonomous Transactions
• Extensively used for all and bulk collect to fetch large volumes of data from table
• Involved in data migration from Production to test and created test data for analyzing problems, providing solution
• Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement
• Designed and developed various custom packages triggers and forms
• Review and Analysis of Business Requirement
• Debugging and deployment of coding and testing
• Resolving issues and providing inputs for performance improvement
• Created heavy stored procedures using Dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose
• Extensively worked in Performance Tuning of programs and processes.

Title : ******

Environment : ******.

Client : ******

Roles & Responsibilities:

• Created Procedures, Triggers, Functions and Packages
• Very good knowledge of SQL, PL/SQL especially writing queries with Joins, Sub-Queries, Rollups, Cubes, Set Operators
• Knowledge of Materialized Views, Tables, Views, Primary keys, Indexes, Constraints, Sequences, Grants and Synonyms
• Understanding the requirements and carrying out impact analysis
• Database design and development including, Indexes and Stored Procedures
• Prepared root cause analysis for problems occurred
• Code Walk Through, Review and Testing
• Constructed and implemented multiple-table links requiring complex join statements, including Outer-Joins and Self-Joins
• Converted open purchase orders from legacy system to Oracle Purchasing using SQL
• Developed interface for item data conversion to load items from flat file to Oracle Inventory using SQL
• Supporting DIT, SIT and UAT Testing
• Involved in resolving production problems for the applications and Ensure all support service level agreements are met
• Created maintenance plans for Regular Backups and Rebuilding indexes
• Created changes in the database according new requirements (new tables in the existing database and fields in the existing tables)
• Expert in creating Public Synonyms, DB Links.