Resume Teledata

A.N.PANDIYARAJ

#14, Raja Srinivasa Nagar, Kuppam Beach Road, Thiruvanmiyur, Chennai – 41.

Mobile E-Mail

: (+91) 9176446604 : [email protected]

Professional Experience Summary

    

Having 1 Year of Experience as Oracle PL/SQL Developer in Teledata Informatics Chennai. Having good Knowledge in Data Base Architecture and Normalization. Sound Knowledge in PL/SQL Procedures, functions, Triggers, Inbound Interface and Outbound Interface. Having good experience in designing of Reports using Lexical Parameters and Placeholder columns. Developed, modified, and optimized complex queries for data retrieval and modification. Developed User GUI using Oracle Forms 9i. Having good Knowledge in SQL and database tuning. Having good Knowledge on Troubleshoot of PL/SQL Packages.



Having Good Experience on Java Applet designing.

  

Skills Set, Knowledge & Abilities Languages Databases Tools

:: SQL,PL/SQL, UNIX Shell Script,Java,c,c++. :: ORACLE[9i,10g,11i],SQL Server [version: 2005/2000] :: Toad , Oracle Forms & Reports [6i,9i],Informatica 8.1

Work Experience Organization

: Teledata Informatics Chennai.

Title

:

Client

: American Express.

Environment

: PL/SQL, SQL, SQL*Plus,Forms 6i ,Reports 6i,SQL*Loader,

Role

: Software Developer

Duration

: April 2008 to till.

Risk Information System (RIS)

Description: Bank AMEX is significantly expanding its risk capability via some automated systems. Subsequently, a risk information store solution is required to provide a suitable enterprise-wide risk information environment capable of meeting our future reporting and information requirements. The RIS Program is focused on providing a platform for Risk Information collection from various source systems, performing complex calculations. Responsibilities: • •

Responsible for developing technical specifications from business requirements. Developed the inbound interface using SQL Loader to transfer the customer details from MS Excel to Oracle system, like assets and liabilities information of customer.

•

Developed automated shell scripts to schedule the load of flat files on daily basis.

• • • •

Designed PL/SQL procedure to calculate Credit Rating in credit Management Module designed complex procedure to calculate Risk Factor. Involved in designing of form to enter customer Loan request. Involved in Development of Asset-Liability form, form to show credit rating,form to show his existing loan history. E-mail: [email protected]; Mobile: (+91) 9176446604

A.N.PANDIYARAJ • • • • •

Involved in Development of customer asset-liability Report,Credit Rating Analysis Report,Risk factor advice report. Troubleshoot Issues faced while Development. Troubleshooted performance issues and bugs within packages, forms, and reports using dbms_output. Documented business rules, functional and technical designs and test cases. Involved in System Testing and Unit Testing.

Academic Projects Project #1 Project Name Duration Technical Environment Team Size

: CHAT SERVER : 4 months : ASP.Net, MS SQL Server 2000 : Individual

Project Description As the Internet becomes a common part of daily life, long-held patterns of communication are changing. Whereas meetings or telephone conferences held the monopoly of information distribution points and brainstorming centers, computer software applications reached over the Internet or intranets now offer forums for information sharing and collaboration. In place of meeting minutes or messy printouts from whiteboards, online communication offers a well organized, searchable record of discussion and announcements. No wonder corporations, educational institutions, and community groups are turning to online conferencing and chat systems..

Project #2 Project Name Technical Environment Team Size

: STEGANOGRAPHY : Visual basic 6.0,Oracle 9i : Individual

Project Description Steganography is the art and science of writing hidden messages in such a way that no one apart from the sender and intended recipient even realizes there is a hidden message. It includes the concealment of digital information within image(JPEG) files and send it to recipients over the network and same data can be viewed by recipient by providing security code.

Academic History B.Tech Information Technology Diploma SSLC

: 2008, Anna University, Coimbatore, with 69%. : 2004, Nachimuthu polytechnic, Pollachi, with 89%. : 2000, Central Higher Secondary School, Pollachi, with 93% .

Personal Profile Data of Birth

:

05th May 1984

Gender

:

Male

Marital status

:

Single

Nationality

:

Indian

Languages known

:

English, Tamil

Address

:

Morakutty, E-mail: [email protected]; Mobile: (+91) 9176446604

A.N.PANDIYARAJ Ebbanadu P.O, The Nilgiris-643206

E-mail: [email protected]; Mobile: (+91) 9176446604