ganesan M

I am a dynamic professional with 9+ years of qualitative hands-on experience in PLSQL, in developing database applications and information system

 Having progressive and dynamic experience in Oracle SQL, PLSQL development.  Expertise in Client server application development using Oracle 10g/11g/19c, TOAD, PLSQL Developer, SQL Developer and sql plus.  Having experience of creating SQL objects like Tables, Views, Sequence, Synonyms and Indexes. Table creation with constraints and Expertise in DDL and DML statements.  Extensive experience in writing complex queries using Joins, Subqueries and various analytical functions.  Have experience of developing, modifying Oracle procedures, functions as per business requirement.  Used cursor and Exception handling while writing the Stored Procedure.  Expertise in SQL*LOADER to transfer data from flat file into oracle database.  Having better understanding and working experience in PLSQL advanced concepts like Collections and Bulk operations.  Extensively used FORALL and BULK COLLECT to fetch large volumes of data from the table.  Having experience in Trigger, Ref Cursor and Hierarchical query.  Installation & Troubleshooting Operating System.  Network sharing Creation, Access & Permission issue Troubleshooting.  Backup, Restore & Recovery data’s from end user’s.  Configure, verify, and troubleshoot IPv4 addressing and subnetting.  IPv4 address types Unicast, Broadcast, and Multicast.  The IPv6 addressing scheme in LAN/WAN environment.  Routing Protocols: OSPF, EIGRP and Static Routing.  Switching Protocols: LAN, VPN, VTP, STP, Inter VLAN routing and Ether channels.  LAN technologies: Ethernet, Fast Ethernet, Gigabit Ethernet and VLANs.

 The Indian Engineering College, Vadakkangulam, Tirunelveli - 627116. Bachelor of Engineering (B.E.), Computer Science and Engineering (2008 to 2012)