LEVIN.C

E-mail: adijf1@r.postjobfree.com

Mobile: +91-960*******

JOB OBJECTIVE:

To work in a professional managed company with a scope of challenging career opportunity for learning, excellence and continuous improvement. To grow in an environment where performance is rewarded with new responsibilities and challenges.

PROFESSIONAL SUMMARY:

Having 2.9 years of experience in Application Support & Development using Oracle 10g/11g.

In depth knowledge in writing medium and complex queries using Joins.

Solid Knowledge in writing Sub-queries, Grouping functions.

Good working knowledge on creating and maintaining the DB objects like indexes, Sequences and Views.

Worked extensively on creating and modifying the Stored Procedures, Triggers, Functions, and Packages.

Well working knowledge in PL/SQL like Collections, Cursors.

Good working knowledge in Exception handling.

Strong knowledge in Loaded Data into Oracle Tables using SQL*Loader.

Good experience in using tool like Oracle SQL developer.

Specified user access level for each segment of one or more data items, such as insert, update, delete, merge data.

Tested and corrected errors and refined changes to database.

Ambitious, self-motivated, ability to work independently as well as in teams, possess multi- Tasking skills, results oriented Engineering Professional.

Capable API delivery end to end includes Planing, Design, Development, Testing and Delivery of API

TECHNICAL SKILLS:

Programming Languages : SQL Server, Oracle PLSQL

Database Technologies : Oracle 10g/11g, Oracle SQL developer

Operating Systems : Windows 10, LINUX

Web technologies : XML

Tools : SQL Developer

EDUCATION QUALIFICATION:

B.TECH from Bharathiyar College of Engineering & Technology affiliated to Pondicherry University (2013-2017).

PROFESSIONAL EXPERIENCE:

Working as Programmer Analyst at Aspire Systems India Pvt Ltd, Siruseri, Chennai from June 2017 – August 2018 & Vendor in Karur Vysya Bank as Application Support Analyst from August 2018 – Till Date.

PROJECT EXPERIENCE SUMMARY:

PROJECT 1:

Title : DYNAMIC FEATURE CAP

Clients : First Direct

Tools & Utilities : SQL Developer, SQL Plus, Easy Vista

Domain : Banking

Period : June 2017 – August 2018

DESCRIPTION:

Collection tracking system handles delinquent customers’ information. Here, delinquent customer, whoever not paying their due amount, data are collecting from core system. Delinquent customers’ data will be classified by portfolio which contains customers’ exact loan information like car loan, home loan, vehicle loan etc.

PROJECT 2:

Title : KARUR VYSYA BANK( FRS,AOS )

Clients : Branches

Tools & Utilities : SQL Navigator 6.2, LINUX, VM WARE

Domain : Banking

Period : August 2018 – Till Date

DESCRIPTION:

Monitoring and Submitting report of Automation. Handling HMS, Phone calls and mails from the branches. Providing requested Data through SQL Navigator. Configuring some mandatory devices and required softwares to branches. Sharing required files such as Cheque Book, Welcome Kits, Transaction Files through SFTP to KVB vendors. Monitoring and handling FRS application error Logs. Submitting all the generated reports through FRS at the end of the day. Configuring and troubleshooting all the required softwares which is using through FRS from all the branches.

ROLES & RESPONSIBILITY:

Involved in development of interface programs to import parts information to inventory base tables.

Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements.

Built complex queries using SQL and wrote stored procedures using PL/SQL.

Performing Root Cause analysis and submitted Known errors.

Loaded the data into database tables using SQL*loader from text and excel files.

Participate in projects related to Projects and peripheral applications, as requested.

Worked on UNIX to automate and systemize the load process at nightly cycles and used alert scripts to validate application status.

Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.

Monitoring the Database performance and take necessary action to optimize the database performance

Responsible for developing technical specifications from business requirements.

Developed interface for item data conversion to load items from flat file to Oracle Inventory using SQL* Loader, PL/SQL and import items program.

ENVIRONMENT: Oracle 10g/11g, PL/SQL, SQL* PLUS, SQL Navigator.

PERSONAL PROFILE:

Name : LEVIN.C

Father’s Name : CHRISTURAJ.G

DOB : 18-OCT-1995

Address for Communication : 18/1 KAZIAR STREET, KARAIKAL

PAN Number : BCJPL1205Q

Notice Period : 30 Days

DECLARATION:

I hereby declare that the information furnished above is true to the best of my knowledge and belief.

PLACE: Chennai

DATE: (LEVIN.C)

Contact this candidate