PRAKASH R

Contact: +91-770*******

E-mail:admtk4@r.postjobfree.com

OBJECTIVE

Seeking position to utilize my skills and abilities in the information technology industry that offer professional growth while being resourceful, innovative and flexible.

Entry level position in Software Design/Development.

PROFESSIONAL EXPERIENCE

•Having overall 1.1 years of experience in Computer Age Management Services Ltd – CAMS from March 2020 to till date.

•Conceptual knowledge and experience in SQL & PL/SQL.

•Have Good knowledge in Mutual Funds domain.

SUMMARY

•Have knowledge and worked with SQL, PL/SQL queries.

•Tuned SQL queries to improve response time.

•Working with application developers to create optimized queries.

•Creating table indexes to improve database performance

•Have created and worked with oracle objects such as Table, View, Index, Sequence, Synonyms.

•Developed Materialized Views for data replication in distributed environments.

•Developed Complex database objects like Stored Procedures, Functions and Packages.

•Loaded data into Oracle Tables using SQL loader.

•Provided technical production applications support and assistance to customers.

•Wrote Audit Programs for data consistency checking and validation.

•Coordinating with Development & Operations team for requirement gathering.

•Designed developed and maintained reports, involved in data validation, analysis, testing and debugging.

•Created schema, metrics reports and documents supporting client business goals

EDUCATIONAL QUALIFICATION:

UG- Completed B.E in Computer Science and Engineering in the year 2019 from Knowledge Institute of Technology. Tamilnadu with 6.51 CGPA.

12th from shri vinayaga Higher Secondary School in 2015 with percentage of 79.5%, Tamilnadu State Board.

10th from Shri Vinayaga Higher Secondary School in 2015 with percentage of 79.5%, Tamilnadu State Board.

IT SKILLS:

Programming Languages : SQL,PL/SQL,JAVA

Database : Oracle 11g,12c

Tools : Oracle PL/SQL developer, MS-Office, Eclipse.

Operating System : Windows

PROFESSONAL TRAINING :

Completed JAVA Training from Jspiders BTM Bangalore

PROJECT:

PROJECT :

Company: Computer Age Management Services Project

Name: myCAMS Mobile Application

Client: MF Investors

Technologies: Oracle 11g

Role: Tech Support

Tools: PL/SQL Developer 11.1

PROJECT DESCRIPTION:

The objective of My CAMS Application is to ensure that the investors achieve complete automation by eliminating manual intervention and ensuring uniformity and reliability of information about the MF (Mutual Fund) industry.

RESPONSIBILITIES:

Understanding the Business requirements document (BRD) and data mapping document (DMD) completely and implement data transformation methodologies and business logic.

Involved in importing Source/Target tables from the respective database, developing mappings using transformations.

Users receive notifications such as last transaction details, latest NAV details of the investment made by them using the backend source, which entirely is extracted, populated and maintained by myself.

Clients balance will be triggered to them automatically on daily basis. Data mapping and populating data will be done on daily.

Programmed Procedures, Functions, Views on Oracle 11g.

PERSONAL DETAILS

FATHER’S NAME : Ramasamy R

MOTHER’S NAME : Vijayalashmi

DATE OF BIRTH : 31/08/1997

GENDER : Male

LINGUISTIC SKILLS : English, Tamil

NATIONALITY : Indian

HOBBIES : Listening Music,Playing Cricket.

DECLARATION

I hereby declare that all the details furnished above are true to the best of my knowledge.

Date : Yours faithfully,

Place :

Contact this candidate