Deva Resume (1).docx

Deva. E E-mail: [email protected] Contact no : 8072847944 CAREER OBJECTIVE: Seeking a position in SQL/PLSQL DEVELOPER in a reputed organization where I can make an impact by utilizing my rich functional expertise and strong PLSQL knowledge. CAREER PROFILE: ● Having 3+ years of experience in Application Software development using Oracle 10g/11g. ● Extensive experience in developing Views, Joins, Sub Queries and Set Operators. ● Good exposure on advanced topics Like Analytical Functions, Indexes, Group functions and Sequences. ● Quick learner & Self-directed, consistently updating self with emerging trends in the industry. ● Basic knowledge in Unix commands. ● Analyzing different user requirements and coming up with specifications for the various database applications ● I have knowledge in Bulk collect, Bulk bind and collections. ● Good experience of coordinating with various teams like Deployment, Testing Team to speed up Development process. ● Knowledge in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages, Exceptions.

PROFESSIONAL EXPERIENCE: ● Company

: Arinos Infosolutions (P) Limited

● Duration

: OCT 2015 to till date

● Environment : Oracle 10g/11g ● Role

: PLSQL Developer.

PROJECT DETAILS: PROJECT-1 ● Client

: NorthField Bank

● Project

: Vision One - NF

● Domain

: Banking - Support & Development

● Duration

: JAN 2018 to till date

● Role

: SQL/PLSQL developer

● Technologies

: Toad, sql plus, sql developer

ROLES AND RESPONSIBILITIES: ● This project has modules like, cash receipt, cash payment and transfer module. ● Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements. ● Collect and analyze the project's business requirements and transferring the same knowledge to development team. ● Development and modified PL/SQL code to make new enhancements or resolve problems as per customer requirements. ● Created indexes on some columns of tables to increase the application’s performance. ● Modification of existing table based on new client requirements. ● Developed and modified triggers, packages, functions and stored procedures for data conversions. ● Having good knowledge in performance tuning concepts like indexes, sub queries, Joins ● Created views on multiple tables. ● Solving user end issues for accessing applications.

PROJECT-2

● Client

: Baylink Logistics

● Project

: Baylink_pro

● Domain

: Shipping And Logistics

● Duration

: JAN 2016 to DEC 2017

● Role

: SQL developer

● Technologies

: Toad, sql plus, sql developer

ROLES AND RESPONSIBILITIES: ● Involved in all phases of software development including gathering requirements, creating specifications, development of database objects, developing code and validating programs. ● Understanding the existing application, gathering new requirement, and business rule. ● Developed various background application programs such as views, functions, Joins, Trigger. ● Involved SQL Queries using Joins, Sub Queries and correlated sub Queries to retrieve data from the database. ● Perform DML, DDL Operations as per the Business requirement. ● Has involved in resolving the project specific code issues by discussing with team. ● Created views on multiple tables. ● Worked under tight schedules for successful development and implementation. ● Strong understanding of business processes with good experience in development. ● Good experience of coordinating with various teams like Deployment, Testing Team to speed up Development process TOOLS USED : ● ● ● ●

Languages : SQL, PLSQL. Operating System : Windows XP, Window 7, UNIX. Database : ORACLE 10g, 11g Ticket tracking : JIRA,SNOW.

ACADEMIC PROFILE:

● B.E (Computer Science And Engineering)in KarpagaVinayaga college of Engineering and Technology – 66%. ● 12th standard Marvar Government Boys Higher Secondary School Acharapakkam-70%. ● 10th standard Government High School Nedungal– 73%.

PERSONAL INFORMATION: Age

: 24

Sex

: Male

Nationality

: Indian

Marital Status : Single Date of Birth

: 10th JAN 1994

Father

: Mr.M. Elumalai

Mother

: Mrs.E.Joesphine

Declaration: I here by declare that all the information given by me is true to my knowledge.

Date: Place:

(E. DEVA)