Selvavinayagam K Email & Phone Number

• Over 14+ years of experience in Information Technology with Extensive knowledge and work Experience in design and development of Database applications in Client/Server environment using Oracle Database and PL/SQL Programming.• Experience in Design and maintenance of Healthcare, Manufacturing& Logistics, Banking and financial Data Warehouse applications/ Domains.• Expertise working with Oracle 12.2c,11g, 10g, 9i, 8i, SQL*Plus, PL/SQL.• Extensive experience as Oracle Developer in utilizing PL/SQL procedures, functions, packages, triggers along with shell scripting, and also involved in data extraction, transformation and loading operations using SQL Loader, Informatica.• Experience in performance tuning and Sql optimization using (Hints, Explain Plan, Auto Trace, Tkprof, AWR&ADDM), restructuring tables, de-normalize tables and build Materialized views.• Experience in Adopting Business Process with Decoupling for Performance.• Knowledge in utilizing ETL like Informatica, Crystal reports.• Strong experience in batch processing scheduling using Corn jobs, DBMS_SCHEDULER.• Knowledge in Data Modelling, Relational Database concepts and Entity relation diagrams (ERD).• Performed some DBA Functionality by creating tables, constraints, granting permission, move data from one server to another etc.• Experience in overall data warehouse, database and ETL tuning for better performance• Experience in integration of various data sources like Oracle, DB2, SQL Server, Flat Files, XML files into the staging area.• Involved in project planning and scheduling, System design, Functional Specification, Design specification, preparation of impact analysis, Coding, system test plan, Testing, code review, coordinating user testing and user training, Project demonstration and Implementation.• Acquired Certification OCA -Oracle Certified Associate.

• 

  University Of Madras

  A