Prithivirajan C

PRITHIVIRAJAN C Mobile no: -Email: - Objective To succeed in an environment of growth and excellence and earn a job which provides me job satisfaction and self-development that helps me to achieve personal as well as organization goals. Professional Experience 3+ years of experience in information technology industry for database development Analytical, Debugging skills in Oracle 10g/11g SQL and PL/SQL. Created Tables, Constraints, views, Indexes, Triggers, sequences, synonyms. Loaded Data into Oracle Tables using SQL Loader . Experience in Bulk Collect, Ref Cursor and Dynamic SQL, Materialized Views. Data Conversion from Flat files to Oracle using Oracle SQL* Loader. Strong Experience in SQL & PL/SQL Packages, Procedures and functions etc. Experience includes in anonymous blocks, Cursors, Exception handling, Parameterized cursor. Having good analytical and programming capabilities. Expertise in using tools such as SQL Developer and SQL*Plus. Have theoretical knowledge in concepts like GTT and 11G concepts like Aggregate functions, read only table, read/write etc. Have theoretical knowledge in Granted privileges and roles to users. Handled the performance and tuning by using creating indexes, Hints and theoretical knowledge in table partition, explain plan. Excellent code reviews and code debugging skills. Technical skills Languages: SQL, PL/SQL Databases: Oracle 11g/10g,RDBMS. Tools/ Utilities: SQL Developer, SQL*PLUS, SQL*Loader. Work Experience Worked as a “Executive” at Preethi tours and travels, Chennai from Sep 2014-Nov 2016. Working as a “Software Engineer” at Oramate Technology,Chennai since Dec -2016 to Mar-2020. Project details PROJECT-1 This project is designed and developed for Telecom Company called Toucan Telecom which is a telephony and broad band internet service provider and this project is in the production. Purpose of this application is to support their Employees flexi allowance and their Day to day Release, Delivery Order processing requirements, Customer Payment Details. I Worked in Forward Cover, Remittance, and Delivery Order Processing System. Client : TOUCAN TELECOM, MARCOM ,UK(Duration: Dec 2016 to Oct 2017) PROJECT-2 The product is the primary attribute during creating the policy or getting an insurance cover.It is customized for retail insurance which includes trip cancellation, lost luggage, hijack, death, accidents. MONARCH INSURANCE COMPANY Environment: Oracle 11g, SQL*PLUS, PL/SQL Developer Academic Profile B.E. Computer science in Dhanalakshmi Srinivasan College of Engineering (Anna University, Chennai) with 6.06 CGPA,2013 HSC in SAMBAVIGA Hr.sec. School, Sivaganga with 79% in the year 2008. SSLC in DON BOSCO Hr. sec. School, Pallithamam with 69% in the year 2006. Personal details Date of Birth:- Gender : Male Father’s Name: Chandran. K Mother’s Name: Amutha. C Nationality: Indian Languages Known: English, Tamil Address : 2/84,3rd main road , Ganga nagar, valasaravakkam,Chennai-87 Declaration I hereby declare that the above mentioned information is correct up to my knowledge and I bear the responsibility for the correctness of the above mentioned particulars. Date: Place: