Now you can Instantly Chat with Anandh!
Having 5 years 3 month of professional experience in ORACLE as a PL/SQL Developer.
➢ Experience in Software Development in Oracle SQL, PL/SQL.
➢ Rich experience in writing SQL queries, Views, Materialized views, PL/SQL Procedur...
➢ Rich experience in writing SQL queries, Views, Materialized views, PL/SQL Procedures, functions, Packages, triggers, cursors, collections, Ref cursor.
➢ Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
➢ Vast experiences using PL/SQL Collections, Ref Cursor, Bulk collect, Pragma Autonomous Transaction and Oracle Supplied Package .
➢ Extensive ability to provide 24/7 production support, analyzing the issue priority and raise tickets to the L3 team with details and follow up on items.
➢ Experienced in working with Service Now to raise tickets and monitoring applications with Application Monitoring tool.
➢ Extensively providing support for Incident management, Problem management and Change management.Show More
NXP Semiconductors(Supply Chain Processing Legacy Oracle (SCP Legacy))
➢ A supply chain is a network of facilities and distribution options that performs the functions of procurement of materials, transformation of these materials into intermediate and finished products, and the distribution of these finished products to customers.
➢ Understand demand pattern plays key role for success of industry.
➢ New products arrival, trend and season changes customer demand.
➢ SAP provides solution to forecasting, planning and optimization by considering sales history and all above facts.
➢ Data Consolidation Module (DCM) is a major business initiative in Supply Chain Operations.
➢ DCM is a planning legacy system that gathers information from multiple systems and processes the inbound data and sends the outbound data in a format that is acceptable by SAP system.
➢ DCM is critical in terms of production planning pertaining to factories and equipment’s over a period of time and to use this capacity information to derive production schedules in SAP which will be more accurate and realistically achievable .
SkillsUnix UNIX Shell Scripting PL/SQL SQL
ToolsSQL Developer putty
BTN(Bank Tabungan Negara)
➢ This Project is developed for Bank Tabungan Negara which is a banking service provider in Indonesia. This project has various modules like, cash receipt, cash payment, transfer module.
➢ Analyzing the business requirements of the projects by studying the Business Requirement Specification document.
➢ Creating indexes on the tables for faster retrieval of the data to enhance database performance.
➢ Creating database objects like tables, views, materialized views, procedures, packages using oracle tools like TOAD.
➢ Implementing several triggers to maintain Database Security by auditing log table to track information about users.
➢ Writing complex SQL queries including sub queries for faster data retrieval from multiple tables.
➢ Handling errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
➢ Using for all and Bulk collect to fetch large volumes of data from table.
➢ Using Pragma Autonomous Transaction to avoid mutating problem in database trigger.Show More Show Less
Toolstoad for oracle
Master Health was designed and developed for Indo-American Cancer Hospital (A Super specialist Hospital offering distinguished medical and theraphatic services around the clock). This project is basically providing sophisticated software for the automation of the various transactions in the hospital. It includes total 27 modules like Security, Registration,
Doctor Ap pointments, Inpatient, and Outpatient, Investigative lab Services, Housekeeping, Radiology, O peration Theatre, Finance and Accounting with Reports.
Toolstoad for oracle